Query Metrics

40 Database Queries
6 Different statements
26.32 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.content AS content_5, t0.online AS online_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "ecoles"
]
2 0.69 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.subtitle AS subtitle_2, p0_.slug AS slug_3, p0_.content AS content_4, p0_.online AS online_5, p0_.position AS position_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.parent_id AS parent_id_9 FROM page p0_ WHERE p0_.online = 1 ORDER BY p0_.position ASC
Parameters:
[]
3 0.37 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.content AS content_5, t0.online AS online_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM page t0 WHERE t0.parent_id = ?
Parameters:
[
  12
]
4 0.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.content AS content_5, t0.online AS online_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM page t0 WHERE t0.parent_id = ?
Parameters:
[
  15
]
5 0.34 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.content AS content_5, t0.online AS online_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM page t0 WHERE t0.parent_id = ?
Parameters:
[
  2
]
6 0.27 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.content AS content_5, t0.online AS online_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM page t0 WHERE t0.parent_id = ?
Parameters:
[
  10
]
7 0.29 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.content AS content_5, t0.online AS online_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM page t0 WHERE t0.parent_id = ?
Parameters:
[
  13
]
8 0.27 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.content AS content_5, t0.online AS online_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM page t0 WHERE t0.parent_id = ?
Parameters:
[
  8
]
9 0.32 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.content AS content_5, t0.online AS online_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM page t0 WHERE t0.parent_id = ?
Parameters:
[
  11
]
10 0.28 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.content AS content_5, t0.online AS online_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM page t0 WHERE t0.parent_id = ?
Parameters:
[
  14
]
11 0.28 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.content AS content_5, t0.online AS online_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM page t0 WHERE t0.parent_id = ?
Parameters:
[
  9
]
12 0.28 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.content AS content_5, t0.online AS online_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM page t0 WHERE t0.parent_id = ?
Parameters:
[
  5
]
13 0.35 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.content AS content_5, t0.online AS online_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM page t0 WHERE t0.parent_id = ?
Parameters:
[
  3
]
14 0.28 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.content AS content_5, t0.online AS online_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM page t0 WHERE t0.parent_id = ?
Parameters:
[
  4
]
15 7.71 ms
SELECT s0_.id AS id_0, s0_.duration AS duration_1, s0_.periodes AS periodes_2, s0_.primary_time_animation AS primary_time_animation_3, s0_.maternel_time_animation AS maternel_time_animation_4, s0_.date_end AS date_end_5, s0_.normal_price AS normal_price_6, s0_.jette_price AS jette_price_7, s0_.date_jette_register_start AS date_jette_register_start_8, s0_.date_jette_register_end AS date_jette_register_end_9, a1_.id AS id_10, a1_.title AS title_11, a1_.slug AS slug_12, a1_.description AS description_13, a1_.date_start AS date_start_14, a1_.date_end AS date_end_15, a1_.date_register_start AS date_register_start_16, a1_.date_register_end AS date_register_end_17, a1_.note AS note_18, a1_.created_at AS created_at_19, a1_.updated_at AS updated_at_20, s0_.activity_id AS activity_id_21, s0_.theme_id AS theme_id_22 FROM school_activity s0_ INNER JOIN activity a1_ ON s0_.activity_id = a1_.id WHERE a1_.id = s0_.activity_id
Parameters:
[]
16 1.70 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM theme t0 WHERE t0.id = ?
Parameters:
[
  9
]
17 2.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  1
]
18 0.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM theme t0 WHERE t0.id = ?
Parameters:
[
  8
]
19 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  2
]
20 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  3
]
21 0.25 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM theme t0 WHERE t0.id = ?
Parameters:
[
  11
]
22 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  4
]
23 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  5
]
24 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  6
]
25 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  7
]
26 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  16
]
27 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  17
]
28 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  18
]
29 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  19
]
30 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  20
]
31 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  21
]
32 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  22
]
33 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  23
]
34 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  24
]
35 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  25
]
36 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  26
]
37 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  27
]
38 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  28
]
39 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  29
]
40 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.maternel AS maternel_4 FROM class_level t0 INNER JOIN school_activity_class_level ON t0.id = school_activity_class_level.class_level_id WHERE school_activity_class_level.school_activity_id = ?
Parameters:
[
  30
]

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\Page No errors.
App\Entity\User No errors.
App\Entity\Media No errors.
App\Entity\SchoolActivity No errors.
App\Entity\Activity No errors.
App\Entity\Theme No errors.
App\Entity\ClassLevel No errors.
App\Entity\SchoolRegistration No errors.