Symfony Profiler

[
  "route" => "app_report_budget_items"
  "route_parameters" => [
    "_route" => "app_report_budget_items"
    "_controller" => "App\Controller\ReportController::budgetItemsReport"
  ]
  "request_uri" => "https://bcc-project-tracker.com/reports/budget-items"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 0
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerVIimjyq\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "sa"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "real_project_tracker"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 0
  ]
  "types" => [
    1 => 5
    2 => 5
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 0
    2 => 2025
  ]
  "types" => [
    1 => 5
    2 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 17
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 132
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 133
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 143
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 144
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 145
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 146
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 147
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 148
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 149
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 150
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 151
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 152
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 153
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 154
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 155
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 156
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 157
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 158
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 159
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 160
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 17
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 161
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 162
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 163
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 164
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 165
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 166
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 167
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 168
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 169
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 170
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 171
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 172
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 173
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 174
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 175
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 176
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 177
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 178
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 179
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 180
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 181
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 182
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 183
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 184
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 185
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 186
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 187
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 188
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 189
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 190
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 191
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 192
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 193
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 194
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 195
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 196
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 197
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 198
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 199
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 200
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 201
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 202
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 1
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 2
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 3
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 4
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 5
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 6
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 7
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 8
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 9
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 10
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 11
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 12
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 13
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 14
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 15
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 16
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 17
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 18
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 19
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 20
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 21
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 22
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 23
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 24
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 25
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 26
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 27
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 28
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 29
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 30
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 31
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 32
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 33
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 34
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 35
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 36
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 37
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 38
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 39
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 40
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 41
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 42
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 43
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 44
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 45
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 46
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 47
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 48
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 49
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 50
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 51
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 52
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 53
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 54
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 55
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 56
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 57
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 58
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 59
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 60
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 61
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 62
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 63
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 64
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 65
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 66
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 67
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 68
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 69
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 117
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 118
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 119
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 120
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 121
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 122
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(e0_.amount), 0) AS sclr_0 FROM expense e0_ WHERE e0_.project_id = ? AND e0_.status = ? AND e0_.expense_date <= ?"
  "params" => [
    1 => 295
    2 => "VALIDATED"
    3 => "2025-11-30 00:00:00"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]