Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.super_user AS super_user_3,
  t0.user_type AS user_type_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.time_created AS time_created_7,
  t0.is_deleted AS is_deleted_8,
  t9.id AS id_10,
  t9.family_name AS family_name_11,
  t9.lastname_mn AS lastname_mn_12,
  t9.lastname_en AS lastname_en_13,
  t9.firstname_mn AS firstname_mn_14,
  t9.firstname_en AS firstname_en_15,
  t9.degree AS degree_16,
  t9.title AS title_17,
  t9.reg_num AS reg_num_18,
  t9.student_code AS student_code_19,
  t9.gender AS gender_20,
  t9.birth_date AS birth_date_21,
  t9.mobile AS mobile_22,
  t9.phone_home AS phone_home_23,
  t9.phone_work AS phone_work_24,
  t9.ethnicity AS ethnicity_25,
  t9.university AS university_26,
  t9.academic_field AS academic_field_27,
  t9.course AS course_28,
  t9.mobile_2 AS mobile_2_29,
  t9.user_id AS user_id_30,
  t9.province_id AS province_id_31,
  t9.nationality_id AS nationality_id_32,
  t9.country_id AS country_id_33,
  t9.user_education_id AS user_education_id_34,
  t9.user_addressing_main_id AS user_addressing_main_id_35,
  t9.user_addressing_current_id AS user_addressing_current_id_36
FROM
  `user` t0
  LEFT JOIN user_info t9 ON t9.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.super_user AS super_user_3, t0.user_type AS user_type_4, t0.roles AS roles_5, t0.password AS password_6, t0.time_created AS time_created_7, t0.is_deleted AS is_deleted_8, t9.id AS id_10, t9.family_name AS family_name_11, t9.lastname_mn AS lastname_mn_12, t9.lastname_en AS lastname_en_13, t9.firstname_mn AS firstname_mn_14, t9.firstname_en AS firstname_en_15, t9.degree AS degree_16, t9.title AS title_17, t9.reg_num AS reg_num_18, t9.student_code AS student_code_19, t9.gender AS gender_20, t9.birth_date AS birth_date_21, t9.mobile AS mobile_22, t9.phone_home AS phone_home_23, t9.phone_work AS phone_work_24, t9.ethnicity AS ethnicity_25, t9.university AS university_26, t9.academic_field AS academic_field_27, t9.course AS course_28, t9.mobile_2 AS mobile_2_29, t9.user_id AS user_id_30, t9.province_id AS province_id_31, t9.nationality_id AS nationality_id_32, t9.country_id AS country_id_33, t9.user_education_id AS user_education_id_34, t9.user_addressing_main_id AS user_addressing_main_id_35, t9.user_addressing_current_id AS user_addressing_current_id_36 FROM `user` t0 LEFT JOIN user_info t9 ON t9.user_id = t0.id WHERE t0.id = 324;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.roles AS roles_3
FROM
  user_group t0
  INNER JOIN users_groups ON t0.id = users_groups.user_group_id
WHERE
  users_groups.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3 FROM user_group t0 INNER JOIN users_groups ON t0.id = users_groups.user_group_id WHERE users_groups.user_id = 324;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.register_start AS register_start_4,
  t0.register_end AS register_end_5,
  t0.register_fee_amount AS register_fee_amount_6,
  t0.credit_fee_amount AS credit_fee_amount_7,
  t0.register_student_discount AS register_student_discount_8,
  t0.confirm_start AS confirm_start_9,
  t0.confirm_end AS confirm_end_10,
  t0.sat_exam AS sat_exam_11,
  t0.registration_fee AS registration_fee_12,
  t0.state AS state_13,
  t0.study_year AS study_year_14,
  t0.study_session AS study_session_15,
  t0.study_language AS study_language_16,
  t0.is_deleted AS is_deleted_17,
  t0.file_path AS file_path_18,
  t0.image_path AS image_path_19,
  t0.location AS location_20,
  t0.degree_id AS degree_id_21,
  t0.file_id AS file_id_22,
  t0.image_id AS image_id_23
FROM
  admission t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.register_start AS register_start_4, t0.register_end AS register_end_5, t0.register_fee_amount AS register_fee_amount_6, t0.credit_fee_amount AS credit_fee_amount_7, t0.register_student_discount AS register_student_discount_8, t0.confirm_start AS confirm_start_9, t0.confirm_end AS confirm_end_10, t0.sat_exam AS sat_exam_11, t0.registration_fee AS registration_fee_12, t0.state AS state_13, t0.study_year AS study_year_14, t0.study_session AS study_session_15, t0.study_language AS study_language_16, t0.is_deleted AS is_deleted_17, t0.file_path AS file_path_18, t0.image_path AS image_path_19, t0.location AS location_20, t0.degree_id AS degree_id_21, t0.file_id AS file_id_22, t0.image_id AS image_id_23 FROM admission t0 WHERE t0.id = 11;

SELECT
  t0.id AS id_1,
  t0.group_name AS group_name_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.time_created AS time_created_5,
  t0.admission_id AS admission_id_6
FROM
  global_constant t0
WHERE
  t0.group_name = ?

SELECT t0.id AS id_1, t0.group_name AS group_name_2, t0.name AS name_3, t0.description AS description_4, t0.time_created AS time_created_5, t0.admission_id AS admission_id_6 FROM global_constant t0 WHERE t0.group_name = 'info_channel';

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  admission_user a0_
  LEFT JOIN `user` u1_ ON a0_.user_id = u1_.id
  LEFT JOIN user_info u2_ ON u1_.id = u2_.user_id
  LEFT JOIN payment p3_ ON a0_.payment_register_fee_id = p3_.id
  LEFT JOIN payment p4_ ON a0_.payment_credit_id = p4_.id
  LEFT JOIN admission_user_comment a5_ ON a0_.last_comment_id = a5_.id
WHERE
  a0_.admission_id = ?
  AND a0_.state IN (?, ?, ?, ?, ?)

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM admission_user a0_ LEFT JOIN `user` u1_ ON a0_.user_id = u1_.id LEFT JOIN user_info u2_ ON u1_.id = u2_.user_id LEFT JOIN payment p3_ ON a0_.payment_register_fee_id = p3_.id LEFT JOIN payment p4_ ON a0_.payment_credit_id = p4_.id LEFT JOIN admission_user_comment a5_ ON a0_.last_comment_id = a5_.id WHERE a0_.admission_id = 11 AND a0_.state IN ('R', 'D', 'F', '3', '2');

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.time_created AS time_created_1
FROM
  admission_user a0_
  LEFT JOIN `user` u1_ ON a0_.user_id = u1_.id
  LEFT JOIN user_info u2_ ON u1_.id = u2_.user_id
  LEFT JOIN payment p3_ ON a0_.payment_register_fee_id = p3_.id
  LEFT JOIN payment p4_ ON a0_.payment_credit_id = p4_.id
  LEFT JOIN admission_user_comment a5_ ON a0_.last_comment_id = a5_.id
WHERE
  a0_.admission_id = ?
  AND a0_.state IN (?, ?, ?, ?, ?)
ORDER BY
  a0_.time_created DESC
LIMIT
  20

SELECT DISTINCT a0_.id AS id_0, a0_.time_created AS time_created_1 FROM admission_user a0_ LEFT JOIN `user` u1_ ON a0_.user_id = u1_.id LEFT JOIN user_info u2_ ON u1_.id = u2_.user_id LEFT JOIN payment p3_ ON a0_.payment_register_fee_id = p3_.id LEFT JOIN payment p4_ ON a0_.payment_credit_id = p4_.id LEFT JOIN admission_user_comment a5_ ON a0_.last_comment_id = a5_.id WHERE a0_.admission_id = 11 AND a0_.state IN ('R', 'D', 'F', '3', '2') ORDER BY a0_.time_created DESC LIMIT 20;

SELECT
  a0_.id AS id_0,
  a0_.sat_code AS sat_code_1,
  a0_.type AS type_2,
  a0_.state AS state_3,
  a0_.pub_state AS pub_state_4,
  a0_.time_created AS time_created_5,
  a0_.time_updated AS time_updated_6,
  a0_.fe_id AS fe_id_7,
  u1_.id AS id_8,
  u1_.email AS email_9,
  u1_.super_user AS super_user_10,
  u1_.user_type AS user_type_11,
  u1_.roles AS roles_12,
  u1_.password AS password_13,
  u1_.time_created AS time_created_14,
  u1_.is_deleted AS is_deleted_15,
  u2_.id AS id_16,
  u2_.family_name AS family_name_17,
  u2_.lastname_mn AS lastname_mn_18,
  u2_.lastname_en AS lastname_en_19,
  u2_.firstname_mn AS firstname_mn_20,
  u2_.firstname_en AS firstname_en_21,
  u2_.degree AS degree_22,
  u2_.title AS title_23,
  u2_.reg_num AS reg_num_24,
  u2_.student_code AS student_code_25,
  u2_.gender AS gender_26,
  u2_.birth_date AS birth_date_27,
  u2_.mobile AS mobile_28,
  u2_.phone_home AS phone_home_29,
  u2_.phone_work AS phone_work_30,
  u2_.ethnicity AS ethnicity_31,
  u2_.university AS university_32,
  u2_.academic_field AS academic_field_33,
  u2_.course AS course_34,
  u2_.mobile_2 AS mobile_2_35,
  p3_.id AS id_36,
  p3_.payment_type AS payment_type_37,
  p3_.payment_code AS payment_code_38,
  p3_.amount AS amount_39,
  p3_.amount_paid AS amount_paid_40,
  p3_.description AS description_41,
  p3_.note AS note_42,
  p3_.state AS state_43,
  p3_.time_created AS time_created_44,
  p3_.time_paid AS time_paid_45,
  p4_.id AS id_46,
  p4_.payment_type AS payment_type_47,
  p4_.payment_code AS payment_code_48,
  p4_.amount AS amount_49,
  p4_.amount_paid AS amount_paid_50,
  p4_.description AS description_51,
  p4_.note AS note_52,
  p4_.state AS state_53,
  p4_.time_created AS time_created_54,
  p4_.time_paid AS time_paid_55,
  a5_.id AS id_56,
  a5_.comment AS comment_57,
  a5_.state AS state_58,
  a5_.type AS type_59,
  a5_.time_created AS time_created_60,
  a5_.comment_index AS comment_index_61,
  a0_.admission_id AS admission_id_62,
  a0_.user_id AS user_id_63,
  a0_.info_channel_id AS info_channel_id_64,
  a0_.payment_register_fee_id AS payment_register_fee_id_65,
  a0_.payment_credit_id AS payment_credit_id_66,
  a0_.admission_register_id AS admission_register_id_67,
  a0_.last_comment_id AS last_comment_id_68,
  a0_.admission_discount_id AS admission_discount_id_69,
  u2_.user_id AS user_id_70,
  u2_.province_id AS province_id_71,
  u2_.nationality_id AS nationality_id_72,
  u2_.country_id AS country_id_73,
  u2_.user_education_id AS user_education_id_74,
  u2_.user_addressing_main_id AS user_addressing_main_id_75,
  u2_.user_addressing_current_id AS user_addressing_current_id_76,
  p3_.admission_user_id AS admission_user_id_77,
  p3_.user_customer_id AS user_customer_id_78,
  p3_.user_created_id AS user_created_id_79,
  p3_.last_log_id AS last_log_id_80,
  p4_.admission_user_id AS admission_user_id_81,
  p4_.user_customer_id AS user_customer_id_82,
  p4_.user_created_id AS user_created_id_83,
  p4_.last_log_id AS last_log_id_84,
  a5_.admission_user_id AS admission_user_id_85,
  a5_.user_created_id AS user_created_id_86
FROM
  admission_user a0_
  LEFT JOIN `user` u1_ ON a0_.user_id = u1_.id
  LEFT JOIN user_info u2_ ON u1_.id = u2_.user_id
  LEFT JOIN payment p3_ ON a0_.payment_register_fee_id = p3_.id
  LEFT JOIN payment p4_ ON a0_.payment_credit_id = p4_.id
  LEFT JOIN admission_user_comment a5_ ON a0_.last_comment_id = a5_.id
WHERE
  a0_.admission_id = ?
  AND a0_.state IN (?, ?, ?, ?, ?)
  AND a0_.id IN (?, ?, ?)
ORDER BY
  a0_.time_created DESC

SELECT a0_.id AS id_0, a0_.sat_code AS sat_code_1, a0_.type AS type_2, a0_.state AS state_3, a0_.pub_state AS pub_state_4, a0_.time_created AS time_created_5, a0_.time_updated AS time_updated_6, a0_.fe_id AS fe_id_7, u1_.id AS id_8, u1_.email AS email_9, u1_.super_user AS super_user_10, u1_.user_type AS user_type_11, u1_.roles AS roles_12, u1_.password AS password_13, u1_.time_created AS time_created_14, u1_.is_deleted AS is_deleted_15, u2_.id AS id_16, u2_.family_name AS family_name_17, u2_.lastname_mn AS lastname_mn_18, u2_.lastname_en AS lastname_en_19, u2_.firstname_mn AS firstname_mn_20, u2_.firstname_en AS firstname_en_21, u2_.degree AS degree_22, u2_.title AS title_23, u2_.reg_num AS reg_num_24, u2_.student_code AS student_code_25, u2_.gender AS gender_26, u2_.birth_date AS birth_date_27, u2_.mobile AS mobile_28, u2_.phone_home AS phone_home_29, u2_.phone_work AS phone_work_30, u2_.ethnicity AS ethnicity_31, u2_.university AS university_32, u2_.academic_field AS academic_field_33, u2_.course AS course_34, u2_.mobile_2 AS mobile_2_35, p3_.id AS id_36, p3_.payment_type AS payment_type_37, p3_.payment_code AS payment_code_38, p3_.amount AS amount_39, p3_.amount_paid AS amount_paid_40, p3_.description AS description_41, p3_.note AS note_42, p3_.state AS state_43, p3_.time_created AS time_created_44, p3_.time_paid AS time_paid_45, p4_.id AS id_46, p4_.payment_type AS payment_type_47, p4_.payment_code AS payment_code_48, p4_.amount AS amount_49, p4_.amount_paid AS amount_paid_50, p4_.description AS description_51, p4_.note AS note_52, p4_.state AS state_53, p4_.time_created AS time_created_54, p4_.time_paid AS time_paid_55, a5_.id AS id_56, a5_.comment AS comment_57, a5_.state AS state_58, a5_.type AS type_59, a5_.time_created AS time_created_60, a5_.comment_index AS comment_index_61, a0_.admission_id AS admission_id_62, a0_.user_id AS user_id_63, a0_.info_channel_id AS info_channel_id_64, a0_.payment_register_fee_id AS payment_register_fee_id_65, a0_.payment_credit_id AS payment_credit_id_66, a0_.admission_register_id AS admission_register_id_67, a0_.last_comment_id AS last_comment_id_68, a0_.admission_discount_id AS admission_discount_id_69, u2_.user_id AS user_id_70, u2_.province_id AS province_id_71, u2_.nationality_id AS nationality_id_72, u2_.country_id AS country_id_73, u2_.user_education_id AS user_education_id_74, u2_.user_addressing_main_id AS user_addressing_main_id_75, u2_.user_addressing_current_id AS user_addressing_current_id_76, p3_.admission_user_id AS admission_user_id_77, p3_.user_customer_id AS user_customer_id_78, p3_.user_created_id AS user_created_id_79, p3_.last_log_id AS last_log_id_80, p4_.admission_user_id AS admission_user_id_81, p4_.user_customer_id AS user_customer_id_82, p4_.user_created_id AS user_created_id_83, p4_.last_log_id AS last_log_id_84, a5_.admission_user_id AS admission_user_id_85, a5_.user_created_id AS user_created_id_86 FROM admission_user a0_ LEFT JOIN `user` u1_ ON a0_.user_id = u1_.id LEFT JOIN user_info u2_ ON u1_.id = u2_.user_id LEFT JOIN payment p3_ ON a0_.payment_register_fee_id = p3_.id LEFT JOIN payment p4_ ON a0_.payment_credit_id = p4_.id LEFT JOIN admission_user_comment a5_ ON a0_.last_comment_id = a5_.id WHERE a0_.admission_id = 11 AND a0_.state IN ('R', 'D', 'F', '3', '2') AND a0_.id IN (443, 441, 437) ORDER BY a0_.time_created DESC;

SELECT
  t0.id AS id_1,
  t0.has_issue AS has_issue_2,
  t0.loss_rate AS loss_rate_3,
  t0.user_info_id AS user_info_id_4,
  t0.type_id AS type_id_5,
  t0.reason_id AS reason_id_6
FROM
  user_disability t0
WHERE
  t0.user_info_id = ?

SELECT t0.id AS id_1, t0.has_issue AS has_issue_2, t0.loss_rate AS loss_rate_3, t0.user_info_id AS user_info_id_4, t0.type_id AS type_id_5, t0.reason_id AS reason_id_6 FROM user_disability t0 WHERE t0.user_info_id = 188;

SELECT
  t0.id AS id_1,
  t0.has_issue AS has_issue_2,
  t0.loss_rate AS loss_rate_3,
  t0.user_info_id AS user_info_id_4,
  t0.type_id AS type_id_5,
  t0.reason_id AS reason_id_6
FROM
  user_disability t0
WHERE
  t0.user_info_id = ?

SELECT t0.id AS id_1, t0.has_issue AS has_issue_2, t0.loss_rate AS loss_rate_3, t0.user_info_id AS user_info_id_4, t0.type_id AS type_id_5, t0.reason_id AS reason_id_6 FROM user_disability t0 WHERE t0.user_info_id = 259;

SELECT
  u0_.id AS id_0,
  u1_.lesson_code AS lesson_code_1,
  max(u1_.lesson_score) AS sclr_2,
  max(u1_.corr_scaled_score) AS sclr_3
FROM
  user_sat_result u1_
  LEFT JOIN user_sat u2_ ON u1_.user_sat_id = u2_.id
  LEFT JOIN user_info u0_ ON u2_.user_info_id = u0_.id
WHERE
  u2_.sat_year >= ?
  AND u2_.is_deleted <> ?
  AND u0_.id IN (?, ?)
GROUP BY
  u0_.id,
  u1_.lesson_code

SELECT u0_.id AS id_0, u1_.lesson_code AS lesson_code_1, max(u1_.lesson_score) AS sclr_2, max(u1_.corr_scaled_score) AS sclr_3 FROM user_sat_result u1_ LEFT JOIN user_sat u2_ ON u1_.user_sat_id = u2_.id LEFT JOIN user_info u0_ ON u2_.user_info_id = u0_.id WHERE u2_.sat_year >= 2023 AND u2_.is_deleted <> 1 AND u0_.id IN (188, 259) GROUP BY u0_.id, u1_.lesson_code;

SELECT
  sum(p0_.amount_paid) AS sclr_0
FROM
  payment p0_
WHERE
  p0_.payment_code = ?
  AND p0_.state = ?
  AND p0_.payment_type = ?

SELECT sum(p0_.amount_paid) AS sclr_0 FROM payment p0_ WHERE p0_.payment_code = 'C2' AND p0_.state = 'PAID' AND p0_.payment_type = 'admission_register';

SELECT
  sum(p0_.amount_paid) AS sclr_0
FROM
  payment p0_
WHERE
  p0_.payment_code = ?
  AND p0_.state = ?
  AND p0_.payment_type = ?

SELECT sum(p0_.amount_paid) AS sclr_0 FROM payment p0_ WHERE p0_.payment_code = 'C2' AND p0_.state = 'PAID' AND p0_.payment_type = 'admission_credit';