SHOW FULL COLUMNS FROM `t_cate` [ RunTime:0.000859s ]
SELECT `id`,`name` FROM `t_cate` WHERE `type_id` = 2 AND `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000259s ]
SHOW FULL COLUMNS FROM `t_agent` [ RunTime:0.000763s ]
SHOW FULL COLUMNS FROM `t_need` [ RunTime:0.000824s ]
SHOW FULL COLUMNS FROM `t_need_cate` [ RunTime:0.000594s ]
SELECT `n_id` FROM `t_need_cate` WHERE `cate_id` = 2 AND `type` = 1 [ RunTime:0.000581s ]
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` = 2 AND `type` = 1) AND `expiry_time` > '2024-04-20 19:06:00' LIMIT 1 [ RunTime:0.023910s ]
SELECT `n_id` FROM `t_need_cate` WHERE `cate_id` = 2 AND `type` = 1 [ RunTime:0.000325s ]
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` = 2 AND `type` = 1) AND `expiry_time` > '2024-04-20 19:06:00' ORDER BY `sort` DESC LIMIT 0,20 [ RunTime:0.006104s ]
SHOW FULL COLUMNS FROM `t_need_ad` [ RunTime:0.000852s ]
SELECT * FROM `t_need_ad` WHERE `n_id` IN (46775,44323,46524,47172,42529,46859,46970,45546,44643,35345,46768,25957,46190,46729,37072,34680,36803,46562,41082,35732) ORDER BY `price` ASC [ RunTime:0.000268s ]
SHOW FULL COLUMNS FROM `t_users` [ RunTime:0.000930s ]
SELECT id,username,is_auth1,is_auth2,head_portrait,realname,brand,company,position,department,city,is_data FROM `t_users` WHERE `id` IN (51649,49241,13376,51990,29604,50680,51927,30970,49624,27206,15931,35667,6067,7962,6561,11822,29836) [ RunTime:0.000514s ]
SHOW FULL COLUMNS FROM `t_user_vip` [ RunTime:0.000706s ]
SELECT * FROM `t_user_vip` WHERE `end_time` > 1713611160 AND `user_id` IN (6067,6561,7962,11822,13376,15931,27206,29604,29836,30970,35667,49241,49624,50680,51649,51927,51990) [ RunTime:0.000861s ]
SHOW FULL COLUMNS FROM `t_vip` [ RunTime:0.001837s ]
SELECT * FROM `t_vip` WHERE `id` = 1 [ RunTime:0.000232s ]
SELECT * FROM `t_need_cate` WHERE `type` = 1 AND `n_id` IN (46775,44323,46524,47172,42529,46859,46970,45546,44643,35345,46768,25957,46190,46729,37072,34680,36803,46562,41082,35732) [ RunTime:0.000686s ]
SELECT * FROM `t_cate` WHERE `id` IN (2,18,19,29,21,30,4,110,103,1) [ RunTime:0.000230s ]
SELECT * FROM `t_need_cate` WHERE `type` = 2 AND `n_id` IN (46775,44323,46524,47172,42529,46859,46970,45546,44643,35345,46768,25957,46190,46729,37072,34680,36803,46562,41082,35732) [ RunTime:0.000568s ]
SELECT * FROM `t_cate` WHERE `id` IN (32,31,35,246,249,245) [ RunTime:0.000201s ]
SHOW FULL COLUMNS FROM `t_company` [ RunTime:0.000994s ]
SELECT `id`,`name`,`brand`,`logo` FROM `t_company` WHERE `status` = 2 ORDER BY `is_recommend` DESC,`sort_time` DESC LIMIT 4 [ RunTime:0.000244s ]
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.000219s ]
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.000286s ]
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.000248s ]
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.000234s ]
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.000216s ]
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.000215s ]