SHOW FULL COLUMNS FROM `t_agent` [ RunTime:0.001009s ]
SHOW FULL COLUMNS FROM `t_need` [ RunTime:0.001073s ]
SHOW FULL COLUMNS FROM `t_need_cate` [ RunTime:0.000781s ]
SELECT `n_id` FROM `t_need_cate` WHERE `cate_id` = 19 AND `type` = 1 [ RunTime:0.000501s ]
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` = 19 AND `type` = 1) AND `expiry_time` > '2024-05-13 05:46:54' LIMIT 1 [ RunTime:0.024767s ]
SELECT `n_id` FROM `t_need_cate` WHERE `cate_id` = 19 AND `type` = 1 [ RunTime:0.000532s ]
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` = 19 AND `type` = 1) AND `expiry_time` > '2024-05-13 05:46:54' ORDER BY `sort` DESC LIMIT 0,20 [ RunTime:0.002241s ]
SHOW FULL COLUMNS FROM `t_need_ad` [ RunTime:0.002739s ]
SELECT * FROM `t_need_ad` WHERE `n_id` IN (47181,43781,44310,41410,46725,44133,44349,46012,45866,47463,47208,46587,43998,44054,43965,47383,45840,47461,43997,44610) ORDER BY `price` ASC [ RunTime:0.000292s ]
SHOW FULL COLUMNS FROM `t_users` [ RunTime:0.001507s ]
SELECT id,username,is_auth1,is_auth2,head_portrait,realname,brand,company,position,department,city,is_data FROM `t_users` WHERE `id` IN (52167,22598,38745,36082,50536,15217,35600,36906,50671,52423,52211,8127,36905,48993,37050,52372,50644,52435,10402,1314) [ RunTime:0.001359s ]
SHOW FULL COLUMNS FROM `t_user_vip` [ RunTime:0.001757s ]
SELECT * FROM `t_user_vip` WHERE `end_time` > 1715550414 AND `user_id` IN (1314,8127,10402,15217,22598,35600,36082,36905,36906,37050,38745,48993,50536,50644,50671,52167,52211,52372,52423,52435) [ RunTime:0.001054s ]
SELECT * FROM `t_need_cate` WHERE `type` = 1 AND `n_id` IN (47181,43781,44310,41410,46725,44133,44349,46012,45866,47463,47208,46587,43998,44054,43965,47383,45840,47461,43997,44610) [ RunTime:0.001104s ]
SHOW FULL COLUMNS FROM `t_cate` [ RunTime:0.001209s ]
SELECT * FROM `t_cate` WHERE `id` IN (1,21,19,110,4,18,30,29,28,26,25,3) [ RunTime:0.001086s ]
SELECT * FROM `t_need_cate` WHERE `type` = 2 AND `n_id` IN (47181,43781,44310,41410,46725,44133,44349,46012,45866,47463,47208,46587,43998,44054,43965,47383,45840,47461,43997,44610) [ RunTime:0.000883s ]
SELECT * FROM `t_cate` WHERE `id` IN (249,32,31,35,33) [ RunTime:0.000621s ]
SHOW FULL COLUMNS FROM `t_company` [ RunTime:0.001095s ]
SELECT `id`,`name`,`brand`,`logo` FROM `t_company` WHERE `status` = 2 ORDER BY `is_recommend` DESC,`sort_time` DESC LIMIT 4 [ RunTime:0.000282s ]
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.000258s ]
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.000244s ]
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.000240s ]
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.000261s ]
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.000250s ]
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.000256s ]