Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.app_id AS app_id_4,
  t0.country_id AS country_id_5,
  t0.locale AS locale_6,
  t0.company_hash AS company_hash_7,
  t0.company_unique_code AS company_unique_code_8,
  t0.contact_number AS contact_number_9,
  t0.email AS email_10,
  t0.enabled_module_id_list AS enabled_module_id_list_11,
  t0.company_type AS company_type_12,
  t0.usage_valid_upto_date AS usage_valid_upto_date_13,
  t0.usage_valid_upto_date_ts AS usage_valid_upto_date_ts_14,
  t0.post_dated_job_active AS post_dated_job_active_15,
  t0.address AS address_16,
  t0.shipping_address AS shipping_address_17,
  t0.sms_notification_enabled AS sms_notification_enabled_18,
  t0.sms_settings AS sms_settings_19,
  t0.lock_device_id_on_first_login_user AS lock_device_id_on_first_login_user_20,
  t0.lock_device_id_on_first_login_supplier AS lock_device_id_on_first_login_supplier_21,
  t0.lock_device_id_on_first_login_client AS lock_device_id_on_first_login_client_22,
  t0.dark_vibrant AS dark_vibrant_23,
  t0.light_vibrant AS light_vibrant_24,
  t0.vibrant AS vibrant_25,
  t0.billing_address AS billing_address_26,
  t0.motto AS motto_27,
  t0.invoice_footer AS invoice_footer_28,
  t0.general_footer AS general_footer_29,
  t0.company_bin AS company_bin_30,
  t0.company_tin AS company_tin_31,
  t0.company_reg AS company_reg_32,
  t0.company_tl AS company_tl_33,
  t0.ait_certificate_no AS ait_certificate_no_34,
  t0.uen AS uen_35,
  t0.ssic_code AS ssic_code_36,
  t0.incorporation_date AS incorporation_date_37,
  t0.financial_year_end AS financial_year_end_38,
  t0.user_allowed AS user_allowed_39,
  t0.user_allocated AS user_allocated_40,
  t0.user_remaining AS user_remaining_41,
  t0.admin_user_allowed AS admin_user_allowed_42,
  t0.admin_user_allocated AS admin_user_allocated_43,
  t0.admin_user_remaining AS admin_user_remaining_44,
  t0.me_str AS me_str_45,
  t0.cash AS cash_46,
  t0.bank AS bank_47,
  t0.sales AS sales_48,
  t0.asset AS asset_49,
  t0.liability AS liability_50,
  t0.expense AS expense_51,
  t0.revenue AS revenue_52,
  t0.payable AS payable_53,
  t0.receivable AS receivable_54,
  t0.net_worth AS net_worth_55,
  t0.monthly_growth AS monthly_growth_56,
  t0.wacc AS wacc_57,
  t0.active AS active_58,
  t0.company_status AS company_status_59,
  t0.package_type AS package_type_60,
  t0.subscription_expiry AS subscription_expiry_61,
  t0.last_activity_at AS last_activity_at_62,
  t0.company_description AS company_description_63,
  t0.created_at AS created_at_64,
  t0.updated_at AS updated_at_65,
  t0.doc_booked_flag AS doc_booked_flag_66,
  t0.time_stamp_of_form AS time_stamp_of_form_67
FROM
  company t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.app_id AS app_id_4, t0.country_id AS country_id_5, t0.locale AS locale_6, t0.company_hash AS company_hash_7, t0.company_unique_code AS company_unique_code_8, t0.contact_number AS contact_number_9, t0.email AS email_10, t0.enabled_module_id_list AS enabled_module_id_list_11, t0.company_type AS company_type_12, t0.usage_valid_upto_date AS usage_valid_upto_date_13, t0.usage_valid_upto_date_ts AS usage_valid_upto_date_ts_14, t0.post_dated_job_active AS post_dated_job_active_15, t0.address AS address_16, t0.shipping_address AS shipping_address_17, t0.sms_notification_enabled AS sms_notification_enabled_18, t0.sms_settings AS sms_settings_19, t0.lock_device_id_on_first_login_user AS lock_device_id_on_first_login_user_20, t0.lock_device_id_on_first_login_supplier AS lock_device_id_on_first_login_supplier_21, t0.lock_device_id_on_first_login_client AS lock_device_id_on_first_login_client_22, t0.dark_vibrant AS dark_vibrant_23, t0.light_vibrant AS light_vibrant_24, t0.vibrant AS vibrant_25, t0.billing_address AS billing_address_26, t0.motto AS motto_27, t0.invoice_footer AS invoice_footer_28, t0.general_footer AS general_footer_29, t0.company_bin AS company_bin_30, t0.company_tin AS company_tin_31, t0.company_reg AS company_reg_32, t0.company_tl AS company_tl_33, t0.ait_certificate_no AS ait_certificate_no_34, t0.uen AS uen_35, t0.ssic_code AS ssic_code_36, t0.incorporation_date AS incorporation_date_37, t0.financial_year_end AS financial_year_end_38, t0.user_allowed AS user_allowed_39, t0.user_allocated AS user_allocated_40, t0.user_remaining AS user_remaining_41, t0.admin_user_allowed AS admin_user_allowed_42, t0.admin_user_allocated AS admin_user_allocated_43, t0.admin_user_remaining AS admin_user_remaining_44, t0.me_str AS me_str_45, t0.cash AS cash_46, t0.bank AS bank_47, t0.sales AS sales_48, t0.asset AS asset_49, t0.liability AS liability_50, t0.expense AS expense_51, t0.revenue AS revenue_52, t0.payable AS payable_53, t0.receivable AS receivable_54, t0.net_worth AS net_worth_55, t0.monthly_growth AS monthly_growth_56, t0.wacc AS wacc_57, t0.active AS active_58, t0.company_status AS company_status_59, t0.package_type AS package_type_60, t0.subscription_expiry AS subscription_expiry_61, t0.last_activity_at AS last_activity_at_62, t0.company_description AS company_description_63, t0.created_at AS created_at_64, t0.updated_at AS updated_at_65, t0.doc_booked_flag AS doc_booked_flag_66, t0.time_stamp_of_form AS time_stamp_of_form_67 FROM company t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  *
FROM
  inv_product_categories
WHERE
  company_id = ?
  AND ig_id = ?
  AND (`name` LIKE ?)
LIMIT
  25

SELECT * FROM inv_product_categories WHERE company_id = 0  AND ig_id = 1 AND (`name` LIKE '%%')   LIMIT 25;