Symfony Profiler

SELECT
  NEXTVAL('refrence_id_seq')

SELECT NEXTVAL('refrence_id_seq');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO refrence (
  id, name, email, affiliation, job_title,
  phone, address, ref_letter, applicant_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO refrence (id, name, email, affiliation, job_title, phone, address, ref_letter, applicant_id) VALUES (414, 'David Sarkany, MD, MS-HPEd, FACR', 'dsarkany@northwell.edu', 'Please add', 'Program Director', 'Please add', 'Please add', 'Please upload', NULL);

"COMMIT"

"COMMIT";

SELECT
  NEXTVAL('applicant_id_seq')

SELECT NEXTVAL('applicant_id_seq');

"START TRANSACTION"

"START TRANSACTION";

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
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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 (140, 'Wendy Zhang', 'wwzhangmd@gmail.com', '7 Navy Pier Ct Unit 5055
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);

"COMMIT"

"COMMIT";

SELECT
  NEXTVAL('refrence_id_seq')

SELECT NEXTVAL('refrence_id_seq');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO refrence (
  id, name, email, affiliation, job_title,
  phone, address, ref_letter, applicant_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO refrence (id, name, email, affiliation, job_title, phone, address, ref_letter, applicant_id) VALUES (415, 'Shirley Hanna, MD', 'shanna2@northwell.edu', 'Please add', 'Associate Chair, Dept of Radiology; Director, Breast Imaging Center', 'Please add', 'Please add', 'Please upload', NULL);

UPDATE
  refrence
SET
  applicant_id = ?
WHERE
  id = ?

UPDATE refrence SET applicant_id = 140 WHERE id = 414;

"COMMIT"

"COMMIT";

SELECT
  NEXTVAL('refrence_id_seq')

SELECT NEXTVAL('refrence_id_seq');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO refrence (
  id, name, email, affiliation, job_title,
  phone, address, ref_letter, applicant_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO refrence (id, name, email, affiliation, job_title, phone, address, ref_letter, applicant_id) VALUES (416, 'Yolande Kwok, DO', 'ykwok1@northwell.edu', 'Please add', 'Section Chief of Breast Imaging', 'Please add', 'Please add', 'Please upload', NULL);

UPDATE
  refrence
SET
  applicant_id = ?
WHERE
  id = ?

UPDATE refrence SET applicant_id = 140 WHERE id = 415;

"COMMIT"

"COMMIT";