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

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": 142,
          "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
reward_points 71 0 ADDON reward_points settings.manage?section_id=reward_points
discussion 90 0 ADDON discussion settings.manage?section_id=discussion
products 91 0 TAB products settings.manage?section_id=products
watermarks 97 0 ADDON watermarks settings.manage?section_id=watermarks
general 98 0 TAB general settings.manage?section_id=general
product_reviews 99 0 ADDON product_reviews settings.manage?section_id=product_reviews
general 100 0 TAB general settings.manage?section_id=general
google_sitemap 101 0 ADDON google_sitemap settings.manage?section_id=google_sitemap
general 102 0 TAB general settings.manage?section_id=general
image_zoom 103 0 ADDON image_zoom settings.manage?section_id=image_zoom
general 104 0 TAB general settings.manage?section_id=general
data_feeds 105 0 ADDON data_feeds settings.manage?section_id=data_feeds
general 106 0 TAB general settings.manage?section_id=general
price_list 107 0 ADDON price_list settings.manage?section_id=price_list
general 108 0 TAB general settings.manage?section_id=general
general 89 0 TAB general settings.manage?section_id=general
banners 88 0 ADDON banners settings.manage?section_id=banners
general 72 0 TAB general settings.manage?section_id=general
vendor_data_premoderation 73 0 ADDON vendor_data_premoderation settings.manage?section_id=vendor_data_premoderation
vendors 74 0 TAB vendors settings.manage?section_id=vendors
facebook_pixel 76 0 ADDON facebook_pixel settings.manage?section_id=facebook_pixel
general 77 0 TAB general settings.manage?section_id=general
google_analytics 78 0 ADDON google_analytics settings.manage?section_id=google_analytics
general 79 0 TAB general settings.manage?section_id=general
call_requests 80 0 ADDON call_requests settings.manage?section_id=call_requests
general 81 0 TAB general settings.manage?section_id=general
barcode 82 0 ADDON barcode settings.manage?section_id=barcode
general 83 0 TAB general settings.manage?section_id=general
polls 84 0 ADDON polls settings.manage?section_id=polls
general 85 0 TAB general settings.manage?section_id=general
access_restrictions 366 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
catalog_mode 109 0 ADDON catalog_mode settings.manage?section_id=catalog_mode
general 110 0 TAB general settings.manage?section_id=general
signup_terms 445 0 TAB signup_terms settings.manage?section_id=signup_terms
general 394 0 TAB general settings.manage?section_id=general
catalog 441 0 TAB catalog settings.manage?section_id=catalog
vendor_plans 256 0 ADDON vendor_plans settings.manage?section_id=vendor_plans
general 257 0 TAB general settings.manage?section_id=general
eitems_design 440 0 ADDON eitems_design settings.manage?section_id=eitems_design
eitems_office 447 0 ADDON eitems_office settings.manage?section_id=eitems_office
currency 448 0 TAB currency settings.manage?section_id=currency
eitems_currency 397 0 ADDON eitems_currency settings.manage?section_id=eitems_currency
general 398 0 TAB general settings.manage?section_id=general
general 367 0 TAB general settings.manage?section_id=general
main_chat 396 0 TAB main_chat settings.manage?section_id=main_chat
eitems_chat 395 0 ADDON eitems_chat settings.manage?section_id=eitems_chat
eitems_banners 432 0 ADDON eitems_banners settings.manage?section_id=eitems_banners
general 302 0 TAB general settings.manage?section_id=general
eitems_gold 301 0 ADDON eitems_gold settings.manage?section_id=eitems_gold
hybrid_auth 111 0 ADDON hybrid_auth settings.manage?section_id=hybrid_auth
general 112 0 TAB general settings.manage?section_id=general
janrain 113 0 ADDON janrain settings.manage?section_id=janrain
general 114 0 TAB general settings.manage?section_id=general
zapier 115 0 ADDON zapier settings.manage?section_id=zapier
general 116 0 TAB general settings.manage?section_id=general
gdpr 117 0 ADDON gdpr settings.manage?section_id=gdpr
general 118 0 TAB general settings.manage?section_id=general
vendor_panel_configurator 120 0 ADDON vendor_panel_configurator settings.manage?section_id=vendor_panel_configurator
product_page_settings 121 0 TAB product_page_settings settings.manage?section_id=product_page_settings
eitems_acc 444 0 ADDON eitems_acc settings.manage?section_id=eitems_acc
eitems_validation 393 0 ADDON eitems_validation settings.manage?section_id=eitems_validation
vendor_privileges 125 0 ADDON vendor_privileges settings.manage?section_id=vendor_privileges
general 126 0 TAB general settings.manage?section_id=general
general 433 0 TAB general settings.manage?section_id=general
general 18 0 TAB general settings.manage?section_id=general
general 32 0 TAB general settings.manage?section_id=general
Upgrade_center 13 0 CORE Upgrade_center settings.manage?section_id=Upgrade_center
newsletters 129 0 ADDON newsletters settings.manage?section_id=newsletters
attachments 38 0 ADDON attachments settings.manage?section_id=attachments
general 39 0 TAB general settings.manage?section_id=general
vendor_rating 40 0 ADDON vendor_rating settings.manage?section_id=vendor_rating
service 41 0 TAB service settings.manage?section_id=service
geo_maps 42 0 ADDON geo_maps settings.manage?section_id=geo_maps
general 43 0 TAB general settings.manage?section_id=general
Image_verification 11 0 CORE Image_verification settings.manage?section_id=Image_verification
privat_chat 439 0 TAB privat_chat settings.manage?section_id=privat_chat
email_marketing 31 0 ADDON email_marketing settings.manage?section_id=email_marketing
general 30 0 TAB general settings.manage?section_id=general
Emails 1 0 CORE Emails settings.manage?section_id=Emails
paypal 19 0 ADDON paypal settings.manage?section_id=paypal
hidpi 17 0 ADDON hidpi settings.manage?section_id=hidpi
general 20 0 TAB general settings.manage?section_id=general
social_buttons 21 0 ADDON social_buttons settings.manage?section_id=social_buttons
twitter 22 0 TAB twitter settings.manage?section_id=twitter
Vendors 16 0 CORE Vendors settings.manage?section_id=Vendors
Security 15 0 CORE Security settings.manage?section_id=Security
tags 27 0 ADDON tags settings.manage?section_id=tags
general 28 0 TAB general settings.manage?section_id=general
rss_feed 29 0 ADDON rss_feed settings.manage?section_id=rss_feed
eitems_privat 438 0 ADDON eitems_privat settings.manage?section_id=eitems_privat
gift_certificates 51 0 ADDON gift_certificates settings.manage?section_id=gift_certificates
general 58 0 TAB general settings.manage?section_id=general
general 70 0 TAB general settings.manage?section_id=general
storefront_rest_api 60 0 ADDON storefront_rest_api settings.manage?section_id=storefront_rest_api
general 61 0 TAB general settings.manage?section_id=general
product_bundles 62 0 ADDON product_bundles settings.manage?section_id=product_bundles
general 63 0 TAB general settings.manage?section_id=general
rma 64 0 ADDON rma settings.manage?section_id=rma
general 65 0 TAB general settings.manage?section_id=general
bestsellers 66 0 ADDON bestsellers settings.manage?section_id=bestsellers
general 67 0 TAB general settings.manage?section_id=general
seo 69 0 ADDON seo settings.manage?section_id=seo
recaptcha 57 0 ADDON recaptcha settings.manage?section_id=recaptcha
general 56 0 TAB general settings.manage?section_id=general
general 52 0 TAB general settings.manage?section_id=general
product_variations 55 0 ADDON product_variations settings.manage?section_id=product_variations
general 54 0 TAB general settings.manage?section_id=general
store_locator 53 0 ADDON store_locator settings.manage?section_id=store_locator
general 130 0 TAB general settings.manage?section_id=general
yandex 44 10 TAB yandex settings.manage?section_id=yandex
products 75 10 TAB products settings.manage?section_id=products
newest 68 10 TAB newest settings.manage?section_id=newest
mailchimp 33 10 TAB mailchimp settings.manage?section_id=mailchimp
other 446 10 TAB other settings.manage?section_id=other
item 449 10 TAB item settings.manage?section_id=item
facebook 23 10 TAB facebook settings.manage?section_id=facebook
General 2 10 CORE General settings.manage?section_id=General
vendor_panel_style 122 10 TAB vendor_panel_style settings.manage?section_id=vendor_panel_style
styleswitcher 442 10 TAB styleswitcher settings.manage?section_id=styleswitcher
categories 92 10 TAB categories settings.manage?section_id=categories
gdpr 119 10 TAB gdpr settings.manage?section_id=gdpr
promotions 131 10 TAB promotions settings.manage?section_id=promotions
forbidden_countries 59 10 TAB forbidden_countries settings.manage?section_id=forbidden_countries
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
general 450 20 TAB general settings.manage?section_id=general
checkout 443 20 TAB checkout settings.manage?section_id=checkout
google 45 20 TAB google settings.manage?section_id=google
orders 93 20 TAB orders settings.manage?section_id=orders
madmimi 34 20 TAB madmimi settings.manage?section_id=madmimi
vkontakte 24 20 TAB vkontakte settings.manage?section_id=vkontakte
yandex 25 30 TAB yandex settings.manage?section_id=yandex
pages 94 30 TAB pages settings.manage?section_id=pages
Company 5 30 CORE Company settings.manage?section_id=Company
pinterest 26 40 TAB pinterest settings.manage?section_id=pinterest
testimonials 95 40 TAB testimonials settings.manage?section_id=testimonials
Checkout 6 40 CORE Checkout settings.manage?section_id=Checkout
companies 96 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
profile_fields_thumbnais 233 1000 TAB profile_fields_thumbnais settings.manage?section_id=profile_fields_thumbnais