Query Metrics
54
Database Queries
9
Different statements
6.15 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.92 ms (0.00%) |
35 |
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:
[] |
1.01 ms (0.00%) |
1 |
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 ] |
0.72 ms (0.00%) |
7 |
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
]
|
0.71 ms (0.00%) |
6 |
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
]
|
0.18 ms (0.00%) |
1 |
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"
]
|
0.17 ms (0.00%) |
1 |
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" ] |
0.16 ms (0.00%) |
1 |
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:
[] |
0.14 ms (0.00%) |
1 |
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
]
|
0.12 ms (0.00%) |
1 |
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
]
|
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. |