POST https://trouvascan.swack.fr/articles/nouveau

Query Metrics

10 Database Queries
10 Different statements
5.92 ms Query time
0 Invalid entities
73 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.47 ms
(58.66%)
1
"COMMIT"
Parameters:
[]
0.46 ms
(7.73%)
1
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
Parameters:
[
  b"\x01žº†ùÿrg•Áø„àëz\x06"
]
0.38 ms
(6.46%)
1
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  b"\x01ž»ÛRwzµ•g޾睊ÿ"
  "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"
  b"\x01žºƒADv\x1Ež,‹Ú]\x06š\x15"
  b"\x01žºx~±t&¡ð…n\x05½ûy"
  b"\x01žº†ùÿq£•Áø„ÝKÔC"
  b"\x01žº†ùÿrg•Áø„àëz\x06"
  null
]
0.34 ms
(5.76%)
1
SELECT MAX(a0_.reference) AS sclr_0 FROM article a0_ WHERE a0_.reference LIKE ?
Parameters:
[
  "1-2026-Q2-%"
]
0.28 ms
(4.73%)
1
"START TRANSACTION"
Parameters:
[]
0.21 ms
(3.63%)
1
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 = ?
Parameters:
[
  b"\x01žºx~±t&¡ð…n\x05½ûy"
]
0.20 ms
(3.43%)
1
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
Parameters:
[
  1
]
0.19 ms
(3.25%)
1
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
Parameters:
[
  b"\x01žºØ¦zM°£ðäÈóab"
  1
]
0.19 ms
(3.24%)
1
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
Parameters:
[
  1
]
0.18 ms
(3.11%)
1
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 = ?
Parameters:
[
  b"\x01žºƒADv\x1Ež,‹Ú]\x06š\x15"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\SousCategorieArticle 52
App\Entity\CategorieArticle 16
App\Entity\User 1
App\Entity\Site 1
App\Entity\Organisation 1
App\Entity\Abaque 1
App\Entity\Article 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Site No errors.
App\Entity\Organisation No errors.
App\Entity\Article No errors.
App\Entity\CategorieArticle No errors.
App\Entity\SousCategorieArticle No errors.
App\Entity\Abaque No errors.
App\Entity\Partenaire No errors.