https://console.nvtst.ru/surveyResult/

Query Metrics

10 Database Queries
10 Different statements
378.62 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.65 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:
[
  68
]
2 0.18 ms
"START TRANSACTION"
Parameters:
[]
3 0.40 ms
UPDATE `user` SET last_activity_at = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "2025-12-08 18:00:16"
  "2025-12-08 18:00:16"
  68
]
4 374.55 ms
"COMMIT"
Parameters:
[]
5 0.56 ms
SELECT s0_.created_at AS created_at_0 FROM survey_result s0_ ORDER BY s0_.created_at DESC
Parameters:
[]
6 0.50 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_5 FROM (SELECT s0_.user_ip AS user_ip_0, s0_.user_agent AS user_agent_1, s0_.email AS email_2, s0_.travel_time AS travel_time_3, s0_.progress AS progress_4, s0_.id AS id_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7 FROM survey_result s0_ ORDER BY s0_.id DESC) dctrn_result) dctrn_table
Parameters:
[]
7 0.30 ms
SELECT s0_.user_ip AS user_ip_0, s0_.user_agent AS user_agent_1, s0_.email AS email_2, s0_.travel_time AS travel_time_3, s0_.progress AS progress_4, s0_.id AS id_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.survey_id AS survey_id_8, s0_.user_id AS user_id_9 FROM survey_result s0_ ORDER BY s0_.id DESC LIMIT 5
Parameters:
[]
8 0.48 ms
SELECT t0.uri AS uri_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.type AS type_5, t0.valid_start AS valid_start_6, t0.valid_end AS valid_end_7, t0.refresh AS refresh_8, t0.result_myself AS result_myself_9, t0.notification_after_each AS notification_after_each_10, t0.notification_appointed_time AS notification_appointed_time_11, t0.notification_date AS notification_date_12, t0.system_date AS system_date_13, t0.result_filter_start_in_notification AS result_filter_start_in_notification_14, t0.result_filter_end_in_notification AS result_filter_end_in_notification_15, t0.timer AS timer_16, t0.timer_time AS timer_time_17, t0.id AS id_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.author_id AS author_id_21 FROM survey t0 WHERE t0.id = ?
Parameters:
[
  120
]
9 0.39 ms
SELECT s0_.uri AS uri_0, s0_.title AS title_1, s0_.description AS description_2, s0_.status AS status_3, s0_.type AS type_4, s0_.valid_start AS valid_start_5, s0_.valid_end AS valid_end_6, s0_.refresh AS refresh_7, s0_.result_myself AS result_myself_8, s0_.notification_after_each AS notification_after_each_9, s0_.notification_appointed_time AS notification_appointed_time_10, s0_.notification_date AS notification_date_11, s0_.system_date AS system_date_12, s0_.result_filter_start_in_notification AS result_filter_start_in_notification_13, s0_.result_filter_end_in_notification AS result_filter_end_in_notification_14, s0_.timer AS timer_15, s0_.timer_time AS timer_time_16, s0_.id AS id_17, s0_.created_at AS created_at_18, s0_.updated_at AS updated_at_19, s0_.author_id AS author_id_20 FROM survey s0_
Parameters:
[]
10 0.61 ms
SELECT u0_.firstname AS firstname_0, u0_.lastname AS lastname_1, u0_.login AS login_2, u0_.roles AS roles_3, u0_.email AS email_4, u0_.password AS password_5, u0_.is_verified AS is_verified_6, u0_.avatar AS avatar_7, u0_.slack_nick AS slack_nick_8, u0_.position AS position_9, u0_.department AS department_10, u0_.status AS status_11, u0_.slack_id AS slack_id_12, u0_.last_activity_at AS last_activity_at_13, u0_.id AS id_14, u0_.created_at AS created_at_15, u0_.updated_at AS updated_at_16 FROM `user` u0_
Parameters:
[]

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\User\User
  • The mappings App\Entity\User\User#availableDays and App\Entity\AvailableDay#user are inconsistent with each other.
App\Entity\Survey\Survey No errors.
App\Entity\Survey\SurveyNotification No errors.
App\Entity\Vacation No errors.
App\Entity\Application No errors.
App\Entity\AvailableDay No errors.
App\Entity\SMS No errors.
App\Entity\Security\ServiceSession No errors.
App\Entity\Technic No errors.
App\Entity\Survey\SurveyResult
  • The association App\Entity\Survey\SurveyResult#user refers to the inverse side field App\Entity\User\User#surveyResult which does not exist.
App\Entity\Survey\SurveyResultData No errors.
App\Entity\Survey\SurveyQuestion No errors.