Query Metrics
4
Database Queries
4
Different statements
42.27 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
20.82 ms (49.26%) |
1 |
SELECT t0.g_name AS g_name_1, t0.g_checkusers AS g_checkusers_2, t0.id AS id_3, t0.visibility AS visibility_4, t0.created_at AS created_at_5, t0.edited_at AS edited_at_6, t0.last_check_at AS last_check_at_7, t0.next_check_at AS next_check_at_8 FROM cms_optiongroup t0 ORDER BY t0.edited_at ASC
Parameters:
[] |
11.01 ms (26.05%) |
1 |
SELECT c0_.code AS code_0, c0_.name AS name_1, c0_.value AS value_2, c0_.o_params AS o_params_3, c0_.id AS id_4, c0_.visibility AS visibility_5, c0_.created_at AS created_at_6, c0_.edited_at AS edited_at_7, c0_.last_check_at AS last_check_at_8, c0_.next_check_at AS next_check_at_9 FROM cms_option c0_ WHERE c0_.code IS NOT NULL AND c0_.visibility = ?
Parameters:
[
1
]
|
6.78 ms (16.04%) |
1 |
SELECT t0.username AS username_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.description AS description_7, t0.is_active AS is_active_8, t0.settings AS settings_9, t0.icon AS icon_10, t0.new_pass_hash AS new_pass_hash_11, t0.slug AS slug_12, t0.source AS source_13, t0.is_public AS is_public_14, t0.u_params AS u_params_15, t0.id AS id_16, t0.visibility AS visibility_17, t0.created_at AS created_at_18, t0.edited_at AS edited_at_19, t0.last_check_at AS last_check_at_20, t0.next_check_at AS next_check_at_21 FROM cms_user t0 WHERE t0.id = ?
Parameters:
[
4
]
|
3.66 ms (8.65%) |
1 |
SELECT t0.name AS name_1, t0.role AS role_2, t0.id AS id_3, t0.visibility AS visibility_4, t0.created_at AS created_at_5, t0.edited_at AS edited_at_6, t0.last_check_at AS last_check_at_7, t0.next_check_at AS next_check_at_8 FROM cms_group t0 INNER JOIN cms_conn_user_group ON t0.id = cms_conn_user_group.group_id WHERE cms_conn_user_group.user_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.
Entities Mapping
Class | Mapping errors |
---|---|
Score\CmsBundle\Entity\User | No errors. |
Score\CmsBundle\Entity\Group | No errors. |
Score\CmsBundle\Entity\Stat | No errors. |
Score\CmsBundle\Entity\OptionGroup | No errors. |
Score\CmsBundle\Entity\Option | No errors. |