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 = 'P0283' 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 ('14');

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 = '342501198507051545' 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 ('342501198507051545', '女', '教育学', '0551-63603984', '18755138502', 'tingl@ustc.edu.cn', '中国科学技术大学教务处', '230026', '刘婷', NULL, 40, 2, 2, 14);

UPDATE
  users
SET
  user_info_id = ?
WHERE
  id = ?

UPDATE users SET user_info_id = 699 WHERE id = 425;

"COMMIT"

"COMMIT";