SHOW FULL COLUMNS FROM `t_product_cate` [ RunTime:0.000819s ]
SELECT * FROM `t_product_cate` WHERE `type` = 1 AND `route` = 'shopapp' LIMIT 1 [ RunTime:0.000244s ]
SHOW FULL COLUMNS FROM `t_product` [ RunTime:0.000820s ]
SELECT * FROM `t_product` WHERE `id` = 459 LIMIT 1 [ RunTime:0.000365s ]
SHOW FULL COLUMNS FROM `t_agent` [ RunTime:0.000732s ]
SHOW FULL COLUMNS FROM `t_need` [ RunTime:0.000885s ]
SHOW FULL COLUMNS FROM `t_need_ad` [ RunTime:0.000714s ]
SELECT `n_id` FROM `t_need_ad` WHERE `product_id` = 459 [ RunTime:0.002138s ]
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` = 459) AND `expiry_time` > '2024-05-14 07:02:40' ORDER BY `sort` DESC [ RunTime:0.029138s ]
SELECT * FROM `t_need_ad` WHERE `n_id` IN (20134,29139,20469,28463,36902,28055,35998,30210,38523,33971,36805,35737,36261,36132,35700,35202,29066,28581,28386,28191,27935,13442,27730,27709,27642,27428,26347,26794,26670,26077,25945,25843,25759,25681,25668,25610,25487,25407,25341,25171,23489,23016,19552,22213,21237,21048,19537,19487,19468,14868,14754) ORDER BY `price` ASC [ RunTime:0.001340s ]
SHOW FULL COLUMNS FROM `t_users` [ RunTime:0.001151s ]
SELECT id,username,is_auth1,is_auth2,head_portrait,realname,brand,company,position,department,city,is_data FROM `t_users` WHERE `id` IN (13877,10201,13352,11810,6524,6775,6453,2876,6563,6880,6342,6225,7315,7725,14893,10265,8280,17056,15501,15285,14786,14307,13282,4325) [ RunTime:0.000529s ]
SHOW FULL COLUMNS FROM `t_user_vip` [ RunTime:0.000793s ]
SELECT * FROM `t_user_vip` WHERE `end_time` > 1715641360 AND `user_id` IN (2876,4325,6225,6342,6453,6524,6563,6775,6880,7315,7725,8280,10201,10265,11810,13282,13352,13877,14307,14786,14893,15285,15501,17056) [ RunTime:0.000638s ]
SHOW FULL COLUMNS FROM `t_need_cate` [ RunTime:0.000697s ]
SELECT * FROM `t_need_cate` WHERE `type` = 1 AND `n_id` IN (20134,29139,20469,28463,36902,28055,35998,30210,38523,33971,36805,35737,36261,36132,35700,35202,29066,28581,28386,28191,27935,13442,27730,27709,27642,27428,26347,26794,26670,26077,25945,25843,25759,25681,25668,25610,25487,25407,25341,25171,23489,23016,19552,22213,21237,21048,19537,19487,19468,14868,14754) [ RunTime:0.000873s ]
SHOW FULL COLUMNS FROM `t_cate` [ RunTime:0.000797s ]
SELECT * FROM `t_cate` WHERE `id` IN (1,30,21) [ RunTime:0.000215s ]
SELECT * FROM `t_need_cate` WHERE `type` = 2 AND `n_id` IN (20134,29139,20469,28463,36902,28055,35998,30210,38523,33971,36805,35737,36261,36132,35700,35202,29066,28581,28386,28191,27935,13442,27730,27709,27642,27428,26347,26794,26670,26077,25945,25843,25759,25681,25668,25610,25487,25407,25341,25171,23489,23016,19552,22213,21237,21048,19537,19487,19468,14868,14754) [ RunTime:0.000823s ]
SELECT * FROM `t_cate` WHERE `id` IN (35,31) [ RunTime:0.000205s ]