1 (edited by Paul 2006-06-22 12:45)

Topic: Performance issues... What are these queries?

I got some of these in my slow_queries.log, could you tell me what they are?

# Time: 060622 12:01:41
# User@Host: ubuntu_fr[ubuntu_fr] @ mawu-ubuntu.apinc.org [80.82.17.132]
# Query_time: 12  Lock_time: 0  Rows_sent: 30  Rows_examined: 85767
use ubuntu_fr;
SELECT t.id AS tid, t.poster, t.subject, t.last_post, t.last_post_id, t.last_poster, t.num_replies, t.closed, t.forum_id FROM forum_posts AS p INNER JOI
N forum_topics AS t ON t.id=p.topic_id WHERE t.id IN(41669,42011,42031,24379,27624,28508,36848,29075,29913,30432,30702,30780,30935,30900,31442,31650,316
54,44943,32056,32211,32369,32461,32507,32933,33001,33344,33705,33772,42072,34036,34693,34758,34812,34879,36086,34946,35338,35730,35658,35713,35838,35873
,35983,36053,36146,36556,37585,36641,36773,36998,37181,37203,37213,37228,37257,37286,37543,37374,37376,37425,37427,37717,42297,37789,37889,38062,38114,3
8117,38386,38453,38539,38639,38653,38720,38731,38828,38849,38852,38912,38921,38949,38989,39106,39493,39275,39248,39424,39536,39577,41716,39729,39870,397
92,39826,39885,39995,40038,40042,40066,40117,40094,41829,40143,40173,40228,40278,40384,40421,40551,40571,40574,40578,40685,40918,40642,40639,40718,40726
,40733,40750,40798,40863,41055,40994,40995,41027,41306,41077,41117,41125,41135,41206,43335,41239,41243,41283,42021,41314,41366,41379,41383,41388,41401,4
1412,41489,41420,41436,41447,41927,41679,41553,42026,41576,41586,41628,41630,41645,41667,41660,41712,41701,41798,41721,41739,41776,41786,41781,41925,418
06,41810,41815,41948,41861,41992,41909,41919,41933,41926,41928,41929,41931,41936,41937,41938,42183,41959,41961,41982,41971,41973,41976,41983,41986,41993
,41997,42056,42014,42032,42044,42045,42047,42051,42057,42069,42083,42114,42124,42125,42128,42166,42139,42142,42154,42158,42159,42161,42165,42182,42195,4
2200,42205,42413,42290,42339,42389,42417,42561,42575,42589,42646,42682,42753,42789,42795,42929,43061,43190,43344,43683,43680,43684,43879,43930,44031,440
35,44342,44425,44677,44840,44939,45039,45248,45281,45754,45957,46210,46271,46458,46604,43364,820,43177,1628,4086,4342,6277,7514,43174,8259,8966,41888,98
59,12140,12382,44297,41946,15369,15952,42015,16518,42030,42453,16940,42916,18393,43380,43455,19806,21445,22347,23479,23575,23789,44892,44891,24930,25274
,26628,26787,27603,28318,28735,43915,30611,46008,31814,31859,31960,32046,32066,32607,33118,33213,45244,33680,34022,34091,34100,34457,43154,35731,35785,4
5276,36075,44156,36490,36579,36788,36864,39081,39257,39287,46240,39355,39406,39420,39542,39628,39651,39739,40787,39775,40122,40400,40668,40513,40541,409
83,41005,41020,41063,41075,41193,41218,41226,42235,41347,42484,41517,41534,43639,41558,41964,41587,41592,41593,41658,41674,42084,41605,44584,42052,42391
,41676,43582,41744,41745,41823,41900,42140,41842,41862,41897,41910,41920,41941,44974,41958,46356,41974,42082,41998,42013,42004,42027,42036,42038,42075,4
2070,42118,42079,42833,42091,42100,42107,42111,42116,42119,42123,42130,42135,42152,42175,42300,42673,42245,42204,42192,42206,42221,42210,42461,42225,422
29,42232,42233,42269,42264,42272,42271,42287,42288,42295,42325,42304,42318,42337,42341,42346,42351,42367,42378,42502,42371,42382,42396,42400,42437,42435
,42426,42430,42431,43238,42462,42443,42496,42446,42459,42465,42471,42472,42490,42495,42851,42499,42500,42506,42513,42518,42837,42625,42542,42539,42540,4
2541,42557,42601,43173,42588,42605,42594,42599,42628,42621,42619,42708,42652,42655,42662,42788,42685,42687,42721,42714,42724,42727,42728,42762,42731,427
35,42736,42739,42743,42748,42765,42778,42784,42792,42794,42797,42804,42811,42814,42825,42832,42841,42948,42877,42860,42863,43658,42868,42881,42873,42882
,42898,42974,42926,42928,42931,42935,42939,42963,42947,42951,42954,46165,42965,42969,42973,42975,42978,42989,42985,45036,43382,43018,43021,43022,43031,4
3040,43037,43894,43043,43079,43042,43044,43047,43052,43060,43068,43072,43086,43074,43081,43087,43134,43102,43296,43114,43252,43170,43137,43178,43172,431
47,43149,43157,43226,43161,43167,43337,43188,43193,43199,43201,43212,43375,43248,46033,44166,43688,43241,43247,43256,43270,43273,43281,43283,43334,43294
,43333,43354,43302,43504,43303,43307,43317,43321,43323,43326,43338,43355,43363,43367,43385,43386,43417,43418,43426,43442,43428,43431,43441,44754,43494,4
3449,43457,43466,43467,43470,43476,43909,43773,43484,43485,43490,43493,44129,43513,43503,43511,43516,43524,43531,43533,43537,43539,43542,43543,43547,435
48,43553,43568,43570,44804,43579,43581,43586,43610,43590,43599,43651,43607,43608,43609,43641,43645,43647,43656,43664,43668,43672,43675,43678,43685,43686
,43782,43691,43695,43704,43716,43735,43711,43714,43719,43723,43724,43734,43922,43745,43757,43765,43791,43805,43806,43807,43809,43810,43813,43823,43832,43829,43839,43943,43903,45228,43875,44300,43878,43885,43887,43914,43931,43934,43936,43940,43944,43946,43956,43965,43970,43983,43984,44003,43993,44002,440
04,44038,44539,44016,44034,44037,44039,44040,44044,44055,44063,44065,44070,44083,44101,44113,44119,44153,44138,44140,44144,44147,44152,44157,44159,44176
,44163,44165,44179,44188,44185,44187,44241,44191,44204,44211,44213,44214,44218,44222,44223,44234,44301,44249,44251,44263,44276,44284,44298,44302,44308,4
4321,44326,44337,44347,44349,44360,45134,44376,44865,44398,44514,44397,44400,44475,44416,45139,44464,44602,44438,44453,44455,44456,44461,44463,44465,444
67,44489,44511,44500,44817,44501,44502,44505,44510,44702,44530,44566,44568,44569,44572,44580,44640,44603,44607,44609,44615,44630,44641,44658,44665,44681
,44753,44690,44693,44703,44711,44716,44735,44752,44749,44770,44771,44783,44785,44792,44795,44812,44816,44843,44841,44852,44854,44885,44886,44903,44912,4
4914,44920,44929,45848,44942,45126,44960,44958,45098,44978,44983,44989,44997,44998,45011,45016,45017,45024,45029,45031,45035,45163,45074,45075,45078,457
46,45082,45095,45106,45121,45172,45173,45313,45184,45188,45190,45194,45202,45347,45217,45235,45221,45230,45232,45234,45236,45239,45245,45551,45252,45255
,46284,45265,45270,45278,45295,45771,45307,45308,45310,45314,45315,45495,45321,45331,45341,45354,45369,45387,45389,45391,45396,45398,45858,45402,45410,4
5452,45438,45450,45458,45459,45463,45474,45480,45485,45486,45487,45489,45491,45499,45508,45516,45519,45524,45777,45642,45530,45534,45539,45544,45588,455
68,45576,45580,45617,45592,45593,45595,45611,45613,45631,45615,45618,45634,45640,45652,45653,45655,45660,45659,45690,45674,45780,45678,45681,45687,45683
,45695,45694,45697,45696,45763,45706,45711,45715,45721,45725,45727,45735,45741,45745,45750,45753,45772,45813,45801,45804,45811,45821,45817,45825,45815,4
5838,46417,45850,45859,45872,45884,45893,45894,45899,45964,45907,45909,45913,45932,45940,45952,45956,46027,45996,45997,46005,46010,46028,46030,46035,460
38,46053,46258,46071,46080,46083,46094,46115,46098,46100,46101,46102,46196,46106,46109,46118,46116,46123,46127,46137,46150,46156,46163,46167,46432,46178
,46189,46255,46211,46212,46213,46228,46317,46241,46265,46344,46270,46275,46276,46277,46282,46291,46426,46302,46313,46318,46401,46334,46336,46367,46342,4
6357,46485,46455,46398,46392,46468,46414,46413,46425,46427,46496,46430,46449,46497,46466,46474,46488,46507,46495,46501,46503,46504,46538,46505,46516,465
32,46551,46563,46571,46573,46577,46578,46581,46583,621,1690,2001,2121,5273,7257,7461,7809,8141,41796,10256,11628,12469,41914,12822,13040,13981,42064,148
12,15615,16901,42547,17956,18467,18656,18849,19409,19958,43535,20312,20333,21259,22599,22740,23085,23422,23636,44877,24451,25681,25684,25977,26551,26941
,28170,29086,29091,29094,29444,30093,30753,30829,31613,32697,33051,33433,33483,37979,33561,45191,34454,34481,34471,34576,34596,34817,35438,35752,35932,3
6145,36329,36674,37014,36941,37002,37058,37314,37860,38019,38095,38721,38797,39245,39266,39694,39740,39925,40070,40091,40348,46565,40509,40713,40868,409
48,41010,41059,41216,41298,41324,41354,41363,41947,41442,41459,41470,41702,44573,41653,41672,41698,41696,41707,41943,41787,41814,41821,41851,41833,41891
,41967,41969,42006,42012,42008,42022,42033,42086,42096,42115,42120,42137,42181,42178,42208,42202,42203,42227,42322,42265,42283,42291,42306,42311,46151,4
2334,42347,42372,42381,42397,42394,42405,42528,42436,42454,44381,42466,42489,42554,42514,42529,42577,42639,42651,42653,42669,42681,42717,42744,42694,427
09,42712,42720,42755,42764,42782,43412,42839,43109,42892,42857,42865,42867,42874,42878,42888,42910,42933,42964,44258,42991,42994,43000,43003,46586,43026
,43028,43046,43067,43869,43105,43113,43122,43148,43180,43191,43209,43673,43259,43422,43268,43291,43292,43300,43305,43312,43313,43315,43331,43341,43495,4
3402,43413,43451,43463,43474,43483,43491,43741,43505,43622,43550,43546,43635,43666,43708,44190,43727,43760,43780,43837,43847,43854,43897,43902,43916,439
45,43947,43975,45053,43978,43986,44011,44066,44074,44073,44075,44098,44112,44116,44127,44143,44168,44183,44196,45359,44202,44203,44210,44221,45136,44961
,44387,44361,44384,44386,44639,44406,44427,44434,44437,44448,44450,44460,44471,44522,44523,44526,44540,44610,44581,44613,44627,44617,44636,44655,44678,4
4664,44660,44720,44679,44685,44845,44686,44694,44831,44697,44698,44701,44766,44758,44786,44794,44813,45080,44818,44864,44871,44922,44941,44988,44975,449
94,44977,45382,45054,45086,45092,45096,45103,45157,45166,45161,45216,45240,45376,45197,45198,45209,45211,45272,45242,45249,45250,45284,45267,45294,46546
,45297,45303,45317,45564,45325,45921,45357,45367,45419,45383,45418,45429,45432,45444,45488,45503,45506,45538,45579,45616,45625,45637,45645,45663,45664,4
5673,45686,45693,45918,45704,45710,45712,45720,45775,45779,45800,45842,45831,45836,45898,45917,45937,45955,45960,45966,45983,46420,46018,46037,46025,460
60,46122,46121,46141,46142,46143,46158,46166,46169,46170,46176,46193,46200,46236,46289,46307,46316,46335,46347,46351,46358,46380,46389,46390,46395,46400
,46424,46442,46454,46459,46528,46477,46482,46494,46537,46602,46541,46548,46570,46575,46595,46597,46615,2,1963,2906,4696,41668,5976,41906,41752,8401,8444
,8549,8851,11696,12592,13132,43528,42010,15775,15890,16679,18965,21243,21571,44838,22968,23445,45127,24669,24762,25162,26307,45510,27527,27596,28445,330
48,32010,32484,33072,33618,33948,34008,45288,35643,36000,36180,36254,36630,36800,36801,36852,36930,37787,42914,39415,39887,39983,40241,40346,40352,42092,40606,40746,40875,40972,40993,41006,41070,41355,41482,41577,41637,41711,41709,41723,41827,41826,41873,41880,41932,41913,41934,41942,42121,41979,42088,4
2025,42246,42048,42053,42067,42081,42101,42076,42077,42087,42102,42109,42112,42131,42155,42151,42163,42162,42173,42164,42174,42180,42185,42193,42191,422
14,42220,42224,42231,42239,42240,42252,42248,42251,42256,42262,42270,42281,42274,42298,42309,42333,42364,42344,42345,42349,42360,42388,42401,42402,42407
,42432,42475,42483,42524,42585,43396,42606,42612,42626,42629,42638,42656,42827,42659,42660,42713,42779,42808,42823,42828,42834,42852,42862,42887,42897,4
2980,42983,43056,42995,43065,43071,43125,43094,43099,43117,43159,43187,43222,43225,43293,43342,43371,43374,43387,43926,43462,43544,43529,43612,43560,438
31,43606,43621,43676,43693,43949,43730,43737,43739,43767,43766,43797,43890,43900,43906,43912,43920,44283,43955,46261,43959,43988,43992,44001,44020,44032
,44094,44726,44084,44423,44250,44189,44232,44369,44248,44257,44266,44767,44305,44307,44318,44323,44328,44341,44345,44353,44395,44418,44391,44457,44407,4
4441,44806,44611,44503,44509,44555,44550,44695,44773,44901,44796,44868,44805,44811,44834,44836,44873,44928,44933,44945,44965,44946,44953,44973,44993,449
80,44982,45021,45052,45135,45141,45153,45177,45251,45293,45412,45426,45461,45462,45467,45533,45521,45537,45548,45563,45585,45599,45609,45607,45622,45623
,46031,45656,45776,45675,45722,45783,45737,46034,45961,45868,45809,45819,45852,45866,45890,46238,45924,45920,45988,45977,46004,46063,46131,46139,46252,4
6201,46207,46215,46256,46251,46411,46297,46324,46327,46445,46456,46475,46518,46523,46520,46531,46553,46584,46596,46613,5515,27379,27640,31452,36235,3857
8,38306,39263,39779,40612,41561,41506,41996,42020,42327,42249,42531,42533,42671,42679,42725,43100,43118,43171,43197,45761,43459,43508,43517,43792,43660,
43669,43895,43991,44161,44184,44413,44608,44824,45070,45922,45320,45346,45479,45647,46120,46187,46415,46428,46471,46481,46483,436,681,15339,19753,43794,
43815,21491,44080,44356,28431,31417,34828,46146,35453,37920,38399,39050,40004,40159,40422,40827,40976,41353,41662,41853,41896,41970,41975,42189,42041,42
029,42023,42050,42085,42104,42464,42197,42236,42244,42263,42267,42275,42284,42286,42310,42943,42340,42392,42398,42410,42576,42429,42452,42667,42470,4248
2,42486,42523,42530,42543,42553,42546,42570,42579,42591,42616,42617,42684,42704,42693,42700,42805,42738,42775,42843,42793,42990,42854,42875,43223,42924,
42941,42942,42961,42992,43004,43214,43142,43115,43124,43236,43128,43151,43160,43210,43213,43237,43251,43253,43306,43319,43340,43390,43392,43415,45442,43
452,43460,43468,43471,43479,43499,43502,43571,43594,43614,43663,43690,43729,43743,43796,43789,43908,43932,43958,43962,43972,44068,44104,44078,44093,4412
0,44154,44164,44172,44169,44180,44499,44293,44449,44408,44490,44543,44557,44605,44582,44595,44600,44623,44616,44622,44635,44651,44644,44657,44675,44724,
44737,44740,44789,44797,44826,44828,44833,44847,44869,44888,44904,44954,44955,44985,45405,45147,45144,45219,45229,45351,45350,45378,45393,46594,45774,45
468,45478,45560,45570,45670,45646,45803,45880,45904,45954,45971,45993,46036,46055,46078,46086,46088,46133,46124,46130,46135,46138,46159,46183,46205,4628
7,46310,46576,46368,46373,46391,46453,46479,46492,46506,46549,46567,200,43176,4223,7509,7626,16449,17597,21224,26565,46363,45925,27993,33790,37601,37482
,38076,38251,39744,43990,40445,40555,40745,41004,41038,41128,41139,41266,41331,41357,41432,41540,41620,41846,41963,41876,41878,41981,41989,42042,42068,4
2194,43357,42133,42156,42141,42215,42201,42242,42228,42230,42237,42254,42258,42259,43135,42276,42285,42302,42312,42313,42355,42356,42353,42354,42369,423
70,42517,42393,42406,42424,42414,42419,42448,42451,42481,42505,42492,42497,42508,42537,42551,42562,42558,42560,42568,42580,42678,42609,42614,42623,42631
,42643,42640,42654,43057,42732,42740,42759,42767,42802,42780,42855,42817,42820,42822,42876,42904,42909,42930,42923,42936,42944,42949,42956,42960,42962,4
2981,42997,43005,43017,43006,43058,43062,43063,43070,43095,43103,43133,43189,43145,43184,43221,43454,43203,43217,43219,43231,43282,46194,43359,43348,433
76,43384,43393,43394,43406,43408,43421,43433,43450,43453,43456,43549,43569,43591,43655,43692,43712,43886,43750,43772,43785,43818,43825,43870,43855,43867
,43871,44008,43999,45542,44049,44059,44110,44069,44849,44086,44096,44099,44109,44122,44676,44145,44175,44181,45223,44270,44230,44231,44253,44269,44330,4
4275,44281,44762,44292,44299,44338,44350,44351,44567,44374,44375,44382,44393,44403,44430,44556,44559,44620,44673,44764,45152,44736,44769,44778,44782,455
57,44793,44822,44853,44890,44910,44934,44972,44987,44996,45007,45015,45083,45150,45156,45243,45253,45311,45328,45455,45349,45517,45413,45407,45408,45425
,45456,45481,45482,45493,45501,45505,45635,46154,45915,45672,45702,45740,45743,45768,45795,45818,45834,45837,45839,45849,45844,45883,45934,45941,45974,4
5986,46042,46026,46047,46043,46077,46084,46092,46179,46112,46155,46177,46182,46221,46239,46233,46599,46285,46288,46295,46296,46320,46352,46407,46422,464
43,46444,46457,46472,46487,46515,46526,46545,46547,46552,46556,46557,46609,10177,13873,14863,21377,21919,24279,26803,29307,29861,31184,32404,33578,33836
,35715,41854,2046,7647,11766,15763,19424,19062,20519,22729,26942,28728,32719,36339,36679,38843,38899,39232,39985,40009,40353,40596,40628,40655,40898,410
60,41282,41502,41809,41585,41859,42007,42016,42073,42095,42132,42169,42301,42416,42442,42468,44682,42637,42573,42661,42702,42766,42986,43194,43023,43055
,43155,43255,43258,43264,43388,45206,43593,43389,43400,43736,43874,43963,44021,44036,44340,44433,44440,44535,44558,44560,44601,44715,44757,44858,44894,4
5169,44951,46104,45128,45164,45668,45333,45271,45286,45436,45445,45525,45562,45584,45586,45587,45784,45867,45919,45953,46000,46293,46147,46161,46175,463
64,46431,46579,46514,46529,46607,46622,1156,2518,41754,17101,19119,24199,29621,33077,33120,34068,34746,35712,37104,37259,38448,39624,39530,40131,44800,4
1220,41292,41277,41610,41991,41944,42074,45045,42438,42608,42773,42774,42809,43015,43054,43196,43330,43731,43808,43862,43899,43910,43952,44045,44092,441
05,44148,44252,44267,44273,44358,44481,44484,44570,45215,44688,44777,44779,44918,44971,45005,45110,45142,45264,45257,45263,45360,45380,45460,45665,45791
,45856,45905,45870,45929,45973,46022,46089,46157,46268,46230,46247,46321,46372,46383,46465,46489,46564,46616,107,158,226,1550,3790,3849,6357,41666,10060
,10966,12064,13278,16517,17043,17470,19798,19884,23137,23179,23567,23871,25128,26973,27463,32255,32971,33389,34707,34910,35196,36038,35561,35590,35774,3
6372,45649,37688,37930,38025,38867,38868,44378,40700,41203,41217,41368,41621,41652,41657,41661,41789,41836,41980,42054,42062,42136,42153,42282,42365,423
77,43267,42521,42583,42647,42677,42706,42846,42772,42906,42911,43010,43078,43083,43089,43254,43287,43556,43574,43589,43604,43637,43776,43836,43872,43880,43905,43933,43942,43953,43994,44041,45807,44158,44216,44228,44233,44238,44277,44355,44370,44401,44446,44466,44477,44492,44634,44632,44652,44710,44765,4
4935,44791,44825,44839,45633,45162,44884,44900,45091,45048,44957,45088,45338,45266,45371,45406,45441,45515,45540,45546,45578,45583,45767,46044,45728,457
55,45759,45802,45799,45827,45824,45855,45927,45958,45970,46052,46217,46224,46294,46306,46339,46348,46371,46379,46382,46484,46550,46574,46610,400,1117,11
99,1742,3087,4734,5193,5302,5901,5938,5978,7760,8539,8835,10744,10761,43227,11905,12257,41899,14283,14701,14941,42065,42017,15959,16289,16610,16631,1703
2,18838,18844,43438,19948,43534,20780,43800,21987,22739,22806,23055,23376,23593,24446,25626,25954,26172,26563,26647,26819,27336,27410,27995,28267,28801,
45744,29186,30434,30869,31206,31541,32137,32316,32618,32943,32777,32986,33266,33340,33632,34057,44334,34259,34854,34900,34942,35268,35269,35382,35546,35
548,35595,35608,36124,36887,36898,37125,37569,37458,37772,37864,37886,37943,38245,38534,38614,45336,38681,38713,43706,38768,38781,44324,38966,39082,3910
8,46470,39271,39486,39946,46264,40100,40124,40188,40203,46404,40343,40446,40479,40641,40657,40769,40791,40890,40909,41026,41118,41170,41175,41174,42117,
41538,45446,41332,41313,41424,41408,41453,41492,41514,41554,41579,43049,41614,41623,41697,41717,42350,41771,42680,41885,41894,41924,41915,41923,41935,41
962,41966,41972,42002,42040,42058,42060,42080,42110,42090,44087,42129,42150,42147,42399,42186,42188,42209,42211,42213,42217,42218,42222,42234,42261,4233
1,42289,42317,42319,42321,42328,42330,42366,42485,42380,42411,42404,44303,42870,42441,42445,42447,42469,42474,42511,42705,42510,42512,42515,42522,42525,
42534,42538,42545,42567,42571,42604,42574,42611,45116,42607,42615,42622,42658,42644,42650,42663,42665,42670,42674,42683,42691,42692,42690,42697,42699,42
703,42719,43027,42741,46097,42757,42838,42776,42781,42785,42790,42819,42799,42803,42806,42830,42829,42856,42864,42871,42879,44271,42900,42902,43130,4290
3,42913,42918,42927,43703,42932,42984,43873,42957,42971,43001,43121,43013,43014,43016,43033,43034,43036,43050,43053,43106,43110,43119,43120,43144,43150,
43158,43162,43175,43181,43183,43242,43205,43216,43230,43243,46032,43261,43262,43265,43277,43285,43288,43299,43398,43361,43401,43588,43365,43378,45332,43
399,43407,43409,43411,43643,43423,43424,43432,43434,43440,43443,44219,43465,43469,43481,43487,43616,43587,43520,43525,43536,43545,43572,43576,43583,4360
2,43629,43611,43618,43630,43632,43633,43640,43667,43671,43682,43694,43697,43702,43717,43718,43726,43740,43744,43748,43911,43783,43753,44009,43764,43770,
43774,43775,43790,43795,43828,43842,43804,43811,43812,43814,43816,43820,43821,43827,43830,43844,43845,43850,43852,43857,43860,43861,43865,43866,43893,43
904,43917,44017,43941,43961,44097,43969,43971,44061,43979,43995,43996,44005,44006,44007,44012,44013,44024,44030,44048,44050,44103,44123,44056,44095,4410
8,44114,44117,44132,44134,44139,44150,44142,44173,44174,44371,44193,44431,44197,44201,44209,44259,44224,44240,44242,44243,44244,44268,44278,44290,44286,
44316,44372,44311,44336,44462,44359,44388,44364,45224,44474,44390,44396,44405,44410,44424,44447,44480,44482,44488,44498,44863,44524,44527,44548,44542,44
544,44545,44561,44578,44565,44574,44612,44579,44596,44598,44604,44606,44621,44625,44721,44629,44647,44633,44638,44643,44650,45504,44653,44659,44861,4466
7,44823,44680,44687,44696,44699,44700,44705,44712,44932,44731,44734,44747,44738,44755,44756,44772,44774,44781,44776,44798,44799,44815,44827,44829,44832,
44835,44837,44906,44856,44908,44911,44921,44925,44931,44938,44950,44947,45117,44949,44952,44981,44966,44968,45608,44984,44995,45115,45000,45008,45038,45
059,45472,45084,45137,45090,45094,45113,45149,45124,45279,45130,45133,45143,45159,45155,45158,45160,45180,45183,45167,45168,45175,45186,45187,45196,4520
3,45205,45218,45213,45222,45277,45301,45258,45300,45302,45304,45309,45327,45329,45319,45782,45348,45365,45386,45366,45415,45375,45388,45394,45621,45390,
46020,45430,45422,45433,45601,45475,45470,45496,45497,45498,45500,45513,45556,45523,45529,45654,45531,45545,45547,45549,45566,45558,45559,45571,45602,45
581,45606,45603,45619,45717,45628,45644,45658,45793,45669,45689,45736,45701,45709,45714,45778,45765,46012,45876,45806,45814,45833,45851,45873,45877,4588
2,45888,45896,45901,45903,45908,46059,45931,45944,45965,45979,45980,45984,45987,45998,46002,46006,46007,46011,46017,46589,46023,46046,46049,46065,46074,
46081,46090,46091,46093,46099,46107,46110,46114,46153,46172,46199,46185,46190,46195,46197,46209,46218,46227,46237,46332,46260,46266,46281,46283,46292,46
299,46319,46325,46328,46354,46346,46361,46377,46448,46393,46394,46402,46403,46410,46498,46435,46437,46452,46539,46450,46460,46534,46490,46493,46511,4651
3,46533,46536,46542,46544,46555,46566,46561,46582,46593,46608,623,3441,3485,2458,4511,4630,6352,6392,7190,7457,8770,9147,9924,11117,13891,13931,41994,41
954,15166,15648,16182,17363,17463,18738,19533,19686,19984,20359,20679,43891,22614,23023,24030,24806,45207,26037,26055,45148,26702,27577,27171,27250,2744
3,28008,27779,27929,28026,28812,29169,29430,29776,29910,45612,30938,31354,31773,31668,32691,32798,33388,33503,33706,34340,34349,34412,34442,34543,34811,
35279,35445,35661,36637,40930,36988,37327,37590,37656,37823,42494,37881,42958,45384,38078,38232,38263,44586,38304,38795,38365,38424,38513,38894,38967,39
032,39208,39750,39867,39955,40132,40439,42122,40417,40502,45677,40519,40544,40576,40708,42257,41017,41509,41154,41791,41364,41429,41450,41446,41467,4152
2,41949,41570,41591,41594,41601,41611,41612,41619,41624,41740,41766,41777,41822,41819,41820,41849,41892,41916,41957,42000,42019,42024,42035,42039,42059,
42600,42063,42066,42071,42103,42093,42148,42268,42106,42149,42157,42338,42207,42266,42308,42303,42329,42326,42343,42423,45081,42359,42361,42363,42384,42
519,42434,42450,42478,43088,42584,42596,42696,42636,42686,42672,42675,43107,42707,42711,42715,42729,42730,42733,42760,42746,42754,42807,42815,42894,4284
0,42842,42848,42869,42872,42886,42890,42893,42905,42946,42966,43541,43008,43025,43029,43041,43051,43059,43073,43084,43104,43112,43195,43192,43228,43233,
43229,43240,43257,43679,43263,43271,43272,43274,43279,43284,43297,43301,43318,43328,43352,43350,43475,43625,43439,43444,43458,43482,43480,43628,43507,43
509,43756,43575,43598,43603,43619,43698,43646,43662,43710,43888,43781,43853,43787,43786,43822,43826,43838,43843,44399,43868,43889,44022,43954,46132,4396
0,43998,44010,44019,44033,44235,44042,44047,44058,44348,44076,44199,44208,44624,44236,44280,44287,44288,44312,44352,44366,44367,44368,44373,44383,44436,
44392,44411,44414,44419,44420,44422,44439,44472,44487,44495,44506,44507,44515,44517,44518,44519,44521,44520,44525,44529,44533,44538,44547,44549,44564,44
576,44587,44671,44626,44628,44649,44642,44646,44656,44668,44729,44719,44713,44717,44727,44748,44763,44780,44787,44788,44820,44860,44857,44866,44875,4487
9,44881,44883,44902,45330,44917,44930,45033,45326,45042,45004,44999,45037,45165,45046,45051,45085,45055,45077,45104,45109,45118,45119,45170,45181,45189,
45200,45195,45210,45254,45269,45259,45260,45262,45268,45273,45305,45322,45355,45385,45411,45552,45424,45632,45437,45447,45448,45476,45477,45527,45512,45
514,45543,45554,45567,45639,45582,45597,45684,45627,45643,46286,45692,46079,45723,45730,45724,45726,45732,45738,45739,45742,45781,45829,45816,45863,4583
0,45841,45865,45864,45875,45895,45906,45933,45978,45995,46014,45999,46003,46021,46056,46064,46073,46105,46173,46144,46186,46204,46206,46226,46232,46246,
46278,46262,46279,46436,46333,46349,46366,46375,46399,46406,46408,46409,46416,46439,46478,46508,46519,46525,46543,46559,46585,46590,46605,46606,46618,46620,761,1015,3321,4531,6842,7536,41751,41748,8855,41968,12367,41953,15590,15721,16181,17300,42917,18390,20144,20213,44071,44889,24777,24910,45174,27643,
27840,27888,28036,29017,31502,31580,32364,43430,34018,35083,35118,42787,35165,35220,35611,36083,37070,37107,43677,37644,41901,38372,38542,38668,39516,39
565,39706,40047,40249,40334,40546,40590,44192,41678,41249,41330,41460,41541,41659,41687,43349,41825,41905,42046,41995,42043,42113,42385,42167,42176,4231
5,42390,42420,42439,42456,42479,42487,42503,42535,42572,42593,42633,42635,42648,42688,42718,42777,42770,42768,42769,42800,42818,42847,42915,42976,42970,
43045,43841,43127,43141,43143,43156,43208,43801,43308,43298,43295,43289,43314,43310,43353,43381,43403,43592,43419,43523,43486,43512,43515,43538,43580,43
636,43585,43615,43597,43638,43650,45466,44151,43802,43840,43834,44085,44057,44029,44064,44090,44106,44245,44125,44131,44162,44344,44195,44237,44254,4511
2,44296,44320,44362,44760,44402,44404,44415,44802,44454,44426,44459,44478,44485,44504,44528,44532,44537,44552,44575,44589,44591,44631,44654,44743,44674,
44746,44830,44750,44751,44810,45747,44862,44915,44927,44916,44944,44986,45003,45012,45023,45028,45030,45093,45101,45192,45178,45193,45204,45208,45212,45
214,45247,45786,45256,45275,45290,45352,45358,45364,45550,45528,45399,45509,45471,45502,45535,45569,45605,45614,45624,46108,45671,45685,45729,45733,4577
3,45976,45832,45835,46188,45886,45891,45897,45900,45910,45930,45945,45972,45991,46015,46024,46062,46145,46160,46191,46202,46214,46225,46231,46269,46301,
46303,46315,46330,46331,46350,46355,46362,46365,46384,46397,46419,46476,46521,46568,46572,46588,46600,46621,1043,7682,11893,30852,34894,35570,39051,3726
2,37894,38944,39252,39753,40116,40477,40429,40650,41763,41839,41955,42455,42745,42756,43152,43198,43290,43526,44100,43778,43967,43966,43977,44015,44206,
44229,44592,44718,44895,45087,45097,45107,45427,45573,45604,45703,46162,46378,46433,23,2662,8899,42323,18850,22891,25045,27107,31406,33407,35151,36806,3
7108,43833,38794,40256,40637,42742,42374,46601,41874,41895,41960,43670,42247,42097,42108,42144,42170,42184,42238,42243,42280,42376,42357,42379,42460,424
67,42504,42507,42627,42771,42968,42993,43082,43111,43182,43339,43416,43500,43798,43763,43777,44215,43913,43973,43985,44239,44304,44322,44531,44898,45409
,44948,45047,45108,45808,45171,45434,45680,45572,45698,45981,46019,46096,46203,46337,46343,46418,46463,732,41952,44897,42613,30231,35508,42563,37988,406
63,40859,43901,41146,41336,42126,42216,42219,42223,42408,42457,42476,42509,42532,42548,42695,42634,42750,42796,42836,42853,42901,42934,43075,43358,43530
,43521,43657,43709,43876,43849,44027,44124,44205,44247,44445,44536,44551,44648,44669,44704,44940,45076,45111,45138,45403,45483,45638,45789,45916,45878,4
6076,46300,46592,46619,2962,4600,6446,6479,6512,6803,7799,7896,8523,10530,10852,13803,15913,41985,15557,16670,42037,16775,17087,18625,19768,20006,20145,
20437,20557,43951,21220,21812,23046,23433,23365,23689,26516,26844,27196,28888,29615,32575,33674,34185,35242,35225,35529,36750,38031,38411,39476,39521,40
040,40086,40703,41028,43788,41528,41956,41999,42171,42199,43410,42603,42649,43327,42749,42810,42812,42821,42907,43278,43085,43165,43169,43185,43204,4327
6,43448,43496,43518,43742,43846,43929,43968,43981,44121,44217,44429,44306,44339,44357,44380,44571,44976,45034,45049,45099,45125,45443,45316,45318,45401,
45414,45421,45454,45526,45594,45650,45679,45713,45845,45787,45810,45914,45949,46184,46267,46305,46326,46517,376,11625,29331,37501,33629,37572,38548,4016
9,40843,40849,41158,41167,41423,41767,41835,42003,42241,42292,42527,42549,42559,42578,42595,42858,42938,43577,43713,43858,43928,44126,44346,44389,44443,
44468,44663,44848,44855,44899,45073,45079,45145,45179,45397,45453,45923,45854,45935,45967,46054,46220,8111,44512,15057,43584,19713,20507,25742,28707,325
01,45435,33852,35227,42581,38058,38421,39052,39934,43372,40702,41263,42098,41889,42005,42018,42055,42138,42198,42226,42279,42273,42387,42375,42352,42415
,42433,42912,42488,42491,43069,42555,42556,42592,42602,42630,42632,42664,42676,42689,42723,42899,42885,42922,42937,42952,42977,43020,43009,43012,43522,4
3123,43153,43246,43202,44689,43224,43304,43336,43356,43351,43373,43436,43634,43532,43552,43687,43701,43707,43793,43819,43824,43851,43948,44018,44077,441
15,44225,44149,44264,44262,44310,44317,44432,44417,44645,44670,44672,44684,44691,44692,44846,44808,44936,44874,45009,45020,45027,45043,45132,46617,45220
,45226,45246,45469,45377,45420,45423,45484,45520,45575,45565,45629,45657,45662,45749,45752,45758,45769,45797,45794,45798,46164,45871,45911,45947,45975,4
5982,46039,46040,46072,46085,46168,46117,46462,46171,46192,46253,46249,46290,46314,46370,46387,46388,46421,46451,46438,46467,46469,46502,46591,46603,185
,43179,41454,2487,3803,10578,12828,13750,13769,14472,41987,16531,42324,19337,25166,45596,27407,28366,28396,28723,30819,31786,32790,34436,45963,43140,453
24,35123,35402,35858,42590,38308,38390,38734,38684,38811,38900,38909,39101,39168,42421,43652,40046,40470,40466,40515,40530,40535,40595,40675,40796,41054
,44081,41101,41150,41147,41169,41212,45682,41598,41603,41760,41779,41783,41866,42049,41907,41908,43997,42028,42061,43343,42105,42253,42255,42278,42296,4
2299,42307,42314,42332,42335,42383,42896,42362,42403,42422,42428,42440,42449,42734,42582,42544,42552,42566,43002,42597,42620,42618,42624,42641,42657,426
66,42668,42698,42710,42722,42737,42786,42791,42801,42816,42813,42884,42826,42831,42849,42866,42845,42861,42880,42972,42889,42908,42921,42950,42955,42979
,42982,42988,42998,42999,43038,43039,43048,43164,43090,43168,43139,43163,43206,43215,43218,43234,43235,43249,43266,43324,43275,43280,43488,43309,43320,4
3329,43332,43370,43395,43404,43600,43506,43429,43435,43437,43478,43557,43519,43561,43527,43559,43573,43595,43648,43624,43626,43907,43653,43674,43722,437
28,43733,43768,43769,43771,43799,45392,43864,43883,43892,43896,43918,43927,43937,43980,44025,44028,44051,44052,44062,44079,44102,44107,44111,44118,44130
,44128,44133,44135,44146,44167,44178,44486,44194,44220,44260,44265,44285,44294,44325,44335,44343,44354,44435,44562,44444,44442,44451,44452,44473,44493,4
4516,44513,44508,44534,44546,44577,44583,44588,44597,44637,44706,44759,44784,44969,46491,44913,45041,44872,45541,44882,44896,44907,44963,45001,45018,450
25,45044,45050,45056,45100,45114,45123,45131,45140,45151,45182,45225,45231,45237,45345,45274,45282,45289,45306,45335,45337,45339,45400,45342,45344,45353
,45356,45370,45374,45395,45439,45449,45465,45511,45522,45536,45553,45555,45676,45600,45574,45590,45591,45636,45661,45757,45688,45691,45707,45731,45756,4
5766,45788,45792,45812,45822,45847,45862,45869,45874,45881,45887,45889,45926,45951,45985,45990,45994,46061,46119,46113,46486,46148,46180,46219,46222,462
34,46248,46272,46308,46340,46374,46423,46434,46441,46464,46480,46554,46560,46562,4493,4904,5351,5641,6059,8781,13658,41951,15352,42919,44072,22166,44893,45846,29472,45298,36357,33834,35505,36726,36970,38500,38814,40061,42099,40163,40284,40416,41421,41463,41520,41688,41930,41977,44261,43383,42134,42143,4
2177,42179,42196,42212,42368,42260,42395,42425,42473,42498,43414,42758,42835,45323,42953,42987,43076,43098,43116,43129,43131,43136,43220,43245,43250,432
60,43360,43397,43498,43461,43489,43540,43699,43613,43623,43642,43665,43720,43725,43835,43882,43898,45040,43919,43957,44046,44014,44067,44054,44160,44200
,44212,44246,44295,44274,44282,45010,44412,44428,44469,44476,44491,45120,44683,44541,44666,44619,44742,44790,44880,44887,44923,44937,44964,44991,45022,4
5146,45154,45185,45201,45233,45241,45292,45312,45362,45372,45404,45416,45451,45473,45626,45764,46612,45716,45719,45762,45828,45853,45860,46041,46140,461
52,46259,46229,46257,46273,46280,46309,46311,46353,46369,46535,46580,17388,24999,30816,32408,34569,34674,35295,35334,36553,37307,40566,41990,42001,42516
,43101,44170,44409,44819,45019,45343,46359,41950,41988,22002,46069,27277,44332,44909,34749,34935,37681,37898,40146,40741,40643,41345,41548,41704,41729,4
1805,41881,41939,42146,42320,42305,42342,42348,42427,42463,42480,42493,44177,42520,42610,42642,43146,43091,43032,43024,43064,43092,43232,43311,43369,434
64,43715,43649,43681,43732,43747,43755,43817,43863,43923,43925,44207,44091,44141,44289,44313,44315,44327,44333,44385,44421,44458,44594,44844,44709,44745
,44761,44990,44801,44803,44850,44878,44967,44924,45013,44956,44970,45006,45032,45089,45105,45122,45238,45280,45291,45296,45363,45431,45699,45620,45630,4
5641,45790,45879,45938,45943,46009,46013,46048,46051,46066,46067,46068,46070,46075,46095,46216,46235,46323,46274,46312,46322,46329,46360,46440,46611,247
2,3341,7440,15655,16157,21213,23754,23916,25777,29756,31608,33379,35547,36747,41486,39512,40298,40840,40854,41144,45912,41689,41343,41556,41499,41816,41
978,41984,42009,42859,42089,42190,42293,42294,42386,42316,42358,42373,42409,42444,42536,42701,42564,42569,42587,42598,42716,42751,42824,42850,42844,4292
5,44962,43066,43211,43166,43186,43207,43377,43322,43286,43345,43346,43379,43391,43405,43578,43427,43446,43950,43477,43497,43551,43554,43620,43617,43644,
43803,43752,43754,43779,43848,43939,43924,43935,44775,43989,43964,43974,43987,44060,44379,44198,44226,44227,44272,44279,44291,44309,44314,44329,44331,44
394,44470,44479,44553,44483,44707,44618,44728,44723,44744,44807,44814,44821,44842,44979,45014,45057,45102,45176,45283,46136,45261,45334,45361,45368,4541
7,45457,45464,45494,45577,45507,45532,45610,45589,45648,45651,45700,45705,45748,45751,45770,45785,45820,45826,45840,45942,45857,45892,45885,46058,45968,
45969,45989,45992,46001,46045,46050,46057,46111,46134,46082,46128,46103,46149,46198,46250,46254,46338,46298,46304,46381,46446,46405,46429,46447,46522,46
499,46510,46524,46558,46569,46587,46598,6830,25724,45518,41965,36843,39079,40504,41797,41903,41922,42168,42550,42565,42586,42726,42747,42783,42940,43007
,43019,43420,43108,44053,43316,43325,43347,43362,43425,43447,43473,45561,43596,43661,43749,43784,43859,44043,44088,44171,44554,44870,44919,45299,45490,4
5718,45823,45959,46016,46223,46245,46341,46509,12464,41945,22853,25010,33092,37719,38125,40121,40589,40593,40839,40838,41002,41049,41052,45734,41452,419
11,41921,41940,44593,42078,42094,42160,42458,42477,42752,42761,42763,42895,42883,42945,42959,42996,43035,43093,43096,43097,43138,43132,43200,43244,43269
,43366,43368,43445,43472,43510,43601,43605,43654,43696,43700,43738,43746,43856,43877,43938,43982,44023,44136,44365,44319,44363,44563,44585,45129,44722,4
4732,44768,44851,44926,45227,45381,45285,45428,45598,45843,45796,45861,45939,45962,46181,46243,46242,46263,46345,46386,46412,46461,46512,46527,30382,306
38,31190,31320,32224,34806,36181,37502,39112,40261,43659,43705,44155,44905,45936,46396,10789,25325,29842,37964,38021,38363,40563,41228,42277,43126,42920
,42967,44859,44876,46125,46540,15990,30058,37679,38181,39144,39169,40449,40531,40810,41056,41508,41589,41912,42172,42250,42891,42412,43689,43751,43921,4
4255,44494,44959,45440,45708,46029,46126,46500,46614,54,227,1430,4002,5479,9885,13407,17092,17565,17896,23528,24608,25399,26839,26975,28434,29138,31342,
33306,34446,43080,38339,39447,40332,40333,41724,43976,44000,44182,44256) GROUP BY t.id, t.poster, t.subject, t.last_post, t.last_post_id, t.last_poster,
 t.num_replies, t.closed, t.forum_id ORDER BY t.last_post DESC LIMIT 0, 30;

Looks pretty bad, doesn't it? And you know what, it's getting worse sad
Which query is this? May there be one way to improve it?

Re: Performance issues... What are these queries?

That's a search.php query
I'm not exactly sure what it's supposed to be doing that it needs such a large group by statement (and I'm not sure why the posts table needs to be joined in)

Re: Performance issues... What are these queries?

It's not pretty, I know. We're working on speeding it up.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

4

Re: Performance issues... What are these queries?

Who is this "we". When it comes to messing with queries you're on your own mate.

Re: Performance issues... What are these queries?

Paul wrote:

Who is this "we". When it comes to messing with queries you're on your own mate.

lol tongue

Oh, and I advise someone to put that into a code block...