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 43750

[]

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

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

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

[
  429782
  429781
  429780
  429779
  429778
  429777
  429776
  429775
  429774
  429773
  429772
  429771
  429770
  429769
  429768
  429767
  429766
  429765
  429764
  429763
  429762
  429761
  429760
  429759
  429758
  429757
  429756
  429755
  429754
  429753
  429752
  429751
  429750
  429749
  429748
  429747
  429746
  429745
  429744
  429743
  429742
  429741
  429740
  429739
  429738
  429737
  429736
  429735
  429734
  429733
]

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 (429782, 429781, 429780, 429779, 429778, 429777, 429776, 429775, 429774, 429773, 429772, 429771, 429770, 429769, 429768, 429767, 429766, 429765, 429764, 429763, 429762, 429761, 429760, 429759, 429758, 429757, 429756, 429755, 429754, 429753, 429752, 429751, 429750, 429749, 429748, 429747, 429746, 429745, 429744, 429743, 429742, 429741, 429740, 429739, 429738, 429737, 429736, 429735, 429734, 429733) ORDER BY b0_.date DESC;