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

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": 192,
          "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
facebook_store 498 0 ADDON facebook_store settings.manage?section_id=facebook_store
service 533 0 TAB service settings.manage?section_id=service
sd_braintree 538 0 ADDON sd_braintree settings.manage?section_id=sd_braintree
general 539 0 TAB general settings.manage?section_id=general
ss_clone_options 542 0 ADDON ss_clone_options settings.manage?section_id=ss_clone_options
general 543 0 TAB general settings.manage?section_id=general
cp_google_ench_ecom 546 0 ADDON cp_google_ench_ecom settings.manage?section_id=cp_google_ench_ecom
general 547 0 TAB general settings.manage?section_id=general
ecl_instagram_feed 550 0 ADDON ecl_instagram_feed settings.manage?section_id=ecl_instagram_feed
general 551 0 TAB general settings.manage?section_id=general
pdf_documents 552 0 ADDON pdf_documents settings.manage?section_id=pdf_documents
general 553 0 TAB general settings.manage?section_id=general
general 555 0 TAB general settings.manage?section_id=general
cp_lazyload 565 0 ADDON cp_lazyload settings.manage?section_id=cp_lazyload
cp_webp 579 0 ADDON cp_webp settings.manage?section_id=cp_webp
cp_gtm 581 0 ADDON cp_gtm settings.manage?section_id=cp_gtm
general 582 0 TAB general settings.manage?section_id=general
cp_move_guest_order 585 0 ADDON cp_move_guest_order settings.manage?section_id=cp_move_guest_order
twigmo 532 0 ADDON twigmo settings.manage?section_id=twigmo
mailchimp 531 0 TAB mailchimp settings.manage?section_id=mailchimp
sd_advanced_mailing_lists 530 0 ADDON sd_advanced_mailing_lists settings.manage?section_id=sd_advanced_mailing_lists
general 499 0 TAB general settings.manage?section_id=general
social_buttons 500 0 ADDON social_buttons settings.manage?section_id=social_buttons
twitter 501 0 TAB twitter settings.manage?section_id=twitter
general 630 0 TAB general settings.manage?section_id=general
tags 629 0 ADDON tags settings.manage?section_id=tags
taki_gtm 512 0 ADDON taki_gtm settings.manage?section_id=taki_gtm
general 513 0 TAB general settings.manage?section_id=general
product_variations 514 0 ADDON product_variations settings.manage?section_id=product_variations
general 515 0 TAB general settings.manage?section_id=general
email_marketing 516 0 ADDON email_marketing settings.manage?section_id=email_marketing
general 517 0 TAB general settings.manage?section_id=general
general 566 0 TAB general settings.manage?section_id=general
general 580 0 TAB general settings.manage?section_id=general
sd_get1free 524 0 ADDON sd_get1free settings.manage?section_id=sd_get1free
general 525 0 TAB general settings.manage?section_id=general
cp_seo_fixes 526 0 ADDON cp_seo_fixes settings.manage?section_id=cp_seo_fixes
general 527 0 TAB general settings.manage?section_id=general
general 586 0 TAB general settings.manage?section_id=general
cp_honeypot_captcha 587 0 ADDON cp_honeypot_captcha settings.manage?section_id=cp_honeypot_captcha
general 588 0 TAB general settings.manage?section_id=general
ab__motivation_block 614 0 ADDON ab__motivation_block settings.manage?section_id=ab__motivation_block
settings 615 0 TAB settings settings.manage?section_id=settings
general 643 0 TAB general settings.manage?section_id=general
ab__scroll_to_top 618 0 ADDON ab__scroll_to_top settings.manage?section_id=ab__scroll_to_top
settings 619 0 TAB settings settings.manage?section_id=settings
ab__search_motivation 620 0 ADDON ab__search_motivation settings.manage?section_id=ab__search_motivation
settings 621 0 TAB settings settings.manage?section_id=settings
ab__video_gallery 622 0 ADDON ab__video_gallery settings.manage?section_id=ab__video_gallery
settings 623 0 TAB settings settings.manage?section_id=settings
abt__unitheme2 624 0 ADDON abt__unitheme2 settings.manage?section_id=abt__unitheme2
settings 625 0 TAB settings settings.manage?section_id=settings
cp_custom_theme 626 0 ADDON cp_custom_theme settings.manage?section_id=cp_custom_theme
general 627 0 TAB general settings.manage?section_id=general
cp_smart_image_cropper 631 0 ADDON cp_smart_image_cropper settings.manage?section_id=cp_smart_image_cropper
general 632 0 TAB general settings.manage?section_id=general
discussion 636 0 ADDON discussion settings.manage?section_id=discussion
products 637 0 TAB products settings.manage?section_id=products
settings 613 0 TAB settings settings.manage?section_id=settings
ab__landing_categories 612 0 ADDON ab__landing_categories settings.manage?section_id=ab__landing_categories
settings 611 0 TAB settings settings.manage?section_id=settings
cp_image_gallery 589 0 ADDON cp_image_gallery settings.manage?section_id=cp_image_gallery
general 590 0 TAB general settings.manage?section_id=general
cp_seo_optimization 592 0 ADDON cp_seo_optimization settings.manage?section_id=cp_seo_optimization
general 593 0 TAB general settings.manage?section_id=general
cp_shipping_values 598 0 ADDON cp_shipping_values settings.manage?section_id=cp_shipping_values
general 599 0 TAB general settings.manage?section_id=general
ab__addons_manager 600 0 ADDON ab__addons_manager settings.manage?section_id=ab__addons_manager
settings 601 0 TAB settings settings.manage?section_id=settings
ab__category_banners 602 0 ADDON ab__category_banners settings.manage?section_id=ab__category_banners
settings 603 0 TAB settings settings.manage?section_id=settings
ab__deal_of_the_day 604 0 ADDON ab__deal_of_the_day settings.manage?section_id=ab__deal_of_the_day
settings 605 0 TAB settings settings.manage?section_id=settings
ab__fast_navigation 606 0 ADDON ab__fast_navigation settings.manage?section_id=ab__fast_navigation
settings 607 0 TAB settings settings.manage?section_id=settings
ab__hide_product_description 608 0 ADDON ab__hide_product_description settings.manage?section_id=ab__hide_product_description
settings 609 0 TAB settings settings.manage?section_id=settings
ab__image_previewers 610 0 ADDON ab__image_previewers settings.manage?section_id=ab__image_previewers
product_reviews 642 0 ADDON product_reviews settings.manage?section_id=product_reviews
general 497 0 TAB general settings.manage?section_id=general
price_calculation 443 0 ADDON price_calculation settings.manage?section_id=price_calculation
general 424 0 TAB general settings.manage?section_id=general
hw_snowfall 423 0 ADDON hw_snowfall settings.manage?section_id=hw_snowfall
free_shipping_left 404 0 ADDON free_shipping_left settings.manage?section_id=free_shipping_left
general 405 0 TAB general settings.manage?section_id=general
herbaria 417 0 ADDON herbaria settings.manage?section_id=herbaria
access_restrictions 357 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
general 358 0 TAB general settings.manage?section_id=general
general 92 0 TAB general settings.manage?section_id=general
paypal 425 0 ADDON paypal settings.manage?section_id=paypal
general 426 0 TAB general settings.manage?section_id=general
bestsellers 427 0 ADDON bestsellers settings.manage?section_id=bestsellers
general 438 0 TAB general settings.manage?section_id=general
reward_points 437 0 ADDON reward_points settings.manage?section_id=reward_points
general 436 0 TAB general settings.manage?section_id=general
recaptcha 435 0 ADDON recaptcha settings.manage?section_id=recaptcha
general 434 0 TAB general settings.manage?section_id=general
cp_one_step_checkout 433 0 ADDON cp_one_step_checkout settings.manage?section_id=cp_one_step_checkout
newest 429 0 TAB newest settings.manage?section_id=newest
general 428 0 TAB general settings.manage?section_id=general
general 360 0 TAB general settings.manage?section_id=general
banners 359 0 ADDON banners settings.manage?section_id=banners
searchanise 371 0 ADDON searchanise settings.manage?section_id=searchanise
general 374 0 TAB general settings.manage?section_id=general
seo 373 0 ADDON seo settings.manage?section_id=seo
free_bar_upsell 418 0 TAB free_bar_upsell settings.manage?section_id=free_bar_upsell
Stores 136 0 CORE Stores settings.manage?section_id=Stores
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
configuration 372 0 SEPARATE_TAB configuration settings.manage?section_id=configuration
general 368 0 TAB general settings.manage?section_id=general
google_sitemap 369 0 ADDON google_sitemap settings.manage?section_id=google_sitemap
general 362 0 TAB general settings.manage?section_id=general
data_feeds 361 0 ADDON data_feeds settings.manage?section_id=data_feeds
general 364 0 TAB general settings.manage?section_id=general
gift_certificates 363 0 ADDON gift_certificates settings.manage?section_id=gift_certificates
google_analytics 365 0 ADDON google_analytics settings.manage?section_id=google_analytics
google_export 367 0 ADDON google_export settings.manage?section_id=google_export
general 366 0 TAB general settings.manage?section_id=general
general 370 0 TAB general settings.manage?section_id=general
Emails 1 0 CORE Emails settings.manage?section_id=Emails
image_zoom 496 0 ADDON image_zoom settings.manage?section_id=image_zoom
ecl_google_tag_manager 469 0 ADDON ecl_google_tag_manager settings.manage?section_id=ecl_google_tag_manager
general 470 0 TAB general settings.manage?section_id=general
facebook_pixel 478 0 TAB facebook_pixel settings.manage?section_id=facebook_pixel
sd_facebook_pixel 477 0 ADDON sd_facebook_pixel settings.manage?section_id=sd_facebook_pixel
cp_mobile_layout 479 0 ADDON cp_mobile_layout settings.manage?section_id=cp_mobile_layout
general 480 0 TAB general settings.manage?section_id=general
guest_checkout_pro 481 0 ADDON guest_checkout_pro settings.manage?section_id=guest_checkout_pro
general 482 0 TAB general settings.manage?section_id=general
general 485 0 TAB general settings.manage?section_id=general
sd_affiliate 508 0 ADDON sd_affiliate settings.manage?section_id=sd_affiliate
step_by_step_checkout 488 0 ADDON step_by_step_checkout settings.manage?section_id=step_by_step_checkout
general 489 0 TAB general settings.manage?section_id=general
cp_addons_manager 554 0 ADDON cp_addons_manager settings.manage?section_id=cp_addons_manager
sd_hide_for_usergroups 492 0 ADDON sd_hide_for_usergroups settings.manage?section_id=sd_hide_for_usergroups
general 493 0 TAB general settings.manage?section_id=general
cp_free_shipping_left 494 0 ADDON cp_free_shipping_left settings.manage?section_id=cp_free_shipping_left
general 495 0 TAB general settings.manage?section_id=general
geo_maps 484 0 ADDON geo_maps settings.manage?section_id=geo_maps
general 444 0 TAB general settings.manage?section_id=general
general 509 0 TAB general settings.manage?section_id=general
storefront_rest_api 451 0 ADDON storefront_rest_api settings.manage?section_id=storefront_rest_api
general 460 0 TAB general settings.manage?section_id=general
image_gallery 459 0 ADDON image_gallery settings.manage?section_id=image_gallery
forbidden_countries 483 10 TAB forbidden_countries settings.manage?section_id=forbidden_countries
mailchimp 518 10 TAB mailchimp settings.manage?section_id=mailchimp
appearance 616 10 TAB appearance settings.manage?section_id=appearance
general 452 10 TAB general settings.manage?section_id=general
display 567 10 TAB display settings.manage?section_id=display
logs 556 10 TAB logs settings.manage?section_id=logs
product_details 628 10 TAB product_details settings.manage?section_id=product_details
facebook 502 10 TAB facebook settings.manage?section_id=facebook
cp_settings 633 10 TAB cp_settings settings.manage?section_id=cp_settings
order_statuses 548 10 TAB order_statuses settings.manage?section_id=order_statuses
categories 638 10 TAB categories settings.manage?section_id=categories
order_statuses 583 10 TAB order_statuses settings.manage?section_id=order_statuses
text_banner 510 10 TAB text_banner settings.manage?section_id=text_banner
links 594 10 TAB links settings.manage?section_id=links
galleries_page_settings 591 10 TAB galleries_page_settings settings.manage?section_id=galleries_page_settings
yandex 486 10 TAB yandex settings.manage?section_id=yandex
storefront 534 10 TAB storefront settings.manage?section_id=storefront
General 2 10 CORE General settings.manage?section_id=General
admin_panel 617 20 TAB admin_panel settings.manage?section_id=admin_panel
vkontakte 503 20 TAB vkontakte settings.manage?section_id=vkontakte
ext_links 595 20 TAB ext_links settings.manage?section_id=ext_links
ga4_events 584 20 TAB ga4_events settings.manage?section_id=ga4_events
cp_settings_v 634 20 TAB cp_settings_v settings.manage?section_id=cp_settings_v
non_interaction_events 549 20 TAB non_interaction_events settings.manage?section_id=non_interaction_events
orders 639 20 TAB orders settings.manage?section_id=orders
discount_coupons 511 20 TAB discount_coupons settings.manage?section_id=discount_coupons
madmimi 519 20 TAB madmimi settings.manage?section_id=madmimi
nolazy 568 20 TAB nolazy settings.manage?section_id=nolazy
admin_app 535 20 TAB admin_app settings.manage?section_id=admin_app
google 487 20 TAB google settings.manage?section_id=google
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
pages 640 30 TAB pages settings.manage?section_id=pages
twg_push 536 30 TAB twg_push settings.manage?section_id=twg_push
cp_cron 635 30 TAB cp_cron settings.manage?section_id=cp_cron
Company 5 30 CORE Company settings.manage?section_id=Company
indexing 596 30 TAB indexing settings.manage?section_id=indexing
yandex 504 30 TAB yandex settings.manage?section_id=yandex
Checkout 430 40 CORE Checkout settings.manage?section_id=Checkout
addon 537 40 TAB addon settings.manage?section_id=addon
testimonials 641 40 TAB testimonials settings.manage?section_id=testimonials
pinterest 505 40 TAB pinterest settings.manage?section_id=pinterest
last_modified 597 40 TAB last_modified settings.manage?section_id=last_modified
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