[ DB ] CONNECT:[ UseTime:0.000362s ] mysql:host=127.0.0.1;port=3306;dbname=bb2_tadiao;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tp_mobile_template` [ RunTime:0.000579s ]
[ SQL ] SELECT `template_html`,`block_info` FROM `tp_mobile_template` WHERE ( is_index=1 ) LIMIT 1 [ RunTime:0.002970s ]
[ SQL ] SHOW COLUMNS FROM `tp_coupon` [ RunTime:0.000489s ]
[ SQL ] SELECT * FROM `tp_coupon` WHERE `type` = 4 AND `send_start_time` <= 1771363721 AND `send_end_time` >= 1771363721 AND `status` = 1 ORDER BY `add_time` desc LIMIT 2 [ RunTime:0.000422s ]
[ SQL ] SHOW COLUMNS FROM `tp_order` [ RunTime:0.000672s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_order` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.002895s ]
[ SQL ] SHOW COLUMNS FROM `tp_users` [ RunTime:0.000617s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_users` WHERE `reg_time` > 1770758921 AND `user_id` IS NULL LIMIT 1 [ RunTime:0.000200s ]
[ SQL ] SHOW COLUMNS FROM `tp_coupon_list` [ RunTime:0.000550s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_coupon_list` WHERE `uid` IS NULL LIMIT 1 [ RunTime:0.000163s ]
[ SQL ] SHOW COLUMNS FROM `tp_team_goods_item` [ RunTime:0.003253s ]
[ SQL ] SELECT *,i.team_price as team_price,a.team_price as team_activity_price FROM `tp_team_goods_item` `i` INNER JOIN `tp_team_activity` `a` ON `a`.`team_id`=`i`.`team_id` WHERE `a`.`status` = 1 AND `a`.`is_lottery` = 0 AND `a`.`deleted` = 0 GROUP BY `i`.`goods_id` ORDER BY a.team_id desc LIMIT 20 [ RunTime:0.000374s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods` [ RunTime:0.000704s ]
[ SQL ] SELECT * FROM `tp_goods` WHERE ( is_hot=1 and is_on_sale=1 and goods_state=1 ) ORDER BY goods_id DESC LIMIT 20 [ RunTime:0.000731s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods_category` [ RunTime:0.000455s ]
[ SQL ] SELECT * FROM `tp_goods_category` WHERE ( level=1 ) ORDER BY `sort_order` LIMIT 9 [ RunTime:0.000377s ]
[ SQL ] SELECT * FROM `tp_goods` WHERE ( is_recommend=1 and is_on_sale=1 and goods_state=1 ) ORDER BY sort DESC LIMIT 20 [ RunTime:0.000569s ]
[ SQL ] SELECT `g`.`goods_id`,`f`.`price`,`s`.`item_id`,`f`.`title` FROM `tp_goods` `g` LEFT JOIN `tp_flash_sale` `f` ON `g`.`goods_id`=`f`.`goods_id` LEFT JOIN `tp_spec_goods_price` `s` ON `s`.`prom_id`=f.id AND g.goods_id = s.goods_id WHERE `f`.`status` = 1 AND ( f.start_time >= 1771358400 and f.end_time <= 1771365600 and f.recommend=1 ) LIMIT 3 [ RunTime:0.000346s ]
[ SQL ] SHOW COLUMNS FROM `tp_ad` [ RunTime:0.000465s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=2 and enabled = 1 and start_time <= 1771317452 and end_time >= 1771317452 ) ORDER BY orderby desc LIMIT 5 [ RunTime:0.000304s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=301 and enabled = 1 and start_time <= 1771317452 and end_time >= 1771317452 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000304s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=302 and enabled = 1 and start_time <= 1771317452 and end_time >= 1771317452 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000310s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=300 and enabled = 1 and start_time <= 1771317452 and end_time >= 1771317452 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000290s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=303 and enabled = 1 and start_time <= 1771317452 and end_time >= 1771317452 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000262s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=400 and enabled = 1 and start_time <= 1771317452 and end_time >= 1771317452 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000283s ]
