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(
      'ULT:STOREFRONT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'ULT:VENDOR', 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.00037

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "read_sorted_file": {
          "filesort": {
            "sort_key": "cscart_settings_sections.position",
            "table": {
              "table_name": "cscart_settings_sections",
              "access_type": "ALL",
              "rows": 148,
              "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('ULT:STOREFRONT',cscart_settings_sections.edition_type) or find_in_set('ULT:VENDOR',cscart_settings_sections.edition_type) or find_in_set('ULT:ROOT',cscart_settings_sections.edition_type)"
            }
          }
        }
      }
    ]
  }
}

Result

name section_id position type description href
general 78 0 TAB general settings.manage?section_id=general
catalog_mode 99 0 ADDON catalog_mode settings.manage?section_id=catalog_mode
general 100 0 TAB general settings.manage?section_id=general
general 102 0 TAB general settings.manage?section_id=general
janrain 103 0 ADDON janrain settings.manage?section_id=janrain
general 104 0 TAB general settings.manage?section_id=general
zapier 105 0 ADDON zapier settings.manage?section_id=zapier
general 106 0 TAB general settings.manage?section_id=general
gdpr 107 0 ADDON gdpr settings.manage?section_id=gdpr
general 108 0 TAB general settings.manage?section_id=general
ab__addons_manager 110 0 ADDON ab__addons_manager settings.manage?section_id=ab__addons_manager
settings 111 0 TAB settings settings.manage?section_id=settings
ab__extended_metadata 112 0 ADDON ab__extended_metadata settings.manage?section_id=ab__extended_metadata
settings 113 0 TAB settings settings.manage?section_id=settings
ab__lazy_load 114 0 ADDON ab__lazy_load settings.manage?section_id=ab__lazy_load
settings 115 0 TAB settings settings.manage?section_id=settings
general 98 0 TAB general settings.manage?section_id=general
price_list 97 0 ADDON price_list settings.manage?section_id=price_list
banners 79 0 ADDON banners settings.manage?section_id=banners
general 80 0 TAB general settings.manage?section_id=general
discussion 81 0 ADDON discussion settings.manage?section_id=discussion
products 82 0 TAB products settings.manage?section_id=products
hybrid_auth 101 0 ADDON hybrid_auth settings.manage?section_id=hybrid_auth
watermarks 87 0 ADDON watermarks settings.manage?section_id=watermarks
general 88 0 TAB general settings.manage?section_id=general
product_reviews 89 0 ADDON product_reviews settings.manage?section_id=product_reviews
general 90 0 TAB general settings.manage?section_id=general
google_sitemap 91 0 ADDON google_sitemap settings.manage?section_id=google_sitemap
general 92 0 TAB general settings.manage?section_id=general
image_zoom 93 0 ADDON image_zoom settings.manage?section_id=image_zoom
general 94 0 TAB general settings.manage?section_id=general
data_feeds 95 0 ADDON data_feeds settings.manage?section_id=data_feeds
general 96 0 TAB general settings.manage?section_id=general
abt__unitheme2 116 0 ADDON abt__unitheme2 settings.manage?section_id=abt__unitheme2
settings 117 0 TAB settings settings.manage?section_id=settings
settings 137 0 TAB settings settings.manage?section_id=settings
settings 139 0 TAB settings settings.manage?section_id=settings
ab__image_previewers 142 0 ADDON ab__image_previewers settings.manage?section_id=ab__image_previewers
settings 143 0 TAB settings settings.manage?section_id=settings
general 166 0 TAB general settings.manage?section_id=general
wk_buynow 165 0 ADDON wk_buynow settings.manage?section_id=wk_buynow
wk_payment_restrict 146 0 ADDON wk_payment_restrict settings.manage?section_id=wk_payment_restrict
configuration 147 0 TAB configuration settings.manage?section_id=configuration
seometatags 148 0 ADDON seometatags settings.manage?section_id=seometatags
general 149 0 TAB general settings.manage?section_id=general
general 170 0 TAB general settings.manage?section_id=general
smsalert 169 0 ADDON smsalert settings.manage?section_id=smsalert
general 164 0 TAB general settings.manage?section_id=general
razorpay_refunds 163 0 ADDON razorpay_refunds settings.manage?section_id=razorpay_refunds
order_webhook 161 0 ADDON order_webhook settings.manage?section_id=order_webhook
ab__deal_of_the_day 136 0 ADDON ab__deal_of_the_day settings.manage?section_id=ab__deal_of_the_day
settings 135 0 TAB settings settings.manage?section_id=settings
ab__category_banners 118 0 ADDON ab__category_banners settings.manage?section_id=ab__category_banners
settings 119 0 TAB settings settings.manage?section_id=settings
ab__motivation_block 120 0 ADDON ab__motivation_block settings.manage?section_id=ab__motivation_block
settings 121 0 TAB settings settings.manage?section_id=settings
ab__fast_navigation 124 0 ADDON ab__fast_navigation settings.manage?section_id=ab__fast_navigation
settings 125 0 TAB settings settings.manage?section_id=settings
ab__video_gallery 126 0 ADDON ab__video_gallery settings.manage?section_id=ab__video_gallery
settings 127 0 TAB settings settings.manage?section_id=settings
ab__scroll_to_top 128 0 ADDON ab__scroll_to_top settings.manage?section_id=ab__scroll_to_top
settings 129 0 TAB settings settings.manage?section_id=settings
ab__search_motivation 130 0 ADDON ab__search_motivation settings.manage?section_id=ab__search_motivation
settings 131 0 TAB settings settings.manage?section_id=settings
ab__landing_categories 132 0 ADDON ab__landing_categories settings.manage?section_id=ab__landing_categories
settings 133 0 TAB settings settings.manage?section_id=settings
ab__hide_product_description 134 0 ADDON ab__hide_product_description settings.manage?section_id=ab__hide_product_description
OrderWebhookSettings 162 0 TAB OrderWebhookSettings settings.manage?section_id=OrderWebhookSettings
access_restrictions 77 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
Company 5 0 CORE Company settings.manage?section_id=Company
email_marketing 30 0 ADDON email_marketing settings.manage?section_id=email_marketing
general 31 0 TAB general settings.manage?section_id=general
newsletters 34 0 ADDON newsletters settings.manage?section_id=newsletters
general 35 0 TAB general settings.manage?section_id=general
attachments 37 0 ADDON attachments settings.manage?section_id=attachments
general 38 0 TAB general settings.manage?section_id=general
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
gift_certificates 45 0 ADDON gift_certificates settings.manage?section_id=gift_certificates
general 46 0 TAB general settings.manage?section_id=general
product_variations 49 0 ADDON product_variations settings.manage?section_id=product_variations
general 29 0 TAB general settings.manage?section_id=general
rss_feed 28 0 ADDON rss_feed settings.manage?section_id=rss_feed
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
Emails 1 0 CORE Emails settings.manage?section_id=Emails
social_buttons 20 0 ADDON social_buttons settings.manage?section_id=social_buttons
twitter 21 0 TAB twitter settings.manage?section_id=twitter
ab__stickers 138 0 ADDON ab__stickers settings.manage?section_id=ab__stickers
tags 26 0 ADDON tags settings.manage?section_id=tags
general 27 0 TAB general settings.manage?section_id=general
general 50 0 TAB general settings.manage?section_id=general
recaptcha 51 0 ADDON recaptcha settings.manage?section_id=recaptcha
barcode 73 0 ADDON barcode settings.manage?section_id=barcode
general 59 0 TAB general settings.manage?section_id=general
bestsellers 60 0 ADDON bestsellers settings.manage?section_id=bestsellers
general 70 0 TAB general settings.manage?section_id=general
google_analytics 69 0 ADDON google_analytics settings.manage?section_id=google_analytics
facebook_pixel 67 0 ADDON facebook_pixel settings.manage?section_id=facebook_pixel
general 61 0 TAB general settings.manage?section_id=general
seo 63 0 ADDON seo settings.manage?section_id=seo
general 64 0 TAB general settings.manage?section_id=general
general 74 0 TAB general settings.manage?section_id=general
general 57 0 TAB general settings.manage?section_id=general
product_bundles 56 0 ADDON product_bundles settings.manage?section_id=product_bundles
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 76 0 TAB general settings.manage?section_id=general
rma 58 0 ADDON rma settings.manage?section_id=rma
polls 75 0 ADDON polls settings.manage?section_id=polls
general 55 0 TAB general settings.manage?section_id=general
general 68 0 TAB general settings.manage?section_id=general
text_stickers 140 10 TAB text_stickers settings.manage?section_id=text_stickers
customer_notifications 171 10 TAB customer_notifications settings.manage?section_id=customer_notifications
General 2 10 CORE General settings.manage?section_id=General
facebook 22 10 TAB facebook settings.manage?section_id=facebook
yandex 41 10 TAB yandex settings.manage?section_id=yandex
mailchimp 32 10 TAB mailchimp settings.manage?section_id=mailchimp
forbidden_countries 53 10 TAB forbidden_countries settings.manage?section_id=forbidden_countries
gdpr 109 10 TAB gdpr settings.manage?section_id=gdpr
vendor_to_customer 44 10 TAB vendor_to_customer settings.manage?section_id=vendor_to_customer
categories 83 10 TAB categories settings.manage?section_id=categories
promotions 36 10 TAB promotions settings.manage?section_id=promotions
appearance 122 10 TAB appearance settings.manage?section_id=appearance
newest 62 10 TAB newest settings.manage?section_id=newest
vkontakte 23 20 TAB vkontakte settings.manage?section_id=vkontakte
admin_notifications 172 20 TAB admin_notifications settings.manage?section_id=admin_notifications
madmimi 33 20 TAB madmimi settings.manage?section_id=madmimi
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
pictograms 141 20 TAB pictograms settings.manage?section_id=pictograms
admin_panel 123 20 TAB admin_panel settings.manage?section_id=admin_panel
orders 84 20 TAB orders settings.manage?section_id=orders
google 42 20 TAB google settings.manage?section_id=google
yandex 24 30 TAB yandex settings.manage?section_id=yandex
pages 85 30 TAB pages settings.manage?section_id=pages
cod_sms_confirmation 173 30 TAB cod_sms_confirmation settings.manage?section_id=cod_sms_confirmation
Checkout 6 40 CORE Checkout settings.manage?section_id=Checkout
testimonials 86 40 TAB testimonials settings.manage?section_id=testimonials
pinterest 25 40 TAB pinterest settings.manage?section_id=pinterest
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