Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.accronym AS accronym_3,
  t0.symbole AS symbole_4,
  t0.is_deleted AS is_deleted_5,
  t0.is_default AS is_default_6,
  t0.is_local AS is_local_7
FROM
  currency t0
WHERE
  t0.is_default = ?
  AND t0.is_deleted = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.accronym AS accronym_3, t0.symbole AS symbole_4, t0.is_deleted AS is_deleted_5, t0.is_default AS is_default_6, t0.is_local AS is_local_7 FROM currency t0 WHERE t0.is_default = 1 AND t0.is_deleted = 0 LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.code AS code_1,
  b0_.label AS label_2,
  b0_.amount AS amount_3,
  b0_.year AS year_4,
  b0_.description AS description_5,
  b0_.created_at AS created_at_6,
  b0_.updated_at AS updated_at_7,
  b0_.is_deleted AS is_deleted_8,
  b0_.currency_id AS currency_id_9
FROM
  budget_item b0_
  LEFT JOIN project p1_ ON b0_.id = p1_.budget_item_id
  LEFT JOIN administrative_unit a2_ ON p1_.administrative_unit_id = a2_.id
WHERE
  b0_.is_deleted = ?
  AND b0_.year = ?
ORDER BY
  b0_.label ASC

SELECT b0_.id AS id_0, b0_.code AS code_1, b0_.label AS label_2, b0_.amount AS amount_3, b0_.year AS year_4, b0_.description AS description_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.is_deleted AS is_deleted_8, b0_.currency_id AS currency_id_9 FROM budget_item b0_ LEFT JOIN project p1_ ON b0_.id = p1_.budget_item_id LEFT JOIN administrative_unit a2_ ON p1_.administrative_unit_id = a2_.id WHERE b0_.is_deleted = 0 AND b0_.year = 2025 ORDER BY b0_.label ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.type AS type_3,
  t0.is_investment_project AS is_investment_project_4,
  t0.planned_budget AS planned_budget_5,
  t0.realized_budget AS realized_budget_6,
  t0.status AS status_7,
  t0.planned_start_date AS planned_start_date_8,
  t0.planned_end_date AS planned_end_date_9,
  t0.actual_start_date AS actual_start_date_10,
  t0.actual_end_date AS actual_end_date_11,
  t0.created_at AS created_at_12,
  t0.market_type AS market_type_13,
  t0.is_deleted AS is_deleted_14,
  t0.title AS title_15,
  t0.phase AS phase_16,
  t0.description AS description_17,
  t0.is_sub_project AS is_sub_project_18,
  t0.currency_id AS currency_id_19,
  t0.site_id AS site_id_20,
  t0.objective_id AS objective_id_21,
  t0.administrative_unit_id AS administrative_unit_id_22,
  t0.budget_item_id AS budget_item_id_23,
  t0.main_project_id AS main_project_id_24
FROM
  project t0
WHERE
  t0.budget_item_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.type AS type_3, t0.is_investment_project AS is_investment_project_4, t0.planned_budget AS planned_budget_5, t0.realized_budget AS realized_budget_6, t0.status AS status_7, t0.planned_start_date AS planned_start_date_8, t0.planned_end_date AS planned_end_date_9, t0.actual_start_date AS actual_start_date_10, t0.actual_end_date AS actual_end_date_11, t0.created_at AS created_at_12, t0.market_type AS market_type_13, t0.is_deleted AS is_deleted_14, t0.title AS title_15, t0.phase AS phase_16, t0.description AS description_17, t0.is_sub_project AS is_sub_project_18, t0.currency_id AS currency_id_19, t0.site_id AS site_id_20, t0.objective_id AS objective_id_21, t0.administrative_unit_id AS administrative_unit_id_22, t0.budget_item_id AS budget_item_id_23, t0.main_project_id AS main_project_id_24 FROM project t0 WHERE t0.budget_item_id = 17;

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 132 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.accronym AS accronym_3,
  t0.type AS type_4,
  t0.is_deleted AS is_deleted_5
FROM
  administrative_unit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.accronym AS accronym_3, t0.type AS type_4, t0.is_deleted AS is_deleted_5 FROM administrative_unit t0 WHERE t0.id = 24;

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 133 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.type AS type_3,
  t0.is_investment_project AS is_investment_project_4,
  t0.planned_budget AS planned_budget_5,
  t0.realized_budget AS realized_budget_6,
  t0.status AS status_7,
  t0.planned_start_date AS planned_start_date_8,
  t0.planned_end_date AS planned_end_date_9,
  t0.actual_start_date AS actual_start_date_10,
  t0.actual_end_date AS actual_end_date_11,
  t0.created_at AS created_at_12,
  t0.market_type AS market_type_13,
  t0.is_deleted AS is_deleted_14,
  t0.title AS title_15,
  t0.phase AS phase_16,
  t0.description AS description_17,
  t0.is_sub_project AS is_sub_project_18,
  t0.currency_id AS currency_id_19,
  t0.site_id AS site_id_20,
  t0.objective_id AS objective_id_21,
  t0.administrative_unit_id AS administrative_unit_id_22,
  t0.budget_item_id AS budget_item_id_23,
  t0.main_project_id AS main_project_id_24
FROM
  project t0
WHERE
  t0.budget_item_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.type AS type_3, t0.is_investment_project AS is_investment_project_4, t0.planned_budget AS planned_budget_5, t0.realized_budget AS realized_budget_6, t0.status AS status_7, t0.planned_start_date AS planned_start_date_8, t0.planned_end_date AS planned_end_date_9, t0.actual_start_date AS actual_start_date_10, t0.actual_end_date AS actual_end_date_11, t0.created_at AS created_at_12, t0.market_type AS market_type_13, t0.is_deleted AS is_deleted_14, t0.title AS title_15, t0.phase AS phase_16, t0.description AS description_17, t0.is_sub_project AS is_sub_project_18, t0.currency_id AS currency_id_19, t0.site_id AS site_id_20, t0.objective_id AS objective_id_21, t0.administrative_unit_id AS administrative_unit_id_22, t0.budget_item_id AS budget_item_id_23, t0.main_project_id AS main_project_id_24 FROM project t0 WHERE t0.budget_item_id = 18;

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 143 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 144 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 145 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 146 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 147 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 148 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 149 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 150 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 151 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 152 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 153 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 154 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 155 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 156 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 157 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 158 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 159 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 160 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.accronym AS accronym_3,
  t0.type AS type_4,
  t0.is_deleted AS is_deleted_5
FROM
  administrative_unit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.accronym AS accronym_3, t0.type AS type_4, t0.is_deleted AS is_deleted_5 FROM administrative_unit t0 WHERE t0.id = 17;

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 161 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 162 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 163 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?

SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = 164 AND e0_.status = 'VALIDATED' AND e0_.expense_date <= '2025-11-30 00:00:00';

SELECT
  COALESCE(
    SUM(e0_.amount),
    0
  ) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.project_id = ?
  AND e0_.status = ?
  AND e0_.expense_date <= ?