Symfony Profiler

Query Metrics

60 Database Queries

26 Different statements

52.24 ms Query time

0 Invalid entities

20 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.decoupage_id AS decoupage_id_9, t0.superviseur_id AS superviseur_id_10, t0.circonscription_id AS circonscription_id_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.circ_id AS circ_id_14, t15.id AS id_16, t15.nom AS nom_17, t15.prenoms AS prenoms_18, t15.adresse AS adresse_19, t15.statut AS statut_20, t15.created_at AS created_at_21, t15.updated_at AS updated_at_22, t15.gestionnaire_id AS gestionnaire_id_23, t15.user_id AS user_id_24, t15.zone_id AS zone_id_25, t15.zon_id AS zon_id_26 FROM lieu t0 LEFT JOIN agent t15 ON t15.zone_id = t0.id WHERE t0.nom = ? LIMIT 1
SELECT 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_.decoupage_id AS decoupage_id_8, l0_.superviseur_id AS superviseur_id_9, l0_.circonscription_id AS circonscription_id_10, l0_.tree_root AS tree_root_11, l0_.parent_id AS parent_id_12, l0_.circ_id AS circ_id_13 FROM lieu l0_ WHERE l0_.parent_id = ? AND l0_.tree_root = ? ORDER BY l0_.nom ASC
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ?
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 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 HOUR(s.heure) = 6 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 HOUR(s.heure) = 7 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 HOUR(s.heure) = 8 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 HOUR(s.heure) = 9 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 HOUR(s.heure) = 10 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 HOUR(s.heure) = 11 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 HOUR(s.heure) = 12 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 HOUR(s.heure) = 13 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 HOUR(s.heure) = 14 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 HOUR(s.heure) = 15 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 HOUR(s.heure) = 16 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 HOUR(s.heure) = 17 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 HOUR(s.heure) = 18 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 HOUR(s.heure) = 19 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 HOUR(s.heure) = 20 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 HOUR(s.heure) = 21 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 HOUR(s.heure) = 22 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 HOUR(s.heure) = 23 AND resolution is not NULL
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.nom AS nom_2, t0.lat AS lat_3, t0.lon AS lon_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.nbe AS nbe_8, t0.decoupage_id AS decoupage_id_9, t0.superviseur_id AS superviseur_id_10, t0.circonscription_id AS circonscription_id_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.circ_id AS circ_id_14, t15.id AS id_16, t15.nom AS nom_17, t15.prenoms AS prenoms_18, t15.adresse AS adresse_19, t15.statut AS statut_20, t15.created_at AS created_at_21, t15.updated_at AS updated_at_22, t15.gestionnaire_id AS gestionnaire_id_23, t15.user_id AS user_id_24, t15.zone_id AS zone_id_25, t15.zon_id AS zon_id_26 FROM lieu t0 LEFT JOIN agent t15 ON t15.zone_id = t0.id WHERE t0.decoupage_id = ?

#▲	Time	Info
1	1.04 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.decoupage_id AS decoupage_id_9, t0.superviseur_id AS superviseur_id_10, t0.circonscription_id AS circonscription_id_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.circ_id AS circ_id_14, t15.id AS id_16, t15.nom AS nom_17, t15.prenoms AS prenoms_18, t15.adresse AS adresse_19, t15.statut AS statut_20, t15.created_at AS created_at_21, t15.updated_at AS updated_at_22, t15.gestionnaire_id AS gestionnaire_id_23, t15.user_id AS user_id_24, t15.zone_id AS zone_id_25, t15.zon_id AS zon_id_26 FROM lieu t0 LEFT JOIN agent t15 ON t15.zone_id = t0.id WHERE t0.nom = ? LIMIT 1 Parameters: [`"BENIN"`] 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.decoupage_id AS decoupage_id_9, t0.superviseur_id AS superviseur_id_10, t0.circonscription_id AS circonscription_id_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.circ_id AS circ_id_14, t15.id AS id_16, t15.nom AS nom_17, t15.prenoms AS prenoms_18, t15.adresse AS adresse_19, t15.statut AS statut_20, t15.created_at AS created_at_21, t15.updated_at AS updated_at_22, t15.gestionnaire_id AS gestionnaire_id_23, t15.user_id AS user_id_24, t15.zone_id AS zone_id_25, t15.zon_id AS zon_id_26 FROM lieu t0 LEFT JOIN agent t15 ON t15.zone_id = t0.id WHERE t0.nom = ? LIMIT 1 SELECT t0.id AS id_1, t0.nom AS nom_2, t0.lat AS lat_3, t0.lon AS lon_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.nbe AS nbe_8, t0.decoupage_id AS decoupage_id_9, t0.superviseur_id AS superviseur_id_10, t0.circonscription_id AS circonscription_id_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.circ_id AS circ_id_14, t15.id AS id_16, t15.nom AS nom_17, t15.prenoms AS prenoms_18, t15.adresse AS adresse_19, t15.statut AS statut_20, t15.created_at AS created_at_21, t15.updated_at AS updated_at_22, t15.gestionnaire_id AS gestionnaire_id_23, t15.user_id AS user_id_24, t15.zone_id AS zone_id_25, t15.zon_id AS zon_id_26 FROM lieu t0 LEFT JOIN agent t15 ON t15.zone_id = t0.id WHERE t0.nom = 'BENIN' LIMIT 1;
2	0.83 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" => 7164`] 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 <= 7164 AND resolution is not NULL;
3	0.55 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" => 7164`] 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 <= 7164 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
4	0.89 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_.decoupage_id AS decoupage_id_8, l0_.superviseur_id AS superviseur_id_9, l0_.circonscription_id AS circonscription_id_10, l0_.tree_root AS tree_root_11, l0_.parent_id AS parent_id_12, l0_.circ_id AS circ_id_13 FROM lieu l0_ WHERE l0_.parent_id = ? AND l0_.tree_root = ? ORDER BY l0_.nom ASC 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_.decoupage_id AS decoupage_id_8, l0_.superviseur_id AS superviseur_id_9, l0_.circonscription_id AS circonscription_id_10, l0_.tree_root AS tree_root_11, l0_.parent_id AS parent_id_12, l0_.circ_id AS circ_id_13 FROM lieu l0_ WHERE l0_.parent_id = ? AND l0_.tree_root = ? ORDER BY l0_.nom ASC SELECT l0_.id AS id_0, l0_.nom AS nom_1, l0_.lat AS lat_2, l0_.lon AS lon_3, l0_.lft AS lft_4, l0_.lvl AS lvl_5, l0_.rgt AS rgt_6, l0_.nbe AS nbe_7, l0_.decoupage_id AS decoupage_id_8, l0_.superviseur_id AS superviseur_id_9, l0_.circonscription_id AS circonscription_id_10, l0_.tree_root AS tree_root_11, l0_.parent_id AS parent_id_12, l0_.circ_id AS circ_id_13 FROM lieu l0_ WHERE l0_.parent_id = '1' AND l0_.tree_root = '1' ORDER BY l0_.nom ASC;
5	0.41 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"101"`] 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '101';
6	0.43 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"102"`] 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '102';
7	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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"103"`] 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '103';
8	0.59 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"104"`] 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '104';
9	0.41 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"105"`] 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '105';
10	0.36 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"106"`] 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '106';
11	0.46 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"107"`] 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '107';
12	0.46 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"108"`] 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '108';
13	0.53 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"109"`] 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '109';
14	0.51 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"110"`] 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '110';
15	0.46 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"111"`] 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '111';
16	0.58 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? Parameters: [`"112"`] 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.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '112';
17	1.31 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" => 543`] 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 <= 543 AND resolution IN ("remonte", "remonté") ;
18	1.44 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" => 543`] 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 <= 543 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
19	1.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 ("remonte", "remonté") Parameters: [`"alt" => "alt%" "lft" => 544 "rgt" => 1153`] 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 >= 544 AND l.rgt <= 1153 AND resolution IN ("remonte", "remonté") ;
20	0.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" => 544 "rgt" => 1153`] 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 >= 544 AND l.rgt <= 1153 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
21	0.69 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" => 1154 "rgt" => 2135`] 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 >= 1154 AND l.rgt <= 2135 AND resolution IN ("remonte", "remonté") ;
22	0.77 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" => 1154 "rgt" => 2135`] 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 >= 1154 AND l.rgt <= 2135 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
23	0.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 ("remonte", "remonté") Parameters: [`"alt" => "alt%" "lft" => 2136 "rgt" => 2737`] 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 >= 2136 AND l.rgt <= 2737 AND resolution IN ("remonte", "remonté") ;
24	0.61 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" => 2136 "rgt" => 2737`] 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 >= 2136 AND l.rgt <= 2737 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
25	0.61 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" => 2738 "rgt" => 3469`] 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 >= 2738 AND l.rgt <= 3469 AND resolution IN ("remonte", "remonté") ;
26	0.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" => 2738 "rgt" => 3469`] 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 >= 2738 AND l.rgt <= 3469 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
27	0.56 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" => 3470 "rgt" => 4095`] 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 >= 3470 AND l.rgt <= 4095 AND resolution IN ("remonte", "remonté") ;
28	0.57 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" => 3470 "rgt" => 4095`] 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 >= 3470 AND l.rgt <= 4095 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
29	0.78 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" => 4096 "rgt" => 4455`] 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 >= 4096 AND l.rgt <= 4455 AND resolution IN ("remonte", "remonté") ;
30	0.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" => 4096 "rgt" => 4455`] 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 >= 4096 AND l.rgt <= 4455 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
31	0.57 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" => 4456 "rgt" => 4675`] 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 >= 4456 AND l.rgt <= 4675 AND resolution IN ("remonte", "remonté") ;
32	0.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" => 4456 "rgt" => 4675`] 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 >= 4456 AND l.rgt <= 4675 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
33	0.66 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" => 4676 "rgt" => 5119`] 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 >= 4676 AND l.rgt <= 5119 AND resolution IN ("remonte", "remonté") ;
34	0.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" => 4676 "rgt" => 5119`] 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 >= 4676 AND l.rgt <= 5119 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
35	0.91 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" => 5120 "rgt" => 5823`] 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 >= 5120 AND l.rgt <= 5823 AND resolution IN ("remonte", "remonté") ;
36	0.67 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" => 5120 "rgt" => 5823`] 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 >= 5120 AND l.rgt <= 5823 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
37	0.67 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" => 5824 "rgt" => 6219`] 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 >= 5824 AND l.rgt <= 6219 AND resolution IN ("remonte", "remonté") ;
38	0.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 ("resolu", "résolu", "true", "resolved") Parameters: [`"alt" => "alt%" "lft" => 5824 "rgt" => 6219`] 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 >= 5824 AND l.rgt <= 6219 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
39	0.64 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" => 6220 "rgt" => 7163`] 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 >= 6220 AND l.rgt <= 7163 AND resolution IN ("remonte", "remonté") ;
40	0.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 IN ("resolu", "résolu", "true", "resolved") Parameters: [`"alt" => "alt%" "lft" => 6220 "rgt" => 7163`] 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 >= 6220 AND l.rgt <= 7163 AND resolution IN ("resolu", "résolu", "true", "resolved") ;
41	1.76 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 HOUR(s.heure) = 6 AND resolution is not NULL Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 7164`] 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 HOUR(s.heure) = 6 AND resolution is not NULL SELECT COUNT(*) as incidents FROM type_msg t INNER JOIN sms s ON s.type_msg_id = t.id INNER JOIN numero n ON s.sender_num_id = n.id INNER JOIN agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164 AND HOUR(s.heure) = 6 AND resolution is not NULL;
42	0.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 HOUR(s.heure) = 7 AND resolution is not NULL Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 7164`] 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 HOUR(s.heure) = 7 AND resolution is not NULL SELECT COUNT(*) as incidents FROM type_msg t INNER JOIN sms s ON s.type_msg_id = t.id INNER JOIN numero n ON s.sender_num_id = n.id INNER JOIN agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164 AND HOUR(s.heure) = 7 AND resolution is not NULL;
43	0.40 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 HOUR(s.heure) = 8 AND resolution is not NULL Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 7164`] 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 HOUR(s.heure) = 8 AND resolution is not NULL SELECT COUNT(*) as incidents FROM type_msg t INNER JOIN sms s ON s.type_msg_id = t.id INNER JOIN numero n ON s.sender_num_id = n.id INNER JOIN agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164 AND HOUR(s.heure) = 8 AND resolution is not NULL;
44	0.48 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 HOUR(s.heure) = 9 AND resolution is not NULL Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 7164`] 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 HOUR(s.heure) = 9 AND resolution is not NULL SELECT COUNT(*) as incidents FROM type_msg t INNER JOIN sms s ON s.type_msg_id = t.id INNER JOIN numero n ON s.sender_num_id = n.id INNER JOIN agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164 AND HOUR(s.heure) = 9 AND resolution is not NULL;
45	0.47 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 HOUR(s.heure) = 10 AND resolution is not NULL Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 7164`] 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 HOUR(s.heure) = 10 AND resolution is not NULL SELECT COUNT(*) as incidents FROM type_msg t INNER JOIN sms s ON s.type_msg_id = t.id INNER JOIN numero n ON s.sender_num_id = n.id INNER JOIN agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164 AND HOUR(s.heure) = 10 AND resolution is not NULL;
46	0.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 HOUR(s.heure) = 11 AND resolution is not NULL Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 7164`] 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 HOUR(s.heure) = 11 AND resolution is not NULL SELECT COUNT(*) as incidents FROM type_msg t INNER JOIN sms s ON s.type_msg_id = t.id INNER JOIN numero n ON s.sender_num_id = n.id INNER JOIN agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164 AND HOUR(s.heure) = 11 AND resolution is not NULL;
47	0.54 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 HOUR(s.heure) = 12 AND resolution is not NULL Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 7164`] 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 HOUR(s.heure) = 12 AND resolution is not NULL SELECT COUNT(*) as incidents FROM type_msg t INNER JOIN sms s ON s.type_msg_id = t.id INNER JOIN numero n ON s.sender_num_id = n.id INNER JOIN agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164 AND HOUR(s.heure) = 12 AND resolution is not NULL;
48	0.43 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 HOUR(s.heure) = 13 AND resolution is not NULL Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 7164`] 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 HOUR(s.heure) = 13 AND resolution is not NULL SELECT COUNT(*) as incidents FROM type_msg t INNER JOIN sms s ON s.type_msg_id = t.id INNER JOIN numero n ON s.sender_num_id = n.id INNER JOIN agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164 AND HOUR(s.heure) = 13 AND resolution is not NULL;
49	0.62 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 HOUR(s.heure) = 14 AND resolution is not NULL Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 7164`] 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 HOUR(s.heure) = 14 AND resolution is not NULL SELECT COUNT(*) as incidents FROM type_msg t INNER JOIN sms s ON s.type_msg_id = t.id INNER JOIN numero n ON s.sender_num_id = n.id INNER JOIN agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164 AND HOUR(s.heure) = 14 AND resolution is not NULL;
50	0.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 HOUR(s.heure) = 15 AND resolution is not NULL Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 7164`] 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 HOUR(s.heure) = 15 AND resolution is not NULL SELECT COUNT(*) as incidents FROM type_msg t INNER JOIN sms s ON s.type_msg_id = t.id INNER JOIN numero n ON s.sender_num_id = n.id INNER JOIN agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164 AND HOUR(s.heure) = 15 AND resolution is not NULL;
51	1.08 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 HOUR(s.heure) = 16 AND resolution is not NULL Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 7164`] 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 HOUR(s.heure) = 16 AND resolution is not NULL SELECT COUNT(*) as incidents FROM type_msg t INNER JOIN sms s ON s.type_msg_id = t.id INNER JOIN numero n ON s.sender_num_id = n.id INNER JOIN agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164 AND HOUR(s.heure) = 16 AND resolution is not NULL;
52	1.00 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 HOUR(s.heure) = 17 AND resolution is not NULL Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 7164`] 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 HOUR(s.heure) = 17 AND resolution is not NULL SELECT COUNT(*) as incidents FROM type_msg t INNER JOIN sms s ON s.type_msg_id = t.id INNER JOIN numero n ON s.sender_num_id = n.id INNER JOIN agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164 AND HOUR(s.heure) = 17 AND resolution is not NULL;
53	0.78 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 HOUR(s.heure) = 18 AND resolution is not NULL Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 7164`] 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 HOUR(s.heure) = 18 AND resolution is not NULL SELECT COUNT(*) as incidents FROM type_msg t INNER JOIN sms s ON s.type_msg_id = t.id INNER JOIN numero n ON s.sender_num_id = n.id INNER JOIN agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164 AND HOUR(s.heure) = 18 AND resolution is not NULL;
54	0.67 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 HOUR(s.heure) = 19 AND resolution is not NULL Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 7164`] 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 HOUR(s.heure) = 19 AND resolution is not NULL SELECT COUNT(*) as incidents FROM type_msg t INNER JOIN sms s ON s.type_msg_id = t.id INNER JOIN numero n ON s.sender_num_id = n.id INNER JOIN agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164 AND HOUR(s.heure) = 19 AND resolution is not NULL;
55	1.48 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 HOUR(s.heure) = 20 AND resolution is not NULL Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 7164`] 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 HOUR(s.heure) = 20 AND resolution is not NULL SELECT COUNT(*) as incidents FROM type_msg t INNER JOIN sms s ON s.type_msg_id = t.id INNER JOIN numero n ON s.sender_num_id = n.id INNER JOIN agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164 AND HOUR(s.heure) = 20 AND resolution is not NULL;
56	5.62 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 HOUR(s.heure) = 21 AND resolution is not NULL Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 7164`] 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 HOUR(s.heure) = 21 AND resolution is not NULL SELECT COUNT(*) as incidents FROM type_msg t INNER JOIN sms s ON s.type_msg_id = t.id INNER JOIN numero n ON s.sender_num_id = n.id INNER JOIN agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164 AND HOUR(s.heure) = 21 AND resolution is not NULL;
57	1.36 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 HOUR(s.heure) = 22 AND resolution is not NULL Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 7164`] 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 HOUR(s.heure) = 22 AND resolution is not NULL SELECT COUNT(*) as incidents FROM type_msg t INNER JOIN sms s ON s.type_msg_id = t.id INNER JOIN numero n ON s.sender_num_id = n.id INNER JOIN agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164 AND HOUR(s.heure) = 22 AND resolution is not NULL;
58	1.01 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 HOUR(s.heure) = 23 AND resolution is not NULL Parameters: [`"alt" => "alt%" "lft" => 1 "rgt" => 7164`] 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 HOUR(s.heure) = 23 AND resolution is not NULL SELECT COUNT(*) as incidents FROM type_msg t INNER JOIN sms s ON s.type_msg_id = t.id INNER JOIN numero n ON s.sender_num_id = n.id INNER JOIN agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164 AND HOUR(s.heure) = 23 AND resolution is not NULL;
59	4.55 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;
60	1.37 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.decoupage_id AS decoupage_id_9, t0.superviseur_id AS superviseur_id_10, t0.circonscription_id AS circonscription_id_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.circ_id AS circ_id_14, t15.id AS id_16, t15.nom AS nom_17, t15.prenoms AS prenoms_18, t15.adresse AS adresse_19, t15.statut AS statut_20, t15.created_at AS created_at_21, t15.updated_at AS updated_at_22, t15.gestionnaire_id AS gestionnaire_id_23, t15.user_id AS user_id_24, t15.zone_id AS zone_id_25, t15.zon_id AS zon_id_26 FROM lieu t0 LEFT JOIN agent t15 ON t15.zone_id = t0.id WHERE t0.decoupage_id = ? Parameters: [`1`] 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.decoupage_id AS decoupage_id_9, t0.superviseur_id AS superviseur_id_10, t0.circonscription_id AS circonscription_id_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.circ_id AS circ_id_14, t15.id AS id_16, t15.nom AS nom_17, t15.prenoms AS prenoms_18, t15.adresse AS adresse_19, t15.statut AS statut_20, t15.created_at AS created_at_21, t15.updated_at AS updated_at_22, t15.gestionnaire_id AS gestionnaire_id_23, t15.user_id AS user_id_24, t15.zone_id AS zone_id_25, t15.zon_id AS zon_id_26 FROM lieu t0 LEFT JOIN agent t15 ON t15.zone_id = t0.id WHERE t0.decoupage_id = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.lat AS lat_3, t0.lon AS lon_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.nbe AS nbe_8, t0.decoupage_id AS decoupage_id_9, t0.superviseur_id AS superviseur_id_10, t0.circonscription_id AS circonscription_id_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.circ_id AS circ_id_14, t15.id AS id_16, t15.nom AS nom_17, t15.prenoms AS prenoms_18, t15.adresse AS adresse_19, t15.statut AS statut_20, t15.created_at AS created_at_21, t15.updated_at AS updated_at_22, t15.gestionnaire_id AS gestionnaire_id_23, t15.user_id AS user_id_24, t15.zone_id AS zone_id_25, t15.zon_id AS zon_id_26 FROM lieu t0 LEFT JOIN agent t15 ON t15.zone_id = t0.id WHERE t0.decoupage_id = 1;

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	13
App\Entity\Decoupage	7

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.

Symfony Profiler

GET https://xenpresi26.trouvelebon.com/incidents

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping