Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.12 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.12 ms

SELECT t0.id AS id_1, t0.payment AS payment_2, t0.active AS active_3, t0.siblingname AS siblingname_4, t0.percentage AS percentage_5, t0.alt_email AS alt_email_6, t0.alt_phone AS alt_phone_7, t0.student_user_data_id AS student_user_data_id_8, t0.teacher_user_data_id AS teacher_user_data_id_9, t0.grade_id AS grade_id_10, t0.instrument_id AS instrument_id_11, t0.teacher_id AS teacher_id_12, t0.term_id AS term_id_13, t0.student_id AS student_id_14 FROM user_instrument_grade t0 WHERE t0.id IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.payment AS payment_2,
  t0.active AS active_3,
  t0.siblingname AS siblingname_4,
  t0.percentage AS percentage_5,
  t0.alt_email AS alt_email_6,
  t0.alt_phone AS alt_phone_7,
  t0.student_user_data_id AS student_user_data_id_8,
  t0.teacher_user_data_id AS teacher_user_data_id_9,
  t0.grade_id AS grade_id_10,
  t0.instrument_id AS instrument_id_11,
  t0.teacher_id AS teacher_id_12,
  t0.term_id AS term_id_13,
  t0.student_id AS student_id_14
FROM
  user_instrument_grade t0
WHERE
  t0.id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.payment AS payment_2, t0.active AS active_3, t0.siblingname AS siblingname_4, t0.percentage AS percentage_5, t0.alt_email AS alt_email_6, t0.alt_phone AS alt_phone_7, t0.student_user_data_id AS student_user_data_id_8, t0.teacher_user_data_id AS teacher_user_data_id_9, t0.grade_id AS grade_id_10, t0.instrument_id AS instrument_id_11, t0.teacher_id AS teacher_id_12, t0.term_id AS term_id_13, t0.student_id AS student_id_14 FROM user_instrument_grade t0 WHERE t0.id IS NULL LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 368)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 276)
5	Doctrine\ORM\EntityRepository->__call (line 527)
6	App\Controller\LessonPlanController->showSessionsForUig (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
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.

Entities Mapping

Class	Mapping errors
App\Entity\Section	No errors.
App\Entity\UserInstrumentGrade	No errors.
App\Entity\StudentUserData	No errors.
App\Entity\TeacherUserData	No errors.
App\Entity\InstrumentGrade	No errors.
App\Entity\Instrument	No errors.
App\Entity\User	No errors.
App\Entity\Term	No errors.
App\Entity\Page	No errors.
App\Entity\WebPhotos	No errors.
App\Entity\Session	No errors.
App\Entity\Payment	No errors.
App\Entity\Report	No errors.
App\Entity\Notes	No errors.
App\Entity\Reporting	No errors.
App\Entity\Deductions	No errors.
App\Entity\Exercise	No errors.
App\Entity\Course	No errors.
App\Entity\Booking	No errors.
App\Entity\Learner	No errors.
App\Entity\SchoolTime	No errors.
App\Entity\Post	No errors.
App\Entity\UserSettings	No errors.
App\Entity\Communication	No errors.
App\Entity\DeductionPayment	No errors.
App\Entity\Assignment	No errors.
App\Entity\PracticeSessions	No errors.
App\Entity\LessonPlan	No errors.
App\Entity\Blog	No errors.
App\Entity\Comment	No errors.
App\Entity\CommentReply	No errors.
App\Entity\PhotoUpload	No errors.
App\Entity\ShortUrl	No errors.
App\Entity\UigGroup	No errors.
App\Entity\SimpleReport	No errors.
App\Entity\TeacherInvoice	No errors.

Symfony Profiler

GET https://chezamusicschool.co.ke/lesson/plan/teacher/show/sessions/for/uig

Configuration Settings

Theme