:(

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'www.miibeian.gov.cn LIMIT 0,12' at line 1 [ SQL语句 ] : SELECT g.goods_id,g.goods_name,g.goods_img,g.goods_pc_img,g.goods_desc,g.shop_price,g.market_price,g.is_integral,g.brand_id,g.cat_id FROM wy_goods AS g LEFT JOIN wy_goods_statistics AS gs ON gs.goods_id=g.goods_id WHERE g.token='jpyshx1450577630' AND g.is_on_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('2215') OR g.goods_id IN ('') ) GROUP BY g.goods_id ORDER BY g.shop_price www.miibeian.gov.cn LIMIT 0,12

错误位置

FILE: D:\yun.cwwic.com\wwwroot\Lib\Driver\Db\DbMysql.class.php  LINE: 320

TRACE

[24-05-14 09:44:05] D:\yun.cwwic.com\wwwroot\Lib\Driver\Db\DbMysql.class.php (320) trace(You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'www.miibeian.gov.cn LIMIT 0,12' at line 1
[ SQL语句 ] : SELECT g.goods_id,g.goods_name,g.goods_img,g.goods_pc_img,g.goods_desc,g.shop_price,g.market_price,g.is_integral,g.brand_id,g.cat_id FROM wy_goods AS g LEFT JOIN wy_goods_statistics AS gs ON gs.goods_id=g.goods_id WHERE g.token='jpyshx1450577630' AND g.is_on_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('2215') OR g.goods_id IN ('') ) GROUP BY g.goods_id ORDER BY g.shop_price www.miibeian.gov.cn LIMIT 0,12, , ERR)
[24-05-14 09:44:05] D:\yun.cwwic.com\wwwroot\Lib\Driver\Db\DbMysql.class.php (107) DbMysql->error()
[24-05-14 09:44:05] D:\yun.cwwic.com\wwwroot\Lib\Core\Model.class.php (1080) DbMysql->query(SELECT g.goods_id,g.goods_name,g.goods_img,g.goods_pc_img,g.goods_desc,g.shop_price,g.market_price,g.is_integral,g.brand_id,g.cat_id FROM wy_goods AS g LEFT JOIN wy_goods_statistics AS gs ON gs.goods_id=g.goods_id WHERE g.token='jpyshx1450577630' AND g.is_on_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('2215') OR g.goods_id IN ('') ) GROUP BY g.goods_id ORDER BY g.shop_price www.miibeian.gov.cn LIMIT 0,12)
[24-05-14 09:44:05] D:\yun.cwwic.com\wwwroot\weiwin\Lib\Action\CommoditywapAction.class.php (2200) Model->query(SELECT g.goods_id,g.goods_name,g.goods_img,g.goods_pc_img,g.goods_desc,g.shop_price,g.market_price,g.is_integral,g.brand_id,g.cat_id FROM #@_goods AS g LEFT JOIN #@_goods_statistics AS gs ON gs.goods_id=g.goods_id WHERE g.token='jpyshx1450577630' AND g.is_on_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('2215') OR g.goods_id IN ('') ) GROUP BY g.goods_id ORDER BY g.shop_price www.miibeian.gov.cn LIMIT 0,12)
[24-05-14 09:44:05] D:\yun.cwwic.com\wwwroot\weiwin\Lib\Action\CommoditywapAction.class.php (1327) CommoditywapAction->category_get_mallgoods(g.cat_id IN ('2215') , , , 12, 1, g.shop_price, www.miibeian.gov.cn, , jpyshx1450577630, 1, , )
[24-05-14 09:44:05] D:\yun.cwwic.com\wwwroot\weiwin\Lib\Action\Pc\GoodsAction.class.php (614) CommoditywapAction->get_mallgoods(jpyshx1450577630, Array, , 1, 12, shop_price, www.miibeian.gov.cn, 1)
[24-05-14 09:44:05] () GoodsAction->goods_category()
[24-05-14 09:44:05] D:\yun.cwwic.com\wwwroot\Lib\Core\App.class.php (174) ReflectionMethod->invoke()
[24-05-14 09:44:05] D:\yun.cwwic.com\wwwroot\Lib\Core\App.class.php (210) App::exec()
[24-05-14 09:44:05] D:\yun.cwwic.com\wwwroot\Lib\Core\Think.class.php (39) App::run()
[24-05-14 09:44:05] D:\yun.cwwic.com\wwwroot\Common\runtime.php (243) Think::start()
[24-05-14 09:44:05] D:\yun.cwwic.com\wwwroot\index.php (60) require(D:\yun.cwwic.com\wwwroot\Common\runtime.php)