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 33950

[]

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

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

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

[
  439927
  439926
  439925
  439924
  439923
  439922
  439921
  439920
  439919
  439918
  439917
  439916
  439915
  439914
  439913
  439912
  439911
  439910
  439909
  439908
  439907
  439906
  439905
  439904
  439903
  439902
  439901
  439900
  439899
  439898
  439897
  439896
  439895
  439894
  439893
  439892
  439891
  439890
  439889
  439888
  439887
  439886
  439885
  439884
  439883
  439882
  439881
  439880
  439879
  439878
]

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 (439927, 439926, 439925, 439924, 439923, 439922, 439921, 439920, 439919, 439918, 439917, 439916, 439915, 439914, 439913, 439912, 439911, 439910, 439909, 439908, 439907, 439906, 439905, 439904, 439903, 439902, 439901, 439900, 439899, 439898, 439897, 439896, 439895, 439894, 439893, 439892, 439891, 439890, 439889, 439888, 439887, 439886, 439885, 439884, 439883, 439882, 439881, 439880, 439879, 439878) ORDER BY b0_.date DESC;