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

Query Metrics

6 Database Queries
6 Different statements
98.22 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 90.13 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:
[
  "202BC88E-35B8-4249-A2F5-2F68483C91EE"
]
2 0.88 ms
SELECT a0_.challenge_id AS sclr_0 FROM action_log a0_ WHERE a0_.player_id = ?
Parameters:
[
  128466
]
3 1.97 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:
[
  [
    "1"
    "217"
    "32"
    "116"
  ]
]
4 0.29 ms
"START TRANSACTION"
Parameters:
[]
5 0.60 ms
INSERT INTO action_log (action, created_at, player_id, challenge_id) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "seen"
  2 => "2024-07-01 00:58:29"
  3 => 128466
  4 => 7
]
6 4.36 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.