Symfony Profiler

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

Query Metrics

SELECT w.id
    FROM configuration.workspace w
    JOIN LATERAL jsonb_array_elements_text((w.config::jsonb)->'WORKSPACE_ID') WITH ORDINALITY AS workspace_ids(value, ord)
        ON true
    WHERE workspace_ids.value::int = ?
    ORDER BY workspace_ids.ord ASC, w.id ASC
    LIMIT 1

[
  0
]

SELECT
  w.id
FROM
  configuration.workspace w
  JOIN LATERAL jsonb_array_elements_text(
    (w.config :: jsonb)-> 'WORKSPACE_ID'
  )
WITH
  ORDINALITY AS workspace_ids(value, ord) ON true
WHERE
  workspace_ids.value :: int = ?
ORDER BY
  workspace_ids.ord ASC,
  w.id ASC
LIMIT
  1

SELECT w.id
    FROM configuration.workspace w
    JOIN LATERAL jsonb_array_elements_text((w.config::jsonb)->'WORKSPACE_ID') WITH ORDINALITY AS workspace_ids(value, ord)
        ON true
    WHERE workspace_ids.value::int = 0
    ORDER BY workspace_ids.ord ASC, w.id ASC
    LIMIT 1;