Symfony Profiler

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

Query Metrics

SELECT poster.id, poster.event AS event, event.title AS poster_title, event.sort AS poster_sort, event.start AS poster_start, event.ended AS poster_end, JSON_AGG(
                    DISTINCT JSONB_BUILD_OBJECT(
                        'texts', poster_text.text,
                        'positions', poster_text.position,
                        'css', poster_text.css
                    )
                ) AS poster_text, CONCAT ('/upload/poster_image' , '/', poster_image.name) AS poster_image_name, poster_image.ext AS poster_image_ext, poster_image.cdn AS poster_image_cdn FROM poster LEFT JOIN poster_profile project_profile ON project_profile.event = poster.event INNER JOIN poster_event event ON 
                    event.id = poster.event AND
                    event.device = ? AND
                    
                    DATE(event.start) <= CURRENT_DATE AND
                    (event.ended IS NULL OR DATE(event.ended) >= CURRENT_DATE)
                  LEFT JOIN poster_text poster_text ON poster_text.event = poster.event LEFT JOIN poster_image poster_image ON poster_image.event = poster.event WHERE (project_profile.value IS NULL OR project_profile.value = ?) GROUP BY poster.id, poster.event, event.title, event.sort, event.start, event.ended, poster_image.name, poster_image.ext, poster_image.cdn ORDER BY event.sort ASC

[
  "pc"
  "01982ecf-0a6a-79e5-967b-4992d1b836bb"
]

SELECT
  poster.id,
  poster.event AS event,
  event.title AS poster_title,
  event.sort AS poster_sort,
  event.start AS poster_start,
  event.ended AS poster_end,
  JSON_AGG(
    DISTINCT JSONB_BUILD_OBJECT(
      'texts', poster_text.text, 'positions',
      poster_text.position, 'css', poster_text.css
    )
  ) AS poster_text,
  CONCAT (
    '/upload/poster_image', '/', poster_image.name
  ) AS poster_image_name,
  poster_image.ext AS poster_image_ext,
  poster_image.cdn AS poster_image_cdn
FROM
  poster
  LEFT JOIN poster_profile project_profile ON project_profile.event = poster.event
  INNER JOIN poster_event event ON event.id = poster.event
  AND event.device = ?
  AND DATE(event.start) <= CURRENT_DATE
  AND (
    event.ended IS NULL
    OR DATE(event.ended) >= CURRENT_DATE
  )
  LEFT JOIN poster_text poster_text ON poster_text.event = poster.event
  LEFT JOIN poster_image poster_image ON poster_image.event = poster.event
WHERE
  (
    project_profile.value IS NULL
    OR project_profile.value = ?
  )
GROUP BY
  poster.id,
  poster.event,
  event.title,
  event.sort,
  event.start,
  event.ended,
  poster_image.name,
  poster_image.ext,
  poster_image.cdn
ORDER BY
  event.sort ASC

SELECT poster.id, poster.event AS event, event.title AS poster_title, event.sort AS poster_sort, event.start AS poster_start, event.ended AS poster_end, JSON_AGG(
                    DISTINCT JSONB_BUILD_OBJECT(
                        'texts', poster_text.text,
                        'positions', poster_text.position,
                        'css', poster_text.css
                    )
                ) AS poster_text, CONCAT ('/upload/poster_image' , '/', poster_image.name) AS poster_image_name, poster_image.ext AS poster_image_ext, poster_image.cdn AS poster_image_cdn FROM poster LEFT JOIN poster_profile project_profile ON project_profile.event = poster.event INNER JOIN poster_event event ON 
                    event.id = poster.event AND
                    event.device = 'pc' AND
                    
                    DATE(event.start) <= CURRENT_DATE AND
                    (event.ended IS NULL OR DATE(event.ended) >= CURRENT_DATE)
                  LEFT JOIN poster_text poster_text ON poster_text.event = poster.event LEFT JOIN poster_image poster_image ON poster_image.event = poster.event WHERE (project_profile.value IS NULL OR project_profile.value = '01982ecf-0a6a-79e5-967b-4992d1b836bb') GROUP BY poster.id, poster.event, event.title, event.sort, event.start, event.ended, poster_image.name, poster_image.ext, poster_image.cdn ORDER BY event.sort ASC;