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

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

Result

name section_id position type description href
general 227 0 TAB general settings.manage?section_id=general
general 77 0 TAB general settings.manage?section_id=general
access_restrictions 76 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
general 69 0 TAB general settings.manage?section_id=general
tags 68 0 ADDON tags settings.manage?section_id=tags
general 179 0 TAB general settings.manage?section_id=general
advanced_payment_settings_jp 182 0 ADDON advanced_payment_settings_jp settings.manage?section_id=advanced_payment_settings_jp
general 215 0 TAB general settings.manage?section_id=general
seo 56 0 ADDON seo settings.manage?section_id=seo
general 57 0 TAB general settings.manage?section_id=general
general 46 0 TAB general settings.manage?section_id=general
suppliers 45 0 ADDON suppliers settings.manage?section_id=suppliers
general 44 0 TAB general settings.manage?section_id=general
reward_points 43 0 ADDON reward_points settings.manage?section_id=reward_points
kttmr_auto_change_usergroup 178 0 ADDON kttmr_auto_change_usergroup settings.manage?section_id=kttmr_auto_change_usergroup
ap_point_extension 173 0 ADDON ap_point_extension settings.manage?section_id=ap_point_extension
point_permissions 174 0 TAB point_permissions settings.manage?section_id=point_permissions
kuroneko_webcollect 175 0 ADDON kuroneko_webcollect settings.manage?section_id=kuroneko_webcollect
order_mail_jp 226 0 ADDON order_mail_jp settings.manage?section_id=order_mail_jp
general 225 0 TAB general settings.manage?section_id=general
ap_auto_usergroup_pw 224 0 ADDON ap_auto_usergroup_pw settings.manage?section_id=ap_auto_usergroup_pw
general 223 0 TAB general settings.manage?section_id=general
ap_regular_update_usergroup 222 0 ADDON ap_regular_update_usergroup settings.manage?section_id=ap_regular_update_usergroup
general 221 0 TAB general settings.manage?section_id=general
hw_product_questions 220 0 ADDON hw_product_questions settings.manage?section_id=hw_product_questions
subscription_payment_jp 216 0 ADDON subscription_payment_jp settings.manage?section_id=subscription_payment_jp
kttmr_order_items_list_front 214 0 ADDON kttmr_order_items_list_front settings.manage?section_id=kttmr_order_items_list_front
general 187 0 TAB general settings.manage?section_id=general
kttmr_profiles_add_before 186 0 ADDON kttmr_profiles_add_before settings.manage?section_id=kttmr_profiles_add_before
general 185 0 TAB general settings.manage?section_id=general
kttmr_admin_column 184 0 ADDON kttmr_admin_column settings.manage?section_id=kttmr_admin_column
webcollect 176 0 TAB webcollect settings.manage?section_id=webcollect
general 217 0 TAB general settings.manage?section_id=general
general 38 0 TAB general settings.manage?section_id=general
Emails 1 0 CORE Emails settings.manage?section_id=Emails
general 25 0 TAB general settings.manage?section_id=general
polls 24 0 ADDON polls settings.manage?section_id=polls
general 22 0 TAB general settings.manage?section_id=general
bestsellers 21 0 ADDON bestsellers settings.manage?section_id=bestsellers
general 19 0 TAB general settings.manage?section_id=general
newsletters 18 0 ADDON newsletters settings.manage?section_id=newsletters
Stores 17 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
Company 5 0 CORE Company settings.manage?section_id=Company
banners 26 0 ADDON banners settings.manage?section_id=banners
general 27 0 TAB general settings.manage?section_id=general
localization_jp 37 0 ADDON localization_jp settings.manage?section_id=localization_jp
general 36 0 TAB general settings.manage?section_id=general
data_feeds 35 0 ADDON data_feeds settings.manage?section_id=data_feeds
general 183 0 TAB general settings.manage?section_id=general
products 29 0 TAB products settings.manage?section_id=products
discussion 28 0 ADDON discussion settings.manage?section_id=discussion
General 2 10 CORE General settings.manage?section_id=General
categories 30 10 TAB categories settings.manage?section_id=categories
newest 23 10 TAB newest settings.manage?section_id=newest
jp_holidays 39 10 TAB jp_holidays settings.manage?section_id=jp_holidays
promotions 20 10 TAB promotions settings.manage?section_id=promotions
atobarai 177 10 TAB atobarai settings.manage?section_id=atobarai
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
jp_pdfinv_tab_name 40 20 TAB jp_pdfinv_tab_name settings.manage?section_id=jp_pdfinv_tab_name
orders 31 20 TAB orders settings.manage?section_id=orders
gift_registry 32 30 TAB gift_registry settings.manage?section_id=gift_registry
Checkout 6 40 CORE Checkout settings.manage?section_id=Checkout
pages 33 40 TAB pages settings.manage?section_id=pages
testimonials 34 50 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