GET https://bereup.online/admin?crudAction=index&crudControllerFqcn=App%5CController%5CAdmin%5CInventaireCrudController&entityId=240&page=5

Response
200 OK
IP
2a03:2880:f806:4a::
Profiled on
Token
ef8854

Query Metrics

25 Database Queries
6 Different statements
5.83 ms Query time
2 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.49 ms 
SELECT t0.id AS id_1, t0.longueur AS longueur_2, t0.largeur AS largeur_3, t0.hauteur AS hauteur_4, t0.diametre AS diametre_5, t0.unite_diametre AS unite_diametre_6, t0.materiaux AS materiaux_7, t0.color1 AS color1_8, t0.marque AS marque_9, t0.etat AS etat_10, t0.description AS description_11, t0.conditionnement AS conditionnement_12, t0.risques_precautions AS risques_precautions_13, t0.etape AS etape_14, t0.quantite AS quantite_15, t0.unite_quantite AS unite_quantite_16, t0.actions AS actions_17, t0.localisation AS localisation_18, t0.visuel AS visuel_19, t0.lesvisuels AS lesvisuels_20, t0.poids AS poids_21, t0.quantite_reservee AS quantite_reservee_22, t0.date_debut_reservation AS date_debut_reservation_23, t0.date_fin_reservation AS date_fin_reservation_24, t0.designation AS designation_25, t0.categorie AS categorie_26, t0.site_id AS site_id_27, t0.provenance_id AS provenance_id_28 FROM inventaire t0 WHERE t0.id = ?
Parameters: 
[
  "240"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.26 ms 
SELECT DISTINCT i0_.id AS id_0 FROM inventaire i0_ LIMIT 20 OFFSET 80
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.44 ms 
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: 
[
  47
  48
  49
  50
  51
  56
  57
  58
  59
  60
  61
  62
  63
  64
  65
  66
  67
  68
  69
  70
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.27 ms 
SELECT COUNT(i0_.id) AS sclr_0 FROM inventaire i0_
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.30 ms 
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: 
[
  47
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.32 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: 
[
  22
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.27 ms 
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: 
[
  48
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.24 ms 
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: 
[
  49
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.21 ms 
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: 
[
  50
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.21 ms 
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: 
[
  51
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.21 ms 
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: 
[
  56
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.20 ms 
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: 
[
  57
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.21 ms 
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: 
[
  58
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.18 ms 
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: 
[
  59
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.17 ms 
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: 
[
  60
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.17 ms 
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: 
[
  61
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.19 ms 
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: 
[
  62
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.18 ms 
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: 
[
  63
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.18 ms 
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: 
[
  64
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.17 ms 
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: 
[
  65
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.22 ms 
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: 
[
  66
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.19 ms 
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: 
[
  67
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.18 ms 
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: 
[
  68
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.18 ms 
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: 
[
  69
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.19 ms 
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: 
[
  70
]
View formatted query    View runnable query    Explain query    View query backtrace

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\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\Panier 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\Suivi No errors.
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.