https://new-site.hrz.fr/localite/blaye

Query Metrics

13 Database Queries
10 Different statements
10.03 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.43 ms
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 1.08 ms
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"
]
3 0.62 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.authorization_api AS authorization_api_3, t0.actif_home AS actif_home_4, t0.post_archive AS post_archive_5, t0.date_archive AS date_archive_6, t0.image AS image_7, t0.url_video AS url_video_8, t0.image_bandeau AS image_bandeau_9, t0.image_bandeau_height AS image_bandeau_height_10, t0.image_couverture AS image_couverture_11, t0.tag_managerhead AS tag_managerhead_12, t0.tag_managerbody AS tag_managerbody_13, t0.date_publication AS date_publication_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.id_activite AS id_activite_17, t0.id_sous_activite AS id_sous_activite_18, t0.id_secteur AS id_secteur_19, t0.type_page_ref AS type_page_ref_20, t0.author_id AS author_id_21, t0.type_post AS type_post_22, t0.template_cms_id AS template_cms_id_23, t0.modele_gallerie_id AS modele_gallerie_id_24 FROM post t0 WHERE t0.id_secteur = ?
Parameters:
[
  8
]
4 0.79 ms
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:
[
  172
]
5 0.56 ms
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:
[
  173
]
6 0.83 ms
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.date_creation AS date_creation_3, t0.date_modification AS date_modification_4, t0.date_generation AS date_generation_5, t0.id_secteur AS id_secteur_6, t0.id_activite AS id_activite_7, t0.type AS type_8 FROM liste_ref t0 WHERE t0.id_secteur = ?
Parameters:
[
  8
]
7 1.15 ms
SELECT p0_.id AS id_0, p0_.position AS position_1, p0_.authorization_api AS authorization_api_2, p0_.actif_home AS actif_home_3, p0_.post_archive AS post_archive_4, p0_.date_archive AS date_archive_5, p0_.image AS image_6, p0_.url_video AS url_video_7, p0_.image_bandeau AS image_bandeau_8, p0_.image_bandeau_height AS image_bandeau_height_9, p0_.image_couverture AS image_couverture_10, p0_.tag_managerhead AS tag_managerhead_11, p0_.tag_managerbody AS tag_managerbody_12, p0_.date_publication AS date_publication_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.id_activite AS id_activite_16, p0_.id_sous_activite AS id_sous_activite_17, p0_.id_secteur AS id_secteur_18, p0_.type_page_ref AS type_page_ref_19, p0_.author_id AS author_id_20, p0_.type_post AS type_post_21, p0_.template_cms_id AS template_cms_id_22, p0_.modele_gallerie_id AS modele_gallerie_id_23 FROM post p0_ INNER JOIN post_translation p1_ ON p0_.id = p1_.translatable_id WHERE p1_.locale = ? AND p1_.slug = ?
Parameters:
[
  "fr"
  "Home"
]
8 0.59 ms
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:
[
  39
]
9 0.54 ms
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:
[
  8
]
10 0.82 ms
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.lien_param_ref AS lien_param_ref_3, t0.nombre_jour_generer AS nombre_jour_generer_4, t0.image_bandeau AS image_bandeau_5, t0.nb_secteur AS nb_secteur_6, t0.nb_activite AS nb_activite_7, t0.nb_maillage_secteur AS nb_maillage_secteur_8, t0.nb_maillage_activite AS nb_maillage_activite_9, t0.settig_meta_title_1 AS settig_meta_title_1_10, t0.settig_meta_title_2 AS settig_meta_title_2_11, t0.settig_meta_title_3 AS settig_meta_title_3_12, t0.settig_meta_desc_1 AS settig_meta_desc_1_13, t0.settig_meta_desc_2 AS settig_meta_desc_2_14, t0.settig_meta_desc_3 AS settig_meta_desc_3_15 FROM parametre_ref t0 ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
11 0.83 ms
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
]
12 0.65 ms
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
]
13 0.14 ms
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
]

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\SecteursTranslation No errors.
App\Entity\UrlRef 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
  • The association App\Entity\Widget#type_affichage_home refers to the inverse side field App\Entity\PostAffichage#widget which does not exist.
App\Entity\CpPostField No errors.
App\Entity\PostBloc No errors.
App\Entity\PostTranslation No errors.
App\Entity\ExportTraductions No errors.
App\Entity\ListeRef 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\ListeMenu No errors.
App\Entity\TextParametrable No errors.
App\Entity\Email No errors.
App\Entity\ParametreSite No errors.
App\Entity\Media No errors.
App\Entity\ReseauSociaux No errors.
App\Entity\ModulesCookies No errors.
App\Entity\PostAffichage No errors.
App\Entity\Category
  • The association App\Entity\Category#modele_gallerie refers to the inverse side field App\Entity\ModelGallerie#category which does not exist.
App\Entity\Activites No errors.
App\Entity\UrlRefTranslation No errors.
App\Entity\ParametrePost No errors.
App\Entity\TypePostTranslation No errors.
App\Entity\MenuTranslation No errors.
App\Entity\DefaultBloc No errors.
App\Entity\CategoryBloc 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\ProductTranslation No errors.
App\Entity\CategoriesProductTranslation No errors.
App\Entity\ListeRefTranslation No errors.
App\Entity\ParametreLabelPhraseTranslation No errors.