Query Metrics

20 Database Queries
19 Different statements
23.62 ms Query time
0 Invalid entities
16 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.69 ms
(11.40%)
2
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.titre AS titre_3, t0.slug AS slug_4, t0.name AS name_5, t0.title AS title_6, t0.slug_en AS slug_en_7, t0.navbar AS navbar_8, t0.ordre AS ordre_9, t0.actif AS actif_10, t0.home_page AS home_page_11, t0.layout AS layout_12, t0.content AS content_13, t0.date_crea AS date_crea_14, t0.date_modif AS date_modif_15, t0.user_crea_id AS user_crea_id_16, t0.user_modif_id AS user_modif_id_17, t0.parent_id AS parent_id_18 FROM pages t0 WHERE t0.parent_id = ?
Parameters:
[
  1
]
1.90 ms
(8.03%)
1
SELECT c0_.id AS id_0, c0_.nom_template AS nom_template_1, c0_.ordre AS ordre_2, c0_.id_conf AS id_conf_3, c0_.actif AS actif_4, c0_.page_id AS page_id_5, c0_.contenu_id AS contenu_id_6 FROM cases_pages c0_ WHERE c0_.page_id = ? AND c0_.actif = 1 ORDER BY c0_.ordre ASC
Parameters:
[
  1
]
1.65 ms
(6.97%)
1
SELECT a0_.id AS id_0, a0_.content AS content_1, a0_.active AS active_2, a0_.reply_notification_read AS reply_notification_read_3, a0_.moderation_status AS moderation_status_4, a0_.moderation_reason AS moderation_reason_5, a0_.moderated_by_name AS moderated_by_name_6, a0_.moderated_at AS moderated_at_7, a0_.created_at AS created_at_8, s1_.id AS id_9, s1_.username AS username_10, s1_.roles AS roles_11, s1_.password AS password_12, s1_.email AS email_13, s1_.telephone AS telephone_14, s1_.cgu AS cgu_15, s1_.actif AS actif_16, s1_.code_verif AS code_verif_17, s1_.date_crea AS date_crea_18, s1_.date_modif AS date_modif_19, s1_.code_tel_verif AS code_tel_verif_20, s1_.pref AS pref_21, s1_.change_pass AS change_pass_22, s1_.fermeture AS fermeture_23, s1_.nickname AS nickname_24, s1_.nom AS nom_25, s1_.prenom AS prenom_26, s1_.date_naissance AS date_naissance_27, s1_.avatar AS avatar_28, s1_.comment_reply_email_enabled AS comment_reply_email_enabled_29, a2_.id AS id_30, a2_.auteur AS auteur_31, a2_.date_crea AS date_crea_32, a2_.date_modif AS date_modif_33, a2_.date_publi AS date_publi_34, a2_.actif AS actif_35, a2_.latitude AS latitude_36, a2_.longitude AS longitude_37, a2_.views_count AS views_count_38, d3_.id AS id_39, d3_.contenu AS contenu_40, d3_.actif AS actif_41, d3_.ordre AS ordre_42, a0_.article_id AS article_id_43, a0_.user_id AS user_id_44, a0_.parent_id AS parent_id_45, a2_.titre_id AS titre_id_46, a2_.texte_id AS texte_id_47, a2_.user_crea_id AS user_crea_id_48, a2_.user_modif_id AS user_modif_id_49, a2_.visuel_id AS visuel_id_50 FROM article_comment a0_ INNER JOIN secur_user s1_ ON a0_.user_id = s1_.id INNER JOIN articles a2_ ON a0_.article_id = a2_.id LEFT JOIN data_varchar d3_ ON a2_.titre_id = d3_.id WHERE a0_.active = 1 AND a0_.moderation_status = ? AND a2_.id IN (?) ORDER BY a0_.created_at DESC LIMIT 5
Parameters:
[
  "approved"
  2
]
1.39 ms
(5.87%)
1
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.titre AS titre_2, p0_.slug AS slug_3, p0_.name AS name_4, p0_.title AS title_5, p0_.slug_en AS slug_en_6, p0_.navbar AS navbar_7, p0_.ordre AS ordre_8, p0_.actif AS actif_9, p0_.home_page AS home_page_10, p0_.layout AS layout_11, p0_.content AS content_12, p0_.date_crea AS date_crea_13, p0_.date_modif AS date_modif_14, p0_.user_crea_id AS user_crea_id_15, p0_.user_modif_id AS user_modif_id_16, p0_.parent_id AS parent_id_17 FROM pages p0_ WHERE p0_.home_page = 1 AND p0_.parent_id IS NULL ORDER BY p0_.id ASC LIMIT 1
Parameters:
[]
1.37 ms
(5.80%)
1
SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM articles a0_ INNER JOIN articles_articles_categories a2_ ON a0_.id = a2_.articles_id INNER JOIN articles_categories a1_ ON a1_.id = a2_.articles_categories_id WHERE a0_.actif = 1 AND ((a0_.date_publi IS NULL OR a0_.date_publi <= ?)) AND a1_.id = ?
Parameters:
[
  "2026-09-15 11:03:25"
  1
]
1.26 ms
(5.33%)
1
SELECT a0_.id AS id_0, a0_.auteur AS auteur_1, a0_.date_crea AS date_crea_2, a0_.date_modif AS date_modif_3, a0_.date_publi AS date_publi_4, a0_.actif AS actif_5, a0_.latitude AS latitude_6, a0_.longitude AS longitude_7, a0_.views_count AS views_count_8, a0_.titre_id AS titre_id_9, a0_.texte_id AS texte_id_10, a0_.user_crea_id AS user_crea_id_11, a0_.user_modif_id AS user_modif_id_12, a0_.visuel_id AS visuel_id_13 FROM articles a0_ WHERE a0_.actif = 1 AND ((a0_.date_publi IS NULL OR a0_.date_publi <= ?)) ORDER BY a0_.date_publi DESC, a0_.date_crea DESC LIMIT 6
Parameters:
[
  "2026-09-15 11:03:25"
]
1.19 ms
(5.04%)
1
SELECT t0.id AS id_1, t0.contenu AS contenu_2 FROM data_text t0 WHERE t0.id = ?
Parameters:
[
  11
]
1.16 ms
(4.92%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.base_name AS base_name_3, t0.version_label AS version_label_4, t0.description AS description_5, t0.url AS url_6, t0.js AS js_7, t0.css AS css_8, t0.actif AS actif_9, t0.est_publie AS est_publie_10, t0.est_archive AS est_archive_11, t0.slug AS slug_12, t0.created_at AS created_at_13, t0.parent_version_id AS parent_version_id_14 FROM contenu t0
Parameters:
[]
1.13 ms
(4.77%)
1
SELECT t0.id AS id_1, t0.png32 AS png32_2, t0.png16 AS png16_3, t0.ico AS ico_4, t0.png180 AS png180_5, t0.theme_color AS theme_color_6, t0.png192 AS png192_7, t0.png512 AS png512_8, t0.svg_icon AS svg_icon_9, t0.svg_color AS svg_color_10, t0.tile_color AS tile_color_11, t0.png70 AS png70_12, t0.png150 AS png150_13, t0.png310 AS png310_14, t0.png310w150 AS png310w150_15, t0.background_color AS background_color_16 FROM favicon t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.10 ms
(4.67%)
1
SELECT t0.id AS id_1, t0.logo_fsp AS logo_fsp_2, t0.logo_fsm AS logo_fsm_3, t0.logo_fsg AS logo_fsg_4, t0.logo_fsv AS logo_fsv_5, t0.logo_fcp AS logo_fcp_6, t0.logo_fcm AS logo_fcm_7, t0.logo_fcg AS logo_fcg_8, t0.logo_fcv AS logo_fcv_9, t0.logo_nbfcp AS logo_nbfcp_10, t0.logo_nbfcm AS logo_nbfcm_11, t0.logo_nbfcg AS logo_nbfcg_12, t0.logo_nbfcv AS logo_nbfcv_13, t0.logo_nbfsp AS logo_nbfsp_14, t0.logo_nbfsm AS logo_nbfsm_15, t0.logo_nbfsg AS logo_nbfsg_16, t0.logo_nbfsv AS logo_nbfsv_17, t0.logo_fsvw AS logo_fsvw_18, t0.logo_fsvh AS logo_fsvh_19, t0.logo_fcvw AS logo_fcvw_20, t0.logo_fcvh AS logo_fcvh_21, t0.logo_nbfcvw AS logo_nbfcvw_22, t0.logo_nbfcvh AS logo_nbfcvh_23, t0.logo_nbfsvw AS logo_nbfsvw_24, t0.logo_nbfsvh AS logo_nbfsvh_25 FROM logo t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.09 ms
(4.59%)
1
SELECT t0.id AS id_1, t0.der_articles_id AS der_articles_id_2 FROM conf_content_2 t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.05 ms
(4.45%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3 FROM articles_categories t0 INNER JOIN articles_articles_categories ON t0.id = articles_articles_categories.articles_categories_id WHERE articles_articles_categories.articles_id = ?
Parameters:
[
  2
]
1.04 ms
(4.40%)
1
SELECT b0_.id AS id_0, b0_.version AS version_1, b0_.code_head AS code_head_2, b0_.code_body AS code_body_3, b0_.actif AS actif_4 FROM bootstrap b0_ WHERE b0_.actif = 1 ORDER BY b0_.id DESC
Parameters:
[]
0.99 ms
(4.18%)
1
SELECT t0_.id AS id_0, t0_.nom AS nom_1, t0_.actif AS actif_2, t0_.code_head AS code_head_3, t0_.code_body AS code_body_4, t0_.date_crea AS date_crea_5 FROM template t0_ WHERE t0_.actif = 1 ORDER BY t0_.id DESC
Parameters:
[]
0.99 ms
(4.18%)
1
SELECT j0_.id AS id_0, j0_.version AS version_1, j0_.code_head AS code_head_2, j0_.code_body AS code_body_3, j0_.actif AS actif_4 FROM jquery j0_ WHERE j0_.actif = 1 ORDER BY j0_.id DESC
Parameters:
[]
0.98 ms
(4.15%)
1
SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.slug AS slug_2 FROM articles_categories a0_ ORDER BY a0_.nom ASC
Parameters:
[]
0.97 ms
(4.12%)
1
SELECT t0.id AS id_1, t0.url_original AS url_original_2, t0.url AS url_3, t0.alt AS alt_4, t0.title AS title_5, t0.legende AS legende_6, t0.description AS description_7, t0.largeur AS largeur_8, t0.hauteur AS hauteur_9, t0.actif AS actif_10, t0.ordre AS ordre_11, t0.document_id AS document_id_12 FROM data_image t0 WHERE t0.id = ?
Parameters:
[
  3
]
0.86 ms
(3.63%)
1
SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.actif AS actif_3, t0.ordre AS ordre_4 FROM data_varchar t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.83 ms
(3.50%)
1
SELECT t0.id AS id_1, t0.contenu AS contenu_2 FROM data_quill t0 WHERE t0.id = ?
Parameters:
[
  2
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Pages\Contenu 2
App\Entity\Pages\Pages 2
App\Entity\Securite\SecurAdmin 2
App\Entity\Interface\Favicon 1
App\Entity\Pages\CasesPages 1
App\Entity\ConfContent2 1
App\Entity\ConfObj\DataText 1
App\Entity\Blog\Articles 1
App\Entity\ConfObj\DataVarchar 1
App\Entity\ConfObj\DataQuill 1
App\Entity\ConfObj\DataImage 1
App\Entity\Blog\ArticlesCategories 1
App\Entity\Album\AlbumDocs 1