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(
      'ROOT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'ULT:ROOT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'VENDOR', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'ULT:VENDOR', cscart_settings_sections.edition_type
    )
  ) 
ORDER BY 
  cscart_settings_sections.position

Query time 0.00056

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_settings_sections ALL 184 Using where; Using filesort

Result

name section_id position type description href
sd_google_autocomplete_address 415 0 ADDON sd_google_autocomplete_address settings.manage?section_id=sd_google_autocomplete_address
general 446 0 TAB general settings.manage?section_id=general
general 448 0 TAB general settings.manage?section_id=general
image_gallery 449 0 ADDON image_gallery settings.manage?section_id=image_gallery
general 450 0 TAB general settings.manage?section_id=general
image_gallery 451 0 TAB image_gallery settings.manage?section_id=image_gallery
ecl_seo_images 452 0 ADDON ecl_seo_images settings.manage?section_id=ecl_seo_images
section1 453 0 TAB section1 settings.manage?section_id=section1
ecl_staff_notes 457 0 ADDON ecl_staff_notes settings.manage?section_id=ecl_staff_notes
general 458 0 TAB general settings.manage?section_id=general
ecl_extra_services 459 0 ADDON ecl_extra_services settings.manage?section_id=ecl_extra_services
general 460 0 TAB general settings.manage?section_id=general
sd_seo_pack 461 0 ADDON sd_seo_pack settings.manage?section_id=sd_seo_pack
general 462 0 TAB general settings.manage?section_id=general
access_restrictions 463 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
general 464 0 TAB general settings.manage?section_id=general
ez_common 465 0 ADDON ez_common settings.manage?section_id=ez_common
sd_labels 445 0 ADDON sd_labels settings.manage?section_id=sd_labels
ez_common 444 0 ADDON ez_common settings.manage?section_id=ez_common
general 441 0 TAB general settings.manage?section_id=general
general 436 0 TAB general settings.manage?section_id=general
sd_youtube 435 0 ADDON sd_youtube settings.manage?section_id=sd_youtube
sd_shipping_estimation 423 0 ADDON sd_shipping_estimation settings.manage?section_id=sd_shipping_estimation
sd_gaa_general 416 0 TAB sd_gaa_general settings.manage?section_id=sd_gaa_general
sd_order_improvements 421 0 ADDON sd_order_improvements settings.manage?section_id=sd_order_improvements
sd_oi_general 422 0 TAB sd_oi_general settings.manage?section_id=sd_oi_general
general 424 0 TAB general settings.manage?section_id=general
sd_pbl_general 443 0 TAB sd_pbl_general settings.manage?section_id=sd_pbl_general
sd_pay_by_link 442 0 ADDON sd_pay_by_link settings.manage?section_id=sd_pay_by_link
cp_size_charts 447 0 ADDON cp_size_charts settings.manage?section_id=cp_size_charts
general 438 0 TAB general settings.manage?section_id=general
store_import 430 0 ADDON store_import settings.manage?section_id=store_import
general 431 0 TAB general settings.manage?section_id=general
recaptcha 433 0 ADDON recaptcha settings.manage?section_id=recaptcha
general 434 0 TAB general settings.manage?section_id=general
gift_certificates 440 0 ADDON gift_certificates settings.manage?section_id=gift_certificates
sd_cart_sharing 492 0 ADDON sd_cart_sharing settings.manage?section_id=sd_cart_sharing
sd_pages_options 471 0 ADDON sd_pages_options settings.manage?section_id=sd_pages_options
ez_common 511 0 ADDON ez_common settings.manage?section_id=ez_common
ez_common 512 0 ADDON ez_common settings.manage?section_id=ez_common
ez_common 513 0 ADDON ez_common settings.manage?section_id=ez_common
ez_common 520 0 ADDON ez_common settings.manage?section_id=ez_common
general 558 0 TAB general settings.manage?section_id=general
popup_cookie_law 554 0 ADDON popup_cookie_law settings.manage?section_id=popup_cookie_law
ab__product_fe04_google_rm 539 0 ADDON ab__product_fe04_google_rm settings.manage?section_id=ab__product_fe04_google_rm
settings 540 0 TAB settings settings.manage?section_id=settings
ecl_google_tag_manager 541 0 ADDON ecl_google_tag_manager settings.manage?section_id=ecl_google_tag_manager
general 542 0 TAB general settings.manage?section_id=general
general 555 0 TAB general settings.manage?section_id=general
ez_common 549 0 ADDON ez_common settings.manage?section_id=ez_common
ez_common 550 0 ADDON ez_common settings.manage?section_id=ez_common
ez_common 551 0 ADDON ez_common settings.manage?section_id=ez_common
ez_common 552 0 ADDON ez_common settings.manage?section_id=ez_common
ez_common 553 0 ADDON ez_common settings.manage?section_id=ez_common
sd_seo_jsonld 536 0 ADDON sd_seo_jsonld settings.manage?section_id=sd_seo_jsonld
sd_google_analytics 531 0 ADDON sd_google_analytics settings.manage?section_id=sd_google_analytics
general 532 0 TAB general settings.manage?section_id=general
product_list_header 472 0 TAB product_list_header settings.manage?section_id=product_list_header
sd_devices_layout 475 0 ADDON sd_devices_layout settings.manage?section_id=sd_devices_layout
general 476 0 TAB general settings.manage?section_id=general
sd_google_tags 481 0 ADDON sd_google_tags settings.manage?section_id=sd_google_tags
general 482 0 TAB general settings.manage?section_id=general
general 537 0 TAB general settings.manage?section_id=general
general 493 0 TAB general settings.manage?section_id=general
general 498 0 TAB general settings.manage?section_id=general
sd_accelerated_pages 497 0 ADDON sd_accelerated_pages settings.manage?section_id=sd_accelerated_pages
ez_common 500 0 ADDON ez_common settings.manage?section_id=ez_common
ez_common 501 0 ADDON ez_common settings.manage?section_id=ez_common
ez_common 502 0 ADDON ez_common settings.manage?section_id=ez_common
ez_common 503 0 ADDON ez_common settings.manage?section_id=ez_common
emo_connector 508 0 ADDON emo_connector settings.manage?section_id=emo_connector
general 509 0 TAB general settings.manage?section_id=general
ez_common 510 0 ADDON ez_common settings.manage?section_id=ez_common
csc_full_page_cache 557 0 ADDON csc_full_page_cache settings.manage?section_id=csc_full_page_cache
general 408 0 TAB general settings.manage?section_id=general
Emails 1 0 CORE Emails settings.manage?section_id=Emails
general 298 0 TAB general settings.manage?section_id=general
paypal 300 0 ADDON paypal settings.manage?section_id=paypal
general 301 0 TAB general settings.manage?section_id=general
bestsellers 437 0 ADDON bestsellers settings.manage?section_id=bestsellers
searchanise 309 0 ADDON searchanise settings.manage?section_id=searchanise
configuration 310 0 SEPARATE_TAB configuration settings.manage?section_id=configuration
call_requests 311 0 ADDON call_requests settings.manage?section_id=call_requests
general 312 0 TAB general settings.manage?section_id=general
image_zoom 313 0 ADDON image_zoom settings.manage?section_id=image_zoom
general 314 0 TAB general settings.manage?section_id=general
hybrid_auth 315 0 ADDON hybrid_auth settings.manage?section_id=hybrid_auth
general 316 0 TAB general settings.manage?section_id=general
social_buttons 317 0 ADDON social_buttons settings.manage?section_id=social_buttons
twitter 318 0 TAB twitter settings.manage?section_id=twitter
live_search 396 0 ADDON live_search settings.manage?section_id=live_search
auto_mail 330 0 ADDON auto_mail settings.manage?section_id=auto_mail
newsletters 297 0 ADDON newsletters settings.manage?section_id=newsletters
general 296 0 TAB general settings.manage?section_id=general
watermarks 295 0 ADDON watermarks settings.manage?section_id=watermarks
Company 5 0 CORE Company settings.manage?section_id=Company
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
general 284 0 TAB general settings.manage?section_id=general
google_sitemap 283 0 ADDON google_sitemap settings.manage?section_id=google_sitemap
general 280 0 TAB general settings.manage?section_id=general
google_analytics 279 0 ADDON google_analytics settings.manage?section_id=google_analytics
products 273 0 TAB products settings.manage?section_id=products
discussion 272 0 ADDON discussion settings.manage?section_id=discussion
general 92 0 TAB general settings.manage?section_id=general
seo 287 0 ADDON seo settings.manage?section_id=seo
general 288 0 TAB general settings.manage?section_id=general
general 308 0 TAB general settings.manage?section_id=general
fraction_quantity 307 0 ADDON fraction_quantity settings.manage?section_id=fraction_quantity
general 331 0 TAB general settings.manage?section_id=general
cp_additional_products 380 0 ADDON cp_additional_products settings.manage?section_id=cp_additional_products
general 379 0 TAB general settings.manage?section_id=general
general 381 0 TAB general settings.manage?section_id=general
1clue_seo_titles 382 0 ADDON 1clue_seo_titles settings.manage?section_id=1clue_seo_titles
general 383 0 TAB general settings.manage?section_id=general
sd_ajax_blocks 407 0 ADDON sd_ajax_blocks settings.manage?section_id=sd_ajax_blocks
1clue_product_inquiry 384 0 ADDON 1clue_product_inquiry settings.manage?section_id=1clue_product_inquiry
section1 385 0 TAB section1 settings.manage?section_id=section1
ez_common 398 0 ADDON ez_common settings.manage?section_id=ez_common
general 397 0 TAB general settings.manage?section_id=general
general 394 0 TAB general settings.manage?section_id=general
banners 393 0 ADDON banners settings.manage?section_id=banners
general 391 0 TAB general settings.manage?section_id=general
google_export 390 0 ADDON google_export settings.manage?section_id=google_export
data_feeds 388 0 ADDON data_feeds settings.manage?section_id=data_feeds
general 387 0 TAB general settings.manage?section_id=general
1clue_related_products 386 0 ADDON 1clue_related_products settings.manage?section_id=1clue_related_products
general 389 0 TAB general settings.manage?section_id=general
general 377 0 TAB general settings.manage?section_id=general
general 375 0 TAB general settings.manage?section_id=general
general 355 0 TAB general settings.manage?section_id=general
general 353 0 TAB general settings.manage?section_id=general
general 351 0 TAB general settings.manage?section_id=general
general 349 0 TAB general settings.manage?section_id=general
general 347 0 TAB general settings.manage?section_id=general
general 345 0 TAB general settings.manage?section_id=general
general 343 0 TAB general settings.manage?section_id=general
general 341 0 TAB general settings.manage?section_id=general
general 357 0 TAB general settings.manage?section_id=general
general 359 0 TAB general settings.manage?section_id=general
general 373 0 TAB general settings.manage?section_id=general
general 371 0 TAB general settings.manage?section_id=general
general 369 0 TAB general settings.manage?section_id=general
general 367 0 TAB general settings.manage?section_id=general
general 365 0 TAB general settings.manage?section_id=general
general 363 0 TAB general settings.manage?section_id=general
general 361 0 TAB general settings.manage?section_id=general
settings 556 10 TAB settings settings.manage?section_id=settings
order_statuses 533 10 TAB order_statuses settings.manage?section_id=order_statuses
promotions 299 10 TAB promotions settings.manage?section_id=promotions
products 538 10 TAB products settings.manage?section_id=products
newest 439 10 TAB newest settings.manage?section_id=newest
General 2 10 CORE General settings.manage?section_id=General
categories 274 10 TAB categories settings.manage?section_id=categories
thumbnails 499 10 TAB thumbnails settings.manage?section_id=thumbnails
data_layer_settings 483 10 TAB data_layer_settings settings.manage?section_id=data_layer_settings
product_block_header 473 10 TAB product_block_header settings.manage?section_id=product_block_header
section2 454 10 TAB section2 settings.manage?section_id=section2
addon_basic 332 10 TAB addon_basic settings.manage?section_id=addon_basic
facebook 319 10 TAB facebook settings.manage?section_id=facebook
orders 275 20 TAB orders settings.manage?section_id=orders
vkontakte 320 20 TAB vkontakte settings.manage?section_id=vkontakte
addon_template_settings 333 20 TAB addon_template_settings settings.manage?section_id=addon_template_settings
section3 455 20 TAB section3 settings.manage?section_id=section3
product_product_header 474 20 TAB product_product_header settings.manage?section_id=product_product_header
events_affecting_the_bounce_rate 534 20 TAB events_affecting_the_bounce_rate settings.manage?section_id=events_affecting_the_bounce_rate
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
gift_registry 276 30 TAB gift_registry settings.manage?section_id=gift_registry
gplus 321 30 TAB gplus settings.manage?section_id=gplus
section4 456 30 TAB section4 settings.manage?section_id=section4
cross_domain_tracking 535 30 TAB cross_domain_tracking settings.manage?section_id=cross_domain_tracking
deprecated 466 30 TAB deprecated settings.manage?section_id=deprecated
yandex 432 35 TAB yandex settings.manage?section_id=yandex
pages 277 40 TAB pages settings.manage?section_id=pages
pinterest 322 40 TAB pinterest settings.manage?section_id=pinterest
Checkout 304 40 CORE Checkout settings.manage?section_id=Checkout
testimonials 278 50 TAB testimonials settings.manage?section_id=testimonials
email 323 50 TAB email settings.manage?section_id=email
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