Query Metrics
26
Database Queries
6
Different statements
3.32 ms
Query time
0
Invalid entities
46
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.17 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.remote_auth AS remote_auth_3, t0.is_approved AS is_approved_4, t0.pwd AS pwd_5, t0.auth_key AS auth_key_6, t0.trust_level_id AS trust_level_id_7, t0.temp_key AS temp_key_8, t0.is_deleted AS is_deleted_9, t0.interface AS interface_10, t0.company AS company_11, t0.traf_cat AS traf_cat_12, t0.min_balance AS min_balance_13, t0.login_attempts AS login_attempts_14, t0.subscribe_active AS subscribe_active_15, t0.contact_phone AS contact_phone_16, t0.is_invoice_auto_link AS is_invoice_auto_link_17, t0.time_zone AS time_zone_18, t0.country_id AS country_id_19, t0.reg_site_id AS reg_site_id_20, t0.mobile_push_token AS mobile_push_token_21, t0.fname AS fname_22, t0.sname AS sname_23, t0.is_active AS is_active_24, t0.user_role_id AS user_role_id_25, t0.office AS office_26, t0.currency_id AS currency_id_27, t28.id AS id_29, t28.ip AS ip_30, t28.created_at AS created_at_31, t28.user_id AS user_id_32 FROM user t0 LEFT JOIN user_agreement t28 ON t28.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
"s.goncharov@sovaunion.com"
]
|
| 2 | 0.23 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.remote_auth AS remote_auth_3, t0.is_approved AS is_approved_4, t0.pwd AS pwd_5, t0.auth_key AS auth_key_6, t0.trust_level_id AS trust_level_id_7, t0.temp_key AS temp_key_8, t0.is_deleted AS is_deleted_9, t0.interface AS interface_10, t0.company AS company_11, t0.traf_cat AS traf_cat_12, t0.min_balance AS min_balance_13, t0.login_attempts AS login_attempts_14, t0.subscribe_active AS subscribe_active_15, t0.contact_phone AS contact_phone_16, t0.is_invoice_auto_link AS is_invoice_auto_link_17, t0.time_zone AS time_zone_18, t0.country_id AS country_id_19, t0.reg_site_id AS reg_site_id_20, t0.mobile_push_token AS mobile_push_token_21, t0.fname AS fname_22, t0.sname AS sname_23, t0.is_active AS is_active_24, t0.user_role_id AS user_role_id_25, t0.office AS office_26, t0.currency_id AS currency_id_27, t28.id AS id_29, t28.ip AS ip_30, t28.created_at AS created_at_31, t28.user_id AS user_id_32 FROM user t0 LEFT JOIN user_agreement t28 ON t28.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
"s.goncharov@sovaunion.com"
]
|
| 3 | 0.16 ms |
SELECT DISTINCT u0_.id AS id_0, u0_.id AS id_1 FROM user u0_ ORDER BY u0_.id DESC LIMIT 20
Parameters:
[] |
| 4 | 0.16 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.remote_auth AS remote_auth_2, u0_.is_approved AS is_approved_3, u0_.pwd AS pwd_4, u0_.auth_key AS auth_key_5, u0_.trust_level_id AS trust_level_id_6, u0_.temp_key AS temp_key_7, u0_.is_deleted AS is_deleted_8, u0_.interface AS interface_9, u0_.company AS company_10, u0_.traf_cat AS traf_cat_11, u0_.min_balance AS min_balance_12, u0_.login_attempts AS login_attempts_13, u0_.subscribe_active AS subscribe_active_14, u0_.contact_phone AS contact_phone_15, u0_.is_invoice_auto_link AS is_invoice_auto_link_16, u0_.time_zone AS time_zone_17, u0_.country_id AS country_id_18, u0_.reg_site_id AS reg_site_id_19, u0_.mobile_push_token AS mobile_push_token_20, u0_.fname AS fname_21, u0_.sname AS sname_22, u0_.is_active AS is_active_23, u0_.user_role_id AS user_role_id_24, u0_.office AS office_25, u0_.currency_id AS currency_id_26 FROM user u0_ WHERE u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY u0_.id DESC
Parameters:
[ 4496 4495 4494 4493 4492 4491 4490 4489 4488 4487 4486 4485 4484 4483 4482 4481 4480 4479 4478 4477 ] |
| 5 | 0.12 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4496
]
|
| 6 | 0.12 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4495
]
|
| 7 | 0.11 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4494
]
|
| 8 | 0.12 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4493
]
|
| 9 | 0.11 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4492
]
|
| 10 | 0.11 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4491
]
|
| 11 | 0.11 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4490
]
|
| 12 | 0.10 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4489
]
|
| 13 | 0.11 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4488
]
|
| 14 | 0.13 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4487
]
|
| 15 | 0.15 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4486
]
|
| 16 | 0.12 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4485
]
|
| 17 | 0.12 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4484
]
|
| 18 | 0.13 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4483
]
|
| 19 | 0.13 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4482
]
|
| 20 | 0.11 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4481
]
|
| 21 | 0.10 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4480
]
|
| 22 | 0.10 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4479
]
|
| 23 | 0.12 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4478
]
|
| 24 | 0.11 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4 FROM user_agreement t0 WHERE t0.user_id = ?
Parameters:
[
4477
]
|
| 25 | 0.12 ms |
SELECT count(*) AS sclr_0 FROM user u0_
Parameters:
[] |
| 26 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM user_role t0 WHERE t0.id = ?
Parameters:
[
3
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| conversions | doctrine.dbal.conversions_connection |
| queue | doctrine.dbal.queue_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| conversions | doctrine.orm.conversions_entity_manager |
| queue | doctrine.orm.queue_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Default\User | 21 |
| App\Entity\Default\UserAgreement | 20 |
| App\Entity\Default\UserRole | 2 |
| App\Entity\Default\Office | 2 |
| App\Entity\Default\Currency | 1 |
conversions entity manager
| Class | Amount of managed objects |
|---|
queue entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Default\User | No errors. |
| App\Entity\Default\UserRole | No errors. |
| App\Entity\Default\Office | No errors. |
| App\Entity\Default\Currency | No errors. |
| App\Entity\Default\UserAgreement | No errors. |
| App\Entity\Default\Account | No errors. |
conversions entity manager
No loaded entities.
queue entity manager
No loaded entities.