Query Metrics

24 Database Queries
5 Different statements
17.77 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.90 ms
SELECT DISTINCT f0_.id AS id_0 FROM formulairemillenium f0_ LIMIT 20 OFFSET 1660
Parameters:
[]
2 1.02 ms
SELECT f0_.id AS id_0, f0_.date AS date_1, f0_.site AS site_2, f0_.salon AS salon_3, f0_.bouteille_plastique AS bouteille_plastique_4, f0_.bouteille_plastique_nombre AS bouteille_plastique_nombre_5, f0_.bouteille_plastique_type_contenant AS bouteille_plastique_type_contenant_6, f0_.bouteille_plastique_poids AS bouteille_plastique_poids_7, f0_.canettes AS canettes_8, f0_.canettes_nombre AS canettes_nombre_9, f0_.canettes_type_contenant AS canettes_type_contenant_10, f0_.canettes_poids AS canettes_poids_11, f0_.verre AS verre_12, f0_.verre_nombre AS verre_nombre_13, f0_.verre_type_contenant AS verre_type_contenant_14, f0_.verre_poids AS verre_poids_15, f0_.papier_catalogues AS papier_catalogues_16, f0_.papier_catalogues_nombre AS papier_catalogues_nombre_17, f0_.papier_catalogues_type_contenant AS papier_catalogues_type_contenant_18, f0_.papier_catalogues_poids AS papier_catalogues_poids_19, f0_.plastique_souple AS plastique_souple_20, f0_.plastique_souple_nombre AS plastique_souple_nombre_21, f0_.plastique_souple_type_contenant AS plastique_souple_type_contenant_22, f0_.plastique_souple_poids AS plastique_souple_poids_23, f0_.autres AS autres_24, f0_.autres_nombre AS autres_nombre_25, f0_.autres_type_contenant AS autres_type_contenant_26, f0_.autres_poids AS autres_poids_27, f0_.dr AS dr_28, f0_.dr_nombre AS dr_nombre_29, f0_.dr_type_contenant AS dr_type_contenant_30, f0_.dr_poids AS dr_poids_31, f0_.bois AS bois_32, f0_.bois_nombre AS bois_nombre_33, f0_.bois_type_contenant AS bois_type_contenant_34, f0_.bois_poids AS bois_poids_35, f0_.moquette AS moquette_36, f0_.moquette_nombre AS moquette_nombre_37, f0_.moquette_type_contenant AS moquette_type_contenant_38, f0_.moquette_poids AS moquette_poids_39, f0_.carton AS carton_40, f0_.carton_nombre AS carton_nombre_41, f0_.carton_type_contenant AS carton_type_contenant_42, f0_.carton_poids AS carton_poids_43, f0_.metal AS metal_44, f0_.metal_nombre AS metal_nombre_45, f0_.metal_type_contenant AS metal_type_contenant_46, f0_.metal_poids AS metal_poids_47, f0_.coton_gratte AS coton_gratte_48, f0_.coton_gratte_nombre AS coton_gratte_nombre_49, f0_.coton_gratte_type_contenant AS coton_gratte_type_contenant_50, f0_.coton_gratte_poids AS coton_gratte_poids_51, f0_.gravats AS gravats_52, f0_.gravats_nombre AS gravats_nombre_53, f0_.gravats_type_contenant AS gravats_type_contenant_54, f0_.gravats_poids AS gravats_poids_55, f0_.biodechets AS biodechets_56, f0_.biodechets_nombre AS biodechets_nombre_57, f0_.biodechets_type_contenant AS biodechets_type_contenant_58, f0_.biodechets_poids AS biodechets_poids_59, f0_.trois_f AS trois_f_60, f0_.trois_fnombre AS trois_fnombre_61, f0_.trois_ftype_contenant AS trois_ftype_contenant_62, f0_.trois_fpoids AS trois_fpoids_63, f0_.hall AS hall_64, f0_.auteur_id AS auteur_id_65 FROM formulairemillenium f0_ WHERE f0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1395
  1396
  1397
  1398
  1399
  1400
  1401
  1402
  1514
  1515
  1516
  1539
  1540
  1541
  1542
  1705
  1706
  1707
  1708
  1709
]
3 0.65 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM formulairemillenium f0_
Parameters:
[]
4 0.66 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:
[
  68
]
5 0.47 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.formulairemillenium_id = ?
Parameters:
[
  1395
]
6 0.41 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.formulairemillenium_id = ?
Parameters:
[
  1396
]
7 0.40 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.formulairemillenium_id = ?
Parameters:
[
  1397
]
8 0.37 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.formulairemillenium_id = ?
Parameters:
[
  1398
]
9 0.49 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.formulairemillenium_id = ?
Parameters:
[
  1399
]
10 0.40 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.formulairemillenium_id = ?
Parameters:
[
  1400
]
11 0.34 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.formulairemillenium_id = ?
Parameters:
[
  1401
]
12 0.33 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.formulairemillenium_id = ?
Parameters:
[
  1402
]
13 0.39 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.formulairemillenium_id = ?
Parameters:
[
  1514
]
14 0.44 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.formulairemillenium_id = ?
Parameters:
[
  1515
]
15 0.33 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.formulairemillenium_id = ?
Parameters:
[
  1516
]
16 0.90 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.formulairemillenium_id = ?
Parameters:
[
  1539
]
17 0.39 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.formulairemillenium_id = ?
Parameters:
[
  1540
]
18 0.41 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.formulairemillenium_id = ?
Parameters:
[
  1541
]
19 6.96 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.formulairemillenium_id = ?
Parameters:
[
  1542
]
20 0.37 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.formulairemillenium_id = ?
Parameters:
[
  1705
]
21 0.35 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.formulairemillenium_id = ?
Parameters:
[
  1706
]
22 0.33 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.formulairemillenium_id = ?
Parameters:
[
  1707
]
23 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.formulairemillenium_id = ?
Parameters:
[
  1708
]
24 0.23 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.formulairemillenium_id = ?
Parameters:
[
  1709
]

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\Formulairemillenium
  • The association App\Entity\Formulairemillenium#auteur refers to the inverse side field App\Entity\User#formulaireMillenium which does not exist.
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\Photosarchives No errors.
App\Entity\Filiere No errors.
App\Entity\Panier No errors.
App\Entity\Suivi No errors.
App\Entity\Centredetri No errors.
App\Entity\Inventaire No errors.
App\Entity\SuiviPhoto
  • The association App\Entity\SuiviPhoto#createdBy refers to the inverse side field App\Entity\User#suiviPhotos which does not exist.