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(
      'ROOT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'MVE:STOREFRONT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'MVE:ROOT', cscart_settings_sections.edition_type
    )
  ) 
ORDER BY 
  cscart_settings_sections.position

Query time 0.00010

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": 56,
          "filtered": 100,
          "attached_condition": "find_in_set('STOREFRONT',cscart_settings_sections.edition_type) or find_in_set('ROOT',cscart_settings_sections.edition_type) or find_in_set('MVE:STOREFRONT',cscart_settings_sections.edition_type) or find_in_set('MVE:ROOT',cscart_settings_sections.edition_type)"
        }
      }
    }
  }
}

Result

name section_id position type description href
general 58 0 TAB general settings.manage?section_id=general
bestsellers 39 0 ADDON bestsellers settings.manage?section_id=bestsellers
general 38 0 TAB general settings.manage?section_id=general
product_variations 37 0 ADDON product_variations settings.manage?section_id=product_variations
general 35 0 TAB general settings.manage?section_id=general
recaptcha 34 0 ADDON recaptcha settings.manage?section_id=recaptcha
general 33 0 TAB general settings.manage?section_id=general
storefront_rest_api 32 0 ADDON storefront_rest_api settings.manage?section_id=storefront_rest_api
general 31 0 TAB general settings.manage?section_id=general
pdf_documents 30 0 ADDON pdf_documents settings.manage?section_id=pdf_documents
general 40 0 TAB general settings.manage?section_id=general
polls 42 0 ADDON polls settings.manage?section_id=polls
general 43 0 TAB general settings.manage?section_id=general
localization_jp 57 0 ADDON localization_jp settings.manage?section_id=localization_jp
general 56 0 TAB general settings.manage?section_id=general
data_feeds 55 0 ADDON data_feeds settings.manage?section_id=data_feeds
products 49 0 TAB products settings.manage?section_id=products
discussion 48 0 ADDON discussion settings.manage?section_id=discussion
general 47 0 TAB general settings.manage?section_id=general
product_reviews 46 0 ADDON product_reviews settings.manage?section_id=product_reviews
general 45 0 TAB general settings.manage?section_id=general
banners 44 0 ADDON banners settings.manage?section_id=banners
general 28 0 TAB general settings.manage?section_id=general
vendor_communication 27 0 ADDON vendor_communication settings.manage?section_id=vendor_communication
Vendors 16 0 CORE Vendors settings.manage?section_id=Vendors
Security 15 0 CORE Security settings.manage?section_id=Security
Image_verification 11 0 CORE Image_verification settings.manage?section_id=Image_verification
newsletters 17 0 ADDON newsletters settings.manage?section_id=newsletters
Emails 1 0 CORE Emails settings.manage?section_id=Emails
general 18 0 TAB general settings.manage?section_id=general
Upgrade_center 13 0 CORE Upgrade_center settings.manage?section_id=Upgrade_center
attachments 20 0 ADDON attachments settings.manage?section_id=attachments
general 21 0 TAB general settings.manage?section_id=general
vendor_plans 22 0 ADDON vendor_plans settings.manage?section_id=vendor_plans
general 23 0 TAB general settings.manage?section_id=general
vendor_data_premoderation 24 0 ADDON vendor_data_premoderation settings.manage?section_id=vendor_data_premoderation
general 25 0 TAB general settings.manage?section_id=general
General 2 10 CORE General settings.manage?section_id=General
categories 50 10 TAB categories settings.manage?section_id=categories
jp_holidays 59 10 TAB jp_holidays settings.manage?section_id=jp_holidays
newest 41 10 TAB newest settings.manage?section_id=newest
products 26 10 TAB products settings.manage?section_id=products
promotions 19 10 TAB promotions settings.manage?section_id=promotions
forbidden_countries 36 10 TAB forbidden_countries settings.manage?section_id=forbidden_countries
vendor_to_customer 29 10 TAB vendor_to_customer settings.manage?section_id=vendor_to_customer
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
orders 51 20 TAB orders settings.manage?section_id=orders
Company 5 30 CORE Company settings.manage?section_id=Company
pages 52 30 TAB pages settings.manage?section_id=pages
Checkout 6 40 CORE Checkout settings.manage?section_id=Checkout
testimonials 53 40 TAB testimonials settings.manage?section_id=testimonials
companies 54 50 TAB companies settings.manage?section_id=companies
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