[ SQL ] SELECT `a`.*,`c`.`cn_name`,`c`.`en_name`,`c`.`list_tpl` FROM `cmf_portal_product` `a` INNER JOIN `cmf_portal_category` `c` ON `a`.`cat_id`=`c`.`id` WHERE `a`.`published_time` >= '0' AND `c`.`list_tpl` = 'product' AND `a`.`delete_time` = '0' AND `a`.`post_status` = '1' AND ( `a`.`cat_id` = '54' ) ORDER BY `update_time` DESC LIMIT 0,12 [ RunTime:0.000262s ]
English
