Query Metrics

90 Database Queries
38 Different statements
51.93 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.86 ms
(7.43%)
12
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.Titre AS Titre_3, t0.SousTitre AS SousTitre_4, t0.Url AS Url_5, t0.target AS target_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM menu_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
3.64 ms
(7.00%)
4
SELECT p0_.id AS id_0, p0_.position AS position_1, p0_.authorization_api AS authorization_api_2, p0_.actif_home AS actif_home_3, p0_.post_archive AS post_archive_4, p0_.date_archive AS date_archive_5, p0_.image AS image_6, p0_.url_video AS url_video_7, p0_.image_bandeau AS image_bandeau_8, p0_.image_bandeau_height AS image_bandeau_height_9, p0_.image_couverture AS image_couverture_10, p0_.tag_managerhead AS tag_managerhead_11, p0_.tag_managerbody AS tag_managerbody_12, p0_.date_publication AS date_publication_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.id_activite AS id_activite_16, p0_.id_sous_activite AS id_sous_activite_17, p0_.id_secteur AS id_secteur_18, p0_.type_page_ref AS type_page_ref_19, p0_.author_id AS author_id_20, p0_.type_post AS type_post_21, p0_.template_cms_id AS template_cms_id_22, p0_.modele_gallerie_id AS modele_gallerie_id_23 FROM post p0_ INNER JOIN post_translation p1_ ON p0_.id = p1_.translatable_id WHERE p1_.locale = ? AND p1_.slug = ?
Parameters:
[
  "fr"
  "mentions-legales"
]
2.57 ms
(4.94%)
3
SELECT m0_.id AS id_0, m0_.DateCreation AS DateCreation_1, m0_.DateModification AS DateModification_2, m0_.type_post AS type_post_3, m0_.id_activite AS id_activite_4, m0_.id_secteur AS id_secteur_5, m0_.Parent AS Parent_6, m0_.Position AS Position_7, m0_.Nofollow AS Nofollow_8, m0_.icone AS icone_9, m0_.icone_hover AS icone_hover_10, m0_.Id_menu AS Id_menu_11, m0_.IdTypePost AS IdTypePost_12, m0_.IdCategory AS IdCategory_13, m0_.IdSousCategory AS IdSousCategory_14, m0_.IdPost AS IdPost_15 FROM menu m0_ INNER JOIN menu_translation m1_ ON m0_.id = m1_.translatable_id WHERE m0_.Id_menu = ? AND m1_.actif = 1 AND m1_.locale = ? ORDER BY m0_.Position ASC
Parameters:
[
  2
  "fr"
]
2.57 ms
(4.94%)
3
SELECT t0.id AS id_1, t0.id_module AS id_module_2, t0.type_module AS type_module_3, t0.old AS old_4, t0.new AS new_5, t0.active AS active_6, t0.lien_externe AS lien_externe_7, t0.DateCreation AS DateCreation_8, t0.DateModification AS DateModification_9, t0.locale AS locale_10, t0.IdSite AS IdSite_11 FROM redirection t0 WHERE t0.old = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "/mentions-legales"
  1
]
2.50 ms
(4.81%)
2
SELECT t0.id AS id_1, t0.couleur_text_btn AS couleur_text_btn_2, t0.couleur_text_btn_hover AS couleur_text_btn_hover_3, t0.couleur_btn AS couleur_btn_4, t0.couleur_btn_hover AS couleur_btn_hover_5, t0.bg_body AS bg_body_6, t0.couleur_body AS couleur_body_7, t0.couleur_generale AS couleur_generale_8, t0.couleur_secondaire AS couleur_secondaire_9, t0.couleur_troisieme AS couleur_troisieme_10, t0.typo_body AS typo_body_11, t0.style_typo_body AS style_typo_body_12, t0.font_size_typo_body AS font_size_typo_body_13, t0.typo_body_secondaire AS typo_body_secondaire_14, t0.style_typo_body_secondaire AS style_typo_body_secondaire_15, t0.font_size_typo_body_secondaire AS font_size_typo_body_secondaire_16, t0.typo_menu AS typo_menu_17, t0.style_typo_menu AS style_typo_menu_18, t0.font_size_menu AS font_size_menu_19, t0.typo_titre AS typo_titre_20, t0.style_typo_titre AS style_typo_titre_21, t0.font_size_titre AS font_size_titre_22, t0.typo_sous_titre AS typo_sous_titre_23, t0.style_typo_sous_titre AS style_typo_sous_titre_24, t0.font_size_sous_titre AS font_size_sous_titre_25, t0.typo_h1 AS typo_h1_26, t0.style_typo_h1 AS style_typo_h1_27, t0.font_size_h1 AS font_size_h1_28, t0.typo_h2 AS typo_h2_29, t0.style_typo_h2 AS style_typo_h2_30, t0.font_size_h2 AS font_size_h2_31, t0.typo_h3 AS typo_h3_32, t0.style_typo_h3 AS style_typo_h3_33, t0.font_size_h3 AS font_size_h3_34, t0.typo_h4 AS typo_h4_35, t0.style_typo_h4 AS style_typo_h4_36, t0.font_size_h4 AS font_size_h4_37, t0.typo_h5 AS typo_h5_38, t0.style_typo_h5 AS style_typo_h5_39, t0.font_size_h5 AS font_size_h5_40, t0.typo_h6 AS typo_h6_41, t0.style_typo_h6 AS style_typo_h6_42, t0.font_size_h6 AS font_size_h6_43, t0.theme AS theme_44, t0.header_style AS header_style_45, t0.footer_style AS footer_style_46, t0.header_bg_color AS header_bg_color_47, t0.header_top_bg_color AS header_top_bg_color_48, t0.header_text_color AS header_text_color_49, t0.header_text_color_hover AS header_text_color_hover_50, t0.header_top_text_color AS header_top_text_color_51, t0.header_top_text_color_hover AS header_top_text_color_hover_52, t0.header_bg_transparent AS header_bg_transparent_53, t0.header_top_bg_transparent AS header_top_bg_transparent_54, t0.actif_pictos_info AS actif_pictos_info_55, t0.actif_icones_navigation AS actif_icones_navigation_56, t0.show_reseaux_sociaux AS show_reseaux_sociaux_57, t0.actif_tel1 AS actif_tel1_58, t0.actif_tel2 AS actif_tel2_59, t0.actif_email1 AS actif_email1_60, t0.actif_email2 AS actif_email2_61, t0.actif_adresse1 AS actif_adresse1_62, t0.actif_adresse2 AS actif_adresse2_63, t0.actif_horaires1 AS actif_horaires1_64, t0.actif_horaires2 AS actif_horaires2_65, t0.actif_titre_tel1 AS actif_titre_tel1_66, t0.actif_titre_tel2 AS actif_titre_tel2_67, t0.actif_titre_email1 AS actif_titre_email1_68, t0.actif_titre_email2 AS actif_titre_email2_69, t0.actif_titre_adresse1 AS actif_titre_adresse1_70, t0.actif_titre_adresse2 AS actif_titre_adresse2_71, t0.actif_titre_horaires1 AS actif_titre_horaires1_72, t0.actif_titre_horaires2 AS actif_titre_horaires2_73, t0.actif_reseaux_sociaux AS actif_reseaux_sociaux_74, t0.actif_bouton1 AS actif_bouton1_75, t0.position_bouton1 AS position_bouton1_76, t0.actif_bouton2 AS actif_bouton2_77, t0.position_bouton2 AS position_bouton2_78, t0.actif_bouton3 AS actif_bouton3_79, t0.position_bouton3 AS position_bouton3_80, t0.couleur_text_bouton1 AS couleur_text_bouton1_81, t0.couleur_text_bouton1_hover AS couleur_text_bouton1_hover_82, t0.bg_bouton1 AS bg_bouton1_83, t0.bg_bouton1_hover AS bg_bouton1_hover_84, t0.couleur_text_bouton2 AS couleur_text_bouton2_85, t0.couleur_text_bouton2_hover AS couleur_text_bouton2_hover_86, t0.bg_bouton2 AS bg_bouton2_87, t0.bg_bouton2_hover AS bg_bouton2_hover_88, t0.couleur_text_bouton3 AS couleur_text_bouton3_89, t0.couleur_text_bouton3_hover AS couleur_text_bouton3_hover_90, t0.bg_bouton3 AS bg_bouton3_91, t0.bg_bouton3_hover AS bg_bouton3_hover_92, t0.couleur_infos_header AS couleur_infos_header_93, t0.couleur_infos_header_hover AS couleur_infos_header_hover_94, t0.couleur_pictos_header AS couleur_pictos_header_95, t0.bg_infos_header AS bg_infos_header_96, t0.actif_logo_footer AS actif_logo_footer_97, t0.position_logo_footer AS position_logo_footer_98, t0.actif_pictos_info_footer AS actif_pictos_info_footer_99, t0.actif_tel_footer AS actif_tel_footer_100, t0.actif_email_footer AS actif_email_footer_101, t0.actif_adresse_footer AS actif_adresse_footer_102, t0.actif_horaires_footer AS actif_horaires_footer_103, t0.actif_titre_tel_footer AS actif_titre_tel_footer_104, t0.actif_titre_email_footer AS actif_titre_email_footer_105, t0.actif_titre_adresse_footer AS actif_titre_adresse_footer_106, t0.actif_titre_horaires_footer AS actif_titre_horaires_footer_107, t0.actif_reseaux_sociaux_footer AS actif_reseaux_sociaux_footer_108, t0.actif_bouton1_footer AS actif_bouton1_footer_109, t0.actif_codeqr_footer AS actif_codeqr_footer_110, t0.actif_texte_footer AS actif_texte_footer_111, t0.nbr_contacts_footer AS nbr_contacts_footer_112, t0.actif_logo_copyright AS actif_logo_copyright_113, t0.actif_date_copyright AS actif_date_copyright_114, t0.bg_color_top_footer AS bg_color_top_footer_115, t0.color_top_footer AS color_top_footer_116, t0.bg_color_sub_footer AS bg_color_sub_footer_117, t0.color_sub_footer AS color_sub_footer_118, t0.DateCreation AS DateCreation_119, t0.DateModification AS DateModification_120 FROM theme_options t0 WHERE t0.theme = ? LIMIT 1
Parameters:
[
  "theme1"
]
2.35 ms
(4.52%)
6
SELECT t0.id AS id_1, t0.nom_contact AS nom_contact_2, t0.titre_mail AS titre_mail_3, t0.titre_tel AS titre_tel_4, t0.texte_contact AS texte_contact_5, t0.horaires_contact AS horaires_contact_6, t0.email AS email_7, t0.tel AS tel_8, t0.horaire_lun AS horaire_lun_9, t0.horaire_mard AS horaire_mard_10, t0.horaire_merc AS horaire_merc_11, t0.horaire_jeu AS horaire_jeu_12, t0.horaire_vend AS horaire_vend_13, t0.horaire_sam AS horaire_sam_14, t0.horaire_dim AS horaire_dim_15, t0.locale AS locale_16, t0.translatable_id AS translatable_id_17 FROM contact_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
1.97 ms
(3.80%)
3
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.title AS title_3, t0.title_affichage AS title_affichage_4, t0.slug AS slug_5, t0.summary AS summary_6, t0.content AS content_7, t0.content2 AS content2_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.meta_keys AS meta_keys_11, t0.script_sc AS script_sc_12, t0.breadcrumb AS breadcrumb_13, t0.canonical AS canonical_14, t0.meta_robots AS meta_robots_15, t0.settig_metaTitle AS settig_metaTitle_16, t0.settig_metaDesc AS settig_metaDesc_17, t0.traduite AS traduite_18, t0.image_alt AS image_alt_19, t0.image_bandeau_alt AS image_bandeau_alt_20, t0.image_couverture_alt AS image_couverture_alt_21, t0.titre_lien AS titre_lien_22, t0.type_lien AS type_lien_23, t0.lien_interne AS lien_interne_24, t0.lien_externe AS lien_externe_25, t0.telephone AS telephone_26, t0.locale AS locale_27, t0.export_traductions_id AS export_traductions_id_28, t0.translatable_id AS translatable_id_29 FROM post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  96
]
1.88 ms
(3.61%)
2
SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.path AS path_2, m0_.fileName AS fileName_3, m0_.image_cropped AS image_cropped_4, m0_.type AS type_5, m0_.type_media_post AS type_media_post_6, m0_.position AS position_7, m0_.module AS module_8, m0_.module_id AS module_id_9, m0_.lien_externe AS lien_externe_10, m0_.width AS width_11, m0_.height AS height_12, m0_.filesize AS filesize_13, m0_.crop_width AS crop_width_14, m0_.crop_height AS crop_height_15, m0_.crop_x AS crop_x_16, m0_.crop_y AS crop_y_17, m0_.DateCreation AS DateCreation_18, m0_.DateModification AS DateModification_19 FROM media_cms m0_ WHERE m0_.module = ? AND m0_.module_id = ? AND m0_.type_media_post = ? ORDER BY m0_.position ASC
Parameters:
[
  "Cms"
  96
  "media"
]
1.78 ms
(3.43%)
6
SELECT t0.id AS id_1, t0.email_site AS email_site_2, t0.image AS image_3, t0.lien_carte AS lien_carte_4, t0.apercu_image_lien AS apercu_image_lien_5, t0.image_footer AS image_footer_6, t0.image_bandeau AS image_bandeau_7, t0.tel AS tel_8, t0.image_vide AS image_vide_9, t0.maintenance AS maintenance_10, t0.htaccess_val AS htaccess_val_11, t0.meta_index AS meta_index_12, t0.meta_follow AS meta_follow_13, t0.robots AS robots_14, t0.analytics AS analytics_15, t0.cle_key AS cle_key_16, t0.cle_secret AS cle_secret_17, t0.tag_managerhead AS tag_managerhead_18, t0.meta_keywords AS meta_keywords_19, t0.cle_map AS cle_map_20, t0.active_smtp AS active_smtp_21, t0.email_from AS email_from_22, t0.email_sender AS email_sender_23, t0.host_smtp AS host_smtp_24, t0.type_cryptage AS type_cryptage_25, t0.port_tls AS port_tls_26, t0.port_ssl AS port_ssl_27, t0.smtp_user AS smtp_user_28, t0.smtp_pass AS smtp_pass_29, t0.typeLienErrorPage AS typeLienErrorPage_30, t0.lienExterneErrorPage AS lienExterneErrorPage_31, t0.telephoneErrorPage AS telephoneErrorPage_32, t0.domain_api_hrz AS domain_api_hrz_33, t0.token_api_hrz AS token_api_hrz_34, t0.actif_auth_gmail AS actif_auth_gmail_35, t0.id_client_auth AS id_client_auth_36, t0.secret_client_auth AS secret_client_auth_37, t0.IdSite AS IdSite_38 FROM parametre_site t0 ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
1.77 ms
(3.41%)
3
SELECT t0.id AS id_1, t0.titre_categorie AS titre_categorie_2, t0.slug_url AS slug_url_3, t0.chapeau_categorie AS chapeau_categorie_4, t0.texte_categorie AS texte_categorie_5, t0.texte_categorie2 AS texte_categorie2_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.canonical AS canonical_10, t0.settig_metaTitle AS settig_metaTitle_11, t0.settig_metaTitle1 AS settig_metaTitle1_12, t0.settig_metaTitle2 AS settig_metaTitle2_13, t0.settig_metaTitle3 AS settig_metaTitle3_14, t0.settig_metaTitle_post AS settig_metaTitle_post_15, t0.settig_metaDesc AS settig_metaDesc_16, t0.settig_metaDesc1 AS settig_metaDesc1_17, t0.settig_metaDesc2 AS settig_metaDesc2_18, t0.settig_metaDesc3 AS settig_metaDesc3_19, t0.settig_metaDesc_post AS settig_metaDesc_post_20, t0.titre_lien AS titre_lien_21, t0.type_lien AS type_lien_22, t0.lien_interne AS lien_interne_23, t0.lien_externe AS lien_externe_24, t0.telephone AS telephone_25, t0.locale AS locale_26, t0.translatable_id AS translatable_id_27 FROM category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
1.59 ms
(3.06%)
1
SELECT u0_.id AS id_0, u0_.id_module AS id_module_1, u0_.type AS type_2, u0_.created_at AS created_at_3, u0_.updated_at AS updated_at_4 FROM url_post u0_ INNER JOIN url_post_translation u1_ ON u0_.id = u1_.translatable_id WHERE u1_.slug = ? AND u1_.locale = ? LIMIT 1
Parameters:
[
  "mentions-legales"
  "fr"
]
1.54 ms
(2.96%)
3
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.type AS type_3, t0.DateCreation AS DateCreation_4, t0.DateModification AS DateModification_5, t0.IdSite AS IdSite_6 FROM liste_menu t0 WHERE t0.type = ? AND t0.IdSite = ? LIMIT 1
Parameters:
[
  "Header-right"
  "1"
]
1.43 ms
(2.76%)
6
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.actif_slider AS actif_slider_3, t0.position_text AS position_text_4, t0.alias AS alias_5, t0.nombre_article AS nombre_article_6, t0.bg_image AS bg_image_7, t0.color AS color_8, t0.color_texte AS color_texte_9, t0.DateCreation AS DateCreation_10, t0.DateModification AS DateModification_11, t0.multi_affichage AS multi_affichage_12, t0.IdPostAffichage AS IdPostAffichage_13 FROM bloc_service t0 WHERE t0.actif = ? AND t0.alias = ? LIMIT 1
Parameters:
[
  1
  "btn_header"
]
1.28 ms
(2.47%)
1
SELECT p0_.id AS id_0, p0_.actif AS actif_1, p0_.actif_desktop AS actif_desktop_2, p0_.actif_mobile AS actif_mobile_3, p0_.type_bloc AS type_bloc_4, p0_.id_bloc_service AS id_bloc_service_5, p0_.type_post AS type_post_6, p0_.position AS position_7, p0_.image AS image_8, p0_.bg_color AS bg_color_9, p0_.video_url AS video_url_10, p0_.position_text AS position_text_11, p0_.grid_carousel AS grid_carousel_12, p0_.DateCreation AS DateCreation_13, p0_.DateModification AS DateModification_14, p0_.is_deleted AS is_deleted_15, p0_.IdMedia AS IdMedia_16, p0_.IdForms AS IdForms_17, p0_.IdPost AS IdPost_18, p0_.IdWidget AS IdWidget_19 FROM post_bloc p0_ INNER JOIN post p1_ ON p0_.IdPost = p1_.id WHERE p1_.id = ? AND (p0_.is_deleted IS NULL OR p0_.is_deleted = ?) ORDER BY p0_.position ASC
Parameters:
[
  96
  0
]
1.24 ms
(2.38%)
3
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.actif_haut AS actif_haut_3, t0.position_text AS position_text_4, t0.nombre_article AS nombre_article_5, t0.actif_slider AS actif_slider_6, t0.pagination AS pagination_7, t0.page_size AS page_size_8, t0.order_by AS order_by_9, t0.fixe_texte AS fixe_texte_10, t0.image AS image_11, t0.image_bandeau AS image_bandeau_12, t0.url_video AS url_video_13, t0.DateCreation AS DateCreation_14, t0.DateModification AS DateModification_15, t0.IdParent AS IdParent_16, t0.IdSousParent AS IdSousParent_17, t0.tag_managerhead AS tag_managerhead_18, t0.meta_keywords AS meta_keywords_19, t0.meta_robots AS meta_robots_20, t0.multi_affichage AS multi_affichage_21, t0.IdSite AS IdSite_22, t0.id_type_post AS id_type_post_23, t0.IdPostAffichage AS IdPostAffichage_24, t0.modele_gallerie_id AS modele_gallerie_id_25 FROM category t0 WHERE t0.id = ?
Parameters:
[
  2
]
1.22 ms
(2.36%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.sub_title AS sub_title_3, t0.content AS content_4, t0.titre_lien AS titre_lien_5, t0.type_lien AS type_lien_6, t0.lien_interne AS lien_interne_7, t0.lien_externe AS lien_externe_8, t0.telephone AS telephone_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM bloc_service_items_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  10
]
1.22 ms
(2.35%)
4
SELECT l0_.id AS id_0, l0_.active AS active_1, l0_.name AS name_2, l0_.language_code AS language_code_3, l0_.flag AS flag_4, l0_.created_at AS created_at_5, l0_.updated_at AS updated_at_6 FROM language l0_ WHERE l0_.active = 1
Parameters:
[]
1.13 ms
(2.18%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.titre_activite AS titre_activite_3, t0.libelle_url AS libelle_url_4, t0.var_active AS var_active_5, t0.text_activite_principal AS text_activite_principal_6, t0.text_generer_activite_principal AS text_generer_activite_principal_7, t0.text_activite_secondaire AS text_activite_secondaire_8, t0.text_generer_activite_secondaire AS text_generer_activite_secondaire_9, t0.text_activite_principal_final AS text_activite_principal_final_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.breadcrumb AS breadcrumb_14, t0.schema_script AS schema_script_15, t0.canonical_url AS canonical_url_16, t0.meta_robots AS meta_robots_17, t0.setting_meta_title AS setting_meta_title_18, t0.setting_meta_desc AS setting_meta_desc_19, t0.locale AS locale_20, t0.translatable_id AS translatable_id_21 FROM activites_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  9
]
1.04 ms
(2.00%)
3
SELECT t0.id AS id_1, t0.email_site AS email_site_2, t0.image AS image_3, t0.lien_carte AS lien_carte_4, t0.apercu_image_lien AS apercu_image_lien_5, t0.image_footer AS image_footer_6, t0.image_bandeau AS image_bandeau_7, t0.tel AS tel_8, t0.image_vide AS image_vide_9, t0.maintenance AS maintenance_10, t0.htaccess_val AS htaccess_val_11, t0.meta_index AS meta_index_12, t0.meta_follow AS meta_follow_13, t0.robots AS robots_14, t0.analytics AS analytics_15, t0.cle_key AS cle_key_16, t0.cle_secret AS cle_secret_17, t0.tag_managerhead AS tag_managerhead_18, t0.meta_keywords AS meta_keywords_19, t0.cle_map AS cle_map_20, t0.active_smtp AS active_smtp_21, t0.email_from AS email_from_22, t0.email_sender AS email_sender_23, t0.host_smtp AS host_smtp_24, t0.type_cryptage AS type_cryptage_25, t0.port_tls AS port_tls_26, t0.port_ssl AS port_ssl_27, t0.smtp_user AS smtp_user_28, t0.smtp_pass AS smtp_pass_29, t0.typeLienErrorPage AS typeLienErrorPage_30, t0.lienExterneErrorPage AS lienExterneErrorPage_31, t0.telephoneErrorPage AS telephoneErrorPage_32, t0.domain_api_hrz AS domain_api_hrz_33, t0.token_api_hrz AS token_api_hrz_34, t0.actif_auth_gmail AS actif_auth_gmail_35, t0.id_client_auth AS id_client_auth_36, t0.secret_client_auth AS secret_client_auth_37, t0.IdSite AS IdSite_38 FROM parametre_site t0 WHERE t0.IdSite = ? LIMIT 1
Parameters:
[
  "1"
]
1.02 ms
(1.96%)
1
SELECT t0.id AS id_1, t0.category_id AS category_id_2, t0.post_id AS post_id_3 FROM post_category t0 WHERE t0.post_id = ?
Parameters:
[
  96
]
1.02 ms
(1.96%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.system_name AS system_name_3, t0.enable_seo_blocks AS enable_seo_blocks_4, t0.enable_menu_link AS enable_menu_link_5, t0.categorie AS categorie_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM post_type_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  4
]
0.99 ms
(1.91%)
1
SELECT t0.id AS id_1, t0.Titre AS Titre_2, t0.slogan AS slogan_3, t0.referencement_site AS referencement_site_4, t0.caption_cms AS caption_cms_5, t0.slug_url AS slug_url_6, t0.copyright_site AS copyright_site_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.meta_keywords AS meta_keywords_10, t0.titreErrorPage AS titreErrorPage_11, t0.texteErrorPage AS texteErrorPage_12, t0.titreLienErrorPage AS titreLienErrorPage_13, t0.lienInterneErrorPage AS lienInterneErrorPage_14, t0.locale AS locale_15, t0.translatable_id AS translatable_id_16 FROM parametre_site_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  4
]
0.97 ms
(1.88%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.twig AS twig_3, t0.type AS type_4, t0.image AS image_5, t0.dateCreation AS dateCreation_6, t0.dateModification AS dateModification_7 FROM model_gallerie t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.97 ms
(1.87%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.actif AS actif_3, t0.activite_primaire_ids AS activite_primaire_ids_4, t0.activite_secondaire_ids AS activite_secondaire_ids_5, t0.tag_managerhead AS tag_managerhead_6, t0.tag_managerbody AS tag_managerbody_7, t0.DateCreation AS DateCreation_8, t0.DateModification AS DateModification_9 FROM secteurs t0 WHERE t0.actif = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
0.96 ms
(1.85%)
1
SELECT c0_.id AS id_0 FROM post_category p1_ INNER JOIN category c0_ ON p1_.category_id = c0_.id INNER JOIN post p2_ ON p1_.post_id = p2_.id WHERE p2_.id = ?
Parameters:
[
  96
]
0.93 ms
(1.78%)
1
SELECT p0_.id AS id_0, p0_.position AS position_1, p0_.authorization_api AS authorization_api_2, p0_.actif_home AS actif_home_3, p0_.post_archive AS post_archive_4, p0_.date_archive AS date_archive_5, p0_.image AS image_6, p0_.url_video AS url_video_7, p0_.image_bandeau AS image_bandeau_8, p0_.image_bandeau_height AS image_bandeau_height_9, p0_.image_couverture AS image_couverture_10, p0_.tag_managerhead AS tag_managerhead_11, p0_.tag_managerbody AS tag_managerbody_12, p0_.date_publication AS date_publication_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.id_activite AS id_activite_16, p0_.id_sous_activite AS id_sous_activite_17, p0_.id_secteur AS id_secteur_18, p0_.type_page_ref AS type_page_ref_19, p0_.author_id AS author_id_20, p0_.type_post AS type_post_21, p0_.template_cms_id AS template_cms_id_22, p0_.modele_gallerie_id AS modele_gallerie_id_23 FROM post p0_ INNER JOIN post_translation p1_ ON p0_.id = p1_.translatable_id INNER JOIN post_category p2_ ON p0_.id = p2_.post_id WHERE p1_.actif = 1 AND p0_.id <> ? AND p2_.category_id IN (?) AND p1_.locale = ? AND p0_.id > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[
  96
  []
  "fr"
  96
]
0.91 ms
(1.74%)
2
SELECT t0.actif AS actif_1, t0.id AS id_2, t0.backgound_color AS backgound_color_3, t0.color AS color_4, t0.type_lien AS type_lien_5, t0.lien_interne AS lien_interne_6, t0.lien_externe AS lien_externe_7, t0.telephone AS telephone_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM param_publicite t0 WHERE t0.actif = ? AND t0.id = ? LIMIT 1
Parameters:
[
  1
  1
]
0.82 ms
(1.58%)
2
SELECT c0_.id AS id_0, c0_.adresse AS adresse_1, c0_.code_postal AS code_postal_2, c0_.ville AS ville_3, c0_.region AS region_4, c0_.pays AS pays_5, c0_.latitude AS latitude_6, c0_.longitude AS longitude_7, c0_.lien_map AS lien_map_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.actif AS actif_11, c0_.actif_horaire_contact AS actif_horaire_contact_12, c0_.actif_horaire_complete AS actif_horaire_complete_13, c0_.actif_coordonnees_contact AS actif_coordonnees_contact_14 FROM contact c0_ WHERE c0_.actif = 1 ORDER BY c0_.id ASC
Parameters:
[]
0.82 ms
(1.57%)
1
SELECT t0.id AS id_1, t0.DateCreation AS DateCreation_2, t0.DateModification AS DateModification_3, t0.text_value AS text_value_4, t0.textarea_value AS textarea_value_5, t0.link_value AS link_value_6, t0.checkboxValue AS checkboxValue_7, t0.radio_value AS radio_value_8, t0.image_value AS image_value_9, t0.dateValue AS dateValue_10, t0.id_post AS id_post_11, t0.IdField AS IdField_12 FROM cp_post_field t0 WHERE t0.id_post = ?
Parameters:
[
  96
]
0.81 ms
(1.56%)
1
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.lien_param_ref AS lien_param_ref_3, t0.nombre_jour_generer AS nombre_jour_generer_4, t0.image_bandeau AS image_bandeau_5, t0.nb_secteur AS nb_secteur_6, t0.nb_activite AS nb_activite_7, t0.nb_maillage_secteur AS nb_maillage_secteur_8, t0.nb_maillage_activite AS nb_maillage_activite_9, t0.settig_meta_title_1 AS settig_meta_title_1_10, t0.settig_meta_title_2 AS settig_meta_title_2_11, t0.settig_meta_title_3 AS settig_meta_title_3_12, t0.settig_meta_desc_1 AS settig_meta_desc_1_13, t0.settig_meta_desc_2 AS settig_meta_desc_2_14, t0.settig_meta_desc_3 AS settig_meta_desc_3_15 FROM parametre_ref t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.80 ms
(1.53%)
1
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.image AS image_3, t0.color AS color_4, t0.DateCreation AS DateCreation_5, t0.DateModification AS DateModification_6, t0.bloc_service_id AS bloc_service_id_7 FROM bloc_service_items t0 WHERE t0.bloc_service_id = ?
Parameters:
[
  5
]
0.76 ms
(1.46%)
1
SELECT t0.id AS id_1, t0.image AS image_2, t0.order_product AS order_product_3, t0.position AS position_4, t0.DateCreation AS DateCreation_5, t0.DateModification AS DateModification_6 FROM categories_product t0 ORDER BY t0.position ASC
Parameters:
[]
0.75 ms
(1.44%)
1
SELECT t0.id AS id_1, t0.DateCreation AS DateCreation_2, t0.DateModification AS DateModification_3, t0.IdSite AS IdSite_4, t0.position AS position_5, t0.icon AS icon_6, t0.categorie_niveau AS categorie_niveau_7 FROM post_type t0 WHERE t0.id = ?
Parameters:
[
  4
]
0.72 ms
(1.38%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.url AS url_4, t0.IdSite AS IdSite_5 FROM reseau_sociaux t0
Parameters:
[]
0.69 ms
(1.33%)
1
SELECT p0_.id AS id_0, p0_.position AS position_1, p0_.authorization_api AS authorization_api_2, p0_.actif_home AS actif_home_3, p0_.post_archive AS post_archive_4, p0_.date_archive AS date_archive_5, p0_.image AS image_6, p0_.url_video AS url_video_7, p0_.image_bandeau AS image_bandeau_8, p0_.image_bandeau_height AS image_bandeau_height_9, p0_.image_couverture AS image_couverture_10, p0_.tag_managerhead AS tag_managerhead_11, p0_.tag_managerbody AS tag_managerbody_12, p0_.date_publication AS date_publication_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.id_activite AS id_activite_16, p0_.id_sous_activite AS id_sous_activite_17, p0_.id_secteur AS id_secteur_18, p0_.type_page_ref AS type_page_ref_19, p0_.author_id AS author_id_20, p0_.type_post AS type_post_21, p0_.template_cms_id AS template_cms_id_22, p0_.modele_gallerie_id AS modele_gallerie_id_23 FROM post p0_ INNER JOIN post_translation p1_ ON p0_.id = p1_.translatable_id INNER JOIN post_category p2_ ON p0_.id = p2_.post_id WHERE p1_.actif = 1 AND p0_.id <> ? AND p2_.category_id IN (?) AND p1_.locale = ? AND p0_.id < ? ORDER BY p0_.id DESC LIMIT 1
Parameters:
[
  96
  []
  "fr"
  96
]
0.65 ms
(1.26%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.actif AS actif_3, t0.tag_managerhead AS tag_managerhead_4, t0.tag_managerbody AS tag_managerbody_5, t0.DateCreation AS DateCreation_6, t0.DateModification AS DateModification_7 FROM activites t0 WHERE t0.id = ?
Parameters:
[
  "9"
]
0.39 ms
(0.76%)
2
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.url AS url_4, t0.IdSite AS IdSite_5 FROM reseau_sociaux t0 WHERE t0.IdSite = ?
Parameters:
[
  "1"
]
0.39 ms
(0.76%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.authorization_api AS authorization_api_3, t0.actif_home AS actif_home_4, t0.post_archive AS post_archive_5, t0.date_archive AS date_archive_6, t0.image AS image_7, t0.url_video AS url_video_8, t0.image_bandeau AS image_bandeau_9, t0.image_bandeau_height AS image_bandeau_height_10, t0.image_couverture AS image_couverture_11, t0.tag_managerhead AS tag_managerhead_12, t0.tag_managerbody AS tag_managerbody_13, t0.date_publication AS date_publication_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.id_activite AS id_activite_17, t0.id_sous_activite AS id_sous_activite_18, t0.id_secteur AS id_secteur_19, t0.type_page_ref AS type_page_ref_20, t0.author_id AS author_id_21, t0.type_post AS type_post_22, t0.template_cms_id AS template_cms_id_23, t0.modele_gallerie_id AS modele_gallerie_id_24 FROM post t0 WHERE t0.id = ?
Parameters:
[
  97
]

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\User No errors.
App\Entity\Redirection No errors.
App\Entity\Site No errors.
App\Entity\UrlPost No errors.
App\Entity\UrlPostTranslation No errors.
App\Entity\Post No errors.
App\Entity\PostTranslation No errors.
App\Entity\TypePost No errors.
App\Entity\CmsAffichage No errors.
App\Entity\ModelGallerie No errors.
App\Entity\PostCategory No errors.
App\Entity\Menu No errors.
App\Entity\Widget
  • The association App\Entity\Widget#type_affichage_home refers to the inverse side field App\Entity\PostAffichage#widget which does not exist.
App\Entity\CpPostField No errors.
App\Entity\PostBloc No errors.
App\Entity\ExportTraductions No errors.
App\Entity\ParametreSite No errors.
App\Entity\ParametreSiteTranslation No errors.
App\Entity\MediaGallery No errors.
App\Entity\Forms No errors.
App\Entity\ParametrePost No errors.
App\Entity\Category
  • The association App\Entity\Category#modele_gallerie refers to the inverse side field App\Entity\ModelGallerie#category which does not exist.
App\Entity\TypePostTranslation No errors.
App\Entity\MediaCms No errors.
App\Entity\ReseauSociaux No errors.
App\Entity\CpField No errors.
App\Entity\Language No errors.
App\Entity\ThemeOptions No errors.
App\Entity\ListeMenu No errors.
App\Entity\ListeMenuTranslation No errors.
App\Entity\Contact No errors.
App\Entity\ContactTranslation No errors.
App\Entity\MenuTranslation No errors.
App\Entity\PostAffichage No errors.
App\Entity\CategoryBloc No errors.
App\Entity\CategoryTranslation No errors.
App\Entity\Activites No errors.
App\Entity\UrlRef No errors.
App\Entity\ActivitesTranslation No errors.
App\Entity\ParamPublicite No errors.
App\Entity\BlocService No errors.
App\Entity\BlocServiceItems No errors.
App\Entity\BlocServiceTranslation No errors.
App\Entity\BlocServiceItemsTranslation No errors.
App\Entity\TextParametrable No errors.
App\Entity\Email No errors.
App\Entity\Media No errors.
App\Entity\ModulesCookies No errors.
App\Entity\DefaultBloc No errors.
App\Entity\WidgetTranslation No errors.
App\Entity\PostBlocTranslation No errors.
App\Entity\ProductTranslation No errors.
App\Entity\CategoriesProductTranslation No errors.
App\Entity\MediaGalleryTranslation No errors.
App\Entity\FormsFields No errors.
App\Entity\FormsData No errors.
App\Entity\FormsTranslation No errors.
App\Entity\ParametrePostTranslation No errors.
App\Entity\MediaCmsTranslation No errors.
App\Entity\CpFieldTranslation No errors.
App\Entity\CategoryBlocTranslation No errors.
App\Entity\Secteurs No errors.
App\Entity\UrlRefTranslation No errors.
App\Entity\ParamPubliciteTranslation No errors.
App\Entity\CategoriesProduct No errors.
App\Entity\Product No errors.
App\Entity\ParametreRef No errors.
App\Entity\ParametreRefTranslation No errors.
App\Entity\SecteursTranslation No errors.