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.00087

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": 93,
          "filtered": 100,
          "attached_condition": "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)"
        }
      }
    }
  }
}

Result

name section_id position type description href
general 48 0 TAB general settings.manage?section_id=general
general 61 0 TAB general settings.manage?section_id=general
access_restrictions 62 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
general 63 0 TAB general settings.manage?section_id=general
banners 64 0 ADDON banners settings.manage?section_id=banners
general 65 0 TAB general settings.manage?section_id=general
watermarks 66 0 ADDON watermarks settings.manage?section_id=watermarks
general 67 0 TAB general settings.manage?section_id=general
discussion 68 0 ADDON discussion settings.manage?section_id=discussion
polls 60 0 ADDON polls settings.manage?section_id=polls
general 59 0 TAB general settings.manage?section_id=general
barcode 58 0 ADDON barcode settings.manage?section_id=barcode
seo 50 0 ADDON seo settings.manage?section_id=seo
general 51 0 TAB general settings.manage?section_id=general
reward_points 52 0 ADDON reward_points settings.manage?section_id=reward_points
general 53 0 TAB general settings.manage?section_id=general
google_analytics 54 0 ADDON google_analytics settings.manage?section_id=google_analytics
general 55 0 TAB general settings.manage?section_id=general
call_requests 56 0 ADDON call_requests settings.manage?section_id=call_requests
general 57 0 TAB general settings.manage?section_id=general
products 69 0 TAB products settings.manage?section_id=products
google_sitemap 75 0 ADDON google_sitemap settings.manage?section_id=google_sitemap
janrain 87 0 ADDON janrain settings.manage?section_id=janrain
general 88 0 TAB general settings.manage?section_id=general
mobile_admin_app 89 0 ADDON mobile_admin_app settings.manage?section_id=mobile_admin_app
service 90 0 TAB service settings.manage?section_id=service
energothemes_search 92 0 ADDON energothemes_search settings.manage?section_id=energothemes_search
section1 93 0 TAB section1 settings.manage?section_id=section1
energothemes_license 94 0 ADDON energothemes_license settings.manage?section_id=energothemes_license
main 95 0 TAB main settings.manage?section_id=main
general 86 0 TAB general settings.manage?section_id=general
catalog_mode 85 0 ADDON catalog_mode settings.manage?section_id=catalog_mode
general 84 0 TAB general settings.manage?section_id=general
general 76 0 TAB general settings.manage?section_id=general
image_zoom 77 0 ADDON image_zoom settings.manage?section_id=image_zoom
general 78 0 TAB general settings.manage?section_id=general
data_feeds 79 0 ADDON data_feeds settings.manage?section_id=data_feeds
general 80 0 TAB general settings.manage?section_id=general
price_list 81 0 ADDON price_list settings.manage?section_id=price_list
general 82 0 TAB general settings.manage?section_id=general
hybrid_auth 83 0 ADDON hybrid_auth settings.manage?section_id=hybrid_auth
storefront_rest_api 96 0 ADDON storefront_rest_api settings.manage?section_id=storefront_rest_api
bestsellers 47 0 ADDON bestsellers settings.manage?section_id=bestsellers
Emails 1 0 CORE Emails settings.manage?section_id=Emails
general 31 0 TAB general settings.manage?section_id=general
rss_feed 30 0 ADDON rss_feed settings.manage?section_id=rss_feed
general 29 0 TAB general settings.manage?section_id=general
tags 28 0 ADDON tags settings.manage?section_id=tags
twitter 21 0 TAB twitter settings.manage?section_id=twitter
social_buttons 20 0 ADDON social_buttons settings.manage?section_id=social_buttons
general 19 0 TAB general settings.manage?section_id=general
paypal 18 0 ADDON paypal settings.manage?section_id=paypal
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
email_marketing 32 0 ADDON email_marketing settings.manage?section_id=email_marketing
general 33 0 TAB general settings.manage?section_id=general
general 46 0 TAB general settings.manage?section_id=general
rma 45 0 ADDON rma settings.manage?section_id=rma
general 44 0 TAB general settings.manage?section_id=general
recaptcha 43 0 ADDON recaptcha settings.manage?section_id=recaptcha
general 42 0 TAB general settings.manage?section_id=general
store_locator 41 0 ADDON store_locator settings.manage?section_id=store_locator
general 40 0 TAB general settings.manage?section_id=general
gift_certificates 39 0 ADDON gift_certificates settings.manage?section_id=gift_certificates
newsletters 36 0 ADDON newsletters settings.manage?section_id=newsletters
general 37 0 TAB general settings.manage?section_id=general
mailchimp 34 10 TAB mailchimp settings.manage?section_id=mailchimp
General 2 10 CORE General settings.manage?section_id=General
newest 49 10 TAB newest settings.manage?section_id=newest
admin_app 91 10 TAB admin_app settings.manage?section_id=admin_app
general 97 10 TAB general settings.manage?section_id=general
categories 70 10 TAB categories settings.manage?section_id=categories
promotions 38 10 TAB promotions settings.manage?section_id=promotions
facebook 22 10 TAB facebook settings.manage?section_id=facebook
orders 71 20 TAB orders settings.manage?section_id=orders
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
vkontakte 23 20 TAB vkontakte settings.manage?section_id=vkontakte
madmimi 35 20 TAB madmimi settings.manage?section_id=madmimi
gplus 24 30 TAB gplus settings.manage?section_id=gplus
gift_registry 72 30 TAB gift_registry settings.manage?section_id=gift_registry
yandex 25 40 TAB yandex settings.manage?section_id=yandex
Checkout 6 40 CORE Checkout settings.manage?section_id=Checkout
pages 73 40 TAB pages settings.manage?section_id=pages
pinterest 26 50 TAB pinterest settings.manage?section_id=pinterest
testimonials 74 50 TAB testimonials settings.manage?section_id=testimonials
email 27 60 TAB email settings.manage?section_id=email
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