[ DB ] CONNECT:[ UseTime:0.002925s ] mysql:dbname=shoem_db;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `33hao_goods` [ RunTime:0.001107s ]
[ SQL ] SELECT * FROM `33hao_goods` WHERE `goods_id` = 124756 LIMIT 1 [ RunTime:0.000634s ]
[ SQL ] SHOW COLUMNS FROM `33hao_groupbuy` [ RunTime:0.000820s ]
[ SQL ] SELECT * FROM `33hao_groupbuy` WHERE `state` = 20 AND `end_time` > 1576491056 AND `goods_commonid` = 103065 ORDER BY start_time asc LIMIT 0,1 [ RunTime:0.000546s ]
[ SQL ] SELECT * FROM `33hao_goods` WHERE `goods_id` = 124756 LIMIT 1 [ RunTime:0.000525s ]
[ SQL ] SHOW COLUMNS FROM `33hao_goods_common` [ RunTime:0.001069s ]
[ SQL ] SELECT * FROM `33hao_goods_common` WHERE `goods_commonid` = 103065 LIMIT 1 [ RunTime:0.000877s ]
[ SQL ] SELECT `goods_spec`,`goods_id`,`store_id`,`goods_image`,`color_id` FROM `33hao_goods` WHERE `goods_commonid` = 103065 ORDER BY goods_id desc [ RunTime:0.008791s ]
[ SQL ] SHOW COLUMNS FROM `33hao_goods_images` [ RunTime:0.000727s ]
[ SQL ] SELECT * FROM `33hao_goods_images` WHERE `goods_commonid` = 103065 AND `color_id` = 6486 ORDER BY is_default desc,goods_image_sort asc [ RunTime:0.003135s ]
[ SQL ] UPDATE `33hao_goods` SET `goods_click`=goods_click + 1,`goods_edittime`=1576491056 WHERE `goods_id` IN (124756) [ RunTime:0.000438s ]
[ SQL ] SHOW COLUMNS FROM `33hao_evaluate_goods` [ RunTime:0.000715s ]
[ SQL ] SELECT count(*) as count,`geval_scores` FROM `33hao_evaluate_goods` WHERE ( geval_goodsid ='124756' ) GROUP BY geval_scores [ RunTime:0.000408s ]
[ SQL ] UPDATE `33hao_goods` SET `evaluation_good_star`=5,`evaluation_count`=0,`goods_edittime`=1576491056 WHERE `goods_id` IN (124756) [ RunTime:0.000313s ]
[ SQL ] SHOW COLUMNS FROM `33hao_store` [ RunTime:0.000900s ]
[ SQL ] SELECT * FROM `33hao_store` WHERE `store_id` = 3 LIMIT 1 [ RunTime:0.000400s ]
[ SQL ] SELECT `goods_id`,`goods_name`,`goods_price`,`goods_image`,`goods_collect`,`goods_salenum` FROM `33hao_goods` WHERE `store_id` = 3 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY goods_commonid ORDER BY goods_collect desc LIMIT 5 [ RunTime:0.019906s ]
[ SQL ] SELECT `goods_id`,`goods_name`,`goods_price`,`goods_image`,`goods_collect`,`goods_salenum` FROM `33hao_goods` WHERE `store_id` = 3 AND `goods_state` = 1 AND `goods_verify` = 1 GROUP BY goods_commonid ORDER BY goods_salenum desc LIMIT 5 [ RunTime:0.019210s ]
[ SQL ] SELECT `goods_id`,`goods_name`,`goods_price`,`goods_image`,`goods_collect`,`goods_salenum` FROM `33hao_goods` WHERE `store_id` = 3 AND `goods_state` = 1 AND `goods_verify` = 1 AND `goods_commend` = 1 GROUP BY goods_commonid ORDER BY rand() LIMIT 5 [ RunTime:0.020448s ]
[ SQL ] SHOW COLUMNS FROM `33hao_goods_class` [ RunTime:0.000847s ]
[ SQL ] SELECT `gc_id` FROM `33hao_goods_class` WHERE ( gc_show=1 and gc_parent_id!=0 ) ORDER BY rand() LIMIT 10 [ RunTime:0.001114s ]
[ SQL ] SELECT `goods_id`,`goods_name`,`goods_image`,`goods_promotion_price` FROM `33hao_goods` WHERE `gc_id` IN (2831,2427,2553,2721,3182,410,3028,2574,369,1985) AND `goods_state` = 1 ORDER BY rand() LIMIT 6 [ RunTime:0.009334s ]
商品评价
100 % 好评
共有0人参与评分