Query Metrics
38
Database Queries
4
Different statements
10.32 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 4.37 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 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 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 p1_.slug = ? AND p1_.locale = ?
Parameters:
[ "oui" "fr" ] |
2 | 0.73 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:
[] |
3 | 1.51 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" ] |
4 | 0.38 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:
[] |
5 | 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:
[] |
6 | 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:
[] |
7 | 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:
[] |
8 | 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:
[] |
9 | 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:
[] |
10 | 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:
[] |
11 | 0.24 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:
[] |
12 | 0.17 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:
[] |
13 | 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:
[] |
14 | 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:
[] |
15 | 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:
[] |
16 | 0.12 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:
[] |
17 | 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:
[] |
18 | 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:
[] |
19 | 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:
[] |
20 | 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:
[] |
21 | 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:
[] |
22 | 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:
[] |
23 | 0.05 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.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:
[] |
25 | 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:
[] |
26 | 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:
[] |
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.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:
[] |
29 | 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:
[] |
30 | 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:
[] |
31 | 0.17 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.16 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:
[] |
34 | 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:
[] |
35 | 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:
[] |
36 | 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:
[] |
37 | 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:
[] |
38 | 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:
[] |
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\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. |