Symfony Profiler

Query Metrics

18 Database Queries

13 Different statements

3.28 ms Query time

0 Invalid entities

43 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.84 ms
(25.48%)

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM produit p0_ LEFT JOIN photo_produit p1_ ON p0_.id = p1_.id_produit WHERE p0_.categorie = ? AND p0_.id_style = ?

Parameters:

[
  "Master Tapes"
  36
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  produit p0_
  LEFT JOIN photo_produit p1_ ON p0_.id = p1_.id_produit
WHERE
  p0_.categorie = ?
  AND p0_.id_style = ?

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM produit p0_ LEFT JOIN photo_produit p1_ ON p0_.id = p1_.id_produit WHERE p0_.categorie = 'Master Tapes' AND p0_.id_style = 36;

#	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 407)
16	App\Repository\ProduitRepository->FrontRecuperationProduitParCategorie (line 258)
17	App\Controller\FrontEnd\ProduitController->reponseProduitListe (line 114)
18	App\Controller\FrontEnd\ProduitController->style (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.54 ms
(16.51%)

SELECT DISTINCT p0_.id AS id_0, p0_.modifier_le AS modifier_le_1, p0_.nom AS nom_2 FROM produit p0_ LEFT JOIN photo_produit p1_ ON p0_.id = p1_.id_produit WHERE p0_.categorie = ? AND p0_.id_style = ? ORDER BY p0_.modifier_le DESC, p0_.nom ASC LIMIT 12

Parameters:

[
  "Master Tapes"
  36
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.modifier_le AS modifier_le_1,
  p0_.nom AS nom_2
FROM
  produit p0_
  LEFT JOIN photo_produit p1_ ON p0_.id = p1_.id_produit
WHERE
  p0_.categorie = ?
  AND p0_.id_style = ?
ORDER BY
  p0_.modifier_le DESC,
  p0_.nom ASC
LIMIT
  12

SELECT DISTINCT p0_.id AS id_0, p0_.modifier_le AS modifier_le_1, p0_.nom AS nom_2 FROM produit p0_ LEFT JOIN photo_produit p1_ ON p0_.id = p1_.id_produit WHERE p0_.categorie = 'Master Tapes' AND p0_.id_style = 36 ORDER BY p0_.modifier_le DESC, p0_.nom ASC 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 407)
16	App\Repository\ProduitRepository->FrontRecuperationProduitParCategorie (line 258)
17	App\Controller\FrontEnd\ProduitController->reponseProduitListe (line 114)
18	App\Controller\FrontEnd\ProduitController->style (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.29 ms
(8.78%)

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 53)
16	__TwigTemplate_0cb91ff2e32e14ce081c5f868db16ff4->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 255)
25	App\Controller\FrontEnd\ProduitController->reponseProduitListe (line 114)
26	App\Controller\FrontEnd\ProduitController->style (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.25 ms
(7.55%)

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 53)
16	__TwigTemplate_0cb91ff2e32e14ce081c5f868db16ff4->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 255)
25	App\Controller\FrontEnd\ProduitController->reponseProduitListe (line 114)
26	App\Controller\FrontEnd\ProduitController->style (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.23 ms
(6.92%)

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.22 ms
(6.62%)

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 53)
18	__TwigTemplate_0cb91ff2e32e14ce081c5f868db16ff4->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 255)
27	App\Controller\FrontEnd\ProduitController->reponseProduitListe (line 114)
28	App\Controller\FrontEnd\ProduitController->style (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

0.20 ms
(6.06%)

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 53)
16	__TwigTemplate_0cb91ff2e32e14ce081c5f868db16ff4->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 255)
25	App\Controller\FrontEnd\ProduitController->reponseProduitListe (line 114)
26	App\Controller\FrontEnd\ProduitController->style (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.13 ms
(4.11%)

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 53)
17	__TwigTemplate_0cb91ff2e32e14ce081c5f868db16ff4->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 255)
26	App\Controller\FrontEnd\ProduitController->reponseProduitListe (line 114)
27	App\Controller\FrontEnd\ProduitController->style (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.13 ms
(3.90%)

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 53)
12	__TwigTemplate_0cb91ff2e32e14ce081c5f868db16ff4->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 255)
21	App\Controller\FrontEnd\ProduitController->reponseProduitListe (line 114)
22	App\Controller\FrontEnd\ProduitController->style (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.12 ms
(3.69%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM style t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "pop-rock"
]

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
FROM
  style t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM style t0 WHERE t0.slug = 'pop-rock' 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 69)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.12 ms
(3.62%)

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 53)
12	__TwigTemplate_0cb91ff2e32e14ce081c5f868db16ff4->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 255)
21	App\Controller\FrontEnd\ProduitController->reponseProduitListe (line 114)
22	App\Controller\FrontEnd\ProduitController->style (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.11 ms
(3.50%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM style t0 ORDER BY t0.nom ASC LIMIT 30

Parameters:

[]

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
FROM
  style t0
ORDER BY
  t0.nom ASC
LIMIT
  30

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM style t0 ORDER BY t0.nom ASC LIMIT 30;

#	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 82)
5	App\Service\FrontGestionProduitIdentite->recuperationIdentitePourfiltre (line 253)
6	App\Controller\FrontEnd\ProduitController->reponseProduitListe (line 114)
7	App\Controller\FrontEnd\ProduitController->style (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.11 ms
(3.26%)

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 53)
16	__TwigTemplate_0cb91ff2e32e14ce081c5f868db16ff4->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 255)
25	App\Controller\FrontEnd\ProduitController->reponseProduitListe (line 114)
26	App\Controller\FrontEnd\ProduitController->style (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)

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\Style	29
App\Entity\Pays	11
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\Style	No errors.
App\Entity\Produit	No errors.
App\Entity\PhotoProduit	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/produit/Master%20Tapes/style/pop-rock

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping