Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.user_id AS user_id_3
FROM
  api_token t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.token AS token_2, t0.user_id AS user_id_3 FROM api_token t0 WHERE t0.token = '917ee1c4e21a9a1455e6ebb4bee14cb67cb41dbb7e0518c57f1b2bbc99ad8f4a' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 1;

SELECT
  AVG(l0_.dayahead) AS sclr_0,
  AVG(l0_.realtime_web) AS sclr_1,
  l0_.id AS id_2,
  l0_.date AS date_3,
  l0_.hour AS hour_4,
  l0_.intervals AS intervals_5,
  l0_.dayahead AS dayahead_6,
  l0_.realtime AS realtime_7,
  l0_.prelimhour AS prelimhour_8,
  l0_.prelimfive AS prelimfive_9,
  l0_.realtime_web AS realtime_web_10,
  l0_.peak AS peak_11,
  s1_.id AS id_12,
  s1_.name AS name_13,
  u2_.id AS id_14,
  u2_.type AS type_15,
  l0_.settlement_id AS settlement_id_16,
  l0_.type_id AS type_id_17,
  s1_.type_id AS type_id_18
FROM
  lmp l0_
  INNER JOIN settlements s1_ ON l0_.settlement_id = s1_.id
  INNER JOIN unitzonal u2_ ON l0_.type_id = u2_.id
WHERE
  l0_.id IN (
    SELECT
      l3_.id
    FROM
      lmp l3_
      INNER JOIN settlements s4_ ON l3_.settlement_id = s4_.id
    WHERE
      l3_.date <= ?
      AND l3_.date >= ?
      AND s4_.id = ?
  )
GROUP BY
  l0_.settlement_id
ORDER BY
  l0_.id ASC
LIMIT
  50

SELECT AVG(l0_.dayahead) AS sclr_0, AVG(l0_.realtime_web) AS sclr_1, l0_.id AS id_2, l0_.date AS date_3, l0_.hour AS hour_4, l0_.intervals AS intervals_5, l0_.dayahead AS dayahead_6, l0_.realtime AS realtime_7, l0_.prelimhour AS prelimhour_8, l0_.prelimfive AS prelimfive_9, l0_.realtime_web AS realtime_web_10, l0_.peak AS peak_11, s1_.id AS id_12, s1_.name AS name_13, u2_.id AS id_14, u2_.type AS type_15, l0_.settlement_id AS settlement_id_16, l0_.type_id AS type_id_17, s1_.type_id AS type_id_18 FROM lmp l0_ INNER JOIN settlements s1_ ON l0_.settlement_id = s1_.id INNER JOIN unitzonal u2_ ON l0_.type_id = u2_.id WHERE l0_.id IN (SELECT l3_.id FROM lmp l3_ INNER JOIN settlements s4_ ON l3_.settlement_id = s4_.id WHERE l3_.date <= '2025-10-01' AND l3_.date >= '2025-09-01' AND s4_.id = '4006') GROUP BY l0_.settlement_id ORDER BY l0_.id ASC LIMIT 50;

SELECT
  count(DISTINCT l0_.settlement_id) AS sclr_0
FROM
  lmp l0_
  INNER JOIN settlements s1_ ON l0_.settlement_id = s1_.id
  INNER JOIN unitzonal u2_ ON l0_.type_id = u2_.id
WHERE
  l0_.id IN (
    SELECT
      l3_.id
    FROM
      lmp l3_
      INNER JOIN settlements s4_ ON l3_.settlement_id = s4_.id
    WHERE
      l3_.date <= ?
      AND l3_.date >= ?
      AND s4_.id = ?
  )
GROUP BY
  l0_.settlement_id

SELECT count(DISTINCT l0_.settlement_id) AS sclr_0 FROM lmp l0_ INNER JOIN settlements s1_ ON l0_.settlement_id = s1_.id INNER JOIN unitzonal u2_ ON l0_.type_id = u2_.id WHERE l0_.id IN (SELECT l3_.id FROM lmp l3_ INNER JOIN settlements s4_ ON l3_.settlement_id = s4_.id WHERE l3_.date <= '2025-10-01' AND l3_.date >= '2025-09-01' AND s4_.id = '4006') GROUP BY l0_.settlement_id;