Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.createdAt AS createdAt_1,
  t0_.updatedAt AS updatedAt_2,
  t0_.dateFrom AS dateFrom_3,
  t0_.dateTo AS dateTo_4,
  t0_.name AS name_5
FROM
  tbl_inventory_stage t0_
WHERE
  t0_.dateFrom <= ?
  AND t0_.dateTo >= ?
LIMIT
  1

SELECT t0_.id AS id_0, t0_.createdAt AS createdAt_1, t0_.updatedAt AS updatedAt_2, t0_.dateFrom AS dateFrom_3, t0_.dateTo AS dateTo_4, t0_.name AS name_5 FROM tbl_inventory_stage t0_ WHERE t0_.dateFrom <= '2026-03-01 01:00:00' AND t0_.dateTo >= '2026-03-01 01:00:00' LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.isDeferred AS isDeferred_1,
  t0_.isExported AS isExported_2,
  t1_.id AS id_3,
  t1_.name AS name_4,
  t1_.dateFrom AS dateFrom_5,
  t1_.dateTo AS dateTo_6,
  COUNT(DISTINCT t2_.id) AS sclr_7,
  t2_.id AS id_8,
  t2_.reference AS reference_9,
  t2_.name AS name_10,
  t3_.id AS id_11,
  COUNT(DISTINCT t3_.id) AS sclr_12,
  t3_.date AS date_13,
  t3_.status AS status_14,
  t3_.amount AS amount_15,
  t3_.amountMP AS amountMP_16,
  t3_.amountBoissons AS amountBoissons_17,
  t3_.amountAutres AS amountAutres_18,
  COUNT(
    DISTINCT CASE WHEN t4_.quantity > 0 THEN
      t4_.id
    ELSE
      NULLIF(0, 0)
    END
  ) AS sclr_19,
  (
    SELECT
      t5_.id
    FROM
      tbl_site t6_
      INNER JOIN tbl_inventory t5_ ON t6_.id = t5_.site_id
      INNER JOIN tbl_inventory_stage_site t7_ ON t5_.id = t7_.inventory_id
      INNER JOIN tbl_inventory_stage t8_ ON t7_.stage_id = t8_.id
    WHERE
      t6_.id = t2_.id
      AND t5_.status IN (?, ?)
      AND t7_.isExported = 1
      AND t8_.dateTo <= t1_.dateFrom
    ORDER BY
      t5_.date DESC
    LIMIT
      1
  ) AS sclr_20,
  (
    SELECT
      t9_.id
    FROM
      tbl_site t10_
      INNER JOIN tbl_inventory t11_ ON t10_.id = t11_.site_id
      INNER JOIN tbl_inventory_stage_site t12_ ON t11_.id = t12_.inventory_id
      INNER JOIN tbl_inventory_stage t9_ ON t12_.stage_id = t9_.id
    WHERE
      t10_.id = t2_.id
      AND t11_.status IN (?, ?)
      AND t12_.isExported = 1
      AND t9_.dateTo < t1_.dateFrom
    ORDER BY
      t11_.date DESC
    LIMIT
      1
  ) AS sclr_21,
  (
    SELECT
      t13_.id
    FROM
      tbl_inventory_stage t13_
    WHERE
      t13_.dateTo < t1_.dateFrom
    ORDER BY
      t13_.dateFrom DESC
    LIMIT
      1
  ) AS sclr_22
FROM
  tbl_inventory_stage_site t0_
  LEFT JOIN tbl_inventory_stage t1_ ON t0_.stage_id = t1_.id
  LEFT JOIN tbl_site t2_ ON t0_.site_id = t2_.id
  LEFT JOIN tbl_inventory t3_ ON t0_.inventory_id = t3_.id
  LEFT JOIN tbl_inventory_product t4_ ON t3_.id = t4_.inventory_id
WHERE
  t1_.id = ?
GROUP BY
  t0_.id
ORDER BY
  t2_.reference ASC

SELECT t0_.id AS id_0, t0_.isDeferred AS isDeferred_1, t0_.isExported AS isExported_2, t1_.id AS id_3, t1_.name AS name_4, t1_.dateFrom AS dateFrom_5, t1_.dateTo AS dateTo_6, COUNT(DISTINCT t2_.id) AS sclr_7, t2_.id AS id_8, t2_.reference AS reference_9, t2_.name AS name_10, t3_.id AS id_11, COUNT(DISTINCT t3_.id) AS sclr_12, t3_.date AS date_13, t3_.status AS status_14, t3_.amount AS amount_15, t3_.amountMP AS amountMP_16, t3_.amountBoissons AS amountBoissons_17, t3_.amountAutres AS amountAutres_18, COUNT(DISTINCT CASE WHEN t4_.quantity > 0 THEN t4_.id ELSE NULLIF(0, 0) END) AS sclr_19, (SELECT t5_.id FROM tbl_site t6_ INNER JOIN tbl_inventory t5_ ON t6_.id = t5_.site_id INNER JOIN tbl_inventory_stage_site t7_ ON t5_.id = t7_.inventory_id INNER JOIN tbl_inventory_stage t8_ ON t7_.stage_id = t8_.id WHERE t6_.id = t2_.id AND t5_.status IN ('done', 'exported') AND t7_.isExported = 1 AND t8_.dateTo <= t1_.dateFrom ORDER BY t5_.date DESC LIMIT 1) AS sclr_20, (SELECT t9_.id FROM tbl_site t10_ INNER JOIN tbl_inventory t11_ ON t10_.id = t11_.site_id INNER JOIN tbl_inventory_stage_site t12_ ON t11_.id = t12_.inventory_id INNER JOIN tbl_inventory_stage t9_ ON t12_.stage_id = t9_.id WHERE t10_.id = t2_.id AND t11_.status IN ('done', 'exported') AND t12_.isExported = 1 AND t9_.dateTo < t1_.dateFrom ORDER BY t11_.date DESC LIMIT 1) AS sclr_21, (SELECT t13_.id FROM tbl_inventory_stage t13_ WHERE t13_.dateTo < t1_.dateFrom ORDER BY t13_.dateFrom DESC LIMIT 1) AS sclr_22 FROM tbl_inventory_stage_site t0_ LEFT JOIN tbl_inventory_stage t1_ ON t0_.stage_id = t1_.id LEFT JOIN tbl_site t2_ ON t0_.site_id = t2_.id LEFT JOIN tbl_inventory t3_ ON t0_.inventory_id = t3_.id LEFT JOIN tbl_inventory_product t4_ ON t3_.id = t4_.inventory_id WHERE t1_.id = 121 GROUP BY t0_.id ORDER BY t2_.reference ASC;

SELECT
  t0_.id AS id_0,
  t0_.date AS date_1,
  t0_.status AS status_2,
  t0_.amount AS amount_3,
  t0_.amountMP AS amountMP_4,
  t0_.amountBoissons AS amountBoissons_5,
  t0_.amountAutres AS amountAutres_6,
  SUM(
    CASE WHEN t1_.quantity > 0 THEN
      1
    ELSE
      0
    END
  ) AS sclr_7,
  t2_.id AS id_8
FROM
  tbl_inventory t0_
  LEFT JOIN tbl_site t2_ ON t0_.site_id = t2_.id
  LEFT JOIN tbl_inventory_product t1_ ON t0_.id = t1_.inventory_id
WHERE
  t0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
GROUP BY
  t0_.id
ORDER BY
  t2_.reference ASC

SELECT t0_.id AS id_0, t0_.date AS date_1, t0_.status AS status_2, t0_.amount AS amount_3, t0_.amountMP AS amountMP_4, t0_.amountBoissons AS amountBoissons_5, t0_.amountAutres AS amountAutres_6, SUM(CASE WHEN t1_.quantity > 0 THEN 1 ELSE 0 END) AS sclr_7, t2_.id AS id_8 FROM tbl_inventory t0_ LEFT JOIN tbl_site t2_ ON t0_.site_id = t2_.id LEFT JOIN tbl_inventory_product t1_ ON t0_.id = t1_.inventory_id WHERE t0_.id IN (14800, 14871, 14906, 14876, 14883, 14827, 14866, 14911, 14838, 14859, 14853, 14885, 14828, 14908, 14879, 14881, 14843, 14825, 14896, 14903, 14916, 14915, 14914, 14832, 14545, 14846, 14909, 14910, 14889, 14844, 14840, 14833, 14863, 14897, 14857, 14888, 14890, 14847, 14858, 14868, 14826, 14829, 14892, 14893, 14900, 14907, 14864, 14894, 14904, 14816, 14822, 14860, 14912, 14743, 14830, 14862, 14848, 14831, 14873, 14917, 14913, 14887, 14870, 14874, 14836, 14850, 14310, 14835, 14849, 14901, 14837, 14851, 14821, 14823, 14841, 14819, 14817, 14818, 14880, 14895, 14861, 14855, 14867, 14820, 14856, 14902, 14842, 14865, 14824, 14839, 14886, 14869, 14834, 14882, 14884, 14872, 14891, 14877, 14898, 14845, 14854, 14905, 14878, 14875) GROUP BY t0_.id ORDER BY t2_.reference ASC;

SELECT
  t0_.id AS id_0,
  t0_.createdAt AS createdAt_1,
  t0_.updatedAt AS updatedAt_2,
  t0_.dateFrom AS dateFrom_3,
  t0_.dateTo AS dateTo_4,
  t0_.name AS name_5
FROM
  tbl_inventory_stage t0_
WHERE
  t0_.id IN (?, ?, ?)
ORDER BY
  t0_.dateFrom ASC
LIMIT
  1

SELECT t0_.id AS id_0, t0_.createdAt AS createdAt_1, t0_.updatedAt AS updatedAt_2, t0_.dateFrom AS dateFrom_3, t0_.dateTo AS dateTo_4, t0_.name AS name_5 FROM tbl_inventory_stage t0_ WHERE t0_.id IN (117, 119, 115) ORDER BY t0_.dateFrom ASC LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.isDeferred AS isDeferred_1,
  t0_.isExported AS isExported_2,
  t1_.id AS id_3,
  t1_.name AS name_4,
  t1_.dateFrom AS dateFrom_5,
  t1_.dateTo AS dateTo_6,
  t2_.id AS id_7,
  t3_.id AS id_8,
  t3_.date AS date_9,
  t3_.status AS status_10,
  t3_.amount AS amount_11,
  t3_.amountMP AS amountMP_12,
  t3_.amountBoissons AS amountBoissons_13,
  t3_.amountAutres AS amountAutres_14,
  COUNT(
    DISTINCT CASE WHEN t4_.quantity > 0 THEN
      t4_.id
    ELSE
      NULLIF(0, 0)
    END
  ) AS sclr_15
FROM
  tbl_inventory_stage_site t0_
  LEFT JOIN tbl_inventory_stage t1_ ON t0_.stage_id = t1_.id
  LEFT JOIN tbl_site t2_ ON t0_.site_id = t2_.id
  LEFT JOIN tbl_inventory t3_ ON t0_.inventory_id = t3_.id
  LEFT JOIN tbl_inventory_product t4_ ON t3_.id = t4_.inventory_id
WHERE
  t1_.dateTo > ?
  AND t1_.dateTo < ?
  AND t2_.id IN (?, ?, ?)
  AND (
    t3_.status IN (?, ?)
    OR (
      t3_.id IS NULL
      AND t0_.isDeferred = 1
    )
  )
GROUP BY
  t0_.id
ORDER BY
  t1_.dateFrom DESC,
  t2_.reference ASC

SELECT t0_.id AS id_0, t0_.isDeferred AS isDeferred_1, t0_.isExported AS isExported_2, t1_.id AS id_3, t1_.name AS name_4, t1_.dateFrom AS dateFrom_5, t1_.dateTo AS dateTo_6, t2_.id AS id_7, t3_.id AS id_8, t3_.date AS date_9, t3_.status AS status_10, t3_.amount AS amount_11, t3_.amountMP AS amountMP_12, t3_.amountBoissons AS amountBoissons_13, t3_.amountAutres AS amountAutres_14, COUNT(DISTINCT CASE WHEN t4_.quantity > 0 THEN t4_.id ELSE NULLIF(0, 0) END) AS sclr_15 FROM tbl_inventory_stage_site t0_ LEFT JOIN tbl_inventory_stage t1_ ON t0_.stage_id = t1_.id LEFT JOIN tbl_site t2_ ON t0_.site_id = t2_.id LEFT JOIN tbl_inventory t3_ ON t0_.inventory_id = t3_.id LEFT JOIN tbl_inventory_product t4_ ON t3_.id = t4_.inventory_id WHERE t1_.dateTo > '2025-09-01 00:00:00' AND t1_.dateTo < '2026-03-01 00:00:00' AND t2_.id IN (87, 238, 264) AND (t3_.status IN ('done', 'exported') OR (t3_.id IS NULL AND t0_.isDeferred = 1)) GROUP BY t0_.id ORDER BY t1_.dateFrom DESC, t2_.reference ASC;

SELECT
  t0_.id AS id_0,
  t0_.createdAt AS createdAt_1,
  t0_.updatedAt AS updatedAt_2,
  t0_.dateFrom AS dateFrom_3,
  t0_.dateTo AS dateTo_4,
  t0_.name AS name_5
FROM
  tbl_inventory_stage t0_
WHERE
  t0_.dateFrom <= ?
  AND t0_.dateTo >= ?
LIMIT
  1

SELECT t0_.id AS id_0, t0_.createdAt AS createdAt_1, t0_.updatedAt AS updatedAt_2, t0_.dateFrom AS dateFrom_3, t0_.dateTo AS dateTo_4, t0_.name AS name_5 FROM tbl_inventory_stage t0_ WHERE t0_.dateFrom <= '2026-04-01 01:00:00' AND t0_.dateTo >= '2026-04-01 01:00:00' LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.isDeferred AS isDeferred_1,
  t0_.isExported AS isExported_2,
  t1_.id AS id_3,
  t1_.name AS name_4,
  t1_.dateFrom AS dateFrom_5,
  t1_.dateTo AS dateTo_6,
  COUNT(DISTINCT t2_.id) AS sclr_7,
  t2_.id AS id_8,
  t2_.reference AS reference_9,
  t2_.name AS name_10,
  t3_.id AS id_11,
  COUNT(DISTINCT t3_.id) AS sclr_12,
  t3_.date AS date_13,
  t3_.status AS status_14,
  t3_.amount AS amount_15,
  t3_.amountMP AS amountMP_16,
  t3_.amountBoissons AS amountBoissons_17,
  t3_.amountAutres AS amountAutres_18,
  COUNT(
    DISTINCT CASE WHEN t4_.quantity > 0 THEN
      t4_.id
    ELSE
      NULLIF(0, 0)
    END
  ) AS sclr_19,
  (
    SELECT
      t5_.id
    FROM
      tbl_site t6_
      INNER JOIN tbl_inventory t5_ ON t6_.id = t5_.site_id
      INNER JOIN tbl_inventory_stage_site t7_ ON t5_.id = t7_.inventory_id
      INNER JOIN tbl_inventory_stage t8_ ON t7_.stage_id = t8_.id
    WHERE
      t6_.id = t2_.id
      AND t5_.status IN (?, ?)
      AND t7_.isExported = 1
      AND t8_.dateTo <= t1_.dateFrom
    ORDER BY
      t5_.date DESC
    LIMIT
      1
  ) AS sclr_20,
  (
    SELECT
      t9_.id
    FROM
      tbl_site t10_
      INNER JOIN tbl_inventory t11_ ON t10_.id = t11_.site_id
      INNER JOIN tbl_inventory_stage_site t12_ ON t11_.id = t12_.inventory_id
      INNER JOIN tbl_inventory_stage t9_ ON t12_.stage_id = t9_.id
    WHERE
      t10_.id = t2_.id
      AND t11_.status IN (?, ?)
      AND t12_.isExported = 1
      AND t9_.dateTo < t1_.dateFrom
    ORDER BY
      t11_.date DESC
    LIMIT
      1
  ) AS sclr_21,
  (
    SELECT
      t13_.id
    FROM
      tbl_inventory_stage t13_
    WHERE
      t13_.dateTo < t1_.dateFrom
    ORDER BY
      t13_.dateFrom DESC
    LIMIT
      1
  ) AS sclr_22
FROM
  tbl_inventory_stage_site t0_
  LEFT JOIN tbl_inventory_stage t1_ ON t0_.stage_id = t1_.id
  LEFT JOIN tbl_site t2_ ON t0_.site_id = t2_.id
  LEFT JOIN tbl_inventory t3_ ON t0_.inventory_id = t3_.id
  LEFT JOIN tbl_inventory_product t4_ ON t3_.id = t4_.inventory_id
WHERE
  t1_.id = ?
GROUP BY
  t0_.id
ORDER BY
  t2_.reference ASC

SELECT t0_.id AS id_0, t0_.isDeferred AS isDeferred_1, t0_.isExported AS isExported_2, t1_.id AS id_3, t1_.name AS name_4, t1_.dateFrom AS dateFrom_5, t1_.dateTo AS dateTo_6, COUNT(DISTINCT t2_.id) AS sclr_7, t2_.id AS id_8, t2_.reference AS reference_9, t2_.name AS name_10, t3_.id AS id_11, COUNT(DISTINCT t3_.id) AS sclr_12, t3_.date AS date_13, t3_.status AS status_14, t3_.amount AS amount_15, t3_.amountMP AS amountMP_16, t3_.amountBoissons AS amountBoissons_17, t3_.amountAutres AS amountAutres_18, COUNT(DISTINCT CASE WHEN t4_.quantity > 0 THEN t4_.id ELSE NULLIF(0, 0) END) AS sclr_19, (SELECT t5_.id FROM tbl_site t6_ INNER JOIN tbl_inventory t5_ ON t6_.id = t5_.site_id INNER JOIN tbl_inventory_stage_site t7_ ON t5_.id = t7_.inventory_id INNER JOIN tbl_inventory_stage t8_ ON t7_.stage_id = t8_.id WHERE t6_.id = t2_.id AND t5_.status IN ('done', 'exported') AND t7_.isExported = 1 AND t8_.dateTo <= t1_.dateFrom ORDER BY t5_.date DESC LIMIT 1) AS sclr_20, (SELECT t9_.id FROM tbl_site t10_ INNER JOIN tbl_inventory t11_ ON t10_.id = t11_.site_id INNER JOIN tbl_inventory_stage_site t12_ ON t11_.id = t12_.inventory_id INNER JOIN tbl_inventory_stage t9_ ON t12_.stage_id = t9_.id WHERE t10_.id = t2_.id AND t11_.status IN ('done', 'exported') AND t12_.isExported = 1 AND t9_.dateTo < t1_.dateFrom ORDER BY t11_.date DESC LIMIT 1) AS sclr_21, (SELECT t13_.id FROM tbl_inventory_stage t13_ WHERE t13_.dateTo < t1_.dateFrom ORDER BY t13_.dateFrom DESC LIMIT 1) AS sclr_22 FROM tbl_inventory_stage_site t0_ LEFT JOIN tbl_inventory_stage t1_ ON t0_.stage_id = t1_.id LEFT JOIN tbl_site t2_ ON t0_.site_id = t2_.id LEFT JOIN tbl_inventory t3_ ON t0_.inventory_id = t3_.id LEFT JOIN tbl_inventory_product t4_ ON t3_.id = t4_.inventory_id WHERE t1_.id = 122 GROUP BY t0_.id ORDER BY t2_.reference ASC;

SELECT
  t0_.id AS id_0,
  t0_.date AS date_1,
  t0_.status AS status_2,
  t0_.amount AS amount_3,
  t0_.amountMP AS amountMP_4,
  t0_.amountBoissons AS amountBoissons_5,
  t0_.amountAutres AS amountAutres_6,
  SUM(
    CASE WHEN t1_.quantity > 0 THEN
      1
    ELSE
      0
    END
  ) AS sclr_7,
  t2_.id AS id_8
FROM
  tbl_inventory t0_
  LEFT JOIN tbl_site t2_ ON t0_.site_id = t2_.id
  LEFT JOIN tbl_inventory_product t1_ ON t0_.id = t1_.inventory_id
WHERE
  t0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
GROUP BY
  t0_.id
ORDER BY
  t2_.reference ASC

SELECT t0_.id AS id_0, t0_.date AS date_1, t0_.status AS status_2, t0_.amount AS amount_3, t0_.amountMP AS amountMP_4, t0_.amountBoissons AS amountBoissons_5, t0_.amountAutres AS amountAutres_6, SUM(CASE WHEN t1_.quantity > 0 THEN 1 ELSE 0 END) AS sclr_7, t2_.id AS id_8 FROM tbl_inventory t0_ LEFT JOIN tbl_site t2_ ON t0_.site_id = t2_.id LEFT JOIN tbl_inventory_product t1_ ON t0_.id = t1_.inventory_id WHERE t0_.id IN (14800, 14871, 14906, 14876, 14883, 14827, 14866, 14911, 14838, 14859, 14853, 14885, 14828, 14908, 14879, 14881, 14843, 14825, 14896, 14903, 14916, 14915, 14914, 14832, 14545, 14846, 14909, 14910, 14889, 14844, 14840, 14833, 14863, 14897, 14857, 14888, 14890, 14847, 14858, 14868, 14826, 14829, 14892, 14893, 14900, 14907, 14864, 14894, 14904, 14816, 14822, 14860, 14912, 14743, 14830, 14862, 14848, 14831, 14873, 14917, 14913, 14887, 14870, 14874, 14836, 14850, 14310, 14835, 14849, 14901, 14837, 14851, 14821, 14823, 14841, 14819, 14817, 14818, 14880, 14895, 14861, 14855, 14867, 14820, 14856, 14902, 14842, 14865, 14824, 14839, 14886, 14869, 14834, 14882, 14884, 14872, 14891, 14877, 14898, 14845, 14854, 14905, 14878, 14875) GROUP BY t0_.id ORDER BY t2_.reference ASC;

SELECT
  t0_.id AS id_0,
  t0_.createdAt AS createdAt_1,
  t0_.updatedAt AS updatedAt_2,
  t0_.dateFrom AS dateFrom_3,
  t0_.dateTo AS dateTo_4,
  t0_.name AS name_5
FROM
  tbl_inventory_stage t0_
WHERE
  t0_.id IN (?, ?, ?, ?)
ORDER BY
  t0_.dateFrom ASC
LIMIT
  1

SELECT t0_.id AS id_0, t0_.createdAt AS createdAt_1, t0_.updatedAt AS updatedAt_2, t0_.dateFrom AS dateFrom_3, t0_.dateTo AS dateTo_4, t0_.name AS name_5 FROM tbl_inventory_stage t0_ WHERE t0_.id IN (120, 117, 119, 115) ORDER BY t0_.dateFrom ASC LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.isDeferred AS isDeferred_1,
  t0_.isExported AS isExported_2,
  t1_.id AS id_3,
  t1_.name AS name_4,
  t1_.dateFrom AS dateFrom_5,
  t1_.dateTo AS dateTo_6,
  t2_.id AS id_7,
  t3_.id AS id_8,
  t3_.date AS date_9,
  t3_.status AS status_10,
  t3_.amount AS amount_11,
  t3_.amountMP AS amountMP_12,
  t3_.amountBoissons AS amountBoissons_13,
  t3_.amountAutres AS amountAutres_14,
  COUNT(
    DISTINCT CASE WHEN t4_.quantity > 0 THEN
      t4_.id
    ELSE
      NULLIF(0, 0)
    END
  ) AS sclr_15
FROM
  tbl_inventory_stage_site t0_
  LEFT JOIN tbl_inventory_stage t1_ ON t0_.stage_id = t1_.id
  LEFT JOIN tbl_site t2_ ON t0_.site_id = t2_.id
  LEFT JOIN tbl_inventory t3_ ON t0_.inventory_id = t3_.id
  LEFT JOIN tbl_inventory_product t4_ ON t3_.id = t4_.inventory_id
WHERE
  t1_.dateTo > ?
  AND t1_.dateTo < ?
  AND t2_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND (
    t3_.status IN (?, ?)
    OR (
      t3_.id IS NULL
      AND t0_.isDeferred = 1
    )
  )
GROUP BY
  t0_.id
ORDER BY
  t1_.dateFrom DESC,
  t2_.reference ASC

SELECT t0_.id AS id_0, t0_.isDeferred AS isDeferred_1, t0_.isExported AS isExported_2, t1_.id AS id_3, t1_.name AS name_4, t1_.dateFrom AS dateFrom_5, t1_.dateTo AS dateTo_6, t2_.id AS id_7, t3_.id AS id_8, t3_.date AS date_9, t3_.status AS status_10, t3_.amount AS amount_11, t3_.amountMP AS amountMP_12, t3_.amountBoissons AS amountBoissons_13, t3_.amountAutres AS amountAutres_14, COUNT(DISTINCT CASE WHEN t4_.quantity > 0 THEN t4_.id ELSE NULLIF(0, 0) END) AS sclr_15 FROM tbl_inventory_stage_site t0_ LEFT JOIN tbl_inventory_stage t1_ ON t0_.stage_id = t1_.id LEFT JOIN tbl_site t2_ ON t0_.site_id = t2_.id LEFT JOIN tbl_inventory t3_ ON t0_.inventory_id = t3_.id LEFT JOIN tbl_inventory_product t4_ ON t3_.id = t4_.inventory_id WHERE t1_.dateTo > '2025-09-01 00:00:00' AND t1_.dateTo < '2026-04-01 00:00:00' AND t2_.id IN (3, 7, 28, 30, 31, 32, 34, 36, 38, 40, 41, 42, 49, 50, 51, 53, 55, 59, 60, 66, 67, 76, 79, 82, 87, 88, 96, 97, 114, 117, 128, 131, 137, 145, 146, 154, 153, 156, 157, 159, 160, 201, 168, 169, 170, 171, 172, 173, 174, 176, 200, 210, 207, 238, 239, 240, 243, 244, 245, 251, 253, 255, 256, 257, 259, 263, 264, 268, 265, 279, 269, 272, 273, 274, 275, 282, 283, 284, 285, 286, 289, 292, 293, 294, 298, 299, 300, 301, 302, 304, 305, 307, 306, 311, 312, 313, 314, 317, 318, 323, 319, 324, 321, 320) AND (t3_.status IN ('done', 'exported') OR (t3_.id IS NULL AND t0_.isDeferred = 1)) GROUP BY t0_.id ORDER BY t1_.dateFrom DESC, t2_.reference ASC;

SELECT
  t0_.id AS id_0,
  t0_.createdAt AS createdAt_1,
  t0_.updatedAt AS updatedAt_2,
  t0_.dateFrom AS dateFrom_3,
  t0_.dateTo AS dateTo_4,
  t0_.name AS name_5
FROM
  tbl_inventory_stage t0_
WHERE
  t0_.dateFrom <= ?
  AND t0_.dateTo >= ?
LIMIT
  1

SELECT t0_.id AS id_0, t0_.createdAt AS createdAt_1, t0_.updatedAt AS updatedAt_2, t0_.dateFrom AS dateFrom_3, t0_.dateTo AS dateTo_4, t0_.name AS name_5 FROM tbl_inventory_stage t0_ WHERE t0_.dateFrom <= '2026-05-01 01:00:00' AND t0_.dateTo >= '2026-05-01 01:00:00' LIMIT 1;