SHOW FULL COLUMNS FROM `t_product` [ RunTime:0.001017s ]
SELECT * FROM `t_product` WHERE `id` = 300 LIMIT 1 [ RunTime:0.000492s ]
SHOW FULL COLUMNS FROM `t_agent` [ RunTime:0.000913s ]
SHOW FULL COLUMNS FROM `t_need` [ RunTime:0.000956s ]
SHOW FULL COLUMNS FROM `t_need_ad` [ RunTime:0.000792s ]
SELECT `n_id` FROM `t_need_ad` WHERE `product_id` = 300 [ RunTime:0.002572s ]
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` = 300) AND `expiry_time` > '2024-05-08 22:03:35' ORDER BY `sort` DESC [ RunTime:0.020122s ]
SELECT * FROM `t_need_ad` WHERE `n_id` IN (32540,36909,46923,46508,44519,44297,46719,46388,46332,34190,43566,43613,44090,43912,43933,35313,36117,20871,37374,37653,29853,34256,34480,34500,34642,34772,35565,34844,12720,34669,35514,33943,35836,38047,37855,37868,37718,37593,37553,35366,35245,35116,34754,34624,34499,34317,34088,32194,32198,28524,28479,28320,27764,27368,26865,23012,19470,21110,20991,20231,14604,13660) ORDER BY `price` ASC [ RunTime:0.001683s ]
SHOW FULL COLUMNS FROM `t_users` [ RunTime:0.001165s ]
SELECT id,username,is_auth1,is_auth2,head_portrait,realname,brand,company,position,department,city,is_data FROM `t_users` WHERE `id` IN (21446,6189,36785,51007,49373,49291,50989,51121,34037,7963,4137,31033,48802,19346,38149,7702,6381,13918,31450,7636,10201,7933,7895,7910,7867,7800,7885,7792,9861,7858,7556,2898,6831,7508,7618,7788,7678,7688,836,7599,7843,7736,7813,7904,7909,7922,2841,22129,21263,11810,19470,17896,15285,13352,13282,10309,8280) [ RunTime:0.001437s ]
SHOW FULL COLUMNS FROM `t_user_vip` [ RunTime:0.000869s ]
SELECT * FROM `t_user_vip` WHERE `end_time` > 1715177015 AND `user_id` IN (836,2841,2898,4137,6189,6381,6831,7508,7556,7599,7618,7636,7678,7688,7702,7736,7788,7792,7800,7813,7843,7858,7867,7885,7895,7904,7909,7910,7922,7933,7963,8280,9861,10201,10309,11810,13282,13352,13918,15285,17896,19346,19470,21263,21446,22129,31033,31450,34037,36785,38149,48802,49291,49373,50989,51007,51121) [ RunTime:0.003502s ]
SHOW FULL COLUMNS FROM `t_need_cate` [ RunTime:0.000862s ]
SELECT * FROM `t_need_cate` WHERE `type` = 1 AND `n_id` IN (32540,36909,46923,46508,44519,44297,46719,46388,46332,34190,43566,43613,44090,43912,43933,35313,36117,20871,37374,37653,29853,34256,34480,34500,34642,34772,35565,34844,12720,34669,35514,33943,35836,38047,37855,37868,37718,37593,37553,35366,35245,35116,34754,34624,34499,34317,34088,32194,32198,28524,28479,28320,27764,27368,26865,23012,19470,21110,20991,20231,14604,13660) [ RunTime:0.001083s ]
SHOW FULL COLUMNS FROM `t_cate` [ RunTime:0.000807s ]
SELECT * FROM `t_cate` WHERE `id` IN (15,1,21,19,18,103,110,29,4,14) [ RunTime:0.000271s ]
SELECT * FROM `t_need_cate` WHERE `type` = 2 AND `n_id` IN (32540,36909,46923,46508,44519,44297,46719,46388,46332,34190,43566,43613,44090,43912,43933,35313,36117,20871,37374,37653,29853,34256,34480,34500,34642,34772,35565,34844,12720,34669,35514,33943,35836,38047,37855,37868,37718,37593,37553,35366,35245,35116,34754,34624,34499,34317,34088,32194,32198,28524,28479,28320,27764,27368,26865,23012,19470,21110,20991,20231,14604,13660) [ RunTime:0.001195s ]
SELECT * FROM `t_cate` WHERE `id` IN (34,31,35,249) [ RunTime:0.000229s ]