Query Metrics
3
Database Queries
2
Different statements
0.72 ms
Query time
0
Invalid entities
3
Managed entities
Queries
manager connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.32 ms |
SELECT t0.use_id AS use_id_1, t0.use_login AS use_login_2, t0.use_password AS use_password_3, t0.roles AS roles_4, t0.use_first_name AS use_first_name_5, t0.use_last_name AS use_last_name_6, t0.use_email AS use_email_7, t0.use_id_parent AS use_id_parent_8, t0.last_connection AS last_connection_9, t0.count_connection AS count_connection_10, t0.password_last_changed AS password_last_changed_11, t0.require_password_change AS require_password_change_12, t0.two_factor_secret AS two_factor_secret_13, t0.two_factor_method AS two_factor_method_14, t0.two_factor_enabled AS two_factor_enabled_15, t0.two_factor_email_code AS two_factor_email_code_16, t0.two_factor_email_code_expiry AS two_factor_email_code_expiry_17, t0.failed_login_attempts AS failed_login_attempts_18, t0.locked_until AS locked_until_19, t0.cust_id AS cust_id_20, t0.priv_id AS priv_id_21 FROM itm_user t0 WHERE t0.use_login = ? LIMIT 1
Parameters:
[
"managerIT2-1"
]
|
| 2 | 0.23 ms |
SELECT i0_.id AS id_0, i0_.min_length AS min_length_1, i0_.require_uppercase AS require_uppercase_2, i0_.require_digit AS require_digit_3, i0_.require_special_char AS require_special_char_4, i0_.expiration_days AS expiration_days_5, i0_.history_count AS history_count_6, i0_.max_attempts AS max_attempts_7, i0_.lockout_minutes AS lockout_minutes_8, i0_.two_factor_required AS two_factor_required_9, i0_.two_factor_type AS two_factor_type_10, i0_.grace_period_days AS grace_period_days_11, i0_.cust_id AS cust_id_12 FROM itm_password_policy i0_ WHERE i0_.cust_id = ?
Parameters:
[
1
]
|
| 3 | 0.16 ms |
SELECT i0_.id AS id_0, i0_.min_length AS min_length_1, i0_.require_uppercase AS require_uppercase_2, i0_.require_digit AS require_digit_3, i0_.require_special_char AS require_special_char_4, i0_.expiration_days AS expiration_days_5, i0_.history_count AS history_count_6, i0_.max_attempts AS max_attempts_7, i0_.lockout_minutes AS lockout_minutes_8, i0_.two_factor_required AS two_factor_required_9, i0_.two_factor_type AS two_factor_type_10, i0_.grace_period_days AS grace_period_days_11, i0_.cust_id AS cust_id_12 FROM itm_password_policy i0_ WHERE i0_.cust_id = ?
Parameters:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| manager | doctrine.dbal.manager_connection |
| stats | doctrine.dbal.stats_connection |
Entity Managers
| Name | Service |
|---|---|
| manager | doctrine.orm.manager_entity_manager |
| stats | doctrine.orm.stats_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
manager entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Manager\User | 1 |
| App\Entity\Manager\Customer | 1 |
| App\Entity\Manager\Privilege | 1 |
stats entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
manager entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Manager\User | No errors. |
| App\Entity\Manager\Customer | No errors. |
| App\Entity\Manager\Privilege | No errors. |
| App\Entity\Manager\PasswordPolicy | No errors. |
| App\Entity\Manager\SubscriptionPermissions | No errors. |
stats entity manager
No loaded entities.