https://api.deeper-couple.com/api/next

Query Metrics

9 Database Queries
7 Different statements
77.89 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
68.67 ms
(0.00%)
1
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"
]
6.04 ms
(0.00%)
2
"COMMIT"
Parameters:
[]
1.37 ms
(0.00%)
1
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
  ]
]
0.57 ms
(0.00%)
1
SELECT a0_.challenge_id AS sclr_0 FROM action_log a0_ WHERE a0_.player_id = ?
Parameters:
[
  130181
]
0.48 ms
(0.00%)
1
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
]
0.38 ms
(0.00%)
2
"START TRANSACTION"
Parameters:
[]
0.37 ms
(0.00%)
1
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
]

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.