[ DB ] CONNECT:[ UseTime:0.000565s ] mysql:host=127.0.0.1;port=3306;dbname=mall_chtc365;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ds_goods` [ RunTime:0.001564s ]
[ SQL ] SELECT `goods_id`,`goods_name`,`goods_advword`,`goods_image`,`store_id`,`goods_promotion_price`,`goods_price` FROM `ds_goods` WHERE `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 5 [ RunTime:0.001106s ]
[ SQL ] SHOW COLUMNS FROM `ds_pxianshigoods` [ RunTime:0.001145s ]
[ SQL ] SELECT * FROM `ds_pxianshigoods` WHERE `xianshigoods_state` = 1 AND `xianshigoods_starttime` < 1568542143 AND `xianshigoods_end_time` > 1568542143 ORDER BY `xianshigoods_recommend` DESC LIMIT 5 [ RunTime:0.000364s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_addtime` DESC LIMIT 5 [ RunTime:0.001997s ]
[ SQL ] SHOW COLUMNS FROM `ds_groupbuy` [ RunTime:0.001293s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ds_groupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1568542143 AND `groupbuy_endtime` > 1568542143 LIMIT 1 [ RunTime:0.000333s ]
[ SQL ] SELECT * FROM `ds_groupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1568542143 AND `groupbuy_endtime` > 1568542143 ORDER BY `groupbuy_recommended` DESC LIMIT 0,15 [ RunTime:0.000325s ]
[ SQL ] SHOW COLUMNS FROM `ds_link` [ RunTime:0.000904s ]
[ SQL ] SELECT * FROM `ds_link` ORDER BY `link_sort` ASC [ RunTime:0.000222s ]
[ SQL ] SHOW COLUMNS FROM `ds_article` [ RunTime:0.000869s ]
[ 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.000416s ]
[ SQL ] SHOW COLUMNS FROM `ds_goodsclass` [ RunTime:0.000891s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE `gc_parent_id` = 0 AND `gc_show` = 1 ORDER BY `gc_sort` ASC [ RunTime:0.000350s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=770 ) [ RunTime:0.000272s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (770,771,772,773,774,775,776,777,778,779,780,781,782,783,784,785,786,787,946,947,948,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001575s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=770 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000374s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (778,809,810,811,812,813,814,815,816) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001657s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (777,807,808) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001230s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (776,800,801,802,803,804,805,806) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001237s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (775,797,798,799) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001279s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (774,795,796) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001181s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=770 ) ORDER BY `gc_sort` ASC LIMIT 8 [ RunTime:0.000360s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (771,779,780,781,782,783,784,785,786,787,946,947,948) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001351s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (772,788,789,790,791) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001187s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (773,792,793,794) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001186s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (774,795,796) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001175s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (775,797,798,799) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001186s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (776,800,801,802,803,804,805,806) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001244s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (777,807,808) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001193s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (778,809,810,811,812,813,814,815,816) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001207s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=871 ) [ RunTime:0.000343s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (871,872,873,874,875,876,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001471s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=871 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000339s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (876,924,925,926,927,928,929,930) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001266s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (875,920,921,922,923) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001259s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (874,918,919) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001318s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (873,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001211s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (872,884,885,886,887,888,889,890,891,892,893,894,895,896,897) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001382s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=871 ) ORDER BY `gc_sort` ASC LIMIT 8 [ RunTime:0.000388s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (872,884,885,886,887,888,889,890,891,892,893,894,895,896,897) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001343s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (873,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001269s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (874,918,919) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001167s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (875,920,921,922,923) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001231s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (876,924,925,926,927,928,929,930) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001199s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=931 ) [ RunTime:0.000624s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (931,932,933,934,970,935,936,937,938,939,940,941,942,943,944,945,971,972,973) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001772s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=931 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000358s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (970,971,972,973) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001350s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (934,941,942,943,944,945) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001426s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (933,938,939,940) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001363s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (932,935,936,937) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001203s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=931 ) ORDER BY `gc_sort` ASC LIMIT 8 [ RunTime:0.000324s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (932,935,936,937) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001192s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (933,938,939,940) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001499s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (934,941,942,943,944,945) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.002612s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (970,971,972,973) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.002132s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=949 ) [ RunTime:0.000483s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.002137s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=949 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000623s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (952,963,964,965,966,967,968,969) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.002184s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (951,955,956,957,958,959,960,961,962) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001943s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (950,953,954) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.002066s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=949 ) ORDER BY `gc_sort` ASC LIMIT 8 [ RunTime:0.000755s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (950,953,954) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001542s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (951,955,956,957,958,959,960,961,962) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001519s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (952,963,964,965,966,967,968,969) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001306s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=817 ) [ RunTime:0.000317s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (817,818,819,820,821,863,822,823,824,825,826,827,828,829,830,831,832,833,864,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,854,855,856,857,858,859,860,861,862,865,866,867,868,869,870) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001791s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=817 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000416s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (822,868,869,870) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001437s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (863,865,866,867) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001584s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (821,857,858,859,860,861,862) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001299s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (820,850,851,854,855,856) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001382s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (819,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001788s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=817 ) ORDER BY `gc_sort` ASC LIMIT 8 [ RunTime:0.000409s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (818,823,824,825,826,827,828,829,830,831,832,833,864) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001479s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (819,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001773s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (820,850,851,854,855,856) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001989s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (821,857,858,859,860,861,862) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001919s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (863,865,866,867) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001342s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (822,868,869,870) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC,`goods_commend` DESC,`goods_id` DESC LIMIT 10 [ RunTime:0.001389s ]
[ SQL ] SHOW COLUMNS FROM `ds_advposition` [ RunTime:0.000945s ]
[ SQL ] SELECT `ap_id`,`ap_name`,`ap_width`,`ap_height` FROM `ds_advposition` [ RunTime:0.000243s ]
[ SQL ] SHOW COLUMNS FROM `ds_adv` [ RunTime:0.000839s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=1 and adv_enabled = 1 and adv_startdate < 1566446400 and adv_enddate > 1566446400 ) ORDER BY `adv_sort` DESC LIMIT 10 [ RunTime:0.000481s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=2 and adv_enabled = 1 and adv_startdate < 1566446400 and adv_enddate > 1566446400 ) ORDER BY `adv_sort` DESC LIMIT 10 [ RunTime:0.000354s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=8 and adv_enabled = 1 and adv_startdate < 1566446400 and adv_enddate > 1566446400 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000299s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=3 and adv_enabled = 1 and adv_startdate < 1566446400 and adv_enddate > 1566446400 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000297s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=9 and adv_enabled = 1 and adv_startdate < 1566446400 and adv_enddate > 1566446400 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000291s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=4 and adv_enabled = 1 and adv_startdate < 1566446400 and adv_enddate > 1566446400 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000299s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=10 and adv_enabled = 1 and adv_startdate < 1566446400 and adv_enddate > 1566446400 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000294s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=5 and adv_enabled = 1 and adv_startdate < 1566446400 and adv_enddate > 1566446400 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000420s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=12 and adv_enabled = 1 and adv_startdate < 1566446400 and adv_enddate > 1566446400 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000293s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=7 and adv_enabled = 1 and adv_startdate < 1566446400 and adv_enddate > 1566446400 ) ORDER BY `adv_sort` DESC LIMIT 1 [ RunTime:0.000349s ]
