https://www.biereau.mywebcreation.be/

Query Metrics

42 Database Queries
8 Different statements
8.62 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.42 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.slogan AS slogan_3, t0.link_to_menu AS link_to_menu_4, t0.updated_at AS updated_at_5 FROM site_home_page_carousel t0
Parameters:
[]
2 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.article AS article_3, t0.author AS author_4, t0.job AS job_5, t0.url AS url_6, t0.created_at AS created_at_7, t0.internal_route_id AS internal_route_id_8 FROM news t0
Parameters:
[]
3 0.42 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3 FROM school_value t0
Parameters:
[]
4 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.external_link AS external_link_4, t0.position AS position_5 FROM nav_menu t0
Parameters:
[]
5 0.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.external_link AS external_link_4, t0.position AS position_5 FROM nav_menu t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Accueil"
]
6 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.street_num AS street_num_4, t0.postal_code AS postal_code_5, t0.city AS city_6, t0.phone1 AS phone1_7, t0.phone2 AS phone2_8, t0.email1 AS email1_9, t0.email2 AS email2_10 FROM school_data t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
7 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.street_num AS street_num_4, t0.postal_code AS postal_code_5, t0.city AS city_6, t0.phone1 AS phone1_7, t0.phone2 AS phone2_8, t0.email1 AS email1_9, t0.email2 AS email2_10 FROM school_data t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
8 0.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.street_num AS street_num_4, t0.postal_code AS postal_code_5, t0.city AS city_6, t0.phone1 AS phone1_7, t0.phone2 AS phone2_8, t0.email1 AS email1_9, t0.email2 AS email2_10 FROM school_data t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
9 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.street_num AS street_num_4, t0.postal_code AS postal_code_5, t0.city AS city_6, t0.phone1 AS phone1_7, t0.phone2 AS phone2_8, t0.email1 AS email1_9, t0.email2 AS email2_10 FROM school_data t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
10 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.street_num AS street_num_4, t0.postal_code AS postal_code_5, t0.city AS city_6, t0.phone1 AS phone1_7, t0.phone2 AS phone2_8, t0.email1 AS email1_9, t0.email2 AS email2_10 FROM school_data t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
11 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.street_num AS street_num_4, t0.postal_code AS postal_code_5, t0.city AS city_6, t0.phone1 AS phone1_7, t0.phone2 AS phone2_8, t0.email1 AS email1_9, t0.email2 AS email2_10 FROM school_data t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
12 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.external_link AS external_link_4, t0.position AS position_5, t0.parent_menu_id AS parent_menu_id_6, t7.id AS id_8, t7.name AS name_9, t7.title AS title_10, t7.created_at AS created_at_11, t7.filename AS filename_12, t7.updated_at AS updated_at_13, t7.parent_sub_menu_id AS parent_sub_menu_id_14, t7.parent_nav_menu_id AS parent_nav_menu_id_15 FROM sub_menu t0 LEFT JOIN basic_page t7 ON t7.parent_sub_menu_id = t0.id WHERE t0.parent_menu_id = ?
Parameters:
[
  1
]
13 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.external_link AS external_link_4, t0.position AS position_5, t0.parent_menu_id AS parent_menu_id_6, t7.id AS id_8, t7.name AS name_9, t7.title AS title_10, t7.created_at AS created_at_11, t7.filename AS filename_12, t7.updated_at AS updated_at_13, t7.parent_sub_menu_id AS parent_sub_menu_id_14, t7.parent_nav_menu_id AS parent_nav_menu_id_15 FROM sub_menu t0 LEFT JOIN basic_page t7 ON t7.parent_sub_menu_id = t0.id WHERE t0.parent_menu_id = ?
Parameters:
[
  2
]
14 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.text AS text_5, t0.created_at AS created_at_6, t0.filename AS filename_7, t0.updated_at AS updated_at_8, t0.parent_page_id AS parent_page_id_9 FROM pageintro t0 WHERE t0.parent_page_id = ?
Parameters:
[
  4
]
15 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.text AS text_5, t0.created_at AS created_at_6, t0.filename AS filename_7, t0.updated_at AS updated_at_8, t0.parent_page_id AS parent_page_id_9 FROM pageintro t0 WHERE t0.parent_page_id = ?
Parameters:
[
  17
]
16 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.text AS text_5, t0.created_at AS created_at_6, t0.filename AS filename_7, t0.updated_at AS updated_at_8, t0.parent_page_id AS parent_page_id_9 FROM pageintro t0 WHERE t0.parent_page_id = ?
Parameters:
[
  19
]
17 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.text AS text_5, t0.created_at AS created_at_6, t0.filename AS filename_7, t0.updated_at AS updated_at_8, t0.parent_page_id AS parent_page_id_9 FROM pageintro t0 WHERE t0.parent_page_id = ?
Parameters:
[
  20
]
18 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.text AS text_5, t0.created_at AS created_at_6, t0.filename AS filename_7, t0.updated_at AS updated_at_8, t0.parent_page_id AS parent_page_id_9 FROM pageintro t0 WHERE t0.parent_page_id = ?
Parameters:
[
  16
]
19 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.text AS text_5, t0.created_at AS created_at_6, t0.filename AS filename_7, t0.updated_at AS updated_at_8, t0.parent_page_id AS parent_page_id_9 FROM pageintro t0 WHERE t0.parent_page_id = ?
Parameters:
[
  18
]
20 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.text AS text_5, t0.created_at AS created_at_6, t0.filename AS filename_7, t0.updated_at AS updated_at_8, t0.parent_page_id AS parent_page_id_9 FROM pageintro t0 WHERE t0.parent_page_id = ?
Parameters:
[
  15
]
21 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.external_link AS external_link_4, t0.position AS position_5, t0.parent_menu_id AS parent_menu_id_6, t7.id AS id_8, t7.name AS name_9, t7.title AS title_10, t7.created_at AS created_at_11, t7.filename AS filename_12, t7.updated_at AS updated_at_13, t7.parent_sub_menu_id AS parent_sub_menu_id_14, t7.parent_nav_menu_id AS parent_nav_menu_id_15 FROM sub_menu t0 LEFT JOIN basic_page t7 ON t7.parent_sub_menu_id = t0.id WHERE t0.parent_menu_id = ?
Parameters:
[
  9
]
22 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.external_link AS external_link_4, t0.position AS position_5, t0.parent_menu_id AS parent_menu_id_6, t7.id AS id_8, t7.name AS name_9, t7.title AS title_10, t7.created_at AS created_at_11, t7.filename AS filename_12, t7.updated_at AS updated_at_13, t7.parent_sub_menu_id AS parent_sub_menu_id_14, t7.parent_nav_menu_id AS parent_nav_menu_id_15 FROM sub_menu t0 LEFT JOIN basic_page t7 ON t7.parent_sub_menu_id = t0.id WHERE t0.parent_menu_id = ?
Parameters:
[
  4
]
23 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.external_link AS external_link_4, t0.position AS position_5, t0.parent_menu_id AS parent_menu_id_6, t7.id AS id_8, t7.name AS name_9, t7.title AS title_10, t7.created_at AS created_at_11, t7.filename AS filename_12, t7.updated_at AS updated_at_13, t7.parent_sub_menu_id AS parent_sub_menu_id_14, t7.parent_nav_menu_id AS parent_nav_menu_id_15 FROM sub_menu t0 LEFT JOIN basic_page t7 ON t7.parent_sub_menu_id = t0.id WHERE t0.parent_menu_id = ?
Parameters:
[
  5
]
24 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.text AS text_5, t0.created_at AS created_at_6, t0.filename AS filename_7, t0.updated_at AS updated_at_8, t0.parent_page_id AS parent_page_id_9 FROM pageintro t0 WHERE t0.parent_page_id = ?
Parameters:
[
  22
]
25 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.text AS text_5, t0.created_at AS created_at_6, t0.filename AS filename_7, t0.updated_at AS updated_at_8, t0.parent_page_id AS parent_page_id_9 FROM pageintro t0 WHERE t0.parent_page_id = ?
Parameters:
[
  24
]
26 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.text AS text_5, t0.created_at AS created_at_6, t0.filename AS filename_7, t0.updated_at AS updated_at_8, t0.parent_page_id AS parent_page_id_9 FROM pageintro t0 WHERE t0.parent_page_id = ?
Parameters:
[
  25
]
27 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.text AS text_5, t0.created_at AS created_at_6, t0.filename AS filename_7, t0.updated_at AS updated_at_8, t0.parent_page_id AS parent_page_id_9 FROM pageintro t0 WHERE t0.parent_page_id = ?
Parameters:
[
  26
]
28 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.text AS text_5, t0.created_at AS created_at_6, t0.filename AS filename_7, t0.updated_at AS updated_at_8, t0.parent_page_id AS parent_page_id_9 FROM pageintro t0 WHERE t0.parent_page_id = ?
Parameters:
[
  27
]
29 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.text AS text_5, t0.created_at AS created_at_6, t0.filename AS filename_7, t0.updated_at AS updated_at_8, t0.parent_page_id AS parent_page_id_9 FROM pageintro t0 WHERE t0.parent_page_id = ?
Parameters:
[
  28
]
30 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.text AS text_5, t0.created_at AS created_at_6, t0.filename AS filename_7, t0.updated_at AS updated_at_8, t0.parent_page_id AS parent_page_id_9 FROM pageintro t0 WHERE t0.parent_page_id = ?
Parameters:
[
  29
]
31 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.text AS text_5, t0.created_at AS created_at_6, t0.filename AS filename_7, t0.updated_at AS updated_at_8, t0.parent_page_id AS parent_page_id_9 FROM pageintro t0 WHERE t0.parent_page_id = ?
Parameters:
[
  30
]
32 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.external_link AS external_link_4, t0.position AS position_5, t0.parent_menu_id AS parent_menu_id_6, t7.id AS id_8, t7.name AS name_9, t7.title AS title_10, t7.created_at AS created_at_11, t7.filename AS filename_12, t7.updated_at AS updated_at_13, t7.parent_sub_menu_id AS parent_sub_menu_id_14, t7.parent_nav_menu_id AS parent_nav_menu_id_15 FROM sub_menu t0 LEFT JOIN basic_page t7 ON t7.parent_sub_menu_id = t0.id WHERE t0.parent_menu_id = ?
Parameters:
[
  6
]
33 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.external_link AS external_link_4, t0.position AS position_5, t0.parent_menu_id AS parent_menu_id_6, t7.id AS id_8, t7.name AS name_9, t7.title AS title_10, t7.created_at AS created_at_11, t7.filename AS filename_12, t7.updated_at AS updated_at_13, t7.parent_sub_menu_id AS parent_sub_menu_id_14, t7.parent_nav_menu_id AS parent_nav_menu_id_15 FROM sub_menu t0 LEFT JOIN basic_page t7 ON t7.parent_sub_menu_id = t0.id WHERE t0.parent_menu_id = ?
Parameters:
[
  7
]
34 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.text AS text_5, t0.created_at AS created_at_6, t0.filename AS filename_7, t0.updated_at AS updated_at_8, t0.parent_page_id AS parent_page_id_9 FROM pageintro t0 WHERE t0.parent_page_id = ?
Parameters:
[
  3
]
35 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.text AS text_5, t0.created_at AS created_at_6, t0.filename AS filename_7, t0.updated_at AS updated_at_8, t0.parent_page_id AS parent_page_id_9 FROM pageintro t0 WHERE t0.parent_page_id = ?
Parameters:
[
  31
]
36 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.external_link AS external_link_4, t0.position AS position_5, t0.parent_menu_id AS parent_menu_id_6, t7.id AS id_8, t7.name AS name_9, t7.title AS title_10, t7.created_at AS created_at_11, t7.filename AS filename_12, t7.updated_at AS updated_at_13, t7.parent_sub_menu_id AS parent_sub_menu_id_14, t7.parent_nav_menu_id AS parent_nav_menu_id_15 FROM sub_menu t0 LEFT JOIN basic_page t7 ON t7.parent_sub_menu_id = t0.id WHERE t0.parent_menu_id = ?
Parameters:
[
  8
]
37 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.text AS text_5, t0.created_at AS created_at_6, t0.filename AS filename_7, t0.updated_at AS updated_at_8, t0.parent_page_id AS parent_page_id_9 FROM pageintro t0 WHERE t0.parent_page_id = ?
Parameters:
[
  21
]
38 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.street_num AS street_num_4, t0.postal_code AS postal_code_5, t0.city AS city_6, t0.phone1 AS phone1_7, t0.phone2 AS phone2_8, t0.email1 AS email1_9, t0.email2 AS email2_10 FROM school_data t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
39 0.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.street_num AS street_num_4, t0.postal_code AS postal_code_5, t0.city AS city_6, t0.phone1 AS phone1_7, t0.phone2 AS phone2_8, t0.email1 AS email1_9, t0.email2 AS email2_10 FROM school_data t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
40 0.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.street_num AS street_num_4, t0.postal_code AS postal_code_5, t0.city AS city_6, t0.phone1 AS phone1_7, t0.phone2 AS phone2_8, t0.email1 AS email1_9, t0.email2 AS email2_10 FROM school_data t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
41 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.street_num AS street_num_4, t0.postal_code AS postal_code_5, t0.city AS city_6, t0.phone1 AS phone1_7, t0.phone2 AS phone2_8, t0.email1 AS email1_9, t0.email2 AS email2_10 FROM school_data t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
42 0.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.street_num AS street_num_4, t0.postal_code AS postal_code_5, t0.city AS city_6, t0.phone1 AS phone1_7, t0.phone2 AS phone2_8, t0.email1 AS email1_9, t0.email2 AS email2_10 FROM school_data t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  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\SiteHomePageCarousel No errors.
App\Entity\NavMenu No errors.
App\Entity\News No errors.
App\Entity\SchoolValue No errors.
App\Entity\SubMenu No errors.
App\Entity\BasicPage No errors.
App\Entity\SchoolData No errors.
App\Entity\Article No errors.
App\Entity\Pageintro No errors.