消息MySQL Query Error
SQLSELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number FROM `xjd_huitouyu`.`ecs_goods` AS g, `xjd_huitouyu`.`ecs_order_info` AS o, `xjd_huitouyu`.`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 ('113','258','247','126','498','254','260','248','134','257','266','128','261','272','129','792','280','273','795','282','284','283','291','287','760','762','296','753','293','444','286','301','761','773','788','754','185','657','819','114','309','400','311','156','314','331','409','694','615','325','330','690','308','737','344','357','348','360','799','356','724','758','704','349','332','779','448','665','627','808','658','117','364','231','568','411','235','398','161','407','151','371','678','406','373','552','265','363','379','557','789','378','163','390','381','722','202','382','787','188','384','558','749','668','532','529','767','765','160','659','115','772','118','623','625','618','466','624','164','631','467','460','470','734','471','626','474','757','759','733','479','801','165','802','820','459','245','796','748','774','307','729','475','472','730','628','764','756','755','135','821','362','671','127','153','310','264','323','328','319','790','509','316','275','132','403','434','404','682','791','412','436','826','481','339','445','620','766','800','351','747','300','285','374','740','299','771','294','340','234','392','443','377','451','561','304','780','708','784','769','358','738','777','200','752','619','672','255','408','256','227','612','613','312','335','616','793','225','370','263','138','394','499','614','435','510','428','541','512','660','544','661','546','662','543','537','567','554','548','539','545','549','136','653','617','268','133','622','269','396','525','252','274','317','326','334','226','538','547','166','116','366','201','750','770','809','810','811','812','813','768','455','785','376','650','656','705','336','473','814','815','816','186','739','778','119','742','743','744','745','822','823','817','824','818','215','216','219','610','243','1000','1001','1100','1101','1102','1103','1121','1104','1105','1106','1122','1123','1107','1108','1109','1110','1111','1112','1113','1114','1115','1116','1117','1118','1119','1120','1002','1200','1201','1202','1203','1204','1205','1206','1207','1208','1209','1210','1211','1212','1213','1214','1215','1216','1217','1218','1219','1220','1221','1003','1300','1301','1302','1004','1400','1401','1402','1403','1404','1411','1412','1405','1406','1407','1408','1409','1410','1005','1500','1501','1502','1503','1504','1505','1506','1507','1516','1517','1508','1509','1510','1511','1512','1513','1514','1515','1006','1600','1601','1602','1603','1604','1605','1606','1607','1608','1609','1610','1611','1612','1613','1614','1615','932','600','120') OR g.goods_id IN ('2001','2002','2003','2004','2005','2006','2007','2008','2010','2011','2015','2016','2018','2020','3794','3795','3796','3797','3798','3799','3800','3801','3802','3803','3804','3805','3806','3807','3808','3809','3810','3811','3812','3813','3814','3816','3817','3819','3820','3821','3825','3827','3828','3829','3830','3831','3832','3834','3835','3836','3837','3838','3839','3843','3844','3845','4010','4011','4012','4014','4015','4017','4018','4021','4022','4023','4030','4033','4042','4043','4044','4046','4050','4055','4060','4062','4063','4064','4069','4076','4204','4205','4206','4207','4210','4308','4310','4311','4312','4315','4318','4319','4320','4321','4322','4323','4325','4327','4328','4329','4330','4331','4333','4334','4335','4338','4339','4340','4341','4342','4343','4344','4345','4346','4348','4350','4351','4353','4354','4355','4356','4357','4358','4359','4360','4361','4362','4363','4364','4365','4366','4367','4368','4369','4370','4371','4372','4373','4374','4375','4376','4377','4378','4379','4380','4382','4383','4386','4387','4390','4391','4392','4396','4397','4399','4402','4403','4404','4405','4406','4407','4408','4409','4410','4412','4413','4414','4415','4416','4418','4419','4420','4421','4422','4424','4425','4426','4427','4428','4429','4432','4434','4436','4437','4438','4439','4440','4441','4442','4443','4444','4446','4447','4448','4449','4451','4452','4454','4470','4471','4472','4473','4475','4477','4478','4480','4481','4484','4485','4496','4504','4508','4512','5378','5379','5380','5382','5384','5412','5413','5414','5415','5416','5417','5418','5419','5420','5421','5422','5423','5425','5426','5427','5429','5431','5432','5434','5435','5436','5438','5441','5443','5444','5446','5447','5482','5483','5484','5485','5486','5487','5488','5489','5490','5491','5492','5493','5494','5495','5496','5497','5498','5508','5517','5520','5521','5522','5523','5524','5525','5526','5527','5528','5529','5530','5531','5532','5533','5534','5541','5542','5543','5544','5546','5552','5553','5554','5555','5561','5562','5563','5566','5567','5568','5569','5570','5571','5572','5573','5574','5575','5576','5577','5578','5579','5580','5581','5582','5583','5584','5585','5586','5587','5588','5589','5590','5591','5592','5593','5594','5596','5597','5598','5599','5600','5601','5602','5603','5604','5605','5606','5607','5608','5609','5610','5611','5612','5613','5614','5615','5616','5617','5618','5619','5620','5621','5622','5627','5628','5629','5630','5631','5632','5633','5634','5635','5636','5637','5638','5639','5640','5641','5644','5645','5646','5647','5648','5649','5650','5651','5652','5653','5654','5655','5656','5657','5658','5659','5660','5661','5662','5663','5664','5665','5666','5667','5668','5669','5670','5671','5672','5673','5674','5675','5676','5677','5678','5679','5680','5681','5682','5684','5685','5686','5687','5688','5689','5690','5691','5692','5693','5695','5697','5699','5700','5701','5702','5704','5705','5706','5707','5708','5709','5710','5711','5713','5714','5716','5717','5718','5719','5720','5721','5722','5723','5724','5725','5726','5727','5728','5729','5730','5731','5732','5734','5735','5737','5739','5740','5741','5742','5743','5744','5745','5746','5747','5748','5749','5750','5751','5752','5753','5754','5756','5757','5759','5760','5761','5762','5763','5764','5765','5766','5767','5768','5769','5770','5771','5773','5775','5798','5803','5805','5806','5807','5808','5809','5810','5811','5812','5814','5815','5816','5817','5818','5819','5820','5821','5822','5824','5825','5827','5828','5829','5830','5831','5832','5833','5834','5835','5836','5837','5838','5839','5841','5842','5843','5846','5850','5851','5852','5853','5856','5857','5858','5859','5860','5861','5862','5863','5864','5865','5866','5867','5868','5869','5870','5871','5872','5876','5877','5878','5879','5880','5881','5883','5884','5885','5886','5887','5888','5889','5891','5892','5893','5894','5895','5896','5897','5899','5900','5901','5902','5903','5904','5905','5906','5907','5908','5909','5910','5911','5912','5913','5914','5915','5916','5917','5918','5919','5921','5923','5924','5925','5926','5928','5929','5931','5932','5933','5934','5935','5936','5938','5939','5940','5941','5944','5945','5949','5950','5951','5952','5953','5954','5955','5958','5959','5960','5961','5962','5963','5964','5965','5966','5967','5968','5969','5970','5971','5972','5973','5974','5975','5976','5977','5978','5979','5980','5982','5983','5984','5985','5986','5987','5988','5989','5990','5991','5992','5993','5994','5995','5996','5997','5998','5999','6000','6001','6002','6003','6004','6005','6006','6007','6008','6009','6010','6011','6012','6013','6014','6015','6016','6017','6018','6019','6020','6021','6022','6025','6026','6027','6028','6029','6030','6031','6032','6033','6034','6035','6036','6037','6038','6039','6040','6041','6042','6043','6044','6045','6046','6047','6048','6049','6050','6051','6052','6053','6054','6055','6056','6057','6058','6059','6060','6061','6062','6063','6064','6065','6066','6067','6068','6069','6070','6071','6072','6073','6074','6075','6076','6077','6078','6079','6080','6081','6082','6083','6084','6085','6086','6087','6088','6089','6090','6091','6092','6093','6094','6095','6096','6097','6098','6099','6100','6101','6102','6103','6104','6105','6106','6107','6108','6109','6110','6111','6112','6113','6114','6115','6116','6117','6118','6119','6120','6121','6122','6123','6125','6127','6128','6129','6131','6132','6133','6134','6135','6136','6137','6138','6139','6140','6141','6142','6143','6144','6145','6146','6147','6148','6149','6150','6151','6152','6153','6154','6155','6156','6157','6158','6159','6160','6161','6162','6163','6164','6165','6166','6167','6168','6169','6170','6171','6172','6173','6174','6175','6176','6177','6178','6179','6180','6181','6182','6183','6184','6185','6186','6187','6188','6189','6190','6191','6192','6193','6194','6195','6196','6197','6198','6199','6200','6201','6202','6203','6204','6205','6206','6207','6208','6209','6210','6211','6212','6213','6214','6215','6216','6217','6218','6219','6220','6221','6222','6223','6224','6225','6226','6227','6228','6229','6231','6233','6234','6235','6236','6237','6238','6239','6240','6241','6242','6243','6244','6245','6246','6247','6248','6249','6250','6251','6252','6253','6254','6256','6257','6260','6261','6263','6264','6265','6266','6267','6268','6269','6270','6271','6272','6273','6274','6275','6276','6277','6278','6280','6281','6282','6283','6284','6285','6286','6287','6288','6289','6290','6291','6292','6293','6294','6295','6296','6297','6298','6299','6300','6301','6302','6303','6304','6305','6306','6307','6309','6310','6312','6313','6316','6317','6318','6319','6322','6323','6324','6325','6326','6327','6328','6329','6330','6331','6332','6333','6334','6335','6336','6337','6338','6339','6340','6341','6342','6343','6344','6345','6346','6347','6348','6349','6350','6351','6352','6353','6354','6355','6356','6357','6358','6359','6360','6361','6362','6363','6364','6365','6366','6367','6368','6369','6370','6371','6372','6373','6374','6375','6376','6377','6378','6379','6380','6381','6382','6383','6384','6385','6386','6387','6388','6389','6390','6391','6392','6393','6394','6395','6396','6397','6398','6399','6400','6401','6402','6403','6404','6405','6406','6407','6408','6409','6410','6411','6412','6413','6414','6415','6416','6417','6418','6419','6420','6421','6422','6423','6424','6425','6426','6427','6428','6429','6430','6431','6432','6433','6434','6435','6436','6437','6438','6439','6440','6441','6442','6443','6444','6445','6446','6447','6448','6449','6450','6451','6452','6453','6454','6455','6456','6457','6458','6459','6460','6461','6462','6463','6464','6465','6466','6467','6468','6469','6470','6471','6472','6473','6474','6475','6476','6477','6478','6479','6480','6481','6482','6483','6484','6485','6486','6488','6489','6490','6491','6492','6493','6494','6495','6496','6497','6498','6499','6500','6501','6502','6503','6504','6505','6506','6507','6508','6509','6510','6511','6512','6513','6514','6515','6516','6517','6518','6519','6520','6521','6522','6523','6524','6525','6526','6527','6528','6529','6530','6531','6532','6533','6534','6535','6536','6537','6538','6539','6540','6541','6542','6543','6544','6545','6546','6547','6548','6549','6550','6551','6552','6553','6554','6555','6556','6557','6558','6559','6560','6561','6562','6563','6564','6565','6566','6567','6568','6569','6570','6571','6572','6573','6574','6575','6576','6577','6578','6579','6580','6581','6582','6583','6584','6585','6586','6587','6588','6589','6590','6591','6592','6593','6594','6595','6596','6597','6598','6599','6600','6601','6602','6603','6604','6605','6606','6607','6608','6609','6610','6611','6612','6613','6614','6615','6616','6617','6618','6619','6620','6621','6622','6623','6624','6625','6626','6627','6628','6629','6630','6631','6632','6633','6634','6635','6636','6637','6638','6639','6640','6641','6642','6643','6644','6645','6646','6647','6648','6649','6650','6651','6652','6653','6654','6655','6656','6657','6658','6659','6660','6661','6662','6663','6664','6665','6666','6667','6668','6669','6670','6671','6672','6673','6674','6675','6676','6677','6678','6679','6680','6681','6682','6683','6684','6685','6686','6687','6688','6689','6690','6691','6692','6693','6694','6695','6696','6697','6698','6699','6700','6701','6702','6703','6704','6705','6706','6707','6708','6709','6710','6711','6712','6713','6714','6715','6716','6717','6718','6719','6720','6721','6722','6723','6724','6725','6726','6727','6728','6729','6730','6731','6732','6733','6734','6735','6736','6737','6738','6739','6740','6741','6742','6743','6744','6745','6746','6747','6748','6749','6750','6752','6753','6754','6755','6756','6757','6758','6759','6760','6761','6762','6763','6764','6765','6766','6767','6768','6769','6770','6771','6772','6773','6774','6775','6776','6777','6778','6779','6780','6781','6782','6783','6784','6785','6786','6787','6788','6789','6790','6791','6792','6793','6794','6795','6796','6797','6798','6799','6800','6801','6802','6803','6804','6805','6806','6807','6808','6809','6810','6811','6812','6813','6814','6815','6816','6817','6818','6819','6820','6821','6822','6823','6824','6825','6826','6827','6828','6829','6830','6831','6832','6833','6834','6835','6836','6837','6838','6839','6840','6841','6842','6843','6844','6845','6846','6847','6848','6849','6850','6851','6852','6853','6854','6855','6856','6857','6858','6859','6860','6861','6862','6863','6864','6865','6866','6867','6868','6869','6870','6871','6872','6873','6874','6875','6876','6877','6878','6879','6880','6881','6882','6883','6884','6885','6886','6887','6888','6889','6890','6891','6892','6893','6894','6895','6896','6897','6898','6899','6900','6901','6902','6903','6904','6905','6906','6907','6908','6909','6910','6911','6912','6913','6914','7816','7817','7818','7819','7820','7821','7822','7824','7825','7862','7863','7864','7865','7866','7867','7868','7869','7873','7874','7875','7877','7878','7879','7880','7881','7882','7883','7884','7885','7886','7887','7890','7891','7892','7893','7894','7895','7896','7897','7899','7902','7903','7904','7905','7906','7907','7908','7923','10401','10402','10403','10404','10405','10406','10407','10408','10409','10410','10411','10412','10413','10414','10415','10416','10417','10418','10419','10420','10421','10422','10423','11201','11202','11203','11204','11205','11206','11207','11208','11501','11502','11503','11504','11801','11802','12101','12102','12103','12104','12401','12402','12403','12404','12405','12406','12407','12408','12409','12410','12411','12412','12413','12414','12415','12416','12701','12702','12703','12704','12705','12706','12707','13001','13002','13003','13004','13005','13006','13007','13008','13009','13010','13011','13012','13013','13014','13015','13016','13017','13018','13019','13020','13021','13301','13302','13901','13902','13903','13904','13905','13906','13907','13908','13909','13910','13911','13912','14201','14501','14502','14503','14504','14505','14506','14507','14508','14509','14510','14511','14512','14513','14514','14515','14516','14518','14519','14520','14521','14522','14523','14801','14802','14803','14804','15101','15102','15103','15104','15105','15106','15107','15108','15109','15110','15111','15112','15113','15114','15115','15116','15117','15118','15119','15120','15122','15123','15124','15125','15126','15301','15302','15303','15304','15305','15306','15307','15309','15310','15311','15501','15901','15902','16101','16102','16103','16104','16105','16106','16107','16108','16111','16112','16113','16114','16115','16116','16117','16301','16302','16303','16304','16501','16502','16503','16504','16505','16506','16507','16508','16509','16510','16511','16512','16513','16514','16515','16516','16517','16518','16519','17301','17302','17303','17304','17305','17306','17307','17308','17309','17310','17311','17312','17313','17314','17316','17317','17318','17319','17320','17321','17322','17323','17324','17325','17326','17901','17902','17903','17904','17905','17906','17907','17908','17909','18101','18102','18103','18104','18105','18106','18107','18901','18902','18903','18904','18905','18906','18907','19101','19102','19301','19302','19303','19304','19305','19306','19307','19308','19309','19310','19311','19312','19313','19314','19315','19316','19317','19319','19501','19701','19702','19703','19704','19705','19706','19707','19708','19709','19710','19711','19712','19901','19902','19903','19904','19905','19906','19907','19908','19909','19910','19911','19912','19913','19914','19915','19916','20501','20502','20503','20504','20701','21101','21102','21103','21104','21105','21106','21107','21201','21202','21203','21204','21205','21206','21207','21208','21209','21210','21301','21302','21305','21306','21307','21308','21309','21310','21311','21312','21313','21314','21315','21316','21317','21318','21319','21320','21321','21322','21323','21324','21325','21401','21402','21403','21501','21502','21503','21504','21601','21602','21604','21802','21803','21804','21805','22101','22102','22103','22104','22105','22106','22107','22108','22109','22110','22111','22112','22113','22114','22115','22116','22118','22120','22121','22501','22502','22503','22504','22505','22506','22507','22701','22702','22703','22901','22902','22903','22904','23001','23002','23101','23102','23201','23202','23203','23204','23401','23402','23501','23502','23601','24001','24002','24101','24102','24103','24201','24401','24701','24901','24902','25001','25002','25101','25201','25202','25301','25302','25401','25501','25550','25551','25552','25601','25602','25603','25604','25605','25606','25607','25608','25609','25701','25702','25703','25801','25802','25851','25852','25853','25854','25855','25856','25857','25858','25951','26001','26002','26051','26052','26053','26101','26102','26103','26104','26201','26202','26302','26351','26352','26353','26354','26355','26402','26451','26453','26454','26502','29501','29502','50014') ) 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 8
错误Lost connection to MySQL server during query
代码2013
消息MySQL Query Error
SQLSELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number FROM `xjd_huitouyu`.`ecs_goods` AS g, `xjd_huitouyu`.`ecs_order_info` AS o, `xjd_huitouyu`.`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 ('113','258','247','126','498','254','260','248','134','257','266','128','261','272','129','792','280','273','795','282','284','283','291','287','760','762','296','753','293','444','286','301','761','773','788','754','185','657','819','114','309','400','311','156','314','331','409','694','615','325','330','690','308','737','344','357','348','360','799','356','724','758','704','349','332','779','448','665','627','808','658','117','364','231','568','411','235','398','161','407','151','371','678','406','373','552','265','363','379','557','789','378','163','390','381','722','202','382','787','188','384','558','749','668','532','529','767','765','160','659','115','772','118','623','625','618','466','624','164','631','467','460','470','734','471','626','474','757','759','733','479','801','165','802','820','459','245','796','748','774','307','729','475','472','730','628','764','756','755','135','821','362','671','127','153','310','264','323','328','319','790','509','316','275','132','403','434','404','682','791','412','436','826','481','339','445','620','766','800','351','747','300','285','374','740','299','771','294','340','234','392','443','377','451','561','304','780','708','784','769','358','738','777','200','752','619','672','255','408','256','227','612','613','312','335','616','793','225','370','263','138','394','499','614','435','510','428','541','512','660','544','661','546','662','543','537','567','554','548','539','545','549','136','653','617','268','133','622','269','396','525','252','274','317','326','334','226','538','547','166','116','366','201','750','770','809','810','811','812','813','768','455','785','376','650','656','705','336','473','814','815','816','186','739','778','119','742','743','744','745','822','823','817','824','818','215','216','219','610','243','1000','1001','1100','1101','1102','1103','1121','1104','1105','1106','1122','1123','1107','1108','1109','1110','1111','1112','1113','1114','1115','1116','1117','1118','1119','1120','1002','1200','1201','1202','1203','1204','1205','1206','1207','1208','1209','1210','1211','1212','1213','1214','1215','1216','1217','1218','1219','1220','1221','1003','1300','1301','1302','1004','1400','1401','1402','1403','1404','1411','1412','1405','1406','1407','1408','1409','1410','1005','1500','1501','1502','1503','1504','1505','1506','1507','1516','1517','1508','1509','1510','1511','1512','1513','1514','1515','1006','1600','1601','1602','1603','1604','1605','1606','1607','1608','1609','1610','1611','1612','1613','1614','1615','932','600','120') OR g.goods_id IN ('2001','2002','2003','2004','2005','2006','2007','2008','2010','2011','2015','2016','2018','2020','3794','3795','3796','3797','3798','3799','3800','3801','3802','3803','3804','3805','3806','3807','3808','3809','3810','3811','3812','3813','3814','3816','3817','3819','3820','3821','3825','3827','3828','3829','3830','3831','3832','3834','3835','3836','3837','3838','3839','3843','3844','3845','4010','4011','4012','4014','4015','4017','4018','4021','4022','4023','4030','4033','4042','4043','4044','4046','4050','4055','4060','4062','4063','4064','4069','4076','4204','4205','4206','4207','4210','4308','4310','4311','4312','4315','4318','4319','4320','4321','4322','4323','4325','4327','4328','4329','4330','4331','4333','4334','4335','4338','4339','4340','4341','4342','4343','4344','4345','4346','4348','4350','4351','4353','4354','4355','4356','4357','4358','4359','4360','4361','4362','4363','4364','4365','4366','4367','4368','4369','4370','4371','4372','4373','4374','4375','4376','4377','4378','4379','4380','4382','4383','4386','4387','4390','4391','4392','4396','4397','4399','4402','4403','4404','4405','4406','4407','4408','4409','4410','4412','4413','4414','4415','4416','4418','4419','4420','4421','4422','4424','4425','4426','4427','4428','4429','4432','4434','4436','4437','4438','4439','4440','4441','4442','4443','4444','4446','4447','4448','4449','4451','4452','4454','4470','4471','4472','4473','4475','4477','4478','4480','4481','4484','4485','4496','4504','4508','4512','5378','5379','5380','5382','5384','5412','5413','5414','5415','5416','5417','5418','5419','5420','5421','5422','5423','5425','5426','5427','5429','5431','5432','5434','5435','5436','5438','5441','5443','5444','5446','5447','5482','5483','5484','5485','5486','5487','5488','5489','5490','5491','5492','5493','5494','5495','5496','5497','5498','5508','5517','5520','5521','5522','5523','5524','5525','5526','5527','5528','5529','5530','5531','5532','5533','5534','5541','5542','5543','5544','5546','5552','5553','5554','5555','5561','5562','5563','5566','5567','5568','5569','5570','5571','5572','5573','5574','5575','5576','5577','5578','5579','5580','5581','5582','5583','5584','5585','5586','5587','5588','5589','5590','5591','5592','5593','5594','5596','5597','5598','5599','5600','5601','5602','5603','5604','5605','5606','5607','5608','5609','5610','5611','5612','5613','5614','5615','5616','5617','5618','5619','5620','5621','5622','5627','5628','5629','5630','5631','5632','5633','5634','5635','5636','5637','5638','5639','5640','5641','5644','5645','5646','5647','5648','5649','5650','5651','5652','5653','5654','5655','5656','5657','5658','5659','5660','5661','5662','5663','5664','5665','5666','5667','5668','5669','5670','5671','5672','5673','5674','5675','5676','5677','5678','5679','5680','5681','5682','5684','5685','5686','5687','5688','5689','5690','5691','5692','5693','5695','5697','5699','5700','5701','5702','5704','5705','5706','5707','5708','5709','5710','5711','5713','5714','5716','5717','5718','5719','5720','5721','5722','5723','5724','5725','5726','5727','5728','5729','5730','5731','5732','5734','5735','5737','5739','5740','5741','5742','5743','5744','5745','5746','5747','5748','5749','5750','5751','5752','5753','5754','5756','5757','5759','5760','5761','5762','5763','5764','5765','5766','5767','5768','5769','5770','5771','5773','5775','5798','5803','5805','5806','5807','5808','5809','5810','5811','5812','5814','5815','5816','5817','5818','5819','5820','5821','5822','5824','5825','5827','5828','5829','5830','5831','5832','5833','5834','5835','5836','5837','5838','5839','5841','5842','5843','5846','5850','5851','5852','5853','5856','5857','5858','5859','5860','5861','5862','5863','5864','5865','5866','5867','5868','5869','5870','5871','5872','5876','5877','5878','5879','5880','5881','5883','5884','5885','5886','5887','5888','5889','5891','5892','5893','5894','5895','5896','5897','5899','5900','5901','5902','5903','5904','5905','5906','5907','5908','5909','5910','5911','5912','5913','5914','5915','5916','5917','5918','5919','5921','5923','5924','5925','5926','5928','5929','5931','5932','5933','5934','5935','5936','5938','5939','5940','5941','5944','5945','5949','5950','5951','5952','5953','5954','5955','5958','5959','5960','5961','5962','5963','5964','5965','5966','5967','5968','5969','5970','5971','5972','5973','5974','5975','5976','5977','5978','5979','5980','5982','5983','5984','5985','5986','5987','5988','5989','5990','5991','5992','5993','5994','5995','5996','5997','5998','5999','6000','6001','6002','6003','6004','6005','6006','6007','6008','6009','6010','6011','6012','6013','6014','6015','6016','6017','6018','6019','6020','6021','6022','6025','6026','6027','6028','6029','6030','6031','6032','6033','6034','6035','6036','6037','6038','6039','6040','6041','6042','6043','6044','6045','6046','6047','6048','6049','6050','6051','6052','6053','6054','6055','6056','6057','6058','6059','6060','6061','6062','6063','6064','6065','6066','6067','6068','6069','6070','6071','6072','6073','6074','6075','6076','6077','6078','6079','6080','6081','6082','6083','6084','6085','6086','6087','6088','6089','6090','6091','6092','6093','6094','6095','6096','6097','6098','6099','6100','6101','6102','6103','6104','6105','6106','6107','6108','6109','6110','6111','6112','6113','6114','6115','6116','6117','6118','6119','6120','6121','6122','6123','6125','6127','6128','6129','6131','6132','6133','6134','6135','6136','6137','6138','6139','6140','6141','6142','6143','6144','6145','6146','6147','6148','6149','6150','6151','6152','6153','6154','6155','6156','6157','6158','6159','6160','6161','6162','6163','6164','6165','6166','6167','6168','6169','6170','6171','6172','6173','6174','6175','6176','6177','6178','6179','6180','6181','6182','6183','6184','6185','6186','6187','6188','6189','6190','6191','6192','6193','6194','6195','6196','6197','6198','6199','6200','6201','6202','6203','6204','6205','6206','6207','6208','6209','6210','6211','6212','6213','6214','6215','6216','6217','6218','6219','6220','6221','6222','6223','6224','6225','6226','6227','6228','6229','6231','6233','6234','6235','6236','6237','6238','6239','6240','6241','6242','6243','6244','6245','6246','6247','6248','6249','6250','6251','6252','6253','6254','6256','6257','6260','6261','6263','6264','6265','6266','6267','6268','6269','6270','6271','6272','6273','6274','6275','6276','6277','6278','6280','6281','6282','6283','6284','6285','6286','6287','6288','6289','6290','6291','6292','6293','6294','6295','6296','6297','6298','6299','6300','6301','6302','6303','6304','6305','6306','6307','6309','6310','6312','6313','6316','6317','6318','6319','6322','6323','6324','6325','6326','6327','6328','6329','6330','6331','6332','6333','6334','6335','6336','6337','6338','6339','6340','6341','6342','6343','6344','6345','6346','6347','6348','6349','6350','6351','6352','6353','6354','6355','6356','6357','6358','6359','6360','6361','6362','6363','6364','6365','6366','6367','6368','6369','6370','6371','6372','6373','6374','6375','6376','6377','6378','6379','6380','6381','6382','6383','6384','6385','6386','6387','6388','6389','6390','6391','6392','6393','6394','6395','6396','6397','6398','6399','6400','6401','6402','6403','6404','6405','6406','6407','6408','6409','6410','6411','6412','6413','6414','6415','6416','6417','6418','6419','6420','6421','6422','6423','6424','6425','6426','6427','6428','6429','6430','6431','6432','6433','6434','6435','6436','6437','6438','6439','6440','6441','6442','6443','6444','6445','6446','6447','6448','6449','6450','6451','6452','6453','6454','6455','6456','6457','6458','6459','6460','6461','6462','6463','6464','6465','6466','6467','6468','6469','6470','6471','6472','6473','6474','6475','6476','6477','6478','6479','6480','6481','6482','6483','6484','6485','6486','6488','6489','6490','6491','6492','6493','6494','6495','6496','6497','6498','6499','6500','6501','6502','6503','6504','6505','6506','6507','6508','6509','6510','6511','6512','6513','6514','6515','6516','6517','6518','6519','6520','6521','6522','6523','6524','6525','6526','6527','6528','6529','6530','6531','6532','6533','6534','6535','6536','6537','6538','6539','6540','6541','6542','6543','6544','6545','6546','6547','6548','6549','6550','6551','6552','6553','6554','6555','6556','6557','6558','6559','6560','6561','6562','6563','6564','6565','6566','6567','6568','6569','6570','6571','6572','6573','6574','6575','6576','6577','6578','6579','6580','6581','6582','6583','6584','6585','6586','6587','6588','6589','6590','6591','6592','6593','6594','6595','6596','6597','6598','6599','6600','6601','6602','6603','6604','6605','6606','6607','6608','6609','6610','6611','6612','6613','6614','6615','6616','6617','6618','6619','6620','6621','6622','6623','6624','6625','6626','6627','6628','6629','6630','6631','6632','6633','6634','6635','6636','6637','6638','6639','6640','6641','6642','6643','6644','6645','6646','6647','6648','6649','6650','6651','6652','6653','6654','6655','6656','6657','6658','6659','6660','6661','6662','6663','6664','6665','6666','6667','6668','6669','6670','6671','6672','6673','6674','6675','6676','6677','6678','6679','6680','6681','6682','6683','6684','6685','6686','6687','6688','6689','6690','6691','6692','6693','6694','6695','6696','6697','6698','6699','6700','6701','6702','6703','6704','6705','6706','6707','6708','6709','6710','6711','6712','6713','6714','6715','6716','6717','6718','6719','6720','6721','6722','6723','6724','6725','6726','6727','6728','6729','6730','6731','6732','6733','6734','6735','6736','6737','6738','6739','6740','6741','6742','6743','6744','6745','6746','6747','6748','6749','6750','6752','6753','6754','6755','6756','6757','6758','6759','6760','6761','6762','6763','6764','6765','6766','6767','6768','6769','6770','6771','6772','6773','6774','6775','6776','6777','6778','6779','6780','6781','6782','6783','6784','6785','6786','6787','6788','6789','6790','6791','6792','6793','6794','6795','6796','6797','6798','6799','6800','6801','6802','6803','6804','6805','6806','6807','6808','6809','6810','6811','6812','6813','6814','6815','6816','6817','6818','6819','6820','6821','6822','6823','6824','6825','6826','6827','6828','6829','6830','6831','6832','6833','6834','6835','6836','6837','6838','6839','6840','6841','6842','6843','6844','6845','6846','6847','6848','6849','6850','6851','6852','6853','6854','6855','6856','6857','6858','6859','6860','6861','6862','6863','6864','6865','6866','6867','6868','6869','6870','6871','6872','6873','6874','6875','6876','6877','6878','6879','6880','6881','6882','6883','6884','6885','6886','6887','6888','6889','6890','6891','6892','6893','6894','6895','6896','6897','6898','6899','6900','6901','6902','6903','6904','6905','6906','6907','6908','6909','6910','6911','6912','6913','6914','7816','7817','7818','7819','7820','7821','7822','7824','7825','7862','7863','7864','7865','7866','7867','7868','7869','7873','7874','7875','7877','7878','7879','7880','7881','7882','7883','7884','7885','7886','7887','7890','7891','7892','7893','7894','7895','7896','7897','7899','7902','7903','7904','7905','7906','7907','7908','7923','10401','10402','10403','10404','10405','10406','10407','10408','10409','10410','10411','10412','10413','10414','10415','10416','10417','10418','10419','10420','10421','10422','10423','11201','11202','11203','11204','11205','11206','11207','11208','11501','11502','11503','11504','11801','11802','12101','12102','12103','12104','12401','12402','12403','12404','12405','12406','12407','12408','12409','12410','12411','12412','12413','12414','12415','12416','12701','12702','12703','12704','12705','12706','12707','13001','13002','13003','13004','13005','13006','13007','13008','13009','13010','13011','13012','13013','13014','13015','13016','13017','13018','13019','13020','13021','13301','13302','13901','13902','13903','13904','13905','13906','13907','13908','13909','13910','13911','13912','14201','14501','14502','14503','14504','14505','14506','14507','14508','14509','14510','14511','14512','14513','14514','14515','14516','14518','14519','14520','14521','14522','14523','14801','14802','14803','14804','15101','15102','15103','15104','15105','15106','15107','15108','15109','15110','15111','15112','15113','15114','15115','15116','15117','15118','15119','15120','15122','15123','15124','15125','15126','15301','15302','15303','15304','15305','15306','15307','15309','15310','15311','15501','15901','15902','16101','16102','16103','16104','16105','16106','16107','16108','16111','16112','16113','16114','16115','16116','16117','16301','16302','16303','16304','16501','16502','16503','16504','16505','16506','16507','16508','16509','16510','16511','16512','16513','16514','16515','16516','16517','16518','16519','17301','17302','17303','17304','17305','17306','17307','17308','17309','17310','17311','17312','17313','17314','17316','17317','17318','17319','17320','17321','17322','17323','17324','17325','17326','17901','17902','17903','17904','17905','17906','17907','17908','17909','18101','18102','18103','18104','18105','18106','18107','18901','18902','18903','18904','18905','18906','18907','19101','19102','19301','19302','19303','19304','19305','19306','19307','19308','19309','19310','19311','19312','19313','19314','19315','19316','19317','19319','19501','19701','19702','19703','19704','19705','19706','19707','19708','19709','19710','19711','19712','19901','19902','19903','19904','19905','19906','19907','19908','19909','19910','19911','19912','19913','19914','19915','19916','20501','20502','20503','20504','20701','21101','21102','21103','21104','21105','21106','21107','21201','21202','21203','21204','21205','21206','21207','21208','21209','21210','21301','21302','21305','21306','21307','21308','21309','21310','21311','21312','21313','21314','21315','21316','21317','21318','21319','21320','21321','21322','21323','21324','21325','21401','21402','21403','21501','21502','21503','21504','21601','21602','21604','21802','21803','21804','21805','22101','22102','22103','22104','22105','22106','22107','22108','22109','22110','22111','22112','22113','22114','22115','22116','22118','22120','22121','22501','22502','22503','22504','22505','22506','22507','22701','22702','22703','22901','22902','22903','22904','23001','23002','23101','23102','23201','23202','23203','23204','23401','23402','23501','23502','23601','24001','24002','24101','24102','24103','24201','24401','24701','24901','24902','25001','25002','25101','25201','25202','25301','25302','25401','25501','25550','25551','25552','25601','25602','25603','25604','25605','25606','25607','25608','25609','25701','25702','25703','25801','25802','25851','25852','25853','25854','25855','25856','25857','25858','25951','26001','26002','26051','26052','26053','26101','26102','26103','26104','26201','26202','26302','26351','26352','26353','26354','26355','26402','26451','26453','26454','26502','29501','29502','50014') ) 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 8
错误Lost connection to MySQL server during query
代码2013
消息MySQL Query Error
SQLUPDATE `xjd_huitouyu`.`ecs_sessions` SET expiry = '1531350751', ip = '23.226.71.41', 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 = '47132ccacec3af2baab63ceeb1810db3' LIMIT 1
错误MySQL server has gone away
代码2006