Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 23
• Events
• Routing
• Cache
• Translation 3
• Security
• Twig
• Doctrine
• Emails
• Elastica
• Configuration

Query Metrics

SELECT o.occurrence_id AS occurrence_id,
                    t.tag AS tag_id, t.tag AS tag_name,
                    et.event_type_id AS event_type_id, et.event_type_name AS event_type_name,
                    g.group_id AS group_id, g.group_name AS group_name,
                    b.building_id AS building_id, b.building_name AS building_name
            FROM occurrence o
            STRAIGHT_JOIN event e ON e.event_id=o.event_id
            LEFT JOIN brd AS b ON b.building_id=o.building_id
            LEFT JOIN tag AS t ON t.event_id=e.event_id
            LEFT JOIN events_groups AS eg ON e.event_id=eg.event_id
            LEFT JOIN `group` AS g ON eg.group_id=g.group_id
            LEFT JOIN event_feature AS f ON e.event_id=f.event_id
            JOIN event_type AS et ON e.event_type_id=et.event_type_id
            WHERE ((o.date_start>=? AND o.date_start<=?)
                  OR (o.date_start>=? AND o.date_start<=?))
            AND eg.admin_status!='denied'
            
             AND  e.archived=0 AND e.cancelled=0 AND e.unpublished=0 AND (e.prominent=1 OR e.prominent IS NULL) AND (e.status='active' OR e.status='approved')

[
  "2026-06-01 00:00:00"
  "2026-06-30 23:23:59"
  "2026-06-01 00:00:00"
  "2026-06-30 23:23:59"
]

SELECT
  o.occurrence_id AS occurrence_id,
  t.tag AS tag_id,
  t.tag AS tag_name,
  et.event_type_id AS event_type_id,
  et.event_type_name AS event_type_name,
  g.group_id AS group_id,
  g.group_name AS group_name,
  b.building_id AS building_id,
  b.building_name AS building_name
FROM
  occurrence o
  STRAIGHT_JOIN event e ON e.event_id = o.event_id
  LEFT JOIN brd AS b ON b.building_id = o.building_id
  LEFT JOIN tag AS t ON t.event_id = e.event_id
  LEFT JOIN events_groups AS eg ON e.event_id = eg.event_id
  LEFT JOIN `group` AS g ON eg.group_id = g.group_id
  LEFT JOIN event_feature AS f ON e.event_id = f.event_id
  JOIN event_type AS et ON e.event_type_id = et.event_type_id
WHERE
  (
    (
      o.date_start >= ?
      AND o.date_start <= ?
    )
    OR (
      o.date_start >= ?
      AND o.date_start <= ?
    )
  )
  AND eg.admin_status != 'denied'
  AND e.archived = 0
  AND e.cancelled = 0
  AND e.unpublished = 0
  AND (
    e.prominent = 1
    OR e.prominent IS NULL
  )
  AND (
    e.status = 'active'
    OR e.status = 'approved'
  )

SELECT o.occurrence_id AS occurrence_id,
                    t.tag AS tag_id, t.tag AS tag_name,
                    et.event_type_id AS event_type_id, et.event_type_name AS event_type_name,
                    g.group_id AS group_id, g.group_name AS group_name,
                    b.building_id AS building_id, b.building_name AS building_name
            FROM occurrence o
            STRAIGHT_JOIN event e ON e.event_id=o.event_id
            LEFT JOIN brd AS b ON b.building_id=o.building_id
            LEFT JOIN tag AS t ON t.event_id=e.event_id
            LEFT JOIN events_groups AS eg ON e.event_id=eg.event_id
            LEFT JOIN `group` AS g ON eg.group_id=g.group_id
            LEFT JOIN event_feature AS f ON e.event_id=f.event_id
            JOIN event_type AS et ON e.event_type_id=et.event_type_id
            WHERE ((o.date_start>='2026-06-01 00:00:00' AND o.date_start<='2026-06-30 23:23:59')
                  OR (o.date_start>='2026-06-01 00:00:00' AND o.date_start<='2026-06-30 23:23:59'))
            AND eg.admin_status!='denied'
            
             AND  e.archived=0 AND e.cancelled=0 AND e.unpublished=0 AND (e.prominent=1 OR e.prominent IS NULL) AND (e.status='active' OR e.status='approved') 
            
            ;

SELECT COUNT(e.event_id) AS number, DATE_FORMAT(o.date_start,'%Y-%m-%d') as `date`
            FROM occurrence o
            JOIN event e ON e.event_id=o.event_id
            
            WHERE ((o.date_start>=? AND o.date_start<=?)
                  OR (o.date_start>=? AND o.date_start<=?))
            
             AND  e.archived=0 AND e.cancelled=0 AND e.unpublished=0 AND (e.prominent=1 OR e.prominent IS NULL) AND (e.status='active' OR e.status='approved') 
            GROUP BY `date`
            ORDER BY o.date_start ASC

[
  "2026-06-01 00:00:00"
  "2026-06-30 23:23:59"
  "2026-06-01 00:00:00"
  "2026-06-30 23:23:59"
]

SELECT
  COUNT(e.event_id) AS number,
  DATE_FORMAT(o.date_start, '%Y-%m-%d') as `date`
FROM
  occurrence o
  JOIN event e ON e.event_id = o.event_id
WHERE
  (
    (
      o.date_start >= ?
      AND o.date_start <= ?
    )
    OR (
      o.date_start >= ?
      AND o.date_start <= ?
    )
  )
  AND e.archived = 0
  AND e.cancelled = 0
  AND e.unpublished = 0
  AND (
    e.prominent = 1
    OR e.prominent IS NULL
  )
  AND (
    e.status = 'active'
    OR e.status = 'approved'
  )
GROUP BY
  `date`
ORDER BY
  o.date_start ASC

SELECT COUNT(e.event_id) AS number, DATE_FORMAT(o.date_start,'%Y-%m-%d') as `date`
            FROM occurrence o
            JOIN event e ON e.event_id=o.event_id
            
            WHERE ((o.date_start>='2026-06-01 00:00:00' AND o.date_start<='2026-06-30 23:23:59')
                  OR (o.date_start>='2026-06-01 00:00:00' AND o.date_start<='2026-06-30 23:23:59'))
            
             AND  e.archived=0 AND e.cancelled=0 AND e.unpublished=0 AND (e.prominent=1 OR e.prominent IS NULL) AND (e.status='active' OR e.status='approved') 
            GROUP BY `date`
            ORDER BY o.date_start ASC;