Query Metrics
54
Database Queries
9
Different statements
7.30 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.14 ms |
SELECT p0_.id AS id_0, p0_.is_home AS is_home_1, p0_.privacy AS privacy_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p1_.id AS id_5, p1_.title AS title_6, p1_.slug AS slug_7, p1_.description AS description_8, p1_.keywords AS keywords_9, p1_.locale AS locale_10, t2_.id AS id_11, t2_.name AS name_12, t2_.filename AS filename_13, t3_.id AS id_14, t3_.position AS position_15, f4_.id AS id_16, f4_.collection_id AS collection_id_17, f4_.locale AS locale_18, f4_.value AS value_19, f4_.updated_at AS updated_at_20, f5_.id AS id_21, f5_.name AS name_22, f5_.identifier AS identifier_23, f5_.required AS required_24, f5_.position AS position_25, f6_.id AS id_26, f6_.name AS name_27, f6_.slug AS slug_28, f7_.id AS id_29, f7_.name AS name_30, f7_.value AS value_31, f7_.position AS position_32, p0_.template_id AS template_id_33, p1_.page_id AS page_id_34, t3_.template_id AS template_id_35, t3_.block_id AS block_id_36, f4_.page_id AS page_id_37, f4_.field_id AS field_id_38, f4_.parent_id AS parent_id_39, f5_.type_id AS type_id_40, f5_.block_id AS block_id_41, f5_.parent_id AS parent_id_42, f6_.parent_id AS parent_id_43, f7_.field_id AS field_id_44 FROM page p0_ LEFT JOIN page_meta p1_ ON p0_.id = p1_.page_id AND (p1_.locale = ?) LEFT JOIN template t2_ ON p0_.template_id = t2_.id LEFT JOIN template_block t3_ ON t2_.id = t3_.template_id LEFT JOIN field_value f4_ ON p0_.id = f4_.page_id AND (f4_.locale = ?) LEFT JOIN field f5_ ON f4_.field_id = f5_.id LEFT JOIN field_category f6_ ON f5_.type_id = f6_.id LEFT JOIN field_option f7_ ON f5_.id = f7_.field_id WHERE p0_.is_home = ?
Parameters:
[ "fr" "fr" 1 ] |
| 2 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.identifier AS identifier_4, t0.position AS position_5 FROM block t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 3 | 0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.identifier AS identifier_3, t0.required AS required_4, t0.position AS position_5, t0.type_id AS type_id_6, t0.block_id AS block_id_7, t0.parent_id AS parent_id_8 FROM field t0 WHERE t0.id = ?
Parameters:
[
48
]
|
| 4 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.identifier AS identifier_4, t0.position AS position_5 FROM block t0 WHERE t0.id = ?
Parameters:
[
12
]
|
| 5 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.identifier AS identifier_3, t0.required AS required_4, t0.position AS position_5, t0.type_id AS type_id_6, t0.block_id AS block_id_7, t0.parent_id AS parent_id_8 FROM field t0 WHERE t0.id = ?
Parameters:
[
54
]
|
| 6 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.identifier AS identifier_4, t0.position AS position_5 FROM block t0 WHERE t0.id = ?
Parameters:
[
13
]
|
| 7 | 0.16 ms |
SELECT t0.id AS id_1, t0.thumbnail AS thumbnail_2, t0.is_published AS is_published_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.published_at AS published_at_6, t0.category_id AS category_id_7 FROM article t0 WHERE t0.id = ?
Parameters:
[
"1"
]
|
| 8 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.identifier AS identifier_3, t0.required AS required_4, t0.position AS position_5, t0.type_id AS type_id_6, t0.block_id AS block_id_7, t0.parent_id AS parent_id_8 FROM field t0 WHERE t0.id = ?
Parameters:
[
16
]
|
| 9 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.identifier AS identifier_4, t0.position AS position_5 FROM block t0 WHERE t0.id = ?
Parameters:
[
9
]
|
| 10 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.identifier AS identifier_3, t0.required AS required_4, t0.position AS position_5, t0.type_id AS type_id_6, t0.block_id AS block_id_7, t0.parent_id AS parent_id_8 FROM field t0 WHERE t0.id = ?
Parameters:
[
24
]
|
| 11 | 0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.identifier AS identifier_4, t0.position AS position_5 FROM block t0 WHERE t0.id = ?
Parameters:
[
10
]
|
| 12 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.identifier AS identifier_3, t0.required AS required_4, t0.position AS position_5, t0.type_id AS type_id_6, t0.block_id AS block_id_7, t0.parent_id AS parent_id_8 FROM field t0 WHERE t0.id = ?
Parameters:
[
31
]
|
| 13 | 0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.identifier AS identifier_4, t0.position AS position_5 FROM block t0 WHERE t0.id = ?
Parameters:
[
11
]
|
| 14 | 0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.identifier AS identifier_4, t0.position AS position_5 FROM block t0 WHERE t0.id = ?
Parameters:
[
14
]
|
| 15 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.identifier AS identifier_3, t0.required AS required_4, t0.position AS position_5, t0.type_id AS type_id_6, t0.block_id AS block_id_7, t0.parent_id AS parent_id_8 FROM field t0 WHERE t0.id = ?
Parameters:
[
59
]
|
| 16 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM configuration t0
Parameters:
[] |
| 17 | 0.22 ms |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.location AS location_2, m1_.id AS id_3, m1_.type AS type_4, m1_.label AS label_5, m1_.url AS url_6, m1_.locale AS locale_7, m1_.position AS position_8, m2_.id AS id_9, m2_.type AS type_10, m2_.label AS label_11, m2_.url AS url_12, m2_.locale AS locale_13, m2_.position AS position_14, m1_.menu_id AS menu_id_15, m1_.parent_id AS parent_id_16, m2_.menu_id AS menu_id_17, m2_.parent_id AS parent_id_18 FROM menu m0_ LEFT JOIN menu_link m1_ ON m0_.id = m1_.menu_id AND (m1_.locale = ?) LEFT JOIN menu_link m2_ ON m1_.id = m2_.parent_id AND (m2_.locale = ?) WHERE m1_.parent_id IS NULL ORDER BY m1_.position ASC, m2_.position ASC
Parameters:
[ "fr" "fr" ] |
| 18 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 19 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 20 | 0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 21 | 0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 22 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 23 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 24 | 0.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 25 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 26 | 0.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 27 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 28 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 29 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 30 | 0.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 31 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 32 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 33 | 0.17 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.article_id AS article_id_6 FROM article_meta t0 WHERE t0.article_id = ?
Parameters:
[
1
]
|
| 34 | 0.19 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.locale AS locale_3, t0.article_id AS article_id_4 FROM article_content t0 WHERE t0.article_id = ?
Parameters:
[
1
]
|
| 35 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 36 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 37 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 38 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 39 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 40 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 41 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 42 | 0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 43 | 0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 44 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 45 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 46 | 0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 47 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 48 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 49 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 50 | 0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 51 | 0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 52 | 0.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 53 | 0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
| 54 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.root_id AS root_id_5 FROM style t0
Parameters:
[] |
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\Page | No errors. |
| App\Entity\Page\PageMeta | No errors. |
| App\Entity\Template\Template | No errors. |
| App\Entity\Template\TemplateBlock | No errors. |
| App\Entity\Field\FieldValue | No errors. |
| App\Entity\Field\Field | No errors. |
| App\Entity\Field\FieldCategory | No errors. |
| App\Entity\Field\FieldOption | No errors. |
| App\Entity\Template\Block | No errors. |
| App\Entity\User\User | No errors. |
| App\Entity\User\UserGroup | No errors. |
| App\Entity\Article\Article | No errors. |
| App\Entity\Article\ArticleCategory | No errors. |
| App\Entity\Article\ArticleMeta | No errors. |
| App\Entity\Article\ArticleContent | No errors. |
| App\Entity\Configuration\Configuration | No errors. |
| App\Entity\Configuration\Root | No errors. |
| App\Entity\Menu\Menu | No errors. |
| App\Entity\Menu\MenuLink | No errors. |
| App\Entity\Configuration\Style | No errors. |