SHOW FULL COLUMNS FROM `t_product` [ RunTime:0.001115s ]
SELECT * FROM `t_product` WHERE `id` = 747 LIMIT 1 [ RunTime:0.000454s ]
SHOW FULL COLUMNS FROM `t_agent` [ RunTime:0.000918s ]
SHOW FULL COLUMNS FROM `t_need` [ RunTime:0.001010s ]
SHOW FULL COLUMNS FROM `t_need_ad` [ RunTime:0.001131s ]
SELECT `n_id` FROM `t_need_ad` WHERE `product_id` = 747 [ RunTime:0.000251s ]
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` = 747) AND `expiry_time` > '2024-04-19 22:38:00' ORDER BY `sort` DESC [ RunTime:0.020471s ]
SELECT * FROM `t_need_ad` WHERE `n_id` IN (36503,36044,36544,35188,37395,37633,36126,35262,36357,37060,36222,36133,35115) ORDER BY `price` ASC [ RunTime:0.000368s ]
SHOW FULL COLUMNS FROM `t_users` [ RunTime:0.001252s ]
SELECT id,username,is_auth1,is_auth2,head_portrait,realname,brand,company,position,department,city,is_data FROM `t_users` WHERE `id` IN (6715,6763,6693,7730,7601,843,6377,7715,9956,6083,6428,6227,7735) [ RunTime:0.000709s ]
SHOW FULL COLUMNS FROM `t_user_vip` [ RunTime:0.000826s ]
SELECT * FROM `t_user_vip` WHERE `end_time` > 1713537480 AND `user_id` IN (843,6083,6227,6377,6428,6693,6715,6763,7601,7715,7730,7735,9956) [ RunTime:0.000561s ]
SHOW FULL COLUMNS FROM `t_need_cate` [ RunTime:0.000747s ]
SELECT * FROM `t_need_cate` WHERE `type` = 1 AND `n_id` IN (36503,36044,36544,35188,37395,37633,36126,35262,36357,37060,36222,36133,35115) [ RunTime:0.000268s ]
SHOW FULL COLUMNS FROM `t_cate` [ RunTime:0.000858s ]
SELECT * FROM `t_cate` WHERE `id` IN (3,26) [ RunTime:0.000211s ]
SELECT * FROM `t_need_cate` WHERE `type` = 2 AND `n_id` IN (36503,36044,36544,35188,37395,37633,36126,35262,36357,37060,36222,36133,35115) [ RunTime:0.000247s ]
SELECT * FROM `t_cate` WHERE `id` = 31 [ RunTime:0.000229s ]