vb.org Archive - Forum Home Enhancements - Cyb

For big forum at one point it runs an absolutely strupid query, that blocks forum loading. In my case the query left joined tread and user on username and lastposter respectively, wich caused mysql to do " Copying to tmp table " on and on. Here is an example of such a query:

Code:

SELECT thread.forumid, thread.threadid, thread.title, thread.lastpost, thread.lastpostid, thread.lastposter, thread.iconid, user.userid

FROM vb_thread AS thread

LEFT JOIN vb_user AS user ON ( user.username = thread.lastposter )

WHERE threadid >0

AND visible =1

AND OPEN !=10

AND forumid

IN ( 395, 741, 4948, 742, 1866, 743, 744, 4919, 745, 746, 4949, 750, 4950, 1865, 4951, 1864, 4920, 4947, 2739, 2740, 2741, 2742, 2743, 2744, 2745, 2885, 2747, 2746, 2762, 2883, 2748, 3265, 2884, 2886, 2887, 2749, 4621, 4622, 4623, 4624, 4625, 4627, 4626, 4628, 4630, 4631, 4629, 4633, 4635, 9, 430, 874, 49, 2325, 876, 877, 2307, 54, 875, 50, 52, 51, 53, 727, 2308, 55, 2309, 2310, 878, 2326, 5427, 5428, 5429, 5430, 5431, 5432, 5433, 5434, 5435, 5436, 5437, 5438, 5439, 5273, 5274, 5275, 5276, 5402, 5277, 5278, 5279, 5280, 5281, 5282, 5283, 5284, 4386, 4387, 4388, 4389, 4390, 4391, 4414, 4392, 4393, 4394, 4395, 4396, 4397, 4398, 2443, 2444, 2445, 2446, 2447, 2448, 2449, 2450, 2483, 2451, 2480, 2482, 2452, 5108, 5109, 5110, 5111, 5112, 5113, 5114, 5115, 5116, 5117, 5118, 5150, 5119, 5120, 5121, 4758, 4759, 4760, 4761, 4762, 4763, 4764, 4765, 4766, 4767, 4768, 5300, 5301, 5302, 5303, 5304, 5305, 5306, 5307, 5308, 5309, 5310, 5311, 5312, 5313, 2782, 2783, 2784, 2896, 3503, 3504, 2785, 2786, 2787, 2788, 3263, 2789, 2790, 2791, 2792, 5235, 5236, 5237, 5238, 5239, 5240, 5241, 5242, 5243, 5244, 5245, 5246, 5247, 5030, 5031, 5032, 5033, 5034, 5035, 5036, 5037, 5038, 5039, 5040, 5041, 5042, 5409, 5044, 2426, 2427, 2428, 2429, 2430, 2431, 2432, 2433, 2434, 2435, 4140, 2436, 3552, 2536, 4696, 2437, 12, 75, 76, 2296, 77, 78, 79, 80, 81, 82, 624, 829, 124, 2232, 178, 2575, 880, 180, 181, 182, 4361, 184, 185, 4363, 186, 2355, 1339, 5137, 5138, 5139, 5140, 5574, 5141, 5142, 5575, 5143, 5144, 5145, 5576, 5146, 5147, 5577, 5148, 5578, 5579, 5149, 3783, 3784, 3785, 3786, 3787, 3788, 3789, 3790, 3791, 4139, 4211, 4212, 3792, 3793, 4342, 3794, 5162, 3795, 3486, 3487, 3488, 3489, 3490, 3491, 3492, 3493, 3494, 3495, 3496, 3499, 3500, 3497, 3915, 5365, 5366, 5367, 5368, 5369, 5370, 5371, 5372, 5373, 5374, 5375, 5376, 5377, 5123, 5124, 5125, 5126, 5127, 5128, 5129, 5130, 5131, 5132, 5133, 5134, 5135, 5136, 704, 705, 767, 706, 707, 708, 709, 710, 4734, 712, 4735, 3507, 5152, 2277, 4054, 4197, 4198, 4207, 4199, 4200, 4201, 4203, 4213, 4202, 4208, 4209, 4210, 4204, 4205, 4206, 5561, 5562, 5563, 5564, 5565, 5566, 5567, 5568, 5569, 5570, 5571, 5572, 5573, 4586, 4587, 4588, 4589, 4590, 4591, 4592, 5403, 4593, 5179, 4594, 4620, 4738, 4595, 5323, 5324, 5325, 5326, 5327, 5328, 5329, 5330, 5331, 5332, 5334, 5335, 5408, 5336, 5337, 5339, 5248, 5249, 5250, 5251, 5252, 5253, 5254, 5255, 5256, 5257, 5258, 5259, 5260, 1786, 1787, 1788, 1789, 2662, 1790, 1791, 1792, 1794, 1793, 1795, 1796, 2377, 1797, 4973, 4974, 4975, 4976, 4977, 4978, 4979, 4980, 4981, 4982, 4983, 4984, 4985, 5440, 5441, 5442, 5443, 5444, 5445, 5446, 5447, 5448, 5449, 5452, 5450, 5451, 5353, 5354, 5355, 5356, 5357, 5358, 5359, 5360, 5361, 5362, 5363, 5426, 5364, 5595, 5596, 5597, 5598, 5599, 5600, 5601, 5602, 5603, 5604, 5605, 5606, 2956, 2957, 2958, 2959, 3815, 2960, 2961, 2962, 2963, 2964, 2995, 2965, 5535, 2966, 4875, 4876, 4877, 4878, 4879, 4880, 4881, 4999, 4882, 4884, 5178, 4885, 4886, 4887, 4273, 4274, 4663, 4275, 4276, 4277, 4278, 4279, 4280, 4281, 4282, 4283, 4284, 5062, 5063, 5064, 5106, 5066, 5067, 5068, 5070, 5069, 5071, 5072, 5074, 5075, 17, 21, 29, 22, 23, 24, 25, 26, 27, 2261, 28, 5298, 608, 2442, 465, 2260, 922, 923, 2236, 924, 4755, 925, 926, 4756, 927, 928, 929, 930, 4757, 5558, 934, 931, 4719, 4679, 4680, 4681, 4682, 4683, 4684, 4685, 4686, 4687, 4688, 4689, 4690, 4691, 4692, 4693, 4694, 4695, 5453, 5454, 5455, 5456, 5457, 5458, 5459, 5460, 5461, 5462, 5463, 5464, 5465, 1430, 1431, 1432, 1433, 1437, 1439, 1435, 1438, 1440, 1436, 1434, 1442, 3483, 1441, 1613, 1614, 1615, 5508, 5509, 5510, 5511, 5512, 5513, 5514, 5515, 5516, 5517, 5518, 5519, 5520, 4895, 4896, 4897, 4898, 4899, 4900, 4901, 4903, 4902, 4904, 4905, 4906, 4907, 4908, 196, 264, 1444, 265, 267, 268, 271, 272, 1765, 274, 1880, 1448, 200, 331, 1000, 342, 343, 344, 345, 346, 347, 348, 350, 2240, 5197, 5466, 5467, 5468, 5469, 5470, 5471, 5472, 5473, 5474, 5475, 5476, 5477, 5478, 5412, 5413, 5414, 5415, 5416, 5417, 5418, 5419, 5420, 5421, 5422, 5423, 5424, 5425, 3088, 3089, 3090, 3091, 3092, 3093, 3094, 3095, 3096, 3097, 3137, 3098, 3099, 20, 30, 817, 31, 32, 33, 34, 35, 36, 37, 1631, 38, 818, 5180, 5181, 5182, 5183, 5184, 5185, 5186, 5187, 5188, 5190, 5189, 5191, 5192, 5193, 4475, 4476, 4477, 4478, 4636, 4479, 4480, 4481, 4482, 4637, 4483, 4484, 4638, 4485, 4487, 5607, 5608, 5609, 5610, 5611, 5612, 5613, 5614, 5615, 5616, 5617, 5618, 5619, 751, 752, 1461, 753, 754, 755, 756, 758, 1382, 5407, 4643, 5411, 4666, 4667, 4668, 4671, 4669, 4670, 4672, 4673, 4674, 4675, 4676, 4736, 4737, 4677, 4678, 5092, 5093, 5094, 5095, 5096, 5097, 5098, 5099, 5100, 5101, 5102, 5103, 5104, 5105, 4721, 4722, 4731, 4723, 4724, 4725, 4726, 4733, 4728, 5220, 4729, 4732, 519, 520, 528, 521, 522, 3654, 523, 524, 525, 1661, 526, 527, 725, 529, 625, 4432, 4433, 4434, 4435, 5400, 4441, 4503, 4504, 4437, 4438, 4440, 4442, 5055, 4554, 4439, 4443, 5054, 4505, 4506, 4445, 4446, 4507, 4444, 4447, 5003, 5016, 5017, 5018, 5019, 5020, 5022, 5023, 5024, 5025, 5026, 5027, 5410, 5029, 5198, 5199, 5200, 5201, 5202, 5203, 5204, 5205, 5206, 5207, 5208, 5209, 5210, 5211, 5222, 5223, 5224, 5225, 5226, 5227, 5228, 5229, 5230, 5231, 5299, 5232, 5233, 5234, 1769, 1770, 1771, 1772, 3501, 1773, 1774, 1775, 1776, 1784, 2337, 3914, 1777, 1778, 1867, 2338, 2339, 2336, 5580, 5581, 5582, 5583, 5584, 5585, 5586, 5587, 5588, 5589, 5590, 5591, 5592, 5593, 5594, 900, 911, 5194, 912, 913, 914, 915, 916, 917, 1632, 918, 919, 3367, 4890, 531, 532, 1881, 765, 533, 534, 799, 535, 4015, 4016, 537, 762, 539, 764, 614, 3553, 3554, 1018, 3222, 862, 863, 872, 864, 865, 866, 867, 868, 2378, 869, 873, 870, 2379, 1783, 2229, 871, 3898, 3899, 3900, 3901, 3902, 3903, 3904, 3905, 3906, 3907, 3908, 3909, 3910, 4831, 4832, 4833, 4834, 4835, 4836, 5058, 4837, 4838, 4893, 4839, 5267, 5268, 5269, 4840, 4841, 4857, 4858, 4859, 4860, 4861, 4862, 4863, 4864, 4865, 4866, 4867, 4872, 4868, 4869, 19, 100, 780, 102, 103, 104, 106, 107, 109, 110, 127, 761, 617, 5387, 5388, 5389, 5390, 5391, 5392, 5393, 5394, 5395, 5396, 5397, 5398, 5399, 3150, 3152, 3161, 3151, 3154, 3158, 3155, 3157, 3153, 3160, 3162, 2871, 2872, 2873, 2874, 2875, 2876, 2877, 2878, 2879, 2880, 2881, 2882, 5078, 5079, 5080, 5081, 5082, 5083, 5084, 5085, 5086, 5087, 5088, 5089, 5090, 5091, 5002, 5004, 5005, 5006, 5007, 5008, 5009, 5010, 5011, 5012, 5013, 5014, 5021, 5015, 4181, 4182, 4183, 4184, 4185, 4186, 4187, 4188, 4189, 4562, 4190, 4191, 4192, 5522, 5523, 5524, 5525, 5526, 5527, 5528, 5529, 5530, 5531, 5532, 5533, 5534, 5482, 5483, 5484, 5485, 5486, 5487, 5488, 5489, 5490, 5491, 5492, 5493, 5494, 204, 288, 660, 289, 290, 4794, 291, 292, 293, 294, 4795, 4798, 4796, 295, 4799, 1417, 661, 4797, 296, 4792, 989, 990, 1220, 991, 992, 993, 994, 995, 996, 1221, 997, 4502, 998, 5560, 2425, 374, 375, 702, 376, 377, 378, 379, 380, 381, 382, 834, 703, 466, 2502, 383, 1401, 2479, 1222, 2826, 2827, 2828, 2829, 2830, 2831, 2832, 2833, 2834, 2835, 2836, 2837, 2838, 4769, 4770, 4772, 4773, 4774, 4775, 4776, 4777, 5404, 4778, 5405, 4779, 4780, 5495, 5496, 5497, 5498, 5499, 5500, 5501, 5502, 5503, 5504, 5557, 5505, 5506, 5507, 195, 247, 248, 250, 251, 252, 254, 255, 256, 258, 261, 1487, 2295, 3223, 3224, 4417, 3225, 3226, 3227, 3229, 3230, 4418, 3231, 5175, 4143, 3232, 2411, 2412, 2413, 2414, 2415, 5479, 2416, 2417, 2418, 2661, 2420, 5322, 4560, 2534, 5521, 4559, 4800, 4801, 4802, 4803, 5077, 4992, 5052, 4972, 4804, 4805, 4806, 4807, 4808, 4809, 5406, 5401, 5221, 4810, 4811, 5122, 4813, 4814, 468, 469, 1488, 5059, 470, 4416, 3025, 471, 472, 473, 4053, 474, 475, 476, 3028, 3894, 607, 3026, 1489, 4415, 3024, 999 , -1 )

ORDER BY lastpost DESC

LIMIT 0 , 5

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01183 seconds Memory Usage 1,799KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (20)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: