Query Metrics
9
Database Queries
6
Different statements
2.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.58 ms (53.81%) |
4 |
SELECT * FROM users WHERE hash = ?
Parameters:
[
"local:цуа"
]
|
|
0.34 ms (11.74%) |
1 |
SELECT COALESCE(SUM(suma), 0) FROM deposits WHERE user_id = ? AND STATUS = 1
Parameters:
[
"2"
]
|
|
0.31 ms (10.52%) |
1 |
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"
]
|
|
0.27 ms (9.06%) |
1 |
SELECT * FROM slots WHERE id = ?
Parameters:
[
910
]
|
|
0.24 ms (8.07%) |
1 |
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"
]
|
|
0.20 ms (6.81%) |
1 |
SELECT id FROM users WHERE hash = ?
Parameters:
[
"local:цуа"
]
|
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.