Symfony Profiler

SELECT
  p0_.status AS status_0,
  COUNT(p0_.id) AS sclr_1
FROM
  project p0_
GROUP BY
  p0_.status

SELECT p0_.status AS status_0, COUNT(p0_.id) AS sclr_1 FROM project p0_ GROUP BY p0_.status;

SELECT
  a0_.status AS status_0,
  COUNT(a0_.id) AS sclr_1
FROM
  activity a0_
GROUP BY
  a0_.status

SELECT a0_.status AS status_0, COUNT(a0_.id) AS sclr_1 FROM activity a0_ GROUP BY a0_.status;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.unit AS unit_4,
  t0.baseline_value AS baseline_value_5,
  t0.target_value AS target_value_6,
  t0.current_value AS current_value_7,
  t0.category AS category_8,
  t0.frequency AS frequency_9,
  t0.created_at AS created_at_10,
  t0.project_id AS project_id_11
FROM
  indicator t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.unit AS unit_4, t0.baseline_value AS baseline_value_5, t0.target_value AS target_value_6, t0.current_value AS current_value_7, t0.category AS category_8, t0.frequency AS frequency_9, t0.created_at AS created_at_10, t0.project_id AS project_id_11 FROM indicator t0;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.description AS description_2,
  a0_.status AS status_3,
  a0_.planned_date AS planned_date_4,
  a0_.completed_date AS completed_date_5,
  a0_.category AS category_6,
  a0_.participant_count AS participant_count_7,
  a0_.cost AS cost_8,
  a0_.responsible_person AS responsible_person_9,
  a0_.created_at AS created_at_10,
  a0_.project_id AS project_id_11,
  a0_.location_id AS location_id_12
FROM
  activity a0_
WHERE
  a0_.planned_date < ?
  AND a0_.status NOT IN (?, ?)
ORDER BY
  a0_.planned_date ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.status AS status_3, a0_.planned_date AS planned_date_4, a0_.completed_date AS completed_date_5, a0_.category AS category_6, a0_.participant_count AS participant_count_7, a0_.cost AS cost_8, a0_.responsible_person AS responsible_person_9, a0_.created_at AS created_at_10, a0_.project_id AS project_id_11, a0_.location_id AS location_id_12 FROM activity a0_ WHERE a0_.planned_date < '2026-03-13 04:50:28' AND a0_.status NOT IN ('completed', 'cancelled') ORDER BY a0_.planned_date ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.region AS region_3,
  t0.district AS district_4,
  t0.country AS country_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.area_hectares AS area_hectares_8,
  t0.location_type AS location_type_9,
  t0.created_at AS created_at_10
FROM
  location t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.region AS region_3, t0.district AS district_4, t0.country AS country_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.area_hectares AS area_hectares_8, t0.location_type AS location_type_9, t0.created_at AS created_at_10 FROM location t0;

SELECT
  SUM(l0_.area_hectares) AS sclr_0
FROM
  location l0_

SELECT SUM(l0_.area_hectares) AS sclr_0 FROM location l0_;

SELECT
  SUM(p0_.budget) AS sclr_0
FROM
  project p0_

SELECT SUM(p0_.budget) AS sclr_0 FROM project p0_;

SELECT
  SUM(a0_.participant_count) AS sclr_0
FROM
  activity a0_

SELECT SUM(a0_.participant_count) AS sclr_0 FROM activity a0_;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.description AS description_2,
  a0_.status AS status_3,
  a0_.planned_date AS planned_date_4,
  a0_.completed_date AS completed_date_5,
  a0_.category AS category_6,
  a0_.participant_count AS participant_count_7,
  a0_.cost AS cost_8,
  a0_.responsible_person AS responsible_person_9,
  a0_.created_at AS created_at_10,
  a0_.project_id AS project_id_11,
  a0_.location_id AS location_id_12
FROM
  activity a0_
WHERE
  a0_.status = ?
ORDER BY
  a0_.completed_date DESC
LIMIT
  5

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.status AS status_3, a0_.planned_date AS planned_date_4, a0_.completed_date AS completed_date_5, a0_.category AS category_6, a0_.participant_count AS participant_count_7, a0_.cost AS cost_8, a0_.responsible_person AS responsible_person_9, a0_.created_at AS created_at_10, a0_.project_id AS project_id_11, a0_.location_id AS location_id_12 FROM activity a0_ WHERE a0_.status = 'completed' ORDER BY a0_.completed_date DESC LIMIT 5;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.description AS description_2,
  a0_.status AS status_3,
  a0_.planned_date AS planned_date_4,
  a0_.completed_date AS completed_date_5,
  a0_.category AS category_6,
  a0_.participant_count AS participant_count_7,
  a0_.cost AS cost_8,
  a0_.responsible_person AS responsible_person_9,
  a0_.created_at AS created_at_10,
  a0_.project_id AS project_id_11,
  a0_.location_id AS location_id_12
FROM
  activity a0_
WHERE
  (
    a0_.planned_date BETWEEN ?
    AND ?
  )
  AND a0_.status <> ?
ORDER BY
  a0_.planned_date ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.status AS status_3, a0_.planned_date AS planned_date_4, a0_.completed_date AS completed_date_5, a0_.category AS category_6, a0_.participant_count AS participant_count_7, a0_.cost AS cost_8, a0_.responsible_person AS responsible_person_9, a0_.created_at AS created_at_10, a0_.project_id AS project_id_11, a0_.location_id AS location_id_12 FROM activity a0_ WHERE (a0_.planned_date BETWEEN '2026-03-13 04:50:28' AND '2026-04-12 04:50:28') AND a0_.status <> 'completed' ORDER BY a0_.planned_date ASC;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.description AS description_2,
  a0_.status AS status_3,
  a0_.planned_date AS planned_date_4,
  a0_.completed_date AS completed_date_5,
  a0_.category AS category_6,
  a0_.participant_count AS participant_count_7,
  a0_.cost AS cost_8,
  a0_.responsible_person AS responsible_person_9,
  a0_.created_at AS created_at_10,
  a0_.project_id AS project_id_11,
  a0_.location_id AS location_id_12
FROM
  activity a0_
WHERE
  a0_.planned_date < ?
  AND a0_.status NOT IN (?, ?)
ORDER BY
  a0_.planned_date ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.status AS status_3, a0_.planned_date AS planned_date_4, a0_.completed_date AS completed_date_5, a0_.category AS category_6, a0_.participant_count AS participant_count_7, a0_.cost AS cost_8, a0_.responsible_person AS responsible_person_9, a0_.created_at AS created_at_10, a0_.project_id AS project_id_11, a0_.location_id AS location_id_12 FROM activity a0_ WHERE a0_.planned_date < '2026-03-13 04:50:28' AND a0_.status NOT IN ('completed', 'cancelled') ORDER BY a0_.planned_date ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.status AS status_4,
  t0.start_date AS start_date_5,
  t0.end_date AS end_date_6,
  t0.budget AS budget_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.budget AS budget_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM project t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.status AS status_4,
  t0.start_date AS start_date_5,
  t0.end_date AS end_date_6,
  t0.budget AS budget_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.budget AS budget_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM project t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.status AS status_4,
  t0.start_date AS start_date_5,
  t0.end_date AS end_date_6,
  t0.budget AS budget_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.budget AS budget_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM project t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.status AS status_4,
  t0.start_date AS start_date_5,
  t0.end_date AS end_date_6,
  t0.budget AS budget_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.budget AS budget_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM project t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.status AS status_4,
  t0.start_date AS start_date_5,
  t0.end_date AS end_date_6,
  t0.budget AS budget_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.budget AS budget_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM project t0 WHERE t0.id = 4;