Query Metrics
4
Database Queries
4
Different statements
54.39 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
26.62 ms (48.95%) |
1 |
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" ] |
|
26.20 ms (48.16%) |
1 |
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" ] |
|
0.95 ms (1.75%) |
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.id = ?
Parameters:
[
1
]
|
|
0.62 ms (1.14%) |
1 |
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 ] |
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 |
|