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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 48.99 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:
[
  "9279EA53-44AD-403B-89D3-87C56E98D76F"
]
2 0.63 ms
SELECT a0_.challenge_id AS sclr_0 FROM action_log a0_ WHERE a0_.player_id = ?
Parameters:
[
  130185
]
3 1.34 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:
[
  [
    "218"
    "56"
    "107"
  ]
]
4 0.16 ms
"START TRANSACTION"
Parameters:
[]
5 0.39 ms
INSERT INTO action_log (action, created_at, player_id, challenge_id) VALUES (?, ?, ?, ?)
Parameters:
[
  1 => "seen"
  2 => "2024-10-06 01:18:07"
  3 => 130185
  4 => 161
]
6 4.98 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.