Symfony Profiler

SELECT 
  t0.applicant_id AS applicant_id_1, 
  t0.sync_flag AS sync_flag_2, 
  t0.schedule_available_flag AS schedule_available_flag_3, 
  t0.device_id AS device_id_4, 
  t0.device_id_locked_flag AS device_id_locked_flag_5, 
  t0.lock_device_id_on_next_login_flag AS lock_device_id_on_next_login_flag_6, 
  t0.username AS username_7, 
  t0.email AS email_8, 
  t0.o_auth_unique_id AS o_auth_unique_id_9, 
  t0.o_auth_email AS o_auth_email_10, 
  t0.fb_unique_id AS fb_unique_id_11, 
  t0.li_unique_id AS li_unique_id_12, 
  t0.google_unique_id AS google_unique_id_13, 
  t0.fb_profile_link AS fb_profile_link_14, 
  t0.fb_profile_id AS fb_profile_id_15, 
  t0.ig_profile_link AS ig_profile_link_16, 
  t0.ig_profile_id AS ig_profile_id_17, 
  t0.li_profile_link AS li_profile_link_18, 
  t0.li_profile_id AS li_profile_id_19, 
  t0.user_app_ids AS user_app_ids_20, 
  t0.user_types_by_app_ids AS user_types_by_app_ids_21, 
  t0.password AS password_22, 
  t0.temp_password AS temp_password_23, 
  t0.salt AS salt_24, 
  t0.email_verification_hash AS email_verification_hash_25, 
  t0.phone_verification_hash AS phone_verification_hash_26, 
  t0.trigger_reset_password AS trigger_reset_password_27, 
  t0.otp_action_id AS otp_action_id_28, 
  t0.otp AS otp_29, 
  t0.otp_expire_ts AS otp_expire_ts_30, 
  t0.forgot_password_token AS forgot_password_token_31, 
  t0.forgot_password_token_expire_ts AS forgot_password_token_expire_ts_32, 
  t0.is_email_verified AS is_email_verified_33, 
  t0.is_phone_verified AS is_phone_verified_34, 
  t0.is_banned AS is_banned_35, 
  t0.ban_expires AS ban_expires_36, 
  t0.strike_count AS strike_count_37, 
  t0.strike_threshold AS strike_threshold_38, 
  t0.account_status AS account_status_39, 
  t0.student_level AS student_level_40, 
  t0.job_applicant_level AS job_applicant_level_41, 
  t0.consultant_level AS consultant_level_42, 
  t0.nationality_country_id AS nationality_country_id_43, 
  t0.current_country_id AS current_country_id_44, 
  t0.user_id AS user_id_45, 
  t0.firstname AS firstname_46, 
  t0.lastname AS lastname_47, 
  t0.image AS image_48, 
  t0.is_img_legal AS is_img_legal_49, 
  t0.nid AS nid_50, 
  t0.dob AS dob_51, 
  t0.sex AS sex_52, 
  t0.father AS father_53, 
  t0.mother AS mother_54, 
  t0.spouse AS spouse_55, 
  t0.child_1 AS child_1_56, 
  t0.child_2 AS child_2_57, 
  t0.blood AS blood_58, 
  t0.phone AS phone_59, 
  t0.phone_with_country_code AS phone_with_country_code_60, 
  t0.phone_country_code AS phone_country_code_61, 
  t0.curr_addr_state AS curr_addr_state_62, 
  t0.curr_addr_city AS curr_addr_city_63, 
  t0.curr_addr_zip AS curr_addr_zip_64, 
  t0.curr_addr AS curr_addr_65, 
  t0.curr_addr_lat AS curr_addr_lat_66, 
  t0.curr_addr_lng AS curr_addr_lng_67, 
  t0.perm_addr AS perm_addr_68, 
  t0.emm_contact AS emm_contact_69, 
  t0.skill AS skill_70, 
  t0.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_71, 
  t0.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_72, 
  t0.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_73, 
  t0.preferred_country_ids_as_student AS preferred_country_ids_as_student_74, 
  t0.joining_date AS joining_date_75, 
  t0.emp_valid_till AS emp_valid_till_76, 
  t0.emp_status AS emp_status_77, 
  t0.emp_type AS emp_type_78, 
  t0.emp_code AS emp_code_79, 
  t0.emp_label AS emp_label_80, 
  t0.tin AS tin_81, 
  t0.tin_valid_till AS tin_valid_till_82, 
  t0.med_ins AS med_ins_83, 
  t0.med_ins_valid_till AS med_ins_valid_till_84, 
  t0.docs AS docs_85, 
  t0.inst1 AS inst1_86, 
  t0.yr1 AS yr1_87, 
  t0.dur1 AS dur1_88, 
  t0.inst2 AS inst2_89, 
  t0.yr2 AS yr2_90, 
  t0.dur2 AS dur2_91, 
  t0.inst3 AS inst3_92, 
  t0.yr3 AS yr3_93, 
  t0.dur3 AS dur3_94, 
  t0.einst1 AS einst1_95, 
  t0.eyr1 AS eyr1_96, 
  t0.edeg1 AS edeg1_97, 
  t0.einst2 AS einst2_98, 
  t0.eyr2 AS eyr2_99, 
  t0.edeg2 AS edeg2_100, 
  t0.einst3 AS einst3_101, 
  t0.eyr3 AS eyr3_102, 
  t0.edeg3 AS edeg3_103, 
  t0.tax_code AS tax_code_104, 
  t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_105, 
  t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_106, 
  t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_107, 
  t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_108, 
  t0.allowed_earning_per_day AS allowed_earning_per_day_109, 
  t0.allowed_earning_per_week AS allowed_earning_per_week_110, 
  t0.allowed_earning_per_month AS allowed_earning_per_month_111, 
  t0.allowed_earning_per_year AS allowed_earning_per_year_112, 
  t0.revenue_percentage_per_session AS revenue_percentage_per_session_113, 
  t0.transaction_acc_no AS transaction_acc_no_114, 
  t0.transaction_acc_name AS transaction_acc_name_115, 
  t0.bank_id AS bank_id_116, 
  t0.bank_branch_code AS bank_branch_code_117, 
  t0.bank_acc AS bank_acc_118, 
  t0.bank_acc_name AS bank_acc_name_119, 
  t0.bank_acc_type AS bank_acc_type_120, 
  t0.bank_acc_valid_from AS bank_acc_valid_from_121, 
  t0.bank_acc_valid_to AS bank_acc_valid_to_122, 
  t0.routing_code AS routing_code_123, 
  t0.swift_code AS swift_code_124, 
  t0.mobile_wallet_no AS mobile_wallet_no_125, 
  t0.mobile_wallet_type AS mobile_wallet_type_126, 
  t0.ear1 AS ear1_127, 
  t0.ear2 AS ear2_128, 
  t0.ear3 AS ear3_129, 
  t0.ear4 AS ear4_130, 
  t0.ear5 AS ear5_131, 
  t0.ear6 AS ear6_132, 
  t0.eart AS eart_133, 
  t0.ded1 AS ded1_134, 
  t0.ded2 AS ded2_135, 
  t0.ded3 AS ded3_136, 
  t0.ded4 AS ded4_137, 
  t0.dedt AS dedt_138, 
  t0.payable AS payable_139, 
  t0.hand_cash AS hand_cash_140, 
  t0.bank_transfer AS bank_transfer_141, 
  t0.sec_dep AS sec_dep_142, 
  t0.sec_dep_span AS sec_dep_span_143, 
  t0.sec_dep_rem_mon AS sec_dep_rem_mon_144, 
  t0.sec_dep_rem_amount AS sec_dep_rem_amount_145, 
  t0.sl_qty AS sl_qty_146, 
  t0.sl_tkn AS sl_tkn_147, 
  t0.sl_freq AS sl_freq_148, 
  t0.ml_qty AS ml_qty_149, 
  t0.ml_tkn AS ml_tkn_150, 
  t0.ml_freq AS ml_freq_151, 
  t0.el_qty AS el_qty_152, 
  t0.el_tkn AS el_tkn_153, 
  t0.el_freq AS el_freq_154, 
  t0.cl_qty AS cl_qty_155, 
  t0.cl_tkn AS cl_tkn_156, 
  t0.cl_freq AS cl_freq_157, 
  t0.levt AS levt_158, 
  t0.weekly_holiday AS weekly_holiday_159, 
  t0.files AS files_160, 
  t0.supervisor AS supervisor_161, 
  t0.dept AS dept_162, 
  t0.desg AS desg_163, 
  t0.branch AS branch_164, 
  t0.division AS division_165, 
  t0.application_text AS application_text_166, 
  t0.current_employment AS current_employment_167, 
  t0.emergency_contact_number AS emergency_contact_number_168, 
  t0.postal_code AS postal_code_169, 
  t0.country AS country_170, 
  t0.education_data AS education_data_171, 
  t0.work_experience_data AS work_experience_data_172, 
  t0.certificate_data AS certificate_data_173, 
  t0.languages_data AS languages_data_174, 
  t0.important_comm_tags AS important_comm_tags_175, 
  t0.is_consultant AS is_consultant_176, 
  t0.is_featured AS is_featured_177, 
  t0.featured_duration_end_ts AS featured_duration_end_ts_178, 
  t0.is_moderator AS is_moderator_179, 
  t0.is_admin AS is_admin_180, 
  t0.admin_level AS admin_level_181, 
  t0.is_retailer AS is_retailer_182, 
  t0.retailer_level AS retailer_level_183, 
  t0.is_student AS is_student_184, 
  t0.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_185, 
  t0.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_186, 
  t0.online_status AS online_status_187, 
  t0.assigned_sales_representative_id AS assigned_sales_representative_id_188, 
  t0.lead_created_by_id AS lead_created_by_id_189, 
  t0.is_temporary_entry AS is_temporary_entry_190, 
  t0.lead_type AS lead_type_191, 
  t0.lead_level AS lead_level_192, 
  t0.immediate_follow_up_flag AS immediate_follow_up_flag_193, 
  t0.pending_initial_communication AS pending_initial_communication_194, 
  t0.last_online_ts AS last_online_ts_195, 
  t0.courses_data AS courses_data_196, 
  t0.video_link AS video_link_197, 
  t0.account_balance AS account_balance_198, 
  t0.session_count_balance AS session_count_balance_199, 
  t0.total_session_used AS total_session_used_200, 
  t0.total_consultancy_session_provided AS total_consultancy_session_provided_201, 
  t0.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_202, 
  t0.default_currency_id AS default_currency_id_203, 
  t0.default_language_id AS default_language_id_204, 
  t0.country_id AS country_id_205, 
  t0.following_consultant_ids AS following_consultant_ids_206, 
  t0.following_topic_ids AS following_topic_ids_207, 
  t0.viewed_topic_ids AS viewed_topic_ids_208, 
  t0.viewed_consultant_ids AS viewed_consultant_ids_209, 
  t0.following_event_ids AS following_event_ids_210, 
  t0.attending_event_ids AS attending_event_ids_211, 
  t0.skip_event_ids AS skip_event_ids_212, 
  t0.rating AS rating_213, 
  t0.applicant_specific_note AS applicant_specific_note_214, 
  t0.promo_discount_percentage AS promo_discount_percentage_215, 
  t0.promo_discount_balance_count AS promo_discount_balance_count_216, 
  t0.code_as_referer AS code_as_referer_217, 
  t0.referred_code AS referred_code_218, 
  t0.is_referred_code_used AS is_referred_code_used_219, 
  t0.promo_code_id AS promo_code_id_220, 
  t0.claimed_promo_code_ids AS claimed_promo_code_ids_221, 
  t0.referred_coins_earned AS referred_coins_earned_222, 
  t0.referred_amount_earned AS referred_amount_earned_223, 
  t0.rating_weight AS rating_weight_224, 
  t0.rating_total AS rating_total_225, 
  t0.rating_count AS rating_count_226, 
  t0.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_227, 
  t0.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_228, 
  t0.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_229, 
  t0.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_230, 
  t0.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_231, 
  t0.selector AS selector_232, 
  t0.apply_for_consultant AS apply_for_consultant_233, 
  t0.apply_for_consultant_date AS apply_for_consultant_date_234, 
  t0.consultant_application_feedback AS consultant_application_feedback_235, 
  t0.apply_for_retailer AS apply_for_retailer_236, 
  t0.apply_for_retailer_date AS apply_for_retailer_date_237, 
  t0.doc_image AS doc_image_238, 
  t0.document_list AS document_list_239, 
  t0.document_list_by_topic_id AS document_list_by_topic_id_240, 
  t0.document_list_by_session_id AS document_list_by_session_id_241, 
  t0.work_experience_year AS work_experience_year_242, 
  t0.description AS description_243, 
  t0.summary_text AS summary_text_244, 
  t0.professional_title AS professional_title_245, 
  t0.work_experience_text AS work_experience_text_246, 
  t0.profession_text AS profession_text_247, 
  t0.education_text AS education_text_248, 
  t0.education_major_text AS education_major_text_249, 
  t0.highest_degree_achieved AS highest_degree_achieved_250, 
  t0.target_education_degree AS target_education_degree_251, 
  t0.target_education_major AS target_education_major_252, 
  t0.lead_query_text AS lead_query_text_253, 
  t0.university_text AS university_text_254, 
  t0.experience_text AS experience_text_255, 
  t0.skillstext AS skillstext_256, 
  t0.interest AS interest_257, 
  t0.speciality AS speciality_258, 
  t0.last_settings_updated_ts AS last_settings_updated_ts_259, 
  t0.created_at AS created_at_260, 
  t0.actual_registration_at AS actual_registration_at_261, 
  t0.updated_at AS updated_at_262 
FROM 
  entity_applicant_details t0 
WHERE 
  t0.applicant_id = ? 
LIMIT 
  1

SELECT t0.applicant_id AS applicant_id_1, t0.sync_flag AS sync_flag_2, t0.schedule_available_flag AS schedule_available_flag_3, t0.device_id AS device_id_4, t0.device_id_locked_flag AS device_id_locked_flag_5, t0.lock_device_id_on_next_login_flag AS lock_device_id_on_next_login_flag_6, t0.username AS username_7, t0.email AS email_8, t0.o_auth_unique_id AS o_auth_unique_id_9, t0.o_auth_email AS o_auth_email_10, t0.fb_unique_id AS fb_unique_id_11, t0.li_unique_id AS li_unique_id_12, t0.google_unique_id AS google_unique_id_13, t0.fb_profile_link AS fb_profile_link_14, t0.fb_profile_id AS fb_profile_id_15, t0.ig_profile_link AS ig_profile_link_16, t0.ig_profile_id AS ig_profile_id_17, t0.li_profile_link AS li_profile_link_18, t0.li_profile_id AS li_profile_id_19, t0.user_app_ids AS user_app_ids_20, t0.user_types_by_app_ids AS user_types_by_app_ids_21, t0.password AS password_22, t0.temp_password AS temp_password_23, t0.salt AS salt_24, t0.email_verification_hash AS email_verification_hash_25, t0.phone_verification_hash AS phone_verification_hash_26, t0.trigger_reset_password AS trigger_reset_password_27, t0.otp_action_id AS otp_action_id_28, t0.otp AS otp_29, t0.otp_expire_ts AS otp_expire_ts_30, t0.forgot_password_token AS forgot_password_token_31, t0.forgot_password_token_expire_ts AS forgot_password_token_expire_ts_32, t0.is_email_verified AS is_email_verified_33, t0.is_phone_verified AS is_phone_verified_34, t0.is_banned AS is_banned_35, t0.ban_expires AS ban_expires_36, t0.strike_count AS strike_count_37, t0.strike_threshold AS strike_threshold_38, t0.account_status AS account_status_39, t0.student_level AS student_level_40, t0.job_applicant_level AS job_applicant_level_41, t0.consultant_level AS consultant_level_42, t0.nationality_country_id AS nationality_country_id_43, t0.current_country_id AS current_country_id_44, t0.user_id AS user_id_45, t0.firstname AS firstname_46, t0.lastname AS lastname_47, t0.image AS image_48, t0.is_img_legal AS is_img_legal_49, t0.nid AS nid_50, t0.dob AS dob_51, t0.sex AS sex_52, t0.father AS father_53, t0.mother AS mother_54, t0.spouse AS spouse_55, t0.child_1 AS child_1_56, t0.child_2 AS child_2_57, t0.blood AS blood_58, t0.phone AS phone_59, t0.phone_with_country_code AS phone_with_country_code_60, t0.phone_country_code AS phone_country_code_61, t0.curr_addr_state AS curr_addr_state_62, t0.curr_addr_city AS curr_addr_city_63, t0.curr_addr_zip AS curr_addr_zip_64, t0.curr_addr AS curr_addr_65, t0.curr_addr_lat AS curr_addr_lat_66, t0.curr_addr_lng AS curr_addr_lng_67, t0.perm_addr AS perm_addr_68, t0.emm_contact AS emm_contact_69, t0.skill AS skill_70, t0.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_71, t0.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_72, t0.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_73, t0.preferred_country_ids_as_student AS preferred_country_ids_as_student_74, t0.joining_date AS joining_date_75, t0.emp_valid_till AS emp_valid_till_76, t0.emp_status AS emp_status_77, t0.emp_type AS emp_type_78, t0.emp_code AS emp_code_79, t0.emp_label AS emp_label_80, t0.tin AS tin_81, t0.tin_valid_till AS tin_valid_till_82, t0.med_ins AS med_ins_83, t0.med_ins_valid_till AS med_ins_valid_till_84, t0.docs AS docs_85, t0.inst1 AS inst1_86, t0.yr1 AS yr1_87, t0.dur1 AS dur1_88, t0.inst2 AS inst2_89, t0.yr2 AS yr2_90, t0.dur2 AS dur2_91, t0.inst3 AS inst3_92, t0.yr3 AS yr3_93, t0.dur3 AS dur3_94, t0.einst1 AS einst1_95, t0.eyr1 AS eyr1_96, t0.edeg1 AS edeg1_97, t0.einst2 AS einst2_98, t0.eyr2 AS eyr2_99, t0.edeg2 AS edeg2_100, t0.einst3 AS einst3_101, t0.eyr3 AS eyr3_102, t0.edeg3 AS edeg3_103, t0.tax_code AS tax_code_104, t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_105, t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_106, t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_107, t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_108, t0.allowed_earning_per_day AS allowed_earning_per_day_109, t0.allowed_earning_per_week AS allowed_earning_per_week_110, t0.allowed_earning_per_month AS allowed_earning_per_month_111, t0.allowed_earning_per_year AS allowed_earning_per_year_112, t0.revenue_percentage_per_session AS revenue_percentage_per_session_113, t0.transaction_acc_no AS transaction_acc_no_114, t0.transaction_acc_name AS transaction_acc_name_115, t0.bank_id AS bank_id_116, t0.bank_branch_code AS bank_branch_code_117, t0.bank_acc AS bank_acc_118, t0.bank_acc_name AS bank_acc_name_119, t0.bank_acc_type AS bank_acc_type_120, t0.bank_acc_valid_from AS bank_acc_valid_from_121, t0.bank_acc_valid_to AS bank_acc_valid_to_122, t0.routing_code AS routing_code_123, t0.swift_code AS swift_code_124, t0.mobile_wallet_no AS mobile_wallet_no_125, t0.mobile_wallet_type AS mobile_wallet_type_126, t0.ear1 AS ear1_127, t0.ear2 AS ear2_128, t0.ear3 AS ear3_129, t0.ear4 AS ear4_130, t0.ear5 AS ear5_131, t0.ear6 AS ear6_132, t0.eart AS eart_133, t0.ded1 AS ded1_134, t0.ded2 AS ded2_135, t0.ded3 AS ded3_136, t0.ded4 AS ded4_137, t0.dedt AS dedt_138, t0.payable AS payable_139, t0.hand_cash AS hand_cash_140, t0.bank_transfer AS bank_transfer_141, t0.sec_dep AS sec_dep_142, t0.sec_dep_span AS sec_dep_span_143, t0.sec_dep_rem_mon AS sec_dep_rem_mon_144, t0.sec_dep_rem_amount AS sec_dep_rem_amount_145, t0.sl_qty AS sl_qty_146, t0.sl_tkn AS sl_tkn_147, t0.sl_freq AS sl_freq_148, t0.ml_qty AS ml_qty_149, t0.ml_tkn AS ml_tkn_150, t0.ml_freq AS ml_freq_151, t0.el_qty AS el_qty_152, t0.el_tkn AS el_tkn_153, t0.el_freq AS el_freq_154, t0.cl_qty AS cl_qty_155, t0.cl_tkn AS cl_tkn_156, t0.cl_freq AS cl_freq_157, t0.levt AS levt_158, t0.weekly_holiday AS weekly_holiday_159, t0.files AS files_160, t0.supervisor AS supervisor_161, t0.dept AS dept_162, t0.desg AS desg_163, t0.branch AS branch_164, t0.division AS division_165, t0.application_text AS application_text_166, t0.current_employment AS current_employment_167, t0.emergency_contact_number AS emergency_contact_number_168, t0.postal_code AS postal_code_169, t0.country AS country_170, t0.education_data AS education_data_171, t0.work_experience_data AS work_experience_data_172, t0.certificate_data AS certificate_data_173, t0.languages_data AS languages_data_174, t0.important_comm_tags AS important_comm_tags_175, t0.is_consultant AS is_consultant_176, t0.is_featured AS is_featured_177, t0.featured_duration_end_ts AS featured_duration_end_ts_178, t0.is_moderator AS is_moderator_179, t0.is_admin AS is_admin_180, t0.admin_level AS admin_level_181, t0.is_retailer AS is_retailer_182, t0.retailer_level AS retailer_level_183, t0.is_student AS is_student_184, t0.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_185, t0.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_186, t0.online_status AS online_status_187, t0.assigned_sales_representative_id AS assigned_sales_representative_id_188, t0.lead_created_by_id AS lead_created_by_id_189, t0.is_temporary_entry AS is_temporary_entry_190, t0.lead_type AS lead_type_191, t0.lead_level AS lead_level_192, t0.immediate_follow_up_flag AS immediate_follow_up_flag_193, t0.pending_initial_communication AS pending_initial_communication_194, t0.last_online_ts AS last_online_ts_195, t0.courses_data AS courses_data_196, t0.video_link AS video_link_197, t0.account_balance AS account_balance_198, t0.session_count_balance AS session_count_balance_199, t0.total_session_used AS total_session_used_200, t0.total_consultancy_session_provided AS total_consultancy_session_provided_201, t0.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_202, t0.default_currency_id AS default_currency_id_203, t0.default_language_id AS default_language_id_204, t0.country_id AS country_id_205, t0.following_consultant_ids AS following_consultant_ids_206, t0.following_topic_ids AS following_topic_ids_207, t0.viewed_topic_ids AS viewed_topic_ids_208, t0.viewed_consultant_ids AS viewed_consultant_ids_209, t0.following_event_ids AS following_event_ids_210, t0.attending_event_ids AS attending_event_ids_211, t0.skip_event_ids AS skip_event_ids_212, t0.rating AS rating_213, t0.applicant_specific_note AS applicant_specific_note_214, t0.promo_discount_percentage AS promo_discount_percentage_215, t0.promo_discount_balance_count AS promo_discount_balance_count_216, t0.code_as_referer AS code_as_referer_217, t0.referred_code AS referred_code_218, t0.is_referred_code_used AS is_referred_code_used_219, t0.promo_code_id AS promo_code_id_220, t0.claimed_promo_code_ids AS claimed_promo_code_ids_221, t0.referred_coins_earned AS referred_coins_earned_222, t0.referred_amount_earned AS referred_amount_earned_223, t0.rating_weight AS rating_weight_224, t0.rating_total AS rating_total_225, t0.rating_count AS rating_count_226, t0.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_227, t0.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_228, t0.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_229, t0.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_230, t0.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_231, t0.selector AS selector_232, t0.apply_for_consultant AS apply_for_consultant_233, t0.apply_for_consultant_date AS apply_for_consultant_date_234, t0.consultant_application_feedback AS consultant_application_feedback_235, t0.apply_for_retailer AS apply_for_retailer_236, t0.apply_for_retailer_date AS apply_for_retailer_date_237, t0.doc_image AS doc_image_238, t0.document_list AS document_list_239, t0.document_list_by_topic_id AS document_list_by_topic_id_240, t0.document_list_by_session_id AS document_list_by_session_id_241, t0.work_experience_year AS work_experience_year_242, t0.description AS description_243, t0.summary_text AS summary_text_244, t0.professional_title AS professional_title_245, t0.work_experience_text AS work_experience_text_246, t0.profession_text AS profession_text_247, t0.education_text AS education_text_248, t0.education_major_text AS education_major_text_249, t0.highest_degree_achieved AS highest_degree_achieved_250, t0.target_education_degree AS target_education_degree_251, t0.target_education_major AS target_education_major_252, t0.lead_query_text AS lead_query_text_253, t0.university_text AS university_text_254, t0.experience_text AS experience_text_255, t0.skillstext AS skillstext_256, t0.interest AS interest_257, t0.speciality AS speciality_258, t0.last_settings_updated_ts AS last_settings_updated_ts_259, t0.created_at AS created_at_260, t0.actual_registration_at AS actual_registration_at_261, t0.updated_at AS updated_at_262 FROM entity_applicant_details t0 WHERE t0.applicant_id = 0 LIMIT 1;

SELECT 
  t0.country_id AS country_id_1, 
  t0.code AS code_2, 
  t0.name_en AS name_en_3, 
  t0.nationality_string AS nationality_string_4, 
  t0.name_fr AS name_fr_5, 
  t0.flag_image AS flag_image_6, 
  t0.time_zone_str AS time_zone_str_7, 
  t0.flag_image_square AS flag_image_square_8, 
  t0.active_for_buddy_bee AS active_for_buddy_bee_9, 
  t0.currency_id AS currency_id_10, 
  t0.default_language_id AS default_language_id_11, 
  t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_12, 
  t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_13, 
  t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_14, 
  t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_15, 
  t0.allowed_earning_per_day AS allowed_earning_per_day_16, 
  t0.allowed_earning_per_week AS allowed_earning_per_week_17, 
  t0.allowed_earning_per_month AS allowed_earning_per_month_18, 
  t0.allowed_earning_per_year AS allowed_earning_per_year_19, 
  t0.revenue_percentage_per_session AS revenue_percentage_per_session_20 
FROM 
  entity_countries t0 
WHERE 
  t0.active_for_buddy_bee = ?

SELECT t0.country_id AS country_id_1, t0.code AS code_2, t0.name_en AS name_en_3, t0.nationality_string AS nationality_string_4, t0.name_fr AS name_fr_5, t0.flag_image AS flag_image_6, t0.time_zone_str AS time_zone_str_7, t0.flag_image_square AS flag_image_square_8, t0.active_for_buddy_bee AS active_for_buddy_bee_9, t0.currency_id AS currency_id_10, t0.default_language_id AS default_language_id_11, t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_12, t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_13, t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_14, t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_15, t0.allowed_earning_per_day AS allowed_earning_per_day_16, t0.allowed_earning_per_week AS allowed_earning_per_week_17, t0.allowed_earning_per_month AS allowed_earning_per_month_18, t0.allowed_earning_per_year AS allowed_earning_per_year_19, t0.revenue_percentage_per_session AS revenue_percentage_per_session_20 FROM entity_countries t0 WHERE t0.active_for_buddy_bee = 1;

SELECT 
  t0.id AS id_1, 
  t0.code AS code_2, 
  t0.name AS name_3, 
  t0.image AS image_4, 
  t0.active_for_buddy_bee AS active_for_buddy_bee_5 
FROM 
  entity_languages t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.image AS image_4, t0.active_for_buddy_bee AS active_for_buddy_bee_5 FROM entity_languages t0;

SELECT 
  distinct current_country_id 
from 
  entity_applicant_details 
where 
  is_consultant = 1

SELECT distinct current_country_id from  entity_applicant_details   where is_consultant=1;

SELECT 
  t0.country_id AS country_id_1, 
  t0.code AS code_2, 
  t0.name_en AS name_en_3, 
  t0.nationality_string AS nationality_string_4, 
  t0.name_fr AS name_fr_5, 
  t0.flag_image AS flag_image_6, 
  t0.time_zone_str AS time_zone_str_7, 
  t0.flag_image_square AS flag_image_square_8, 
  t0.active_for_buddy_bee AS active_for_buddy_bee_9, 
  t0.currency_id AS currency_id_10, 
  t0.default_language_id AS default_language_id_11, 
  t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_12, 
  t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_13, 
  t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_14, 
  t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_15, 
  t0.allowed_earning_per_day AS allowed_earning_per_day_16, 
  t0.allowed_earning_per_week AS allowed_earning_per_week_17, 
  t0.allowed_earning_per_month AS allowed_earning_per_month_18, 
  t0.allowed_earning_per_year AS allowed_earning_per_year_19, 
  t0.revenue_percentage_per_session AS revenue_percentage_per_session_20 
FROM 
  entity_countries t0 
WHERE 
  t0.country_id IN (?)

SELECT t0.country_id AS country_id_1, t0.code AS code_2, t0.name_en AS name_en_3, t0.nationality_string AS nationality_string_4, t0.name_fr AS name_fr_5, t0.flag_image AS flag_image_6, t0.time_zone_str AS time_zone_str_7, t0.flag_image_square AS flag_image_square_8, t0.active_for_buddy_bee AS active_for_buddy_bee_9, t0.currency_id AS currency_id_10, t0.default_language_id AS default_language_id_11, t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_12, t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_13, t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_14, t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_15, t0.allowed_earning_per_day AS allowed_earning_per_day_16, t0.allowed_earning_per_week AS allowed_earning_per_week_17, t0.allowed_earning_per_month AS allowed_earning_per_month_18, t0.allowed_earning_per_year AS allowed_earning_per_year_19, t0.revenue_percentage_per_session AS revenue_percentage_per_session_20 FROM entity_countries t0 WHERE t0.country_id IN ();