Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.father_name AS father_name_2,
  c0_.address AS address_3,
  c0_.city AS city_4,
  c0_.pin AS pin_5,
  c0_.qualification AS qualification_6,
  c0_.occupation AS occupation_7,
  c0_.is_amritdhari AS is_amritdhari_8,
  c0_.phone AS phone_9,
  c0_.roll_number AS roll_number_10,
  c0_.date_of_birth AS date_of_birth_11,
  c0_.mother_name AS mother_name_12,
  c0_.is_paid AS is_paid_13,
  c0_.mobile AS mobile_14,
  c0_.certificate_number AS certificate_number_15,
  c0_.certificate_date AS certificate_date_16,
  c0_.reciept AS reciept_17,
  c0_.created_by AS created_by_18,
  c0_.gender AS gender_19,
  c0_.relation AS relation_20,
  c0_.created_on AS created_on_21,
  c0_.name_punjabi AS name_punjabi_22,
  c0_.father_name_punjabi AS father_name_punjabi_23,
  c0_.address_punjabi AS address_punjabi_24,
  c0_.darja_punjabi AS darja_punjabi_25,
  c0_.payment_mode AS payment_mode_26,
  c0_.amount AS amount_27,
  c0_.email AS email_28,
  c0_.prospectus AS prospectus_29,
  c0_.circle_id AS circle_id_30,
  c0_.correspondence_course_id AS correspondence_course_id_31,
  c0_.language_id AS language_id_32,
  c0_.user_id AS user_id_33,
  c0_.country_id AS country_id_34,
  c0_.member_id AS member_id_35
FROM
  ccstudent c0_
WHERE
  c0_.circle_id = ?
ORDER BY
  c0_.id DESC
LIMIT
  10

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.father_name AS father_name_2, c0_.address AS address_3, c0_.city AS city_4, c0_.pin AS pin_5, c0_.qualification AS qualification_6, c0_.occupation AS occupation_7, c0_.is_amritdhari AS is_amritdhari_8, c0_.phone AS phone_9, c0_.roll_number AS roll_number_10, c0_.date_of_birth AS date_of_birth_11, c0_.mother_name AS mother_name_12, c0_.is_paid AS is_paid_13, c0_.mobile AS mobile_14, c0_.certificate_number AS certificate_number_15, c0_.certificate_date AS certificate_date_16, c0_.reciept AS reciept_17, c0_.created_by AS created_by_18, c0_.gender AS gender_19, c0_.relation AS relation_20, c0_.created_on AS created_on_21, c0_.name_punjabi AS name_punjabi_22, c0_.father_name_punjabi AS father_name_punjabi_23, c0_.address_punjabi AS address_punjabi_24, c0_.darja_punjabi AS darja_punjabi_25, c0_.payment_mode AS payment_mode_26, c0_.amount AS amount_27, c0_.email AS email_28, c0_.prospectus AS prospectus_29, c0_.circle_id AS circle_id_30, c0_.correspondence_course_id AS correspondence_course_id_31, c0_.language_id AS language_id_32, c0_.user_id AS user_id_33, c0_.country_id AS country_id_34, c0_.member_id AS member_id_35 FROM ccstudent c0_ WHERE c0_.circle_id = 357 ORDER BY c0_.id DESC LIMIT 10;

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 = 3818;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  cclanguages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM cclanguages t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.iso AS iso_3,
  t0.is_enabled AS is_enabled_4,
  t0.country_id AS country_id_5
FROM
  state t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.iso AS iso_3, t0.is_enabled AS is_enabled_4, t0.country_id AS country_id_5 FROM state t0 WHERE t0.id = 49;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.star AS star_3,
  t0.wz_code AS wz_code_4,
  t0.circle_code AS circle_code_5,
  t0.circle_name AS circle_name_6,
  t0.circle_name1 AS circle_name1_7,
  t0.circle_add1 AS circle_add1_8,
  t0.circle_add2 AS circle_add2_9,
  t0.circle_add3 AS circle_add3_10,
  t0.circle_city AS circle_city_11,
  t0.circle_state AS circle_state_12,
  t0.pincode AS pincode_13,
  t0.phone AS phone_14,
  t0.punjabi_magzine AS punjabi_magzine_15,
  t0.hindi_magzine AS hindi_magzine_16,
  t0.free_lit_p AS free_lit_p_17,
  t0.free_lit_h AS free_lit_h_18,
  t0.bp_mag AS bp_mag_19,
  t0.category AS category_20,
  t0.head_circle AS head_circle_21,
  t0.flag AS flag_22,
  t0.suspend AS suspend_23,
  t0.lbls AS lbls_24,
  t0.lbl_s1 AS lbl_s1_25,
  t0.bilty AS bilty_26,
  t0.line1 AS line1_27,
  t0.line2 AS line2_28,
  t0.line3 AS line3_29,
  t0.line4 AS line4_30,
  t0.line5 AS line5_31,
  t0.total AS total_32,
  t0.bh_mag AS bh_mag_33,
  t0.status AS status_34,
  t0.email AS email_35,
  t0.zoho_customer_id AS zoho_customer_id_36,
  t0.district_id AS district_id_37,
  t0.zone_id AS zone_id_38,
  t0.zone_fixer_id AS zone_fixer_id_39,
  t0.road_route_id AS road_route_id_40
FROM
  circle t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.star AS star_3, t0.wz_code AS wz_code_4, t0.circle_code AS circle_code_5, t0.circle_name AS circle_name_6, t0.circle_name1 AS circle_name1_7, t0.circle_add1 AS circle_add1_8, t0.circle_add2 AS circle_add2_9, t0.circle_add3 AS circle_add3_10, t0.circle_city AS circle_city_11, t0.circle_state AS circle_state_12, t0.pincode AS pincode_13, t0.phone AS phone_14, t0.punjabi_magzine AS punjabi_magzine_15, t0.hindi_magzine AS hindi_magzine_16, t0.free_lit_p AS free_lit_p_17, t0.free_lit_h AS free_lit_h_18, t0.bp_mag AS bp_mag_19, t0.category AS category_20, t0.head_circle AS head_circle_21, t0.flag AS flag_22, t0.suspend AS suspend_23, t0.lbls AS lbls_24, t0.lbl_s1 AS lbl_s1_25, t0.bilty AS bilty_26, t0.line1 AS line1_27, t0.line2 AS line2_28, t0.line3 AS line3_29, t0.line4 AS line4_30, t0.line5 AS line5_31, t0.total AS total_32, t0.bh_mag AS bh_mag_33, t0.status AS status_34, t0.email AS email_35, t0.zoho_customer_id AS zoho_customer_id_36, t0.district_id AS district_id_37, t0.zone_id AS zone_id_38, t0.zone_fixer_id AS zone_fixer_id_39, t0.road_route_id AS road_route_id_40 FROM circle t0 WHERE t0.id = 357;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.code AS code_6,
  t0.phone AS phone_7,
  t0.dollar AS dollar_8,
  t0.is_foreign AS is_foreign_9,
  t0.star AS star_10,
  t0.category AS category_11,
  t0.total AS total_12,
  t0.last_update_on AS last_update_on_13,
  t0.email AS email_14,
  t0.state_id AS state_id_15
FROM
  zone 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.name AS name_5, t0.code AS code_6, t0.phone AS phone_7, t0.dollar AS dollar_8, t0.is_foreign AS is_foreign_9, t0.star AS star_10, t0.category AS category_11, t0.total AS total_12, t0.last_update_on AS last_update_on_13, t0.email AS email_14, t0.state_id AS state_id_15 FROM zone t0 WHERE t0.id = 24;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.iso AS iso_3,
  t0.is_enabled AS is_enabled_4,
  t0.calling_code AS calling_code_5
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.iso AS iso_3, t0.is_enabled AS is_enabled_4, t0.calling_code AS calling_code_5 FROM country t0 WHERE t0.id = 1;

SELECT
  count(c0_.id) AS sclr_0
FROM
  ccstudent c0_
WHERE
  c0_.circle_id = ?

SELECT count(c0_.id) AS sclr_0 FROM ccstudent c0_ WHERE c0_.circle_id = 357;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.admission_fee AS admission_fee_3,
  t0.online AS online_4
FROM
  correspondence_course t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.admission_fee AS admission_fee_3, t0.online AS online_4 FROM correspondence_course t0 WHERE t0.id = 1;