SHOW FULL COLUMNS FROM `t_product_cate` [ RunTime:0.000871s ]
SELECT * FROM `t_product_cate` WHERE `type` = 1 AND `route` = 'xwapp' LIMIT 1 [ RunTime:0.000235s ]
SHOW FULL COLUMNS FROM `t_product` [ RunTime:0.000770s ]
SELECT * FROM `t_product` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000289s ]
SHOW FULL COLUMNS FROM `t_agent` [ RunTime:0.000706s ]
SHOW FULL COLUMNS FROM `t_need` [ RunTime:0.000803s ]
SHOW FULL COLUMNS FROM `t_need_ad` [ RunTime:0.000666s ]
SELECT `n_id` FROM `t_need_ad` WHERE `product_id` = 13 [ RunTime:0.002339s ]
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` = 13) AND `expiry_time` > '2024-05-14 17:57:51' ORDER BY `sort` DESC [ RunTime:0.019579s ]
SELECT * FROM `t_need_ad` WHERE `n_id` IN (47504,47301,47278,10710,11212,37532,33967,38319,35180,37854,34853) ORDER BY `price` ASC [ RunTime:0.000780s ]
SHOW FULL COLUMNS FROM `t_users` [ RunTime:0.001763s ]
SELECT id,username,is_auth1,is_auth2,head_portrait,realname,brand,company,position,department,city,is_data FROM `t_users` WHERE `id` IN (51990,49587,37498,7569,7389,468,2879,7460,7774,7617,7754) [ RunTime:0.000686s ]
SHOW FULL COLUMNS FROM `t_user_vip` [ RunTime:0.000684s ]
SELECT * FROM `t_user_vip` WHERE `end_time` > 1715680671 AND `user_id` IN (468,2879,7389,7460,7569,7617,7754,7774,37498,49587,51990) [ RunTime:0.000473s ]
SHOW FULL COLUMNS FROM `t_need_cate` [ RunTime:0.000679s ]
SELECT * FROM `t_need_cate` WHERE `type` = 1 AND `n_id` IN (47504,47301,47278,10710,11212,37532,33967,38319,35180,37854,34853) [ RunTime:0.000534s ]
SHOW FULL COLUMNS FROM `t_cate` [ RunTime:0.000702s ]
SELECT * FROM `t_cate` WHERE `id` IN (1,103,30,110) [ RunTime:0.000339s ]
SELECT * FROM `t_need_cate` WHERE `type` = 2 AND `n_id` IN (47504,47301,47278,10710,11212,37532,33967,38319,35180,37854,34853) [ RunTime:0.000409s ]
SELECT * FROM `t_cate` WHERE `id` IN (31,248,249) [ RunTime:0.000191s ]