^ "SELECT * FROM ( SELECT g.id, g.code,g.barcode,g.name,g.brief,g.class_id,g.images,g.brand_id,g.marketable,g.unit,g.spec,g.params,g.view_count,g.type,g.startnum,g.stepnum,g.cost_freight,g.ctime,g.utime,CAST(p.price * (IFNULL(sg.fee, 20)+100) / 100 AS DECIMAL(10,2)) AS price FROM `jshop_b2c_goods` `g` INNER JOIN `jshop_b2c_products` `p` ON `g`.`id`=`p`.`goods_id` LEFT JOIN `jshop_store_store_goods` `sg` ON `g`.`id`=sg.goods_id and sg.store_id = 1 ) `temp` WHERE  `temp`.`price` > '0'"
0.166544s