Query Metrics
40
Database Queries
13
Different statements
261.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
239.80 ms (91.84%) |
1 |
SELECT p0_.id AS id_0 FROM produit p0_ INNER JOIN lien_produit_categorie l2_ ON p0_.id = l2_.produit_id INNER JOIN categorie c1_ ON c1_.id = l2_.categorie_produit_id AND c1_.type IN ('produit') WHERE EXISTS (SELECT 1 FROM lien_produit_categorie l3_ INNER JOIN categorie c4_ ON l3_.categorie_produit_id = c4_.id WHERE l3_.produit_id = p0_.id AND c4_.id IN (?)) AND p0_.published_at <= ? AND (p0_.expired_at >= ? OR p0_.expired_at IS NULL) AND p0_.active = 1 AND p0_.visible = 1 GROUP BY p0_.id ORDER BY p0_.accueil_affichage_prioritaire DESC, p0_.is_reduc_ce ASC, p0_.created_at DESC LIMIT 9
Parameters:
[ 13 "2025-08-02 16:59:28" "2025-08-02 16:59:28" ] |
|
6.74 ms (2.58%) |
9 |
SELECT p0_.created_at AS created_at_0, p0_.updated_at AS updated_at_1, p0_.id AS id_2, p0_.nom AS nom_3, p0_.type AS type_4, p0_.code AS code_5, p0_.start_at AS start_at_6, p0_.end_at AS end_at_7, p0_.prix_fixe AS prix_fixe_8, p0_.remise_pourcentage AS remise_pourcentage_9, p0_.remise_valeur AS remise_valeur_10, p0_.remise_plafond AS remise_plafond_11, p0_.montant_cagnotte AS montant_cagnotte_12, p0_.montant_min AS montant_min_13, p0_.montant_max AS montant_max_14, p0_.quantite_min AS quantite_min_15, p0_.quantite_offerte AS quantite_offerte_16, p0_.nb_utilisation_commande AS nb_utilisation_commande_17, p0_.nb_utilisation_periode AS nb_utilisation_periode_18, p0_.plafond_periode AS plafond_periode_19, p0_.unite_periode AS unite_periode_20, p0_.is_cumulable AS is_cumulable_21, p0_.afficher_countdown AS afficher_countdown_22, p0_.pourcentage_cagnotte AS pourcentage_cagnotte_23, p0_.is_administrable AS is_administrable_24, p0_.produit_offert_id AS produit_offert_id_25 FROM promotion p0_ LEFT JOIN promotion_group_priorite p1_ ON p0_.id = p1_.promotion_id WHERE p0_.start_at <= ? AND p0_.end_at >= ? AND p0_.type IN (?) AND NOT EXISTS (SELECT 1 FROM lien_promotion_produit_exclusion l2_ INNER JOIN produit p3_ ON l2_.produit_id = p3_.id WHERE l2_.promotion_id = p0_.id AND p3_.id IN (?)) AND NOT EXISTS (SELECT 1 FROM lien_promotion_categorie_exclusion l4_ INNER JOIN categorie c5_ ON l4_.categorie_id = c5_.id WHERE l4_.promotion_id = p0_.id AND c5_.id IN (?)) AND (((SELECT COUNT(*) FROM lien_promotion_categorie l6_ WHERE l6_.promotion_id = p0_.id) = 0 AND (SELECT COUNT(*) FROM lien_promotion_produit l7_ WHERE l7_.promotion_id = p0_.id) = 0) OR EXISTS (SELECT 1 FROM lien_promotion_categorie l6_ INNER JOIN categorie c5_ ON l6_.categorie_id = c5_.id WHERE l6_.promotion_id = p0_.id AND c5_.id IN (?)) OR EXISTS (SELECT 1 FROM lien_promotion_produit l7_ INNER JOIN produit p3_ ON l7_.produit_id = p3_.id WHERE l7_.promotion_id = p0_.id AND p3_.id IN (?))) ORDER BY p1_.position ASC
Parameters:
[ "2025-08-02" "2025-08-02" [ 1 2 ] [ 51652 ] [ 13 ] [ 13 ] [ 51652 ] ] |
|
4.13 ms (1.58%) |
9 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.visible AS visible_4, t0.gestion_stock AS gestion_stock_5, t0.afficher_stock AS afficher_stock_6, t0.dispo_vente AS dispo_vente_7, t0.is_reduc_ce AS is_reduc_ce_8, t0.active AS active_9, t0.position AS position_10, t0.intitule AS intitule_11, t0.titre AS titre_12, t0.slug AS slug_13, t0.reference AS reference_14, t0.reference_fournisseur AS reference_fournisseur_15, t0.ean AS ean_16, t0.dimensions AS dimensions_17, t0.prix_info AS prix_info_18, t0.prix_achat AS prix_achat_19, t0.prix_public_ttc AS prix_public_ttc_20, t0.prix_vente_ht AS prix_vente_ht_21, t0.ecotaxe AS ecotaxe_22, t0.poids AS poids_23, t0.quantite AS quantite_24, t0.accroche AS accroche_25, t0.description_courte AS description_courte_26, t0.description_longue AS description_longue_27, t0.description_complementaire AS description_complementaire_28, t0.published_at AS published_at_29, t0.expired_at AS expired_at_30, t0.valid_at AS valid_at_31, t0.quantite_minimale AS quantite_minimale_32, t0.quantite_multiple AS quantite_multiple_33, t0.is_france AS is_france_34, t0.mot_cles AS mot_cles_35, t0.nominatif AS nominatif_36, t0.description_billet AS description_billet_37, t0.seuil_alerte_billet AS seuil_alerte_billet_38, t0.email_formulaire AS email_formulaire_39, t0.accueil_affichage_prioritaire AS accueil_affichage_prioritaire_40, t0.stock_seuil_alerte AS stock_seuil_alerte_41, t0.coupon_reduction_utilisation_nombre AS coupon_reduction_utilisation_nombre_42, t0.coupon_reduction_valeur AS coupon_reduction_valeur_43, t0.coupon_reduction_pourcentage AS coupon_reduction_pourcentage_44, t0.coupon_reduction_conditions AS coupon_reduction_conditions_45, t0.image_id AS image_id_46, t0.galerie_id AS galerie_id_47, t0.fichier_id AS fichier_id_48, t0.tva_id AS tva_id_49, t0.marque_id AS marque_id_50, t0.default_categorie_id AS default_categorie_id_51, t0.default_produit_declinaison_id AS default_produit_declinaison_id_52, t0.seo_id AS seo_id_53, t0.geolocalisation_id AS geolocalisation_id_54, t55.created_at AS created_at_56, t55.updated_at AS updated_at_57, t55.id AS id_58, t55.catalogues_id AS catalogues_id_59, t55.lieux_id AS lieux_id_60, t55.guid AS guid_61, t55.nb_jours AS nb_jours_62, t55.familletva AS familletva_63, t55.assurance AS assurance_64, t55.caution AS caution_65, t55.age_min AS age_min_66, t55.age_max AS age_max_67, t55.pack AS pack_68, t55.nom_obligatoire AS nom_obligatoire_69, t55.prenom_obligatoire AS prenom_obligatoire_70, t55.naissance_obligatoire AS naissance_obligatoire_71, t55.date_jour_obligatoire AS date_jour_obligatoire_72, t55.conditions AS conditions_73, t55.infos_verite AS infos_verite_74, t55.dedie AS dedie_75, t55.support AS support_76, t55.prevente AS prevente_77, t55.placement AS placement_78, t55.plan_placement AS plan_placement_79, t55.date_libre AS date_libre_80, t55.type AS type_81, t55.nb_billets_max AS nb_billets_max_82, t55.assurance_non_disponible AS assurance_non_disponible_83, t55.api_created_at AS api_created_at_84, t55.api_updated_at AS api_updated_at_85, t55.start_at AS start_at_86, t55.end_at AS end_at_87, t55.manif_id AS manif_id_88, t55.manif_nom AS manif_nom_89, t55.manif_statut AS manif_statut_90, t55.manif_start_at AS manif_start_at_91, t55.manif_end_at AS manif_end_at_92, t55.conditions_tarifaires AS conditions_tarifaires_93, t55.image AS image_94, t55.image_choix_rapide AS image_choix_rapide_95, t55.image_choix_plan AS image_choix_plan_96, t55.image_plan_petit AS image_plan_petit_97, t55.image_plan_grand AS image_plan_grand_98, t55.image_plan_placement AS image_plan_placement_99, t55.image_plan_placement_xx AS image_plan_placement_xx_100, t55.produit_id AS produit_id_101, t0.manifestation_id AS manifestation_id_102, t0.coupon_reduction_image_id AS coupon_reduction_image_id_103 FROM produit t0 LEFT JOIN produit_reduc_ce t55 ON t55.produit_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
51652
]
|
|
3.22 ms (1.23%) |
1 |
SELECT l0_.created_at AS created_at_0, l0_.updated_at AS updated_at_1, l0_.id AS id_2, l0_.visible AS visible_3, l0_.position AS position_4, b1_.created_at AS created_at_5, b1_.updated_at AS updated_at_6, b1_.id AS id_7, b1_.intitule AS intitule_8, b1_.titre AS titre_9, b1_.texte AS texte_10, b1_.bouton_lien AS bouton_lien_11, b1_.bouton_titre AS bouton_titre_12, b1_.bouton_target AS bouton_target_13, b1_.type AS type_14, b1_.position_image AS position_image_15, b1_.fond AS fond_16, b1_.espacement_haut AS espacement_haut_17, b1_.espacement_bas AS espacement_bas_18, b1_.formulaire AS formulaire_19, b1_.afficher_coordonnees AS afficher_coordonnees_20, m2_.name AS name_21, m2_.description AS description_22, m2_.enabled AS enabled_23, m2_.provider_name AS provider_name_24, m2_.provider_status AS provider_status_25, m2_.provider_reference AS provider_reference_26, m2_.provider_metadata AS provider_metadata_27, m2_.width AS width_28, m2_.height AS height_29, m2_.length AS length_30, m2_.content_type AS content_type_31, m2_.content_size AS content_size_32, m2_.copyright AS copyright_33, m2_.author_name AS author_name_34, m2_.context AS context_35, m2_.cdn_is_flushable AS cdn_is_flushable_36, m2_.cdn_flush_identifier AS cdn_flush_identifier_37, m2_.cdn_flush_at AS cdn_flush_at_38, m2_.cdn_status AS cdn_status_39, m2_.updated_at AS updated_at_40, m2_.created_at AS created_at_41, m2_.id AS id_42, l3_.created_at AS created_at_43, l3_.updated_at AS updated_at_44, l3_.id AS id_45, l3_.visible AS visible_46, l3_.position AS position_47, b4_.created_at AS created_at_48, b4_.updated_at AS updated_at_49, b4_.id AS id_50, b4_.titre AS titre_51, b4_.texte AS texte_52, b4_.bouton_lien AS bouton_lien_53, b4_.bouton_titre AS bouton_titre_54, b4_.bouton_target AS bouton_target_55, b4_.position_image AS position_image_56, m5_.name AS name_57, m5_.description AS description_58, m5_.enabled AS enabled_59, m5_.provider_name AS provider_name_60, m5_.provider_status AS provider_status_61, m5_.provider_reference AS provider_reference_62, m5_.provider_metadata AS provider_metadata_63, m5_.width AS width_64, m5_.height AS height_65, m5_.length AS length_66, m5_.content_type AS content_type_67, m5_.content_size AS content_size_68, m5_.copyright AS copyright_69, m5_.author_name AS author_name_70, m5_.context AS context_71, m5_.cdn_is_flushable AS cdn_is_flushable_72, m5_.cdn_flush_identifier AS cdn_flush_identifier_73, m5_.cdn_flush_at AS cdn_flush_at_74, m5_.cdn_status AS cdn_status_75, m5_.updated_at AS updated_at_76, m5_.created_at AS created_at_77, m5_.id AS id_78, l6_.created_at AS created_at_79, l6_.updated_at AS updated_at_80, l6_.id AS id_81, l6_.visible AS visible_82, l6_.position AS position_83, p7_.created_at AS created_at_84, p7_.updated_at AS updated_at_85, p7_.id AS id_86, p7_.visible AS visible_87, p7_.gestion_stock AS gestion_stock_88, p7_.afficher_stock AS afficher_stock_89, p7_.dispo_vente AS dispo_vente_90, p7_.is_reduc_ce AS is_reduc_ce_91, p7_.active AS active_92, p7_.position AS position_93, p7_.intitule AS intitule_94, p7_.titre AS titre_95, p7_.slug AS slug_96, p7_.reference AS reference_97, p7_.reference_fournisseur AS reference_fournisseur_98, p7_.ean AS ean_99, p7_.dimensions AS dimensions_100, p7_.prix_info AS prix_info_101, p7_.prix_achat AS prix_achat_102, p7_.prix_public_ttc AS prix_public_ttc_103, p7_.prix_vente_ht AS prix_vente_ht_104, p7_.ecotaxe AS ecotaxe_105, p7_.poids AS poids_106, p7_.quantite AS quantite_107, p7_.accroche AS accroche_108, p7_.description_courte AS description_courte_109, p7_.description_longue AS description_longue_110, p7_.description_complementaire AS description_complementaire_111, p7_.published_at AS published_at_112, p7_.expired_at AS expired_at_113, p7_.valid_at AS valid_at_114, p7_.quantite_minimale AS quantite_minimale_115, p7_.quantite_multiple AS quantite_multiple_116, p7_.is_france AS is_france_117, p7_.mot_cles AS mot_cles_118, p7_.nominatif AS nominatif_119, p7_.description_billet AS description_billet_120, p7_.seuil_alerte_billet AS seuil_alerte_billet_121, p7_.email_formulaire AS email_formulaire_122, p7_.accueil_affichage_prioritaire AS accueil_affichage_prioritaire_123, p7_.stock_seuil_alerte AS stock_seuil_alerte_124, p7_.coupon_reduction_utilisation_nombre AS coupon_reduction_utilisation_nombre_125, p7_.coupon_reduction_valeur AS coupon_reduction_valeur_126, p7_.coupon_reduction_pourcentage AS coupon_reduction_pourcentage_127, p7_.coupon_reduction_conditions AS coupon_reduction_conditions_128, m8_.name AS name_129, m8_.description AS description_130, m8_.enabled AS enabled_131, m8_.provider_name AS provider_name_132, m8_.provider_status AS provider_status_133, m8_.provider_reference AS provider_reference_134, m8_.provider_metadata AS provider_metadata_135, m8_.width AS width_136, m8_.height AS height_137, m8_.length AS length_138, m8_.content_type AS content_type_139, m8_.content_size AS content_size_140, m8_.copyright AS copyright_141, m8_.author_name AS author_name_142, m8_.context AS context_143, m8_.cdn_is_flushable AS cdn_is_flushable_144, m8_.cdn_flush_identifier AS cdn_flush_identifier_145, m8_.cdn_flush_at AS cdn_flush_at_146, m8_.cdn_status AS cdn_status_147, m8_.updated_at AS updated_at_148, m8_.created_at AS created_at_149, m8_.id AS id_150, c9_.created_at AS created_at_151, c9_.updated_at AS updated_at_152, c9_.id AS id_153, c9_.visible AS visible_154, c9_.position AS position_155, c9_.intitule AS intitule_156, c9_.titre AS titre_157, c9_.slug AS slug_158, c9_.accroche AS accroche_159, c9_.texte AS texte_160, c9_.icone AS icone_161, c9_.level AS level_162, c9_.type_canonical AS type_canonical_163, p10_.created_at AS created_at_164, p10_.updated_at AS updated_at_165, p10_.id AS id_166, p10_.visible AS visible_167, p10_.position AS position_168, p10_.reference AS reference_169, p10_.reference_fournisseur AS reference_fournisseur_170, p10_.ean AS ean_171, p10_.prix_achat AS prix_achat_172, p10_.prix_public_ttc AS prix_public_ttc_173, p10_.prix_vente_ht AS prix_vente_ht_174, p10_.poids AS poids_175, p10_.quantite AS quantite_176, p10_.published_at AS published_at_177, p10_.expired_at AS expired_at_178, p10_.nb_places_limitees AS nb_places_limitees_179, p10_.seuil_alerte_billet AS seuil_alerte_billet_180, p10_.stock_seuil_alerte AS stock_seuil_alerte_181, m11_.name AS name_182, m11_.description AS description_183, m11_.enabled AS enabled_184, m11_.provider_name AS provider_name_185, m11_.provider_status AS provider_status_186, m11_.provider_reference AS provider_reference_187, m11_.provider_metadata AS provider_metadata_188, m11_.width AS width_189, m11_.height AS height_190, m11_.length AS length_191, m11_.content_type AS content_type_192, m11_.content_size AS content_size_193, m11_.copyright AS copyright_194, m11_.author_name AS author_name_195, m11_.context AS context_196, m11_.cdn_is_flushable AS cdn_is_flushable_197, m11_.cdn_flush_identifier AS cdn_flush_identifier_198, m11_.cdn_flush_at AS cdn_flush_at_199, m11_.cdn_status AS cdn_status_200, m11_.updated_at AS updated_at_201, m11_.created_at AS created_at_202, m11_.id AS id_203, p12_.created_at AS created_at_204, p12_.updated_at AS updated_at_205, p12_.id AS id_206, p12_.catalogues_id AS catalogues_id_207, p12_.lieux_id AS lieux_id_208, p12_.guid AS guid_209, p12_.nb_jours AS nb_jours_210, p12_.familletva AS familletva_211, p12_.assurance AS assurance_212, p12_.caution AS caution_213, p12_.age_min AS age_min_214, p12_.age_max AS age_max_215, p12_.pack AS pack_216, p12_.nom_obligatoire AS nom_obligatoire_217, p12_.prenom_obligatoire AS prenom_obligatoire_218, p12_.naissance_obligatoire AS naissance_obligatoire_219, p12_.date_jour_obligatoire AS date_jour_obligatoire_220, p12_.conditions AS conditions_221, p12_.infos_verite AS infos_verite_222, p12_.dedie AS dedie_223, p12_.support AS support_224, p12_.prevente AS prevente_225, p12_.placement AS placement_226, p12_.plan_placement AS plan_placement_227, p12_.date_libre AS date_libre_228, p12_.type AS type_229, p12_.nb_billets_max AS nb_billets_max_230, p12_.assurance_non_disponible AS assurance_non_disponible_231, p12_.api_created_at AS api_created_at_232, p12_.api_updated_at AS api_updated_at_233, p12_.start_at AS start_at_234, p12_.end_at AS end_at_235, p12_.manif_id AS manif_id_236, p12_.manif_nom AS manif_nom_237, p12_.manif_statut AS manif_statut_238, p12_.manif_start_at AS manif_start_at_239, p12_.manif_end_at AS manif_end_at_240, p12_.conditions_tarifaires AS conditions_tarifaires_241, p12_.image AS image_242, p12_.image_choix_rapide AS image_choix_rapide_243, p12_.image_choix_plan AS image_choix_plan_244, p12_.image_plan_petit AS image_plan_petit_245, p12_.image_plan_grand AS image_plan_grand_246, p12_.image_plan_placement AS image_plan_placement_247, p12_.image_plan_placement_xx AS image_plan_placement_xx_248, g13_.created_at AS created_at_249, g13_.updated_at AS updated_at_250, g13_.id AS id_251, g13_.adresse_saisie AS adresse_saisie_252, g13_.numero AS numero_253, g13_.route AS route_254, g13_.code_postal AS code_postal_255, g13_.ville AS ville_256, g13_.departement AS departement_257, g13_.region AS region_258, g13_.pays AS pays_259, g13_.latitude AS latitude_260, g13_.longitude AS longitude_261, g13_.guid AS guid_262, m14_.created_at AS created_at_263, m14_.updated_at AS updated_at_264, m14_.id AS id_265, m14_.nom AS nom_266, m14_.statut AS statut_267, m14_.start_at AS start_at_268, m14_.end_at AS end_at_269, m14_.slug AS slug_270, l0_.bloc_id AS bloc_id_271, l0_.page_accueil_id AS page_accueil_id_272, b1_.image_id AS image_id_273, b1_.categorie_id AS categorie_id_274, l3_.bloc_id AS bloc_id_275, l3_.ligne_id AS ligne_id_276, b4_.image_id AS image_id_277, l6_.bloc_id AS bloc_id_278, l6_.produit_id AS produit_id_279, p7_.image_id AS image_id_280, p7_.galerie_id AS galerie_id_281, p7_.fichier_id AS fichier_id_282, p7_.tva_id AS tva_id_283, p7_.marque_id AS marque_id_284, p7_.default_categorie_id AS default_categorie_id_285, p7_.default_produit_declinaison_id AS default_produit_declinaison_id_286, p7_.seo_id AS seo_id_287, p7_.geolocalisation_id AS geolocalisation_id_288, p7_.manifestation_id AS manifestation_id_289, p7_.coupon_reduction_image_id AS coupon_reduction_image_id_290, c9_.type AS type_291, c9_.categorie_parent_id AS categorie_parent_id_292, c9_.image_id AS image_id_293, c9_.seo_id AS seo_id_294, p10_.image_id AS image_id_295, p10_.galerie_id AS galerie_id_296, p10_.produit_id AS produit_id_297, p12_.produit_id AS produit_id_298, m14_.image_id AS image_id_299, m14_.seo_id AS seo_id_300 FROM lien_bloc_page_accueil l0_ LEFT JOIN bloc b1_ ON l0_.bloc_id = b1_.id LEFT JOIN media__media m2_ ON b1_.image_id = m2_.id LEFT JOIN lien_bloc_ligne l3_ ON b1_.id = l3_.bloc_id LEFT JOIN bloc_ligne b4_ ON l3_.ligne_id = b4_.id LEFT JOIN media__media m5_ ON b4_.image_id = m5_.id LEFT JOIN lien_bloc_ligne_produit l6_ ON b1_.id = l6_.bloc_id LEFT JOIN produit p7_ ON l6_.produit_id = p7_.id LEFT JOIN tva t15_ ON p7_.tva_id = t15_.id LEFT JOIN marque m16_ ON p7_.marque_id = m16_.id LEFT JOIN media__media m8_ ON p7_.image_id = m8_.id LEFT JOIN categorie c9_ ON p7_.default_categorie_id = c9_.id AND c9_.type IN ('produit') LEFT JOIN produit_declinaison p10_ ON p7_.default_produit_declinaison_id = p10_.id LEFT JOIN media__media m11_ ON p10_.image_id = m11_.id LEFT JOIN produit_reduc_ce p12_ ON p7_.id = p12_.produit_id LEFT JOIN geolocalisation g13_ ON p7_.geolocalisation_id = g13_.id LEFT JOIN manifestation m14_ ON p7_.manifestation_id = m14_.id WHERE l0_.visible = 1 AND l0_.page_accueil_id = ? ORDER BY l0_.position ASC, l3_.position ASC, l6_.position ASC
Parameters:
[
2
]
|
|
2.46 ms (0.94%) |
9 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.visible AS visible_4, t0.position AS position_5, t0.intitule AS intitule_6, t0.titre AS titre_7, t0.slug AS slug_8, t0.accroche AS accroche_9, t0.texte AS texte_10, t0.icone AS icone_11, t0.level AS level_12, t0.type_canonical AS type_canonical_13, t0.categorie_parent_id AS categorie_parent_id_14, t0.image_id AS image_id_15, t0.seo_id AS seo_id_16, t0.type FROM categorie t0 INNER JOIN lien_produit_categorie ON t0.id = lien_produit_categorie.categorie_produit_id WHERE lien_produit_categorie.produit_id = ? AND t0.type IN ('produit')
Parameters:
[
51652
]
|
|
0.85 ms (0.33%) |
3 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.intitule AS intitule_4, t0.titre AS titre_5, t0.accroche AS accroche_6, t0.texte AS texte_7, t0.image_id AS image_id_8, t0.seo_id AS seo_id_9 FROM page_accueil t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
|
0.81 ms (0.31%) |
1 |
SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.id AS id_2, m0_.type AS type_3, m0_.redirection_lien AS redirection_lien_4, m0_.redirection_titre AS redirection_titre_5, m0_.separateur_titre AS separateur_titre_6, m0_.redirection_target AS redirection_target_7, m0_.level AS level_8, m0_.description AS description_9, p1_.created_at AS created_at_10, p1_.updated_at AS updated_at_11, p1_.id AS id_12, p1_.visible AS visible_13, p1_.position AS position_14, p1_.intitule AS intitule_15, p1_.titre AS titre_16, p1_.slug AS slug_17, p1_.slug_fixe AS slug_fixe_18, p1_.accroche AS accroche_19, p1_.texte AS texte_20, c2_.created_at AS created_at_21, c2_.updated_at AS updated_at_22, c2_.id AS id_23, c2_.visible AS visible_24, c2_.position AS position_25, c2_.intitule AS intitule_26, c2_.titre AS titre_27, c2_.slug AS slug_28, c2_.accroche AS accroche_29, c2_.texte AS texte_30, c2_.icone AS icone_31, c2_.level AS level_32, c2_.type_canonical AS type_canonical_33, c3_.created_at AS created_at_34, c3_.updated_at AS updated_at_35, c3_.id AS id_36, c3_.visible AS visible_37, c3_.position AS position_38, c3_.intitule AS intitule_39, c3_.titre AS titre_40, c3_.slug AS slug_41, c3_.accroche AS accroche_42, c3_.texte AS texte_43, c3_.icone AS icone_44, c3_.level AS level_45, c3_.type_canonical AS type_canonical_46, c4_.created_at AS created_at_47, c4_.updated_at AS updated_at_48, c4_.id AS id_49, c4_.visible AS visible_50, c4_.position AS position_51, c4_.intitule AS intitule_52, c4_.titre AS titre_53, c4_.slug AS slug_54, c4_.accroche AS accroche_55, c4_.texte AS texte_56, c4_.icone AS icone_57, c4_.level AS level_58, c4_.type_canonical AS type_canonical_59, m0_.menu_item_parent_id AS menu_item_parent_id_60, m0_.page_id AS page_id_61, m0_.categorie_page_id AS categorie_page_id_62, m0_.categorie_produit_id AS categorie_produit_id_63, m0_.categorie_actualite_id AS categorie_actualite_id_64, m0_.categorie_cse_id AS categorie_cse_id_65, m0_.image_id AS image_id_66, p1_.image_id AS image_id_67, p1_.seo_id AS seo_id_68, c2_.type AS type_69, c2_.categorie_parent_id AS categorie_parent_id_70, c2_.image_id AS image_id_71, c2_.seo_id AS seo_id_72, c3_.type AS type_73, c3_.categorie_parent_id AS categorie_parent_id_74, c3_.image_id AS image_id_75, c3_.seo_id AS seo_id_76, c4_.type AS type_77, c4_.categorie_parent_id AS categorie_parent_id_78, c4_.image_id AS image_id_79, c4_.seo_id AS seo_id_80 FROM menu_item m0_ INNER JOIN lien_menu_menu_item l5_ ON m0_.id = l5_.menu_item_id LEFT JOIN page p1_ ON m0_.page_id = p1_.id LEFT JOIN categorie c2_ ON m0_.categorie_page_id = c2_.id AND c2_.type IN ('page') LEFT JOIN categorie c3_ ON m0_.categorie_actualite_id = c3_.id AND c3_.type IN ('actualite') LEFT JOIN categorie c4_ ON m0_.categorie_produit_id = c4_.id AND c4_.type IN ('produit') WHERE l5_.visible = 1 AND l5_.menu_id = ? ORDER BY l5_.position ASC
Parameters:
[
4
]
|
|
0.70 ms (0.27%) |
1 |
SELECT a0_.created_at AS created_at_0, a0_.updated_at AS updated_at_1, a0_.id AS id_2, a0_.visible AS visible_3, a0_.position AS position_4, a0_.slug AS slug_5, a0_.titre AS titre_6, a0_.accroche AS accroche_7, a0_.texte AS texte_8, a0_.video AS video_9, a0_.published_at AS published_at_10, a0_.expired_at AS expired_at_11, a0_.user_id AS user_id_12, a0_.image_id AS image_id_13, a0_.fichier_id AS fichier_id_14, a0_.galerie_id AS galerie_id_15, a0_.seo_id AS seo_id_16 FROM actualite a0_ WHERE a0_.published_at <= ? AND (a0_.expired_at >= ? OR a0_.expired_at IS NULL) AND a0_.visible = 1 AND (SELECT COUNT(*) FROM lien_categorie_actualite l1_ WHERE l1_.actualite_id = a0_.id) > 0 ORDER BY a0_.published_at DESC LIMIT 4
Parameters:
[ "2025-08-02 16:59:28" "2025-08-02 16:59:28" ] |
|
0.62 ms (0.24%) |
1 |
SELECT l0_.created_at AS created_at_0, l0_.updated_at AS updated_at_1, l0_.id AS id_2, l0_.visible AS visible_3, l0_.position AS position_4, d1_.created_at AS created_at_5, d1_.updated_at AS updated_at_6, d1_.id AS id_7, d1_.titre AS titre_8, d1_.accroche AS accroche_9, d1_.bouton_lien AS bouton_lien_10, d1_.bouton_titre AS bouton_titre_11, d1_.bouton_target AS bouton_target_12, d1_.alignement AS alignement_13, m2_.name AS name_14, m2_.description AS description_15, m2_.enabled AS enabled_16, m2_.provider_name AS provider_name_17, m2_.provider_status AS provider_status_18, m2_.provider_reference AS provider_reference_19, m2_.provider_metadata AS provider_metadata_20, m2_.width AS width_21, m2_.height AS height_22, m2_.length AS length_23, m2_.content_type AS content_type_24, m2_.content_size AS content_size_25, m2_.copyright AS copyright_26, m2_.author_name AS author_name_27, m2_.context AS context_28, m2_.cdn_is_flushable AS cdn_is_flushable_29, m2_.cdn_flush_identifier AS cdn_flush_identifier_30, m2_.cdn_flush_at AS cdn_flush_at_31, m2_.cdn_status AS cdn_status_32, m2_.updated_at AS updated_at_33, m2_.created_at AS created_at_34, m2_.id AS id_35, l0_.diaporama_id AS diaporama_id_36, l0_.page_accueil_id AS page_accueil_id_37, d1_.image_id AS image_id_38 FROM lien_diaporama_page_accueil l0_ LEFT JOIN diaporama d1_ ON l0_.diaporama_id = d1_.id LEFT JOIN media__media m2_ ON d1_.image_id = m2_.id WHERE l0_.visible = 1 AND l0_.page_accueil_id = ? ORDER BY l0_.position ASC
Parameters:
[
2
]
|
|
0.50 ms (0.19%) |
2 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.titre AS titre_4, t0.taux AS taux_5, t0.code_comptable AS code_comptable_6 FROM tva t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
0.47 ms (0.18%) |
1 |
SELECT COUNT(c0_.id) AS sclr_0 FROM conversation c0_ WHERE c0_.need_reply = 1
Parameters:
[] |
|
0.40 ms (0.15%) |
1 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.visible AS visible_4, t0.position AS position_5, t0.intitule AS intitule_6, t0.titre AS titre_7, t0.slug AS slug_8, t0.accroche AS accroche_9, t0.texte AS texte_10, t0.icone AS icone_11, t0.level AS level_12, t0.type_canonical AS type_canonical_13, t0.categorie_parent_id AS categorie_parent_id_14, t0.image_id AS image_id_15, t0.seo_id AS seo_id_16, t0.type, t0.guid AS guid_17, t0.categorie_produit_id AS categorie_produit_id_18 FROM categorie t0 WHERE t0.id = ? AND t0.type IN ('actualite', 'page', 'produit', 'cse', 'offre', 'reducce')
Parameters:
[
13
]
|
|
0.39 ms (0.15%) |
1 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.meta_title AS meta_title_4, t0.meta_keywords AS meta_keywords_5, t0.meta_description AS meta_description_6, t0.seo_parametre_id AS seo_parametre_id_7, t8.created_at AS created_at_9, t8.updated_at AS updated_at_10, t8.id AS id_11, t8.url_canonical AS url_canonical_12, t8.redirection301 AS redirection301_13, t8.robot_index AS robot_index_14, t8.robot_follow AS robot_follow_15, t0.seo_reseaux_sociaux_id AS seo_reseaux_sociaux_id_16, t17.created_at AS created_at_18, t17.updated_at AS updated_at_19, t17.id AS id_20, t17.facebook_description AS facebook_description_21, t17.image_id AS image_id_22 FROM seo t0 LEFT JOIN seo_parametre t8 ON t0.seo_parametre_id = t8.id LEFT JOIN seo_reseaux_sociaux t17 ON t0.seo_reseaux_sociaux_id = t17.id WHERE t0.id = ?
Parameters:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\EntityBase | No errors. |
| App\Entity\Seo\R301 | No errors. |
| App\Entity\Contenu\PageAccueil | No errors. |
| Sonata\MediaBundle\Entity\BaseMedia | No errors. |
| App\Application\Sonata\MediaBundle\Entity\Media | No errors. |
| App\Entity\Seo\Seo | No errors. |
| App\Entity\Contenu\LienBlocPageAccueil | No errors. |
| App\Entity\Contenu\LienDiaporamaPageAccueil | No errors. |
| App\Entity\Seo\SeoParametre | No errors. |
| App\Entity\Seo\SeoReseauxSociaux | No errors. |
| App\Entity\Bloc\Bloc | No errors. |
| App\Entity\Bloc\LienBlocLigne | No errors. |
| App\Entity\Bloc\BlocLigne | No errors. |
| App\Entity\Boutique\LienBlocLigneProduit | No errors. |
| App\Entity\Boutique\Produit | No errors. |
| App\Entity\Boutique\Tva | No errors. |
| App\Entity\Boutique\Marque | No errors. |
| App\Entity\Categorie\Categorie | No errors. |
| App\Entity\Boutique\CategorieProduit | No errors. |
| App\Entity\Boutique\ProduitDeclinaison | No errors. |
| App\Entity\Boutique\ProduitReducCe | No errors. |
| App\Entity\Boutique\Geolocalisation | No errors. |
| App\Entity\Boutique\Manifestation | No errors. |
| Sonata\MediaBundle\Entity\BaseGallery | No errors. |
| App\Application\Sonata\MediaBundle\Entity\Gallery | No errors. |
| App\Entity\Contenu\LienBlocPage | No errors. |
| App\Entity\Contenu\LienBlocActualite | No errors. |
| App\Entity\Categorie\LienBlocCategorie | No errors. |
| App\Entity\Boutique\LienBlocProduit | No errors. |
| App\Entity\Boutique\LienBlocMarque | No errors. |
| App\Entity\User\LienBlocUserGroup | No errors. |
| Sonata\MediaBundle\Entity\BaseGalleryHasMedia | No errors. |
| App\Application\Sonata\MediaBundle\Entity\GalleryHasMedia | No errors. |
| App\Entity\Contenu\CategorieActualite | No errors. |
| App\Entity\Contenu\CategoriePage | No errors. |
| App\Entity\Contenu\CategorieCse | No errors. |
| App\Entity\Boutique\CategorieOffre | No errors. |
| App\Entity\Boutique\CategorieReducCe | No errors. |
| App\Entity\Menu\MenuItem | No errors. |
| FOS\UserBundle\Model\Group | No errors. |
| App\Entity\User\UserGroup | No errors. |
| App\Entity\Boutique\Caracteristique | No errors. |
| App\Entity\Boutique\Promotion | No errors. |
| App\Entity\Boutique\PromotionLigne | No errors. |
| App\Entity\Boutique\PanierLigne | No errors. |
| App\Entity\Boutique\CommandeLigne | No errors. |
| App\Entity\Boutique\ProduitEan | No errors. |
| App\Entity\Formulaire\Contact | No errors. |
| App\Entity\Boutique\ProduitStockBalance | No errors. |
| App\Entity\Boutique\ProduitCouponReductionHistorique | No errors. |
| App\Entity\Boutique\Transporteur | No errors. |
| App\Entity\Boutique\PromotionGroupPriorite | No errors. |
| App\Entity\Contenu\Actualite | No errors. |
| FOS\UserBundle\Model\User | No errors. |
| App\Entity\User\User | No errors. |
| App\Entity\Bloc\Diaporama | No errors. |
| App\Entity\Menu\LienMenuMenuItem | No errors. |
| App\Entity\Contenu\Page | No errors. |
| App\Entity\Formulaire\Conversation | No errors. |