Symfony Profiler

SELECT
  h0_.id AS id_0,
  h0_.volume_produit AS volume_produit_1,
  h0_.date_at AS date_at_2,
  h0_.initiale AS initiale_3,
  h0_.citerne_id AS citerne_id_4
FROM
  historique_citerne h0_
  LEFT JOIN citerne c1_ ON h0_.citerne_id = c1_.id
WHERE
  h0_.id = (
    SELECT
      MAX(h2_.id) AS sclr_5
    FROM
      historique_citerne h2_
    WHERE
      h2_.citerne_id = h0_.citerne_id
  )
GROUP BY
  c1_.id

SELECT h0_.id AS id_0, h0_.volume_produit AS volume_produit_1, h0_.date_at AS date_at_2, h0_.initiale AS initiale_3, h0_.citerne_id AS citerne_id_4 FROM historique_citerne h0_ LEFT JOIN citerne c1_ ON h0_.citerne_id = c1_.id WHERE h0_.id = (SELECT MAX(h2_.id) AS sclr_5 FROM historique_citerne h2_ WHERE h2_.citerne_id = h0_.citerne_id) GROUP BY c1_.id;

SELECT
  sum(h0_.volume_produit) AS sclr_0
FROM
  historique_citerne h0_
WHERE
  h0_.citerne_id = ?
  AND (
    h0_.date_at BETWEEN ?
    AND ?
  )
  AND h0_.initiale = ?

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = 1 AND (h0_.date_at BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:00') AND h0_.initiale = 1;

SELECT
  sum(h0_.volume_produit) AS sclr_0
FROM
  historique_citerne h0_
WHERE
  h0_.citerne_id = ?
  AND (
    h0_.date_at BETWEEN ?
    AND ?
  )
  AND h0_.initiale = ?

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = 2 AND (h0_.date_at BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:00') AND h0_.initiale = 1;

SELECT
  sum(h0_.volume_produit) AS sclr_0
FROM
  historique_citerne h0_
WHERE
  h0_.citerne_id = ?
  AND (
    h0_.date_at BETWEEN ?
    AND ?
  )
  AND h0_.initiale = ?

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = 3 AND (h0_.date_at BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:00') AND h0_.initiale = 1;

SELECT
  sum(h0_.volume_produit) AS sclr_0
FROM
  historique_citerne h0_
WHERE
  h0_.citerne_id = ?
  AND (
    h0_.date_at BETWEEN ?
    AND ?
  )
  AND h0_.initiale = ?

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = 4 AND (h0_.date_at BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:00') AND h0_.initiale = 1;

SELECT
  sum(h0_.volume_produit) AS sclr_0
FROM
  historique_citerne h0_
WHERE
  h0_.citerne_id = ?
  AND (
    h0_.date_at BETWEEN ?
    AND ?
  )
  AND h0_.initiale = ?

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = 6 AND (h0_.date_at BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:00') AND h0_.initiale = 1;

SELECT
  sum(h0_.volume_produit) AS sclr_0
FROM
  historique_citerne h0_
WHERE
  h0_.citerne_id = ?
  AND (
    h0_.date_at BETWEEN ?
    AND ?
  )
  AND h0_.initiale = ?

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = 7 AND (h0_.date_at BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:00') AND h0_.initiale = 1;

SELECT
  sum(h0_.volume_produit) AS sclr_0
FROM
  historique_citerne h0_
WHERE
  h0_.citerne_id = ?
  AND (
    h0_.date_at BETWEEN ?
    AND ?
  )
  AND h0_.initiale = ?

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = 9 AND (h0_.date_at BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:00') AND h0_.initiale = 1;

SELECT
  sum(h0_.volume_produit) AS sclr_0
FROM
  historique_citerne h0_
WHERE
  h0_.citerne_id = ?
  AND (
    h0_.date_at BETWEEN ?
    AND ?
  )
  AND h0_.initiale = ?

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = 10 AND (h0_.date_at BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:00') AND h0_.initiale = 1;

SELECT
  sum(h0_.volume_produit) AS sclr_0
FROM
  historique_citerne h0_
WHERE
  h0_.citerne_id = ?
  AND (
    h0_.date_at BETWEEN ?
    AND ?
  )
  AND h0_.initiale = ?

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = 11 AND (h0_.date_at BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:00') AND h0_.initiale = 1;

SELECT
  sum(h0_.volume_produit) AS sclr_0
FROM
  historique_citerne h0_
WHERE
  h0_.citerne_id = ?
  AND (
    h0_.date_at BETWEEN ?
    AND ?
  )
  AND h0_.initiale = ?

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = 12 AND (h0_.date_at BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:00') AND h0_.initiale = 1;

SELECT
  sum(h0_.volume_produit) AS sclr_0
FROM
  historique_citerne h0_
WHERE
  h0_.citerne_id = ?
  AND (
    h0_.date_at BETWEEN ?
    AND ?
  )
  AND h0_.initiale = ?

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = 13 AND (h0_.date_at BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:00') AND h0_.initiale = 1;

SELECT
  sum(h0_.volume_produit) AS sclr_0
FROM
  historique_citerne h0_
WHERE
  h0_.citerne_id = ?
  AND (
    h0_.date_at BETWEEN ?
    AND ?
  )
  AND h0_.initiale = ?

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = 15 AND (h0_.date_at BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:00') AND h0_.initiale = 1;

SELECT
  sum(h0_.volume_produit) AS sclr_0
FROM
  historique_citerne h0_
WHERE
  h0_.citerne_id = ?
  AND (
    h0_.date_at BETWEEN ?
    AND ?
  )
  AND h0_.initiale = ?

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = 16 AND (h0_.date_at BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:00') AND h0_.initiale = 1;

SELECT
  sum(h0_.volume_produit) AS sclr_0
FROM
  historique_citerne h0_
WHERE
  h0_.citerne_id = ?
  AND (
    h0_.date_at BETWEEN ?
    AND ?
  )
  AND h0_.initiale = ?

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = 19 AND (h0_.date_at BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:00') AND h0_.initiale = 1;

SELECT
  sum(h0_.volume_produit) AS sclr_0
FROM
  historique_citerne h0_
WHERE
  h0_.citerne_id = ?
  AND (
    h0_.date_at BETWEEN ?
    AND ?
  )
  AND h0_.initiale = ?

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = 20 AND (h0_.date_at BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:00') AND h0_.initiale = 1;

SELECT
  sum(h0_.volume_produit) AS sclr_0
FROM
  historique_citerne h0_
WHERE
  h0_.citerne_id = ?
  AND (
    h0_.date_at BETWEEN ?
    AND ?
  )
  AND h0_.initiale = ?

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = 21 AND (h0_.date_at BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:00') AND h0_.initiale = 1;

SELECT
  sum(h0_.volume_produit) AS sclr_0
FROM
  historique_citerne h0_
WHERE
  h0_.citerne_id = ?
  AND (
    h0_.date_at BETWEEN ?
    AND ?
  )
  AND h0_.initiale = ?

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = 22 AND (h0_.date_at BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:00') AND h0_.initiale = 1;

SELECT
  sum(h0_.volume_produit) AS sclr_0
FROM
  historique_citerne h0_
WHERE
  h0_.citerne_id = ?
  AND (
    h0_.date_at BETWEEN ?
    AND ?
  )
  AND h0_.initiale = ?

SELECT sum(h0_.volume_produit) AS sclr_0 FROM historique_citerne h0_ WHERE h0_.citerne_id = 23 AND (h0_.date_at BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:00') AND h0_.initiale = 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO historique_citerne (
  volume_produit, date_at, initiale,
  citerne_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO historique_citerne (volume_produit, date_at, initiale, citerne_id) VALUES (0, '2026-04-17 09:43:00', 1, 21);

INSERT INTO task_execution (
  task_name, started_at, finished_at,
  status, output
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO task_execution (task_name, started_at, finished_at, status, output) VALUES ('DailyTransactionHistoryInitializer', '2026-04-17 09:43:00', '2026-04-17 09:43:00', 1, 'Transactions du 2026-04-17 marquées comme initiales');

"COMMIT"

"COMMIT";