Symfony Profiler

Query Metrics

17 Database Queries

12 Different statements

2.13 ms Query time

0 Invalid entities

24 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.26 ms
(12.46%)

SELECT count(DISTINCT n0_.id) AS sclr_0 FROM newsletter n0_ WHERE n0_.statut <> ?

Parameters:

[
  "Pas encore traité"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT n0_.id) AS sclr_0
FROM
  newsletter n0_
WHERE
  n0_.statut <> ?

SELECT count(DISTINCT n0_.id) AS sclr_0 FROM newsletter n0_ WHERE n0_.statut <> 'Pas encore traité';

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerSfwNWTr\PaginatorProxyBa079e5->paginate (line 65)
16	App\Repository\NewsletterRepository->ClientRecuperationNewsletter (line 29)
17	App\Controller\FrontEnd\ColletionController->index (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.25 ms
(11.80%)

SELECT n0_.id AS id_0, n0_.nom AS nom_1, n0_.enregistre_le AS enregistre_le_2, n0_.modifier_le AS modifier_le_3, n0_.envoyer AS envoyer_4, n0_.statut AS statut_5, n0_.slug AS slug_6, n0_.description AS description_7 FROM newsletter n0_ WHERE n0_.statut <> ? AND n0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY n0_.enregistre_le DESC

Parameters:

[
  "Pas encore traité"
  11
  10
  9
  8
  7
  6
  5
  4
  3
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.nom AS nom_1,
  n0_.enregistre_le AS enregistre_le_2,
  n0_.modifier_le AS modifier_le_3,
  n0_.envoyer AS envoyer_4,
  n0_.statut AS statut_5,
  n0_.slug AS slug_6,
  n0_.description AS description_7
FROM
  newsletter n0_
WHERE
  n0_.statut <> ?
  AND n0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  n0_.enregistre_le DESC

SELECT n0_.id AS id_0, n0_.nom AS nom_1, n0_.enregistre_le AS enregistre_le_2, n0_.modifier_le AS modifier_le_3, n0_.envoyer AS envoyer_4, n0_.statut AS statut_5, n0_.slug AS slug_6, n0_.description AS description_7 FROM newsletter n0_ WHERE n0_.statut <> 'Pas encore traité' AND n0_.id IN (11, 10, 9, 8, 7, 6, 5, 4, 3, 1) ORDER BY n0_.enregistre_le 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 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerSfwNWTr\PaginatorProxyBa079e5->paginate (line 65)
16	App\Repository\NewsletterRepository->ClientRecuperationNewsletter (line 29)
17	App\Controller\FrontEnd\ColletionController->index (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.23 ms
(11.05%)

SELECT COUNT(*) FROM ligne_favori t0 WHERE t0.id_favori = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  ligne_favori t0
WHERE
  t0.id_favori = ?

SELECT COUNT(*) FROM ligne_favori t0 WHERE t0.id_favori = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 865)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 140)
3	Doctrine\ORM\EntityRepository->count (line 87)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->count (line 70)
5	App\Twig\Components\GestionEntetePageComponents->getTotalFavori (line 1882)
6	Twig\Extension\CoreExtension::getAttribute (line 145)
7	__TwigTemplate_d28292ee9bdd2db91b9c48f3151ef485->doDisplay (line 388)
8	Twig\Template->yield (line 344)
9	Twig\Template->display (line 359)
10	Twig\Template->render (line 77)
11	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
12	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
13	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 185)
14	__TwigTemplate_3ab3398f0eea779d3bb1b81fb101f347->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_58eca42479de07ab815c51f24ae4bad5->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 28)
25	App\Controller\FrontEnd\ColletionController->index (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.20 ms
(9.59%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.vat_rate AS vat_rate_3, t0.email AS email_4, t0.shipping_fee AS shipping_fee_5, t0.delivery_time AS delivery_time_6, t0.public_key AS public_key_7, t0.private_key AS private_key_8, t0.webhook_secret AS webhook_secret_9, t0.updated_at AS updated_at_10 FROM sale_setting t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "GLOBAL"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.vat_rate AS vat_rate_3,
  t0.email AS email_4,
  t0.shipping_fee AS shipping_fee_5,
  t0.delivery_time AS delivery_time_6,
  t0.public_key AS public_key_7,
  t0.private_key AS private_key_8,
  t0.webhook_secret AS webhook_secret_9,
  t0.updated_at AS updated_at_10
FROM
  sale_setting t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.vat_rate AS vat_rate_3, t0.email AS email_4, t0.shipping_fee AS shipping_fee_5, t0.delivery_time AS delivery_time_6, t0.public_key AS public_key_7, t0.private_key AS private_key_8, t0.webhook_secret AS webhook_secret_9, t0.updated_at AS updated_at_10 FROM sale_setting t0 WHERE t0.code = 'GLOBAL' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 22)
5	App\Service\GestionSaleSetting->__construct (line 29)
6	ContainerSfwNWTr\getGestionSaleSettingService::do (line 671)
7	ContainerSfwNWTr\App_KernelDevDebugContainer->load (line 34)
8	ContainerSfwNWTr\getMesVariableGlobalRuntimeService::do (line 671)
9	ContainerSfwNWTr\App_KernelDevDebugContainer->load (line 399)
10	Symfony\Component\DependencyInjection\Container->getService (line 36)
11	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 33)
12	Twig\RuntimeLoader\ContainerRuntimeLoader->load (line 673)
13	Twig\Environment->getRuntime (line 62)
14	__TwigTemplate_3ab3398f0eea779d3bb1b81fb101f347->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_58eca42479de07ab815c51f24ae4bad5->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 28)
25	App\Controller\FrontEnd\ColletionController->index (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.20 ms
(9.28%)

SELECT t0.id AS id_1, t0.telephone_portable AS telephone_portable_2, t0.telephone_fixe AS telephone_fixe_3, t0.mail_contact AS mail_contact_4, t0.mail_newsletter AS mail_newsletter_5, t0.representant AS representant_6, t0.raison_social AS raison_social_7, t0.maintenance_mode AS maintenance_mode_8, t0.id_adresse AS id_adresse_9 FROM parametre_site t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.telephone_portable AS telephone_portable_2,
  t0.telephone_fixe AS telephone_fixe_3,
  t0.mail_contact AS mail_contact_4,
  t0.mail_newsletter AS mail_newsletter_5,
  t0.representant AS representant_6,
  t0.raison_social AS raison_social_7,
  t0.maintenance_mode AS maintenance_mode_8,
  t0.id_adresse AS id_adresse_9
FROM
  parametre_site t0
LIMIT
  1

SELECT t0.id AS id_1, t0.telephone_portable AS telephone_portable_2, t0.telephone_fixe AS telephone_fixe_3, t0.mail_contact AS mail_contact_4, t0.mail_newsletter AS mail_newsletter_5, t0.representant AS representant_6, t0.raison_social AS raison_social_7, t0.maintenance_mode AS maintenance_mode_8, t0.id_adresse AS id_adresse_9 FROM parametre_site t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 39)
5	App\EventListener\MaintenanceListener->onKernelRequest (line 115)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.19 ms
(8.75%)

SELECT t0.id AS id_1, t0.enregistre_le AS enregistre_le_2, t0.modifier_le AS modifier_le_3, t0.total_ht AS total_ht_4, t0.nombre_total AS nombre_total_5, t0.total_tva AS total_tva_6, t0.total_ttc AS total_ttc_7, t0.id_client AS id_client_8 FROM panier t0 WHERE t0.id = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.enregistre_le AS enregistre_le_2,
  t0.modifier_le AS modifier_le_3,
  t0.total_ht AS total_ht_4,
  t0.nombre_total AS nombre_total_5,
  t0.total_tva AS total_tva_6,
  t0.total_ttc AS total_ttc_7,
  t0.id_client AS id_client_8
FROM
  panier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.enregistre_le AS enregistre_le_2, t0.modifier_le AS modifier_le_3, t0.total_ht AS total_ht_4, t0.nombre_total AS nombre_total_5, t0.total_tva AS total_tva_6, t0.total_ttc AS total_ttc_7, t0.id_client AS id_client_8 FROM panier t0 WHERE t0.id = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 112)
7	App\Twig\Components\ListePanier->getPanier (line 1882)
8	Twig\Extension\CoreExtension::getAttribute (line 68)
9	__TwigTemplate_813fb210a0faad2a99e6301994a1d0b4->doDisplay (line 388)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 77)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 313)
16	__TwigTemplate_3ab3398f0eea779d3bb1b81fb101f347->doDisplay (line 388)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_58eca42479de07ab815c51f24ae4bad5->doDisplay (line 388)
19	Twig\Template->yield (line 344)
20	Twig\Template->display (line 359)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 334)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 28)
27	App\Controller\FrontEnd\ColletionController->index (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.18 ms
(8.56%)

SELECT DISTINCT n0_.id AS id_0, n0_.enregistre_le AS enregistre_le_1 FROM newsletter n0_ WHERE n0_.statut <> ? ORDER BY n0_.enregistre_le DESC LIMIT 12

Parameters:

[
  "Pas encore traité"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT n0_.id AS id_0,
  n0_.enregistre_le AS enregistre_le_1
FROM
  newsletter n0_
WHERE
  n0_.statut <> ?
ORDER BY
  n0_.enregistre_le DESC
LIMIT
  12

SELECT DISTINCT n0_.id AS id_0, n0_.enregistre_le AS enregistre_le_1 FROM newsletter n0_ WHERE n0_.statut <> 'Pas encore traité' ORDER BY n0_.enregistre_le DESC LIMIT 12;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerSfwNWTr\PaginatorProxyBa079e5->paginate (line 65)
16	App\Repository\NewsletterRepository->ClientRecuperationNewsletter (line 29)
17	App\Controller\FrontEnd\ColletionController->index (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.17 ms
(8.19%)

SELECT COUNT(*) FROM ligne_panier t0 WHERE t0.id_panier = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  ligne_panier t0
WHERE
  t0.id_panier = ?

SELECT COUNT(*) FROM ligne_panier t0 WHERE t0.id_panier = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 865)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 140)
3	Doctrine\ORM\EntityRepository->count (line 87)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->count (line 62)
5	App\Twig\Components\GestionEntetePageComponents->getTotalPanier (line 1882)
6	Twig\Extension\CoreExtension::getAttribute (line 145)
7	__TwigTemplate_d28292ee9bdd2db91b9c48f3151ef485->doDisplay (line 388)
8	Twig\Template->yield (line 344)
9	Twig\Template->display (line 359)
10	Twig\Template->render (line 77)
11	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
12	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
13	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 185)
14	__TwigTemplate_3ab3398f0eea779d3bb1b81fb101f347->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_58eca42479de07ab815c51f24ae4bad5->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 28)
25	App\Controller\FrontEnd\ColletionController->index (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.12 ms
(5.84%)

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.code_iso2 AS code_iso2_2, p0_.code_iso3 AS code_iso3_3, p0_.slug AS slug_4 FROM pays p0_ LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.code_iso2 AS code_iso2_2,
  p0_.code_iso3 AS code_iso3_3,
  p0_.slug AS slug_4
FROM
  pays p0_
LIMIT
  10

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.code_iso2 AS code_iso2_2, p0_.code_iso3 AS code_iso3_3, p0_.slug AS slug_4 FROM pays p0_ LIMIT 10;

#	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 99)
7	App\Twig\Components\ListePanier->getPays (line 90)
8	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 1)
9	iterator_to_array (line 50)
10	Symfony\UX\TwigComponent\ComponentProperties->getProperties (line 114)
11	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 63)
12	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
14	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 313)
15	__TwigTemplate_3ab3398f0eea779d3bb1b81fb101f347->doDisplay (line 388)
16	Twig\Template->yield (line 54)
17	__TwigTemplate_58eca42479de07ab815c51f24ae4bad5->doDisplay (line 388)
18	Twig\Template->yield (line 344)
19	Twig\Template->display (line 359)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 334)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 28)
26	App\Controller\FrontEnd\ColletionController->index (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.11 ms
(5.22%)

SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.societe AS societe_4, t0.libelle AS libelle_5, t0.complement AS complement_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.par_defaut AS par_defaut_9, t0.enregistre_le AS enregistre_le_10, t0.modifier_le AS modifier_le_11, t0.telephone_portable AS telephone_portable_12, t0.telephone_fixe AS telephone_fixe_13, t0.type AS type_14, t0.id_pays AS id_pays_15, t0.id_utilisateur AS id_utilisateur_16 FROM adresse t0 WHERE t0.id = ?

Parameters:

[
  1118
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.prenom AS prenom_2,
  t0.nom AS nom_3,
  t0.societe AS societe_4,
  t0.libelle AS libelle_5,
  t0.complement AS complement_6,
  t0.ville AS ville_7,
  t0.code_postal AS code_postal_8,
  t0.par_defaut AS par_defaut_9,
  t0.enregistre_le AS enregistre_le_10,
  t0.modifier_le AS modifier_le_11,
  t0.telephone_portable AS telephone_portable_12,
  t0.telephone_fixe AS telephone_fixe_13,
  t0.type AS type_14,
  t0.id_pays AS id_pays_15,
  t0.id_utilisateur AS id_utilisateur_16
FROM
  adresse t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.societe AS societe_4, t0.libelle AS libelle_5, t0.complement AS complement_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.par_defaut AS par_defaut_9, t0.enregistre_le AS enregistre_le_10, t0.modifier_le AS modifier_le_11, t0.telephone_portable AS telephone_portable_12, t0.telephone_fixe AS telephone_fixe_13, t0.type AS type_14, t0.id_pays AS id_pays_15, t0.id_utilisateur AS id_utilisateur_16 FROM adresse t0 WHERE t0.id = 1118;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Adresse::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Adresse->__get (line 126)
8	App\Entity\Adresse->getLibelle (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 593)
10	__TwigTemplate_3ab3398f0eea779d3bb1b81fb101f347->doDisplay (line 388)
11	Twig\Template->yield (line 54)
12	__TwigTemplate_58eca42479de07ab815c51f24ae4bad5->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 28)
21	App\Controller\FrontEnd\ColletionController->index (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.10 ms
(4.79%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_iso2 AS code_iso2_3, t0.code_iso3 AS code_iso3_4, t0.slug AS slug_5 FROM pays t0 WHERE t0.id = ?

Parameters:

[
  37
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code_iso2 AS code_iso2_3,
  t0.code_iso3 AS code_iso3_4,
  t0.slug AS slug_5
FROM
  pays t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_iso2 AS code_iso2_3, t0.code_iso3 AS code_iso3_4, t0.slug AS slug_5 FROM pays t0 WHERE t0.id = 37;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Pays::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Pays->__get (line 47)
8	App\Entity\Pays->getNom (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 605)
10	__TwigTemplate_3ab3398f0eea779d3bb1b81fb101f347->doDisplay (line 388)
11	Twig\Template->yield (line 54)
12	__TwigTemplate_58eca42479de07ab815c51f24ae4bad5->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 28)
21	App\Controller\FrontEnd\ColletionController->index (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.09 ms
(4.46%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.prix AS prix_3, t0.temps AS temps_4, t0.id_pays AS id_pays_5 FROM frais_livraison t0 WHERE t0.id_pays IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.prix AS prix_3,
  t0.temps AS temps_4,
  t0.id_pays AS id_pays_5
FROM
  frais_livraison t0
WHERE
  t0.id_pays IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.description AS description_2, t0.prix AS prix_3, t0.temps AS temps_4, t0.id_pays AS id_pays_5 FROM frais_livraison t0 WHERE t0.id_pays IS NULL LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 29)
5	App\Service\GestionSaleSetting->recuperationFraisLivraisonParPays (line 179)
6	App\Twig\Components\ListePanier->getFraisDeLivraison (line 90)
7	Symfony\UX\TwigComponent\ComponentProperties->extractProperties (line 1)
8	iterator_to_array (line 50)
9	Symfony\UX\TwigComponent\ComponentProperties->getProperties (line 114)
10	Symfony\UX\TwigComponent\ComponentRenderer->preRender (line 63)
11	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
12	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
13	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 313)
14	__TwigTemplate_3ab3398f0eea779d3bb1b81fb101f347->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_58eca42479de07ab815c51f24ae4bad5->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 28)
25	App\Controller\FrontEnd\ColletionController->index (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	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\Pays	11
App\Entity\Newsletter	10
App\Entity\ParametreSite	1
App\Entity\Adresse	1
App\Entity\SaleSetting	1

Entities Mapping

Class	Mapping errors
App\Entity\ParametreSite	No errors.
App\Entity\Adresse	No errors.
App\Entity\Newsletter	No errors.
App\Entity\LigneNewsletter	No errors.
App\Entity\SaleSetting	No errors.
App\Entity\LigneFavori	No errors.
App\Entity\Favori	No errors.
App\Entity\LignePanier	No errors.
App\Entity\Panier	No errors.
App\Entity\Pays	No errors.
App\Entity\FraisLivraison	No errors.
App\Entity\Utilisateur	No errors.

Symfony Profiler

GET https://preprod.audioanalogdistribution.com/collection/liste

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping