Symfony Profiler

SELECT
  count(a0_.id) AS sclr_0,
  (
    SELECT
      count(a1_.id) AS sclr_2
    FROM
      alert a1_
    WHERE
      a1_.is_valid = 1
      AND a1_.is_deleted = 0
      AND a1_.country_id = 'cd'
  ) AS sclr_1,
  (
    SELECT
      count(a2_.id) AS sclr_4
    FROM
      alert a2_
      LEFT JOIN process p3_ ON (p3_.id = a2_.statut_id)
    WHERE
      a2_.is_valid = 1
      AND a2_.is_deleted = 0
      AND p3_.workflow_id > 3
      AND a2_.country_id = 'cd'
  ) AS sclr_3
FROM
  alert a0_
  LEFT JOIN process p4_ ON (p4_.id = a0_.statut_id)
  LEFT JOIN alert_detail a5_ ON (a0_.id = a5_.alert_id)
WHERE
  a0_.is_valid = 1
  AND a0_.is_deleted = 0
  AND p4_.workflow_id > 3
  AND a0_.country_id = ?

SELECT count(a0_.id) AS sclr_0, (SELECT count(a1_.id) AS sclr_2 FROM alert a1_ WHERE a1_.is_valid = 1 AND a1_.is_deleted = 0 AND a1_.country_id = 'cd') AS sclr_1, (SELECT count(a2_.id) AS sclr_4 FROM alert a2_ LEFT JOIN process p3_ ON (p3_.id = a2_.statut_id) WHERE a2_.is_valid = 1 AND a2_.is_deleted = 0 AND p3_.workflow_id > 3 AND a2_.country_id = 'cd') AS sclr_3 FROM alert a0_ LEFT JOIN process p4_ ON (p4_.id = a0_.statut_id) LEFT JOIN alert_detail a5_ ON (a0_.id = a5_.alert_id) WHERE a0_.is_valid = 1 AND a0_.is_deleted = 0 AND p4_.workflow_id > 3 AND a0_.country_id = 'cd';

SELECT
  count(a0_.id) AS sclr_0,
  (
    SELECT
      count(a1_.id) AS sclr_2
    FROM
      alert a1_
    WHERE
      a1_.is_valid = 1
      AND a1_.is_deleted = 0
      AND a1_.country_id = 'cd'
  ) AS sclr_1,
  (
    SELECT
      count(a2_.id) AS sclr_4
    FROM
      alert a2_
      LEFT JOIN process p3_ ON (p3_.id = a2_.statut_id)
    WHERE
      a2_.is_valid = 1
      AND a2_.is_deleted = 0
      AND p3_.workflow_id > 3
      AND a2_.country_id = 'cd'
  ) AS sclr_3
FROM
  alert a0_
  LEFT JOIN process p4_ ON (p4_.id = a0_.statut_id)
  LEFT JOIN alert_detail a5_ ON (a0_.id = a5_.alert_id)
WHERE
  a0_.is_valid = 1
  AND a0_.is_deleted = 0
  AND p4_.workflow_id > 3
  AND a0_.country_id = ?

SELECT count(a0_.id) AS sclr_0, (SELECT count(a1_.id) AS sclr_2 FROM alert a1_ WHERE a1_.is_valid = 1 AND a1_.is_deleted = 0 AND a1_.country_id = 'cd') AS sclr_1, (SELECT count(a2_.id) AS sclr_4 FROM alert a2_ LEFT JOIN process p3_ ON (p3_.id = a2_.statut_id) WHERE a2_.is_valid = 1 AND a2_.is_deleted = 0 AND p3_.workflow_id > 3 AND a2_.country_id = 'cd') AS sclr_3 FROM alert a0_ LEFT JOIN process p4_ ON (p4_.id = a0_.statut_id) LEFT JOIN alert_detail a5_ ON (a0_.id = a5_.alert_id) WHERE a0_.is_valid = 1 AND a0_.is_deleted = 0 AND p4_.workflow_id > 3 AND a0_.country_id = 'cd';

SELECT
  DISTINCT a0_.id AS id_0
FROM
  actor a0_
  LEFT JOIN project_actor p1_ ON (p1_.actor_id = a0_.id)
  LEFT JOIN project p2_ ON (p1_.project_id = p2_.id)
WHERE
  p2_.end_date > ?
  AND p2_.deleted = 0
  AND p2_.is_valid = 1

SELECT DISTINCT a0_.id AS id_0 FROM actor a0_ LEFT JOIN project_actor p1_ ON (p1_.actor_id = a0_.id) LEFT JOIN project p2_ ON (p1_.project_id = p2_.id) WHERE p2_.end_date > '2025-08-26 00:00:00' AND p2_.deleted = 0 AND p2_.is_valid = 1;

SELECT
  sum(m0_.person) AS sclr_0
FROM
  movement_detail m0_
  LEFT JOIN movement m1_ ON (m1_.id = m0_.movement_id)
WHERE
  m1_.population_id = ?
  AND m1_.is_valid = 1
  AND m1_.is_deleted = 0
  AND m0_.deleted = 0
  AND (
    m1_.start_date BETWEEN ?
    AND ?
  )

SELECT sum(m0_.person) AS sclr_0 FROM movement_detail m0_ LEFT JOIN movement m1_ ON (m1_.id = m0_.movement_id) WHERE m1_.population_id = 1 AND m1_.is_valid = 1 AND m1_.is_deleted = 0 AND m0_.deleted = 0 AND (m1_.start_date BETWEEN '2023-08-28 00:00:00' AND '2025-08-27 00:00:00');

SELECT
  sum(m0_.person) AS sclr_0
FROM
  movement_detail m0_
  LEFT JOIN movement m1_ ON (m1_.id = m0_.movement_id)
WHERE
  m1_.population_id = ?
  AND m1_.is_valid = 1
  AND m1_.is_deleted = 0
  AND m0_.deleted = 0
  AND (
    m1_.date_evaluation BETWEEN ?
    AND ?
  )

SELECT sum(m0_.person) AS sclr_0 FROM movement_detail m0_ LEFT JOIN movement m1_ ON (m1_.id = m0_.movement_id) WHERE m1_.population_id = 2 AND m1_.is_valid = 1 AND m1_.is_deleted = 0 AND m0_.deleted = 0 AND (m1_.date_evaluation BETWEEN '2024-02-28 00:00:00' AND '2025-08-27 00:00:00');

SELECT
  i0_.id AS id_0,
  i0_.person AS person_1,
  i0_.label AS label_2,
  i0_.link AS link_3,
  i0_.date_create AS date_create_4,
  i0_.is_deleted AS is_deleted_5,
  i0_.population_id AS population_id_6
FROM
  idps i0_
WHERE
  i0_.population_id = ?
  AND i0_.is_deleted = ?

SELECT i0_.id AS id_0, i0_.person AS person_1, i0_.label AS label_2, i0_.link AS link_3, i0_.date_create AS date_create_4, i0_.is_deleted AS is_deleted_5, i0_.population_id AS population_id_6 FROM idps i0_ WHERE i0_.population_id = 1 AND i0_.is_deleted = 0;

SELECT
  i0_.id AS id_0,
  i0_.person AS person_1,
  i0_.label AS label_2,
  i0_.link AS link_3,
  i0_.date_create AS date_create_4,
  i0_.is_deleted AS is_deleted_5,
  i0_.population_id AS population_id_6
FROM
  idps i0_
WHERE
  i0_.population_id = ?
  AND i0_.is_deleted = ?

SELECT i0_.id AS id_0, i0_.person AS person_1, i0_.label AS label_2, i0_.link AS link_3, i0_.date_create AS date_create_4, i0_.is_deleted AS is_deleted_5, i0_.population_id AS population_id_6 FROM idps i0_ WHERE i0_.population_id = 2 AND i0_.is_deleted = 0;

SELECT
  p0_.id AS id_0,
  p0_.label AS label_1,
  p0_.latitude AS latitude_2,
  p0_.longitude AS longitude_3,
  p0_.pcode_category_id AS pcode_category_id_4,
  p0_.pcode_parent_id AS pcode_parent_id_5
FROM
  pcode p0_
WHERE
  p0_.pcode_category_id = ?

SELECT p0_.id AS id_0, p0_.label AS label_1, p0_.latitude AS latitude_2, p0_.longitude AS longitude_3, p0_.pcode_category_id AS pcode_category_id_4, p0_.pcode_parent_id AS pcode_parent_id_5 FROM pcode p0_ WHERE p0_.pcode_category_id = 2;

SELECT
  p0_.id AS id_0,
  p0_.label AS label_1,
  (
    SELECT
      count(a1_.alert_id) AS sclr_3
    FROM
      alert_detail a1_
      LEFT JOIN alert a2_ ON (a2_.id = a1_.alert_id)
    WHERE
      a1_.admin1_id = p0_.id
      AND a2_.is_valid = 1
      AND a2_.is_deleted = 0
  ) AS sclr_2,
  (
    SELECT
      COUNT(DISTINCT p3_.project_id) AS sclr_5
    FROM
      project_detail p3_
      LEFT JOIN project p4_ ON (p3_.project_id = p4_.id)
    WHERE
      p3_.admin1_id = p0_.id
      AND p4_.end_date > ?
      AND p4_.deleted = 0
      AND p4_.is_valid = 1
  ) AS sclr_4,
  (
    SELECT
      COUNT(DISTINCT p5_.actor_id) AS sclr_7
    FROM
      project_detail p6_
      LEFT JOIN project p7_ ON (p6_.project_id = p7_.id)
      LEFT JOIN project_actor p5_ ON (p5_.project_id = p6_.project_id)
    WHERE
      p6_.admin1_id = p0_.id
      AND p7_.end_date > ?
      AND p7_.deleted = 0
      AND p7_.is_valid = 1
  ) AS sclr_6,
  (
    SELECT
      sum(m8_.person) AS sclr_9
    FROM
      movement_detail m8_
      LEFT JOIN movement m9_ ON (m9_.id = m8_.movement_id)
    WHERE
      m8_.admin1_id = p0_.id
      AND m9_.population_id = 1
      AND m9_.is_valid = 1
      AND m9_.is_deleted = 0
      AND m8_.deleted = 0
      AND (
        m9_.date_evaluation BETWEEN ?
        AND ?
      )
  ) AS sclr_8,
  (
    SELECT
      sum(m10_.person) AS sclr_11
    FROM
      movement_detail m10_
      LEFT JOIN movement m11_ ON (m11_.id = m10_.movement_id)
    WHERE
      m10_.admin1_id = p0_.id
      AND m11_.population_id = 2
      AND m11_.is_valid = 1
      AND m11_.is_deleted = 0
      AND m10_.deleted = 0
      AND (
        m11_.start_date BETWEEN ?
        AND ?
      )
  ) AS sclr_10,
  (
    SELECT
      sum(p12_.target) AS sclr_13
    FROM
      project_detail p12_
      LEFT JOIN project p13_ ON (p12_.project_id = p13_.id)
    WHERE
      p12_.admin1_id = p0_.id
      AND p13_.end_date > ?
      AND p13_.deleted = 0
      AND p13_.is_valid = 1
  ) AS sclr_12
FROM
  pcode p0_
WHERE
  p0_.pcode_category_id = ?
  AND p0_.pcode_parent_id = ?
ORDER BY
  sclr_2 DESC

SELECT p0_.id AS id_0, p0_.label AS label_1, (SELECT count(a1_.alert_id) AS sclr_3 FROM alert_detail a1_ LEFT JOIN alert a2_ ON (a2_.id = a1_.alert_id) WHERE a1_.admin1_id = p0_.id AND a2_.is_valid = 1 AND a2_.is_deleted = 0) AS sclr_2, (SELECT COUNT(DISTINCT p3_.project_id) AS sclr_5 FROM project_detail p3_ LEFT JOIN project p4_ ON (p3_.project_id = p4_.id) WHERE p3_.admin1_id = p0_.id AND p4_.end_date > '2025-08-26 00:00:00' AND p4_.deleted = 0 AND p4_.is_valid = 1) AS sclr_4, (SELECT COUNT(DISTINCT p5_.actor_id) AS sclr_7 FROM project_detail p6_ LEFT JOIN project p7_ ON (p6_.project_id = p7_.id) LEFT JOIN project_actor p5_ ON (p5_.project_id = p6_.project_id) WHERE p6_.admin1_id = p0_.id AND p7_.end_date > '2025-08-26 00:00:00' AND p7_.deleted = 0 AND p7_.is_valid = 1) AS sclr_6, (SELECT sum(m8_.person) AS sclr_9 FROM movement_detail m8_ LEFT JOIN movement m9_ ON (m9_.id = m8_.movement_id) WHERE m8_.admin1_id = p0_.id AND m9_.population_id = 1 AND m9_.is_valid = 1 AND m9_.is_deleted = 0 AND m8_.deleted = 0 AND (m9_.date_evaluation BETWEEN '2023-07-28 00:00:00' AND '2025-08-27 00:00:00')) AS sclr_8, (SELECT sum(m10_.person) AS sclr_11 FROM movement_detail m10_ LEFT JOIN movement m11_ ON (m11_.id = m10_.movement_id) WHERE m10_.admin1_id = p0_.id AND m11_.population_id = 2 AND m11_.is_valid = 1 AND m11_.is_deleted = 0 AND m10_.deleted = 0 AND (m11_.start_date BETWEEN '2024-01-28 00:00:00' AND '2025-08-27 00:00:00')) AS sclr_10, (SELECT sum(p12_.target) AS sclr_13 FROM project_detail p12_ LEFT JOIN project p13_ ON (p12_.project_id = p13_.id) WHERE p12_.admin1_id = p0_.id AND p13_.end_date > '2025-08-26 00:00:00' AND p13_.deleted = 0 AND p13_.is_valid = 1) AS sclr_12 FROM pcode p0_ WHERE p0_.pcode_category_id = 2 AND p0_.pcode_parent_id = NULL ORDER BY sclr_2 DESC;