Symfony Profiler

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
  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
  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
  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 ("remonte", "remonté")

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 >= 2 AND l.rgt <= 543
                 AND resolution IN ("remonte", "remonté") ;

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
  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.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
  t0.id AS id_1,
  t0.niveau AS niveau_2,
  t0.appelation AS appelation_3
FROM
  decoupage t0

SELECT t0.id AS id_1, t0.niveau AS niveau_2, t0.appelation AS appelation_3 FROM decoupage t0;

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
  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
  t0.id AS id_1,
  t0.code AS code_2,
  t0.genre AS genre_3,
  t0.controller AS controller_4,
  t0.violent AS violent_5,
  t0.ordre AS ordre_6,
  t0.actif AS actif_7
FROM
  type_msg t0
WHERE
  t0.code IS NULL

SELECT t0.id AS id_1, t0.code AS code_2, t0.genre AS genre_3, t0.controller AS controller_4, t0.violent AS violent_5, t0.ordre AS ordre_6, t0.actif AS actif_7 FROM type_msg t0 WHERE t0.code IS NULL;