Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation 11
• Security
• Twig
• HTTP Client
• Doctrine 2
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• Configuration

Query Metrics

SELECT DISTINCT s0_.id AS id_0 FROM suivi_photo s0_ LIMIT 100 OFFSET 200

[]

SELECT
  DISTINCT s0_.id AS id_0
FROM
  suivi_photo s0_
LIMIT
  100 OFFSET 200

SELECT DISTINCT s0_.id AS id_0 FROM suivi_photo s0_ LIMIT 100 OFFSET 200;

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 = ?

[
  21
]

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 = ?

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 = 21;

SELECT s0_.id AS id_0, s0_.type_localisation AS type_localisation_1, s0_.localisation AS localisation_2, s0_.commentaire AS commentaire_3, s0_.date_creation AS date_creation_4, s0_.evenement_id AS evenement_id_5, s0_.created_by_id AS created_by_id_6 FROM suivi_photo s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  167
  168
  169
  170
  171
  172
  173
  174
  175
  176
  177
  178
  179
  180
  181
  182
  183
  184
  185
  186
  187
  188
  189
  190
  191
  192
  193
  194
  195
  196
  197
  198
  199
  200
  201
  202
  204
  205
  206
  207
  208
  209
  210
  211
  212
  213
  214
  215
  216
  217
  218
  219
  220
  221
  223
  224
  226
  227
  228
  230
  231
  233
  234
  235
  236
  237
  239
  240
  241
  242
  244
  245
  246
  247
  248
  249
  251
  252
  253
  254
  255
  256
  260
  261
  265
  269
  270
  271
  272
  273
  274
  275
  276
  277
  278
  279
  280
  281
  282
  283
]

SELECT
  s0_.id AS id_0,
  s0_.type_localisation AS type_localisation_1,
  s0_.localisation AS localisation_2,
  s0_.commentaire AS commentaire_3,
  s0_.date_creation AS date_creation_4,
  s0_.evenement_id AS evenement_id_5,
  s0_.created_by_id AS created_by_id_6
FROM
  suivi_photo s0_
WHERE
  s0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT s0_.id AS id_0, s0_.type_localisation AS type_localisation_1, s0_.localisation AS localisation_2, s0_.commentaire AS commentaire_3, s0_.date_creation AS date_creation_4, s0_.evenement_id AS evenement_id_5, s0_.created_by_id AS created_by_id_6 FROM suivi_photo s0_ WHERE s0_.id IN (167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 223, 224, 226, 227, 228, 230, 231, 233, 234, 235, 236, 237, 239, 240, 241, 242, 244, 245, 246, 247, 248, 249, 251, 252, 253, 254, 255, 256, 260, 261, 265, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283);

SELECT COUNT(s0_.id) AS sclr_0 FROM suivi_photo s0_

[]

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  suivi_photo s0_

SELECT COUNT(s0_.id) AS sclr_0 FROM suivi_photo s0_;

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 = ?

[
  54
]

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 = ?

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 = 54;