Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.expire_date AS expire_date_2,
  t0.start_date AS start_date_3,
  t0.amount AS amount_4,
  t0.created_on AS created_on_5,
  t0.payment_from AS payment_from_6,
  t0.reciept AS reciept_7,
  t0.member_id AS member_id_8,
  t0.admin_id AS admin_id_9
FROM
  membership_renew_history t0
WHERE
  t0.member_id = ?

SELECT t0.id AS id_1, t0.expire_date AS expire_date_2, t0.start_date AS start_date_3, t0.amount AS amount_4, t0.created_on AS created_on_5, t0.payment_from AS payment_from_6, t0.reciept AS reciept_7, t0.member_id AS member_id_8, t0.admin_id AS admin_id_9 FROM membership_renew_history t0 WHERE t0.member_id = 10608;

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

SELECT
  m0_.id AS id_0,
  m0_.type AS type_1,
  m0_.class AS class_2,
  m0_.code AS code_3,
  m0_.sur_name AS sur_name_4,
  m0_.name AS name_5,
  m0_.address1 AS address1_6,
  m0_.address2 AS address2_7,
  m0_.address3 AS address3_8,
  m0_.city AS city_9,
  m0_.pin AS pin_10,
  m0_.phone AS phone_11,
  m0_.sub_type AS sub_type_12,
  m0_.is_foreign AS is_foreign_13,
  m0_.is_suspend AS is_suspend_14,
  m0_.subscription_date AS subscription_date_15,
  m0_.expire_date AS expire_date_16,
  m0_.temp_date AS temp_date_17,
  m0_.mag_copy AS mag_copy_18,
  m0_.mag_cop1 AS mag_cop1_19,
  m0_.remarks AS remarks_20,
  m0_.language AS language_21,
  m0_.old_code AS old_code_22,
  m0_.mailing_order AS mailing_order_23,
  m0_.registration_date AS registration_date_24,
  m0_.subscription_type AS subscription_type_25,
  m0_.amount AS amount_26,
  m0_.is_paid AS is_paid_27,
  m0_.is_verified_by_circle AS is_verified_by_circle_28,
  m0_.is_old AS is_old_29,
  m0_.manual_booking_ref AS manual_booking_ref_30,
  m0_.mobile AS mobile_31,
  m0_.is_by_hand AS is_by_hand_32,
  m0_.dispatch_mode AS dispatch_mode_33,
  m0_.email AS email_34,
  m0_.is_print AS is_print_35,
  m0_.payment_type AS payment_type_36,
  m0_.uuid AS uuid_37,
  m0_.created_on AS created_on_38,
  m0_.registered_by AS registered_by_39,
  m0_.subscription_start_date AS subscription_start_date_40,
  m0_.registered_from AS registered_from_41,
  m0_.ip AS ip_42,
  m0_.is_old_lifetime AS is_old_lifetime_43,
  m0_.state AS state_44,
  m0_.old_lifetime_magazine AS old_lifetime_magazine_45,
  m0_.old_lifetime_suspended_on AS old_lifetime_suspended_on_46,
  m0_.circle_id AS circle_id_47,
  m0_.member_id AS member_id_48,
  m0_.country_id AS country_id_49,
  m0_.destination_circle_id AS destination_circle_id_50,
  m0_.by_hand_master_id AS by_hand_master_id_51,
  m0_.destination_zone_id AS destination_zone_id_52,
  m0_.is_admin_id AS is_admin_id_53,
  m0_.subscription_number_id AS subscription_number_id_54,
  m0_.user_id AS user_id_55
FROM
  magazine_subscription m0_
WHERE
  m0_.member_id = ?
ORDER BY
  m0_.id DESC
LIMIT
  10

SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.class AS class_2, m0_.code AS code_3, m0_.sur_name AS sur_name_4, m0_.name AS name_5, m0_.address1 AS address1_6, m0_.address2 AS address2_7, m0_.address3 AS address3_8, m0_.city AS city_9, m0_.pin AS pin_10, m0_.phone AS phone_11, m0_.sub_type AS sub_type_12, m0_.is_foreign AS is_foreign_13, m0_.is_suspend AS is_suspend_14, m0_.subscription_date AS subscription_date_15, m0_.expire_date AS expire_date_16, m0_.temp_date AS temp_date_17, m0_.mag_copy AS mag_copy_18, m0_.mag_cop1 AS mag_cop1_19, m0_.remarks AS remarks_20, m0_.language AS language_21, m0_.old_code AS old_code_22, m0_.mailing_order AS mailing_order_23, m0_.registration_date AS registration_date_24, m0_.subscription_type AS subscription_type_25, m0_.amount AS amount_26, m0_.is_paid AS is_paid_27, m0_.is_verified_by_circle AS is_verified_by_circle_28, m0_.is_old AS is_old_29, m0_.manual_booking_ref AS manual_booking_ref_30, m0_.mobile AS mobile_31, m0_.is_by_hand AS is_by_hand_32, m0_.dispatch_mode AS dispatch_mode_33, m0_.email AS email_34, m0_.is_print AS is_print_35, m0_.payment_type AS payment_type_36, m0_.uuid AS uuid_37, m0_.created_on AS created_on_38, m0_.registered_by AS registered_by_39, m0_.subscription_start_date AS subscription_start_date_40, m0_.registered_from AS registered_from_41, m0_.ip AS ip_42, m0_.is_old_lifetime AS is_old_lifetime_43, m0_.state AS state_44, m0_.old_lifetime_magazine AS old_lifetime_magazine_45, m0_.old_lifetime_suspended_on AS old_lifetime_suspended_on_46, m0_.circle_id AS circle_id_47, m0_.member_id AS member_id_48, m0_.country_id AS country_id_49, m0_.destination_circle_id AS destination_circle_id_50, m0_.by_hand_master_id AS by_hand_master_id_51, m0_.destination_zone_id AS destination_zone_id_52, m0_.is_admin_id AS is_admin_id_53, m0_.subscription_number_id AS subscription_number_id_54, m0_.user_id AS user_id_55 FROM magazine_subscription m0_ WHERE m0_.member_id = 10608 ORDER BY m0_.id DESC LIMIT 10;

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(m0_.id) AS sclr_0
FROM
  magazine_subscription m0_
WHERE
  m0_.member_id = ?

SELECT count(m0_.id) AS sclr_0 FROM magazine_subscription m0_ WHERE m0_.member_id = 10608;

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

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

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