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

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": 155,
          "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
discussion 89 0 ADDON discussion settings.manage?section_id=discussion
product_page_settings 118 0 TAB product_page_settings settings.manage?section_id=product_page_settings
vendor_debt_payout 120 0 ADDON vendor_debt_payout settings.manage?section_id=vendor_debt_payout
general 121 0 TAB general settings.manage?section_id=general
saas 124 0 ADDON saas settings.manage?section_id=saas
general 125 0 TAB general settings.manage?section_id=general
paypal_commerce_platform 127 0 ADDON paypal_commerce_platform settings.manage?section_id=paypal_commerce_platform
general 129 0 TAB general settings.manage?section_id=general
stripe_connect 131 0 ADDON stripe_connect settings.manage?section_id=stripe_connect
general 133 0 TAB general settings.manage?section_id=general
wk_buynow 134 0 ADDON wk_buynow settings.manage?section_id=wk_buynow
general 135 0 TAB general settings.manage?section_id=general
store_locator 136 0 ADDON store_locator settings.manage?section_id=store_locator
general 137 0 TAB general settings.manage?section_id=general
mobile_app 138 0 ADDON mobile_app settings.manage?section_id=mobile_app
service 139 0 TAB service settings.manage?section_id=service
vendor_panel_configurator 117 0 ADDON vendor_panel_configurator settings.manage?section_id=vendor_panel_configurator
general 115 0 TAB general settings.manage?section_id=general
gdpr 114 0 ADDON gdpr settings.manage?section_id=gdpr
products 90 0 TAB products settings.manage?section_id=products
product_reviews 96 0 ADDON product_reviews settings.manage?section_id=product_reviews
general 97 0 TAB general settings.manage?section_id=general
google_sitemap 98 0 ADDON google_sitemap settings.manage?section_id=google_sitemap
general 99 0 TAB general settings.manage?section_id=general
image_zoom 100 0 ADDON image_zoom settings.manage?section_id=image_zoom
general 101 0 TAB general settings.manage?section_id=general
data_feeds 102 0 ADDON data_feeds settings.manage?section_id=data_feeds
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
hybrid_auth 108 0 ADDON hybrid_auth settings.manage?section_id=hybrid_auth
general 109 0 TAB general settings.manage?section_id=general
catalog_mode 110 0 ADDON catalog_mode settings.manage?section_id=catalog_mode
general 111 0 TAB general settings.manage?section_id=general
pdf_documents 140 0 ADDON pdf_documents settings.manage?section_id=pdf_documents
general 141 0 TAB general settings.manage?section_id=general
ab__addons_manager 169 0 ADDON ab__addons_manager settings.manage?section_id=ab__addons_manager
settings 170 0 TAB settings settings.manage?section_id=settings
ab__scroll_to_top 171 0 ADDON ab__scroll_to_top settings.manage?section_id=ab__scroll_to_top
settings 172 0 TAB settings settings.manage?section_id=settings
hw_promotions_4_customers 175 0 ADDON hw_promotions_4_customers settings.manage?section_id=hw_promotions_4_customers
general 176 0 TAB general settings.manage?section_id=general
ath_extended_banners 184 0 ADDON ath_extended_banners settings.manage?section_id=ath_extended_banners
styles_controls 185 0 TAB styles_controls settings.manage?section_id=styles_controls
chatra 191 0 ADDON chatra settings.manage?section_id=chatra
general 192 0 TAB general settings.manage?section_id=general
ec_whatsapp_support 193 0 ADDON ec_whatsapp_support settings.manage?section_id=ec_whatsapp_support
general 194 0 TAB general settings.manage?section_id=general
cr_address_autocomplete 197 0 ADDON cr_address_autocomplete settings.manage?section_id=cr_address_autocomplete
general 198 0 TAB general settings.manage?section_id=general
reward_points 199 0 ADDON reward_points settings.manage?section_id=reward_points
general 166 0 TAB general settings.manage?section_id=general
cp_extended_marketing 165 0 ADDON cp_extended_marketing settings.manage?section_id=cp_extended_marketing
general 161 0 TAB general settings.manage?section_id=general
ab__hide_product_description 144 0 ADDON ab__hide_product_description settings.manage?section_id=ab__hide_product_description
settings 145 0 TAB settings settings.manage?section_id=settings
vendor_privileges 146 0 ADDON vendor_privileges settings.manage?section_id=vendor_privileges
general 147 0 TAB general settings.manage?section_id=general
master_products 148 0 ADDON master_products settings.manage?section_id=master_products
general 149 0 TAB general settings.manage?section_id=general
sd_google_translate_api 150 0 ADDON sd_google_translate_api settings.manage?section_id=sd_google_translate_api
gt_api_general 151 0 TAB gt_api_general settings.manage?section_id=gt_api_general
cp_addons_manager 153 0 ADDON cp_addons_manager settings.manage?section_id=cp_addons_manager
general 154 0 TAB general settings.manage?section_id=general
invoice_editor 156 0 ADDON invoice_editor settings.manage?section_id=invoice_editor
general 157 0 TAB general settings.manage?section_id=general
orders_feedback 158 0 ADDON orders_feedback settings.manage?section_id=orders_feedback
general 159 0 TAB general settings.manage?section_id=general
cp_legal_documents 160 0 ADDON cp_legal_documents settings.manage?section_id=cp_legal_documents
general 200 0 TAB general settings.manage?section_id=general
Image_verification 11 0 CORE Image_verification settings.manage?section_id=Image_verification
vendor_rating 37 0 ADDON vendor_rating settings.manage?section_id=vendor_rating
service 38 0 TAB service settings.manage?section_id=service
vendor_plans 39 0 ADDON vendor_plans settings.manage?section_id=vendor_plans
general 40 0 TAB general settings.manage?section_id=general
vendor_communication 41 0 ADDON vendor_communication settings.manage?section_id=vendor_communication
general 42 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
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
storefront_rest_api 57 0 ADDON storefront_rest_api settings.manage?section_id=storefront_rest_api
general 36 0 TAB general settings.manage?section_id=general
attachments 35 0 ADDON attachments settings.manage?section_id=attachments
general 32 0 TAB general settings.manage?section_id=general
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
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
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
rss_feed 29 0 ADDON rss_feed settings.manage?section_id=rss_feed
general 30 0 TAB general settings.manage?section_id=general
email_marketing 31 0 ADDON email_marketing settings.manage?section_id=email_marketing
general 58 0 TAB general settings.manage?section_id=general
general 86 0 TAB general settings.manage?section_id=general
facebook_pixel 75 0 ADDON facebook_pixel settings.manage?section_id=facebook_pixel
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
access_restrictions 81 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
general 82 0 TAB general settings.manage?section_id=general
banners 83 0 ADDON banners settings.manage?section_id=banners
general 84 0 TAB general settings.manage?section_id=general
ath_thin_theme_settings 85 0 ADDON ath_thin_theme_settings settings.manage?section_id=ath_thin_theme_settings
vendors 69 0 TAB vendors settings.manage?section_id=vendors
vendor_data_premoderation 68 0 ADDON vendor_data_premoderation settings.manage?section_id=vendor_data_premoderation
general 67 0 TAB general settings.manage?section_id=general
general 62 0 TAB general settings.manage?section_id=general
bestsellers 63 0 ADDON bestsellers settings.manage?section_id=bestsellers
general 64 0 TAB general settings.manage?section_id=general
rma 61 0 ADDON rma settings.manage?section_id=rma
general 60 0 TAB general settings.manage?section_id=general
product_bundles 59 0 ADDON product_bundles settings.manage?section_id=product_bundles
seo 66 0 ADDON seo settings.manage?section_id=seo
categories 91 10 TAB categories settings.manage?section_id=categories
styles_desktop 186 10 TAB styles_desktop settings.manage?section_id=styles_desktop
General 2 10 CORE General settings.manage?section_id=General
forbidden_countries 56 10 TAB forbidden_countries settings.manage?section_id=forbidden_countries
facebook 21 10 TAB facebook settings.manage?section_id=facebook
automatic_actions 162 10 TAB automatic_actions settings.manage?section_id=automatic_actions
vendor_panel_style 119 10 TAB vendor_panel_style settings.manage?section_id=vendor_panel_style
logs 155 10 TAB logs settings.manage?section_id=logs
gdpr 116 10 TAB gdpr settings.manage?section_id=gdpr
products 70 10 TAB products settings.manage?section_id=products
newest 65 10 TAB newest settings.manage?section_id=newest
mailchimp 33 10 TAB mailchimp settings.manage?section_id=mailchimp
vendor_to_customer 43 10 TAB vendor_to_customer settings.manage?section_id=vendor_to_customer
cron 152 10 TAB cron settings.manage?section_id=cron
styles_tablet 187 20 TAB styles_tablet settings.manage?section_id=styles_tablet
orders 92 20 TAB orders settings.manage?section_id=orders
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
vkontakte 22 20 TAB vkontakte settings.manage?section_id=vkontakte
pages 93 30 TAB pages settings.manage?section_id=pages
Company 5 30 CORE Company settings.manage?section_id=Company
yandex 23 30 TAB yandex settings.manage?section_id=yandex
styles_phone 188 30 TAB styles_phone settings.manage?section_id=styles_phone
Checkout 6 40 CORE Checkout settings.manage?section_id=Checkout
text_postiion 189 40 TAB text_postiion settings.manage?section_id=text_postiion
testimonials 94 40 TAB testimonials settings.manage?section_id=testimonials
pinterest 24 40 TAB pinterest settings.manage?section_id=pinterest
activation 190 50 TAB activation settings.manage?section_id=activation
companies 95 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