[ DB ] CONNECT:[ UseTime:0.000768s ] mysql:host=101.201.70.13;port=3306;dbname=yizhayan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzyarticleclass` [ RunTime:0.001191s ]
[ SQL ] SELECT * FROM `yzyarticleclass` WHERE `ac_id` <= 7 ORDER BY `ac_sort` ASC [ RunTime:0.000498s ]
[ SQL ] SHOW COLUMNS FROM `yzyarticle` [ RunTime:0.001095s ]
[ 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.000646s ]
[ SQL ] SHOW COLUMNS FROM `yzygoodscommon` [ RunTime:0.001480s ]
[ 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.111618s ]
[ SQL ] SHOW COLUMNS FROM `yzypxianshigoods` [ RunTime:0.001112s ]
[ SQL ] SELECT * FROM `yzypxianshigoods` WHERE `xianshigoods_state` = 1 AND `xianshigoods_starttime` < 1591424969 AND `xianshigoods_end_time` > 1591424969 ORDER BY `xianshigoods_recommend` DESC LIMIT 5 [ RunTime:0.000642s ]
[ SQL ] SHOW COLUMNS FROM `yzygoods` [ RunTime:0.001265s ]
[ 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.972468s ]
[ SQL ] SHOW COLUMNS FROM `yzygroupbuy` [ RunTime:0.001249s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzygroupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1591424969 AND `groupbuy_endtime` > 1591424969 LIMIT 1 [ RunTime:0.000634s ]
[ SQL ] SELECT * FROM `yzygroupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1591424969 AND `groupbuy_endtime` > 1591424969 ORDER BY `groupbuy_recommended` DESC LIMIT 0,15 [ RunTime:0.000973s ]
[ SQL ] SHOW COLUMNS FROM `yzylink` [ RunTime:0.001103s ]
[ SQL ] SELECT * FROM `yzylink` ORDER BY `link_sort` ASC [ RunTime:0.000444s ]
[ 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.000459s ]
[ SQL ] SHOW COLUMNS FROM `yzygoodsclass` [ RunTime:0.001111s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE `gc_parent_id` = 0 AND `gc_show` = 1 ORDER BY `gc_sort` ASC [ RunTime:0.000516s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=12 ) [ 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 (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.291975s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=12 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000498s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.001099s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.124560s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.122409s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.124732s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.115377s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=11 ) [ RunTime:0.000516s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.322769s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=11 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000557s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.131159s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.123210s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.108659s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.148266s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.139057s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=8 ) [ RunTime:0.000481s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.278209s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=8 ) 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 (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.016525s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.102574s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.112796s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.126926s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.119244s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=4 ) [ RunTime:0.000508s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.203817s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=4 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000521s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.112031s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.121205s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.113154s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.117955s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.115139s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=9 ) [ RunTime:0.000494s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.256350s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=9 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000533s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.101242s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.108841s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.107791s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.105962s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.114091s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=10 ) [ RunTime:0.000528s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.316045s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=10 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000575s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.001358s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.001036s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.016474s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.128930s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.117744s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=15 ) [ RunTime:0.000511s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.499551s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=15 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000551s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.001070s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.000944s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.109987s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.000966s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.011561s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=16 ) [ RunTime:0.000452s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.355802s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=16 ) ORDER BY `gc_sort` DESC LIMIT 5 [ 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 (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.001150s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.001162s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.000897s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.119736s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.118791s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=792 ) [ RunTime:0.000513s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.003549s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=792 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000492s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=785 ) [ 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 (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.000905s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=785 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000465s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=826 ) [ RunTime:0.000406s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.108234s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=826 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000516s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.000940s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.000881s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.000905s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=791 ) [ RunTime:0.000472s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.000457s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=468 ) [ RunTime:0.000441s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.263046s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=468 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000488s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.001155s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.016310s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.108888s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.119098s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.114712s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=768 ) [ RunTime:0.000545s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.128042s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=768 ) ORDER BY `gc_sort` DESC LIMIT 5 [ 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 (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.104405s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.109861s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.000984s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.001029s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.000880s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=771 ) [ RunTime:0.000461s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.106766s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=771 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000511s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.001108s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.012077s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.100349s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=837 ) [ RunTime:0.000512s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.046592s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=837 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000507s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=793 ) [ 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 (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.124741s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=793 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000528s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.009235s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.001148s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.000996s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.001163s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.019559s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=799 ) [ RunTime:0.000468s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.144186s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=799 ) 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 (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.000875s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.128032s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.001335s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.104142s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.103554s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=802 ) [ RunTime:0.000567s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.120885s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=802 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000511s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.009414s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.001017s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.001192s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.000951s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.001051s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=820 ) [ 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 (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.119940s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=820 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000817s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.016793s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.001504s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.001057s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.001094s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.110136s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=1082 ) [ RunTime:0.000464s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.000922s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=1082 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000688s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=830 ) [ RunTime:0.000426s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.016313s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=830 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000479s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=836 ) [ RunTime:0.000424s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_intro`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_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.008858s ]
[ SQL ] SELECT * FROM `yzygoodsclass` WHERE ( gc_parent_id=836 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000502s ]
[ SQL ] SHOW COLUMNS FROM `yzyadvposition` [ RunTime:0.001086s ]
[ SQL ] SELECT `ap_id`,`ap_name`,`ap_width`,`ap_height` FROM `yzyadvposition` [ RunTime:0.000477s ]
[ SQL ] SHOW COLUMNS FROM `yzyadv` [ RunTime:0.001062s ]
[ SQL ] SELECT * FROM `yzyadv` WHERE ( ap_id=1 and adv_enabled = 1 and adv_startdate < 1591066800 and adv_enddate > 1591066800 ) ORDER BY `adv_sort` DESC LIMIT 10 [ RunTime:0.000438s ]
[ SQL ] SELECT * FROM `yzyadv` WHERE ( ap_id=2 and adv_enabled = 1 and adv_startdate < 1591066800 and adv_enddate > 1591066800 ) ORDER BY `adv_sort` DESC LIMIT 10 [ RunTime:0.000497s ]
[ SQL ] SELECT * FROM `yzyadv` WHERE ( ap_id=8 and adv_enabled = 1 and adv_startdate < 1591066800 and adv_enddate > 1591066800 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000452s ]
[ SQL ] SELECT * FROM `yzyadv` WHERE ( ap_id=3 and adv_enabled = 1 and adv_startdate < 1591066800 and adv_enddate > 1591066800 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000583s ]
[ SQL ] SELECT * FROM `yzyadv` WHERE ( ap_id=9 and adv_enabled = 1 and adv_startdate < 1591066800 and adv_enddate > 1591066800 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000460s ]
[ SQL ] SELECT * FROM `yzyadv` WHERE ( ap_id=4 and adv_enabled = 1 and adv_startdate < 1591066800 and adv_enddate > 1591066800 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000441s ]
[ SQL ] SELECT * FROM `yzyadv` WHERE ( ap_id=10 and adv_enabled = 1 and adv_startdate < 1591066800 and adv_enddate > 1591066800 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000438s ]
[ SQL ] SELECT * FROM `yzyadv` WHERE ( ap_id=5 and adv_enabled = 1 and adv_startdate < 1591066800 and adv_enddate > 1591066800 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000458s ]
[ SQL ] SELECT * FROM `yzyadv` WHERE ( ap_id=11 and adv_enabled = 1 and adv_startdate < 1591066800 and adv_enddate > 1591066800 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000451s ]
[ SQL ] SELECT * FROM `yzyadv` WHERE ( ap_id=6 and adv_enabled = 1 and adv_startdate < 1591066800 and adv_enddate > 1591066800 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000459s ]
[ SQL ] SELECT * FROM `yzyadv` WHERE ( ap_id=12 and adv_enabled = 1 and adv_startdate < 1591066800 and adv_enddate > 1591066800 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000439s ]
[ SQL ] SELECT * FROM `yzyadv` WHERE ( ap_id=7 and adv_enabled = 1 and adv_startdate < 1591066800 and adv_enddate > 1591066800 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000435s ]
