[ DB ] CONNECT:[ UseTime:0.005404s ] mysql:host=101.201.70.13;port=3306;dbname=yizhayan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzyarticleclass` [ RunTime:0.004405s ]
[ SQL ] SELECT * FROM `yzyarticleclass` WHERE `ac_id` <= 7 ORDER BY `ac_sort` ASC [ RunTime:0.003657s ]
[ SQL ] SHOW COLUMNS FROM `yzyarticle` [ RunTime:0.004273s ]
[ SQL ] SELECT `article`.`article_id`,`article`.`ac_id`,`article`.`article_url`,`article`.`article_title`,`article`.`article_time`,`article_class`.`ac_name`,`article_class`.`ac_parent_id` FROM `yzyarticle` `article` LEFT JOIN `yzyarticleclass` `article_class` ON `article`.`ac_id`=`article_class`.`ac_id` WHERE ( article.article_show = '1' and (article_class.ac_id <= 7 or (article_class.ac_parent_id > 0 and article_class.ac_parent_id <= 7)) ) ORDER BY `article_sort` ASC,`article_time` DESC LIMIT 300 [ RunTime:0.003777s ]
[ SQL ] SHOW COLUMNS FROM `yzygoodscommon` [ RunTime:0.004721s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_body`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`mall_goods_commend` = 1 AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_sort` ASC LIMIT 5 [ RunTime:0.084341s ]
[ SQL ] SHOW COLUMNS FROM `yzypxianshigoods` [ RunTime:0.004369s ]
[ SQL ] SELECT * FROM `yzypxianshigoods` WHERE `xianshigoods_state` = 1 AND `xianshigoods_starttime` < 1634652177 AND `xianshigoods_end_time` > 1634652177 ORDER BY `xianshigoods_recommend` DESC LIMIT 5 [ RunTime:0.004206s ]
[ SQL ] SHOW COLUMNS FROM `yzygoods` [ RunTime:0.004488s ]
[ SQL ] SELECT * FROM `yzygoods` WHERE `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_addtime` DESC LIMIT 5 [ RunTime:2.454722s ]
[ SQL ] SHOW COLUMNS FROM `yzygroupbuy` [ RunTime:0.004461s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzygroupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1634652177 AND `groupbuy_endtime` > 1634652177 LIMIT 1 [ RunTime:0.003750s ]
[ SQL ] SELECT * FROM `yzygroupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1634652177 AND `groupbuy_endtime` > 1634652177 ORDER BY `groupbuy_recommended` DESC LIMIT 0,15 [ RunTime:0.003784s ]
[ SQL ] SHOW COLUMNS FROM `yzylink` [ RunTime:0.004302s ]
[ SQL ] SELECT * FROM `yzylink` ORDER BY `link_sort` ASC [ RunTime:0.003528s ]
[ SQL ] SELECT `a`.`article_id`,`a`.`article_url`,`a`.`article_title` FROM `yzyarticle` `a` INNER JOIN `yzyarticleclass` `ac` ON `a`.`ac_id`=`ac`.`ac_id` WHERE `ac`.`ac_code` = 'notice' AND `a`.`article_show` = 1 ORDER BY `a`.`article_sort` ASC,`a`.`article_time` DESC LIMIT 3 [ RunTime:0.003567s ]
[ SQL ] SHOW COLUMNS FROM `yzygoodsclass` [ RunTime:0.004210s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 0 AND `gc_show` = 1 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` ASC [ RunTime:0.003704s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 12 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003650s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (12,'30','31','32','63','64','440','442','445','446','448','1076','423','507','508','509','510','511','512','513','514','515','782','824','982','1040','516','517','518','519','520','521','522','854','523','524','525','526','527','528','529','530','531','532','533','534','949','535','536','537','538','539','540','541','969','996','1044','542','543','544','545','546','547','548','877','936','958','549','550','551','552','553','554','555','556','865','959','557','558','559','560','561','562','563','564','565','566','846','1012','567','568','569','570','571','572','825','454','456','573','574','575','576') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.202588s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 12 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003738s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (1076) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004505s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (440,'542','543','544','545','546','547','548','877','936','958') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.096723s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (442,'549','550','551','552','553','554','555','556','865','959') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.096705s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (445,'557','558','559','560','561','562','563','564','565','566','846','1012') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.097080s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (446,'567','568','569','570','571','572','825') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.089053s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 11 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003764s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (11,'28','29','60','61','62','262','857','859','187','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','778','805','831','875','901','1059','1060','1080','213','214','215','216','217','219','220','221','222','223','224','225','226','227','228','229','230','777','834','902','1009','1086','1092','231','232','233','578','579','580','581','582','583','584','786','833','888','978','764','234','235','236','237','238','239','240','241','242','243','244','245','247','248','765','889','1025','1047','1061','246','249','250','251','252','253','254','255','256','257','258','259','260','972','1022','263','264','265','266','267','268','269','271','272','274','275','277','278','280','767','779','858','886','977','1043') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.232264s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 11 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003733s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (262,'263','264','265','266','267','268','269','271','272','274','275','277','278','280','767','779') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.101185s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (857,'858') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.083084s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (859,'886','977','1043') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.086463s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (28,'187','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','778','805','831','875','901','1059','1060','1080') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.114274s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (29,'213','214','215','216','217','219','220','221','222','223','224','225','226','227','228','229','230','777','834','902','1009','1086','1092') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.110157s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 8 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003793s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (8,'20','21','22','55','410','412','413','416','843','844','109','110','111','112','113','114','115','758','759','988','116','117','118','119','120','760','916','979','981','1021','1026','121','122','123','669','761','762','763','796','835','860','862','864','917','1070','124','125','126','127','128','129','130','131','132','133','985','1024','1049','1072','640','641','642','643','644','645','646','647','648','649','650','651','652','653','654','655','788','789','923','924','1023','656','657','658','659','660','661','662','663','872','975','664','665','666','667','668','874') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.199777s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 8 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003726s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (843) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.020141s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (844,'874') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.083368s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (410,'640','641','642','643','644','645','646') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.090651s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (412,'647','648','649','650','651','652','653','654','655','788','789','923','924','1023') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.097735s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (413,'656','657','658','659','660','661','662','663','872','975') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.092738s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 4 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003708s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (4,'5','6','7','51','54','392','94','104','105','106','107','108','379','381','383','384','385','386','90','91','92','93','739','740','741','1064','95','96','97','742','743','744','745','746','747','748','98','99','100','101','102','103','749','1071','400','402','403','405','407','750','751','753','396','397','754','755','756','757') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.148152s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 4 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003762s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (392,'396','397','754','755','756','757') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.088640s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (5,'94','104','105','106','107','108','379','381','383','384','385','386') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.096116s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (6,'90','91','92','93','739','740','741','1064') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.090156s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (7,'95','96','97','742','743','744','745','746','747','748') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.093170s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (51,'98','99','100','101','102','103','749','1071') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.090641s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 9 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003767s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (9,'23','24','56','57','424','425','426','428','798','801','964','986','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','851','970','154','155','156','157','158','818','159','160','161','162','163','164','165','166','806','809','471','472','473','474','475','477','478','479','481','483','484','486','487','800','813','491','492','494','496','498','499','500','502','797','804','807','810','815','817','808','811','812','814','816','819','987','989','990','991') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.183276s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 9 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003731s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (798,'808') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.082791s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (801,'811','812','814','816','819') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.087281s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (424,'471','472','473','474','475') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.086744s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (425,'477','478','479','481') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.085243s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (426,'483','484','486','487','800','813') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.088804s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 768 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003843s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (768,'769','773','976','1073','1074','1084','1087','770','781','1075','774','775','776','967','1010','1011') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.102238s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 768 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003684s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (769,'770','781','1075') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.083410s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (773,'774','775','776','967','1010','1011') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.087164s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (976) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004485s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 771 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003605s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (771,'772','848','878','893') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.089032s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 771 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003727s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (772) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004661s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (848) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.013054s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (878,'893') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.083254s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 10 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003725s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (10,'25','26','27','58','59','420','422','434','823','863','873','167','168','169','170','171','172','173','585','586','587','588','589','590','591','887','174','175','176','177','178','179','180','181','592','593','594','595','596','597','787','992','993','1081','182','183','184','185','186','598','599','600','601','602','790','849','852','898','953','1065','1066','1068','1069','188','189','190','191','192','603','604','605','606','607','608','193','194','195','196','609','610','611','612','613','614','577','615','616','617','618','619','620','621','622','623','624','891','625','626','627','628','629','630','631','632','633','634','635','636','637','638','639','943') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.224581s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 10 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003733s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (823) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004593s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (863) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004308s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (873) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.018157s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (420,'577','615','616','617','618','619','620','621','622','623','624','891') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.097047s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (422,'625','626','627','628','629','630','631') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.092658s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 15 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003790s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (15,'39','41','44','65','66','67','455','856','861','926','927','1007','1055','1056','362','363','364','365','366','367','368','369','370','371','372','374','766','880','884','905','908','911','933','934','935','937','944','954','956','966','983','1038','1062','1063','375','376','377','378','380','382','387','388','389','390','391','832','883','918','919','920','921','922','925','932','952','971','974','995','1006','1041','393','394','395','398','399','401','404','406','931','941','946','1015','408','409','411','414','415','417','418','419','421','899','910','1005','1018','427','429','430','431','432','433','435','436','437','866','870','1027','1048','438','439','441','443','444','447','449','450','890','928','947','955','999','1029','459','461','463','464','465','466','467','469','951','1028','1042','997','998','1046','1051','1083','1008') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.379984s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 15 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003831s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (1055) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004820s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (1056) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004252s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (856,'997','998','1046') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.087613s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (861) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004529s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (926) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.015865s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 16 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003715s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (16,'45','46','47','68','69','460','462','876','907','945','270','273','276','279','281','283','312','315','318','320','783','838','855','871','904','912','960','961','965','286','289','290','292','294','322','323','326','327','850','882','903','906','300','301','303','306','308','331','334','336','879','894','895','896','915','311','337','340','342','345','347','350','352','885','1039','1050','353','354','355','356','358','359','360','361','470','476','480','482','485','488','489','490','493','495','497','501','503','504','505','506') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.286351s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 16 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003744s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (876) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004550s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (907) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004684s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (945) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004259s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (460,'470','476','480','482','485','488','489','490') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.092055s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (462,'493','495','497','501','503','504','505','506') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.091954s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 785 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003700s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (785) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004514s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 785 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003647s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 791 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003624s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (791) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004959s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 791 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003630s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 792 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003679s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (792) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.019019s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 792 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003705s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 793 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003723s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (793,'794','795','839','841','845','892','1057','1078') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.094534s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 793 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003694s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (794) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.011728s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (795) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004436s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (1057) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004127s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (1078) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004117s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (839) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.021726s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 799 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003673s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (799,'938','957','1000','1003','1067','939','940','948','1030','1031','1032','1033','1034','1035','1036','1037','1052','1053','1001','1002','1004','1014') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.107245s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 799 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003735s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (1067) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004401s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (938,'939','940','948','1030','1031','1032','1033','1034','1035','1036','1037','1052','1053') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.097529s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (957) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004756s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (1000,'1001','1002') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.083647s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (1003,'1004','1014') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.083557s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 802 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003761s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (802,'803','822','840','847','867','881','914','1019','1020','1077','1079') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.095055s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 802 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003742s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (803) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.011863s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (1077) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004466s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (822) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004582s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (1079) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004296s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (840) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004423s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 820 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003678s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (820,'821','929','963','973','984','994','1013','1016','1017','1058') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.093760s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 820 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003719s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (821) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.017781s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (929) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004647s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (963) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004207s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (973) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004289s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (984,'1013','1016','1017','1058') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.084949s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 826 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003716s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (826,'827','828','829') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.083716s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 826 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003665s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (827) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004301s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (828) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004110s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (829) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004104s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 1082 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003598s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (1082) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004140s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 1082 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003613s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 830 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003604s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (830) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.017819s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 830 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003647s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 1088 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003560s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (1088,'1093','1095','1094') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.086514s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 1088 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003704s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (1093,'1094') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.082781s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (1095) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004454s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 1089 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003668s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (1089,'1090','1091') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.083374s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 1089 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003739s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (1090,'1091') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.081802s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 836 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003723s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (836) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.013368s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 836 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003712s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 837 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003645s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (837) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.045847s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 837 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003724s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 468 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003644s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (468,'670','671','672','673','674','675','676','842','853','930','962','681','682','683','684','685','686','687','688','689','690','691','692','900','913','693','694','695','696','697','698','699','700','701','702','703','704','705','706','707','708','709','710','711','712','713','714','715','716','718','719','720','721','722','723','724','725','726','727','728','869','897','909','950','980','729','730','731','732','733','734','735','736','737','738') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.182621s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 468 AND `gc_id` NOT IN (1073,1074,1084,1087) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.003677s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (842) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004510s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (853) AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.018215s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (670,'681','682','683','684') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.086344s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (671,'685','686','687','688','689','690','691','692','900','913') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.093664s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `yzygoodscommon` `goodscommon` INNER JOIN `yzygoods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (672,'693','694','695','696','697','698','699','700') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.091045s ]
