https://console.nvtst.ru/api/appClient/v1/lk/vacations/all

Query Metrics

10 Database Queries
4 Different statements
10.45 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.98 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.client_id AS client_id_3, t0.client_secret AS client_secret_4, t0.roles AS roles_5, t0.user_id AS user_id_6 FROM application t0 WHERE t0.client_id = ? LIMIT 1
Parameters:
[
  "b8ce365c5be1bb01c7d993a92b06e194b84c4313"
]
2 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.client_id AS client_id_3, t0.client_secret AS client_secret_4, t0.roles AS roles_5, t0.user_id AS user_id_6 FROM application t0 WHERE t0.client_id = ? LIMIT 1
Parameters:
[
  "b8ce365c5be1bb01c7d993a92b06e194b84c4313"
]
3 1.04 ms
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.client_id AS client_id_2, a0_.client_secret AS client_secret_3, a0_.roles AS roles_4, a0_.user_id AS user_id_5 FROM application a0_ WHERE a0_.client_id = ?
Parameters:
[
  "b8ce365c5be1bb01c7d993a92b06e194b84c4313"
]
4 4.54 ms
SELECT t0.date_to AS date_to_1, t0.date_from AS date_from_2, t0.id AS id_3, t0.user_id AS user_id_4 FROM vacation t0
Parameters:
[]
5 0.75 ms
SELECT t0.firstname AS firstname_1, t0.lastname AS lastname_2, t0.login AS login_3, t0.roles AS roles_4, t0.email AS email_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.avatar AS avatar_8, t0.slack_nick AS slack_nick_9, t0.position AS position_10, t0.department AS department_11, t0.status AS status_12, t0.slack_id AS slack_id_13, t0.last_activity_at AS last_activity_at_14, t0.id AS id_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  26
]
6 0.76 ms
SELECT t0.firstname AS firstname_1, t0.lastname AS lastname_2, t0.login AS login_3, t0.roles AS roles_4, t0.email AS email_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.avatar AS avatar_8, t0.slack_nick AS slack_nick_9, t0.position AS position_10, t0.department AS department_11, t0.status AS status_12, t0.slack_id AS slack_id_13, t0.last_activity_at AS last_activity_at_14, t0.id AS id_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  33
]
7 0.45 ms
SELECT t0.firstname AS firstname_1, t0.lastname AS lastname_2, t0.login AS login_3, t0.roles AS roles_4, t0.email AS email_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.avatar AS avatar_8, t0.slack_nick AS slack_nick_9, t0.position AS position_10, t0.department AS department_11, t0.status AS status_12, t0.slack_id AS slack_id_13, t0.last_activity_at AS last_activity_at_14, t0.id AS id_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  44
]
8 0.43 ms
SELECT t0.firstname AS firstname_1, t0.lastname AS lastname_2, t0.login AS login_3, t0.roles AS roles_4, t0.email AS email_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.avatar AS avatar_8, t0.slack_nick AS slack_nick_9, t0.position AS position_10, t0.department AS department_11, t0.status AS status_12, t0.slack_id AS slack_id_13, t0.last_activity_at AS last_activity_at_14, t0.id AS id_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  43
]
9 0.40 ms
SELECT t0.firstname AS firstname_1, t0.lastname AS lastname_2, t0.login AS login_3, t0.roles AS roles_4, t0.email AS email_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.avatar AS avatar_8, t0.slack_nick AS slack_nick_9, t0.position AS position_10, t0.department AS department_11, t0.status AS status_12, t0.slack_id AS slack_id_13, t0.last_activity_at AS last_activity_at_14, t0.id AS id_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  154
]
10 0.41 ms
SELECT t0.firstname AS firstname_1, t0.lastname AS lastname_2, t0.login AS login_3, t0.roles AS roles_4, t0.email AS email_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.avatar AS avatar_8, t0.slack_nick AS slack_nick_9, t0.position AS position_10, t0.department AS department_11, t0.status AS status_12, t0.slack_id AS slack_id_13, t0.last_activity_at AS last_activity_at_14, t0.id AS id_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  158
]

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
App\Entity\Application No errors.
App\Entity\User\User
  • The mappings App\Entity\User\User#availableDays and App\Entity\AvailableDay#user are inconsistent with each other.
App\Entity\Vacation No errors.
App\Entity\Survey\Survey No errors.
App\Entity\Survey\SurveyNotification No errors.
App\Entity\AvailableDay No errors.
App\Entity\SMS No errors.
App\Entity\Security\ServiceSession No errors.
App\Entity\Technic No errors.