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

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": 189,
          "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
ab__stickers 141 0 ADDON ab__stickers settings.manage?section_id=ab__stickers
settings 125 0 TAB settings settings.manage?section_id=settings
ab__addons_manager 124 0 ADDON ab__addons_manager settings.manage?section_id=ab__addons_manager
general 123 0 TAB general settings.manage?section_id=general
vendor_privileges 122 0 ADDON vendor_privileges settings.manage?section_id=vendor_privileges
general 121 0 TAB general settings.manage?section_id=general
vendor_debt_payout 120 0 ADDON vendor_debt_payout settings.manage?section_id=vendor_debt_payout
product_page_settings 118 0 TAB product_page_settings settings.manage?section_id=product_page_settings
vendor_panel_configurator 117 0 ADDON vendor_panel_configurator settings.manage?section_id=vendor_panel_configurator
ab__advanced_sitemap 126 0 ADDON ab__advanced_sitemap settings.manage?section_id=ab__advanced_sitemap
general 127 0 TAB general settings.manage?section_id=general
ab__category_banners 131 0 ADDON ab__category_banners settings.manage?section_id=ab__category_banners
settings 140 0 TAB settings settings.manage?section_id=settings
ab__search_motivation 139 0 ADDON ab__search_motivation settings.manage?section_id=ab__search_motivation
abt__unitheme2_mv 195 0 ADDON abt__unitheme2_mv settings.manage?section_id=abt__unitheme2_mv
abt__unitheme2 193 0 ADDON abt__unitheme2 settings.manage?section_id=abt__unitheme2
settings 194 0 TAB settings settings.manage?section_id=settings
settings 134 0 TAB settings settings.manage?section_id=settings
ab__deal_of_the_day 133 0 ADDON ab__deal_of_the_day settings.manage?section_id=ab__deal_of_the_day
settings 132 0 TAB settings settings.manage?section_id=settings
general 115 0 TAB general settings.manage?section_id=general
gdpr 114 0 ADDON gdpr settings.manage?section_id=gdpr
data_feeds 102 0 ADDON data_feeds settings.manage?section_id=data_feeds
general 101 0 TAB general settings.manage?section_id=general
image_zoom 100 0 ADDON image_zoom settings.manage?section_id=image_zoom
general 99 0 TAB general settings.manage?section_id=general
google_sitemap 98 0 ADDON google_sitemap settings.manage?section_id=google_sitemap
general 97 0 TAB general settings.manage?section_id=general
product_reviews 96 0 ADDON product_reviews settings.manage?section_id=product_reviews
general 95 0 TAB general settings.manage?section_id=general
general 103 0 TAB general settings.manage?section_id=general
price_list 104 0 ADDON price_list settings.manage?section_id=price_list
general 105 0 TAB general settings.manage?section_id=general
general 113 0 TAB general settings.manage?section_id=general
zapier 112 0 ADDON zapier settings.manage?section_id=zapier
general 111 0 TAB general settings.manage?section_id=general
janrain 110 0 ADDON janrain settings.manage?section_id=janrain
general 109 0 TAB general settings.manage?section_id=general
hybrid_auth 108 0 ADDON hybrid_auth settings.manage?section_id=hybrid_auth
catalog_mode 197 0 ADDON catalog_mode settings.manage?section_id=catalog_mode
general 198 0 TAB general settings.manage?section_id=general
watermarks 94 0 ADDON watermarks settings.manage?section_id=watermarks
settings 196 0 TAB settings settings.manage?section_id=settings
ab__seo_reviews 181 0 ADDON ab__seo_reviews settings.manage?section_id=ab__seo_reviews
settings 178 0 TAB settings settings.manage?section_id=settings
ab__short_desc_from_features 177 0 ADDON ab__short_desc_from_features settings.manage?section_id=ab__short_desc_from_features
settings 176 0 TAB settings settings.manage?section_id=settings
ab__seo_brands 175 0 ADDON ab__seo_brands settings.manage?section_id=ab__seo_brands
settings 174 0 TAB settings settings.manage?section_id=settings
ab__seo_for_tags 173 0 ADDON ab__seo_for_tags settings.manage?section_id=ab__seo_for_tags
general 171 0 TAB general settings.manage?section_id=general
settings 182 0 TAB settings settings.manage?section_id=settings
ab__extended_metadata 183 0 ADDON ab__extended_metadata settings.manage?section_id=ab__extended_metadata
settings 184 0 TAB settings settings.manage?section_id=settings
settings 192 0 TAB settings settings.manage?section_id=settings
ab__lazy_load 191 0 ADDON ab__lazy_load settings.manage?section_id=ab__lazy_load
settings 190 0 TAB settings settings.manage?section_id=settings
ab__country_language 189 0 ADDON ab__country_language settings.manage?section_id=ab__country_language
settings 188 0 TAB settings settings.manage?section_id=settings
ab__seo_for_blog 187 0 ADDON ab__seo_for_blog settings.manage?section_id=ab__seo_for_blog
settings 186 0 TAB settings settings.manage?section_id=settings
ab__webp 185 0 ADDON ab__webp settings.manage?section_id=ab__webp
ab__intelligent_accessories 170 0 ADDON ab__intelligent_accessories settings.manage?section_id=ab__intelligent_accessories
settings 169 0 TAB settings settings.manage?section_id=settings
settings 153 0 TAB settings settings.manage?section_id=settings
ab__images_seo 152 0 ADDON ab__images_seo settings.manage?section_id=ab__images_seo
settings 151 0 TAB settings settings.manage?section_id=settings
ab__custom_h1 150 0 ADDON ab__custom_h1 settings.manage?section_id=ab__custom_h1
settings 149 0 TAB settings settings.manage?section_id=settings
ab__seo_product_tabs 148 0 ADDON ab__seo_product_tabs settings.manage?section_id=ab__seo_product_tabs
settings 147 0 TAB settings settings.manage?section_id=settings
ab__image_previewers 146 0 ADDON ab__image_previewers settings.manage?section_id=ab__image_previewers
ab__landing_categories 154 0 ADDON ab__landing_categories settings.manage?section_id=ab__landing_categories
settings 155 0 TAB settings settings.manage?section_id=settings
ab__motivation_block 156 0 ADDON ab__motivation_block settings.manage?section_id=ab__motivation_block
ab__multiple_cat_descriptions 168 0 ADDON ab__multiple_cat_descriptions settings.manage?section_id=ab__multiple_cat_descriptions
settings 167 0 TAB settings settings.manage?section_id=settings
ab__preload 166 0 ADDON ab__preload settings.manage?section_id=ab__preload
settings 165 0 TAB settings settings.manage?section_id=settings
ab__video_gallery 164 0 ADDON ab__video_gallery settings.manage?section_id=ab__video_gallery
general 161 0 TAB general settings.manage?section_id=general
ab__seo_filters 160 0 ADDON ab__seo_filters settings.manage?section_id=ab__seo_filters
settings 157 0 TAB settings settings.manage?section_id=settings
settings 142 0 TAB settings settings.manage?section_id=settings
products 88 0 TAB products settings.manage?section_id=products
Image_verification 11 0 CORE Image_verification settings.manage?section_id=Image_verification
geo_maps 39 0 ADDON geo_maps settings.manage?section_id=geo_maps
general 40 0 TAB general settings.manage?section_id=general
vendor_communication 43 0 ADDON vendor_communication settings.manage?section_id=vendor_communication
general 44 0 TAB general settings.manage?section_id=general
Emails 1 0 CORE Emails settings.manage?section_id=Emails
vendor_plans 46 0 ADDON vendor_plans settings.manage?section_id=vendor_plans
general 47 0 TAB general settings.manage?section_id=general
gift_certificates 48 0 ADDON gift_certificates settings.manage?section_id=gift_certificates
general 49 0 TAB general settings.manage?section_id=general
store_locator 50 0 ADDON store_locator settings.manage?section_id=store_locator
general 51 0 TAB general settings.manage?section_id=general
product_variations 52 0 ADDON product_variations settings.manage?section_id=product_variations
general 53 0 TAB general settings.manage?section_id=general
recaptcha 54 0 ADDON recaptcha settings.manage?section_id=recaptcha
general 55 0 TAB general settings.manage?section_id=general
attachments 35 0 ADDON attachments settings.manage?section_id=attachments
service 38 0 TAB service settings.manage?section_id=service
vendor_rating 37 0 ADDON vendor_rating settings.manage?section_id=vendor_rating
Upgrade_center 13 0 CORE Upgrade_center settings.manage?section_id=Upgrade_center
Security 15 0 CORE Security settings.manage?section_id=Security
Vendors 16 0 CORE Vendors settings.manage?section_id=Vendors
hidpi 17 0 ADDON hidpi settings.manage?section_id=hidpi
general 18 0 TAB general settings.manage?section_id=general
social_buttons 19 0 ADDON social_buttons settings.manage?section_id=social_buttons
twitter 20 0 TAB twitter settings.manage?section_id=twitter
tags 25 0 ADDON tags settings.manage?section_id=tags
general 26 0 TAB general settings.manage?section_id=general
rss_feed 27 0 ADDON rss_feed settings.manage?section_id=rss_feed
general 28 0 TAB general settings.manage?section_id=general
email_marketing 29 0 ADDON email_marketing settings.manage?section_id=email_marketing
general 30 0 TAB general settings.manage?section_id=general
newsletters 32 0 ADDON newsletters settings.manage?section_id=newsletters
general 33 0 TAB general settings.manage?section_id=general
general 36 0 TAB general settings.manage?section_id=general
storefront_rest_api 57 0 ADDON storefront_rest_api settings.manage?section_id=storefront_rest_api
general 58 0 TAB general settings.manage?section_id=general
discussion 87 0 ADDON discussion settings.manage?section_id=discussion
vendors 71 0 TAB vendors settings.manage?section_id=vendors
facebook_pixel 73 0 ADDON facebook_pixel settings.manage?section_id=facebook_pixel
general 74 0 TAB general settings.manage?section_id=general
google_analytics 75 0 ADDON google_analytics settings.manage?section_id=google_analytics
general 76 0 TAB general settings.manage?section_id=general
call_requests 77 0 ADDON call_requests settings.manage?section_id=call_requests
general 78 0 TAB general settings.manage?section_id=general
barcode 79 0 ADDON barcode settings.manage?section_id=barcode
general 80 0 TAB general settings.manage?section_id=general
polls 81 0 ADDON polls settings.manage?section_id=polls
general 82 0 TAB general settings.manage?section_id=general
access_restrictions 83 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
general 84 0 TAB general settings.manage?section_id=general
banners 85 0 ADDON banners settings.manage?section_id=banners
general 86 0 TAB general settings.manage?section_id=general
vendor_data_premoderation 70 0 ADDON vendor_data_premoderation settings.manage?section_id=vendor_data_premoderation
general 64 0 TAB general settings.manage?section_id=general
general 60 0 TAB general settings.manage?section_id=general
seo 66 0 ADDON seo settings.manage?section_id=seo
bestsellers 63 0 ADDON bestsellers settings.manage?section_id=bestsellers
general 62 0 TAB general settings.manage?section_id=general
rma 61 0 ADDON rma settings.manage?section_id=rma
general 67 0 TAB general settings.manage?section_id=general
reward_points 68 0 ADDON reward_points settings.manage?section_id=reward_points
product_bundles 59 0 ADDON product_bundles settings.manage?section_id=product_bundles
general 69 0 TAB general settings.manage?section_id=general
vendor_to_customer 45 10 TAB vendor_to_customer settings.manage?section_id=vendor_to_customer
ab__pfe 179 10 TAB ab__pfe settings.manage?section_id=ab__pfe
params_default 172 10 TAB params_default settings.manage?section_id=params_default
forbidden_countries 56 10 TAB forbidden_countries settings.manage?section_id=forbidden_countries
multiple_descriptions 162 10 TAB multiple_descriptions settings.manage?section_id=multiple_descriptions
mailchimp 31 10 TAB mailchimp settings.manage?section_id=mailchimp
promotions 34 10 TAB promotions settings.manage?section_id=promotions
facebook 21 10 TAB facebook settings.manage?section_id=facebook
yandex 41 10 TAB yandex settings.manage?section_id=yandex
products 72 10 TAB products settings.manage?section_id=products
General 2 10 CORE General settings.manage?section_id=General
categories 89 10 TAB categories settings.manage?section_id=categories
gdpr 116 10 TAB gdpr settings.manage?section_id=gdpr
xml_sitemap 128 10 TAB xml_sitemap settings.manage?section_id=xml_sitemap
vendor_panel_style 119 10 TAB vendor_panel_style settings.manage?section_id=vendor_panel_style
newest 65 10 TAB newest settings.manage?section_id=newest
appearance 158 10 TAB appearance settings.manage?section_id=appearance
text_stickers 143 10 TAB text_stickers settings.manage?section_id=text_stickers
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
ab__sf 180 20 TAB ab__sf settings.manage?section_id=ab__sf
orders 90 20 TAB orders settings.manage?section_id=orders
category_view 163 20 TAB category_view settings.manage?section_id=category_view
vkontakte 22 20 TAB vkontakte settings.manage?section_id=vkontakte
google 42 20 TAB google settings.manage?section_id=google
pictograms 144 20 TAB pictograms settings.manage?section_id=pictograms
admin_panel 159 20 TAB admin_panel settings.manage?section_id=admin_panel
html_sitemap 129 20 TAB html_sitemap settings.manage?section_id=html_sitemap
xml_images_map 130 30 TAB xml_images_map settings.manage?section_id=xml_images_map
pages 91 30 TAB pages settings.manage?section_id=pages
vendors 145 30 TAB vendors settings.manage?section_id=vendors
yandex 23 30 TAB yandex settings.manage?section_id=yandex
Company 5 30 CORE Company settings.manage?section_id=Company
Checkout 6 40 CORE Checkout settings.manage?section_id=Checkout
testimonials 92 40 TAB testimonials settings.manage?section_id=testimonials
pinterest 24 40 TAB pinterest settings.manage?section_id=pinterest
companies 93 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