Query Metrics
13
Database Queries
5
Different statements
1.00 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.19 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.actif AS actif_3, t0.is_delete AS is_delete_4, t0.username AS username_5, t0.roles AS roles_6, t0.password AS password_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.lang AS lang_10, t0.authentication_failure AS authentication_failure_11, t0.locked AS locked_12, t0.id_site AS id_site_13 FROM cms_user t0 WHERE t0.id = ?
Parameters:
[
10
]
|
| 2 | 0.06 ms |
SELECT t0.id AS id_1, t0.type_bloc AS type_bloc_2, t0.content AS content_3, t0.short_code AS short_code_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM cms_historique_bloc_ai t0
Parameters:
[] |
| 3 | 0.11 ms |
SELECT t0.id AS id_1, t0.archive AS archive_2, t0.show_image_principal AS show_image_principal_3, t0.id_membre AS id_membre_4, t0.generate_with_ai AS generate_with_ai_5, t0.alias AS alias_6, t0.position AS position_7, t0.authorization_api AS authorization_api_8, t0.actif_home AS actif_home_9, t0.post_archive AS post_archive_10, t0.date_archive AS date_archive_11, t0.image AS image_12, t0.image_import_valide AS image_import_valide_13, t0.url_video AS url_video_14, t0.image_bandeau AS image_bandeau_15, t0.image_bandeau_height AS image_bandeau_height_16, t0.image_couverture AS image_couverture_17, t0.tag_managerhead AS tag_managerhead_18, t0.tag_managerbody AS tag_managerbody_19, t0.default_categorie AS default_categorie_20, t0.date_publication AS date_publication_21, t0.date_import AS date_import_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.date_update_ref AS date_update_ref_25, t0.id_activite AS id_activite_26, t0.id_sous_activite AS id_sous_activite_27, t0.id_secteur AS id_secteur_28, t0.type_page_ref AS type_page_ref_29, t0.disponibilite_produit AS disponibilite_produit_30, t0.prix_produit AS prix_produit_31, t0.referance_produit AS referance_produit_32, t0.position_image AS position_image_33, t0.id_import_categorie_old AS id_import_categorie_old_34, t0.old_id_import AS old_id_import_35, t0.module_import AS module_import_36, t0.posts_associes AS posts_associes_37, t0.posts_associes_autres_types AS posts_associes_autres_types_38, t0.tags AS tags_39, t0.custom_style AS custom_style_40, t0.last_date_indexation_google AS last_date_indexation_google_41, t0.nb_cota_indexation AS nb_cota_indexation_42, t0.parent_page AS parent_page_43, t0.ids_categoies_related AS ids_categoies_related_44, t0.old_url AS old_url_45, t0.image_import_csv AS image_import_csv_46, t0.site_internet AS site_internet_47, t0.lien_facebook AS lien_facebook_48, t0.lien_instagram AS lien_instagram_49, t0.lien_linkedin AS lien_linkedin_50, t0.lien_twitter AS lien_twitter_51, t0.lien_tiktok AS lien_tiktok_52, t0.lien_pinterest AS lien_pinterest_53, t0.lien_video AS lien_video_54, t0.tarifs AS tarifs_55, t0.author_id AS author_id_56, t0.type_post AS type_post_57, t0.template_cms_id AS template_cms_id_58, t0.modele_gallerie_id AS modele_gallerie_id_59 FROM cms_post t0
Parameters:
[] |
| 4 | 0.14 ms |
SELECT c.id,c.IdParent,c.IdSousParent as IdParent2,cms_category_translation.titre_categorie as titre,cms_category_translation.slug_url as slug FROM cms_category c INNER JOIN cms_category_translation ON c.id = cms_category_translation.translatable_id WHERE cms_category_translation.locale = :local and c.actif = true ORDER BY c.order_by ASC
Parameters:
[ "local" => "fr" ] |
| 5 | 0.11 ms |
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.title_botton_affichage AS title_botton_affichage_6, t0.slug AS slug_7, t0.old_slug AS old_slug_8, t0.summary AS summary_9, t0.content AS content_10, t0.content2 AS content2_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.meta_keys AS meta_keys_14, t0.mot_cle AS mot_cle_15, t0.script_sc AS script_sc_16, t0.breadcrumb AS breadcrumb_17, t0.canonical AS canonical_18, t0.meta_robots AS meta_robots_19, t0.settig_metaTitle AS settig_metaTitle_20, t0.settig_metaDesc AS settig_metaDesc_21, t0.traduite AS traduite_22, t0.image_alt AS image_alt_23, t0.image_bandeau_alt AS image_bandeau_alt_24, t0.image_couverture_alt AS image_couverture_alt_25, t0.titre_lien AS titre_lien_26, t0.type_lien AS type_lien_27, t0.lien_interne AS lien_interne_28, t0.lien_externe AS lien_externe_29, t0.telephone AS telephone_30, t0.data_champs_personalizer AS data_champs_personalizer_31, t0.stories AS stories_32, t0.length_text AS length_text_33, t0.locale AS locale_34, t0.translatable_id AS translatable_id_35 FROM cms_post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
2
]
|
| 6 | 0.06 ms |
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.title_botton_affichage AS title_botton_affichage_6, t0.slug AS slug_7, t0.old_slug AS old_slug_8, t0.summary AS summary_9, t0.content AS content_10, t0.content2 AS content2_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.meta_keys AS meta_keys_14, t0.mot_cle AS mot_cle_15, t0.script_sc AS script_sc_16, t0.breadcrumb AS breadcrumb_17, t0.canonical AS canonical_18, t0.meta_robots AS meta_robots_19, t0.settig_metaTitle AS settig_metaTitle_20, t0.settig_metaDesc AS settig_metaDesc_21, t0.traduite AS traduite_22, t0.image_alt AS image_alt_23, t0.image_bandeau_alt AS image_bandeau_alt_24, t0.image_couverture_alt AS image_couverture_alt_25, t0.titre_lien AS titre_lien_26, t0.type_lien AS type_lien_27, t0.lien_interne AS lien_interne_28, t0.lien_externe AS lien_externe_29, t0.telephone AS telephone_30, t0.data_champs_personalizer AS data_champs_personalizer_31, t0.stories AS stories_32, t0.length_text AS length_text_33, t0.locale AS locale_34, t0.translatable_id AS translatable_id_35 FROM cms_post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
3
]
|
| 7 | 0.05 ms |
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.title_botton_affichage AS title_botton_affichage_6, t0.slug AS slug_7, t0.old_slug AS old_slug_8, t0.summary AS summary_9, t0.content AS content_10, t0.content2 AS content2_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.meta_keys AS meta_keys_14, t0.mot_cle AS mot_cle_15, t0.script_sc AS script_sc_16, t0.breadcrumb AS breadcrumb_17, t0.canonical AS canonical_18, t0.meta_robots AS meta_robots_19, t0.settig_metaTitle AS settig_metaTitle_20, t0.settig_metaDesc AS settig_metaDesc_21, t0.traduite AS traduite_22, t0.image_alt AS image_alt_23, t0.image_bandeau_alt AS image_bandeau_alt_24, t0.image_couverture_alt AS image_couverture_alt_25, t0.titre_lien AS titre_lien_26, t0.type_lien AS type_lien_27, t0.lien_interne AS lien_interne_28, t0.lien_externe AS lien_externe_29, t0.telephone AS telephone_30, t0.data_champs_personalizer AS data_champs_personalizer_31, t0.stories AS stories_32, t0.length_text AS length_text_33, t0.locale AS locale_34, t0.translatable_id AS translatable_id_35 FROM cms_post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
4
]
|
| 8 | 0.05 ms |
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.title_botton_affichage AS title_botton_affichage_6, t0.slug AS slug_7, t0.old_slug AS old_slug_8, t0.summary AS summary_9, t0.content AS content_10, t0.content2 AS content2_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.meta_keys AS meta_keys_14, t0.mot_cle AS mot_cle_15, t0.script_sc AS script_sc_16, t0.breadcrumb AS breadcrumb_17, t0.canonical AS canonical_18, t0.meta_robots AS meta_robots_19, t0.settig_metaTitle AS settig_metaTitle_20, t0.settig_metaDesc AS settig_metaDesc_21, t0.traduite AS traduite_22, t0.image_alt AS image_alt_23, t0.image_bandeau_alt AS image_bandeau_alt_24, t0.image_couverture_alt AS image_couverture_alt_25, t0.titre_lien AS titre_lien_26, t0.type_lien AS type_lien_27, t0.lien_interne AS lien_interne_28, t0.lien_externe AS lien_externe_29, t0.telephone AS telephone_30, t0.data_champs_personalizer AS data_champs_personalizer_31, t0.stories AS stories_32, t0.length_text AS length_text_33, t0.locale AS locale_34, t0.translatable_id AS translatable_id_35 FROM cms_post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
5
]
|
| 9 | 0.05 ms |
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.title_botton_affichage AS title_botton_affichage_6, t0.slug AS slug_7, t0.old_slug AS old_slug_8, t0.summary AS summary_9, t0.content AS content_10, t0.content2 AS content2_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.meta_keys AS meta_keys_14, t0.mot_cle AS mot_cle_15, t0.script_sc AS script_sc_16, t0.breadcrumb AS breadcrumb_17, t0.canonical AS canonical_18, t0.meta_robots AS meta_robots_19, t0.settig_metaTitle AS settig_metaTitle_20, t0.settig_metaDesc AS settig_metaDesc_21, t0.traduite AS traduite_22, t0.image_alt AS image_alt_23, t0.image_bandeau_alt AS image_bandeau_alt_24, t0.image_couverture_alt AS image_couverture_alt_25, t0.titre_lien AS titre_lien_26, t0.type_lien AS type_lien_27, t0.lien_interne AS lien_interne_28, t0.lien_externe AS lien_externe_29, t0.telephone AS telephone_30, t0.data_champs_personalizer AS data_champs_personalizer_31, t0.stories AS stories_32, t0.length_text AS length_text_33, t0.locale AS locale_34, t0.translatable_id AS translatable_id_35 FROM cms_post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
10
]
|
| 10 | 0.05 ms |
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.title_botton_affichage AS title_botton_affichage_6, t0.slug AS slug_7, t0.old_slug AS old_slug_8, t0.summary AS summary_9, t0.content AS content_10, t0.content2 AS content2_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.meta_keys AS meta_keys_14, t0.mot_cle AS mot_cle_15, t0.script_sc AS script_sc_16, t0.breadcrumb AS breadcrumb_17, t0.canonical AS canonical_18, t0.meta_robots AS meta_robots_19, t0.settig_metaTitle AS settig_metaTitle_20, t0.settig_metaDesc AS settig_metaDesc_21, t0.traduite AS traduite_22, t0.image_alt AS image_alt_23, t0.image_bandeau_alt AS image_bandeau_alt_24, t0.image_couverture_alt AS image_couverture_alt_25, t0.titre_lien AS titre_lien_26, t0.type_lien AS type_lien_27, t0.lien_interne AS lien_interne_28, t0.lien_externe AS lien_externe_29, t0.telephone AS telephone_30, t0.data_champs_personalizer AS data_champs_personalizer_31, t0.stories AS stories_32, t0.length_text AS length_text_33, t0.locale AS locale_34, t0.translatable_id AS translatable_id_35 FROM cms_post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
23
]
|
| 11 | 0.04 ms |
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.title_botton_affichage AS title_botton_affichage_6, t0.slug AS slug_7, t0.old_slug AS old_slug_8, t0.summary AS summary_9, t0.content AS content_10, t0.content2 AS content2_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.meta_keys AS meta_keys_14, t0.mot_cle AS mot_cle_15, t0.script_sc AS script_sc_16, t0.breadcrumb AS breadcrumb_17, t0.canonical AS canonical_18, t0.meta_robots AS meta_robots_19, t0.settig_metaTitle AS settig_metaTitle_20, t0.settig_metaDesc AS settig_metaDesc_21, t0.traduite AS traduite_22, t0.image_alt AS image_alt_23, t0.image_bandeau_alt AS image_bandeau_alt_24, t0.image_couverture_alt AS image_couverture_alt_25, t0.titre_lien AS titre_lien_26, t0.type_lien AS type_lien_27, t0.lien_interne AS lien_interne_28, t0.lien_externe AS lien_externe_29, t0.telephone AS telephone_30, t0.data_champs_personalizer AS data_champs_personalizer_31, t0.stories AS stories_32, t0.length_text AS length_text_33, t0.locale AS locale_34, t0.translatable_id AS translatable_id_35 FROM cms_post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
24
]
|
| 12 | 0.05 ms |
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.title_botton_affichage AS title_botton_affichage_6, t0.slug AS slug_7, t0.old_slug AS old_slug_8, t0.summary AS summary_9, t0.content AS content_10, t0.content2 AS content2_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.meta_keys AS meta_keys_14, t0.mot_cle AS mot_cle_15, t0.script_sc AS script_sc_16, t0.breadcrumb AS breadcrumb_17, t0.canonical AS canonical_18, t0.meta_robots AS meta_robots_19, t0.settig_metaTitle AS settig_metaTitle_20, t0.settig_metaDesc AS settig_metaDesc_21, t0.traduite AS traduite_22, t0.image_alt AS image_alt_23, t0.image_bandeau_alt AS image_bandeau_alt_24, t0.image_couverture_alt AS image_couverture_alt_25, t0.titre_lien AS titre_lien_26, t0.type_lien AS type_lien_27, t0.lien_interne AS lien_interne_28, t0.lien_externe AS lien_externe_29, t0.telephone AS telephone_30, t0.data_champs_personalizer AS data_champs_personalizer_31, t0.stories AS stories_32, t0.length_text AS length_text_33, t0.locale AS locale_34, t0.translatable_id AS translatable_id_35 FROM cms_post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
25
]
|
| 13 | 0.05 ms |
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.title_botton_affichage AS title_botton_affichage_6, t0.slug AS slug_7, t0.old_slug AS old_slug_8, t0.summary AS summary_9, t0.content AS content_10, t0.content2 AS content2_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.meta_keys AS meta_keys_14, t0.mot_cle AS mot_cle_15, t0.script_sc AS script_sc_16, t0.breadcrumb AS breadcrumb_17, t0.canonical AS canonical_18, t0.meta_robots AS meta_robots_19, t0.settig_metaTitle AS settig_metaTitle_20, t0.settig_metaDesc AS settig_metaDesc_21, t0.traduite AS traduite_22, t0.image_alt AS image_alt_23, t0.image_bandeau_alt AS image_bandeau_alt_24, t0.image_couverture_alt AS image_couverture_alt_25, t0.titre_lien AS titre_lien_26, t0.type_lien AS type_lien_27, t0.lien_interne AS lien_interne_28, t0.lien_externe AS lien_externe_29, t0.telephone AS telephone_30, t0.data_champs_personalizer AS data_champs_personalizer_31, t0.stories AS stories_32, t0.length_text AS length_text_33, t0.locale AS locale_34, t0.translatable_id AS translatable_id_35 FROM cms_post_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
26
]
|
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\Site | No errors. |
| App\Entity\HistoriqueBlocAi | No errors. |
| App\Entity\Post | No errors. |
| App\Entity\Language | 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\PostTranslation | No errors. |
| App\Entity\Category | No errors. |