Query Metrics
9
Database Queries
6
Different statements
2.94 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.60 ms |
SELECT * FROM users WHERE hash = ?
Parameters:
[
"local:цуа"
]
|
| 2 | 0.20 ms |
SELECT id FROM users WHERE hash = ?
Parameters:
[
"local:цуа"
]
|
| 3 | 0.24 ms |
SELECT DATE(created_at) AS reg_date, COUNT(*) AS registrations FROM users WHERE ref_id = ? AND DATE(created_at) >= DATE_SUB(CURDATE(), INTERVAL 4 DAY) GROUP BY reg_date
Parameters:
[
"2"
]
|
| 4 | 0.37 ms |
SELECT * FROM users WHERE hash = ?
Parameters:
[
"local:цуа"
]
|
| 5 | 0.34 ms |
SELECT COALESCE(SUM(suma), 0) FROM deposits WHERE user_id = ? AND STATUS = 1
Parameters:
[
"2"
]
|
| 6 | 0.32 ms |
SELECT * FROM users WHERE hash = ?
Parameters:
[
"local:цуа"
]
|
| 7 | 0.27 ms |
SELECT * FROM slots WHERE id = ?
Parameters:
[
910
]
|
| 8 | 0.29 ms |
SELECT * FROM users WHERE hash = ?
Parameters:
[
"local:цуа"
]
|
| 9 | 0.31 ms |
SELECT SUM(suma) FROM deposits WHERE user_id = ? AND STATUS = 1 AND STR_TO_DATE(data, '%d-%m-%Y %H:%i:%s') >= DATE_SUB(NOW(), INTERVAL 7 DAY)
Parameters:
[
"2"
]
|
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
No loaded entities.