SELECT 
  st.service_type_id, 
  st.title, 
  st.show_on_home, 
  st.show_in_account, 
  st.home_icon, 
  st.office_icon, 
  st.product_template_default, 
  st.office_offer_template_default, 
  st.office_table_template_default, 
  st.home_page_order, 
  st.user_office_order 
FROM 
  cscart_service_types AS st 
WHERE 
  1 
  AND st.show_on_home = 'Y' 
ORDER BY 
  st.home_page_order ASC

Query time 0.00079

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "st.home_page_order",
        "table": {
          "table_name": "st",
          "access_type": "ALL",
          "rows": 7,
          "filtered": 100,
          "attached_condition": "st.show_on_home = 'Y'"
        }
      }
    }
  }
}

Result

service_type_id title show_on_home show_in_account home_icon office_icon product_template_default office_offer_template_default office_table_template_default home_page_order user_office_order
2 Currency Y Y <svg width="40" height="40" viewBox="0 0 24 24" fill="black" xmlns="http://www.w3.org/2000/svg"> <path d="M12 2L2 8V20H22V8L12 2ZM4 9.3L12 4L20 9.3V18H4V9.3ZM10 12H14V16H10V12ZM7 12H9V16H7V12ZM15 12H17V16H15V12Z"/> </svg> <svg width="16" height="16" viewBox="0 0 24 24" fill="black" xmlns="http://www.w3.org/2000/svg"> <path d="M6 2L5 6H19L18 2H6ZM5 8V20C5 21.1 5.9 22 7 22H17C18.1 22 19 21.1 19 20V8H5ZM12 12C13.1 12 14 11.1 14 10H10C10 11.1 10.9 12 12 12Z"/> </svg> currency currency currency 1 1
3 Boost Y Y <svg width="40" height="40" viewBox="0 0 24 24" fill="black" xmlns="http://www.w3.org/2000/svg"> <path d="M12 2L2 8V20H22V8L12 2ZM4 9.3L12 4L20 9.3V18H4V9.3ZM10 12H14V16H10V12ZM7 12H9V16H7V12ZM15 12H17V16H15V12Z"/> </svg> <svg width="16" height="16" viewBox="0 0 24 24" fill="black" xmlns="http://www.w3.org/2000/svg"> <path d="M6 2L5 6H19L18 2H6ZM5 8V20C5 21.1 5.9 22 7 22H17C18.1 22 19 21.1 19 20V8H5ZM12 12C13.1 12 14 11.1 14 10H10C10 11.1 10.9 12 12 12Z"/> </svg> boost boost boost 2 3
1 Items Y Y <svg width="40" height="40" viewBox="0 0 24 24" fill="black" xmlns="http://www.w3.org/2000/svg"> <path d="M12 2L2 8V20H22V8L12 2ZM4 9.3L12 4L20 9.3V18H4V9.3ZM10 12H14V16H10V12ZM7 12H9V16H7V12ZM15 12H17V16H15V12Z"/> </svg> <svg width="16" height="16" viewBox="0 0 24 24" fill="black" xmlns="http://www.w3.org/2000/svg"> <path d="M6 2L5 6H19L18 2H6ZM5 8V20C5 21.1 5.9 22 7 22H17C18.1 22 19 21.1 19 20V8H5ZM12 12C13.1 12 14 11.1 14 10H10C10 11.1 10.9 12 12 12Z"/> </svg> boost boost boost 3 2
5 Game Keys Y N <svg width="40" height="40" viewBox="0 0 24 24" fill="black" xmlns="http://www.w3.org/2000/svg"> <path d="M12 2L2 8V20H22V8L12 2ZM4 9.3L12 4L20 9.3V18H4V9.3ZM10 12H14V16H10V12ZM7 12H9V16H7V12ZM15 12H17V16H15V12Z"/> </svg> <svg width="16" height="16" viewBox="0 0 24 24" fill="black" xmlns="http://www.w3.org/2000/svg"> <path d="M6 2L5 6H19L18 2H6ZM5 8V20C5 21.1 5.9 22 7 22H17C18.1 22 19 21.1 19 20V8H5ZM12 12C13.1 12 14 11.1 14 10H10C10 11.1 10.9 12 12 12Z"/> </svg> boost boost boost 4 0
6 Gift Cards Y N <svg width="40" height="40" viewBox="0 0 24 24" fill="black" xmlns="http://www.w3.org/2000/svg"> <path d="M12 2L2 8V20H22V8L12 2ZM4 9.3L12 4L20 9.3V18H4V9.3ZM10 12H14V16H10V12ZM7 12H9V16H7V12ZM15 12H17V16H15V12Z"/> </svg> <svg width="16" height="16" viewBox="0 0 24 24" fill="black" xmlns="http://www.w3.org/2000/svg"> <path d="M6 2L5 6H19L18 2H6ZM5 8V20C5 21.1 5.9 22 7 22H17C18.1 22 19 21.1 19 20V8H5ZM12 12C13.1 12 14 11.1 14 10H10C10 11.1 10.9 12 12 12Z"/> </svg> boost boost boost 5 0
7 Accounts Y N <svg width="40" height="40" viewBox="0 0 24 24" fill="black" xmlns="http://www.w3.org/2000/svg"> <path d="M12 2L2 8V20H22V8L12 2ZM4 9.3L12 4L20 9.3V18H4V9.3ZM10 12H14V16H10V12ZM7 12H9V16H7V12ZM15 12H17V16H15V12Z"/> </svg> <svg width="16" height="16" viewBox="0 0 24 24" fill="black" xmlns="http://www.w3.org/2000/svg"> <path d="M6 2L5 6H19L18 2H6ZM5 8V20C5 21.1 5.9 22 7 22H17C18.1 22 19 21.1 19 20V8H5ZM12 12C13.1 12 14 11.1 14 10H10C10 11.1 10.9 12 12 12Z"/> </svg> boost boost boost 6 0
8 Skins Y N <svg width="40" height="40" viewBox="0 0 24 24" fill="black" xmlns="http://www.w3.org/2000/svg"> <path d="M12 2L2 8V20H22V8L12 2ZM4 9.3L12 4L20 9.3V18H4V9.3ZM10 12H14V16H10V12ZM7 12H9V16H7V12ZM15 12H17V16H15V12Z"/> </svg> <svg width="16" height="16" viewBox="0 0 24 24" fill="black" xmlns="http://www.w3.org/2000/svg"> <path d="M6 2L5 6H19L18 2H6ZM5 8V20C5 21.1 5.9 22 7 22H17C18.1 22 19 21.1 19 20V8H5ZM12 12C13.1 12 14 11.1 14 10H10C10 11.1 10.9 12 12 12Z"/> </svg> boost boost boost 7 0
9 Others Y N <svg width="40" height="40" viewBox="0 0 24 24" fill="black" xmlns="http://www.w3.org/2000/svg"> <path d="M12 2L2 8V20H22V8L12 2ZM4 9.3L12 4L20 9.3V18H4V9.3ZM10 12H14V16H10V12ZM7 12H9V16H7V12ZM15 12H17V16H15V12Z"/> </svg> <svg width="16" height="16" viewBox="0 0 24 24" fill="black" xmlns="http://www.w3.org/2000/svg"> <path d="M6 2L5 6H19L18 2H6ZM5 8V20C5 21.1 5.9 22 7 22H17C18.1 22 19 21.1 19 20V8H5ZM12 12C13.1 12 14 11.1 14 10H10C10 11.1 10.9 12 12 12Z"/> </svg> boost boost boost 8 0