PolarDBÕâ¸öÀàÐÍsqlΪʲô²¢·¢Á¿²»¸ßÄÜ°ÑAP½Úµãcpu´òµÄºÜ¸ßÄØ£¿

PolarDBÕâ¸öÀàÐÍsqlΪʲô²¢·¢Á¿²»¸ßÄÜ°ÑAP½Úµãcpu´òµÄºÜ¸ßÄØ？ SELECT sdt.produce_id, sdt.customer_id, sdt.company_name AS company_name_m, sdt.prefix_domain_name, sdt.products_id , sdt.products_url_name, sdt.cas_no, sdt.produce_name, sdt.produce_url_name, sdt.goods_picture_s , sdt.goods_picture_m AS goods_picture, sdt.goods_picture_b, sdt.complete_flag, sdt.hot_flag, sdt.main_flag , sdt.grade_name, sdt.content, sdt.package_name, sdt.n_price_type, sdt.n_price_trade_term_type , sdt.n_price_trade_term_text, sdt.n_price, sdt.n_price_unit, sdt.n_price_currency, sdt.n_price_currency_symbol , CASE WHEN CEILING(IFNULL(sdt.n_min_price, 0)) = 0 THEN '0' WHEN sdt.n_price_end_date < CURRENT_DATE() THEN '0' ELSE '1' END AS n_pending_flag, sdt.activity_id, sdt.activity_type, sdt.a_price_trade_term_type, sdt.a_price_trade_term_text , sdt.a_price, sdt.a_price_unit, sdt.a_price_currency, sdt.a_price_currency_symbol FROM t_e_all_produce_seller_activity sdt LEFT JOIN ( SELECT stpr.id, stpr.produce_id FROM t_e_seller_tag_produce stpr INNER JOIN t_e_seller_tag stag ON stag.customer_id = 'us20220607140012825' AND IFNULL(stag.is_website_show, '') != '1' AND IFNULL(stag.delflag, '') != '1' WHERE stpr.tag_id = stag.tag_id AND IFNULL(stpr.is_website_show, '') != '1' AND IFNULL(stpr.delflag, '') != '1' ) tagp ON tagp.produce_id = sdt.produce_id WHERE sdt.customer_id = 'us20220607140012825' AND IFNULL(sdt.delflag, '') != '1' AND tagp.id IS NULL ORDER BY sdt.complete_flag DESC, sdt.main_flag DESC, sdt.activity_id DESC, sdt.hot_flag DESC, n_pending_flag DESC, sdt.produce_update_date DESC LIMIT 24;