Query Metrics

4 Database Queries
4 Different statements
54.39 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.95 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.id = ?
Parameters:
[
  1
]
2 26.62 ms
SELECT DISTINCT a0_.id AS id_0 FROM app_user a0_ WHERE (LOWER(a0_.name) LIKE ? OR LOWER(a0_.name) IN (?) OR LOWER(a0_.telegram_id) LIKE ? OR LOWER(a0_.telegram_id) IN (?) OR LOWER(a0_.phone) LIKE ? OR LOWER(a0_.phone) IN (?) OR LOWER(a0_.email) LIKE ? OR LOWER(a0_.email) IN (?) OR LOWER(a0_.city) LIKE ? OR LOWER(a0_.city) IN (?) OR LOWER(a0_.password) LIKE ? OR LOWER(a0_.password) IN (?) OR LOWER(a0_.brands_history) LIKE ? OR LOWER(a0_.brands_history) IN (?)) AND a0_.roles IS NULL LIMIT 20
Parameters:
[
  "%996999848418%"
  "996999848418"
  "%996999848418%"
  "996999848418"
  "%996999848418%"
  "996999848418"
  "%996999848418%"
  "996999848418"
  "%996999848418%"
  "996999848418"
  "%996999848418%"
  "996999848418"
  "%996999848418%"
  "996999848418"
]
3 0.62 ms
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.create_at AS create_at_2, a0_.telegram_id AS telegram_id_3, a0_.phone AS phone_4, a0_.is_admin AS is_admin_5, a0_.is_banned AS is_banned_6, a0_.email AS email_7, a0_.city AS city_8, a0_.roles AS roles_9, a0_.password AS password_10, a0_.brands_history AS brands_history_11 FROM app_user a0_ WHERE (LOWER(a0_.name) LIKE ? OR LOWER(a0_.name) IN (?) OR LOWER(a0_.telegram_id) LIKE ? OR LOWER(a0_.telegram_id) IN (?) OR LOWER(a0_.phone) LIKE ? OR LOWER(a0_.phone) IN (?) OR LOWER(a0_.email) LIKE ? OR LOWER(a0_.email) IN (?) OR LOWER(a0_.city) LIKE ? OR LOWER(a0_.city) IN (?) OR LOWER(a0_.password) LIKE ? OR LOWER(a0_.password) IN (?) OR LOWER(a0_.brands_history) LIKE ? OR LOWER(a0_.brands_history) IN (?)) AND a0_.roles IS NULL AND a0_.id IN (?)
Parameters:
[
  "%996999848418%"
  "996999848418"
  "%996999848418%"
  "996999848418"
  "%996999848418%"
  "996999848418"
  "%996999848418%"
  "996999848418"
  "%996999848418%"
  "996999848418"
  "%996999848418%"
  "996999848418"
  "%996999848418%"
  "996999848418"
  1074
]
4 26.20 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM app_user a0_ WHERE (LOWER(a0_.name) LIKE ? OR LOWER(a0_.name) IN (?) OR LOWER(a0_.telegram_id) LIKE ? OR LOWER(a0_.telegram_id) IN (?) OR LOWER(a0_.phone) LIKE ? OR LOWER(a0_.phone) IN (?) OR LOWER(a0_.email) LIKE ? OR LOWER(a0_.email) IN (?) OR LOWER(a0_.city) LIKE ? OR LOWER(a0_.city) IN (?) OR LOWER(a0_.password) LIKE ? OR LOWER(a0_.password) IN (?) OR LOWER(a0_.brands_history) LIKE ? OR LOWER(a0_.brands_history) IN (?)) AND a0_.roles IS NULL
Parameters:
[
  "%996999848418%"
  "996999848418"
  "%996999848418%"
  "996999848418"
  "%996999848418%"
  "996999848418"
  "%996999848418%"
  "996999848418"
  "%996999848418%"
  "996999848418"
  "%996999848418%"
  "996999848418"
  "%996999848418%"
  "996999848418"
]

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
  • The association App\Entity\QuestionnaireResult#survey refers to the inverse side field App\Entity\Survey#questionnaireResults which does not exist.
  • The association App\Entity\QuestionnaireResult#question refers to the inverse side field App\Entity\Question#questionnaireResults which does not exist.
  • The association App\Entity\QuestionnaireResult#answer refers to the inverse side field App\Entity\Answer#questionnaireResults which does not exist.