[ DB ] CONNECT:[ UseTime:0.000345s ] mysql:host=127.0.0.1;dbname=taomeixh;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tmxh_article_class` [ RunTime:0.000880s ]
[ SQL ] SELECT * FROM `tmxh_article_class` WHERE ( ac_img_state = '1' AND ac_code = '' ) [ RunTime:0.000406s ]
[ SQL ] SHOW COLUMNS FROM `tmxh_store` [ RunTime:0.005351s ]
[ SQL ] SELECT `store_id` FROM `tmxh_store` WHERE `store_id` = 27 AND `is_shop` = 0 LIMIT 1 [ RunTime:0.000408s ]
[ SQL ] SELECT * FROM `tmxh_store` WHERE `store_id` = 27 LIMIT 1 [ RunTime:0.000433s ]
[ SQL ] SHOW COLUMNS FROM `tmxh_store_banner` [ RunTime:0.000739s ]
[ SQL ] SELECT * FROM `tmxh_store_banner` WHERE `store_id` = 27 [ RunTime:0.000293s ]
[ SQL ] SHOW COLUMNS FROM `tmxh_store_nav` [ RunTime:0.000581s ]
[ SQL ] SELECT * FROM `tmxh_store_nav` WHERE `store_id` = 27 AND `nav_state` = 2 ORDER BY `nav_sort` LIMIT 7 [ RunTime:0.000291s ]
[ SQL ] SHOW COLUMNS FROM `tmxh_collect` [ RunTime:0.000596s ]
[ SQL ] SELECT * FROM `tmxh_collect` WHERE `store_id` = 27 AND `member_id` IS NULL AND `collect_type` = 2 AND `goods_price` > 0 LIMIT 1 [ RunTime:0.000263s ]
[ SQL ] SHOW COLUMNS FROM `tmxh_store_goods_class` [ RunTime:0.000544s ]
[ SQL ] SELECT `name`,`id` FROM `tmxh_store_goods_class` WHERE ( store_id =27 AND state=1 AND parent_id != 0 ) [ RunTime:0.000310s ]
[ SQL ] SHOW COLUMNS FROM `tmxh_goods` [ RunTime:0.000775s ]
[ SQL ] SELECT `goods_name`,`id`,`store_id`,`goods_image`,`goods_price`,`goods_num_sale`,`goods_num_click` FROM `tmxh_goods` WHERE `store_id` = 27 AND `goods_state` = 1 AND `goods_price` > 0 AND `goods_verify` = 1 ORDER BY `goods_num_click` DESC LIMIT 3 [ RunTime:0.001855s ]
[ SQL ] SELECT `store_id`,`goods_id` FROM `tmxh_collect` WHERE `store_id` = 27 AND `goods_price` > 0 AND `collect_type` = 1 LIMIT 3 [ RunTime:0.000384s ]
[ SQL ] SELECT `goods_name`,`id`,`store_id`,`goods_image`,`goods_price`,`goods_num_sale`,`goods_num_click` FROM `tmxh_goods` WHERE `store_id` = 27 AND `id` IN (167) AND `goods_state` = 1 AND `goods_price` > 0 AND `goods_verify` = 1 LIMIT 3 [ RunTime:0.000330s ]
[ SQL ] SHOW COLUMNS FROM `tmxh_area` [ RunTime:0.000751s ]
[ SQL ] SELECT `name` FROM `tmxh_area` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000231s ]
[ SQL ] SELECT `name` FROM `tmxh_area` WHERE `id` = 36 LIMIT 1 [ RunTime:0.000188s ]
[ SQL ] SELECT `name` FROM `tmxh_area` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000242s ]
[ SQL ] SHOW COLUMNS FROM `tmxh_store_class` [ RunTime:0.000660s ]
[ SQL ] SELECT `name` FROM `tmxh_store_class` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000294s ]
[ SQL ] SELECT `goods_name`,`id`,`store_id`,`goods_image`,`goods_price`,`goods_num_sale` FROM `tmxh_goods` WHERE `store_id` = 27 AND `goods_state` = 1 AND `goods_verify` = 1 AND `goods_price` > 0 AND `goods_commend` = 1 LIMIT 4 [ RunTime:0.000379s ]
[ SQL ] SELECT * FROM `tmxh_collect` WHERE `store_id` = 27 AND `goods_id` = 63 AND `member_id` IS NULL AND `collect_type` = 1 LIMIT 1 [ RunTime:0.000315s ]
[ SQL ] SELECT * FROM `tmxh_collect` WHERE `store_id` = 27 AND `goods_id` = 64 AND `member_id` IS NULL AND `collect_type` = 1 LIMIT 1 [ RunTime:0.000246s ]
[ SQL ] SELECT * FROM `tmxh_collect` WHERE `store_id` = 27 AND `goods_id` = 65 AND `member_id` IS NULL AND `collect_type` = 1 LIMIT 1 [ RunTime:0.000248s ]
[ SQL ] SELECT * FROM `tmxh_collect` WHERE `store_id` = 27 AND `goods_id` = 66 AND `member_id` IS NULL AND `collect_type` = 1 LIMIT 1 [ RunTime:0.000244s ]
[ SQL ] SELECT `goods_name`,`id`,`store_id`,`goods_image`,`goods_price`,`goods_num_sale` FROM `tmxh_goods` WHERE `store_id` = 27 AND `goods_state` = 1 AND `goods_price` > 0 AND `goods_verify` = 1 ORDER BY `id` DESC LIMIT 8 [ RunTime:0.000522s ]
[ SQL ] SELECT * FROM `tmxh_collect` WHERE `store_id` = 27 AND `goods_id` = 1934 AND `member_id` IS NULL AND `collect_type` = 1 LIMIT 1 [ RunTime:0.000247s ]
[ SQL ] SELECT * FROM `tmxh_collect` WHERE `store_id` = 27 AND `goods_id` = 1933 AND `member_id` IS NULL AND `collect_type` = 1 LIMIT 1 [ RunTime:0.000272s ]
[ SQL ] SELECT * FROM `tmxh_collect` WHERE `store_id` = 27 AND `goods_id` = 1932 AND `member_id` IS NULL AND `collect_type` = 1 LIMIT 1 [ RunTime:0.000238s ]
[ SQL ] SELECT * FROM `tmxh_collect` WHERE `store_id` = 27 AND `goods_id` = 1931 AND `member_id` IS NULL AND `collect_type` = 1 LIMIT 1 [ RunTime:0.000267s ]
[ SQL ] SELECT * FROM `tmxh_collect` WHERE `store_id` = 27 AND `goods_id` = 1839 AND `member_id` IS NULL AND `collect_type` = 1 LIMIT 1 [ RunTime:0.000267s ]
[ SQL ] SELECT * FROM `tmxh_collect` WHERE `store_id` = 27 AND `goods_id` = 1838 AND `member_id` IS NULL AND `collect_type` = 1 LIMIT 1 [ RunTime:0.000255s ]
[ SQL ] SELECT * FROM `tmxh_collect` WHERE `store_id` = 27 AND `goods_id` = 1837 AND `member_id` IS NULL AND `collect_type` = 1 LIMIT 1 [ RunTime:0.000214s ]
[ SQL ] SELECT * FROM `tmxh_collect` WHERE `store_id` = 27 AND `goods_id` = 1836 AND `member_id` IS NULL AND `collect_type` = 1 LIMIT 1 [ RunTime:0.000235s ]