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 = '05824' LIMIT 1;

SELECT
  t0.type AS type_1,
  t0.apply_deadline AS apply_deadline_2,
  t0.college_deadline AS college_deadline_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.open AS open_6
FROM
  batch t0
WHERE
  t0.id = ?

SELECT t0.type AS type_1, t0.apply_deadline AS apply_deadline_2, t0.college_deadline AS college_deadline_3, t0.id AS id_4, t0.name AS name_5, t0.open AS open_6 FROM batch t0 WHERE t0.id = '36';

SELECT
  p0_.number AS number_0,
  p0_.school_project_number AS school_project_number_1,
  p0_.status AS status_2,
  p0_.college_sort AS college_sort_3,
  p0_.school_sort AS school_sort_4,
  p0_.doc_name AS doc_name_5,
  p0_.college_doc_name AS college_doc_name_6,
  p0_.id AS id_7,
  p0_.name AS name_8,
  p0_.updated_at AS updated_at_9,
  s1_.id AS id_10,
  s1_.name AS name_11,
  c2_.id AS id_12,
  c2_.name AS name_13,
  c2_.valid AS valid_14,
  c3_.id AS id_15,
  c3_.name AS name_16,
  c3_.orders AS orders_17,
  l4_.id AS id_18,
  l4_.name AS name_19,
  u5_.role AS role_20,
  u5_.name AS name_21,
  u5_.id AS id_22,
  u5_.username AS username_23,
  u6_.number AS number_24,
  u6_.gender AS gender_25,
  u6_.major AS major_26,
  u6_.phone AS phone_27,
  u6_.mobile AS mobile_28,
  u6_.email AS email_29,
  u6_.address AS address_30,
  u6_.zipcode AS zipcode_31,
  u6_.id AS id_32,
  u6_.name AS name_33,
  p7_.id AS id_34,
  p7_.name AS name_35,
  p7_.valid AS valid_36,
  y8_.id AS id_37,
  y8_.name AS name_38,
  y8_.valid AS valid_39,
  p9_.attachment_name AS attachment_name_40,
  p9_.id AS id_41,
  p9_.name AS name_42,
  p0_.batch_id AS batch_id_43,
  p0_.user_id AS user_id_44,
  p0_.subject_id AS subject_id_45,
  p0_.college_id AS college_id_46,
  p0_.category_id AS category_id_47,
  p0_.level_id AS level_id_48,
  p0_.year_id AS year_id_49,
  p0_.property_id AS property_id_50,
  c3_.batch_id AS batch_id_51,
  l4_.category_id AS category_id_52,
  u5_.admin_college_id AS admin_college_id_53,
  u5_.user_info_id AS user_info_id_54,
  u6_.subject_id AS subject_id_55,
  u6_.title_id AS title_id_56,
  u6_.qualification_id AS qualification_id_57,
  u6_.degree_id AS degree_id_58,
  u6_.college_id AS college_id_59,
  p9_.project_id AS project_id_60
FROM
  project p0_
  LEFT JOIN subject s1_ ON p0_.subject_id = s1_.id
  LEFT JOIN college c2_ ON p0_.college_id = c2_.id
  LEFT JOIN category c3_ ON p0_.category_id = c3_.id
  LEFT JOIN LEVEL l4_ ON p0_.level_id = l4_.id
  LEFT JOIN users u5_ ON p0_.user_id = u5_.id
  LEFT JOIN user_info u6_ ON u5_.user_info_id = u6_.id
  LEFT JOIN property p7_ ON p0_.property_id = p7_.id
  LEFT JOIN year y8_ ON p0_.year_id = y8_.id
  LEFT JOIN project_attachment p9_ ON p0_.id = p9_.project_id
WHERE
  p0_.batch_id = ?
ORDER BY
  p0_.level_id ASC,
  p0_.school_sort ASC,
  p0_.college_sort ASC

SELECT p0_.number AS number_0, p0_.school_project_number AS school_project_number_1, p0_.status AS status_2, p0_.college_sort AS college_sort_3, p0_.school_sort AS school_sort_4, p0_.doc_name AS doc_name_5, p0_.college_doc_name AS college_doc_name_6, p0_.id AS id_7, p0_.name AS name_8, p0_.updated_at AS updated_at_9, s1_.id AS id_10, s1_.name AS name_11, c2_.id AS id_12, c2_.name AS name_13, c2_.valid AS valid_14, c3_.id AS id_15, c3_.name AS name_16, c3_.orders AS orders_17, l4_.id AS id_18, l4_.name AS name_19, u5_.role AS role_20, u5_.name AS name_21, u5_.id AS id_22, u5_.username AS username_23, u6_.number AS number_24, u6_.gender AS gender_25, u6_.major AS major_26, u6_.phone AS phone_27, u6_.mobile AS mobile_28, u6_.email AS email_29, u6_.address AS address_30, u6_.zipcode AS zipcode_31, u6_.id AS id_32, u6_.name AS name_33, p7_.id AS id_34, p7_.name AS name_35, p7_.valid AS valid_36, y8_.id AS id_37, y8_.name AS name_38, y8_.valid AS valid_39, p9_.attachment_name AS attachment_name_40, p9_.id AS id_41, p9_.name AS name_42, p0_.batch_id AS batch_id_43, p0_.user_id AS user_id_44, p0_.subject_id AS subject_id_45, p0_.college_id AS college_id_46, p0_.category_id AS category_id_47, p0_.level_id AS level_id_48, p0_.year_id AS year_id_49, p0_.property_id AS property_id_50, c3_.batch_id AS batch_id_51, l4_.category_id AS category_id_52, u5_.admin_college_id AS admin_college_id_53, u5_.user_info_id AS user_info_id_54, u6_.subject_id AS subject_id_55, u6_.title_id AS title_id_56, u6_.qualification_id AS qualification_id_57, u6_.degree_id AS degree_id_58, u6_.college_id AS college_id_59, p9_.project_id AS project_id_60 FROM project p0_ LEFT JOIN subject s1_ ON p0_.subject_id = s1_.id LEFT JOIN college c2_ ON p0_.college_id = c2_.id LEFT JOIN category c3_ ON p0_.category_id = c3_.id LEFT JOIN LEVEL l4_ ON p0_.level_id = l4_.id LEFT JOIN users u5_ ON p0_.user_id = u5_.id LEFT JOIN user_info u6_ ON u5_.user_info_id = u6_.id LEFT JOIN property p7_ ON p0_.property_id = p7_.id LEFT JOIN year y8_ ON p0_.year_id = y8_.id LEFT JOIN project_attachment p9_ ON p0_.id = p9_.project_id WHERE p0_.batch_id = 36 ORDER BY p0_.level_id ASC, p0_.school_sort ASC, p0_.college_sort ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.valid AS valid_2
FROM
  college c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.valid AS valid_2 FROM college c0_;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.orders AS orders_2,
  c0_.batch_id AS batch_id_3
FROM
  category c0_
WHERE
  c0_.batch_id = ?
ORDER BY
  c0_.orders ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.orders AS orders_2, c0_.batch_id AS batch_id_3 FROM category c0_ WHERE c0_.batch_id = 36 ORDER BY c0_.orders ASC;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'pms'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  title t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM title t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  title t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM title t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  title t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM title t0 WHERE t0.id = 21;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  title t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM title t0 WHERE t0.id = 22;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  title t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM title t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  title t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM title t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  title t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM title t0 WHERE t0.id = 40;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  title t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM title t0 WHERE t0.id = 18;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  title t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM title t0 WHERE t0.id = 17;