Symfony Profiler

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

Query Metrics

SELECT count(DISTINCT b0_.id) AS sclr_0 FROM ban b0_

[]

SELECT
  count(DISTINCT b0_.id) AS sclr_0
FROM
  ban b0_

SELECT count(DISTINCT b0_.id) AS sclr_0 FROM ban b0_;

SELECT DISTINCT b0_.id AS id_0, b0_.date AS date_1 FROM ban b0_ ORDER BY b0_.date DESC LIMIT 50 OFFSET 46550

[]

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.date AS date_1
FROM
  ban b0_
ORDER BY
  b0_.date DESC
LIMIT
  50
OFFSET
  46550

SELECT DISTINCT b0_.id AS id_0, b0_.date AS date_1 FROM ban b0_ ORDER BY b0_.date DESC LIMIT 50 OFFSET 46550;

SELECT b0_.id AS id_0, b0_.ip AS ip_1, b0_.port AS port_2, b0_.action AS action_3, b0_.type AS type_4, b0_.fai AS fai_5, b0_.city AS city_6, b0_.country AS country_7, b0_.continent AS continent_8, b0_.date AS date_9, b0_.lastdate AS lastdate_10 FROM ban b0_ WHERE b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.date DESC

[
  427327
  427326
  427325
  427324
  427323
  427322
  427321
  427320
  427319
  427318
  427317
  427316
  427315
  427314
  427313
  427312
  427311
  427310
  427309
  427308
  427307
  427306
  427305
  427304
  427303
  427302
  427301
  427300
  427299
  427298
  427297
  427296
  427295
  427294
  427293
  427292
  427291
  427290
  427289
  427288
  427287
  427286
  427285
  427284
  427283
  427282
  427281
  427280
  427279
  427278
]

SELECT
  b0_.id AS id_0,
  b0_.ip AS ip_1,
  b0_.port AS port_2,
  b0_.action AS action_3,
  b0_.type AS type_4,
  b0_.fai AS fai_5,
  b0_.city AS city_6,
  b0_.country AS country_7,
  b0_.continent AS continent_8,
  b0_.date AS date_9,
  b0_.lastdate AS lastdate_10
FROM
  ban b0_
WHERE
  b0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  b0_.date DESC

SELECT b0_.id AS id_0, b0_.ip AS ip_1, b0_.port AS port_2, b0_.action AS action_3, b0_.type AS type_4, b0_.fai AS fai_5, b0_.city AS city_6, b0_.country AS country_7, b0_.continent AS continent_8, b0_.date AS date_9, b0_.lastdate AS lastdate_10 FROM ban b0_ WHERE b0_.id IN (427327, 427326, 427325, 427324, 427323, 427322, 427321, 427320, 427319, 427318, 427317, 427316, 427315, 427314, 427313, 427312, 427311, 427310, 427309, 427308, 427307, 427306, 427305, 427304, 427303, 427302, 427301, 427300, 427299, 427298, 427297, 427296, 427295, 427294, 427293, 427292, 427291, 427290, 427289, 427288, 427287, 427286, 427285, 427284, 427283, 427282, 427281, 427280, 427279, 427278) ORDER BY b0_.date DESC;