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

Query Metrics

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

Queries

Group similar statements

# 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.