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

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": 249,
              "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
csc_full_page_cache 193 0 ADDON csc_full_page_cache settings.manage?section_id=csc_full_page_cache
general 173 0 TAB general settings.manage?section_id=general
ab__advanced_sitemap 172 0 ADDON ab__advanced_sitemap settings.manage?section_id=ab__advanced_sitemap
settings 171 0 TAB settings settings.manage?section_id=settings
ab__seo_for_tags 170 0 ADDON ab__seo_for_tags settings.manage?section_id=ab__seo_for_tags
settings 168 0 TAB settings settings.manage?section_id=settings
ab__so_noindex_tech_pages 167 0 ADDON ab__so_noindex_tech_pages settings.manage?section_id=ab__so_noindex_tech_pages
settings 166 0 TAB settings settings.manage?section_id=settings
ab__multiple_cat_descriptions 165 0 ADDON ab__multiple_cat_descriptions settings.manage?section_id=ab__multiple_cat_descriptions
settings 162 0 TAB settings settings.manage?section_id=settings
ab__short_desc_from_features 161 0 ADDON ab__short_desc_from_features settings.manage?section_id=ab__short_desc_from_features
settings 160 0 TAB settings settings.manage?section_id=settings
ab__extended_metadata 177 0 ADDON ab__extended_metadata settings.manage?section_id=ab__extended_metadata
settings 178 0 TAB settings settings.manage?section_id=settings
ab__images_seo 179 0 ADDON ab__images_seo settings.manage?section_id=ab__images_seo
settings 190 0 TAB settings settings.manage?section_id=settings
ab__product_fe02_prom_ua 189 0 ADDON ab__product_fe02_prom_ua settings.manage?section_id=ab__product_fe02_prom_ua
settings 188 0 TAB settings settings.manage?section_id=settings
ab__product_feed_export 187 0 ADDON ab__product_feed_export settings.manage?section_id=ab__product_feed_export
settings 186 0 TAB settings settings.manage?section_id=settings
ab__protection_content_copying 185 0 ADDON ab__protection_content_copying settings.manage?section_id=ab__protection_content_copying
settings 184 0 TAB settings settings.manage?section_id=settings
ab__seo_product_tabs 183 0 ADDON ab__seo_product_tabs settings.manage?section_id=ab__seo_product_tabs
settings 182 0 TAB settings settings.manage?section_id=settings
ab__seo_brands 181 0 ADDON ab__seo_brands settings.manage?section_id=ab__seo_brands
settings 180 0 TAB settings settings.manage?section_id=settings
ab__custom_h1 159 0 ADDON ab__custom_h1 settings.manage?section_id=ab__custom_h1
general 156 0 TAB general settings.manage?section_id=general
ab__deal_of_the_day 131 0 ADDON ab__deal_of_the_day settings.manage?section_id=ab__deal_of_the_day
settings 130 0 TAB settings settings.manage?section_id=settings
ab__hide_product_description 129 0 ADDON ab__hide_product_description settings.manage?section_id=ab__hide_product_description
settings 128 0 TAB settings settings.manage?section_id=settings
ab__landing_categories 127 0 ADDON ab__landing_categories settings.manage?section_id=ab__landing_categories
settings 126 0 TAB settings settings.manage?section_id=settings
ab__search_motivation 125 0 ADDON ab__search_motivation settings.manage?section_id=ab__search_motivation
settings 124 0 TAB settings settings.manage?section_id=settings
ab__scroll_to_top 123 0 ADDON ab__scroll_to_top settings.manage?section_id=ab__scroll_to_top
settings 122 0 TAB settings settings.manage?section_id=settings
ab__video_gallery 121 0 ADDON ab__video_gallery settings.manage?section_id=ab__video_gallery
settings 132 0 TAB settings settings.manage?section_id=settings
ab__stickers 133 0 ADDON ab__stickers settings.manage?section_id=ab__stickers
settings 134 0 TAB settings settings.manage?section_id=settings
ab__seo_filters 155 0 ADDON ab__seo_filters settings.manage?section_id=ab__seo_filters
general 147 0 TAB general settings.manage?section_id=general
ecl_live_search 146 0 ADDON ecl_live_search settings.manage?section_id=ecl_live_search
settings 145 0 TAB settings settings.manage?section_id=settings
ab__antibot 144 0 ADDON ab__antibot settings.manage?section_id=ab__antibot
settings 143 0 TAB settings settings.manage?section_id=settings
ab__preload 142 0 ADDON ab__preload settings.manage?section_id=ab__preload
general 139 0 TAB general settings.manage?section_id=general
ath_mega_menu 138 0 ADDON ath_mega_menu settings.manage?section_id=ath_mega_menu
general 137 0 TAB general settings.manage?section_id=general
rf_content_mistakes 136 0 ADDON rf_content_mistakes settings.manage?section_id=rf_content_mistakes
settings 120 0 TAB settings settings.manage?section_id=settings
general 194 0 TAB general settings.manage?section_id=general
settings 333 0 TAB settings settings.manage?section_id=settings
general 261 0 TAB general settings.manage?section_id=general
cp_live_search 260 0 ADDON cp_live_search settings.manage?section_id=cp_live_search
general 259 0 TAB general settings.manage?section_id=general
cp_free_shipping_left 258 0 ADDON cp_free_shipping_left settings.manage?section_id=cp_free_shipping_left
settings 257 0 TAB settings settings.manage?section_id=settings
ab__image_previewers 256 0 ADDON ab__image_previewers settings.manage?section_id=ab__image_previewers
general 255 0 TAB general settings.manage?section_id=general
rf_fast_login 254 0 ADDON rf_fast_login settings.manage?section_id=rf_fast_login
rf_pro_sms 252 0 ADDON rf_pro_sms settings.manage?section_id=rf_pro_sms
general 253 0 TAB general settings.manage?section_id=general
settings 335 0 TAB settings settings.manage?section_id=settings
general 316 0 TAB general settings.manage?section_id=general
searchanise 268 0 ADDON searchanise settings.manage?section_id=searchanise
configuration 269 0 SEPARATE_TAB configuration settings.manage?section_id=configuration
ab__ukr_cities 332 0 ADDON ab__ukr_cities settings.manage?section_id=ab__ukr_cities
section 325 0 TAB section settings.manage?section_id=section
default_secondary_currency 324 0 ADDON default_secondary_currency settings.manage?section_id=default_secondary_currency
abt__unitheme2 322 0 ADDON abt__unitheme2 settings.manage?section_id=abt__unitheme2
settings 323 0 TAB settings settings.manage?section_id=settings
zapier 315 0 ADDON zapier settings.manage?section_id=zapier
cp_power_reviews 308 0 ADDON cp_power_reviews settings.manage?section_id=cp_power_reviews
settings 275 0 TAB settings settings.manage?section_id=settings
ab__webp 274 0 ADDON ab__webp settings.manage?section_id=ab__webp
general 273 0 TAB general settings.manage?section_id=general
ecloud_search 272 0 ADDON ecloud_search settings.manage?section_id=ecloud_search
general 248 0 TAB general settings.manage?section_id=general
cp_image_gallery 247 0 ADDON cp_image_gallery settings.manage?section_id=cp_image_gallery
general 220 0 TAB general settings.manage?section_id=general
sd_accelerated_pages 219 0 ADDON sd_accelerated_pages settings.manage?section_id=sd_accelerated_pages
general 218 0 TAB general settings.manage?section_id=general
cp_hide_products 217 0 ADDON cp_hide_products settings.manage?section_id=cp_hide_products
cp_addons_manager 241 0 ADDON cp_addons_manager settings.manage?section_id=cp_addons_manager
ab__nova_poshta 334 0 ADDON ab__nova_poshta settings.manage?section_id=ab__nova_poshta
settings 210 0 TAB settings settings.manage?section_id=settings
ab__quick_order_by_phone 209 0 ADDON ab__quick_order_by_phone settings.manage?section_id=ab__quick_order_by_phone
settings 206 0 TAB settings settings.manage?section_id=settings
ab__product_fe07_rozetka 205 0 ADDON ab__product_fe07_rozetka settings.manage?section_id=ab__product_fe07_rozetka
settings 204 0 TAB settings settings.manage?section_id=settings
ab__intelligent_accessories 223 0 ADDON ab__intelligent_accessories settings.manage?section_id=ab__intelligent_accessories
general 224 0 TAB general settings.manage?section_id=general
ab__product_sets 226 0 ADDON ab__product_sets settings.manage?section_id=ab__product_sets
general 246 0 TAB general settings.manage?section_id=general
pdf_documents 245 0 ADDON pdf_documents settings.manage?section_id=pdf_documents
general 242 0 TAB general settings.manage?section_id=general
general 309 0 TAB general settings.manage?section_id=general
service 233 0 TAB service settings.manage?section_id=service
mobile_app 232 0 ADDON mobile_app settings.manage?section_id=mobile_app
general 231 0 TAB general settings.manage?section_id=general
csc_webp_converter 230 0 ADDON csc_webp_converter settings.manage?section_id=csc_webp_converter
settings 229 0 TAB settings settings.manage?section_id=settings
ab__buy_together 228 0 ADDON ab__buy_together settings.manage?section_id=ab__buy_together
settings 227 0 TAB settings settings.manage?section_id=settings
ab__product_fe04_google_rm 203 0 ADDON ab__product_fe04_google_rm settings.manage?section_id=ab__product_fe04_google_rm
ab__fast_navigation 119 0 ADDON ab__fast_navigation settings.manage?section_id=ab__fast_navigation
general 80 0 TAB general settings.manage?section_id=general
general 72 0 TAB general settings.manage?section_id=general
call_requests 71 0 ADDON call_requests settings.manage?section_id=call_requests
general 70 0 TAB general settings.manage?section_id=general
facebook_pixel 69 0 ADDON facebook_pixel settings.manage?section_id=facebook_pixel
general 68 0 TAB general settings.manage?section_id=general
google_analytics 67 0 ADDON google_analytics settings.manage?section_id=google_analytics
general 66 0 TAB general settings.manage?section_id=general
reward_points 65 0 ADDON reward_points settings.manage?section_id=reward_points
general 64 0 TAB general settings.manage?section_id=general
yandex_search 73 0 ADDON yandex_search settings.manage?section_id=yandex_search
general 74 0 TAB general settings.manage?section_id=general
general 29 0 TAB general settings.manage?section_id=general
access_restrictions 79 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
general 78 0 TAB general settings.manage?section_id=general
polls 77 0 ADDON polls settings.manage?section_id=polls
general 76 0 TAB general settings.manage?section_id=general
rss_feed 30 0 ADDON rss_feed settings.manage?section_id=rss_feed
general 31 0 TAB general settings.manage?section_id=general
bestsellers 60 0 ADDON bestsellers settings.manage?section_id=bestsellers
barcode 75 0 ADDON barcode settings.manage?section_id=barcode
seo 63 0 ADDON seo settings.manage?section_id=seo
email_marketing 32 0 ADDON email_marketing settings.manage?section_id=email_marketing
general 50 0 TAB general settings.manage?section_id=general
store_locator 49 0 ADDON store_locator settings.manage?section_id=store_locator
general 48 0 TAB general settings.manage?section_id=general
newsletters 36 0 ADDON newsletters settings.manage?section_id=newsletters
gift_certificates 47 0 ADDON gift_certificates settings.manage?section_id=gift_certificates
general 37 0 TAB general settings.manage?section_id=general
attachments 39 0 ADDON attachments settings.manage?section_id=attachments
general 44 0 TAB general settings.manage?section_id=general
geo_maps 43 0 ADDON geo_maps settings.manage?section_id=geo_maps
product_variations 51 0 ADDON product_variations settings.manage?section_id=product_variations
general 52 0 TAB general settings.manage?section_id=general
general 33 0 TAB general settings.manage?section_id=general
general 61 0 TAB general settings.manage?section_id=general
vendor_communication 41 0 ADDON vendor_communication settings.manage?section_id=vendor_communication
general 59 0 TAB general settings.manage?section_id=general
rma 58 0 ADDON rma settings.manage?section_id=rma
general 56 0 TAB general settings.manage?section_id=general
recaptcha 55 0 ADDON recaptcha settings.manage?section_id=recaptcha
general 54 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 40 0 TAB general settings.manage?section_id=general
general 98 0 TAB general settings.manage?section_id=general
general 102 0 TAB general settings.manage?section_id=general
hybrid_auth 101 0 ADDON hybrid_auth settings.manage?section_id=hybrid_auth
general 100 0 TAB general settings.manage?section_id=general
janrain 99 0 ADDON janrain settings.manage?section_id=janrain
Company 5 0 CORE Company settings.manage?section_id=Company
price_list 97 0 ADDON price_list settings.manage?section_id=price_list
general 96 0 TAB general settings.manage?section_id=general
Image_verification 11 0 CORE Image_verification settings.manage?section_id=Image_verification
catalog_mode 103 0 ADDON catalog_mode settings.manage?section_id=catalog_mode
general 104 0 TAB general settings.manage?section_id=general
rus_personal_data_processing 107 0 ADDON rus_personal_data_processing settings.manage?section_id=rus_personal_data_processing
Emails 1 0 CORE Emails settings.manage?section_id=Emails
settings 116 0 TAB settings settings.manage?section_id=settings
ab__motivation_block 115 0 ADDON ab__motivation_block settings.manage?section_id=ab__motivation_block
settings 114 0 TAB settings settings.manage?section_id=settings
ab__category_banners 113 0 ADDON ab__category_banners settings.manage?section_id=ab__category_banners
settings 110 0 TAB settings settings.manage?section_id=settings
ab__addons_manager 109 0 ADDON ab__addons_manager settings.manage?section_id=ab__addons_manager
general 108 0 TAB general settings.manage?section_id=general
Upgrade_center 13 0 CORE Upgrade_center settings.manage?section_id=Upgrade_center
data_feeds 95 0 ADDON data_feeds settings.manage?section_id=data_feeds
general 94 0 TAB general settings.manage?section_id=general
social_buttons 22 0 ADDON social_buttons settings.manage?section_id=social_buttons
twitter 23 0 TAB twitter settings.manage?section_id=twitter
products 86 0 TAB products settings.manage?section_id=products
discussion 85 0 ADDON discussion settings.manage?section_id=discussion
general 84 0 TAB general settings.manage?section_id=general
tags 28 0 ADDON tags settings.manage?section_id=tags
watermarks 83 0 ADDON watermarks settings.manage?section_id=watermarks
general 82 0 TAB general settings.manage?section_id=general
banners 81 0 ADDON banners settings.manage?section_id=banners
general 21 0 TAB general settings.manage?section_id=general
paypal 20 0 ADDON paypal settings.manage?section_id=paypal
general 19 0 TAB general settings.manage?section_id=general
hidpi 18 0 ADDON hidpi settings.manage?section_id=hidpi
google_sitemap 93 0 ADDON google_sitemap settings.manage?section_id=google_sitemap
general 92 0 TAB general settings.manage?section_id=general
image_zoom 91 0 ADDON image_zoom settings.manage?section_id=image_zoom
Stores 17 0 CORE Stores settings.manage?section_id=Stores
Security 15 0 CORE Security settings.manage?section_id=Security
search_options 262 10 TAB search_options settings.manage?section_id=search_options
promotions 38 10 TAB promotions settings.manage?section_id=promotions
facebook 24 10 TAB facebook settings.manage?section_id=facebook
products 310 10 TAB products settings.manage?section_id=products
logs 243 10 TAB logs settings.manage?section_id=logs
General 2 10 CORE General settings.manage?section_id=General
mailchimp 34 10 TAB mailchimp settings.manage?section_id=mailchimp
vendor_to_customer 42 10 TAB vendor_to_customer settings.manage?section_id=vendor_to_customer
ab__pfe 163 10 TAB ab__pfe settings.manage?section_id=ab__pfe
multiple_descriptions 157 10 TAB multiple_descriptions settings.manage?section_id=multiple_descriptions
301_redirects 169 10 TAB 301_redirects settings.manage?section_id=301_redirects
xml_sitemap 174 10 TAB xml_sitemap settings.manage?section_id=xml_sitemap
newest 62 10 TAB newest settings.manage?section_id=newest
search 148 10 TAB search settings.manage?section_id=search
forbidden_countries 57 10 TAB forbidden_countries settings.manage?section_id=forbidden_countries
thumbnails 221 10 TAB thumbnails settings.manage?section_id=thumbnails
activation 140 10 TAB activation settings.manage?section_id=activation
yandex 45 10 TAB yandex settings.manage?section_id=yandex
appearance 117 10 TAB appearance settings.manage?section_id=appearance
text_stickers 135 10 TAB text_stickers settings.manage?section_id=text_stickers
params_default 225 10 TAB params_default settings.manage?section_id=params_default
galleries_page_settings 249 10 TAB galleries_page_settings settings.manage?section_id=galleries_page_settings
categories 87 10 TAB categories settings.manage?section_id=categories
sort 149 20 TAB sort settings.manage?section_id=sort
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
display_options 263 20 TAB display_options settings.manage?section_id=display_options
orders 88 20 TAB orders settings.manage?section_id=orders
admin_panel 118 20 TAB admin_panel settings.manage?section_id=admin_panel
demo 141 20 TAB demo settings.manage?section_id=demo
category_view 158 20 TAB category_view settings.manage?section_id=category_view
vkontakte 25 20 TAB vkontakte settings.manage?section_id=vkontakte
logo 222 20 TAB logo settings.manage?section_id=logo
google 46 20 TAB google settings.manage?section_id=google
categories 311 20 TAB categories settings.manage?section_id=categories
html_sitemap 175 20 TAB html_sitemap settings.manage?section_id=html_sitemap
ab__sf 164 20 TAB ab__sf settings.manage?section_id=ab__sf
yandex 26 30 TAB yandex settings.manage?section_id=yandex
cron 150 30 TAB cron settings.manage?section_id=cron
search_motivation 264 30 TAB search_motivation settings.manage?section_id=search_motivation
pages 312 30 TAB pages settings.manage?section_id=pages
pages 89 30 TAB pages settings.manage?section_id=pages
xml_images_map 176 30 TAB xml_images_map settings.manage?section_id=xml_images_map
testimonials 313 40 TAB testimonials settings.manage?section_id=testimonials
Checkout 6 40 CORE Checkout settings.manage?section_id=Checkout
search_acceleration 265 40 TAB search_acceleration settings.manage?section_id=search_acceleration
testimonials 90 40 TAB testimonials settings.manage?section_id=testimonials
pinterest 27 40 TAB pinterest settings.manage?section_id=pinterest
pictograms 317 50 TAB pictograms settings.manage?section_id=pictograms
all_reviews 314 60 TAB all_reviews settings.manage?section_id=all_reviews
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