Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.24 ms Query time

0 Invalid entities

20 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.64 ms
(51.54%)

SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.fichier AS fichier_2, p0_.type AS type_3, p0_.description AS description_4, p0_.date_publication AS date_publication_5, p0_.visible AS visible_6, p0_.titreen AS titreen_7, p0_.typeen AS typeen_8, p0_.descriptionen AS descriptionen_9, p0_.fichieren AS fichieren_10, p0_.visiblefr AS visiblefr_11 FROM publication p0_ WHERE p0_.visible = ? AND p0_.type = ? ORDER BY p0_.date_publication DESC

Parameters:

[
  1
  "Revue hebdomadaire"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.titre AS titre_1,
  p0_.fichier AS fichier_2,
  p0_.type AS type_3,
  p0_.description AS description_4,
  p0_.date_publication AS date_publication_5,
  p0_.visible AS visible_6,
  p0_.titreen AS titreen_7,
  p0_.typeen AS typeen_8,
  p0_.descriptionen AS descriptionen_9,
  p0_.fichieren AS fichieren_10,
  p0_.visiblefr AS visiblefr_11
FROM
  publication p0_
WHERE
  p0_.visible = ?
  AND p0_.type = ?
ORDER BY
  p0_.date_publication DESC

SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.fichier AS fichier_2, p0_.type AS type_3, p0_.description AS description_4, p0_.date_publication AS date_publication_5, p0_.visible AS visible_6, p0_.titreen AS titreen_7, p0_.typeen AS typeen_8, p0_.descriptionen AS descriptionen_9, p0_.fichieren AS fichieren_10, p0_.visiblefr AS visiblefr_11 FROM publication p0_ WHERE p0_.visible = 1 AND p0_.type = 'Revue hebdomadaire' ORDER BY p0_.date_publication DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 38)
7	App\Controller\RevueHebdomadaireController->index (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.34 ms
(27.35%)

SELECT t0.id AS id_1, t0.ticker AS ticker_2, t0.name AS name_3, t0.price AS price_4, t0.variation AS variation_5, t0.trend AS trend_6, t0.created_at AS created_at_7 FROM brvm_stock t0 LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ticker AS ticker_2,
  t0.name AS name_3,
  t0.price AS price_4,
  t0.variation AS variation_5,
  t0.trend AS trend_6,
  t0.created_at AS created_at_7
FROM
  brvm_stock t0
LIMIT
  20

SELECT t0.id AS id_1, t0.ticker AS ticker_2, t0.name AS name_3, t0.price AS price_4, t0.variation AS variation_5, t0.trend AS trend_6, t0.created_at AS created_at_7 FROM brvm_stock t0 LIMIT 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 18)
5	App\Twig\GlobalStocksExtension->getGlobals (line 352)
6	Twig\ExtensionSet->getGlobals (line 901)
7	Twig\Environment->getGlobals (line 384)
8	Twig\Template->yield (line 344)
9	Twig\Template->display (line 359)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 334)
12	Twig\Environment->render (line 431)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 60)
16	App\Controller\RevueHebdomadaireController->index (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.26 ms
(21.10%)

SELECT p0_.date_publication AS date_publication_0 FROM publication p0_ WHERE p0_.visible = ? AND p0_.type = ?

Parameters:

[
  1
  "Revue hebdomadaire"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.date_publication AS date_publication_0
FROM
  publication p0_
WHERE
  p0_.visible = ?
  AND p0_.type = ?

SELECT p0_.date_publication AS date_publication_0 FROM publication p0_ WHERE p0_.visible = 1 AND p0_.type = 'Revue hebdomadaire';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 48)
7	App\Controller\RevueHebdomadaireController->index (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\BrvmStock	20

Entities Mapping

Class	Mapping errors
App\Entity\Publication	No errors.
App\Entity\BrvmStock	No errors.

Symfony Profiler

GET https://sa2if.com/en/revue-hebdomadaire

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping