Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.64 ms Query time

7 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.64 ms
(100.00%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.phone AS phone_4, t0.starting_year AS starting_year_5, t0.student_capacity AS student_capacity_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.slug AS slug_11, t0.flag AS flag_12, t0.faculty_id AS faculty_id_13 FROM department t0 WHERE t0.id = ?

Parameters:

[
  "contact@Clgunme.edu"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.phone AS phone_4,
  t0.starting_year AS starting_year_5,
  t0.student_capacity AS student_capacity_6,
  t0.created_at AS created_at_7,
  t0.created_by AS created_by_8,
  t0.updated_at AS updated_at_9,
  t0.updated_by AS updated_by_10,
  t0.slug AS slug_11,
  t0.flag AS flag_12,
  t0.faculty_id AS faculty_id_13
FROM
  department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.phone AS phone_4, t0.starting_year AS starting_year_5, t0.student_capacity AS student_capacity_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10, t0.slug AS slug_11, t0.flag AS flag_12, t0.faculty_id AS faculty_id_13 FROM department t0 WHERE t0.id = 'contact@Clgunme.edu';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 119)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 90)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	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\Department	The mappings App\Entity\Department#formation and App\Entity\Timetable#formation are inconsistent with each other.
App\Entity\Faculty	No errors.
App\Entity\Course	No errors.
App\Entity\Timetable	No errors.
App\Entity\Formation	The association App\Entity\Formation#onlineCourses refers to the owning side field App\Entity\OnlineCourse#Formation which does not exist.
App\Entity\Teacher	No errors.
App\Entity\Promotion	The association App\Entity\Promotion#publishes refers to the owning side field App\Entity\Publish#Promotion which does not exist. The association App\Entity\Promotion#onlineCourses refers to the owning side field App\Entity\OnlineCourse#Promotion which does not exist.
App\Entity\Publish	The mappings App\Entity\Publish#promotion and App\Entity\Promotion#publishes are inconsistent with each other.
App\Entity\Homework	No errors.
App\Entity\Subject	No errors.
App\Entity\Chapter	No errors.
App\Entity\Room	No errors.
App\Entity\Enrollment	No errors.
App\Entity\OnlineCourse	The mappings App\Entity\OnlineCourse#formation and App\Entity\Formation#onlineCourses are inconsistent with each other. The mappings App\Entity\OnlineCourse#grade and App\Entity\Grade#onlineCourses are inconsistent with each other. The mappings App\Entity\OnlineCourse#promotion and App\Entity\Promotion#onlineCourses are inconsistent with each other.
App\Entity\Address	No errors.
App\Entity\Article	No errors.
App\Entity\AcademicYear	No errors.
App\Entity\Event	No errors.
App\Entity\Semester	No errors.
App\Entity\Grade	The association App\Entity\Grade#onlineCourses refers to the owning side field App\Entity\OnlineCourse#Grade which does not exist.
App\Entity\StudentResponse	No errors.
App\Entity\Result	No errors.
App\Entity\Student	The mappings App\Entity\Student#formation and App\Entity\Enrollment#student are inconsistent with each other.
App\Entity\User	No errors.
App\Entity\Contact	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Service	No errors.
App\Entity\Reference	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://www.ist-mamou.org/d%C3%A9partement/contact@Clgunme.edu

Configuration Settings

Theme