Query Metrics
19
Database Queries
9
Different statements
9.20 ms
Query time
4
Invalid entities
34
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.52 ms |
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.salt AS salt_5, t0.password AS password_6, t0.confirmation_token AS confirmation_token_7, t0.last_login AS last_login_8, t0.password_requested AS password_requested_9, t0.account_registered AS account_registered_10, t0.account_expired AS account_expired_11, t0.account_locked AS account_locked_12, t0.credentials_expired AS credentials_expired_13, t0.google_authenticator_secret AS google_authenticator_secret_14, t0.id AS id_15, t0.enabled AS enabled_16, t0.created AS created_17, t0.updated AS updated_18, t0.party_id AS party_id_19 FROM account t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 2 | 0.62 ms |
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 = ? LIMIT 1
Parameters:
[
"484482"
]
|
| 3 | 0.34 ms |
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:
[
43
]
|
| 4 | 0.41 ms |
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" 43 ] |
| 5 | 0.69 ms |
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:
[
484481
]
|
| 6 | 0.32 ms |
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:
[
72
]
|
| 7 | 0.40 ms |
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" 98 ] |
| 8 | 0.38 ms |
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" 72 ] |
| 9 | 0.68 ms |
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:
[
484472
]
|
| 10 | 0.32 ms |
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:
[
1
]
|
| 11 | 0.38 ms |
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" 31 ] |
| 12 | 0.38 ms |
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" 1 ] |
| 13 | 0.71 ms |
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:
[
484396
]
|
| 14 | 0.53 ms |
"START TRANSACTION"
Parameters:
[] |
| 15 | 0.13 ms |
"COMMIT"
Parameters:
[] |
| 16 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
| 17 | 0.44 ms |
INSERT INTO widget_change (id, actor_type, ip, source, status, created, applied, duration_ms, user_input, metadata, parent_id, root_id, party_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "chg_c73efd1a086c517d365e90e3" "user" "2a09:bac5:55fa:25d7::3c5:41" "manual_ui" "applied" 1782791553 1782791553 null null "[]" null 484395 6 ] |
| 18 | 0.30 ms |
INSERT INTO widget_change_step (seq, widget_id, widget_path, op_type, target, payload, before_state, after_state, status, error, duration_ms, change_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 0 484482 "aacorp_header > container > container_5 > dropdown > list > language > repeat" "update_content" null "{"changes":[]}" "{"name":"repeat","enabled":true,"deleted":null,"parent_id":484481,"position":0,"configs":[],"mapping":{"items":{"advanced":false,"path_simple":{"provider":"provider_","property":null},"path_advanced":{"path":null},"sort_key":null,"sort_direction":null}},"styles":[],"source_id":null,"reference_roles":null,"widget_type_sku":"repeat__provider"}" "{"name":"repeat","enabled":true,"deleted":null,"parent_id":484481,"position":0,"configs":[],"mapping":{"items":{"advanced":false,"path_simple":{"provider":"provider_","property":null},"path_advanced":{"path":null},"sort_key":null,"sort_direction":null}},"styles":[],"source_id":null,"reference_roles":null,"widget_type_sku":"repeat__provider"}" "applied" null null "chg_c73efd1a086c517d365e90e3" ] |
| 19 | 1.54 ms |
"COMMIT"
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| Nilead\TagBundle\Model\Tag | 9 |
| Nilead\TagBundle\Model\TagRelation | 9 |
| Nilead\BlockBundle\Model\Widget | 7 |
| Nilead\BlockBundle\Model\WidgetType | 5 |
| Nilead\AccountBundle\Model\Account | 1 |
| Nilead\PartyBundle\Model\Party | 1 |
| Nilead\BlockBundle\Model\WidgetChange | 1 |
| Nilead\BlockBundle\Model\WidgetChangeStep | 1 |