Query Metrics
124
Database Queries
41
Different statements
22.19 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.38 ms (10.75%) |
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.id = ?
Parameters:
[
23
]
|
1.82 ms (8.22%) |
3 |
SELECT c0_.id AS id_0, c0_.actif AS actif_1, c0_.actif_haut AS actif_haut_2, c0_.position AS position_3, c0_.position_text AS position_text_4, c0_.nombre_article AS nombre_article_5, c0_.actif_slider AS actif_slider_6, c0_.pagination AS pagination_7, c0_.page_size AS page_size_8, c0_.order_by AS order_by_9, c0_.fixe_texte AS fixe_texte_10, c0_.image AS image_11, c0_.image_bandeau AS image_bandeau_12, c0_.url_video AS url_video_13, c0_.DateCreation AS DateCreation_14, c0_.DateModification AS DateModification_15, c0_.IdParent AS IdParent_16, c0_.IdSousParent AS IdSousParent_17, c0_.tag_managerhead AS tag_managerhead_18, c0_.meta_keywords AS meta_keywords_19, c0_.meta_robots AS meta_robots_20, c0_.multi_affichage AS multi_affichage_21, c0_.id_import_categorie AS id_import_categorie_22, c0_.date_import AS date_import_23, c0_.IdSite AS IdSite_24, c0_.id_type_post AS id_type_post_25, c0_.IdPostAffichage AS IdPostAffichage_26, c0_.modele_gallerie_id AS modele_gallerie_id_27 FROM category c0_ INNER JOIN category_translation c1_ ON c0_.id = c1_.translatable_id WHERE c1_.slug_url = ? AND c1_.locale = ?
Parameters:
[ "mobilier-pour-evenements-dans-la-region-de-toulouse" "fr" ] |
1.62 ms (7.32%) |
2 |
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" "chaises-tabourets-et-bancs" ] |
1.55 ms (6.98%) |
13 |
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:
[
36
]
|
1.50 ms (6.77%) |
19 |
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
]
|
1.42 ms (6.42%) |
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:
[ "/mobilier-pour-evenements-dans-la-region-de-toulouse/chaises-tabourets-et-bancs" 1 ] |
1.20 ms (5.40%) |
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:
[
"mobilier-pour-evenements-dans-la-region-de-toulouse"
]
|
1.17 ms (5.28%) |
3 |
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_.media_import AS media_import_11, m0_.width AS width_12, m0_.height AS height_13, m0_.filesize AS filesize_14, m0_.crop_width AS crop_width_15, m0_.crop_height AS crop_height_16, m0_.crop_x AS crop_x_17, m0_.crop_y AS crop_y_18, m0_.DateCreation AS DateCreation_19, m0_.DateModification AS DateModification_20 FROM media_cms m0_ WHERE m0_.module = ? AND m0_.module_id = ? AND m0_.type_media_post = ? ORDER BY m0_.position ASC
Parameters:
[ "category" 36 "media" ] |
0.99 ms (4.48%) |
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 INNER JOIN post_category p2_ ON p0_.id = p2_.post_id WHERE p1_.actif = 1 AND p2_.category_id IN (?) AND p1_.locale = ? ORDER BY p0_.date_publication DESC
Parameters:
[ [ 36 37 ] "fr" ] |
0.92 ms (4.16%) |
8 |
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 ORDER BY t0.id ASC LIMIT 1
Parameters:
[] |
0.82 ms (3.68%) |
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 ] |
0.73 ms (3.31%) |
9 |
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
]
|
0.69 ms (3.12%) |
1 |
SELECT c0_.id AS id_0, c0_.actif AS actif_1, c0_.actif_desktop AS actif_desktop_2, c0_.actif_mobile AS actif_mobile_3, c0_.type_bloc AS type_bloc_4, c0_.position AS position_5, c0_.image AS image_6, c0_.bg_color AS bg_color_7, c0_.video_url AS video_url_8, c0_.position_text AS position_text_9, c0_.grid_carousel AS grid_carousel_10, c0_.id_bloc_service AS id_bloc_service_11, c0_.DateCreation AS DateCreation_12, c0_.DateModification AS DateModification_13, c0_.is_deleted AS is_deleted_14, c0_.affichage_bloc AS affichage_bloc_15, c0_.model_affichage_galeries AS model_affichage_galeries_16, c0_.ids_images_galeries AS ids_images_galeries_17, c0_.IdForms AS IdForms_18, c0_.IdMedia AS IdMedia_19, c0_.IdWidget AS IdWidget_20, c0_.category_id AS category_id_21 FROM category_bloc c0_ INNER JOIN category c1_ ON c0_.category_id = c1_.id WHERE c1_.id = ? AND (c0_.is_deleted IS NULL OR c0_.is_deleted = ?) ORDER BY c0_.position ASC
Parameters:
[ 36 0 ] |
0.58 ms (2.62%) |
2 |
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.IdParent = ? ORDER BY t0.position ASC
Parameters:
[ 1 34 ] |
0.58 ms (2.62%) |
4 |
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:
[
1
]
|
0.55 ms (2.48%) |
5 |
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"
]
|
0.32 ms (1.44%) |
1 |
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.IdParent = ? AND t0.IdSousParent = ? AND t0.id_type_post = ?
Parameters:
[ 1 0 0 10 ] |
0.29 ms (1.33%) |
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:
[
10
]
|
0.29 ms (1.31%) |
3 |
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" ] |
0.28 ms (1.27%) |
1 |
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.IdParent = ? AND t0.IdSousParent = ? ORDER BY t0.position ASC
Parameters:
[ 1 0 36 ] |
0.23 ms (1.05%) |
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:
[
10
]
|
0.22 ms (0.98%) |
1 |
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"
]
|
0.19 ms (0.88%) |
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:
[
397
]
|
0.18 ms (0.81%) |
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.id = ?
Parameters:
[
91
]
|
0.16 ms (0.73%) |
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
Parameters:
[] |
0.13 ms (0.57%) |
1 |
SELECT t0.id AS id_1, t0.mot_metas AS mot_metas_2, t0.module_metas AS module_metas_3, t0.correspondant_metas AS correspondant_metas_4, t0.DateCreation AS DateCreation_5, t0.DateModification AS DateModification_6 FROM metas_cles t0
Parameters:
[] |
0.12 ms (0.55%) |
1 |
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" ] |
0.10 ms (0.43%) |
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.09 ms (0.43%) |
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.09 ms (0.42%) |
1 |
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
]
|
0.09 ms (0.42%) |
1 |
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.09 ms (0.41%) |
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.09 ms (0.40%) |
1 |
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.09 ms (0.39%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.label AS label_3, t0.description AS description_4, t0.icon_svg AS icon_svg_5, t0.css AS css_6, t0.twig AS twig_7, t0.icon AS icon_8, t0.type_affichage_home AS type_affichage_home_9, t0.DateCreation AS DateCreation_10, t0.DateModification AS DateModification_11, t0.IdSite AS IdSite_12 FROM post_affichage t0 WHERE t0.id = ?
Parameters:
[
5
]
|
0.09 ms (0.39%) |
1 |
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.09 ms (0.38%) |
1 |
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" ] |
0.08 ms (0.38%) |
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.08 ms (0.38%) |
1 |
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.08 ms (0.37%) |
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 WHERE t0.IdSite = ?
Parameters:
[
"1"
]
|
0.08 ms (0.34%) |
1 |
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.07 ms (0.33%) |
1 |
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:
[] |
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\Language | No errors. |
App\Entity\UrlPostTranslation | No errors. |
App\Entity\Category |
|
App\Entity\CategoryTranslation | No errors. |
App\Entity\TypePost | No errors. |
App\Entity\PostAffichage | No errors. |
App\Entity\ModelGallerie | No errors. |
App\Entity\PostCategory | No errors. |
App\Entity\Menu | No errors. |
App\Entity\CategoryBloc | No errors. |
App\Entity\Post | No errors. |
App\Entity\PostTranslation | No errors. |
App\Entity\CmsAffichage | No errors. |
App\Entity\ParametreLabel | No errors. |
App\Entity\ParametreLabelTranslation | No errors. |
App\Entity\MetasCles | No errors. |
App\Entity\ParametreSite | No errors. |
App\Entity\ParametreSiteTranslation | No errors. |
App\Entity\Widget |
|
App\Entity\CpPostField | No errors. |
App\Entity\PostBloc | No errors. |
App\Entity\ProduitsInfo | No errors. |
App\Entity\Forms | No errors. |
App\Entity\MediaGallery | No errors. |
App\Entity\ParametrePost | No errors. |
App\Entity\TypePostTranslation | No errors. |
App\Entity\MediaCms | No errors. |
App\Entity\ExportTraductions | No errors. |
App\Entity\ParametrePostTranslation | No errors. |
App\Entity\CpField | 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\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\CategoryBlocTranslation | No errors. |
App\Entity\DefaultBloc | No errors. |
App\Entity\WidgetTranslation | No errors. |
App\Entity\PostBlocTranslation | No errors. |
App\Entity\ProduitsInfoTranslation | No errors. |
App\Entity\FormsFields | No errors. |
App\Entity\FormsData | No errors. |
App\Entity\FormsTranslation | No errors. |
App\Entity\MediaGalleryTranslation | No errors. |
App\Entity\MediaCmsTranslation | No errors. |
App\Entity\CpFieldTranslation | No errors. |
App\Entity\ParamPubliciteTranslation | No errors. |