Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

12.05 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.67 ms
(55.35%)

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.description AS description_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.academic_year AS academic_year_6, t0.semester AS semester_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_deleted AS is_deleted_11, t0.deleted_at AS deleted_at_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14 FROM academic_sessions t0 WHERE t0.status = ? LIMIT 1

Parameters:

[
  "active"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.description AS description_3,
  t0.start_date AS start_date_4,
  t0.end_date AS end_date_5,
  t0.academic_year AS academic_year_6,
  t0.semester AS semester_7,
  t0.status AS status_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.is_deleted AS is_deleted_11,
  t0.deleted_at AS deleted_at_12,
  t0.created_by_id AS created_by_id_13,
  t0.updated_by_id AS updated_by_id_14
FROM
  academic_sessions t0
WHERE
  t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.description AS description_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.academic_year AS academic_year_6, t0.semester AS semester_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_deleted AS is_deleted_11, t0.deleted_at AS deleted_at_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14 FROM academic_sessions t0 WHERE t0.status = 'active' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 33)
5	App\Controller\HomeController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 4)

5.38 ms
(44.65%)

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.middle_name AS middle_name_5, t0.username AS username_6, t0.department AS department_7, t0.profile_photo AS profile_photo_8, t0.cover_photo AS cover_photo_9, t0.password AS password_10, t0.email_address AS email_address_11, t0.phone_number AS phone_number_12, t0.is_logged_in AS is_logged_in_13, t0.last_logged_in_date AS last_logged_in_date_14, t0.status AS status_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_deleted AS is_deleted_18, t0.deleted_at AS deleted_at_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21, t0.user_type, t0.bio AS bio_22, t0.designation AS designation_23, t0.webpage AS webpage_24, t0.is_verified AS is_verified_25, t0.account_confirmation_date AS account_confirmation_date_26, t0.password_is_default AS password_is_default_27, t0.is_two_factor_enabled AS is_two_factor_enabled_28, t0.index_number AS index_number_29, t0.level AS level_30, t0.program AS program_31, t0.session AS session_32, t0.gender AS gender_33, t0.date_of_birth AS date_of_birth_34, t0.guardian_name AS guardian_name_35, t0.guardian_contact AS guardian_contact_36, t0.nationality AS nationality_37, t0.date_of_admission AS date_of_admission_38, t0.expected_date_of_completion AS expected_date_of_completion_39, t0.title AS title_40, t0.marital_status AS marital_status_41, t0.religion AS religion_42, t0.mime_type AS mime_type_43 FROM base_user t0 WHERE t0.id = ? AND t0.user_type IN ('admin', 'student')

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.middle_name AS middle_name_5,
  t0.username AS username_6,
  t0.department AS department_7,
  t0.profile_photo AS profile_photo_8,
  t0.cover_photo AS cover_photo_9,
  t0.password AS password_10,
  t0.email_address AS email_address_11,
  t0.phone_number AS phone_number_12,
  t0.is_logged_in AS is_logged_in_13,
  t0.last_logged_in_date AS last_logged_in_date_14,
  t0.status AS status_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.is_deleted AS is_deleted_18,
  t0.deleted_at AS deleted_at_19,
  t0.created_by_id AS created_by_id_20,
  t0.updated_by_id AS updated_by_id_21,
  t0.user_type,
  t0.bio AS bio_22,
  t0.designation AS designation_23,
  t0.webpage AS webpage_24,
  t0.is_verified AS is_verified_25,
  t0.account_confirmation_date AS account_confirmation_date_26,
  t0.password_is_default AS password_is_default_27,
  t0.is_two_factor_enabled AS is_two_factor_enabled_28,
  t0.index_number AS index_number_29,
  t0.level AS level_30,
  t0.program AS program_31,
  t0.session AS session_32,
  t0.gender AS gender_33,
  t0.date_of_birth AS date_of_birth_34,
  t0.guardian_name AS guardian_name_35,
  t0.guardian_contact AS guardian_contact_36,
  t0.nationality AS nationality_37,
  t0.date_of_admission AS date_of_admission_38,
  t0.expected_date_of_completion AS expected_date_of_completion_39,
  t0.title AS title_40,
  t0.marital_status AS marital_status_41,
  t0.religion AS religion_42,
  t0.mime_type AS mime_type_43
FROM
  base_user t0
WHERE
  t0.id = ?
  AND t0.user_type IN ('admin', 'student')

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.middle_name AS middle_name_5, t0.username AS username_6, t0.department AS department_7, t0.profile_photo AS profile_photo_8, t0.cover_photo AS cover_photo_9, t0.password AS password_10, t0.email_address AS email_address_11, t0.phone_number AS phone_number_12, t0.is_logged_in AS is_logged_in_13, t0.last_logged_in_date AS last_logged_in_date_14, t0.status AS status_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.is_deleted AS is_deleted_18, t0.deleted_at AS deleted_at_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21, t0.user_type, t0.bio AS bio_22, t0.designation AS designation_23, t0.webpage AS webpage_24, t0.is_verified AS is_verified_25, t0.account_confirmation_date AS account_confirmation_date_26, t0.password_is_default AS password_is_default_27, t0.is_two_factor_enabled AS is_two_factor_enabled_28, t0.index_number AS index_number_29, t0.level AS level_30, t0.program AS program_31, t0.session AS session_32, t0.gender AS gender_33, t0.date_of_birth AS date_of_birth_34, t0.guardian_name AS guardian_name_35, t0.guardian_contact AS guardian_contact_36, t0.nationality AS nationality_37, t0.date_of_admission AS date_of_admission_38, t0.expected_date_of_completion AS expected_date_of_completion_39, t0.title AS title_40, t0.marital_status AS marital_status_41, t0.religion AS religion_42, t0.mime_type AS mime_type_43 FROM base_user t0 WHERE t0.id = 5 AND t0.user_type IN ('admin', 'student');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 778)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2516)
4	Doctrine\ORM\UnitOfWork->createEntity (line 168)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 59)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 742)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
9	Doctrine\ORM\EntityRepository->findOneBy (line 80)
10	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 33)
11	App\Controller\HomeController->index (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 4)

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\Setups\ApplicationOpening	No errors.
App\Entity\User\BaseUser	No errors.
App\Entity\User\AdminUser	No errors.
App\Entity\User\StudentUser	No errors.
App\Entity\User\Role	No errors.

Symfony Profiler

GET http://hostel.hcu.edu.gh/

Configuration Settings

Theme