https://rad-sdsc.ucsd.edu/applicant/new Return to referer URL

Query Metrics

18 Database Queries
7 Different statements
6.13 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.39 ms
(22.64%)
3
SELECT NEXTVAL('refrence_id_seq')
Parameters:
[]
1.29 ms
(21.04%)
4
"COMMIT"
Parameters:
[]
1.22 ms
(19.89%)
2
UPDATE refrence SET applicant_id = ? WHERE id = ?
Parameters:
[
  140
  414
]
1.14 ms
(18.67%)
3
INSERT INTO refrence (id, name, email, affiliation, job_title, phone, address, ref_letter, applicant_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  414
  "David Sarkany, MD, MS-HPEd, FACR"
  "dsarkany@northwell.edu"
  "Please add"
  "Program Director"
  "Please add"
  "Please add"
  "Please upload"
  null
]
0.39 ms
(6.36%)
1
INSERT INTO applicant (id, name, email, address, degree, current_position, division, application_form, personal, cv, usmle, dean_letter, med_school_d, ref1_name, ref1_email, ref1_letter, ref2_name, ref2_email, ref2_letter, ref3_name, ref3_email, ref3_letter, phone, status, notes, ref_lt_num) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  140
  "Wendy Zhang"
  "wwzhangmd@gmail.com"
  """
    7 Navy Pier Ct Unit 5055\r\n
    Staten Island, NY 10304
    """
  "Doctor of Medicine"
  "Diagnostic Radiology Resident (R3/PGY-4)"
  "Breast"
  "972fe211428d3437b66c42cb3e226312.pdf"
  "8199c7f487760ffc11b759c1ba10196a.pdf"
  "79649ec6b272f0fe03caffcfa8e3dc69.pdf"
  "c35bbbecab5fc414d287b548e5128955.pdf"
  "3a73740c0ec0c06fcb4aa60bc2a8ad62.pdf"
  "c0470a90291c5b5c8b713005de665206.pdf"
  "David Sarkany, MD, MS-HPEd, FACR"
  "dsarkany@northwell.edu"
  "Program Director"
  "Shirley Hanna, MD"
  "shanna2@northwell.edu"
  "Associate Chair, Dept of Radiology; Director, Breast Imaging Center"
  "Yolande Kwok, DO"
  "ykwok1@northwell.edu"
  "Section Chief of Breast Imaging"
  "(858)205-5892"
  null
  null
  null
]
0.37 ms
(6.00%)
1
SELECT NEXTVAL('applicant_id_seq')
Parameters:
[]
0.33 ms
(5.41%)
4
"START TRANSACTION"
Parameters:
[]

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\Applicant No errors.
App\Entity\Refrence No errors.