Query Metrics
18
Database Queries
7
Different statements
6.13 ms
Query time
0
Invalid entities
Grouped Statements
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. |