POST https://hr.mercyfoods.ru/login_check

Query Metrics

12 Database Queries
8 Different statements
19.14 ms Query time
0 Invalid entities
240 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 1.08 ms
SELECT u0_.auth_code AS auth_code_0, u0_.auth_code_expiration AS auth_code_expiration_1, u0_.last_login AS last_login_2, u0_.username AS username_3, u0_.created_by AS created_by_4, u0_.updated_by AS updated_by_5, u0_.created_at AS created_at_6, u0_.updated_at AS updated_at_7, u0_.enabled AS enabled_8, u0_.id AS id_9, u0_.migrate_uuid AS migrate_uuid_10 FROM users u0_ WHERE u0_.enabled = 1 AND u0_.username = ?
Parameters:
[
  "00000000000"
]
2 0.77 ms
SELECT t0.code AS code_1, t0.description AS description_2, t0.name AS name_3, t0.redirect_uri AS redirect_uri_4, t0.logo AS logo_5, t0.id AS id_6, t0.migrate_uuid AS migrate_uuid_7 FROM systems t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "main"
]
3 3.92 ms
SELECT t0.code AS code_1, t0.parent_code AS parent_code_2, t0.id AS id_3, t0.migrate_uuid AS migrate_uuid_4 FROM applications t0 INNER JOIN systems_applications ON t0.id = systems_applications.applications_id WHERE systems_applications.systems_id = ?
Parameters:
[
  1
]
4 3.56 ms
SELECT t0.enabled AS enabled_1, t0.id AS id_2, t0.migrate_uuid AS migrate_uuid_3, t0.system_id AS system_id_4, t0.user_id AS user_id_5 FROM accesses t0 WHERE t0.user_id = ?
Parameters:
[
  288321
]
5 0.87 ms
SELECT u0_.auth_code AS auth_code_0, u0_.auth_code_expiration AS auth_code_expiration_1, u0_.last_login AS last_login_2, u0_.username AS username_3, u0_.created_by AS created_by_4, u0_.updated_by AS updated_by_5, u0_.created_at AS created_at_6, u0_.updated_at AS updated_at_7, u0_.enabled AS enabled_8, u0_.id AS id_9, u0_.migrate_uuid AS migrate_uuid_10 FROM users u0_ WHERE u0_.enabled = 1 AND u0_.username = ?
Parameters:
[
  "00000000000"
]
6 0.99 ms
SELECT t0.avatar AS avatar_1, t0.department AS department_2, t0.languages AS languages_3, t0.profile_url AS profile_url_4, t0.real_phone AS real_phone_5, t0.signature AS signature_6, t0.sort_order AS sort_order_7, t0.time_from AS time_from_8, t0.time_to AS time_to_9, t0.work_since AS work_since_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.enabled AS enabled_15, t0.birthday AS birthday_16, t0.email AS email_17, t0.first_name AS first_name_18, t0.last_name AS last_name_19, t0.patronymic AS patronymic_20, t0.phone AS phone_21, t0.id AS id_22, t0.telegram_id AS telegram_id_23, t0.migrate_uuid AS migrate_uuid_24, t0.max_id AS max_id_25, t0.main_system_id AS main_system_id_26, t0.use_affiliate_id AS use_affiliate_id_27, t0.user_id AS user_id_28 FROM employees t0 WHERE t0.user_id = ?
Parameters:
[
  288321
]
7 1.29 ms
SELECT t0.code AS code_1, t0.description AS description_2, t0.name AS name_3, t0.redirect_uri AS redirect_uri_4, t0.logo AS logo_5, t0.id AS id_6, t0.migrate_uuid AS migrate_uuid_7 FROM systems t0 WHERE t0.id = ?
Parameters:
[
  16
]
8 1.29 ms
SELECT t0.code AS code_1, t0.parent_code AS parent_code_2, t0.id AS id_3, t0.migrate_uuid AS migrate_uuid_4 FROM applications t0 INNER JOIN systems_applications ON t0.id = systems_applications.applications_id WHERE systems_applications.systems_id = ?
Parameters:
[
  16
]
9 0.51 ms
SELECT t0.code AS code_1, t0.description AS description_2, t0.name AS name_3, t0.redirect_uri AS redirect_uri_4, t0.logo AS logo_5, t0.id AS id_6, t0.migrate_uuid AS migrate_uuid_7 FROM systems t0 WHERE t0.id = ?
Parameters:
[
  20
]
10 1.01 ms
SELECT t0.code AS code_1, t0.parent_code AS parent_code_2, t0.id AS id_3, t0.migrate_uuid AS migrate_uuid_4 FROM applications t0 INNER JOIN systems_applications ON t0.id = systems_applications.applications_id WHERE systems_applications.systems_id = ?
Parameters:
[
  20
]
11 3.04 ms
SELECT t0.category AS category_1, t0.code AS code_2, t0.description AS description_3, t0.name AS name_4, t0.start_point AS start_point_5, t0.enabled AS enabled_6, t0.id AS id_7, t0.migrate_uuid AS migrate_uuid_8 FROM roles t0 INNER JOIN employees_roles ON t0.id = employees_roles.roles_id WHERE employees_roles.employees_id = ?
Parameters:
[
  43
]
12 0.81 ms
SELECT t0.start_point AS start_point_1, t0.enabled AS enabled_2, t0.id AS id_3, t0.migrate_uuid AS migrate_uuid_4, t0.role_id AS role_id_5, t0.system_id AS system_id_6 FROM system_roles t0 WHERE t0.system_id = ?
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection
audit doctrine.dbal.audit_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
audit doctrine.orm.audit_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\System\Application 230
App\Entity\System\System 3
App\Entity\System\Access 3
App\Entity\Setting\User 1
App\Entity\Employee\Employee 1
App\Entity\System\Role 1
App\Entity\System\SystemRole 1

audit entity manager

Class Amount of managed objects

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Setting\User No errors.
App\Entity\System\Access No errors.
App\Entity\Employee\Employee No errors.
App\Entity\System\System No errors.
App\Entity\Setting\Affiliate No errors.
App\Entity\System\Application No errors.
App\Entity\System\Permission No errors.
App\Entity\Setting\Faq No errors.
App\Entity\System\SystemRole No errors.
App\Entity\Setting\UnitOfMeasurement No errors.
App\Entity\Dashboard\Widget No errors.
App\Entity\Client\Client No errors.
App\Entity\System\Role No errors.
App\Entity\Setting\Specialty No errors.

audit entity manager

No loaded entities.