excepInfo: select c.name,c.img,c.id,count(*) as num from iwebshop_goods as go left join iwebshop_category_extend  as ca on go.id = ca.goods_id left join iwebshop_category  as c on c.id = ca.category_id where go.is_del = 0 and go. like "%免疫学%" GROUP BY ca.category_id   limit 20 
 -- 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 'like "%免疫学%" GROUP BY ca.category_id   limit 20' at line 1
excepFile: IWEB_PATH/lib/db/db_class.php
excepLine: 148
excepCode: 1000
excepTime: 2024-05-08 12:04:05
#0 IWEB_PATH/lib/core/query_class.php(216): IDB->query(select c.name,c.img,c.id,count(*) as num from iwebshop_goods as go left join iwebshop_category_extend  as ca on go.id = ca.goods_id left join iwebshop_category  as c on c.id = ca.category_id where go.is_del = 0 and go. like "%免疫学%" GROUP BY ca.category_id   limit 20 )
#1 IWEB_PATH/classes/api.php(209): IQuery->find()
#2 IWEB_PATH/classes/api.php(81): Api::query()
#3 IWEB_PATH/runtime/views/huawei/site/search_list.php(702): Api::run(getGoodsCategoryExtenda)
#4 IWEB_PATH/lib/web/controller/controllerbase_class.php(116): require(IWEB_PATH/runtime/views/huawei/site/search_list.php)
#5 IWEB_PATH/lib/web/controller/controllerbase_class.php(82): IControllerBase->requireFile(IWEB_PATH/runtime/views/huawei/site/search_list.php)
#6 IWEB_PATH/lib/web/controller/controller_class.php(160): IControllerBase->renderView(IWEB_PATH/views/huawei/site/search_list,)
#7 IWEB_PATH/lib/web/action/view_action.php(35): IController->render(IWEB_PATH/views/huawei/site/search_list,)
#8 IWEB_PATH/lib/web/controller/controller_class.php(384): IViewAction->run()
#9 IWEB_PATH/controllers/site.php(555): IController->redirect(search_list)
#10 : Site->search_list()
#11 IWEB_PATH/lib/web/action/inline_action.php(38): call_user_func()
#12 IWEB_PATH/lib/web/controller/controller_class.php(119): IInlineAction->run()
#13 IWEB_PATH/lib/core/webapplication_class.php(76): IController->run(search_list)
#14 IWEB_PATH/lib/core/application_class.php(94): IWebApplication->execRequest()
#15 IWEB_PATH/index.php(5): IApplication->run()