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_.id LIKE ?
    OR c0_.name LIKE ?
    OR c0_.roll_number LIKE ?
  )
  AND c0_.language_id = ?
  AND c0_.correspondence_course_id = ?
  AND c0_.roll_number IS NOT NULL
ORDER BY
  c0_.id DESC
LIMIT
  10
OFFSET
  20

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_.id LIKE '%5447%' OR c0_.name LIKE '%5447%' OR c0_.roll_number LIKE '%5447%') AND c0_.language_id = 1 AND c0_.correspondence_course_id = '1' AND c0_.roll_number IS NOT NULL ORDER BY c0_.id DESC LIMIT 10 OFFSET 20;

SELECT
  count(c0_.id) AS sclr_0
FROM
  ccstudent c0_
WHERE
  (
    c0_.id LIKE ?
    OR c0_.name LIKE ?
    OR c0_.roll_number LIKE ?
  )
  AND c0_.language_id = ?
  AND c0_.correspondence_course_id = ?
  AND c0_.roll_number IS NOT NULL

SELECT count(c0_.id) AS sclr_0 FROM ccstudent c0_ WHERE (c0_.id LIKE '%5447%' OR c0_.name LIKE '%5447%' OR c0_.roll_number LIKE '%5447%') AND c0_.language_id = 1 AND c0_.correspondence_course_id = '1' AND c0_.roll_number IS NOT NULL;

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

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

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

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.deleted AS deleted_6,
  t0.deleted_on AS deleted_on_7
FROM
  admin t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.deleted AS deleted_6, t0.deleted_on AS deleted_on_7 FROM admin t0 WHERE t0.id = 8;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM cclanguages t0 WHERE t0.code = 'PB' LIMIT 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.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
  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;