SELECT 
  addon, 
  priority, 
  status, 
  unmanaged 
FROM 
  addons 
WHERE 
  1 
ORDER BY 
  priority

Query time 0.00676

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "100.35"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "91.00"
      },
      "table": {
        "table_name": "addons",
        "access_type": "ALL",
        "rows_examined_per_scan": 91,
        "rows_produced_per_join": 91,
        "filtered": "100.00",
        "cost_info": {
          "read_cost": "0.25",
          "eval_cost": "9.10",
          "prefix_cost": "9.35",
          "data_read_per_join": "168K"
        },
        "used_columns": [
          "addon",
          "status",
          "priority",
          "unmanaged"
        ]
      }
    }
  }
}

Result

addon priority status unmanaged
ss_prom_vendor 1 A 0
security_patch_4_15_1 1 A 0
as_gi_changes 1 A 0
hidpi 1 D 0
ez_tax_reporting 1 A 0
cp_addons_manager 1 A 0
shippo_shipments 6 A 0
as_gi_custom_checkout 8 D 0
address_autocomplete 9 A 0
onestepcheckout 9 A 0
ss_custom_lincoln_changes 10 A 0
vendor_product_page_pro 100 A 0
stripe_connect 100 A 0
image_cropper 100 A 0
paypal_commerce_platform 100 A 0
as_options_inventory 200 A 0
rss_feed 490 D 0
attachments 600 A 0
guest_checkout_pro 900 A 0
sd_vendor_modification 1000 A 0
geo_maps 1000 A 0
emails_delays 1000 D 0
mve_plus 1000 A 1
sd_design_changes 1000 A 0
sd_enhancement_vendor_accounting 1000 A 0
sd_gift_recipient_address 1000 A 0
shareasale 1000 D 0
advanced_import 1000 A 0
vendor_communication 1000 A 0
vendor_plans 1000 A 0
vendor_terms 1000 A 0
ath_subdomain_homepage 1070 A 0
wk_vendor_subdomain 1075 A 0
custom_domain 1075 A 0
gift_certificates 1100 A 0
storefront_rest_api 1500 A 1
csc_vendor_gallery 1500 A 0
recaptcha 1500 A 0
seo 1800 A 0
tracking_services 2000 A 0
cp_honeypot_captcha 2000 D 0
algolia 2100 A 0
sd_google_tags 2100 D 0
anti_bot 2100 A 0
form_builder 2400 A 0
access_restrictions 2700 A 0
banners 2800 A 0
ath_thin_theme_settings 2828 A 0
ath_custom__goimagine_com 2829 A 0
ath_tac_notice 2830 A 0
ath_vendor_subdomain_blocks 2830 A 0
ath_sliding_filter_panel 2830 A 0
ecl_search_improvements 2900 D 0
ecl_exim_reviews 2900 A 0
pounds_conversion 3000 A 0
vendor_shipping_autocreate 3000 A 0
discussion 3000 A 0
wishlist 3100 A 0
csc_product_code_generator 3100 A 0
csc_live_search 3100 D 0
csc_admin_colors 3100 D 0
google_sitemap 3500 D 0
data_feeds 4000 A 0
cp_otp_registration 4000 D 0
sd_vendor_ratings 4000 D 0
price_list 4100 D 0
graphql_api 4200 A 1
cp_sms_services 5000 D 0
google_export 5000 A 0
sd_google_analytics 7000 D 0
ss_product_shippings 10000 D 0
ss_promotion_simple 10000 A 0
ss_product_es_change 10000 A 0
ss_vendor_disable_billing 10000 A 0
ss_vendor_search_changes 10000 A 0
ss_lincoln_options_changes 10000 A 0
vendor_locations 10000 A 0
sd_eagleowl 20000 D 0
sd_taxjar 70000 D 0
sd_advanced_social_buttons 100000 D 0
vendor_store_banner 100000 A 0
sd_facebook_pixel 777777 D 0
wk_seller_vacations 1230656 A 0
klaviyo 99999999 A 0
vendor_debt_payout 4294967294 D 0
my_changes 4294967294 A 0
tech_support_chat 4294967294 A 1
ecl_custom_headers 4294967294 A 0
ecl_google_recaptcha 4294967294 D 0
ss_vendor_categories 4294967295 A 0
ss_permission_tabs 4294967295 A 0