Symfony Profiler

SELECT
  t0.role AS role_1,
  t0.name AS name_2,
  t0.id AS id_3,
  t0.username AS username_4,
  t0.admin_college_id AS admin_college_id_5,
  t0.user_info_id AS user_info_id_6
FROM
  users t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.role AS role_1, t0.name AS name_2, t0.id AS id_3, t0.username AS username_4, t0.admin_college_id AS admin_college_id_5, t0.user_info_id AS user_info_id_6 FROM users t0 WHERE t0.username = '9202244276' LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1
FROM
  title t0_
WHERE
  t0_.id IN (?)

SELECT t0_.id AS id_0, t0_.name AS name_1 FROM title t0_ WHERE t0_.id IN ('40');

SELECT
  q0_.id AS id_0,
  q0_.name AS name_1
FROM
  qualification q0_
WHERE
  q0_.id IN (?)

SELECT q0_.id AS id_0, q0_.name AS name_1 FROM qualification q0_ WHERE q0_.id IN ('2');

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1
FROM
  degree d0_
WHERE
  d0_.id IN (?)

SELECT d0_.id AS id_0, d0_.name AS name_1 FROM degree d0_ WHERE d0_.id IN ('2');

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.valid AS valid_2
FROM
  college c0_
WHERE
  c0_.id IN (?)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.valid AS valid_2 FROM college c0_ WHERE c0_.id IN ('35');

SELECT
  t0.number AS number_1,
  t0.gender AS gender_2,
  t0.major AS major_3,
  t0.phone AS phone_4,
  t0.mobile AS mobile_5,
  t0.email AS email_6,
  t0.address AS address_7,
  t0.zipcode AS zipcode_8,
  t0.id AS id_9,
  t0.name AS name_10,
  t0.subject_id AS subject_id_11,
  t0.title_id AS title_id_12,
  t0.qualification_id AS qualification_id_13,
  t0.degree_id AS degree_id_14,
  t0.college_id AS college_id_15
FROM
  user_info t0
WHERE
  t0.number = ?
LIMIT
  2

SELECT t0.number AS number_1, t0.gender AS gender_2, t0.major AS major_3, t0.phone AS phone_4, t0.mobile AS mobile_5, t0.email AS email_6, t0.address AS address_7, t0.zipcode AS zipcode_8, t0.id AS id_9, t0.name AS name_10, t0.subject_id AS subject_id_11, t0.title_id AS title_id_12, t0.qualification_id AS qualification_id_13, t0.degree_id AS degree_id_14, t0.college_id AS college_id_15 FROM user_info t0 WHERE t0.number = '341222199107026534' LIMIT 2;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO user_info (
  number, gender, major, phone, mobile,
  email, address, zipcode, name, subject_id,
  title_id, qualification_id, degree_id,
  college_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO user_info (number, gender, major, phone, mobile, email, address, zipcode, name, subject_id, title_id, qualification_id, degree_id, college_id) VALUES ('341222199107026534', '男', '社会医学与卫生事业管理', '0551-62284396', '18256920521', 'weiyang072@ustc.edu.cn', '中国科学技术大学附属第一医院', '230001', '杨威', NULL, 40, 2, 2, 35);

UPDATE
  users
SET
  name = ?,
  user_info_id = ?
WHERE
  id = ?

UPDATE users SET name = '杨威', user_info_id = 702 WHERE id = 1154;

"COMMIT"

"COMMIT";