Symfony Profiler

Query Metrics

4 Database Queries

2 Different statements

2.14 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.93 ms

SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.order_index AS order_index_2 FROM supports_faq_question_groupe s0_ ORDER BY s0_.order_index ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.nom AS nom_1,
  s0_.order_index AS order_index_2
FROM
  supports_faq_question_groupe s0_
ORDER BY
  s0_.order_index ASC

SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.order_index AS order_index_2 FROM supports_faq_question_groupe s0_ ORDER BY s0_.order_index 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 36)
7	App\Repository\Supports\FaqQuestionGroupeRepository->findFrontIndex (line 17)
8	App\Controller\Front\Pages\FaqController->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.55 ms

SELECT t0.id AS id_1, t0.question AS question_2, t0.reponse AS reponse_3, t0.class_icon AS class_icon_4, t0.order_index AS order_index_5, t0.the_groupe_id AS the_groupe_id_6 FROM supports_faq_question t0 WHERE t0.the_groupe_id = ? ORDER BY t0.order_index ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.question AS question_2,
  t0.reponse AS reponse_3,
  t0.class_icon AS class_icon_4,
  t0.order_index AS order_index_5,
  t0.the_groupe_id AS the_groupe_id_6
FROM
  supports_faq_question t0
WHERE
  t0.the_groupe_id = ?
ORDER BY
  t0.order_index ASC

SELECT t0.id AS id_1, t0.question AS question_2, t0.reponse AS reponse_3, t0.class_icon AS class_icon_4, t0.order_index AS order_index_5, t0.the_groupe_id AS the_groupe_id_6 FROM supports_faq_question t0 WHERE t0.the_groupe_id = 1 ORDER BY t0.order_index ASC;

#	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 98)
8	__TwigTemplate_0c2265bed131c3f155ffbd477a82ef57->block_body (line 430)
9	Twig\Template->yieldBlock (line 97)
10	__TwigTemplate_eff3d267cd8967a1511235cfbc5c975f->doDisplay (line 360)
11	Twig\Template->yield (line 49)
12	__TwigTemplate_23f3fb7b7f335efbb350818a65910869->doDisplay (line 360)
13	Twig\Template->yield (line 52)
14	__TwigTemplate_0c2265bed131c3f155ffbd477a82ef57->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 16)
22	App\Controller\Front\Pages\FaqController->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.34 ms

SELECT t0.id AS id_1, t0.question AS question_2, t0.reponse AS reponse_3, t0.class_icon AS class_icon_4, t0.order_index AS order_index_5, t0.the_groupe_id AS the_groupe_id_6 FROM supports_faq_question t0 WHERE t0.the_groupe_id = ? ORDER BY t0.order_index ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.question AS question_2,
  t0.reponse AS reponse_3,
  t0.class_icon AS class_icon_4,
  t0.order_index AS order_index_5,
  t0.the_groupe_id AS the_groupe_id_6
FROM
  supports_faq_question t0
WHERE
  t0.the_groupe_id = ?
ORDER BY
  t0.order_index ASC

SELECT t0.id AS id_1, t0.question AS question_2, t0.reponse AS reponse_3, t0.class_icon AS class_icon_4, t0.order_index AS order_index_5, t0.the_groupe_id AS the_groupe_id_6 FROM supports_faq_question t0 WHERE t0.the_groupe_id = 2 ORDER BY t0.order_index ASC;

#	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 98)
8	__TwigTemplate_0c2265bed131c3f155ffbd477a82ef57->block_body (line 430)
9	Twig\Template->yieldBlock (line 97)
10	__TwigTemplate_eff3d267cd8967a1511235cfbc5c975f->doDisplay (line 360)
11	Twig\Template->yield (line 49)
12	__TwigTemplate_23f3fb7b7f335efbb350818a65910869->doDisplay (line 360)
13	Twig\Template->yield (line 52)
14	__TwigTemplate_0c2265bed131c3f155ffbd477a82ef57->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 16)
22	App\Controller\Front\Pages\FaqController->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.32 ms

SELECT t0.id AS id_1, t0.question AS question_2, t0.reponse AS reponse_3, t0.class_icon AS class_icon_4, t0.order_index AS order_index_5, t0.the_groupe_id AS the_groupe_id_6 FROM supports_faq_question t0 WHERE t0.the_groupe_id = ? ORDER BY t0.order_index ASC

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.question AS question_2,
  t0.reponse AS reponse_3,
  t0.class_icon AS class_icon_4,
  t0.order_index AS order_index_5,
  t0.the_groupe_id AS the_groupe_id_6
FROM
  supports_faq_question t0
WHERE
  t0.the_groupe_id = ?
ORDER BY
  t0.order_index ASC

SELECT t0.id AS id_1, t0.question AS question_2, t0.reponse AS reponse_3, t0.class_icon AS class_icon_4, t0.order_index AS order_index_5, t0.the_groupe_id AS the_groupe_id_6 FROM supports_faq_question t0 WHERE t0.the_groupe_id = 3 ORDER BY t0.order_index ASC;

#	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 98)
8	__TwigTemplate_0c2265bed131c3f155ffbd477a82ef57->block_body (line 430)
9	Twig\Template->yieldBlock (line 97)
10	__TwigTemplate_eff3d267cd8967a1511235cfbc5c975f->doDisplay (line 360)
11	Twig\Template->yield (line 49)
12	__TwigTemplate_23f3fb7b7f335efbb350818a65910869->doDisplay (line 360)
13	Twig\Template->yield (line 52)
14	__TwigTemplate_0c2265bed131c3f155ffbd477a82ef57->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 16)
22	App\Controller\Front\Pages\FaqController->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)

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\Supports\FaqQuestionGroupe	No errors.
App\Entity\Supports\FaqQuestion	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping