SHOW FULL COLUMNS FROM `t_product` [ RunTime:0.001152s ]
SELECT * FROM `t_product` WHERE `id` = 482 LIMIT 1 [ RunTime:0.000520s ]
SHOW FULL COLUMNS FROM `t_agent` [ RunTime:0.000942s ]
SHOW FULL COLUMNS FROM `t_need` [ RunTime:0.000976s ]
SHOW FULL COLUMNS FROM `t_need_ad` [ RunTime:0.000815s ]
SELECT `n_id` FROM `t_need_ad` WHERE `product_id` = 482 [ RunTime:0.002227s ]
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` = 482) AND `expiry_time` > '2024-04-27 09:13:05' ORDER BY `sort` DESC [ RunTime:0.019693s ]
SELECT * FROM `t_need_ad` WHERE `n_id` IN (47231,39547,46085,46108,45855,45902,43976,37972,43922,43445,38328,35800,38368,37463,26866,37520,37645,37443,37977,37778,35526,38075,33913,34137,34682,34920,35456,37013,36858,37334,36903,37919,37636,37273,16831,37917,38450,38049,38621,38558,37924,36966,37204,37557,38136,38074,37915,37611,37073,37862,37861,37865,37592,37556,37441,37393,35736,37335,37373,28265,36933,36791,36612,36529,36308,36131,36067,35989,35593,35576,34694,34474,34341,33859,14199,13050,24669,10793) ORDER BY `price` ASC [ RunTime:0.001768s ]
SHOW FULL COLUMNS FROM `t_users` [ RunTime:0.001204s ]
SELECT id,username,is_auth1,is_auth2,head_portrait,realname,brand,company,position,department,city,is_data FROM `t_users` WHERE `id` IN (50680,28508,14215,18707,34086,48809,7576,17456,38149,7452,6841,7431,31309,17896,31771,469,7647,7580,3192,7551,7498,7839,2511,7939,7789,7568,6135,6554,7523,6524,7567,850,6384,7341,7565,6892,7510,29865,3221,6779,6161,6016,464,7475,7496,6768,7784,6074,7629,7625,7632,7687,767,7644,7598,6872,7524,7559,15011,6179,6589,6658,6695,6315,6222,6727,6787,7530,7545,7848,7898,7915,7805,9890,6774,16153,8953) [ RunTime:0.001013s ]
SHOW FULL COLUMNS FROM `t_user_vip` [ RunTime:0.000807s ]
SELECT * FROM `t_user_vip` WHERE `end_time` > 1714180385 AND `user_id` IN (464,469,767,850,2511,3192,3221,6016,6074,6135,6161,6179,6222,6315,6384,6524,6554,6589,6658,6695,6727,6768,6774,6779,6787,6841,6872,6892,7341,7431,7452,7475,7496,7498,7510,7523,7524,7530,7545,7551,7559,7565,7567,7568,7576,7580,7598,7625,7629,7632,7644,7647,7687,7784,7789,7805,7839,7848,7898,7915,7939,8953,9890,14215,15011,16153,17456,17896,18707,28508,29865,31309,31771,34086,38149,48809,50680) [ RunTime:0.000971s ]
SHOW FULL COLUMNS FROM `t_need_cate` [ RunTime:0.000853s ]
SELECT * FROM `t_need_cate` WHERE `type` = 1 AND `n_id` IN (47231,39547,46085,46108,45855,45902,43976,37972,43922,43445,38328,35800,38368,37463,26866,37520,37645,37443,37977,37778,35526,38075,33913,34137,34682,34920,35456,37013,36858,37334,36903,37919,37636,37273,16831,37917,38450,38049,38621,38558,37924,36966,37204,37557,38136,38074,37915,37611,37073,37862,37861,37865,37592,37556,37441,37393,35736,37335,37373,28265,36933,36791,36612,36529,36308,36131,36067,35989,35593,35576,34694,34474,34341,33859,14199,13050,24669,10793) [ RunTime:0.001216s ]
SHOW FULL COLUMNS FROM `t_cate` [ RunTime:0.000813s ]
SELECT * FROM `t_cate` WHERE `id` IN (19,1,3,4,18,21,30,110,14,103,26,28,29) [ RunTime:0.000963s ]
SELECT * FROM `t_need_cate` WHERE `type` = 2 AND `n_id` IN (47231,39547,46085,46108,45855,45902,43976,37972,43922,43445,38328,35800,38368,37463,26866,37520,37645,37443,37977,37778,35526,38075,33913,34137,34682,34920,35456,37013,36858,37334,36903,37919,37636,37273,16831,37917,38450,38049,38621,38558,37924,36966,37204,37557,38136,38074,37915,37611,37073,37862,37861,37865,37592,37556,37441,37393,35736,37335,37373,28265,36933,36791,36612,36529,36308,36131,36067,35989,35593,35576,34694,34474,34341,33859,14199,13050,24669,10793) [ RunTime:0.001300s ]
SELECT * FROM `t_cate` WHERE `id` IN (35,31,249) [ RunTime:0.000262s ]