Symfony Profiler

SELECT
  DISTINCT o0_.id AS id_0,
  v1_.date_visite AS date_visite_1,
  p2_.property_name AS property_name_2,
  o0_.parcelle AS parcelle_3
FROM
  observation o0_
  LEFT JOIN preconisation_actualisee_observation p4_ ON o0_.id = p4_.observation_id
  LEFT JOIN preconisation_actualisee p3_ ON p3_.id = p4_.preconisation_actualisee_id
  LEFT JOIN property p2_ ON o0_.property_id = p2_.id
  LEFT JOIN visite v1_ ON o0_.visite_id = v1_.id
ORDER BY
  v1_.date_visite DESC,
  p2_.property_name ASC,
  o0_.parcelle ASC
LIMIT
  20 OFFSET 81940

SELECT DISTINCT o0_.id AS id_0, v1_.date_visite AS date_visite_1, p2_.property_name AS property_name_2, o0_.parcelle AS parcelle_3 FROM observation o0_ LEFT JOIN preconisation_actualisee_observation p4_ ON o0_.id = p4_.observation_id LEFT JOIN preconisation_actualisee p3_ ON p3_.id = p4_.preconisation_actualisee_id LEFT JOIN property p2_ ON o0_.property_id = p2_.id LEFT JOIN visite v1_ ON o0_.visite_id = v1_.id ORDER BY v1_.date_visite DESC, p2_.property_name ASC, o0_.parcelle ASC LIMIT 20 OFFSET 81940;

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0
FROM
  observation o0_
  LEFT JOIN preconisation_actualisee_observation p2_ ON o0_.id = p2_.observation_id
  LEFT JOIN preconisation_actualisee p1_ ON p1_.id = p2_.preconisation_actualisee_id
  LEFT JOIN property p3_ ON o0_.property_id = p3_.id
  LEFT JOIN visite v4_ ON o0_.visite_id = v4_.id

SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM observation o0_ LEFT JOIN preconisation_actualisee_observation p2_ ON o0_.id = p2_.observation_id LEFT JOIN preconisation_actualisee p1_ ON p1_.id = p2_.preconisation_actualisee_id LEFT JOIN property p3_ ON o0_.property_id = p3_.id LEFT JOIN visite v4_ ON o0_.visite_id = v4_.id;

SELECT
  t0.id AS id_1,
  t0.date_preco AS date_preco_2,
  t0.num_trt AS num_trt_3,
  t0.type_traitement AS type_traitement_4,
  t0.categorie_surface AS categorie_surface_5,
  t0.stade_pheno AS stade_pheno_6,
  t0.contexte_sanitaire AS contexte_sanitaire_7,
  t0.complement_information AS complement_information_8,
  t0.surface AS surface_9,
  t0.operation_culturale AS operation_culturale_10,
  t0.delai AS delai_11,
  t0.uuid AS uuid_12,
  t0.client_uuid AS client_uuid_13,
  t0.created_by AS created_by_14,
  t0.last_update AS last_update_15,
  t0.last_updater AS last_updater_16,
  t0.mail_body AS mail_body_17,
  t0.preco_rapide_id AS preco_rapide_id_18,
  t0.property_id AS property_id_19,
  t0.regroupement_propriete_id AS regroupement_propriete_id_20,
  t0.preconisation_saison_id AS preconisation_saison_id_21,
  t0.visite_id AS visite_id_22
FROM
  preconisation_actualisee t0
  INNER JOIN preconisation_actualisee_observation ON t0.id = preconisation_actualisee_observation.preconisation_actualisee_id
WHERE
  preconisation_actualisee_observation.observation_id = ?

SELECT t0.id AS id_1, t0.date_preco AS date_preco_2, t0.num_trt AS num_trt_3, t0.type_traitement AS type_traitement_4, t0.categorie_surface AS categorie_surface_5, t0.stade_pheno AS stade_pheno_6, t0.contexte_sanitaire AS contexte_sanitaire_7, t0.complement_information AS complement_information_8, t0.surface AS surface_9, t0.operation_culturale AS operation_culturale_10, t0.delai AS delai_11, t0.uuid AS uuid_12, t0.client_uuid AS client_uuid_13, t0.created_by AS created_by_14, t0.last_update AS last_update_15, t0.last_updater AS last_updater_16, t0.mail_body AS mail_body_17, t0.preco_rapide_id AS preco_rapide_id_18, t0.property_id AS property_id_19, t0.regroupement_propriete_id AS regroupement_propriete_id_20, t0.preconisation_saison_id AS preconisation_saison_id_21, t0.visite_id AS visite_id_22 FROM preconisation_actualisee t0 INNER JOIN preconisation_actualisee_observation ON t0.id = preconisation_actualisee_observation.preconisation_actualisee_id WHERE preconisation_actualisee_observation.observation_id = 2830;

SELECT
  (
    SELECT
      COUNT(o0_.id) AS sclr_1
    FROM
      observation o0_
      INNER JOIN preconisation_actualisee_observation p2_ ON o0_.id = p2_.observation_id
      INNER JOIN preconisation_actualisee p1_ ON p1_.id = p2_.preconisation_actualisee_id
    WHERE
      o0_.id = o3_.id
  ) AS sclr_0,
  o3_.id AS id_2,
  o3_.secteur AS secteur_3,
  o3_.ilot AS ilot_4,
  o3_.parcelle AS parcelle_5,
  o3_.stade_r_1 AS stade_r_1_6,
  o3_.stade_r_2 AS stade_r_2_7,
  o3_.mi_f AS mi_f_8,
  o3_.mi_g AS mi_g_9,
  o3_.br_f AS br_f_10,
  o3_.br_g AS br_g_11,
  o3_.oi_f AS oi_f_12,
  o3_.oi_g AS oi_g_13,
  o3_.pg_f AS pg_f_14,
  o3_.pg_g AS pg_g_15,
  o3_.maladie_bois AS maladie_bois_16,
  o3_.note_mdb AS note_mdb_17,
  o3_.cic_v AS cic_v_18,
  o3_.cic_fd AS cic_fd_19,
  o3_.vdg_glom AS vdg_glom_20,
  o3_.vdg_perfos AS vdg_perfos_21,
  o3_.carences AS carences_22,
  o3_.note_carence AS note_carence_23,
  o3_.commentaire AS commentaire_24,
  o3_.notation AS notation_25,
  o3_.created_by AS created_by_26,
  o3_.last_update AS last_update_27,
  o3_.last_updater AS last_updater_28,
  o3_.vdg_ponte AS vdg_ponte_29,
  o3_.uuid AS uuid_30,
  o3_.client_uuid AS client_uuid_31,
  p4_.id AS id_32,
  p4_.property_name AS property_name_33,
  p4_.commune AS commune_34,
  p4_.surface_totale AS surface_totale_35,
  p4_.contract_name AS contract_name_36,
  p4_.adresse_1 AS adresse_1_37,
  p4_.adresse_2 AS adresse_2_38,
  p4_.code_postal AS code_postal_39,
  v5_.id AS id_40,
  v5_.date_visite AS date_visite_41,
  v5_.uuid AS uuid_42,
  v5_.client_uuid AS client_uuid_43,
  v5_.commentaire AS commentaire_44,
  o3_.property_id AS property_id_45,
  o3_.visite_id AS visite_id_46,
  p4_.departement_id AS departement_id_47,
  v5_.property_id AS property_id_48
FROM
  observation o3_
  LEFT JOIN preconisation_actualisee_observation p7_ ON o3_.id = p7_.observation_id
  LEFT JOIN preconisation_actualisee p6_ ON p6_.id = p7_.preconisation_actualisee_id
  LEFT JOIN property p4_ ON o3_.property_id = p4_.id
  LEFT JOIN visite v5_ ON o3_.visite_id = v5_.id
WHERE
  o3_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  v5_.date_visite DESC,
  p4_.property_name ASC,
  o3_.parcelle ASC

SELECT (SELECT COUNT(o0_.id) AS sclr_1 FROM observation o0_ INNER JOIN preconisation_actualisee_observation p2_ ON o0_.id = p2_.observation_id INNER JOIN preconisation_actualisee p1_ ON p1_.id = p2_.preconisation_actualisee_id WHERE o0_.id = o3_.id) AS sclr_0, o3_.id AS id_2, o3_.secteur AS secteur_3, o3_.ilot AS ilot_4, o3_.parcelle AS parcelle_5, o3_.stade_r_1 AS stade_r_1_6, o3_.stade_r_2 AS stade_r_2_7, o3_.mi_f AS mi_f_8, o3_.mi_g AS mi_g_9, o3_.br_f AS br_f_10, o3_.br_g AS br_g_11, o3_.oi_f AS oi_f_12, o3_.oi_g AS oi_g_13, o3_.pg_f AS pg_f_14, o3_.pg_g AS pg_g_15, o3_.maladie_bois AS maladie_bois_16, o3_.note_mdb AS note_mdb_17, o3_.cic_v AS cic_v_18, o3_.cic_fd AS cic_fd_19, o3_.vdg_glom AS vdg_glom_20, o3_.vdg_perfos AS vdg_perfos_21, o3_.carences AS carences_22, o3_.note_carence AS note_carence_23, o3_.commentaire AS commentaire_24, o3_.notation AS notation_25, o3_.created_by AS created_by_26, o3_.last_update AS last_update_27, o3_.last_updater AS last_updater_28, o3_.vdg_ponte AS vdg_ponte_29, o3_.uuid AS uuid_30, o3_.client_uuid AS client_uuid_31, p4_.id AS id_32, p4_.property_name AS property_name_33, p4_.commune AS commune_34, p4_.surface_totale AS surface_totale_35, p4_.contract_name AS contract_name_36, p4_.adresse_1 AS adresse_1_37, p4_.adresse_2 AS adresse_2_38, p4_.code_postal AS code_postal_39, v5_.id AS id_40, v5_.date_visite AS date_visite_41, v5_.uuid AS uuid_42, v5_.client_uuid AS client_uuid_43, v5_.commentaire AS commentaire_44, o3_.property_id AS property_id_45, o3_.visite_id AS visite_id_46, p4_.departement_id AS departement_id_47, v5_.property_id AS property_id_48 FROM observation o3_ LEFT JOIN preconisation_actualisee_observation p7_ ON o3_.id = p7_.observation_id LEFT JOIN preconisation_actualisee p6_ ON p6_.id = p7_.preconisation_actualisee_id LEFT JOIN property p4_ ON o3_.property_id = p4_.id LEFT JOIN visite v5_ ON o3_.visite_id = v5_.id WHERE o3_.id IN (2830, 2835, 2836, 2829, 2833, 2831, 2832, 2807, 2805, 2797, 2796, 2795, 2806, 2790, 2792, 2791, 2793, 2804, 2803, 2794) ORDER BY v5_.date_visite DESC, p4_.property_name ASC, o3_.parcelle ASC;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.reset_token AS reset_token_4,
  u0_.is_active AS is_active_5,
  u0_.first_name AS first_name_6,
  u0_.last_name AS last_name_7,
  u0_.function AS function_8,
  u0_.type_certiphyto AS type_certiphyto_9,
  u0_.validite_certiphyto AS validite_certiphyto_10,
  u0_.mobile AS mobile_11,
  u0_.phone AS phone_12,
  u0_.num_certiphyto AS num_certiphyto_13,
  u0_.stades_pheno AS stades_pheno_14,
  u0_.p_tordeuses AS p_tordeuses_15,
  u0_.movida AS movida_16,
  u0_.grp_30k AS grp_30k_17,
  u0_.is_admin AS is_admin_18
FROM
  `user` u0_
WHERE
  u0_.is_admin = ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_token AS reset_token_4, u0_.is_active AS is_active_5, u0_.first_name AS first_name_6, u0_.last_name AS last_name_7, u0_.function AS function_8, u0_.type_certiphyto AS type_certiphyto_9, u0_.validite_certiphyto AS validite_certiphyto_10, u0_.mobile AS mobile_11, u0_.phone AS phone_12, u0_.num_certiphyto AS num_certiphyto_13, u0_.stades_pheno AS stades_pheno_14, u0_.p_tordeuses AS p_tordeuses_15, u0_.movida AS movida_16, u0_.grp_30k AS grp_30k_17, u0_.is_admin AS is_admin_18 FROM `user` u0_ WHERE u0_.is_admin = 1;

SELECT
  t0.id AS id_1,
  t0.secteur AS secteur_2,
  t0.ilot AS ilot_3,
  t0.parcelle AS parcelle_4,
  t0.stade_r_1 AS stade_r_1_5,
  t0.stade_r_2 AS stade_r_2_6,
  t0.mi_f AS mi_f_7,
  t0.mi_g AS mi_g_8,
  t0.br_f AS br_f_9,
  t0.br_g AS br_g_10,
  t0.oi_f AS oi_f_11,
  t0.oi_g AS oi_g_12,
  t0.pg_f AS pg_f_13,
  t0.pg_g AS pg_g_14,
  t0.maladie_bois AS maladie_bois_15,
  t0.note_mdb AS note_mdb_16,
  t0.cic_v AS cic_v_17,
  t0.cic_fd AS cic_fd_18,
  t0.vdg_glom AS vdg_glom_19,
  t0.vdg_perfos AS vdg_perfos_20,
  t0.carences AS carences_21,
  t0.note_carence AS note_carence_22,
  t0.commentaire AS commentaire_23,
  t0.notation AS notation_24,
  t0.created_by AS created_by_25,
  t0.last_update AS last_update_26,
  t0.last_updater AS last_updater_27,
  t0.vdg_ponte AS vdg_ponte_28,
  t0.uuid AS uuid_29,
  t0.client_uuid AS client_uuid_30,
  t0.property_id AS property_id_31,
  t0.visite_id AS visite_id_32
FROM
  observation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.ilot AS ilot_3, t0.parcelle AS parcelle_4, t0.stade_r_1 AS stade_r_1_5, t0.stade_r_2 AS stade_r_2_6, t0.mi_f AS mi_f_7, t0.mi_g AS mi_g_8, t0.br_f AS br_f_9, t0.br_g AS br_g_10, t0.oi_f AS oi_f_11, t0.oi_g AS oi_g_12, t0.pg_f AS pg_f_13, t0.pg_g AS pg_g_14, t0.maladie_bois AS maladie_bois_15, t0.note_mdb AS note_mdb_16, t0.cic_v AS cic_v_17, t0.cic_fd AS cic_fd_18, t0.vdg_glom AS vdg_glom_19, t0.vdg_perfos AS vdg_perfos_20, t0.carences AS carences_21, t0.note_carence AS note_carence_22, t0.commentaire AS commentaire_23, t0.notation AS notation_24, t0.created_by AS created_by_25, t0.last_update AS last_update_26, t0.last_updater AS last_updater_27, t0.vdg_ponte AS vdg_ponte_28, t0.uuid AS uuid_29, t0.client_uuid AS client_uuid_30, t0.property_id AS property_id_31, t0.visite_id AS visite_id_32 FROM observation t0 WHERE t0.id = '71890';

SELECT
  t0.id AS id_1,
  t0.property_name AS property_name_2,
  t0.commune AS commune_3,
  t0.surface_totale AS surface_totale_4,
  t0.contract_name AS contract_name_5,
  t0.adresse_1 AS adresse_1_6,
  t0.adresse_2 AS adresse_2_7,
  t0.code_postal AS code_postal_8,
  t0.departement_id AS departement_id_9
FROM
  property t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.property_name AS property_name_2, t0.commune AS commune_3, t0.surface_totale AS surface_totale_4, t0.contract_name AS contract_name_5, t0.adresse_1 AS adresse_1_6, t0.adresse_2 AS adresse_2_7, t0.code_postal AS code_postal_8, t0.departement_id AS departement_id_9 FROM property t0 WHERE t0.id = 521;

SELECT
  t0.id AS id_1,
  t0.date_visite AS date_visite_2,
  t0.uuid AS uuid_3,
  t0.client_uuid AS client_uuid_4,
  t0.commentaire AS commentaire_5,
  t0.property_id AS property_id_6
FROM
  visite t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_visite AS date_visite_2, t0.uuid AS uuid_3, t0.client_uuid AS client_uuid_4, t0.commentaire AS commentaire_5, t0.property_id AS property_id_6 FROM visite t0 WHERE t0.id = 6604;