Symfony Profiler

SELECT
  DISTINCT v0_.id AS id_0,
  v0_.date_visite AS date_visite_1,
  p1_.property_name AS property_name_2
FROM
  visite v0_
  LEFT JOIN property p2_ ON v0_.property_id = p2_.id
  LEFT JOIN property p1_ ON v0_.property_id = p1_.id
ORDER BY
  v0_.date_visite DESC,
  p1_.property_name ASC
LIMIT
  20 OFFSET 2400

SELECT DISTINCT v0_.id AS id_0, v0_.date_visite AS date_visite_1, p1_.property_name AS property_name_2 FROM visite v0_ LEFT JOIN property p2_ ON v0_.property_id = p2_.id LEFT JOIN property p1_ ON v0_.property_id = p1_.id ORDER BY v0_.date_visite DESC, p1_.property_name ASC LIMIT 20 OFFSET 2400;

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.visite_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.visite_id = 5174;

SELECT
  COUNT(DISTINCT v0_.id) AS sclr_0
FROM
  visite v0_
  LEFT JOIN property p1_ ON v0_.property_id = p1_.id
  LEFT JOIN property p2_ ON v0_.property_id = p2_.id

SELECT COUNT(DISTINCT v0_.id) AS sclr_0 FROM visite v0_ LEFT JOIN property p1_ ON v0_.property_id = p1_.id LEFT JOIN property p2_ ON v0_.property_id = p2_.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
WHERE
  t0.visite_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 WHERE t0.visite_id = 5174;

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
  v0_.id AS id_0,
  v0_.date_visite AS date_visite_1,
  v0_.uuid AS uuid_2,
  v0_.client_uuid AS client_uuid_3,
  v0_.commentaire AS commentaire_4,
  v0_.main_consultant AS main_consultant_5,
  p1_.id AS id_6,
  p1_.property_name AS property_name_7,
  p1_.commune AS commune_8,
  p1_.surface_totale AS surface_totale_9,
  p1_.contract_name AS contract_name_10,
  p1_.adresse_1 AS adresse_1_11,
  p1_.adresse_2 AS adresse_2_12,
  p1_.code_postal AS code_postal_13,
  v0_.property_id AS property_id_14,
  p1_.departement_id AS departement_id_15,
  p1_.main_consultant_id AS main_consultant_id_16
FROM
  visite v0_
  LEFT JOIN property p2_ ON v0_.property_id = p2_.id
  LEFT JOIN property p1_ ON v0_.property_id = p1_.id
WHERE
  v0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  v0_.date_visite DESC,
  p1_.property_name ASC

SELECT v0_.id AS id_0, v0_.date_visite AS date_visite_1, v0_.uuid AS uuid_2, v0_.client_uuid AS client_uuid_3, v0_.commentaire AS commentaire_4, v0_.main_consultant AS main_consultant_5, p1_.id AS id_6, p1_.property_name AS property_name_7, p1_.commune AS commune_8, p1_.surface_totale AS surface_totale_9, p1_.contract_name AS contract_name_10, p1_.adresse_1 AS adresse_1_11, p1_.adresse_2 AS adresse_2_12, p1_.code_postal AS code_postal_13, v0_.property_id AS property_id_14, p1_.departement_id AS departement_id_15, p1_.main_consultant_id AS main_consultant_id_16 FROM visite v0_ LEFT JOIN property p2_ ON v0_.property_id = p2_.id LEFT JOIN property p1_ ON v0_.property_id = p1_.id WHERE v0_.id IN (5174, 5178, 5099, 5173, 5180, 5159, 5095, 5078, 5079, 5074, 5083, 5075, 5184, 5092, 5103, 5081, 5082, 5086, 5087, 5073) ORDER BY v0_.date_visite DESC, p1_.property_name ASC;