Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username_user AS username_user_2,
  t0.nom_user AS nom_user_3,
  t0.prenoms_user AS prenoms_user_4,
  t0.email_user AS email_user_5,
  t0.tel1_user AS tel1_user_6,
  t0.tel2_user AS tel2_user_7,
  t0.bp AS bp_8,
  t0.adresse_user AS adresse_user_9,
  t0.etat_user AS etat_user_10,
  t0.attempt_user AS attempt_user_11,
  t0.password_user AS password_user_12,
  t0.c_password_user AS c_password_user_13,
  t0.salt_user AS salt_user_14,
  t0.etat_connecte AS etat_connecte_15,
  t0.adresse_ip_user AS adresse_ip_user_16,
  t0.sexe_user AS sexe_user_17,
  t0.date_ajout_user AS date_ajout_user_18,
  t0.date_edit_user AS date_edit_user_19,
  t0.loss_password_url_user AS loss_password_url_user_20,
  t0.date_loss_password_user AS date_loss_password_user_21,
  t0.date_naissance AS date_naissance_22,
  t0.date_synchronisation AS date_synchronisation_23,
  t0.type_prod_user AS type_prod_user_24,
  t0.si_chef AS si_chef_25,
  t0.code_genere AS code_genere_26,
  t0.site_web AS site_web_27,
  t0.cni AS cni_28,
  t0.cout AS cout_29,
  t0.commission AS commission_30,
  t0.type_utilisateur AS type_utilisateur_31,
  t0.roles AS roles_32,
  t0.profil_id AS profil_id_33,
  t0.ville_id AS ville_id_34,
  t0.entrepot_id AS entrepot_id_35,
  t0.caisse_id AS caisse_id_36,
  t0.abonne_id AS abonne_id_37
FROM
  utilisateur t0
WHERE
  t0.username_user = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username_user AS username_user_2, t0.nom_user AS nom_user_3, t0.prenoms_user AS prenoms_user_4, t0.email_user AS email_user_5, t0.tel1_user AS tel1_user_6, t0.tel2_user AS tel2_user_7, t0.bp AS bp_8, t0.adresse_user AS adresse_user_9, t0.etat_user AS etat_user_10, t0.attempt_user AS attempt_user_11, t0.password_user AS password_user_12, t0.c_password_user AS c_password_user_13, t0.salt_user AS salt_user_14, t0.etat_connecte AS etat_connecte_15, t0.adresse_ip_user AS adresse_ip_user_16, t0.sexe_user AS sexe_user_17, t0.date_ajout_user AS date_ajout_user_18, t0.date_edit_user AS date_edit_user_19, t0.loss_password_url_user AS loss_password_url_user_20, t0.date_loss_password_user AS date_loss_password_user_21, t0.date_naissance AS date_naissance_22, t0.date_synchronisation AS date_synchronisation_23, t0.type_prod_user AS type_prod_user_24, t0.si_chef AS si_chef_25, t0.code_genere AS code_genere_26, t0.site_web AS site_web_27, t0.cni AS cni_28, t0.cout AS cout_29, t0.commission AS commission_30, t0.type_utilisateur AS type_utilisateur_31, t0.roles AS roles_32, t0.profil_id AS profil_id_33, t0.ville_id AS ville_id_34, t0.entrepot_id AS entrepot_id_35, t0.caisse_id AS caisse_id_36, t0.abonne_id AS abonne_id_37 FROM utilisateur t0 WHERE t0.username_user = 'k.akoni' LIMIT 1;

UPDATE
  localisation
SET
  date_publication = ?,
  latitude = ?,
  longitude = ?,
  type_localisation = ?,
  code_genere = ?,
  tab_polygone = ?
WHERE
  id = ?

UPDATE localisation SET date_publication = '2024-09-22 13:18:52', latitude = '8.759601083333333', longitude = '1.4603331833333333', type_localisation = '1', code_genere = 'MAP4182_11152_351', tab_polygone = '0' WHERE id = 1;

SELECT
  t0.id AS id_1,
  t0.superficie AS superficie_2,
  t0.superficie_reelle AS superficie_reelle_3,
  t0.type_parcelle AS type_parcelle_4,
  t0.code_parcelle AS code_parcelle_5,
  t0.date_publication AS date_publication_6,
  t0.etat_surface_annee AS etat_surface_annee_7,
  t0.type_main_oeuvre AS type_main_oeuvre_8,
  t0.type_culture AS type_culture_9,
  t0.type_sol AS type_sol_10,
  t0.si_pv AS si_pv_11,
  t0.si_transformation AS si_transformation_12,
  t0.code_genere AS code_genere_13,
  t0.prod_code_genere AS prod_code_genere_14,
  t0.code_surface AS code_surface_15,
  t0.si_modification AS si_modification_16,
  t0.annee_entree AS annee_entree_17,
  t0.date_plantation AS date_plantation_18,
  t0.date_recolte AS date_recolte_19,
  t0.date_visite AS date_visite_20,
  ST_AsBinary(t0.localisation) AS localisation_21,
  ST_AsBinary(t0.polygon) AS polygon_22,
  t0.si_polygon AS si_polygon_23,
  t0.anneecampagne_id AS anneecampagne_id_24,
  t0.surface_id AS surface_id_25,
  t0.produit_id AS produit_id_26,
  t0.surfaceannee_id AS surfaceannee_id_27,
  t0.utilisateur_id AS utilisateur_id_28,
  t0.abonne_id AS abonne_id_29,
  t0.producteur_id AS producteur_id_30,
  t0.ville_id AS ville_id_31
FROM
  surface_annee t0
WHERE
  t0.code_genere = ?
  AND t0.abonne_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.superficie AS superficie_2, t0.superficie_reelle AS superficie_reelle_3, t0.type_parcelle AS type_parcelle_4, t0.code_parcelle AS code_parcelle_5, t0.date_publication AS date_publication_6, t0.etat_surface_annee AS etat_surface_annee_7, t0.type_main_oeuvre AS type_main_oeuvre_8, t0.type_culture AS type_culture_9, t0.type_sol AS type_sol_10, t0.si_pv AS si_pv_11, t0.si_transformation AS si_transformation_12, t0.code_genere AS code_genere_13, t0.prod_code_genere AS prod_code_genere_14, t0.code_surface AS code_surface_15, t0.si_modification AS si_modification_16, t0.annee_entree AS annee_entree_17, t0.date_plantation AS date_plantation_18, t0.date_recolte AS date_recolte_19, t0.date_visite AS date_visite_20, ST_AsBinary(t0.localisation) AS localisation_21, ST_AsBinary(t0.polygon) AS polygon_22, t0.si_polygon AS si_polygon_23, t0.anneecampagne_id AS anneecampagne_id_24, t0.surface_id AS surface_id_25, t0.produit_id AS produit_id_26, t0.surfaceannee_id AS surfaceannee_id_27, t0.utilisateur_id AS utilisateur_id_28, t0.abonne_id AS abonne_id_29, t0.producteur_id AS producteur_id_30, t0.ville_id AS ville_id_31 FROM surface_annee t0 WHERE t0.code_genere = 'M_PROD925_1389 P2' AND t0.abonne_id = 110 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.etat_surface_abonne AS etat_surface_abonne_2,
  t0.date_publication AS date_publication_3,
  t0.si_principale AS si_principale_4,
  t0.surfaceannee_id AS surfaceannee_id_5,
  t0.abonne_id AS abonne_id_6,
  t0.partenaire_id AS partenaire_id_7
FROM
  surface_abonne t0
WHERE
  t0.abonne_id = ?
  AND t0.surfaceannee_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.etat_surface_abonne AS etat_surface_abonne_2, t0.date_publication AS date_publication_3, t0.si_principale AS si_principale_4, t0.surfaceannee_id AS surfaceannee_id_5, t0.abonne_id AS abonne_id_6, t0.partenaire_id AS partenaire_id_7 FROM surface_abonne t0 WHERE t0.abonne_id = 110 AND t0.surfaceannee_id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.date_publication AS date_publication_2,
  t0.latitude AS latitude_3,
  t0.longitude AS longitude_4,
  t0.etat_localisation AS etat_localisation_5,
  t0.type_localisation AS type_localisation_6,
  t0.code_genere AS code_genere_7,
  t0.tab_polygone AS tab_polygone_8,
  t0.fournisseur_id AS fournisseur_id_9,
  t0.producteur_id AS producteur_id_10,
  t0.producteurabonne_id AS producteurabonne_id_11,
  t0.client_id AS client_id_12,
  t0.evenement_id AS evenement_id_13,
  t0.surfaceannee_id AS surfaceannee_id_14,
  t0.surfaceabonne_id AS surfaceabonne_id_15,
  t0.plante_id AS plante_id_16,
  t0.commande_id AS commande_id_17,
  t0.entrepot_id AS entrepot_id_18,
  t0.utilisateur_id AS utilisateur_id_19,
  t0.abonne_id AS abonne_id_20,
  t0.inspectionrempli_id AS inspectionrempli_id_21
FROM
  localisation t0
WHERE
  t0.surfaceannee_id IS NULL
  AND t0.type_localisation = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date_publication AS date_publication_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.etat_localisation AS etat_localisation_5, t0.type_localisation AS type_localisation_6, t0.code_genere AS code_genere_7, t0.tab_polygone AS tab_polygone_8, t0.fournisseur_id AS fournisseur_id_9, t0.producteur_id AS producteur_id_10, t0.producteurabonne_id AS producteurabonne_id_11, t0.client_id AS client_id_12, t0.evenement_id AS evenement_id_13, t0.surfaceannee_id AS surfaceannee_id_14, t0.surfaceabonne_id AS surfaceabonne_id_15, t0.plante_id AS plante_id_16, t0.commande_id AS commande_id_17, t0.entrepot_id AS entrepot_id_18, t0.utilisateur_id AS utilisateur_id_19, t0.abonne_id AS abonne_id_20, t0.inspectionrempli_id AS inspectionrempli_id_21 FROM localisation t0 WHERE t0.surfaceannee_id IS NULL AND t0.type_localisation = '1' LIMIT 1;

"COMMIT"

"COMMIT";