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

Query time 0.00080

JSON explain

{
  "query_block": {
    "select_id": 1,
    "ordering_operation": {
      "using_filesort": true,
      "table": {
        "table_name": "cscart_settings_sections",
        "access_type": "ALL",
        "rows": 51,
        "filtered": 100,
        "attached_condition": "(find_in_set('ROOT',`_testcscart`.`cscart_settings_sections`.`edition_type`) or find_in_set('VENDOR',`_testcscart`.`cscart_settings_sections`.`edition_type`) or find_in_set('ULT:ROOT',`_testcscart`.`cscart_settings_sections`.`edition_type`) or find_in_set('ULT:VENDOR',`_testcscart`.`cscart_settings_sections`.`edition_type`))"
      }
    }
  }
}

Result

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