[ DB ] CONNECT:[ UseTime:0.001705s ] mysql:host=127.0.0.1;dbname=taomeixh;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tmxh_article_class` [ RunTime:0.000854s ]
[ SQL ] SELECT * FROM `tmxh_article_class` WHERE ( ac_img_state = '1' AND ac_code = '' ) [ RunTime:0.000382s ]
[ SQL ] SHOW COLUMNS FROM `tmxh_goods` [ RunTime:0.000766s ]
[ SQL ] SELECT * FROM `tmxh_goods` WHERE ( id = 138 AND goods_verify = '1' AND goods_state = '1' AND goods_price > 'goods_costprice'* 0.8 ) LIMIT 1 [ RunTime:0.000462s ]
[ SQL ] SHOW COLUMNS FROM `tmxh_goods_class` [ RunTime:0.000637s ]
[ SQL ] SELECT `name`,`route_short` FROM `tmxh_goods_class` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000239s ]
[ SQL ] SELECT `name`,`route_short` FROM `tmxh_goods_class` WHERE `id` = 2674 LIMIT 1 [ RunTime:0.000219s ]
[ SQL ] UPDATE `tmxh_goods` SET `goods_num_click`=796 WHERE ( id = 138 AND goods_verify = '1' AND goods_state = '1' AND goods_price > 'goods_costprice'* 0.8 ) [ RunTime:0.001542s ]
[ SQL ] SHOW COLUMNS FROM `tmxh_goods_images` [ RunTime:0.000553s ]
[ SQL ] SELECT * FROM `tmxh_goods_images` WHERE ( common_id = 138 AND store_id=29 ) ORDER BY `sort` LIMIT 5 [ RunTime:0.001191s ]
[ SQL ] SHOW COLUMNS FROM `tmxh_goods_common` [ RunTime:0.000733s ]
[ SQL ] SELECT * FROM `tmxh_goods_common` WHERE `goods_commonid` = 138 LIMIT 1 [ RunTime:0.000393s ]
[ SQL ] SELECT `store_id`,`goods_price`,`goods_image`,`goods_name` FROM `tmxh_goods` WHERE `id` = 138 LIMIT 1 [ RunTime:0.000234s ]
[ SQL ] SHOW COLUMNS FROM `tmxh_collect` [ RunTime:0.000522s ]
[ SQL ] SELECT * FROM `tmxh_collect` WHERE `goods_id` = 138 AND `member_id` IS NULL AND `collect_type` = 1 LIMIT 1 [ RunTime:0.000226s ]
[ SQL ] SELECT * FROM `tmxh_collect` WHERE `store_id` = 29 AND `member_id` IS NULL AND `collect_type` = 2 LIMIT 1 [ RunTime:0.000287s ]
[ SQL ] SHOW COLUMNS FROM `tmxh_store_goods_class` [ RunTime:0.000588s ]
[ SQL ] SELECT `name`,`id` FROM `tmxh_store_goods_class` WHERE ( store_id =29 AND state=1 AND parent_id != 0 ) [ RunTime:0.000300s ]
[ SQL ] SELECT `goods_price`,`goods_image`,`goods_name`,`store_id`,`id`,`goods_num_sale`,`goods_num_click` FROM `tmxh_goods` WHERE `store_id` = 29 AND `gc_id` = 2674 AND `goods_state` = 1 AND `goods_verify` = 1 AND `goods_price` > 0 AND `goods_commend` = 1 ORDER BY `id` DESC LIMIT 5 [ RunTime:0.001844s ]
[ SQL ] SELECT `goods_price`,`goods_image`,`goods_name`,`store_id`,`id`,`goods_num_sale`,`goods_num_click` FROM `tmxh_goods` WHERE `store_id` = 29 AND `goods_state` = 1 AND `goods_verify` = 1 ORDER BY `goods_num_sale` DESC LIMIT 6 [ RunTime:0.001492s ]
[ SQL ] SELECT `goods_price`,`goods_image`,`goods_name`,`store_id`,`id`,`goods_num_sale`,`goods_num_click` FROM `tmxh_goods` WHERE `store_id` = 29 AND `goods_state` = 1 AND `goods_verify` = 1 ORDER BY `goods_num_click` DESC LIMIT 6 [ RunTime:0.001486s ]
