Query Metrics
4
Database Queries
3
Different statements
1.31 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.privilege_name AS privilege_name_3, t0.description AS description_4, t0.collection AS collection_5 FROM s201_privilege t0
Parameters:
[] |
| 2 | 0.41 ms |
SELECT t1.id AS id_2, t1.firstname AS firstname_3, t1.lastname AS lastname_4, t1.username AS username_5, t1.email AS email_6, t1.roles AS roles_7, t1.password AS password_8, t1.enabled AS enabled_9, t1.session_id AS session_id_10, t1.additional_rights AS additional_rights_11, t1.last_login AS last_login_12, t1.is_verified AS is_verified_13, t1.last_notification_sent AS last_notification_sent_14, t1.notification_period AS notification_period_15, t1.must_change_password AS must_change_password_16, t1.must_activate_twofa AS must_activate_twofa_17, t1.last_changed_password AS last_changed_password_18, t1.locale AS locale_19, t1.mobile_phone_nr_for_sms AS mobile_phone_nr_for_sms_20, t1.authenticated_external AS authenticated_external_21, t1.authenticated_external_type AS authenticated_external_type_22, t1.reset_token AS reset_token_23, t1.reset_token_expires_at AS reset_token_expires_at_24, t1.twofa_enabled AS twofa_enabled_25, t1.twofa_authenticator_secret AS twofa_authenticator_secret_26, t1.deleted AS deleted_27, t1.deleted_at AS deleted_at_28, t1.uuid AS uuid_29, t1.created AS created_30, t1.updated AS updated_31, t0.refresh_token AS refresh_token_32, t0.last_automatic_email_sent AS last_automatic_email_sent_33, t1.created_by_id AS created_by_id_34, t1.updated_by_id AS updated_by_id_35, t1.type FROM fos_user t0 INNER JOIN s201_user t1 ON t0.id = t1.id WHERE ((t1.deleted = 0))
Parameters:
[] |
| 3 | 0.25 ms |
SELECT t1.id AS id_2, t1.name AS name_3, t1.roles AS roles_4, t1.uuid AS uuid_5, t1.created AS created_6, t1.updated AS updated_7, t1.created_by_id AS created_by_id_8, t1.updated_by_id AS updated_by_id_9, t1.type FROM fos_group t0 INNER JOIN s201_coregroup t1 ON t0.id = t1.id
Parameters:
[] |
| 4 | 0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.privilege_name AS privilege_name_3, t0.description AS description_4, t0.collection AS collection_5 FROM s201_privilege t0
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| Studio201\UserBackendBundle\Entity\AbstractDocument | No errors. |
| Studio201\UserBackendBundle\Entity\UserSetting | No errors. |
| Studio201\UserBackendBundle\Entity\BackendUser | No errors. |
| Studio201\UserBackendBundle\Entity\Privilege | No errors. |
| App\Entity\Base\User | No errors. |
| Studio201\UserBackendBundle\Entity\BackendGroup | No errors. |
| App\Entity\Base\Employee | No errors. |
| App\Entity\Base\AppUserGroup | No errors. |