Query Metrics
63
Database Queries
11
Different statements
20.18 ms
Query time
0
Invalid entities
70
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
5.96 ms (29.55%) |
22 |
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:
[ "ApKnowhow\ApEchoBundle\Entity\Page" 8718 ] |
||||||||||||||||||||||||||||||||
|
5.90 ms (29.22%) |
19 |
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.exclude_slug AS exclude_slug_11, t0.in_sitemap AS in_sitemap_12, t0.in_menu AS in_menu_13, t0.published_template AS published_template_14, t0.published_data AS published_data_15, t0.published AS published_16, t0.published_at AS published_at_17, t0.data AS data_18, t0.created_at AS created_at_19, t0.created_by AS created_by_20, t0.created_from AS created_from_21, t0.updated_at AS updated_at_22, t0.updated_by AS updated_by_23, t0.updated_from AS updated_from_24, t0.deleted_by AS deleted_by_25, t0.deleted_from AS deleted_from_26, t0.deleted_at AS deleted_at_27, t0.parent_id AS parent_id_28, t0.canonical_page_id AS canonical_page_id_29, t0.social_share_image_id AS social_share_image_id_30 FROM page t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"8714"
]
|
||||||||||||||||||||||||||||||||
|
1.99 ms (9.84%) |
6 |
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 8720 ]
|
||||||||||||||||||||||||||||||||
|
1.60 ms (7.91%) |
6 |
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:
[
8720
]
|
||||||||||||||||||||||||||||||||
|
1.45 ms (7.19%) |
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:
[ "ApKnowhow\ApEchoBundle\Entity\Page" 8718 ] |
||||||||||||||||||||||||||||||||
|
1.22 ms (6.05%) |
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:
[
8721
]
|
||||||||||||||||||||||||||||||||
|
0.59 ms (2.93%) |
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_.exclude_slug AS exclude_slug_10, p0_.in_sitemap AS in_sitemap_11, p0_.in_menu AS in_menu_12, p0_.published_template AS published_template_13, p0_.published_data AS published_data_14, p0_.published AS published_15, p0_.published_at AS published_at_16, p0_.data AS data_17, p0_.created_at AS created_at_18, p0_.created_by AS created_by_19, p0_.created_from AS created_from_20, p0_.updated_at AS updated_at_21, p0_.updated_by AS updated_by_22, p0_.updated_from AS updated_from_23, p0_.deleted_by AS deleted_by_24, p0_.deleted_from AS deleted_from_25, p0_.deleted_at AS deleted_at_26, p0_.parent_id AS parent_id_27, p0_.canonical_page_id AS canonical_page_id_28, p0_.social_share_image_id AS social_share_image_id_29 FROM page p0_ WHERE (p0_.slug = ? AND p0_.parent_id IS NULL) AND (p0_.deleted_at IS NULL)
Parameters:
[
"contact"
]
|
||||||||||||||||||||||||||||||||
|
0.55 ms (2.72%) |
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:
[ "/contact" 1 ]
|
||||||||||||||||||||||||||||||||
|
0.42 ms (2.08%) |
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.26 ms (1.27%) |
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.25 ms (1.24%) |
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 |
|---|---|
| ApKnowhow\ApEchoBundle\Entity\MenuItem | 41 |
| ApKnowhow\ApEchoBundle\Entity\Page | 20 |
| ApKnowhow\ApEchoBundle\Entity\Menu | 6 |
| ApKnowhow\ApEchoBundle\Entity\DataBlock | 2 |
| ApKnowhow\ApEchoBundle\Entity\SiteSettings | 1 |
external entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
external entity manager
No loaded entities.