Symfony Profiler

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

Query Metrics

SELECT DISTINCT s0_.id AS id_0, s0_.subscribed_at AS subscribed_at_1 FROM subscriber s0_ ORDER BY s0_.subscribed_at DESC LIMIT 20

[]

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.subscribed_at AS subscribed_at_1
FROM
  subscriber s0_
ORDER BY
  s0_.subscribed_at DESC
LIMIT
  20

SELECT DISTINCT s0_.id AS id_0, s0_.subscribed_at AS subscribed_at_1 FROM subscriber s0_ ORDER BY s0_.subscribed_at DESC LIMIT 20;

SELECT s0_.id AS id_0, s0_.email AS email_1, s0_.name AS name_2, s0_.subscribed_at AS subscribed_at_3, s0_.is_confirmed AS is_confirmed_4, s0_.confirmed_at AS confirmed_at_5, s0_.source AS source_6, s0_.unsubscribed_at AS unsubscribed_at_7, s0_.locale AS locale_8, s0_.notes AS notes_9, s0_.ip_address AS ip_address_10, s0_.country AS country_11, s0_.timezone AS timezone_12 FROM subscriber s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.subscribed_at DESC

[
  45
  46
  50
  21
  8
  20
  1
  39
  34
  35
  28
  24
  25
  12
  27
  23
  10
  7
  30
  43
]

SELECT
  s0_.id AS id_0,
  s0_.email AS email_1,
  s0_.name AS name_2,
  s0_.subscribed_at AS subscribed_at_3,
  s0_.is_confirmed AS is_confirmed_4,
  s0_.confirmed_at AS confirmed_at_5,
  s0_.source AS source_6,
  s0_.unsubscribed_at AS unsubscribed_at_7,
  s0_.locale AS locale_8,
  s0_.notes AS notes_9,
  s0_.ip_address AS ip_address_10,
  s0_.country AS country_11,
  s0_.timezone AS timezone_12
FROM
  subscriber s0_
WHERE
  s0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  s0_.subscribed_at DESC

SELECT s0_.id AS id_0, s0_.email AS email_1, s0_.name AS name_2, s0_.subscribed_at AS subscribed_at_3, s0_.is_confirmed AS is_confirmed_4, s0_.confirmed_at AS confirmed_at_5, s0_.source AS source_6, s0_.unsubscribed_at AS unsubscribed_at_7, s0_.locale AS locale_8, s0_.notes AS notes_9, s0_.ip_address AS ip_address_10, s0_.country AS country_11, s0_.timezone AS timezone_12 FROM subscriber s0_ WHERE s0_.id IN (45, 46, 50, 21, 8, 20, 1, 39, 34, 35, 28, 24, 25, 12, 27, 23, 10, 7, 30, 43) ORDER BY s0_.subscribed_at DESC;

SELECT count(*) AS sclr_0 FROM subscriber s0_

[]

SELECT
  count(*) AS sclr_0
FROM
  subscriber s0_

SELECT count(*) AS sclr_0 FROM subscriber s0_;

SELECT COUNT(*) FROM post t0 WHERE t0.status = ?

[
  "draft"
]

SELECT
  COUNT(*)
FROM
  post t0
WHERE
  t0.status = ?

SELECT COUNT(*) FROM post t0 WHERE t0.status = 'draft';

SELECT COUNT(*) FROM comment t0 WHERE t0.status = ?

[
  "pending"
]

SELECT
  COUNT(*)
FROM
  comment t0
WHERE
  t0.status = ?

SELECT COUNT(*) FROM comment t0 WHERE t0.status = 'pending';

SELECT COUNT(*) FROM subscriber t0 WHERE t0.is_confirmed = ?

[
  0
]

SELECT
  COUNT(*)
FROM
  subscriber t0
WHERE
  t0.is_confirmed = ?

SELECT COUNT(*) FROM subscriber t0 WHERE t0.is_confirmed = 0;