Query Metrics
10
Database Queries
8
Different statements
3.72 ms
Query time
4
Invalid entities
16
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.71 ms (19.03%) |
1 |
SELECT p0_.name AS name_0, p0_.route AS route_1, p0_.domain AS domain_2, p0_.path AS path_3, p0_.resource AS resource_4, p0_.lang AS lang_5, p0_.providers AS providers_6, p0_.layouts AS layouts_7, p0_.meta AS meta_8, p0_.custom_header_code AS custom_header_code_9, p0_.custom_footer_code AS custom_footer_code_10, p0_.etag AS etag_11, p0_.cache_ttl AS cache_ttl_12, p0_.public AS public_13, p0_.permission AS permission_14, p0_.searchable AS searchable_15, p0_.sitemap AS sitemap_16, p0_.id AS id_17, p0_.custom_id AS custom_id_18, p0_.configurations AS configurations_19, p0_.enabled AS enabled_20, p0_.created AS created_21, p0_.updated AS updated_22, p0_.deleted AS deleted_23, p0_.type AS type_24, p0_.system AS system_25, p0_.group_id AS group_id_26, p0_.og_layout AS og_layout_27, p0_.extension_id AS extension_id_28 FROM page p0_ WHERE p0_.path = ? AND p0_.route = ? LIMIT 1
Parameters:
[ "item" "nilead.theme.frontend.page.sluggable_resource_show" ] |
|
0.68 ms (18.35%) |
2 |
SELECT t0_.name AS name_0, t0_.id AS id_1, t0_.color AS color_2, t0_.created AS created_3, t0_.updated AS updated_4, t1_.source AS source_5, t1_.entity_id AS entity_id_6, t1_.id AS id_7, t1_.created AS created_8, t1_.updated AS updated_9, t1_.tag_id AS tag_id_10 FROM tag t0_ INNER JOIN tag_relation t1_ ON t0_.id = t1_.tag_id AND (t1_.source = ? AND t1_.entity_id = ?)
Parameters:
[ "content.content" 219 ] |
|
0.64 ms (17.27%) |
2 |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "595" "es" "Nilead\ThemeBundle\Model\Page" ] |
|
0.43 ms (11.68%) |
1 |
SELECT t0.name AS name_1, t0.route AS route_2, t0.domain AS domain_3, t0.path AS path_4, t0.resource AS resource_5, t0.lang AS lang_6, t0.providers AS providers_7, t0.layouts AS layouts_8, t0.meta AS meta_9, t0.custom_header_code AS custom_header_code_10, t0.custom_footer_code AS custom_footer_code_11, t0.etag AS etag_12, t0.cache_ttl AS cache_ttl_13, t0.public AS public_14, t0.permission AS permission_15, t0.searchable AS searchable_16, t0.sitemap AS sitemap_17, t0.id AS id_18, t0.custom_id AS custom_id_19, t0.configurations AS configurations_20, t0.enabled AS enabled_21, t0.created AS created_22, t0.updated AS updated_23, t0.deleted AS deleted_24, t0.type AS type_25, t0.system AS system_26, t0.group_id AS group_id_27, t0.og_layout AS og_layout_28, t0.extension_id AS extension_id_29 FROM page t0 WHERE t0.id = ?
Parameters:
[
595
]
|
|
0.43 ms (11.55%) |
1 |
SELECT c0_.name AS name_0, c0_.summary AS summary_1, c0_.description AS description_2, c0_.position AS position_3, c0_.id AS id_4, c0_.custom_id AS custom_id_5, c0_.slug AS slug_6, c0_.featured AS featured_7, c0_.created AS created_8, c0_.updated AS updated_9, c0_.deleted AS deleted_10, c0_.lock_expired AS lock_expired_11, c0_.published AS published_12, c0_.enabled AS enabled_13, c0_.locker_id AS locker_id_14, c0_.extension_id AS extension_id_15, c0_.owner_id AS owner_id_16 FROM content c0_ WHERE c0_.slug = ? AND c0_.extension_id = ? LIMIT 1
Parameters:
[ "polybutylene" 56 ] |
|
0.31 ms (8.34%) |
1 |
SELECT e0_.field AS field_0, e0_.value AS value_1, e0_.entity_id AS entity_id_2, e0_.source AS source_3, e0_.id AS id_4 FROM extension_field e0_ WHERE e0_.source = ? AND e0_.entity_id = ?
Parameters:
[ "content.content" 219 ] |
|
0.26 ms (7.05%) |
1 |
SELECT e0_.name AS name_0, e0_.route AS route_1, e0_.path AS path_2, e0_.source AS source_3, e0_.private AS private_4, e0_.id AS id_5, e0_.custom_id AS custom_id_6, e0_.description AS description_7, e0_.created AS created_8, e0_.updated AS updated_9, e0_.system AS system_10, e0_.form_definition AS form_definition_11, e0_.`references` AS references_12, e0_.configurations AS configurations_13 FROM extension e0_ WHERE e0_.source = ? AND e0_.route = ? LIMIT 1
Parameters:
[ "content.content" "item" ] |
|
0.25 ms (6.75%) |
1 |
SELECT t0.name AS name_1, t0.summary AS summary_2, t0.description AS description_3, t0.position AS position_4, t0.id AS id_5, t0.custom_id AS custom_id_6, t0.slug AS slug_7, t0.featured AS featured_8, t0.created AS created_9, t0.updated AS updated_10, t0.deleted AS deleted_11, t0.lock_expired AS lock_expired_12, t0.published AS published_13, t0.enabled AS enabled_14, t0.locker_id AS locker_id_15, t0.extension_id AS extension_id_16, t0.owner_id AS owner_id_17 FROM content t0 WHERE t0.id = ?
Parameters:
[
219
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| Nilead\ExtensionBundle\Model\ExtensionField | 13 |
| Nilead\ThemeBundle\Model\Page | 1 |
| Nilead\ExtensionBundle\Model\Extension | 1 |
| Nilead\ContentBundle\Model\Content | 1 |