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(
      'ULT:STOREFRONT', 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.00055

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": 200,
          "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('ULT:STOREFRONT',cscart_settings_sections.edition_type) or find_in_set('ULT:ROOT',cscart_settings_sections.edition_type)"
        }
      }
    }
  }
}

Result

name section_id position type description href
settings 147 0 TAB settings settings.manage?section_id=settings
settings 134 0 TAB settings settings.manage?section_id=settings
ab__video_gallery 133 0 ADDON ab__video_gallery settings.manage?section_id=ab__video_gallery
settings 132 0 TAB settings settings.manage?section_id=settings
ab__fast_navigation 131 0 ADDON ab__fast_navigation settings.manage?section_id=ab__fast_navigation
settings 128 0 TAB settings settings.manage?section_id=settings
ab__motivation_block 127 0 ADDON ab__motivation_block settings.manage?section_id=ab__motivation_block
settings 126 0 TAB settings settings.manage?section_id=settings
ab__category_banners 125 0 ADDON ab__category_banners settings.manage?section_id=ab__category_banners
ab__scroll_to_top 135 0 ADDON ab__scroll_to_top settings.manage?section_id=ab__scroll_to_top
settings 136 0 TAB settings settings.manage?section_id=settings
ab__search_motivation 137 0 ADDON ab__search_motivation settings.manage?section_id=ab__search_motivation
ab__deal_of_the_day 146 0 ADDON ab__deal_of_the_day settings.manage?section_id=ab__deal_of_the_day
settings 144 0 TAB settings settings.manage?section_id=settings
ab__stickers 143 0 ADDON ab__stickers settings.manage?section_id=ab__stickers
settings 142 0 TAB settings settings.manage?section_id=settings
ab__hide_product_description 141 0 ADDON ab__hide_product_description settings.manage?section_id=ab__hide_product_description
settings 140 0 TAB settings settings.manage?section_id=settings
ab__landing_categories 139 0 ADDON ab__landing_categories settings.manage?section_id=ab__landing_categories
settings 138 0 TAB settings settings.manage?section_id=settings
settings 124 0 TAB settings settings.manage?section_id=settings
abt__unitheme2 123 0 ADDON abt__unitheme2 settings.manage?section_id=abt__unitheme2
settings 122 0 TAB settings settings.manage?section_id=settings
general 102 0 TAB general settings.manage?section_id=general
hybrid_auth 101 0 ADDON hybrid_auth settings.manage?section_id=hybrid_auth
general 100 0 TAB general settings.manage?section_id=general
catalog_mode 99 0 ADDON catalog_mode settings.manage?section_id=catalog_mode
general 98 0 TAB general settings.manage?section_id=general
janrain 97 0 ADDON janrain settings.manage?section_id=janrain
general 96 0 TAB general settings.manage?section_id=general
price_list 95 0 ADDON price_list settings.manage?section_id=price_list
rus_ruble 106 0 ADDON rus_ruble settings.manage?section_id=rus_ruble
settings 107 0 TAB settings settings.manage?section_id=settings
rus_personal_data_processing 108 0 ADDON rus_personal_data_processing settings.manage?section_id=rus_personal_data_processing
ab__addons_manager 121 0 ADDON ab__addons_manager settings.manage?section_id=ab__addons_manager
general 120 0 TAB general settings.manage?section_id=general
rus_yandex_metrika 119 0 ADDON rus_yandex_metrika settings.manage?section_id=rus_yandex_metrika
general 113 0 TAB general settings.manage?section_id=general
rus_exim_1c 112 0 ADDON rus_exim_1c settings.manage?section_id=rus_exim_1c
general 111 0 TAB general settings.manage?section_id=general
yandex_delivery 110 0 ADDON yandex_delivery settings.manage?section_id=yandex_delivery
general 109 0 TAB general settings.manage?section_id=general
general 94 0 TAB general settings.manage?section_id=general
general 282 0 TAB general settings.manage?section_id=general
general 308 0 TAB general settings.manage?section_id=general
general 273 0 TAB general settings.manage?section_id=general
sd_loyalty_program 272 0 ADDON sd_loyalty_program settings.manage?section_id=sd_loyalty_program
vc_noframes_style 281 0 ADDON vc_noframes_style settings.manage?section_id=vc_noframes_style
settings 265 0 TAB settings settings.manage?section_id=settings
gr__product_fe09_yandex 264 0 ADDON gr__product_fe09_yandex settings.manage?section_id=gr__product_fe09_yandex
settings 263 0 TAB settings settings.manage?section_id=settings
gr__product_feed_export 262 0 ADDON gr__product_feed_export settings.manage?section_id=gr__product_feed_export
general 261 0 TAB general settings.manage?section_id=general
retailcrm 274 0 ADDON retailcrm settings.manage?section_id=retailcrm
general 275 0 TAB general settings.manage?section_id=general
vc_ac_address 277 0 ADDON vc_ac_address settings.manage?section_id=vc_ac_address
vc_retailcrm_prices 307 0 ADDON vc_retailcrm_prices settings.manage?section_id=vc_retailcrm_prices
general 297 0 TAB general settings.manage?section_id=general
rus_sdek 296 0 ADDON rus_sdek settings.manage?section_id=rus_sdek
general 295 0 TAB general settings.manage?section_id=general
rf_phonemask 294 0 ADDON rf_phonemask settings.manage?section_id=rf_phonemask
cp_power_blog 298 0 ADDON cp_power_blog settings.manage?section_id=cp_power_blog
general 299 0 TAB general settings.manage?section_id=general
general 278 0 TAB general settings.manage?section_id=general
ecl_exim_features 260 0 ADDON ecl_exim_features settings.manage?section_id=ecl_exim_features
general 259 0 TAB general settings.manage?section_id=general
rf_stock_parser 258 0 ADDON rf_stock_parser settings.manage?section_id=rf_stock_parser
csc_live_search 236 0 ADDON csc_live_search settings.manage?section_id=csc_live_search
settings 235 0 TAB settings settings.manage?section_id=settings
gr__images_seo 234 0 ADDON gr__images_seo settings.manage?section_id=gr__images_seo
settings 233 0 TAB settings settings.manage?section_id=settings
ecl_extended_metadata 232 0 ADDON ecl_extended_metadata settings.manage?section_id=ecl_extended_metadata
general 230 0 TAB general settings.manage?section_id=general
sw_any_code 229 0 ADDON sw_any_code settings.manage?section_id=sw_any_code
general 210 0 TAB general settings.manage?section_id=general
general 237 0 TAB general settings.manage?section_id=general
rf_last_modified 244 0 ADDON rf_last_modified settings.manage?section_id=rf_last_modified
general 245 0 TAB general settings.manage?section_id=general
general 257 0 TAB general settings.manage?section_id=general
csc_fractional_stock 256 0 ADDON csc_fractional_stock settings.manage?section_id=csc_fractional_stock
general 255 0 TAB general settings.manage?section_id=general
cp_webp 254 0 ADDON cp_webp settings.manage?section_id=cp_webp
general 253 0 TAB general settings.manage?section_id=general
vc_companions 252 0 ADDON vc_companions settings.manage?section_id=vc_companions
general 247 0 TAB general settings.manage?section_id=general
ecl_city 246 0 ADDON ecl_city settings.manage?section_id=ecl_city
attachments 209 0 ADDON attachments settings.manage?section_id=attachments
data_feeds 93 0 ADDON data_feeds settings.manage?section_id=data_feeds
Company 5 0 CORE Company settings.manage?section_id=Company
general 40 0 TAB general settings.manage?section_id=general
vendor_communication 43 0 ADDON vendor_communication settings.manage?section_id=vendor_communication
general 36 0 TAB general settings.manage?section_id=general
gift_certificates 45 0 ADDON gift_certificates settings.manage?section_id=gift_certificates
general 46 0 TAB general settings.manage?section_id=general
store_locator 47 0 ADDON store_locator settings.manage?section_id=store_locator
general 48 0 TAB general settings.manage?section_id=general
product_variations 49 0 ADDON product_variations settings.manage?section_id=product_variations
general 50 0 TAB general settings.manage?section_id=general
recaptcha 51 0 ADDON recaptcha settings.manage?section_id=recaptcha
general 52 0 TAB general settings.manage?section_id=general
storefront_rest_api 54 0 ADDON storefront_rest_api settings.manage?section_id=storefront_rest_api
general 55 0 TAB general settings.manage?section_id=general
rma 56 0 ADDON rma settings.manage?section_id=rma
general 57 0 TAB general settings.manage?section_id=general
bestsellers 58 0 ADDON bestsellers settings.manage?section_id=bestsellers
geo_maps 39 0 ADDON geo_maps settings.manage?section_id=geo_maps
email_marketing 35 0 ADDON email_marketing settings.manage?section_id=email_marketing
general 33 0 TAB general settings.manage?section_id=general
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
Stores 17 0 CORE Stores settings.manage?section_id=Stores
hidpi 18 0 ADDON hidpi settings.manage?section_id=hidpi
general 19 0 TAB general settings.manage?section_id=general
social_buttons 20 0 ADDON social_buttons settings.manage?section_id=social_buttons
twitter 21 0 TAB twitter settings.manage?section_id=twitter
Emails 1 0 CORE Emails settings.manage?section_id=Emails
paypal 26 0 ADDON paypal settings.manage?section_id=paypal
general 27 0 TAB general settings.manage?section_id=general
tags 28 0 ADDON tags settings.manage?section_id=tags
general 29 0 TAB general settings.manage?section_id=general
rss_feed 30 0 ADDON rss_feed settings.manage?section_id=rss_feed
general 31 0 TAB general settings.manage?section_id=general
newsletters 32 0 ADDON newsletters settings.manage?section_id=newsletters
general 59 0 TAB general settings.manage?section_id=general
seo 61 0 ADDON seo settings.manage?section_id=seo
general 74 0 TAB general settings.manage?section_id=general
barcode 73 0 ADDON barcode settings.manage?section_id=barcode
general 90 0 TAB general settings.manage?section_id=general
polls 75 0 ADDON polls settings.manage?section_id=polls
image_zoom 89 0 ADDON image_zoom settings.manage?section_id=image_zoom
products 84 0 TAB products settings.manage?section_id=products
discussion 83 0 ADDON discussion settings.manage?section_id=discussion
general 82 0 TAB general settings.manage?section_id=general
watermarks 81 0 ADDON watermarks settings.manage?section_id=watermarks
general 80 0 TAB general settings.manage?section_id=general
banners 79 0 ADDON banners settings.manage?section_id=banners
access_restrictions 77 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
general 78 0 TAB general settings.manage?section_id=general
general 76 0 TAB general settings.manage?section_id=general
general 72 0 TAB general settings.manage?section_id=general
yandex_search 71 0 ADDON yandex_search settings.manage?section_id=yandex_search
general 70 0 TAB general settings.manage?section_id=general
general 62 0 TAB general settings.manage?section_id=general
reward_points 63 0 ADDON reward_points settings.manage?section_id=reward_points
general 64 0 TAB general settings.manage?section_id=general
google_analytics 65 0 ADDON google_analytics settings.manage?section_id=google_analytics
general 92 0 TAB general settings.manage?section_id=general
general 66 0 TAB general settings.manage?section_id=general
google_sitemap 91 0 ADDON google_sitemap settings.manage?section_id=google_sitemap
call_requests 69 0 ADDON call_requests settings.manage?section_id=call_requests
general 68 0 TAB general settings.manage?section_id=general
facebook_pixel 67 0 ADDON facebook_pixel settings.manage?section_id=facebook_pixel
General 2 10 CORE General settings.manage?section_id=General
categories 85 10 TAB categories settings.manage?section_id=categories
color_scheme 300 10 TAB color_scheme settings.manage?section_id=color_scheme
facebook 22 10 TAB facebook settings.manage?section_id=facebook
mapping 276 10 TAB mapping settings.manage?section_id=mapping
import_restraction_features 114 10 TAB import_restraction_features settings.manage?section_id=import_restraction_features
promotions 34 10 TAB promotions settings.manage?section_id=promotions
vendor_to_customer 208 10 TAB vendor_to_customer settings.manage?section_id=vendor_to_customer
newest 60 10 TAB newest settings.manage?section_id=newest
text_stickers 145 10 TAB text_stickers settings.manage?section_id=text_stickers
search_settings 238 10 TAB search_settings settings.manage?section_id=search_settings
forbidden_countries 53 10 TAB forbidden_countries settings.manage?section_id=forbidden_countries
appearance 129 10 TAB appearance settings.manage?section_id=appearance
mailchimp 37 10 TAB mailchimp settings.manage?section_id=mailchimp
review_tab 231 10 TAB review_tab settings.manage?section_id=review_tab
yandex 41 10 TAB yandex settings.manage?section_id=yandex
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
admin_panel 130 20 TAB admin_panel settings.manage?section_id=admin_panel
posts_list_settings 301 20 TAB posts_list_settings settings.manage?section_id=posts_list_settings
vkontakte 23 20 TAB vkontakte settings.manage?section_id=vkontakte
prices 115 20 TAB prices settings.manage?section_id=prices
google 42 20 TAB google settings.manage?section_id=google
orders 86 20 TAB orders settings.manage?section_id=orders
categories_settings 239 20 TAB categories_settings settings.manage?section_id=categories_settings
madmimi 38 20 TAB madmimi settings.manage?section_id=madmimi
sort_settings 240 30 TAB sort_settings settings.manage?section_id=sort_settings
pages 87 30 TAB pages settings.manage?section_id=pages
article_page_settings 302 30 TAB article_page_settings settings.manage?section_id=article_page_settings
yandex 24 30 TAB yandex settings.manage?section_id=yandex
shipping_features 116 30 TAB shipping_features settings.manage?section_id=shipping_features
subscription_settings 303 40 TAB subscription_settings settings.manage?section_id=subscription_settings
testimonials 88 40 TAB testimonials settings.manage?section_id=testimonials
true_orders 117 40 TAB true_orders settings.manage?section_id=true_orders
storefronts 241 40 TAB storefronts settings.manage?section_id=storefronts
pinterest 25 40 TAB pinterest settings.manage?section_id=pinterest
Checkout 6 40 CORE Checkout settings.manage?section_id=Checkout
xml_settings 304 50 TAB xml_settings settings.manage?section_id=xml_settings
elements 242 50 TAB elements settings.manage?section_id=elements
styles 243 60 TAB styles settings.manage?section_id=styles
cp_blog 293 60 TAB cp_blog settings.manage?section_id=cp_blog
cp_blog 292 60 TAB cp_blog settings.manage?section_id=cp_blog
seo_tab 305 60 TAB seo_tab settings.manage?section_id=seo_tab
yandex_rss 306 70 TAB yandex_rss settings.manage?section_id=yandex_rss
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