Symfony Profiler

Query Metrics

43 Database Queries

11 Different statements

6888.70 ms Query time

0 Invalid entities

26 Managed entities

Queries


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.num1 AS num1_9, t0.num2 AS num2_10, t0.decoupage_id AS decoupage_id_11, t0.superviseur_id AS superviseur_id_12, t0.circonscription_id AS circonscription_id_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15, t0.circ_id AS circ_id_16, t17.id AS id_18, t17.nom AS nom_19, t17.prenoms AS prenoms_20, t17.adresse AS adresse_21, t17.statut AS statut_22, t17.created_at AS created_at_23, t17.updated_at AS updated_at_24, t17.arid AS arid_25, t17.commune AS commune_26, t17.gestionnaire_id AS gestionnaire_id_27, t17.user_id AS user_id_28, t17.zone_id AS zone_id_29, t17.zon_id AS zon_id_30, t17.parent_id AS parent_id_31 FROM lieu t0 LEFT JOIN agent t17 ON t17.zone_id = t0.id WHERE t0.nom = ? 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_.format AS format_9, q0_.libelle_oui AS libelle_oui_10, q0_.libelle_non AS libelle_non_11, q0_.unik AS unik_12, q0_.parent_id AS parent_id_13, q0_.opoption_id AS opoption_id_14 FROM question q0_ WHERE q0_.genre = ?
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 >= :lft AND l.rgt <= :rgt
                 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_.num1 AS num1_8, l0_.num2 AS num2_9, l0_.decoupage_id AS decoupage_id_10, l0_.superviseur_id AS superviseur_id_11, l0_.circonscription_id AS circonscription_id_12, l0_.tree_root AS tree_root_13, l0_.parent_id AS parent_id_14, l0_.circ_id AS circ_id_15 FROM lieu l0_ WHERE l0_.parent_id = ? AND l0_.tree_root = ? 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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.observateur_id = t0.id WHERE t0.zone_id = ?
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 >= :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 >= :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 >= :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 >= :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 >= :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 >= :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 >= :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 >= :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 >= :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 >= :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 >= :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 >= :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 >= :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 >= :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 >= :lft AND l.rgt <= :rgt
                 AND resolution IN ("resolu", "résolu", "true", "resolved")
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
                              ) AS 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
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
                              ) AS 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
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
                              ) AS 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
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
                              ) AS 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
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
                              ) AS 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
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
                              ) AS 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
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
                              ) AS 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
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
                              ) AS 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
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
                              ) AS 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
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.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

#▲	Time	Info
1	4.12 ms	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.num1 AS num1_9, t0.num2 AS num2_10, t0.decoupage_id AS decoupage_id_11, t0.superviseur_id AS superviseur_id_12, t0.circonscription_id AS circonscription_id_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15, t0.circ_id AS circ_id_16, t17.id AS id_18, t17.nom AS nom_19, t17.prenoms AS prenoms_20, t17.adresse AS adresse_21, t17.statut AS statut_22, t17.created_at AS created_at_23, t17.updated_at AS updated_at_24, t17.arid AS arid_25, t17.commune AS commune_26, t17.gestionnaire_id AS gestionnaire_id_27, t17.user_id AS user_id_28, t17.zone_id AS zone_id_29, t17.zon_id AS zon_id_30, t17.parent_id AS parent_id_31 FROM lieu t0 LEFT JOIN agent t17 ON t17.zone_id = t0.id WHERE t0.nom = ? LIMIT 1 Parameters: [`"GUINEE"`] View formatted query View runnable query Explain query 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.num1 AS num1_9, t0.num2 AS num2_10, t0.decoupage_id AS decoupage_id_11, t0.superviseur_id AS superviseur_id_12, t0.circonscription_id AS circonscription_id_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15, t0.circ_id AS circ_id_16, t17.id AS id_18, t17.nom AS nom_19, t17.prenoms AS prenoms_20, t17.adresse AS adresse_21, t17.statut AS statut_22, t17.created_at AS created_at_23, t17.updated_at AS updated_at_24, t17.arid AS arid_25, t17.commune AS commune_26, t17.gestionnaire_id AS gestionnaire_id_27, t17.user_id AS user_id_28, t17.zone_id AS zone_id_29, t17.zon_id AS zon_id_30, t17.parent_id AS parent_id_31 FROM lieu t0 LEFT JOIN agent t17 ON t17.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.num1 AS num1_9, t0.num2 AS num2_10, t0.decoupage_id AS decoupage_id_11, t0.superviseur_id AS superviseur_id_12, t0.circonscription_id AS circonscription_id_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15, t0.circ_id AS circ_id_16, t17.id AS id_18, t17.nom AS nom_19, t17.prenoms AS prenoms_20, t17.adresse AS adresse_21, t17.statut AS statut_22, t17.created_at AS created_at_23, t17.updated_at AS updated_at_24, t17.arid AS arid_25, t17.commune AS commune_26, t17.gestionnaire_id AS gestionnaire_id_27, t17.user_id AS user_id_28, t17.zone_id AS zone_id_29, t17.zon_id AS zon_id_30, t17.parent_id AS parent_id_31 FROM lieu t0 LEFT JOIN agent t17 ON t17.zone_id = t0.id WHERE t0.nom = 'GUINEE' LIMIT 1;
2	14.44 ms	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_.format AS format_9, q0_.libelle_oui AS libelle_oui_10, q0_.libelle_non AS libelle_non_11, q0_.unik AS unik_12, q0_.parent_id AS parent_id_13, q0_.opoption_id AS opoption_id_14 FROM question q0_ WHERE q0_.genre = ? Parameters: [`"proposition"`] View formatted query View runnable query Explain query 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_.format AS format_9, q0_.libelle_oui AS libelle_oui_10, q0_.libelle_non AS libelle_non_11, q0_.unik AS unik_12, q0_.parent_id AS parent_id_13, q0_.opoption_id AS opoption_id_14 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_.format AS format_9, q0_.libelle_oui AS libelle_oui_10, q0_.libelle_non AS libelle_non_11, q0_.unik AS unik_12, q0_.parent_id AS parent_id_13, q0_.opoption_id AS opoption_id_14 FROM question q0_ WHERE q0_.genre = 'proposition';
3	49.31 ms	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 Parameters: [`":lft" => 1 ":rgt" => 16502 ":parent" => 9`] View formatted query View runnable query Explain query 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;
4	79.96 ms	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 Parameters: [`":lft" => 1 ":rgt" => 16502 ":parent" => 16`] View formatted query View runnable query Explain query 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;
5	3.64 ms	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 Parameters: [`":lft" => 1 ":rgt" => 16502 ":parent" => 44`] View formatted query View runnable query Explain query 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;
6	42.52 ms	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 Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 16502`] View formatted query View runnable query Explain query 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 <= 16502 AND resolution is not NULL;
7	13.18 ms	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") Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 16502`] View formatted query View runnable query Explain query 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 <= 16502 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
8	2.02 ms	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_.num1 AS num1_8, l0_.num2 AS num2_9, l0_.decoupage_id AS decoupage_id_10, l0_.superviseur_id AS superviseur_id_11, l0_.circonscription_id AS circonscription_id_12, l0_.tree_root AS tree_root_13, l0_.parent_id AS parent_id_14, l0_.circ_id AS circ_id_15 FROM lieu l0_ WHERE l0_.parent_id = ? AND l0_.tree_root = ? ORDER BY l0_.nom ASC Parameters: [`"1" "1"`] View formatted query View runnable query Explain query 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_.num1 AS num1_8, l0_.num2 AS num2_9, l0_.decoupage_id AS decoupage_id_10, l0_.superviseur_id AS superviseur_id_11, l0_.circonscription_id AS circonscription_id_12, l0_.tree_root AS tree_root_13, l0_.parent_id AS parent_id_14, l0_.circ_id AS circ_id_15 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_.num1 AS num1_8, l0_.num2 AS num2_9, l0_.decoupage_id AS decoupage_id_10, l0_.superviseur_id AS superviseur_id_11, l0_.circonscription_id AS circonscription_id_12, l0_.tree_root AS tree_root_13, l0_.parent_id AS parent_id_14, l0_.circ_id AS circ_id_15 FROM lieu l0_ WHERE l0_.parent_id = '1' AND l0_.tree_root = '1' ORDER BY l0_.nom ASC;
9	0.68 ms	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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"2"`] View formatted query View runnable query Explain query 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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.observateur_id = t0.id WHERE t0.zone_id = '2';
10	0.35 ms	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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"3"`] View formatted query View runnable query Explain query 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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.observateur_id = t0.id WHERE t0.zone_id = '3';
11	0.39 ms	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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"4"`] View formatted query View runnable query Explain query 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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.observateur_id = t0.id WHERE t0.zone_id = '4';
12	0.33 ms	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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"5"`] View formatted query View runnable query Explain query 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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.observateur_id = t0.id WHERE t0.zone_id = '5';
13	0.39 ms	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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"6"`] View formatted query View runnable query Explain query 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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.observateur_id = t0.id WHERE t0.zone_id = '6';
14	1.12 ms	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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"7"`] View formatted query View runnable query Explain query 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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.observateur_id = t0.id WHERE t0.zone_id = '7';
15	0.34 ms	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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"8"`] View formatted query View runnable query Explain query 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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.observateur_id = t0.id WHERE t0.zone_id = '8';
16	0.38 ms	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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"9"`] View formatted query View runnable query Explain query 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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.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.arid AS arid_8, t0.commune AS commune_9, t0.gestionnaire_id AS gestionnaire_id_10, t0.user_id AS user_id_11, t12.id AS id_13, t12.idpv AS idpv_14, t12.libelle AS libelle_15, t12.nbi AS nbi_16, t12.nbh AS nbh_17, t12.nbf AS nbf_18, t12.nbi_cena AS nbi_cena_19, t12.lieu_id AS lieu_id_20, t12.observateur_id AS observateur_id_21, t0.zone_id AS zone_id_22, t0.zon_id AS zon_id_23, t0.parent_id AS parent_id_24 FROM agent t0 LEFT JOIN poste t12 ON t12.observateur_id = t0.id WHERE t0.zone_id = '9';
17	12.11 ms	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é") Parameters: [`"alt" => "alt%" "lft" => 2 "rgt" => 1255`] View formatted query View runnable query Explain query 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 <= 1255 AND resolution IN ("remonte", "remonté") ;
18	10.59 ms	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") Parameters: [`"alt" => "alt%" "lft" => 2 "rgt" => 1255`] View formatted query View runnable query Explain query 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 >= 2 AND l.rgt <= 1255 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
19	11.24 ms	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é") Parameters: [`"alt" => "alt%" "lft" => 1256 "rgt" => 1731`] View formatted query View runnable query Explain query 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 >= 1256 AND l.rgt <= 1731 AND resolution IN ("remonte", "remonté") ;
20	11.25 ms	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") Parameters: [`"alt" => "alt%" "lft" => 1256 "rgt" => 1731`] View formatted query View runnable query Explain query 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 >= 1256 AND l.rgt <= 1731 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
21	10.85 ms	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é") Parameters: [`"alt" => "alt%" "lft" => 1732 "rgt" => 3339`] View formatted query View runnable query Explain query 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 >= 1732 AND l.rgt <= 3339 AND resolution IN ("remonte", "remonté") ;
22	10.97 ms	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") Parameters: [`"alt" => "alt%" "lft" => 1732 "rgt" => 3339`] View formatted query View runnable query Explain query 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 >= 1732 AND l.rgt <= 3339 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
23	11.74 ms	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é") Parameters: [`"alt" => "alt%" "lft" => 3340 "rgt" => 6383`] View formatted query View runnable query Explain query 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 >= 3340 AND l.rgt <= 6383 AND resolution IN ("remonte", "remonté") ;
24	11.70 ms	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") Parameters: [`"alt" => "alt%" "lft" => 3340 "rgt" => 6383`] View formatted query View runnable query Explain query 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 >= 3340 AND l.rgt <= 6383 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
25	12.49 ms	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é") Parameters: [`"alt" => "alt%" "lft" => 6384 "rgt" => 7941`] View formatted query View runnable query Explain query 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 >= 6384 AND l.rgt <= 7941 AND resolution IN ("remonte", "remonté") ;
26	11.63 ms	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") Parameters: [`"alt" => "alt%" "lft" => 6384 "rgt" => 7941`] View formatted query View runnable query Explain query 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 >= 6384 AND l.rgt <= 7941 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
27	14.20 ms	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é") Parameters: [`"alt" => "alt%" "lft" => 7942 "rgt" => 10453`] View formatted query View runnable query Explain query 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 >= 7942 AND l.rgt <= 10453 AND resolution IN ("remonte", "remonté") ;
28	12.20 ms	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") Parameters: [`"alt" => "alt%" "lft" => 7942 "rgt" => 10453`] View formatted query View runnable query Explain query 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 >= 7942 AND l.rgt <= 10453 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
29	15.22 ms	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é") Parameters: [`"alt" => "alt%" "lft" => 10454 "rgt" => 12585`] View formatted query View runnable query Explain query 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 >= 10454 AND l.rgt <= 12585 AND resolution IN ("remonte", "remonté") ;
30	14.09 ms	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") Parameters: [`"alt" => "alt%" "lft" => 10454 "rgt" => 12585`] View formatted query View runnable query Explain query 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 >= 10454 AND l.rgt <= 12585 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
31	12.60 ms	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é") Parameters: [`"alt" => "alt%" "lft" => 12586 "rgt" => 16501`] View formatted query View runnable query Explain query 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 >= 12586 AND l.rgt <= 16501 AND resolution IN ("remonte", "remonté") ;
32	13.68 ms	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") Parameters: [`"alt" => "alt%" "lft" => 12586 "rgt" => 16501`] View formatted query View runnable query Explain query 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 >= 12586 AND l.rgt <= 16501 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
33	2996.74 ms	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 ) AS 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 Parameters: [`":lft" => 1 ":rgt" => 16502 ":boolean" => "boolean"`] View formatted query View runnable query Explain query 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 ) AS 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 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 ) AS 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;
34	257.41 ms	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 ) AS 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 Parameters: [`":lft" => 2 ":rgt" => 1255 ":boolean" => "boolean"`] View formatted query View runnable query Explain query 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 ) AS 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 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 ) AS 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;
35	156.99 ms	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 ) AS 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 Parameters: [`":lft" => 1256 ":rgt" => 1731 ":boolean" => "boolean"`] View formatted query View runnable query Explain query 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 ) AS 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 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 ) AS 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;
36	315.59 ms	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 ) AS 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 Parameters: [`":lft" => 1732 ":rgt" => 3339 ":boolean" => "boolean"`] View formatted query View runnable query Explain query 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 ) AS 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 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 ) AS 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;
37	680.57 ms	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 ) AS 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 Parameters: [`":lft" => 3340 ":rgt" => 6383 ":boolean" => "boolean"`] View formatted query View runnable query Explain query 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 ) AS 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 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 ) AS 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;
38	322.57 ms	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 ) AS 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 Parameters: [`":lft" => 6384 ":rgt" => 7941 ":boolean" => "boolean"`] View formatted query View runnable query Explain query 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 ) AS 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 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 ) AS 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;
39	614.13 ms	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 ) AS 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 Parameters: [`":lft" => 7942 ":rgt" => 10453 ":boolean" => "boolean"`] View formatted query View runnable query Explain query 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 ) AS 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 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 ) AS 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;
40	491.13 ms	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 ) AS 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 Parameters: [`":lft" => 10454 ":rgt" => 12585 ":boolean" => "boolean"`] View formatted query View runnable query Explain query 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 ) AS 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 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 ) AS 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;
41	617.30 ms	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 ) AS 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 Parameters: [`":lft" => 12586 ":rgt" => 16501 ":boolean" => "boolean"`] View formatted query View runnable query Explain query 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 ) AS 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 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 ) AS 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;
42	24.71 ms	SELECT t0.id AS id_1, t0.niveau AS niveau_2, t0.appelation AS appelation_3 FROM decoupage t0 Parameters: [] View formatted query View runnable query Explain query 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;
43	1.84 ms	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 Parameters: [] View formatted query View runnable query Explain query 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;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Lieu	9
App\Entity\Decoupage	6
App\Entity\Question	6
App\Entity\TypeMsg	5

Entities Mapping

Class	Mapping errors
App\Entity\Lieu	No errors.
App\Entity\Decoupage	No errors.
App\Entity\Agent	No errors.
App\Entity\Circonscription	No errors.
App\Entity\User	No errors.
App\Entity\Poste	No errors.
App\Entity\ResultatsZone	No errors.
App\Entity\Question	No errors.
App\Entity\Proposition	No errors.
App\Entity\TypeMsg	No errors.
App\Entity\Resultat	No errors.
App\Entity\Sms	No errors.

Symfony Profiler

GET https://xensyli.trouvelebon.com/dashboard

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping