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(
      'ROOT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'VENDOR', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'ULT:ROOT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'ULT:VENDOR', cscart_settings_sections.edition_type
    )
  ) 
ORDER BY 
  cscart_settings_sections.position

Query time 0.00058

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

Result

name section_id position type description href
general 389 0 TAB general settings.manage?section_id=general
image_zoom 357 0 ADDON image_zoom settings.manage?section_id=image_zoom
general 356 0 TAB general settings.manage?section_id=general
recaptcha 355 0 ADDON recaptcha settings.manage?section_id=recaptcha
general 354 0 TAB general settings.manage?section_id=general
seo 353 0 ADDON seo settings.manage?section_id=seo
general 350 0 TAB general settings.manage?section_id=general
settings 348 0 TAB settings settings.manage?section_id=settings
ab__vertical_gallery 347 0 ADDON ab__vertical_gallery settings.manage?section_id=ab__vertical_gallery
settings 346 0 TAB settings settings.manage?section_id=settings
ab__addons_manager 345 0 ADDON ab__addons_manager settings.manage?section_id=ab__addons_manager
newest 306 0 TAB newest settings.manage?section_id=newest
general 305 0 TAB general settings.manage?section_id=general
general 299 0 TAB general settings.manage?section_id=general
google_export 298 0 ADDON google_export settings.manage?section_id=google_export
general 297 0 TAB general settings.manage?section_id=general
general 358 0 TAB general settings.manage?section_id=general
google_analytics 359 0 ADDON google_analytics settings.manage?section_id=google_analytics
general 360 0 TAB general settings.manage?section_id=general
ble_tax 388 0 ADDON ble_tax settings.manage?section_id=ble_tax
general 387 0 TAB general settings.manage?section_id=general
ble_helpdesk 386 0 ADDON ble_helpdesk settings.manage?section_id=ble_helpdesk
general 384 0 TAB general settings.manage?section_id=general
sd_seo_jsonld 383 0 ADDON sd_seo_jsonld settings.manage?section_id=sd_seo_jsonld
general 382 0 TAB general settings.manage?section_id=general
ble_etsy 381 0 ADDON ble_etsy settings.manage?section_id=ble_etsy
section1 378 0 TAB section1 settings.manage?section_id=section1
avatax_tax_calculation 377 0 ADDON avatax_tax_calculation settings.manage?section_id=avatax_tax_calculation
section_commercial_orders 369 0 TAB section_commercial_orders settings.manage?section_id=section_commercial_orders
ble_email 368 0 ADDON ble_email settings.manage?section_id=ble_email
general 364 0 TAB general settings.manage?section_id=general
shipstation 363 0 ADDON shipstation settings.manage?section_id=shipstation
general 362 0 TAB general settings.manage?section_id=general
paypal 361 0 ADDON paypal settings.manage?section_id=paypal
data_feeds 296 0 ADDON data_feeds settings.manage?section_id=data_feeds
general 295 0 TAB general settings.manage?section_id=general
access_restrictions 281 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
general 275 0 TAB general settings.manage?section_id=general
bestsellers 274 0 ADDON bestsellers settings.manage?section_id=bestsellers
general 271 0 TAB general settings.manage?section_id=general
reward_points 270 0 ADDON reward_points settings.manage?section_id=reward_points
general 263 0 TAB general settings.manage?section_id=general
rss_feed 262 0 ADDON rss_feed settings.manage?section_id=rss_feed
Stores 261 0 CORE Stores settings.manage?section_id=Stores
general 92 0 TAB general settings.manage?section_id=general
Security 15 0 CORE Security settings.manage?section_id=Security
Upgrade_center 13 0 CORE Upgrade_center settings.manage?section_id=Upgrade_center
Image_verification 11 0 CORE Image_verification settings.manage?section_id=Image_verification
general 282 0 TAB general settings.manage?section_id=general
banners 283 0 ADDON banners settings.manage?section_id=banners
general 284 0 TAB general settings.manage?section_id=general
google_sitemap 294 0 ADDON google_sitemap settings.manage?section_id=google_sitemap
general 293 0 TAB general settings.manage?section_id=general
Emails 1 0 CORE Emails settings.manage?section_id=Emails
watermarks 292 0 ADDON watermarks settings.manage?section_id=watermarks
gift_certificates 349 0 ADDON gift_certificates settings.manage?section_id=gift_certificates
discussion 285 0 ADDON discussion settings.manage?section_id=discussion
products 286 0 TAB products settings.manage?section_id=products
General 2 10 CORE General settings.manage?section_id=General
products 385 10 TAB products settings.manage?section_id=products
section_new_orders 370 10 TAB section_new_orders settings.manage?section_id=section_new_orders
newest 276 10 TAB newest settings.manage?section_id=newest
categories 287 10 TAB categories settings.manage?section_id=categories
orders 288 20 TAB orders settings.manage?section_id=orders
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
Company 5 30 CORE Company settings.manage?section_id=Company
gift_registry 289 30 TAB gift_registry settings.manage?section_id=gift_registry
Checkout 307 40 CORE Checkout settings.manage?section_id=Checkout
pages 290 40 TAB pages settings.manage?section_id=pages
testimonials 291 50 TAB testimonials settings.manage?section_id=testimonials
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