Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.prenom AS prenom_5,
  t0.nom AS nom_6,
  t0.actif AS actif_7,
  t0.created_at AS created_at_8,
  t0.site_id AS site_id_9
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.prenom AS prenom_5, t0.nom AS nom_6, t0.actif AS actif_7, t0.created_at AS created_at_8, t0.site_id AS site_id_9 FROM `user` t0 WHERE t0.id = 0x019EBA787EB17426A1F0856E05BDFB79;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.adresse AS adresse_4,
  t0.code_postal AS code_postal_5,
  t0.ville AS ville_6,
  t0.actif AS actif_7,
  t0.imprimante_ip AS imprimante_ip_8,
  t0.imprimante_port AS imprimante_port_9,
  t0.created_at AS created_at_10,
  t0.organisation_id AS organisation_id_11
FROM
  site t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.adresse AS adresse_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.actif AS actif_7, t0.imprimante_ip AS imprimante_ip_8, t0.imprimante_port AS imprimante_port_9, t0.created_at AS created_at_10, t0.organisation_id AS organisation_id_11 FROM site t0 WHERE t0.id = 0x019EBA834144761E9E2C8BDA5D069A15;

SELECT
  t0.id AS id_1,
  t0.filiere AS filiere_2,
  t0.code AS code_3,
  t0.libelle AS libelle_4,
  t0.ordre AS ordre_5,
  t0.actif AS actif_6
FROM
  categorie_article t0
WHERE
  t0.actif = ?
ORDER BY
  t0.filiere ASC,
  t0.ordre ASC

SELECT t0.id AS id_1, t0.filiere AS filiere_2, t0.code AS code_3, t0.libelle AS libelle_4, t0.ordre AS ordre_5, t0.actif AS actif_6 FROM categorie_article t0 WHERE t0.actif = 1 ORDER BY t0.filiere ASC, t0.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.ordre AS ordre_4,
  t0.actif AS actif_5,
  t0.categorie_id AS categorie_id_6
FROM
  sous_categorie_article t0
WHERE
  t0.actif = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.ordre AS ordre_4, t0.actif AS actif_5, t0.categorie_id AS categorie_id_6 FROM sous_categorie_article t0 WHERE t0.actif = 1 ORDER BY t0.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.nom AS nom_3,
  t0.adresse AS adresse_4,
  t0.complement_adresse AS complement_adresse_5,
  t0.code_postal AS code_postal_6,
  t0.ville AS ville_7,
  t0.actif AS actif_8,
  t0.filieres AS filieres_9,
  t0.collecte_remuneree AS collecte_remuneree_10,
  t0.date_debut_convention AS date_debut_convention_11,
  t0.date_fin_convention AS date_fin_convention_12,
  t0.chemin_convention AS chemin_convention_13,
  t0.type_entreprise AS type_entreprise_14,
  t0.type_apport_entreprise AS type_apport_entreprise_15,
  t0.mise_en_relation_ecomaison AS mise_en_relation_ecomaison_16,
  t0.id_ecomaison AS id_ecomaison_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.organisation_id AS organisation_id_20
FROM
  partenaire t0
WHERE
  t0.organisation_id = ?
  AND t0.actif = ?
ORDER BY
  t0.nom ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.nom AS nom_3, t0.adresse AS adresse_4, t0.complement_adresse AS complement_adresse_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.actif AS actif_8, t0.filieres AS filieres_9, t0.collecte_remuneree AS collecte_remuneree_10, t0.date_debut_convention AS date_debut_convention_11, t0.date_fin_convention AS date_fin_convention_12, t0.chemin_convention AS chemin_convention_13, t0.type_entreprise AS type_entreprise_14, t0.type_apport_entreprise AS type_apport_entreprise_15, t0.mise_en_relation_ecomaison AS mise_en_relation_ecomaison_16, t0.id_ecomaison AS id_ecomaison_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.organisation_id AS organisation_id_20 FROM partenaire t0 WHERE t0.organisation_id = 0x019EBA81D8A67A4DB0A3F0E4C8F36162 AND t0.actif = 1 ORDER BY t0.nom ASC;

SELECT
  t0.id AS id_1,
  t0.poids_moyen_kg AS poids_moyen_kg_2,
  t0.date_application AS date_application_3,
  t0.source AS source_4,
  t0.sous_categorie_id AS sous_categorie_id_5
FROM
  abaque t0
WHERE
  t0.sous_categorie_id = ?
ORDER BY
  t0.date_application DESC

SELECT t0.id AS id_1, t0.poids_moyen_kg AS poids_moyen_kg_2, t0.date_application AS date_application_3, t0.source AS source_4, t0.sous_categorie_id AS sous_categorie_id_5 FROM abaque t0 WHERE t0.sous_categorie_id = 0x019EBA86F9FF726795C1F884E0EB7A06 ORDER BY t0.date_application DESC;

SELECT
  MAX(a0_.reference) AS sclr_0
FROM
  article a0_
WHERE
  a0_.reference LIKE ?

SELECT MAX(a0_.reference) AS sclr_0 FROM article a0_ WHERE a0_.reference LIKE '1-2026-Q2-%';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO article (
  id, reference, filiere, type_apport,
  methode_saisie, poids_kg, quantite,
  poids_calcule_kg, description, prix_estime,
  chemin_photo, statut, etiquette_imprimee,
  date_reception, trimestre_reception,
  annee_reception, created_at, updated_at,
  site_id, cree_par_id, categorie_id,
  sous_categorie_id, partenaire_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO article (id, reference, filiere, type_apport, methode_saisie, poids_kg, quantite, poids_calcule_kg, description, prix_estime, chemin_photo, statut, etiquette_imprimee, date_reception, trimestre_reception, annee_reception, created_at, updated_at, site_id, cree_par_id, categorie_id, sous_categorie_id, partenaire_id) VALUES (0x019EBBDB52777AB59567DEBEEFAAA9FF, '1-2026-Q2-00003', 'brico_jardin', 'AV', 'comptee', NULL, 2, '16.000', NULL, '30.00', NULL, 'en_stock', 0, '2026-06-12', 2, 2026, '2026-06-12 12:42:53', '2026-06-12 12:42:53', 0x019EBA834144761E9E2C8BDA5D069A15, 0x019EBA787EB17426A1F0856E05BDFB79, 0x019EBA86F9FF71A395C1F884DD4BD443, 0x019EBA86F9FF726795C1F884E0EB7A06, NULL);

"COMMIT"

"COMMIT";