Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.33 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.95 ms

SELECT t0.id AS id_1, t0.username AS username_2, t0.org_id AS org_id_3, t0.display_name AS display_name_4, t0.email AS email_5, t0.category AS category_6, t0.status AS status_7, t0.frozen AS frozen_8, t0.loaded_from AS loaded_from_9, t0.created AS created_10, t0.updated AS updated_11, t0.roles AS roles_12, t0.d7_uid AS d7_uid_13 FROM user t0 WHERE t0.username = ? LIMIT 1

Parameters:

[
  "kfan64"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.org_id AS org_id_3,
  t0.display_name AS display_name_4,
  t0.email AS email_5,
  t0.category AS category_6,
  t0.status AS status_7,
  t0.frozen AS frozen_8,
  t0.loaded_from AS loaded_from_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.roles AS roles_12,
  t0.d7_uid AS d7_uid_13
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.org_id AS org_id_3, t0.display_name AS display_name_4, t0.email AS email_5, t0.category AS category_6, t0.status AS status_7, t0.frozen AS frozen_8, t0.loaded_from AS loaded_from_9, t0.created AS created_10, t0.updated AS updated_11, t0.roles AS roles_12, t0.d7_uid AS d7_uid_13 FROM user t0 WHERE t0.username = 'kfan64' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 38)
4	App\Security\DevAuthenticator->authenticate (line 60)
5	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 176)
6	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
9	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 66)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
12	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.52 ms

SELECT t0.id AS id_1, t0.serial_num AS serial_num_2, t0.req_admin AS req_admin_3, t0.institution_other AS institution_other_4, t0.institution_country AS institution_country_5, t0.course_subj_code AS course_subj_code_6, t0.course_crse_num AS course_crse_num_7, t0.course_title AS course_title_8, t0.course_term AS course_term_9, t0.course_credit_hrs AS course_credit_hrs_10, t0.course_credit_basis AS course_credit_basis_11, t0.lab_subj_code AS lab_subj_code_12, t0.lab_crse_num AS lab_crse_num_13, t0.lab_title AS lab_title_14, t0.lab_term AS lab_term_15, t0.lab_credit_hrs AS lab_credit_hrs_16, t0.lab_credit_basis AS lab_credit_basis_17, t0.phase AS phase_18, t0.status AS status_19, t0.created AS created_20, t0.updated AS updated_21, t0.draft_equiv1_course AS draft_equiv1_course_22, t0.draft_equiv1_credit_hrs AS draft_equiv1_credit_hrs_23, t0.draft_equiv1_operator AS draft_equiv1_operator_24, t0.draft_equiv2_course AS draft_equiv2_course_25, t0.draft_equiv2_credit_hrs AS draft_equiv2_credit_hrs_26, t0.draft_equiv2_operator AS draft_equiv2_operator_27, t0.draft_equiv3_course AS draft_equiv3_course_28, t0.draft_equiv3_credit_hrs AS draft_equiv3_credit_hrs_29, t0.draft_equiv3_operator AS draft_equiv3_operator_30, t0.draft_equiv4_course AS draft_equiv4_course_31, t0.draft_equiv4_credit_hours AS draft_equiv4_credit_hours_32, t0.draft_policy AS draft_policy_33, t0.final_equiv1_credit_hrs AS final_equiv1_credit_hrs_34, t0.final_equiv1_operator AS final_equiv1_operator_35, t0.final_equiv2_credit_hrs AS final_equiv2_credit_hrs_36, t0.final_equiv2_operator AS final_equiv2_operator_37, t0.final_equiv3_credit_hrs AS final_equiv3_credit_hrs_38, t0.final_equiv3_operator AS final_equiv3_operator_39, t0.final_equiv4_credit_hrs AS final_equiv4_credit_hrs_40, t0.final_policy AS final_policy_41, t0.requester_type AS requester_type_42, t0.course_in_sis AS course_in_sis_43, t0.transcript_on_hand AS transcript_on_hand_44, t0.hold_for_requester_admit AS hold_for_requester_admit_45, t0.hold_for_course_input AS hold_for_course_input_46, t0.hold_for_transcript AS hold_for_transcript_47, t0.tag_spot_articulated AS tag_spot_articulated_48, t0.tag_r1_to_student AS tag_r1_to_student_49, t0.tag_dept_to_student AS tag_dept_to_student_50, t0.tag_dept_to_r1 AS tag_dept_to_r1_51, t0.tag_r2_to_student AS tag_r2_to_student_52, t0.tag_r2_to_dept AS tag_r2_to_dept_53, t0.tag_reassigned AS tag_reassigned_54, t0.d7_nid AS d7_nid_55, t0.d7_uuid AS d7_uuid_56, t0.loaded_from AS loaded_from_57, t0.requester_id AS requester_id_58, t0.institution_id AS institution_id_59, t0.assignee_id AS assignee_id_60, t0.final_equiv1_course_id AS final_equiv1_course_id_61, t0.final_equiv2_course_id AS final_equiv2_course_id_62, t0.final_equiv3_course_id AS final_equiv3_course_id_63, t0.final_equiv4_course_id AS final_equiv4_course_id_64 FROM evaluation t0 WHERE t0.id = ?

Parameters:

[
  "65437"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.serial_num AS serial_num_2,
  t0.req_admin AS req_admin_3,
  t0.institution_other AS institution_other_4,
  t0.institution_country AS institution_country_5,
  t0.course_subj_code AS course_subj_code_6,
  t0.course_crse_num AS course_crse_num_7,
  t0.course_title AS course_title_8,
  t0.course_term AS course_term_9,
  t0.course_credit_hrs AS course_credit_hrs_10,
  t0.course_credit_basis AS course_credit_basis_11,
  t0.lab_subj_code AS lab_subj_code_12,
  t0.lab_crse_num AS lab_crse_num_13,
  t0.lab_title AS lab_title_14,
  t0.lab_term AS lab_term_15,
  t0.lab_credit_hrs AS lab_credit_hrs_16,
  t0.lab_credit_basis AS lab_credit_basis_17,
  t0.phase AS phase_18,
  t0.status AS status_19,
  t0.created AS created_20,
  t0.updated AS updated_21,
  t0.draft_equiv1_course AS draft_equiv1_course_22,
  t0.draft_equiv1_credit_hrs AS draft_equiv1_credit_hrs_23,
  t0.draft_equiv1_operator AS draft_equiv1_operator_24,
  t0.draft_equiv2_course AS draft_equiv2_course_25,
  t0.draft_equiv2_credit_hrs AS draft_equiv2_credit_hrs_26,
  t0.draft_equiv2_operator AS draft_equiv2_operator_27,
  t0.draft_equiv3_course AS draft_equiv3_course_28,
  t0.draft_equiv3_credit_hrs AS draft_equiv3_credit_hrs_29,
  t0.draft_equiv3_operator AS draft_equiv3_operator_30,
  t0.draft_equiv4_course AS draft_equiv4_course_31,
  t0.draft_equiv4_credit_hours AS draft_equiv4_credit_hours_32,
  t0.draft_policy AS draft_policy_33,
  t0.final_equiv1_credit_hrs AS final_equiv1_credit_hrs_34,
  t0.final_equiv1_operator AS final_equiv1_operator_35,
  t0.final_equiv2_credit_hrs AS final_equiv2_credit_hrs_36,
  t0.final_equiv2_operator AS final_equiv2_operator_37,
  t0.final_equiv3_credit_hrs AS final_equiv3_credit_hrs_38,
  t0.final_equiv3_operator AS final_equiv3_operator_39,
  t0.final_equiv4_credit_hrs AS final_equiv4_credit_hrs_40,
  t0.final_policy AS final_policy_41,
  t0.requester_type AS requester_type_42,
  t0.course_in_sis AS course_in_sis_43,
  t0.transcript_on_hand AS transcript_on_hand_44,
  t0.hold_for_requester_admit AS hold_for_requester_admit_45,
  t0.hold_for_course_input AS hold_for_course_input_46,
  t0.hold_for_transcript AS hold_for_transcript_47,
  t0.tag_spot_articulated AS tag_spot_articulated_48,
  t0.tag_r1_to_student AS tag_r1_to_student_49,
  t0.tag_dept_to_student AS tag_dept_to_student_50,
  t0.tag_dept_to_r1 AS tag_dept_to_r1_51,
  t0.tag_r2_to_student AS tag_r2_to_student_52,
  t0.tag_r2_to_dept AS tag_r2_to_dept_53,
  t0.tag_reassigned AS tag_reassigned_54,
  t0.d7_nid AS d7_nid_55,
  t0.d7_uuid AS d7_uuid_56,
  t0.loaded_from AS loaded_from_57,
  t0.requester_id AS requester_id_58,
  t0.institution_id AS institution_id_59,
  t0.assignee_id AS assignee_id_60,
  t0.final_equiv1_course_id AS final_equiv1_course_id_61,
  t0.final_equiv2_course_id AS final_equiv2_course_id_62,
  t0.final_equiv3_course_id AS final_equiv3_course_id_63,
  t0.final_equiv4_course_id AS final_equiv4_course_id_64
FROM
  evaluation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.serial_num AS serial_num_2, t0.req_admin AS req_admin_3, t0.institution_other AS institution_other_4, t0.institution_country AS institution_country_5, t0.course_subj_code AS course_subj_code_6, t0.course_crse_num AS course_crse_num_7, t0.course_title AS course_title_8, t0.course_term AS course_term_9, t0.course_credit_hrs AS course_credit_hrs_10, t0.course_credit_basis AS course_credit_basis_11, t0.lab_subj_code AS lab_subj_code_12, t0.lab_crse_num AS lab_crse_num_13, t0.lab_title AS lab_title_14, t0.lab_term AS lab_term_15, t0.lab_credit_hrs AS lab_credit_hrs_16, t0.lab_credit_basis AS lab_credit_basis_17, t0.phase AS phase_18, t0.status AS status_19, t0.created AS created_20, t0.updated AS updated_21, t0.draft_equiv1_course AS draft_equiv1_course_22, t0.draft_equiv1_credit_hrs AS draft_equiv1_credit_hrs_23, t0.draft_equiv1_operator AS draft_equiv1_operator_24, t0.draft_equiv2_course AS draft_equiv2_course_25, t0.draft_equiv2_credit_hrs AS draft_equiv2_credit_hrs_26, t0.draft_equiv2_operator AS draft_equiv2_operator_27, t0.draft_equiv3_course AS draft_equiv3_course_28, t0.draft_equiv3_credit_hrs AS draft_equiv3_credit_hrs_29, t0.draft_equiv3_operator AS draft_equiv3_operator_30, t0.draft_equiv4_course AS draft_equiv4_course_31, t0.draft_equiv4_credit_hours AS draft_equiv4_credit_hours_32, t0.draft_policy AS draft_policy_33, t0.final_equiv1_credit_hrs AS final_equiv1_credit_hrs_34, t0.final_equiv1_operator AS final_equiv1_operator_35, t0.final_equiv2_credit_hrs AS final_equiv2_credit_hrs_36, t0.final_equiv2_operator AS final_equiv2_operator_37, t0.final_equiv3_credit_hrs AS final_equiv3_credit_hrs_38, t0.final_equiv3_operator AS final_equiv3_operator_39, t0.final_equiv4_credit_hrs AS final_equiv4_credit_hrs_40, t0.final_policy AS final_policy_41, t0.requester_type AS requester_type_42, t0.course_in_sis AS course_in_sis_43, t0.transcript_on_hand AS transcript_on_hand_44, t0.hold_for_requester_admit AS hold_for_requester_admit_45, t0.hold_for_course_input AS hold_for_course_input_46, t0.hold_for_transcript AS hold_for_transcript_47, t0.tag_spot_articulated AS tag_spot_articulated_48, t0.tag_r1_to_student AS tag_r1_to_student_49, t0.tag_dept_to_student AS tag_dept_to_student_50, t0.tag_dept_to_r1 AS tag_dept_to_r1_51, t0.tag_r2_to_student AS tag_r2_to_student_52, t0.tag_r2_to_dept AS tag_r2_to_dept_53, t0.tag_reassigned AS tag_reassigned_54, t0.d7_nid AS d7_nid_55, t0.d7_uuid AS d7_uuid_56, t0.loaded_from AS loaded_from_57, t0.requester_id AS requester_id_58, t0.institution_id AS institution_id_59, t0.assignee_id AS assignee_id_60, t0.final_equiv1_course_id AS final_equiv1_course_id_61, t0.final_equiv2_course_id AS final_equiv2_course_id_62, t0.final_equiv3_course_id AS final_equiv3_course_id_63, t0.final_equiv4_course_id AS final_equiv4_course_id_64 FROM evaluation t0 WHERE t0.id = '65437';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 142)
6	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->find (line 91)
7	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->apply (line 84)
8	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->applyConverter (line 48)
9	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->apply (line 72)
10	Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener->onKernelController (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.62 ms

SELECT t0.id AS id_1, t0.username AS username_2, t0.org_id AS org_id_3, t0.display_name AS display_name_4, t0.email AS email_5, t0.category AS category_6, t0.status AS status_7, t0.frozen AS frozen_8, t0.loaded_from AS loaded_from_9, t0.created AS created_10, t0.updated AS updated_11, t0.roles AS roles_12, t0.d7_uid AS d7_uid_13 FROM user t0 WHERE t0.id = ?

Parameters:

[
  b"\x01Å%▄\x17Ã~┼┐ý7\x02\x1FêÇ9"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.org_id AS org_id_3,
  t0.display_name AS display_name_4,
  t0.email AS email_5,
  t0.category AS category_6,
  t0.status AS status_7,
  t0.frozen AS frozen_8,
  t0.loaded_from AS loaded_from_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.roles AS roles_12,
  t0.d7_uid AS d7_uid_13
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.org_id AS org_id_3, t0.display_name AS display_name_4, t0.email AS email_5, t0.category AS category_6, t0.status AS status_7, t0.frozen AS frozen_8, t0.loaded_from AS loaded_from_9, t0.created AS created_10, t0.updated AS updated_11, t0.roles AS roles_12, t0.d7_uid AS d7_uid_13 FROM user t0 WHERE t0.id = 0x018F25DC17C77EC5BFEC37021F888039;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
7	Proxies\__CG__\App\Entity\User->__get (line 115)
8	App\Entity\User->getOrgID (line 28)
9	App\Service\EvaluationFormDefaultsService->getEvaluationUpdateDefaults (line 34)
10	App\Form\EvaluationUpdateType->buildForm (line 102)
11	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
12	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
13	Symfony\Component\Form\FormFactory->createNamedBuilder (line 43)
14	Symfony\Component\Form\FormFactory->createBuilder (line 28)
15	Symfony\Component\Form\FormFactory->create (line 344)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 415)
17	App\Controller\CoordinatorPageController->coordinatorEvaluationUpdateForm (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.23 ms

SELECT t0.id AS id_1, t0.dapip_id AS dapip_id_2, t0.usg_id AS usg_id_3, t0.name AS name_4, t0.state AS state_5, t0.address AS address_6, t0.status AS status_7, t0.d7_nid AS d7_nid_8, t0.loaded_from AS loaded_from_9 FROM institution t0 WHERE t0.id = ?

Parameters:

[
  575
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.dapip_id AS dapip_id_2,
  t0.usg_id AS usg_id_3,
  t0.name AS name_4,
  t0.state AS state_5,
  t0.address AS address_6,
  t0.status AS status_7,
  t0.d7_nid AS d7_nid_8,
  t0.loaded_from AS loaded_from_9
FROM
  institution t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.dapip_id AS dapip_id_2, t0.usg_id AS usg_id_3, t0.name AS name_4, t0.state AS state_5, t0.address AS address_6, t0.status AS status_7, t0.d7_nid AS d7_nid_8, t0.loaded_from AS loaded_from_9 FROM institution t0 WHERE t0.id = 575;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Institution::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
7	Proxies\__CG__\App\Entity\Institution->__get (line 93)
8	App\Entity\Institution->getState (line 84)
9	App\Service\EvaluationFormDefaultsService->getState (line 36)
10	App\Service\EvaluationFormDefaultsService->getEvaluationUpdateDefaults (line 34)
11	App\Form\EvaluationUpdateType->buildForm (line 102)
12	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
13	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
14	Symfony\Component\Form\FormFactory->createNamedBuilder (line 43)
15	Symfony\Component\Form\FormFactory->createBuilder (line 28)
16	Symfony\Component\Form\FormFactory->create (line 344)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 415)
18	App\Controller\CoordinatorPageController->coordinatorEvaluationUpdateForm (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	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\User	No errors.
App\Entity\Evaluation	No errors.
App\Entity\Note	No errors.
App\Entity\Affiliation	No errors.
App\Entity\Institution	No errors.
App\Entity\Course	No errors.
App\Entity\Trail	No errors.

Symfony Profiler

GET https://tc.innovation.registrar.gatech.edu/secure/coordinator/evaluation/65437/update

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping