Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

7.75 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.88 ms
(50.06%)

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')

Parameters:

[
  "2026-07-01 00:00:00"
  "2026-07-31 23:23:59"
  "2026-07-01 00:00:00"
  "2026-07-31 23:23:59"
]

View formatted query View runnable query Explain query View query backtrace

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-07-01 00:00:00' AND o.date_start<='2026-07-31 23:23:59')
                  OR (o.date_start>='2026-07-01 00:00:00' AND o.date_start<='2026-07-31 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') 
            
            ;

#	File/Call
1	Doctrine\ORM\NativeQuery->_doExecute (line 69)
2	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
3	Doctrine\ORM\AbstractQuery->execute (line 886)
4	Doctrine\ORM\AbstractQuery->getResult (line 688)
5	App\Repository\OccurrenceRepository->queryProperties (line 441)
6	App\Repository\OccurrenceRepository->findOccurrenceFilterPropertiesInRange (line 226)
7	App\Controller\EventController->eventMonthAction (line 533)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

3.87 ms
(49.94%)

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

Parameters:

[
  "2026-07-01 00:00:00"
  "2026-07-31 23:23:59"
  "2026-07-01 00:00:00"
  "2026-07-31 23:23:59"
]

View formatted query View runnable query Explain query View query backtrace

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-07-01 00:00:00' AND o.date_start<='2026-07-31 23:23:59')
                  OR (o.date_start>='2026-07-01 00:00:00' AND o.date_start<='2026-07-31 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;

#	File/Call
1	Doctrine\ORM\NativeQuery->_doExecute (line 69)
2	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
3	Doctrine\ORM\AbstractQuery->execute (line 886)
4	Doctrine\ORM\AbstractQuery->getResult (line 688)
5	App\Repository\OccurrenceRepository->findOccurrenceCountsInRange (line 548)
6	App\Controller\EventController->eventMonthAction (line 528)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
App\Entity\Occurrence	No errors.
App\Entity\BRD	No errors.
App\Entity\Event	No errors.
App\Entity\Recurrence	No errors.
App\Entity\CLEvent	No errors.
App\Entity\EventFeature	No errors.
App\Entity\EventType	No errors.
App\Entity\ICSFeed	No errors.
App\Entity\Tag	No errors.
App\Entity\EventsGroups	No errors.
App\Entity\EventLink	No errors.
App\Entity\EventFeedback	No errors.
App\Entity\Attachment	No errors.
App\Entity\AttachmentEvent	No errors.
App\Entity\Feedback	No errors.
App\Entity\Group	No errors.
App\Entity\GroupLink	No errors.

Symfony Profiler

GET https://events-rvandael.studentlife.umich.edu/month/2026-07-01

Configuration Settings

Theme

Page Width