GET https://admin.sovaunion.io/user?page=1

Query Metrics

26 Database Queries
6 Different statements
3.32 ms Query time
0 Invalid entities
46 Managed entities

Queries

Group similar statements

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.