SHOW FULL COLUMNS FROM `t_agent` [ RunTime:0.001046s ]
SHOW FULL COLUMNS FROM `t_ad_type` [ RunTime:0.000930s ]
SELECT * FROM `t_ad_type` WHERE `n_id` = 5 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000291s ]
SHOW FULL COLUMNS FROM `t_ad` [ RunTime:0.000854s ]
SELECT * FROM `t_ad` WHERE `start_time` <= '2024-04-19 17:26:26' AND `end_time` >= '2024-04-19 17:26:26' AND `host` = 'ukezhitui.com' AND `status` = 2 AND `t_id` IN (21,20) ORDER BY `id` DESC [ RunTime:0.000798s ]
SHOW FULL COLUMNS FROM `t_users` [ RunTime:0.001059s ]
SELECT * FROM `t_users` WHERE `id` = 2 [ RunTime:0.000338s ]
SHOW FULL COLUMNS FROM `t_need` [ RunTime:0.001065s ]
SHOW FULL COLUMNS FROM `t_need_cate` [ RunTime:0.000766s ]
SELECT `n_id` FROM `t_need_cate` WHERE `cate_id` = 21 AND `type` = 1 [ RunTime:0.002940s ]
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` = 21 AND `type` = 1) AND `expiry_time` > '2024-04-19 17:26:26' LIMIT 1 [ RunTime:0.025316s ]
SELECT `n_id` FROM `t_need_cate` WHERE `cate_id` = 21 AND `type` = 1 [ RunTime:0.000511s ]
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` = 21 AND `type` = 1) AND `expiry_time` > '2024-04-19 17:26:26' ORDER BY `sort` DESC LIMIT 0,20 [ RunTime:0.002027s ]
SHOW FULL COLUMNS FROM `t_need_ad` [ RunTime:0.001033s ]
SELECT * FROM `t_need_ad` WHERE `n_id` IN (47176,47240,46012,42529,41410,46704,43909,45360,46626,46466,43339,47208,46875,46503,45206,47104,37825,45840,46085,47040) ORDER BY `price` ASC [ RunTime:0.000917s ]
SELECT id,username,is_auth1,is_auth2,head_portrait,realname,brand,company,position,department,city,is_data FROM `t_users` WHERE `id` IN (51935,51938,36906,29604,36082,51622,38780,36306,49138,38034,52211,51838,27811,49374,50738,29026,50644,14215,52007) [ RunTime:0.000523s ]
SHOW FULL COLUMNS FROM `t_user_vip` [ RunTime:0.000905s ]
SELECT * FROM `t_user_vip` WHERE `end_time` > 1713518786 AND `user_id` IN (14215,27811,29026,29604,36082,36306,36906,38034,38780,49138,49374,50644,50738,51622,51838,51935,51938,52007,52211) [ RunTime:0.001695s ]
SHOW FULL COLUMNS FROM `t_vip` [ RunTime:0.001004s ]
SELECT * FROM `t_vip` WHERE `id` = 1 [ RunTime:0.000274s ]
SELECT * FROM `t_need_cate` WHERE `type` = 1 AND `n_id` IN (47176,47240,46012,42529,41410,46704,43909,45360,46626,46466,43339,47208,46875,46503,45206,47104,37825,45840,46085,47040) [ RunTime:0.000772s ]
SHOW FULL COLUMNS FROM `t_cate` [ RunTime:0.000830s ]
SELECT * FROM `t_cate` WHERE `id` IN (21,1,19,110,4,2,29,104,18,3,30,28) [ RunTime:0.000276s ]
SELECT * FROM `t_need_cate` WHERE `type` = 2 AND `n_id` IN (47176,47240,46012,42529,41410,46704,43909,45360,46626,46466,43339,47208,46875,46503,45206,47104,37825,45840,46085,47040) [ RunTime:0.001041s ]
SELECT * FROM `t_cate` WHERE `id` IN (32,249,31,35,248,247) [ RunTime:0.000293s ]
SHOW FULL COLUMNS FROM `t_company` [ RunTime:0.000753s ]
SELECT `id`,`name`,`brand`,`logo` FROM `t_company` WHERE `status` = 2 ORDER BY `is_recommend` DESC,`sort_time` DESC LIMIT 4 [ RunTime:0.000228s ]
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.007099s ]
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.004742s ]
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.003065s ]
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.001937s ]
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.002273s ]
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.001956s ]