Query Metrics
64
Database Queries
8
Different statements
36.31 ms
Query time
3
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 9.87 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.create_at AS create_at_3, t0.telegram_id AS telegram_id_4, t0.phone AS phone_5, t0.is_admin AS is_admin_6, t0.is_banned AS is_banned_7, t0.email AS email_8, t0.city AS city_9, t0.roles AS roles_10, t0.password AS password_11, t0.brands_history AS brands_history_12 FROM app_user t0 WHERE t0.telegram_id = ? LIMIT 1
Parameters:
[
323898984
]
|
| 2 | 0.74 ms |
SELECT DISTINCT a0_.survey_id AS sclr_0 FROM app_questionnaire_result a0_ WHERE a0_.user_id = ? AND a0_.completed = 1
Parameters:
[
6279
]
|
| 3 | 0.78 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.title_local AS title_local_3, a0_.description_local AS description_local_4, a0_.is_active AS is_active_5, a0_.is_poll AS is_poll_6, a0_.total_correct AS total_correct_7, a0_.type AS type_8, a0_.article_success_id AS article_success_id_9, a0_.article_failed_id AS article_failed_id_10 FROM app_survey a0_ WHERE a0_.is_active = 1 AND a0_.id NOT IN (?)
Parameters:
[
0
]
|
| 4 | 0.54 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.survey_id AS survey_id_5 FROM app_survey_image t0 WHERE t0.survey_id = ?
Parameters:
[
61
]
|
| 5 | 0.54 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.type AS type_4, t0.is_add_balance AS is_add_balance_5, t0.survey_id AS survey_id_6 FROM app_question t0 WHERE t0.survey_id = ?
Parameters:
[
61
]
|
| 6 | 0.51 ms |
SELECT t0.id AS id_1, t0.result AS result_2, t0.create_at AS create_at_3, t0.completed AS completed_4, t0.survey_id AS survey_id_5, t0.question_id AS question_id_6, t0.answer_id AS answer_id_7, t0.user_id AS user_id_8 FROM app_questionnaire_result t0 WHERE t0.question_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ 345 6279 ] |
| 7 | 0.57 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.end_survey AS end_survey_4, t0.is_correct AS is_correct_5, t0.score AS score_6, t0.question_id AS question_id_7 FROM app_answer t0 WHERE t0.question_id = ?
Parameters:
[
345
]
|
| 8 | 0.44 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.question_id AS question_id_5 FROM app_question_image t0 WHERE t0.question_id = ?
Parameters:
[
345
]
|
| 9 | 0.47 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.survey_id AS survey_id_5 FROM app_survey_image t0 WHERE t0.survey_id = ?
Parameters:
[
62
]
|
| 10 | 0.46 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.type AS type_4, t0.is_add_balance AS is_add_balance_5, t0.survey_id AS survey_id_6 FROM app_question t0 WHERE t0.survey_id = ?
Parameters:
[
62
]
|
| 11 | 0.51 ms |
SELECT t0.id AS id_1, t0.result AS result_2, t0.create_at AS create_at_3, t0.completed AS completed_4, t0.survey_id AS survey_id_5, t0.question_id AS question_id_6, t0.answer_id AS answer_id_7, t0.user_id AS user_id_8 FROM app_questionnaire_result t0 WHERE t0.question_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ 346 6279 ] |
| 12 | 0.50 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.end_survey AS end_survey_4, t0.is_correct AS is_correct_5, t0.score AS score_6, t0.question_id AS question_id_7 FROM app_answer t0 WHERE t0.question_id = ?
Parameters:
[
346
]
|
| 13 | 0.42 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.question_id AS question_id_5 FROM app_question_image t0 WHERE t0.question_id = ?
Parameters:
[
346
]
|
| 14 | 0.45 ms |
SELECT t0.id AS id_1, t0.result AS result_2, t0.create_at AS create_at_3, t0.completed AS completed_4, t0.survey_id AS survey_id_5, t0.question_id AS question_id_6, t0.answer_id AS answer_id_7, t0.user_id AS user_id_8 FROM app_questionnaire_result t0 WHERE t0.question_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ 347 6279 ] |
| 15 | 0.43 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.end_survey AS end_survey_4, t0.is_correct AS is_correct_5, t0.score AS score_6, t0.question_id AS question_id_7 FROM app_answer t0 WHERE t0.question_id = ?
Parameters:
[
347
]
|
| 16 | 0.43 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.question_id AS question_id_5 FROM app_question_image t0 WHERE t0.question_id = ?
Parameters:
[
347
]
|
| 17 | 0.48 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.survey_id AS survey_id_5 FROM app_survey_image t0 WHERE t0.survey_id = ?
Parameters:
[
63
]
|
| 18 | 0.50 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.type AS type_4, t0.is_add_balance AS is_add_balance_5, t0.survey_id AS survey_id_6 FROM app_question t0 WHERE t0.survey_id = ?
Parameters:
[
63
]
|
| 19 | 0.43 ms |
SELECT t0.id AS id_1, t0.result AS result_2, t0.create_at AS create_at_3, t0.completed AS completed_4, t0.survey_id AS survey_id_5, t0.question_id AS question_id_6, t0.answer_id AS answer_id_7, t0.user_id AS user_id_8 FROM app_questionnaire_result t0 WHERE t0.question_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ 348 6279 ] |
| 20 | 0.38 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.end_survey AS end_survey_4, t0.is_correct AS is_correct_5, t0.score AS score_6, t0.question_id AS question_id_7 FROM app_answer t0 WHERE t0.question_id = ?
Parameters:
[
348
]
|
| 21 | 0.33 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.question_id AS question_id_5 FROM app_question_image t0 WHERE t0.question_id = ?
Parameters:
[
348
]
|
| 22 | 0.43 ms |
SELECT t0.id AS id_1, t0.result AS result_2, t0.create_at AS create_at_3, t0.completed AS completed_4, t0.survey_id AS survey_id_5, t0.question_id AS question_id_6, t0.answer_id AS answer_id_7, t0.user_id AS user_id_8 FROM app_questionnaire_result t0 WHERE t0.question_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ 349 6279 ] |
| 23 | 0.38 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.end_survey AS end_survey_4, t0.is_correct AS is_correct_5, t0.score AS score_6, t0.question_id AS question_id_7 FROM app_answer t0 WHERE t0.question_id = ?
Parameters:
[
349
]
|
| 24 | 0.49 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.question_id AS question_id_5 FROM app_question_image t0 WHERE t0.question_id = ?
Parameters:
[
349
]
|
| 25 | 0.42 ms |
SELECT t0.id AS id_1, t0.result AS result_2, t0.create_at AS create_at_3, t0.completed AS completed_4, t0.survey_id AS survey_id_5, t0.question_id AS question_id_6, t0.answer_id AS answer_id_7, t0.user_id AS user_id_8 FROM app_questionnaire_result t0 WHERE t0.question_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ 350 6279 ] |
| 26 | 0.37 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.end_survey AS end_survey_4, t0.is_correct AS is_correct_5, t0.score AS score_6, t0.question_id AS question_id_7 FROM app_answer t0 WHERE t0.question_id = ?
Parameters:
[
350
]
|
| 27 | 0.35 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.question_id AS question_id_5 FROM app_question_image t0 WHERE t0.question_id = ?
Parameters:
[
350
]
|
| 28 | 0.37 ms |
SELECT t0.id AS id_1, t0.result AS result_2, t0.create_at AS create_at_3, t0.completed AS completed_4, t0.survey_id AS survey_id_5, t0.question_id AS question_id_6, t0.answer_id AS answer_id_7, t0.user_id AS user_id_8 FROM app_questionnaire_result t0 WHERE t0.question_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ 351 6279 ] |
| 29 | 0.34 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.end_survey AS end_survey_4, t0.is_correct AS is_correct_5, t0.score AS score_6, t0.question_id AS question_id_7 FROM app_answer t0 WHERE t0.question_id = ?
Parameters:
[
351
]
|
| 30 | 0.38 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.question_id AS question_id_5 FROM app_question_image t0 WHERE t0.question_id = ?
Parameters:
[
351
]
|
| 31 | 0.50 ms |
SELECT t0.id AS id_1, t0.result AS result_2, t0.create_at AS create_at_3, t0.completed AS completed_4, t0.survey_id AS survey_id_5, t0.question_id AS question_id_6, t0.answer_id AS answer_id_7, t0.user_id AS user_id_8 FROM app_questionnaire_result t0 WHERE t0.question_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ 352 6279 ] |
| 32 | 0.42 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.end_survey AS end_survey_4, t0.is_correct AS is_correct_5, t0.score AS score_6, t0.question_id AS question_id_7 FROM app_answer t0 WHERE t0.question_id = ?
Parameters:
[
352
]
|
| 33 | 0.40 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.question_id AS question_id_5 FROM app_question_image t0 WHERE t0.question_id = ?
Parameters:
[
352
]
|
| 34 | 0.50 ms |
SELECT t0.id AS id_1, t0.result AS result_2, t0.create_at AS create_at_3, t0.completed AS completed_4, t0.survey_id AS survey_id_5, t0.question_id AS question_id_6, t0.answer_id AS answer_id_7, t0.user_id AS user_id_8 FROM app_questionnaire_result t0 WHERE t0.question_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ 353 6279 ] |
| 35 | 0.44 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.end_survey AS end_survey_4, t0.is_correct AS is_correct_5, t0.score AS score_6, t0.question_id AS question_id_7 FROM app_answer t0 WHERE t0.question_id = ?
Parameters:
[
353
]
|
| 36 | 0.35 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.question_id AS question_id_5 FROM app_question_image t0 WHERE t0.question_id = ?
Parameters:
[
353
]
|
| 37 | 0.35 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.survey_id AS survey_id_5 FROM app_survey_image t0 WHERE t0.survey_id = ?
Parameters:
[
64
]
|
| 38 | 0.47 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.type AS type_4, t0.is_add_balance AS is_add_balance_5, t0.survey_id AS survey_id_6 FROM app_question t0 WHERE t0.survey_id = ?
Parameters:
[
64
]
|
| 39 | 0.44 ms |
SELECT t0.id AS id_1, t0.result AS result_2, t0.create_at AS create_at_3, t0.completed AS completed_4, t0.survey_id AS survey_id_5, t0.question_id AS question_id_6, t0.answer_id AS answer_id_7, t0.user_id AS user_id_8 FROM app_questionnaire_result t0 WHERE t0.question_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ 354 6279 ] |
| 40 | 0.41 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.end_survey AS end_survey_4, t0.is_correct AS is_correct_5, t0.score AS score_6, t0.question_id AS question_id_7 FROM app_answer t0 WHERE t0.question_id = ?
Parameters:
[
354
]
|
| 41 | 0.38 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.question_id AS question_id_5 FROM app_question_image t0 WHERE t0.question_id = ?
Parameters:
[
354
]
|
| 42 | 0.41 ms |
SELECT t0.id AS id_1, t0.result AS result_2, t0.create_at AS create_at_3, t0.completed AS completed_4, t0.survey_id AS survey_id_5, t0.question_id AS question_id_6, t0.answer_id AS answer_id_7, t0.user_id AS user_id_8 FROM app_questionnaire_result t0 WHERE t0.question_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ 355 6279 ] |
| 43 | 0.42 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.end_survey AS end_survey_4, t0.is_correct AS is_correct_5, t0.score AS score_6, t0.question_id AS question_id_7 FROM app_answer t0 WHERE t0.question_id = ?
Parameters:
[
355
]
|
| 44 | 0.36 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.question_id AS question_id_5 FROM app_question_image t0 WHERE t0.question_id = ?
Parameters:
[
355
]
|
| 45 | 0.34 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.survey_id AS survey_id_5 FROM app_survey_image t0 WHERE t0.survey_id = ?
Parameters:
[
65
]
|
| 46 | 0.36 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.type AS type_4, t0.is_add_balance AS is_add_balance_5, t0.survey_id AS survey_id_6 FROM app_question t0 WHERE t0.survey_id = ?
Parameters:
[
65
]
|
| 47 | 0.37 ms |
SELECT t0.id AS id_1, t0.result AS result_2, t0.create_at AS create_at_3, t0.completed AS completed_4, t0.survey_id AS survey_id_5, t0.question_id AS question_id_6, t0.answer_id AS answer_id_7, t0.user_id AS user_id_8 FROM app_questionnaire_result t0 WHERE t0.question_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ 356 6279 ] |
| 48 | 0.41 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.end_survey AS end_survey_4, t0.is_correct AS is_correct_5, t0.score AS score_6, t0.question_id AS question_id_7 FROM app_answer t0 WHERE t0.question_id = ?
Parameters:
[
356
]
|
| 49 | 0.36 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.question_id AS question_id_5 FROM app_question_image t0 WHERE t0.question_id = ?
Parameters:
[
356
]
|
| 50 | 0.41 ms |
SELECT t0.id AS id_1, t0.result AS result_2, t0.create_at AS create_at_3, t0.completed AS completed_4, t0.survey_id AS survey_id_5, t0.question_id AS question_id_6, t0.answer_id AS answer_id_7, t0.user_id AS user_id_8 FROM app_questionnaire_result t0 WHERE t0.question_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ 357 6279 ] |
| 51 | 0.39 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.end_survey AS end_survey_4, t0.is_correct AS is_correct_5, t0.score AS score_6, t0.question_id AS question_id_7 FROM app_answer t0 WHERE t0.question_id = ?
Parameters:
[
357
]
|
| 52 | 0.36 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.question_id AS question_id_5 FROM app_question_image t0 WHERE t0.question_id = ?
Parameters:
[
357
]
|
| 53 | 0.37 ms |
SELECT t0.id AS id_1, t0.result AS result_2, t0.create_at AS create_at_3, t0.completed AS completed_4, t0.survey_id AS survey_id_5, t0.question_id AS question_id_6, t0.answer_id AS answer_id_7, t0.user_id AS user_id_8 FROM app_questionnaire_result t0 WHERE t0.question_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ 358 6279 ] |
| 54 | 0.34 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.end_survey AS end_survey_4, t0.is_correct AS is_correct_5, t0.score AS score_6, t0.question_id AS question_id_7 FROM app_answer t0 WHERE t0.question_id = ?
Parameters:
[
358
]
|
| 55 | 0.33 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.question_id AS question_id_5 FROM app_question_image t0 WHERE t0.question_id = ?
Parameters:
[
358
]
|
| 56 | 0.38 ms |
SELECT t0.id AS id_1, t0.result AS result_2, t0.create_at AS create_at_3, t0.completed AS completed_4, t0.survey_id AS survey_id_5, t0.question_id AS question_id_6, t0.answer_id AS answer_id_7, t0.user_id AS user_id_8 FROM app_questionnaire_result t0 WHERE t0.question_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ 359 6279 ] |
| 57 | 0.35 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.end_survey AS end_survey_4, t0.is_correct AS is_correct_5, t0.score AS score_6, t0.question_id AS question_id_7 FROM app_answer t0 WHERE t0.question_id = ?
Parameters:
[
359
]
|
| 58 | 0.33 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.question_id AS question_id_5 FROM app_question_image t0 WHERE t0.question_id = ?
Parameters:
[
359
]
|
| 59 | 0.37 ms |
SELECT t0.id AS id_1, t0.result AS result_2, t0.create_at AS create_at_3, t0.completed AS completed_4, t0.survey_id AS survey_id_5, t0.question_id AS question_id_6, t0.answer_id AS answer_id_7, t0.user_id AS user_id_8 FROM app_questionnaire_result t0 WHERE t0.question_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ 360 6279 ] |
| 60 | 0.34 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.end_survey AS end_survey_4, t0.is_correct AS is_correct_5, t0.score AS score_6, t0.question_id AS question_id_7 FROM app_answer t0 WHERE t0.question_id = ?
Parameters:
[
360
]
|
| 61 | 0.32 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.question_id AS question_id_5 FROM app_question_image t0 WHERE t0.question_id = ?
Parameters:
[
360
]
|
| 62 | 0.38 ms |
SELECT t0.id AS id_1, t0.result AS result_2, t0.create_at AS create_at_3, t0.completed AS completed_4, t0.survey_id AS survey_id_5, t0.question_id AS question_id_6, t0.answer_id AS answer_id_7, t0.user_id AS user_id_8 FROM app_questionnaire_result t0 WHERE t0.question_id = ? AND t0.user_id = ? LIMIT 1
Parameters:
[ 361 6279 ] |
| 63 | 0.34 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.text_local AS text_local_3, t0.end_survey AS end_survey_4, t0.is_correct AS is_correct_5, t0.score AS score_6, t0.question_id AS question_id_7 FROM app_answer t0 WHERE t0.question_id = ?
Parameters:
[
361
]
|
| 64 | 0.33 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_kg AS is_kg_3, t0.updated_at AS updated_at_4, t0.question_id AS question_id_5 FROM app_question_image t0 WHERE t0.question_id = ?
Parameters:
[
361
]
|
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 | No errors. |
| App\Entity\QuestionnaireResult |
|
| App\Entity\Survey |
|
| App\Entity\Article |
|
| App\Entity\SurveyImage | No errors. |
| App\Entity\Question | No errors. |
| App\Entity\Answer | No errors. |
| App\Entity\QuestionImage | No errors. |