| 1 |
0.79 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.emp_number AS emp_number_3, t0.url AS url_4, t0.first_name AS first_name_5, t0.second_name AS second_name_6, t0.full_name AS full_name_7, t0.index_no AS index_no_8, t0.email AS email_9, t0.username AS username_10, t0.description AS description_11, t0.password AS password_12, t0.nationality AS nationality_13, t0.study_medium AS study_medium_14, t0.birth_date AS birth_date_15, t0.nic AS nic_16, t0.code AS code_17, t0.sex AS sex_18, t0.address AS address_19, t0.tel AS tel_20, t0.mob AS mob_21, t0.sms_number AS sms_number_22, t0.lan_number AS lan_number_23, t0.sms_usage AS sms_usage_24, t0.stream AS stream_25, t0.exam_year AS exam_year_26, t0.dark_mode AS dark_mode_27, t0.id_paid AS id_paid_28, t0.id_delivered AS id_delivered_29, t0.id_stu_delivered AS id_stu_delivered_30, t0.id_stu_delivered_on AS id_stu_delivered_on_31, t0.id_printed AS id_printed_32, t0.box_id AS box_id_33, t0.send_sms AS send_sms_34, t0.sms_limit AS sms_limit_35, t0.admission AS admission_36, t0.join_date AS join_date_37, t0.image_path AS image_path_38, t0.media_folder AS media_folder_39, t0.last_sesson AS last_sesson_40, t0.raw_password AS raw_password_41, t0.permission AS permission_42, t0.lang AS lang_43, t0.lecturers AS lecturers_44, t0.custom_field1 AS custom_field1_45, t0.deduct AS deduct_46, t0.permissions AS permissions_47, t0.sms_code AS sms_code_48, t0.roles AS roles_49, t0.sms_code_exp AS sms_code_exp_50, t0.father_name AS father_name_51, t0.father_occupation AS father_occupation_52, t0.father_present_address AS father_present_address_53, t0.father_mobile_number AS father_mobile_number_54, t0.father_email AS father_email_55, t0.mother_name AS mother_name_56, t0.mother_occupation AS mother_occupation_57, t0.mother_present_address AS mother_present_address_58, t0.mother_mobile_number AS mother_mobile_number_59, t0.mother_email AS mother_email_60, t0.guardian_kinship AS guardian_kinship_61, t0.guardian_name AS guardian_name_62, t0.guardian_occupation AS guardian_occupation_63, t0.guardian_present_address AS guardian_present_address_64, t0.guardian_mobile_number AS guardian_mobile_number_65, t0.guardian_email AS guardian_email_66, t0.university AS university_67, t0.university_year AS university_year_68, t0.work_started_on AS work_started_on_69, t0.is_active AS is_active_70, t0.passport_number AS passport_number_71, t0.epf_number AS epf_number_72, t0.employment_type AS employment_type_73, t0.resignation_date AS resignation_date_74, t0.department_id AS department_id_75, t0.branch_id AS branch_id_76, t0.designation_id AS designation_id_77 FROM mynine_users t0 WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.title AS title_2,
t0.emp_number AS emp_number_3,
t0.url AS url_4,
t0.first_name AS first_name_5,
t0.second_name AS second_name_6,
t0.full_name AS full_name_7,
t0.index_no AS index_no_8,
t0.email AS email_9,
t0.username AS username_10,
t0.description AS description_11,
t0.password AS password_12,
t0.nationality AS nationality_13,
t0.study_medium AS study_medium_14,
t0.birth_date AS birth_date_15,
t0.nic AS nic_16,
t0.code AS code_17,
t0.sex AS sex_18,
t0.address AS address_19,
t0.tel AS tel_20,
t0.mob AS mob_21,
t0.sms_number AS sms_number_22,
t0.lan_number AS lan_number_23,
t0.sms_usage AS sms_usage_24,
t0.stream AS stream_25,
t0.exam_year AS exam_year_26,
t0.dark_mode AS dark_mode_27,
t0.id_paid AS id_paid_28,
t0.id_delivered AS id_delivered_29,
t0.id_stu_delivered AS id_stu_delivered_30,
t0.id_stu_delivered_on AS id_stu_delivered_on_31,
t0.id_printed AS id_printed_32,
t0.box_id AS box_id_33,
t0.send_sms AS send_sms_34,
t0.sms_limit AS sms_limit_35,
t0.admission AS admission_36,
t0.join_date AS join_date_37,
t0.image_path AS image_path_38,
t0.media_folder AS media_folder_39,
t0.last_sesson AS last_sesson_40,
t0.raw_password AS raw_password_41,
t0.permission AS permission_42,
t0.lang AS lang_43,
t0.lecturers AS lecturers_44,
t0.custom_field1 AS custom_field1_45,
t0.deduct AS deduct_46,
t0.permissions AS permissions_47,
t0.sms_code AS sms_code_48,
t0.roles AS roles_49,
t0.sms_code_exp AS sms_code_exp_50,
t0.father_name AS father_name_51,
t0.father_occupation AS father_occupation_52,
t0.father_present_address AS father_present_address_53,
t0.father_mobile_number AS father_mobile_number_54,
t0.father_email AS father_email_55,
t0.mother_name AS mother_name_56,
t0.mother_occupation AS mother_occupation_57,
t0.mother_present_address AS mother_present_address_58,
t0.mother_mobile_number AS mother_mobile_number_59,
t0.mother_email AS mother_email_60,
t0.guardian_kinship AS guardian_kinship_61,
t0.guardian_name AS guardian_name_62,
t0.guardian_occupation AS guardian_occupation_63,
t0.guardian_present_address AS guardian_present_address_64,
t0.guardian_mobile_number AS guardian_mobile_number_65,
t0.guardian_email AS guardian_email_66,
t0.university AS university_67,
t0.university_year AS university_year_68,
t0.work_started_on AS work_started_on_69,
t0.is_active AS is_active_70,
t0.passport_number AS passport_number_71,
t0.epf_number AS epf_number_72,
t0.employment_type AS employment_type_73,
t0.resignation_date AS resignation_date_74,
t0.department_id AS department_id_75,
t0.branch_id AS branch_id_76,
t0.designation_id AS designation_id_77
FROM
mynine_users t0
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.emp_number AS emp_number_3, t0.url AS url_4, t0.first_name AS first_name_5, t0.second_name AS second_name_6, t0.full_name AS full_name_7, t0.index_no AS index_no_8, t0.email AS email_9, t0.username AS username_10, t0.description AS description_11, t0.password AS password_12, t0.nationality AS nationality_13, t0.study_medium AS study_medium_14, t0.birth_date AS birth_date_15, t0.nic AS nic_16, t0.code AS code_17, t0.sex AS sex_18, t0.address AS address_19, t0.tel AS tel_20, t0.mob AS mob_21, t0.sms_number AS sms_number_22, t0.lan_number AS lan_number_23, t0.sms_usage AS sms_usage_24, t0.stream AS stream_25, t0.exam_year AS exam_year_26, t0.dark_mode AS dark_mode_27, t0.id_paid AS id_paid_28, t0.id_delivered AS id_delivered_29, t0.id_stu_delivered AS id_stu_delivered_30, t0.id_stu_delivered_on AS id_stu_delivered_on_31, t0.id_printed AS id_printed_32, t0.box_id AS box_id_33, t0.send_sms AS send_sms_34, t0.sms_limit AS sms_limit_35, t0.admission AS admission_36, t0.join_date AS join_date_37, t0.image_path AS image_path_38, t0.media_folder AS media_folder_39, t0.last_sesson AS last_sesson_40, t0.raw_password AS raw_password_41, t0.permission AS permission_42, t0.lang AS lang_43, t0.lecturers AS lecturers_44, t0.custom_field1 AS custom_field1_45, t0.deduct AS deduct_46, t0.permissions AS permissions_47, t0.sms_code AS sms_code_48, t0.roles AS roles_49, t0.sms_code_exp AS sms_code_exp_50, t0.father_name AS father_name_51, t0.father_occupation AS father_occupation_52, t0.father_present_address AS father_present_address_53, t0.father_mobile_number AS father_mobile_number_54, t0.father_email AS father_email_55, t0.mother_name AS mother_name_56, t0.mother_occupation AS mother_occupation_57, t0.mother_present_address AS mother_present_address_58, t0.mother_mobile_number AS mother_mobile_number_59, t0.mother_email AS mother_email_60, t0.guardian_kinship AS guardian_kinship_61, t0.guardian_name AS guardian_name_62, t0.guardian_occupation AS guardian_occupation_63, t0.guardian_present_address AS guardian_present_address_64, t0.guardian_mobile_number AS guardian_mobile_number_65, t0.guardian_email AS guardian_email_66, t0.university AS university_67, t0.university_year AS university_year_68, t0.work_started_on AS work_started_on_69, t0.is_active AS is_active_70, t0.passport_number AS passport_number_71, t0.epf_number AS epf_number_72, t0.employment_type AS employment_type_73, t0.resignation_date AS resignation_date_74, t0.department_id AS department_id_75, t0.branch_id AS branch_id_76, t0.designation_id AS designation_id_77 FROM mynine_users t0 WHERE t0.id = 1;
|
| 2 |
0.52 ms |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.business_key AS business_key_2, m0_.employee_prefix AS employee_prefix_3, m0_.legal_name AS legal_name_4, m0_.registration_number AS registration_number_5, m0_.logo AS logo_6, m0_.address_line1 AS address_line1_7, m0_.address_line2 AS address_line2_8, m0_.city AS city_9, m0_.district AS district_10, m0_.postal_code AS postal_code_11, m0_.country AS country_12, m0_.primary_contact_name AS primary_contact_name_13, m0_.primary_contact_phone AS primary_contact_phone_14, m0_.primary_contact_email AS primary_contact_email_15, m0_.general_phone AS general_phone_16, m0_.email AS email_17, m0_.website AS website_18, m0_.industry AS industry_19, m0_.timezone AS timezone_20, m0_.currency AS currency_21, m0_.status AS status_22, m0_.default_working_days AS default_working_days_23, m0_.default_work_start_time AS default_work_start_time_24, m0_.default_work_end_time AS default_work_end_time_25, m0_.payroll_frequency AS payroll_frequency_26, m0_.payroll_day AS payroll_day_27, m0_.epf_employer_number AS epf_employer_number_28, m0_.tax_identification_number AS tax_identification_number_29, m0_.sms_addon_enabled AS sms_addon_enabled_30, m0_.push_notifications_enabled AS push_notifications_enabled_31, m0_.sms_credits AS sms_credits_32, m0_.sms_features AS sms_features_33, m0_.subscription_package AS subscription_package_34, m0_.employee_limit AS employee_limit_35, m0_.annual_fee_per_employee AS annual_fee_per_employee_36, m0_.billing_currency AS billing_currency_37, m0_.free_trial_enabled AS free_trial_enabled_38, m0_.trial_start_date AS trial_start_date_39, m0_.trial_end_date AS trial_end_date_40, m0_.next_billing_date AS next_billing_date_41, m0_.created_at AS created_at_42, m0_.updated_at AS updated_at_43, m0_.created_by AS created_by_44 FROM mynine_business m0_ ORDER BY m0_.created_at DESC
SELECT
m0_.id AS id_0,
m0_.name AS name_1,
m0_.business_key AS business_key_2,
m0_.employee_prefix AS employee_prefix_3,
m0_.legal_name AS legal_name_4,
m0_.registration_number AS registration_number_5,
m0_.logo AS logo_6,
m0_.address_line1 AS address_line1_7,
m0_.address_line2 AS address_line2_8,
m0_.city AS city_9,
m0_.district AS district_10,
m0_.postal_code AS postal_code_11,
m0_.country AS country_12,
m0_.primary_contact_name AS primary_contact_name_13,
m0_.primary_contact_phone AS primary_contact_phone_14,
m0_.primary_contact_email AS primary_contact_email_15,
m0_.general_phone AS general_phone_16,
m0_.email AS email_17,
m0_.website AS website_18,
m0_.industry AS industry_19,
m0_.timezone AS timezone_20,
m0_.currency AS currency_21,
m0_.status AS status_22,
m0_.default_working_days AS default_working_days_23,
m0_.default_work_start_time AS default_work_start_time_24,
m0_.default_work_end_time AS default_work_end_time_25,
m0_.payroll_frequency AS payroll_frequency_26,
m0_.payroll_day AS payroll_day_27,
m0_.epf_employer_number AS epf_employer_number_28,
m0_.tax_identification_number AS tax_identification_number_29,
m0_.sms_addon_enabled AS sms_addon_enabled_30,
m0_.push_notifications_enabled AS push_notifications_enabled_31,
m0_.sms_credits AS sms_credits_32,
m0_.sms_features AS sms_features_33,
m0_.subscription_package AS subscription_package_34,
m0_.employee_limit AS employee_limit_35,
m0_.annual_fee_per_employee AS annual_fee_per_employee_36,
m0_.billing_currency AS billing_currency_37,
m0_.free_trial_enabled AS free_trial_enabled_38,
m0_.trial_start_date AS trial_start_date_39,
m0_.trial_end_date AS trial_end_date_40,
m0_.next_billing_date AS next_billing_date_41,
m0_.created_at AS created_at_42,
m0_.updated_at AS updated_at_43,
m0_.created_by AS created_by_44
FROM
mynine_business m0_
ORDER BY
m0_.created_at DESC
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.business_key AS business_key_2, m0_.employee_prefix AS employee_prefix_3, m0_.legal_name AS legal_name_4, m0_.registration_number AS registration_number_5, m0_.logo AS logo_6, m0_.address_line1 AS address_line1_7, m0_.address_line2 AS address_line2_8, m0_.city AS city_9, m0_.district AS district_10, m0_.postal_code AS postal_code_11, m0_.country AS country_12, m0_.primary_contact_name AS primary_contact_name_13, m0_.primary_contact_phone AS primary_contact_phone_14, m0_.primary_contact_email AS primary_contact_email_15, m0_.general_phone AS general_phone_16, m0_.email AS email_17, m0_.website AS website_18, m0_.industry AS industry_19, m0_.timezone AS timezone_20, m0_.currency AS currency_21, m0_.status AS status_22, m0_.default_working_days AS default_working_days_23, m0_.default_work_start_time AS default_work_start_time_24, m0_.default_work_end_time AS default_work_end_time_25, m0_.payroll_frequency AS payroll_frequency_26, m0_.payroll_day AS payroll_day_27, m0_.epf_employer_number AS epf_employer_number_28, m0_.tax_identification_number AS tax_identification_number_29, m0_.sms_addon_enabled AS sms_addon_enabled_30, m0_.push_notifications_enabled AS push_notifications_enabled_31, m0_.sms_credits AS sms_credits_32, m0_.sms_features AS sms_features_33, m0_.subscription_package AS subscription_package_34, m0_.employee_limit AS employee_limit_35, m0_.annual_fee_per_employee AS annual_fee_per_employee_36, m0_.billing_currency AS billing_currency_37, m0_.free_trial_enabled AS free_trial_enabled_38, m0_.trial_start_date AS trial_start_date_39, m0_.trial_end_date AS trial_end_date_40, m0_.next_billing_date AS next_billing_date_41, m0_.created_at AS created_at_42, m0_.updated_at AS updated_at_43, m0_.created_by AS created_by_44 FROM mynine_business m0_ ORDER BY m0_.created_at DESC;
|