Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

17 Database Queries

13 Different statements

96.56 ms Query time

0 Invalid entities

Queries

Group similar statements

company_group connection


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.religion AS religion_61, t0.phone AS phone_62, t0.official_phone AS official_phone_63, t0.phone_with_country_code AS phone_with_country_code_64, t0.phone_country_code AS phone_country_code_65, t0.curr_addr_state AS curr_addr_state_66, t0.curr_addr_city AS curr_addr_city_67, t0.curr_addr_zip AS curr_addr_zip_68, t0.curr_addr AS curr_addr_69, t0.curr_addr_lat AS curr_addr_lat_70, t0.curr_addr_lng AS curr_addr_lng_71, t0.perm_addr AS perm_addr_72, t0.emm_contact AS emm_contact_73, t0.skill AS skill_74, t0.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_75, t0.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_76, t0.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_77, t0.preferred_country_ids_as_student AS preferred_country_ids_as_student_78, t0.joining_date AS joining_date_79, t0.emp_valid_till AS emp_valid_till_80, t0.emp_status AS emp_status_81, t0.emp_type AS emp_type_82, t0.emp_code AS emp_code_83, t0.emp_label AS emp_label_84, t0.tin AS tin_85, t0.tin_valid_till AS tin_valid_till_86, t0.med_ins AS med_ins_87, t0.med_ins_valid_till AS med_ins_valid_till_88, t0.docs AS docs_89, t0.inst1 AS inst1_90, t0.yr1 AS yr1_91, t0.dur1 AS dur1_92, t0.inst2 AS inst2_93, t0.yr2 AS yr2_94, t0.dur2 AS dur2_95, t0.inst3 AS inst3_96, t0.yr3 AS yr3_97, t0.dur3 AS dur3_98, t0.einst1 AS einst1_99, t0.eyr1 AS eyr1_100, t0.edeg1 AS edeg1_101, t0.einst2 AS einst2_102, t0.eyr2 AS eyr2_103, t0.edeg2 AS edeg2_104, t0.einst3 AS einst3_105, t0.eyr3 AS eyr3_106, t0.edeg3 AS edeg3_107, t0.tax_code AS tax_code_108, t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_109, t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_110, t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_111, t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_112, t0.allowed_earning_per_day AS allowed_earning_per_day_113, t0.allowed_earning_per_week AS allowed_earning_per_week_114, t0.allowed_earning_per_month AS allowed_earning_per_month_115, t0.allowed_earning_per_year AS allowed_earning_per_year_116, t0.revenue_percentage_per_session AS revenue_percentage_per_session_117, t0.transaction_acc_no AS transaction_acc_no_118, t0.transaction_acc_name AS transaction_acc_name_119, t0.bank_id AS bank_id_120, t0.bank_branch_code AS bank_branch_code_121, t0.bank_acc AS bank_acc_122, t0.bank_name AS bank_name_123, t0.bank_acc_name AS bank_acc_name_124, t0.bank_acc_type AS bank_acc_type_125, t0.bank_acc_valid_from AS bank_acc_valid_from_126, t0.bank_acc_valid_to AS bank_acc_valid_to_127, t0.routing_code AS routing_code_128, t0.swift_code AS swift_code_129, t0.mobile_wallet_no AS mobile_wallet_no_130, t0.mobile_wallet_type AS mobile_wallet_type_131, t0.ear1 AS ear1_132, t0.ear2 AS ear2_133, t0.ear3 AS ear3_134, t0.ear4 AS ear4_135, t0.ear5 AS ear5_136, t0.ear6 AS ear6_137, t0.eart AS eart_138, t0.ded1 AS ded1_139, t0.ded2 AS ded2_140, t0.ded3 AS ded3_141, t0.ded4 AS ded4_142, t0.dedt AS dedt_143, t0.payable AS payable_144, t0.hand_cash AS hand_cash_145, t0.bank_transfer AS bank_transfer_146, t0.sec_dep AS sec_dep_147, t0.sec_dep_span AS sec_dep_span_148, t0.sec_dep_rem_mon AS sec_dep_rem_mon_149, t0.sec_dep_rem_amount AS sec_dep_rem_amount_150, t0.sl_qty AS sl_qty_151, t0.sl_tkn AS sl_tkn_152, t0.sl_freq AS sl_freq_153, t0.ml_qty AS ml_qty_154, t0.ml_tkn AS ml_tkn_155, t0.ml_freq AS ml_freq_156, t0.el_qty AS el_qty_157, t0.el_tkn AS el_tkn_158, t0.el_freq AS el_freq_159, t0.cl_qty AS cl_qty_160, t0.cl_tkn AS cl_tkn_161, t0.cl_freq AS cl_freq_162, t0.levt AS levt_163, t0.weekly_holiday AS weekly_holiday_164, t0.files AS files_165, t0.supervisor AS supervisor_166, t0.dept AS dept_167, t0.desg AS desg_168, t0.branch AS branch_169, t0.division AS division_170, t0.application_text AS application_text_171, t0.current_employment AS current_employment_172, t0.emergency_contact_number AS emergency_contact_number_173, t0.postal_code AS postal_code_174, t0.country AS country_175, t0.education_data AS education_data_176, t0.work_experience_data AS work_experience_data_177, t0.certificate_data AS certificate_data_178, t0.languages_data AS languages_data_179, t0.important_comm_tags AS important_comm_tags_180, t0.is_consultant AS is_consultant_181, t0.is_featured AS is_featured_182, t0.featured_duration_end_ts AS featured_duration_end_ts_183, t0.is_moderator AS is_moderator_184, t0.is_admin AS is_admin_185, t0.admin_level AS admin_level_186, t0.is_retailer AS is_retailer_187, t0.retailer_level AS retailer_level_188, t0.is_student AS is_student_189, t0.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_190, t0.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_191, t0.online_status AS online_status_192, t0.assigned_sales_representative_id AS assigned_sales_representative_id_193, t0.lead_created_by_id AS lead_created_by_id_194, t0.is_temporary_entry AS is_temporary_entry_195, t0.lead_type AS lead_type_196, t0.lead_level AS lead_level_197, t0.immediate_follow_up_flag AS immediate_follow_up_flag_198, t0.pending_initial_communication AS pending_initial_communication_199, t0.last_online_ts AS last_online_ts_200, t0.courses_data AS courses_data_201, t0.video_link AS video_link_202, t0.account_balance AS account_balance_203, t0.session_count_balance AS session_count_balance_204, t0.total_session_used AS total_session_used_205, t0.total_consultancy_session_provided AS total_consultancy_session_provided_206, t0.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_207, t0.default_currency_id AS default_currency_id_208, t0.default_language_id AS default_language_id_209, t0.country_id AS country_id_210, t0.following_consultant_ids AS following_consultant_ids_211, t0.following_topic_ids AS following_topic_ids_212, t0.viewed_topic_ids AS viewed_topic_ids_213, t0.viewed_consultant_ids AS viewed_consultant_ids_214, t0.following_event_ids AS following_event_ids_215, t0.attending_event_ids AS attending_event_ids_216, t0.skip_event_ids AS skip_event_ids_217, t0.rating AS rating_218, t0.applicant_specific_note AS applicant_specific_note_219, t0.promo_discount_percentage AS promo_discount_percentage_220, t0.promo_discount_balance_count AS promo_discount_balance_count_221, t0.code_as_referer AS code_as_referer_222, t0.referred_code AS referred_code_223, t0.is_referred_code_used AS is_referred_code_used_224, t0.promo_code_id AS promo_code_id_225, t0.max_discount_allowed AS max_discount_allowed_226, t0.claimed_promo_code_ids AS claimed_promo_code_ids_227, t0.referred_coins_earned AS referred_coins_earned_228, t0.referred_amount_earned AS referred_amount_earned_229, t0.rating_weight AS rating_weight_230, t0.rating_total AS rating_total_231, t0.rating_count AS rating_count_232, t0.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_233, t0.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_234, t0.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_235, t0.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_236, t0.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_237, t0.selector AS selector_238, t0.apply_for_consultant AS apply_for_consultant_239, t0.apply_for_consultant_date AS apply_for_consultant_date_240, t0.consultant_application_feedback AS consultant_application_feedback_241, t0.apply_for_retailer AS apply_for_retailer_242, t0.apply_for_retailer_date AS apply_for_retailer_date_243, t0.doc_image AS doc_image_244, t0.document_list AS document_list_245, t0.document_list_by_topic_id AS document_list_by_topic_id_246, t0.document_list_by_session_id AS document_list_by_session_id_247, t0.work_experience_year AS work_experience_year_248, t0.description AS description_249, t0.summary_text AS summary_text_250, t0.professional_title AS professional_title_251, t0.work_experience_text AS work_experience_text_252, t0.profession_text AS profession_text_253, t0.education_text AS education_text_254, t0.education_major_text AS education_major_text_255, t0.highest_degree_achieved AS highest_degree_achieved_256, t0.target_education_degree AS target_education_degree_257, t0.target_education_major AS target_education_major_258, t0.lead_query_text AS lead_query_text_259, t0.university_text AS university_text_260, t0.experience_text AS experience_text_261, t0.skillstext AS skillstext_262, t0.interest AS interest_263, t0.speciality AS speciality_264, t0.last_settings_updated_ts AS last_settings_updated_ts_265, t0.created_at AS created_at_266, t0.actual_registration_at AS actual_registration_at_267, t0.updated_at AS updated_at_268 FROM entity_applicant_details t0 WHERE t0.username IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.sync_flag AS sync_flag_2, t0.name AS name_3, t0.image AS image_4, t0.app_id AS app_id_5, t0.owner_id AS owner_id_6, t0.stripe_customer_id AS stripe_customer_id_7, t0.manage_user_ids AS manage_user_ids_8, t0.post_dated_job_active AS post_dated_job_active_9, t0.address AS address_10, t0.shipping_address AS shipping_address_11, t0.billing_address AS billing_address_12, t0.motto AS motto_13, t0.invoice_footer AS invoice_footer_14, t0.general_footer AS general_footer_15, t0.company_allowed AS company_allowed_16, t0.company_allocated AS company_allocated_17, t0.country_id AS country_id_18, t0.locale AS locale_19, t0.company_remaining AS company_remaining_20, t0.user_allowed AS user_allowed_21, t0.user_allocated AS user_allocated_22, t0.user_remaining AS user_remaining_23, t0.admin_user_allowed AS admin_user_allowed_24, t0.admin_user_allocated AS admin_user_allocated_25, t0.admin_user_remaining AS admin_user_remaining_26, t0.contact_number AS contact_number_27, t0.email AS email_28, t0.db_name AS db_name_29, t0.db_pass AS db_pass_30, t0.db_user AS db_user_31, t0.db_host AS db_host_32, t0.company_group_hash AS company_group_hash_33, t0.company_group_unique_code AS company_group_unique_code_34, t0.enabled_module_id_list AS enabled_module_id_list_35, t0.company_group_server_id AS company_group_server_id_36, t0.company_group_server_hash AS company_group_server_hash_37, t0.company_group_server_address AS company_group_server_address_38, t0.company_group_server_port AS company_group_server_port_39, t0.company_bin AS company_bin_40, t0.company_tin AS company_tin_41, t0.company_reg AS company_reg_42, t0.company_tl AS company_tl_43, t0.initiate_flag AS initiate_flag_44, t0.current_server_id AS current_server_id_45, t0.current_server_hash AS current_server_hash_46, t0.current_server_address AS current_server_address_47, t0.current_server_port AS current_server_port_48, t0.usage_valid_upto_date AS usage_valid_upto_date_49, t0.usage_valid_upto_date_ts AS usage_valid_upto_date_ts_50, t0.company_group_server_domain_full_link AS company_group_server_domain_full_link_51, t0.current_server_domain_full_link AS current_server_domain_full_link_52, t0.company_group_billing_info AS company_group_billing_info_53, t0.company_group_next_bill_date AS company_group_next_bill_date_54, t0.company_group_next_bill_date_ts AS company_group_next_bill_date_ts_55, t0.company_group_billing_frequency AS company_group_billing_frequency_56, t0.cash AS cash_57, t0.sales AS sales_58, t0.expense AS expense_59, t0.payable AS payable_60, t0.net_worth AS net_worth_61, t0.monthly_growth AS monthly_growth_62, t0.active AS active_63, t0.read_only_mode AS read_only_mode_64, t0.company_status AS company_status_65, t0.package_type AS package_type_66, t0.subscription_expiry AS subscription_expiry_67, t0.last_activity_at AS last_activity_at_68, t0.current_subscription_package_id AS current_subscription_package_id_69, t0.subscription_month AS subscription_month_70, t0.billing_amount AS billing_amount_71, t0.subscription_details AS subscription_details_72, t0.company_type AS company_type_73, t0.company_description AS company_description_74, t0.skip_in_web_flag AS skip_in_web_flag_75, t0.skip_in_app_flag AS skip_in_app_flag_76, t0.schema_update_pending_flag AS schema_update_pending_flag_77, t0.created_at AS created_at_78, t0.updated_at AS updated_at_79 FROM company_group t0
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_.religion AS religion_60, e0_.phone AS phone_61, e0_.official_phone AS official_phone_62, e0_.phone_with_country_code AS phone_with_country_code_63, e0_.phone_country_code AS phone_country_code_64, e0_.curr_addr_state AS curr_addr_state_65, e0_.curr_addr_city AS curr_addr_city_66, e0_.curr_addr_zip AS curr_addr_zip_67, e0_.curr_addr AS curr_addr_68, e0_.curr_addr_lat AS curr_addr_lat_69, e0_.curr_addr_lng AS curr_addr_lng_70, e0_.perm_addr AS perm_addr_71, e0_.emm_contact AS emm_contact_72, e0_.skill AS skill_73, e0_.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_74, e0_.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_75, e0_.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_76, e0_.preferred_country_ids_as_student AS preferred_country_ids_as_student_77, e0_.joining_date AS joining_date_78, e0_.emp_valid_till AS emp_valid_till_79, e0_.emp_status AS emp_status_80, e0_.emp_type AS emp_type_81, e0_.emp_code AS emp_code_82, e0_.emp_label AS emp_label_83, e0_.tin AS tin_84, e0_.tin_valid_till AS tin_valid_till_85, e0_.med_ins AS med_ins_86, e0_.med_ins_valid_till AS med_ins_valid_till_87, e0_.docs AS docs_88, e0_.inst1 AS inst1_89, e0_.yr1 AS yr1_90, e0_.dur1 AS dur1_91, e0_.inst2 AS inst2_92, e0_.yr2 AS yr2_93, e0_.dur2 AS dur2_94, e0_.inst3 AS inst3_95, e0_.yr3 AS yr3_96, e0_.dur3 AS dur3_97, e0_.einst1 AS einst1_98, e0_.eyr1 AS eyr1_99, e0_.edeg1 AS edeg1_100, e0_.einst2 AS einst2_101, e0_.eyr2 AS eyr2_102, e0_.edeg2 AS edeg2_103, e0_.einst3 AS einst3_104, e0_.eyr3 AS eyr3_105, e0_.edeg3 AS edeg3_106, e0_.tax_code AS tax_code_107, e0_.allowed_working_hours_per_day AS allowed_working_hours_per_day_108, e0_.allowed_working_hours_per_week AS allowed_working_hours_per_week_109, e0_.allowed_working_hours_per_month AS allowed_working_hours_per_month_110, e0_.allowed_working_hours_per_year AS allowed_working_hours_per_year_111, e0_.allowed_earning_per_day AS allowed_earning_per_day_112, e0_.allowed_earning_per_week AS allowed_earning_per_week_113, e0_.allowed_earning_per_month AS allowed_earning_per_month_114, e0_.allowed_earning_per_year AS allowed_earning_per_year_115, e0_.revenue_percentage_per_session AS revenue_percentage_per_session_116, e0_.transaction_acc_no AS transaction_acc_no_117, e0_.transaction_acc_name AS transaction_acc_name_118, e0_.bank_id AS bank_id_119, e0_.bank_branch_code AS bank_branch_code_120, e0_.bank_acc AS bank_acc_121, e0_.bank_name AS bank_name_122, e0_.bank_acc_name AS bank_acc_name_123, e0_.bank_acc_type AS bank_acc_type_124, e0_.bank_acc_valid_from AS bank_acc_valid_from_125, e0_.bank_acc_valid_to AS bank_acc_valid_to_126, e0_.routing_code AS routing_code_127, e0_.swift_code AS swift_code_128, e0_.mobile_wallet_no AS mobile_wallet_no_129, e0_.mobile_wallet_type AS mobile_wallet_type_130, e0_.ear1 AS ear1_131, e0_.ear2 AS ear2_132, e0_.ear3 AS ear3_133, e0_.ear4 AS ear4_134, e0_.ear5 AS ear5_135, e0_.ear6 AS ear6_136, e0_.eart AS eart_137, e0_.ded1 AS ded1_138, e0_.ded2 AS ded2_139, e0_.ded3 AS ded3_140, e0_.ded4 AS ded4_141, e0_.dedt AS dedt_142, e0_.payable AS payable_143, e0_.hand_cash AS hand_cash_144, e0_.bank_transfer AS bank_transfer_145, e0_.sec_dep AS sec_dep_146, e0_.sec_dep_span AS sec_dep_span_147, e0_.sec_dep_rem_mon AS sec_dep_rem_mon_148, e0_.sec_dep_rem_amount AS sec_dep_rem_amount_149, e0_.sl_qty AS sl_qty_150, e0_.sl_tkn AS sl_tkn_151, e0_.sl_freq AS sl_freq_152, e0_.ml_qty AS ml_qty_153, e0_.ml_tkn AS ml_tkn_154, e0_.ml_freq AS ml_freq_155, e0_.el_qty AS el_qty_156, e0_.el_tkn AS el_tkn_157, e0_.el_freq AS el_freq_158, e0_.cl_qty AS cl_qty_159, e0_.cl_tkn AS cl_tkn_160, e0_.cl_freq AS cl_freq_161, e0_.levt AS levt_162, e0_.weekly_holiday AS weekly_holiday_163, e0_.files AS files_164, e0_.supervisor AS supervisor_165, e0_.dept AS dept_166, e0_.desg AS desg_167, e0_.branch AS branch_168, e0_.division AS division_169, e0_.application_text AS application_text_170, e0_.current_employment AS current_employment_171, e0_.emergency_contact_number AS emergency_contact_number_172, e0_.postal_code AS postal_code_173, e0_.country AS country_174, e0_.education_data AS education_data_175, e0_.work_experience_data AS work_experience_data_176, e0_.certificate_data AS certificate_data_177, e0_.languages_data AS languages_data_178, e0_.important_comm_tags AS important_comm_tags_179, e0_.is_consultant AS is_consultant_180, e0_.is_featured AS is_featured_181, e0_.featured_duration_end_ts AS featured_duration_end_ts_182, e0_.is_moderator AS is_moderator_183, e0_.is_admin AS is_admin_184, e0_.admin_level AS admin_level_185, e0_.is_retailer AS is_retailer_186, e0_.retailer_level AS retailer_level_187, e0_.is_student AS is_student_188, e0_.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_189, e0_.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_190, e0_.online_status AS online_status_191, e0_.assigned_sales_representative_id AS assigned_sales_representative_id_192, e0_.lead_created_by_id AS lead_created_by_id_193, e0_.is_temporary_entry AS is_temporary_entry_194, e0_.lead_type AS lead_type_195, e0_.lead_level AS lead_level_196, e0_.immediate_follow_up_flag AS immediate_follow_up_flag_197, e0_.pending_initial_communication AS pending_initial_communication_198, e0_.last_online_ts AS last_online_ts_199, e0_.courses_data AS courses_data_200, e0_.video_link AS video_link_201, e0_.account_balance AS account_balance_202, e0_.session_count_balance AS session_count_balance_203, e0_.total_session_used AS total_session_used_204, e0_.total_consultancy_session_provided AS total_consultancy_session_provided_205, e0_.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_206, e0_.default_currency_id AS default_currency_id_207, e0_.default_language_id AS default_language_id_208, e0_.country_id AS country_id_209, e0_.following_consultant_ids AS following_consultant_ids_210, e0_.following_topic_ids AS following_topic_ids_211, e0_.viewed_topic_ids AS viewed_topic_ids_212, e0_.viewed_consultant_ids AS viewed_consultant_ids_213, e0_.following_event_ids AS following_event_ids_214, e0_.attending_event_ids AS attending_event_ids_215, e0_.skip_event_ids AS skip_event_ids_216, e0_.rating AS rating_217, e0_.applicant_specific_note AS applicant_specific_note_218, e0_.promo_discount_percentage AS promo_discount_percentage_219, e0_.promo_discount_balance_count AS promo_discount_balance_count_220, e0_.code_as_referer AS code_as_referer_221, e0_.referred_code AS referred_code_222, e0_.is_referred_code_used AS is_referred_code_used_223, e0_.promo_code_id AS promo_code_id_224, e0_.max_discount_allowed AS max_discount_allowed_225, e0_.claimed_promo_code_ids AS claimed_promo_code_ids_226, e0_.referred_coins_earned AS referred_coins_earned_227, e0_.referred_amount_earned AS referred_amount_earned_228, e0_.rating_weight AS rating_weight_229, e0_.rating_total AS rating_total_230, e0_.rating_count AS rating_count_231, e0_.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_232, e0_.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_233, e0_.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_234, e0_.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_235, e0_.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_236, e0_.selector AS selector_237, e0_.apply_for_consultant AS apply_for_consultant_238, e0_.apply_for_consultant_date AS apply_for_consultant_date_239, e0_.consultant_application_feedback AS consultant_application_feedback_240, e0_.apply_for_retailer AS apply_for_retailer_241, e0_.apply_for_retailer_date AS apply_for_retailer_date_242, e0_.doc_image AS doc_image_243, e0_.document_list AS document_list_244, e0_.document_list_by_topic_id AS document_list_by_topic_id_245, e0_.document_list_by_session_id AS document_list_by_session_id_246, e0_.work_experience_year AS work_experience_year_247, e0_.description AS description_248, e0_.summary_text AS summary_text_249, e0_.professional_title AS professional_title_250, e0_.work_experience_text AS work_experience_text_251, e0_.profession_text AS profession_text_252, e0_.education_text AS education_text_253, e0_.education_major_text AS education_major_text_254, e0_.highest_degree_achieved AS highest_degree_achieved_255, e0_.target_education_degree AS target_education_degree_256, e0_.target_education_major AS target_education_major_257, e0_.lead_query_text AS lead_query_text_258, e0_.university_text AS university_text_259, e0_.experience_text AS experience_text_260, e0_.skillstext AS skillstext_261, e0_.interest AS interest_262, e0_.speciality AS speciality_263, e0_.last_settings_updated_ts AS last_settings_updated_ts_264, e0_.created_at AS created_at_265, e0_.actual_registration_at AS actual_registration_at_266, e0_.updated_at AS updated_at_267 FROM entity_applicant_details e0_ WHERE e0_.email LIKE ? OR e0_.o_auth_email LIKE ?
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.religion AS religion_61, t0.phone AS phone_62, t0.official_phone AS official_phone_63, t0.phone_with_country_code AS phone_with_country_code_64, t0.phone_country_code AS phone_country_code_65, t0.curr_addr_state AS curr_addr_state_66, t0.curr_addr_city AS curr_addr_city_67, t0.curr_addr_zip AS curr_addr_zip_68, t0.curr_addr AS curr_addr_69, t0.curr_addr_lat AS curr_addr_lat_70, t0.curr_addr_lng AS curr_addr_lng_71, t0.perm_addr AS perm_addr_72, t0.emm_contact AS emm_contact_73, t0.skill AS skill_74, t0.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_75, t0.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_76, t0.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_77, t0.preferred_country_ids_as_student AS preferred_country_ids_as_student_78, t0.joining_date AS joining_date_79, t0.emp_valid_till AS emp_valid_till_80, t0.emp_status AS emp_status_81, t0.emp_type AS emp_type_82, t0.emp_code AS emp_code_83, t0.emp_label AS emp_label_84, t0.tin AS tin_85, t0.tin_valid_till AS tin_valid_till_86, t0.med_ins AS med_ins_87, t0.med_ins_valid_till AS med_ins_valid_till_88, t0.docs AS docs_89, t0.inst1 AS inst1_90, t0.yr1 AS yr1_91, t0.dur1 AS dur1_92, t0.inst2 AS inst2_93, t0.yr2 AS yr2_94, t0.dur2 AS dur2_95, t0.inst3 AS inst3_96, t0.yr3 AS yr3_97, t0.dur3 AS dur3_98, t0.einst1 AS einst1_99, t0.eyr1 AS eyr1_100, t0.edeg1 AS edeg1_101, t0.einst2 AS einst2_102, t0.eyr2 AS eyr2_103, t0.edeg2 AS edeg2_104, t0.einst3 AS einst3_105, t0.eyr3 AS eyr3_106, t0.edeg3 AS edeg3_107, t0.tax_code AS tax_code_108, t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_109, t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_110, t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_111, t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_112, t0.allowed_earning_per_day AS allowed_earning_per_day_113, t0.allowed_earning_per_week AS allowed_earning_per_week_114, t0.allowed_earning_per_month AS allowed_earning_per_month_115, t0.allowed_earning_per_year AS allowed_earning_per_year_116, t0.revenue_percentage_per_session AS revenue_percentage_per_session_117, t0.transaction_acc_no AS transaction_acc_no_118, t0.transaction_acc_name AS transaction_acc_name_119, t0.bank_id AS bank_id_120, t0.bank_branch_code AS bank_branch_code_121, t0.bank_acc AS bank_acc_122, t0.bank_name AS bank_name_123, t0.bank_acc_name AS bank_acc_name_124, t0.bank_acc_type AS bank_acc_type_125, t0.bank_acc_valid_from AS bank_acc_valid_from_126, t0.bank_acc_valid_to AS bank_acc_valid_to_127, t0.routing_code AS routing_code_128, t0.swift_code AS swift_code_129, t0.mobile_wallet_no AS mobile_wallet_no_130, t0.mobile_wallet_type AS mobile_wallet_type_131, t0.ear1 AS ear1_132, t0.ear2 AS ear2_133, t0.ear3 AS ear3_134, t0.ear4 AS ear4_135, t0.ear5 AS ear5_136, t0.ear6 AS ear6_137, t0.eart AS eart_138, t0.ded1 AS ded1_139, t0.ded2 AS ded2_140, t0.ded3 AS ded3_141, t0.ded4 AS ded4_142, t0.dedt AS dedt_143, t0.payable AS payable_144, t0.hand_cash AS hand_cash_145, t0.bank_transfer AS bank_transfer_146, t0.sec_dep AS sec_dep_147, t0.sec_dep_span AS sec_dep_span_148, t0.sec_dep_rem_mon AS sec_dep_rem_mon_149, t0.sec_dep_rem_amount AS sec_dep_rem_amount_150, t0.sl_qty AS sl_qty_151, t0.sl_tkn AS sl_tkn_152, t0.sl_freq AS sl_freq_153, t0.ml_qty AS ml_qty_154, t0.ml_tkn AS ml_tkn_155, t0.ml_freq AS ml_freq_156, t0.el_qty AS el_qty_157, t0.el_tkn AS el_tkn_158, t0.el_freq AS el_freq_159, t0.cl_qty AS cl_qty_160, t0.cl_tkn AS cl_tkn_161, t0.cl_freq AS cl_freq_162, t0.levt AS levt_163, t0.weekly_holiday AS weekly_holiday_164, t0.files AS files_165, t0.supervisor AS supervisor_166, t0.dept AS dept_167, t0.desg AS desg_168, t0.branch AS branch_169, t0.division AS division_170, t0.application_text AS application_text_171, t0.current_employment AS current_employment_172, t0.emergency_contact_number AS emergency_contact_number_173, t0.postal_code AS postal_code_174, t0.country AS country_175, t0.education_data AS education_data_176, t0.work_experience_data AS work_experience_data_177, t0.certificate_data AS certificate_data_178, t0.languages_data AS languages_data_179, t0.important_comm_tags AS important_comm_tags_180, t0.is_consultant AS is_consultant_181, t0.is_featured AS is_featured_182, t0.featured_duration_end_ts AS featured_duration_end_ts_183, t0.is_moderator AS is_moderator_184, t0.is_admin AS is_admin_185, t0.admin_level AS admin_level_186, t0.is_retailer AS is_retailer_187, t0.retailer_level AS retailer_level_188, t0.is_student AS is_student_189, t0.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_190, t0.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_191, t0.online_status AS online_status_192, t0.assigned_sales_representative_id AS assigned_sales_representative_id_193, t0.lead_created_by_id AS lead_created_by_id_194, t0.is_temporary_entry AS is_temporary_entry_195, t0.lead_type AS lead_type_196, t0.lead_level AS lead_level_197, t0.immediate_follow_up_flag AS immediate_follow_up_flag_198, t0.pending_initial_communication AS pending_initial_communication_199, t0.last_online_ts AS last_online_ts_200, t0.courses_data AS courses_data_201, t0.video_link AS video_link_202, t0.account_balance AS account_balance_203, t0.session_count_balance AS session_count_balance_204, t0.total_session_used AS total_session_used_205, t0.total_consultancy_session_provided AS total_consultancy_session_provided_206, t0.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_207, t0.default_currency_id AS default_currency_id_208, t0.default_language_id AS default_language_id_209, t0.country_id AS country_id_210, t0.following_consultant_ids AS following_consultant_ids_211, t0.following_topic_ids AS following_topic_ids_212, t0.viewed_topic_ids AS viewed_topic_ids_213, t0.viewed_consultant_ids AS viewed_consultant_ids_214, t0.following_event_ids AS following_event_ids_215, t0.attending_event_ids AS attending_event_ids_216, t0.skip_event_ids AS skip_event_ids_217, t0.rating AS rating_218, t0.applicant_specific_note AS applicant_specific_note_219, t0.promo_discount_percentage AS promo_discount_percentage_220, t0.promo_discount_balance_count AS promo_discount_balance_count_221, t0.code_as_referer AS code_as_referer_222, t0.referred_code AS referred_code_223, t0.is_referred_code_used AS is_referred_code_used_224, t0.promo_code_id AS promo_code_id_225, t0.max_discount_allowed AS max_discount_allowed_226, t0.claimed_promo_code_ids AS claimed_promo_code_ids_227, t0.referred_coins_earned AS referred_coins_earned_228, t0.referred_amount_earned AS referred_amount_earned_229, t0.rating_weight AS rating_weight_230, t0.rating_total AS rating_total_231, t0.rating_count AS rating_count_232, t0.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_233, t0.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_234, t0.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_235, t0.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_236, t0.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_237, t0.selector AS selector_238, t0.apply_for_consultant AS apply_for_consultant_239, t0.apply_for_consultant_date AS apply_for_consultant_date_240, t0.consultant_application_feedback AS consultant_application_feedback_241, t0.apply_for_retailer AS apply_for_retailer_242, t0.apply_for_retailer_date AS apply_for_retailer_date_243, t0.doc_image AS doc_image_244, t0.document_list AS document_list_245, t0.document_list_by_topic_id AS document_list_by_topic_id_246, t0.document_list_by_session_id AS document_list_by_session_id_247, t0.work_experience_year AS work_experience_year_248, t0.description AS description_249, t0.summary_text AS summary_text_250, t0.professional_title AS professional_title_251, t0.work_experience_text AS work_experience_text_252, t0.profession_text AS profession_text_253, t0.education_text AS education_text_254, t0.education_major_text AS education_major_text_255, t0.highest_degree_achieved AS highest_degree_achieved_256, t0.target_education_degree AS target_education_degree_257, t0.target_education_major AS target_education_major_258, t0.lead_query_text AS lead_query_text_259, t0.university_text AS university_text_260, t0.experience_text AS experience_text_261, t0.skillstext AS skillstext_262, t0.interest AS interest_263, t0.speciality AS speciality_264, t0.last_settings_updated_ts AS last_settings_updated_ts_265, t0.created_at AS created_at_266, t0.actual_registration_at AS actual_registration_at_267, t0.updated_at AS updated_at_268 FROM entity_applicant_details t0 WHERE t0.o_auth_unique_id = ? LIMIT 1
"START TRANSACTION"
INSERT INTO entity_login_log (user_id, applicant_id, is_applicant, position_id, login_ip, log_time, log_status, device_id, firebase_token, locale, o_auth_token, o_auth_type, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
SELECT t0.id AS id_1, t0.anon_token AS anon_token_2, t0.share_token AS share_token_3, t0.applicant_id AS applicant_id_4, t0.email AS email_5, t0.title AS title_6, t0.address AS address_7, t0.lat AS lat_8, t0.lng AS lng_9, t0.inputs_json AS inputs_json_10, t0.estimate_json AS estimate_json_11, t0.report_json AS report_json_12, t0.design_json AS design_json_13, t0.status AS status_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.attached_at AS attached_at_17, t0.report_at AS report_at_18, t0.converted_app_id AS converted_app_id_19, t0.converted_ref AS converted_ref_20, t0.converted_at AS converted_at_21 FROM hb360_project t0 WHERE t0.anon_token = ? AND t0.status = ?
SELECT t0.id AS id_1, t0.organization_id AS organization_id_2, t0.app_id AS app_id_3, t0.applicant_id AS applicant_id_4, t0.user_type AS user_type_5, t0.role AS role_6, t0.status AS status_7, t0.erp_entity_type AS erp_entity_type_8, t0.erp_entity_id AS erp_entity_id_9, t0.source AS source_10, t0.metadata_json AS metadata_json_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM entity_organization_user_access t0 WHERE t0.applicant_id = ? AND t0.status = ? AND t0.user_type = ? AND t0.erp_entity_type = ?
"START TRANSACTION"
INSERT INTO entity_token_storage (session_data, token, fire_base_token, user_id, user_type, expires_at, perpetual, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
"START TRANSACTION"
UPDATE entity_token_storage SET expires_at = ?, updated_at = ? WHERE id = ?
"COMMIT"
DELETE FROM entity_token_storage WHERE ( perpetual !=1 ) AND expires_at < NOW();

#▲	Time	Info
1	20.75 ms	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.religion AS religion_61, t0.phone AS phone_62, t0.official_phone AS official_phone_63, t0.phone_with_country_code AS phone_with_country_code_64, t0.phone_country_code AS phone_country_code_65, t0.curr_addr_state AS curr_addr_state_66, t0.curr_addr_city AS curr_addr_city_67, t0.curr_addr_zip AS curr_addr_zip_68, t0.curr_addr AS curr_addr_69, t0.curr_addr_lat AS curr_addr_lat_70, t0.curr_addr_lng AS curr_addr_lng_71, t0.perm_addr AS perm_addr_72, t0.emm_contact AS emm_contact_73, t0.skill AS skill_74, t0.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_75, t0.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_76, t0.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_77, t0.preferred_country_ids_as_student AS preferred_country_ids_as_student_78, t0.joining_date AS joining_date_79, t0.emp_valid_till AS emp_valid_till_80, t0.emp_status AS emp_status_81, t0.emp_type AS emp_type_82, t0.emp_code AS emp_code_83, t0.emp_label AS emp_label_84, t0.tin AS tin_85, t0.tin_valid_till AS tin_valid_till_86, t0.med_ins AS med_ins_87, t0.med_ins_valid_till AS med_ins_valid_till_88, t0.docs AS docs_89, t0.inst1 AS inst1_90, t0.yr1 AS yr1_91, t0.dur1 AS dur1_92, t0.inst2 AS inst2_93, t0.yr2 AS yr2_94, t0.dur2 AS dur2_95, t0.inst3 AS inst3_96, t0.yr3 AS yr3_97, t0.dur3 AS dur3_98, t0.einst1 AS einst1_99, t0.eyr1 AS eyr1_100, t0.edeg1 AS edeg1_101, t0.einst2 AS einst2_102, t0.eyr2 AS eyr2_103, t0.edeg2 AS edeg2_104, t0.einst3 AS einst3_105, t0.eyr3 AS eyr3_106, t0.edeg3 AS edeg3_107, t0.tax_code AS tax_code_108, t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_109, t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_110, t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_111, t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_112, t0.allowed_earning_per_day AS allowed_earning_per_day_113, t0.allowed_earning_per_week AS allowed_earning_per_week_114, t0.allowed_earning_per_month AS allowed_earning_per_month_115, t0.allowed_earning_per_year AS allowed_earning_per_year_116, t0.revenue_percentage_per_session AS revenue_percentage_per_session_117, t0.transaction_acc_no AS transaction_acc_no_118, t0.transaction_acc_name AS transaction_acc_name_119, t0.bank_id AS bank_id_120, t0.bank_branch_code AS bank_branch_code_121, t0.bank_acc AS bank_acc_122, t0.bank_name AS bank_name_123, t0.bank_acc_name AS bank_acc_name_124, t0.bank_acc_type AS bank_acc_type_125, t0.bank_acc_valid_from AS bank_acc_valid_from_126, t0.bank_acc_valid_to AS bank_acc_valid_to_127, t0.routing_code AS routing_code_128, t0.swift_code AS swift_code_129, t0.mobile_wallet_no AS mobile_wallet_no_130, t0.mobile_wallet_type AS mobile_wallet_type_131, t0.ear1 AS ear1_132, t0.ear2 AS ear2_133, t0.ear3 AS ear3_134, t0.ear4 AS ear4_135, t0.ear5 AS ear5_136, t0.ear6 AS ear6_137, t0.eart AS eart_138, t0.ded1 AS ded1_139, t0.ded2 AS ded2_140, t0.ded3 AS ded3_141, t0.ded4 AS ded4_142, t0.dedt AS dedt_143, t0.payable AS payable_144, t0.hand_cash AS hand_cash_145, t0.bank_transfer AS bank_transfer_146, t0.sec_dep AS sec_dep_147, t0.sec_dep_span AS sec_dep_span_148, t0.sec_dep_rem_mon AS sec_dep_rem_mon_149, t0.sec_dep_rem_amount AS sec_dep_rem_amount_150, t0.sl_qty AS sl_qty_151, t0.sl_tkn AS sl_tkn_152, t0.sl_freq AS sl_freq_153, t0.ml_qty AS ml_qty_154, t0.ml_tkn AS ml_tkn_155, t0.ml_freq AS ml_freq_156, t0.el_qty AS el_qty_157, t0.el_tkn AS el_tkn_158, t0.el_freq AS el_freq_159, t0.cl_qty AS cl_qty_160, t0.cl_tkn AS cl_tkn_161, t0.cl_freq AS cl_freq_162, t0.levt AS levt_163, t0.weekly_holiday AS weekly_holiday_164, t0.files AS files_165, t0.supervisor AS supervisor_166, t0.dept AS dept_167, t0.desg AS desg_168, t0.branch AS branch_169, t0.division AS division_170, t0.application_text AS application_text_171, t0.current_employment AS current_employment_172, t0.emergency_contact_number AS emergency_contact_number_173, t0.postal_code AS postal_code_174, t0.country AS country_175, t0.education_data AS education_data_176, t0.work_experience_data AS work_experience_data_177, t0.certificate_data AS certificate_data_178, t0.languages_data AS languages_data_179, t0.important_comm_tags AS important_comm_tags_180, t0.is_consultant AS is_consultant_181, t0.is_featured AS is_featured_182, t0.featured_duration_end_ts AS featured_duration_end_ts_183, t0.is_moderator AS is_moderator_184, t0.is_admin AS is_admin_185, t0.admin_level AS admin_level_186, t0.is_retailer AS is_retailer_187, t0.retailer_level AS retailer_level_188, t0.is_student AS is_student_189, t0.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_190, t0.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_191, t0.online_status AS online_status_192, t0.assigned_sales_representative_id AS assigned_sales_representative_id_193, t0.lead_created_by_id AS lead_created_by_id_194, t0.is_temporary_entry AS is_temporary_entry_195, t0.lead_type AS lead_type_196, t0.lead_level AS lead_level_197, t0.immediate_follow_up_flag AS immediate_follow_up_flag_198, t0.pending_initial_communication AS pending_initial_communication_199, t0.last_online_ts AS last_online_ts_200, t0.courses_data AS courses_data_201, t0.video_link AS video_link_202, t0.account_balance AS account_balance_203, t0.session_count_balance AS session_count_balance_204, t0.total_session_used AS total_session_used_205, t0.total_consultancy_session_provided AS total_consultancy_session_provided_206, t0.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_207, t0.default_currency_id AS default_currency_id_208, t0.default_language_id AS default_language_id_209, t0.country_id AS country_id_210, t0.following_consultant_ids AS following_consultant_ids_211, t0.following_topic_ids AS following_topic_ids_212, t0.viewed_topic_ids AS viewed_topic_ids_213, t0.viewed_consultant_ids AS viewed_consultant_ids_214, t0.following_event_ids AS following_event_ids_215, t0.attending_event_ids AS attending_event_ids_216, t0.skip_event_ids AS skip_event_ids_217, t0.rating AS rating_218, t0.applicant_specific_note AS applicant_specific_note_219, t0.promo_discount_percentage AS promo_discount_percentage_220, t0.promo_discount_balance_count AS promo_discount_balance_count_221, t0.code_as_referer AS code_as_referer_222, t0.referred_code AS referred_code_223, t0.is_referred_code_used AS is_referred_code_used_224, t0.promo_code_id AS promo_code_id_225, t0.max_discount_allowed AS max_discount_allowed_226, t0.claimed_promo_code_ids AS claimed_promo_code_ids_227, t0.referred_coins_earned AS referred_coins_earned_228, t0.referred_amount_earned AS referred_amount_earned_229, t0.rating_weight AS rating_weight_230, t0.rating_total AS rating_total_231, t0.rating_count AS rating_count_232, t0.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_233, t0.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_234, t0.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_235, t0.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_236, t0.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_237, t0.selector AS selector_238, t0.apply_for_consultant AS apply_for_consultant_239, t0.apply_for_consultant_date AS apply_for_consultant_date_240, t0.consultant_application_feedback AS consultant_application_feedback_241, t0.apply_for_retailer AS apply_for_retailer_242, t0.apply_for_retailer_date AS apply_for_retailer_date_243, t0.doc_image AS doc_image_244, t0.document_list AS document_list_245, t0.document_list_by_topic_id AS document_list_by_topic_id_246, t0.document_list_by_session_id AS document_list_by_session_id_247, t0.work_experience_year AS work_experience_year_248, t0.description AS description_249, t0.summary_text AS summary_text_250, t0.professional_title AS professional_title_251, t0.work_experience_text AS work_experience_text_252, t0.profession_text AS profession_text_253, t0.education_text AS education_text_254, t0.education_major_text AS education_major_text_255, t0.highest_degree_achieved AS highest_degree_achieved_256, t0.target_education_degree AS target_education_degree_257, t0.target_education_major AS target_education_major_258, t0.lead_query_text AS lead_query_text_259, t0.university_text AS university_text_260, t0.experience_text AS experience_text_261, t0.skillstext AS skillstext_262, t0.interest AS interest_263, t0.speciality AS speciality_264, t0.last_settings_updated_ts AS last_settings_updated_ts_265, t0.created_at AS created_at_266, t0.actual_registration_at AS actual_registration_at_267, t0.updated_at AS updated_at_268 FROM entity_applicant_details t0 WHERE t0.username IS NULL LIMIT 1 Parameters: [] View formatted query View runnable query Explain query 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.religion AS religion_61, t0.phone AS phone_62, t0.official_phone AS official_phone_63, t0.phone_with_country_code AS phone_with_country_code_64, t0.phone_country_code AS phone_country_code_65, t0.curr_addr_state AS curr_addr_state_66, t0.curr_addr_city AS curr_addr_city_67, t0.curr_addr_zip AS curr_addr_zip_68, t0.curr_addr AS curr_addr_69, t0.curr_addr_lat AS curr_addr_lat_70, t0.curr_addr_lng AS curr_addr_lng_71, t0.perm_addr AS perm_addr_72, t0.emm_contact AS emm_contact_73, t0.skill AS skill_74, t0.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_75, t0.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_76, t0.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_77, t0.preferred_country_ids_as_student AS preferred_country_ids_as_student_78, t0.joining_date AS joining_date_79, t0.emp_valid_till AS emp_valid_till_80, t0.emp_status AS emp_status_81, t0.emp_type AS emp_type_82, t0.emp_code AS emp_code_83, t0.emp_label AS emp_label_84, t0.tin AS tin_85, t0.tin_valid_till AS tin_valid_till_86, t0.med_ins AS med_ins_87, t0.med_ins_valid_till AS med_ins_valid_till_88, t0.docs AS docs_89, t0.inst1 AS inst1_90, t0.yr1 AS yr1_91, t0.dur1 AS dur1_92, t0.inst2 AS inst2_93, t0.yr2 AS yr2_94, t0.dur2 AS dur2_95, t0.inst3 AS inst3_96, t0.yr3 AS yr3_97, t0.dur3 AS dur3_98, t0.einst1 AS einst1_99, t0.eyr1 AS eyr1_100, t0.edeg1 AS edeg1_101, t0.einst2 AS einst2_102, t0.eyr2 AS eyr2_103, t0.edeg2 AS edeg2_104, t0.einst3 AS einst3_105, t0.eyr3 AS eyr3_106, t0.edeg3 AS edeg3_107, t0.tax_code AS tax_code_108, t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_109, t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_110, t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_111, t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_112, t0.allowed_earning_per_day AS allowed_earning_per_day_113, t0.allowed_earning_per_week AS allowed_earning_per_week_114, t0.allowed_earning_per_month AS allowed_earning_per_month_115, t0.allowed_earning_per_year AS allowed_earning_per_year_116, t0.revenue_percentage_per_session AS revenue_percentage_per_session_117, t0.transaction_acc_no AS transaction_acc_no_118, t0.transaction_acc_name AS transaction_acc_name_119, t0.bank_id AS bank_id_120, t0.bank_branch_code AS bank_branch_code_121, t0.bank_acc AS bank_acc_122, t0.bank_name AS bank_name_123, t0.bank_acc_name AS bank_acc_name_124, t0.bank_acc_type AS bank_acc_type_125, t0.bank_acc_valid_from AS bank_acc_valid_from_126, t0.bank_acc_valid_to AS bank_acc_valid_to_127, t0.routing_code AS routing_code_128, t0.swift_code AS swift_code_129, t0.mobile_wallet_no AS mobile_wallet_no_130, t0.mobile_wallet_type AS mobile_wallet_type_131, t0.ear1 AS ear1_132, t0.ear2 AS ear2_133, t0.ear3 AS ear3_134, t0.ear4 AS ear4_135, t0.ear5 AS ear5_136, t0.ear6 AS ear6_137, t0.eart AS eart_138, t0.ded1 AS ded1_139, t0.ded2 AS ded2_140, t0.ded3 AS ded3_141, t0.ded4 AS ded4_142, t0.dedt AS dedt_143, t0.payable AS payable_144, t0.hand_cash AS hand_cash_145, t0.bank_transfer AS bank_transfer_146, t0.sec_dep AS sec_dep_147, t0.sec_dep_span AS sec_dep_span_148, t0.sec_dep_rem_mon AS sec_dep_rem_mon_149, t0.sec_dep_rem_amount AS sec_dep_rem_amount_150, t0.sl_qty AS sl_qty_151, t0.sl_tkn AS sl_tkn_152, t0.sl_freq AS sl_freq_153, t0.ml_qty AS ml_qty_154, t0.ml_tkn AS ml_tkn_155, t0.ml_freq AS ml_freq_156, t0.el_qty AS el_qty_157, t0.el_tkn AS el_tkn_158, t0.el_freq AS el_freq_159, t0.cl_qty AS cl_qty_160, t0.cl_tkn AS cl_tkn_161, t0.cl_freq AS cl_freq_162, t0.levt AS levt_163, t0.weekly_holiday AS weekly_holiday_164, t0.files AS files_165, t0.supervisor AS supervisor_166, t0.dept AS dept_167, t0.desg AS desg_168, t0.branch AS branch_169, t0.division AS division_170, t0.application_text AS application_text_171, t0.current_employment AS current_employment_172, t0.emergency_contact_number AS emergency_contact_number_173, t0.postal_code AS postal_code_174, t0.country AS country_175, t0.education_data AS education_data_176, t0.work_experience_data AS work_experience_data_177, t0.certificate_data AS certificate_data_178, t0.languages_data AS languages_data_179, t0.important_comm_tags AS important_comm_tags_180, t0.is_consultant AS is_consultant_181, t0.is_featured AS is_featured_182, t0.featured_duration_end_ts AS featured_duration_end_ts_183, t0.is_moderator AS is_moderator_184, t0.is_admin AS is_admin_185, t0.admin_level AS admin_level_186, t0.is_retailer AS is_retailer_187, t0.retailer_level AS retailer_level_188, t0.is_student AS is_student_189, t0.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_190, t0.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_191, t0.online_status AS online_status_192, t0.assigned_sales_representative_id AS assigned_sales_representative_id_193, t0.lead_created_by_id AS lead_created_by_id_194, t0.is_temporary_entry AS is_temporary_entry_195, t0.lead_type AS lead_type_196, t0.lead_level AS lead_level_197, t0.immediate_follow_up_flag AS immediate_follow_up_flag_198, t0.pending_initial_communication AS pending_initial_communication_199, t0.last_online_ts AS last_online_ts_200, t0.courses_data AS courses_data_201, t0.video_link AS video_link_202, t0.account_balance AS account_balance_203, t0.session_count_balance AS session_count_balance_204, t0.total_session_used AS total_session_used_205, t0.total_consultancy_session_provided AS total_consultancy_session_provided_206, t0.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_207, t0.default_currency_id AS default_currency_id_208, t0.default_language_id AS default_language_id_209, t0.country_id AS country_id_210, t0.following_consultant_ids AS following_consultant_ids_211, t0.following_topic_ids AS following_topic_ids_212, t0.viewed_topic_ids AS viewed_topic_ids_213, t0.viewed_consultant_ids AS viewed_consultant_ids_214, t0.following_event_ids AS following_event_ids_215, t0.attending_event_ids AS attending_event_ids_216, t0.skip_event_ids AS skip_event_ids_217, t0.rating AS rating_218, t0.applicant_specific_note AS applicant_specific_note_219, t0.promo_discount_percentage AS promo_discount_percentage_220, t0.promo_discount_balance_count AS promo_discount_balance_count_221, t0.code_as_referer AS code_as_referer_222, t0.referred_code AS referred_code_223, t0.is_referred_code_used AS is_referred_code_used_224, t0.promo_code_id AS promo_code_id_225, t0.max_discount_allowed AS max_discount_allowed_226, t0.claimed_promo_code_ids AS claimed_promo_code_ids_227, t0.referred_coins_earned AS referred_coins_earned_228, t0.referred_amount_earned AS referred_amount_earned_229, t0.rating_weight AS rating_weight_230, t0.rating_total AS rating_total_231, t0.rating_count AS rating_count_232, t0.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_233, t0.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_234, t0.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_235, t0.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_236, t0.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_237, t0.selector AS selector_238, t0.apply_for_consultant AS apply_for_consultant_239, t0.apply_for_consultant_date AS apply_for_consultant_date_240, t0.consultant_application_feedback AS consultant_application_feedback_241, t0.apply_for_retailer AS apply_for_retailer_242, t0.apply_for_retailer_date AS apply_for_retailer_date_243, t0.doc_image AS doc_image_244, t0.document_list AS document_list_245, t0.document_list_by_topic_id AS document_list_by_topic_id_246, t0.document_list_by_session_id AS document_list_by_session_id_247, t0.work_experience_year AS work_experience_year_248, t0.description AS description_249, t0.summary_text AS summary_text_250, t0.professional_title AS professional_title_251, t0.work_experience_text AS work_experience_text_252, t0.profession_text AS profession_text_253, t0.education_text AS education_text_254, t0.education_major_text AS education_major_text_255, t0.highest_degree_achieved AS highest_degree_achieved_256, t0.target_education_degree AS target_education_degree_257, t0.target_education_major AS target_education_major_258, t0.lead_query_text AS lead_query_text_259, t0.university_text AS university_text_260, t0.experience_text AS experience_text_261, t0.skillstext AS skillstext_262, t0.interest AS interest_263, t0.speciality AS speciality_264, t0.last_settings_updated_ts AS last_settings_updated_ts_265, t0.created_at AS created_at_266, t0.actual_registration_at AS actual_registration_at_267, t0.updated_at AS updated_at_268 FROM entity_applicant_details t0 WHERE t0.username IS NULL 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.religion AS religion_61, t0.phone AS phone_62, t0.official_phone AS official_phone_63, t0.phone_with_country_code AS phone_with_country_code_64, t0.phone_country_code AS phone_country_code_65, t0.curr_addr_state AS curr_addr_state_66, t0.curr_addr_city AS curr_addr_city_67, t0.curr_addr_zip AS curr_addr_zip_68, t0.curr_addr AS curr_addr_69, t0.curr_addr_lat AS curr_addr_lat_70, t0.curr_addr_lng AS curr_addr_lng_71, t0.perm_addr AS perm_addr_72, t0.emm_contact AS emm_contact_73, t0.skill AS skill_74, t0.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_75, t0.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_76, t0.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_77, t0.preferred_country_ids_as_student AS preferred_country_ids_as_student_78, t0.joining_date AS joining_date_79, t0.emp_valid_till AS emp_valid_till_80, t0.emp_status AS emp_status_81, t0.emp_type AS emp_type_82, t0.emp_code AS emp_code_83, t0.emp_label AS emp_label_84, t0.tin AS tin_85, t0.tin_valid_till AS tin_valid_till_86, t0.med_ins AS med_ins_87, t0.med_ins_valid_till AS med_ins_valid_till_88, t0.docs AS docs_89, t0.inst1 AS inst1_90, t0.yr1 AS yr1_91, t0.dur1 AS dur1_92, t0.inst2 AS inst2_93, t0.yr2 AS yr2_94, t0.dur2 AS dur2_95, t0.inst3 AS inst3_96, t0.yr3 AS yr3_97, t0.dur3 AS dur3_98, t0.einst1 AS einst1_99, t0.eyr1 AS eyr1_100, t0.edeg1 AS edeg1_101, t0.einst2 AS einst2_102, t0.eyr2 AS eyr2_103, t0.edeg2 AS edeg2_104, t0.einst3 AS einst3_105, t0.eyr3 AS eyr3_106, t0.edeg3 AS edeg3_107, t0.tax_code AS tax_code_108, t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_109, t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_110, t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_111, t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_112, t0.allowed_earning_per_day AS allowed_earning_per_day_113, t0.allowed_earning_per_week AS allowed_earning_per_week_114, t0.allowed_earning_per_month AS allowed_earning_per_month_115, t0.allowed_earning_per_year AS allowed_earning_per_year_116, t0.revenue_percentage_per_session AS revenue_percentage_per_session_117, t0.transaction_acc_no AS transaction_acc_no_118, t0.transaction_acc_name AS transaction_acc_name_119, t0.bank_id AS bank_id_120, t0.bank_branch_code AS bank_branch_code_121, t0.bank_acc AS bank_acc_122, t0.bank_name AS bank_name_123, t0.bank_acc_name AS bank_acc_name_124, t0.bank_acc_type AS bank_acc_type_125, t0.bank_acc_valid_from AS bank_acc_valid_from_126, t0.bank_acc_valid_to AS bank_acc_valid_to_127, t0.routing_code AS routing_code_128, t0.swift_code AS swift_code_129, t0.mobile_wallet_no AS mobile_wallet_no_130, t0.mobile_wallet_type AS mobile_wallet_type_131, t0.ear1 AS ear1_132, t0.ear2 AS ear2_133, t0.ear3 AS ear3_134, t0.ear4 AS ear4_135, t0.ear5 AS ear5_136, t0.ear6 AS ear6_137, t0.eart AS eart_138, t0.ded1 AS ded1_139, t0.ded2 AS ded2_140, t0.ded3 AS ded3_141, t0.ded4 AS ded4_142, t0.dedt AS dedt_143, t0.payable AS payable_144, t0.hand_cash AS hand_cash_145, t0.bank_transfer AS bank_transfer_146, t0.sec_dep AS sec_dep_147, t0.sec_dep_span AS sec_dep_span_148, t0.sec_dep_rem_mon AS sec_dep_rem_mon_149, t0.sec_dep_rem_amount AS sec_dep_rem_amount_150, t0.sl_qty AS sl_qty_151, t0.sl_tkn AS sl_tkn_152, t0.sl_freq AS sl_freq_153, t0.ml_qty AS ml_qty_154, t0.ml_tkn AS ml_tkn_155, t0.ml_freq AS ml_freq_156, t0.el_qty AS el_qty_157, t0.el_tkn AS el_tkn_158, t0.el_freq AS el_freq_159, t0.cl_qty AS cl_qty_160, t0.cl_tkn AS cl_tkn_161, t0.cl_freq AS cl_freq_162, t0.levt AS levt_163, t0.weekly_holiday AS weekly_holiday_164, t0.files AS files_165, t0.supervisor AS supervisor_166, t0.dept AS dept_167, t0.desg AS desg_168, t0.branch AS branch_169, t0.division AS division_170, t0.application_text AS application_text_171, t0.current_employment AS current_employment_172, t0.emergency_contact_number AS emergency_contact_number_173, t0.postal_code AS postal_code_174, t0.country AS country_175, t0.education_data AS education_data_176, t0.work_experience_data AS work_experience_data_177, t0.certificate_data AS certificate_data_178, t0.languages_data AS languages_data_179, t0.important_comm_tags AS important_comm_tags_180, t0.is_consultant AS is_consultant_181, t0.is_featured AS is_featured_182, t0.featured_duration_end_ts AS featured_duration_end_ts_183, t0.is_moderator AS is_moderator_184, t0.is_admin AS is_admin_185, t0.admin_level AS admin_level_186, t0.is_retailer AS is_retailer_187, t0.retailer_level AS retailer_level_188, t0.is_student AS is_student_189, t0.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_190, t0.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_191, t0.online_status AS online_status_192, t0.assigned_sales_representative_id AS assigned_sales_representative_id_193, t0.lead_created_by_id AS lead_created_by_id_194, t0.is_temporary_entry AS is_temporary_entry_195, t0.lead_type AS lead_type_196, t0.lead_level AS lead_level_197, t0.immediate_follow_up_flag AS immediate_follow_up_flag_198, t0.pending_initial_communication AS pending_initial_communication_199, t0.last_online_ts AS last_online_ts_200, t0.courses_data AS courses_data_201, t0.video_link AS video_link_202, t0.account_balance AS account_balance_203, t0.session_count_balance AS session_count_balance_204, t0.total_session_used AS total_session_used_205, t0.total_consultancy_session_provided AS total_consultancy_session_provided_206, t0.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_207, t0.default_currency_id AS default_currency_id_208, t0.default_language_id AS default_language_id_209, t0.country_id AS country_id_210, t0.following_consultant_ids AS following_consultant_ids_211, t0.following_topic_ids AS following_topic_ids_212, t0.viewed_topic_ids AS viewed_topic_ids_213, t0.viewed_consultant_ids AS viewed_consultant_ids_214, t0.following_event_ids AS following_event_ids_215, t0.attending_event_ids AS attending_event_ids_216, t0.skip_event_ids AS skip_event_ids_217, t0.rating AS rating_218, t0.applicant_specific_note AS applicant_specific_note_219, t0.promo_discount_percentage AS promo_discount_percentage_220, t0.promo_discount_balance_count AS promo_discount_balance_count_221, t0.code_as_referer AS code_as_referer_222, t0.referred_code AS referred_code_223, t0.is_referred_code_used AS is_referred_code_used_224, t0.promo_code_id AS promo_code_id_225, t0.max_discount_allowed AS max_discount_allowed_226, t0.claimed_promo_code_ids AS claimed_promo_code_ids_227, t0.referred_coins_earned AS referred_coins_earned_228, t0.referred_amount_earned AS referred_amount_earned_229, t0.rating_weight AS rating_weight_230, t0.rating_total AS rating_total_231, t0.rating_count AS rating_count_232, t0.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_233, t0.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_234, t0.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_235, t0.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_236, t0.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_237, t0.selector AS selector_238, t0.apply_for_consultant AS apply_for_consultant_239, t0.apply_for_consultant_date AS apply_for_consultant_date_240, t0.consultant_application_feedback AS consultant_application_feedback_241, t0.apply_for_retailer AS apply_for_retailer_242, t0.apply_for_retailer_date AS apply_for_retailer_date_243, t0.doc_image AS doc_image_244, t0.document_list AS document_list_245, t0.document_list_by_topic_id AS document_list_by_topic_id_246, t0.document_list_by_session_id AS document_list_by_session_id_247, t0.work_experience_year AS work_experience_year_248, t0.description AS description_249, t0.summary_text AS summary_text_250, t0.professional_title AS professional_title_251, t0.work_experience_text AS work_experience_text_252, t0.profession_text AS profession_text_253, t0.education_text AS education_text_254, t0.education_major_text AS education_major_text_255, t0.highest_degree_achieved AS highest_degree_achieved_256, t0.target_education_degree AS target_education_degree_257, t0.target_education_major AS target_education_major_258, t0.lead_query_text AS lead_query_text_259, t0.university_text AS university_text_260, t0.experience_text AS experience_text_261, t0.skillstext AS skillstext_262, t0.interest AS interest_263, t0.speciality AS speciality_264, t0.last_settings_updated_ts AS last_settings_updated_ts_265, t0.created_at AS created_at_266, t0.actual_registration_at AS actual_registration_at_267, t0.updated_at AS updated_at_268 FROM entity_applicant_details t0 WHERE t0.username IS NULL LIMIT 1;
2	3.31 ms	SELECT t0.id AS id_1, t0.sync_flag AS sync_flag_2, t0.name AS name_3, t0.image AS image_4, t0.app_id AS app_id_5, t0.owner_id AS owner_id_6, t0.stripe_customer_id AS stripe_customer_id_7, t0.manage_user_ids AS manage_user_ids_8, t0.post_dated_job_active AS post_dated_job_active_9, t0.address AS address_10, t0.shipping_address AS shipping_address_11, t0.billing_address AS billing_address_12, t0.motto AS motto_13, t0.invoice_footer AS invoice_footer_14, t0.general_footer AS general_footer_15, t0.company_allowed AS company_allowed_16, t0.company_allocated AS company_allocated_17, t0.country_id AS country_id_18, t0.locale AS locale_19, t0.company_remaining AS company_remaining_20, t0.user_allowed AS user_allowed_21, t0.user_allocated AS user_allocated_22, t0.user_remaining AS user_remaining_23, t0.admin_user_allowed AS admin_user_allowed_24, t0.admin_user_allocated AS admin_user_allocated_25, t0.admin_user_remaining AS admin_user_remaining_26, t0.contact_number AS contact_number_27, t0.email AS email_28, t0.db_name AS db_name_29, t0.db_pass AS db_pass_30, t0.db_user AS db_user_31, t0.db_host AS db_host_32, t0.company_group_hash AS company_group_hash_33, t0.company_group_unique_code AS company_group_unique_code_34, t0.enabled_module_id_list AS enabled_module_id_list_35, t0.company_group_server_id AS company_group_server_id_36, t0.company_group_server_hash AS company_group_server_hash_37, t0.company_group_server_address AS company_group_server_address_38, t0.company_group_server_port AS company_group_server_port_39, t0.company_bin AS company_bin_40, t0.company_tin AS company_tin_41, t0.company_reg AS company_reg_42, t0.company_tl AS company_tl_43, t0.initiate_flag AS initiate_flag_44, t0.current_server_id AS current_server_id_45, t0.current_server_hash AS current_server_hash_46, t0.current_server_address AS current_server_address_47, t0.current_server_port AS current_server_port_48, t0.usage_valid_upto_date AS usage_valid_upto_date_49, t0.usage_valid_upto_date_ts AS usage_valid_upto_date_ts_50, t0.company_group_server_domain_full_link AS company_group_server_domain_full_link_51, t0.current_server_domain_full_link AS current_server_domain_full_link_52, t0.company_group_billing_info AS company_group_billing_info_53, t0.company_group_next_bill_date AS company_group_next_bill_date_54, t0.company_group_next_bill_date_ts AS company_group_next_bill_date_ts_55, t0.company_group_billing_frequency AS company_group_billing_frequency_56, t0.cash AS cash_57, t0.sales AS sales_58, t0.expense AS expense_59, t0.payable AS payable_60, t0.net_worth AS net_worth_61, t0.monthly_growth AS monthly_growth_62, t0.active AS active_63, t0.read_only_mode AS read_only_mode_64, t0.company_status AS company_status_65, t0.package_type AS package_type_66, t0.subscription_expiry AS subscription_expiry_67, t0.last_activity_at AS last_activity_at_68, t0.current_subscription_package_id AS current_subscription_package_id_69, t0.subscription_month AS subscription_month_70, t0.billing_amount AS billing_amount_71, t0.subscription_details AS subscription_details_72, t0.company_type AS company_type_73, t0.company_description AS company_description_74, t0.skip_in_web_flag AS skip_in_web_flag_75, t0.skip_in_app_flag AS skip_in_app_flag_76, t0.schema_update_pending_flag AS schema_update_pending_flag_77, t0.created_at AS created_at_78, t0.updated_at AS updated_at_79 FROM company_group t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.sync_flag AS sync_flag_2, t0.name AS name_3, t0.image AS image_4, t0.app_id AS app_id_5, t0.owner_id AS owner_id_6, t0.stripe_customer_id AS stripe_customer_id_7, t0.manage_user_ids AS manage_user_ids_8, t0.post_dated_job_active AS post_dated_job_active_9, t0.address AS address_10, t0.shipping_address AS shipping_address_11, t0.billing_address AS billing_address_12, t0.motto AS motto_13, t0.invoice_footer AS invoice_footer_14, t0.general_footer AS general_footer_15, t0.company_allowed AS company_allowed_16, t0.company_allocated AS company_allocated_17, t0.country_id AS country_id_18, t0.locale AS locale_19, t0.company_remaining AS company_remaining_20, t0.user_allowed AS user_allowed_21, t0.user_allocated AS user_allocated_22, t0.user_remaining AS user_remaining_23, t0.admin_user_allowed AS admin_user_allowed_24, t0.admin_user_allocated AS admin_user_allocated_25, t0.admin_user_remaining AS admin_user_remaining_26, t0.contact_number AS contact_number_27, t0.email AS email_28, t0.db_name AS db_name_29, t0.db_pass AS db_pass_30, t0.db_user AS db_user_31, t0.db_host AS db_host_32, t0.company_group_hash AS company_group_hash_33, t0.company_group_unique_code AS company_group_unique_code_34, t0.enabled_module_id_list AS enabled_module_id_list_35, t0.company_group_server_id AS company_group_server_id_36, t0.company_group_server_hash AS company_group_server_hash_37, t0.company_group_server_address AS company_group_server_address_38, t0.company_group_server_port AS company_group_server_port_39, t0.company_bin AS company_bin_40, t0.company_tin AS company_tin_41, t0.company_reg AS company_reg_42, t0.company_tl AS company_tl_43, t0.initiate_flag AS initiate_flag_44, t0.current_server_id AS current_server_id_45, t0.current_server_hash AS current_server_hash_46, t0.current_server_address AS current_server_address_47, t0.current_server_port AS current_server_port_48, t0.usage_valid_upto_date AS usage_valid_upto_date_49, t0.usage_valid_upto_date_ts AS usage_valid_upto_date_ts_50, t0.company_group_server_domain_full_link AS company_group_server_domain_full_link_51, t0.current_server_domain_full_link AS current_server_domain_full_link_52, t0.company_group_billing_info AS company_group_billing_info_53, t0.company_group_next_bill_date AS company_group_next_bill_date_54, t0.company_group_next_bill_date_ts AS company_group_next_bill_date_ts_55, t0.company_group_billing_frequency AS company_group_billing_frequency_56, t0.cash AS cash_57, t0.sales AS sales_58, t0.expense AS expense_59, t0.payable AS payable_60, t0.net_worth AS net_worth_61, t0.monthly_growth AS monthly_growth_62, t0.active AS active_63, t0.read_only_mode AS read_only_mode_64, t0.company_status AS company_status_65, t0.package_type AS package_type_66, t0.subscription_expiry AS subscription_expiry_67, t0.last_activity_at AS last_activity_at_68, t0.current_subscription_package_id AS current_subscription_package_id_69, t0.subscription_month AS subscription_month_70, t0.billing_amount AS billing_amount_71, t0.subscription_details AS subscription_details_72, t0.company_type AS company_type_73, t0.company_description AS company_description_74, t0.skip_in_web_flag AS skip_in_web_flag_75, t0.skip_in_app_flag AS skip_in_app_flag_76, t0.schema_update_pending_flag AS schema_update_pending_flag_77, t0.created_at AS created_at_78, t0.updated_at AS updated_at_79 FROM company_group t0 SELECT t0.id AS id_1, t0.sync_flag AS sync_flag_2, t0.name AS name_3, t0.image AS image_4, t0.app_id AS app_id_5, t0.owner_id AS owner_id_6, t0.stripe_customer_id AS stripe_customer_id_7, t0.manage_user_ids AS manage_user_ids_8, t0.post_dated_job_active AS post_dated_job_active_9, t0.address AS address_10, t0.shipping_address AS shipping_address_11, t0.billing_address AS billing_address_12, t0.motto AS motto_13, t0.invoice_footer AS invoice_footer_14, t0.general_footer AS general_footer_15, t0.company_allowed AS company_allowed_16, t0.company_allocated AS company_allocated_17, t0.country_id AS country_id_18, t0.locale AS locale_19, t0.company_remaining AS company_remaining_20, t0.user_allowed AS user_allowed_21, t0.user_allocated AS user_allocated_22, t0.user_remaining AS user_remaining_23, t0.admin_user_allowed AS admin_user_allowed_24, t0.admin_user_allocated AS admin_user_allocated_25, t0.admin_user_remaining AS admin_user_remaining_26, t0.contact_number AS contact_number_27, t0.email AS email_28, t0.db_name AS db_name_29, t0.db_pass AS db_pass_30, t0.db_user AS db_user_31, t0.db_host AS db_host_32, t0.company_group_hash AS company_group_hash_33, t0.company_group_unique_code AS company_group_unique_code_34, t0.enabled_module_id_list AS enabled_module_id_list_35, t0.company_group_server_id AS company_group_server_id_36, t0.company_group_server_hash AS company_group_server_hash_37, t0.company_group_server_address AS company_group_server_address_38, t0.company_group_server_port AS company_group_server_port_39, t0.company_bin AS company_bin_40, t0.company_tin AS company_tin_41, t0.company_reg AS company_reg_42, t0.company_tl AS company_tl_43, t0.initiate_flag AS initiate_flag_44, t0.current_server_id AS current_server_id_45, t0.current_server_hash AS current_server_hash_46, t0.current_server_address AS current_server_address_47, t0.current_server_port AS current_server_port_48, t0.usage_valid_upto_date AS usage_valid_upto_date_49, t0.usage_valid_upto_date_ts AS usage_valid_upto_date_ts_50, t0.company_group_server_domain_full_link AS company_group_server_domain_full_link_51, t0.current_server_domain_full_link AS current_server_domain_full_link_52, t0.company_group_billing_info AS company_group_billing_info_53, t0.company_group_next_bill_date AS company_group_next_bill_date_54, t0.company_group_next_bill_date_ts AS company_group_next_bill_date_ts_55, t0.company_group_billing_frequency AS company_group_billing_frequency_56, t0.cash AS cash_57, t0.sales AS sales_58, t0.expense AS expense_59, t0.payable AS payable_60, t0.net_worth AS net_worth_61, t0.monthly_growth AS monthly_growth_62, t0.active AS active_63, t0.read_only_mode AS read_only_mode_64, t0.company_status AS company_status_65, t0.package_type AS package_type_66, t0.subscription_expiry AS subscription_expiry_67, t0.last_activity_at AS last_activity_at_68, t0.current_subscription_package_id AS current_subscription_package_id_69, t0.subscription_month AS subscription_month_70, t0.billing_amount AS billing_amount_71, t0.subscription_details AS subscription_details_72, t0.company_type AS company_type_73, t0.company_description AS company_description_74, t0.skip_in_web_flag AS skip_in_web_flag_75, t0.skip_in_app_flag AS skip_in_app_flag_76, t0.schema_update_pending_flag AS schema_update_pending_flag_77, t0.created_at AS created_at_78, t0.updated_at AS updated_at_79 FROM company_group t0;
3	39.37 ms	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_.religion AS religion_60, e0_.phone AS phone_61, e0_.official_phone AS official_phone_62, e0_.phone_with_country_code AS phone_with_country_code_63, e0_.phone_country_code AS phone_country_code_64, e0_.curr_addr_state AS curr_addr_state_65, e0_.curr_addr_city AS curr_addr_city_66, e0_.curr_addr_zip AS curr_addr_zip_67, e0_.curr_addr AS curr_addr_68, e0_.curr_addr_lat AS curr_addr_lat_69, e0_.curr_addr_lng AS curr_addr_lng_70, e0_.perm_addr AS perm_addr_71, e0_.emm_contact AS emm_contact_72, e0_.skill AS skill_73, e0_.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_74, e0_.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_75, e0_.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_76, e0_.preferred_country_ids_as_student AS preferred_country_ids_as_student_77, e0_.joining_date AS joining_date_78, e0_.emp_valid_till AS emp_valid_till_79, e0_.emp_status AS emp_status_80, e0_.emp_type AS emp_type_81, e0_.emp_code AS emp_code_82, e0_.emp_label AS emp_label_83, e0_.tin AS tin_84, e0_.tin_valid_till AS tin_valid_till_85, e0_.med_ins AS med_ins_86, e0_.med_ins_valid_till AS med_ins_valid_till_87, e0_.docs AS docs_88, e0_.inst1 AS inst1_89, e0_.yr1 AS yr1_90, e0_.dur1 AS dur1_91, e0_.inst2 AS inst2_92, e0_.yr2 AS yr2_93, e0_.dur2 AS dur2_94, e0_.inst3 AS inst3_95, e0_.yr3 AS yr3_96, e0_.dur3 AS dur3_97, e0_.einst1 AS einst1_98, e0_.eyr1 AS eyr1_99, e0_.edeg1 AS edeg1_100, e0_.einst2 AS einst2_101, e0_.eyr2 AS eyr2_102, e0_.edeg2 AS edeg2_103, e0_.einst3 AS einst3_104, e0_.eyr3 AS eyr3_105, e0_.edeg3 AS edeg3_106, e0_.tax_code AS tax_code_107, e0_.allowed_working_hours_per_day AS allowed_working_hours_per_day_108, e0_.allowed_working_hours_per_week AS allowed_working_hours_per_week_109, e0_.allowed_working_hours_per_month AS allowed_working_hours_per_month_110, e0_.allowed_working_hours_per_year AS allowed_working_hours_per_year_111, e0_.allowed_earning_per_day AS allowed_earning_per_day_112, e0_.allowed_earning_per_week AS allowed_earning_per_week_113, e0_.allowed_earning_per_month AS allowed_earning_per_month_114, e0_.allowed_earning_per_year AS allowed_earning_per_year_115, e0_.revenue_percentage_per_session AS revenue_percentage_per_session_116, e0_.transaction_acc_no AS transaction_acc_no_117, e0_.transaction_acc_name AS transaction_acc_name_118, e0_.bank_id AS bank_id_119, e0_.bank_branch_code AS bank_branch_code_120, e0_.bank_acc AS bank_acc_121, e0_.bank_name AS bank_name_122, e0_.bank_acc_name AS bank_acc_name_123, e0_.bank_acc_type AS bank_acc_type_124, e0_.bank_acc_valid_from AS bank_acc_valid_from_125, e0_.bank_acc_valid_to AS bank_acc_valid_to_126, e0_.routing_code AS routing_code_127, e0_.swift_code AS swift_code_128, e0_.mobile_wallet_no AS mobile_wallet_no_129, e0_.mobile_wallet_type AS mobile_wallet_type_130, e0_.ear1 AS ear1_131, e0_.ear2 AS ear2_132, e0_.ear3 AS ear3_133, e0_.ear4 AS ear4_134, e0_.ear5 AS ear5_135, e0_.ear6 AS ear6_136, e0_.eart AS eart_137, e0_.ded1 AS ded1_138, e0_.ded2 AS ded2_139, e0_.ded3 AS ded3_140, e0_.ded4 AS ded4_141, e0_.dedt AS dedt_142, e0_.payable AS payable_143, e0_.hand_cash AS hand_cash_144, e0_.bank_transfer AS bank_transfer_145, e0_.sec_dep AS sec_dep_146, e0_.sec_dep_span AS sec_dep_span_147, e0_.sec_dep_rem_mon AS sec_dep_rem_mon_148, e0_.sec_dep_rem_amount AS sec_dep_rem_amount_149, e0_.sl_qty AS sl_qty_150, e0_.sl_tkn AS sl_tkn_151, e0_.sl_freq AS sl_freq_152, e0_.ml_qty AS ml_qty_153, e0_.ml_tkn AS ml_tkn_154, e0_.ml_freq AS ml_freq_155, e0_.el_qty AS el_qty_156, e0_.el_tkn AS el_tkn_157, e0_.el_freq AS el_freq_158, e0_.cl_qty AS cl_qty_159, e0_.cl_tkn AS cl_tkn_160, e0_.cl_freq AS cl_freq_161, e0_.levt AS levt_162, e0_.weekly_holiday AS weekly_holiday_163, e0_.files AS files_164, e0_.supervisor AS supervisor_165, e0_.dept AS dept_166, e0_.desg AS desg_167, e0_.branch AS branch_168, e0_.division AS division_169, e0_.application_text AS application_text_170, e0_.current_employment AS current_employment_171, e0_.emergency_contact_number AS emergency_contact_number_172, e0_.postal_code AS postal_code_173, e0_.country AS country_174, e0_.education_data AS education_data_175, e0_.work_experience_data AS work_experience_data_176, e0_.certificate_data AS certificate_data_177, e0_.languages_data AS languages_data_178, e0_.important_comm_tags AS important_comm_tags_179, e0_.is_consultant AS is_consultant_180, e0_.is_featured AS is_featured_181, e0_.featured_duration_end_ts AS featured_duration_end_ts_182, e0_.is_moderator AS is_moderator_183, e0_.is_admin AS is_admin_184, e0_.admin_level AS admin_level_185, e0_.is_retailer AS is_retailer_186, e0_.retailer_level AS retailer_level_187, e0_.is_student AS is_student_188, e0_.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_189, e0_.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_190, e0_.online_status AS online_status_191, e0_.assigned_sales_representative_id AS assigned_sales_representative_id_192, e0_.lead_created_by_id AS lead_created_by_id_193, e0_.is_temporary_entry AS is_temporary_entry_194, e0_.lead_type AS lead_type_195, e0_.lead_level AS lead_level_196, e0_.immediate_follow_up_flag AS immediate_follow_up_flag_197, e0_.pending_initial_communication AS pending_initial_communication_198, e0_.last_online_ts AS last_online_ts_199, e0_.courses_data AS courses_data_200, e0_.video_link AS video_link_201, e0_.account_balance AS account_balance_202, e0_.session_count_balance AS session_count_balance_203, e0_.total_session_used AS total_session_used_204, e0_.total_consultancy_session_provided AS total_consultancy_session_provided_205, e0_.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_206, e0_.default_currency_id AS default_currency_id_207, e0_.default_language_id AS default_language_id_208, e0_.country_id AS country_id_209, e0_.following_consultant_ids AS following_consultant_ids_210, e0_.following_topic_ids AS following_topic_ids_211, e0_.viewed_topic_ids AS viewed_topic_ids_212, e0_.viewed_consultant_ids AS viewed_consultant_ids_213, e0_.following_event_ids AS following_event_ids_214, e0_.attending_event_ids AS attending_event_ids_215, e0_.skip_event_ids AS skip_event_ids_216, e0_.rating AS rating_217, e0_.applicant_specific_note AS applicant_specific_note_218, e0_.promo_discount_percentage AS promo_discount_percentage_219, e0_.promo_discount_balance_count AS promo_discount_balance_count_220, e0_.code_as_referer AS code_as_referer_221, e0_.referred_code AS referred_code_222, e0_.is_referred_code_used AS is_referred_code_used_223, e0_.promo_code_id AS promo_code_id_224, e0_.max_discount_allowed AS max_discount_allowed_225, e0_.claimed_promo_code_ids AS claimed_promo_code_ids_226, e0_.referred_coins_earned AS referred_coins_earned_227, e0_.referred_amount_earned AS referred_amount_earned_228, e0_.rating_weight AS rating_weight_229, e0_.rating_total AS rating_total_230, e0_.rating_count AS rating_count_231, e0_.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_232, e0_.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_233, e0_.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_234, e0_.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_235, e0_.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_236, e0_.selector AS selector_237, e0_.apply_for_consultant AS apply_for_consultant_238, e0_.apply_for_consultant_date AS apply_for_consultant_date_239, e0_.consultant_application_feedback AS consultant_application_feedback_240, e0_.apply_for_retailer AS apply_for_retailer_241, e0_.apply_for_retailer_date AS apply_for_retailer_date_242, e0_.doc_image AS doc_image_243, e0_.document_list AS document_list_244, e0_.document_list_by_topic_id AS document_list_by_topic_id_245, e0_.document_list_by_session_id AS document_list_by_session_id_246, e0_.work_experience_year AS work_experience_year_247, e0_.description AS description_248, e0_.summary_text AS summary_text_249, e0_.professional_title AS professional_title_250, e0_.work_experience_text AS work_experience_text_251, e0_.profession_text AS profession_text_252, e0_.education_text AS education_text_253, e0_.education_major_text AS education_major_text_254, e0_.highest_degree_achieved AS highest_degree_achieved_255, e0_.target_education_degree AS target_education_degree_256, e0_.target_education_major AS target_education_major_257, e0_.lead_query_text AS lead_query_text_258, e0_.university_text AS university_text_259, e0_.experience_text AS experience_text_260, e0_.skillstext AS skillstext_261, e0_.interest AS interest_262, e0_.speciality AS speciality_263, e0_.last_settings_updated_ts AS last_settings_updated_ts_264, e0_.created_at AS created_at_265, e0_.actual_registration_at AS actual_registration_at_266, e0_.updated_at AS updated_at_267 FROM entity_applicant_details e0_ WHERE e0_.email LIKE ? OR e0_.o_auth_email LIKE ? Parameters: [`"%emrul.hasan.himel@gmail.com%" "%emrul.hasan.himel@gmail.com%"`] View formatted query View runnable query Explain query 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_.religion AS religion_60, e0_.phone AS phone_61, e0_.official_phone AS official_phone_62, e0_.phone_with_country_code AS phone_with_country_code_63, e0_.phone_country_code AS phone_country_code_64, e0_.curr_addr_state AS curr_addr_state_65, e0_.curr_addr_city AS curr_addr_city_66, e0_.curr_addr_zip AS curr_addr_zip_67, e0_.curr_addr AS curr_addr_68, e0_.curr_addr_lat AS curr_addr_lat_69, e0_.curr_addr_lng AS curr_addr_lng_70, e0_.perm_addr AS perm_addr_71, e0_.emm_contact AS emm_contact_72, e0_.skill AS skill_73, e0_.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_74, e0_.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_75, e0_.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_76, e0_.preferred_country_ids_as_student AS preferred_country_ids_as_student_77, e0_.joining_date AS joining_date_78, e0_.emp_valid_till AS emp_valid_till_79, e0_.emp_status AS emp_status_80, e0_.emp_type AS emp_type_81, e0_.emp_code AS emp_code_82, e0_.emp_label AS emp_label_83, e0_.tin AS tin_84, e0_.tin_valid_till AS tin_valid_till_85, e0_.med_ins AS med_ins_86, e0_.med_ins_valid_till AS med_ins_valid_till_87, e0_.docs AS docs_88, e0_.inst1 AS inst1_89, e0_.yr1 AS yr1_90, e0_.dur1 AS dur1_91, e0_.inst2 AS inst2_92, e0_.yr2 AS yr2_93, e0_.dur2 AS dur2_94, e0_.inst3 AS inst3_95, e0_.yr3 AS yr3_96, e0_.dur3 AS dur3_97, e0_.einst1 AS einst1_98, e0_.eyr1 AS eyr1_99, e0_.edeg1 AS edeg1_100, e0_.einst2 AS einst2_101, e0_.eyr2 AS eyr2_102, e0_.edeg2 AS edeg2_103, e0_.einst3 AS einst3_104, e0_.eyr3 AS eyr3_105, e0_.edeg3 AS edeg3_106, e0_.tax_code AS tax_code_107, e0_.allowed_working_hours_per_day AS allowed_working_hours_per_day_108, e0_.allowed_working_hours_per_week AS allowed_working_hours_per_week_109, e0_.allowed_working_hours_per_month AS allowed_working_hours_per_month_110, e0_.allowed_working_hours_per_year AS allowed_working_hours_per_year_111, e0_.allowed_earning_per_day AS allowed_earning_per_day_112, e0_.allowed_earning_per_week AS allowed_earning_per_week_113, e0_.allowed_earning_per_month AS allowed_earning_per_month_114, e0_.allowed_earning_per_year AS allowed_earning_per_year_115, e0_.revenue_percentage_per_session AS revenue_percentage_per_session_116, e0_.transaction_acc_no AS transaction_acc_no_117, e0_.transaction_acc_name AS transaction_acc_name_118, e0_.bank_id AS bank_id_119, e0_.bank_branch_code AS bank_branch_code_120, e0_.bank_acc AS bank_acc_121, e0_.bank_name AS bank_name_122, e0_.bank_acc_name AS bank_acc_name_123, e0_.bank_acc_type AS bank_acc_type_124, e0_.bank_acc_valid_from AS bank_acc_valid_from_125, e0_.bank_acc_valid_to AS bank_acc_valid_to_126, e0_.routing_code AS routing_code_127, e0_.swift_code AS swift_code_128, e0_.mobile_wallet_no AS mobile_wallet_no_129, e0_.mobile_wallet_type AS mobile_wallet_type_130, e0_.ear1 AS ear1_131, e0_.ear2 AS ear2_132, e0_.ear3 AS ear3_133, e0_.ear4 AS ear4_134, e0_.ear5 AS ear5_135, e0_.ear6 AS ear6_136, e0_.eart AS eart_137, e0_.ded1 AS ded1_138, e0_.ded2 AS ded2_139, e0_.ded3 AS ded3_140, e0_.ded4 AS ded4_141, e0_.dedt AS dedt_142, e0_.payable AS payable_143, e0_.hand_cash AS hand_cash_144, e0_.bank_transfer AS bank_transfer_145, e0_.sec_dep AS sec_dep_146, e0_.sec_dep_span AS sec_dep_span_147, e0_.sec_dep_rem_mon AS sec_dep_rem_mon_148, e0_.sec_dep_rem_amount AS sec_dep_rem_amount_149, e0_.sl_qty AS sl_qty_150, e0_.sl_tkn AS sl_tkn_151, e0_.sl_freq AS sl_freq_152, e0_.ml_qty AS ml_qty_153, e0_.ml_tkn AS ml_tkn_154, e0_.ml_freq AS ml_freq_155, e0_.el_qty AS el_qty_156, e0_.el_tkn AS el_tkn_157, e0_.el_freq AS el_freq_158, e0_.cl_qty AS cl_qty_159, e0_.cl_tkn AS cl_tkn_160, e0_.cl_freq AS cl_freq_161, e0_.levt AS levt_162, e0_.weekly_holiday AS weekly_holiday_163, e0_.files AS files_164, e0_.supervisor AS supervisor_165, e0_.dept AS dept_166, e0_.desg AS desg_167, e0_.branch AS branch_168, e0_.division AS division_169, e0_.application_text AS application_text_170, e0_.current_employment AS current_employment_171, e0_.emergency_contact_number AS emergency_contact_number_172, e0_.postal_code AS postal_code_173, e0_.country AS country_174, e0_.education_data AS education_data_175, e0_.work_experience_data AS work_experience_data_176, e0_.certificate_data AS certificate_data_177, e0_.languages_data AS languages_data_178, e0_.important_comm_tags AS important_comm_tags_179, e0_.is_consultant AS is_consultant_180, e0_.is_featured AS is_featured_181, e0_.featured_duration_end_ts AS featured_duration_end_ts_182, e0_.is_moderator AS is_moderator_183, e0_.is_admin AS is_admin_184, e0_.admin_level AS admin_level_185, e0_.is_retailer AS is_retailer_186, e0_.retailer_level AS retailer_level_187, e0_.is_student AS is_student_188, e0_.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_189, e0_.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_190, e0_.online_status AS online_status_191, e0_.assigned_sales_representative_id AS assigned_sales_representative_id_192, e0_.lead_created_by_id AS lead_created_by_id_193, e0_.is_temporary_entry AS is_temporary_entry_194, e0_.lead_type AS lead_type_195, e0_.lead_level AS lead_level_196, e0_.immediate_follow_up_flag AS immediate_follow_up_flag_197, e0_.pending_initial_communication AS pending_initial_communication_198, e0_.last_online_ts AS last_online_ts_199, e0_.courses_data AS courses_data_200, e0_.video_link AS video_link_201, e0_.account_balance AS account_balance_202, e0_.session_count_balance AS session_count_balance_203, e0_.total_session_used AS total_session_used_204, e0_.total_consultancy_session_provided AS total_consultancy_session_provided_205, e0_.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_206, e0_.default_currency_id AS default_currency_id_207, e0_.default_language_id AS default_language_id_208, e0_.country_id AS country_id_209, e0_.following_consultant_ids AS following_consultant_ids_210, e0_.following_topic_ids AS following_topic_ids_211, e0_.viewed_topic_ids AS viewed_topic_ids_212, e0_.viewed_consultant_ids AS viewed_consultant_ids_213, e0_.following_event_ids AS following_event_ids_214, e0_.attending_event_ids AS attending_event_ids_215, e0_.skip_event_ids AS skip_event_ids_216, e0_.rating AS rating_217, e0_.applicant_specific_note AS applicant_specific_note_218, e0_.promo_discount_percentage AS promo_discount_percentage_219, e0_.promo_discount_balance_count AS promo_discount_balance_count_220, e0_.code_as_referer AS code_as_referer_221, e0_.referred_code AS referred_code_222, e0_.is_referred_code_used AS is_referred_code_used_223, e0_.promo_code_id AS promo_code_id_224, e0_.max_discount_allowed AS max_discount_allowed_225, e0_.claimed_promo_code_ids AS claimed_promo_code_ids_226, e0_.referred_coins_earned AS referred_coins_earned_227, e0_.referred_amount_earned AS referred_amount_earned_228, e0_.rating_weight AS rating_weight_229, e0_.rating_total AS rating_total_230, e0_.rating_count AS rating_count_231, e0_.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_232, e0_.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_233, e0_.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_234, e0_.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_235, e0_.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_236, e0_.selector AS selector_237, e0_.apply_for_consultant AS apply_for_consultant_238, e0_.apply_for_consultant_date AS apply_for_consultant_date_239, e0_.consultant_application_feedback AS consultant_application_feedback_240, e0_.apply_for_retailer AS apply_for_retailer_241, e0_.apply_for_retailer_date AS apply_for_retailer_date_242, e0_.doc_image AS doc_image_243, e0_.document_list AS document_list_244, e0_.document_list_by_topic_id AS document_list_by_topic_id_245, e0_.document_list_by_session_id AS document_list_by_session_id_246, e0_.work_experience_year AS work_experience_year_247, e0_.description AS description_248, e0_.summary_text AS summary_text_249, e0_.professional_title AS professional_title_250, e0_.work_experience_text AS work_experience_text_251, e0_.profession_text AS profession_text_252, e0_.education_text AS education_text_253, e0_.education_major_text AS education_major_text_254, e0_.highest_degree_achieved AS highest_degree_achieved_255, e0_.target_education_degree AS target_education_degree_256, e0_.target_education_major AS target_education_major_257, e0_.lead_query_text AS lead_query_text_258, e0_.university_text AS university_text_259, e0_.experience_text AS experience_text_260, e0_.skillstext AS skillstext_261, e0_.interest AS interest_262, e0_.speciality AS speciality_263, e0_.last_settings_updated_ts AS last_settings_updated_ts_264, e0_.created_at AS created_at_265, e0_.actual_registration_at AS actual_registration_at_266, e0_.updated_at AS updated_at_267 FROM entity_applicant_details e0_ WHERE e0_.email LIKE ? OR e0_.o_auth_email LIKE ? 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_.religion AS religion_60, e0_.phone AS phone_61, e0_.official_phone AS official_phone_62, e0_.phone_with_country_code AS phone_with_country_code_63, e0_.phone_country_code AS phone_country_code_64, e0_.curr_addr_state AS curr_addr_state_65, e0_.curr_addr_city AS curr_addr_city_66, e0_.curr_addr_zip AS curr_addr_zip_67, e0_.curr_addr AS curr_addr_68, e0_.curr_addr_lat AS curr_addr_lat_69, e0_.curr_addr_lng AS curr_addr_lng_70, e0_.perm_addr AS perm_addr_71, e0_.emm_contact AS emm_contact_72, e0_.skill AS skill_73, e0_.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_74, e0_.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_75, e0_.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_76, e0_.preferred_country_ids_as_student AS preferred_country_ids_as_student_77, e0_.joining_date AS joining_date_78, e0_.emp_valid_till AS emp_valid_till_79, e0_.emp_status AS emp_status_80, e0_.emp_type AS emp_type_81, e0_.emp_code AS emp_code_82, e0_.emp_label AS emp_label_83, e0_.tin AS tin_84, e0_.tin_valid_till AS tin_valid_till_85, e0_.med_ins AS med_ins_86, e0_.med_ins_valid_till AS med_ins_valid_till_87, e0_.docs AS docs_88, e0_.inst1 AS inst1_89, e0_.yr1 AS yr1_90, e0_.dur1 AS dur1_91, e0_.inst2 AS inst2_92, e0_.yr2 AS yr2_93, e0_.dur2 AS dur2_94, e0_.inst3 AS inst3_95, e0_.yr3 AS yr3_96, e0_.dur3 AS dur3_97, e0_.einst1 AS einst1_98, e0_.eyr1 AS eyr1_99, e0_.edeg1 AS edeg1_100, e0_.einst2 AS einst2_101, e0_.eyr2 AS eyr2_102, e0_.edeg2 AS edeg2_103, e0_.einst3 AS einst3_104, e0_.eyr3 AS eyr3_105, e0_.edeg3 AS edeg3_106, e0_.tax_code AS tax_code_107, e0_.allowed_working_hours_per_day AS allowed_working_hours_per_day_108, e0_.allowed_working_hours_per_week AS allowed_working_hours_per_week_109, e0_.allowed_working_hours_per_month AS allowed_working_hours_per_month_110, e0_.allowed_working_hours_per_year AS allowed_working_hours_per_year_111, e0_.allowed_earning_per_day AS allowed_earning_per_day_112, e0_.allowed_earning_per_week AS allowed_earning_per_week_113, e0_.allowed_earning_per_month AS allowed_earning_per_month_114, e0_.allowed_earning_per_year AS allowed_earning_per_year_115, e0_.revenue_percentage_per_session AS revenue_percentage_per_session_116, e0_.transaction_acc_no AS transaction_acc_no_117, e0_.transaction_acc_name AS transaction_acc_name_118, e0_.bank_id AS bank_id_119, e0_.bank_branch_code AS bank_branch_code_120, e0_.bank_acc AS bank_acc_121, e0_.bank_name AS bank_name_122, e0_.bank_acc_name AS bank_acc_name_123, e0_.bank_acc_type AS bank_acc_type_124, e0_.bank_acc_valid_from AS bank_acc_valid_from_125, e0_.bank_acc_valid_to AS bank_acc_valid_to_126, e0_.routing_code AS routing_code_127, e0_.swift_code AS swift_code_128, e0_.mobile_wallet_no AS mobile_wallet_no_129, e0_.mobile_wallet_type AS mobile_wallet_type_130, e0_.ear1 AS ear1_131, e0_.ear2 AS ear2_132, e0_.ear3 AS ear3_133, e0_.ear4 AS ear4_134, e0_.ear5 AS ear5_135, e0_.ear6 AS ear6_136, e0_.eart AS eart_137, e0_.ded1 AS ded1_138, e0_.ded2 AS ded2_139, e0_.ded3 AS ded3_140, e0_.ded4 AS ded4_141, e0_.dedt AS dedt_142, e0_.payable AS payable_143, e0_.hand_cash AS hand_cash_144, e0_.bank_transfer AS bank_transfer_145, e0_.sec_dep AS sec_dep_146, e0_.sec_dep_span AS sec_dep_span_147, e0_.sec_dep_rem_mon AS sec_dep_rem_mon_148, e0_.sec_dep_rem_amount AS sec_dep_rem_amount_149, e0_.sl_qty AS sl_qty_150, e0_.sl_tkn AS sl_tkn_151, e0_.sl_freq AS sl_freq_152, e0_.ml_qty AS ml_qty_153, e0_.ml_tkn AS ml_tkn_154, e0_.ml_freq AS ml_freq_155, e0_.el_qty AS el_qty_156, e0_.el_tkn AS el_tkn_157, e0_.el_freq AS el_freq_158, e0_.cl_qty AS cl_qty_159, e0_.cl_tkn AS cl_tkn_160, e0_.cl_freq AS cl_freq_161, e0_.levt AS levt_162, e0_.weekly_holiday AS weekly_holiday_163, e0_.files AS files_164, e0_.supervisor AS supervisor_165, e0_.dept AS dept_166, e0_.desg AS desg_167, e0_.branch AS branch_168, e0_.division AS division_169, e0_.application_text AS application_text_170, e0_.current_employment AS current_employment_171, e0_.emergency_contact_number AS emergency_contact_number_172, e0_.postal_code AS postal_code_173, e0_.country AS country_174, e0_.education_data AS education_data_175, e0_.work_experience_data AS work_experience_data_176, e0_.certificate_data AS certificate_data_177, e0_.languages_data AS languages_data_178, e0_.important_comm_tags AS important_comm_tags_179, e0_.is_consultant AS is_consultant_180, e0_.is_featured AS is_featured_181, e0_.featured_duration_end_ts AS featured_duration_end_ts_182, e0_.is_moderator AS is_moderator_183, e0_.is_admin AS is_admin_184, e0_.admin_level AS admin_level_185, e0_.is_retailer AS is_retailer_186, e0_.retailer_level AS retailer_level_187, e0_.is_student AS is_student_188, e0_.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_189, e0_.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_190, e0_.online_status AS online_status_191, e0_.assigned_sales_representative_id AS assigned_sales_representative_id_192, e0_.lead_created_by_id AS lead_created_by_id_193, e0_.is_temporary_entry AS is_temporary_entry_194, e0_.lead_type AS lead_type_195, e0_.lead_level AS lead_level_196, e0_.immediate_follow_up_flag AS immediate_follow_up_flag_197, e0_.pending_initial_communication AS pending_initial_communication_198, e0_.last_online_ts AS last_online_ts_199, e0_.courses_data AS courses_data_200, e0_.video_link AS video_link_201, e0_.account_balance AS account_balance_202, e0_.session_count_balance AS session_count_balance_203, e0_.total_session_used AS total_session_used_204, e0_.total_consultancy_session_provided AS total_consultancy_session_provided_205, e0_.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_206, e0_.default_currency_id AS default_currency_id_207, e0_.default_language_id AS default_language_id_208, e0_.country_id AS country_id_209, e0_.following_consultant_ids AS following_consultant_ids_210, e0_.following_topic_ids AS following_topic_ids_211, e0_.viewed_topic_ids AS viewed_topic_ids_212, e0_.viewed_consultant_ids AS viewed_consultant_ids_213, e0_.following_event_ids AS following_event_ids_214, e0_.attending_event_ids AS attending_event_ids_215, e0_.skip_event_ids AS skip_event_ids_216, e0_.rating AS rating_217, e0_.applicant_specific_note AS applicant_specific_note_218, e0_.promo_discount_percentage AS promo_discount_percentage_219, e0_.promo_discount_balance_count AS promo_discount_balance_count_220, e0_.code_as_referer AS code_as_referer_221, e0_.referred_code AS referred_code_222, e0_.is_referred_code_used AS is_referred_code_used_223, e0_.promo_code_id AS promo_code_id_224, e0_.max_discount_allowed AS max_discount_allowed_225, e0_.claimed_promo_code_ids AS claimed_promo_code_ids_226, e0_.referred_coins_earned AS referred_coins_earned_227, e0_.referred_amount_earned AS referred_amount_earned_228, e0_.rating_weight AS rating_weight_229, e0_.rating_total AS rating_total_230, e0_.rating_count AS rating_count_231, e0_.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_232, e0_.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_233, e0_.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_234, e0_.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_235, e0_.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_236, e0_.selector AS selector_237, e0_.apply_for_consultant AS apply_for_consultant_238, e0_.apply_for_consultant_date AS apply_for_consultant_date_239, e0_.consultant_application_feedback AS consultant_application_feedback_240, e0_.apply_for_retailer AS apply_for_retailer_241, e0_.apply_for_retailer_date AS apply_for_retailer_date_242, e0_.doc_image AS doc_image_243, e0_.document_list AS document_list_244, e0_.document_list_by_topic_id AS document_list_by_topic_id_245, e0_.document_list_by_session_id AS document_list_by_session_id_246, e0_.work_experience_year AS work_experience_year_247, e0_.description AS description_248, e0_.summary_text AS summary_text_249, e0_.professional_title AS professional_title_250, e0_.work_experience_text AS work_experience_text_251, e0_.profession_text AS profession_text_252, e0_.education_text AS education_text_253, e0_.education_major_text AS education_major_text_254, e0_.highest_degree_achieved AS highest_degree_achieved_255, e0_.target_education_degree AS target_education_degree_256, e0_.target_education_major AS target_education_major_257, e0_.lead_query_text AS lead_query_text_258, e0_.university_text AS university_text_259, e0_.experience_text AS experience_text_260, e0_.skillstext AS skillstext_261, e0_.interest AS interest_262, e0_.speciality AS speciality_263, e0_.last_settings_updated_ts AS last_settings_updated_ts_264, e0_.created_at AS created_at_265, e0_.actual_registration_at AS actual_registration_at_266, e0_.updated_at AS updated_at_267 FROM entity_applicant_details e0_ WHERE e0_.email LIKE '%emrul.hasan.himel@gmail.com%' OR e0_.o_auth_email LIKE '%emrul.hasan.himel@gmail.com%';
4	1.17 ms	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.religion AS religion_61, t0.phone AS phone_62, t0.official_phone AS official_phone_63, t0.phone_with_country_code AS phone_with_country_code_64, t0.phone_country_code AS phone_country_code_65, t0.curr_addr_state AS curr_addr_state_66, t0.curr_addr_city AS curr_addr_city_67, t0.curr_addr_zip AS curr_addr_zip_68, t0.curr_addr AS curr_addr_69, t0.curr_addr_lat AS curr_addr_lat_70, t0.curr_addr_lng AS curr_addr_lng_71, t0.perm_addr AS perm_addr_72, t0.emm_contact AS emm_contact_73, t0.skill AS skill_74, t0.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_75, t0.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_76, t0.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_77, t0.preferred_country_ids_as_student AS preferred_country_ids_as_student_78, t0.joining_date AS joining_date_79, t0.emp_valid_till AS emp_valid_till_80, t0.emp_status AS emp_status_81, t0.emp_type AS emp_type_82, t0.emp_code AS emp_code_83, t0.emp_label AS emp_label_84, t0.tin AS tin_85, t0.tin_valid_till AS tin_valid_till_86, t0.med_ins AS med_ins_87, t0.med_ins_valid_till AS med_ins_valid_till_88, t0.docs AS docs_89, t0.inst1 AS inst1_90, t0.yr1 AS yr1_91, t0.dur1 AS dur1_92, t0.inst2 AS inst2_93, t0.yr2 AS yr2_94, t0.dur2 AS dur2_95, t0.inst3 AS inst3_96, t0.yr3 AS yr3_97, t0.dur3 AS dur3_98, t0.einst1 AS einst1_99, t0.eyr1 AS eyr1_100, t0.edeg1 AS edeg1_101, t0.einst2 AS einst2_102, t0.eyr2 AS eyr2_103, t0.edeg2 AS edeg2_104, t0.einst3 AS einst3_105, t0.eyr3 AS eyr3_106, t0.edeg3 AS edeg3_107, t0.tax_code AS tax_code_108, t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_109, t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_110, t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_111, t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_112, t0.allowed_earning_per_day AS allowed_earning_per_day_113, t0.allowed_earning_per_week AS allowed_earning_per_week_114, t0.allowed_earning_per_month AS allowed_earning_per_month_115, t0.allowed_earning_per_year AS allowed_earning_per_year_116, t0.revenue_percentage_per_session AS revenue_percentage_per_session_117, t0.transaction_acc_no AS transaction_acc_no_118, t0.transaction_acc_name AS transaction_acc_name_119, t0.bank_id AS bank_id_120, t0.bank_branch_code AS bank_branch_code_121, t0.bank_acc AS bank_acc_122, t0.bank_name AS bank_name_123, t0.bank_acc_name AS bank_acc_name_124, t0.bank_acc_type AS bank_acc_type_125, t0.bank_acc_valid_from AS bank_acc_valid_from_126, t0.bank_acc_valid_to AS bank_acc_valid_to_127, t0.routing_code AS routing_code_128, t0.swift_code AS swift_code_129, t0.mobile_wallet_no AS mobile_wallet_no_130, t0.mobile_wallet_type AS mobile_wallet_type_131, t0.ear1 AS ear1_132, t0.ear2 AS ear2_133, t0.ear3 AS ear3_134, t0.ear4 AS ear4_135, t0.ear5 AS ear5_136, t0.ear6 AS ear6_137, t0.eart AS eart_138, t0.ded1 AS ded1_139, t0.ded2 AS ded2_140, t0.ded3 AS ded3_141, t0.ded4 AS ded4_142, t0.dedt AS dedt_143, t0.payable AS payable_144, t0.hand_cash AS hand_cash_145, t0.bank_transfer AS bank_transfer_146, t0.sec_dep AS sec_dep_147, t0.sec_dep_span AS sec_dep_span_148, t0.sec_dep_rem_mon AS sec_dep_rem_mon_149, t0.sec_dep_rem_amount AS sec_dep_rem_amount_150, t0.sl_qty AS sl_qty_151, t0.sl_tkn AS sl_tkn_152, t0.sl_freq AS sl_freq_153, t0.ml_qty AS ml_qty_154, t0.ml_tkn AS ml_tkn_155, t0.ml_freq AS ml_freq_156, t0.el_qty AS el_qty_157, t0.el_tkn AS el_tkn_158, t0.el_freq AS el_freq_159, t0.cl_qty AS cl_qty_160, t0.cl_tkn AS cl_tkn_161, t0.cl_freq AS cl_freq_162, t0.levt AS levt_163, t0.weekly_holiday AS weekly_holiday_164, t0.files AS files_165, t0.supervisor AS supervisor_166, t0.dept AS dept_167, t0.desg AS desg_168, t0.branch AS branch_169, t0.division AS division_170, t0.application_text AS application_text_171, t0.current_employment AS current_employment_172, t0.emergency_contact_number AS emergency_contact_number_173, t0.postal_code AS postal_code_174, t0.country AS country_175, t0.education_data AS education_data_176, t0.work_experience_data AS work_experience_data_177, t0.certificate_data AS certificate_data_178, t0.languages_data AS languages_data_179, t0.important_comm_tags AS important_comm_tags_180, t0.is_consultant AS is_consultant_181, t0.is_featured AS is_featured_182, t0.featured_duration_end_ts AS featured_duration_end_ts_183, t0.is_moderator AS is_moderator_184, t0.is_admin AS is_admin_185, t0.admin_level AS admin_level_186, t0.is_retailer AS is_retailer_187, t0.retailer_level AS retailer_level_188, t0.is_student AS is_student_189, t0.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_190, t0.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_191, t0.online_status AS online_status_192, t0.assigned_sales_representative_id AS assigned_sales_representative_id_193, t0.lead_created_by_id AS lead_created_by_id_194, t0.is_temporary_entry AS is_temporary_entry_195, t0.lead_type AS lead_type_196, t0.lead_level AS lead_level_197, t0.immediate_follow_up_flag AS immediate_follow_up_flag_198, t0.pending_initial_communication AS pending_initial_communication_199, t0.last_online_ts AS last_online_ts_200, t0.courses_data AS courses_data_201, t0.video_link AS video_link_202, t0.account_balance AS account_balance_203, t0.session_count_balance AS session_count_balance_204, t0.total_session_used AS total_session_used_205, t0.total_consultancy_session_provided AS total_consultancy_session_provided_206, t0.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_207, t0.default_currency_id AS default_currency_id_208, t0.default_language_id AS default_language_id_209, t0.country_id AS country_id_210, t0.following_consultant_ids AS following_consultant_ids_211, t0.following_topic_ids AS following_topic_ids_212, t0.viewed_topic_ids AS viewed_topic_ids_213, t0.viewed_consultant_ids AS viewed_consultant_ids_214, t0.following_event_ids AS following_event_ids_215, t0.attending_event_ids AS attending_event_ids_216, t0.skip_event_ids AS skip_event_ids_217, t0.rating AS rating_218, t0.applicant_specific_note AS applicant_specific_note_219, t0.promo_discount_percentage AS promo_discount_percentage_220, t0.promo_discount_balance_count AS promo_discount_balance_count_221, t0.code_as_referer AS code_as_referer_222, t0.referred_code AS referred_code_223, t0.is_referred_code_used AS is_referred_code_used_224, t0.promo_code_id AS promo_code_id_225, t0.max_discount_allowed AS max_discount_allowed_226, t0.claimed_promo_code_ids AS claimed_promo_code_ids_227, t0.referred_coins_earned AS referred_coins_earned_228, t0.referred_amount_earned AS referred_amount_earned_229, t0.rating_weight AS rating_weight_230, t0.rating_total AS rating_total_231, t0.rating_count AS rating_count_232, t0.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_233, t0.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_234, t0.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_235, t0.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_236, t0.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_237, t0.selector AS selector_238, t0.apply_for_consultant AS apply_for_consultant_239, t0.apply_for_consultant_date AS apply_for_consultant_date_240, t0.consultant_application_feedback AS consultant_application_feedback_241, t0.apply_for_retailer AS apply_for_retailer_242, t0.apply_for_retailer_date AS apply_for_retailer_date_243, t0.doc_image AS doc_image_244, t0.document_list AS document_list_245, t0.document_list_by_topic_id AS document_list_by_topic_id_246, t0.document_list_by_session_id AS document_list_by_session_id_247, t0.work_experience_year AS work_experience_year_248, t0.description AS description_249, t0.summary_text AS summary_text_250, t0.professional_title AS professional_title_251, t0.work_experience_text AS work_experience_text_252, t0.profession_text AS profession_text_253, t0.education_text AS education_text_254, t0.education_major_text AS education_major_text_255, t0.highest_degree_achieved AS highest_degree_achieved_256, t0.target_education_degree AS target_education_degree_257, t0.target_education_major AS target_education_major_258, t0.lead_query_text AS lead_query_text_259, t0.university_text AS university_text_260, t0.experience_text AS experience_text_261, t0.skillstext AS skillstext_262, t0.interest AS interest_263, t0.speciality AS speciality_264, t0.last_settings_updated_ts AS last_settings_updated_ts_265, t0.created_at AS created_at_266, t0.actual_registration_at AS actual_registration_at_267, t0.updated_at AS updated_at_268 FROM entity_applicant_details t0 WHERE t0.o_auth_unique_id = ? LIMIT 1 Parameters: [`"118269991768947018287"`] View formatted query View runnable query Explain query 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.religion AS religion_61, t0.phone AS phone_62, t0.official_phone AS official_phone_63, t0.phone_with_country_code AS phone_with_country_code_64, t0.phone_country_code AS phone_country_code_65, t0.curr_addr_state AS curr_addr_state_66, t0.curr_addr_city AS curr_addr_city_67, t0.curr_addr_zip AS curr_addr_zip_68, t0.curr_addr AS curr_addr_69, t0.curr_addr_lat AS curr_addr_lat_70, t0.curr_addr_lng AS curr_addr_lng_71, t0.perm_addr AS perm_addr_72, t0.emm_contact AS emm_contact_73, t0.skill AS skill_74, t0.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_75, t0.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_76, t0.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_77, t0.preferred_country_ids_as_student AS preferred_country_ids_as_student_78, t0.joining_date AS joining_date_79, t0.emp_valid_till AS emp_valid_till_80, t0.emp_status AS emp_status_81, t0.emp_type AS emp_type_82, t0.emp_code AS emp_code_83, t0.emp_label AS emp_label_84, t0.tin AS tin_85, t0.tin_valid_till AS tin_valid_till_86, t0.med_ins AS med_ins_87, t0.med_ins_valid_till AS med_ins_valid_till_88, t0.docs AS docs_89, t0.inst1 AS inst1_90, t0.yr1 AS yr1_91, t0.dur1 AS dur1_92, t0.inst2 AS inst2_93, t0.yr2 AS yr2_94, t0.dur2 AS dur2_95, t0.inst3 AS inst3_96, t0.yr3 AS yr3_97, t0.dur3 AS dur3_98, t0.einst1 AS einst1_99, t0.eyr1 AS eyr1_100, t0.edeg1 AS edeg1_101, t0.einst2 AS einst2_102, t0.eyr2 AS eyr2_103, t0.edeg2 AS edeg2_104, t0.einst3 AS einst3_105, t0.eyr3 AS eyr3_106, t0.edeg3 AS edeg3_107, t0.tax_code AS tax_code_108, t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_109, t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_110, t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_111, t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_112, t0.allowed_earning_per_day AS allowed_earning_per_day_113, t0.allowed_earning_per_week AS allowed_earning_per_week_114, t0.allowed_earning_per_month AS allowed_earning_per_month_115, t0.allowed_earning_per_year AS allowed_earning_per_year_116, t0.revenue_percentage_per_session AS revenue_percentage_per_session_117, t0.transaction_acc_no AS transaction_acc_no_118, t0.transaction_acc_name AS transaction_acc_name_119, t0.bank_id AS bank_id_120, t0.bank_branch_code AS bank_branch_code_121, t0.bank_acc AS bank_acc_122, t0.bank_name AS bank_name_123, t0.bank_acc_name AS bank_acc_name_124, t0.bank_acc_type AS bank_acc_type_125, t0.bank_acc_valid_from AS bank_acc_valid_from_126, t0.bank_acc_valid_to AS bank_acc_valid_to_127, t0.routing_code AS routing_code_128, t0.swift_code AS swift_code_129, t0.mobile_wallet_no AS mobile_wallet_no_130, t0.mobile_wallet_type AS mobile_wallet_type_131, t0.ear1 AS ear1_132, t0.ear2 AS ear2_133, t0.ear3 AS ear3_134, t0.ear4 AS ear4_135, t0.ear5 AS ear5_136, t0.ear6 AS ear6_137, t0.eart AS eart_138, t0.ded1 AS ded1_139, t0.ded2 AS ded2_140, t0.ded3 AS ded3_141, t0.ded4 AS ded4_142, t0.dedt AS dedt_143, t0.payable AS payable_144, t0.hand_cash AS hand_cash_145, t0.bank_transfer AS bank_transfer_146, t0.sec_dep AS sec_dep_147, t0.sec_dep_span AS sec_dep_span_148, t0.sec_dep_rem_mon AS sec_dep_rem_mon_149, t0.sec_dep_rem_amount AS sec_dep_rem_amount_150, t0.sl_qty AS sl_qty_151, t0.sl_tkn AS sl_tkn_152, t0.sl_freq AS sl_freq_153, t0.ml_qty AS ml_qty_154, t0.ml_tkn AS ml_tkn_155, t0.ml_freq AS ml_freq_156, t0.el_qty AS el_qty_157, t0.el_tkn AS el_tkn_158, t0.el_freq AS el_freq_159, t0.cl_qty AS cl_qty_160, t0.cl_tkn AS cl_tkn_161, t0.cl_freq AS cl_freq_162, t0.levt AS levt_163, t0.weekly_holiday AS weekly_holiday_164, t0.files AS files_165, t0.supervisor AS supervisor_166, t0.dept AS dept_167, t0.desg AS desg_168, t0.branch AS branch_169, t0.division AS division_170, t0.application_text AS application_text_171, t0.current_employment AS current_employment_172, t0.emergency_contact_number AS emergency_contact_number_173, t0.postal_code AS postal_code_174, t0.country AS country_175, t0.education_data AS education_data_176, t0.work_experience_data AS work_experience_data_177, t0.certificate_data AS certificate_data_178, t0.languages_data AS languages_data_179, t0.important_comm_tags AS important_comm_tags_180, t0.is_consultant AS is_consultant_181, t0.is_featured AS is_featured_182, t0.featured_duration_end_ts AS featured_duration_end_ts_183, t0.is_moderator AS is_moderator_184, t0.is_admin AS is_admin_185, t0.admin_level AS admin_level_186, t0.is_retailer AS is_retailer_187, t0.retailer_level AS retailer_level_188, t0.is_student AS is_student_189, t0.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_190, t0.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_191, t0.online_status AS online_status_192, t0.assigned_sales_representative_id AS assigned_sales_representative_id_193, t0.lead_created_by_id AS lead_created_by_id_194, t0.is_temporary_entry AS is_temporary_entry_195, t0.lead_type AS lead_type_196, t0.lead_level AS lead_level_197, t0.immediate_follow_up_flag AS immediate_follow_up_flag_198, t0.pending_initial_communication AS pending_initial_communication_199, t0.last_online_ts AS last_online_ts_200, t0.courses_data AS courses_data_201, t0.video_link AS video_link_202, t0.account_balance AS account_balance_203, t0.session_count_balance AS session_count_balance_204, t0.total_session_used AS total_session_used_205, t0.total_consultancy_session_provided AS total_consultancy_session_provided_206, t0.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_207, t0.default_currency_id AS default_currency_id_208, t0.default_language_id AS default_language_id_209, t0.country_id AS country_id_210, t0.following_consultant_ids AS following_consultant_ids_211, t0.following_topic_ids AS following_topic_ids_212, t0.viewed_topic_ids AS viewed_topic_ids_213, t0.viewed_consultant_ids AS viewed_consultant_ids_214, t0.following_event_ids AS following_event_ids_215, t0.attending_event_ids AS attending_event_ids_216, t0.skip_event_ids AS skip_event_ids_217, t0.rating AS rating_218, t0.applicant_specific_note AS applicant_specific_note_219, t0.promo_discount_percentage AS promo_discount_percentage_220, t0.promo_discount_balance_count AS promo_discount_balance_count_221, t0.code_as_referer AS code_as_referer_222, t0.referred_code AS referred_code_223, t0.is_referred_code_used AS is_referred_code_used_224, t0.promo_code_id AS promo_code_id_225, t0.max_discount_allowed AS max_discount_allowed_226, t0.claimed_promo_code_ids AS claimed_promo_code_ids_227, t0.referred_coins_earned AS referred_coins_earned_228, t0.referred_amount_earned AS referred_amount_earned_229, t0.rating_weight AS rating_weight_230, t0.rating_total AS rating_total_231, t0.rating_count AS rating_count_232, t0.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_233, t0.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_234, t0.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_235, t0.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_236, t0.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_237, t0.selector AS selector_238, t0.apply_for_consultant AS apply_for_consultant_239, t0.apply_for_consultant_date AS apply_for_consultant_date_240, t0.consultant_application_feedback AS consultant_application_feedback_241, t0.apply_for_retailer AS apply_for_retailer_242, t0.apply_for_retailer_date AS apply_for_retailer_date_243, t0.doc_image AS doc_image_244, t0.document_list AS document_list_245, t0.document_list_by_topic_id AS document_list_by_topic_id_246, t0.document_list_by_session_id AS document_list_by_session_id_247, t0.work_experience_year AS work_experience_year_248, t0.description AS description_249, t0.summary_text AS summary_text_250, t0.professional_title AS professional_title_251, t0.work_experience_text AS work_experience_text_252, t0.profession_text AS profession_text_253, t0.education_text AS education_text_254, t0.education_major_text AS education_major_text_255, t0.highest_degree_achieved AS highest_degree_achieved_256, t0.target_education_degree AS target_education_degree_257, t0.target_education_major AS target_education_major_258, t0.lead_query_text AS lead_query_text_259, t0.university_text AS university_text_260, t0.experience_text AS experience_text_261, t0.skillstext AS skillstext_262, t0.interest AS interest_263, t0.speciality AS speciality_264, t0.last_settings_updated_ts AS last_settings_updated_ts_265, t0.created_at AS created_at_266, t0.actual_registration_at AS actual_registration_at_267, t0.updated_at AS updated_at_268 FROM entity_applicant_details t0 WHERE t0.o_auth_unique_id = ? 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.religion AS religion_61, t0.phone AS phone_62, t0.official_phone AS official_phone_63, t0.phone_with_country_code AS phone_with_country_code_64, t0.phone_country_code AS phone_country_code_65, t0.curr_addr_state AS curr_addr_state_66, t0.curr_addr_city AS curr_addr_city_67, t0.curr_addr_zip AS curr_addr_zip_68, t0.curr_addr AS curr_addr_69, t0.curr_addr_lat AS curr_addr_lat_70, t0.curr_addr_lng AS curr_addr_lng_71, t0.perm_addr AS perm_addr_72, t0.emm_contact AS emm_contact_73, t0.skill AS skill_74, t0.preferred_topic_ids_as_consultant AS preferred_topic_ids_as_consultant_75, t0.preferred_topic_ids_as_student AS preferred_topic_ids_as_student_76, t0.preferred_country_ids_as_consultant AS preferred_country_ids_as_consultant_77, t0.preferred_country_ids_as_student AS preferred_country_ids_as_student_78, t0.joining_date AS joining_date_79, t0.emp_valid_till AS emp_valid_till_80, t0.emp_status AS emp_status_81, t0.emp_type AS emp_type_82, t0.emp_code AS emp_code_83, t0.emp_label AS emp_label_84, t0.tin AS tin_85, t0.tin_valid_till AS tin_valid_till_86, t0.med_ins AS med_ins_87, t0.med_ins_valid_till AS med_ins_valid_till_88, t0.docs AS docs_89, t0.inst1 AS inst1_90, t0.yr1 AS yr1_91, t0.dur1 AS dur1_92, t0.inst2 AS inst2_93, t0.yr2 AS yr2_94, t0.dur2 AS dur2_95, t0.inst3 AS inst3_96, t0.yr3 AS yr3_97, t0.dur3 AS dur3_98, t0.einst1 AS einst1_99, t0.eyr1 AS eyr1_100, t0.edeg1 AS edeg1_101, t0.einst2 AS einst2_102, t0.eyr2 AS eyr2_103, t0.edeg2 AS edeg2_104, t0.einst3 AS einst3_105, t0.eyr3 AS eyr3_106, t0.edeg3 AS edeg3_107, t0.tax_code AS tax_code_108, t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_109, t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_110, t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_111, t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_112, t0.allowed_earning_per_day AS allowed_earning_per_day_113, t0.allowed_earning_per_week AS allowed_earning_per_week_114, t0.allowed_earning_per_month AS allowed_earning_per_month_115, t0.allowed_earning_per_year AS allowed_earning_per_year_116, t0.revenue_percentage_per_session AS revenue_percentage_per_session_117, t0.transaction_acc_no AS transaction_acc_no_118, t0.transaction_acc_name AS transaction_acc_name_119, t0.bank_id AS bank_id_120, t0.bank_branch_code AS bank_branch_code_121, t0.bank_acc AS bank_acc_122, t0.bank_name AS bank_name_123, t0.bank_acc_name AS bank_acc_name_124, t0.bank_acc_type AS bank_acc_type_125, t0.bank_acc_valid_from AS bank_acc_valid_from_126, t0.bank_acc_valid_to AS bank_acc_valid_to_127, t0.routing_code AS routing_code_128, t0.swift_code AS swift_code_129, t0.mobile_wallet_no AS mobile_wallet_no_130, t0.mobile_wallet_type AS mobile_wallet_type_131, t0.ear1 AS ear1_132, t0.ear2 AS ear2_133, t0.ear3 AS ear3_134, t0.ear4 AS ear4_135, t0.ear5 AS ear5_136, t0.ear6 AS ear6_137, t0.eart AS eart_138, t0.ded1 AS ded1_139, t0.ded2 AS ded2_140, t0.ded3 AS ded3_141, t0.ded4 AS ded4_142, t0.dedt AS dedt_143, t0.payable AS payable_144, t0.hand_cash AS hand_cash_145, t0.bank_transfer AS bank_transfer_146, t0.sec_dep AS sec_dep_147, t0.sec_dep_span AS sec_dep_span_148, t0.sec_dep_rem_mon AS sec_dep_rem_mon_149, t0.sec_dep_rem_amount AS sec_dep_rem_amount_150, t0.sl_qty AS sl_qty_151, t0.sl_tkn AS sl_tkn_152, t0.sl_freq AS sl_freq_153, t0.ml_qty AS ml_qty_154, t0.ml_tkn AS ml_tkn_155, t0.ml_freq AS ml_freq_156, t0.el_qty AS el_qty_157, t0.el_tkn AS el_tkn_158, t0.el_freq AS el_freq_159, t0.cl_qty AS cl_qty_160, t0.cl_tkn AS cl_tkn_161, t0.cl_freq AS cl_freq_162, t0.levt AS levt_163, t0.weekly_holiday AS weekly_holiday_164, t0.files AS files_165, t0.supervisor AS supervisor_166, t0.dept AS dept_167, t0.desg AS desg_168, t0.branch AS branch_169, t0.division AS division_170, t0.application_text AS application_text_171, t0.current_employment AS current_employment_172, t0.emergency_contact_number AS emergency_contact_number_173, t0.postal_code AS postal_code_174, t0.country AS country_175, t0.education_data AS education_data_176, t0.work_experience_data AS work_experience_data_177, t0.certificate_data AS certificate_data_178, t0.languages_data AS languages_data_179, t0.important_comm_tags AS important_comm_tags_180, t0.is_consultant AS is_consultant_181, t0.is_featured AS is_featured_182, t0.featured_duration_end_ts AS featured_duration_end_ts_183, t0.is_moderator AS is_moderator_184, t0.is_admin AS is_admin_185, t0.admin_level AS admin_level_186, t0.is_retailer AS is_retailer_187, t0.retailer_level AS retailer_level_188, t0.is_student AS is_student_189, t0.preferred_consultancy_types_as_student AS preferred_consultancy_types_as_student_190, t0.preferred_consultancy_types_as_consultant AS preferred_consultancy_types_as_consultant_191, t0.online_status AS online_status_192, t0.assigned_sales_representative_id AS assigned_sales_representative_id_193, t0.lead_created_by_id AS lead_created_by_id_194, t0.is_temporary_entry AS is_temporary_entry_195, t0.lead_type AS lead_type_196, t0.lead_level AS lead_level_197, t0.immediate_follow_up_flag AS immediate_follow_up_flag_198, t0.pending_initial_communication AS pending_initial_communication_199, t0.last_online_ts AS last_online_ts_200, t0.courses_data AS courses_data_201, t0.video_link AS video_link_202, t0.account_balance AS account_balance_203, t0.session_count_balance AS session_count_balance_204, t0.total_session_used AS total_session_used_205, t0.total_consultancy_session_provided AS total_consultancy_session_provided_206, t0.total_individual_consultancy_session_provided AS total_individual_consultancy_session_provided_207, t0.default_currency_id AS default_currency_id_208, t0.default_language_id AS default_language_id_209, t0.country_id AS country_id_210, t0.following_consultant_ids AS following_consultant_ids_211, t0.following_topic_ids AS following_topic_ids_212, t0.viewed_topic_ids AS viewed_topic_ids_213, t0.viewed_consultant_ids AS viewed_consultant_ids_214, t0.following_event_ids AS following_event_ids_215, t0.attending_event_ids AS attending_event_ids_216, t0.skip_event_ids AS skip_event_ids_217, t0.rating AS rating_218, t0.applicant_specific_note AS applicant_specific_note_219, t0.promo_discount_percentage AS promo_discount_percentage_220, t0.promo_discount_balance_count AS promo_discount_balance_count_221, t0.code_as_referer AS code_as_referer_222, t0.referred_code AS referred_code_223, t0.is_referred_code_used AS is_referred_code_used_224, t0.promo_code_id AS promo_code_id_225, t0.max_discount_allowed AS max_discount_allowed_226, t0.claimed_promo_code_ids AS claimed_promo_code_ids_227, t0.referred_coins_earned AS referred_coins_earned_228, t0.referred_amount_earned AS referred_amount_earned_229, t0.rating_weight AS rating_weight_230, t0.rating_total AS rating_total_231, t0.rating_count AS rating_count_232, t0.preferred_consultancy_language_ids AS preferred_consultancy_language_ids_233, t0.preferred_consultancy_topic_country_ids AS preferred_consultancy_topic_country_ids_234, t0.preferred_consultancy_student_country_ids AS preferred_consultancy_student_country_ids_235, t0.preferred_schedule_data_for_getting_consultancy AS preferred_schedule_data_for_getting_consultancy_236, t0.preferred_schedule_data_for_providing_consultancy AS preferred_schedule_data_for_providing_consultancy_237, t0.selector AS selector_238, t0.apply_for_consultant AS apply_for_consultant_239, t0.apply_for_consultant_date AS apply_for_consultant_date_240, t0.consultant_application_feedback AS consultant_application_feedback_241, t0.apply_for_retailer AS apply_for_retailer_242, t0.apply_for_retailer_date AS apply_for_retailer_date_243, t0.doc_image AS doc_image_244, t0.document_list AS document_list_245, t0.document_list_by_topic_id AS document_list_by_topic_id_246, t0.document_list_by_session_id AS document_list_by_session_id_247, t0.work_experience_year AS work_experience_year_248, t0.description AS description_249, t0.summary_text AS summary_text_250, t0.professional_title AS professional_title_251, t0.work_experience_text AS work_experience_text_252, t0.profession_text AS profession_text_253, t0.education_text AS education_text_254, t0.education_major_text AS education_major_text_255, t0.highest_degree_achieved AS highest_degree_achieved_256, t0.target_education_degree AS target_education_degree_257, t0.target_education_major AS target_education_major_258, t0.lead_query_text AS lead_query_text_259, t0.university_text AS university_text_260, t0.experience_text AS experience_text_261, t0.skillstext AS skillstext_262, t0.interest AS interest_263, t0.speciality AS speciality_264, t0.last_settings_updated_ts AS last_settings_updated_ts_265, t0.created_at AS created_at_266, t0.actual_registration_at AS actual_registration_at_267, t0.updated_at AS updated_at_268 FROM entity_applicant_details t0 WHERE t0.o_auth_unique_id = '118269991768947018287' LIMIT 1;
5	0.19 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
6	0.49 ms	INSERT INTO entity_login_log (user_id, applicant_id, is_applicant, position_id, login_ip, log_time, log_status, device_id, firebase_token, locale, o_auth_token, o_auth_type, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"54" "54" 1 0 "91.153.231.49" "2026-08-29 12:05:07" true "" "" "" "" "" "2026-08-29 12:05:07" null`] View formatted query View runnable query Explain query INSERT INTO entity_login_log ( user_id, applicant_id, is_applicant, position_id, login_ip, log_time, log_status, device_id, firebase_token, locale, o_auth_token, o_auth_type, created_at, updated_at ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO entity_login_log (user_id, applicant_id, is_applicant, position_id, login_ip, log_time, log_status, device_id, firebase_token, locale, o_auth_token, o_auth_type, created_at, updated_at) VALUES ('54', '54', 1, 0, '91.153.231.49', '2026-08-29 12:05:07', 1, '', '', '', '', '', '2026-08-29 12:05:07', NULL);
7	0.18 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
8	1.05 ms	SELECT t0.id AS id_1, t0.anon_token AS anon_token_2, t0.share_token AS share_token_3, t0.applicant_id AS applicant_id_4, t0.email AS email_5, t0.title AS title_6, t0.address AS address_7, t0.lat AS lat_8, t0.lng AS lng_9, t0.inputs_json AS inputs_json_10, t0.estimate_json AS estimate_json_11, t0.report_json AS report_json_12, t0.design_json AS design_json_13, t0.status AS status_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.attached_at AS attached_at_17, t0.report_at AS report_at_18, t0.converted_app_id AS converted_app_id_19, t0.converted_ref AS converted_ref_20, t0.converted_at AS converted_at_21 FROM hb360_project t0 WHERE t0.anon_token = ? AND t0.status = ? Parameters: [`"4abd89efb20d0dc037aca46ac5c2e025266a8ed13b9baa3e" "anon"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.anon_token AS anon_token_2, t0.share_token AS share_token_3, t0.applicant_id AS applicant_id_4, t0.email AS email_5, t0.title AS title_6, t0.address AS address_7, t0.lat AS lat_8, t0.lng AS lng_9, t0.inputs_json AS inputs_json_10, t0.estimate_json AS estimate_json_11, t0.report_json AS report_json_12, t0.design_json AS design_json_13, t0.status AS status_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.attached_at AS attached_at_17, t0.report_at AS report_at_18, t0.converted_app_id AS converted_app_id_19, t0.converted_ref AS converted_ref_20, t0.converted_at AS converted_at_21 FROM hb360_project t0 WHERE t0.anon_token = ? AND t0.status = ? SELECT t0.id AS id_1, t0.anon_token AS anon_token_2, t0.share_token AS share_token_3, t0.applicant_id AS applicant_id_4, t0.email AS email_5, t0.title AS title_6, t0.address AS address_7, t0.lat AS lat_8, t0.lng AS lng_9, t0.inputs_json AS inputs_json_10, t0.estimate_json AS estimate_json_11, t0.report_json AS report_json_12, t0.design_json AS design_json_13, t0.status AS status_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.attached_at AS attached_at_17, t0.report_at AS report_at_18, t0.converted_app_id AS converted_app_id_19, t0.converted_ref AS converted_ref_20, t0.converted_at AS converted_at_21 FROM hb360_project t0 WHERE t0.anon_token = '4abd89efb20d0dc037aca46ac5c2e025266a8ed13b9baa3e' AND t0.status = 'anon';
9	0.44 ms	SELECT t0.id AS id_1, t0.organization_id AS organization_id_2, t0.app_id AS app_id_3, t0.applicant_id AS applicant_id_4, t0.user_type AS user_type_5, t0.role AS role_6, t0.status AS status_7, t0.erp_entity_type AS erp_entity_type_8, t0.erp_entity_id AS erp_entity_id_9, t0.source AS source_10, t0.metadata_json AS metadata_json_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM entity_organization_user_access t0 WHERE t0.applicant_id = ? AND t0.status = ? AND t0.user_type = ? AND t0.erp_entity_type = ? Parameters: [`54 "active" 4 "customer"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.organization_id AS organization_id_2, t0.app_id AS app_id_3, t0.applicant_id AS applicant_id_4, t0.user_type AS user_type_5, t0.role AS role_6, t0.status AS status_7, t0.erp_entity_type AS erp_entity_type_8, t0.erp_entity_id AS erp_entity_id_9, t0.source AS source_10, t0.metadata_json AS metadata_json_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM entity_organization_user_access t0 WHERE t0.applicant_id = ? AND t0.status = ? AND t0.user_type = ? AND t0.erp_entity_type = ? SELECT t0.id AS id_1, t0.organization_id AS organization_id_2, t0.app_id AS app_id_3, t0.applicant_id AS applicant_id_4, t0.user_type AS user_type_5, t0.role AS role_6, t0.status AS status_7, t0.erp_entity_type AS erp_entity_type_8, t0.erp_entity_id AS erp_entity_id_9, t0.source AS source_10, t0.metadata_json AS metadata_json_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM entity_organization_user_access t0 WHERE t0.applicant_id = 54 AND t0.status = 'active' AND t0.user_type = 4 AND t0.erp_entity_type = 'customer';
10	0.21 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
11	1.52 ms	INSERT INTO entity_token_storage (session_data, token, fire_base_token, user_id, user_type, expires_at, perpetual, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["{"userId":"54","userEmployeeId":0,"applicantId":"54","userCurrentTaskId":0,"currentPlanningItemId":0,"userHolidayListCurrentMonth":"[]","userHolidayCalendarId":0,"supplierId":0,"clientId":0,"userType":8,"userTypeName":"Applicant","last_settings_updated_ts":"1709528898","isConsultant":0,"isBuddybeeRetailer":0,"buddybeeRetailerLevel":0,"buddybeeAdminLevel":100,"isBuddybeeModerator":0,"isBuddybeeAdmin":1,"userCompanyLocale":"en","userEmail":"","userImage":"","userName":"Emrul Hasan","userDefaultRoute":"applicant_dashboard","userCompanyId":0,"userCompanyIdList":"[]","userCompanyNameList":"[]","userCompanyImageList":"[]","userAppId":0,"userPositionList":"[]","allModuleAccessFlag":0,"sessionSalt":"13759104736a927693b5427","applicationSecret":"756630af84937eefcb2843b19ef56c1e128b40d7","userGocId":0,"productNameDisplayType":0,"userNotificationEnabled":1,"userNotificationServer":"https:\/\/ourhoneybee.xyz","userLoginId":"43318","userCurrentPosition":0,"userRouteList":"[]","userProhibitList":"[]","relevantRequiredPromptFields":"[\"email\",\"phone\",\"currentCountryId\",\"preferredConsultancyTopicCountryIds\"]","triggerPromptInfoModalFlag":1,"TRIGGER_RESET_PASSWORD":0,"IS_EMAIL_VERIFIED":1,"REMEMBERME":0,"BUDDYBEE_BALANCE":0,"BUDDYBEE_COIN_BALANCE":0,"oAuthToken":"","locale":"","firebaseToken":"","token":"7OMI2QP6FX1787983507","firstLogin":0,"oAuthImage":"","appIdList":"\"\"","branchIdList":"\"\"","branchId":0,"companyIdListByAppId":"[]","companyNameListByAppId":"[]","companyImageListByAppId":"[]","userCompanyDarkVibrantList":"[]","userCompanyVibrantList":"[]","userCompanyLightVibrantList":"[]","userAccessList":[{"userType":1,"userTypeName":"Admin","globalId":"54","serverId":1,"serverUrl":"https:\/\/www.ourhoneybee.xyz","serverPort":"80","systemType":"_ERP_","companyId":1,"appId":1,"companyLogoUrl":"\/uploads\/CompanyImage\/company_image1.png","companyName":"HoneyBee IoT Limited","authenticationStr":"_Ka1g0rx_8RZJRXBlKNRabSnZmbYHLbRUTM92gI4P6JRJqWC8lcz6z9lLJmu1TiWxGmMwNIxJgYECeXEjX_IqVT5mssK672tUtVI3ydA_Y58GJ0j-IZMDlyB8R-Guwh6","userCompanyList":[]},{"userType":1,"userTypeName":"Admin","globalId":"54","serverId":1,"serverUrl":"https:\/\/www.ourhoneybee.xyz","serverPort":"80","systemType":"_ERP_","companyId":1,"appId":421,"companyLogoUrl":"\/uploads\/CompanyImage\/company_image421.jpeg","companyName":"Raach Solar Projects (BD) Ltd","authenticationStr":"_Ka1g0rx_8RZJRXBlKNRabSnZmbYHLbRUTM92gI4P6JRJqWC8lcz6z9gMorjgi2L1W-dx8U5MQJSVvbSniaZuVXIke8WueK-RMYRjjdBzIVYBKMn24IDUVz6tzOLuENpiLk","userCompanyList":[]},{"userType":1,"userTypeName":"Admin","globalId":"54","serverId":1,"serverUrl":"https:\/\/www.ourhoneybee.xyz","serverPort":"80","systemType":"_ERP_","companyId":1,"appId":450,"companyLogoUrl":"\/uploads\/CompanyImage\/company_image450.jpeg","companyName":"RAACH SOLAR PROJECTS GmbH","authenticationStr":"_Ka1g0rx_8RZJRXBlKNRabSnZmbYHLbRUTM92gI4P6JRJqWC8lcz6z9gNYvjgi2L1W-dx8U5MQJSVvbSniaZuVXIke8WueK-RMYRjjdBzIVYBKMn24IDUVz6tzOLuENpiLk","userCompanyList":[]},{"userType":1,"userTypeName":"Admin","globalId":"54","serverId":5,"serverUrl":"https:\/\/sg.ourhoneybee.xyz","serverPort":"443","systemType":"_ERP_","companyId":1,"appId":9001,"companyLogoUrl":"\/uploads\/CompanyImage\/company_image9001.jpeg","companyName":"NETZERO SYSTEMS (PTE.) LTD.","authenticationStr":"_Ka1g0rx_8RZJRXBlKNRabSnZmbYHLbRUTM92gI4P6JRJqWC8lcz6z9tMIv-jG6f1HOQzN8kOwBHR7HKlTuX7lPehsk7sPf5XM0MgGBH2pJ-Kaoy8K0PWRvir1CusUduxOZo","userCompanyList":[]},{"userType":2,"userTypeName":"General","globalId":"54","serverId":1,"serverUrl":"https:\/\/development.ourhoneybee.xyz","serverPort":"80","systemType":"_ERP_","companyId":1,"appId":425,"companyLogoUrl":"\/uploads\/CompanyImage\/company_image425.png","companyName":"General Development Test (BD)","authenticationStr":"_Ka1g0rx_8RZJRXBlKNRabSnZmbYHLbRUTM92gI4P6JRJqWC8lcz6z9gMo7jgi2L1W-dx8U5MQJSVvbSniaZuVXIke8WueK-RMURjjdBzIVYBKMn24IDUVz6tzWKu091y6g3Aw","userCompanyList":[]},{"userType":"1","userTypeName":"Admin","globalId":"54","serverId":5,"serverUrl":"https:\/\/sg.ourhoneybee.xyz","serverPort":"","systemType":"_ERP_","companyId":1,"appId":9103,"companyLogoUrl":"\/uploads\/CompanyImage\/company_image9103.png","companyName":"HoneyBee IoT Pte Ltd.","authenticationStr":"_Ka1g0rx_8RZJRXBlKNRabSnZmbYHLbRUTM92gI4P6JRJqWC8lcz6z9tMYv8jG6f1HOQzN8kOwBHR7HKlTuX7lPehsk7sPf5XM0fnWAei4J_GKEW7JMLeh-t8FDV92tjx617XMY","userCompanyList":[]},{"userType":1,"userTypeName":"Admin","globalId":"54","serverId":5,"serverUrl":"https:\/\/sg.ourhoneybee.xyz","serverPort":"","systemType":"_ERP_","companyId":1,"appId":9275,"companyLogoUrl":null,"companyName":"Netzero 2.0","authenticationStr":"_Ka1g0rx_8RZJRXBlKNRabSnZmbYHLbRUTM92gI4P6JRJqWC8lcz6z9tMoz6jG6f1HOQzN8kOwBHR7HKlTuX7lPehsk7sPf5XM0MgGBH2pJ-Kaoy8K0PWRvir1CusUduxOZo","userCompanyList":[]}]}" "7OMI2QP6FX1787983507" "" "54" 8 null null "2026-08-29 12:05:07" null] View formatted query View runnable query Explain query INSERT INTO entity_token_storage ( session_data, token, fire_base_token, user_id, user_type, expires_at, perpetual, created_at, updated_at ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO entity_token_storage (session_data, token, fire_base_token, user_id, user_type, expires_at, perpetual, created_at, updated_at) VALUES ('{\"userId\":\"54\",\"userEmployeeId\":0,\"applicantId\":\"54\",\"userCurrentTaskId\":0,\"currentPlanningItemId\":0,\"userHolidayListCurrentMonth\":\"[]\",\"userHolidayCalendarId\":0,\"supplierId\":0,\"clientId\":0,\"userType\":8,\"userTypeName\":\"Applicant\",\"last_settings_updated_ts\":\"1709528898\",\"isConsultant\":0,\"isBuddybeeRetailer\":0,\"buddybeeRetailerLevel\":0,\"buddybeeAdminLevel\":100,\"isBuddybeeModerator\":0,\"isBuddybeeAdmin\":1,\"userCompanyLocale\":\"en\",\"userEmail\":\"\",\"userImage\":\"\",\"userName\":\"Emrul Hasan\",\"userDefaultRoute\":\"applicant_dashboard\",\"userCompanyId\":0,\"userCompanyIdList\":\"[]\",\"userCompanyNameList\":\"[]\",\"userCompanyImageList\":\"[]\",\"userAppId\":0,\"userPositionList\":\"[]\",\"allModuleAccessFlag\":0,\"sessionSalt\":\"13759104736a927693b5427\",\"applicationSecret\":\"756630af84937eefcb2843b19ef56c1e128b40d7\",\"userGocId\":0,\"productNameDisplayType\":0,\"userNotificationEnabled\":1,\"userNotificationServer\":\"https:\\/\\/ourhoneybee.xyz\",\"userLoginId\":\"43318\",\"userCurrentPosition\":0,\"userRouteList\":\"[]\",\"userProhibitList\":\"[]\",\"relevantRequiredPromptFields\":\"[\\\"email\\\",\\\"phone\\\",\\\"currentCountryId\\\",\\\"preferredConsultancyTopicCountryIds\\\"]\",\"triggerPromptInfoModalFlag\":1,\"TRIGGER_RESET_PASSWORD\":0,\"IS_EMAIL_VERIFIED\":1,\"REMEMBERME\":0,\"BUDDYBEE_BALANCE\":0,\"BUDDYBEE_COIN_BALANCE\":0,\"oAuthToken\":\"\",\"locale\":\"\",\"firebaseToken\":\"\",\"token\":\"7OMI2QP6FX1787983507\",\"firstLogin\":0,\"oAuthImage\":\"\",\"appIdList\":\"\\\"\\\"\",\"branchIdList\":\"\\\"\\\"\",\"branchId\":0,\"companyIdListByAppId\":\"[]\",\"companyNameListByAppId\":\"[]\",\"companyImageListByAppId\":\"[]\",\"userCompanyDarkVibrantList\":\"[]\",\"userCompanyVibrantList\":\"[]\",\"userCompanyLightVibrantList\":\"[]\",\"userAccessList\":[{\"userType\":1,\"userTypeName\":\"Admin\",\"globalId\":\"54\",\"serverId\":1,\"serverUrl\":\"https:\\/\\/www.ourhoneybee.xyz\",\"serverPort\":\"80\",\"systemType\":\"_ERP_\",\"companyId\":1,\"appId\":1,\"companyLogoUrl\":\"\\/uploads\\/CompanyImage\\/company_image1.png\",\"companyName\":\"HoneyBee IoT Limited\",\"authenticationStr\":\"_Ka1g0rx_8RZJRXBlKNRabSnZmbYHLbRUTM92gI4P6JRJqWC8lcz6z9lLJmu1TiWxGmMwNIxJgYECeXEjX_IqVT5mssK672tUtVI3ydA_Y58GJ0j-IZMDlyB8R-Guwh6\",\"userCompanyList\":[]},{\"userType\":1,\"userTypeName\":\"Admin\",\"globalId\":\"54\",\"serverId\":1,\"serverUrl\":\"https:\\/\\/www.ourhoneybee.xyz\",\"serverPort\":\"80\",\"systemType\":\"_ERP_\",\"companyId\":1,\"appId\":421,\"companyLogoUrl\":\"\\/uploads\\/CompanyImage\\/company_image421.jpeg\",\"companyName\":\"Raach Solar Projects (BD) Ltd\",\"authenticationStr\":\"_Ka1g0rx_8RZJRXBlKNRabSnZmbYHLbRUTM92gI4P6JRJqWC8lcz6z9gMorjgi2L1W-dx8U5MQJSVvbSniaZuVXIke8WueK-RMYRjjdBzIVYBKMn24IDUVz6tzOLuENpiLk\",\"userCompanyList\":[]},{\"userType\":1,\"userTypeName\":\"Admin\",\"globalId\":\"54\",\"serverId\":1,\"serverUrl\":\"https:\\/\\/www.ourhoneybee.xyz\",\"serverPort\":\"80\",\"systemType\":\"_ERP_\",\"companyId\":1,\"appId\":450,\"companyLogoUrl\":\"\\/uploads\\/CompanyImage\\/company_image450.jpeg\",\"companyName\":\"RAACH SOLAR PROJECTS GmbH\",\"authenticationStr\":\"_Ka1g0rx_8RZJRXBlKNRabSnZmbYHLbRUTM92gI4P6JRJqWC8lcz6z9gNYvjgi2L1W-dx8U5MQJSVvbSniaZuVXIke8WueK-RMYRjjdBzIVYBKMn24IDUVz6tzOLuENpiLk\",\"userCompanyList\":[]},{\"userType\":1,\"userTypeName\":\"Admin\",\"globalId\":\"54\",\"serverId\":5,\"serverUrl\":\"https:\\/\\/sg.ourhoneybee.xyz\",\"serverPort\":\"443\",\"systemType\":\"_ERP_\",\"companyId\":1,\"appId\":9001,\"companyLogoUrl\":\"\\/uploads\\/CompanyImage\\/company_image9001.jpeg\",\"companyName\":\"NETZERO SYSTEMS (PTE.) LTD.\",\"authenticationStr\":\"_Ka1g0rx_8RZJRXBlKNRabSnZmbYHLbRUTM92gI4P6JRJqWC8lcz6z9tMIv-jG6f1HOQzN8kOwBHR7HKlTuX7lPehsk7sPf5XM0MgGBH2pJ-Kaoy8K0PWRvir1CusUduxOZo\",\"userCompanyList\":[]},{\"userType\":2,\"userTypeName\":\"General\",\"globalId\":\"54\",\"serverId\":1,\"serverUrl\":\"https:\\/\\/development.ourhoneybee.xyz\",\"serverPort\":\"80\",\"systemType\":\"_ERP_\",\"companyId\":1,\"appId\":425,\"companyLogoUrl\":\"\\/uploads\\/CompanyImage\\/company_image425.png\",\"companyName\":\"General Development Test (BD)\",\"authenticationStr\":\"_Ka1g0rx_8RZJRXBlKNRabSnZmbYHLbRUTM92gI4P6JRJqWC8lcz6z9gMo7jgi2L1W-dx8U5MQJSVvbSniaZuVXIke8WueK-RMURjjdBzIVYBKMn24IDUVz6tzWKu091y6g3Aw\",\"userCompanyList\":[]},{\"userType\":\"1\",\"userTypeName\":\"Admin\",\"globalId\":\"54\",\"serverId\":5,\"serverUrl\":\"https:\\/\\/sg.ourhoneybee.xyz\",\"serverPort\":\"\",\"systemType\":\"_ERP_\",\"companyId\":1,\"appId\":9103,\"companyLogoUrl\":\"\\/uploads\\/CompanyImage\\/company_image9103.png\",\"companyName\":\"HoneyBee IoT Pte Ltd.\",\"authenticationStr\":\"_Ka1g0rx_8RZJRXBlKNRabSnZmbYHLbRUTM92gI4P6JRJqWC8lcz6z9tMYv8jG6f1HOQzN8kOwBHR7HKlTuX7lPehsk7sPf5XM0fnWAei4J_GKEW7JMLeh-t8FDV92tjx617XMY\",\"userCompanyList\":[]},{\"userType\":1,\"userTypeName\":\"Admin\",\"globalId\":\"54\",\"serverId\":5,\"serverUrl\":\"https:\\/\\/sg.ourhoneybee.xyz\",\"serverPort\":\"\",\"systemType\":\"_ERP_\",\"companyId\":1,\"appId\":9275,\"companyLogoUrl\":null,\"companyName\":\"Netzero 2.0\",\"authenticationStr\":\"_Ka1g0rx_8RZJRXBlKNRabSnZmbYHLbRUTM92gI4P6JRJqWC8lcz6z9tMoz6jG6f1HOQzN8kOwBHR7HKlTuX7lPehsk7sPf5XM0MgGBH2pJ-Kaoy8K0PWRvir1CusUduxOZo\",\"userCompanyList\":[]}]}', '7OMI2QP6FX1787983507', '', '54', 8, NULL, NULL, '2026-08-29 12:05:07', NULL);
12	0.18 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
13	0.21 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
14	0.45 ms	UPDATE entity_token_storage SET expires_at = ?, updated_at = ? WHERE id = ? Parameters: [`"2026-08-30 12:05:07" "2026-08-29 12:05:07" "43286"`] View formatted query View runnable query Explain query UPDATE entity_token_storage SET expires_at = ?, updated_at = ? WHERE id = ? UPDATE entity_token_storage SET expires_at = '2026-08-30 12:05:07', updated_at = '2026-08-29 12:05:07' WHERE id = '43286';
15	0.19 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
16	26.49 ms	DELETE FROM entity_token_storage WHERE ( perpetual !=1 ) AND expires_at < NOW(); Parameters: [] View formatted query View runnable query Explain query DELETE FROM entity_token_storage WHERE (perpetual != 1) AND expires_at < NOW(); DELETE FROM entity_token_storage WHERE ( perpetual !=1 ) AND expires_at < NOW(); ;

default connection

#▲	Time	Info
1	0.36 ms	SELECT data FROM acc_setting WHERE name = 'cors_extra_origins' ORDER BY id DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT data FROM acc_setting WHERE name = 'cors_extra_origins' ORDER BY id DESC LIMIT 1 SELECT data FROM acc_setting WHERE name = 'cors_extra_origins' ORDER BY id DESC LIMIT 1;

#▲

Time

Info

0.36 ms

SELECT data FROM acc_setting WHERE name = 'cors_extra_origins' ORDER BY id DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  data
FROM
  acc_setting
WHERE
  name = 'cors_extra_origins'
ORDER BY
  id DESC
LIMIT
  1

SELECT data FROM acc_setting WHERE name = 'cors_extra_origins' ORDER BY id DESC LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
company_group	doctrine.dbal.company_group_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
company_group	doctrine.orm.company_group_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

No loaded entities.

company_group entity manager

Class	Mapping errors
CompanyGroupBundle\Entity\EntityApplicantDetails	No errors.
CompanyGroupBundle\Entity\CompanyGroup	No errors.
CompanyGroupBundle\Entity\EntityLoginLog	No errors.
CompanyGroupBundle\Entity\Hb360Project	No errors.
CompanyGroupBundle\Entity\EntityOrganizationUserAccess	No errors.
CompanyGroupBundle\Entity\EntityTokenStorage	No errors.