Query Metrics
13
Database Queries
10
Different statements
11.34 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.33 ms (20.58%) |
3 |
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
]
|
1.57 ms (13.84%) |
2 |
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 ] |
1.34 ms (11.79%) |
1 |
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.16 ms (10.21%) |
1 |
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" ] |
1.02 ms (9.01%) |
1 |
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
]
|
0.93 ms (8.19%) |
1 |
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:
[] |
0.85 ms (7.51%) |
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.83 ms (7.34%) |
1 |
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
]
|
0.74 ms (6.52%) |
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.57 ms (5.00%) |
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:
[
8
]
|
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 |
|
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 |
|
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. |