SELECT 
  cscart_settings_sections.name, 
  cscart_settings_sections.section_id, 
  cscart_settings_sections.position, 
  cscart_settings_sections.type, 
  cscart_settings_sections.name as description, 
  CONCAT(
    'settings.manage?section_id=', cscart_settings_sections.name
  ) as href 
FROM 
  cscart_settings_sections 
WHERE 
  1 
  AND (
    FIND_IN_SET(
      'STOREFRONT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'VENDOR', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'ROOT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'ULT:STOREFRONT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'ULT:VENDOR', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'ULT:ROOT', cscart_settings_sections.edition_type
    )
  ) 
ORDER BY 
  cscart_settings_sections.position

Query time 0.00013

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_settings_sections.position",
        "table": {
          "table_name": "cscart_settings_sections",
          "access_type": "ALL",
          "rows": 89,
          "filtered": 100,
          "attached_condition": "find_in_set('STOREFRONT',cscart_settings_sections.edition_type) or find_in_set('VENDOR',cscart_settings_sections.edition_type) or find_in_set('ROOT',cscart_settings_sections.edition_type) or find_in_set('ULT:STOREFRONT',cscart_settings_sections.edition_type) or find_in_set('ULT:VENDOR',cscart_settings_sections.edition_type) or find_in_set('ULT:ROOT',cscart_settings_sections.edition_type)"
        }
      }
    }
  }
}

Result

name section_id position type description href
general 132 0 TAB general settings.manage?section_id=general
general 103 0 TAB general settings.manage?section_id=general
storefront_rest_api 102 0 ADDON storefront_rest_api settings.manage?section_id=storefront_rest_api
general 96 0 TAB general settings.manage?section_id=general
access_restrictions 95 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
recaptcha 100 0 ADDON recaptcha settings.manage?section_id=recaptcha
general 101 0 TAB general settings.manage?section_id=general
general 84 0 TAB general settings.manage?section_id=general
hw_top 83 0 ADDON hw_top settings.manage?section_id=hw_top
general 82 0 TAB general settings.manage?section_id=general
image_zoom 81 0 ADDON image_zoom settings.manage?section_id=image_zoom
general 80 0 TAB general settings.manage?section_id=general
chatclerk 79 0 ADDON chatclerk settings.manage?section_id=chatclerk
general 76 0 TAB general settings.manage?section_id=general
cart_st 75 0 ADDON cart_st settings.manage?section_id=cart_st
bestsellers 104 0 ADDON bestsellers settings.manage?section_id=bestsellers
general 105 0 TAB general settings.manage?section_id=general
product_reviews 131 0 ADDON product_reviews settings.manage?section_id=product_reviews
vendor_communication 129 0 ADDON vendor_communication settings.manage?section_id=vendor_communication
general 128 0 TAB general settings.manage?section_id=general
hybrid_auth 127 0 ADDON hybrid_auth settings.manage?section_id=hybrid_auth
general 124 0 TAB general settings.manage?section_id=general
pdf_documents 123 0 ADDON pdf_documents settings.manage?section_id=pdf_documents
general 122 0 TAB general settings.manage?section_id=general
step_by_step_checkout 121 0 ADDON step_by_step_checkout settings.manage?section_id=step_by_step_checkout
general 118 0 TAB general settings.manage?section_id=general
general 116 0 TAB general settings.manage?section_id=general
product_variations 115 0 ADDON product_variations settings.manage?section_id=product_variations
geo_maps 117 0 ADDON geo_maps settings.manage?section_id=geo_maps
general 108 0 TAB general settings.manage?section_id=general
suppliers 107 0 ADDON suppliers settings.manage?section_id=suppliers
social_buttons 65 0 ADDON social_buttons settings.manage?section_id=social_buttons
twitter 66 0 TAB twitter settings.manage?section_id=twitter
Emails 1 0 CORE Emails settings.manage?section_id=Emails
newsletters 34 0 ADDON newsletters settings.manage?section_id=newsletters
general 31 0 TAB general settings.manage?section_id=general
localization_jp 30 0 ADDON localization_jp settings.manage?section_id=localization_jp
products 23 0 TAB products settings.manage?section_id=products
discussion 22 0 ADDON discussion settings.manage?section_id=discussion
general 21 0 TAB general settings.manage?section_id=general
data_feeds 20 0 ADDON data_feeds settings.manage?section_id=data_feeds
general 19 0 TAB general settings.manage?section_id=general
banners 18 0 ADDON banners settings.manage?section_id=banners
Stores 17 0 CORE Stores settings.manage?section_id=Stores
Security 15 0 CORE Security settings.manage?section_id=Security
Upgrade_center 13 0 CORE Upgrade_center settings.manage?section_id=Upgrade_center
Image_verification 11 0 CORE Image_verification settings.manage?section_id=Image_verification
Company 5 0 CORE Company settings.manage?section_id=Company
general 35 0 TAB general settings.manage?section_id=general
paypal 137 0 ADDON paypal settings.manage?section_id=paypal
general 58 0 TAB general settings.manage?section_id=general
google_export 57 0 ADDON google_export settings.manage?section_id=google_export
replain 141 0 ADDON replain settings.manage?section_id=replain
general 142 0 TAB general settings.manage?section_id=general
general 54 0 TAB general settings.manage?section_id=general
reward_points 53 0 ADDON reward_points settings.manage?section_id=reward_points
general 52 0 TAB general settings.manage?section_id=general
rss_feed 51 0 ADDON rss_feed settings.manage?section_id=rss_feed
tags 139 0 ADDON tags settings.manage?section_id=tags
polls 38 0 ADDON polls settings.manage?section_id=polls
general 39 0 TAB general settings.manage?section_id=general
general 138 0 TAB general settings.manage?section_id=general
seo 47 0 ADDON seo settings.manage?section_id=seo
general 48 0 TAB general settings.manage?section_id=general
general 140 0 TAB general settings.manage?section_id=general
vendor_to_customer 130 10 TAB vendor_to_customer settings.manage?section_id=vendor_to_customer
yandex 119 10 TAB yandex settings.manage?section_id=yandex
forbidden_countries 114 10 TAB forbidden_countries settings.manage?section_id=forbidden_countries
newest 106 10 TAB newest settings.manage?section_id=newest
promotions 88 10 TAB promotions settings.manage?section_id=promotions
jp_holidays 32 10 TAB jp_holidays settings.manage?section_id=jp_holidays
categories 24 10 TAB categories settings.manage?section_id=categories
General 2 10 CORE General settings.manage?section_id=General
facebook 67 10 TAB facebook settings.manage?section_id=facebook
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
orders 25 20 TAB orders settings.manage?section_id=orders
jp_pdfinv_tab_name 33 20 TAB jp_pdfinv_tab_name settings.manage?section_id=jp_pdfinv_tab_name
vkontakte 68 20 TAB vkontakte settings.manage?section_id=vkontakte
google 120 20 TAB google settings.manage?section_id=google
yandex 97 35 TAB yandex settings.manage?section_id=yandex
Checkout 91 40 CORE Checkout settings.manage?section_id=Checkout
gift_registry 27 40 TAB gift_registry settings.manage?section_id=gift_registry
pinterest 90 40 TAB pinterest settings.manage?section_id=pinterest
pages 28 50 TAB pages settings.manage?section_id=pages
testimonials 29 60 TAB testimonials settings.manage?section_id=testimonials
Sitemap 8 80 CORE Sitemap settings.manage?section_id=Sitemap
Logging 12 100 CORE Logging settings.manage?section_id=Logging
Thumbnails 9 110 CORE Thumbnails settings.manage?section_id=Thumbnails
Reports 10 140 CORE Reports settings.manage?section_id=Reports