Symfony Profiler

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0
FROM
  observation o0_
  INNER JOIN property p1_ ON o0_.property_id = p1_.id
  LEFT JOIN visite v2_ ON o0_.visite_id = v2_.id
  LEFT JOIN preconisation_actualisee_observation p4_ ON o0_.id = p4_.observation_id
  LEFT JOIN preconisation_actualisee p3_ ON p3_.id = p4_.preconisation_actualisee_id
WHERE
  o0_.last_update > ?
  AND o0_.property_id IN (
    SELECT
      p5_.id
    FROM
      property p5_
      INNER JOIN user_property u7_ ON p5_.id = u7_.property_id
      INNER JOIN `user` u6_ ON u6_.id = u7_.user_id
    WHERE
      u6_.id = ?
  )

SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM observation o0_ INNER JOIN property p1_ ON o0_.property_id = p1_.id LEFT JOIN visite v2_ ON o0_.visite_id = v2_.id LEFT JOIN preconisation_actualisee_observation p4_ ON o0_.id = p4_.observation_id LEFT JOIN preconisation_actualisee p3_ ON p3_.id = p4_.preconisation_actualisee_id WHERE o0_.last_update > '2025-06-22 17:01:34' AND o0_.property_id IN (SELECT p5_.id FROM property p5_ INNER JOIN user_property u7_ ON p5_.id = u7_.property_id INNER JOIN `user` u6_ ON u6_.id = u7_.user_id WHERE u6_.id = '1');

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.last_update AS last_update_1
FROM
  observation o0_
  INNER JOIN property p1_ ON o0_.property_id = p1_.id
  LEFT JOIN visite v2_ ON o0_.visite_id = v2_.id
  LEFT JOIN preconisation_actualisee_observation p4_ ON o0_.id = p4_.observation_id
  LEFT JOIN preconisation_actualisee p3_ ON p3_.id = p4_.preconisation_actualisee_id
WHERE
  o0_.last_update > ?
  AND o0_.property_id IN (
    SELECT
      p5_.id
    FROM
      property p5_
      INNER JOIN user_property u7_ ON p5_.id = u7_.property_id
      INNER JOIN `user` u6_ ON u6_.id = u7_.user_id
    WHERE
      u6_.id = ?
  )
ORDER BY
  o0_.last_update DESC
LIMIT
  30 OFFSET 660

SELECT DISTINCT o0_.id AS id_0, o0_.last_update AS last_update_1 FROM observation o0_ INNER JOIN property p1_ ON o0_.property_id = p1_.id LEFT JOIN visite v2_ ON o0_.visite_id = v2_.id LEFT JOIN preconisation_actualisee_observation p4_ ON o0_.id = p4_.observation_id LEFT JOIN preconisation_actualisee p3_ ON p3_.id = p4_.preconisation_actualisee_id WHERE o0_.last_update > '2025-06-22 17:01:34' AND o0_.property_id IN (SELECT p5_.id FROM property p5_ INNER JOIN user_property u7_ ON p5_.id = u7_.property_id INNER JOIN `user` u6_ ON u6_.id = u7_.user_id WHERE u6_.id = '1') ORDER BY o0_.last_update DESC LIMIT 30 OFFSET 660;

SELECT
  o0_.id AS id_0,
  o0_.secteur AS secteur_1,
  o0_.ilot AS ilot_2,
  o0_.parcelle AS parcelle_3,
  o0_.stade_r_1 AS stade_r_1_4,
  o0_.stade_r_2 AS stade_r_2_5,
  o0_.mi_f AS mi_f_6,
  o0_.mi_g AS mi_g_7,
  o0_.br_f AS br_f_8,
  o0_.br_g AS br_g_9,
  o0_.oi_f AS oi_f_10,
  o0_.oi_g AS oi_g_11,
  o0_.pg_f AS pg_f_12,
  o0_.pg_g AS pg_g_13,
  o0_.maladie_bois AS maladie_bois_14,
  o0_.note_mdb AS note_mdb_15,
  o0_.cic_v AS cic_v_16,
  o0_.cic_fd AS cic_fd_17,
  o0_.vdg_glom AS vdg_glom_18,
  o0_.vdg_perfos AS vdg_perfos_19,
  o0_.carences AS carences_20,
  o0_.note_carence AS note_carence_21,
  o0_.commentaire AS commentaire_22,
  o0_.notation AS notation_23,
  o0_.created_by AS created_by_24,
  o0_.last_update AS last_update_25,
  o0_.last_updater AS last_updater_26,
  o0_.vdg_ponte AS vdg_ponte_27,
  o0_.uuid AS uuid_28,
  o0_.client_uuid AS client_uuid_29,
  p1_.id AS id_30,
  p1_.property_name AS property_name_31,
  p1_.commune AS commune_32,
  p1_.surface_totale AS surface_totale_33,
  p1_.contract_name AS contract_name_34,
  p1_.adresse_1 AS adresse_1_35,
  p1_.adresse_2 AS adresse_2_36,
  p1_.code_postal AS code_postal_37,
  v2_.id AS id_38,
  v2_.date_visite AS date_visite_39,
  v2_.uuid AS uuid_40,
  v2_.client_uuid AS client_uuid_41,
  v2_.commentaire AS commentaire_42,
  p3_.id AS id_43,
  p3_.date_preco AS date_preco_44,
  p3_.num_trt AS num_trt_45,
  p3_.type_traitement AS type_traitement_46,
  p3_.categorie_surface AS categorie_surface_47,
  p3_.stade_pheno AS stade_pheno_48,
  p3_.contexte_sanitaire AS contexte_sanitaire_49,
  p3_.complement_information AS complement_information_50,
  p3_.surface AS surface_51,
  p3_.operation_culturale AS operation_culturale_52,
  p3_.delai AS delai_53,
  p3_.uuid AS uuid_54,
  p3_.client_uuid AS client_uuid_55,
  p3_.created_by AS created_by_56,
  p3_.last_update AS last_update_57,
  p3_.last_updater AS last_updater_58,
  p3_.mail_body AS mail_body_59,
  o0_.property_id AS property_id_60,
  o0_.visite_id AS visite_id_61,
  p1_.departement_id AS departement_id_62,
  v2_.property_id AS property_id_63,
  p3_.preco_rapide_id AS preco_rapide_id_64,
  p3_.property_id AS property_id_65,
  p3_.regroupement_propriete_id AS regroupement_propriete_id_66,
  p3_.preconisation_saison_id AS preconisation_saison_id_67,
  p3_.visite_id AS visite_id_68
FROM
  observation o0_
  INNER JOIN property p1_ ON o0_.property_id = p1_.id
  LEFT JOIN visite v2_ ON o0_.visite_id = v2_.id
  LEFT JOIN preconisation_actualisee_observation p4_ ON o0_.id = p4_.observation_id
  LEFT JOIN preconisation_actualisee p3_ ON p3_.id = p4_.preconisation_actualisee_id
WHERE
  o0_.last_update > ?
  AND o0_.property_id IN (
    SELECT
      p5_.id
    FROM
      property p5_
      INNER JOIN user_property u7_ ON p5_.id = u7_.property_id
      INNER JOIN `user` u6_ ON u6_.id = u7_.user_id
    WHERE
      u6_.id = ?
  )
  AND o0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  o0_.last_update DESC

SELECT o0_.id AS id_0, o0_.secteur AS secteur_1, o0_.ilot AS ilot_2, o0_.parcelle AS parcelle_3, o0_.stade_r_1 AS stade_r_1_4, o0_.stade_r_2 AS stade_r_2_5, o0_.mi_f AS mi_f_6, o0_.mi_g AS mi_g_7, o0_.br_f AS br_f_8, o0_.br_g AS br_g_9, o0_.oi_f AS oi_f_10, o0_.oi_g AS oi_g_11, o0_.pg_f AS pg_f_12, o0_.pg_g AS pg_g_13, o0_.maladie_bois AS maladie_bois_14, o0_.note_mdb AS note_mdb_15, o0_.cic_v AS cic_v_16, o0_.cic_fd AS cic_fd_17, o0_.vdg_glom AS vdg_glom_18, o0_.vdg_perfos AS vdg_perfos_19, o0_.carences AS carences_20, o0_.note_carence AS note_carence_21, o0_.commentaire AS commentaire_22, o0_.notation AS notation_23, o0_.created_by AS created_by_24, o0_.last_update AS last_update_25, o0_.last_updater AS last_updater_26, o0_.vdg_ponte AS vdg_ponte_27, o0_.uuid AS uuid_28, o0_.client_uuid AS client_uuid_29, p1_.id AS id_30, p1_.property_name AS property_name_31, p1_.commune AS commune_32, p1_.surface_totale AS surface_totale_33, p1_.contract_name AS contract_name_34, p1_.adresse_1 AS adresse_1_35, p1_.adresse_2 AS adresse_2_36, p1_.code_postal AS code_postal_37, v2_.id AS id_38, v2_.date_visite AS date_visite_39, v2_.uuid AS uuid_40, v2_.client_uuid AS client_uuid_41, v2_.commentaire AS commentaire_42, p3_.id AS id_43, p3_.date_preco AS date_preco_44, p3_.num_trt AS num_trt_45, p3_.type_traitement AS type_traitement_46, p3_.categorie_surface AS categorie_surface_47, p3_.stade_pheno AS stade_pheno_48, p3_.contexte_sanitaire AS contexte_sanitaire_49, p3_.complement_information AS complement_information_50, p3_.surface AS surface_51, p3_.operation_culturale AS operation_culturale_52, p3_.delai AS delai_53, p3_.uuid AS uuid_54, p3_.client_uuid AS client_uuid_55, p3_.created_by AS created_by_56, p3_.last_update AS last_update_57, p3_.last_updater AS last_updater_58, p3_.mail_body AS mail_body_59, o0_.property_id AS property_id_60, o0_.visite_id AS visite_id_61, p1_.departement_id AS departement_id_62, v2_.property_id AS property_id_63, p3_.preco_rapide_id AS preco_rapide_id_64, p3_.property_id AS property_id_65, p3_.regroupement_propriete_id AS regroupement_propriete_id_66, p3_.preconisation_saison_id AS preconisation_saison_id_67, p3_.visite_id AS visite_id_68 FROM observation o0_ INNER JOIN property p1_ ON o0_.property_id = p1_.id LEFT JOIN visite v2_ ON o0_.visite_id = v2_.id LEFT JOIN preconisation_actualisee_observation p4_ ON o0_.id = p4_.observation_id LEFT JOIN preconisation_actualisee p3_ ON p3_.id = p4_.preconisation_actualisee_id WHERE o0_.last_update > '2025-06-22 17:01:34' AND o0_.property_id IN (SELECT p5_.id FROM property p5_ INNER JOIN user_property u7_ ON p5_.id = u7_.property_id INNER JOIN `user` u6_ ON u6_.id = u7_.user_id WHERE u6_.id = '1') AND o0_.id IN (69425, 69163, 69179, 69410, 69488, 69255, 69199, 69215, 69231, 69497, 69426, 69164, 69180, 69411, 69489, 69257, 69200, 69216, 69232, 69498, 69427, 69165, 69181, 69412, 69490, 69259, 69201, 69217, 69233, 69499) ORDER BY o0_.last_update DESC;