[ DB ] CONNECT:[ UseTime:0.000315s ] mysql:host=127.0.0.1;port=3306;dbname=bb2_tadiao;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tp_mobile_template` [ RunTime:0.000651s ]
[ SQL ] SELECT `template_html`,`block_info` FROM `tp_mobile_template` WHERE ( is_index=1 ) LIMIT 1 [ RunTime:0.000440s ]
[ SQL ] SHOW COLUMNS FROM `tp_coupon` [ RunTime:0.000464s ]
[ SQL ] SELECT * FROM `tp_coupon` WHERE `type` = 4 AND `send_start_time` <= 1758415047 AND `send_end_time` >= 1758415047 AND `status` = 1 ORDER BY `add_time` desc LIMIT 2 [ RunTime:0.000326s ]
[ SQL ] SHOW COLUMNS FROM `tp_order` [ RunTime:0.000614s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_order` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000190s ]
[ SQL ] SHOW COLUMNS FROM `tp_users` [ RunTime:0.000609s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_users` WHERE `reg_time` > 1757810247 AND `user_id` IS NULL LIMIT 1 [ RunTime:0.000195s ]
[ SQL ] SHOW COLUMNS FROM `tp_coupon_list` [ RunTime:0.000409s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_coupon_list` WHERE `uid` IS NULL LIMIT 1 [ RunTime:0.000158s ]
[ SQL ] SHOW COLUMNS FROM `tp_team_goods_item` [ RunTime:0.000419s ]
[ 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.000354s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods` [ RunTime:0.000654s ]
[ 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.000684s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods_category` [ RunTime:0.000442s ]
[ SQL ] SELECT * FROM `tp_goods_category` WHERE ( level=1 ) ORDER BY `sort_order` LIMIT 9 [ RunTime:0.000340s ]
[ 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.000576s ]
[ 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 >= 1758412800 and f.end_time <= 1758420000 and f.recommend=1 ) LIMIT 3 [ RunTime:0.000413s ]
[ SQL ] SHOW COLUMNS FROM `tp_ad` [ RunTime:0.001734s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=2 and enabled = 1 and start_time <= 1758409153 and end_time >= 1758409153 ) ORDER BY orderby desc LIMIT 5 [ RunTime:0.002134s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=301 and enabled = 1 and start_time <= 1758409153 and end_time >= 1758409153 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000388s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=302 and enabled = 1 and start_time <= 1758409153 and end_time >= 1758409153 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000383s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=300 and enabled = 1 and start_time <= 1758409153 and end_time >= 1758409153 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000403s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=303 and enabled = 1 and start_time <= 1758409153 and end_time >= 1758409153 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000428s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=400 and enabled = 1 and start_time <= 1758409153 and end_time >= 1758409153 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000361s ]
