Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

7.92 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

4.31 ms

SELECT count(DISTINCT o0_.occurrence_id) AS sclr_0 FROM occurrence o0_ STRAIGHT_JOIN event e1_ ON o0_.event_id = e1_.event_id STRAIGHT_JOIN event_type e2_ ON e1_.event_type_id = e2_.event_type_id LEFT JOIN tag t3_ ON e1_.event_id = t3_.event_id LEFT JOIN attachment a4_ ON e1_.event_id = a4_.foreign_id AND a4_.relation IN ('event') LEFT JOIN brd b5_ ON o0_.building_id = b5_.building_id LEFT JOIN event_feature e6_ ON e1_.event_id = e6_.event_id LEFT JOIN event_link e7_ ON e1_.event_id = e7_.event_id LEFT JOIN events_groups e8_ ON e1_.event_id = e8_.event_id LEFT JOIN `group` g9_ ON e8_.group_id = g9_.group_id LEFT JOIN attachment a10_ ON g9_.group_id = a10_.foreign_id AND a10_.relation IN ('group') WHERE ((o0_.date_start >= ? AND o0_.date_start <= ?) OR (o0_.date_end >= ? AND o0_.date_end <= ?)) AND e8_.admin_status <> 'denied' AND e1_.archived = 0 AND e1_.cancelled = 0 AND e1_.unpublished = 0 AND (e1_.prominent = 1 OR e1_.prominent IS NULL) AND (e1_.status = 'active' OR e1_.status = 'approved')

Parameters:

[
  "2026-06-13 00:00:00"
  "2027-06-13 23:59:59"
  "2026-06-13 00:00:00"
  "2027-06-13 23:59:59"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT o0_.occurrence_id) AS sclr_0
FROM
  occurrence o0_
  STRAIGHT_JOIN event e1_ ON o0_.event_id = e1_.event_id
  STRAIGHT_JOIN event_type e2_ ON e1_.event_type_id = e2_.event_type_id
  LEFT JOIN tag t3_ ON e1_.event_id = t3_.event_id
  LEFT JOIN attachment a4_ ON e1_.event_id = a4_.foreign_id
  AND a4_.relation IN ('event')
  LEFT JOIN brd b5_ ON o0_.building_id = b5_.building_id
  LEFT JOIN event_feature e6_ ON e1_.event_id = e6_.event_id
  LEFT JOIN event_link e7_ ON e1_.event_id = e7_.event_id
  LEFT JOIN events_groups e8_ ON e1_.event_id = e8_.event_id
  LEFT JOIN `group` g9_ ON e8_.group_id = g9_.group_id
  LEFT JOIN attachment a10_ ON g9_.group_id = a10_.foreign_id
  AND a10_.relation IN ('group')
WHERE
  (
    (
      o0_.date_start >= ?
      AND o0_.date_start <= ?
    )
    OR (
      o0_.date_end >= ?
      AND o0_.date_end <= ?
    )
  )
  AND e8_.admin_status <> 'denied'
  AND e1_.archived = 0
  AND e1_.cancelled = 0
  AND e1_.unpublished = 0
  AND (
    e1_.prominent = 1
    OR e1_.prominent IS NULL
  )
  AND (
    e1_.status = 'active'
    OR e1_.status = 'approved'
  )

SELECT count(DISTINCT o0_.occurrence_id) AS sclr_0 FROM occurrence o0_ STRAIGHT_JOIN event e1_ ON o0_.event_id = e1_.event_id STRAIGHT_JOIN event_type e2_ ON e1_.event_type_id = e2_.event_type_id LEFT JOIN tag t3_ ON e1_.event_id = t3_.event_id LEFT JOIN attachment a4_ ON e1_.event_id = a4_.foreign_id AND a4_.relation IN ('event') LEFT JOIN brd b5_ ON o0_.building_id = b5_.building_id LEFT JOIN event_feature e6_ ON e1_.event_id = e6_.event_id LEFT JOIN event_link e7_ ON e1_.event_id = e7_.event_id LEFT JOIN events_groups e8_ ON e1_.event_id = e8_.event_id LEFT JOIN `group` g9_ ON e8_.group_id = g9_.group_id LEFT JOIN attachment a10_ ON g9_.group_id = a10_.foreign_id AND a10_.relation IN ('group') WHERE ((o0_.date_start >= '2026-06-13 00:00:00' AND o0_.date_start <= '2027-06-13 23:59:59') OR (o0_.date_end >= '2026-06-13 00:00:00' AND o0_.date_end <= '2027-06-13 23:59:59')) AND e8_.admin_status <> 'denied' AND e1_.archived = 0 AND e1_.cancelled = 0 AND e1_.unpublished = 0 AND (e1_.prominent = 1 OR e1_.prominent IS NULL) AND (e1_.status = 'active' OR e1_.status = 'approved');

#	File/Call
1	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 39)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerZxxxigs\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\EventController->eventListAction (line 297)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

1.96 ms

SELECT DISTINCT o0_.occurrence_id AS occurrence_id_0, o0_.date_start AS date_start_1, e1_.event_name AS event_name_2 FROM occurrence o0_ STRAIGHT_JOIN event e1_ ON o0_.event_id = e1_.event_id STRAIGHT_JOIN event_type e2_ ON e1_.event_type_id = e2_.event_type_id LEFT JOIN tag t3_ ON e1_.event_id = t3_.event_id LEFT JOIN attachment a4_ ON e1_.event_id = a4_.foreign_id AND a4_.relation IN ('event') LEFT JOIN brd b5_ ON o0_.building_id = b5_.building_id LEFT JOIN event_feature e6_ ON e1_.event_id = e6_.event_id LEFT JOIN event_link e7_ ON e1_.event_id = e7_.event_id LEFT JOIN events_groups e8_ ON e1_.event_id = e8_.event_id LEFT JOIN `group` g9_ ON e8_.group_id = g9_.group_id LEFT JOIN attachment a10_ ON g9_.group_id = a10_.foreign_id AND a10_.relation IN ('group') WHERE ((o0_.date_start >= ? AND o0_.date_start <= ?) OR (o0_.date_end >= ? AND o0_.date_end <= ?)) AND e8_.admin_status <> 'denied' AND e1_.archived = 0 AND e1_.cancelled = 0 AND e1_.unpublished = 0 AND (e1_.prominent = 1 OR e1_.prominent IS NULL) AND (e1_.status = 'active' OR e1_.status = 'approved') ORDER BY o0_.date_start ASC, e1_.event_name ASC LIMIT 50

Parameters:

[
  "2026-06-13 00:00:00"
  "2027-06-13 23:59:59"
  "2026-06-13 00:00:00"
  "2027-06-13 23:59:59"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT o0_.occurrence_id AS occurrence_id_0,
  o0_.date_start AS date_start_1,
  e1_.event_name AS event_name_2
FROM
  occurrence o0_
  STRAIGHT_JOIN event e1_ ON o0_.event_id = e1_.event_id
  STRAIGHT_JOIN event_type e2_ ON e1_.event_type_id = e2_.event_type_id
  LEFT JOIN tag t3_ ON e1_.event_id = t3_.event_id
  LEFT JOIN attachment a4_ ON e1_.event_id = a4_.foreign_id
  AND a4_.relation IN ('event')
  LEFT JOIN brd b5_ ON o0_.building_id = b5_.building_id
  LEFT JOIN event_feature e6_ ON e1_.event_id = e6_.event_id
  LEFT JOIN event_link e7_ ON e1_.event_id = e7_.event_id
  LEFT JOIN events_groups e8_ ON e1_.event_id = e8_.event_id
  LEFT JOIN `group` g9_ ON e8_.group_id = g9_.group_id
  LEFT JOIN attachment a10_ ON g9_.group_id = a10_.foreign_id
  AND a10_.relation IN ('group')
WHERE
  (
    (
      o0_.date_start >= ?
      AND o0_.date_start <= ?
    )
    OR (
      o0_.date_end >= ?
      AND o0_.date_end <= ?
    )
  )
  AND e8_.admin_status <> 'denied'
  AND e1_.archived = 0
  AND e1_.cancelled = 0
  AND e1_.unpublished = 0
  AND (
    e1_.prominent = 1
    OR e1_.prominent IS NULL
  )
  AND (
    e1_.status = 'active'
    OR e1_.status = 'approved'
  )
ORDER BY
  o0_.date_start ASC,
  e1_.event_name ASC
LIMIT
  50

SELECT DISTINCT o0_.occurrence_id AS occurrence_id_0, o0_.date_start AS date_start_1, e1_.event_name AS event_name_2 FROM occurrence o0_ STRAIGHT_JOIN event e1_ ON o0_.event_id = e1_.event_id STRAIGHT_JOIN event_type e2_ ON e1_.event_type_id = e2_.event_type_id LEFT JOIN tag t3_ ON e1_.event_id = t3_.event_id LEFT JOIN attachment a4_ ON e1_.event_id = a4_.foreign_id AND a4_.relation IN ('event') LEFT JOIN brd b5_ ON o0_.building_id = b5_.building_id LEFT JOIN event_feature e6_ ON e1_.event_id = e6_.event_id LEFT JOIN event_link e7_ ON e1_.event_id = e7_.event_id LEFT JOIN events_groups e8_ ON e1_.event_id = e8_.event_id LEFT JOIN `group` g9_ ON e8_.group_id = g9_.group_id LEFT JOIN attachment a10_ ON g9_.group_id = a10_.foreign_id AND a10_.relation IN ('group') WHERE ((o0_.date_start >= '2026-06-13 00:00:00' AND o0_.date_start <= '2027-06-13 23:59:59') OR (o0_.date_end >= '2026-06-13 00:00:00' AND o0_.date_end <= '2027-06-13 23:59:59')) AND e8_.admin_status <> 'denied' AND e1_.archived = 0 AND e1_.cancelled = 0 AND e1_.unpublished = 0 AND (e1_.prominent = 1 OR e1_.prominent IS NULL) AND (e1_.status = 'active' OR e1_.status = 'approved') ORDER BY o0_.date_start ASC, e1_.event_name ASC LIMIT 50;

#	File/Call
1	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 39)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerZxxxigs\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\EventController->eventListAction (line 297)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

1.65 ms

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-06-13 00:00:00"
  "2027-06-13 23:59:59"
  "2026-06-13 00:00:00"
  "2027-06-13 23:59: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-06-13 00:00:00' AND o.date_start<='2027-06-13 23:59:59')
                  OR (o.date_start>='2026-06-13 00:00:00' AND o.date_start<='2027-06-13 23:59: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->eventListAction (line 305)
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)

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\Event	No errors.
App\Entity\EventType	No errors.
App\Entity\Tag	No errors.
App\Entity\Attachment	No errors.
App\Entity\AttachmentEvent	No errors.
App\Entity\BRD	No errors.
App\Entity\EventFeature	No errors.
App\Entity\EventLink	No errors.
App\Entity\EventsGroups	No errors.
App\Entity\Group	No errors.
App\Entity\AttachmentGroup	No errors.
App\Entity\Recurrence	No errors.
App\Entity\CLEvent	No errors.
App\Entity\ICSFeed	No errors.
App\Entity\EventFeedback	No errors.
App\Entity\GroupLink	No errors.
App\Entity\GroupsUsers	No errors.
App\Entity\ImportFeed	No errors.
App\Entity\User	No errors.
App\Entity\Feedback	No errors.

Symfony Profiler

GET https://events-rvandael.studentlife.umich.edu/list

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping