Symfony Profiler

"COMMIT"

"COMMIT";

SELECT
  t0.role AS role_1,
  t0.accepte AS accepte_2,
  t0.est_parti AS est_parti_3,
  t0.salaire AS salaire_4,
  t0.matricule AS matricule_5,
  t0.la_fonction AS la_fonction_6,
  t0.categorie_emploi AS categorie_emploi_7,
  t0.la_qualification AS la_qualification_8,
  t0.departement_emploi AS departement_emploi_9,
  t0.date_de_prise_de_fonction AS date_de_prise_de_fonction_10,
  t0.igr AS igr_11,
  t0.nombre_d_enfant AS nombre_d_enfant_12,
  t0.nom_etablissement_fne AS nom_etablissement_fne_13,
  t0.nom_point_de_vente_fne AS nom_point_de_vente_fne_14,
  t0.boutique_id AS boutique_id_15,
  t0.user_id AS user_id_16
FROM
  gestock_user_boutique t0
WHERE
  t0.user_id = ?
  AND t0.boutique_id = ?
LIMIT
  1

SELECT t0.role AS role_1, t0.accepte AS accepte_2, t0.est_parti AS est_parti_3, t0.salaire AS salaire_4, t0.matricule AS matricule_5, t0.la_fonction AS la_fonction_6, t0.categorie_emploi AS categorie_emploi_7, t0.la_qualification AS la_qualification_8, t0.departement_emploi AS departement_emploi_9, t0.date_de_prise_de_fonction AS date_de_prise_de_fonction_10, t0.igr AS igr_11, t0.nombre_d_enfant AS nombre_d_enfant_12, t0.nom_etablissement_fne AS nom_etablissement_fne_13, t0.nom_point_de_vente_fne AS nom_point_de_vente_fne_14, t0.boutique_id AS boutique_id_15, t0.user_id AS user_id_16 FROM gestock_user_boutique t0 WHERE t0.user_id = 3 AND t0.boutique_id = 3 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.slug_username AS slug_username_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.id AS id_5,
  t0.email AS email_6,
  t0.email_token AS email_token_7,
  t0.nom AS nom_8,
  t0.prenom AS prenom_9,
  t0.nom_complet AS nom_complet_10,
  t0.dateNaissance AS dateNaissance_11,
  t0.contacts AS contacts_12,
  t0.adresse AS adresse_13,
  t0.matricule AS matricule_14,
  t0.salaire AS salaire_15,
  t0.numero_cnps AS numero_cnps_16,
  t0.vacataire AS vacataire_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.filename AS filename_20,
  t0.boutique_id AS boutique_id_21,
  t0.avatar_id AS avatar_id_22
FROM
  app_user t0
WHERE
  t0.id = ?

SELECT t0.slug_username AS slug_username_1, t0.username AS username_2, t0.password AS password_3, t0.roles AS roles_4, t0.id AS id_5, t0.email AS email_6, t0.email_token AS email_token_7, t0.nom AS nom_8, t0.prenom AS prenom_9, t0.nom_complet AS nom_complet_10, t0.dateNaissance AS dateNaissance_11, t0.contacts AS contacts_12, t0.adresse AS adresse_13, t0.matricule AS matricule_14, t0.salaire AS salaire_15, t0.numero_cnps AS numero_cnps_16, t0.vacataire AS vacataire_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.filename AS filename_20, t0.boutique_id AS boutique_id_21, t0.avatar_id AS avatar_id_22 FROM app_user t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.etat AS etat_2,
  t0.etat_chaine AS etat_chaine_3,
  t0.lien_pdf AS lien_pdf_4,
  t0.la_date AS la_date_5,
  t0.valable_jusqu_au AS valable_jusqu_au_6,
  t0.total_ht AS total_ht_7,
  t0.total_htapres_remise AS total_htapres_remise_8,
  t0.type_facture AS type_facture_9,
  t0.nature_facture AS nature_facture_10,
  t0.total_tva AS total_tva_11,
  t0.total_autre_taxe AS total_autre_taxe_12,
  t0.autres_taxes AS autres_taxes_13,
  t0.frais_de_port AS frais_de_port_14,
  t0.total_ttc AS total_ttc_15,
  t0.acquitee AS acquitee_16,
  t0.numero AS numero_17,
  t0.montant_paye AS montant_paye_18,
  t0.reste_apayer AS reste_apayer_19,
  t0.remise AS remise_20,
  t0.remise_pourcentage AS remise_pourcentage_21,
  t0.montant_en_lettre AS montant_en_lettre_22,
  t0.observation_sur_facture AS observation_sur_facture_23,
  t0.titre_document AS titre_document_24,
  t0.mois AS mois_25,
  t0.annee AS annee_26,
  t0.observation AS observation_27,
  t0.moyen_de_paiement AS moyen_de_paiement_28,
  t0.id_facture_de_base AS id_facture_de_base_29,
  t0.id_facture_fne AS id_facture_fne_30,
  t0.token_fne AS token_fne_31,
  t0.warning_solde_timbre_fne AS warning_solde_timbre_fne_32,
  t0.est_supprime AS est_supprime_33,
  t0.matricule_vehicule AS matricule_vehicule_34,
  t0.marque_vehicule AS marque_vehicule_35,
  t0.kilometrage_vehicule AS kilometrage_vehicule_36,
  t0.boutique_id AS boutique_id_37,
  t0.tiers_id AS tiers_id_38,
  t0.cree_par_id AS cree_par_id_39,
  t0.modifie_par_id AS modifie_par_id_40,
  t0.supprime_par_id AS supprime_par_id_41
FROM
  gestock_commande t0
WHERE
  t0.boutique_id = ?
  AND t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.etat AS etat_2, t0.etat_chaine AS etat_chaine_3, t0.lien_pdf AS lien_pdf_4, t0.la_date AS la_date_5, t0.valable_jusqu_au AS valable_jusqu_au_6, t0.total_ht AS total_ht_7, t0.total_htapres_remise AS total_htapres_remise_8, t0.type_facture AS type_facture_9, t0.nature_facture AS nature_facture_10, t0.total_tva AS total_tva_11, t0.total_autre_taxe AS total_autre_taxe_12, t0.autres_taxes AS autres_taxes_13, t0.frais_de_port AS frais_de_port_14, t0.total_ttc AS total_ttc_15, t0.acquitee AS acquitee_16, t0.numero AS numero_17, t0.montant_paye AS montant_paye_18, t0.reste_apayer AS reste_apayer_19, t0.remise AS remise_20, t0.remise_pourcentage AS remise_pourcentage_21, t0.montant_en_lettre AS montant_en_lettre_22, t0.observation_sur_facture AS observation_sur_facture_23, t0.titre_document AS titre_document_24, t0.mois AS mois_25, t0.annee AS annee_26, t0.observation AS observation_27, t0.moyen_de_paiement AS moyen_de_paiement_28, t0.id_facture_de_base AS id_facture_de_base_29, t0.id_facture_fne AS id_facture_fne_30, t0.token_fne AS token_fne_31, t0.warning_solde_timbre_fne AS warning_solde_timbre_fne_32, t0.est_supprime AS est_supprime_33, t0.matricule_vehicule AS matricule_vehicule_34, t0.marque_vehicule AS marque_vehicule_35, t0.kilometrage_vehicule AS kilometrage_vehicule_36, t0.boutique_id AS boutique_id_37, t0.tiers_id AS tiers_id_38, t0.cree_par_id AS cree_par_id_39, t0.modifie_par_id AS modifie_par_id_40, t0.supprime_par_id AS supprime_par_id_41 FROM gestock_commande t0 WHERE t0.boutique_id = 3 AND t0.id = '604' LIMIT 1;

SELECT
  t0.slug AS slug_1,
  t0.id AS id_2,
  t0.adresse AS adresse_3,
  t0.nom AS nom_4,
  t0.heure_debut_travail AS heure_debut_travail_5,
  t0.heure_fin_travail AS heure_fin_travail_6,
  t0.temps_de_travail AS temps_de_travail_7,
  t0.sigle AS sigle_8,
  t0.email AS email_9,
  t0.phone AS phone_10,
  t0.code_postal AS code_postal_11,
  t0.ville AS ville_12,
  t0.site_web AS site_web_13,
  t0.fax AS fax_14,
  t0.statut_juridique AS statut_juridique_15,
  t0.capital AS capital_16,
  t0.matricule AS matricule_17,
  t0.siret AS siret_18,
  t0.ape AS ape_19,
  t0.cc AS cc_20,
  t0.facture_tva AS facture_tva_21,
  t0.mention_legal AS mention_legal_22,
  t0.banque AS banque_23,
  t0.rib AS rib_24,
  t0.iban AS iban_25,
  t0.bic AS bic_26,
  t0.url_fnede_base AS url_fnede_base_27,
  t0.api_key_fne AS api_key_fne_28,
  t0.solde_timbre_fne AS solde_timbre_fne_29,
  t0.numero_cnps AS numero_cnps_30,
  t0.logo_id AS logo_id_31,
  t0.settings_id AS settings_id_32,
  t0.pays_id AS pays_id_33
FROM
  gestock_boutique t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.slug AS slug_1, t0.id AS id_2, t0.adresse AS adresse_3, t0.nom AS nom_4, t0.heure_debut_travail AS heure_debut_travail_5, t0.heure_fin_travail AS heure_fin_travail_6, t0.temps_de_travail AS temps_de_travail_7, t0.sigle AS sigle_8, t0.email AS email_9, t0.phone AS phone_10, t0.code_postal AS code_postal_11, t0.ville AS ville_12, t0.site_web AS site_web_13, t0.fax AS fax_14, t0.statut_juridique AS statut_juridique_15, t0.capital AS capital_16, t0.matricule AS matricule_17, t0.siret AS siret_18, t0.ape AS ape_19, t0.cc AS cc_20, t0.facture_tva AS facture_tva_21, t0.mention_legal AS mention_legal_22, t0.banque AS banque_23, t0.rib AS rib_24, t0.iban AS iban_25, t0.bic AS bic_26, t0.url_fnede_base AS url_fnede_base_27, t0.api_key_fne AS api_key_fne_28, t0.solde_timbre_fne AS solde_timbre_fne_29, t0.numero_cnps AS numero_cnps_30, t0.logo_id AS logo_id_31, t0.settings_id AS settings_id_32, t0.pays_id AS pays_id_33 FROM gestock_boutique t0 WHERE t0.slug = 'berassou-multi-services' LIMIT 1;

UPDATE
  gestock_commande
SET
  est_supprime = ?,
  supprime_par_id = ?
WHERE
  id = ?

UPDATE gestock_commande SET est_supprime = 1, supprime_par_id = 3 WHERE id = 604;