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

SELECT
  s0_.id AS id_0,
  s0_.code AS code_1,
  s0_.name AS name_2,
  s0_.address1 AS address1_3,
  s0_.address2 AS address2_4,
  s0_.address3 AS address3_5,
  s0_.city AS city_6,
  s0_.phone AS phone_7,
  s0_.pin AS pin_8,
  s0_.email AS email_9,
  s0_.roles AS roles_10,
  s0_.password AS password_11,
  s0_.mobile AS mobile_12,
  s0_.password_reset_key AS password_reset_key_13,
  s0_.password_reset_key_time AS password_reset_key_time_14,
  s0_.is_valid AS is_valid_15,
  s0_.teacher_name AS teacher_name_16,
  s0_.teacher_email AS teacher_email_17,
  s0_.teacher_mobile AS teacher_mobile_18,
  s0_.is_verified AS is_verified_19,
  s0_.deleted AS deleted_20,
  s0_.is_unsubscribe AS is_unsubscribe_21,
  s0_.unsubscribe_at AS unsubscribe_at_22,
  s0_.unsubscribe_key AS unsubscribe_key_23,
  s0_.circle_id AS circle_id_24,
  s0_.state_id AS state_id_25
FROM
  school s0_
WHERE
  (
    s0_.id LIKE ?
    OR s0_.code LIKE ?
    OR s0_.name LIKE ?
    OR s0_.city LIKE ?
    OR s0_.address1 LIKE ?
    OR s0_.address2 LIKE ?
    OR s0_.email LIKE ?
    OR s0_.mobile LIKE ?
  )
  AND s0_.circle_id = ?
  AND s0_.deleted = ?
ORDER BY
  s0_.id DESC
LIMIT
  100

SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.name AS name_2, s0_.address1 AS address1_3, s0_.address2 AS address2_4, s0_.address3 AS address3_5, s0_.city AS city_6, s0_.phone AS phone_7, s0_.pin AS pin_8, s0_.email AS email_9, s0_.roles AS roles_10, s0_.password AS password_11, s0_.mobile AS mobile_12, s0_.password_reset_key AS password_reset_key_13, s0_.password_reset_key_time AS password_reset_key_time_14, s0_.is_valid AS is_valid_15, s0_.teacher_name AS teacher_name_16, s0_.teacher_email AS teacher_email_17, s0_.teacher_mobile AS teacher_mobile_18, s0_.is_verified AS is_verified_19, s0_.deleted AS deleted_20, s0_.is_unsubscribe AS is_unsubscribe_21, s0_.unsubscribe_at AS unsubscribe_at_22, s0_.unsubscribe_key AS unsubscribe_key_23, s0_.circle_id AS circle_id_24, s0_.state_id AS state_id_25 FROM school s0_ WHERE (s0_.id LIKE '%BH%' OR s0_.code LIKE '%BH%' OR s0_.name LIKE '%BH%' OR s0_.city LIKE '%BH%' OR s0_.address1 LIKE '%BH%' OR s0_.address2 LIKE '%BH%' OR s0_.email LIKE '%BH%' OR s0_.mobile LIKE '%BH%') AND s0_.circle_id = 555 AND s0_.deleted = 0 ORDER BY s0_.id DESC LIMIT 100;

SELECT
  count(s0_.id) AS sclr_0
FROM
  school s0_
WHERE
  (
    s0_.id LIKE ?
    OR s0_.code LIKE ?
    OR s0_.name LIKE ?
    OR s0_.city LIKE ?
    OR s0_.address1 LIKE ?
    OR s0_.address2 LIKE ?
    OR s0_.email LIKE ?
    OR s0_.mobile LIKE ?
  )
  AND s0_.circle_id = ?
  AND s0_.deleted = ?

SELECT count(s0_.id) AS sclr_0 FROM school s0_ WHERE (s0_.id LIKE '%BH%' OR s0_.code LIKE '%BH%' OR s0_.name LIKE '%BH%' OR s0_.city LIKE '%BH%' OR s0_.address1 LIKE '%BH%' OR s0_.address2 LIKE '%BH%' OR s0_.email LIKE '%BH%' OR s0_.mobile LIKE '%BH%') AND s0_.circle_id = 555 AND s0_.deleted = 0;

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

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

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

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.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 = 19;