GET https://asfivillejuif.com/le-club/installations

Query Metrics

35 Database Queries
10 Different statements
22.02 ms Query time
0 Invalid entities
35 Managed entities

Grouped Statements

Show all queries

Time Count Info
15.42 ms
(70.04%)
26
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.titre AS titre_3, t0.slug AS slug_4, t0.navbar AS navbar_5, t0.ordre AS ordre_6, t0.actif AS actif_7, t0.home_page AS home_page_8, t0.layout AS layout_9, t0.content AS content_10, t0.date_crea AS date_crea_11, t0.date_modif AS date_modif_12, t0.user_crea_id AS user_crea_id_13, t0.user_modif_id AS user_modif_id_14, t0.parent_id AS parent_id_15 FROM pages t0 WHERE t0.parent_id = ?
Parameters:
[
  1
]
1.20 ms
(5.46%)
1
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.titre AS titre_2, p0_.slug AS slug_3, p0_.navbar AS navbar_4, p0_.ordre AS ordre_5, p0_.actif AS actif_6, p0_.home_page AS home_page_7, p0_.layout AS layout_8, p0_.content AS content_9, p0_.date_crea AS date_crea_10, p0_.date_modif AS date_modif_11, p0_.user_crea_id AS user_crea_id_12, p0_.user_modif_id AS user_modif_id_13, p0_.parent_id AS parent_id_14 FROM pages p0_ WHERE p0_.actif = 1 AND p0_.home_page = 1
Parameters:
[]
1.17 ms
(5.33%)
1
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.titre AS titre_2, p0_.slug AS slug_3, p0_.navbar AS navbar_4, p0_.ordre AS ordre_5, p0_.actif AS actif_6, p0_.home_page AS home_page_7, p0_.layout AS layout_8, p0_.content AS content_9, p0_.date_crea AS date_crea_10, p0_.date_modif AS date_modif_11, p0_.user_crea_id AS user_crea_id_12, p0_.user_modif_id AS user_modif_id_13, p0_.parent_id AS parent_id_14 FROM pages p0_ WHERE p0_.home_page = 1
Parameters:
[]
0.71 ms
(3.22%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contenu AS contenu_3, t0.url AS url_4, t0.js AS js_5, t0.css AS css_6, t0.actif AS actif_7 FROM contenu t0 WHERE t0.id = ?
Parameters:
[
  17
]
0.69 ms
(3.12%)
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:
[
  14
]
0.65 ms
(2.93%)
1
SELECT t0.id AS id_1, t0.titre_id AS titre_id_2, t0.texte_id AS texte_id_3 FROM conf_article_large t0 WHERE t0.id = ?
Parameters:
[
  4
]
0.59 ms
(2.68%)
1
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.titre AS titre_2, p0_.slug AS slug_3, p0_.navbar AS navbar_4, p0_.ordre AS ordre_5, p0_.actif AS actif_6, p0_.home_page AS home_page_7, p0_.layout AS layout_8, p0_.content AS content_9, p0_.date_crea AS date_crea_10, p0_.date_modif AS date_modif_11, p0_.user_crea_id AS user_crea_id_12, p0_.user_modif_id AS user_modif_id_13, p0_.parent_id AS parent_id_14 FROM pages p0_ WHERE p0_.actif = 1 AND p0_.slug = ?
Parameters:
[
  "/le-club/installations"
]
0.54 ms
(2.46%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.titre AS titre_3, t0.slug AS slug_4, t0.navbar AS navbar_5, t0.ordre AS ordre_6, t0.actif AS actif_7, t0.home_page AS home_page_8, t0.layout AS layout_9, t0.content AS content_10, t0.date_crea AS date_crea_11, t0.date_modif AS date_modif_12, t0.user_crea_id AS user_crea_id_13, t0.user_modif_id AS user_modif_id_14, t0.parent_id AS parent_id_15 FROM pages t0 WHERE t0.id = ?
Parameters:
[
  3
]
0.54 ms
(2.46%)
1
SELECT t0.id AS id_1, t0.contenu AS contenu_2 FROM data_varchar t0 WHERE t0.id = ?
Parameters:
[
  77
]
0.51 ms
(2.30%)
1
SELECT t0.id AS id_1, t0.contenu AS contenu_2 FROM data_quill t0 WHERE t0.id = ?
Parameters:
[
  117
]

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 29
App\Entity\SecurUser 1
App\Entity\CasesPages 1
App\Entity\Contenu 1
App\Entity\ConfArticleLarge 1
App\Entity\DataVarchar 1
App\Entity\DataQuill 1

Entities Mapping

Class Mapping errors
App\Entity\Pages No errors.
App\Entity\SecurUser No errors.
App\Entity\CasesPages No errors.
App\Entity\Contenu No errors.
App\Entity\ConfArticleLarge No errors.
App\Entity\DataVarchar No errors.
App\Entity\DataQuill No errors.