https://cappellelagrande.fr/news/a-la-decouverte-du-restaurant-scolaire-avec-votre-enfant

Query Metrics

28 Database Queries
5 Different statements
129.75 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.45 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.slug AS slug_4, t0.featured AS featured_5, t0.hours AS hours_6, t0.begins_at AS begins_at_7, t0.ends_at AS ends_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11 FROM news t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "a-la-decouverte-du-restaurant-scolaire-avec-votre-enfant"
]
2 0.25 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  342
]
3 0.25 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.color AS color_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.image_id AS image_id_7 FROM menu t0 ORDER BY t0.position ASC
Parameters:
[]
4 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.parent_id AS parent_id_6 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  2
]
5 23.58 ms
SELECT t0.id AS id_6, t0.title AS title_7, t0.position AS position_8, t0.slug AS slug_9, t0.is_visible AS is_visible_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_item_id AS menu_item_id_13, t0.discr, t1.description AS description_14, t3.content AS content_15, t4.url AS url_16 FROM page t0 LEFT JOIN trombi t1 ON t0.id = t1.id LEFT JOIN yearbook t2 ON t0.id = t2.id LEFT JOIN content_page t3 ON t0.id = t3.id LEFT JOIN link t4 ON t0.id = t4.id LEFT JOIN document_page t5 ON t0.id = t5.id WHERE t0.menu_item_id = ?
Parameters:
[
  1
]
6 0.51 ms
SELECT t0.id AS id_6, t0.title AS title_7, t0.position AS position_8, t0.slug AS slug_9, t0.is_visible AS is_visible_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_item_id AS menu_item_id_13, t0.discr, t1.description AS description_14, t3.content AS content_15, t4.url AS url_16 FROM page t0 LEFT JOIN trombi t1 ON t0.id = t1.id LEFT JOIN yearbook t2 ON t0.id = t2.id LEFT JOIN content_page t3 ON t0.id = t3.id LEFT JOIN link t4 ON t0.id = t4.id LEFT JOIN document_page t5 ON t0.id = t5.id WHERE t0.menu_item_id = ?
Parameters:
[
  2
]
7 11.09 ms
SELECT t0.id AS id_6, t0.title AS title_7, t0.position AS position_8, t0.slug AS slug_9, t0.is_visible AS is_visible_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_item_id AS menu_item_id_13, t0.discr, t1.description AS description_14, t3.content AS content_15, t4.url AS url_16 FROM page t0 LEFT JOIN trombi t1 ON t0.id = t1.id LEFT JOIN yearbook t2 ON t0.id = t2.id LEFT JOIN content_page t3 ON t0.id = t3.id LEFT JOIN link t4 ON t0.id = t4.id LEFT JOIN document_page t5 ON t0.id = t5.id WHERE t0.menu_item_id = ?
Parameters:
[
  3
]
8 0.36 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  2
]
9 0.16 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.parent_id AS parent_id_6 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  3
]
10 15.28 ms
SELECT t0.id AS id_6, t0.title AS title_7, t0.position AS position_8, t0.slug AS slug_9, t0.is_visible AS is_visible_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_item_id AS menu_item_id_13, t0.discr, t1.description AS description_14, t3.content AS content_15, t4.url AS url_16 FROM page t0 LEFT JOIN trombi t1 ON t0.id = t1.id LEFT JOIN yearbook t2 ON t0.id = t2.id LEFT JOIN content_page t3 ON t0.id = t3.id LEFT JOIN link t4 ON t0.id = t4.id LEFT JOIN document_page t5 ON t0.id = t5.id WHERE t0.menu_item_id = ?
Parameters:
[
  4
]
11 10.47 ms
SELECT t0.id AS id_6, t0.title AS title_7, t0.position AS position_8, t0.slug AS slug_9, t0.is_visible AS is_visible_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_item_id AS menu_item_id_13, t0.discr, t1.description AS description_14, t3.content AS content_15, t4.url AS url_16 FROM page t0 LEFT JOIN trombi t1 ON t0.id = t1.id LEFT JOIN yearbook t2 ON t0.id = t2.id LEFT JOIN content_page t3 ON t0.id = t3.id LEFT JOIN link t4 ON t0.id = t4.id LEFT JOIN document_page t5 ON t0.id = t5.id WHERE t0.menu_item_id = ?
Parameters:
[
  5
]
12 2.89 ms
SELECT t0.id AS id_6, t0.title AS title_7, t0.position AS position_8, t0.slug AS slug_9, t0.is_visible AS is_visible_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_item_id AS menu_item_id_13, t0.discr, t1.description AS description_14, t3.content AS content_15, t4.url AS url_16 FROM page t0 LEFT JOIN trombi t1 ON t0.id = t1.id LEFT JOIN yearbook t2 ON t0.id = t2.id LEFT JOIN content_page t3 ON t0.id = t3.id LEFT JOIN link t4 ON t0.id = t4.id LEFT JOIN document_page t5 ON t0.id = t5.id WHERE t0.menu_item_id = ?
Parameters:
[
  6
]
13 15.30 ms
SELECT t0.id AS id_6, t0.title AS title_7, t0.position AS position_8, t0.slug AS slug_9, t0.is_visible AS is_visible_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_item_id AS menu_item_id_13, t0.discr, t1.description AS description_14, t3.content AS content_15, t4.url AS url_16 FROM page t0 LEFT JOIN trombi t1 ON t0.id = t1.id LEFT JOIN yearbook t2 ON t0.id = t2.id LEFT JOIN content_page t3 ON t0.id = t3.id LEFT JOIN link t4 ON t0.id = t4.id LEFT JOIN document_page t5 ON t0.id = t5.id WHERE t0.menu_item_id = ?
Parameters:
[
  7
]
14 0.68 ms
SELECT t0.id AS id_6, t0.title AS title_7, t0.position AS position_8, t0.slug AS slug_9, t0.is_visible AS is_visible_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_item_id AS menu_item_id_13, t0.discr, t1.description AS description_14, t3.content AS content_15, t4.url AS url_16 FROM page t0 LEFT JOIN trombi t1 ON t0.id = t1.id LEFT JOIN yearbook t2 ON t0.id = t2.id LEFT JOIN content_page t3 ON t0.id = t3.id LEFT JOIN link t4 ON t0.id = t4.id LEFT JOIN document_page t5 ON t0.id = t5.id WHERE t0.menu_item_id = ?
Parameters:
[
  8
]
15 0.16 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  3
]
16 0.13 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.parent_id AS parent_id_6 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  4
]
17 1.95 ms
SELECT t0.id AS id_6, t0.title AS title_7, t0.position AS position_8, t0.slug AS slug_9, t0.is_visible AS is_visible_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_item_id AS menu_item_id_13, t0.discr, t1.description AS description_14, t3.content AS content_15, t4.url AS url_16 FROM page t0 LEFT JOIN trombi t1 ON t0.id = t1.id LEFT JOIN yearbook t2 ON t0.id = t2.id LEFT JOIN content_page t3 ON t0.id = t3.id LEFT JOIN link t4 ON t0.id = t4.id LEFT JOIN document_page t5 ON t0.id = t5.id WHERE t0.menu_item_id = ?
Parameters:
[
  9
]
18 13.79 ms
SELECT t0.id AS id_6, t0.title AS title_7, t0.position AS position_8, t0.slug AS slug_9, t0.is_visible AS is_visible_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_item_id AS menu_item_id_13, t0.discr, t1.description AS description_14, t3.content AS content_15, t4.url AS url_16 FROM page t0 LEFT JOIN trombi t1 ON t0.id = t1.id LEFT JOIN yearbook t2 ON t0.id = t2.id LEFT JOIN content_page t3 ON t0.id = t3.id LEFT JOIN link t4 ON t0.id = t4.id LEFT JOIN document_page t5 ON t0.id = t5.id WHERE t0.menu_item_id = ?
Parameters:
[
  10
]
19 5.22 ms
SELECT t0.id AS id_6, t0.title AS title_7, t0.position AS position_8, t0.slug AS slug_9, t0.is_visible AS is_visible_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_item_id AS menu_item_id_13, t0.discr, t1.description AS description_14, t3.content AS content_15, t4.url AS url_16 FROM page t0 LEFT JOIN trombi t1 ON t0.id = t1.id LEFT JOIN yearbook t2 ON t0.id = t2.id LEFT JOIN content_page t3 ON t0.id = t3.id LEFT JOIN link t4 ON t0.id = t4.id LEFT JOIN document_page t5 ON t0.id = t5.id WHERE t0.menu_item_id = ?
Parameters:
[
  11
]
20 11.61 ms
SELECT t0.id AS id_6, t0.title AS title_7, t0.position AS position_8, t0.slug AS slug_9, t0.is_visible AS is_visible_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_item_id AS menu_item_id_13, t0.discr, t1.description AS description_14, t3.content AS content_15, t4.url AS url_16 FROM page t0 LEFT JOIN trombi t1 ON t0.id = t1.id LEFT JOIN yearbook t2 ON t0.id = t2.id LEFT JOIN content_page t3 ON t0.id = t3.id LEFT JOIN link t4 ON t0.id = t4.id LEFT JOIN document_page t5 ON t0.id = t5.id WHERE t0.menu_item_id = ?
Parameters:
[
  12
]
21 0.36 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  4
]
22 0.14 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.parent_id AS parent_id_6 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  5
]
23 3.63 ms
SELECT t0.id AS id_6, t0.title AS title_7, t0.position AS position_8, t0.slug AS slug_9, t0.is_visible AS is_visible_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_item_id AS menu_item_id_13, t0.discr, t1.description AS description_14, t3.content AS content_15, t4.url AS url_16 FROM page t0 LEFT JOIN trombi t1 ON t0.id = t1.id LEFT JOIN yearbook t2 ON t0.id = t2.id LEFT JOIN content_page t3 ON t0.id = t3.id LEFT JOIN link t4 ON t0.id = t4.id LEFT JOIN document_page t5 ON t0.id = t5.id WHERE t0.menu_item_id = ?
Parameters:
[
  13
]
24 3.60 ms
SELECT t0.id AS id_6, t0.title AS title_7, t0.position AS position_8, t0.slug AS slug_9, t0.is_visible AS is_visible_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_item_id AS menu_item_id_13, t0.discr, t1.description AS description_14, t3.content AS content_15, t4.url AS url_16 FROM page t0 LEFT JOIN trombi t1 ON t0.id = t1.id LEFT JOIN yearbook t2 ON t0.id = t2.id LEFT JOIN content_page t3 ON t0.id = t3.id LEFT JOIN link t4 ON t0.id = t4.id LEFT JOIN document_page t5 ON t0.id = t5.id WHERE t0.menu_item_id = ?
Parameters:
[
  14
]
25 3.74 ms
SELECT t0.id AS id_6, t0.title AS title_7, t0.position AS position_8, t0.slug AS slug_9, t0.is_visible AS is_visible_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_item_id AS menu_item_id_13, t0.discr, t1.description AS description_14, t3.content AS content_15, t4.url AS url_16 FROM page t0 LEFT JOIN trombi t1 ON t0.id = t1.id LEFT JOIN yearbook t2 ON t0.id = t2.id LEFT JOIN content_page t3 ON t0.id = t3.id LEFT JOIN link t4 ON t0.id = t4.id LEFT JOIN document_page t5 ON t0.id = t5.id WHERE t0.menu_item_id = ?
Parameters:
[
  15
]
26 2.43 ms
SELECT t0.id AS id_6, t0.title AS title_7, t0.position AS position_8, t0.slug AS slug_9, t0.is_visible AS is_visible_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_item_id AS menu_item_id_13, t0.discr, t1.description AS description_14, t3.content AS content_15, t4.url AS url_16 FROM page t0 LEFT JOIN trombi t1 ON t0.id = t1.id LEFT JOIN yearbook t2 ON t0.id = t2.id LEFT JOIN content_page t3 ON t0.id = t3.id LEFT JOIN link t4 ON t0.id = t4.id LEFT JOIN document_page t5 ON t0.id = t5.id WHERE t0.menu_item_id = ?
Parameters:
[
  16
]
27 0.32 ms
SELECT t0.id AS id_6, t0.title AS title_7, t0.position AS position_8, t0.slug AS slug_9, t0.is_visible AS is_visible_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_item_id AS menu_item_id_13, t0.discr, t1.description AS description_14, t3.content AS content_15, t4.url AS url_16 FROM page t0 LEFT JOIN trombi t1 ON t0.id = t1.id LEFT JOIN yearbook t2 ON t0.id = t2.id LEFT JOIN content_page t3 ON t0.id = t3.id LEFT JOIN link t4 ON t0.id = t4.id LEFT JOIN document_page t5 ON t0.id = t5.id WHERE t0.menu_item_id = ?
Parameters:
[
  17
]
28 0.14 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  5
]

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\News No errors.
App\Entity\Image No errors.
App\Entity\Menu No errors.
App\Entity\MenuItem No errors.
App\Entity\Page No errors.
App\Entity\Trombi No errors.
App\Entity\Yearbook No errors.
App\Entity\ContentPage No errors.
App\Entity\Link No errors.
App\Entity\DocumentPage No errors.
App\Entity\Document No errors.
App\Entity\TrombiCategory No errors.
App\Entity\YearbookCategory No errors.
App\Entity\TrombiItem No errors.
App\Entity\YearbookItem No errors.