Symfony Profiler

Query Metrics

19 Database Queries

14 Different statements

5.57 ms Query time

0 Invalid entities

44 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.12 ms
(55.91%)

SELECT l0_.id AS id_0, l0_.nom AS nom_1, l0_.slug AS slug_2, COUNT(p1_.id) AS sclr_3, p1_.categorie AS categorie_4 FROM produit p1_ LEFT JOIN label l0_ ON p1_.id_label = l0_.id WHERE p1_.categorie = ? AND p1_.id_label <> ? GROUP BY l0_.id ORDER BY l0_.nom ASC

Parameters:

[
  "Vinyles"
  ""
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.nom AS nom_1,
  l0_.slug AS slug_2,
  COUNT(p1_.id) AS sclr_3,
  p1_.categorie AS categorie_4
FROM
  produit p1_
  LEFT JOIN label l0_ ON p1_.id_label = l0_.id
WHERE
  p1_.categorie = ?
  AND p1_.id_label <> ?
GROUP BY
  l0_.id
ORDER BY
  l0_.nom ASC

SELECT l0_.id AS id_0, l0_.nom AS nom_1, l0_.slug AS slug_2, COUNT(p1_.id) AS sclr_3, p1_.categorie AS categorie_4 FROM produit p1_ LEFT JOIN label l0_ ON p1_.id_label = l0_.id WHERE p1_.categorie = 'Vinyles' AND p1_.id_label <> '' GROUP BY l0_.id ORDER BY l0_.nom ASC;

#	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 142)
7	App\Service\FrontGestionProduitIdentite->recuperationIdentiteParProduit (line 90)
8	App\Controller\FrontEnd\IdentiteController->reponseIdentiteListe (line 62)
9	App\Controller\FrontEnd\IdentiteController->labelListe (line 183)
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.36 ms
(6.46%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 430)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 40)
5	App\Service\VisiteurService->ajout (line 43)
6	App\EventListener\EcouteEvenementRequetListener->onKernelRequest (line 115)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.28 ms
(4.97%)

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_30897430dabf057c678033ef0bdb8b9c->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 87)
25	App\Controller\FrontEnd\IdentiteController->reponseIdentiteListe (line 62)
26	App\Controller\FrontEnd\IdentiteController->labelListe (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.24 ms
(4.32%)

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.24 ms
(4.32%)

INSERT INTO visiteur (ip, enregistre_le) VALUES (?, ?)

Parameters:

[
  "216.73.216.232"
  "2026-05-19 13:08:34"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO visiteur (ip, enregistre_le)
VALUES
  (?, ?)

INSERT INTO visiteur (ip, enregistre_le) VALUES ('216.73.216.232', '2026-05-19 13:08:34');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 251)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1051)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 400)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 40)
7	App\Service\VisiteurService->ajout (line 43)
8	App\EventListener\EcouteEvenementRequetListener->onKernelRequest (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.22 ms
(3.97%)

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_30897430dabf057c678033ef0bdb8b9c->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 87)
25	App\Controller\FrontEnd\IdentiteController->reponseIdentiteListe (line 62)
26	App\Controller\FrontEnd\IdentiteController->labelListe (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.21 ms
(3.70%)

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_30897430dabf057c678033ef0bdb8b9c->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 87)
25	App\Controller\FrontEnd\IdentiteController->reponseIdentiteListe (line 62)
26	App\Controller\FrontEnd\IdentiteController->labelListe (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.19 ms
(3.44%)

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_30897430dabf057c678033ef0bdb8b9c->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 87)
27	App\Controller\FrontEnd\IdentiteController->reponseIdentiteListe (line 62)
28	App\Controller\FrontEnd\IdentiteController->labelListe (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.15 ms
(2.78%)

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_30897430dabf057c678033ef0bdb8b9c->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 87)
26	App\Controller\FrontEnd\IdentiteController->reponseIdentiteListe (line 62)
27	App\Controller\FrontEnd\IdentiteController->labelListe (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.14 ms
(2.44%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 379)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 40)
4	App\Service\VisiteurService->ajout (line 43)
5	App\EventListener\EcouteEvenementRequetListener->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.12 ms
(2.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 53)
12	__TwigTemplate_30897430dabf057c678033ef0bdb8b9c->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 87)
21	App\Controller\FrontEnd\IdentiteController->reponseIdentiteListe (line 62)
22	App\Controller\FrontEnd\IdentiteController->labelListe (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
(1.92%)

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 85)
6	App\Controller\FrontEnd\IdentiteController->reponseIdentiteListe (line 62)
7	App\Controller\FrontEnd\IdentiteController->labelListe (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.10 ms
(1.85%)

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_30897430dabf057c678033ef0bdb8b9c->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 87)
21	App\Controller\FrontEnd\IdentiteController->reponseIdentiteListe (line 62)
22	App\Controller\FrontEnd\IdentiteController->labelListe (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.10 ms
(1.71%)

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_30897430dabf057c678033ef0bdb8b9c->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 87)
25	App\Controller\FrontEnd\IdentiteController->reponseIdentiteListe (line 62)
26	App\Controller\FrontEnd\IdentiteController->labelListe (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\Visiteur	1
App\Entity\SaleSetting	1

Entities Mapping

Class	Mapping errors
App\Entity\ParametreSite	No errors.
App\Entity\Adresse	No errors.
App\Entity\Visiteur	No errors.
App\Entity\Style	No errors.
App\Entity\Produit	No errors.
App\Entity\Label	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/Vinyles/label/liste

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping