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

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": 164,
          "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
anti_fraud 176 0 ADDON anti_fraud settings.manage?section_id=anti_fraud
general 257 0 TAB general settings.manage?section_id=general
customer_profilenotification 258 0 ADDON customer_profilenotification settings.manage?section_id=customer_profilenotification
general 259 0 TAB general settings.manage?section_id=general
layout_manager 262 0 ADDON layout_manager settings.manage?section_id=layout_manager
general 263 0 TAB general settings.manage?section_id=general
ecl_google_recaptcha 264 0 ADDON ecl_google_recaptcha settings.manage?section_id=ecl_google_recaptcha
general 265 0 TAB general settings.manage?section_id=general
general 267 0 TAB general settings.manage?section_id=general
storefront_rest_api 268 0 ADDON storefront_rest_api settings.manage?section_id=storefront_rest_api
gdpr 270 0 ADDON gdpr settings.manage?section_id=gdpr
general 271 0 TAB general settings.manage?section_id=general
sd_google_authenticator 275 0 ADDON sd_google_authenticator settings.manage?section_id=sd_google_authenticator
general 276 0 TAB general settings.manage?section_id=general
general 278 0 TAB general settings.manage?section_id=general
general 280 0 TAB general settings.manage?section_id=general
step_by_step_checkout 283 0 ADDON step_by_step_checkout settings.manage?section_id=step_by_step_checkout
livechat 256 0 ADDON livechat settings.manage?section_id=livechat
general 255 0 TAB general settings.manage?section_id=general
access_restrictions 407 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
general 237 0 TAB general settings.manage?section_id=general
general 239 0 TAB general settings.manage?section_id=general
searchanise 240 0 ADDON searchanise settings.manage?section_id=searchanise
configuration 241 0 SEPARATE_TAB configuration settings.manage?section_id=configuration
suppliers 242 0 ADDON suppliers settings.manage?section_id=suppliers
general 243 0 TAB general settings.manage?section_id=general
general 531 0 TAB general settings.manage?section_id=general
general 245 0 TAB general settings.manage?section_id=general
recaptcha 266 0 ADDON recaptcha settings.manage?section_id=recaptcha
paypal 247 0 ADDON paypal settings.manage?section_id=paypal
general 248 0 TAB general settings.manage?section_id=general
bestsellers 249 0 ADDON bestsellers settings.manage?section_id=bestsellers
general 250 0 TAB general settings.manage?section_id=general
newest 251 0 TAB newest settings.manage?section_id=newest
helpdesk 254 0 ADDON helpdesk settings.manage?section_id=helpdesk
general 284 0 TAB general settings.manage?section_id=general
attachments 285 0 ADDON attachments settings.manage?section_id=attachments
general 286 0 TAB general settings.manage?section_id=general
general 491 0 TAB general settings.manage?section_id=general
general 408 0 TAB general settings.manage?section_id=general
sentry 415 0 ADDON sentry settings.manage?section_id=sentry
general 416 0 TAB general settings.manage?section_id=general
xero_integration 515 0 ADDON xero_integration settings.manage?section_id=xero_integration
general 444 0 TAB general settings.manage?section_id=general
campaign_tracker 490 0 ADDON campaign_tracker settings.manage?section_id=campaign_tracker
hsn_code 443 0 ADDON hsn_code settings.manage?section_id=hsn_code
store_selector 453 0 ADDON store_selector settings.manage?section_id=store_selector
general 454 0 TAB general settings.manage?section_id=general
product_bundles 504 0 ADDON product_bundles settings.manage?section_id=product_bundles
general 505 0 TAB general settings.manage?section_id=general
product_variations 506 0 ADDON product_variations settings.manage?section_id=product_variations
general 507 0 TAB general settings.manage?section_id=general
product_reviews 508 0 ADDON product_reviews settings.manage?section_id=product_reviews
general 509 0 TAB general settings.manage?section_id=general
general 533 0 TAB general settings.manage?section_id=general
themes_changes 532 0 ADDON themes_changes settings.manage?section_id=themes_changes
vendor_communication 287 0 ADDON vendor_communication settings.manage?section_id=vendor_communication
pdf_documents 289 0 ADDON pdf_documents settings.manage?section_id=pdf_documents
general 290 0 TAB general settings.manage?section_id=general
category_breadcrumb 293 0 ADDON category_breadcrumb settings.manage?section_id=category_breadcrumb
general 294 0 TAB general settings.manage?section_id=general
zapier 295 0 ADDON zapier settings.manage?section_id=zapier
general 296 0 TAB general settings.manage?section_id=general
crm 437 0 ADDON crm settings.manage?section_id=crm
general 438 0 TAB general settings.manage?section_id=general
general 526 0 TAB general settings.manage?section_id=general
aws_s3 525 0 ADDON aws_s3 settings.manage?section_id=aws_s3
general 511 0 TAB general settings.manage?section_id=general
hubspot_integration 510 0 ADDON hubspot_integration settings.manage?section_id=hubspot_integration
general 516 0 TAB general settings.manage?section_id=general
mobile_app 316 0 ADDON mobile_app settings.manage?section_id=mobile_app
service 317 0 TAB service settings.manage?section_id=service
advance_data_feeds 530 0 ADDON advance_data_feeds settings.manage?section_id=advance_data_feeds
general 177 0 TAB general settings.manage?section_id=general
Emails 1 0 CORE Emails settings.manage?section_id=Emails
store_locator 222 0 ADDON store_locator settings.manage?section_id=store_locator
general 221 0 TAB general settings.manage?section_id=general
sms_notifications 220 0 ADDON sms_notifications settings.manage?section_id=sms_notifications
general 219 0 TAB general settings.manage?section_id=general
seo 218 0 ADDON seo settings.manage?section_id=seo
general 217 0 TAB general settings.manage?section_id=general
rma 216 0 ADDON rma settings.manage?section_id=rma
general 215 0 TAB general settings.manage?section_id=general
reward_points 214 0 ADDON reward_points settings.manage?section_id=reward_points
general 213 0 TAB general settings.manage?section_id=general
quickbooks 212 0 ADDON quickbooks settings.manage?section_id=quickbooks
general 211 0 TAB general settings.manage?section_id=general
price_list 210 0 ADDON price_list settings.manage?section_id=price_list
general 227 0 TAB general settings.manage?section_id=general
geo_maps 279 0 ADDON geo_maps settings.manage?section_id=geo_maps
tags 224 0 ADDON tags settings.manage?section_id=tags
Image_verification 11 0 CORE Image_verification settings.manage?section_id=Image_verification
Security 15 0 CORE Security settings.manage?section_id=Security
Stores 173 0 CORE Stores settings.manage?section_id=Stores
store_import 238 0 ADDON store_import settings.manage?section_id=store_import
store_import 236 0 ADDON store_import settings.manage?section_id=store_import
Upgrade_center 13 0 CORE Upgrade_center settings.manage?section_id=Upgrade_center
general 233 0 TAB general settings.manage?section_id=general
email_marketing 232 0 ADDON email_marketing settings.manage?section_id=email_marketing
general 231 0 TAB general settings.manage?section_id=general
store_import 230 0 ADDON store_import settings.manage?section_id=store_import
configuration 229 0 SEPARATE_TAB configuration settings.manage?section_id=configuration
searchanise 228 0 ADDON searchanise settings.manage?section_id=searchanise
store_import 226 0 ADDON store_import settings.manage?section_id=store_import
general 225 0 TAB general settings.manage?section_id=general
general 209 0 TAB general settings.manage?section_id=general
polls 208 0 ADDON polls settings.manage?section_id=polls
google_export 198 0 ADDON google_export settings.manage?section_id=google_export
catalog_mode 182 0 ADDON catalog_mode settings.manage?section_id=catalog_mode
general 197 0 TAB general settings.manage?section_id=general
google_analytics 196 0 ADDON google_analytics settings.manage?section_id=google_analytics
general 195 0 TAB general settings.manage?section_id=general
general 183 0 TAB general settings.manage?section_id=general
gift_certificates 194 0 ADDON gift_certificates settings.manage?section_id=gift_certificates
discussion 186 0 ADDON discussion settings.manage?section_id=discussion
data_feeds 184 0 ADDON data_feeds settings.manage?section_id=data_feeds
google_sitemap 200 0 ADDON google_sitemap settings.manage?section_id=google_sitemap
ebay 244 0 ADDON ebay settings.manage?section_id=ebay
products 187 0 TAB products settings.manage?section_id=products
general 199 0 TAB general settings.manage?section_id=general
general 181 0 TAB general settings.manage?section_id=general
general 207 0 TAB general settings.manage?section_id=general
newsletters 206 0 ADDON newsletters settings.manage?section_id=newsletters
banners 178 0 ADDON banners settings.manage?section_id=banners
general 179 0 TAB general settings.manage?section_id=general
general 205 0 TAB general settings.manage?section_id=general
myob 204 0 ADDON myob settings.manage?section_id=myob
barcode 180 0 ADDON barcode settings.manage?section_id=barcode
general 201 0 TAB general settings.manage?section_id=general
janrain 202 0 ADDON janrain settings.manage?section_id=janrain
general 185 0 TAB general settings.manage?section_id=general
general 203 0 TAB general settings.manage?section_id=general
General 2 10 CORE General settings.manage?section_id=General
categories 188 10 TAB categories settings.manage?section_id=categories
mailchimp 234 10 TAB mailchimp settings.manage?section_id=mailchimp
transfer_folder_local_to_s3 527 10 TAB transfer_folder_local_to_s3 settings.manage?section_id=transfer_folder_local_to_s3
for_registration 512 10 TAB for_registration settings.manage?section_id=for_registration
xero_object_tab 517 10 TAB xero_object_tab settings.manage?section_id=xero_object_tab
gdpr 272 10 TAB gdpr settings.manage?section_id=gdpr
vendor_to_customer 288 10 TAB vendor_to_customer settings.manage?section_id=vendor_to_customer
for_crm_form_page_settings 439 10 TAB for_crm_form_page_settings settings.manage?section_id=for_crm_form_page_settings
forbidden_countries 277 10 TAB forbidden_countries settings.manage?section_id=forbidden_countries
yandex 281 10 TAB yandex settings.manage?section_id=yandex
promotions 252 10 TAB promotions settings.manage?section_id=promotions
general 269 10 TAB general settings.manage?section_id=general
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
xero_view_chart_of_account_tab 518 20 TAB xero_view_chart_of_account_tab settings.manage?section_id=xero_view_chart_of_account_tab
orders 189 20 TAB orders settings.manage?section_id=orders
google 282 20 TAB google settings.manage?section_id=google
madmimi 235 20 TAB madmimi settings.manage?section_id=madmimi
admin_panel_style 440 20 TAB admin_panel_style settings.manage?section_id=admin_panel_style
for_objsync 513 20 TAB for_objsync settings.manage?section_id=for_objsync
for_hubspot_logs 514 30 TAB for_hubspot_logs settings.manage?section_id=for_hubspot_logs
xero_payment_tab 519 30 TAB xero_payment_tab settings.manage?section_id=xero_payment_tab
Company 5 30 CORE Company settings.manage?section_id=Company
Checkout 253 40 CORE Checkout settings.manage?section_id=Checkout
xero_view_log_tab 520 40 TAB xero_view_log_tab settings.manage?section_id=xero_view_log_tab
gift_registry 191 40 TAB gift_registry settings.manage?section_id=gift_registry
pages 192 50 TAB pages settings.manage?section_id=pages
testimonials 193 60 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