Symfony Profiler

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;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.business_key AS business_key_3,
  t0.employee_prefix AS employee_prefix_4,
  t0.legal_name AS legal_name_5,
  t0.registration_number AS registration_number_6,
  t0.logo AS logo_7,
  t0.address_line1 AS address_line1_8,
  t0.address_line2 AS address_line2_9,
  t0.city AS city_10,
  t0.district AS district_11,
  t0.postal_code AS postal_code_12,
  t0.country AS country_13,
  t0.primary_contact_name AS primary_contact_name_14,
  t0.primary_contact_phone AS primary_contact_phone_15,
  t0.primary_contact_email AS primary_contact_email_16,
  t0.general_phone AS general_phone_17,
  t0.email AS email_18,
  t0.website AS website_19,
  t0.industry AS industry_20,
  t0.timezone AS timezone_21,
  t0.currency AS currency_22,
  t0.status AS status_23,
  t0.default_working_days AS default_working_days_24,
  t0.default_work_start_time AS default_work_start_time_25,
  t0.default_work_end_time AS default_work_end_time_26,
  t0.payroll_frequency AS payroll_frequency_27,
  t0.payroll_day AS payroll_day_28,
  t0.epf_employer_number AS epf_employer_number_29,
  t0.tax_identification_number AS tax_identification_number_30,
  t0.sms_addon_enabled AS sms_addon_enabled_31,
  t0.push_notifications_enabled AS push_notifications_enabled_32,
  t0.sms_credits AS sms_credits_33,
  t0.sms_features AS sms_features_34,
  t0.subscription_package AS subscription_package_35,
  t0.employee_limit AS employee_limit_36,
  t0.annual_fee_per_employee AS annual_fee_per_employee_37,
  t0.billing_currency AS billing_currency_38,
  t0.free_trial_enabled AS free_trial_enabled_39,
  t0.trial_start_date AS trial_start_date_40,
  t0.trial_end_date AS trial_end_date_41,
  t0.next_billing_date AS next_billing_date_42,
  t0.created_at AS created_at_43,
  t0.updated_at AS updated_at_44,
  t0.created_by AS created_by_45
FROM
  mynine_business t0
WHERE
  t0.business_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.business_key AS business_key_3, t0.employee_prefix AS employee_prefix_4, t0.legal_name AS legal_name_5, t0.registration_number AS registration_number_6, t0.logo AS logo_7, t0.address_line1 AS address_line1_8, t0.address_line2 AS address_line2_9, t0.city AS city_10, t0.district AS district_11, t0.postal_code AS postal_code_12, t0.country AS country_13, t0.primary_contact_name AS primary_contact_name_14, t0.primary_contact_phone AS primary_contact_phone_15, t0.primary_contact_email AS primary_contact_email_16, t0.general_phone AS general_phone_17, t0.email AS email_18, t0.website AS website_19, t0.industry AS industry_20, t0.timezone AS timezone_21, t0.currency AS currency_22, t0.status AS status_23, t0.default_working_days AS default_working_days_24, t0.default_work_start_time AS default_work_start_time_25, t0.default_work_end_time AS default_work_end_time_26, t0.payroll_frequency AS payroll_frequency_27, t0.payroll_day AS payroll_day_28, t0.epf_employer_number AS epf_employer_number_29, t0.tax_identification_number AS tax_identification_number_30, t0.sms_addon_enabled AS sms_addon_enabled_31, t0.push_notifications_enabled AS push_notifications_enabled_32, t0.sms_credits AS sms_credits_33, t0.sms_features AS sms_features_34, t0.subscription_package AS subscription_package_35, t0.employee_limit AS employee_limit_36, t0.annual_fee_per_employee AS annual_fee_per_employee_37, t0.billing_currency AS billing_currency_38, t0.free_trial_enabled AS free_trial_enabled_39, t0.trial_start_date AS trial_start_date_40, t0.trial_end_date AS trial_end_date_41, t0.next_billing_date AS next_billing_date_42, t0.created_at AS created_at_43, t0.updated_at AS updated_at_44, t0.created_by AS created_by_45 FROM mynine_business t0 WHERE t0.business_key = 'CRIHNO6XCH' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.employee_number AS employee_number_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.display_name AS display_name_5,
  t0.nic AS nic_6,
  t0.passport_number AS passport_number_7,
  t0.photo AS photo_8,
  t0.mobile AS mobile_9,
  t0.email AS email_10,
  t0.address AS address_11,
  t0.emergency_contact_name AS emergency_contact_name_12,
  t0.emergency_contact_phone AS emergency_contact_phone_13,
  t0.employment_type AS employment_type_14,
  t0.work_mode AS work_mode_15,
  t0.joining_date AS joining_date_16,
  t0.leaving_date AS leaving_date_17,
  t0.status AS status_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.business_id AS business_id_21,
  t0.user_id AS user_id_22,
  t0.department_id AS department_id_23,
  t0.designation_id AS designation_id_24,
  t0.role_id AS role_id_25,
  t0.reporting_manager_id AS reporting_manager_id_26,
  t0.default_work_location_id AS default_work_location_id_27
FROM
  mynine_employee t0
WHERE
  t0.id = ?
  AND t0.business_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.employee_number AS employee_number_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.display_name AS display_name_5, t0.nic AS nic_6, t0.passport_number AS passport_number_7, t0.photo AS photo_8, t0.mobile AS mobile_9, t0.email AS email_10, t0.address AS address_11, t0.emergency_contact_name AS emergency_contact_name_12, t0.emergency_contact_phone AS emergency_contact_phone_13, t0.employment_type AS employment_type_14, t0.work_mode AS work_mode_15, t0.joining_date AS joining_date_16, t0.leaving_date AS leaving_date_17, t0.status AS status_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.business_id AS business_id_21, t0.user_id AS user_id_22, t0.department_id AS department_id_23, t0.designation_id AS designation_id_24, t0.role_id AS role_id_25, t0.reporting_manager_id AS reporting_manager_id_26, t0.default_work_location_id AS default_work_location_id_27 FROM mynine_employee t0 WHERE t0.id = 1 AND t0.business_id = 1 LIMIT 1;

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

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.code AS code_2,
  m0_.active AS active_3,
  m0_.business_id AS business_id_4
FROM
  mynine_department m0_
WHERE
  (
    m0_.business_id IS NULL
    OR m0_.business_id = ?
  )
  AND m0_.active = 1
ORDER BY
  m0_.name ASC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.code AS code_2, m0_.active AS active_3, m0_.business_id AS business_id_4 FROM mynine_department m0_ WHERE (m0_.business_id IS NULL OR m0_.business_id = 1) AND m0_.active = 1 ORDER BY m0_.name ASC;

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.active AS active_2,
  m0_.business_id AS business_id_3
FROM
  mynine_designation m0_
WHERE
  (
    m0_.business_id IS NULL
    OR m0_.business_id = ?
  )
  AND m0_.active = 1
ORDER BY
  m0_.title ASC

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.active AS active_2, m0_.business_id AS business_id_3 FROM mynine_designation m0_ WHERE (m0_.business_id IS NULL OR m0_.business_id = 1) AND m0_.active = 1 ORDER BY m0_.title ASC;

SELECT
  m0_.id AS id_0,
  m0_.employee_number AS employee_number_1,
  m0_.first_name AS first_name_2,
  m0_.last_name AS last_name_3,
  m0_.display_name AS display_name_4,
  m0_.nic AS nic_5,
  m0_.passport_number AS passport_number_6,
  m0_.photo AS photo_7,
  m0_.mobile AS mobile_8,
  m0_.email AS email_9,
  m0_.address AS address_10,
  m0_.emergency_contact_name AS emergency_contact_name_11,
  m0_.emergency_contact_phone AS emergency_contact_phone_12,
  m0_.employment_type AS employment_type_13,
  m0_.work_mode AS work_mode_14,
  m0_.joining_date AS joining_date_15,
  m0_.leaving_date AS leaving_date_16,
  m0_.status AS status_17,
  m0_.created_at AS created_at_18,
  m0_.updated_at AS updated_at_19,
  m0_.business_id AS business_id_20,
  m0_.user_id AS user_id_21,
  m0_.department_id AS department_id_22,
  m0_.designation_id AS designation_id_23,
  m0_.role_id AS role_id_24,
  m0_.reporting_manager_id AS reporting_manager_id_25,
  m0_.default_work_location_id AS default_work_location_id_26
FROM
  mynine_employee m0_
WHERE
  m0_.business_id = ?
ORDER BY
  m0_.first_name ASC

SELECT m0_.id AS id_0, m0_.employee_number AS employee_number_1, m0_.first_name AS first_name_2, m0_.last_name AS last_name_3, m0_.display_name AS display_name_4, m0_.nic AS nic_5, m0_.passport_number AS passport_number_6, m0_.photo AS photo_7, m0_.mobile AS mobile_8, m0_.email AS email_9, m0_.address AS address_10, m0_.emergency_contact_name AS emergency_contact_name_11, m0_.emergency_contact_phone AS emergency_contact_phone_12, m0_.employment_type AS employment_type_13, m0_.work_mode AS work_mode_14, m0_.joining_date AS joining_date_15, m0_.leaving_date AS leaving_date_16, m0_.status AS status_17, m0_.created_at AS created_at_18, m0_.updated_at AS updated_at_19, m0_.business_id AS business_id_20, m0_.user_id AS user_id_21, m0_.department_id AS department_id_22, m0_.designation_id AS designation_id_23, m0_.role_id AS role_id_24, m0_.reporting_manager_id AS reporting_manager_id_25, m0_.default_work_location_id AS default_work_location_id_26 FROM mynine_employee m0_ WHERE m0_.business_id = 1 ORDER BY m0_.first_name ASC;

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.code AS code_2,
  m0_.address AS address_3,
  m0_.active AS active_4,
  m0_.business_id AS business_id_5
FROM
  mynine_branch m0_
WHERE
  m0_.business_id = ?
ORDER BY
  m0_.name ASC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.code AS code_2, m0_.address AS address_3, m0_.active AS active_4, m0_.business_id AS business_id_5 FROM mynine_branch m0_ WHERE m0_.business_id = 1 ORDER BY m0_.name ASC;

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.code AS code_2,
  m0_.active AS active_3,
  m0_.permissions AS permissions_4,
  m0_.business_id AS business_id_5
FROM
  mynine_employee_role m0_
WHERE
  m0_.business_id = ?
  AND m0_.active = 1
ORDER BY
  m0_.name ASC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.code AS code_2, m0_.active AS active_3, m0_.permissions AS permissions_4, m0_.business_id AS business_id_5 FROM mynine_employee_role m0_ WHERE m0_.business_id = 1 AND m0_.active = 1 ORDER BY m0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.active AS active_4,
  t0.permissions AS permissions_5,
  t0.business_id AS business_id_6
FROM
  mynine_employee_role t0
WHERE
  t0.business_id = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.active AS active_4, t0.permissions AS permissions_5, t0.business_id AS business_id_6 FROM mynine_employee_role t0 WHERE t0.business_id = 1 AND t0.active = 1 LIMIT 1;