[ DB ] CONNECT:[ UseTime:0.000407s ] mysql:host=127.0.0.1;port=3306;dbname=mall_chtc365;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ds_goods` [ RunTime:0.001193s ]
[ 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.001940s ]
[ SQL ] SHOW COLUMNS FROM `ds_pxianshigoods` [ RunTime:0.000835s ]
[ SQL ] SELECT * FROM `ds_pxianshigoods` WHERE `xianshigoods_state` = 1 AND `xianshigoods_starttime` < 1713424480 AND `xianshigoods_end_time` > 1713424480 ORDER BY `xianshigoods_recommend` DESC LIMIT 5 [ RunTime:0.000367s ]
[ 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.004216s ]
[ SQL ] SHOW COLUMNS FROM `ds_groupbuy` [ RunTime:0.000968s ]
[ SQL ] SELECT * FROM `ds_groupbuy` WHERE `groupbuy_state` = 20 AND `groupbuy_starttime` < 1713424480 AND `groupbuy_endtime` > 1713424480 ORDER BY `groupbuy_recommended` DESC LIMIT 5 [ RunTime:0.000437s ]
[ SQL ] SHOW COLUMNS FROM `ds_link` [ RunTime:0.000743s ]
[ SQL ] SELECT * FROM `ds_link` ORDER BY `link_sort` ASC [ RunTime:0.000166s ]
[ SQL ] SHOW COLUMNS FROM `ds_article` [ RunTime:0.000738s ]
[ 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.000345s ]
[ SQL ] SHOW COLUMNS FROM `ds_goodsclass` [ RunTime:0.000755s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE `gc_parent_id` = 0 AND `gc_show` = 1 ORDER BY `gc_sort` ASC LIMIT 5 [ RunTime:0.000309s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=770 ) [ RunTime:0.000245s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (770,771,772,773,774,775,776,777,778,996,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,987,989,807,808,809,810,811,812,813,814,815,816,997,998,1001,1161,1162) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.004507s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=770 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000408s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (996) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003762s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (778,809,810,811,812,813,814,815,816,997,998,1001,1161,1162) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003077s ]
[ 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 LIMIT 10 [ RunTime:0.002625s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (776,800,801,802,803,804,805,806,987,989) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002821s ]
[ 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 LIMIT 10 [ RunTime:0.002553s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=770 ) ORDER BY `gc_sort` ASC LIMIT 10 [ RunTime:0.000298s ]
[ 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 LIMIT 10 [ RunTime:0.002936s ]
[ 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 LIMIT 10 [ RunTime:0.002645s ]
[ 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 LIMIT 10 [ RunTime:0.002668s ]
[ 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 LIMIT 10 [ RunTime:0.002639s ]
[ 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 LIMIT 10 [ RunTime:0.002580s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (776,800,801,802,803,804,805,806,987,989) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002827s ]
[ 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 LIMIT 10 [ RunTime:0.003132s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (778,809,810,811,812,813,814,815,816,997,998,1001,1161,1162) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003491s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (996) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003289s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=871 ) [ RunTime:0.000457s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (871,872,873,874,875,876,979,1005,1009,884,885,886,887,888,889,890,891,892,893,894,895,896,897,994,1013,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,1010,918,919,920,921,922,923,1012,924,925,926,927,928,929,930,1011,980,1015) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003988s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=871 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000396s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (979,980,1015) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003181s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (1005) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003426s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (1009) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003012s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (876,924,925,926,927,928,929,930,1011) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003058s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (875,920,921,922,923,1012) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002922s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=871 ) ORDER BY `gc_sort` ASC LIMIT 10 [ RunTime:0.000396s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (872,884,885,886,887,888,889,890,891,892,893,894,895,896,897,994,1013) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003126s ]
[ 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,1010) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003977s ]
[ 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 LIMIT 10 [ RunTime:0.002919s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (875,920,921,922,923,1012) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002761s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (876,924,925,926,927,928,929,930,1011) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002773s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (979,980,1015) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002842s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (1005) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002778s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (1009) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002876s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=931 ) [ RunTime:0.000367s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (931,932,933,934,970,974,1002,1004,1006,935,936,937,938,939,940,941,942,943,944,945,975,988,999,1003,971,972,973,1007,1008) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003368s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=931 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000351s ]
[ 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 LIMIT 10 [ RunTime:0.002850s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (974) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003061s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (1002) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002952s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (1004) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002817s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (1006,1007,1008) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002910s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=931 ) ORDER BY `gc_sort` ASC LIMIT 10 [ RunTime:0.000336s ]
[ 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 LIMIT 10 [ RunTime:0.002829s ]
[ 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 LIMIT 10 [ RunTime:0.002838s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (934,941,942,943,944,945,975,988,999,1003) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002937s ]
[ 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 LIMIT 10 [ RunTime:0.002963s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (974) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002930s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (1002) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003087s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (1004) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002923s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (1006,1007,1008) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002903s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=817 ) [ RunTime:0.000607s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (817,818,1020,820,821,863,822,990,1017,823,824,825,826,827,828,829,830,831,832,833,864,1016,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1044,1045,1046,850,851,854,855,856,857,858,859,860,861,862,865,866,867,981,983,868,869,870,991) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003835s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=817 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000411s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (990,991) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002656s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (1017) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002669s ]
[ 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 LIMIT 10 [ RunTime:0.004692s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (863,865,866,867,981,983) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003532s ]
[ 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 LIMIT 10 [ RunTime:0.003488s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=817 ) ORDER BY `gc_sort` ASC LIMIT 10 [ RunTime:0.000445s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (818,823,824,825,826,827,828,829,830,831,832,833,864,1016) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003557s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1044,1045,1046) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.005248s ]
[ 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 LIMIT 10 [ RunTime:0.003256s ]
[ 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 LIMIT 10 [ RunTime:0.003664s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (863,865,866,867,981,983) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003250s ]
[ 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 LIMIT 10 [ RunTime:0.003832s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (990,991) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.003485s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (1017) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002820s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=1048 ) [ RunTime:0.000267s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `gc_id` IN (1048) AND `goods_commend` = 1 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY `goods_commonid` ORDER BY `goods_sort` ASC LIMIT 10 [ RunTime:0.002614s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=1048 ) ORDER BY `gc_sort` DESC LIMIT 5 [ RunTime:0.000263s ]
[ SQL ] SELECT * FROM `ds_goodsclass` WHERE ( gc_parent_id=1048 ) ORDER BY `gc_sort` ASC LIMIT 10 [ RunTime:0.000218s ]
[ SQL ] SHOW COLUMNS FROM `ds_pboothgoods` [ RunTime:0.000739s ]
[ SQL ] SELECT * FROM `ds_pboothgoods` WHERE `gc_id` IN ('') AND `boothgoods_state` = 1 LIMIT 18 [ RunTime:0.000226s ]
[ SQL ] SELECT * FROM `ds_goods` WHERE `goods_id` IN ('') AND `goods_state` = 1 AND `goods_verify` = 1 ORDER BY `goods_id` DESC [ RunTime:0.000277s ]
[ SQL ] SELECT `goods_id`,`goods_name`,`goods_image`,`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 18 [ RunTime:0.001341s ]
[ SQL ] SHOW COLUMNS FROM `ds_xunjiaorder` [ RunTime:0.000812s ]
[ SQL ] SELECT * FROM `ds_xunjiaorder` ORDER BY `id` DESC LIMIT 8 [ RunTime:0.000192s ]
[ SQL ] SHOW COLUMNS FROM `ds_advposition` [ RunTime:0.000845s ]
[ SQL ] SELECT `ap_id`,`ap_name`,`ap_width`,`ap_height` FROM `ds_advposition` [ RunTime:0.000173s ]
[ SQL ] SHOW COLUMNS FROM `ds_adv` [ RunTime:0.000749s ]
[ SQL ] SELECT * FROM `ds_adv` WHERE ( ap_id=1 and adv_enabled = 1 and adv_startdate < 1709888400 and adv_enddate > 1709888400 ) ORDER BY `adv_sort` DESC LIMIT 10 [ RunTime:0.000274s ]