https://doggy.cash/slots/play/910

Query Metrics

9 Database Queries
6 Different statements
2.94 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.