SHOW FULL COLUMNS FROM `t_product` [ RunTime:0.000893s ]
SELECT * FROM `t_product` WHERE `id` = 653 LIMIT 1 [ RunTime:0.000316s ]
SHOW FULL COLUMNS FROM `t_agent` [ RunTime:0.001043s ]
SHOW FULL COLUMNS FROM `t_need` [ RunTime:0.000890s ]
SHOW FULL COLUMNS FROM `t_need_ad` [ RunTime:0.000673s ]
SELECT `n_id` FROM `t_need_ad` WHERE `product_id` = 653 [ RunTime:0.002069s ]
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` = 653) AND `expiry_time` > '2024-05-07 16:57:13' ORDER BY `sort` DESC [ RunTime:0.019335s ]
SELECT * FROM `t_need_ad` WHERE `n_id` IN (34904,45299,46346,45442,45731,36087,44938,37860,38433,37379,36957,37123,37442,34976,38104,38998,37591,36582,34372,35489,36994,34986,36130,37777,37365,37332,36501,36409,34821,34972,34666,34492,34375,33940,26145) ORDER BY `price` ASC [ RunTime:0.001087s ]
SHOW FULL COLUMNS FROM `t_users` [ RunTime:0.001047s ]
SELECT id,username,is_auth1,is_auth2,head_portrait,realname,brand,company,position,department,city,is_data FROM `t_users` WHERE `id` IN (7794,48772,51121,9046,38411,6603,36755,7624,6899,31695,6162,6120,7646,7766,7492,22363,7686,6673,7836,7565,6152,7762,6221,3191,31309,7520,6713,6495,7796,7772,7862,7885,7834,2900,17426) [ RunTime:0.000582s ]
SHOW FULL COLUMNS FROM `t_user_vip` [ RunTime:0.000735s ]
SELECT * FROM `t_user_vip` WHERE `end_time` > 1715072233 AND `user_id` IN (2900,3191,6120,6152,6162,6221,6495,6603,6673,6713,6899,7492,7520,7565,7624,7646,7686,7762,7766,7772,7794,7796,7834,7836,7862,7885,9046,17426,22363,31309,31695,36755,38411,48772,51121) [ RunTime:0.000553s ]
SHOW FULL COLUMNS FROM `t_need_cate` [ RunTime:0.000697s ]
SELECT * FROM `t_need_cate` WHERE `type` = 1 AND `n_id` IN (34904,45299,46346,45442,45731,36087,44938,37860,38433,37379,36957,37123,37442,34976,38104,38998,37591,36582,34372,35489,36994,34986,36130,37777,37365,37332,36501,36409,34821,34972,34666,34492,34375,33940,26145) [ RunTime:0.000720s ]
SHOW FULL COLUMNS FROM `t_cate` [ RunTime:0.000679s ]
SELECT * FROM `t_cate` WHERE `id` IN (30,1,29,103,18,4,110,19) [ RunTime:0.000214s ]
SELECT * FROM `t_need_cate` WHERE `type` = 2 AND `n_id` IN (34904,45299,46346,45442,45731,36087,44938,37860,38433,37379,36957,37123,37442,34976,38104,38998,37591,36582,34372,35489,36994,34986,36130,37777,37365,37332,36501,36409,34821,34972,34666,34492,34375,33940,26145) [ RunTime:0.000749s ]
SELECT * FROM `t_cate` WHERE `id` IN (31,35) [ RunTime:0.000251s ]