[ DB ] CONNECT:[ UseTime:0.000387s ] mysql:host=127.0.0.1;port=3306;dbname=bb2_tadiao;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tp_mobile_template` [ RunTime:0.000607s ]
[ SQL ] SELECT `template_html`,`block_info` FROM `tp_mobile_template` WHERE ( is_index=1 ) LIMIT 1 [ RunTime:0.000476s ]
[ SQL ] SHOW COLUMNS FROM `tp_coupon` [ RunTime:0.000469s ]
[ SQL ] SELECT * FROM `tp_coupon` WHERE `type` = 4 AND `send_start_time` <= 1748010864 AND `send_end_time` >= 1748010864 AND `status` = 1 ORDER BY `add_time` desc LIMIT 2 [ RunTime:0.000351s ]
[ SQL ] SHOW COLUMNS FROM `tp_order` [ RunTime:0.000632s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_order` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000171s ]
[ SQL ] SHOW COLUMNS FROM `tp_users` [ RunTime:0.000578s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_users` WHERE `reg_time` > 1747406064 AND `user_id` IS NULL LIMIT 1 [ RunTime:0.000187s ]
[ SQL ] SHOW COLUMNS FROM `tp_coupon_list` [ RunTime:0.000428s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_coupon_list` WHERE `uid` IS NULL LIMIT 1 [ RunTime:0.000150s ]
[ SQL ] SHOW COLUMNS FROM `tp_team_goods_item` [ RunTime:0.000441s ]
[ 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.000337s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods` [ RunTime:0.000687s ]
[ 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.000649s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods_category` [ RunTime:0.000417s ]
[ SQL ] SELECT * FROM `tp_goods_category` WHERE ( level=1 ) ORDER BY `sort_order` LIMIT 9 [ RunTime:0.000334s ]
[ 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.000532s ]
[ 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 >= 1748008800 and f.end_time <= 1748016000 and f.recommend=1 ) LIMIT 3 [ RunTime:0.000270s ]
[ SQL ] SHOW COLUMNS FROM `tp_ad_position` [ RunTime:0.000401s ]
[ SQL ] SELECT `position_id`,`position_name`,`ad_width`,`ad_height` FROM `tp_ad_position` [ RunTime:0.000188s ]
[ SQL ] SHOW COLUMNS FROM `tp_ad` [ RunTime:0.000412s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=2 and enabled = 1 and start_time <= 1748008630 and end_time >= 1748008630 ) ORDER BY orderby desc LIMIT 5 [ RunTime:0.000291s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=301 and enabled = 1 and start_time <= 1748008630 and end_time >= 1748008630 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000274s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=302 and enabled = 1 and start_time <= 1748008630 and end_time >= 1748008630 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000256s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=300 and enabled = 1 and start_time <= 1748008630 and end_time >= 1748008630 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000306s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=303 and enabled = 1 and start_time <= 1748008630 and end_time >= 1748008630 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000324s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=400 and enabled = 1 and start_time <= 1748008630 and end_time >= 1748008630 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000313s ]
