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

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": 154,
          "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
banners 80 0 ADDON banners settings.manage?section_id=banners
settings 135 0 TAB settings settings.manage?section_id=settings
settings 143 0 TAB settings settings.manage?section_id=settings
ab__fast_navigation 138 0 ADDON ab__fast_navigation settings.manage?section_id=ab__fast_navigation
rus_ruble 108 0 ADDON rus_ruble settings.manage?section_id=rus_ruble
settings 109 0 TAB settings settings.manage?section_id=settings
rus_personal_data_processing 110 0 ADDON rus_personal_data_processing settings.manage?section_id=rus_personal_data_processing
general 111 0 TAB general settings.manage?section_id=general
gdpr 112 0 ADDON gdpr settings.manage?section_id=gdpr
general 113 0 TAB general settings.manage?section_id=general
anti_fraud 115 0 ADDON anti_fraud settings.manage?section_id=anti_fraud
general 116 0 TAB general settings.manage?section_id=general
commerceml 117 0 ADDON commerceml settings.manage?section_id=commerceml
general 118 0 TAB general settings.manage?section_id=general
pdf_documents 119 0 ADDON pdf_documents settings.manage?section_id=pdf_documents
settings 139 0 TAB settings settings.manage?section_id=settings
general 99 0 TAB general settings.manage?section_id=general
general 81 0 TAB general settings.manage?section_id=general
discussion 82 0 ADDON discussion settings.manage?section_id=discussion
products 83 0 TAB products settings.manage?section_id=products
watermarks 88 0 ADDON watermarks settings.manage?section_id=watermarks
general 89 0 TAB general settings.manage?section_id=general
product_reviews 90 0 ADDON product_reviews settings.manage?section_id=product_reviews
general 91 0 TAB general settings.manage?section_id=general
google_sitemap 92 0 ADDON google_sitemap settings.manage?section_id=google_sitemap
general 93 0 TAB general settings.manage?section_id=general
image_zoom 94 0 ADDON image_zoom settings.manage?section_id=image_zoom
general 95 0 TAB general settings.manage?section_id=general
data_feeds 96 0 ADDON data_feeds settings.manage?section_id=data_feeds
general 97 0 TAB general settings.manage?section_id=general
price_list 98 0 ADDON price_list settings.manage?section_id=price_list
general 120 0 TAB general settings.manage?section_id=general
rus_pickpoint 121 0 ADDON rus_pickpoint settings.manage?section_id=rus_pickpoint
csc_fractional_stock 195 0 ADDON csc_fractional_stock settings.manage?section_id=csc_fractional_stock
general 196 0 TAB general settings.manage?section_id=general
general 183 0 TAB general settings.manage?section_id=general
cp_power_blog 182 0 ADDON cp_power_blog settings.manage?section_id=cp_power_blog
settings 212 0 TAB settings settings.manage?section_id=settings
sd_loyalty_program 193 0 ADDON sd_loyalty_program settings.manage?section_id=sd_loyalty_program
general 194 0 TAB general settings.manage?section_id=general
csc_live_search 197 0 ADDON csc_live_search settings.manage?section_id=csc_live_search
general 198 0 TAB general settings.manage?section_id=general
vc_ac_address 205 0 ADDON vc_ac_address settings.manage?section_id=vc_ac_address
general 206 0 TAB general settings.manage?section_id=general
cdek_markup2 207 0 ADDON cdek_markup2 settings.manage?section_id=cdek_markup2
general 208 0 TAB general settings.manage?section_id=general
ecl_extended_metadata 209 0 ADDON ecl_extended_metadata settings.manage?section_id=ecl_extended_metadata
general 159 0 TAB general settings.manage?section_id=general
vc_companions 158 0 ADDON vc_companions settings.manage?section_id=vc_companions
general 122 0 TAB general settings.manage?section_id=general
rus_yandex_metrika 123 0 ADDON rus_yandex_metrika settings.manage?section_id=rus_yandex_metrika
general 124 0 TAB general settings.manage?section_id=general
retailcrm 125 0 ADDON retailcrm settings.manage?section_id=retailcrm
general 126 0 TAB general settings.manage?section_id=general
settings 147 0 TAB settings settings.manage?section_id=settings
ab__hide_product_description 148 0 ADDON ab__hide_product_description settings.manage?section_id=ab__hide_product_description
settings 149 0 TAB settings settings.manage?section_id=settings
ab__deal_of_the_day 150 0 ADDON ab__deal_of_the_day settings.manage?section_id=ab__deal_of_the_day
settings 151 0 TAB settings settings.manage?section_id=settings
ab__stickers 152 0 ADDON ab__stickers settings.manage?section_id=ab__stickers
settings 153 0 TAB settings settings.manage?section_id=settings
ab__image_previewers 156 0 ADDON ab__image_previewers settings.manage?section_id=ab__image_previewers
settings 157 0 TAB settings settings.manage?section_id=settings
settings 210 0 TAB settings settings.manage?section_id=settings
settings 131 0 TAB settings settings.manage?section_id=settings
general 39 0 TAB general settings.manage?section_id=general
general 19 0 TAB general settings.manage?section_id=general
hidpi 18 0 ADDON hidpi settings.manage?section_id=hidpi
vendor_communication 42 0 ADDON vendor_communication settings.manage?section_id=vendor_communication
gift_certificates 44 0 ADDON gift_certificates settings.manage?section_id=gift_certificates
general 45 0 TAB general settings.manage?section_id=general
Stores 17 0 CORE Stores settings.manage?section_id=Stores
store_locator 46 0 ADDON store_locator settings.manage?section_id=store_locator
general 47 0 TAB general settings.manage?section_id=general
product_variations 48 0 ADDON product_variations settings.manage?section_id=product_variations
general 49 0 TAB general settings.manage?section_id=general
geo_maps 38 0 ADDON geo_maps settings.manage?section_id=geo_maps
general 37 0 TAB general settings.manage?section_id=general
tags 26 0 ADDON tags settings.manage?section_id=tags
general 27 0 TAB general settings.manage?section_id=general
rss_feed 28 0 ADDON rss_feed settings.manage?section_id=rss_feed
general 29 0 TAB general settings.manage?section_id=general
newsletters 30 0 ADDON newsletters settings.manage?section_id=newsletters
general 31 0 TAB general settings.manage?section_id=general
settings 133 0 TAB settings settings.manage?section_id=settings
ab__motivation_block 134 0 ADDON ab__motivation_block settings.manage?section_id=ab__motivation_block
ab__scroll_to_top 142 0 ADDON ab__scroll_to_top settings.manage?section_id=ab__scroll_to_top
settings 141 0 TAB settings settings.manage?section_id=settings
attachments 36 0 ADDON attachments settings.manage?section_id=attachments
recaptcha 50 0 ADDON recaptcha settings.manage?section_id=recaptcha
general 51 0 TAB general settings.manage?section_id=general
Security 15 0 CORE Security settings.manage?section_id=Security
ab__landing_categories 146 0 ADDON ab__landing_categories settings.manage?section_id=ab__landing_categories
ab__category_banners 132 0 ADDON ab__category_banners settings.manage?section_id=ab__category_banners
settings 145 0 TAB settings settings.manage?section_id=settings
ab__search_motivation 144 0 ADDON ab__search_motivation settings.manage?section_id=ab__search_motivation
Company 5 0 CORE Company settings.manage?section_id=Company
general 65 0 TAB general settings.manage?section_id=general
Emails 1 0 CORE Emails settings.manage?section_id=Emails
call_requests 70 0 ADDON call_requests settings.manage?section_id=call_requests
general 71 0 TAB general settings.manage?section_id=general
ab__addons_manager 211 0 ADDON ab__addons_manager settings.manage?section_id=ab__addons_manager
abt__unitheme2 130 0 ADDON abt__unitheme2 settings.manage?section_id=abt__unitheme2
reward_points 64 0 ADDON reward_points settings.manage?section_id=reward_points
general 63 0 TAB general settings.manage?section_id=general
storefront_rest_api 53 0 ADDON storefront_rest_api settings.manage?section_id=storefront_rest_api
general 54 0 TAB general settings.manage?section_id=general
Upgrade_center 13 0 CORE Upgrade_center settings.manage?section_id=Upgrade_center
product_bundles 55 0 ADDON product_bundles settings.manage?section_id=product_bundles
general 56 0 TAB general settings.manage?section_id=general
ab__video_gallery 140 0 ADDON ab__video_gallery settings.manage?section_id=ab__video_gallery
bestsellers 59 0 ADDON bestsellers settings.manage?section_id=bestsellers
general 60 0 TAB general settings.manage?section_id=general
Image_verification 11 0 CORE Image_verification settings.manage?section_id=Image_verification
seo 62 0 ADDON seo settings.manage?section_id=seo
search_settings 199 10 TAB search_settings settings.manage?section_id=search_settings
color_scheme 184 10 TAB color_scheme settings.manage?section_id=color_scheme
mapping 127 10 TAB mapping settings.manage?section_id=mapping
General 2 10 CORE General settings.manage?section_id=General
categories 84 10 TAB categories settings.manage?section_id=categories
gdpr 114 10 TAB gdpr settings.manage?section_id=gdpr
vendor_to_customer 43 10 TAB vendor_to_customer settings.manage?section_id=vendor_to_customer
newest 61 10 TAB newest settings.manage?section_id=newest
yandex 40 10 TAB yandex settings.manage?section_id=yandex
appearance 136 10 TAB appearance settings.manage?section_id=appearance
promotions 32 10 TAB promotions settings.manage?section_id=promotions
text_stickers 154 10 TAB text_stickers settings.manage?section_id=text_stickers
forbidden_countries 52 10 TAB forbidden_countries settings.manage?section_id=forbidden_countries
categories_settings 200 20 TAB categories_settings settings.manage?section_id=categories_settings
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
admin_panel 137 20 TAB admin_panel settings.manage?section_id=admin_panel
orders 85 20 TAB orders settings.manage?section_id=orders
pictograms 155 20 TAB pictograms settings.manage?section_id=pictograms
posts_list_settings 185 20 TAB posts_list_settings settings.manage?section_id=posts_list_settings
google 41 20 TAB google settings.manage?section_id=google
article_page_settings 186 30 TAB article_page_settings settings.manage?section_id=article_page_settings
sort_settings 201 30 TAB sort_settings settings.manage?section_id=sort_settings
pages 86 30 TAB pages settings.manage?section_id=pages
testimonials 87 40 TAB testimonials settings.manage?section_id=testimonials
storefronts 202 40 TAB storefronts settings.manage?section_id=storefronts
Checkout 6 40 CORE Checkout settings.manage?section_id=Checkout
subscription_settings 187 40 TAB subscription_settings settings.manage?section_id=subscription_settings
elements 203 50 TAB elements settings.manage?section_id=elements
xml_settings 188 50 TAB xml_settings settings.manage?section_id=xml_settings
styles 204 60 TAB styles settings.manage?section_id=styles
cp_blog 192 60 TAB cp_blog settings.manage?section_id=cp_blog
cp_blog 191 60 TAB cp_blog settings.manage?section_id=cp_blog
seo_tab 189 60 TAB seo_tab settings.manage?section_id=seo_tab
cp_blog 181 60 TAB cp_blog settings.manage?section_id=cp_blog
yandex_rss 190 70 TAB yandex_rss settings.manage?section_id=yandex_rss
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