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 "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_%';

SELECT id, number, title, year_from, year_to FROM volumes WHERE status = 'opublikowany' ORDER BY number

[]

SELECT
  id,
  number,
  title,
  year_from,
  year_to
FROM
  volumes
WHERE
  status = 'opublikowany'
ORDER BY
  number

SELECT id, number, title, year_from, year_to FROM volumes WHERE status = 'opublikowany' ORDER BY number;

SELECT id, name, slug, color FROM tags ORDER BY name

[]

SELECT
  id,
  name,
  slug,
  color
FROM
  tags
ORDER BY
  name

SELECT id, name, slug, color FROM tags ORDER BY name;

SELECT DISTINCT d.document_type FROM documents d WHERE d.document_type IS NOT NULL AND d.document_type != '' AND EXISTS (SELECT 1 FROM volumes v WHERE v.id = d.volume_id AND v.status = 'opublikowany') ORDER BY d.document_type

[]

SELECT
  DISTINCT d.document_type
FROM
  documents d
WHERE
  d.document_type IS NOT NULL
  AND d.document_type != ''
  AND EXISTS (
    SELECT
      1
    FROM
      volumes v
    WHERE
      v.id = d.volume_id
      AND v.status = 'opublikowany'
  )
ORDER BY
  d.document_type

SELECT DISTINCT d.document_type FROM documents d WHERE d.document_type IS NOT NULL AND d.document_type != '' AND EXISTS (SELECT 1 FROM volumes v WHERE v.id = d.volume_id AND v.status = 'opublikowany') ORDER BY d.document_type;

SELECT COUNT(*) FROM documents d WHERE EXISTS (SELECT 1 FROM volumes v WHERE v.id = d.volume_id AND v.status = 'opublikowany')

[]

SELECT
  COUNT(*)
FROM
  documents d
WHERE
  EXISTS (
    SELECT
      1
    FROM
      volumes v
    WHERE
      v.id = d.volume_id
      AND v.status = 'opublikowany'
  )

SELECT COUNT(*) FROM documents d WHERE EXISTS (SELECT 1 FROM volumes v WHERE v.id = d.volume_id AND v.status = 'opublikowany');

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

[]

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

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

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

[]

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

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