Symfony Profiler

Query Metrics

17 Database Queries

6 Different statements

5.55 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.31 ms
(41.59%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.class_icon AS class_icon_4, t0.description AS description_5, t0.the_datetime_creation AS the_datetime_creation_6, t0.the_datetime_modification AS the_datetime_modification_7, t0.the_statut_id AS the_statut_id_8, t0.the_type_id AS the_type_id_9, t0.the_position_id AS the_position_id_10 FROM modules_module t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.slug AS slug_3,
  t0.class_icon AS class_icon_4,
  t0.description AS description_5,
  t0.the_datetime_creation AS the_datetime_creation_6,
  t0.the_datetime_modification AS the_datetime_modification_7,
  t0.the_statut_id AS the_statut_id_8,
  t0.the_type_id AS the_type_id_9,
  t0.the_position_id AS the_position_id_10
FROM
  modules_module t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.class_icon AS class_icon_4, t0.description AS description_5, t0.the_datetime_creation AS the_datetime_creation_6, t0.the_datetime_modification AS the_datetime_modification_7, t0.the_statut_id AS the_statut_id_8, t0.the_type_id AS the_type_id_9, t0.the_position_id AS the_position_id_10 FROM modules_module t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 61)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
6	Proxies\__CG__\App\Entity\Modules\Module->__get (line 151)
7	App\Entity\Modules\Module->getNom (line 89)
8	App\Entity\Modules\Module->__toString (line 114)
9	Twig\Runtime\EscaperRuntime->escape (line 482)
10	__TwigTemplate_c6523f1ff11ef290e3b9b06459714582->block_body (line 430)
11	Twig\Template->yieldBlock (line 97)
12	__TwigTemplate_eff3d267cd8967a1511235cfbc5c975f->doDisplay (line 360)
13	Twig\Template->yield (line 49)
14	__TwigTemplate_d0fa8c299ca412410c1f52e106ffb2bc->doDisplay (line 360)
15	Twig\Template->yield (line 50)
16	__TwigTemplate_c6523f1ff11ef290e3b9b06459714582->doDisplay (line 360)
17	Twig\Template->yield (line 335)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 307)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 55)
24	App\Controller\Front\Forfaits\ForfaitsController->index (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

1.25 ms
(22.44%)

SELECT t0.id AS id_1, t0.the_forfait_id AS the_forfait_id_2, t0.the_module_id AS the_module_id_3 FROM forfaits_forfait_module t0 WHERE t0.the_forfait_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.the_forfait_id AS the_forfait_id_2,
  t0.the_module_id AS the_module_id_3
FROM
  forfaits_forfait_module t0
WHERE
  t0.the_forfait_id = ?

SELECT t0.id AS id_1, t0.the_forfait_id AS the_forfait_id_2, t0.the_module_id AS the_module_id_3 FROM forfaits_forfait_module t0 WHERE t0.the_forfait_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3304)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 477)
8	__TwigTemplate_c6523f1ff11ef290e3b9b06459714582->block_body (line 430)
9	Twig\Template->yieldBlock (line 97)
10	__TwigTemplate_eff3d267cd8967a1511235cfbc5c975f->doDisplay (line 360)
11	Twig\Template->yield (line 49)
12	__TwigTemplate_d0fa8c299ca412410c1f52e106ffb2bc->doDisplay (line 360)
13	Twig\Template->yield (line 50)
14	__TwigTemplate_c6523f1ff11ef290e3b9b06459714582->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 307)
18	Twig\Environment->render (line 431)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 55)
22	App\Controller\Front\Forfaits\ForfaitsController->index (line 178)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.85 ms
(15.34%)

SELECT f0_.id AS id_0, f0_.prix_mensuel_ht AS prix_mensuel_ht_1, f0_.prix_annuel_ht AS prix_annuel_ht_2 FROM forfaits_licence_mobile f0_ LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.prix_mensuel_ht AS prix_mensuel_ht_1,
  f0_.prix_annuel_ht AS prix_annuel_ht_2
FROM
  forfaits_licence_mobile f0_
LIMIT
  1

SELECT f0_.id AS id_0, f0_.prix_mensuel_ht AS prix_mensuel_ht_1, f0_.prix_annuel_ht AS prix_annuel_ht_2 FROM forfaits_licence_mobile f0_ LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 991)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 29)
7	App\Repository\Forfaits\LicenceMobileRepository->findTheSingleton (line 34)
8	App\Controller\Front\Forfaits\ForfaitsController->index (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.48 ms
(8.69%)

SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.sous_titre AS sous_titre_2, f0_.description AS description_3, f0_.nb_sms_credit AS nb_sms_credit_4, f0_.prix_mensuel_ht AS prix_mensuel_ht_5, f0_.prix_annuel_ht AS prix_annuel_ht_6, f0_.couleur AS couleur_7, f0_.the_datetime_creation AS the_datetime_creation_8, f0_.the_datetime_modification AS the_datetime_modification_9, f0_.the_statut_id AS the_statut_id_10 FROM forfaits_forfait f0_ ORDER BY f0_.prix_mensuel_ht ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.nom AS nom_1,
  f0_.sous_titre AS sous_titre_2,
  f0_.description AS description_3,
  f0_.nb_sms_credit AS nb_sms_credit_4,
  f0_.prix_mensuel_ht AS prix_mensuel_ht_5,
  f0_.prix_annuel_ht AS prix_annuel_ht_6,
  f0_.couleur AS couleur_7,
  f0_.the_datetime_creation AS the_datetime_creation_8,
  f0_.the_datetime_modification AS the_datetime_modification_9,
  f0_.the_statut_id AS the_statut_id_10
FROM
  forfaits_forfait f0_
ORDER BY
  f0_.prix_mensuel_ht ASC

SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.sous_titre AS sous_titre_2, f0_.description AS description_3, f0_.nb_sms_credit AS nb_sms_credit_4, f0_.prix_mensuel_ht AS prix_mensuel_ht_5, f0_.prix_annuel_ht AS prix_annuel_ht_6, f0_.couleur AS couleur_7, f0_.the_datetime_creation AS the_datetime_creation_8, f0_.the_datetime_modification AS the_datetime_modification_9, f0_.the_statut_id AS the_statut_id_10 FROM forfaits_forfait f0_ ORDER BY f0_.prix_mensuel_ht ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 64)
7	App\Repository\Forfaits\ForfaitRepository->findAllOrdered (line 51)
8	App\Controller\Front\Forfaits\ForfaitsController->index (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.41 ms
(7.43%)

SELECT e0_.id AS id_0, e0_.nom AS nom_1, e0_.slug AS slug_2, e0_.prix_mensuel_ht AS prix_mensuel_ht_3, e0_.prix_annuel_ht AS prix_annuel_ht_4, e0_.the_statut_id AS the_statut_id_5 FROM extensions_extension e0_ ORDER BY e0_.nom ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.nom AS nom_1,
  e0_.slug AS slug_2,
  e0_.prix_mensuel_ht AS prix_mensuel_ht_3,
  e0_.prix_annuel_ht AS prix_annuel_ht_4,
  e0_.the_statut_id AS the_statut_id_5
FROM
  extensions_extension e0_
ORDER BY
  e0_.nom ASC

SELECT e0_.id AS id_0, e0_.nom AS nom_1, e0_.slug AS slug_2, e0_.prix_mensuel_ht AS prix_mensuel_ht_3, e0_.prix_annuel_ht AS prix_annuel_ht_4, e0_.the_statut_id AS the_statut_id_5 FROM extensions_extension e0_ ORDER BY e0_.nom ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 70)
7	App\Repository\Extensions\ExtensionRepository->findAllOrdered (line 52)
8	App\Controller\Front\Forfaits\ForfaitsController->index (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.25 ms
(4.52%)

SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.min AS min_2, f0_.max AS max_3, f0_.pourcentage AS pourcentage_4 FROM forfaits_licence_tranche f0_ ORDER BY f0_.min ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.nom AS nom_1,
  f0_.min AS min_2,
  f0_.max AS max_3,
  f0_.pourcentage AS pourcentage_4
FROM
  forfaits_licence_tranche f0_
ORDER BY
  f0_.min ASC

SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.min AS min_2, f0_.max AS max_3, f0_.pourcentage AS pourcentage_4 FROM forfaits_licence_tranche f0_ ORDER BY f0_.min ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 65)
7	App\Repository\Forfaits\LicenceTrancheRepository->findAllOrdered (line 53)
8	App\Controller\Front\Forfaits\ForfaitsController->index (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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.

Entities Mapping

Class	Mapping errors
App\Entity\Paiements\Paiement	No errors.
App\Entity\Forfaits\LicenceMobile	No errors.
App\Entity\Abonnements\Abonnement	No errors.
App\Entity\Modules\Module	No errors.
App\Entity\Contacts\EntrepriseClient	No errors.
App\Entity\Contacts\EntrepriseClientRole	No errors.
App\Entity\Stocks\EntrepotArticle	No errors.
App\Entity\Users\Login	No errors.
App\Entity\Users\User	No errors.
App\Entity\Emails\EmailConfig	No errors.
App\Entity\Sms\SmsConfig	No errors.
App\Entity\Stocks\Entrepot	No errors.
App\Entity\Forfaits\Forfait	No errors.
App\Entity\Forfaits\ForfaitModule	No errors.
App\Entity\Forfaits\ForfaitFonctionnalite	No errors.
App\Entity\Extensions\Extension	No errors.
App\Entity\Forfaits\LicenceTranche	No errors.
App\Entity\Modules\ModuleDependance	No errors.
App\Entity\Modules\Fonctionnalite	No errors.

Symfony Profiler

GET https://app.flexin.fr/forfaits/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping