Symfony Profiler

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

Query Metrics

SELECT COUNT(*) FROM documents d JOIN volumes v ON v.id = d.volume_id AND v.status = 'opublikowany'

[]

SELECT
  COUNT(*)
FROM
  documents d
  JOIN volumes v ON v.id = d.volume_id
  AND v.status = 'opublikowany'

SELECT COUNT(*) FROM documents d JOIN volumes v ON v.id = d.volume_id AND v.status = 'opublikowany';

SELECT COALESCE(SUM(d.words_count),0) FROM documents d JOIN volumes v ON v.id = d.volume_id AND v.status = 'opublikowany'

[]

SELECT
  COALESCE(
    SUM(d.words_count),
    0
  )
FROM
  documents d
  JOIN volumes v ON v.id = d.volume_id
  AND v.status = 'opublikowany'

SELECT COALESCE(SUM(d.words_count),0) FROM documents d JOIN volumes v ON v.id = d.volume_id AND v.status = 'opublikowany';

SELECT COUNT(*) FROM volumes WHERE status = 'opublikowany'

[]

SELECT
  COUNT(*)
FROM
  volumes
WHERE
  status = 'opublikowany'

SELECT COUNT(*) FROM volumes WHERE status = 'opublikowany';

SELECT COALESCE(SUM(LENGTH(d.content)),0) FROM documents d JOIN volumes v ON v.id = d.volume_id AND v.status = 'opublikowany'

[]

SELECT
  COALESCE(
    SUM(
      LENGTH(d.content)
    ),
    0
  )
FROM
  documents d
  JOIN volumes v ON v.id = d.volume_id
  AND v.status = 'opublikowany'

SELECT COALESCE(SUM(LENGTH(d.content)),0) FROM documents d JOIN volumes v ON v.id = d.volume_id AND v.status = 'opublikowany';

SELECT "key", value FROM setting WHERE "key" LIKE 'frontend_%' OR "key" LIKE 'demo_%'

[]

SELECT
  "key",
  value
FROM
  setting
WHERE
  "key" LIKE 'frontend_%'
  OR "key" LIKE 'demo_%'

SELECT "key", value FROM setting WHERE "key" LIKE 'frontend_%' OR "key" LIKE 'demo_%';