Redirect 302 redirect from GET @admin_inventaire (0e3a4d)

Query Metrics

29 Database Queries
6 Different statements
6.16 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.79 ms
(61.51%)
20
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.dateupload AS dateupload_3, t0.commentaire AS commentaire_4, t0.titre AS titre_5, t0.centredetri_id AS centredetri_id_6, t0.inventaire_id AS inventaire_id_7, t0.formulairemillenium_id AS formulairemillenium_id_8, t0.suivi_photo_id AS suivi_photo_id_9 FROM photosarchives t0 WHERE t0.inventaire_id = ?
Parameters:
[
  73
]
0.99 ms
(16.06%)
5
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:
[
  24
]
0.53 ms
(8.59%)
1
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
]
0.39 ms
(6.34%)
1
SELECT i0_.id AS id_0, i0_.longueur AS longueur_1, i0_.largeur AS largeur_2, i0_.hauteur AS hauteur_3, i0_.diametre AS diametre_4, i0_.unite_diametre AS unite_diametre_5, i0_.materiaux AS materiaux_6, i0_.color1 AS color1_7, i0_.marque AS marque_8, i0_.etat AS etat_9, i0_.description AS description_10, i0_.conditionnement AS conditionnement_11, i0_.risques_precautions AS risques_precautions_12, i0_.etape AS etape_13, i0_.quantite AS quantite_14, i0_.unite_quantite AS unite_quantite_15, i0_.actions AS actions_16, i0_.localisation AS localisation_17, i0_.visuel AS visuel_18, i0_.lesvisuels AS lesvisuels_19, i0_.poids AS poids_20, i0_.quantite_reservee AS quantite_reservee_21, i0_.date_debut_reservation AS date_debut_reservation_22, i0_.date_fin_reservation AS date_fin_reservation_23, i0_.designation AS designation_24, i0_.categorie AS categorie_25, i0_.site_id AS site_id_26, i0_.provenance_id AS provenance_id_27 FROM inventaire i0_ WHERE i0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  101
  153
  262
  307
  310
  317
  352
  353
  453
  73
  74
  75
  76
  77
  78
  79
  80
  81
  82
  83
]
0.24 ms
(3.88%)
1
SELECT COUNT(i0_.id) AS sclr_0 FROM inventaire i0_
Parameters:
[]
0.22 ms
(3.61%)
1
SELECT DISTINCT i0_.id AS id_0 FROM inventaire i0_ LIMIT 20
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
  • The field App\Entity\User#panier is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Panier#proprietaire does not contain the required 'inversedBy="panier"' attribute.
App\Entity\Filiere No errors.
App\Entity\Panier No errors.
App\Entity\Suivi No errors.
App\Entity\Inventaire No errors.
App\Entity\Site No errors.
App\Entity\Evenement No errors.
App\Entity\Photosarchives No errors.
App\Entity\Reservation No errors.
App\Entity\Centredetri No errors.
App\Entity\Formulairemillenium
  • The association App\Entity\Formulairemillenium#auteur refers to the inverse side field App\Entity\User#formulaireMillenium which does not exist.
App\Entity\SuiviPhoto
  • The association App\Entity\SuiviPhoto#createdBy refers to the inverse side field App\Entity\User#suiviPhotos which does not exist.
App\Entity\Commentaire No errors.
App\Entity\Suivicentredetri No errors.
App\Entity\Client No errors.
App\Entity\Hall No errors.
App\Entity\Donation No errors.
App\Entity\Documents No errors.
App\Entity\InfosStand No errors.
App\Entity\Suivijournalierstand No errors.
App\Entity\InventaireCatalogue No errors.
App\Entity\FicheDeco No errors.