Symfony Profiler

SELECT
  DISTINCT o0_.secteur AS secteur_0,
  o0_.created_by AS created_by_1,
  GROUP_CONCAT(
    DISTINCT CONCAT(
      o0_.created_by, ' (', u1_.mobile,
      ')'
    ) SEPARATOR ', '
  ) AS sclr_2,
  GROUP_CONCAT(
    DISTINCT CONCAT(
      o0_.created_by, ' (', u1_.num_certiphyto,
      ')'
    ) SEPARATOR ', '
  ) AS sclr_3,
  CONCAT(
    o0_.secteur, '|||', o0_.created_by
  ) AS sclr_4
FROM
  observation o0_
  LEFT JOIN `user` u1_ ON (
    CONCAT(
      u1_.first_name, ' ', u1_.last_name
    ) = o0_.created_by
    AND u1_.is_admin = 1
  )
WHERE
  o0_.visite_id = ?
GROUP BY
  o0_.secteur,
  o0_.created_by
ORDER BY
  o0_.secteur ASC,
  o0_.created_by ASC

SELECT DISTINCT o0_.secteur AS secteur_0, o0_.created_by AS created_by_1, GROUP_CONCAT(DISTINCT CONCAT(o0_.created_by, ' (', u1_.mobile, ')') SEPARATOR ', ') AS sclr_2, GROUP_CONCAT(DISTINCT CONCAT(o0_.created_by, ' (', u1_.num_certiphyto, ')') SEPARATOR ', ') AS sclr_3, CONCAT(o0_.secteur, '|||', o0_.created_by) AS sclr_4 FROM observation o0_ LEFT JOIN `user` u1_ ON (CONCAT(u1_.first_name, ' ', u1_.last_name) = o0_.created_by AND u1_.is_admin = 1) WHERE o0_.visite_id = '7979' GROUP BY o0_.secteur, o0_.created_by ORDER BY o0_.secteur ASC, o0_.created_by ASC;

SELECT
  b0_.id AS id_0,
  b0_.dose_maximale_homologuee AS dose_maximale_homologuee_1,
  b0_.znt_aquatique AS znt_aquatique_2,
  b0_.znt_aquatique_infos AS znt_aquatique_infos_3,
  b0_.znt_terrestre_cultivee AS znt_terrestre_cultivee_4,
  b0_.znt_terrestre_non_cultivee AS znt_terrestre_non_cultivee_5,
  b0_.nombre_application AS nombre_application_6,
  b0_.nombre_applications_infos AS nombre_applications_infos_7,
  b0_.information_avant_dar AS information_avant_dar_8,
  b0_.dar AS dar_9,
  b0_.information_apres_dar AS information_apres_dar_10,
  b0_.specification_usage AS specification_usage_11,
  b0_.date_debut_utilisation_usage AS date_debut_utilisation_usage_12,
  b0_.date_fin_utilisation_usage AS date_fin_utilisation_usage_13,
  b0_.mention_abeille AS mention_abeille_14,
  b0_.dre_animaux AS dre_animaux_15,
  b0_.commentaire_dre_animaux AS commentaire_dre_animaux_16,
  b0_.dose_recommandee_firme AS dose_recommandee_firme_17,
  b0_.commentaire_dose_recommandee AS commentaire_dose_recommandee_18,
  b0_.fractionnement AS fractionnement_19,
  b0_.commentaire_fractionnement AS commentaire_fractionnement_20,
  b0_.intervalle_application AS intervalle_application_21,
  b0_.commentaire_intervalle AS commentaire_intervalle_22,
  b0_.commentaire_znt_terrestre AS commentaire_znt_terrestre_23,
  b0_.fractionnement_dose_maximale AS fractionnement_dose_maximale_24,
  b0_.fractionnement_nombre_application_minimal AS fractionnement_nombre_application_minimal_25,
  b0_.fractionnement_nombre_application_maximal AS fractionnement_nombre_application_maximal_26,
  b0_.code_cible_ministere AS code_cible_ministere_27,
  b0_.uuid AS uuid_28,
  b0_.dose_minimale_homologuee AS dose_minimale_homologuee_29,
  b0_.delai_reentree_local AS delai_reentree_local_30,
  b0_.delai_reentree_plein_champ AS delai_reentree_plein_champ_31,
  b0_.date_debut_delai_grace AS date_debut_delai_grace_32,
  b0_.date_fin_delai_grace AS date_fin_delai_grace_33,
  b0_.date_debut_periode_application AS date_debut_periode_application_34,
  b0_.date_fin_periode_application AS date_fin_periode_application_35,
  b0_.date_fin_commercialisation AS date_fin_commercialisation_36,
  b0_.discriminant AS discriminant_37,
  b0_.usage_duplique AS usage_duplique_38,
  b0_.uuid_usage_duplique AS uuid_usage_duplique_39,
  b0_.utilisation_materiel_attenuation_derive AS utilisation_materiel_attenuation_derive_40,
  b0_.commentaire_distance_securite_riverain AS commentaire_distance_securite_riverain_41,
  b0_.valeur_znt_terrestre_cultivee AS valeur_znt_terrestre_cultivee_42,
  b0_.valeur_znt_terrestre_non_cultivee AS valeur_znt_terrestre_non_cultivee_43,
  b0_.intervalle_application_fractionnement AS intervalle_application_fractionnement_44,
  b0_.surface_maximale AS surface_maximale_45,
  b0_.dose_restrictive AS dose_restrictive_46,
  b0_.commentaire_dose_restrictive AS commentaire_dose_restrictive_47,
  b0_.reduction_derive AS reduction_derive_48,
  b0_.usage_derogatoire AS usage_derogatoire_49,
  b0_.duree_usage_derogatoire AS duree_usage_derogatoire_50,
  b0_.code_produit_id AS code_produit_id_51,
  b0_.culture_id AS culture_id_52,
  b0_.cible_id AS cible_id_53,
  b0_.traitement_id AS traitement_id_54,
  b0_.unite_dose_max_homol_id AS unite_dose_max_homol_id_55,
  b0_.stade_limite_bbch_id AS stade_limite_bbch_id_56,
  b0_.stade_bbch_debut_application_id AS stade_bbch_debut_application_id_57,
  b0_.stade_bbch_fin_application_id AS stade_bbch_fin_application_id_58,
  b0_.etalon_dose_recommandee_id AS etalon_dose_recommandee_id_59,
  b0_.zone_vegetalisee_id AS zone_vegetalisee_id_60,
  b0_.fractionnement_unite_dose_maximale_id AS fractionnement_unite_dose_maximale_id_61,
  b0_.id_usage_ministere_id AS id_usage_ministere_id_62,
  b0_.unite_dose_mini_homol_id AS unite_dose_mini_homol_id_63,
  b0_.periode_application_id AS periode_application_id_64,
  b0_.distance_securite_riverain_id AS distance_securite_riverain_id_65,
  b0_.culture_attractive_id AS culture_attractive_id_66,
  b0_.unite_surface_maximale_id AS unite_surface_maximale_id_67,
  b0_.unite_dose_restrictive_id AS unite_dose_restrictive_id_68,
  b0_.unite_reduction_derive_id AS unite_reduction_derive_id_69
FROM
  basagri_usage b0_
  LEFT JOIN basagri_phyto b1_ ON (b1_.id = b0_.code_produit_id)
WHERE
  b0_.uuid IN ('')
ORDER BY
  b1_.nom ASC

SELECT b0_.id AS id_0, b0_.dose_maximale_homologuee AS dose_maximale_homologuee_1, b0_.znt_aquatique AS znt_aquatique_2, b0_.znt_aquatique_infos AS znt_aquatique_infos_3, b0_.znt_terrestre_cultivee AS znt_terrestre_cultivee_4, b0_.znt_terrestre_non_cultivee AS znt_terrestre_non_cultivee_5, b0_.nombre_application AS nombre_application_6, b0_.nombre_applications_infos AS nombre_applications_infos_7, b0_.information_avant_dar AS information_avant_dar_8, b0_.dar AS dar_9, b0_.information_apres_dar AS information_apres_dar_10, b0_.specification_usage AS specification_usage_11, b0_.date_debut_utilisation_usage AS date_debut_utilisation_usage_12, b0_.date_fin_utilisation_usage AS date_fin_utilisation_usage_13, b0_.mention_abeille AS mention_abeille_14, b0_.dre_animaux AS dre_animaux_15, b0_.commentaire_dre_animaux AS commentaire_dre_animaux_16, b0_.dose_recommandee_firme AS dose_recommandee_firme_17, b0_.commentaire_dose_recommandee AS commentaire_dose_recommandee_18, b0_.fractionnement AS fractionnement_19, b0_.commentaire_fractionnement AS commentaire_fractionnement_20, b0_.intervalle_application AS intervalle_application_21, b0_.commentaire_intervalle AS commentaire_intervalle_22, b0_.commentaire_znt_terrestre AS commentaire_znt_terrestre_23, b0_.fractionnement_dose_maximale AS fractionnement_dose_maximale_24, b0_.fractionnement_nombre_application_minimal AS fractionnement_nombre_application_minimal_25, b0_.fractionnement_nombre_application_maximal AS fractionnement_nombre_application_maximal_26, b0_.code_cible_ministere AS code_cible_ministere_27, b0_.uuid AS uuid_28, b0_.dose_minimale_homologuee AS dose_minimale_homologuee_29, b0_.delai_reentree_local AS delai_reentree_local_30, b0_.delai_reentree_plein_champ AS delai_reentree_plein_champ_31, b0_.date_debut_delai_grace AS date_debut_delai_grace_32, b0_.date_fin_delai_grace AS date_fin_delai_grace_33, b0_.date_debut_periode_application AS date_debut_periode_application_34, b0_.date_fin_periode_application AS date_fin_periode_application_35, b0_.date_fin_commercialisation AS date_fin_commercialisation_36, b0_.discriminant AS discriminant_37, b0_.usage_duplique AS usage_duplique_38, b0_.uuid_usage_duplique AS uuid_usage_duplique_39, b0_.utilisation_materiel_attenuation_derive AS utilisation_materiel_attenuation_derive_40, b0_.commentaire_distance_securite_riverain AS commentaire_distance_securite_riverain_41, b0_.valeur_znt_terrestre_cultivee AS valeur_znt_terrestre_cultivee_42, b0_.valeur_znt_terrestre_non_cultivee AS valeur_znt_terrestre_non_cultivee_43, b0_.intervalle_application_fractionnement AS intervalle_application_fractionnement_44, b0_.surface_maximale AS surface_maximale_45, b0_.dose_restrictive AS dose_restrictive_46, b0_.commentaire_dose_restrictive AS commentaire_dose_restrictive_47, b0_.reduction_derive AS reduction_derive_48, b0_.usage_derogatoire AS usage_derogatoire_49, b0_.duree_usage_derogatoire AS duree_usage_derogatoire_50, b0_.code_produit_id AS code_produit_id_51, b0_.culture_id AS culture_id_52, b0_.cible_id AS cible_id_53, b0_.traitement_id AS traitement_id_54, b0_.unite_dose_max_homol_id AS unite_dose_max_homol_id_55, b0_.stade_limite_bbch_id AS stade_limite_bbch_id_56, b0_.stade_bbch_debut_application_id AS stade_bbch_debut_application_id_57, b0_.stade_bbch_fin_application_id AS stade_bbch_fin_application_id_58, b0_.etalon_dose_recommandee_id AS etalon_dose_recommandee_id_59, b0_.zone_vegetalisee_id AS zone_vegetalisee_id_60, b0_.fractionnement_unite_dose_maximale_id AS fractionnement_unite_dose_maximale_id_61, b0_.id_usage_ministere_id AS id_usage_ministere_id_62, b0_.unite_dose_mini_homol_id AS unite_dose_mini_homol_id_63, b0_.periode_application_id AS periode_application_id_64, b0_.distance_securite_riverain_id AS distance_securite_riverain_id_65, b0_.culture_attractive_id AS culture_attractive_id_66, b0_.unite_surface_maximale_id AS unite_surface_maximale_id_67, b0_.unite_dose_restrictive_id AS unite_dose_restrictive_id_68, b0_.unite_reduction_derive_id AS unite_reduction_derive_id_69 FROM basagri_usage b0_ LEFT JOIN basagri_phyto b1_ ON (b1_.id = b0_.code_produit_id) WHERE b0_.uuid IN ('') ORDER BY b1_.nom ASC;

SELECT
  DISTINCT p0_.created_by AS created_by_0,
  u1_.num_certiphyto AS num_certiphyto_1
FROM
  preconisation_actualisee p0_
  LEFT JOIN `user` u1_ ON (
    CONCAT(
      u1_.first_name, ' ', u1_.last_name
    ) = p0_.created_by
    AND u1_.is_admin = 1
  )
WHERE
  p0_.visite_id = ?
GROUP BY
  p0_.created_by
ORDER BY
  p0_.created_by ASC

SELECT DISTINCT p0_.created_by AS created_by_0, u1_.num_certiphyto AS num_certiphyto_1 FROM preconisation_actualisee p0_ LEFT JOIN `user` u1_ ON (CONCAT(u1_.first_name, ' ', u1_.last_name) = p0_.created_by AND u1_.is_admin = 1) WHERE p0_.visite_id = '7979' GROUP BY p0_.created_by ORDER BY p0_.created_by ASC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.reset_token AS reset_token_5,
  t0.is_active AS is_active_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.function AS function_9,
  t0.type_certiphyto AS type_certiphyto_10,
  t0.validite_certiphyto AS validite_certiphyto_11,
  t0.mobile AS mobile_12,
  t0.phone AS phone_13,
  t0.num_certiphyto AS num_certiphyto_14,
  t0.stades_pheno AS stades_pheno_15,
  t0.p_tordeuses AS p_tordeuses_16,
  t0.movida AS movida_17,
  t0.grp_30k AS grp_30k_18,
  t0.is_admin AS is_admin_19
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.reset_token AS reset_token_5, t0.is_active AS is_active_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.function AS function_9, t0.type_certiphyto AS type_certiphyto_10, t0.validite_certiphyto AS validite_certiphyto_11, t0.mobile AS mobile_12, t0.phone AS phone_13, t0.num_certiphyto AS num_certiphyto_14, t0.stades_pheno AS stades_pheno_15, t0.p_tordeuses AS p_tordeuses_16, t0.movida AS movida_17, t0.grp_30k AS grp_30k_18, t0.is_admin AS is_admin_19 FROM `user` t0 WHERE t0.id = 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.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 = 7979;

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.main_consultant AS main_consultant_6,
  t0.property_id AS property_id_7
FROM
  visite t0
WHERE
  t0.id = ?
LIMIT
  1

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.main_consultant AS main_consultant_6, t0.property_id AS property_id_7 FROM visite t0 WHERE t0.id = '7979' LIMIT 1;

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,
  t0.main_consultant_id AS main_consultant_id_10
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, t0.main_consultant_id AS main_consultant_id_10 FROM property t0 WHERE t0.id = 390;

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

SELECT
  t0.id AS id_1,
  t0.dose_preco AS dose_preco_2,
  t0.usage_id AS usage_id_3,
  t0.uuid AS uuid_4,
  t0.client_uuid AS client_uuid_5,
  t0.preco_flash_id AS preco_flash_id_6
FROM
  preconisation_dosages t0
WHERE
  t0.preco_flash_id = ?

SELECT t0.id AS id_1, t0.dose_preco AS dose_preco_2, t0.usage_id AS usage_id_3, t0.uuid AS uuid_4, t0.client_uuid AS client_uuid_5, t0.preco_flash_id AS preco_flash_id_6 FROM preconisation_dosages t0 WHERE t0.preco_flash_id = 6206;

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.main_consultant AS main_consultant_6,
  t0.property_id AS property_id_7
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.main_consultant AS main_consultant_6, t0.property_id AS property_id_7 FROM visite t0 WHERE t0.id = '7979';