Query Metrics
9
Database Queries
7
Different statements
77.89 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 68.67 ms |
SELECT t0.id AS id_1, t0.identificator AS identificator_2, t0.premium AS premium_3, t0.created_at AS created_at_4, t0.language AS language_5 FROM player t0 WHERE t0.identificator = ? LIMIT 1
Parameters:
[
"41933F14-F22C-4EED-907A-D11C332AB624"
]
|
2 | 0.25 ms |
"START TRANSACTION"
Parameters:
[] |
3 | 0.48 ms |
INSERT INTO player (identificator, premium, created_at, language) VALUES (?, ?, ?, ?)
Parameters:
[ 1 => "41933F14-F22C-4EED-907A-D11C332AB624" 2 => 0 3 => "2024-10-05 23:05:48" 4 => null ] |
4 | 2.79 ms |
"COMMIT"
Parameters:
[] |
5 | 0.57 ms |
SELECT a0_.challenge_id AS sclr_0 FROM action_log a0_ WHERE a0_.player_id = ?
Parameters:
[
130181
]
|
6 | 1.37 ms |
SELECT c0_.id AS id_0, c0_.challenge_en AS challenge_en_1, c0_.challenge_fr AS challenge_fr_2, c0_.challenge_esp AS challenge_esp_3 FROM challenge c0_ WHERE c0_.id NOT IN (?) ORDER BY RAND() ASC LIMIT 1
Parameters:
[
[
99999999
]
]
|
7 | 0.14 ms |
"START TRANSACTION"
Parameters:
[] |
8 | 0.37 ms |
INSERT INTO action_log (action, created_at, player_id, challenge_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 => "seen" 2 => "2024-10-05 23:05:48" 3 => 130181 4 => 22 ] |
9 | 3.25 ms |
"COMMIT"
Parameters:
[] |
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\Player | No errors. |
App\Entity\ActionLog | No errors. |
App\Entity\Challenge | No errors. |