[ DB ] CONNECT:[ UseTime:0.005655s ] mysql:host=101.201.70.13;port=3306;dbname=yizhayan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzyarticleclass` [ RunTime:0.004373s ]
[ SQL ] SELECT * FROM `yzyarticleclass` WHERE `ac_id` <= 7 ORDER BY `ac_sort` ASC [ RunTime:0.003759s ]
[ SQL ] SHOW COLUMNS FROM `yzyarticle` [ RunTime:0.004449s ]
[ 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.003878s ]
[ SQL ] SHOW COLUMNS FROM `yzygoodscommon` [ RunTime:0.004772s ]
[ 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.003862s ]
[ SQL ] SHOW COLUMNS FROM `yzypxianshigoods` [ RunTime:0.004449s ]
[ SQL ] SELECT * FROM `yzypxianshigoods` WHERE `xianshigoods_state` = 1 AND `xianshigoods_starttime` < 1632383437 AND `xianshigoods_end_time` > 1632383437 ORDER BY `xianshigoods_recommend` DESC LIMIT 5 [ RunTime:0.003918s ]
[ SQL ] SHOW COLUMNS FROM `yzygoods` [ RunTime:0.004496s ]
[ SQL ] SELECT * FROM `yzygoods` WHERE `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_addtime` DESC LIMIT 5 [ RunTime:0.003831s ]
[ SQL ] SHOW COLUMNS FROM `yzygroupbuy` [ RunTime:0.004356s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzygroupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1632383437 AND `groupbuy_endtime` > 1632383437 LIMIT 1 [ RunTime:0.003806s ]
[ SQL ] SELECT * FROM `yzygroupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1632383437 AND `groupbuy_endtime` > 1632383437 ORDER BY `groupbuy_recommended` DESC LIMIT 0,15 [ RunTime:0.003886s ]
[ SQL ] SHOW COLUMNS FROM `yzylink` [ RunTime:0.004365s ]
[ SQL ] SELECT * FROM `yzylink` ORDER BY `link_sort` ASC [ RunTime:0.003685s ]
[ 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.003703s ]
[ SQL ] SHOW COLUMNS FROM `yzygoodsclass` [ RunTime:0.004327s ]
[ 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.003751s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 12 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003722s ]
[ 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.003868s ]
[ 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.003740s ]
[ 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.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 (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.003773s ]
[ 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.003787s ]
[ 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.003836s ]
[ 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.089944s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 11 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003795s ]
[ 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.229921s ]
[ 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.004017s ]
[ 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.100757s ]
[ 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.080759s ]
[ 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.084970s ]
[ 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.114093s ]
[ 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.109031s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 8 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003931s ]
[ 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.241954s ]
[ 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.003972s ]
[ 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.022582s ]
[ 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.100398s ]
[ 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.104906s ]
[ 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.138861s ]
[ 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.127103s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 4 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003864s ]
[ 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.149106s ]
[ 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.003870s ]
[ 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.106139s ]
[ 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.143249s ]
[ 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.094626s ]
[ 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.097811s ]
[ 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.095375s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 9 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003898s ]
[ 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.229916s ]
[ 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.003961s ]
[ 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.095250s ]
[ 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.088332s ]
[ 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.087448s ]
[ 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.095632s ]
[ 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.091249s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 768 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003822s ]
[ 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.101731s ]
[ 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.003850s ]
[ 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.084506s ]
[ 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.087849s ]
[ 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.004961s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 771 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003824s ]
[ 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.133082s ]
[ 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.003914s ]
[ 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.005464s ]
[ 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.019673s ]
[ 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.124557s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 10 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.004106s ]
[ 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.313448s ]
[ 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.003993s ]
[ 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.004956s ]
[ 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.004542s ]
[ 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.030500s ]
[ 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.120019s ]
[ 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.094580s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 15 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003997s ]
[ 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.473737s ]
[ 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.003895s ]
[ 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.004742s ]
[ 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.004513s ]
[ 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.127372s ]
[ 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.004766s ]
[ 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.022401s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 16 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003836s ]
[ 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.443931s ]
[ 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.003910s ]
[ 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.005092s ]
[ 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.004823s ]
[ 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.004541s ]
[ 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.120793s ]
[ 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.107555s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 785 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003847s ]
[ 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.004593s ]
[ 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.003766s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 791 AND `gc_id` NOT IN (1073,1074,1084,1087) [ 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 (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.004958s ]
[ 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.003737s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 792 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003815s ]
[ 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.020161s ]
[ 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.004115s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 793 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003893s ]
[ 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.110267s ]
[ 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.003777s ]
[ 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.012127s ]
[ 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.004812s ]
[ 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.004587s ]
[ 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.004595s ]
[ 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.022340s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 799 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003766s ]
[ 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.112658s ]
[ 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.003889s ]
[ 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.004692s ]
[ 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.100478s ]
[ 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.004663s ]
[ 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.095733s ]
[ 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.104049s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 802 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003945s ]
[ 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.113727s ]
[ 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.004010s ]
[ 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.018178s ]
[ 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.004643s ]
[ 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.004726s ]
[ 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.004437s ]
[ 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.004549s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 820 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003870s ]
[ 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.141424s ]
[ 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.003906s ]
[ 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.029464s ]
[ 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.003821s ]
[ 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.003873s ]
[ 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.003828s ]
[ 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.116612s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 826 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003851s ]
[ 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.099140s ]
[ 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.003817s ]
[ 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.004381s ]
[ 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.004358s ]
[ 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.004330s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 1082 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003791s ]
[ 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.004238s ]
[ 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.003769s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 830 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003747s ]
[ 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.018378s ]
[ 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.003725s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 1088 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 (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.101866s ]
[ 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.003960s ]
[ 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.118274s ]
[ 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.004941s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 1089 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003846s ]
[ 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.141107s ]
[ 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.003959s ]
[ 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.127160s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 836 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003858s ]
[ 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.003945s ]
[ 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.003986s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 837 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003861s ]
[ 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.068543s ]
[ 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.004027s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 468 AND `gc_id` NOT IN (1073,1074,1084,1087) [ RunTime:0.003956s ]
[ 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.289865s ]
[ 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.003966s ]
[ 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.003922s ]
[ 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.003934s ]
[ 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.142647s ]
[ 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.151214s ]
[ 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.003990s ]
