https://telegram.irokez.me/gti/survey

Query Metrics

23 Database Queries
8 Different statements
19.13 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.42 ms
(28.36%)
1
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:
[
  6301269788
]
4.67 ms
(24.41%)
6
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:
[
  424
  3386
]
2.87 ms
(15.01%)
6
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:
[
  424
]
2.69 ms
(14.09%)
6
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:
[
  424
]
1.44 ms
(7.50%)
1
SELECT DISTINCT a0_.survey_id AS sclr_0 FROM app_questionnaire_result a0_ WHERE a0_.user_id = ? AND a0_.completed = 1
Parameters:
[
  3386
]
1.05 ms
(5.49%)
1
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:
[
  "38"
  "39"
  "40"
  "41"
  "42"
  "43"
  "44"
  "45"
  "46"
  "47"
  "48"
  "49"
  "50"
  "51"
  "52"
  "53"
  "54"
  "55"
  "56"
  "57"
  "58"
  "59"
  "60"
  "61"
  "62"
  "63"
  "64"
  "65"
  "66"
  "67"
  "68"
  "69"
  "70"
  "71"
  "72"
  "73"
  "74"
  "75"
  "76"
  "77"
  "78"
  "79"
  "80"
  "81"
  "82"
  "83"
]
0.51 ms
(2.67%)
1
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:
[
  84
]
0.47 ms
(2.47%)
1
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:
[
  84
]

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 No errors.
App\Entity\Survey
  • The field App\Entity\Survey#articleSuccess is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Article#survey does not contain the required 'mappedBy="articleSuccess"' attribute.
  • If association App\Entity\Survey#articleSuccess is many-to-one, then the inversed side App\Entity\Article#survey has to be one-to-many.
  • The field App\Entity\Survey#articleFailed is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Article#survey does not contain the required 'mappedBy="articleFailed"' attribute.
  • If association App\Entity\Survey#articleFailed is many-to-one, then the inversed side App\Entity\Article#survey has to be one-to-many.
App\Entity\Article
  • The association App\Entity\Article#survey refers to the inverse side field App\Entity\Survey#article which does not exist.
App\Entity\SurveyImage No errors.
App\Entity\Question No errors.
App\Entity\Answer No errors.
App\Entity\QuestionImage No errors.