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

Query Metrics

12 Database Queries
7 Different statements
4.91 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.73 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.44 ms
SELECT t0.user_ip AS user_ip_1, t0.user_agent AS user_agent_2, t0.email AS email_3, t0.travel_time AS travel_time_4, t0.progress AS progress_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.survey_id AS survey_id_9, t0.user_id AS user_id_10 FROM survey_result t0 WHERE t0.id = ?
Parameters:
[
  "787"
]
3 0.60 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
]
4 0.46 ms
SELECT t0.data AS data_1, t0.is_pasted AS is_pasted_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.survey_result_id AS survey_result_id_6, t0.question_id AS question_id_7 FROM survey_result_data t0 WHERE t0.survey_result_id = ?
Parameters:
[
  787
]
5 0.42 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:
[]
6 0.63 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:
[]
7 0.50 ms
SELECT t0.wording AS wording_1, t0.type AS type_2, t0.required AS required_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM question t0 WHERE t0.id = ?
Parameters:
[
  1047
]
8 0.26 ms
SELECT t0.wording AS wording_1, t0.type AS type_2, t0.required AS required_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM question t0 WHERE t0.id = ?
Parameters:
[
  1048
]
9 0.21 ms
SELECT t0.wording AS wording_1, t0.type AS type_2, t0.required AS required_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM question t0 WHERE t0.id = ?
Parameters:
[
  1049
]
10 0.22 ms
SELECT t0.wording AS wording_1, t0.type AS type_2, t0.required AS required_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM question t0 WHERE t0.id = ?
Parameters:
[
  1052
]
11 0.21 ms
SELECT t0.wording AS wording_1, t0.type AS type_2, t0.required AS required_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM question t0 WHERE t0.id = ?
Parameters:
[
  1053
]
12 0.23 ms
SELECT t0.wording AS wording_1, t0.type AS type_2, t0.required AS required_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM question t0 WHERE t0.id = ?
Parameters:
[
  1054
]

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.
App\Entity\Survey\Question No errors.
App\Entity\Survey\QuestionAnswer No errors.
App\Entity\Survey\AnswerQuestion No errors.