GET https://trouvascan.swack.fr/admin?routeName=app_home

Query Metrics

7 Database Queries
7 Different statements
1.58 ms Query time
0 Invalid entities
10 Managed entities

Queries

Group similar statements

# Time Info
1 0.27 ms
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"
]
2 0.24 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM article a0_ WHERE a0_.statut = ? AND a0_.site_id = ?
Parameters:
[
  "en_stock"
  b"\x01žºƒADv\x1Ež,‹Ú]\x06š\x15"
]
3 0.24 ms
SELECT a0_.filiere AS filiere_0, COUNT(a0_.id) AS sclr_1, SUM(a0_.poids_calcule_kg) AS sclr_2 FROM article a0_ WHERE a0_.trimestre_reception = ? AND a0_.annee_reception = ? AND a0_.site_id = ? GROUP BY a0_.filiere
Parameters:
[
  2
  2026
  b"\x01žºƒADv\x1Ež,‹Ú]\x06š\x15"
]
4 0.24 ms
SELECT s0_.type_sortie AS type_sortie_0, COUNT(s0_.id) AS sclr_1 FROM sortie_article s0_ INNER JOIN article a1_ ON s0_.article_id = a1_.id WHERE s0_.trimestre_sortie = ? AND s0_.annee_sortie = ? AND a1_.site_id = ? GROUP BY s0_.type_sortie
Parameters:
[
  2
  2026
  b"\x01žºƒADv\x1Ež,‹Ú]\x06š\x15"
]
5 0.23 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.filiere AS filiere_3, t0.type_apport AS type_apport_4, t0.methode_saisie AS methode_saisie_5, t0.poids_kg AS poids_kg_6, t0.quantite AS quantite_7, t0.poids_calcule_kg AS poids_calcule_kg_8, t0.description AS description_9, t0.prix_estime AS prix_estime_10, t0.chemin_photo AS chemin_photo_11, t0.statut AS statut_12, t0.etiquette_imprimee AS etiquette_imprimee_13, t0.date_reception AS date_reception_14, t0.trimestre_reception AS trimestre_reception_15, t0.annee_reception AS annee_reception_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.site_id AS site_id_19, t0.cree_par_id AS cree_par_id_20, t0.categorie_id AS categorie_id_21, t0.sous_categorie_id AS sous_categorie_id_22, t0.partenaire_id AS partenaire_id_23, t24.id AS id_25, t24.type_sortie AS type_sortie_26, t24.date_sortie AS date_sortie_27, t24.trimestre_sortie AS trimestre_sortie_28, t24.annee_sortie AS annee_sortie_29, t24.type_dea AS type_dea_30, t24.created_at AS created_at_31, t24.article_id AS article_id_32, t24.enregistre_par_id AS enregistre_par_id_33 FROM article t0 LEFT JOIN sortie_article t24 ON t24.article_id = t0.id WHERE t0.site_id = ? ORDER BY t0.created_at DESC LIMIT 8
Parameters:
[
  b"\x01žºƒADv\x1Ež,‹Ú]\x06š\x15"
]
6 0.18 ms
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"
]
7 0.18 ms
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.id = ?
Parameters:
[
  b"\x01žº†ùütغÛ3K5ù3²"
]

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\Article 2
App\Entity\SousCategorieArticle 2
App\Entity\SortieArticle 2
App\Entity\User 1
App\Entity\Site 1
App\Entity\CategorieArticle 1
App\Entity\Organisation 1

Entities Mapping

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