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

Query time 0.00149

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "200.20"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "166.00"
      },
      "table": {
        "table_name": "cscart_addons",
        "access_type": "ALL",
        "rows_examined_per_scan": 166,
        "rows_produced_per_join": 166,
        "filtered": "100.00",
        "cost_info": {
          "read_cost": "1.00",
          "eval_cost": "33.20",
          "prefix_cost": "34.20",
          "data_read_per_join": "307K"
        },
        "used_columns": [
          "addon",
          "status",
          "priority",
          "unmanaged"
        ]
      }
    }
  }
}

Result

addon priority status unmanaged
pinta_google_feed 0 A 0
cp_addons_manager 1 A 0
gdpr 1 D 0
hidpi 1 A 0
ab__addons_manager 10 A 0
ec_amazon_syncronizer 23 D 0
altteam_stripe_checkout 100 D 0
buy_together 100 A 0
et_category_banner 100 A 0
et_mega_menu 100 A 0
et_mega_menu_featured_products 100 A 0
help_center 100 A 0
paypal 100 A 0
paypal_checkout 100 A 0
poptin 100 D 0
social_buttons 100 A 0
stripe 100 A 0
stripe_connect 100 A 0
sub_domain 100 A 0
sd_shipping_estimation 200 D 0
tags 200 A 0
rss_feed 490 A 0
cp_power_blog 500 A 0
email_marketing 500 D 0
newsletters 500 A 0
wk_prestashop_connector 500 A 0
attachments 600 A 0
hw_cookie_law 700 D 0
sd_affiliate 700 D 0
customers_also_bought 900 A 0
advanced_import 1000 A 0
cp_filter_booking 1000 A 0
cp_finder_block 1000 A 0
custom_pages 1000 A 0
geo_maps 1000 A 0
mve_plus 1000 A 1
sd_fb_conversion_api 1000 D 0
sd_google_helper 1000 D 0
vendor_categories_fee 1000 A 0
vendor_communication 1000 A 0
vendor_plans 1000 A 0
vendor_terms 1000 D 0
vendor_pages 1010 A 0
gift_certificates 1100 A 0
searchanise 1200 D 0
store_locator 1200 A 0
csc_ml_filters 1500 D 0
ec_rfq 1500 A 0
mobile_app 1500 D 0
pdf_documents 1500 A 0
product_variations 1500 A 0
quickbooks 1500 A 0
recaptcha 1500 A 0
storefront_rest_api 1500 A 1
master_products 1510 D 0
rma 1600 D 0
bestsellers 1700 A 0
blog 1700 A 0
seo 1800 A 0
reward_points 1900 D 0
vendor_data_premoderation 1900 A 0
facebook_pixel 2000 D 0
google_analytics 2000 D 0
ab__advanced_sitemap 2016 D 0
ab__category_banners 2016 D 0
ab__deal_of_the_day 2016 D 0
ab__hide_product_description 2016 D 0
ab__images_seo 2016 D 0
ab__multiple_cat_descriptions 2016 D 0
ab__scroll_to_top 2016 D 0
ab__search_motivation 2016 D 0
ab__seo_for_tags 2016 D 0
ab__short_desc_from_features 2016 D 0
ab__landing_categories 2017 D 0
ab__so_noindex_tech_pages 2017 D 0
ab__video_gallery 2017 A 0
ab__motivation_block 2018 D 0
ab__fast_navigation 2019 D 0
ab__seo_product_tabs 2019 D 0
ab__antibot 2020 D 0
ab__seo_brands 2020 D 0
sms_notifications 2200 D 0
call_requests 2300 A 0
form_builder 2400 A 0
barcode 2500 A 0
otp_verification 2510 D 0
polls 2600 D 0
access_restrictions 2700 D 0
banners 2800 A 0
payments_by_country 2800 D 0
age_verification 2900 D 0
ecl_pdf_invoice 2900 A 0
discussion 3000 A 0
watermarks 3000 D 0
product_reviews 3001 A 0
ad_dev_pos 3100 A 0
ad_posta_adex 3100 A 0
ad_redirection 3100 D 0
cp_booking 3100 D 0
csc_live_search 3100 A 0
csc_product_code_generator 3100 A 0
wishlist 3100 A 0
wm_vendor_domain_redirect 3100 A 0
google_sitemap 3500 D 0
image_zoom 3500 A 0
required_products 3900 A 0
data_feeds 4000 A 0
price_list 4100 A 0
catalog_mode 4200 D 0
graphql_api 4200 A 1
hybrid_auth 4200 A 0
janrain 4200 D 0
zapier 4320 A 0
google_export 5000 D 0
grid_no_description 5000 A 0
replain 5000 A 0
scroller_no_description 5000 A 0
webmarco_edp_quote 5000 A 0
new_category_template 6000 A 0
new_product_template 6000 A 0
ec_table_booking_system 7000 A 0
sd_google_analytics 7000 D 0
ecl_legal_users 7200 A 0
abt__unitheme2 10000 A 0
cp_currency_updater 10000 D 0
full_page_cache_unmanaged 10000 D 1
vendor_locations 10000 D 0
vendor_panel_configurator 10000 A 0
abt__unitheme2_mv 10010 D 0
ec_vendor_filter 10101 A 0
full_page_cache 20000 D 0
pi_sms_adavance_notifications 22000 D 0
ec_ebay_synchronization 50000 A 0
sd_geoip_maxmind 55555 D 0
vendor_store_banner 100000 A 0
ab_warehouse 100500 A 0
ec_stripe_subscription 100500 A 0
energothemes_license 100500 A 0
marco_pay 100500 A 0
vendor_customers 100500 D 0
image_compress_pro 100501 A 0
wk_single_seller_checkout 123457 A 0
wk_woocommerce 429400 D 0
sd_facebook_pixel 777777 D 0
wk_order_delivery_confirmation 1023657 A 0
ab__custom_h1 99999999 D 0
ab__extended_metadata 99999999 D 0
ab__seo_filters 100000000 D 0
et_featured_product_banner_tabs 4294967224 A 0
et_search 4294967291 A 0
sd_google_translate_api 4294967293 D 0
ecl_exchange_rates 4294967294 D 0
ecl_infinite_scroll 4294967294 A 0
ecl_live_search_free 4294967294 D 0
ecl_popup_wrapper 4294967294 A 0
ecl_vendors_metadata 4294967294 A 0
et_banners 4294967294 A 0
et_extended_ratings 4294967294 A 0
et_quick_info 4294967294 A 0
et_vivashop_mv_functionality 4294967294 A 0
et_vivashop_mv_seo 4294967294 D 0
et_vivashop_settings 4294967294 A 0
my_changes 4294967294 D 0
tech_support_chat 4294967294 A 1
vendor_privileges 4294967294 A 0
default_language 4294967295 A 0