Query Metrics
4
Database Queries
4
Different statements
2.94 ms
Query time
3
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.55 ms (52.79%) |
1 |
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.dateupload AS dateupload_2, p0_.commentaire AS commentaire_3, p0_.titre AS titre_4, p0_.centredetri_id AS centredetri_id_5, p0_.inventaire_id AS inventaire_id_6, p0_.formulairemillenium_id AS formulairemillenium_id_7, p0_.suivi_photo_id AS suivi_photo_id_8 FROM photosarchives p0_
Parameters:
[] |
0.66 ms (22.48%) |
1 |
SELECT t0.id AS id_1, t0.date AS date_2, t0.site AS site_3, t0.salon AS salon_4, t0.bouteille_plastique AS bouteille_plastique_5, t0.bouteille_plastique_nombre AS bouteille_plastique_nombre_6, t0.bouteille_plastique_type_contenant AS bouteille_plastique_type_contenant_7, t0.bouteille_plastique_poids AS bouteille_plastique_poids_8, t0.canettes AS canettes_9, t0.canettes_nombre AS canettes_nombre_10, t0.canettes_type_contenant AS canettes_type_contenant_11, t0.canettes_poids AS canettes_poids_12, t0.verre AS verre_13, t0.verre_nombre AS verre_nombre_14, t0.verre_type_contenant AS verre_type_contenant_15, t0.verre_poids AS verre_poids_16, t0.papier_catalogues AS papier_catalogues_17, t0.papier_catalogues_nombre AS papier_catalogues_nombre_18, t0.papier_catalogues_type_contenant AS papier_catalogues_type_contenant_19, t0.papier_catalogues_poids AS papier_catalogues_poids_20, t0.plastique_souple AS plastique_souple_21, t0.plastique_souple_nombre AS plastique_souple_nombre_22, t0.plastique_souple_type_contenant AS plastique_souple_type_contenant_23, t0.plastique_souple_poids AS plastique_souple_poids_24, t0.autres AS autres_25, t0.autres_nombre AS autres_nombre_26, t0.autres_type_contenant AS autres_type_contenant_27, t0.autres_poids AS autres_poids_28, t0.dr AS dr_29, t0.dr_nombre AS dr_nombre_30, t0.dr_type_contenant AS dr_type_contenant_31, t0.dr_poids AS dr_poids_32, t0.bois AS bois_33, t0.bois_nombre AS bois_nombre_34, t0.bois_type_contenant AS bois_type_contenant_35, t0.bois_poids AS bois_poids_36, t0.moquette AS moquette_37, t0.moquette_nombre AS moquette_nombre_38, t0.moquette_type_contenant AS moquette_type_contenant_39, t0.moquette_poids AS moquette_poids_40, t0.carton AS carton_41, t0.carton_nombre AS carton_nombre_42, t0.carton_type_contenant AS carton_type_contenant_43, t0.carton_poids AS carton_poids_44, t0.metal AS metal_45, t0.metal_nombre AS metal_nombre_46, t0.metal_type_contenant AS metal_type_contenant_47, t0.metal_poids AS metal_poids_48, t0.coton_gratte AS coton_gratte_49, t0.coton_gratte_nombre AS coton_gratte_nombre_50, t0.coton_gratte_type_contenant AS coton_gratte_type_contenant_51, t0.coton_gratte_poids AS coton_gratte_poids_52, t0.gravats AS gravats_53, t0.gravats_nombre AS gravats_nombre_54, t0.gravats_type_contenant AS gravats_type_contenant_55, t0.gravats_poids AS gravats_poids_56, t0.biodechets AS biodechets_57, t0.biodechets_nombre AS biodechets_nombre_58, t0.biodechets_type_contenant AS biodechets_type_contenant_59, t0.biodechets_poids AS biodechets_poids_60, t0.trois_f AS trois_f_61, t0.trois_fnombre AS trois_fnombre_62, t0.trois_ftype_contenant AS trois_ftype_contenant_63, t0.trois_fpoids AS trois_fpoids_64, t0.hall AS hall_65, t0.auteur_id AS auteur_id_66 FROM formulairemillenium t0 WHERE t0.id = ?
Parameters:
[
"169"
]
|
0.48 ms (16.27%) |
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:
[
66
]
|
0.25 ms (8.46%) |
1 |
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:
[
169
]
|
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 |
|
App\Entity\User |
|
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 |
|
App\Entity\Commentaire | No errors. |
App\Entity\Suivicentredetri | No errors. |