Symfony Profiler

SELECT
  t0.applicant_id AS applicant_id_1,
  t0.sync_flag AS sync_flag_2,
  t0.ids_by_device AS ids_by_device_3,
  t0.schedule_available_flag AS schedule_available_flag_4,
  t0.device_id AS device_id_5,
  t0.device_id_locked_flag AS device_id_locked_flag_6,
  t0.lock_device_id_on_next_login_flag AS lock_device_id_on_next_login_flag_7,
  t0.username AS username_8,
  t0.email AS email_9,
  t0.o_auth_unique_id AS o_auth_unique_id_10,
  t0.o_auth_email AS o_auth_email_11,
  t0.fb_unique_id AS fb_unique_id_12,
  t0.li_unique_id AS li_unique_id_13,
  t0.google_unique_id AS google_unique_id_14,
  t0.fb_profile_link AS fb_profile_link_15,
  t0.fb_profile_id AS fb_profile_id_16,
  t0.ig_profile_link AS ig_profile_link_17,
  t0.ig_profile_id AS ig_profile_id_18,
  t0.li_profile_link AS li_profile_link_19,
  t0.li_profile_id AS li_profile_id_20,
  t0.user_suspended_app_ids AS user_suspended_app_ids_21,
  t0.user_app_ids AS user_app_ids_22,
  t0.user_types_by_app_ids AS user_types_by_app_ids_23,
  t0.password AS password_24,
  t0.temp_password AS temp_password_25,
  t0.salt AS salt_26,
  t0.email_verification_hash AS email_verification_hash_27,
  t0.phone_verification_hash AS phone_verification_hash_28,
  t0.trigger_reset_password AS trigger_reset_password_29,
  t0.otp_action_id AS otp_action_id_30,
  t0.otp AS otp_31,
  t0.otp_expire_ts AS otp_expire_ts_32,
  t0.forgot_password_token AS forgot_password_token_33,
  t0.forgot_password_token_expire_ts AS forgot_password_token_expire_ts_34,
  t0.is_email_verified AS is_email_verified_35,
  t0.is_phone_verified AS is_phone_verified_36,
  t0.is_banned AS is_banned_37,
  t0.ban_expires AS ban_expires_38,
  t0.strike_count AS strike_count_39,
  t0.strike_threshold AS strike_threshold_40,
  t0.account_status AS account_status_41,
  t0.student_level AS student_level_42,
  t0.job_applicant_level AS job_applicant_level_43,
  t0.consultant_level AS consultant_level_44,
  t0.nationality_country_id AS nationality_country_id_45,
  t0.current_country_id AS current_country_id_46,
  t0.user_id AS user_id_47,
  t0.firstname AS firstname_48,
  t0.lastname AS lastname_49,
  t0.image AS image_50,
  t0.is_img_legal AS is_img_legal_51,
  t0.nid AS nid_52,
  t0.dob AS dob_53,
  t0.sex AS sex_54,
  t0.father AS father_55,
  t0.mother AS mother_56,
  t0.spouse AS spouse_57,
  t0.child_1 AS child_1_58,
  t0.child_2 AS child_2_59,
  t0.blood AS blood_60,
  t0.phone AS phone_61,
  t0.official_phone AS official_phone_62,
  t0.phone_with_country_code AS phone_with_country_code_63,
  t0.phone_country_code AS phone_country_code_64,
  t0.curr_addr_state AS curr_addr_state_65,
  t0.curr_addr_city AS curr_addr_city_66,
  t0.curr_addr_zip AS curr_addr_zip_67,
  t0.curr_addr AS curr_addr_68,
  t0.curr_addr_lat AS curr_addr_lat_69,
  t0.curr_addr_lng AS curr_addr_lng_70,
  t0.perm_addr AS perm_addr_71,
  t0.emm_contact AS emm_contact_72,
  t0.skill AS skill_73,
  t0.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_74,
  t0.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_75,
  t0.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_76,
  t0.preferred_country_ids_as_student AS preferred_country_ids_as_student_77,
  t0.joining_date AS joining_date_78,
  t0.emp_valid_till AS emp_valid_till_79,
  t0.emp_status AS emp_status_80,
  t0.emp_type AS emp_type_81,
  t0.emp_code AS emp_code_82,
  t0.emp_label AS emp_label_83,
  t0.tin AS tin_84,
  t0.tin_valid_till AS tin_valid_till_85,
  t0.med_ins AS med_ins_86,
  t0.med_ins_valid_till AS med_ins_valid_till_87,
  t0.docs AS docs_88,
  t0.inst1 AS inst1_89,
  t0.yr1 AS yr1_90,
  t0.dur1 AS dur1_91,
  t0.inst2 AS inst2_92,
  t0.yr2 AS yr2_93,
  t0.dur2 AS dur2_94,
  t0.inst3 AS inst3_95,
  t0.yr3 AS yr3_96,
  t0.dur3 AS dur3_97,
  t0.einst1 AS einst1_98,
  t0.eyr1 AS eyr1_99,
  t0.edeg1 AS edeg1_100,
  t0.einst2 AS einst2_101,
  t0.eyr2 AS eyr2_102,
  t0.edeg2 AS edeg2_103,
  t0.einst3 AS einst3_104,
  t0.eyr3 AS eyr3_105,
  t0.edeg3 AS edeg3_106,
  t0.tax_code AS tax_code_107,
  t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_108,
  t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_109,
  t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_110,
  t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_111,
  t0.allowed_earning_per_day AS allowed_earning_per_day_112,
  t0.allowed_earning_per_week AS allowed_earning_per_week_113,
  t0.allowed_earning_per_month AS allowed_earning_per_month_114,
  t0.allowed_earning_per_year AS allowed_earning_per_year_115,
  t0.revenue_percentage_per_session AS revenue_percentage_per_session_116,
  t0.transaction_acc_no AS transaction_acc_no_117,
  t0.transaction_acc_name AS transaction_acc_name_118,
  t0.bank_id AS bank_id_119,
  t0.bank_branch_code AS bank_branch_code_120,
  t0.bank_acc AS bank_acc_121,
  t0.bank_acc_name AS bank_acc_name_122,
  t0.bank_acc_type AS bank_acc_type_123,
  t0.bank_acc_valid_from AS bank_acc_valid_from_124,
  t0.bank_acc_valid_to AS bank_acc_valid_to_125,
  t0.routing_code AS routing_code_126,
  t0.swift_code AS swift_code_127,
  t0.mobile_wallet_no AS mobile_wallet_no_128,
  t0.mobile_wallet_type AS mobile_wallet_type_129,
  t0.ear1 AS ear1_130,
  t0.ear2 AS ear2_131,
  t0.ear3 AS ear3_132,
  t0.ear4 AS ear4_133,
  t0.ear5 AS ear5_134,
  t0.ear6 AS ear6_135,
  t0.eart AS eart_136,
  t0.ded1 AS ded1_137,
  t0.ded2 AS ded2_138,
  t0.ded3 AS ded3_139,
  t0.ded4 AS ded4_140,
  t0.dedt AS dedt_141,
  t0.payable AS payable_142,
  t0.hand_cash AS hand_cash_143,
  t0.bank_transfer AS bank_transfer_144,
  t0.sec_dep AS sec_dep_145,
  t0.sec_dep_span AS sec_dep_span_146,
  t0.sec_dep_rem_mon AS sec_dep_rem_mon_147,
  t0.sec_dep_rem_amount AS sec_dep_rem_amount_148,
  t0.sl_qty AS sl_qty_149,
  t0.sl_tkn AS sl_tkn_150,
  t0.sl_freq AS sl_freq_151,
  t0.ml_qty AS ml_qty_152,
  t0.ml_tkn AS ml_tkn_153,
  t0.ml_freq AS ml_freq_154,
  t0.el_qty AS el_qty_155,
  t0.el_tkn AS el_tkn_156,
  t0.el_freq AS el_freq_157,
  t0.cl_qty AS cl_qty_158,
  t0.cl_tkn AS cl_tkn_159,
  t0.cl_freq AS cl_freq_160,
  t0.levt AS levt_161,
  t0.weekly_holiday AS weekly_holiday_162,
  t0.files AS files_163,
  t0.supervisor AS supervisor_164,
  t0.dept AS dept_165,
  t0.desg AS desg_166,
  t0.branch AS branch_167,
  t0.division AS division_168,
  t0.application_text AS application_text_169,
  t0.current_employment AS current_employment_170,
  t0.emergency_contact_number AS emergency_contact_number_171,
  t0.postal_code AS postal_code_172,
  t0.country AS country_173,
  t0.education_data AS education_data_174,
  t0.work_experience_data AS work_experience_data_175,
  t0.certificate_data AS certificate_data_176,
  t0.languages_data AS languages_data_177,
  t0.important_comm_tags AS important_comm_tags_178,
  t0.is_consultant AS is_consultant_179,
  t0.is_featured AS is_featured_180,
  t0.featured_duration_end_ts AS featured_duration_end_ts_181,
  t0.is_moderator AS is_moderator_182,
  t0.is_admin AS is_admin_183,
  t0.admin_level AS admin_level_184,
  t0.is_retailer AS is_retailer_185,
  t0.retailer_level AS retailer_level_186,
  t0.is_student AS is_student_187,
  t0.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_188,
  t0.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_189,
  t0.online_status AS online_status_190,
  t0.assigned_sales_representative_id AS assigned_sales_representative_id_191,
  t0.lead_created_by_id AS lead_created_by_id_192,
  t0.is_temporary_entry AS is_temporary_entry_193,
  t0.lead_type AS lead_type_194,
  t0.lead_level AS lead_level_195,
  t0.immediate_follow_up_flag AS immediate_follow_up_flag_196,
  t0.pending_initial_communication AS pending_initial_communication_197,
  t0.last_online_ts AS last_online_ts_198,
  t0.courses_data AS courses_data_199,
  t0.video_link AS video_link_200,
  t0.account_balance AS account_balance_201,
  t0.session_count_balance AS session_count_balance_202,
  t0.total_session_used AS total_session_used_203,
  t0.total_consultancy_session_provided AS total_consultancy_session_provided_204,
  t0.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_205,
  t0.default_currency_id AS default_currency_id_206,
  t0.default_language_id AS default_language_id_207,
  t0.country_id AS country_id_208,
  t0.following_consultant_ids AS following_consultant_ids_209,
  t0.following_topic_ids AS following_topic_ids_210,
  t0.viewed_topic_ids AS viewed_topic_ids_211,
  t0.viewed_consultant_ids AS viewed_consultant_ids_212,
  t0.following_event_ids AS following_event_ids_213,
  t0.attending_event_ids AS attending_event_ids_214,
  t0.skip_event_ids AS skip_event_ids_215,
  t0.rating AS rating_216,
  t0.applicant_specific_note AS applicant_specific_note_217,
  t0.promo_discount_percentage AS promo_discount_percentage_218,
  t0.promo_discount_balance_count AS promo_discount_balance_count_219,
  t0.code_as_referer AS code_as_referer_220,
  t0.referred_code AS referred_code_221,
  t0.is_referred_code_used AS is_referred_code_used_222,
  t0.promo_code_id AS promo_code_id_223,
  t0.max_discount_allowed AS max_discount_allowed_224,
  t0.claimed_promo_code_ids AS claimed_promo_code_ids_225,
  t0.referred_coins_earned AS referred_coins_earned_226,
  t0.referred_amount_earned AS referred_amount_earned_227,
  t0.rating_weight AS rating_weight_228,
  t0.rating_total AS rating_total_229,
  t0.rating_count AS rating_count_230,
  t0.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_231,
  t0.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_232,
  t0.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_233,
  t0.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_234,
  t0.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_235,
  t0.selector AS selector_236,
  t0.apply_for_consultant AS apply_for_consultant_237,
  t0.apply_for_consultant_date AS apply_for_consultant_date_238,
  t0.consultant_application_feedback AS consultant_application_feedback_239,
  t0.apply_for_retailer AS apply_for_retailer_240,
  t0.apply_for_retailer_date AS apply_for_retailer_date_241,
  t0.doc_image AS doc_image_242,
  t0.document_list AS document_list_243,
  t0.document_list_by_topic_id AS document_list_by_topic_id_244,
  t0.document_list_by_session_id AS document_list_by_session_id_245,
  t0.work_experience_year AS work_experience_year_246,
  t0.description AS description_247,
  t0.summary_text AS summary_text_248,
  t0.professional_title AS professional_title_249,
  t0.work_experience_text AS work_experience_text_250,
  t0.profession_text AS profession_text_251,
  t0.education_text AS education_text_252,
  t0.education_major_text AS education_major_text_253,
  t0.highest_degree_achieved AS highest_degree_achieved_254,
  t0.target_education_degree AS target_education_degree_255,
  t0.target_education_major AS target_education_major_256,
  t0.lead_query_text AS lead_query_text_257,
  t0.university_text AS university_text_258,
  t0.experience_text AS experience_text_259,
  t0.skillstext AS skillstext_260,
  t0.interest AS interest_261,
  t0.speciality AS speciality_262,
  t0.last_settings_updated_ts AS last_settings_updated_ts_263,
  t0.created_at AS created_at_264,
  t0.actual_registration_at AS actual_registration_at_265,
  t0.updated_at AS updated_at_266
FROM
  entity_applicant_details t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.applicant_id AS applicant_id_1, t0.sync_flag AS sync_flag_2, t0.ids_by_device AS ids_by_device_3, t0.schedule_available_flag AS schedule_available_flag_4, t0.device_id AS device_id_5, t0.device_id_locked_flag AS device_id_locked_flag_6, t0.lock_device_id_on_next_login_flag AS lock_device_id_on_next_login_flag_7, t0.username AS username_8, t0.email AS email_9, t0.o_auth_unique_id AS o_auth_unique_id_10, t0.o_auth_email AS o_auth_email_11, t0.fb_unique_id AS fb_unique_id_12, t0.li_unique_id AS li_unique_id_13, t0.google_unique_id AS google_unique_id_14, t0.fb_profile_link AS fb_profile_link_15, t0.fb_profile_id AS fb_profile_id_16, t0.ig_profile_link AS ig_profile_link_17, t0.ig_profile_id AS ig_profile_id_18, t0.li_profile_link AS li_profile_link_19, t0.li_profile_id AS li_profile_id_20, t0.user_suspended_app_ids AS user_suspended_app_ids_21, t0.user_app_ids AS user_app_ids_22, t0.user_types_by_app_ids AS user_types_by_app_ids_23, t0.password AS password_24, t0.temp_password AS temp_password_25, t0.salt AS salt_26, t0.email_verification_hash AS email_verification_hash_27, t0.phone_verification_hash AS phone_verification_hash_28, t0.trigger_reset_password AS trigger_reset_password_29, t0.otp_action_id AS otp_action_id_30, t0.otp AS otp_31, t0.otp_expire_ts AS otp_expire_ts_32, t0.forgot_password_token AS forgot_password_token_33, t0.forgot_password_token_expire_ts AS forgot_password_token_expire_ts_34, t0.is_email_verified AS is_email_verified_35, t0.is_phone_verified AS is_phone_verified_36, t0.is_banned AS is_banned_37, t0.ban_expires AS ban_expires_38, t0.strike_count AS strike_count_39, t0.strike_threshold AS strike_threshold_40, t0.account_status AS account_status_41, t0.student_level AS student_level_42, t0.job_applicant_level AS job_applicant_level_43, t0.consultant_level AS consultant_level_44, t0.nationality_country_id AS nationality_country_id_45, t0.current_country_id AS current_country_id_46, t0.user_id AS user_id_47, t0.firstname AS firstname_48, t0.lastname AS lastname_49, t0.image AS image_50, t0.is_img_legal AS is_img_legal_51, t0.nid AS nid_52, t0.dob AS dob_53, t0.sex AS sex_54, t0.father AS father_55, t0.mother AS mother_56, t0.spouse AS spouse_57, t0.child_1 AS child_1_58, t0.child_2 AS child_2_59, t0.blood AS blood_60, t0.phone AS phone_61, t0.official_phone AS official_phone_62, t0.phone_with_country_code AS phone_with_country_code_63, t0.phone_country_code AS phone_country_code_64, t0.curr_addr_state AS curr_addr_state_65, t0.curr_addr_city AS curr_addr_city_66, t0.curr_addr_zip AS curr_addr_zip_67, t0.curr_addr AS curr_addr_68, t0.curr_addr_lat AS curr_addr_lat_69, t0.curr_addr_lng AS curr_addr_lng_70, t0.perm_addr AS perm_addr_71, t0.emm_contact AS emm_contact_72, t0.skill AS skill_73, t0.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_74, t0.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_75, t0.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_76, t0.preferred_country_ids_as_student AS preferred_country_ids_as_student_77, t0.joining_date AS joining_date_78, t0.emp_valid_till AS emp_valid_till_79, t0.emp_status AS emp_status_80, t0.emp_type AS emp_type_81, t0.emp_code AS emp_code_82, t0.emp_label AS emp_label_83, t0.tin AS tin_84, t0.tin_valid_till AS tin_valid_till_85, t0.med_ins AS med_ins_86, t0.med_ins_valid_till AS med_ins_valid_till_87, t0.docs AS docs_88, t0.inst1 AS inst1_89, t0.yr1 AS yr1_90, t0.dur1 AS dur1_91, t0.inst2 AS inst2_92, t0.yr2 AS yr2_93, t0.dur2 AS dur2_94, t0.inst3 AS inst3_95, t0.yr3 AS yr3_96, t0.dur3 AS dur3_97, t0.einst1 AS einst1_98, t0.eyr1 AS eyr1_99, t0.edeg1 AS edeg1_100, t0.einst2 AS einst2_101, t0.eyr2 AS eyr2_102, t0.edeg2 AS edeg2_103, t0.einst3 AS einst3_104, t0.eyr3 AS eyr3_105, t0.edeg3 AS edeg3_106, t0.tax_code AS tax_code_107, t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_108, t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_109, t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_110, t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_111, t0.allowed_earning_per_day AS allowed_earning_per_day_112, t0.allowed_earning_per_week AS allowed_earning_per_week_113, t0.allowed_earning_per_month AS allowed_earning_per_month_114, t0.allowed_earning_per_year AS allowed_earning_per_year_115, t0.revenue_percentage_per_session AS revenue_percentage_per_session_116, t0.transaction_acc_no AS transaction_acc_no_117, t0.transaction_acc_name AS transaction_acc_name_118, t0.bank_id AS bank_id_119, t0.bank_branch_code AS bank_branch_code_120, t0.bank_acc AS bank_acc_121, t0.bank_acc_name AS bank_acc_name_122, t0.bank_acc_type AS bank_acc_type_123, t0.bank_acc_valid_from AS bank_acc_valid_from_124, t0.bank_acc_valid_to AS bank_acc_valid_to_125, t0.routing_code AS routing_code_126, t0.swift_code AS swift_code_127, t0.mobile_wallet_no AS mobile_wallet_no_128, t0.mobile_wallet_type AS mobile_wallet_type_129, t0.ear1 AS ear1_130, t0.ear2 AS ear2_131, t0.ear3 AS ear3_132, t0.ear4 AS ear4_133, t0.ear5 AS ear5_134, t0.ear6 AS ear6_135, t0.eart AS eart_136, t0.ded1 AS ded1_137, t0.ded2 AS ded2_138, t0.ded3 AS ded3_139, t0.ded4 AS ded4_140, t0.dedt AS dedt_141, t0.payable AS payable_142, t0.hand_cash AS hand_cash_143, t0.bank_transfer AS bank_transfer_144, t0.sec_dep AS sec_dep_145, t0.sec_dep_span AS sec_dep_span_146, t0.sec_dep_rem_mon AS sec_dep_rem_mon_147, t0.sec_dep_rem_amount AS sec_dep_rem_amount_148, t0.sl_qty AS sl_qty_149, t0.sl_tkn AS sl_tkn_150, t0.sl_freq AS sl_freq_151, t0.ml_qty AS ml_qty_152, t0.ml_tkn AS ml_tkn_153, t0.ml_freq AS ml_freq_154, t0.el_qty AS el_qty_155, t0.el_tkn AS el_tkn_156, t0.el_freq AS el_freq_157, t0.cl_qty AS cl_qty_158, t0.cl_tkn AS cl_tkn_159, t0.cl_freq AS cl_freq_160, t0.levt AS levt_161, t0.weekly_holiday AS weekly_holiday_162, t0.files AS files_163, t0.supervisor AS supervisor_164, t0.dept AS dept_165, t0.desg AS desg_166, t0.branch AS branch_167, t0.division AS division_168, t0.application_text AS application_text_169, t0.current_employment AS current_employment_170, t0.emergency_contact_number AS emergency_contact_number_171, t0.postal_code AS postal_code_172, t0.country AS country_173, t0.education_data AS education_data_174, t0.work_experience_data AS work_experience_data_175, t0.certificate_data AS certificate_data_176, t0.languages_data AS languages_data_177, t0.important_comm_tags AS important_comm_tags_178, t0.is_consultant AS is_consultant_179, t0.is_featured AS is_featured_180, t0.featured_duration_end_ts AS featured_duration_end_ts_181, t0.is_moderator AS is_moderator_182, t0.is_admin AS is_admin_183, t0.admin_level AS admin_level_184, t0.is_retailer AS is_retailer_185, t0.retailer_level AS retailer_level_186, t0.is_student AS is_student_187, t0.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_188, t0.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_189, t0.online_status AS online_status_190, t0.assigned_sales_representative_id AS assigned_sales_representative_id_191, t0.lead_created_by_id AS lead_created_by_id_192, t0.is_temporary_entry AS is_temporary_entry_193, t0.lead_type AS lead_type_194, t0.lead_level AS lead_level_195, t0.immediate_follow_up_flag AS immediate_follow_up_flag_196, t0.pending_initial_communication AS pending_initial_communication_197, t0.last_online_ts AS last_online_ts_198, t0.courses_data AS courses_data_199, t0.video_link AS video_link_200, t0.account_balance AS account_balance_201, t0.session_count_balance AS session_count_balance_202, t0.total_session_used AS total_session_used_203, t0.total_consultancy_session_provided AS total_consultancy_session_provided_204, t0.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_205, t0.default_currency_id AS default_currency_id_206, t0.default_language_id AS default_language_id_207, t0.country_id AS country_id_208, t0.following_consultant_ids AS following_consultant_ids_209, t0.following_topic_ids AS following_topic_ids_210, t0.viewed_topic_ids AS viewed_topic_ids_211, t0.viewed_consultant_ids AS viewed_consultant_ids_212, t0.following_event_ids AS following_event_ids_213, t0.attending_event_ids AS attending_event_ids_214, t0.skip_event_ids AS skip_event_ids_215, t0.rating AS rating_216, t0.applicant_specific_note AS applicant_specific_note_217, t0.promo_discount_percentage AS promo_discount_percentage_218, t0.promo_discount_balance_count AS promo_discount_balance_count_219, t0.code_as_referer AS code_as_referer_220, t0.referred_code AS referred_code_221, t0.is_referred_code_used AS is_referred_code_used_222, t0.promo_code_id AS promo_code_id_223, t0.max_discount_allowed AS max_discount_allowed_224, t0.claimed_promo_code_ids AS claimed_promo_code_ids_225, t0.referred_coins_earned AS referred_coins_earned_226, t0.referred_amount_earned AS referred_amount_earned_227, t0.rating_weight AS rating_weight_228, t0.rating_total AS rating_total_229, t0.rating_count AS rating_count_230, t0.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_231, t0.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_232, t0.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_233, t0.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_234, t0.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_235, t0.selector AS selector_236, t0.apply_for_consultant AS apply_for_consultant_237, t0.apply_for_consultant_date AS apply_for_consultant_date_238, t0.consultant_application_feedback AS consultant_application_feedback_239, t0.apply_for_retailer AS apply_for_retailer_240, t0.apply_for_retailer_date AS apply_for_retailer_date_241, t0.doc_image AS doc_image_242, t0.document_list AS document_list_243, t0.document_list_by_topic_id AS document_list_by_topic_id_244, t0.document_list_by_session_id AS document_list_by_session_id_245, t0.work_experience_year AS work_experience_year_246, t0.description AS description_247, t0.summary_text AS summary_text_248, t0.professional_title AS professional_title_249, t0.work_experience_text AS work_experience_text_250, t0.profession_text AS profession_text_251, t0.education_text AS education_text_252, t0.education_major_text AS education_major_text_253, t0.highest_degree_achieved AS highest_degree_achieved_254, t0.target_education_degree AS target_education_degree_255, t0.target_education_major AS target_education_major_256, t0.lead_query_text AS lead_query_text_257, t0.university_text AS university_text_258, t0.experience_text AS experience_text_259, t0.skillstext AS skillstext_260, t0.interest AS interest_261, t0.speciality AS speciality_262, t0.last_settings_updated_ts AS last_settings_updated_ts_263, t0.created_at AS created_at_264, t0.actual_registration_at AS actual_registration_at_265, t0.updated_at AS updated_at_266 FROM entity_applicant_details t0 WHERE t0.username = 'Majharul islam10016' LIMIT 1;

SELECT
  e0_.applicant_id AS applicant_id_0,
  e0_.sync_flag AS sync_flag_1,
  e0_.ids_by_device AS ids_by_device_2,
  e0_.schedule_available_flag AS schedule_available_flag_3,
  e0_.device_id AS device_id_4,
  e0_.device_id_locked_flag AS device_id_locked_flag_5,
  e0_.lock_device_id_on_next_login_flag AS lock_device_id_on_next_login_flag_6,
  e0_.username AS username_7,
  e0_.email AS email_8,
  e0_.o_auth_unique_id AS o_auth_unique_id_9,
  e0_.o_auth_email AS o_auth_email_10,
  e0_.fb_unique_id AS fb_unique_id_11,
  e0_.li_unique_id AS li_unique_id_12,
  e0_.google_unique_id AS google_unique_id_13,
  e0_.fb_profile_link AS fb_profile_link_14,
  e0_.fb_profile_id AS fb_profile_id_15,
  e0_.ig_profile_link AS ig_profile_link_16,
  e0_.ig_profile_id AS ig_profile_id_17,
  e0_.li_profile_link AS li_profile_link_18,
  e0_.li_profile_id AS li_profile_id_19,
  e0_.user_suspended_app_ids AS user_suspended_app_ids_20,
  e0_.user_app_ids AS user_app_ids_21,
  e0_.user_types_by_app_ids AS user_types_by_app_ids_22,
  e0_.password AS password_23,
  e0_.temp_password AS temp_password_24,
  e0_.salt AS salt_25,
  e0_.email_verification_hash AS email_verification_hash_26,
  e0_.phone_verification_hash AS phone_verification_hash_27,
  e0_.trigger_reset_password AS trigger_reset_password_28,
  e0_.otp_action_id AS otp_action_id_29,
  e0_.otp AS otp_30,
  e0_.otp_expire_ts AS otp_expire_ts_31,
  e0_.forgot_password_token AS forgot_password_token_32,
  e0_.forgot_password_token_expire_ts AS forgot_password_token_expire_ts_33,
  e0_.is_email_verified AS is_email_verified_34,
  e0_.is_phone_verified AS is_phone_verified_35,
  e0_.is_banned AS is_banned_36,
  e0_.ban_expires AS ban_expires_37,
  e0_.strike_count AS strike_count_38,
  e0_.strike_threshold AS strike_threshold_39,
  e0_.account_status AS account_status_40,
  e0_.student_level AS student_level_41,
  e0_.job_applicant_level AS job_applicant_level_42,
  e0_.consultant_level AS consultant_level_43,
  e0_.nationality_country_id AS nationality_country_id_44,
  e0_.current_country_id AS current_country_id_45,
  e0_.user_id AS user_id_46,
  e0_.firstname AS firstname_47,
  e0_.lastname AS lastname_48,
  e0_.image AS image_49,
  e0_.is_img_legal AS is_img_legal_50,
  e0_.nid AS nid_51,
  e0_.dob AS dob_52,
  e0_.sex AS sex_53,
  e0_.father AS father_54,
  e0_.mother AS mother_55,
  e0_.spouse AS spouse_56,
  e0_.child_1 AS child_1_57,
  e0_.child_2 AS child_2_58,
  e0_.blood AS blood_59,
  e0_.phone AS phone_60,
  e0_.official_phone AS official_phone_61,
  e0_.phone_with_country_code AS phone_with_country_code_62,
  e0_.phone_country_code AS phone_country_code_63,
  e0_.curr_addr_state AS curr_addr_state_64,
  e0_.curr_addr_city AS curr_addr_city_65,
  e0_.curr_addr_zip AS curr_addr_zip_66,
  e0_.curr_addr AS curr_addr_67,
  e0_.curr_addr_lat AS curr_addr_lat_68,
  e0_.curr_addr_lng AS curr_addr_lng_69,
  e0_.perm_addr AS perm_addr_70,
  e0_.emm_contact AS emm_contact_71,
  e0_.skill AS skill_72,
  e0_.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_73,
  e0_.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_74,
  e0_.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_75,
  e0_.preferred_country_ids_as_student AS preferred_country_ids_as_student_76,
  e0_.joining_date AS joining_date_77,
  e0_.emp_valid_till AS emp_valid_till_78,
  e0_.emp_status AS emp_status_79,
  e0_.emp_type AS emp_type_80,
  e0_.emp_code AS emp_code_81,
  e0_.emp_label AS emp_label_82,
  e0_.tin AS tin_83,
  e0_.tin_valid_till AS tin_valid_till_84,
  e0_.med_ins AS med_ins_85,
  e0_.med_ins_valid_till AS med_ins_valid_till_86,
  e0_.docs AS docs_87,
  e0_.inst1 AS inst1_88,
  e0_.yr1 AS yr1_89,
  e0_.dur1 AS dur1_90,
  e0_.inst2 AS inst2_91,
  e0_.yr2 AS yr2_92,
  e0_.dur2 AS dur2_93,
  e0_.inst3 AS inst3_94,
  e0_.yr3 AS yr3_95,
  e0_.dur3 AS dur3_96,
  e0_.einst1 AS einst1_97,
  e0_.eyr1 AS eyr1_98,
  e0_.edeg1 AS edeg1_99,
  e0_.einst2 AS einst2_100,
  e0_.eyr2 AS eyr2_101,
  e0_.edeg2 AS edeg2_102,
  e0_.einst3 AS einst3_103,
  e0_.eyr3 AS eyr3_104,
  e0_.edeg3 AS edeg3_105,
  e0_.tax_code AS tax_code_106,
  e0_.allowed_working_hours_per_day AS allowed_working_hours_per_day_107,
  e0_.allowed_working_hours_per_week AS allowed_working_hours_per_week_108,
  e0_.allowed_working_hours_per_month AS allowed_working_hours_per_month_109,
  e0_.allowed_working_hours_per_year AS allowed_working_hours_per_year_110,
  e0_.allowed_earning_per_day AS allowed_earning_per_day_111,
  e0_.allowed_earning_per_week AS allowed_earning_per_week_112,
  e0_.allowed_earning_per_month AS allowed_earning_per_month_113,
  e0_.allowed_earning_per_year AS allowed_earning_per_year_114,
  e0_.revenue_percentage_per_session AS revenue_percentage_per_session_115,
  e0_.transaction_acc_no AS transaction_acc_no_116,
  e0_.transaction_acc_name AS transaction_acc_name_117,
  e0_.bank_id AS bank_id_118,
  e0_.bank_branch_code AS bank_branch_code_119,
  e0_.bank_acc AS bank_acc_120,
  e0_.bank_acc_name AS bank_acc_name_121,
  e0_.bank_acc_type AS bank_acc_type_122,
  e0_.bank_acc_valid_from AS bank_acc_valid_from_123,
  e0_.bank_acc_valid_to AS bank_acc_valid_to_124,
  e0_.routing_code AS routing_code_125,
  e0_.swift_code AS swift_code_126,
  e0_.mobile_wallet_no AS mobile_wallet_no_127,
  e0_.mobile_wallet_type AS mobile_wallet_type_128,
  e0_.ear1 AS ear1_129,
  e0_.ear2 AS ear2_130,
  e0_.ear3 AS ear3_131,
  e0_.ear4 AS ear4_132,
  e0_.ear5 AS ear5_133,
  e0_.ear6 AS ear6_134,
  e0_.eart AS eart_135,
  e0_.ded1 AS ded1_136,
  e0_.ded2 AS ded2_137,
  e0_.ded3 AS ded3_138,
  e0_.ded4 AS ded4_139,
  e0_.dedt AS dedt_140,
  e0_.payable AS payable_141,
  e0_.hand_cash AS hand_cash_142,
  e0_.bank_transfer AS bank_transfer_143,
  e0_.sec_dep AS sec_dep_144,
  e0_.sec_dep_span AS sec_dep_span_145,
  e0_.sec_dep_rem_mon AS sec_dep_rem_mon_146,
  e0_.sec_dep_rem_amount AS sec_dep_rem_amount_147,
  e0_.sl_qty AS sl_qty_148,
  e0_.sl_tkn AS sl_tkn_149,
  e0_.sl_freq AS sl_freq_150,
  e0_.ml_qty AS ml_qty_151,
  e0_.ml_tkn AS ml_tkn_152,
  e0_.ml_freq AS ml_freq_153,
  e0_.el_qty AS el_qty_154,
  e0_.el_tkn AS el_tkn_155,
  e0_.el_freq AS el_freq_156,
  e0_.cl_qty AS cl_qty_157,
  e0_.cl_tkn AS cl_tkn_158,
  e0_.cl_freq AS cl_freq_159,
  e0_.levt AS levt_160,
  e0_.weekly_holiday AS weekly_holiday_161,
  e0_.files AS files_162,
  e0_.supervisor AS supervisor_163,
  e0_.dept AS dept_164,
  e0_.desg AS desg_165,
  e0_.branch AS branch_166,
  e0_.division AS division_167,
  e0_.application_text AS application_text_168,
  e0_.current_employment AS current_employment_169,
  e0_.emergency_contact_number AS emergency_contact_number_170,
  e0_.postal_code AS postal_code_171,
  e0_.country AS country_172,
  e0_.education_data AS education_data_173,
  e0_.work_experience_data AS work_experience_data_174,
  e0_.certificate_data AS certificate_data_175,
  e0_.languages_data AS languages_data_176,
  e0_.important_comm_tags AS important_comm_tags_177,
  e0_.is_consultant AS is_consultant_178,
  e0_.is_featured AS is_featured_179,
  e0_.featured_duration_end_ts AS featured_duration_end_ts_180,
  e0_.is_moderator AS is_moderator_181,
  e0_.is_admin AS is_admin_182,
  e0_.admin_level AS admin_level_183,
  e0_.is_retailer AS is_retailer_184,
  e0_.retailer_level AS retailer_level_185,
  e0_.is_student AS is_student_186,
  e0_.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_187,
  e0_.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_188,
  e0_.online_status AS online_status_189,
  e0_.assigned_sales_representative_id AS assigned_sales_representative_id_190,
  e0_.lead_created_by_id AS lead_created_by_id_191,
  e0_.is_temporary_entry AS is_temporary_entry_192,
  e0_.lead_type AS lead_type_193,
  e0_.lead_level AS lead_level_194,
  e0_.immediate_follow_up_flag AS immediate_follow_up_flag_195,
  e0_.pending_initial_communication AS pending_initial_communication_196,
  e0_.last_online_ts AS last_online_ts_197,
  e0_.courses_data AS courses_data_198,
  e0_.video_link AS video_link_199,
  e0_.account_balance AS account_balance_200,
  e0_.session_count_balance AS session_count_balance_201,
  e0_.total_session_used AS total_session_used_202,
  e0_.total_consultancy_session_provided AS total_consultancy_session_provided_203,
  e0_.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_204,
  e0_.default_currency_id AS default_currency_id_205,
  e0_.default_language_id AS default_language_id_206,
  e0_.country_id AS country_id_207,
  e0_.following_consultant_ids AS following_consultant_ids_208,
  e0_.following_topic_ids AS following_topic_ids_209,
  e0_.viewed_topic_ids AS viewed_topic_ids_210,
  e0_.viewed_consultant_ids AS viewed_consultant_ids_211,
  e0_.following_event_ids AS following_event_ids_212,
  e0_.attending_event_ids AS attending_event_ids_213,
  e0_.skip_event_ids AS skip_event_ids_214,
  e0_.rating AS rating_215,
  e0_.applicant_specific_note AS applicant_specific_note_216,
  e0_.promo_discount_percentage AS promo_discount_percentage_217,
  e0_.promo_discount_balance_count AS promo_discount_balance_count_218,
  e0_.code_as_referer AS code_as_referer_219,
  e0_.referred_code AS referred_code_220,
  e0_.is_referred_code_used AS is_referred_code_used_221,
  e0_.promo_code_id AS promo_code_id_222,
  e0_.max_discount_allowed AS max_discount_allowed_223,
  e0_.claimed_promo_code_ids AS claimed_promo_code_ids_224,
  e0_.referred_coins_earned AS referred_coins_earned_225,
  e0_.referred_amount_earned AS referred_amount_earned_226,
  e0_.rating_weight AS rating_weight_227,
  e0_.rating_total AS rating_total_228,
  e0_.rating_count AS rating_count_229,
  e0_.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_230,
  e0_.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_231,
  e0_.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_232,
  e0_.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_233,
  e0_.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_234,
  e0_.selector AS selector_235,
  e0_.apply_for_consultant AS apply_for_consultant_236,
  e0_.apply_for_consultant_date AS apply_for_consultant_date_237,
  e0_.consultant_application_feedback AS consultant_application_feedback_238,
  e0_.apply_for_retailer AS apply_for_retailer_239,
  e0_.apply_for_retailer_date AS apply_for_retailer_date_240,
  e0_.doc_image AS doc_image_241,
  e0_.document_list AS document_list_242,
  e0_.document_list_by_topic_id AS document_list_by_topic_id_243,
  e0_.document_list_by_session_id AS document_list_by_session_id_244,
  e0_.work_experience_year AS work_experience_year_245,
  e0_.description AS description_246,
  e0_.summary_text AS summary_text_247,
  e0_.professional_title AS professional_title_248,
  e0_.work_experience_text AS work_experience_text_249,
  e0_.profession_text AS profession_text_250,
  e0_.education_text AS education_text_251,
  e0_.education_major_text AS education_major_text_252,
  e0_.highest_degree_achieved AS highest_degree_achieved_253,
  e0_.target_education_degree AS target_education_degree_254,
  e0_.target_education_major AS target_education_major_255,
  e0_.lead_query_text AS lead_query_text_256,
  e0_.university_text AS university_text_257,
  e0_.experience_text AS experience_text_258,
  e0_.skillstext AS skillstext_259,
  e0_.interest AS interest_260,
  e0_.speciality AS speciality_261,
  e0_.last_settings_updated_ts AS last_settings_updated_ts_262,
  e0_.created_at AS created_at_263,
  e0_.actual_registration_at AS actual_registration_at_264,
  e0_.updated_at AS updated_at_265
FROM
  entity_applicant_details e0_
WHERE
  e0_.email LIKE '%Majharulislam10016%'