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 39900

[]

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

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

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

[
  433977
  433976
  433975
  433974
  433973
  433972
  433971
  433970
  433969
  433968
  433967
  433966
  433965
  433964
  433963
  433962
  433961
  433960
  433959
  433958
  433957
  433956
  433955
  433954
  433953
  433952
  433951
  433950
  433949
  433948
  433947
  433946
  433945
  433944
  433943
  433942
  433941
  433940
  433939
  433938
  433937
  433936
  433935
  433934
  433933
  433932
  433931
  433930
  433929
  433928
]

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 (433977, 433976, 433975, 433974, 433973, 433972, 433971, 433970, 433969, 433968, 433967, 433966, 433965, 433964, 433963, 433962, 433961, 433960, 433959, 433958, 433957, 433956, 433955, 433954, 433953, 433952, 433951, 433950, 433949, 433948, 433947, 433946, 433945, 433944, 433943, 433942, 433941, 433940, 433939, 433938, 433937, 433936, 433935, 433934, 433933, 433932, 433931, 433930, 433929, 433928) ORDER BY b0_.date DESC;