Symfony Profiler

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
  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 75460

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

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,
  v5_.main_consultant AS main_consultant_45,
  o3_.property_id AS property_id_46,
  o3_.visite_id AS visite_id_47,
  p4_.departement_id AS departement_id_48,
  p4_.main_consultant_id AS main_consultant_id_49,
  v5_.property_id AS property_id_50
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, v5_.main_consultant AS main_consultant_45, o3_.property_id AS property_id_46, o3_.visite_id AS visite_id_47, p4_.departement_id AS departement_id_48, p4_.main_consultant_id AS main_consultant_id_49, v5_.property_id AS property_id_50 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 (31357, 31358, 31346, 31344, 31339, 31345, 31347, 31340, 31342, 31343, 31341, 31198, 31196, 31195, 31193, 31194, 31200, 31201, 31191, 31199) ORDER BY v5_.date_visite DESC, p4_.property_name ASC, o3_.parcelle ASC;

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 = 31357;

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 = 31358;

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 = 31346;

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 = 31344;

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 = 31339;

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 = 31345;

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 = 31347;

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 = 31340;