Query Metrics
316
Database Queries
14
Different statements
187.82 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
145.68 ms (77.57%) |
249 |
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.show_resume AS show_resume_3, t0.title AS title_4, t0.title_affichage AS title_affichage_5, t0.slug AS slug_6, t0.old_slug AS old_slug_7, t0.summary AS summary_8, t0.content AS content_9, t0.content2 AS content2_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keys AS meta_keys_13, t0.script_sc AS script_sc_14, t0.breadcrumb AS breadcrumb_15, t0.canonical AS canonical_16, t0.meta_robots AS meta_robots_17, t0.settig_metaTitle AS settig_metaTitle_18, t0.settig_metaDesc AS settig_metaDesc_19, t0.traduite AS traduite_20, t0.image_alt AS image_alt_21, t0.image_bandeau_alt AS image_bandeau_alt_22, t0.image_couverture_alt AS image_couverture_alt_23, t0.titre_lien AS titre_lien_24, t0.type_lien AS type_lien_25, t0.lien_interne AS lien_interne_26, t0.lien_externe AS lien_externe_27, t0.telephone AS telephone_28, t0.data_champs_personalizer AS data_champs_personalizer_29, t0.locale AS locale_30, t0.export_traductions_id AS export_traductions_id_31, t0.translatable_id AS translatable_id_32 FROM post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
39
]
|
15.29 ms (8.14%) |
26 |
SELECT t0.id AS id_1, t0.titre_categorie AS titre_categorie_2, t0.show_resume AS show_resume_3, t0.titre_categorie_from_menu AS titre_categorie_from_menu_4, t0.slug_url AS slug_url_5, t0.old_slug AS old_slug_6, t0.chapeau_categorie AS chapeau_categorie_7, t0.texte_categorie AS texte_categorie_8, t0.texte_categorie2 AS texte_categorie2_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.meta_keywords AS meta_keywords_12, t0.canonical AS canonical_13, t0.settig_metaTitle AS settig_metaTitle_14, t0.settig_metaTitle1 AS settig_metaTitle1_15, t0.settig_metaTitle2 AS settig_metaTitle2_16, t0.settig_metaTitle3 AS settig_metaTitle3_17, t0.settig_metaTitle_post AS settig_metaTitle_post_18, t0.settig_metaDesc AS settig_metaDesc_19, t0.settig_metaDesc1 AS settig_metaDesc1_20, t0.settig_metaDesc2 AS settig_metaDesc2_21, t0.settig_metaDesc3 AS settig_metaDesc3_22, t0.settig_metaDesc_post AS settig_metaDesc_post_23, t0.titre_lien AS titre_lien_24, t0.type_lien AS type_lien_25, t0.lien_interne AS lien_interne_26, t0.lien_externe AS lien_externe_27, t0.telephone AS telephone_28, t0.alt_image AS alt_image_29, t0.alt_image_bandeau AS alt_image_bandeau_30, t0.titre_affichage_categorie AS titre_affichage_categorie_31, t0.locale AS locale_32, t0.translatable_id AS translatable_id_33 FROM category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
6.08 ms (3.24%) |
1 |
SELECT t0.id AS id_1, t0.oscar_rocket AS oscar_rocket_2, t0.id_oscar_rocket AS id_oscar_rocket_3, t0.alias AS alias_4, t0.position AS position_5, t0.authorization_api AS authorization_api_6, t0.actif_home AS actif_home_7, t0.post_archive AS post_archive_8, t0.date_archive AS date_archive_9, t0.image AS image_10, t0.url_video AS url_video_11, t0.image_bandeau AS image_bandeau_12, t0.image_bandeau_height AS image_bandeau_height_13, t0.image_couverture AS image_couverture_14, t0.tag_managerhead AS tag_managerhead_15, t0.tag_managerbody AS tag_managerbody_16, t0.default_categorie AS default_categorie_17, t0.date_publication AS date_publication_18, t0.date_import AS date_import_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.date_update_ref AS date_update_ref_22, t0.id_activite AS id_activite_23, t0.id_sous_activite AS id_sous_activite_24, t0.id_secteur AS id_secteur_25, t0.type_page_ref AS type_page_ref_26, t0.disponibilite_produit AS disponibilite_produit_27, t0.prix_produit AS prix_produit_28, t0.referance_produit AS referance_produit_29, t0.position_image AS position_image_30, t0.id_import_categorie_old AS id_import_categorie_old_31, t0.old_id_import AS old_id_import_32, t0.module_import AS module_import_33, t0.posts_associes AS posts_associes_34, t0.posts_associes_autres_types AS posts_associes_autres_types_35, t0.data_module_biens AS data_module_biens_36, t0.tags AS tags_37, t0.custom_style AS custom_style_38, t0.author_id AS author_id_39, t0.type_post AS type_post_40, t0.template_cms_id AS template_cms_id_41, t0.modele_gallerie_id AS modele_gallerie_id_42 FROM post t0 ORDER BY t0.created_at ASC
Parameters:
[] |
4.13 ms (2.20%) |
10 |
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
]
|
3.64 ms (1.94%) |
10 |
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
]
|
3.47 ms (1.85%) |
6 |
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.tags AS tags_25, t0.custom_style AS custom_style_26, t0.IdSite AS IdSite_27, t0.id_type_post AS id_type_post_28, t0.IdPostAffichage AS IdPostAffichage_29, t0.modele_gallerie_id AS modele_gallerie_id_30 FROM category t0 WHERE t0.actif = ? AND t0.IdParent = ? AND t0.IdSousParent = ?
Parameters:
[ 1 0 18 ] |
1.88 ms (1.00%) |
3 |
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.tags AS tags_25, t0.custom_style AS custom_style_26, t0.IdSite AS IdSite_27, t0.id_type_post AS id_type_post_28, t0.IdPostAffichage AS IdPostAffichage_29, t0.modele_gallerie_id AS modele_gallerie_id_30 FROM category t0 WHERE t0.actif = ? AND t0.IdParent = ?
Parameters:
[ 1 16 ] |
1.58 ms (0.84%) |
5 |
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:
[] |
1.50 ms (0.80%) |
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.tags AS tags_25, t0.custom_style AS custom_style_26, t0.IdSite AS IdSite_27, t0.id_type_post AS id_type_post_28, t0.IdPostAffichage AS IdPostAffichage_29, t0.modele_gallerie_id AS modele_gallerie_id_30 FROM category t0 WHERE t0.actif = ? AND t0.IdParent = ? AND t0.IdSousParent = ? ORDER BY t0.DateCreation ASC
Parameters:
[ 1 0 0 ] |
1.35 ms (0.72%) |
1 |
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:
[ "/sitemap/sitemap.xml" 1 ] |
1.10 ms (0.59%) |
1 |
SELECT p0_.id AS id_0, p0_.oscar_rocket AS oscar_rocket_1, p0_.id_oscar_rocket AS id_oscar_rocket_2, p0_.alias AS alias_3, p0_.position AS position_4, p0_.authorization_api AS authorization_api_5, p0_.actif_home AS actif_home_6, p0_.post_archive AS post_archive_7, p0_.date_archive AS date_archive_8, p0_.image AS image_9, p0_.url_video AS url_video_10, p0_.image_bandeau AS image_bandeau_11, p0_.image_bandeau_height AS image_bandeau_height_12, p0_.image_couverture AS image_couverture_13, p0_.tag_managerhead AS tag_managerhead_14, p0_.tag_managerbody AS tag_managerbody_15, p0_.default_categorie AS default_categorie_16, p0_.date_publication AS date_publication_17, p0_.date_import AS date_import_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, p0_.date_update_ref AS date_update_ref_21, p0_.id_activite AS id_activite_22, p0_.id_sous_activite AS id_sous_activite_23, p0_.id_secteur AS id_secteur_24, p0_.type_page_ref AS type_page_ref_25, p0_.disponibilite_produit AS disponibilite_produit_26, p0_.prix_produit AS prix_produit_27, p0_.referance_produit AS referance_produit_28, p0_.position_image AS position_image_29, p0_.id_import_categorie_old AS id_import_categorie_old_30, p0_.old_id_import AS old_id_import_31, p0_.module_import AS module_import_32, p0_.posts_associes AS posts_associes_33, p0_.posts_associes_autres_types AS posts_associes_autres_types_34, p0_.data_module_biens AS data_module_biens_35, p0_.tags AS tags_36, p0_.custom_style AS custom_style_37, p0_.author_id AS author_id_38, p0_.type_post AS type_post_39, p0_.template_cms_id AS template_cms_id_40, p0_.modele_gallerie_id AS modele_gallerie_id_41 FROM post p0_ INNER JOIN post_type p1_ ON p0_.type_post = p1_.id INNER JOIN post_type_translation p2_ ON p1_.id = p2_.translatable_id INNER JOIN post_translation p3_ ON p0_.id = p3_.translatable_id WHERE p3_.actif = 1 AND p2_.system_name = ? AND p2_.locale = ?
Parameters:
[ "produits" "fr" ] |
0.97 ms (0.52%) |
1 |
SELECT t0.id AS id_1, t0.folder_media AS folder_media_2, t0.position AS position_3, t0.actif AS actif_4, t0.afficher_home AS afficher_home_5, t0.image AS image_6, t0.folder_image AS folder_image_7, t0.tag_managerhead AS tag_managerhead_8, t0.tag_managerbody AS tag_managerbody_9, t0.DateCreation AS DateCreation_10, t0.DateModification AS DateModification_11 FROM activites t0 WHERE t0.actif = ? ORDER BY t0.DateCreation ASC
Parameters:
[
1
]
|
0.94 ms (0.50%) |
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 = ?
Parameters:
[
1
]
|
0.19 ms (0.10%) |
1 |
SELECT t0.id AS id_1, t0.actif_replace_mot_cle AS actif_replace_mot_cle_2, t0.actif_bar_serach AS actif_bar_serach_3, t0.actif_oscar AS actif_oscar_4, t0.actif_data_hrz AS actif_data_hrz_5, t0.actif_titre AS actif_titre_6, t0.email_site AS email_site_7, t0.image AS image_8, t0.lien_carte AS lien_carte_9, t0.apercu_image_lien AS apercu_image_lien_10, t0.image_header AS image_header_11, t0.image_footer AS image_footer_12, t0.image_bandeau AS image_bandeau_13, t0.tel AS tel_14, t0.image_vide AS image_vide_15, t0.maintenance AS maintenance_16, t0.htaccess_val AS htaccess_val_17, t0.meta_index AS meta_index_18, t0.meta_follow AS meta_follow_19, t0.robots AS robots_20, t0.analytics AS analytics_21, t0.cle_key AS cle_key_22, t0.cle_secret AS cle_secret_23, t0.tag_managerhead AS tag_managerhead_24, t0.meta_keywords AS meta_keywords_25, t0.cle_map AS cle_map_26, t0.active_smtp AS active_smtp_27, t0.email_from AS email_from_28, t0.email_sender AS email_sender_29, t0.host_smtp AS host_smtp_30, t0.type_cryptage AS type_cryptage_31, t0.port_tls AS port_tls_32, t0.port_ssl AS port_ssl_33, t0.smtp_user AS smtp_user_34, t0.smtp_pass AS smtp_pass_35, t0.typeLienErrorPage AS typeLienErrorPage_36, t0.lienExterneErrorPage AS lienExterneErrorPage_37, t0.telephoneErrorPage AS telephoneErrorPage_38, t0.domain_api_hrz AS domain_api_hrz_39, t0.token_api_hrz AS token_api_hrz_40, t0.actif_auth_gmail AS actif_auth_gmail_41, t0.id_client_auth AS id_client_auth_42, t0.secret_client_auth AS secret_client_auth_43, t0.id_matomo AS id_matomo_44, t0.code_head AS code_head_45, t0.code_body AS code_body_46, t0.google_verification AS google_verification_47, t0.type_recaptcha AS type_recaptcha_48, t0.actif_whatsapp AS actif_whatsapp_49, t0.tel_whatsapp AS tel_whatsapp_50, t0.header_color_whatsapp AS header_color_whatsapp_51, t0.generation_static_header_footer AS generation_static_header_footer_52, t0.IdSite AS IdSite_53 FROM parametre_site t0 ORDER BY t0.id DESC 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\ParametreSite | No errors. |
App\Entity\Site | No errors. |
App\Entity\ParametreSiteTranslation | No errors. |
App\Entity\Redirection | No errors. |
App\Entity\Language | No errors. |
App\Entity\UrlPost | 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 | No errors. |
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\ParametrePost | No errors. |
App\Entity\Category | No errors. |
App\Entity\TypePostTranslation | No errors. |
App\Entity\Activites | No errors. |
App\Entity\PostAffichage | No errors. |
App\Entity\CategoryBloc | No errors. |
App\Entity\CategoryTranslation | No errors. |
App\Entity\Secteurs | No errors. |