[ DB ] CONNECT:[ UseTime:0.008892s ] mysql:dbname=shoem_db;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `33hao_goods` [ RunTime:0.001559s ]
[ SQL ] SELECT * FROM `33hao_goods` WHERE `goods_id` = 124756 LIMIT 1 [ RunTime:0.001004s ]
[ SQL ] SELECT * FROM `33hao_goods` WHERE `goods_id` = 124756 LIMIT 1 [ RunTime:0.000996s ]
[ SQL ] SHOW COLUMNS FROM `33hao_goods_common` [ RunTime:0.001391s ]
[ SQL ] SELECT * FROM `33hao_goods_common` WHERE `goods_commonid` = 103065 LIMIT 1 [ RunTime:0.001206s ]
[ 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.009153s ]
[ SQL ] SHOW COLUMNS FROM `33hao_goods_images` [ RunTime:0.001030s ]
[ 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.003191s ]
[ SQL ] UPDATE `33hao_goods` SET `goods_click`=goods_click + 1,`goods_edittime`=1594124175 WHERE `goods_id` IN (124756) [ RunTime:0.000664s ]
[ SQL ] SHOW COLUMNS FROM `33hao_evaluate_goods` [ RunTime:0.001416s ]
[ SQL ] SELECT count(*) as count,`geval_scores` FROM `33hao_evaluate_goods` WHERE ( geval_goodsid ='124756' ) GROUP BY geval_scores [ RunTime:0.000662s ]
[ SQL ] UPDATE `33hao_goods` SET `evaluation_good_star`=5,`evaluation_count`=0,`goods_edittime`=1594124175 WHERE `goods_id` IN (124756) [ RunTime:0.000548s ]
[ SQL ] SHOW COLUMNS FROM `33hao_store` [ RunTime:0.001533s ]
[ SQL ] SELECT * FROM `33hao_store` WHERE `store_id` = 3 LIMIT 1 [ RunTime:0.001489s ]
[ 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.020847s ]
[ 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.020692s ]
[ 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.021740s ]
[ SQL ] SHOW COLUMNS FROM `33hao_goods_class` [ RunTime:0.001175s ]
[ SQL ] SELECT `gc_id` FROM `33hao_goods_class` WHERE ( gc_show=1 and gc_parent_id!=0 ) ORDER BY rand() LIMIT 10 [ RunTime:0.001224s ]
[ SQL ] SELECT `goods_id`,`goods_name`,`goods_image`,`goods_promotion_price` FROM `33hao_goods` WHERE `gc_id` IN (2196,2661,2625,3046,2485,3184,2447,3008,398,478) AND `goods_state` = 1 ORDER BY rand() LIMIT 6 [ RunTime:0.009926s ]
商品评价
100 % 好评
共有0人参与评分