Query Metrics
5
Database Queries
5
Different statements
2.37 ms
Query time
4
Invalid entities
9
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.57 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.57 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:
[
"525599"
]
|
| 3 | 0.36 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:
[
47
]
|
| 4 | 0.44 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" 47 ] |
| 5 | 0.44 ms |
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:
[
49
]
|
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 | 2 |
| Nilead\TagBundle\Model\TagRelation | 2 |
| Nilead\AccountBundle\Model\Account | 1 |
| Nilead\PartyBundle\Model\Party | 1 |
| Nilead\BlockBundle\Model\Widget | 1 |
| Nilead\BlockBundle\Model\WidgetType | 1 |
| Nilead\BlockBundle\Model\Style | 1 |