SHOW FULL COLUMNS FROM `t_agent` [ RunTime:0.001039s ]
SHOW FULL COLUMNS FROM `t_need` [ RunTime:0.000968s ]
SHOW FULL COLUMNS FROM `t_need_cate` [ RunTime:0.000669s ]
SELECT `n_id` FROM `t_need_cate` WHERE `cate_id` = 29 AND `type` = 1 [ RunTime:0.000316s ]
SELECT COUNT(*) AS think_count FROM `t_need` WHERE `status` = 2 AND `form` = 1 AND `is_del` = 0 AND `id` IN (SELECT `n_id` FROM `t_need_cate` WHERE `cate_id` = 29 AND `type` = 1) AND `expiry_time` > '2024-04-19 08:41:50' LIMIT 1 [ RunTime:0.023515s ]
SELECT `n_id` FROM `t_need_cate` WHERE `cate_id` = 29 AND `type` = 1 [ RunTime:0.000380s ]
SELECT id,title,stick,create_time,update_time,refresh_time,user_id,comment,hits,brand FROM `t_need` WHERE `status` = 2 AND `form` = 1 AND `is_del` = 0 AND `id` IN (SELECT `n_id` FROM `t_need_cate` WHERE `cate_id` = 29 AND `type` = 1) AND `expiry_time` > '2024-04-19 08:41:50' ORDER BY `sort` DESC LIMIT 0,20 [ RunTime:0.001746s ]
SHOW FULL COLUMNS FROM `t_need_ad` [ RunTime:0.000873s ]
SELECT * FROM `t_need_ad` WHERE `n_id` IN (46756,44133,47172,47237,47076,44663,46060,43909,47223,46524,45747,44675,44440,46725,45156,46828,47104,47180,44382,46906) ORDER BY `price` ASC [ RunTime:0.000829s ]
SHOW FULL COLUMNS FROM `t_users` [ RunTime:0.000905s ]
SELECT id,username,is_auth1,is_auth2,head_portrait,realname,brand,company,position,department,city,is_data FROM `t_users` WHERE `id` IN (2,15217,51990,35293,14327,1312,26325,38780,35833,13376,50392,37120,49444,50536,51686,50738,49925,49378) [ RunTime:0.000425s ]
SHOW FULL COLUMNS FROM `t_user_vip` [ RunTime:0.000644s ]
SELECT * FROM `t_user_vip` WHERE `end_time` > 1713487310 AND `user_id` IN (2,1312,13376,14327,15217,26325,35293,35833,37120,38780,49378,49444,49925,50392,50536,50738,51686,51990) [ RunTime:0.000565s ]
SELECT * FROM `t_need_cate` WHERE `type` = 1 AND `n_id` IN (46756,44133,47172,47237,47076,44663,46060,43909,47223,46524,45747,44675,44440,46725,45156,46828,47104,47180,44382,46906) [ RunTime:0.000728s ]
SHOW FULL COLUMNS FROM `t_cate` [ RunTime:0.000824s ]
SELECT * FROM `t_cate` WHERE `id` IN (29,104,21,19,18,1,4,30,2,3,26,14,110) [ RunTime:0.000264s ]
SELECT * FROM `t_need_cate` WHERE `type` = 2 AND `n_id` IN (46756,44133,47172,47237,47076,44663,46060,43909,47223,46524,45747,44675,44440,46725,45156,46828,47104,47180,44382,46906) [ RunTime:0.000659s ]
SELECT * FROM `t_cate` WHERE `id` IN (31,32,33,35,249) [ RunTime:0.000265s ]
SHOW FULL COLUMNS FROM `t_company` [ RunTime:0.000913s ]
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.010389s ]
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.007121s ]
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.005287s ]
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.004957s ]
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.004202s ]
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.003531s ]