Query Metrics
48
Database Queries
12
Different statements
18.70 ms
Query time
0
Invalid entities
53
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
5.79 ms (30.97%) |
18 |
SELECT p0_.id AS id_0, p0_.class_id AS class_id_1, p0_.class_name AS class_name_2, p0_.published AS published_3, p0_.publish_date_time AS publish_date_time_4, p0_.published_at AS published_at_5, p0_.created_at AS created_at_6, p0_.created_by AS created_by_7, p0_.created_from AS created_from_8, p0_.updated_at AS updated_at_9, p0_.updated_by AS updated_by_10, p0_.updated_from AS updated_from_11, p0_.deleted_by AS deleted_by_12, p0_.deleted_from AS deleted_from_13, p0_.deleted_at AS deleted_at_14 FROM publish_schedule p0_ WHERE (p0_.class_name = ? AND p0_.class_id = ? AND p0_.published = 0 AND p0_.publish_date_time >= CURRENT_TIMESTAMP) AND (p0_.deleted_at IS NULL)
Parameters:
[ "App\Entity\Page" 4746 ] |
||||||||||||||||||||||||||||||||||
|
4.07 ms (21.77%) |
13 |
SELECT t0.id AS id_1, t0.template AS template_2, t0.title AS title_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.access_level AS access_level_7, t0.enabled AS enabled_8, t0.name AS name_9, t0.slug AS slug_10, t0.in_sitemap AS in_sitemap_11, t0.in_menu AS in_menu_12, t0.published_template AS published_template_13, t0.published_data AS published_data_14, t0.published AS published_15, t0.published_at AS published_at_16, t0.data AS data_17, t0.created_at AS created_at_18, t0.created_by AS created_by_19, t0.created_from AS created_from_20, t0.updated_at AS updated_at_21, t0.updated_by AS updated_by_22, t0.updated_from AS updated_from_23, t0.deleted_by AS deleted_by_24, t0.deleted_from AS deleted_from_25, t0.deleted_at AS deleted_at_26, t0.parent_id AS parent_id_27, t0.canonical_page_id AS canonical_page_id_28 FROM page t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"6107"
]
|
||||||||||||||||||||||||||||||||||
|
2.09 ms (11.16%) |
1 |
SELECT t0.id AS id_1, t0.class_name AS class_name_2, t0.class_id AS class_id_3, t0.name AS name_4, t0.template AS template_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.published_template AS published_template_8, t0.published_data AS published_data_9, t0.published AS published_10, t0.published_at AS published_at_11, t0.data AS data_12, t0.created_at AS created_at_13, t0.created_by AS created_by_14, t0.created_from AS created_from_15, t0.updated_at AS updated_at_16, t0.updated_by AS updated_by_17, t0.updated_from AS updated_from_18, t0.deleted_by AS deleted_by_19, t0.deleted_from AS deleted_from_20, t0.deleted_at AS deleted_at_21, t0.global_id AS global_id_22, t0.parent_id AS parent_id_23 FROM data_block t0 WHERE t0.class_name = ? AND t0.class_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC
Parameters:
[ "App\Entity\Page" 6107 ] |
||||||||||||||||||||||||||||||||||
|
1.96 ms (10.50%) |
1 |
SELECT t0.id AS id_1, t0.template AS template_2, t0.title AS title_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.enabled AS enabled_7, t0.name AS name_8, t0.slug AS slug_9, t0.in_sitemap AS in_sitemap_10, t0.in_menu AS in_menu_11, t0.published_template AS published_template_12, t0.published_data AS published_data_13, t0.published AS published_14, t0.published_at AS published_at_15, t0.data AS data_16, t0.created_at AS created_at_17, t0.created_by AS created_by_18, t0.created_from AS created_from_19, t0.updated_at AS updated_at_20, t0.updated_by AS updated_by_21, t0.updated_from AS updated_from_22, t0.deleted_by AS deleted_by_23, t0.deleted_from AS deleted_from_24, t0.deleted_at AS deleted_at_25, t0.visibility AS visibility_26 FROM news t0 WHERE t0.published = ? AND ((t0.deleted_at IS NULL) AND (JSON_CONTAINS(t0.visibility, '"website"') = 1)) ORDER BY t0.position ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||
|
1.28 ms (6.85%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.enabled AS enabled_4, t0.position AS position_5, t0.data AS data_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.created_from AS created_from_9, t0.updated_at AS updated_at_10, t0.updated_by AS updated_by_11, t0.updated_from AS updated_from_12, t0.deleted_by AS deleted_by_13, t0.deleted_from AS deleted_from_14, t0.deleted_at AS deleted_at_15, t0.menu_id AS menu_id_16, t0.parent_id AS parent_id_17 FROM menu_item t0 WHERE t0.parent_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC
Parameters:
[
3352
]
|
||||||||||||||||||||||||||||||||||
|
1.13 ms (6.03%) |
3 |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.type AS type_2, m0_.enabled AS enabled_3, m0_.position AS position_4, m0_.data AS data_5, m0_.created_at AS created_at_6, m0_.created_by AS created_by_7, m0_.created_from AS created_from_8, m0_.updated_at AS updated_at_9, m0_.updated_by AS updated_by_10, m0_.updated_from AS updated_from_11, m0_.deleted_by AS deleted_by_12, m0_.deleted_from AS deleted_from_13, m0_.deleted_at AS deleted_at_14, m0_.menu_id AS menu_id_15, m0_.parent_id AS parent_id_16 FROM menu_item m0_ WHERE (m0_.parent_id IS NULL AND m0_.enabled = ? AND m0_.menu_id = ?) AND (m0_.deleted_at IS NULL) ORDER BY m0_.position ASC
Parameters:
[ 1 76 ]
|
||||||||||||||||||||||||||||||||||
|
0.69 ms (3.69%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.css_classes AS css_classes_3, t0.max_depth AS max_depth_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.created_from AS created_from_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.updated_from AS updated_from_11, t0.deleted_by AS deleted_by_12, t0.deleted_from AS deleted_from_13, t0.deleted_at AS deleted_at_14 FROM menu t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
76
]
|
||||||||||||||||||||||||||||||||||
|
0.51 ms (2.75%) |
1 |
SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.source_url AS source_url_2, r0_.redirect_url AS redirect_url_3, r0_.enabled AS enabled_4, r0_.used_count AS used_count_5, r0_.last_used AS last_used_6, r0_.created_at AS created_at_7, r0_.created_by AS created_by_8, r0_.created_from AS created_from_9, r0_.updated_at AS updated_at_10, r0_.updated_by AS updated_by_11, r0_.updated_from AS updated_from_12, r0_.deleted_by AS deleted_by_13, r0_.deleted_from AS deleted_from_14, r0_.deleted_at AS deleted_at_15, r0_.redirect_page_id AS redirect_page_id_16 FROM redirect r0_ WHERE (r0_.source_url = ? AND r0_.enabled = ?) AND (r0_.deleted_at IS NULL) ORDER BY r0_.updated_at DESC LIMIT 1
Parameters:
[ "/news" 1 ]
|
||||||||||||||||||||||||||||||||||
|
0.49 ms (2.60%) |
1 |
SELECT p0_.id AS id_0, p0_.template AS template_1, p0_.title AS title_2, p0_.description AS description_3, p0_.keywords AS keywords_4, p0_.position AS position_5, p0_.access_level AS access_level_6, p0_.enabled AS enabled_7, p0_.name AS name_8, p0_.slug AS slug_9, p0_.in_sitemap AS in_sitemap_10, p0_.in_menu AS in_menu_11, p0_.published_template AS published_template_12, p0_.published_data AS published_data_13, p0_.published AS published_14, p0_.published_at AS published_at_15, p0_.data AS data_16, p0_.created_at AS created_at_17, p0_.created_by AS created_by_18, p0_.created_from AS created_from_19, p0_.updated_at AS updated_at_20, p0_.updated_by AS updated_by_21, p0_.updated_from AS updated_from_22, p0_.deleted_by AS deleted_by_23, p0_.deleted_from AS deleted_from_24, p0_.deleted_at AS deleted_at_25, p0_.parent_id AS parent_id_26, p0_.canonical_page_id AS canonical_page_id_27 FROM page p0_ WHERE (p0_.slug = ? AND p0_.parent_id IS NULL AND p0_.enabled = ?) AND (p0_.deleted_at IS NULL)
Parameters:
[ "news" 1 ]
|
||||||||||||||||||||||||||||||||||
|
0.26 ms (1.36%) |
1 |
SELECT t0.id AS id_1, t0.category AS category_2, t0.name AS name_3, t0.description AS description_4, t0.src AS src_5, t0.fields AS fields_6, t0.enabled AS enabled_7, t0.image_path AS image_path_8, t0.child AS child_9, t0.allowed_page_templates AS allowed_page_templates_10, t0.allowed_children AS allowed_children_11, t0.created_at AS created_at_12, t0.created_by AS created_by_13, t0.created_from AS created_from_14, t0.updated_at AS updated_at_15, t0.updated_by AS updated_by_16, t0.updated_from AS updated_from_17, t0.deleted_by AS deleted_by_18, t0.deleted_from AS deleted_from_19, t0.deleted_at AS deleted_at_20 FROM data_block_template t0 WHERE ((t0.deleted_at IS NULL))
Parameters:
[] |
||||||||||||||||||||||||||||||||||
|
0.22 ms (1.18%) |
1 |
SELECT t0.id AS id_1, t0.data AS data_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.created_from AS created_from_5, t0.updated_at AS updated_at_6, t0.updated_by AS updated_by_7, t0.updated_from AS updated_from_8, t0.deleted_by AS deleted_by_9, t0.deleted_from AS deleted_from_10, t0.deleted_at AS deleted_at_11 FROM site_settings t0 WHERE ((t0.deleted_at IS NULL))
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
|
0.21 ms (1.13%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.src AS src_3, t0.fields AS fields_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.created_from AS created_from_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.updated_from AS updated_from_11, t0.deleted_by AS deleted_by_12, t0.deleted_from AS deleted_from_13, t0.deleted_at AS deleted_at_14 FROM page_template t0
Parameters:
[]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| external | doctrine.dbal.external_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| external | doctrine.orm.external_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\MenuItem | 25 |
| App\Entity\Page | 13 |
| App\Entity\Menu | 3 |
| App\Entity\DataBlock | 3 |
| App\Entity\DataBlockTemplate | 3 |
| App\Entity\News | 3 |
| App\Entity\Redirect | 1 |
| App\Entity\PageTemplate | 1 |
| App\Entity\SiteSettings | 1 |
external entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Upload | No errors. |
| App\Entity\ImageOriginal | No errors. |
| App\Entity\ImageCropped | No errors. |
| App\Entity\ImageCategory | No errors. |
| App\Entity\ImageTemplate | No errors. |
| App\Entity\Redirect | No errors. |
| App\Entity\SiteSettings | No errors. |
| App\Entity\PageTemplate | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\News | No errors. |
| App\Entity\Event | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\FormSubmission | No errors. |
| App\Entity\SiteSearch | No errors. |
| App\Entity\DataBlock | No errors. |
| App\Entity\MenuItem | No errors. |
| App\Entity\PublishSchedule | No errors. |
| App\Entity\DataBlockTemplate | No errors. |
| App\Entity\DataBlockCategory | No errors. |
| App\Entity\DataBlockGlobal | No errors. |
external entity manager
No loaded entities.