SHOW FULL COLUMNS FROM `t_product` [ RunTime:0.000857s ]
SELECT * FROM `t_product` WHERE `id` = 91 LIMIT 1 [ RunTime:0.000403s ]
SHOW FULL COLUMNS FROM `t_agent` [ RunTime:0.000754s ]
SHOW FULL COLUMNS FROM `t_need` [ RunTime:0.000655s ]
SHOW FULL COLUMNS FROM `t_need_ad` [ RunTime:0.002325s ]
SELECT `n_id` FROM `t_need_ad` WHERE `product_id` = 91 [ RunTime:0.001366s ]
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-04-29 10:47:46' ORDER BY `sort` DESC [ RunTime:0.013243s ]
SELECT * FROM `t_need_ad` WHERE `n_id` IN (47162,47081,46540,47308,44973,45361,46612,34475,46253,47265,45043,45275,47194,40199,45021,46703,45924,43928,45460,44419,46393,29798,45230,45605,34000,36237,43876,44540,37279,46639,44298,44537,30062,46401,37637,46445,46335,45933,45909,45086,45035,46215,45928,44905,46104,45877,45008,45771,45786,45763,44443,45717,45673,45681,45643,23798,45609,45559,45525,45517,45506,44497,45334,45310,44534,45059,45291,45228,18900,21888,45135,45016,44881,44883,44793,11591,44598,44574,43734,35945,14049,43437,36772,43342,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.001961s ]
SHOW FULL COLUMNS FROM `t_users` [ RunTime:0.000851s ]
SELECT id,username,is_auth1,is_auth2,head_portrait,realname,brand,company,position,department,city,is_data FROM `t_users` WHERE `id` IN (49646,37498,51293,14789,48788,21289,51432,7899,51054,38505,49154,49752,51112,32095,33692,51616,50464,11591,38149,51121,10201,50075,7984,6347,38648,49514,6389,48883,49291,49517,21119,860,51247,50989,49126,49594,50725,29675,48890,50726,35404,49923,38411,49446,9034,19576,14070,49720,36082,49310,8869,49516,49690,11023,12833,48778,49826,49837,49385,4325,49578,49543,37882,14745,3208,38252,6616,37973,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.001114s ]
SHOW FULL COLUMNS FROM `t_user_vip` [ RunTime:0.000538s ]
SELECT * FROM `t_user_vip` WHERE `end_time` > 1714358866 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,19576,19651,21119,21289,28078,29675,32095,33692,35404,36082,37478,37498,37882,37973,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) [ RunTime:0.000722s ]
SHOW FULL COLUMNS FROM `t_need_cate` [ RunTime:0.000570s ]
SELECT * FROM `t_need_cate` WHERE `type` = 1 AND `n_id` IN (47162,47081,46540,47308,44973,45361,46612,34475,46253,47265,45043,45275,47194,40199,45021,46703,45924,43928,45460,44419,46393,29798,45230,45605,34000,36237,43876,44540,37279,46639,44298,44537,30062,46401,37637,46445,46335,45933,45909,45086,45035,46215,45928,44905,46104,45877,45008,45771,45786,45763,44443,45717,45673,45681,45643,23798,45609,45559,45525,45517,45506,44497,45334,45310,44534,45059,45291,45228,18900,21888,45135,45016,44881,44883,44793,11591,44598,44574,43734,35945,14049,43437,36772,43342,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.001317s ]
SHOW FULL COLUMNS FROM `t_cate` [ RunTime:0.000580s ]
SELECT * FROM `t_cate` WHERE `id` IN (1,30,4,27,18,103,29,21,110,25,19,2,28) [ RunTime:0.000564s ]
SELECT * FROM `t_need_cate` WHERE `type` = 2 AND `n_id` IN (47162,47081,46540,47308,44973,45361,46612,34475,46253,47265,45043,45275,47194,40199,45021,46703,45924,43928,45460,44419,46393,29798,45230,45605,34000,36237,43876,44540,37279,46639,44298,44537,30062,46401,37637,46445,46335,45933,45909,45086,45035,46215,45928,44905,46104,45877,45008,45771,45786,45763,44443,45717,45673,45681,45643,23798,45609,45559,45525,45517,45506,44497,45334,45310,44534,45059,45291,45228,18900,21888,45135,45016,44881,44883,44793,11591,44598,44574,43734,35945,14049,43437,36772,43342,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.001360s ]
SELECT * FROM `t_cate` WHERE `id` IN (31,35,34,249,32,248,246) [ RunTime:0.000523s ]