Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

1.90 ms Query time

1 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.86 ms

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.starting_date AS starting_date_2, m0_.end_date AS end_date_3, m0_.class_name AS class_name_4, m0_.description AS description_5, m0_.board_notified AS board_notified_6, m0_.google_event_id AS google_event_id_7, m0_.status AS status_8, m1_.id AS id_9, m1_.number AS number_10, m1_.held_at AS held_at_11, m1_.status AS status_12, m1_.note AS note_13, m1_.minute_taken_at AS minute_taken_at_14, m0_.created_by_id AS created_by_id_15, m1_.created_by_id AS created_by_id_16, m1_.minute_taken_by_id AS minute_taken_by_id_17, m1_.meeting_schedule_id AS meeting_schedule_id_18 FROM meeting_schedule m0_ LEFT JOIN meeting m1_ ON m0_.id = m1_.meeting_schedule_id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.starting_date AS starting_date_2,
  m0_.end_date AS end_date_3,
  m0_.class_name AS class_name_4,
  m0_.description AS description_5,
  m0_.board_notified AS board_notified_6,
  m0_.google_event_id AS google_event_id_7,
  m0_.status AS status_8,
  m1_.id AS id_9,
  m1_.number AS number_10,
  m1_.held_at AS held_at_11,
  m1_.status AS status_12,
  m1_.note AS note_13,
  m1_.minute_taken_at AS minute_taken_at_14,
  m0_.created_by_id AS created_by_id_15,
  m1_.created_by_id AS created_by_id_16,
  m1_.minute_taken_by_id AS minute_taken_by_id_17,
  m1_.meeting_schedule_id AS meeting_schedule_id_18
FROM
  meeting_schedule m0_
  LEFT JOIN meeting m1_ ON m0_.id = m1_.meeting_schedule_id

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.starting_date AS starting_date_2, m0_.end_date AS end_date_3, m0_.class_name AS class_name_4, m0_.description AS description_5, m0_.board_notified AS board_notified_6, m0_.google_event_id AS google_event_id_7, m0_.status AS status_8, m1_.id AS id_9, m1_.number AS number_10, m1_.held_at AS held_at_11, m1_.status AS status_12, m1_.note AS note_13, m1_.minute_taken_at AS minute_taken_at_14, m0_.created_by_id AS created_by_id_15, m1_.created_by_id AS created_by_id_16, m1_.minute_taken_by_id AS minute_taken_by_id_17, m1_.meeting_schedule_id AS meeting_schedule_id_18 FROM meeting_schedule m0_ LEFT JOIN meeting m1_ ON m0_.id = m1_.meeting_schedule_id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 55)
7	App\Repository\SERO\MeetingScheduleRepository->findAllWithMeetings (line 124)
8	App\Controller\HomeController->meetingschedule (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.42 ms

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.starting_date AS starting_date_2, m0_.end_date AS end_date_3, m0_.class_name AS class_name_4, m0_.description AS description_5, m0_.board_notified AS board_notified_6, m0_.google_event_id AS google_event_id_7, m0_.status AS status_8, m1_.id AS id_9, m1_.number AS number_10, m1_.held_at AS held_at_11, m1_.status AS status_12, m1_.note AS note_13, m1_.minute_taken_at AS minute_taken_at_14, m0_.created_by_id AS created_by_id_15, m1_.created_by_id AS created_by_id_16, m1_.minute_taken_by_id AS minute_taken_by_id_17, m1_.meeting_schedule_id AS meeting_schedule_id_18 FROM meeting_schedule m0_ LEFT JOIN meeting m1_ ON m0_.id = m1_.meeting_schedule_id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.starting_date AS starting_date_2,
  m0_.end_date AS end_date_3,
  m0_.class_name AS class_name_4,
  m0_.description AS description_5,
  m0_.board_notified AS board_notified_6,
  m0_.google_event_id AS google_event_id_7,
  m0_.status AS status_8,
  m1_.id AS id_9,
  m1_.number AS number_10,
  m1_.held_at AS held_at_11,
  m1_.status AS status_12,
  m1_.note AS note_13,
  m1_.minute_taken_at AS minute_taken_at_14,
  m0_.created_by_id AS created_by_id_15,
  m1_.created_by_id AS created_by_id_16,
  m1_.minute_taken_by_id AS minute_taken_by_id_17,
  m1_.meeting_schedule_id AS meeting_schedule_id_18
FROM
  meeting_schedule m0_
  LEFT JOIN meeting m1_ ON m0_.id = m1_.meeting_schedule_id

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.starting_date AS starting_date_2, m0_.end_date AS end_date_3, m0_.class_name AS class_name_4, m0_.description AS description_5, m0_.board_notified AS board_notified_6, m0_.google_event_id AS google_event_id_7, m0_.status AS status_8, m1_.id AS id_9, m1_.number AS number_10, m1_.held_at AS held_at_11, m1_.status AS status_12, m1_.note AS note_13, m1_.minute_taken_at AS minute_taken_at_14, m0_.created_by_id AS created_by_id_15, m1_.created_by_id AS created_by_id_16, m1_.minute_taken_by_id AS minute_taken_by_id_17, m1_.meeting_schedule_id AS meeting_schedule_id_18 FROM meeting_schedule m0_ LEFT JOIN meeting m1_ ON m0_.id = m1_.meeting_schedule_id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 55)
7	App\Repository\SERO\MeetingScheduleRepository->findAllWithMeetings (line 139)
8	App\Controller\HomeController->meetingschedule (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.63 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.starting_date AS starting_date_3, t0.end_date AS end_date_4, t0.class_name AS class_name_5, t0.description AS description_6, t0.board_notified AS board_notified_7, t0.google_event_id AS google_event_id_8, t0.status AS status_9, t0.created_by_id AS created_by_id_10, t11.id AS id_12, t11.number AS number_13, t11.held_at AS held_at_14, t11.status AS status_15, t11.note AS note_16, t11.minute_taken_at AS minute_taken_at_17, t11.created_by_id AS created_by_id_18, t11.minute_taken_by_id AS minute_taken_by_id_19, t11.meeting_schedule_id AS meeting_schedule_id_20 FROM meeting_schedule t0 LEFT JOIN meeting t11 ON t11.meeting_schedule_id = t0.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.starting_date AS starting_date_3,
  t0.end_date AS end_date_4,
  t0.class_name AS class_name_5,
  t0.description AS description_6,
  t0.board_notified AS board_notified_7,
  t0.google_event_id AS google_event_id_8,
  t0.status AS status_9,
  t0.created_by_id AS created_by_id_10,
  t11.id AS id_12,
  t11.number AS number_13,
  t11.held_at AS held_at_14,
  t11.status AS status_15,
  t11.note AS note_16,
  t11.minute_taken_at AS minute_taken_at_17,
  t11.created_by_id AS created_by_id_18,
  t11.minute_taken_by_id AS minute_taken_by_id_19,
  t11.meeting_schedule_id AS meeting_schedule_id_20
FROM
  meeting_schedule t0
  LEFT JOIN meeting t11 ON t11.meeting_schedule_id = t0.id

SELECT t0.id AS id_1, t0.name AS name_2, t0.starting_date AS starting_date_3, t0.end_date AS end_date_4, t0.class_name AS class_name_5, t0.description AS description_6, t0.board_notified AS board_notified_7, t0.google_event_id AS google_event_id_8, t0.status AS status_9, t0.created_by_id AS created_by_id_10, t11.id AS id_12, t11.number AS number_13, t11.held_at AS held_at_14, t11.status AS status_15, t11.note AS note_16, t11.minute_taken_at AS minute_taken_at_17, t11.created_by_id AS created_by_id_18, t11.minute_taken_by_id AS minute_taken_by_id_19, t11.meeting_schedule_id AS meeting_schedule_id_20 FROM meeting_schedule t0 LEFT JOIN meeting t11 ON t11.meeting_schedule_id = t0.id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 158)
6	App\Controller\HomeController->meetingschedule (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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\SERO\MeetingSchedule	No errors.
App\Entity\SERO\Meeting	The mappings App\Entity\SERO\Meeting#minuteTakenBy and App\Entity\User#meetings are inconsistent with each other.
App\Entity\User	No errors.

Symfony Profiler

GET https://rmp.wgu.edu.et/en/meetingschedule

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping