消息MySQL Query Error
SQLSELECT b.brand_id, b.brand_name, b.brand_logo, COUNT(*) AS goods_num FROM `yidiancn`.`ecs_brand`AS b, `yidiancn`.`ecs_goods` AS g LEFT JOIN `yidiancn`.`ecs_goods_cat` AS gc ON g.goods_id = gc.goods_id WHERE g.brand_id = b.brand_id AND (g.cat_id IN ('8075','8142','8139','8140','8141','8138') OR gc.cat_id IN ('8075','8142','8139','8140','8141','8138') ) AND b.is_show = 1 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY b.sort_order, b.brand_id ASC
错误Query execution was interrupted
代码1317
消息MySQL Query Error
SQLSELECT b.brand_id, b.brand_name, b.brand_logo, COUNT(*) AS goods_num FROM `yidiancn`.`ecs_brand`AS b, `yidiancn`.`ecs_goods` AS g LEFT JOIN `yidiancn`.`ecs_goods_cat` AS gc ON g.goods_id = gc.goods_id WHERE g.brand_id = b.brand_id AND (g.cat_id IN ('8075','8142','8139','8140','8141','8138') OR gc.cat_id IN ('8075','8142','8139','8140','8141','8138') ) AND b.is_show = 1 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY b.sort_order, b.brand_id ASC
错误Query execution was interrupted
代码1317
消息MySQL Query Error
SQLUPDATE `yidiancn`.`ecs_sessions` SET expiry = '1719416401', ip = '3.147.140.18', userid = '0', adminid = '0', user_name='0', user_rank='0', discount='1', email='0', data = 'a:3:{s:7:\"from_ad\";i:0;s:7:\"referer\";s:6:\"本站\";s:10:\"login_fail\";i:0;}' WHERE sesskey = 'bc0da187956f0016024d1b5fabe56f40' LIMIT 1
错误MySQL server has gone away
代码2006