Query Metrics
157
Database Queries
40
Different statements
65.20 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
8.34 ms (12.79%) |
22 |
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:
[
29
]
|
6.81 ms (10.45%) |
12 |
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:
[
34
]
|
5.56 ms (8.53%) |
12 |
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.actif_haut AS actif_haut_3, t0.position AS position_4, t0.position_text AS position_text_5, t0.nombre_article AS nombre_article_6, t0.actif_slider AS actif_slider_7, t0.pagination AS pagination_8, t0.page_size AS page_size_9, t0.order_by AS order_by_10, t0.fixe_texte AS fixe_texte_11, t0.image AS image_12, t0.image_bandeau AS image_bandeau_13, t0.url_video AS url_video_14, t0.DateCreation AS DateCreation_15, t0.DateModification AS DateModification_16, t0.IdParent AS IdParent_17, t0.IdSousParent AS IdSousParent_18, t0.tag_managerhead AS tag_managerhead_19, t0.meta_keywords AS meta_keywords_20, t0.meta_robots AS meta_robots_21, t0.multi_affichage AS multi_affichage_22, t0.id_import_categorie AS id_import_categorie_23, t0.date_import AS date_import_24, t0.IdSite AS IdSite_25, t0.id_type_post AS id_type_post_26, t0.IdPostAffichage AS IdPostAffichage_27, t0.modele_gallerie_id AS modele_gallerie_id_28 FROM category t0 WHERE t0.id = ?
Parameters:
[
34
]
|
5.00 ms (7.66%) |
8 |
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:
[
393
]
|
2.80 ms (4.30%) |
15 |
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 = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
1
]
|
2.51 ms (3.85%) |
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_.IdSousSousCategory AS IdSousSousCategory_15, m0_.IdPost AS IdPost_16 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.31 ms (3.54%) |
4 |
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:
[ "/localite/blaye" 1 ] |
2.15 ms (3.29%) |
12 |
SELECT t0.id AS id_1, t0.actif_bar_serach AS actif_bar_serach_2, t0.actif_oscar AS actif_oscar_3, t0.actif_titre AS actif_titre_4, t0.email_site AS email_site_5, t0.image AS image_6, t0.lien_carte AS lien_carte_7, t0.apercu_image_lien AS apercu_image_lien_8, t0.image_header AS image_header_9, t0.image_footer AS image_footer_10, t0.image_bandeau AS image_bandeau_11, t0.tel AS tel_12, t0.image_vide AS image_vide_13, t0.maintenance AS maintenance_14, t0.htaccess_val AS htaccess_val_15, t0.meta_index AS meta_index_16, t0.meta_follow AS meta_follow_17, t0.robots AS robots_18, t0.analytics AS analytics_19, t0.cle_key AS cle_key_20, t0.cle_secret AS cle_secret_21, t0.tag_managerhead AS tag_managerhead_22, t0.meta_keywords AS meta_keywords_23, t0.cle_map AS cle_map_24, t0.active_smtp AS active_smtp_25, t0.email_from AS email_from_26, t0.email_sender AS email_sender_27, t0.host_smtp AS host_smtp_28, t0.type_cryptage AS type_cryptage_29, t0.port_tls AS port_tls_30, t0.port_ssl AS port_ssl_31, t0.smtp_user AS smtp_user_32, t0.smtp_pass AS smtp_pass_33, t0.typeLienErrorPage AS typeLienErrorPage_34, t0.lienExterneErrorPage AS lienExterneErrorPage_35, t0.telephoneErrorPage AS telephoneErrorPage_36, t0.domain_api_hrz AS domain_api_hrz_37, t0.token_api_hrz AS token_api_hrz_38, t0.actif_auth_gmail AS actif_auth_gmail_39, t0.id_client_auth AS id_client_auth_40, t0.secret_client_auth AS secret_client_auth_41, t0.id_matomo AS id_matomo_42, t0.code_head AS code_head_43, t0.code_body AS code_body_44, t0.google_verification AS google_verification_45, t0.IdSite AS IdSite_46 FROM parametre_site t0 WHERE t0.IdSite = ? LIMIT 1
Parameters:
[
"1"
]
|
2.10 ms (3.21%) |
1 |
SELECT u0_.locale AS locale_0 FROM url_post u1_ INNER JOIN url_post_translation u0_ ON u1_.id = u0_.translatable_id WHERE u0_.slug = ? LIMIT 1
Parameters:
[
"blaye"
]
|
2.06 ms (3.16%) |
4 |
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.position AS position_3, t0.authorization_api AS authorization_api_4, t0.actif_home AS actif_home_5, t0.post_archive AS post_archive_6, t0.date_archive AS date_archive_7, t0.image AS image_8, t0.url_video AS url_video_9, t0.image_bandeau AS image_bandeau_10, t0.image_bandeau_height AS image_bandeau_height_11, t0.image_couverture AS image_couverture_12, t0.tag_managerhead AS tag_managerhead_13, t0.tag_managerbody AS tag_managerbody_14, t0.default_categorie AS default_categorie_15, t0.date_publication AS date_publication_16, t0.date_import AS date_import_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id_activite AS id_activite_20, t0.id_sous_activite AS id_sous_activite_21, t0.id_secteur AS id_secteur_22, t0.type_page_ref AS type_page_ref_23, t0.disponibilite_produit AS disponibilite_produit_24, t0.prix_produit AS prix_produit_25, t0.referance_produit AS referance_produit_26, t0.position_image AS position_image_27, t0.id_import_categorie_old AS id_import_categorie_old_28, t0.old_id_import AS old_id_import_29, t0.module_import AS module_import_30, t0.posts_associes AS posts_associes_31, t0.posts_associes_autres_types AS posts_associes_autres_types_32, t0.author_id AS author_id_33, t0.type_post AS type_post_34, t0.template_cms_id AS template_cms_id_35, t0.modele_gallerie_id AS modele_gallerie_id_36 FROM post t0 WHERE t0.id = ?
Parameters:
[
91
]
|
2.06 ms (3.16%) |
9 |
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.actif_haut AS actif_haut_3, t0.position AS position_4, t0.position_text AS position_text_5, t0.nombre_article AS nombre_article_6, t0.actif_slider AS actif_slider_7, t0.pagination AS pagination_8, t0.page_size AS page_size_9, t0.order_by AS order_by_10, t0.fixe_texte AS fixe_texte_11, t0.image AS image_12, t0.image_bandeau AS image_bandeau_13, t0.url_video AS url_video_14, t0.DateCreation AS DateCreation_15, t0.DateModification AS DateModification_16, t0.IdParent AS IdParent_17, t0.IdSousParent AS IdSousParent_18, t0.tag_managerhead AS tag_managerhead_19, t0.meta_keywords AS meta_keywords_20, t0.meta_robots AS meta_robots_21, t0.multi_affichage AS multi_affichage_22, t0.id_import_categorie AS id_import_categorie_23, t0.date_import AS date_import_24, t0.IdSite AS IdSite_25, t0.id_type_post AS id_type_post_26, t0.IdPostAffichage AS IdPostAffichage_27, t0.modele_gallerie_id AS modele_gallerie_id_28 FROM category t0 WHERE t0.actif = ? AND t0.id = ? LIMIT 1
Parameters:
[ 1 34 ] |
1.99 ms (3.06%) |
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_home_text_color AS header_home_text_color_51, t0.header_home_text_color_hover AS header_home_text_color_hover_52, t0.header_top_text_color AS header_top_text_color_53, t0.header_top_text_color_hover AS header_top_text_color_hover_54, t0.header_bg_transparent AS header_bg_transparent_55, t0.header_top_bg_transparent AS header_top_bg_transparent_56, t0.actif_pictos_info AS actif_pictos_info_57, t0.actif_icones_navigation AS actif_icones_navigation_58, t0.show_reseaux_sociaux AS show_reseaux_sociaux_59, t0.actif_tel1 AS actif_tel1_60, t0.actif_tel2 AS actif_tel2_61, t0.actif_email1 AS actif_email1_62, t0.actif_email2 AS actif_email2_63, t0.actif_adresse1 AS actif_adresse1_64, t0.actif_adresse2 AS actif_adresse2_65, t0.actif_horaires1 AS actif_horaires1_66, t0.actif_horaires2 AS actif_horaires2_67, t0.actif_titre_tel1 AS actif_titre_tel1_68, t0.actif_titre_tel2 AS actif_titre_tel2_69, t0.actif_titre_email1 AS actif_titre_email1_70, t0.actif_titre_email2 AS actif_titre_email2_71, t0.actif_titre_adresse1 AS actif_titre_adresse1_72, t0.actif_titre_adresse2 AS actif_titre_adresse2_73, t0.actif_titre_horaires1 AS actif_titre_horaires1_74, t0.actif_titre_horaires2 AS actif_titre_horaires2_75, t0.actif_reseaux_sociaux AS actif_reseaux_sociaux_76, t0.actif_bouton1 AS actif_bouton1_77, t0.position_bouton1 AS position_bouton1_78, t0.actif_bouton2 AS actif_bouton2_79, t0.position_bouton2 AS position_bouton2_80, t0.actif_bouton3 AS actif_bouton3_81, t0.position_bouton3 AS position_bouton3_82, t0.couleur_text_bouton1 AS couleur_text_bouton1_83, t0.couleur_text_bouton1_hover AS couleur_text_bouton1_hover_84, t0.bg_bouton1 AS bg_bouton1_85, t0.bg_bouton1_hover AS bg_bouton1_hover_86, t0.couleur_text_bouton2 AS couleur_text_bouton2_87, t0.couleur_text_bouton2_hover AS couleur_text_bouton2_hover_88, t0.bg_bouton2 AS bg_bouton2_89, t0.bg_bouton2_hover AS bg_bouton2_hover_90, t0.couleur_text_bouton3 AS couleur_text_bouton3_91, t0.couleur_text_bouton3_hover AS couleur_text_bouton3_hover_92, t0.bg_bouton3 AS bg_bouton3_93, t0.bg_bouton3_hover AS bg_bouton3_hover_94, t0.couleur_infos_header AS couleur_infos_header_95, t0.couleur_infos_header_hover AS couleur_infos_header_hover_96, t0.couleur_pictos_header AS couleur_pictos_header_97, t0.bg_infos_header AS bg_infos_header_98, t0.actif_logo_footer AS actif_logo_footer_99, t0.position_logo_footer AS position_logo_footer_100, t0.actif_pictos_info_footer AS actif_pictos_info_footer_101, t0.actif_tel_footer AS actif_tel_footer_102, t0.actif_email_footer AS actif_email_footer_103, t0.actif_adresse_footer AS actif_adresse_footer_104, t0.actif_horaires_footer AS actif_horaires_footer_105, t0.actif_titre_tel_footer AS actif_titre_tel_footer_106, t0.actif_titre_email_footer AS actif_titre_email_footer_107, t0.actif_titre_adresse_footer AS actif_titre_adresse_footer_108, t0.actif_titre_horaires_footer AS actif_titre_horaires_footer_109, t0.actif_reseaux_sociaux_footer AS actif_reseaux_sociaux_footer_110, t0.actif_bouton1_footer AS actif_bouton1_footer_111, t0.actif_codeqr_footer AS actif_codeqr_footer_112, t0.actif_texte_footer AS actif_texte_footer_113, t0.nbr_contacts_footer AS nbr_contacts_footer_114, t0.nbr_contacts_header AS nbr_contacts_header_115, t0.actif_logo_copyright AS actif_logo_copyright_116, t0.actif_date_copyright AS actif_date_copyright_117, t0.bg_color_top_footer AS bg_color_top_footer_118, t0.color_top_footer AS color_top_footer_119, t0.color_top_footer_hover AS color_top_footer_hover_120, t0.bg_color_sub_footer AS bg_color_sub_footer_121, t0.color_sub_footer AS color_sub_footer_122, t0.actif_recherche AS actif_recherche_123, t0.position_recherche AS position_recherche_124, t0.actif_panier AS actif_panier_125, t0.DateCreation AS DateCreation_126, t0.DateModification AS DateModification_127 FROM theme_options t0 WHERE t0.theme = ? LIMIT 1
Parameters:
[
"theme1"
]
|
1.45 ms (2.22%) |
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.35 ms (2.07%) |
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.34 ms (2.05%) |
3 |
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:
[
26
]
|
1.31 ms (2.01%) |
2 |
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.position AS position_3, t0.authorization_api AS authorization_api_4, t0.actif_home AS actif_home_5, t0.post_archive AS post_archive_6, t0.date_archive AS date_archive_7, t0.image AS image_8, t0.url_video AS url_video_9, t0.image_bandeau AS image_bandeau_10, t0.image_bandeau_height AS image_bandeau_height_11, t0.image_couverture AS image_couverture_12, t0.tag_managerhead AS tag_managerhead_13, t0.tag_managerbody AS tag_managerbody_14, t0.default_categorie AS default_categorie_15, t0.date_publication AS date_publication_16, t0.date_import AS date_import_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id_activite AS id_activite_20, t0.id_sous_activite AS id_sous_activite_21, t0.id_secteur AS id_secteur_22, t0.type_page_ref AS type_page_ref_23, t0.disponibilite_produit AS disponibilite_produit_24, t0.prix_produit AS prix_produit_25, t0.referance_produit AS referance_produit_26, t0.position_image AS position_image_27, t0.id_import_categorie_old AS id_import_categorie_old_28, t0.old_id_import AS old_id_import_29, t0.module_import AS module_import_30, t0.posts_associes AS posts_associes_31, t0.posts_associes_autres_types AS posts_associes_autres_types_32, t0.author_id AS author_id_33, t0.type_post AS type_post_34, t0.template_cms_id AS template_cms_id_35, t0.modele_gallerie_id AS modele_gallerie_id_36 FROM post t0 WHERE t0.type_page_ref = ? AND t0.id_secteur = ?
Parameters:
[ "activite" 2 ] |
1.30 ms (1.99%) |
3 |
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
]
|
1.14 ms (1.74%) |
3 |
SELECT t0.id AS id_1, t0.DateCreation AS DateCreation_2, t0.DateModification AS DateModification_3, t0.IdSite AS IdSite_4, t0.create_index AS create_index_5, t0.filter_categorie AS filter_categorie_6, t0.posts_associes_autres_types AS posts_associes_autres_types_7, t0.position AS position_8, t0.icon AS icon_9, t0.categorie_niveau AS categorie_niveau_10 FROM post_type t0 WHERE t0.id = ?
Parameters:
[
4
]
|
1.06 ms (1.62%) |
2 |
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.actif AS actif_2, s0_.activite_primaire_ids AS activite_primaire_ids_3, s0_.activite_secondaire_ids AS activite_secondaire_ids_4, s0_.tag_managerhead AS tag_managerhead_5, s0_.tag_managerbody AS tag_managerbody_6, s0_.DateCreation AS DateCreation_7, s0_.DateModification AS DateModification_8 FROM secteurs s0_ INNER JOIN secteurs_translation s1_ ON s0_.id = s1_.translatable_id WHERE s1_.locale = ? AND s0_.actif = 1 AND s1_.libelle_url = ?
Parameters:
[ "fr" "blaye" ] |
1.04 ms (1.59%) |
1 |
SELECT p0_.id AS id_0, p0_.alias AS alias_1, p0_.position AS position_2, p0_.authorization_api AS authorization_api_3, p0_.actif_home AS actif_home_4, p0_.post_archive AS post_archive_5, p0_.date_archive AS date_archive_6, p0_.image AS image_7, p0_.url_video AS url_video_8, p0_.image_bandeau AS image_bandeau_9, p0_.image_bandeau_height AS image_bandeau_height_10, p0_.image_couverture AS image_couverture_11, p0_.tag_managerhead AS tag_managerhead_12, p0_.tag_managerbody AS tag_managerbody_13, p0_.default_categorie AS default_categorie_14, p0_.date_publication AS date_publication_15, p0_.date_import AS date_import_16, p0_.created_at AS created_at_17, p0_.updated_at AS updated_at_18, p0_.id_activite AS id_activite_19, p0_.id_sous_activite AS id_sous_activite_20, p0_.id_secteur AS id_secteur_21, p0_.type_page_ref AS type_page_ref_22, p0_.disponibilite_produit AS disponibilite_produit_23, p0_.prix_produit AS prix_produit_24, p0_.referance_produit AS referance_produit_25, p0_.position_image AS position_image_26, p0_.id_import_categorie_old AS id_import_categorie_old_27, p0_.old_id_import AS old_id_import_28, p0_.module_import AS module_import_29, p0_.posts_associes AS posts_associes_30, p0_.posts_associes_autres_types AS posts_associes_autres_types_31, p0_.author_id AS author_id_32, p0_.type_post AS type_post_33, p0_.template_cms_id AS template_cms_id_34, p0_.modele_gallerie_id AS modele_gallerie_id_35 FROM post p0_ INNER JOIN post_translation p1_ ON p0_.id = p1_.translatable_id WHERE p1_.locale = ? AND p1_.slug = ?
Parameters:
[ "fr" "Home" ] |
0.77 ms (1.18%) |
2 |
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.bg_image AS bg_image_3, t0.position AS position_4, t0.color AS color_5, t0.DateCreation AS DateCreation_6, t0.DateModification AS DateModification_7, t0.bloc_service_id AS bloc_service_id_8 FROM bloc_service_items t0 WHERE t0.bloc_service_id = ?
Parameters:
[
11
]
|
0.76 ms (1.17%) |
2 |
SELECT t0.id AS id_1, t0.cookies AS cookies_2, t0.google_maps AS google_maps_3, t0.google_maps_key AS google_maps_key_4, t0.google_tagmanager AS google_tagmanager_5, t0.code_google_tagmanager AS code_google_tagmanager_6, t0.google_typekit AS google_typekit_7, t0.google_typekit_id AS google_typekit_id_8, t0.google_analytics AS google_analytics_9, t0.google_analytics_id AS google_analytics_id_10, t0.google_adwords AS google_adwords_11, t0.code_google_adwords AS code_google_adwords_12, t0.facebook AS facebook_13, t0.code_partage_facebook AS code_partage_facebook_14, t0.facebook_likebox AS facebook_likebox_15, t0.code_partage_facebook_like AS code_partage_facebook_like_16, t0.linkedin AS linkedin_17, t0.code_linkedin AS code_linkedin_18, t0.twitter AS twitter_19, t0.code_twitter AS code_twitter_20, t0.twitter_cards AS twitter_cards_21, t0.twitter_timeline AS twitter_timeline_22, t0.code_twitter_timeline AS code_twitter_timeline_23, t0.google_recaptcha AS google_recaptcha_24, t0.youtube AS youtube_25, t0.message AS message_26, t0.label_close_button AS label_close_button_27, t0.label_custom_link AS label_custom_link_28, t0.label_privacy_policy_link AS label_privacy_policy_link_29, t0.privacy_policy_link AS privacy_policy_link_30, t0.view_service_management AS view_service_management_31, t0.position AS position_32, t0.background_color AS background_color_33, t0.color_cookie_link AS color_cookie_link_34, t0.color_ok_button AS color_ok_button_35, t0.IdSite AS IdSite_36 FROM modules_cookies t0 ORDER BY t0.id ASC LIMIT 1
Parameters:
[] |
0.70 ms (1.07%) |
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, c0_.type_lien AS type_lien_15, c0_.lien_interne AS lien_interne_16, c0_.lien_externe AS lien_externe_17, c0_.telephone AS telephone_18 FROM contact c0_ WHERE c0_.actif = 1 ORDER BY c0_.id ASC
Parameters:
[] |
0.68 ms (1.04%) |
2 |
SELECT p0_.id AS id_0, p0_.DateCreation AS DateCreation_1, p0_.DateModification AS DateModification_2, p0_.IdSite AS IdSite_3, p0_.create_index AS create_index_4, p0_.filter_categorie AS filter_categorie_5, p0_.posts_associes_autres_types AS posts_associes_autres_types_6, p0_.position AS position_7, p0_.icon AS icon_8, p0_.categorie_niveau AS categorie_niveau_9 FROM post_type p0_ INNER JOIN post_type_translation p1_ ON p0_.id = p1_.translatable_id WHERE p1_.locale = ? AND p1_.system_name = ?
Parameters:
[ "fr" "produits" ] |
0.67 ms (1.03%) |
1 |
SELECT d0_.id AS id_0, d0_.actif AS actif_1, d0_.actif_desktop AS actif_desktop_2, d0_.actif_mobile AS actif_mobile_3, d0_.position AS position_4, d0_.image AS image_5, d0_.bg_color AS bg_color_6, d0_.video_url AS video_url_7, d0_.position_text AS position_text_8, d0_.id_bloc_service AS id_bloc_service_9, d0_.type_bloc AS type_bloc_10, d0_.GroupBloc AS GroupBloc_11, d0_.grid_carousel AS grid_carousel_12, d0_.model_affichage_galeries AS model_affichage_galeries_13, d0_.ids_images_galeries AS ids_images_galeries_14, d0_.affichage_bloc AS affichage_bloc_15, d0_.is_deleted AS is_deleted_16, d0_.DateCreation AS DateCreation_17, d0_.DateModification AS DateModification_18, d0_.IdMedia AS IdMedia_19, d0_.IdForms AS IdForms_20, d0_.IdWidget AS IdWidget_21 FROM default_bloc d0_ WHERE d0_.actif = 1 AND (d0_.is_deleted IS NULL OR d0_.is_deleted = ?) ORDER BY d0_.position ASC
Parameters:
[
0
]
|
0.66 ms (1.02%) |
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.color_hover AS color_hover_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.position AS position_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM param_publicite t0 WHERE t0.actif = ? AND t0.id = ? LIMIT 1
Parameters:
[ 1 1 ] |
0.66 ms (1.01%) |
1 |
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.titre_adresse AS titre_adresse_5, t0.titre_horaires AS titre_horaires_6, t0.texte_contact AS texte_contact_7, t0.horaires_contact AS horaires_contact_8, t0.email AS email_9, t0.tel AS tel_10, t0.horaire_lun AS horaire_lun_11, t0.horaire_mard AS horaire_mard_12, t0.horaire_merc AS horaire_merc_13, t0.horaire_jeu AS horaire_jeu_14, t0.horaire_vend AS horaire_vend_15, t0.horaire_sam AS horaire_sam_16, t0.horaire_dim AS horaire_dim_17, t0.locale AS locale_18, t0.translatable_id AS translatable_id_19 FROM contact_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
3
]
|
0.64 ms (0.99%) |
2 |
SELECT t0.id AS id_1, t0.actif_panier AS actif_panier_2, t0.actif_prix_liste AS actif_prix_liste_3, t0.show_categories AS show_categories_4, t0.DateCreation AS DateCreation_5, t0.DateModification AS DateModification_6, t0.ordre_by AS ordre_by_7, t0.actif_social AS actif_social_8, t0.affiche_contact AS affiche_contact_9, t0.type_lien AS type_lien_10, t0.lien_externe AS lien_externe_11, t0.order_by AS order_by_12, t0.multi_affichage AS multi_affichage_13, t0.IdTypePost AS IdTypePost_14, t0.IdPostAffichage AS IdPostAffichage_15 FROM parametre_post t0 WHERE t0.IdTypePost = ? LIMIT 1
Parameters:
[
10
]
|
0.64 ms (0.98%) |
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.titreArticleAssocier AS titreArticleAssocier_15, t0.locale AS locale_16, t0.translatable_id AS translatable_id_17 FROM parametre_site_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
4
]
|
0.63 ms (0.96%) |
3 |
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 ORDER BY l0_.id ASC
Parameters:
[] |
0.61 ms (0.94%) |
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.58 ms (0.88%) |
1 |
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.position AS position_3, t0.authorization_api AS authorization_api_4, t0.actif_home AS actif_home_5, t0.post_archive AS post_archive_6, t0.date_archive AS date_archive_7, t0.image AS image_8, t0.url_video AS url_video_9, t0.image_bandeau AS image_bandeau_10, t0.image_bandeau_height AS image_bandeau_height_11, t0.image_couverture AS image_couverture_12, t0.tag_managerhead AS tag_managerhead_13, t0.tag_managerbody AS tag_managerbody_14, t0.default_categorie AS default_categorie_15, t0.date_publication AS date_publication_16, t0.date_import AS date_import_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id_activite AS id_activite_20, t0.id_sous_activite AS id_sous_activite_21, t0.id_secteur AS id_secteur_22, t0.type_page_ref AS type_page_ref_23, t0.disponibilite_produit AS disponibilite_produit_24, t0.prix_produit AS prix_produit_25, t0.referance_produit AS referance_produit_26, t0.position_image AS position_image_27, t0.id_import_categorie_old AS id_import_categorie_old_28, t0.old_id_import AS old_id_import_29, t0.module_import AS module_import_30, t0.posts_associes AS posts_associes_31, t0.posts_associes_autres_types AS posts_associes_autres_types_32, t0.author_id AS author_id_33, t0.type_post AS type_post_34, t0.template_cms_id AS template_cms_id_35, t0.modele_gallerie_id AS modele_gallerie_id_36 FROM post t0 WHERE t0.type_page_ref IS NULL AND t0.id_secteur = ?
Parameters:
[
2
]
|
0.56 ms (0.86%) |
2 |
SELECT u0_.slug AS slug_0, u1_.type AS type_1, u1_.id_module AS id_module_2 FROM url_post u1_ INNER JOIN url_post_translation u0_ ON u1_.id = u0_.translatable_id WHERE u1_.id = ? AND u0_.locale = ?
Parameters:
[ "1" "fr" ] |
0.52 ms (0.80%) |
1 |
SELECT t0.id AS id_1, t0.order_by AS order_by_2, t0.actif AS actif_3, t0.DateCreation AS DateCreation_4, t0.DateModification AS DateModification_5 FROM parametre_label_phrase t0 WHERE t0.actif = ?
Parameters:
[
1
]
|
0.48 ms (0.74%) |
1 |
SELECT t0.id AS id_1, t0.actif_map AS actif_map_2, t0.type_map AS type_map_3, t0.image_map AS image_map_4, t0.iframe_map AS iframe_map_5, t0.zoom_map AS zoom_map_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.actif_coordonnees AS actif_coordonnees_9 FROM param_contact t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.44 ms (0.68%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.titre_secteur AS titre_secteur_3, t0.libelle_url AS libelle_url_4, t0.text_generer_secteur AS text_generer_secteur_5, t0.text_generer_secteur_final AS text_generer_secteur_final_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.schema_script AS schema_script_10, t0.breadcrumb AS breadcrumb_11, t0.canonical_url AS canonical_url_12, t0.meta_robots AS meta_robots_13, t0.setting_meta_title AS setting_meta_title_14, t0.setting_meta_desc AS setting_meta_desc_15, t0.locale AS locale_16, t0.translatable_id AS translatable_id_17 FROM secteurs_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
2
]
|
0.44 ms (0.67%) |
1 |
SELECT t0.id AS id_1, t0.order_by AS order_by_2, t0.actif AS actif_3, t0.DateCreation AS DateCreation_4, t0.DateModification AS DateModification_5 FROM parametre_label t0 WHERE t0.actif = ?
Parameters:
[
1
]
|
0.41 ms (0.63%) |
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.40 ms (0.61%) |
1 |
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.alias AS alias_3, t0.lien_param_ref AS lien_param_ref_4, t0.nombre_jour_generer AS nombre_jour_generer_5, t0.image_bandeau AS image_bandeau_6, t0.nb_secteur AS nb_secteur_7, t0.nb_activite AS nb_activite_8, t0.nb_maillage_secteur AS nb_maillage_secteur_9, t0.nb_maillage_activite AS nb_maillage_activite_10 FROM parametre_ref t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"param_generale"
]
|
0.27 ms (0.42%) |
1 |
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.alias AS alias_3, t0.lien_param_ref AS lien_param_ref_4, t0.nombre_jour_generer AS nombre_jour_generer_5, t0.image_bandeau AS image_bandeau_6, t0.nb_secteur AS nb_secteur_7, t0.nb_activite AS nb_activite_8, t0.nb_maillage_secteur AS nb_maillage_secteur_9, t0.nb_maillage_activite AS nb_maillage_activite_10 FROM parametre_ref t0 ORDER BY t0.id ASC LIMIT 1
Parameters:
[] |
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\Secteurs | No errors. |
App\Entity\Language | No errors. |
App\Entity\SecteursTranslation | No errors. |
App\Entity\UrlRef | No errors. |
App\Entity\UrlPost | No errors. |
App\Entity\UrlPostTranslation | No errors. |
App\Entity\Post | 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 |
|
App\Entity\CpPostField | No errors. |
App\Entity\PostBloc | No errors. |
App\Entity\ProduitsInfo | No errors. |
App\Entity\PostTranslation | No errors. |
App\Entity\ExportTraductions | No errors. |
App\Entity\ParametreRef | No errors. |
App\Entity\ParametreRefTranslation | No errors. |
App\Entity\ParametreLabel | No errors. |
App\Entity\ParametreLabelTranslation | No errors. |
App\Entity\ParametreLabelPhrase | No errors. |
App\Entity\ParametreSite | No errors. |
App\Entity\ParametreSiteTranslation | 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\ReseauSociaux | No errors. |
App\Entity\MenuTranslation | No errors. |
App\Entity\Category |
|
App\Entity\ParametrePost | No errors. |
App\Entity\TypePostTranslation | No errors. |
App\Entity\PostAffichage | No errors. |
App\Entity\CategoryBloc | No errors. |
App\Entity\CategoryTranslation | 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\Activites | No errors. |
App\Entity\UrlRefTranslation | No errors. |
App\Entity\DefaultBloc | No errors. |
App\Entity\WidgetTranslation | No errors. |
App\Entity\CpField | No errors. |
App\Entity\MediaGallery | No errors. |
App\Entity\Forms | No errors. |
App\Entity\PostBlocTranslation | No errors. |
App\Entity\ProduitsInfoTranslation | No errors. |
App\Entity\ParametreLabelPhraseTranslation | No errors. |
App\Entity\ParametrePostTranslation | No errors. |
App\Entity\CategoryBlocTranslation | No errors. |
App\Entity\ParamPubliciteTranslation | No errors. |
App\Entity\TextParametrableTranslation | No errors. |
App\Entity\EmailTranslation | No errors. |
App\Entity\MediaTranslation | No errors. |
App\Entity\ActivitesTranslation | No errors. |
App\Entity\DefaultBlocTranslation | No errors. |
App\Entity\CpFieldTranslation | No errors. |
App\Entity\MediaGalleryTranslation | No errors. |
App\Entity\FormsFields | No errors. |
App\Entity\FormsData | No errors. |
App\Entity\FormsTranslation | No errors. |
App\Entity\ParamContact | No errors. |