Query Metrics
12
Database Queries
7
Different statements
4.91 ms
Query time
2
Invalid entities
Queries
| #▲ | 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 |
|
| 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 |
|
| 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. |