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(
      'VENDOR', 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:VENDOR', 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.00068

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": 167,
          "filtered": 100,
          "attached_condition": "find_in_set('STOREFRONT',cscart_settings_sections.edition_type) or find_in_set('VENDOR',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:VENDOR',cscart_settings_sections.edition_type) or find_in_set('MVE:ROOT',cscart_settings_sections.edition_type)"
        }
      }
    }
  }
}

Result

name section_id position type description href
general 98 0 TAB general settings.manage?section_id=general
ab__addons_manager 121 0 ADDON ab__addons_manager settings.manage?section_id=ab__addons_manager
settings 122 0 TAB settings settings.manage?section_id=settings
hello_world 135 0 ADDON hello_world settings.manage?section_id=hello_world
general 136 0 TAB general settings.manage?section_id=general
pdf_documents 137 0 ADDON pdf_documents settings.manage?section_id=pdf_documents
general 138 0 TAB general settings.manage?section_id=general
ecl_login_redirect 145 0 ADDON ecl_login_redirect settings.manage?section_id=ecl_login_redirect
general 146 0 TAB general settings.manage?section_id=general
gift_certificates 147 0 ADDON gift_certificates settings.manage?section_id=gift_certificates
general 148 0 TAB general settings.manage?section_id=general
ecl_order_weight 149 0 ADDON ecl_order_weight settings.manage?section_id=ecl_order_weight
general 150 0 TAB general settings.manage?section_id=general
discussion 153 0 ADDON discussion settings.manage?section_id=discussion
products 154 0 TAB products settings.manage?section_id=products
product_reviews 164 0 ADDON product_reviews settings.manage?section_id=product_reviews
general 165 0 TAB general settings.manage?section_id=general
ecl_cross_selling 170 0 ADDON ecl_cross_selling settings.manage?section_id=ecl_cross_selling
configuration 118 0 SEPARATE_TAB configuration settings.manage?section_id=configuration
searchanise 117 0 ADDON searchanise settings.manage?section_id=searchanise
service 116 0 TAB service settings.manage?section_id=service
google_sitemap 99 0 ADDON google_sitemap settings.manage?section_id=google_sitemap
general 100 0 TAB general settings.manage?section_id=general
data_feeds 101 0 ADDON data_feeds settings.manage?section_id=data_feeds
general 102 0 TAB general settings.manage?section_id=general
price_list 103 0 ADDON price_list settings.manage?section_id=price_list
general 104 0 TAB general settings.manage?section_id=general
janrain 105 0 ADDON janrain settings.manage?section_id=janrain
general 106 0 TAB general settings.manage?section_id=general
hybrid_auth 107 0 ADDON hybrid_auth settings.manage?section_id=hybrid_auth
general 108 0 TAB general settings.manage?section_id=general
catalog_mode 109 0 ADDON catalog_mode settings.manage?section_id=catalog_mode
general 110 0 TAB general settings.manage?section_id=general
vendor_debt_payout 111 0 ADDON vendor_debt_payout settings.manage?section_id=vendor_debt_payout
general 112 0 TAB general settings.manage?section_id=general
vendor_privileges 113 0 ADDON vendor_privileges settings.manage?section_id=vendor_privileges
general 114 0 TAB general settings.manage?section_id=general
mobile_app 115 0 ADDON mobile_app settings.manage?section_id=mobile_app
general 171 0 TAB general settings.manage?section_id=general
sd_parallax 179 0 ADDON sd_parallax settings.manage?section_id=sd_parallax
order_visualiser 290 0 ADDON order_visualiser settings.manage?section_id=order_visualiser
general 291 0 TAB general settings.manage?section_id=general
pom_to_crm 292 0 ADDON pom_to_crm settings.manage?section_id=pom_to_crm
general 293 0 TAB general settings.manage?section_id=general
passwordless_login 298 0 ADDON passwordless_login settings.manage?section_id=passwordless_login
general 299 0 TAB general settings.manage?section_id=general
account_requests 302 0 ADDON account_requests settings.manage?section_id=account_requests
general 303 0 TAB general settings.manage?section_id=general
custom_changes 304 0 ADDON custom_changes settings.manage?section_id=custom_changes
hd 305 0 TAB hd settings.manage?section_id=hd
reward_points 313 0 ADDON reward_points settings.manage?section_id=reward_points
general 314 0 TAB general settings.manage?section_id=general
reward_points_enhanced 315 0 ADDON reward_points_enhanced settings.manage?section_id=reward_points_enhanced
general 316 0 TAB general settings.manage?section_id=general
order_reporting 319 0 ADDON order_reporting settings.manage?section_id=order_reporting
general 320 0 TAB general settings.manage?section_id=general
fpt_sms 330 0 ADDON fpt_sms settings.manage?section_id=fpt_sms
general 289 0 TAB general settings.manage?section_id=general
general 287 0 TAB general settings.manage?section_id=general
retry_orders 286 0 ADDON retry_orders settings.manage?section_id=retry_orders
general 180 0 TAB general settings.manage?section_id=general
sd_user_profile 195 0 ADDON sd_user_profile settings.manage?section_id=sd_user_profile
general 196 0 TAB general settings.manage?section_id=general
vendor_plans 223 0 ADDON vendor_plans settings.manage?section_id=vendor_plans
general 224 0 TAB general settings.manage?section_id=general
vendor_updates 271 0 ADDON vendor_updates settings.manage?section_id=vendor_updates
section1 272 0 TAB section1 settings.manage?section_id=section1
ec_no_img 276 0 ADDON ec_no_img settings.manage?section_id=ec_no_img
general 277 0 TAB general settings.manage?section_id=general
eh_sso 278 0 ADDON eh_sso settings.manage?section_id=eh_sso
general 279 0 TAB general settings.manage?section_id=general
bc_oauth_settings 280 0 ADDON bc_oauth_settings settings.manage?section_id=bc_oauth_settings
general 281 0 TAB general settings.manage?section_id=general
csc_full_page_cache 282 0 ADDON csc_full_page_cache settings.manage?section_id=csc_full_page_cache
general 283 0 TAB general settings.manage?section_id=general
vendor_requests 284 0 ADDON vendor_requests settings.manage?section_id=vendor_requests
general 285 0 TAB general settings.manage?section_id=general
general 331 0 TAB general settings.manage?section_id=general
image_zoom 97 0 ADDON image_zoom settings.manage?section_id=image_zoom
Image_verification 11 0 CORE Image_verification settings.manage?section_id=Image_verification
newsletters 31 0 ADDON newsletters settings.manage?section_id=newsletters
general 32 0 TAB general settings.manage?section_id=general
email_marketing 34 0 ADDON email_marketing settings.manage?section_id=email_marketing
general 35 0 TAB general settings.manage?section_id=general
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
vendor_communication 42 0 ADDON vendor_communication settings.manage?section_id=vendor_communication
general 43 0 TAB general settings.manage?section_id=general
vendor_data_premoderation 45 0 ADDON vendor_data_premoderation settings.manage?section_id=vendor_data_premoderation
general 46 0 TAB general settings.manage?section_id=general
geo_maps 50 0 ADDON geo_maps settings.manage?section_id=geo_maps
general 30 0 TAB general settings.manage?section_id=general
rss_feed 29 0 ADDON rss_feed settings.manage?section_id=rss_feed
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
Emails 1 0 CORE Emails settings.manage?section_id=Emails
novem_integration 288 0 ADDON novem_integration settings.manage?section_id=novem_integration
paypal 25 0 ADDON paypal settings.manage?section_id=paypal
general 26 0 TAB general settings.manage?section_id=general
tags 27 0 ADDON tags settings.manage?section_id=tags
general 28 0 TAB general settings.manage?section_id=general
general 51 0 TAB general settings.manage?section_id=general
access_restrictions 84 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
watermarks 88 0 ADDON watermarks settings.manage?section_id=watermarks
general 68 0 TAB general settings.manage?section_id=general
general 66 0 TAB general settings.manage?section_id=general
bestsellers 67 0 ADDON bestsellers settings.manage?section_id=bestsellers
seo 70 0 ADDON seo settings.manage?section_id=seo
general 87 0 TAB general settings.manage?section_id=general
facebook_pixel 76 0 ADDON facebook_pixel settings.manage?section_id=facebook_pixel
general 77 0 TAB general settings.manage?section_id=general
call_requests 78 0 ADDON call_requests settings.manage?section_id=call_requests
general 79 0 TAB general settings.manage?section_id=general
barcode 80 0 ADDON barcode settings.manage?section_id=barcode
banners 86 0 ADDON banners settings.manage?section_id=banners
general 81 0 TAB general settings.manage?section_id=general
general 85 0 TAB general settings.manage?section_id=general
polls 82 0 ADDON polls settings.manage?section_id=polls
general 83 0 TAB general settings.manage?section_id=general
rma 65 0 ADDON rma settings.manage?section_id=rma
general 61 0 TAB general settings.manage?section_id=general
product_variations 58 0 ADDON product_variations settings.manage?section_id=product_variations
general 59 0 TAB general settings.manage?section_id=general
general 89 0 TAB general settings.manage?section_id=general
general 57 0 TAB general settings.manage?section_id=general
storefront_rest_api 60 0 ADDON storefront_rest_api settings.manage?section_id=storefront_rest_api
store_locator 56 0 ADDON store_locator settings.manage?section_id=store_locator
recaptcha 62 0 ADDON recaptcha settings.manage?section_id=recaptcha
general 63 0 TAB general settings.manage?section_id=general
general 71 0 TAB general settings.manage?section_id=general
facebook 21 10 TAB facebook settings.manage?section_id=facebook
products 47 10 TAB products settings.manage?section_id=products
yandex 52 10 TAB yandex settings.manage?section_id=yandex
General 2 10 CORE General settings.manage?section_id=General
ucd 306 10 TAB ucd settings.manage?section_id=ucd
categories 155 10 TAB categories settings.manage?section_id=categories
newest 69 10 TAB newest settings.manage?section_id=newest
mailchimp 36 10 TAB mailchimp settings.manage?section_id=mailchimp
promotions 33 10 TAB promotions settings.manage?section_id=promotions
section2 273 10 TAB section2 settings.manage?section_id=section2
vendor_to_customer 44 10 TAB vendor_to_customer settings.manage?section_id=vendor_to_customer
forbidden_countries 64 10 TAB forbidden_countries settings.manage?section_id=forbidden_countries
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
vkontakte 22 20 TAB vkontakte settings.manage?section_id=vkontakte
orders 156 20 TAB orders settings.manage?section_id=orders
google 53 20 TAB google settings.manage?section_id=google
madmimi 37 20 TAB madmimi settings.manage?section_id=madmimi
Company 5 30 CORE Company settings.manage?section_id=Company
pages 157 30 TAB pages settings.manage?section_id=pages
yandex 23 30 TAB yandex settings.manage?section_id=yandex
pinterest 24 40 TAB pinterest settings.manage?section_id=pinterest
testimonials 158 40 TAB testimonials settings.manage?section_id=testimonials
Checkout 6 40 CORE Checkout settings.manage?section_id=Checkout
companies 159 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