[ DB ] CONNECT:[ UseTime:0.000749s ] mysql:host=101.201.70.13;port=3306;dbname=yizhayan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzyarticleclass` [ RunTime:0.001174s ]
[ SQL ] SELECT * FROM `yzyarticleclass` WHERE `ac_id` <= 7 ORDER BY `ac_sort` ASC [ RunTime:0.000504s ]
[ SQL ] SHOW COLUMNS FROM `yzyarticle` [ RunTime:0.001103s ]
[ 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.000649s ]
[ SQL ] SHOW COLUMNS FROM `yzygoodscommon` [ RunTime:0.001522s ]
[ 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.110271s ]
[ SQL ] SHOW COLUMNS FROM `yzypxianshigoods` [ RunTime:0.001089s ]
[ SQL ] SELECT * FROM `yzypxianshigoods` WHERE `xianshigoods_state` = 1 AND `xianshigoods_starttime` < 1591419167 AND `xianshigoods_end_time` > 1591419167 ORDER BY `xianshigoods_recommend` DESC LIMIT 5 [ RunTime:0.000700s ]
[ SQL ] SHOW COLUMNS FROM `yzygoods` [ RunTime:0.001127s ]
[ 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.961842s ]
[ SQL ] SHOW COLUMNS FROM `yzygroupbuy` [ RunTime:0.001233s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzygroupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1591419167 AND `groupbuy_endtime` > 1591419167 LIMIT 1 [ RunTime:0.000559s ]
[ SQL ] SELECT * FROM `yzygroupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1591419167 AND `groupbuy_endtime` > 1591419167 ORDER BY `groupbuy_recommended` DESC LIMIT 0,15 [ RunTime:0.000642s ]
[ SQL ] SHOW COLUMNS FROM `yzylink` [ RunTime:0.001051s ]
[ SQL ] SELECT * FROM `yzylink` ORDER BY `link_sort` ASC [ RunTime:0.000486s ]
[ 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.000490s ]
[ SQL ] SHOW COLUMNS FROM `yzygoodsclass` [ RunTime:0.001183s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 0 AND `gc_show` = 1 ORDER BY `gc_sort` ASC [ RunTime:0.000488s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=12 ) [ RunTime:0.000454s ]
[ 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.291147s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=12 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000490s ]
[ 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.001060s ]
[ 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.124561s ]
[ 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.121968s ]
[ 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.124314s ]
[ 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.114071s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=11 ) [ RunTime:0.000500s ]
[ 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','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.323938s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=11 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000548s ]
[ 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.135127s ]
[ 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.103798s ]
[ 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.106708s ]
[ 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.146446s ]
[ 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') 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.139644s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=8 ) [ RunTime:0.000525s ]
[ 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.278397s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=8 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000565s ]
[ 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.016450s ]
[ 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.104216s ]
[ 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.113495s ]
[ 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.125918s ]
[ 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.118262s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=4 ) [ RunTime:0.000527s ]
[ 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.204407s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=4 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000478s ]
[ 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.112327s ]
[ 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.123246s ]
[ 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.114860s ]
[ 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.119425s ]
[ 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.114389s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=9 ) [ RunTime:0.000523s ]
[ 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.255651s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=9 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000517s ]
[ 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.101539s ]
[ 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.108552s ]
[ 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.110680s ]
[ 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.107951s ]
[ 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.111394s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=10 ) [ RunTime:0.000479s ]
[ 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.307718s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=10 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000469s ]
[ 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.001220s ]
[ 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.000965s ]
[ 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.016107s ]
[ 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.122528s ]
[ 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.112258s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=15 ) [ RunTime:0.000515s ]
[ 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.499367s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=15 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000576s ]
[ 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.001086s ]
[ 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.000965s ]
[ 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.132094s ]
[ 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.001049s ]
[ 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.011757s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=16 ) [ RunTime:0.000466s ]
[ 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.363363s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=16 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000572s ]
[ 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.001462s ]
[ 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.001327s ]
[ 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.000989s ]
[ 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.123840s ]
[ 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.118887s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=792 ) [ RunTime:0.000505s ]
[ 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.003580s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=792 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000483s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=785 ) [ RunTime:0.000431s ]
[ 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.000906s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=785 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000479s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=826 ) [ RunTime:0.000497s ]
[ 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.107196s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=826 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000523s ]
[ 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.000971s ]
[ 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.000936s ]
[ 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.000935s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=791 ) [ RunTime:0.000473s ]
[ 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.000991s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=791 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000459s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=468 ) [ RunTime:0.000455s ]
[ 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.261609s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=468 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000522s ]
[ 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.001042s ]
[ 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.016397s ]
[ 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.109336s ]
[ 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.119349s ]
[ 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.114850s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=768 ) [ RunTime:0.000487s ]
[ 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','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.128922s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=768 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000524s ]
[ 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.107456s ]
[ 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.111040s ]
[ 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 (1073) 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.001033s ]
[ 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 (1074) 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.000980s ]
[ 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 (1084) 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.000942s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=771 ) [ RunTime:0.000476s ]
[ 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.107209s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=771 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000484s ]
[ 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.001187s ]
[ 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.012259s ]
[ 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.101839s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=837 ) [ RunTime:0.000478s ]
[ 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.048166s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=837 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000489s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=793 ) [ RunTime:0.000423s ]
[ 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.119086s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=793 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000487s ]
[ 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.009113s ]
[ 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.001082s ]
[ 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.000975s ]
[ 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.000995s ]
[ 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.019450s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=799 ) [ RunTime:0.000459s ]
[ 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.141616s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=799 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000458s ]
[ 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.000910s ]
[ 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.124880s ]
[ 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.001253s ]
[ 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.103701s ]
[ 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.103276s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=802 ) [ RunTime:0.000493s ]
[ 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.122009s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=802 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000773s ]
[ 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.009380s ]
[ 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.001004s ]
[ 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.001147s ]
[ 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.000958s ]
[ 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.001056s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=820 ) [ RunTime:0.000465s ]
[ 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.120838s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=820 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000475s ]
[ 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.016088s ]
[ 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.001226s ]
[ 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.001023s ]
[ 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.001074s ]
[ 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.107789s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=1082 ) [ RunTime:0.000485s ]
[ 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.001744s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=1082 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000490s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=830 ) [ RunTime:0.000479s ]
[ 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.016330s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=830 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000474s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=836 ) [ RunTime:0.000413s ]
[ 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.008861s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=836 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000496s ]
