[ DB ] CONNECT:[ UseTime:0.000353s ] mysql:host=127.0.0.1;port=3306;dbname=bb2_tadiao;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tp_mobile_template` [ RunTime:0.000613s ]
[ SQL ] SELECT `template_html`,`block_info` FROM `tp_mobile_template` WHERE ( is_index=1 ) LIMIT 1 [ RunTime:0.000488s ]
[ SQL ] SHOW COLUMNS FROM `tp_coupon` [ RunTime:0.000519s ]
[ SQL ] SELECT * FROM `tp_coupon` WHERE `type` = 4 AND `send_start_time` <= 1752686583 AND `send_end_time` >= 1752686583 AND `status` = 1 ORDER BY `add_time` desc LIMIT 2 [ RunTime:0.000344s ]
[ SQL ] SHOW COLUMNS FROM `tp_order` [ RunTime:0.000709s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_order` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000181s ]
[ SQL ] SHOW COLUMNS FROM `tp_users` [ RunTime:0.000673s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_users` WHERE `reg_time` > 1752081783 AND `user_id` IS NULL LIMIT 1 [ RunTime:0.000212s ]
[ SQL ] SHOW COLUMNS FROM `tp_coupon_list` [ RunTime:0.000468s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_coupon_list` WHERE `uid` IS NULL LIMIT 1 [ RunTime:0.000190s ]
[ SQL ] SHOW COLUMNS FROM `tp_team_goods_item` [ RunTime:0.000439s ]
[ 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.000412s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods` [ RunTime:0.000754s ]
[ 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.000720s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods_category` [ RunTime:0.000515s ]
[ SQL ] SELECT * FROM `tp_goods_category` WHERE ( level=1 ) ORDER BY `sort_order` LIMIT 9 [ RunTime:0.000394s ]
[ 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.000691s ]
[ 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 >= 1752681600 and f.end_time <= 1752688800 and f.recommend=1 ) LIMIT 3 [ RunTime:0.000342s ]
[ SQL ] SHOW COLUMNS FROM `tp_ad` [ RunTime:0.000547s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=2 and enabled = 1 and start_time <= 1752685069 and end_time >= 1752685069 ) ORDER BY orderby desc LIMIT 5 [ RunTime:0.000335s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=301 and enabled = 1 and start_time <= 1752685069 and end_time >= 1752685069 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000317s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=302 and enabled = 1 and start_time <= 1752685069 and end_time >= 1752685069 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000319s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=300 and enabled = 1 and start_time <= 1752685069 and end_time >= 1752685069 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000268s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=303 and enabled = 1 and start_time <= 1752685069 and end_time >= 1752685069 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000283s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=400 and enabled = 1 and start_time <= 1752685069 and end_time >= 1752685069 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000298s ]
