GET https://preprod.button-hop.com/fr

Query Metrics

33 Database Queries
8 Different statements
11.84 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.48 ms
SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2 FROM language l0_ WHERE l0_.code = ?
Parameters:
[
  "fr"
]
2 0.56 ms
SELECT p0_.title AS title_0, p0_.meta_description AS meta_description_1, p0_.og_description AS og_description_2, p0_.og_title AS og_title_3, p0_.slug AS slug_4, p0_.is_published AS is_published_5, p0_.update_date AS update_date_6, p0_.meta_keywords AS meta_keywords_7, p0_.json_ld AS json_ld_8, p0_.id AS id_9, p0_.content AS content_10, p0_.og_image_id AS og_image_id_11, p0_.language_id AS language_id_12 FROM page p0_ WHERE p0_.slug = ?
Parameters:
[
  "home"
]
3 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3 FROM media t0 WHERE t0.id = ?
Parameters:
[
  26
]
4 0.43 ms
SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2 FROM language l0_ WHERE l0_.code = ?
Parameters:
[
  "fr"
]
5 0.82 ms
SELECT m0_.id AS id_0, m0_.label AS label_1, m0_.title AS title_2, m0_.is_active AS is_active_3, m0_.position AS position_4, m0_.page_id AS page_id_5, m0_.parent_id AS parent_id_6, m0_.language_id AS language_id_7 FROM menu m0_ WHERE m0_.is_active = 1 AND m0_.parent_id IS NULL AND m0_.language_id = ? ORDER BY m0_.position ASC
Parameters:
[
  1
]
6 0.38 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.title AS title_3, t0.is_active AS is_active_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7, t0.language_id AS language_id_8 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
7 0.45 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.title AS title_3, t0.is_active AS is_active_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7, t0.language_id AS language_id_8 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  10
]
8 0.38 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?
Parameters:
[
  11
]
9 0.38 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?
Parameters:
[
  12
]
10 0.43 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?
Parameters:
[
  13
]
11 0.33 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?
Parameters:
[
  14
]
12 0.43 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.title AS title_3, t0.is_active AS is_active_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7, t0.language_id AS language_id_8 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  2
]
13 0.30 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?
Parameters:
[
  2
]
14 0.32 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?
Parameters:
[
  4
]
15 0.31 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?
Parameters:
[
  3
]
16 0.30 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?
Parameters:
[
  15
]
17 0.33 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.title AS title_3, t0.is_active AS is_active_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7, t0.language_id AS language_id_8 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  9
]
18 0.31 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?
Parameters:
[
  9
]
19 0.41 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.title AS title_3, t0.is_active AS is_active_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7, t0.language_id AS language_id_8 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  16
]
20 0.31 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?
Parameters:
[
  16
]
21 0.27 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?
Parameters:
[
  17
]
22 0.30 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?
Parameters:
[
  20
]
23 0.28 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?
Parameters:
[
  22
]
24 0.31 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?
Parameters:
[
  23
]
25 0.28 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?
Parameters:
[
  18
]
26 0.28 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?
Parameters:
[
  19
]
27 0.30 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?
Parameters:
[
  21
]
28 0.31 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.title AS title_3, t0.is_active AS is_active_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7, t0.language_id AS language_id_8 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  4
]
29 0.29 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?
Parameters:
[
  5
]
30 0.32 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.title AS title_3, t0.is_active AS is_active_4, t0.position AS position_5, t0.page_id AS page_id_6, t0.parent_id AS parent_id_7, t0.language_id AS language_id_8 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  5
]
31 0.27 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.language_id AS language_id_13 FROM page t0 WHERE t0.id = ?
Parameters:
[
  7
]
32 0.28 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM language t0 WHERE t0.id = ?
Parameters:
[
  2
]
33 0.31 ms
SELECT t0.title AS title_1, t0.meta_description AS meta_description_2, t0.og_description AS og_description_3, t0.og_title AS og_title_4, t0.slug AS slug_5, t0.is_published AS is_published_6, t0.update_date AS update_date_7, t0.meta_keywords AS meta_keywords_8, t0.json_ld AS json_ld_9, t0.id AS id_10, t0.content AS content_11, t0.og_image_id AS og_image_id_12, t0.page_id AS page_id_13 FROM article t0 WHERE t0.page_id = ?
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\Language No errors.
App\Entity\AbstractSeoResource No errors.
App\Entity\Page No errors.
App\Entity\Menu No errors.
App\Entity\Media
  • The target entity 'App\Entity\AbstractSeoResource' specified on App\Entity\Media#abstractSeoResources is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Article No errors.