[ DB ] CONNECT:[ UseTime:0.002394s ] mysql:host=127.0.0.1;port=3306;dbname=sql_j688mall_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `mz_articleclass` [ RunTime:0.003294s ]
[ SQL ] SELECT * FROM `mz_articleclass` WHERE `ac_id` <= 7 ORDER BY `ac_sort` ASC [ RunTime:0.001274s ]
[ SQL ] SHOW COLUMNS FROM `mz_article` [ RunTime:0.002768s ]
[ 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 `mz_article` `article` LEFT JOIN `mz_articleclass` `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.003470s ]
[ SQL ] SHOW COLUMNS FROM `mz_cart` [ RunTime:0.002991s ]
[ SQL ] SELECT * FROM `mz_cart` WHERE `buyer_id` IS NULL [ RunTime:0.001090s ]
[ SQL ] SHOW COLUMNS FROM `mz_goodscommon` [ RunTime:0.002000s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `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.005271s ]
[ SQL ] SHOW COLUMNS FROM `mz_pxianshigoods` [ RunTime:0.001842s ]
[ SQL ] SELECT * FROM `mz_pxianshigoods` WHERE `xianshigoods_state` = 1 AND `xianshigoods_starttime` < 1734872866 AND `xianshigoods_end_time` > 1734872866 ORDER BY `xianshigoods_recommend` DESC LIMIT 5 [ RunTime:0.000759s ]
[ SQL ] SHOW COLUMNS FROM `mz_goods` [ RunTime:0.001071s ]
[ SQL ] SELECT * FROM `mz_goods` WHERE `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_addtime` DESC LIMIT 5 [ RunTime:0.002292s ]
[ SQL ] SHOW COLUMNS FROM `mz_groupbuy` [ RunTime:0.002503s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `mz_groupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1734872866 AND `groupbuy_endtime` > 1734872866 LIMIT 1 [ RunTime:0.000954s ]
[ SQL ] SELECT * FROM `mz_groupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1734872866 AND `groupbuy_endtime` > 1734872866 ORDER BY `groupbuy_recommended` DESC LIMIT 0,15 [ RunTime:0.000655s ]
[ SQL ] SHOW COLUMNS FROM `mz_link` [ RunTime:0.001411s ]
[ SQL ] SELECT * FROM `mz_link` ORDER BY `link_sort` ASC [ RunTime:0.000544s ]
[ SQL ] SELECT `a`.`article_id`,`a`.`article_url`,`a`.`article_title` FROM `mz_article` `a` INNER JOIN `mz_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.000828s ]
[ SQL ] SHOW COLUMNS FROM `mz_goodsclass` [ RunTime:0.000855s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE `gc_parent_id` = 0 AND `gc_show` = 1 ORDER BY `gc_sort` ASC [ RunTime:0.000953s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=1 ) [ RunTime:0.000584s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (1,'2','3','48','49','321','338','75','76','77','78','79','282','284','285','287','288','295','298','324','70','72','73','74','71','291','293','296','297','299','80','81','82','83','84','302','304','305','307','309','310','313','314','316','317','319','85','86','87','88','89','325','328','329','330','332','333','335','339','341','343','344','346','348','349','351') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.004478s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=1 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000843s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (321,'325','328','329','330','332','333','335') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000874s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (338,'339','341','343','344','346','348','349','351') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000932s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_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','295','298','324') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001405s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (3,'70','72','73','74','71','291','293','296','297','299') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001747s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (48,'80','81','82','83','84','302','304','305','307','309','310','313','314','316','317','319') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001124s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=4 ) [ RunTime:0.000550s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `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','95','96','97','742','743','744','745','746','747','748','98','99','100','101','102','103','749','400','402','403','405','407','750','751','752','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.001556s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=4 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000807s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `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.000914s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `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.001110s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (6,'90','91','92','93','739','740','741') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001135s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `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.001083s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (51,'98','99','100','101','102','103','749') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001143s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=8 ) [ RunTime:0.000775s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (8,'20','21','22','55','410','412','413','416','109','110','111','112','113','114','115','758','759','116','117','118','119','120','760','121','122','123','669','761','762','763','124','125','126','127','128','129','130','131','132','133','640','641','642','643','644','645','646','647','648','649','650','651','652','653','654','655','656','657','658','659','660','661','662','663','664','665','666','667','668') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.007214s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=8 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.002759s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `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.001398s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (412,'647','648','649','650','651','652','653','654','655') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001037s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (413,'656','657','658','659','660','661','662','663') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000985s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (416,'664','665','666','667','668') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000933s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (20,'109','110','111','112','113','114','115','758','759') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001212s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=9 ) [ RunTime:0.000652s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (9,'23','24','56','57','424','425','426','428','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','471','472','473','474','475','477','478','479','481','483','484','486','487','491','492','494','496','498','499','500','502') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001786s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=9 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000910s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `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.002228s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `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.000833s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (426,'483','484','486','487') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001116s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (428,'491','492','494','496','498','499','500','502') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001239s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (23,'134','135','136','137','138','139','140','141','142','143') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001664s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=10 ) [ RunTime:0.001248s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (10,'25','26','27','58','59','420','422','434','167','168','169','170','171','172','173','585','586','587','588','589','590','591','174','175','176','177','178','179','180','181','592','593','594','595','596','597','182','183','184','185','186','598','599','600','601','602','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','625','626','627','628','629','630','631','632','633','634','635','636','637','638','639') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.002204s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=10 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000759s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `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') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001224s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `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.001247s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (434,'632','633','634','635','636','637','638','639') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000772s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (25,'167','168','169','170','171','172','173','585','586','587','588','589','590','591') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`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_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (26,'174','175','176','177','178','179','180','181','592','593','594','595','596','597') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001315s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=11 ) [ RunTime:0.000591s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (11,'28','29','60','61','62','262','187','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','219','220','221','222','223','224','225','226','227','228','229','230','231','232','233','578','579','580','581','582','583','584','234','235','236','237','238','239','240','241','242','243','244','245','247','248','246','249','250','251','252','253','254','255','256','257','258','259','260','263','264','265','266','267','268','269','271','272','274','275','277','278','280') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001846s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=11 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000895s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `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') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000927s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `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') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000972s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `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') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001340s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (60,'231','232','233','578','579','580','581','582','583','584') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001112s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (61,'234','235','236','237','238','239','240','241','242','243','244','245','247','248') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000794s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=12 ) [ RunTime:0.000904s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (12,'30','31','32','63','64','440','442','445','446','448','423','507','508','509','510','511','512','513','514','515','516','517','518','519','520','521','522','523','524','525','526','527','528','529','530','531','532','533','534','535','536','537','538','539','540','541','542','543','544','545','546','547','548','549','550','551','552','553','554','555','556','557','558','559','560','561','562','563','564','565','566','567','568','569','570','571','572','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.001684s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=12 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000752s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (440,'542','543','544','545','546','547','548') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001041s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (442,'549','550','551','552','553','554','555','556') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001059s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (445,'557','558','559','560','561','562','563','564','565','566') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000792s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (446,'567','568','569','570','571','572') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000673s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (448,'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.000708s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=15 ) [ RunTime:0.000590s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (15,'39','41','44','65','66','67','455','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','380','382','387','388','389','390','391','393','394','395','398','399','401','404','406','408','409','411','414','415','417','418','419','421','427','429','430','431','432','433','435','436','437','438','439','441','443','444','447','449','450','459','461','463','464','465','466','467','469') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001257s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=15 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000570s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (455,'459','461','463','464','465','466','467','469') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000773s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (39,'362','363','364','365','366','367','368','369','370','371','372','373','374') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000980s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (41,'375','376','377','378','380','382','387','388','389','390','391') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000936s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (44,'393','394','395','398','399','401','404','406') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000836s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (65,'408','409','411','414','415','417','418','419','421') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000670s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=16 ) [ RunTime:0.000555s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (16,'45','46','47','68','69','460','462','270','273','276','279','281','283','312','315','318','320','286','289','290','292','294','322','323','326','327','300','301','303','306','308','331','334','336','311','337','340','342','345','347','350','352','353','354','355','356','357','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.001479s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=16 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000649s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `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.000694s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `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.000733s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (45,'270','273','276','279','281','283','312','315','318','320') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.001422s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (46,'286','289','290','292','294','322','323','326','327') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000863s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (47,'300','301','303','306','308','331','334','336') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000753s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=468 ) [ RunTime:0.000469s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (468,'670','671','672','673','674','675','676','677','678','679','680','681','682','683','684','685','686','687','688','689','690','691','692','693','694','695','696','697','698','699','700','701','702','703','704','705','706','707','708','709','710','711','712','713','714','715','716','717','718','719','720','721','722','723','724','725','726','727','728','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.001078s ]
[ SQL ] SELECT * FROM `mz_goodsclass` WHERE ( gc_parent_id=468 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000462s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (670,'677','678','679','680','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.000641s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (671,'685','686','687','688','689','690','691','692') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000626s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `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.000576s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (673,'701','702','703','704','705','706','707','708','709','710') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000663s ]
[ SQL ] SELECT `goods`.`goods_id`,`goodscommon`.`goods_marketprice`,`goodscommon`.`goods_name`,`goodscommon`.`goods_advword`,`goodscommon`.`goods_image`,`goodscommon`.`store_id`,`goods`.`goods_promotion_price`,`goodscommon`.`goods_price` FROM `mz_goodscommon` `goodscommon` INNER JOIN `mz_goods` `goods` ON `goods`.`goods_commonid`=`goodscommon`.`goods_commonid` WHERE `goodscommon`.`gc_id` IN (674,'711','712','713','714','715','716','717','718','719','720') AND `goodscommon`.`goods_state` = 1 AND `goodscommon`.`goods_verify` = 1 GROUP BY `goodscommon`.`goods_commonid` ORDER BY `goodscommon`.`mall_goods_commend` DESC,`goodscommon`.`mall_goods_sort` ASC LIMIT 10 [ RunTime:0.000607s ]
