Symfony Profiler

Query Metrics

44 Database Queries

26 Different statements

220.97 ms Query time

0 Invalid entities

1918 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

37.62 ms
(17.03%)

SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.parent_id = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.created AS created_1,
  t0.updated AS updated_2,
  t0.id AS id_3,
  t0.visible AS visible_4,
  t0.archive AS archive_5,
  t0.exclude_columbus AS exclude_columbus_6,
  t0.nouveau AS nouveau_7,
  t0.precommande AS precommande_8,
  t0.precommande_date AS precommande_date_9,
  t0.offre_speciale AS offre_speciale_10,
  t0.cadeau AS cadeau_11,
  t0.goodie AS goodie_12,
  t0.declinaison AS declinaison_13,
  t0.declinaison_principale AS declinaison_principale_14,
  t0.reference AS reference_15,
  t0.titre AS titre_16,
  t0.titre_brouillon AS titre_brouillon_17,
  t0.contenu AS contenu_18,
  t0.contenu_brouillon AS contenu_brouillon_19,
  t0.contenu2 AS contenu2_20,
  t0.contenu2_brouillon AS contenu2_brouillon_21,
  t0.slug AS slug_22,
  t0.prix_achat_ht AS prix_achat_ht_23,
  t0.montantHT AS montantHT_24,
  t0.montantTTC AS montantTTC_25,
  t0.montantActuelTTC AS montantActuelTTC_26,
  t0.tva AS tva_27,
  t0.stock AS stock_28,
  t0.alerte_stock AS alerte_stock_29,
  t0.stock_emaplacement AS stock_emaplacement_30,
  t0.poids AS poids_31,
  t0.recherche_keyword AS recherche_keyword_32,
  t0.recherche_slug AS recherche_slug_33,
  t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34,
  t0.produits_associes AS produits_associes_35,
  t0.meta_title AS meta_title_36,
  t0.meta_keyword AS meta_keyword_37,
  t0.meta_description AS meta_description_38,
  t0.note_avis AS note_avis_39,
  t0.nb_avis AS nb_avis_40,
  t0.image_panorama_name AS image_panorama_name_41,
  t0.image_panorama_updated_at AS image_panorama_updated_at_42,
  t0.image_portrait_name AS image_portrait_name_43,
  t0.image_portrait_updated_at AS image_portrait_updated_at_44,
  t0.image_name AS image_name_45,
  t0.image_updated_at AS image_updated_at_46,
  t0.image_alt AS image_alt_47,
  t0.image_name_brouillon AS image_name_brouillon_48,
  t0.image_updated_at_brouillon AS image_updated_at_brouillon_49,
  t0.total_ca AS total_ca_50,
  t0.count_commande AS count_commande_51,
  t0.is_customizable AS is_customizable_52,
  t0.parent_id AS parent_id_53
FROM
  produit t0
WHERE
  t0.parent_id = ?

SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.parent_id = 13;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->isEmpty (line 535)
9	App\Entity\Produit->hasSearchableStock (line 1397)
10	App\Entity\Produit->isSearchable (line 399)
11	App\Search\SearchEditorialService->getEditorialData (line 45)
12	App\Controller\Front\SearchEditorialController->overlayPanel (line 20)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
16	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
17	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
18	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
19	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
20	__TwigTemplate_52459b8e677d0d99da267c994447f883->doDisplay (line 80)
21	Twig\Template->yield (line 447)
22	Twig\Template->display (line 402)
23	Twig\Template->render (line 417)
24	Twig\TemplateWrapper->render (line 53)
25	Twig\Extension\CoreExtension->include (line 1571)
26	__TwigTemplate_9799e282b193541f963e0bb5b2852170::doDisplay (line 186)
27	Twig\Template->yield (line 447)
28	Twig\Template->display (line 402)
29	Twig\Template->render (line 417)
30	Twig\TemplateWrapper->render (line 53)
31	Twig\Extension\CoreExtension->include (line 1571)
32	__TwigTemplate_4f76d49d661d868e852f25d00e21b62c::block_header (line 581)
33	Twig\Template->yieldBlock (line 479)
34	__TwigTemplate_4f76d49d661d868e852f25d00e21b62c->doDisplay (line 227)
35	Twig\Template->yield (line 447)
36	__TwigTemplate_fc5a1f42c5c9d4bf427f2ff176b7fb5d->doDisplay (line 104)
37	Twig\Template->yield (line 447)
38	Twig\Template->display (line 402)
39	Twig\Template->render (line 417)
40	Twig\TemplateWrapper->render (line 53)
41	Twig\Environment->render (line 333)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
45	App\Controller\Front\CatalogController->produit (line 278)
46	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
47	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
48	Symfony\Component\HttpKernel\Kernel->handle (line 193)
49	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
50	require_once (line 32)
51	require_once (line 13)

21.78 ms
(9.86%)

SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = ? ORDER BY t0.id ASC

Parameters:

[
  1024
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.produit_parent_id AS produit_parent_id_2,
  t0.produit_id AS produit_id_3,
  t0.attribut_id AS attribut_id_4,
  t0.attribut_valeur_id AS attribut_valeur_id_5
FROM
  produit_attribut t0
WHERE
  t0.produit_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_id = 1024 ORDER BY t0.id ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->isEmpty (line 535)
9	App\Services\App->getAvailableAttributValeurs (line 153)
10	App\Controller\Front\CatalogController->produit (line 224)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
15	require_once (line 32)
16	require_once (line 13)

20.43 ms
(9.25%)

SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = ? ORDER BY t0.ordre ASC

Parameters:

[
  1023
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ordre AS ordre_2,
  t0.produit_id AS produit_id_3,
  t0.categorie_id AS categorie_id_4
FROM
  categorie_produit t0
WHERE
  t0.produit_id = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.produit_id AS produit_id_3, t0.categorie_id AS categorie_id_4 FROM categorie_produit t0 WHERE t0.produit_id = 1023 ORDER BY t0.ordre ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\Produit->getProperCategories (line 667)
8	App\Entity\Produit->getMainCategorie (line 706)
9	App\Controller\Front\CatalogController->produit (line 238)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 13)

17.27 ms
(7.81%)

SELECT t0_.variable AS variable_0, t1_.variable AS variable_1, t1_.rubrique AS rubrique_2 FROM traduction_valeur t0_ INNER JOIN traduction t1_ ON t0_.traduction_id = t1_.id WHERE t0_.locale = ?

Parameters:

[
  "fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.variable AS variable_0,
  t1_.variable AS variable_1,
  t1_.rubrique AS rubrique_2
FROM
  traduction_valeur t0_
  INNER JOIN traduction t1_ ON t0_.traduction_id = t1_.id
WHERE
  t0_.locale = ?

SELECT t0_.variable AS variable_0, t1_.variable AS variable_1, t1_.rubrique AS rubrique_2 FROM traduction_valeur t0_ INNER JOIN traduction t1_ ON t0_.traduction_id = t1_.id WHERE t0_.locale = 'fr';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 918)
6	App\Repository\TraductionValeurRepository->getAllInArray (line 41)
7	App\Services\TraductionService->loadTraductions (line 93)
8	App\Services\TraductionService->tradme (line 40)
9	App\Form\FrontNewsletterType->buildForm (line 28)
10	Symfony\Component\Form\ResolvedFormType->buildForm (line 100)
11	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
12	Symfony\Component\Form\FormFactory->createNamedBuilder (line 80)
13	Symfony\Component\Form\FormFactory->createBuilder (line 58)
14	App\Newsletter\NewsletterBuilder->formNewsletter (line 41)
15	App\Services\Returner->front (line 182)
16	App\Controller\Front\CatalogController->produit (line 171)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
21	require_once (line 32)
22	require_once (line 13)

16.81 ms
(7.61%)

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.color AS color_4, t0.with_associated_page AS with_associated_page_5, t0.system AS system_6, t0.auto AS auto_7, t0.show_in_search AS show_in_search_8, t0.total_ca AS total_ca_9, t0.count_commande AS count_commande_10, t0.titre AS titre_11, t0.slug AS slug_12 FROM categorie t0 WHERE t0.id = ?

Parameters:

[
  226
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.color AS color_4,
  t0.with_associated_page AS with_associated_page_5,
  t0.system AS system_6,
  t0.auto AS auto_7,
  t0.show_in_search AS show_in_search_8,
  t0.total_ca AS total_ca_9,
  t0.count_commande AS count_commande_10,
  t0.titre AS titre_11,
  t0.slug AS slug_12
FROM
  categorie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.color AS color_4, t0.with_associated_page AS with_associated_page_5, t0.system AS system_6, t0.auto AS auto_7, t0.show_in_search AS show_in_search_8, t0.total_ca AS total_ca_9, t0.count_commande AS count_commande_10, t0.titre AS titre_11, t0.slug AS slug_12 FROM categorie t0 WHERE t0.id = 226;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Entity\Categorie::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Categorie->__get (line 153)
7	App\Entity\Categorie->isSystem (line 187)
8	Twig\Extension\CoreExtension->getAttribute (line 1992)
9	__TwigTemplate_f6eed0a3c82e03bc00fc1296a4a9bcd4::doDisplay (line 288)
10	Twig\Template->yield (line 447)
11	Twig\Template->display (line 402)
12	Twig\Template->render (line 417)
13	Twig\TemplateWrapper->render (line 53)
14	Twig\Extension\CoreExtension->include (line 1571)
15	__TwigTemplate_25b30196622ed5f8fc4a522c79a32bf7::doDisplay (line 126)
16	Twig\Template->yield (line 447)
17	Twig\Template->display (line 402)
18	Twig\Template->render (line 417)
19	Twig\TemplateWrapper->render (line 53)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\Front\SearchEditorialController->overlayPanel (line 25)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
28	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
29	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
30	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
31	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
32	__TwigTemplate_52459b8e677d0d99da267c994447f883->doDisplay (line 80)
33	Twig\Template->yield (line 447)
34	Twig\Template->display (line 402)
35	Twig\Template->render (line 417)
36	Twig\TemplateWrapper->render (line 53)
37	Twig\Extension\CoreExtension->include (line 1571)
38	__TwigTemplate_9799e282b193541f963e0bb5b2852170::doDisplay (line 186)
39	Twig\Template->yield (line 447)
40	Twig\Template->display (line 402)
41	Twig\Template->render (line 417)
42	Twig\TemplateWrapper->render (line 53)
43	Twig\Extension\CoreExtension->include (line 1571)
44	__TwigTemplate_4f76d49d661d868e852f25d00e21b62c::block_header (line 581)
45	Twig\Template->yieldBlock (line 479)
46	__TwigTemplate_4f76d49d661d868e852f25d00e21b62c->doDisplay (line 227)
47	Twig\Template->yield (line 447)
48	__TwigTemplate_fc5a1f42c5c9d4bf427f2ff176b7fb5d->doDisplay (line 104)
49	Twig\Template->yield (line 447)
50	Twig\Template->display (line 402)
51	Twig\Template->render (line 417)
52	Twig\TemplateWrapper->render (line 53)
53	Twig\Environment->render (line 333)
54	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
55	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
56	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
57	App\Controller\Front\CatalogController->produit (line 278)
58	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
59	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
60	Symfony\Component\HttpKernel\Kernel->handle (line 193)
61	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
62	require_once (line 32)
63	require_once (line 13)

9.60 ms
(4.34%)

SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC

Parameters:

[
  1
  "2026-09-24 17:22:18"
  "2026-09-24 17:22:18"
  "2026-09-24 17:22:18"
  "2026-09-24 17:22:18"
  13
  226
  216
  215
  218
  219
  220
  229
  217
  26
  132
  164
  37
  4
  162
  19
  5
  163
  0.0
  13
  13
  13
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.visible AS visible_1,
  p0_.page AS page_2,
  p0_.created AS created_3,
  p0_.updated AS updated_4,
  p0_.date_debut AS date_debut_5,
  p0_.date_fin AS date_fin_6,
  p0_.titre AS titre_7,
  p0_.slug AS slug_8,
  p0_.contenu AS contenu_9,
  p0_.image_name AS image_name_10,
  p0_.image_updated_at AS image_updated_at_11,
  p0_.typage AS typage_12,
  p0_.montant AS montant_13,
  p0_.montant_min AS montant_min_14,
  p0_.customer_order_count_min AS customer_order_count_min_15,
  p0_.customer_order_count_max AS customer_order_count_max_16,
  p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17,
  p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18,
  p0_.customer_account_age_days_min AS customer_account_age_days_min_19,
  p0_.customer_account_age_days_max AS customer_account_age_days_max_20,
  p0_.y_offert AS y_offert_21,
  p0_.meta_title AS meta_title_22,
  p0_.meta_keyword AS meta_keyword_23,
  p0_.meta_description AS meta_description_24,
  p0_.produit_offert_id AS produit_offert_id_25
FROM
  promotion p0_
  LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id
  LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id
  LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id
  LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id
WHERE
  p0_.visible = ?
  AND (
    (
      p0_.date_fin >= ?
      OR p0_.date_fin IS NULL
    )
  )
  AND (
    (
      p0_.date_debut <= ?
      OR p0_.date_debut IS NULL
    )
  )
  AND (
    (
      p0_.date_fin >= ?
      OR p0_.date_fin IS NULL
    )
  )
  AND (
    (
      p0_.date_debut <= ?
      OR p0_.date_debut IS NULL
    )
  )
  AND (
    (
      (p1_.id = ?)
      OR (
        c3_.id IN (
          ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
          ?
        )
        AND c3_.id IS NOT NULL
      )
    )
  )
  AND (
    (
      p0_.montant_min IS NULL
      OR p0_.montant_min <= ?
    )
  )
  AND (
    NOT (
      EXISTS (
        SELECT
          1 AS sclr_26
        FROM
          promotion p5_
          INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id
          INNER JOIN produit p6_ ON p6_.id = p7_.produit_id
        WHERE
          p5_.id = p0_.id
          AND (
            (
              p6_.id = ?
              OR p6_.id = ?
            )
          )
      )
    )
  )
  AND (
    NOT (
      EXISTS (
        SELECT
          1 AS sclr_27
        FROM
          promotion p8_
          INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id
          INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id
          INNER JOIN categorie_produit c11_ ON (
            c11_.categorie_id = c9_.id
            AND (
              c11_.produit_id = ?
              OR c11_.produit_id = ?
            )
          )
        WHERE
          p8_.id = p0_.id
      )
    )
  )
ORDER BY
  p0_.created DESC

SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = 1 AND ((p0_.date_fin >= '2026-09-24 17:22:18' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:22:18' OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= '2026-09-24 17:22:18' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:22:18' OR p0_.date_debut IS NULL)) AND (((p1_.id = 13) OR (c3_.id IN (226, 216, 215, 218, 219, 220, 229, 217, 26, 132, 164, 37, 4, 162, 19, 5, 163) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= 0)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = 13 OR p6_.id = 13))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = 13 OR c11_.produit_id = 13)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\PromotionRepository->findPromotions (line 199)
7	App\Services\PromoPriceCalculator->getProductPricePromo (line 96)
8	App\Twig\PanierTwigExtension->productPricePromo (line 33)
9	__TwigTemplate_f6eed0a3c82e03bc00fc1296a4a9bcd4->doDisplay (line 160)
10	Twig\Template->yield (line 447)
11	Twig\Template->display (line 402)
12	Twig\Template->render (line 417)
13	Twig\TemplateWrapper->render (line 53)
14	Twig\Extension\CoreExtension->include (line 1571)
15	__TwigTemplate_25b30196622ed5f8fc4a522c79a32bf7::doDisplay (line 126)
16	Twig\Template->yield (line 447)
17	Twig\Template->display (line 402)
18	Twig\Template->render (line 417)
19	Twig\TemplateWrapper->render (line 53)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\Front\SearchEditorialController->overlayPanel (line 25)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
28	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
29	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
30	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
31	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
32	__TwigTemplate_52459b8e677d0d99da267c994447f883->doDisplay (line 80)
33	Twig\Template->yield (line 447)
34	Twig\Template->display (line 402)
35	Twig\Template->render (line 417)
36	Twig\TemplateWrapper->render (line 53)
37	Twig\Extension\CoreExtension->include (line 1571)
38	__TwigTemplate_9799e282b193541f963e0bb5b2852170::doDisplay (line 186)
39	Twig\Template->yield (line 447)
40	Twig\Template->display (line 402)
41	Twig\Template->render (line 417)
42	Twig\TemplateWrapper->render (line 53)
43	Twig\Extension\CoreExtension->include (line 1571)
44	__TwigTemplate_4f76d49d661d868e852f25d00e21b62c::block_header (line 581)
45	Twig\Template->yieldBlock (line 479)
46	__TwigTemplate_4f76d49d661d868e852f25d00e21b62c->doDisplay (line 227)
47	Twig\Template->yield (line 447)
48	__TwigTemplate_fc5a1f42c5c9d4bf427f2ff176b7fb5d->doDisplay (line 104)
49	Twig\Template->yield (line 447)
50	Twig\Template->display (line 402)
51	Twig\Template->render (line 417)
52	Twig\TemplateWrapper->render (line 53)
53	Twig\Environment->render (line 333)
54	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
55	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
56	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
57	App\Controller\Front\CatalogController->produit (line 278)
58	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
59	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
60	Symfony\Component\HttpKernel\Kernel->handle (line 193)
61	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
62	require_once (line 32)
63	require_once (line 13)

8.10 ms
(3.67%)

SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.reference IN (?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "DC4357-BLANC"
  "DC4357-BLEU"
  "DC4357-MARRON"
  "\tdc4357-PRUNE"
  "DC4357-ROSE"
  "\tDC4357-VERT"
  "DC4357-VERT CLAIR"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.created AS created_1,
  t0.updated AS updated_2,
  t0.id AS id_3,
  t0.visible AS visible_4,
  t0.archive AS archive_5,
  t0.exclude_columbus AS exclude_columbus_6,
  t0.nouveau AS nouveau_7,
  t0.precommande AS precommande_8,
  t0.precommande_date AS precommande_date_9,
  t0.offre_speciale AS offre_speciale_10,
  t0.cadeau AS cadeau_11,
  t0.goodie AS goodie_12,
  t0.declinaison AS declinaison_13,
  t0.declinaison_principale AS declinaison_principale_14,
  t0.reference AS reference_15,
  t0.titre AS titre_16,
  t0.titre_brouillon AS titre_brouillon_17,
  t0.contenu AS contenu_18,
  t0.contenu_brouillon AS contenu_brouillon_19,
  t0.contenu2 AS contenu2_20,
  t0.contenu2_brouillon AS contenu2_brouillon_21,
  t0.slug AS slug_22,
  t0.prix_achat_ht AS prix_achat_ht_23,
  t0.montantHT AS montantHT_24,
  t0.montantTTC AS montantTTC_25,
  t0.montantActuelTTC AS montantActuelTTC_26,
  t0.tva AS tva_27,
  t0.stock AS stock_28,
  t0.alerte_stock AS alerte_stock_29,
  t0.stock_emaplacement AS stock_emaplacement_30,
  t0.poids AS poids_31,
  t0.recherche_keyword AS recherche_keyword_32,
  t0.recherche_slug AS recherche_slug_33,
  t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34,
  t0.produits_associes AS produits_associes_35,
  t0.meta_title AS meta_title_36,
  t0.meta_keyword AS meta_keyword_37,
  t0.meta_description AS meta_description_38,
  t0.note_avis AS note_avis_39,
  t0.nb_avis AS nb_avis_40,
  t0.image_panorama_name AS image_panorama_name_41,
  t0.image_panorama_updated_at AS image_panorama_updated_at_42,
  t0.image_portrait_name AS image_portrait_name_43,
  t0.image_portrait_updated_at AS image_portrait_updated_at_44,
  t0.image_name AS image_name_45,
  t0.image_updated_at AS image_updated_at_46,
  t0.image_alt AS image_alt_47,
  t0.image_name_brouillon AS image_name_brouillon_48,
  t0.image_updated_at_brouillon AS image_updated_at_brouillon_49,
  t0.total_ca AS total_ca_50,
  t0.count_commande AS count_commande_51,
  t0.is_customizable AS is_customizable_52,
  t0.parent_id AS parent_id_53
FROM
  produit t0
WHERE
  t0.reference IN (?, ?, ?, ?, ?, ?, ?)

SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.reference IN ('DC4357-BLANC', 'DC4357-BLEU', 'DC4357-MARRON', '	dc4357-PRUNE', 'DC4357-ROSE', '	DC4357-VERT', 'DC4357-VERT CLAIR');

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	App\Controller\Front\CatalogController->produit (line 236)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
8	require_once (line 32)
9	require_once (line 13)

7.85 ms
(3.55%)

SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ? OR p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC

Parameters:

[
  1
  "2026-09-24 17:22:18"
  "2026-09-24 17:22:18"
  "2026-09-24 17:22:18"
  "2026-09-24 17:22:18"
  1024
  1023
  226
  229
  220
  219
  218
  217
  216
  215
  214
  213
  201
  134
  11
  61
  87
  13
  60
  0.0
  1024
  1023
  1024
  1023
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.visible AS visible_1,
  p0_.page AS page_2,
  p0_.created AS created_3,
  p0_.updated AS updated_4,
  p0_.date_debut AS date_debut_5,
  p0_.date_fin AS date_fin_6,
  p0_.titre AS titre_7,
  p0_.slug AS slug_8,
  p0_.contenu AS contenu_9,
  p0_.image_name AS image_name_10,
  p0_.image_updated_at AS image_updated_at_11,
  p0_.typage AS typage_12,
  p0_.montant AS montant_13,
  p0_.montant_min AS montant_min_14,
  p0_.customer_order_count_min AS customer_order_count_min_15,
  p0_.customer_order_count_max AS customer_order_count_max_16,
  p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17,
  p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18,
  p0_.customer_account_age_days_min AS customer_account_age_days_min_19,
  p0_.customer_account_age_days_max AS customer_account_age_days_max_20,
  p0_.y_offert AS y_offert_21,
  p0_.meta_title AS meta_title_22,
  p0_.meta_keyword AS meta_keyword_23,
  p0_.meta_description AS meta_description_24,
  p0_.produit_offert_id AS produit_offert_id_25
FROM
  promotion p0_
  LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id
  LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id
  LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id
  LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id
WHERE
  p0_.visible = ?
  AND (
    (
      p0_.date_fin >= ?
      OR p0_.date_fin IS NULL
    )
  )
  AND (
    (
      p0_.date_debut <= ?
      OR p0_.date_debut IS NULL
    )
  )
  AND (
    (
      p0_.date_fin >= ?
      OR p0_.date_fin IS NULL
    )
  )
  AND (
    (
      p0_.date_debut <= ?
      OR p0_.date_debut IS NULL
    )
  )
  AND (
    (
      (
        p1_.id = ?
        OR p1_.id = ?
      )
      OR (
        c3_.id IN (
          ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
          ?
        )
        AND c3_.id IS NOT NULL
      )
    )
  )
  AND (
    (
      p0_.montant_min IS NULL
      OR p0_.montant_min <= ?
    )
  )
  AND (
    NOT (
      EXISTS (
        SELECT
          1 AS sclr_26
        FROM
          promotion p5_
          INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id
          INNER JOIN produit p6_ ON p6_.id = p7_.produit_id
        WHERE
          p5_.id = p0_.id
          AND (
            (
              p6_.id = ?
              OR p6_.id = ?
            )
          )
      )
    )
  )
  AND (
    NOT (
      EXISTS (
        SELECT
          1 AS sclr_27
        FROM
          promotion p8_
          INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id
          INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id
          INNER JOIN categorie_produit c11_ ON (
            c11_.categorie_id = c9_.id
            AND (
              c11_.produit_id = ?
              OR c11_.produit_id = ?
            )
          )
        WHERE
          p8_.id = p0_.id
      )
    )
  )
ORDER BY
  p0_.created DESC

SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = 1 AND ((p0_.date_fin >= '2026-09-24 17:22:18' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:22:18' OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= '2026-09-24 17:22:18' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:22:18' OR p0_.date_debut IS NULL)) AND (((p1_.id = 1024 OR p1_.id = 1023) OR (c3_.id IN (226, 229, 220, 219, 218, 217, 216, 215, 214, 213, 201, 134, 11, 61, 87, 13, 60) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= 0)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = 1024 OR p6_.id = 1023))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = 1024 OR c11_.produit_id = 1023)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\PromotionRepository->findPromotions (line 199)
7	App\Services\PromoPriceCalculator->getProductPricePromo (line 96)
8	App\Twig\PanierTwigExtension->productPricePromo (line 33)
9	__TwigTemplate_fc5a1f42c5c9d4bf427f2ff176b7fb5d->doDisplay (line 101)
10	Twig\Template->yield (line 447)
11	Twig\Template->display (line 402)
12	Twig\Template->render (line 417)
13	Twig\TemplateWrapper->render (line 53)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
18	App\Controller\Front\CatalogController->produit (line 278)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
23	require_once (line 32)
24	require_once (line 13)

7.07 ms
(3.20%)

SELECT c0_.id AS id_0, c0_.ordre AS ordre_1, c0_.produit_id AS produit_id_2, c0_.categorie_id AS categorie_id_3 FROM categorie_produit c0_ INNER JOIN produit p1_ ON c0_.produit_id = p1_.id WHERE p1_.visible = ? AND c0_.categorie_id = ? AND c0_.produit_id NOT IN (1024) ORDER BY c0_.ordre ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.ordre AS ordre_1,
  c0_.produit_id AS produit_id_2,
  c0_.categorie_id AS categorie_id_3
FROM
  categorie_produit c0_
  INNER JOIN produit p1_ ON c0_.produit_id = p1_.id
WHERE
  p1_.visible = ?
  AND c0_.categorie_id = ?
  AND c0_.produit_id NOT IN (1024)
ORDER BY
  c0_.ordre ASC

SELECT c0_.id AS id_0, c0_.ordre AS ordre_1, c0_.produit_id AS produit_id_2, c0_.categorie_id AS categorie_id_3 FROM categorie_produit c0_ INNER JOIN produit p1_ ON c0_.produit_id = p1_.id WHERE p1_.visible = 1 AND c0_.categorie_id = 226 AND c0_.produit_id NOT IN (1024) ORDER BY c0_.ordre ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Controller\Front\CatalogController->produit (line 241)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
11	require_once (line 32)
12	require_once (line 13)

7.03 ms
(3.18%)

SELECT l0_.image_updated_at AS image_updated_at_0, l0_.image2_updated_at AS image2_updated_at_1, l0_.image_bannniere_updated_at AS image_bannniere_updated_at_2, l0_.image_bannniere_illu_updated_at AS image_bannniere_illu_updated_at_3, l0_.id AS id_4, l0_.visible AS visible_5, l0_.archive AS archive_6, l0_.banniere AS banniere_7, l0_.created AS created_8, l0_.updated AS updated_9, l0_.color AS color_10, l0_.redirection AS redirection_11, l0_.titre AS titre_12, l0_.introduction AS introduction_13, l0_.contenu AS contenu_14, l0_.slug AS slug_15, l0_.banniere_titre AS banniere_titre_16, l0_.banniere_soustitre AS banniere_soustitre_17, l0_.banniere_color AS banniere_color_18, l0_.banniere_color_bouton AS banniere_color_bouton_19, l0_.banniere_text_bouton AS banniere_text_bouton_20, l0_.meta_title AS meta_title_21, l0_.meta_keyword AS meta_keyword_22, l0_.meta_description AS meta_description_23, l0_.image_name AS image_name_24, l0_.image_alt AS image_alt_25, l0_.image2_name AS image2_name_26, l0_.image_banniere_name AS image_banniere_name_27, l0_.image_banniere_illu_name AS image_banniere_illu_name_28 FROM listing l0_ WHERE l0_.visible = ? ORDER BY l0_.titre ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.image_updated_at AS image_updated_at_0,
  l0_.image2_updated_at AS image2_updated_at_1,
  l0_.image_bannniere_updated_at AS image_bannniere_updated_at_2,
  l0_.image_bannniere_illu_updated_at AS image_bannniere_illu_updated_at_3,
  l0_.id AS id_4,
  l0_.visible AS visible_5,
  l0_.archive AS archive_6,
  l0_.banniere AS banniere_7,
  l0_.created AS created_8,
  l0_.updated AS updated_9,
  l0_.color AS color_10,
  l0_.redirection AS redirection_11,
  l0_.titre AS titre_12,
  l0_.introduction AS introduction_13,
  l0_.contenu AS contenu_14,
  l0_.slug AS slug_15,
  l0_.banniere_titre AS banniere_titre_16,
  l0_.banniere_soustitre AS banniere_soustitre_17,
  l0_.banniere_color AS banniere_color_18,
  l0_.banniere_color_bouton AS banniere_color_bouton_19,
  l0_.banniere_text_bouton AS banniere_text_bouton_20,
  l0_.meta_title AS meta_title_21,
  l0_.meta_keyword AS meta_keyword_22,
  l0_.meta_description AS meta_description_23,
  l0_.image_name AS image_name_24,
  l0_.image_alt AS image_alt_25,
  l0_.image2_name AS image2_name_26,
  l0_.image_banniere_name AS image_banniere_name_27,
  l0_.image_banniere_illu_name AS image_banniere_illu_name_28
FROM
  listing l0_
WHERE
  l0_.visible = ?
ORDER BY
  l0_.titre ASC

SELECT l0_.image_updated_at AS image_updated_at_0, l0_.image2_updated_at AS image2_updated_at_1, l0_.image_bannniere_updated_at AS image_bannniere_updated_at_2, l0_.image_bannniere_illu_updated_at AS image_bannniere_illu_updated_at_3, l0_.id AS id_4, l0_.visible AS visible_5, l0_.archive AS archive_6, l0_.banniere AS banniere_7, l0_.created AS created_8, l0_.updated AS updated_9, l0_.color AS color_10, l0_.redirection AS redirection_11, l0_.titre AS titre_12, l0_.introduction AS introduction_13, l0_.contenu AS contenu_14, l0_.slug AS slug_15, l0_.banniere_titre AS banniere_titre_16, l0_.banniere_soustitre AS banniere_soustitre_17, l0_.banniere_color AS banniere_color_18, l0_.banniere_color_bouton AS banniere_color_bouton_19, l0_.banniere_text_bouton AS banniere_text_bouton_20, l0_.meta_title AS meta_title_21, l0_.meta_keyword AS meta_keyword_22, l0_.meta_description AS meta_description_23, l0_.image_name AS image_name_24, l0_.image_alt AS image_alt_25, l0_.image2_name AS image2_name_26, l0_.image_banniere_name AS image_banniere_name_27, l0_.image_banniere_illu_name AS image_banniere_illu_name_28 FROM listing l0_ WHERE l0_.visible = 1 ORDER BY l0_.titre ASC;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	Doctrine\DBAL\Connection->executeCacheQuery (line 1157)
3	Doctrine\DBAL\Connection->executeQuery (line 1084)
4	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
5	Doctrine\ORM\Query->_doExecute (line 330)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
7	Doctrine\ORM\AbstractQuery->execute (line 1167)
8	Doctrine\ORM\AbstractQuery->getResult (line 906)
9	App\Services\Returner->front (line 175)
10	App\Controller\Front\CatalogController->produit (line 171)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
15	require_once (line 32)
16	require_once (line 13)

6.71 ms
(3.04%)

SELECT m0_.id AS id_0, m0_.date_debut AS date_debut_1, m0_.date_fin AS date_fin_2, m0_.visible AS visible_3, m0_.hide_desktop AS hide_desktop_4, m0_.hide_tablet AS hide_tablet_5, m0_.hide_mobile AS hide_mobile_6, m0_.created AS created_7, m0_.updated AS updated_8, m0_.type AS type_9, m0_.class_name AS class_name_10, m0_.univer AS univer_11, m0_.nom AS nom_12, m0_.titre AS titre_13, m0_.soustitre AS soustitre_14, m0_.url AS url_15, m0_.color AS color_16, m0_.ancre AS ancre_17, m0_.contenu AS contenu_18, m0_.image_name AS image_name_19, m0_.image_updated_at AS image_updated_at_20, m0_.image_alt AS image_alt_21, m0_.ordre AS ordre_22, m0_.version AS version_23, m0_.page_id AS page_id_24, m0_.produit_id AS produit_id_25, m0_.module_page_id AS module_page_id_26, m0_.module_categorie_id AS module_categorie_id_27, m0_.module_produit_id AS module_produit_id_28, m0_.module_caracteristique_id AS module_caracteristique_id_29, m0_.module_attribut_id AS module_attribut_id_30 FROM module m0_ WHERE m0_.produit_id = ? AND m0_.version = ? ORDER BY m0_.ordre ASC, m0_.titre ASC

Parameters:

[
  1023
  "production"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.date_debut AS date_debut_1,
  m0_.date_fin AS date_fin_2,
  m0_.visible AS visible_3,
  m0_.hide_desktop AS hide_desktop_4,
  m0_.hide_tablet AS hide_tablet_5,
  m0_.hide_mobile AS hide_mobile_6,
  m0_.created AS created_7,
  m0_.updated AS updated_8,
  m0_.type AS type_9,
  m0_.class_name AS class_name_10,
  m0_.univer AS univer_11,
  m0_.nom AS nom_12,
  m0_.titre AS titre_13,
  m0_.soustitre AS soustitre_14,
  m0_.url AS url_15,
  m0_.color AS color_16,
  m0_.ancre AS ancre_17,
  m0_.contenu AS contenu_18,
  m0_.image_name AS image_name_19,
  m0_.image_updated_at AS image_updated_at_20,
  m0_.image_alt AS image_alt_21,
  m0_.ordre AS ordre_22,
  m0_.version AS version_23,
  m0_.page_id AS page_id_24,
  m0_.produit_id AS produit_id_25,
  m0_.module_page_id AS module_page_id_26,
  m0_.module_categorie_id AS module_categorie_id_27,
  m0_.module_produit_id AS module_produit_id_28,
  m0_.module_caracteristique_id AS module_caracteristique_id_29,
  m0_.module_attribut_id AS module_attribut_id_30
FROM
  module m0_
WHERE
  m0_.produit_id = ?
  AND m0_.version = ?
ORDER BY
  m0_.ordre ASC,
  m0_.titre ASC

SELECT m0_.id AS id_0, m0_.date_debut AS date_debut_1, m0_.date_fin AS date_fin_2, m0_.visible AS visible_3, m0_.hide_desktop AS hide_desktop_4, m0_.hide_tablet AS hide_tablet_5, m0_.hide_mobile AS hide_mobile_6, m0_.created AS created_7, m0_.updated AS updated_8, m0_.type AS type_9, m0_.class_name AS class_name_10, m0_.univer AS univer_11, m0_.nom AS nom_12, m0_.titre AS titre_13, m0_.soustitre AS soustitre_14, m0_.url AS url_15, m0_.color AS color_16, m0_.ancre AS ancre_17, m0_.contenu AS contenu_18, m0_.image_name AS image_name_19, m0_.image_updated_at AS image_updated_at_20, m0_.image_alt AS image_alt_21, m0_.ordre AS ordre_22, m0_.version AS version_23, m0_.page_id AS page_id_24, m0_.produit_id AS produit_id_25, m0_.module_page_id AS module_page_id_26, m0_.module_categorie_id AS module_categorie_id_27, m0_.module_produit_id AS module_produit_id_28, m0_.module_caracteristique_id AS module_caracteristique_id_29, m0_.module_attribut_id AS module_attribut_id_30 FROM module m0_ WHERE m0_.produit_id = 1023 AND m0_.version = 'production' ORDER BY m0_.ordre ASC, m0_.titre ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\ModuleRepository->produit (line 78)
7	App\Controller\Front\CatalogController->produit (line 270)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 13)

6.48 ms
(2.93%)

SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC

Parameters:

[
  1
  "2026-09-24 17:22:18"
  "2026-09-24 17:22:18"
  "2026-09-24 17:22:18"
  "2026-09-24 17:22:18"
  46
  63
  226
  223
  229
  220
  219
  218
  217
  175
  29
  174
  46
  190
  166
  185
  36
  20
  4
  163
  5
  162
  59
  3
  0.0
  46
  46
  46
  46
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.visible AS visible_1,
  p0_.page AS page_2,
  p0_.created AS created_3,
  p0_.updated AS updated_4,
  p0_.date_debut AS date_debut_5,
  p0_.date_fin AS date_fin_6,
  p0_.titre AS titre_7,
  p0_.slug AS slug_8,
  p0_.contenu AS contenu_9,
  p0_.image_name AS image_name_10,
  p0_.image_updated_at AS image_updated_at_11,
  p0_.typage AS typage_12,
  p0_.montant AS montant_13,
  p0_.montant_min AS montant_min_14,
  p0_.customer_order_count_min AS customer_order_count_min_15,
  p0_.customer_order_count_max AS customer_order_count_max_16,
  p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17,
  p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18,
  p0_.customer_account_age_days_min AS customer_account_age_days_min_19,
  p0_.customer_account_age_days_max AS customer_account_age_days_max_20,
  p0_.y_offert AS y_offert_21,
  p0_.meta_title AS meta_title_22,
  p0_.meta_keyword AS meta_keyword_23,
  p0_.meta_description AS meta_description_24,
  p0_.produit_offert_id AS produit_offert_id_25
FROM
  promotion p0_
  LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id
  LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id
  LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id
  LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id
WHERE
  p0_.visible = ?
  AND (
    (
      p0_.date_fin >= ?
      OR p0_.date_fin IS NULL
    )
  )
  AND (
    (
      p0_.date_debut <= ?
      OR p0_.date_debut IS NULL
    )
  )
  AND (
    (
      p0_.date_fin >= ?
      OR p0_.date_fin IS NULL
    )
  )
  AND (
    (
      p0_.date_debut <= ?
      OR p0_.date_debut IS NULL
    )
  )
  AND (
    (
      (p1_.id = ?)
      OR (
        c3_.id IN (
          ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
          ?, ?, ?, ?, ?, ?, ?
        )
        AND c3_.id IS NOT NULL
      )
    )
  )
  AND (
    (
      p0_.montant_min IS NULL
      OR p0_.montant_min <= ?
    )
  )
  AND (
    NOT (
      EXISTS (
        SELECT
          1 AS sclr_26
        FROM
          promotion p5_
          INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id
          INNER JOIN produit p6_ ON p6_.id = p7_.produit_id
        WHERE
          p5_.id = p0_.id
          AND (
            (
              p6_.id = ?
              OR p6_.id = ?
            )
          )
      )
    )
  )
  AND (
    NOT (
      EXISTS (
        SELECT
          1 AS sclr_27
        FROM
          promotion p8_
          INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id
          INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id
          INNER JOIN categorie_produit c11_ ON (
            c11_.categorie_id = c9_.id
            AND (
              c11_.produit_id = ?
              OR c11_.produit_id = ?
            )
          )
        WHERE
          p8_.id = p0_.id
      )
    )
  )
ORDER BY
  p0_.created DESC

SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = 1 AND ((p0_.date_fin >= '2026-09-24 17:22:18' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:22:18' OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= '2026-09-24 17:22:18' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:22:18' OR p0_.date_debut IS NULL)) AND (((p1_.id = 46) OR (c3_.id IN (63, 226, 223, 229, 220, 219, 218, 217, 175, 29, 174, 46, 190, 166, 185, 36, 20, 4, 163, 5, 162, 59, 3) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= 0)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = 46 OR p6_.id = 46))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = 46 OR c11_.produit_id = 46)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\PromotionRepository->findPromotions (line 199)
7	App\Services\PromoPriceCalculator->getProductPricePromo (line 96)
8	App\Twig\PanierTwigExtension->productPricePromo (line 33)
9	__TwigTemplate_f6eed0a3c82e03bc00fc1296a4a9bcd4->doDisplay (line 160)
10	Twig\Template->yield (line 447)
11	Twig\Template->display (line 402)
12	Twig\Template->render (line 417)
13	Twig\TemplateWrapper->render (line 53)
14	Twig\Extension\CoreExtension->include (line 1571)
15	__TwigTemplate_25b30196622ed5f8fc4a522c79a32bf7::doDisplay (line 126)
16	Twig\Template->yield (line 447)
17	Twig\Template->display (line 402)
18	Twig\Template->render (line 417)
19	Twig\TemplateWrapper->render (line 53)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\Front\SearchEditorialController->overlayPanel (line 25)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
28	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
29	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
30	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
31	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
32	__TwigTemplate_52459b8e677d0d99da267c994447f883->doDisplay (line 80)
33	Twig\Template->yield (line 447)
34	Twig\Template->display (line 402)
35	Twig\Template->render (line 417)
36	Twig\TemplateWrapper->render (line 53)
37	Twig\Extension\CoreExtension->include (line 1571)
38	__TwigTemplate_9799e282b193541f963e0bb5b2852170::doDisplay (line 186)
39	Twig\Template->yield (line 447)
40	Twig\Template->display (line 402)
41	Twig\Template->render (line 417)
42	Twig\TemplateWrapper->render (line 53)
43	Twig\Extension\CoreExtension->include (line 1571)
44	__TwigTemplate_4f76d49d661d868e852f25d00e21b62c::block_header (line 581)
45	Twig\Template->yieldBlock (line 479)
46	__TwigTemplate_4f76d49d661d868e852f25d00e21b62c->doDisplay (line 227)
47	Twig\Template->yield (line 447)
48	__TwigTemplate_fc5a1f42c5c9d4bf427f2ff176b7fb5d->doDisplay (line 104)
49	Twig\Template->yield (line 447)
50	Twig\Template->display (line 402)
51	Twig\Template->render (line 417)
52	Twig\TemplateWrapper->render (line 53)
53	Twig\Environment->render (line 333)
54	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
55	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
56	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
57	App\Controller\Front\CatalogController->produit (line 278)
58	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
59	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
60	Symfony\Component\HttpKernel\Kernel->handle (line 193)
61	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
62	require_once (line 32)
63	require_once (line 13)

6.46 ms
(2.93%)

SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC

Parameters:

[
  1
  "2026-09-24 17:22:18"
  "2026-09-24 17:22:18"
  "2026-09-24 17:22:18"
  "2026-09-24 17:22:18"
  9
  65
  226
  229
  220
  219
  218
  217
  216
  215
  214
  21
  58
  83
  19
  5
  2
  9
  59
  0.0
  9
  9
  9
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.visible AS visible_1,
  p0_.page AS page_2,
  p0_.created AS created_3,
  p0_.updated AS updated_4,
  p0_.date_debut AS date_debut_5,
  p0_.date_fin AS date_fin_6,
  p0_.titre AS titre_7,
  p0_.slug AS slug_8,
  p0_.contenu AS contenu_9,
  p0_.image_name AS image_name_10,
  p0_.image_updated_at AS image_updated_at_11,
  p0_.typage AS typage_12,
  p0_.montant AS montant_13,
  p0_.montant_min AS montant_min_14,
  p0_.customer_order_count_min AS customer_order_count_min_15,
  p0_.customer_order_count_max AS customer_order_count_max_16,
  p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17,
  p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18,
  p0_.customer_account_age_days_min AS customer_account_age_days_min_19,
  p0_.customer_account_age_days_max AS customer_account_age_days_max_20,
  p0_.y_offert AS y_offert_21,
  p0_.meta_title AS meta_title_22,
  p0_.meta_keyword AS meta_keyword_23,
  p0_.meta_description AS meta_description_24,
  p0_.produit_offert_id AS produit_offert_id_25
FROM
  promotion p0_
  LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id
  LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id
  LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id
  LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id
WHERE
  p0_.visible = ?
  AND (
    (
      p0_.date_fin >= ?
      OR p0_.date_fin IS NULL
    )
  )
  AND (
    (
      p0_.date_debut <= ?
      OR p0_.date_debut IS NULL
    )
  )
  AND (
    (
      p0_.date_fin >= ?
      OR p0_.date_fin IS NULL
    )
  )
  AND (
    (
      p0_.date_debut <= ?
      OR p0_.date_debut IS NULL
    )
  )
  AND (
    (
      (p1_.id = ?)
      OR (
        c3_.id IN (
          ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
          ?, ?
        )
        AND c3_.id IS NOT NULL
      )
    )
  )
  AND (
    (
      p0_.montant_min IS NULL
      OR p0_.montant_min <= ?
    )
  )
  AND (
    NOT (
      EXISTS (
        SELECT
          1 AS sclr_26
        FROM
          promotion p5_
          INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id
          INNER JOIN produit p6_ ON p6_.id = p7_.produit_id
        WHERE
          p5_.id = p0_.id
          AND (
            (
              p6_.id = ?
              OR p6_.id = ?
            )
          )
      )
    )
  )
  AND (
    NOT (
      EXISTS (
        SELECT
          1 AS sclr_27
        FROM
          promotion p8_
          INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id
          INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id
          INNER JOIN categorie_produit c11_ ON (
            c11_.categorie_id = c9_.id
            AND (
              c11_.produit_id = ?
              OR c11_.produit_id = ?
            )
          )
        WHERE
          p8_.id = p0_.id
      )
    )
  )
ORDER BY
  p0_.created DESC

SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = 1 AND ((p0_.date_fin >= '2026-09-24 17:22:18' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:22:18' OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= '2026-09-24 17:22:18' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:22:18' OR p0_.date_debut IS NULL)) AND (((p1_.id = 9) OR (c3_.id IN (65, 226, 229, 220, 219, 218, 217, 216, 215, 214, 21, 58, 83, 19, 5, 2, 9, 59) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= 0)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = 9 OR p6_.id = 9))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = 9 OR c11_.produit_id = 9)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\PromotionRepository->findPromotions (line 199)
7	App\Services\PromoPriceCalculator->getProductPricePromo (line 96)
8	App\Twig\PanierTwigExtension->productPricePromo (line 33)
9	__TwigTemplate_f6eed0a3c82e03bc00fc1296a4a9bcd4->doDisplay (line 160)
10	Twig\Template->yield (line 447)
11	Twig\Template->display (line 402)
12	Twig\Template->render (line 417)
13	Twig\TemplateWrapper->render (line 53)
14	Twig\Extension\CoreExtension->include (line 1571)
15	__TwigTemplate_25b30196622ed5f8fc4a522c79a32bf7::doDisplay (line 126)
16	Twig\Template->yield (line 447)
17	Twig\Template->display (line 402)
18	Twig\Template->render (line 417)
19	Twig\TemplateWrapper->render (line 53)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\Front\SearchEditorialController->overlayPanel (line 25)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
28	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
29	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
30	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
31	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
32	__TwigTemplate_52459b8e677d0d99da267c994447f883->doDisplay (line 80)
33	Twig\Template->yield (line 447)
34	Twig\Template->display (line 402)
35	Twig\Template->render (line 417)
36	Twig\TemplateWrapper->render (line 53)
37	Twig\Extension\CoreExtension->include (line 1571)
38	__TwigTemplate_9799e282b193541f963e0bb5b2852170::doDisplay (line 186)
39	Twig\Template->yield (line 447)
40	Twig\Template->display (line 402)
41	Twig\Template->render (line 417)
42	Twig\TemplateWrapper->render (line 53)
43	Twig\Extension\CoreExtension->include (line 1571)
44	__TwigTemplate_4f76d49d661d868e852f25d00e21b62c::block_header (line 581)
45	Twig\Template->yieldBlock (line 479)
46	__TwigTemplate_4f76d49d661d868e852f25d00e21b62c->doDisplay (line 227)
47	Twig\Template->yield (line 447)
48	__TwigTemplate_fc5a1f42c5c9d4bf427f2ff176b7fb5d->doDisplay (line 104)
49	Twig\Template->yield (line 447)
50	Twig\Template->display (line 402)
51	Twig\Template->render (line 417)
52	Twig\TemplateWrapper->render (line 53)
53	Twig\Environment->render (line 333)
54	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
55	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
56	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
57	App\Controller\Front\CatalogController->produit (line 278)
58	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
59	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
60	Symfony\Component\HttpKernel\Kernel->handle (line 193)
61	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
62	require_once (line 32)
63	require_once (line 13)

6.32 ms
(2.86%)

SELECT t0.id AS id_1, t0.variable AS variable_2, t0.valeur AS valeur_3, t0.format AS format_4, t0.commentaire AS commentaire_5 FROM parametre t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.variable AS variable_2,
  t0.valeur AS valeur_3,
  t0.format AS format_4,
  t0.commentaire AS commentaire_5
FROM
  parametre t0

SELECT t0.id AS id_1, t0.variable AS variable_2, t0.valeur AS valeur_3, t0.format AS format_4, t0.commentaire AS commentaire_5 FROM parametre t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	Doctrine\ORM\EntityRepository->findAll (line 206)
4	App\Services\ParametreService->warmCache (line 94)
5	App\Services\ParametreService->paramme (line 30)
6	App\Services\Returner->front (line 172)
7	App\Controller\Front\CatalogController->produit (line 171)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 13)

6.31 ms
(2.85%)

SELECT a0_.id AS id_0, a0_.created AS created_1, a0_.review_id AS review_id_2, a0_.review_product_id AS review_product_id_3, a0_.review_date AS review_date_4, a0_.nom AS nom_5, a0_.prenom AS prenom_6, a0_.note AS note_7, a0_.commentaire AS commentaire_8, a0_.reponses AS reponses_9, a0_.produit_id AS produit_id_10, a0_.commande_id AS commande_id_11 FROM avis_verifies a0_ WHERE a0_.produit_id IS NULL ORDER BY a0_.review_date DESC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.created AS created_1,
  a0_.review_id AS review_id_2,
  a0_.review_product_id AS review_product_id_3,
  a0_.review_date AS review_date_4,
  a0_.nom AS nom_5,
  a0_.prenom AS prenom_6,
  a0_.note AS note_7,
  a0_.commentaire AS commentaire_8,
  a0_.reponses AS reponses_9,
  a0_.produit_id AS produit_id_10,
  a0_.commande_id AS commande_id_11
FROM
  avis_verifies a0_
WHERE
  a0_.produit_id IS NULL
ORDER BY
  a0_.review_date DESC
LIMIT
  20

SELECT a0_.id AS id_0, a0_.created AS created_1, a0_.review_id AS review_id_2, a0_.review_product_id AS review_product_id_3, a0_.review_date AS review_date_4, a0_.nom AS nom_5, a0_.prenom AS prenom_6, a0_.note AS note_7, a0_.commentaire AS commentaire_8, a0_.reponses AS reponses_9, a0_.produit_id AS produit_id_10, a0_.commande_id AS commande_id_11 FROM avis_verifies a0_ WHERE a0_.produit_id IS NULL ORDER BY a0_.review_date DESC LIMIT 20;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	Doctrine\DBAL\Connection->executeCacheQuery (line 1157)
3	Doctrine\DBAL\Connection->executeQuery (line 1084)
4	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
5	Doctrine\ORM\Query->_doExecute (line 330)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
7	Doctrine\ORM\AbstractQuery->execute (line 1167)
8	Doctrine\ORM\AbstractQuery->getResult (line 906)
9	App\Services\Returner->front (line 178)
10	App\Controller\Front\CatalogController->produit (line 171)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
15	require_once (line 32)
16	require_once (line 13)

5.91 ms
(2.68%)

SELECT s0_.id AS id_0, s0_.frequent_search_entries AS frequent_search_entries_1, s1_.id AS id_2, s1_.position AS position_3, p2_.created AS created_4, p2_.updated AS updated_5, p2_.id AS id_6, p2_.visible AS visible_7, p2_.archive AS archive_8, p2_.exclude_columbus AS exclude_columbus_9, p2_.nouveau AS nouveau_10, p2_.precommande AS precommande_11, p2_.precommande_date AS precommande_date_12, p2_.offre_speciale AS offre_speciale_13, p2_.cadeau AS cadeau_14, p2_.goodie AS goodie_15, p2_.declinaison AS declinaison_16, p2_.declinaison_principale AS declinaison_principale_17, p2_.reference AS reference_18, p2_.titre AS titre_19, p2_.titre_brouillon AS titre_brouillon_20, p2_.contenu AS contenu_21, p2_.contenu_brouillon AS contenu_brouillon_22, p2_.contenu2 AS contenu2_23, p2_.contenu2_brouillon AS contenu2_brouillon_24, p2_.slug AS slug_25, p2_.prix_achat_ht AS prix_achat_ht_26, p2_.montantHT AS montantHT_27, p2_.montantTTC AS montantTTC_28, p2_.montantActuelTTC AS montantActuelTTC_29, p2_.tva AS tva_30, p2_.stock AS stock_31, p2_.alerte_stock AS alerte_stock_32, p2_.stock_emaplacement AS stock_emaplacement_33, p2_.poids AS poids_34, p2_.recherche_keyword AS recherche_keyword_35, p2_.recherche_slug AS recherche_slug_36, p2_.recherche_carac_attr_slug AS recherche_carac_attr_slug_37, p2_.produits_associes AS produits_associes_38, p2_.meta_title AS meta_title_39, p2_.meta_keyword AS meta_keyword_40, p2_.meta_description AS meta_description_41, p2_.note_avis AS note_avis_42, p2_.nb_avis AS nb_avis_43, p2_.image_panorama_name AS image_panorama_name_44, p2_.image_panorama_updated_at AS image_panorama_updated_at_45, p2_.image_portrait_name AS image_portrait_name_46, p2_.image_portrait_updated_at AS image_portrait_updated_at_47, p2_.image_name AS image_name_48, p2_.image_updated_at AS image_updated_at_49, p2_.image_alt AS image_alt_50, p2_.image_name_brouillon AS image_name_brouillon_51, p2_.image_updated_at_brouillon AS image_updated_at_brouillon_52, p2_.total_ca AS total_ca_53, p2_.count_commande AS count_commande_54, p2_.is_customizable AS is_customizable_55, s1_.search_editorial_id AS search_editorial_id_56, s1_.produit_id AS produit_id_57, p2_.parent_id AS parent_id_58 FROM search_editorial s0_ LEFT JOIN search_editorial_produit s1_ ON s0_.id = s1_.search_editorial_id LEFT JOIN produit p2_ ON s1_.produit_id = p2_.id WHERE s0_.id = ? ORDER BY s1_.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.frequent_search_entries AS frequent_search_entries_1,
  s1_.id AS id_2,
  s1_.position AS position_3,
  p2_.created AS created_4,
  p2_.updated AS updated_5,
  p2_.id AS id_6,
  p2_.visible AS visible_7,
  p2_.archive AS archive_8,
  p2_.exclude_columbus AS exclude_columbus_9,
  p2_.nouveau AS nouveau_10,
  p2_.precommande AS precommande_11,
  p2_.precommande_date AS precommande_date_12,
  p2_.offre_speciale AS offre_speciale_13,
  p2_.cadeau AS cadeau_14,
  p2_.goodie AS goodie_15,
  p2_.declinaison AS declinaison_16,
  p2_.declinaison_principale AS declinaison_principale_17,
  p2_.reference AS reference_18,
  p2_.titre AS titre_19,
  p2_.titre_brouillon AS titre_brouillon_20,
  p2_.contenu AS contenu_21,
  p2_.contenu_brouillon AS contenu_brouillon_22,
  p2_.contenu2 AS contenu2_23,
  p2_.contenu2_brouillon AS contenu2_brouillon_24,
  p2_.slug AS slug_25,
  p2_.prix_achat_ht AS prix_achat_ht_26,
  p2_.montantHT AS montantHT_27,
  p2_.montantTTC AS montantTTC_28,
  p2_.montantActuelTTC AS montantActuelTTC_29,
  p2_.tva AS tva_30,
  p2_.stock AS stock_31,
  p2_.alerte_stock AS alerte_stock_32,
  p2_.stock_emaplacement AS stock_emaplacement_33,
  p2_.poids AS poids_34,
  p2_.recherche_keyword AS recherche_keyword_35,
  p2_.recherche_slug AS recherche_slug_36,
  p2_.recherche_carac_attr_slug AS recherche_carac_attr_slug_37,
  p2_.produits_associes AS produits_associes_38,
  p2_.meta_title AS meta_title_39,
  p2_.meta_keyword AS meta_keyword_40,
  p2_.meta_description AS meta_description_41,
  p2_.note_avis AS note_avis_42,
  p2_.nb_avis AS nb_avis_43,
  p2_.image_panorama_name AS image_panorama_name_44,
  p2_.image_panorama_updated_at AS image_panorama_updated_at_45,
  p2_.image_portrait_name AS image_portrait_name_46,
  p2_.image_portrait_updated_at AS image_portrait_updated_at_47,
  p2_.image_name AS image_name_48,
  p2_.image_updated_at AS image_updated_at_49,
  p2_.image_alt AS image_alt_50,
  p2_.image_name_brouillon AS image_name_brouillon_51,
  p2_.image_updated_at_brouillon AS image_updated_at_brouillon_52,
  p2_.total_ca AS total_ca_53,
  p2_.count_commande AS count_commande_54,
  p2_.is_customizable AS is_customizable_55,
  s1_.search_editorial_id AS search_editorial_id_56,
  s1_.produit_id AS produit_id_57,
  p2_.parent_id AS parent_id_58
FROM
  search_editorial s0_
  LEFT JOIN search_editorial_produit s1_ ON s0_.id = s1_.search_editorial_id
  LEFT JOIN produit p2_ ON s1_.produit_id = p2_.id
WHERE
  s0_.id = ?
ORDER BY
  s1_.position ASC

SELECT s0_.id AS id_0, s0_.frequent_search_entries AS frequent_search_entries_1, s1_.id AS id_2, s1_.position AS position_3, p2_.created AS created_4, p2_.updated AS updated_5, p2_.id AS id_6, p2_.visible AS visible_7, p2_.archive AS archive_8, p2_.exclude_columbus AS exclude_columbus_9, p2_.nouveau AS nouveau_10, p2_.precommande AS precommande_11, p2_.precommande_date AS precommande_date_12, p2_.offre_speciale AS offre_speciale_13, p2_.cadeau AS cadeau_14, p2_.goodie AS goodie_15, p2_.declinaison AS declinaison_16, p2_.declinaison_principale AS declinaison_principale_17, p2_.reference AS reference_18, p2_.titre AS titre_19, p2_.titre_brouillon AS titre_brouillon_20, p2_.contenu AS contenu_21, p2_.contenu_brouillon AS contenu_brouillon_22, p2_.contenu2 AS contenu2_23, p2_.contenu2_brouillon AS contenu2_brouillon_24, p2_.slug AS slug_25, p2_.prix_achat_ht AS prix_achat_ht_26, p2_.montantHT AS montantHT_27, p2_.montantTTC AS montantTTC_28, p2_.montantActuelTTC AS montantActuelTTC_29, p2_.tva AS tva_30, p2_.stock AS stock_31, p2_.alerte_stock AS alerte_stock_32, p2_.stock_emaplacement AS stock_emaplacement_33, p2_.poids AS poids_34, p2_.recherche_keyword AS recherche_keyword_35, p2_.recherche_slug AS recherche_slug_36, p2_.recherche_carac_attr_slug AS recherche_carac_attr_slug_37, p2_.produits_associes AS produits_associes_38, p2_.meta_title AS meta_title_39, p2_.meta_keyword AS meta_keyword_40, p2_.meta_description AS meta_description_41, p2_.note_avis AS note_avis_42, p2_.nb_avis AS nb_avis_43, p2_.image_panorama_name AS image_panorama_name_44, p2_.image_panorama_updated_at AS image_panorama_updated_at_45, p2_.image_portrait_name AS image_portrait_name_46, p2_.image_portrait_updated_at AS image_portrait_updated_at_47, p2_.image_name AS image_name_48, p2_.image_updated_at AS image_updated_at_49, p2_.image_alt AS image_alt_50, p2_.image_name_brouillon AS image_name_brouillon_51, p2_.image_updated_at_brouillon AS image_updated_at_brouillon_52, p2_.total_ca AS total_ca_53, p2_.count_commande AS count_commande_54, p2_.is_customizable AS is_customizable_55, s1_.search_editorial_id AS search_editorial_id_56, s1_.produit_id AS produit_id_57, p2_.parent_id AS parent_id_58 FROM search_editorial s0_ LEFT JOIN search_editorial_produit s1_ ON s0_.id = s1_.search_editorial_id LEFT JOIN produit p2_ ON s1_.produit_id = p2_.id WHERE s0_.id = 1 ORDER BY s1_.position ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 958)
6	App\Repository\SearchEditorialRepository->findSingletonWithHighlightedProducts (line 36)
7	App\Search\SearchEditorialService->getSingleton (line 17)
8	App\Search\SearchEditorialService->getEditorialData (line 25)
9	App\Controller\Front\SearchEditorialController->overlayPanel (line 20)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
13	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
14	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
15	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
16	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
17	__TwigTemplate_52459b8e677d0d99da267c994447f883->doDisplay (line 80)
18	Twig\Template->yield (line 447)
19	Twig\Template->display (line 402)
20	Twig\Template->render (line 417)
21	Twig\TemplateWrapper->render (line 53)
22	Twig\Extension\CoreExtension->include (line 1571)
23	__TwigTemplate_9799e282b193541f963e0bb5b2852170::doDisplay (line 186)
24	Twig\Template->yield (line 447)
25	Twig\Template->display (line 402)
26	Twig\Template->render (line 417)
27	Twig\TemplateWrapper->render (line 53)
28	Twig\Extension\CoreExtension->include (line 1571)
29	__TwigTemplate_4f76d49d661d868e852f25d00e21b62c::block_header (line 581)
30	Twig\Template->yieldBlock (line 479)
31	__TwigTemplate_4f76d49d661d868e852f25d00e21b62c->doDisplay (line 227)
32	Twig\Template->yield (line 447)
33	__TwigTemplate_fc5a1f42c5c9d4bf427f2ff176b7fb5d->doDisplay (line 104)
34	Twig\Template->yield (line 447)
35	Twig\Template->display (line 402)
36	Twig\Template->render (line 417)
37	Twig\TemplateWrapper->render (line 53)
38	Twig\Environment->render (line 333)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
42	App\Controller\Front\CatalogController->produit (line 278)
43	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
44	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
45	Symfony\Component\HttpKernel\Kernel->handle (line 193)
46	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
47	require_once (line 32)
48	require_once (line 13)

4.77 ms
(2.16%)

SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = ?

Parameters:

[
  1023
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.created AS created_1,
  t0.updated AS updated_2,
  t0.id AS id_3,
  t0.visible AS visible_4,
  t0.archive AS archive_5,
  t0.exclude_columbus AS exclude_columbus_6,
  t0.nouveau AS nouveau_7,
  t0.precommande AS precommande_8,
  t0.precommande_date AS precommande_date_9,
  t0.offre_speciale AS offre_speciale_10,
  t0.cadeau AS cadeau_11,
  t0.goodie AS goodie_12,
  t0.declinaison AS declinaison_13,
  t0.declinaison_principale AS declinaison_principale_14,
  t0.reference AS reference_15,
  t0.titre AS titre_16,
  t0.titre_brouillon AS titre_brouillon_17,
  t0.contenu AS contenu_18,
  t0.contenu_brouillon AS contenu_brouillon_19,
  t0.contenu2 AS contenu2_20,
  t0.contenu2_brouillon AS contenu2_brouillon_21,
  t0.slug AS slug_22,
  t0.prix_achat_ht AS prix_achat_ht_23,
  t0.montantHT AS montantHT_24,
  t0.montantTTC AS montantTTC_25,
  t0.montantActuelTTC AS montantActuelTTC_26,
  t0.tva AS tva_27,
  t0.stock AS stock_28,
  t0.alerte_stock AS alerte_stock_29,
  t0.stock_emaplacement AS stock_emaplacement_30,
  t0.poids AS poids_31,
  t0.recherche_keyword AS recherche_keyword_32,
  t0.recherche_slug AS recherche_slug_33,
  t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34,
  t0.produits_associes AS produits_associes_35,
  t0.meta_title AS meta_title_36,
  t0.meta_keyword AS meta_keyword_37,
  t0.meta_description AS meta_description_38,
  t0.note_avis AS note_avis_39,
  t0.nb_avis AS nb_avis_40,
  t0.image_panorama_name AS image_panorama_name_41,
  t0.image_panorama_updated_at AS image_panorama_updated_at_42,
  t0.image_portrait_name AS image_portrait_name_43,
  t0.image_portrait_updated_at AS image_portrait_updated_at_44,
  t0.image_name AS image_name_45,
  t0.image_updated_at AS image_updated_at_46,
  t0.image_alt AS image_alt_47,
  t0.image_name_brouillon AS image_name_brouillon_48,
  t0.image_updated_at_brouillon AS image_updated_at_brouillon_49,
  t0.total_ca AS total_ca_50,
  t0.count_commande AS count_commande_51,
  t0.is_customizable AS is_customizable_52,
  t0.parent_id AS parent_id_53
FROM
  produit t0
WHERE
  t0.id = ?

SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id = 1023;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Entity\Produit::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Produit->__get (line 153)
7	App\Entity\Produit->getProperCategories (line 667)
8	App\Entity\Produit->getMainCategorie (line 706)
9	App\Controller\Front\CatalogController->produit (line 238)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 13)

4.43 ms
(2.00%)

SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.groupe AS groupe_3, t0.ordre AS ordre_4, t0.image_name AS image_name_5, t0.image_updated_at AS image_updated_at_6, t0.attribut_id AS attribut_id_7 FROM attribut_valeur t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.valeur AS valeur_2,
  t0.groupe AS groupe_3,
  t0.ordre AS ordre_4,
  t0.image_name AS image_name_5,
  t0.image_updated_at AS image_updated_at_6,
  t0.attribut_id AS attribut_id_7
FROM
  attribut_valeur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.groupe AS groupe_3, t0.ordre AS ordre_4, t0.image_name AS image_name_5, t0.image_updated_at AS image_updated_at_6, t0.attribut_id AS attribut_id_7 FROM attribut_valeur t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Entity\AttributValeur::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\AttributValeur->__get (line 153)
7	App\Entity\AttributValeur->getValeur (line 89)
8	Twig\Extension\CoreExtension->getAttribute (line 1992)
9	__TwigTemplate_f6eed0a3c82e03bc00fc1296a4a9bcd4::doDisplay (line 327)
10	Twig\Template->yield (line 447)
11	Twig\Template->display (line 402)
12	Twig\Template->render (line 417)
13	Twig\TemplateWrapper->render (line 53)
14	Twig\Extension\CoreExtension->include (line 1571)
15	__TwigTemplate_25b30196622ed5f8fc4a522c79a32bf7::doDisplay (line 126)
16	Twig\Template->yield (line 447)
17	Twig\Template->display (line 402)
18	Twig\Template->render (line 417)
19	Twig\TemplateWrapper->render (line 53)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\Front\SearchEditorialController->overlayPanel (line 25)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
28	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
29	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
30	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
31	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
32	__TwigTemplate_52459b8e677d0d99da267c994447f883->doDisplay (line 80)
33	Twig\Template->yield (line 447)
34	Twig\Template->display (line 402)
35	Twig\Template->render (line 417)
36	Twig\TemplateWrapper->render (line 53)
37	Twig\Extension\CoreExtension->include (line 1571)
38	__TwigTemplate_9799e282b193541f963e0bb5b2852170::doDisplay (line 186)
39	Twig\Template->yield (line 447)
40	Twig\Template->display (line 402)
41	Twig\Template->render (line 417)
42	Twig\TemplateWrapper->render (line 53)
43	Twig\Extension\CoreExtension->include (line 1571)
44	__TwigTemplate_4f76d49d661d868e852f25d00e21b62c::block_header (line 581)
45	Twig\Template->yieldBlock (line 479)
46	__TwigTemplate_4f76d49d661d868e852f25d00e21b62c->doDisplay (line 227)
47	Twig\Template->yield (line 447)
48	__TwigTemplate_fc5a1f42c5c9d4bf427f2ff176b7fb5d->doDisplay (line 104)
49	Twig\Template->yield (line 447)
50	Twig\Template->display (line 402)
51	Twig\Template->render (line 417)
52	Twig\TemplateWrapper->render (line 53)
53	Twig\Environment->render (line 333)
54	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
55	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
56	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
57	App\Controller\Front\CatalogController->produit (line 278)
58	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
59	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
60	Symfony\Component\HttpKernel\Kernel->handle (line 193)
61	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
62	require_once (line 32)
63	require_once (line 13)

4.12 ms
(1.86%)

SELECT p0_.id AS id_0, p0_.created AS created_1, p0_.visible AS visible_2, p0_.newsletter AS newsletter_3, p0_.date_debut AS date_debut_4, p0_.date_fin AS date_fin_5, p0_.url AS url_6, p0_.titre AS titre_7, p0_.contenu AS contenu_8 FROM popup p0_ WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) ORDER BY p0_.date_debut DESC LIMIT 1

Parameters:

[
  1
  "2026-09-24 17:22:18"
  "2026-09-24 17:22:18"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.created AS created_1,
  p0_.visible AS visible_2,
  p0_.newsletter AS newsletter_3,
  p0_.date_debut AS date_debut_4,
  p0_.date_fin AS date_fin_5,
  p0_.url AS url_6,
  p0_.titre AS titre_7,
  p0_.contenu AS contenu_8
FROM
  popup p0_
WHERE
  p0_.visible = ?
  AND (
    (
      p0_.date_fin >= ?
      OR p0_.date_fin IS NULL
    )
  )
  AND (
    (
      p0_.date_debut <= ?
      OR p0_.date_debut IS NULL
    )
  )
ORDER BY
  p0_.date_debut DESC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.created AS created_1, p0_.visible AS visible_2, p0_.newsletter AS newsletter_3, p0_.date_debut AS date_debut_4, p0_.date_fin AS date_fin_5, p0_.url AS url_6, p0_.titre AS titre_7, p0_.contenu AS contenu_8 FROM popup p0_ WHERE p0_.visible = 1 AND ((p0_.date_fin >= '2026-09-24 17:22:18' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:22:18' OR p0_.date_debut IS NULL)) ORDER BY p0_.date_debut DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 958)
6	App\Repository\PopupRepository->findOne (line 53)
7	App\Services\Returner->front (line 186)
8	App\Controller\Front\CatalogController->produit (line 171)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 13)

3.73 ms
(1.69%)

SELECT p0_.id AS id_0, p0_.ordre AS ordre_1, p0_.ordre_general AS ordre_general_2, p0_.ordre_brouillon AS ordre_brouillon_3, p0_.visible AS visible_4, p0_.is_page AS is_page_5, p0_.created AS created_6, p0_.updated AS updated_7, p0_.published AS published_8, p0_.template AS template_9, p0_.titre AS titre_10, p0_.titre_brouillon AS titre_brouillon_11, p0_.slug AS slug_12, p0_.body_id AS body_id_13, p0_.meta_title AS meta_title_14, p0_.meta_keyword AS meta_keyword_15, p0_.meta_description AS meta_description_16, p0_.introduction AS introduction_17, p0_.contenu AS contenu_18, p0_.type AS type_19, p0_.url AS url_20, p0_.url_brouillon AS url_brouillon_21, p0_.image_name AS image_name_22, p0_.image_updated_at AS image_updated_at_23, p0_.image_name_brouillon AS image_name_brouillon_24, p0_.image_updated_at_brouillon AS image_updated_at_brouillon_25, p0_.parent_id AS parent_id_26 FROM page p0_ WHERE p0_.visible = ? AND p0_.type = ? ORDER BY p0_.titre ASC

Parameters:

[
  1
  "page"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.ordre AS ordre_1,
  p0_.ordre_general AS ordre_general_2,
  p0_.ordre_brouillon AS ordre_brouillon_3,
  p0_.visible AS visible_4,
  p0_.is_page AS is_page_5,
  p0_.created AS created_6,
  p0_.updated AS updated_7,
  p0_.published AS published_8,
  p0_.template AS template_9,
  p0_.titre AS titre_10,
  p0_.titre_brouillon AS titre_brouillon_11,
  p0_.slug AS slug_12,
  p0_.body_id AS body_id_13,
  p0_.meta_title AS meta_title_14,
  p0_.meta_keyword AS meta_keyword_15,
  p0_.meta_description AS meta_description_16,
  p0_.introduction AS introduction_17,
  p0_.contenu AS contenu_18,
  p0_.type AS type_19,
  p0_.url AS url_20,
  p0_.url_brouillon AS url_brouillon_21,
  p0_.image_name AS image_name_22,
  p0_.image_updated_at AS image_updated_at_23,
  p0_.image_name_brouillon AS image_name_brouillon_24,
  p0_.image_updated_at_brouillon AS image_updated_at_brouillon_25,
  p0_.parent_id AS parent_id_26
FROM
  page p0_
WHERE
  p0_.visible = ?
  AND p0_.type = ?
ORDER BY
  p0_.titre ASC

SELECT p0_.id AS id_0, p0_.ordre AS ordre_1, p0_.ordre_general AS ordre_general_2, p0_.ordre_brouillon AS ordre_brouillon_3, p0_.visible AS visible_4, p0_.is_page AS is_page_5, p0_.created AS created_6, p0_.updated AS updated_7, p0_.published AS published_8, p0_.template AS template_9, p0_.titre AS titre_10, p0_.titre_brouillon AS titre_brouillon_11, p0_.slug AS slug_12, p0_.body_id AS body_id_13, p0_.meta_title AS meta_title_14, p0_.meta_keyword AS meta_keyword_15, p0_.meta_description AS meta_description_16, p0_.introduction AS introduction_17, p0_.contenu AS contenu_18, p0_.type AS type_19, p0_.url AS url_20, p0_.url_brouillon AS url_brouillon_21, p0_.image_name AS image_name_22, p0_.image_updated_at AS image_updated_at_23, p0_.image_name_brouillon AS image_name_brouillon_24, p0_.image_updated_at_brouillon AS image_updated_at_brouillon_25, p0_.parent_id AS parent_id_26 FROM page p0_ WHERE p0_.visible = 1 AND p0_.type = 'page' ORDER BY p0_.titre ASC;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	Doctrine\DBAL\Connection->executeCacheQuery (line 1157)
3	Doctrine\DBAL\Connection->executeQuery (line 1084)
4	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
5	Doctrine\ORM\Query->_doExecute (line 330)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
7	Doctrine\ORM\AbstractQuery->execute (line 1167)
8	Doctrine\ORM\AbstractQuery->getResult (line 906)
9	App\Services\Returner->front (line 156)
10	App\Controller\Front\CatalogController->produit (line 171)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
15	require_once (line 32)
16	require_once (line 13)

3.48 ms
(1.57%)

SELECT t0.id AS id_1, t0.variable AS variable_2, t0.valeur AS valeur_3, t0.format AS format_4, t0.commentaire AS commentaire_5 FROM parametre t0 WHERE t0.variable = ? LIMIT 1

Parameters:

[
  "twitter-compte"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.variable AS variable_2,
  t0.valeur AS valeur_3,
  t0.format AS format_4,
  t0.commentaire AS commentaire_5
FROM
  parametre t0
WHERE
  t0.variable = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.variable AS variable_2, t0.valeur AS valeur_3, t0.format AS format_4, t0.commentaire AS commentaire_5 FROM parametre t0 WHERE t0.variable = 'twitter-compte' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Services\ParametreService->paramme (line 38)
4	App\Twig\ParametreTwigExtension->paramme (line 24)
5	__TwigTemplate_fc5a1f42c5c9d4bf427f2ff176b7fb5d->block_addHeader (line 153)
6	Twig\Template->yieldBlock (line 479)
7	__TwigTemplate_4f76d49d661d868e852f25d00e21b62c->doDisplay (line 202)
8	Twig\Template->yield (line 447)
9	__TwigTemplate_fc5a1f42c5c9d4bf427f2ff176b7fb5d->doDisplay (line 104)
10	Twig\Template->yield (line 447)
11	Twig\Template->display (line 402)
12	Twig\Template->render (line 417)
13	Twig\TemplateWrapper->render (line 53)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
18	App\Controller\Front\CatalogController->produit (line 278)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
23	require_once (line 32)
24	require_once (line 13)

3.24 ms
(1.47%)

SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND (((p1_.id = ?) OR (c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= ?)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = ? OR p6_.id = ?))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = ? OR c11_.produit_id = ?)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC

Parameters:

[
  1
  "2026-09-24 17:22:18"
  "2026-09-24 17:22:18"
  "2026-09-24 17:22:18"
  "2026-09-24 17:22:18"
  30
  64
  226
  215
  216
  217
  218
  219
  220
  229
  181
  185
  26
  190
  175
  174
  46
  37
  19
  4
  5
  59
  0.0
  30
  30
  30
  30
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.visible AS visible_1,
  p0_.page AS page_2,
  p0_.created AS created_3,
  p0_.updated AS updated_4,
  p0_.date_debut AS date_debut_5,
  p0_.date_fin AS date_fin_6,
  p0_.titre AS titre_7,
  p0_.slug AS slug_8,
  p0_.contenu AS contenu_9,
  p0_.image_name AS image_name_10,
  p0_.image_updated_at AS image_updated_at_11,
  p0_.typage AS typage_12,
  p0_.montant AS montant_13,
  p0_.montant_min AS montant_min_14,
  p0_.customer_order_count_min AS customer_order_count_min_15,
  p0_.customer_order_count_max AS customer_order_count_max_16,
  p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17,
  p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18,
  p0_.customer_account_age_days_min AS customer_account_age_days_min_19,
  p0_.customer_account_age_days_max AS customer_account_age_days_max_20,
  p0_.y_offert AS y_offert_21,
  p0_.meta_title AS meta_title_22,
  p0_.meta_keyword AS meta_keyword_23,
  p0_.meta_description AS meta_description_24,
  p0_.produit_offert_id AS produit_offert_id_25
FROM
  promotion p0_
  LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id
  LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id
  LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id
  LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id
WHERE
  p0_.visible = ?
  AND (
    (
      p0_.date_fin >= ?
      OR p0_.date_fin IS NULL
    )
  )
  AND (
    (
      p0_.date_debut <= ?
      OR p0_.date_debut IS NULL
    )
  )
  AND (
    (
      p0_.date_fin >= ?
      OR p0_.date_fin IS NULL
    )
  )
  AND (
    (
      p0_.date_debut <= ?
      OR p0_.date_debut IS NULL
    )
  )
  AND (
    (
      (p1_.id = ?)
      OR (
        c3_.id IN (
          ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
          ?, ?, ?, ?, ?
        )
        AND c3_.id IS NOT NULL
      )
    )
  )
  AND (
    (
      p0_.montant_min IS NULL
      OR p0_.montant_min <= ?
    )
  )
  AND (
    NOT (
      EXISTS (
        SELECT
          1 AS sclr_26
        FROM
          promotion p5_
          INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id
          INNER JOIN produit p6_ ON p6_.id = p7_.produit_id
        WHERE
          p5_.id = p0_.id
          AND (
            (
              p6_.id = ?
              OR p6_.id = ?
            )
          )
      )
    )
  )
  AND (
    NOT (
      EXISTS (
        SELECT
          1 AS sclr_27
        FROM
          promotion p8_
          INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id
          INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id
          INNER JOIN categorie_produit c11_ ON (
            c11_.categorie_id = c9_.id
            AND (
              c11_.produit_id = ?
              OR c11_.produit_id = ?
            )
          )
        WHERE
          p8_.id = p0_.id
      )
    )
  )
ORDER BY
  p0_.created DESC

SELECT DISTINCT p0_.id AS id_0, p0_.visible AS visible_1, p0_.page AS page_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.titre AS titre_7, p0_.slug AS slug_8, p0_.contenu AS contenu_9, p0_.image_name AS image_name_10, p0_.image_updated_at AS image_updated_at_11, p0_.typage AS typage_12, p0_.montant AS montant_13, p0_.montant_min AS montant_min_14, p0_.customer_order_count_min AS customer_order_count_min_15, p0_.customer_order_count_max AS customer_order_count_max_16, p0_.customer_lifetime_spent_min AS customer_lifetime_spent_min_17, p0_.customer_lifetime_spent_max AS customer_lifetime_spent_max_18, p0_.customer_account_age_days_min AS customer_account_age_days_min_19, p0_.customer_account_age_days_max AS customer_account_age_days_max_20, p0_.y_offert AS y_offert_21, p0_.meta_title AS meta_title_22, p0_.meta_keyword AS meta_keyword_23, p0_.meta_description AS meta_description_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_produit p2_ ON p0_.id = p2_.promotion_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id LEFT JOIN promotion_categorie p4_ ON p0_.id = p4_.promotion_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id WHERE p0_.visible = 1 AND ((p0_.date_fin >= '2026-09-24 17:22:18' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:22:18' OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= '2026-09-24 17:22:18' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:22:18' OR p0_.date_debut IS NULL)) AND (((p1_.id = 30) OR (c3_.id IN (64, 226, 215, 216, 217, 218, 219, 220, 229, 181, 185, 26, 190, 175, 174, 46, 37, 19, 4, 5, 59) AND c3_.id IS NOT NULL))) AND ((p0_.montant_min IS NULL OR p0_.montant_min <= 0)) AND (NOT (EXISTS (SELECT 1 AS sclr_26 FROM promotion p5_ INNER JOIN promotion_produit_exclude p7_ ON p5_.id = p7_.promotion_id INNER JOIN produit p6_ ON p6_.id = p7_.produit_id WHERE p5_.id = p0_.id AND ((p6_.id = 30 OR p6_.id = 30))))) AND (NOT (EXISTS (SELECT 1 AS sclr_27 FROM promotion p8_ INNER JOIN promotion_categorie_exclude p10_ ON p8_.id = p10_.promotion_id INNER JOIN categorie c9_ ON c9_.id = p10_.categorie_id INNER JOIN categorie_produit c11_ ON (c11_.categorie_id = c9_.id AND (c11_.produit_id = 30 OR c11_.produit_id = 30)) WHERE p8_.id = p0_.id))) ORDER BY p0_.created DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\PromotionRepository->findPromotions (line 199)
7	App\Services\PromoPriceCalculator->getProductPricePromo (line 96)
8	App\Twig\PanierTwigExtension->productPricePromo (line 33)
9	__TwigTemplate_f6eed0a3c82e03bc00fc1296a4a9bcd4->doDisplay (line 160)
10	Twig\Template->yield (line 447)
11	Twig\Template->display (line 402)
12	Twig\Template->render (line 417)
13	Twig\TemplateWrapper->render (line 53)
14	Twig\Extension\CoreExtension->include (line 1571)
15	__TwigTemplate_25b30196622ed5f8fc4a522c79a32bf7::doDisplay (line 126)
16	Twig\Template->yield (line 447)
17	Twig\Template->display (line 402)
18	Twig\Template->render (line 417)
19	Twig\TemplateWrapper->render (line 53)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\Front\SearchEditorialController->overlayPanel (line 25)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
28	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
29	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
30	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
31	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
32	__TwigTemplate_52459b8e677d0d99da267c994447f883->doDisplay (line 80)
33	Twig\Template->yield (line 447)
34	Twig\Template->display (line 402)
35	Twig\Template->render (line 417)
36	Twig\TemplateWrapper->render (line 53)
37	Twig\Extension\CoreExtension->include (line 1571)
38	__TwigTemplate_9799e282b193541f963e0bb5b2852170::doDisplay (line 186)
39	Twig\Template->yield (line 447)
40	Twig\Template->display (line 402)
41	Twig\Template->render (line 417)
42	Twig\TemplateWrapper->render (line 53)
43	Twig\Extension\CoreExtension->include (line 1571)
44	__TwigTemplate_4f76d49d661d868e852f25d00e21b62c::block_header (line 581)
45	Twig\Template->yieldBlock (line 479)
46	__TwigTemplate_4f76d49d661d868e852f25d00e21b62c->doDisplay (line 227)
47	Twig\Template->yield (line 447)
48	__TwigTemplate_fc5a1f42c5c9d4bf427f2ff176b7fb5d->doDisplay (line 104)
49	Twig\Template->yield (line 447)
50	Twig\Template->display (line 402)
51	Twig\Template->render (line 417)
52	Twig\TemplateWrapper->render (line 53)
53	Twig\Environment->render (line 333)
54	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
55	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
56	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
57	App\Controller\Front\CatalogController->produit (line 278)
58	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
59	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
60	Symfony\Component\HttpKernel\Kernel->handle (line 193)
61	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
62	require_once (line 32)
63	require_once (line 13)

2.98 ms
(1.35%)

SELECT p0_.created AS created_0, p0_.updated AS updated_1, p0_.id AS id_2, p0_.visible AS visible_3, p0_.archive AS archive_4, p0_.exclude_columbus AS exclude_columbus_5, p0_.nouveau AS nouveau_6, p0_.precommande AS precommande_7, p0_.precommande_date AS precommande_date_8, p0_.offre_speciale AS offre_speciale_9, p0_.cadeau AS cadeau_10, p0_.goodie AS goodie_11, p0_.declinaison AS declinaison_12, p0_.declinaison_principale AS declinaison_principale_13, p0_.reference AS reference_14, p0_.titre AS titre_15, p0_.titre_brouillon AS titre_brouillon_16, p0_.contenu AS contenu_17, p0_.contenu_brouillon AS contenu_brouillon_18, p0_.contenu2 AS contenu2_19, p0_.contenu2_brouillon AS contenu2_brouillon_20, p0_.slug AS slug_21, p0_.prix_achat_ht AS prix_achat_ht_22, p0_.montantHT AS montantHT_23, p0_.montantTTC AS montantTTC_24, p0_.montantActuelTTC AS montantActuelTTC_25, p0_.tva AS tva_26, p0_.stock AS stock_27, p0_.alerte_stock AS alerte_stock_28, p0_.stock_emaplacement AS stock_emaplacement_29, p0_.poids AS poids_30, p0_.recherche_keyword AS recherche_keyword_31, p0_.recherche_slug AS recherche_slug_32, p0_.recherche_carac_attr_slug AS recherche_carac_attr_slug_33, p0_.produits_associes AS produits_associes_34, p0_.meta_title AS meta_title_35, p0_.meta_keyword AS meta_keyword_36, p0_.meta_description AS meta_description_37, p0_.note_avis AS note_avis_38, p0_.nb_avis AS nb_avis_39, p0_.image_panorama_name AS image_panorama_name_40, p0_.image_panorama_updated_at AS image_panorama_updated_at_41, p0_.image_portrait_name AS image_portrait_name_42, p0_.image_portrait_updated_at AS image_portrait_updated_at_43, p0_.image_name AS image_name_44, p0_.image_updated_at AS image_updated_at_45, p0_.image_alt AS image_alt_46, p0_.image_name_brouillon AS image_name_brouillon_47, p0_.image_updated_at_brouillon AS image_updated_at_brouillon_48, p0_.total_ca AS total_ca_49, p0_.count_commande AS count_commande_50, p0_.is_customizable AS is_customizable_51, p0_.parent_id AS parent_id_52 FROM produit p0_ WHERE p0_.slug = ?

Parameters:

[
  "doudou-mouchoir-mon-petit-ourson-marron-10-cm"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.created AS created_0,
  p0_.updated AS updated_1,
  p0_.id AS id_2,
  p0_.visible AS visible_3,
  p0_.archive AS archive_4,
  p0_.exclude_columbus AS exclude_columbus_5,
  p0_.nouveau AS nouveau_6,
  p0_.precommande AS precommande_7,
  p0_.precommande_date AS precommande_date_8,
  p0_.offre_speciale AS offre_speciale_9,
  p0_.cadeau AS cadeau_10,
  p0_.goodie AS goodie_11,
  p0_.declinaison AS declinaison_12,
  p0_.declinaison_principale AS declinaison_principale_13,
  p0_.reference AS reference_14,
  p0_.titre AS titre_15,
  p0_.titre_brouillon AS titre_brouillon_16,
  p0_.contenu AS contenu_17,
  p0_.contenu_brouillon AS contenu_brouillon_18,
  p0_.contenu2 AS contenu2_19,
  p0_.contenu2_brouillon AS contenu2_brouillon_20,
  p0_.slug AS slug_21,
  p0_.prix_achat_ht AS prix_achat_ht_22,
  p0_.montantHT AS montantHT_23,
  p0_.montantTTC AS montantTTC_24,
  p0_.montantActuelTTC AS montantActuelTTC_25,
  p0_.tva AS tva_26,
  p0_.stock AS stock_27,
  p0_.alerte_stock AS alerte_stock_28,
  p0_.stock_emaplacement AS stock_emaplacement_29,
  p0_.poids AS poids_30,
  p0_.recherche_keyword AS recherche_keyword_31,
  p0_.recherche_slug AS recherche_slug_32,
  p0_.recherche_carac_attr_slug AS recherche_carac_attr_slug_33,
  p0_.produits_associes AS produits_associes_34,
  p0_.meta_title AS meta_title_35,
  p0_.meta_keyword AS meta_keyword_36,
  p0_.meta_description AS meta_description_37,
  p0_.note_avis AS note_avis_38,
  p0_.nb_avis AS nb_avis_39,
  p0_.image_panorama_name AS image_panorama_name_40,
  p0_.image_panorama_updated_at AS image_panorama_updated_at_41,
  p0_.image_portrait_name AS image_portrait_name_42,
  p0_.image_portrait_updated_at AS image_portrait_updated_at_43,
  p0_.image_name AS image_name_44,
  p0_.image_updated_at AS image_updated_at_45,
  p0_.image_alt AS image_alt_46,
  p0_.image_name_brouillon AS image_name_brouillon_47,
  p0_.image_updated_at_brouillon AS image_updated_at_brouillon_48,
  p0_.total_ca AS total_ca_49,
  p0_.count_commande AS count_commande_50,
  p0_.is_customizable AS is_customizable_51,
  p0_.parent_id AS parent_id_52
FROM
  produit p0_
WHERE
  p0_.slug = ?

SELECT p0_.created AS created_0, p0_.updated AS updated_1, p0_.id AS id_2, p0_.visible AS visible_3, p0_.archive AS archive_4, p0_.exclude_columbus AS exclude_columbus_5, p0_.nouveau AS nouveau_6, p0_.precommande AS precommande_7, p0_.precommande_date AS precommande_date_8, p0_.offre_speciale AS offre_speciale_9, p0_.cadeau AS cadeau_10, p0_.goodie AS goodie_11, p0_.declinaison AS declinaison_12, p0_.declinaison_principale AS declinaison_principale_13, p0_.reference AS reference_14, p0_.titre AS titre_15, p0_.titre_brouillon AS titre_brouillon_16, p0_.contenu AS contenu_17, p0_.contenu_brouillon AS contenu_brouillon_18, p0_.contenu2 AS contenu2_19, p0_.contenu2_brouillon AS contenu2_brouillon_20, p0_.slug AS slug_21, p0_.prix_achat_ht AS prix_achat_ht_22, p0_.montantHT AS montantHT_23, p0_.montantTTC AS montantTTC_24, p0_.montantActuelTTC AS montantActuelTTC_25, p0_.tva AS tva_26, p0_.stock AS stock_27, p0_.alerte_stock AS alerte_stock_28, p0_.stock_emaplacement AS stock_emaplacement_29, p0_.poids AS poids_30, p0_.recherche_keyword AS recherche_keyword_31, p0_.recherche_slug AS recherche_slug_32, p0_.recherche_carac_attr_slug AS recherche_carac_attr_slug_33, p0_.produits_associes AS produits_associes_34, p0_.meta_title AS meta_title_35, p0_.meta_keyword AS meta_keyword_36, p0_.meta_description AS meta_description_37, p0_.note_avis AS note_avis_38, p0_.nb_avis AS nb_avis_39, p0_.image_panorama_name AS image_panorama_name_40, p0_.image_panorama_updated_at AS image_panorama_updated_at_41, p0_.image_portrait_name AS image_portrait_name_42, p0_.image_portrait_updated_at AS image_portrait_updated_at_43, p0_.image_name AS image_name_44, p0_.image_updated_at AS image_updated_at_45, p0_.image_alt AS image_alt_46, p0_.image_name_brouillon AS image_name_brouillon_47, p0_.image_updated_at_brouillon AS image_updated_at_brouillon_48, p0_.total_ca AS total_ca_49, p0_.count_commande AS count_commande_50, p0_.is_customizable AS is_customizable_51, p0_.parent_id AS parent_id_52 FROM produit p0_ WHERE p0_.slug = 'doudou-mouchoir-mon-petit-ourson-marron-10-cm';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 958)
6	App\Repository\ProduitRepository->findOneBySlug (line 33)
7	App\Controller\Front\CatalogController->produit (line 172)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 13)

1.11 ms
(0.50%)

SELECT a0_.id AS id_0, a0_.created AS created_1, a0_.updated AS updated_2, a0_.ordre AS ordre_3, a0_.affichage AS affichage_4, a0_.titre AS titre_5, a0_.slug AS slug_6 FROM attribut a0_ LEFT JOIN produit_attribut p1_ ON a0_.id = p1_.attribut_id WHERE p1_.produit_parent_id = ? ORDER BY a0_.ordre ASC

Parameters:

[
  1023
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.created AS created_1,
  a0_.updated AS updated_2,
  a0_.ordre AS ordre_3,
  a0_.affichage AS affichage_4,
  a0_.titre AS titre_5,
  a0_.slug AS slug_6
FROM
  attribut a0_
  LEFT JOIN produit_attribut p1_ ON a0_.id = p1_.attribut_id
WHERE
  p1_.produit_parent_id = ?
ORDER BY
  a0_.ordre ASC

SELECT a0_.id AS id_0, a0_.created AS created_1, a0_.updated AS updated_2, a0_.ordre AS ordre_3, a0_.affichage AS affichage_4, a0_.titre AS titre_5, a0_.slug AS slug_6 FROM attribut a0_ LEFT JOIN produit_attribut p1_ ON a0_.id = p1_.attribut_id WHERE p1_.produit_parent_id = 1023 ORDER BY a0_.ordre ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\AttributRepository->produit (line 51)
7	App\Controller\Front\CatalogController->produit (line 189)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 13)

0.93 ms
(0.42%)

SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_parent_id = ? AND t0.attribut_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.produit_parent_id AS produit_parent_id_2,
  t0.produit_id AS produit_id_3,
  t0.attribut_id AS attribut_id_4,
  t0.attribut_valeur_id AS attribut_valeur_id_5
FROM
  produit_attribut t0
WHERE
  t0.produit_parent_id = ?
  AND t0.attribut_id = ?

SELECT t0.id AS id_1, t0.produit_parent_id AS produit_parent_id_2, t0.produit_id AS produit_id_3, t0.attribut_id AS attribut_id_4, t0.attribut_valeur_id AS attribut_valeur_id_5 FROM produit_attribut t0 WHERE t0.produit_parent_id = 1023 AND t0.attribut_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	App\Services\App->getAvailableAttributValeurs (line 193)
4	App\Controller\Front\CatalogController->produit (line 224)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 13)

0.44 ms
(0.20%)

SELECT p0_.id AS id_0, p0_.visible AS visible_1, p0_.created AS created_2, p0_.updated AS updated_3, p0_.date_debut AS date_debut_4, p0_.date_fin AS date_fin_5, p0_.remise AS remise_6 FROM pack p0_ LEFT JOIN pack_produit p2_ ON p0_.id = p2_.pack_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id WHERE p0_.visible = ? AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= ? OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= ? OR p0_.date_debut IS NULL)) AND ((p1_.id = ? OR p1_.id = ?)) ORDER BY p0_.created DESC

Parameters:

[
  1
  "2026-09-24 17:22:18"
  "2026-09-24 17:22:18"
  "2026-09-24 17:22:18"
  "2026-09-24 17:22:18"
  1024
  1023
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.visible AS visible_1,
  p0_.created AS created_2,
  p0_.updated AS updated_3,
  p0_.date_debut AS date_debut_4,
  p0_.date_fin AS date_fin_5,
  p0_.remise AS remise_6
FROM
  pack p0_
  LEFT JOIN pack_produit p2_ ON p0_.id = p2_.pack_id
  LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id
WHERE
  p0_.visible = ?
  AND (
    (
      p0_.date_fin >= ?
      OR p0_.date_fin IS NULL
    )
  )
  AND (
    (
      p0_.date_debut <= ?
      OR p0_.date_debut IS NULL
    )
  )
  AND (
    (
      p0_.date_fin >= ?
      OR p0_.date_fin IS NULL
    )
  )
  AND (
    (
      p0_.date_debut <= ?
      OR p0_.date_debut IS NULL
    )
  )
  AND (
    (
      p1_.id = ?
      OR p1_.id = ?
    )
  )
ORDER BY
  p0_.created DESC

SELECT p0_.id AS id_0, p0_.visible AS visible_1, p0_.created AS created_2, p0_.updated AS updated_3, p0_.date_debut AS date_debut_4, p0_.date_fin AS date_fin_5, p0_.remise AS remise_6 FROM pack p0_ LEFT JOIN pack_produit p2_ ON p0_.id = p2_.pack_id LEFT JOIN produit p1_ ON p1_.id = p2_.produit_id WHERE p0_.visible = 1 AND ((p0_.date_fin >= '2026-09-24 17:22:18' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:22:18' OR p0_.date_debut IS NULL)) AND ((p0_.date_fin >= '2026-09-24 17:22:18' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:22:18' OR p0_.date_debut IS NULL)) AND ((p1_.id = 1024 OR p1_.id = 1023)) ORDER BY p0_.created DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\PackRepository->findPacks (line 93)
7	App\Controller\Front\CatalogController->produit (line 243)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 13)

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\CategorieProduit	806
App\Entity\Produit	706
App\Entity\Listing	150
App\Entity\Parametre	102
App\Entity\Page	51
App\Entity\Categorie	47
App\Entity\AvisVerifies	20
App\Entity\ProduitAttribut	12
App\Entity\AttributValeur	10
App\Entity\Promotion	6
App\Entity\SearchEditorialProduit	5
App\Entity\Attribut	1
App\Entity\Module	1
App\Entity\SearchEditorial	1

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\Module	No errors.
App\Entity\Menu	No errors.
App\Entity\Bloc	No errors.
App\Entity\Produit	No errors.
App\Entity\ProduitAttribut	No errors.
App\Entity\AttributValeur	No errors.
App\Entity\CaracteristiqueValeur	No errors.
App\Entity\Presse	No errors.
App\Entity\Listing	No errors.
App\Entity\Parametre	No errors.
App\Entity\Categorie	No errors.
App\Entity\AvisVerifies	No errors.
App\Entity\Commande	No errors.
App\Entity\TraductionValeur	No errors.
App\Entity\Traduction	No errors.
App\Entity\Popup	No errors.
App\Entity\Pack	No errors.
App\Entity\CategorieProduit	No errors.
App\Entity\Benefice	No errors.
App\Entity\ProduitCaracteristique	No errors.
App\Entity\ProduitImage	No errors.
App\Entity\CodePromo	No errors.
App\Entity\Promotion	No errors.
App\Entity\CommandeProduit	No errors.
App\Entity\CommandeRetour	No errors.
App\Entity\ProduitAlerteStock	No errors.
App\Entity\User	No errors.
App\Entity\InstashopProduit	No errors.
App\Entity\Attribut	No errors.
App\Entity\Caracteristique	No errors.
App\Entity\ModuleListing	No errors.
App\Entity\MenuListing	No errors.
App\Entity\Facture	No errors.
App\Entity\Adresse	No errors.
App\Entity\Transporteur	No errors.
App\Entity\Reglement	No errors.
App\Entity\Zone	No errors.
App\Entity\Paiement	No errors.
App\Entity\Instashop	No errors.
App\Entity\Pays	No errors.
App\Entity\TransporteurTarif	No errors.
App\Entity\SearchEditorial	No errors.
App\Entity\SearchEditorialProduit	No errors.
App\Entity\Collectmail	No errors.
App\Entity\CommandeStatistique	No errors.
App\Entity\Email	No errors.
App\Entity\Cron	No errors.
App\Entity\Fichier	No errors.
App\Entity\Magasin	No errors.
App\Entity\Faq	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation	No errors.
Gedmo\Translator\Entity\Translation	No errors.
Gedmo\Loggable\Entity\MappedSuperclass\AbstractLogEntry	No errors.
Gedmo\Loggable\Entity\LogEntry	No errors.
Gedmo\Tree\Entity\MappedSuperclass\AbstractClosure	No errors.
Vich\UploaderBundle\Entity\File	No errors.
Meilisearch\Bundle\Entity\Aggregator	No errors.

Symfony Profiler

GET https://tender-noether.87-106-247-125.plesk.page/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CFront%255CSearchEditorialC…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping