SHOW FULL COLUMNS FROM `t_product` [ RunTime:0.001528s ]
SELECT * FROM `t_product` WHERE `id` = 91 LIMIT 1 [ RunTime:0.000378s ]
SHOW FULL COLUMNS FROM `t_agent` [ RunTime:0.000930s ]
SHOW FULL COLUMNS FROM `t_need` [ RunTime:0.001077s ]
SHOW FULL COLUMNS FROM `t_need_ad` [ RunTime:0.000806s ]
SELECT `n_id` FROM `t_need_ad` WHERE `product_id` = 91 [ RunTime:0.000263s ]
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` = 91) AND `expiry_time` > '2024-05-13 06:35:01' ORDER BY `sort` DESC [ RunTime:0.020732s ]
SELECT * FROM `t_need_ad` WHERE `n_id` IN (44905,47384,44793,47162,46540,46215,46253,46393,34000,47081,47308,47265,44973,45361,46612,34475,45043,45275,47194,40199,45021,46703,45924,43928,45460,44419,29798,45230,45605,36237,43876,44540,37279,46639,44298,44537,30062,46401,37637,46445,46335,45933,45909,45086,45035,45928,46104,45877,45008,45771,45786,45763,44443,45717,45673,45681,23798,45609,45559,45525,45517,45506,44497,45334,45310,44534,45059,45291,45228,18900,21888,45135,45016,44881,44883,11591,44598,44574,43734,35945,14049,43437,36772,24947,34684,36953,34117,37973,42789,42794,32835,22124,41456,34829,35036,41116,35784,35717,22025,22317,23382,29086,34177,35181,30873,35252,38006,34196,34095,36654,35453,37523,36790,37589,37787,37635,36604,34639,34001,28630,22356,25163,24435,23958,23892,23564,23452,22242,22335,22017,21758,21338,21118,21001,20722,20589,20724,20889,20683,19972,11587,12884) ORDER BY `price` ASC [ RunTime:0.000769s ]
SHOW FULL COLUMNS FROM `t_users` [ RunTime:0.001243s ]
SELECT id,username,is_auth1,is_auth2,head_portrait,realname,brand,company,position,department,city,is_data FROM `t_users` WHERE `id` IN (48890,51735,49385,49646,51293,50725,51054,51121,7984,37498,14789,38505,48788,21289,51432,7899,49154,49752,51112,32095,33692,51616,50464,11591,38149,10201,50075,6347,38648,49514,6389,48883,49291,49517,21119,860,51247,50989,49126,49594,29675,50726,35404,49923,38411,49446,9034,14070,49720,36082,49310,8869,49516,49690,11023,12833,48778,49826,49837,4325,49578,49543,37882,14745,3208,38252,6616,14607,7855,6172,2626,7577,11822,37478,14167,10615,7976,7749,6866,6899,7966,7880,14736,7807,7561,7959,2839,19651,7567,749,6587,7684,3179,846,6665,7868,28078,17728,15800,12905,10204,3700,14069,12883,6882) [ RunTime:0.000500s ]
SHOW FULL COLUMNS FROM `t_user_vip` [ RunTime:0.000815s ]
SELECT * FROM `t_user_vip` WHERE `end_time` > 1715553301 AND `user_id` IN (749,846,860,2626,2839,3179,3208,3700,4325,6172,6347,6389,6587,6616,6665,6866,6882,6899,7561,7567,7577,7684,7749,7807,7855,7868,7880,7899,7959,7966,7976,7984,8869,9034,10201,10204,10615,11023,11591,11822,12833,12883,12905,14069,14070,14167,14607,14736,14745,14789,15800,17728,19651,21119,21289,28078,29675,32095,33692,35404,36082,37478,37498,37882,38149,38252,38411,38505,38648,48778,48788,48883,48890,49126,49154,49291,49310,49385,49446,49514,49516,49517,49543,49578,49594,49646,49690,49720,49752,49826,49837,49923,50075,50464,50725,50726,50989,51054,51112,51121,51247,51293,51432,51616,51735) [ RunTime:0.001021s ]
SHOW FULL COLUMNS FROM `t_need_cate` [ RunTime:0.000875s ]
SELECT * FROM `t_need_cate` WHERE `type` = 1 AND `n_id` IN (44905,47384,44793,47162,46540,46215,46253,46393,34000,47081,47308,47265,44973,45361,46612,34475,45043,45275,47194,40199,45021,46703,45924,43928,45460,44419,29798,45230,45605,36237,43876,44540,37279,46639,44298,44537,30062,46401,37637,46445,46335,45933,45909,45086,45035,45928,46104,45877,45008,45771,45786,45763,44443,45717,45673,45681,23798,45609,45559,45525,45517,45506,44497,45334,45310,44534,45059,45291,45228,18900,21888,45135,45016,44881,44883,11591,44598,44574,43734,35945,14049,43437,36772,24947,34684,36953,34117,37973,42789,42794,32835,22124,41456,34829,35036,41116,35784,35717,22025,22317,23382,29086,34177,35181,30873,35252,38006,34196,34095,36654,35453,37523,36790,37589,37787,37635,36604,34639,34001,28630,22356,25163,24435,23958,23892,23564,23452,22242,22335,22017,21758,21338,21118,21001,20722,20589,20724,20889,20683,19972,11587,12884) [ RunTime:0.000628s ]
SHOW FULL COLUMNS FROM `t_cate` [ RunTime:0.000863s ]
SELECT * FROM `t_cate` WHERE `id` IN (1,30,4,27,18,103,29,21,110,25,19,2,28) [ RunTime:0.000242s ]
SELECT * FROM `t_need_cate` WHERE `type` = 2 AND `n_id` IN (44905,47384,44793,47162,46540,46215,46253,46393,34000,47081,47308,47265,44973,45361,46612,34475,45043,45275,47194,40199,45021,46703,45924,43928,45460,44419,29798,45230,45605,36237,43876,44540,37279,46639,44298,44537,30062,46401,37637,46445,46335,45933,45909,45086,45035,45928,46104,45877,45008,45771,45786,45763,44443,45717,45673,45681,23798,45609,45559,45525,45517,45506,44497,45334,45310,44534,45059,45291,45228,18900,21888,45135,45016,44881,44883,11591,44598,44574,43734,35945,14049,43437,36772,24947,34684,36953,34117,37973,42789,42794,32835,22124,41456,34829,35036,41116,35784,35717,22025,22317,23382,29086,34177,35181,30873,35252,38006,34196,34095,36654,35453,37523,36790,37589,37787,37635,36604,34639,34001,28630,22356,25163,24435,23958,23892,23564,23452,22242,22335,22017,21758,21338,21118,21001,20722,20589,20724,20889,20683,19972,11587,12884) [ RunTime:0.000686s ]
SELECT * FROM `t_cate` WHERE `id` IN (31,35,34,249,32,248,246) [ RunTime:0.000661s ]