Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

3.52 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.62 ms
(45.96%)

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.date_of_birth AS date_of_birth_4, t0.roll_number AS roll_number_5, t0.phone AS phone_6, t0.gender AS gender_7, t0.father AS father_8, t0.mother AS mother_9, t0.parent_number AS parent_number_10, t0.place_of_birth AS place_of_birth_11, t0.nationality AS nationality_12, t0.picture AS picture_13, t0.created_at AS created_at_14, t0.created_by AS created_by_15, t0.updated_at AS updated_at_16, t0.updated_by AS updated_by_17, t0.flag AS flag_18, t0.email AS email_19, t0.exam_table_number AS exam_table_number_20, t0.baccalaureate_option AS baccalaureate_option_21, t0.baccalaureate_session AS baccalaureate_session_22, t0.exam_center AS exam_center_23, t0.high_school AS high_school_24, t0.baccalaureate_average AS baccalaureate_average_25, t0.orientation_session AS orientation_session_26, t0.prefecture AS prefecture_27, t0.orientation_program AS orientation_program_28 FROM student t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.date_of_birth AS date_of_birth_4,
  t0.roll_number AS roll_number_5,
  t0.phone AS phone_6,
  t0.gender AS gender_7,
  t0.father AS father_8,
  t0.mother AS mother_9,
  t0.parent_number AS parent_number_10,
  t0.place_of_birth AS place_of_birth_11,
  t0.nationality AS nationality_12,
  t0.picture AS picture_13,
  t0.created_at AS created_at_14,
  t0.created_by AS created_by_15,
  t0.updated_at AS updated_at_16,
  t0.updated_by AS updated_by_17,
  t0.flag AS flag_18,
  t0.email AS email_19,
  t0.exam_table_number AS exam_table_number_20,
  t0.baccalaureate_option AS baccalaureate_option_21,
  t0.baccalaureate_session AS baccalaureate_session_22,
  t0.exam_center AS exam_center_23,
  t0.high_school AS high_school_24,
  t0.baccalaureate_average AS baccalaureate_average_25,
  t0.orientation_session AS orientation_session_26,
  t0.prefecture AS prefecture_27,
  t0.orientation_program AS orientation_program_28
FROM
  student t0

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.date_of_birth AS date_of_birth_4, t0.roll_number AS roll_number_5, t0.phone AS phone_6, t0.gender AS gender_7, t0.father AS father_8, t0.mother AS mother_9, t0.parent_number AS parent_number_10, t0.place_of_birth AS place_of_birth_11, t0.nationality AS nationality_12, t0.picture AS picture_13, t0.created_at AS created_at_14, t0.created_by AS created_by_15, t0.updated_at AS updated_at_16, t0.updated_by AS updated_by_17, t0.flag AS flag_18, t0.email AS email_19, t0.exam_table_number AS exam_table_number_20, t0.baccalaureate_option AS baccalaureate_option_21, t0.baccalaureate_session AS baccalaureate_session_22, t0.exam_center AS exam_center_23, t0.high_school AS high_school_24, t0.baccalaureate_average AS baccalaureate_average_25, t0.orientation_session AS orientation_session_26, t0.prefecture AS prefecture_27, t0.orientation_program AS orientation_program_28 FROM student t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 77)
6	App\Controller\Client\HomeController->about_us (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.58 ms
(16.52%)

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.specialization AS specialization_4, t0.gender AS gender_5, t0.phone AS phone_6, t0.joining_date AS joining_date_7, t0.created_at AS created_at_8, t0.created_by AS created_by_9, t0.updated_at AS updated_at_10, t0.updated_by AS updated_by_11, t0.date_of_birth AS date_of_birth_12, t0.address AS address_13, t0.picture AS picture_14, t0.education AS education_15, t0.designation AS designation_16, t0.country AS country_17, t0.flag AS flag_18, t0.email AS email_19, t0.security_social_number AS security_social_number_20, t0.roll_number AS roll_number_21 FROM teacher t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.specialization AS specialization_4,
  t0.gender AS gender_5,
  t0.phone AS phone_6,
  t0.joining_date AS joining_date_7,
  t0.created_at AS created_at_8,
  t0.created_by AS created_by_9,
  t0.updated_at AS updated_at_10,
  t0.updated_by AS updated_by_11,
  t0.date_of_birth AS date_of_birth_12,
  t0.address AS address_13,
  t0.picture AS picture_14,
  t0.education AS education_15,
  t0.designation AS designation_16,
  t0.country AS country_17,
  t0.flag AS flag_18,
  t0.email AS email_19,
  t0.security_social_number AS security_social_number_20,
  t0.roll_number AS roll_number_21
FROM
  teacher t0

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.specialization AS specialization_4, t0.gender AS gender_5, t0.phone AS phone_6, t0.joining_date AS joining_date_7, t0.created_at AS created_at_8, t0.created_by AS created_by_9, t0.updated_at AS updated_at_10, t0.updated_by AS updated_by_11, t0.date_of_birth AS date_of_birth_12, t0.address AS address_13, t0.picture AS picture_14, t0.education AS education_15, t0.designation AS designation_16, t0.country AS country_17, t0.flag AS flag_18, t0.email AS email_19, t0.security_social_number AS security_social_number_20, t0.roll_number AS roll_number_21 FROM teacher t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 78)
6	App\Controller\Client\HomeController->about_us (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.52 ms
(14.81%)

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

Parameters:

[]

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

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 81)
6	App\Controller\Client\HomeController->about_us (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.40 ms
(11.43%)

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.created_at AS created_at_6, t0.created_by AS created_by_7, t0.updated_at AS updated_at_8, t0.updated_by AS updated_by_9, t0.flag AS flag_10 FROM faculty t0

Parameters:

[]

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.created_at AS created_at_6,
  t0.created_by AS created_by_7,
  t0.updated_at AS updated_at_8,
  t0.updated_by AS updated_by_9,
  t0.flag AS flag_10
FROM
  faculty t0

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.created_at AS created_at_6, t0.created_by AS created_by_7, t0.updated_at AS updated_at_8, t0.updated_by AS updated_by_9, t0.flag AS flag_10 FROM faculty t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 79)
6	App\Controller\Client\HomeController->about_us (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.40 ms
(11.28%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.duration AS duration_4, t0.ects AS ects_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.updated_at AS updated_at_8, t0.updated_by AS updated_by_9, t0.department_id AS department_id_10 FROM formation t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.duration AS duration_4,
  t0.ects AS ects_5,
  t0.created_at AS created_at_6,
  t0.created_by AS created_by_7,
  t0.updated_at AS updated_at_8,
  t0.updated_by AS updated_by_9,
  t0.department_id AS department_id_10
FROM
  formation t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.duration AS duration_4, t0.ects AS ects_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.updated_at AS updated_at_8, t0.updated_by AS updated_by_9, t0.department_id AS department_id_10 FROM formation t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 80)
6	App\Controller\Client\HomeController->about_us (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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\Student	The mappings App\Entity\Student#formation and App\Entity\Enrollment#student are inconsistent with each other.
App\Entity\Teacher	No errors.
App\Entity\Faculty	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\Department	The mappings App\Entity\Department#formation and App\Entity\Timetable#formation are inconsistent with each other.

Symfony Profiler

GET https://ist-mamou.org/apropos-de-nous

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping