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

[]

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

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

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

[
  473898
  473897
  473896
  473895
  473894
  473893
  473892
  473891
  473890
  473889
  473888
  473887
  473886
  473885
  473884
  473883
  473882
  473881
  473880
  473879
  473878
  473877
  473876
  473875
  473874
  473873
  473872
  473871
  473870
  473869
  473868
  473867
  473866
  473865
  473864
  473863
  473862
  473861
  473860
  473859
  473858
  473857
  473856
  473855
  473854
  473853
  473852
  473851
  473850
  473849
]

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 (473898, 473897, 473896, 473895, 473894, 473893, 473892, 473891, 473890, 473889, 473888, 473887, 473886, 473885, 473884, 473883, 473882, 473881, 473880, 473879, 473878, 473877, 473876, 473875, 473874, 473873, 473872, 473871, 473870, 473869, 473868, 473867, 473866, 473865, 473864, 473863, 473862, 473861, 473860, 473859, 473858, 473857, 473856, 473855, 473854, 473853, 473852, 473851, 473850, 473849) ORDER BY b0_.date DESC;