Symfony Profiler

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

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 = '05718629-BEE7-4AB7-98F4-A1F80E221596' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO player (
  identificator, premium, created_at,
  language
)
VALUES
  (?, ?, ?, ?)

INSERT INTO player (identificator, premium, created_at, language) VALUES ('05718629-BEE7-4AB7-98F4-A1F80E221596', 0, '2024-10-05 21:59:12', NULL);

"COMMIT"

"COMMIT";

SELECT
  a0_.challenge_id AS sclr_0
FROM
  action_log a0_
WHERE
  a0_.player_id = ?

SELECT a0_.challenge_id AS sclr_0 FROM action_log a0_ WHERE a0_.player_id = 130178;

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

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 (99999999) ORDER BY RAND() ASC LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO action_log (
  action, created_at, player_id, challenge_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO action_log (action, created_at, player_id, challenge_id) VALUES ('seen', '2024-10-05 21:59:12', 130178, 108);

"COMMIT"

"COMMIT";