[ DB ] CONNECT:[ UseTime:0.000509s ] mysql:host=127.0.0.1;port=3306;dbname=ds_2mmfarm_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ds_goodsclassnav` [ RunTime:0.000557s ]
[ SQL ] SELECT * FROM `ds_goodsclassnav` WHERE `gc_id` = 1 LIMIT 1 [ RunTime:0.000265s ]
[ SQL ] SELECT * FROM `ds_goodsclassnav` WHERE `gc_id` = 4 LIMIT 1 [ RunTime:0.000168s ]
[ SQL ] SELECT * FROM `ds_goodsclassnav` WHERE `gc_id` = 8 LIMIT 1 [ RunTime:0.000169s ]
[ SQL ] SELECT * FROM `ds_goodsclassnav` WHERE `gc_id` = 9 LIMIT 1 [ RunTime:0.000149s ]
[ SQL ] SELECT * FROM `ds_goodsclassnav` WHERE `gc_id` = 10 LIMIT 1 [ RunTime:0.000159s ]
[ SQL ] SELECT * FROM `ds_goodsclassnav` WHERE `gc_id` = 11 LIMIT 1 [ RunTime:0.000161s ]
[ SQL ] SELECT * FROM `ds_goodsclassnav` WHERE `gc_id` = 12 LIMIT 1 [ RunTime:0.000169s ]
[ SQL ] SELECT * FROM `ds_goodsclassnav` WHERE `gc_id` = 15 LIMIT 1 [ RunTime:0.000177s ]
[ SQL ] SHOW COLUMNS FROM `ds_brand` [ RunTime:0.000410s ]
[ SQL ] SELECT * FROM `ds_brand` WHERE `brand_id` IN (1) ORDER BY `brand_sort` ASC,`brand_id` DESC [ RunTime:0.000239s ]
[ SQL ] SELECT * FROM `ds_goodsclassnav` WHERE `gc_id` = 16 LIMIT 1 [ RunTime:0.000160s ]
[ SQL ] SELECT * FROM `ds_goodsclassnav` WHERE `gc_id` = 625 LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SELECT * FROM `ds_goodsclassnav` WHERE `gc_id` = 626 LIMIT 1 [ RunTime:0.000192s ]
[ SQL ] SHOW COLUMNS FROM `ds_typebrand` [ RunTime:0.000370s ]
[ SQL ] SELECT * FROM `ds_typebrand` WHERE `type_id` IN (1,0,14) LIMIT 10000 [ RunTime:0.000176s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ds_brand` LIMIT 1 [ RunTime:0.000206s ]
[ SQL ] SELECT `brand_id`,`brand_name`,`brand_pic` FROM `ds_brand` ORDER BY `brand_sort` ASC,`brand_id` DESC LIMIT 0,10000 [ RunTime:0.000188s ]
[ SQL ] SHOW COLUMNS FROM `ds_goodscommon` [ RunTime:0.000813s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`goods_commend` = 1 AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_sort` ASC LIMIT 5 [ RunTime:0.000823s ]
[ SQL ] SHOW COLUMNS FROM `ds_pxianshigoods` [ RunTime:0.000618s ]
[ SQL ] SELECT * FROM `ds_pxianshigoods` WHERE `xianshigoods_state` = 1 AND `xianshigoods_starttime` < 1776062331 AND `xianshigoods_end_time` > 1776062331 ORDER BY `xianshigoods_recommend` DESC LIMIT 5 [ RunTime:0.000281s ]
[ SQL ] SHOW COLUMNS FROM `ds_goods` [ RunTime:0.000566s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `goods_state` = 1 GROUP BY `goods_commonid` ORDER BY `goods_addtime` DESC LIMIT 5 [ RunTime:0.001309s ]
[ SQL ] SHOW COLUMNS FROM `ds_groupbuy` [ RunTime:0.000685s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ds_groupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1776062331 AND `groupbuy_endtime` > 1776062331 LIMIT 1 [ RunTime:0.000216s ]
[ SQL ] SELECT * FROM `ds_groupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1776062331 AND `groupbuy_endtime` > 1776062331 ORDER BY `groupbuy_recommended` DESC LIMIT 0,15 [ RunTime:0.000244s ]
[ SQL ] SHOW COLUMNS FROM `ds_link` [ RunTime:0.000359s ]
[ SQL ] SELECT * FROM `ds_link` ORDER BY `link_sort` ASC [ RunTime:0.000168s ]
[ SQL ] SHOW COLUMNS FROM `ds_article` [ RunTime:0.000369s ]
[ SQL ] SELECT `a`.`article_id`,`a`.`article_url`,`a`.`article_title` FROM `ds_article` `a` INNER JOIN `ds_articleclass` `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.000328s ]
[ SQL ] SHOW COLUMNS FROM `ds_goodsclass` [ RunTime:0.000424s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE `gc_parent_id` = 0 AND `gc_show` = 1 ORDER BY `gc_sort` ASC [ RunTime:0.000421s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=1 ) [ RunTime:0.000353s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (1,'2','3','48','49','321','338','575','576','75','76','77','78','79','282','284','285','287','288','70','71','72','73','74','291','80','81','82','83','84','302','304','305','307','85','86','87','88','89','592','593','594','325','328','339','341','343','344','346','348','349','351','595','596','597','598','599','600','601','602') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000564s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=1 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000507s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (575,'596','597','598','599') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000362s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (576,'600','601','602') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000333s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (321,'325','328') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000323s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (338,'339','341','343','344','346','348','349','351','595') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000329s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (2,'75','76','77','78','79','282','284','285','287','288') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000330s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=4 ) [ RunTime:0.000397s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (4,'5','6','7','51','54','392','94','603','604','605','606','607','608','609','610','611','612','613','614','615','616','90','617','618','95','96','97','619','98','620','621','622','400','402','403','623','624') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000994s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=4 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000317s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (5,'94','603','604','605','606','607','608','609','610','611','612','613','614','615','616') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000435s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (6,'90','617','618') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000369s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (7,'95','96','97','619') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000360s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (51,'98','620','621','622') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000649s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (54,'400','402','403','623','624') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000642s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=8 ) [ RunTime:0.000374s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (8,'20','21','22') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000326s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=8 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000277s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (20) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000403s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (21) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000341s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (22) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000351s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=9 ) [ RunTime:0.000345s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (9,'23','24','56','57','424','425','657','658','675','676','677','663','664','665','666','667','668','669','655','656','670','671','672','673','674') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.001705s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=9 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000292s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (23,'657','658') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000659s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (24,'675','676','677') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000577s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (56,'663','664','665','666','667','668','669') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.001111s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (57,'655','656','670','671') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000704s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (424,'672','673','674') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000713s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=10 ) [ RunTime:0.000357s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (10,'646','647','648','652','653','650','687','678','680','681','682','686','679','683','684','685') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000846s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=10 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000303s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (646,'650') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000525s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (647,'687') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000540s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (648,'678','680','681','682') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000630s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (652,'686') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000487s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (653,'679','683','684','685') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000592s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=11 ) [ RunTime:0.000346s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (11,'28','29','60','61','62','262','627','628') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000344s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=11 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000342s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (262) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000363s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (28) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000331s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (29) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000365s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (60) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000301s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (61) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000330s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=12 ) [ RunTime:0.000415s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (12,'30','31','32','63','64','440','442','445') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000363s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=12 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000265s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (30) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000313s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (31) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000393s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (32) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000395s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (63) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000338s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (64) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000346s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=15 ) [ RunTime:0.000434s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (15,'39','41','44','65','66','590','629','630') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000377s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=15 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000269s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (39) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000319s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (41) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000323s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (44) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000298s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (65) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000322s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (66) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000321s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=16 ) [ RunTime:0.000484s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (16,'45','46','47','68','69','460') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000401s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=16 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000302s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (45) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000336s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (46) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000313s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (47) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000302s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (68) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000304s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (69) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000289s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=625 ) [ RunTime:0.000339s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (625,'631','632','633','634','635','636','637') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000333s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=625 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000260s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (631) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000309s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (632) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000361s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (633) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000328s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (634) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000363s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (635) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000365s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=626 ) [ RunTime:0.000350s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (626,'638','639','640','641','642','643','644','645') AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000356s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=626 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000270s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (638) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000395s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (639) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000375s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (640) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000399s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (641) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000336s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `ds_goodscommon` `goodscommon` INNER JOIN `ds_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (642) AND `goodscommon`.`goods_state` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`goods_commend` DESC,`goodscommon`.`goods_sort` ASC LIMIT 10 [ RunTime:0.000369s ]
[ SQL ] SHOW COLUMNS FROM `ds_advposition` [ RunTime:0.000595s ]
[ SQL ] SELECT `ap_id`,`ap_name`,`ap_width`,`ap_height` FROM `ds_advposition` [ RunTime:0.000191s ]
[ SQL ] SHOW COLUMNS FROM `ds_adv` [ RunTime:0.000522s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=21 and adv_enabled = 1 and adv_startdate < 1765443600 and adv_enddate > 1765443600 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000249s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=1 and adv_enabled = 1 and adv_startdate < 1765443600 and adv_enddate > 1765443600 ) ORDER BY `adv_sort` DESC LIMIT 10 [ RunTime:0.000297s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=2 and adv_enabled = 1 and adv_startdate < 1765443600 and adv_enddate > 1765443600 ) ORDER BY `adv_sort` DESC LIMIT 10 [ RunTime:0.000281s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=8 and adv_enabled = 1 and adv_startdate < 1765443600 and adv_enddate > 1765443600 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000262s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=3 and adv_enabled = 1 and adv_startdate < 1765443600 and adv_enddate > 1765443600 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000245s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=9 and adv_enabled = 1 and adv_startdate < 1765443600 and adv_enddate > 1765443600 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000243s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=5 and adv_enabled = 1 and adv_startdate < 1765443600 and adv_enddate > 1765443600 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000284s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=10 and adv_enabled = 1 and adv_startdate < 1765443600 and adv_enddate > 1765443600 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000246s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=6 and adv_enabled = 1 and adv_startdate < 1765443600 and adv_enddate > 1765443600 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000274s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=11 and adv_enabled = 1 and adv_startdate < 1765443600 and adv_enddate > 1765443600 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000289s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=7 and adv_enabled = 1 and adv_startdate < 1765443600 and adv_enddate > 1765443600 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000267s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=12 and adv_enabled = 1 and adv_startdate < 1765443600 and adv_enddate > 1765443600 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000253s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=4 and adv_enabled = 1 and adv_startdate < 1765443600 and adv_enddate > 1765443600 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000241s ]
