Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

5.23 ms Query time

0 Invalid entities

78 Managed entities

Queries

Group similar statements

default connection

#▲

Time

Info

1.39 ms

SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.is_available AS is_available_4, a0_.deleted_at AS deleted_at_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.department_id AS department_id_8, a0_.doctor_id AS doctor_id_9, a0_.created_by AS created_by_10, a0_.updated_by AS updated_by_11, a0_.hospital_id AS hospital_id_12 FROM appointment_slots a0_ WHERE (a0_.hospital_id = ? AND a0_.is_available = ?) AND (a0_.deleted_at IS NULL)

Parameters:

[
  null
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.date AS date_1,
  a0_.start_time AS start_time_2,
  a0_.end_time AS end_time_3,
  a0_.is_available AS is_available_4,
  a0_.deleted_at AS deleted_at_5,
  a0_.created_at AS created_at_6,
  a0_.updated_at AS updated_at_7,
  a0_.department_id AS department_id_8,
  a0_.doctor_id AS doctor_id_9,
  a0_.created_by AS created_by_10,
  a0_.updated_by AS updated_by_11,
  a0_.hospital_id AS hospital_id_12
FROM
  appointment_slots a0_
WHERE
  (
    a0_.hospital_id = ?
    AND a0_.is_available = ?
  )
  AND (a0_.deleted_at IS NULL)

SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.is_available AS is_available_4, a0_.deleted_at AS deleted_at_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.department_id AS department_id_8, a0_.doctor_id AS doctor_id_9, a0_.created_by AS created_by_10, a0_.updated_by AS updated_by_11, a0_.hospital_id AS hospital_id_12 FROM appointment_slots a0_ WHERE (a0_.hospital_id = NULL AND a0_.is_available = 1) AND (a0_.deleted_at IS NULL);

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 202)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildForm (line 84)
14	Symfony\Component\Form\ResolvedFormType->buildForm (line 96)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
16	Symfony\Component\Form\ResolvedFormType->buildForm (line 94)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
18	Symfony\Component\Form\FormFactory->createNamedBuilder (line 56)
19	Symfony\Component\Form\FormFactory->createBuilderForProperty (line 100)
20	Symfony\Component\Form\FormBuilder->create (line 83)
21	Symfony\Component\Form\FormBuilder->resolveChildren (line 207)
22	Symfony\Component\Form\FormBuilder->getForm (line 160)
23	Symfony\Component\Form\FormFactory->create (line 26)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 351)
25	App\Controller\AppointmentController->new (line 48)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 182)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 29)
31	require_once (line 5)

2.82 ms

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.slot_duration AS slot_duration_2, d0_.max_bookings_per_slot AS max_bookings_per_slot_3, d0_.deleted_at AS deleted_at_4, d0_.created_at AS created_at_5, d0_.updated_at AS updated_at_6 FROM doctor_categories d0_ WHERE (d0_.deleted_at IS NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.slot_duration AS slot_duration_2,
  d0_.max_bookings_per_slot AS max_bookings_per_slot_3,
  d0_.deleted_at AS deleted_at_4,
  d0_.created_at AS created_at_5,
  d0_.updated_at AS updated_at_6
FROM
  doctor_categories d0_
WHERE
  (d0_.deleted_at IS NULL)

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.slot_duration AS slot_duration_2, d0_.max_bookings_per_slot AS max_bookings_per_slot_3, d0_.deleted_at AS deleted_at_4, d0_.created_at AS created_at_5, d0_.updated_at AS updated_at_6 FROM doctor_categories d0_ WHERE (d0_.deleted_at IS NULL);

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 202)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 451)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
23	App\Controller\AppointmentController->new (line 64)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

1.03 ms

SELECT h0_.id AS id_0, h0_.h_num AS h_num_1, h0_.reg_num AS reg_num_2, h0_.abha_num AS abha_num_3, h0_.reg_date AS reg_date_4, h0_.abha_date AS abha_date_5, h0_.hip_id AS hip_id_6, h0_.hip_name AS hip_name_7, h0_.hiu_id AS hiu_id_8, h0_.hiu_name AS hiu_name_9, h0_.name AS name_10, h0_.type AS type_11, h0_.level AS level_12, h0_.code AS code_13, h0_.is_active AS is_active_14, h0_.address AS address_15, h0_.pincode AS pincode_16, h0_.phone AS phone_17, h0_.email AS email_18, h0_.latitude AS latitude_19, h0_.longitude AS longitude_20, h0_.is_manual_attendance AS is_manual_attendance_21, h0_.deleted_at AS deleted_at_22, h0_.created_at AS created_at_23, h0_.updated_at AS updated_at_24, h0_.district_id AS district_id_25, h0_.taluka_id AS taluka_id_26, h0_.village_id AS village_id_27 FROM hospitals h0_ WHERE (h0_.deleted_at IS NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.h_num AS h_num_1,
  h0_.reg_num AS reg_num_2,
  h0_.abha_num AS abha_num_3,
  h0_.reg_date AS reg_date_4,
  h0_.abha_date AS abha_date_5,
  h0_.hip_id AS hip_id_6,
  h0_.hip_name AS hip_name_7,
  h0_.hiu_id AS hiu_id_8,
  h0_.hiu_name AS hiu_name_9,
  h0_.name AS name_10,
  h0_.type AS type_11,
  h0_.level AS level_12,
  h0_.code AS code_13,
  h0_.is_active AS is_active_14,
  h0_.address AS address_15,
  h0_.pincode AS pincode_16,
  h0_.phone AS phone_17,
  h0_.email AS email_18,
  h0_.latitude AS latitude_19,
  h0_.longitude AS longitude_20,
  h0_.is_manual_attendance AS is_manual_attendance_21,
  h0_.deleted_at AS deleted_at_22,
  h0_.created_at AS created_at_23,
  h0_.updated_at AS updated_at_24,
  h0_.district_id AS district_id_25,
  h0_.taluka_id AS taluka_id_26,
  h0_.village_id AS village_id_27
FROM
  hospitals h0_
WHERE
  (h0_.deleted_at IS NULL)

SELECT h0_.id AS id_0, h0_.h_num AS h_num_1, h0_.reg_num AS reg_num_2, h0_.abha_num AS abha_num_3, h0_.reg_date AS reg_date_4, h0_.abha_date AS abha_date_5, h0_.hip_id AS hip_id_6, h0_.hip_name AS hip_name_7, h0_.hiu_id AS hiu_id_8, h0_.hiu_name AS hiu_name_9, h0_.name AS name_10, h0_.type AS type_11, h0_.level AS level_12, h0_.code AS code_13, h0_.is_active AS is_active_14, h0_.address AS address_15, h0_.pincode AS pincode_16, h0_.phone AS phone_17, h0_.email AS email_18, h0_.latitude AS latitude_19, h0_.longitude AS longitude_20, h0_.is_manual_attendance AS is_manual_attendance_21, h0_.deleted_at AS deleted_at_22, h0_.created_at AS created_at_23, h0_.updated_at AS updated_at_24, h0_.district_id AS district_id_25, h0_.taluka_id AS taluka_id_26, h0_.village_id AS village_id_27 FROM hospitals h0_ WHERE (h0_.deleted_at IS NULL);

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 202)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 451)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
23	App\Controller\AppointmentController->new (line 64)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
cnmgts	doctrine.dbal.cnmgts_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Hospital	37
App\Entity\Village	14
App\Entity\Taluka	13
App\Entity\District	10
App\Entity\DoctorCategory	4

Entities Mapping

Class	Mapping errors
App\Entity\Appointment	No errors.
App\Entity\DoctorCategory	No errors.
App\Entity\StaffProfile	No errors.
App\Entity\Slot	No errors.
App\Entity\User	No errors.
App\Entity\Hospital	No errors.
App\Entity\District	No errors.
App\Entity\Taluka	No errors.
App\Entity\Village	No errors.

Symfony Profiler

GET https://hmis-abha.7mantra.co.in/appointments/new

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping