Query Metrics
39
Database Queries
11
Different statements
20.55 ms
Query time
4
Invalid entities
103
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
8.61 ms (41.91%) |
11 |
SELECT t0.name AS name_1, t0.alias AS alias_2, t0.styles AS styles_3, t0.providers AS providers_4, t0.mapping AS mapping_5, t0.configs AS configs_6, t0.options AS options_7, t0.interactions AS interactions_8, t0.conditions AS conditions_9, t0.reference_roles AS reference_roles_10, t0.status AS status_11, t0.enabled AS enabled_12, t0.above_fold AS above_fold_13, t0.position AS position_14, t0.is_source AS is_source_15, t0.is_shortcut AS is_shortcut_16, t0.id AS id_17, t0.lock_expired AS lock_expired_18, t0.created AS created_19, t0.updated AS updated_20, t0.deleted AS deleted_21, t0.widget_type_id AS widget_type_id_22, t23.name AS name_24, t23.styles AS styles_25, t23.sku AS sku_26, t23.owner AS owner_27, t23.version AS version_28, t23.publishable AS publishable_29, t23.transparent AS transparent_30, t23.role AS role_31, t23.compatibles AS compatibles_32, t23.framework AS framework_33, t23.providers AS providers_34, t23.mapping AS mapping_35, t23.configs AS configs_36, t23.options AS options_37, t23.interactions AS interactions_38, t23.children AS children_39, t23.system AS system_40, t23.nilead_id AS nilead_id_41, t23.id AS id_42, t23.summary AS summary_43, t23.description AS description_44, t23.enabled AS enabled_45, t23.position AS position_46, t23.created AS created_47, t23.updated AS updated_48, t0.layout_source_id AS layout_source_id_49, t0.source_id AS source_id_50, t51.name AS name_52, t51.alias AS alias_53, t51.styles AS styles_54, t51.providers AS providers_55, t51.mapping AS mapping_56, t51.configs AS configs_57, t51.options AS options_58, t51.interactions AS interactions_59, t51.conditions AS conditions_60, t51.reference_roles AS reference_roles_61, t51.status AS status_62, t51.enabled AS enabled_63, t51.above_fold AS above_fold_64, t51.position AS position_65, t51.is_source AS is_source_66, t51.is_shortcut AS is_shortcut_67, t51.id AS id_68, t51.lock_expired AS lock_expired_69, t51.created AS created_70, t51.updated AS updated_71, t51.deleted AS deleted_72, t51.widget_type_id AS widget_type_id_73, t51.layout_source_id AS layout_source_id_74, t51.source_id AS source_id_75, t51.root_id AS root_id_76, t51.parent_id AS parent_id_77, t51.layout_style_id AS layout_style_id_78, t51.locker_id AS locker_id_79, t0.root_id AS root_id_80, t0.parent_id AS parent_id_81, t82.name AS name_83, t82.alias AS alias_84, t82.styles AS styles_85, t82.providers AS providers_86, t82.mapping AS mapping_87, t82.configs AS configs_88, t82.options AS options_89, t82.interactions AS interactions_90, t82.conditions AS conditions_91, t82.reference_roles AS reference_roles_92, t82.status AS status_93, t82.enabled AS enabled_94, t82.above_fold AS above_fold_95, t82.position AS position_96, t82.is_source AS is_source_97, t82.is_shortcut AS is_shortcut_98, t82.id AS id_99, t82.lock_expired AS lock_expired_100, t82.created AS created_101, t82.updated AS updated_102, t82.deleted AS deleted_103, t82.widget_type_id AS widget_type_id_104, t82.layout_source_id AS layout_source_id_105, t82.source_id AS source_id_106, t82.root_id AS root_id_107, t82.parent_id AS parent_id_108, t82.layout_style_id AS layout_style_id_109, t82.locker_id AS locker_id_110, t0.layout_style_id AS layout_style_id_111, t0.locker_id AS locker_id_112 FROM widget t0 LEFT JOIN widget_type t23 ON t0.widget_type_id = t23.id LEFT JOIN widget t51 ON t0.source_id = t51.id LEFT JOIN widget t82 ON t0.parent_id = t82.id WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
485328
]
|
|
5.10 ms (24.82%) |
15 |
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:
[ "block.widget_type" 47 ] |
|
1.67 ms (8.14%) |
4 |
SELECT c0_.namespace AS namespace_0, c0_.name AS name_1, c0_.value AS value_2, c0_.default_value AS default_value_3, c0_.id AS id_4, c0_.type AS type_5, c0_.created AS created_6, c0_.updated AS updated_7, c0_.system AS system_8 FROM configuration c0_ WHERE c0_.namespace = ?
Parameters:
[
"general"
]
|
|
1.31 ms (6.39%) |
1 |
SELECT w0_.name AS name_0, w0_.alias AS alias_1, w0_.styles AS styles_2, w0_.providers AS providers_3, w0_.mapping AS mapping_4, w0_.configs AS configs_5, w0_.options AS options_6, w0_.interactions AS interactions_7, w0_.conditions AS conditions_8, w0_.reference_roles AS reference_roles_9, w0_.status AS status_10, w0_.enabled AS enabled_11, w0_.above_fold AS above_fold_12, w0_.position AS position_13, w0_.is_source AS is_source_14, w0_.is_shortcut AS is_shortcut_15, w0_.id AS id_16, w0_.lock_expired AS lock_expired_17, w0_.created AS created_18, w0_.updated AS updated_19, w0_.deleted AS deleted_20, w1_.name AS name_21, w1_.alias AS alias_22, w1_.styles AS styles_23, w1_.providers AS providers_24, w1_.mapping AS mapping_25, w1_.configs AS configs_26, w1_.options AS options_27, w1_.interactions AS interactions_28, w1_.conditions AS conditions_29, w1_.reference_roles AS reference_roles_30, w1_.status AS status_31, w1_.enabled AS enabled_32, w1_.above_fold AS above_fold_33, w1_.position AS position_34, w1_.is_source AS is_source_35, w1_.is_shortcut AS is_shortcut_36, w1_.id AS id_37, w1_.lock_expired AS lock_expired_38, w1_.created AS created_39, w1_.updated AS updated_40, w1_.deleted AS deleted_41, w2_.name AS name_42, w2_.styles AS styles_43, w2_.sku AS sku_44, w2_.owner AS owner_45, w2_.version AS version_46, w2_.publishable AS publishable_47, w2_.transparent AS transparent_48, w2_.role AS role_49, w2_.compatibles AS compatibles_50, w2_.framework AS framework_51, w2_.providers AS providers_52, w2_.mapping AS mapping_53, w2_.configs AS configs_54, w2_.options AS options_55, w2_.interactions AS interactions_56, w2_.children AS children_57, w2_.system AS system_58, w2_.nilead_id AS nilead_id_59, w2_.id AS id_60, w2_.summary AS summary_61, w2_.description AS description_62, w2_.enabled AS enabled_63, w2_.position AS position_64, w2_.created AS created_65, w2_.updated AS updated_66, w0_.widget_type_id AS widget_type_id_67, w0_.layout_source_id AS layout_source_id_68, w0_.source_id AS source_id_69, w0_.root_id AS root_id_70, w0_.parent_id AS parent_id_71, w0_.layout_style_id AS layout_style_id_72, w0_.locker_id AS locker_id_73, w1_.widget_type_id AS widget_type_id_74, w1_.layout_source_id AS layout_source_id_75, w1_.source_id AS source_id_76, w1_.root_id AS root_id_77, w1_.parent_id AS parent_id_78, w1_.layout_style_id AS layout_style_id_79, w1_.locker_id AS locker_id_80 FROM widget w0_ LEFT JOIN widget w1_ ON w0_.parent_id = w1_.id LEFT JOIN widget_type w2_ ON w0_.widget_type_id = w2_.id WHERE w0_.enabled = 1 AND w0_.root_id = ? ORDER BY w0_.position ASC
Parameters:
[
485328
]
|
|
0.75 ms (3.64%) |
1 |
SELECT t0.name AS name_1, t0.alias AS alias_2, t0.styles AS styles_3, t0.providers AS providers_4, t0.mapping AS mapping_5, t0.configs AS configs_6, t0.options AS options_7, t0.interactions AS interactions_8, t0.conditions AS conditions_9, t0.reference_roles AS reference_roles_10, t0.status AS status_11, t0.enabled AS enabled_12, t0.above_fold AS above_fold_13, t0.position AS position_14, t0.is_source AS is_source_15, t0.is_shortcut AS is_shortcut_16, t0.id AS id_17, t0.lock_expired AS lock_expired_18, t0.created AS created_19, t0.updated AS updated_20, t0.deleted AS deleted_21, t0.widget_type_id AS widget_type_id_22, t23.name AS name_24, t23.styles AS styles_25, t23.sku AS sku_26, t23.owner AS owner_27, t23.version AS version_28, t23.publishable AS publishable_29, t23.transparent AS transparent_30, t23.role AS role_31, t23.compatibles AS compatibles_32, t23.framework AS framework_33, t23.providers AS providers_34, t23.mapping AS mapping_35, t23.configs AS configs_36, t23.options AS options_37, t23.interactions AS interactions_38, t23.children AS children_39, t23.system AS system_40, t23.nilead_id AS nilead_id_41, t23.id AS id_42, t23.summary AS summary_43, t23.description AS description_44, t23.enabled AS enabled_45, t23.position AS position_46, t23.created AS created_47, t23.updated AS updated_48, t0.layout_source_id AS layout_source_id_49, t0.source_id AS source_id_50, t51.name AS name_52, t51.alias AS alias_53, t51.styles AS styles_54, t51.providers AS providers_55, t51.mapping AS mapping_56, t51.configs AS configs_57, t51.options AS options_58, t51.interactions AS interactions_59, t51.conditions AS conditions_60, t51.reference_roles AS reference_roles_61, t51.status AS status_62, t51.enabled AS enabled_63, t51.above_fold AS above_fold_64, t51.position AS position_65, t51.is_source AS is_source_66, t51.is_shortcut AS is_shortcut_67, t51.id AS id_68, t51.lock_expired AS lock_expired_69, t51.created AS created_70, t51.updated AS updated_71, t51.deleted AS deleted_72, t51.widget_type_id AS widget_type_id_73, t51.layout_source_id AS layout_source_id_74, t51.source_id AS source_id_75, t51.root_id AS root_id_76, t51.parent_id AS parent_id_77, t51.layout_style_id AS layout_style_id_78, t51.locker_id AS locker_id_79, t0.root_id AS root_id_80, t0.parent_id AS parent_id_81, t82.name AS name_83, t82.alias AS alias_84, t82.styles AS styles_85, t82.providers AS providers_86, t82.mapping AS mapping_87, t82.configs AS configs_88, t82.options AS options_89, t82.interactions AS interactions_90, t82.conditions AS conditions_91, t82.reference_roles AS reference_roles_92, t82.status AS status_93, t82.enabled AS enabled_94, t82.above_fold AS above_fold_95, t82.position AS position_96, t82.is_source AS is_source_97, t82.is_shortcut AS is_shortcut_98, t82.id AS id_99, t82.lock_expired AS lock_expired_100, t82.created AS created_101, t82.updated AS updated_102, t82.deleted AS deleted_103, t82.widget_type_id AS widget_type_id_104, t82.layout_source_id AS layout_source_id_105, t82.source_id AS source_id_106, t82.root_id AS root_id_107, t82.parent_id AS parent_id_108, t82.layout_style_id AS layout_style_id_109, t82.locker_id AS locker_id_110, t0.layout_style_id AS layout_style_id_111, t0.locker_id AS locker_id_112 FROM widget t0 LEFT JOIN widget_type t23 ON t0.widget_type_id = t23.id LEFT JOIN widget t51 ON t0.source_id = t51.id LEFT JOIN widget t82 ON t0.parent_id = t82.id WHERE t0.id IN (?, ?, ?, ?)
Parameters:
[ 484954 403107 484951 484957 ] |
|
0.71 ms (3.46%) |
1 |
SELECT w0_.name AS name_0, w0_.alias AS alias_1, w0_.styles AS styles_2, w0_.providers AS providers_3, w0_.mapping AS mapping_4, w0_.configs AS configs_5, w0_.options AS options_6, w0_.interactions AS interactions_7, w0_.conditions AS conditions_8, w0_.reference_roles AS reference_roles_9, w0_.status AS status_10, w0_.enabled AS enabled_11, w0_.above_fold AS above_fold_12, w0_.position AS position_13, w0_.is_source AS is_source_14, w0_.is_shortcut AS is_shortcut_15, w0_.id AS id_16, w0_.lock_expired AS lock_expired_17, w0_.created AS created_18, w0_.updated AS updated_19, w0_.deleted AS deleted_20, w0_.widget_type_id AS widget_type_id_21, w0_.layout_source_id AS layout_source_id_22, w0_.source_id AS source_id_23, w0_.root_id AS root_id_24, w0_.parent_id AS parent_id_25, w0_.layout_style_id AS layout_style_id_26, w0_.locker_id AS locker_id_27 FROM widget w0_ WHERE (w0_.id = ? OR w0_.layout_source_id = ?) AND w0_.status = ? ORDER BY w0_.id DESC
Parameters:
[ 135223 135223 128 ] |
|
0.68 ms (3.31%) |
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_.resource IS NOT NULL AND p0_.deleted IS NULL LIMIT 1
Parameters:
[
"doc"
]
|
|
0.66 ms (3.20%) |
2 |
SELECT t0.name AS name_1, t0.styles AS styles_2, t0.sku AS sku_3, t0.owner AS owner_4, t0.version AS version_5, t0.publishable AS publishable_6, t0.transparent AS transparent_7, t0.role AS role_8, t0.compatibles AS compatibles_9, t0.framework AS framework_10, t0.providers AS providers_11, t0.mapping AS mapping_12, t0.configs AS configs_13, t0.options AS options_14, t0.interactions AS interactions_15, t0.children AS children_16, t0.system AS system_17, t0.nilead_id AS nilead_id_18, t0.id AS id_19, t0.summary AS summary_20, t0.description AS description_21, t0.enabled AS enabled_22, t0.position AS position_23, t0.created AS created_24, t0.updated AS updated_25 FROM widget_type t0 WHERE t0.id IN (?)
Parameters:
[
47
]
|
|
0.40 ms (1.94%) |
1 |
SELECT w0_.name AS name_0, w0_.alias AS alias_1, w0_.styles AS styles_2, w0_.providers AS providers_3, w0_.mapping AS mapping_4, w0_.configs AS configs_5, w0_.options AS options_6, w0_.interactions AS interactions_7, w0_.conditions AS conditions_8, w0_.reference_roles AS reference_roles_9, w0_.status AS status_10, w0_.enabled AS enabled_11, w0_.above_fold AS above_fold_12, w0_.position AS position_13, w0_.is_source AS is_source_14, w0_.is_shortcut AS is_shortcut_15, w0_.id AS id_16, w0_.lock_expired AS lock_expired_17, w0_.created AS created_18, w0_.updated AS updated_19, w0_.deleted AS deleted_20, w0_.widget_type_id AS widget_type_id_21, w0_.layout_source_id AS layout_source_id_22, w0_.source_id AS source_id_23, w0_.root_id AS root_id_24, w0_.parent_id AS parent_id_25, w0_.layout_style_id AS layout_style_id_26, w0_.locker_id AS locker_id_27 FROM widget w0_ WHERE w0_.id = ? AND w0_.enabled = ? LIMIT 1
Parameters:
[ 135223 1 ] |
|
0.35 ms (1.70%) |
1 |
SELECT DISTINCT c0_.id AS id_0 FROM content c0_ WHERE c0_.extension_id = ? AND (c0_.slug = ? AND c0_.enabled = 1) ORDER BY c0_.id DESC LIMIT 1
Parameters:
[ 82 "setting-domain" ] |
|
0.30 ms (1.48%) |
1 |
SELECT t0.name AS name_1, t0.type AS type_2, t0.screens AS screens_3, t0.colors AS colors_4, t0.font_sizes AS font_sizes_5, t0.typographies AS typographies_6, t0.extra AS extra_7, t0.styles AS styles_8, t0.configs AS configs_9, t0.compiled AS compiled_10, t0.id AS id_11, t0.custom_id AS custom_id_12, t0.created AS created_13, t0.updated AS updated_14 FROM style t0 WHERE t0.id = ?
Parameters:
[
4
]
|
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\BlockBundle\Model\Widget | 41 |
| Nilead\TagBundle\Model\Tag | 22 |
| Nilead\TagBundle\Model\TagRelation | 22 |
| Nilead\BlockBundle\Model\WidgetType | 15 |
| Nilead\ThemeBundle\Model\Page | 1 |
| Nilead\ExtensionBundle\Model\Extension | 1 |
| Nilead\BlockBundle\Model\Style | 1 |