Query Metrics
8
Database Queries
7
Different statements
2.56 ms
Query time
3
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.63 ms |
SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.datedenaissance AS datedenaissance_7, t0.lieudenaissance AS lieudenaissance_8, t0.adresse AS adresse_9, t0.contact AS contact_10, t0.rib AS rib_11, t0.siret AS siret_12, t0.securitesociale AS securitesociale_13, t0.email AS email_14, t0.contacturgence AS contacturgence_15, t0.contacturgencetel AS contacturgencetel_16, t0.photo AS photo_17, t0.permis AS permis_18, t0.autres AS autres_19, t20.id AS id_21, t20.nom_structure AS nom_structure_22, t20.type_structure AS type_structure_23, t20.types_projet AS types_projet_24, t20.volume_vehicule AS volume_vehicule_25, t20.manutention AS manutention_26, t20.adresse AS adresse_27, t20.nom_contact AS nom_contact_28, t20.email_contact AS email_contact_29, t20.telephone_contact AS telephone_contact_30, t20.site_web AS site_web_31, t20.linkedin AS linkedin_32, t20.ressources AS ressources_33, t20.details AS details_34, t20.validation AS validation_35, t20.user_id AS user_id_36, t37.id AS id_38, t37.quantites AS quantites_39, t37.proprietaire_id AS proprietaire_id_40 FROM `user` t0 LEFT JOIN filiere t20 ON t20.user_id = t0.id LEFT JOIN panier t37 ON t37.proprietaire_id = t0.id WHERE t0.id = ?
Parameters:
[
12
]
|
||||||||||||||||||||||||||
| 2 | 0.26 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM site t0 WHERE t0.id = ?
Parameters:
[
"23"
]
|
||||||||||||||||||||||||||
| 3 | 0.30 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.datedebut AS datedebut_3, t0.datefin AS datefin_4, t0.montage_debut AS montage_debut_5, t0.montage_fin AS montage_fin_6, t0.exploitation_debut AS exploitation_debut_7, t0.exploitation_fin AS exploitation_fin_8, t0.demontage_debut AS demontage_debut_9, t0.demontage_fin AS demontage_fin_10, t0.lien AS lien_11, t0.reemploi AS reemploi_12, t0.suivi_biodechet AS suivi_biodechet_13, t0.inventaire_ctalogue AS inventaire_ctalogue_14, t0.leclient_id AS leclient_id_15, t0.logo_id AS logo_id_16 FROM evenement t0 WHERE t0.id = ?
Parameters:
[
"68"
]
|
||||||||||||||||||||||||||
| 4 | 0.11 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||
| 5 | 0.34 ms |
INSERT INTO inventaire (longueur, largeur, hauteur, diametre, unite_diametre, materiaux, color1, marque, etat, description, conditionnement, risques_precautions, etape, quantite, unite_quantite, actions, localisation, visuel, lesvisuels, poids, quantite_reservee, date_debut_reservation, date_fin_reservation, designation, categorie, site_id, provenance_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "0" "0" "0" "" "Millimètre" "Métal" "#563d7c" "" "Etat correct" "Récupération, tri et conditionnement en sachets" "" "" "diagnostic" "50" "unite" "Disponible" "23" null "[]" 0.0 null null null "Visserie, aimants Ø20 mm" "Métal" 23 68 ]
|
||||||||||||||||||||||||||
| 6 | 0.67 ms |
INSERT INTO photosarchives (nom, dateupload, commentaire, titre, centredetri_id, inventaire_id, formulairemillenium_id, suivi_photo_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "690b079cada90.jpg" "2025-11-05" null null null 521 null null ]
|
||||||||||||||||||||||||||
| 7 | 0.15 ms |
INSERT INTO photosarchives (nom, dateupload, commentaire, titre, centredetri_id, inventaire_id, formulairemillenium_id, suivi_photo_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "690b079cae079.jpg" "2025-11-05" null null null 521 null null ]
|
||||||||||||||||||||||||||
| 8 | 0.12 ms |
"COMMIT"
Parameters:
[]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User |
|
| App\Entity\Filiere | No errors. |
| App\Entity\Panier | No errors. |
| App\Entity\Suivi | No errors. |
| App\Entity\Inventaire | No errors. |
| App\Entity\Photosarchives | No errors. |
| App\Entity\Site | No errors. |
| App\Entity\Hall | No errors. |
| App\Entity\Client | No errors. |
| App\Entity\Evenement | No errors. |
| App\Entity\Centredetri | No errors. |
| App\Entity\Suivijournalierstand | No errors. |
| App\Entity\Commentaire | No errors. |
| App\Entity\Donation | No errors. |
| App\Entity\Documents | No errors. |
| App\Entity\InfosStand | No errors. |
| App\Entity\SuiviPhoto |
|
| App\Entity\InventaireCatalogue | No errors. |
| App\Entity\FicheDeco | No errors. |
| App\Entity\Suivicentredetri | No errors. |
| App\Entity\Reservation | No errors. |
| App\Entity\Formulairemillenium |
|