Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.91 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.49 ms
(50.71%)

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.blood_group AS blood_group_11, t0.address AS address_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 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.blood_group AS blood_group_11,
  t0.address AS address_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
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.blood_group AS blood_group_11, t0.address AS address_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 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 93)
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)

1.00 ms
(20.37%)

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 94)
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.71 ms
(14.47%)

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 95)
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.71 ms
(14.45%)

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 96)
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\Enrollment	No errors.
App\Entity\Teacher	No errors.
App\Entity\Course	No errors.
App\Entity\Timetable	No errors.
App\Entity\Faculty	No errors.
App\Entity\Department	The mappings App\Entity\Department#formation and App\Entity\Timetable#formation are inconsistent with each other.
App\Entity\Formation	No errors.
App\Entity\Subject	No errors.
App\Entity\Publish	The mappings App\Entity\Publish#promotion and App\Entity\Promotion#publishes are inconsistent with each other.

Symfony Profiler

GET https://datacambi.com/apropos-de-nous

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping