SHOW FULL COLUMNS FROM `t_agent` [ RunTime:0.000893s ]
SHOW FULL COLUMNS FROM `t_need` [ RunTime:0.001025s ]
SELECT COUNT(*) AS think_count FROM `t_need` WHERE `status` = 2 AND `is_del` = 0 AND `expiry_time` > '2024-04-28 11:16:22' LIMIT 1 [ RunTime:0.012197s ]
SELECT id,title,brand,public_title,stick_index,create_time,update_time,refresh_time,user_id,comment,hits,is_good,form,`column` FROM `t_need` WHERE `status` = 2 AND `is_del` = 0 AND `expiry_time` > '2024-04-28 11:16:22' ORDER BY `create_time` DESC LIMIT 120,30 [ RunTime:0.001010s ]
SHOW FULL COLUMNS FROM `t_users` [ RunTime:0.001020s ]
SELECT id,username,head_portrait,is_auth1,is_auth2,realname,brand,company,position,department,city,is_data FROM `t_users` WHERE `id` IN (49208,51892,10131,52021,33715,52059,38255,29169,37498,50548,14413,14327,28719,49646,608,51030,8736,27994,49587,52026,11781,50196) [ RunTime:0.000697s ]
SHOW FULL COLUMNS FROM `t_user_vip` [ RunTime:0.000770s ]
SELECT * FROM `t_user_vip` WHERE `end_time` > 1714274182 AND `user_id` IN (608,8736,10131,11781,14327,14413,27994,28719,29169,33715,37498,38255,49208,49587,49646,50196,50548,51030,51892,52021,52026,52059) [ RunTime:0.000646s ]
SHOW FULL COLUMNS FROM `t_industry` [ RunTime:0.000830s ]
SELECT * FROM `t_industry` WHERE `pid` = 0 [ RunTime:0.000243s ]
SHOW FULL COLUMNS FROM `t_record` [ RunTime:0.000746s ]
SELECT id,user_id,n_id,username,to_username,create_time FROM `t_record` ORDER BY `id` DESC LIMIT 50 [ RunTime:0.000190s ]
SELECT COUNT(*) AS think_count FROM `t_record` LIMIT 1 [ RunTime:0.000197s ]
SHOW FULL COLUMNS FROM `t_company` [ RunTime:0.000931s ]
SELECT `id`,`name`,`brand`,`logo` FROM `t_company` WHERE `status` = 2 ORDER BY `is_recommend` DESC,`sort_time` DESC LIMIT 4 [ RunTime:0.000239s ]
SELECT `id`,`title`,`is_recommend` FROM `t_need` WHERE `form` = 1 AND `is_del` = 0 AND `status` = 2 ORDER BY `is_recommend` DESC,`create_time` DESC LIMIT 5 [ RunTime:0.010806s ]
SELECT `id`,`title`,`is_recommend` FROM `t_need` WHERE `form` = 2 AND `is_del` = 0 AND `status` = 2 ORDER BY `is_recommend` DESC,`create_time` DESC LIMIT 5 [ RunTime:0.007346s ]
SELECT `id`,`title`,`is_recommend` FROM `t_need` WHERE `form` = 9 AND `is_del` = 0 AND `status` = 2 ORDER BY `is_recommend` DESC,`create_time` DESC LIMIT 5 [ RunTime:0.005276s ]
SELECT `id`,`title`,`is_recommend` FROM `t_need` WHERE `form` = 10 AND `is_del` = 0 AND `status` = 2 ORDER BY `is_recommend` DESC,`create_time` DESC LIMIT 5 [ RunTime:0.003387s ]
SELECT `id`,`title`,`is_recommend` FROM `t_need` WHERE `form` = 5 AND `is_del` = 0 AND `status` = 2 ORDER BY `is_recommend` DESC,`create_time` DESC LIMIT 5 [ RunTime:0.004131s ]
SELECT `id`,`title`,`is_recommend` FROM `t_need` WHERE `form` = 8 AND `is_del` = 0 AND `status` = 2 ORDER BY `is_recommend` DESC,`create_time` DESC LIMIT 5 [ RunTime:0.003415s ]