Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.lat AS lat_3,
  t0.lon AS lon_4,
  t0.lft AS lft_5,
  t0.lvl AS lvl_6,
  t0.rgt AS rgt_7,
  t0.nbe AS nbe_8,
  t0.decoupage_id AS decoupage_id_9,
  t0.superviseur_id AS superviseur_id_10,
  t0.circonscription_id AS circonscription_id_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13,
  t0.circ_id AS circ_id_14,
  t15.id AS id_16,
  t15.nom AS nom_17,
  t15.prenoms AS prenoms_18,
  t15.adresse AS adresse_19,
  t15.statut AS statut_20,
  t15.created_at AS created_at_21,
  t15.updated_at AS updated_at_22,
  t15.gestionnaire_id AS gestionnaire_id_23,
  t15.user_id AS user_id_24,
  t15.zone_id AS zone_id_25,
  t15.zon_id AS zon_id_26
FROM
  lieu t0
  LEFT JOIN agent t15 ON t15.zone_id = t0.id
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.lat AS lat_3, t0.lon AS lon_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.nbe AS nbe_8, t0.decoupage_id AS decoupage_id_9, t0.superviseur_id AS superviseur_id_10, t0.circonscription_id AS circonscription_id_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.circ_id AS circ_id_14, t15.id AS id_16, t15.nom AS nom_17, t15.prenoms AS prenoms_18, t15.adresse AS adresse_19, t15.statut AS statut_20, t15.created_at AS created_at_21, t15.updated_at AS updated_at_22, t15.gestionnaire_id AS gestionnaire_id_23, t15.user_id AS user_id_24, t15.zone_id AS zone_id_25, t15.zon_id AS zon_id_26 FROM lieu t0 LEFT JOIN agent t15 ON t15.zone_id = t0.id WHERE t0.nom = 'BENIN' LIMIT 1;

SELECT

  /*l.id, l.nom,*/
  (
    SELECT
      count(*)
    FROM
      resultat r1
      inner join question q1 on r1.question_id = q1.id
      inner join type_msg t1 ON r1.type_id = t1.id
      INNER JOIN poste p1 ON r1.poste_id = p1.id
      INNER JOIN lieu l1 ON p1.lieu_id = l1.id
    WHERE
      valeur <> 2
      AND q1.genre = :boolean
      and t1.code IS NULL
      AND l1.lft >= :lft
      AND l1.rgt <= :rgt
  ) as oui,
  (
    SELECT
      count(*)
    FROM
      resultat r1
      INNER JOIN type_msg t1 ON r1.type_id = t1.id
      INNER JOIN poste p1 ON r1.poste_id = p1.id
      INNER JOIN lieu l1 ON p1.lieu_id = l1.id
    WHERE
      valeur = 2
      AND t1.code IS NULL
      AND l1.lft >= :lft
      AND l1.rgt <= :rgt
  ) as non,
  round(
    (
      (
        SELECT
          count(*)
        FROM
          resultat r1
          inner join question q1 on r1.question_id = q1.id
          inner join type_msg t1 ON r1.type_id = t1.id
          INNER JOIN poste p1 ON r1.poste_id = p1.id
          INNER JOIN lieu l1 ON p1.lieu_id = l1.id
        WHERE
          valeur <> 2
          AND q1.genre = :boolean
          and t1.code IS NULL
          AND l1.lft >= :lft
          AND l1.rgt <= :rgt
      )
    )* 100 / (
      (
        SELECT
          count(*)
        FROM
          resultat r1
          inner join question q1 on r1.question_id = q1.id
          inner join type_msg t1 ON r1.type_id = t1.id
          INNER JOIN poste p1 ON r1.poste_id = p1.id
          INNER JOIN lieu l1 ON p1.lieu_id = l1.id
        WHERE
          valeur <> 2
          AND q1.genre = :boolean
          and t1.code IS NULL
          AND l1.lft >= :lft
          AND l1.rgt <= :rgt
      ) + (
        SELECT
          count(*)
        FROM
          resultat r1
          INNER JOIN type_msg t1 ON r1.type_id = t1.id
          INNER JOIN poste p1 ON r1.poste_id = p1.id
          INNER JOIN lieu l1 ON p1.lieu_id = l1.id
        WHERE
          valeur = 2
          AND t1.code IS NULL
          AND l1.lft >= :lft
          AND l1.rgt <= :rgt
      )
    ),
    2
  ) taux,
  (
    SELECT
      count(DISTINCT pos.id)
    FROM
      resultat r1
      INNER JOIN type_msg tp ON tp.id = r1.type_id
      INNER JOIN poste pos ON r1.poste_id = pos.id
      INNER JOIN lieu lie ON pos.lieu_id = lie.id
    WHERE
      tp.code IS NULL
      and lie.lft >= :lft
      AND lie.rgt <= :rgt
  ) as ouverts,
  (
    SELECT
      COUNT(po2.id)
    FROM
      poste po2
      INNER JOIN lieu li2 ON po2.lieu_id = li2.id
    WHERE
      li2.lft >= :lft
      AND li2.rgt <= :rgt
  ) as postes
  /*FROM lieu l /*WHERE l.lft = :lft AND l.rgt = :rgt*/
LIMIT
  1

SELECT /*l.id, l.nom,*/
                       (SELECT count(*) FROM resultat r1  inner join question q1 on r1.question_id = q1.id inner join 
                           type_msg t1 ON r1.type_id=t1.id
                              INNER JOIN poste p1 ON r1.poste_id=p1.id INNER JOIN lieu l1 ON p1.lieu_id=l1.id
                              WHERE valeur <> 2 AND q1.genre = :boolean and  t1.code IS NULL AND l1.lft >= :lft AND l1.rgt <= :rgt    ) as oui,
                       (SELECT count(*) FROM resultat r1 INNER JOIN type_msg t1 ON r1.type_id=t1.id
                              INNER JOIN poste p1 ON r1.poste_id=p1.id INNER JOIN lieu l1 ON p1.lieu_id=l1.id
                              WHERE valeur = 2 AND  t1.code IS NULL AND l1.lft >= :lft AND l1.rgt <= :rgt    ) as non,
                              
                              round(((SELECT count(*) FROM resultat r1  inner join question q1 on r1.question_id = q1.id inner join 
                           type_msg t1 ON r1.type_id=t1.id
                              INNER JOIN poste p1 ON r1.poste_id=p1.id INNER JOIN lieu l1 ON p1.lieu_id=l1.id
                              WHERE valeur <> 2 AND q1.genre = :boolean and  t1.code IS NULL AND l1.lft >= :lft AND l1.rgt <= :rgt    ))*100
                              /
                              ((SELECT count(*) FROM resultat r1  inner join question q1 on r1.question_id = q1.id inner join 
                           type_msg t1 ON r1.type_id=t1.id
                              INNER JOIN poste p1 ON r1.poste_id=p1.id INNER JOIN lieu l1 ON p1.lieu_id=l1.id
                              WHERE valeur <> 2 AND q1.genre = :boolean and  t1.code IS NULL AND l1.lft >= :lft AND l1.rgt <= :rgt    )
                              +
                              (SELECT count(*) FROM resultat r1 INNER JOIN type_msg t1 ON r1.type_id=t1.id
                              INNER JOIN poste p1 ON r1.poste_id=p1.id INNER JOIN lieu l1 ON p1.lieu_id=l1.id
                              WHERE valeur = 2 AND  t1.code IS NULL AND l1.lft >= :lft AND l1.rgt <= :rgt    )),2) taux,
                       
                              
                       (SELECT count(DISTINCT pos.id) FROM resultat r1 INNER JOIN type_msg tp ON tp.id=r1.type_id INNER JOIN poste pos ON r1.poste_id=pos.id 
                                INNER JOIN lieu lie ON pos.lieu_id=lie.id
                              WHERE tp.code IS NULL     and lie.lft >= :lft AND lie.rgt <= :rgt ) as ouverts,
                       (SELECT COUNT(po2.id) FROM poste po2 INNER  JOIN lieu li2 ON po2.lieu_id = li2.id WHERE li2.lft >= :lft AND li2.rgt <= :rgt) as postes                       
                /*FROM lieu l /*WHERE l.lft = :lft AND l.rgt = :rgt*/ LIMIT 1;

SELECT
  l0_.id AS id_0,
  l0_.nom AS nom_1,
  l0_.lat AS lat_2,
  l0_.lon AS lon_3,
  l0_.lft AS lft_4,
  l0_.lvl AS lvl_5,
  l0_.rgt AS rgt_6,
  l0_.nbe AS nbe_7,
  l0_.decoupage_id AS decoupage_id_8,
  l0_.superviseur_id AS superviseur_id_9,
  l0_.circonscription_id AS circonscription_id_10,
  l0_.tree_root AS tree_root_11,
  l0_.parent_id AS parent_id_12,
  l0_.circ_id AS circ_id_13
FROM
  lieu l0_
WHERE
  l0_.parent_id = ?
  AND l0_.tree_root = ?
ORDER BY
  l0_.nom ASC

SELECT l0_.id AS id_0, l0_.nom AS nom_1, l0_.lat AS lat_2, l0_.lon AS lon_3, l0_.lft AS lft_4, l0_.lvl AS lvl_5, l0_.rgt AS rgt_6, l0_.nbe AS nbe_7, l0_.decoupage_id AS decoupage_id_8, l0_.superviseur_id AS superviseur_id_9, l0_.circonscription_id AS circonscription_id_10, l0_.tree_root AS tree_root_11, l0_.parent_id AS parent_id_12, l0_.circ_id AS circ_id_13 FROM lieu l0_ WHERE l0_.parent_id = '1' AND l0_.tree_root = '1' ORDER BY l0_.nom ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenoms AS prenoms_3,
  t0.adresse AS adresse_4,
  t0.statut AS statut_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.gestionnaire_id AS gestionnaire_id_8,
  t0.user_id AS user_id_9,
  t10.id AS id_11,
  t10.idpv AS idpv_12,
  t10.libelle AS libelle_13,
  t10.nbi AS nbi_14,
  t10.nbh AS nbh_15,
  t10.nbf AS nbf_16,
  t10.lieu_id AS lieu_id_17,
  t10.observateur_id AS observateur_id_18,
  t0.zone_id AS zone_id_19,
  t0.zon_id AS zon_id_20
FROM
  agent t0
  LEFT JOIN poste t10 ON t10.observateur_id = t0.id
WHERE
  t0.zone_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '101';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenoms AS prenoms_3,
  t0.adresse AS adresse_4,
  t0.statut AS statut_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.gestionnaire_id AS gestionnaire_id_8,
  t0.user_id AS user_id_9,
  t10.id AS id_11,
  t10.idpv AS idpv_12,
  t10.libelle AS libelle_13,
  t10.nbi AS nbi_14,
  t10.nbh AS nbh_15,
  t10.nbf AS nbf_16,
  t10.lieu_id AS lieu_id_17,
  t10.observateur_id AS observateur_id_18,
  t0.zone_id AS zone_id_19,
  t0.zon_id AS zon_id_20
FROM
  agent t0
  LEFT JOIN poste t10 ON t10.observateur_id = t0.id
WHERE
  t0.zone_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '102';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenoms AS prenoms_3,
  t0.adresse AS adresse_4,
  t0.statut AS statut_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.gestionnaire_id AS gestionnaire_id_8,
  t0.user_id AS user_id_9,
  t10.id AS id_11,
  t10.idpv AS idpv_12,
  t10.libelle AS libelle_13,
  t10.nbi AS nbi_14,
  t10.nbh AS nbh_15,
  t10.nbf AS nbf_16,
  t10.lieu_id AS lieu_id_17,
  t10.observateur_id AS observateur_id_18,
  t0.zone_id AS zone_id_19,
  t0.zon_id AS zon_id_20
FROM
  agent t0
  LEFT JOIN poste t10 ON t10.observateur_id = t0.id
WHERE
  t0.zone_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '103';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenoms AS prenoms_3,
  t0.adresse AS adresse_4,
  t0.statut AS statut_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.gestionnaire_id AS gestionnaire_id_8,
  t0.user_id AS user_id_9,
  t10.id AS id_11,
  t10.idpv AS idpv_12,
  t10.libelle AS libelle_13,
  t10.nbi AS nbi_14,
  t10.nbh AS nbh_15,
  t10.nbf AS nbf_16,
  t10.lieu_id AS lieu_id_17,
  t10.observateur_id AS observateur_id_18,
  t0.zone_id AS zone_id_19,
  t0.zon_id AS zon_id_20
FROM
  agent t0
  LEFT JOIN poste t10 ON t10.observateur_id = t0.id
WHERE
  t0.zone_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '104';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenoms AS prenoms_3,
  t0.adresse AS adresse_4,
  t0.statut AS statut_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.gestionnaire_id AS gestionnaire_id_8,
  t0.user_id AS user_id_9,
  t10.id AS id_11,
  t10.idpv AS idpv_12,
  t10.libelle AS libelle_13,
  t10.nbi AS nbi_14,
  t10.nbh AS nbh_15,
  t10.nbf AS nbf_16,
  t10.lieu_id AS lieu_id_17,
  t10.observateur_id AS observateur_id_18,
  t0.zone_id AS zone_id_19,
  t0.zon_id AS zon_id_20
FROM
  agent t0
  LEFT JOIN poste t10 ON t10.observateur_id = t0.id
WHERE
  t0.zone_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '105';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenoms AS prenoms_3,
  t0.adresse AS adresse_4,
  t0.statut AS statut_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.gestionnaire_id AS gestionnaire_id_8,
  t0.user_id AS user_id_9,
  t10.id AS id_11,
  t10.idpv AS idpv_12,
  t10.libelle AS libelle_13,
  t10.nbi AS nbi_14,
  t10.nbh AS nbh_15,
  t10.nbf AS nbf_16,
  t10.lieu_id AS lieu_id_17,
  t10.observateur_id AS observateur_id_18,
  t0.zone_id AS zone_id_19,
  t0.zon_id AS zon_id_20
FROM
  agent t0
  LEFT JOIN poste t10 ON t10.observateur_id = t0.id
WHERE
  t0.zone_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '106';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenoms AS prenoms_3,
  t0.adresse AS adresse_4,
  t0.statut AS statut_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.gestionnaire_id AS gestionnaire_id_8,
  t0.user_id AS user_id_9,
  t10.id AS id_11,
  t10.idpv AS idpv_12,
  t10.libelle AS libelle_13,
  t10.nbi AS nbi_14,
  t10.nbh AS nbh_15,
  t10.nbf AS nbf_16,
  t10.lieu_id AS lieu_id_17,
  t10.observateur_id AS observateur_id_18,
  t0.zone_id AS zone_id_19,
  t0.zon_id AS zon_id_20
FROM
  agent t0
  LEFT JOIN poste t10 ON t10.observateur_id = t0.id
WHERE
  t0.zone_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '107';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenoms AS prenoms_3,
  t0.adresse AS adresse_4,
  t0.statut AS statut_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.gestionnaire_id AS gestionnaire_id_8,
  t0.user_id AS user_id_9,
  t10.id AS id_11,
  t10.idpv AS idpv_12,
  t10.libelle AS libelle_13,
  t10.nbi AS nbi_14,
  t10.nbh AS nbh_15,
  t10.nbf AS nbf_16,
  t10.lieu_id AS lieu_id_17,
  t10.observateur_id AS observateur_id_18,
  t0.zone_id AS zone_id_19,
  t0.zon_id AS zon_id_20
FROM
  agent t0
  LEFT JOIN poste t10 ON t10.observateur_id = t0.id
WHERE
  t0.zone_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '108';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenoms AS prenoms_3,
  t0.adresse AS adresse_4,
  t0.statut AS statut_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.gestionnaire_id AS gestionnaire_id_8,
  t0.user_id AS user_id_9,
  t10.id AS id_11,
  t10.idpv AS idpv_12,
  t10.libelle AS libelle_13,
  t10.nbi AS nbi_14,
  t10.nbh AS nbh_15,
  t10.nbf AS nbf_16,
  t10.lieu_id AS lieu_id_17,
  t10.observateur_id AS observateur_id_18,
  t0.zone_id AS zone_id_19,
  t0.zon_id AS zon_id_20
FROM
  agent t0
  LEFT JOIN poste t10 ON t10.observateur_id = t0.id
WHERE
  t0.zone_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '109';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenoms AS prenoms_3,
  t0.adresse AS adresse_4,
  t0.statut AS statut_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.gestionnaire_id AS gestionnaire_id_8,
  t0.user_id AS user_id_9,
  t10.id AS id_11,
  t10.idpv AS idpv_12,
  t10.libelle AS libelle_13,
  t10.nbi AS nbi_14,
  t10.nbh AS nbh_15,
  t10.nbf AS nbf_16,
  t10.lieu_id AS lieu_id_17,
  t10.observateur_id AS observateur_id_18,
  t0.zone_id AS zone_id_19,
  t0.zon_id AS zon_id_20
FROM
  agent t0
  LEFT JOIN poste t10 ON t10.observateur_id = t0.id
WHERE
  t0.zone_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '110';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenoms AS prenoms_3,
  t0.adresse AS adresse_4,
  t0.statut AS statut_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.gestionnaire_id AS gestionnaire_id_8,
  t0.user_id AS user_id_9,
  t10.id AS id_11,
  t10.idpv AS idpv_12,
  t10.libelle AS libelle_13,
  t10.nbi AS nbi_14,
  t10.nbh AS nbh_15,
  t10.nbf AS nbf_16,
  t10.lieu_id AS lieu_id_17,
  t10.observateur_id AS observateur_id_18,
  t0.zone_id AS zone_id_19,
  t0.zon_id AS zon_id_20
FROM
  agent t0
  LEFT JOIN poste t10 ON t10.observateur_id = t0.id
WHERE
  t0.zone_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '111';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenoms AS prenoms_3,
  t0.adresse AS adresse_4,
  t0.statut AS statut_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.gestionnaire_id AS gestionnaire_id_8,
  t0.user_id AS user_id_9,
  t10.id AS id_11,
  t10.idpv AS idpv_12,
  t10.libelle AS libelle_13,
  t10.nbi AS nbi_14,
  t10.nbh AS nbh_15,
  t10.nbf AS nbf_16,
  t10.lieu_id AS lieu_id_17,
  t10.observateur_id AS observateur_id_18,
  t0.zone_id AS zone_id_19,
  t0.zon_id AS zon_id_20
FROM
  agent t0
  LEFT JOIN poste t10 ON t10.observateur_id = t0.id
WHERE
  t0.zone_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '112';