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
  q0_.id AS id_0,
  q0_.libelle AS libelle_1,
  q0_.genre AS genre_2,
  q0_.code AS code_3,
  q0_.modalites AS modalites_4,
  q0_.versus AS versus_5,
  q0_.alerte AS alerte_6,
  q0_.open AS open_7,
  q0_.openalert AS openalert_8,
  q0_.parent_id AS parent_id_9,
  q0_.opoption_id AS opoption_id_10
FROM
  question q0_
WHERE
  q0_.genre = ?

SELECT q0_.id AS id_0, q0_.libelle AS libelle_1, q0_.genre AS genre_2, q0_.code AS code_3, q0_.modalites AS modalites_4, q0_.versus AS versus_5, q0_.alerte AS alerte_6, q0_.open AS open_7, q0_.openalert AS openalert_8, q0_.parent_id AS parent_id_9, q0_.opoption_id AS opoption_id_10 FROM question q0_ WHERE q0_.genre = 'proposition';

select
  q.id,
  q.libelle,
  (
    select
      count(r.valeur)
    from
      resultat r
      inner join poste p on r.poste_id = p.id
      inner join lieu l on p.lieu_id = l.id
    where
      l.rgt <= :rgt
      and l.lft >= :lft
      and question_id = q.id
  ) nb
from
  question q
where
  parent_id = :parent
  and opoption_id is not null

select q.id, q.libelle,
                        (select count(r.valeur) from resultat r inner join poste p on r.poste_id = p.id inner join lieu l on p.lieu_id = l.id where l.rgt <= :rgt and l.lft >= :lft and question_id = q.id) nb
                from question q where parent_id = :parent and opoption_id is not null;

select
  q.id,
  q.libelle,
  (
    select
      count(r.valeur)
    from
      resultat r
      inner join poste p on r.poste_id = p.id
      inner join lieu l on p.lieu_id = l.id
    where
      l.rgt <= :rgt
      and l.lft >= :lft
      and question_id = q.id
  ) nb
from
  question q
where
  parent_id = :parent
  and opoption_id is not null

select q.id, q.libelle,
                        (select count(r.valeur) from resultat r inner join poste p on r.poste_id = p.id inner join lieu l on p.lieu_id = l.id where l.rgt <= :rgt and l.lft >= :lft and question_id = q.id) nb
                from question q where parent_id = :parent and opoption_id is not null;

select
  q.id,
  q.libelle,
  (
    select
      count(r.valeur)
    from
      resultat r
      inner join poste p on r.poste_id = p.id
      inner join lieu l on p.lieu_id = l.id
    where
      l.rgt <= :rgt
      and l.lft >= :lft
      and question_id = q.id
  ) nb
from
  question q
where
  parent_id = :parent
  and opoption_id is not null

select q.id, q.libelle,
                        (select count(r.valeur) from resultat r inner join poste p on r.poste_id = p.id inner join lieu l on p.lieu_id = l.id where l.rgt <= :rgt and l.lft >= :lft and question_id = q.id) nb
                from question q where parent_id = :parent and opoption_id is not null;

select
  q.id,
  q.libelle,
  (
    select
      count(r.valeur)
    from
      resultat r
      inner join poste p on r.poste_id = p.id
      inner join lieu l on p.lieu_id = l.id
    where
      l.rgt <= :rgt
      and l.lft >= :lft
      and question_id = q.id
  ) nb
from
  question q
where
  parent_id = :parent
  and opoption_id is not null

select q.id, q.libelle,
                        (select count(r.valeur) from resultat r inner join poste p on r.poste_id = p.id inner join lieu l on p.lieu_id = l.id where l.rgt <= :rgt and l.lft >= :lft and question_id = q.id) nb
                from question q where parent_id = :parent and opoption_id is not null;

select
  q.id,
  q.libelle,
  (
    select
      count(r.valeur)
    from
      resultat r
      inner join poste p on r.poste_id = p.id
      inner join lieu l on p.lieu_id = l.id
    where
      l.rgt <= :rgt
      and l.lft >= :lft
      and question_id = q.id
  ) nb
from
  question q
where
  parent_id = :parent
  and opoption_id is not null

select q.id, q.libelle,
                        (select count(r.valeur) from resultat r inner join poste p on r.poste_id = p.id inner join lieu l on p.lieu_id = l.id where l.rgt <= :rgt and l.lft >= :lft and question_id = q.id) nb
                from question q where parent_id = :parent and opoption_id is not null;

select
  q.id,
  q.libelle,
  (
    select
      count(r.valeur)
    from
      resultat r
      inner join poste p on r.poste_id = p.id
      inner join lieu l on p.lieu_id = l.id
    where
      l.rgt <= :rgt
      and l.lft >= :lft
      and question_id = q.id
  ) nb
from
  question q
where
  parent_id = :parent
  and opoption_id is not null

select q.id, q.libelle,
                        (select count(r.valeur) from resultat r inner join poste p on r.poste_id = p.id inner join lieu l on p.lieu_id = l.id where l.rgt <= :rgt and l.lft >= :lft and question_id = q.id) nb
                from question q where parent_id = :parent and opoption_id is not null;

select
  q.id,
  q.libelle,
  (
    select
      count(r.valeur)
    from
      resultat r
      inner join poste p on r.poste_id = p.id
      inner join lieu l on p.lieu_id = l.id
    where
      l.rgt <= :rgt
      and l.lft >= :lft
      and question_id = q.id
  ) nb
from
  question q
where
  parent_id = :parent
  and opoption_id is not null

select q.id, q.libelle,
                        (select count(r.valeur) from resultat r inner join poste p on r.poste_id = p.id inner join lieu l on p.lieu_id = l.id where l.rgt <= :rgt and l.lft >= :lft and question_id = q.id) nb
                from question q where parent_id = :parent and opoption_id is not null;

select
  q.id,
  q.libelle,
  (
    select
      count(r.valeur)
    from
      resultat r
      inner join poste p on r.poste_id = p.id
      inner join lieu l on p.lieu_id = l.id
    where
      l.rgt <= :rgt
      and l.lft >= :lft
      and question_id = q.id
  ) nb
from
  question q
where
  parent_id = :parent
  and opoption_id is not null

select q.id, q.libelle,
                        (select count(r.valeur) from resultat r inner join poste p on r.poste_id = p.id inner join lieu l on p.lieu_id = l.id where l.rgt <= :rgt and l.lft >= :lft and question_id = q.id) nb
                from question q where parent_id = :parent and opoption_id is not null;

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND resolution is not NULL

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164
                 AND resolution is not NULL;

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND resolution IN (
    "resolu", "résolu", "true", "resolved"
  )

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164
                 AND resolution IN ("resolu", "résolu", "true", "resolved") ;

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';