SHOW FULL COLUMNS FROM `t_product` [ RunTime:0.000955s ]
SELECT * FROM `t_product` WHERE `id` = 216 LIMIT 1 [ RunTime:0.000327s ]
SHOW FULL COLUMNS FROM `t_agent` [ RunTime:0.000781s ]
SHOW FULL COLUMNS FROM `t_need` [ RunTime:0.000875s ]
SHOW FULL COLUMNS FROM `t_need_ad` [ RunTime:0.000700s ]
SELECT `n_id` FROM `t_need_ad` WHERE `product_id` = 216 [ RunTime:0.002072s ]
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_ad` WHERE `product_id` = 216) AND `expiry_time` > '2024-05-14 12:09:13' ORDER BY `sort` DESC [ RunTime:0.019760s ]
SELECT * FROM `t_need_ad` WHERE `n_id` IN (45206,43909,46721,46704,44440,46780,45479,46997,46126,46411,43408,45510,45536,42677,43929,43992,34822,34021,34856,37681,38583,38019) ORDER BY `price` ASC [ RunTime:0.000951s ]
SHOW FULL COLUMNS FROM `t_users` [ RunTime:0.001064s ]
SELECT id,username,is_auth1,is_auth2,head_portrait,realname,brand,company,position,department,city,is_data FROM `t_users` WHERE `id` IN (49374,38780,38649,51622,49444,38053,50287,51121,16345,37382,38745,38549,7799,7977,7757,7674,3202,7534) [ RunTime:0.000458s ]
SHOW FULL COLUMNS FROM `t_user_vip` [ RunTime:0.000811s ]
SELECT * FROM `t_user_vip` WHERE `end_time` > 1715659753 AND `user_id` IN (3202,7534,7674,7757,7799,7977,16345,37382,38053,38549,38649,38745,38780,49374,49444,50287,51121,51622) [ RunTime:0.000555s ]
SHOW FULL COLUMNS FROM `t_vip` [ RunTime:0.000905s ]
SELECT * FROM `t_vip` WHERE `id` = 3 [ RunTime:0.000252s ]
SHOW FULL COLUMNS FROM `t_need_cate` [ RunTime:0.000708s ]
SELECT * FROM `t_need_cate` WHERE `type` = 1 AND `n_id` IN (45206,43909,46721,46704,44440,46780,45479,46997,46126,46411,43408,45510,45536,42677,43929,43992,34822,34021,34856,37681,38583,38019) [ RunTime:0.000605s ]
SHOW FULL COLUMNS FROM `t_cate` [ RunTime:0.000804s ]
SELECT * FROM `t_cate` WHERE `id` IN (104,30,21,18,29,19,1,110) [ RunTime:0.000225s ]
SELECT * FROM `t_need_cate` WHERE `type` = 2 AND `n_id` IN (45206,43909,46721,46704,44440,46780,45479,46997,46126,46411,43408,45510,45536,42677,43929,43992,34822,34021,34856,37681,38583,38019) [ RunTime:0.000661s ]
SELECT * FROM `t_cate` WHERE `id` IN (31,248,35,32,249,33) [ RunTime:0.000224s ]