Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.msf_code AS msf_code_5,
  t0.msf_old AS msf_old_6,
  t0.name AS name_7,
  t0.father_name AS father_name_8,
  t0.address1 AS address1_9,
  t0.address2 AS address2_10,
  t0.address3 AS address3_11,
  t0.city AS city_12,
  t0.phones AS phones_13,
  t0.education AS education_14,
  t0.amrit_dhari AS amrit_dhari_15,
  t0.subs_date AS subs_date_16,
  t0.job_name AS job_name_17,
  t0.job_addr1 AS job_addr1_18,
  t0.job_addr2 AS job_addr2_19,
  t0.vehicle AS vehicle_20,
  t0.suspend AS suspend_21,
  t0.entry_date AS entry_date_22,
  t0.subc_dtf AS subc_dtf_23,
  t0.subc_dtt AS subc_dtt_24,
  t0.mobile AS mobile_25,
  t0.is_mobile_verified AS is_mobile_verified_26,
  t0.mobile_verification_code AS mobile_verification_code_27,
  t0.mobile_verification_date AS mobile_verification_date_28,
  t0.email AS email_29,
  t0.email_verification_date AS email_verification_date_30,
  t0.email_verification_code AS email_verification_code_31,
  t0.marital_status AS marital_status_32,
  t0.date_of_birth AS date_of_birth_33,
  t0.pincode AS pincode_34,
  t0.update_on AS update_on_35,
  t0.education_stage AS education_stage_36,
  t0.education_type AS education_type_37,
  t0.spouse_name AS spouse_name_38,
  t0.gender AS gender_39,
  t0.expire_date AS expire_date_40,
  t0.membership_type AS membership_type_41,
  t0.status AS status_42,
  t0.password_reset_key AS password_reset_key_43,
  t0.password_reset_key_time AS password_reset_key_time_44,
  t0.auto_login_key AS auto_login_key_45,
  t0.m_app_key AS m_app_key_46,
  t0.is_deleted AS is_deleted_47,
  t0.reason AS reason_48,
  t0.guid AS guid_49,
  t0.ref_url AS ref_url_50,
  t0.old_key AS old_key_51,
  t0.circle_id AS circle_id_52,
  t0.country_id AS country_id_53,
  t0.state_id AS state_id_54
FROM
  member t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.msf_code AS msf_code_5, t0.msf_old AS msf_old_6, t0.name AS name_7, t0.father_name AS father_name_8, t0.address1 AS address1_9, t0.address2 AS address2_10, t0.address3 AS address3_11, t0.city AS city_12, t0.phones AS phones_13, t0.education AS education_14, t0.amrit_dhari AS amrit_dhari_15, t0.subs_date AS subs_date_16, t0.job_name AS job_name_17, t0.job_addr1 AS job_addr1_18, t0.job_addr2 AS job_addr2_19, t0.vehicle AS vehicle_20, t0.suspend AS suspend_21, t0.entry_date AS entry_date_22, t0.subc_dtf AS subc_dtf_23, t0.subc_dtt AS subc_dtt_24, t0.mobile AS mobile_25, t0.is_mobile_verified AS is_mobile_verified_26, t0.mobile_verification_code AS mobile_verification_code_27, t0.mobile_verification_date AS mobile_verification_date_28, t0.email AS email_29, t0.email_verification_date AS email_verification_date_30, t0.email_verification_code AS email_verification_code_31, t0.marital_status AS marital_status_32, t0.date_of_birth AS date_of_birth_33, t0.pincode AS pincode_34, t0.update_on AS update_on_35, t0.education_stage AS education_stage_36, t0.education_type AS education_type_37, t0.spouse_name AS spouse_name_38, t0.gender AS gender_39, t0.expire_date AS expire_date_40, t0.membership_type AS membership_type_41, t0.status AS status_42, t0.password_reset_key AS password_reset_key_43, t0.password_reset_key_time AS password_reset_key_time_44, t0.auto_login_key AS auto_login_key_45, t0.m_app_key AS m_app_key_46, t0.is_deleted AS is_deleted_47, t0.reason AS reason_48, t0.guid AS guid_49, t0.ref_url AS ref_url_50, t0.old_key AS old_key_51, t0.circle_id AS circle_id_52, t0.country_id AS country_id_53, t0.state_id AS state_id_54 FROM member t0 WHERE t0.id = 4510;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_current AS is_current_3,
  t0.result_declared AS result_declared_4
FROM
  dp_season t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_current AS is_current_3, t0.result_declared AS result_declared_4 FROM dp_season t0 WHERE t0.id = 5 LIMIT 1;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.father_name AS father_name_2,
  d0_.email AS email_3,
  d0_.mobile AS mobile_4,
  d0_.class AS class_5,
  d0_.mother_name AS mother_name_6,
  d0_.is_paid AS is_paid_7,
  d0_.uni_key AS uni_key_8,
  d0_.attendance_status AS attendance_status_9,
  d0_.gurbani AS gurbani_10,
  d0_.sik_history AS sik_history_11,
  d0_.gurmat AS gurmat_12,
  d0_.total_marks AS total_marks_13,
  d0_.marks_percentage AS marks_percentage_14,
  d0_.marks_date AS marks_date_15,
  d0_.attendance_date AS attendance_date_16,
  d0_.total AS total_17,
  d0_.dp_roll_number AS dp_roll_number_18,
  d0_.is_punjab AS is_punjab_19,
  d0_.grade AS grade_20,
  d0_.grace_number_data AS grace_number_data_21,
  d0_.certificate_number AS certificate_number_22,
  d0_.merit AS merit_23,
  count(d0_.id) AS sclr_24,
  sum(d1_.price) AS sclr_25,
  s2_.id AS id_26,
  s2_.name AS name_27,
  s2_.mobile AS mobile_28,
  d3_.id AS id_29,
  d0_.dp_group_id AS dp_group_id_30,
  d0_.school_id AS school_id_31,
  d0_.dp_season_id AS dp_season_id_32,
  d0_.dp_exam_id AS dp_exam_id_33,
  d0_.dp_languages_id AS dp_languages_id_34,
  d0_.dp_student_lot_id AS dp_student_lot_id_35,
  d0_.roll_number_id AS roll_number_id_36,
  d0_.center_id AS center_id_37,
  d0_.filled_by_id AS filled_by_id_38,
  d0_.attendence_user_id AS attendence_user_id_39
FROM
  dp_student d0_
  LEFT JOIN school s2_ ON d0_.school_id = s2_.id
  LEFT JOIN circle c4_ ON s2_.circle_id = c4_.id
  LEFT JOIN zone z5_ ON c4_.zone_id = z5_.id
  LEFT JOIN dp_student_lot d3_ ON d0_.dp_student_lot_id = d3_.id
  LEFT JOIN dp_group d1_ ON d0_.dp_group_id = d1_.id
WHERE
  d0_.is_paid = ?
  AND c4_.id = ?
  AND d0_.dp_season_id = ?
  AND s2_.deleted = ?
GROUP BY
  s2_.id
ORDER BY
  sclr_24 ASC
LIMIT
  100

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.father_name AS father_name_2, d0_.email AS email_3, d0_.mobile AS mobile_4, d0_.class AS class_5, d0_.mother_name AS mother_name_6, d0_.is_paid AS is_paid_7, d0_.uni_key AS uni_key_8, d0_.attendance_status AS attendance_status_9, d0_.gurbani AS gurbani_10, d0_.sik_history AS sik_history_11, d0_.gurmat AS gurmat_12, d0_.total_marks AS total_marks_13, d0_.marks_percentage AS marks_percentage_14, d0_.marks_date AS marks_date_15, d0_.attendance_date AS attendance_date_16, d0_.total AS total_17, d0_.dp_roll_number AS dp_roll_number_18, d0_.is_punjab AS is_punjab_19, d0_.grade AS grade_20, d0_.grace_number_data AS grace_number_data_21, d0_.certificate_number AS certificate_number_22, d0_.merit AS merit_23, count(d0_.id) AS sclr_24, sum(d1_.price) AS sclr_25, s2_.id AS id_26, s2_.name AS name_27, s2_.mobile AS mobile_28, d3_.id AS id_29, d0_.dp_group_id AS dp_group_id_30, d0_.school_id AS school_id_31, d0_.dp_season_id AS dp_season_id_32, d0_.dp_exam_id AS dp_exam_id_33, d0_.dp_languages_id AS dp_languages_id_34, d0_.dp_student_lot_id AS dp_student_lot_id_35, d0_.roll_number_id AS roll_number_id_36, d0_.center_id AS center_id_37, d0_.filled_by_id AS filled_by_id_38, d0_.attendence_user_id AS attendence_user_id_39 FROM dp_student d0_ LEFT JOIN school s2_ ON d0_.school_id = s2_.id LEFT JOIN circle c4_ ON s2_.circle_id = c4_.id LEFT JOIN zone z5_ ON c4_.zone_id = z5_.id LEFT JOIN dp_student_lot d3_ ON d0_.dp_student_lot_id = d3_.id LEFT JOIN dp_group d1_ ON d0_.dp_group_id = d1_.id WHERE d0_.is_paid = 1 AND c4_.id = 12 AND d0_.dp_season_id = 5 AND s2_.deleted = 0 GROUP BY s2_.id ORDER BY sclr_24 ASC LIMIT 100;

SELECT
  count(d0_.id) AS sclr_0
FROM
  dp_student d0_
  INNER JOIN school s1_ ON d0_.school_id = s1_.id
  INNER JOIN circle c2_ ON s1_.circle_id = c2_.id
  INNER JOIN zone z3_ ON c2_.zone_id = z3_.id
  INNER JOIN dp_student_lot d4_ ON d0_.dp_student_lot_id = d4_.id
  INNER JOIN dp_group d5_ ON d0_.dp_group_id = d5_.id
WHERE
  d0_.is_paid = ?
  AND c2_.id = ?
  AND d0_.dp_season_id = ?
  AND s1_.deleted = ?
GROUP BY
  s1_.id

SELECT count(d0_.id) AS sclr_0 FROM dp_student d0_ INNER JOIN school s1_ ON d0_.school_id = s1_.id INNER JOIN circle c2_ ON s1_.circle_id = c2_.id INNER JOIN zone z3_ ON c2_.zone_id = z3_.id INNER JOIN dp_student_lot d4_ ON d0_.dp_student_lot_id = d4_.id INNER JOIN dp_group d5_ ON d0_.dp_group_id = d5_.id WHERE d0_.is_paid = 1 AND c2_.id = 12 AND d0_.dp_season_id = 5 AND s1_.deleted = 0 GROUP BY s1_.id;

SELECT
  count(d0_.id) AS sclr_0,
  d1_.id AS id_1,
  d1_.name AS name_2
FROM
  dp_student d0_
  INNER JOIN dp_group d1_ ON d0_.dp_group_id = d1_.id
  INNER JOIN school s2_ ON d0_.school_id = s2_.id
  INNER JOIN circle c3_ ON s2_.circle_id = c3_.id
  INNER JOIN dp_student_lot d4_ ON d0_.dp_student_lot_id = d4_.id
  INNER JOIN dp_season d5_ ON d0_.dp_season_id = d5_.id
WHERE
  s2_.id = ?
  AND d0_.is_paid = 1
  AND d5_.is_current = 1
GROUP BY
  d1_.id,
  d1_.name,
  d1_.classes,
  d1_.price
ORDER BY
  sclr_0 DESC

SELECT count(d0_.id) AS sclr_0, d1_.id AS id_1, d1_.name AS name_2 FROM dp_student d0_ INNER JOIN dp_group d1_ ON d0_.dp_group_id = d1_.id INNER JOIN school s2_ ON d0_.school_id = s2_.id INNER JOIN circle c3_ ON s2_.circle_id = c3_.id INNER JOIN dp_student_lot d4_ ON d0_.dp_student_lot_id = d4_.id INNER JOIN dp_season d5_ ON d0_.dp_season_id = d5_.id WHERE s2_.id = 286 AND d0_.is_paid = 1 AND d5_.is_current = 1 GROUP BY d1_.id, d1_.name, d1_.classes, d1_.price ORDER BY sclr_0 DESC;