消息MySQL Query Error
SQLSELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number FROM `tmotorhobby`.`ecs_goods` AS g, `tmotorhobby`.`ecs_order_info` AS o, `tmotorhobby`.`ecs_order_goods` AS og WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('203','178','179','180','182','183','184','269','181','185','202','187','188','189','190','191','192','193','260','194','195','196','197','198','199','262','261','200','230','231','201','232','233','204','205','209','210','211','212','206','213','214','215','216','207','217','218','219','208','220','221','222','226','234','235','236','227','237','238','239','229','242','273','243','228','240','241','149','274','275','157','245','246','247','158','248','249','250','163','251','142','143','252','253','254','144','255','256','257','225','259','264','263','265','258','267','266','268','270','88','103','148','99','138','139','140','147','155','156','145','146','141','160','161','118','119','132','154','271','272') OR g.goods_id IN ('900','901','902','903','904','976','1022','1045','1103','1104','1136','1141','1143','1153','1163','1164','1171','1176','1177','1180','1182','1192','1195','1204','1211','1212','1224','1226','1245','1246','1250','1268','1269','1270','1271','1272','1273','1274','1275','1309','1314','1324','1327','1333','1334','1346','1356','1371','1372','1374','1375','1376','1388','1390','1392','1430') ) AND o.order_sn >= '20240918' AND g.goods_number > 0 AND og.order_id = o.order_id AND og.goods_id = g.goods_id AND (o.order_status = '1' OR o.order_status = '5') AND (o.pay_status = '2' OR o.pay_status = '1') AND (o.shipping_status = '1' OR o.shipping_status = '2') GROUP BY g.goods_id ORDER BY goods_number DESC, g.goods_id DESC LIMIT 6
错误Query execution was interrupted
代码1317
消息MySQL Query Error
SQLSELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number FROM `tmotorhobby`.`ecs_goods` AS g, `tmotorhobby`.`ecs_order_info` AS o, `tmotorhobby`.`ecs_order_goods` AS og WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('203','178','179','180','182','183','184','269','181','185','202','187','188','189','190','191','192','193','260','194','195','196','197','198','199','262','261','200','230','231','201','232','233','204','205','209','210','211','212','206','213','214','215','216','207','217','218','219','208','220','221','222','226','234','235','236','227','237','238','239','229','242','273','243','228','240','241','149','274','275','157','245','246','247','158','248','249','250','163','251','142','143','252','253','254','144','255','256','257','225','259','264','263','265','258','267','266','268','270','88','103','148','99','138','139','140','147','155','156','145','146','141','160','161','118','119','132','154','271','272') OR g.goods_id IN ('900','901','902','903','904','976','1022','1045','1103','1104','1136','1141','1143','1153','1163','1164','1171','1176','1177','1180','1182','1192','1195','1204','1211','1212','1224','1226','1245','1246','1250','1268','1269','1270','1271','1272','1273','1274','1275','1309','1314','1324','1327','1333','1334','1346','1356','1371','1372','1374','1375','1376','1388','1390','1392','1430') ) AND o.order_sn >= '20240918' AND g.goods_number > 0 AND og.order_id = o.order_id AND og.goods_id = g.goods_id AND (o.order_status = '1' OR o.order_status = '5') AND (o.pay_status = '2' OR o.pay_status = '1') AND (o.shipping_status = '1' OR o.shipping_status = '2') GROUP BY g.goods_id ORDER BY goods_number DESC, g.goods_id DESC LIMIT 6
错误Query execution was interrupted
代码1317
消息MySQL Query Error
SQLDELETE FROM `tmotorhobby`.`ecs_sessions` WHERE expiry < 1758157552
错误MySQL server has gone away
代码2006