Announcement

Collapse
No announcement yet.

A few queries.... Help me out?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • A few queries.... Help me out?

    I am trying to track down the source of slow queries... I really just want to know if someone can tell me how they are being generated, or what they are doing... Scripts or by users/mods, etc....THanks!!


    First, I have this one... 25 seconds to execute... Yuck... Can anyone tell me how it is generated?

    PHP Code:
    # Time: 080624 18:56:27
    # Query_time: 25  Lock_time: 0  Rows_sent: 2  Rows_examined: 33857
    SELECT
                                                    thread
    .threadid
                                                    FROM thread 
    AS thread 

                                                    INNER JOIN post 
    AS post ON(thread.threadid post.threadid )
                                                    
    WHERE post.postid IN(52149,75469,107016,115519,136849,137278,139739,191336,194305,237165,238304,244221,249654,259909,263959,328970,365817,407286,412021,466998,473884,490340,506137,574726,617731,656071,677952,680522,693068,791800,825756,829864,849182,965940,1005288,1007753,1169109,1209911,1273106,1319551,1345344,1347951,1367568,1397229,1401263,1414942,1501460,1583540,1614568,1630083,1667119,1670755,1705590,1730153,1756810,1812702,1915947,1925775,2050836,2074385,2111752,2165812,2192094,2213353,2235360,2250134,2271560,2292112,2299406,2303684,2314704,2335014,2361391,2454964,2456462,2480242,2490901,2497625,2634831,2648636,2719447,2722393,2730695,2947610,3043928,3054496,3107387,3143820,3159964,3197617,3392869,3406335,3465600,3485004,3621455,3643753,3682923,3685323,3691038,3736764,3743620,3765110,3808134,3811359,3813825,3813958,3821321,3848775,3878405,3929353,3987527,3994993,4053397,4172901,4234260,4252844,4256386,4303548,4381239,4464749,4478353,4478358,4478361,4478363,4496535,4502728,4600674,4629712,4795104,4881086,4886075,4900557,4903056,4912137,5000951,5037422,5065082,5084108,5132721,5162282,5311719,5335459,5530673,5537580,5555732,5567185,5571151,5641243,5664372,5676900,5825994,5905641,5911574,5921877,6023774,6056526,6199443,6295083,6331382,6336121,6344410,6398534,6413814,6450302,6459370,6489767,6534173,6571809,6571895,6641754,6647362,6848133,6989883,7119385,7125027,7162814,7194727,7243187,7266777,7276647,7420443,7422540,7422670,7422834,7423322,7423454,7423627,7423713,7423812,7424894,7425759,7425786,7425862,7426022,7426997,7427594,7427750,7427971,7429773,7430950,7431841,7432589,7432663,7436254,7437189,7437203,7437222,7437522,7437793,7438061,7438777,7439957,7440411,7440788,7440799,7440861,7441103,7441152,7441498,7441920,7442006,7442251,7442288,7442329,7442381,7442433,7442515,7443338,7443432,7443599,7443911,7445911,7446817,7447506,7448839,7449000,7449034,7449089,7449331,7449401,7449515,7449616,7449626,7449823,7449880,7450120,7450217,7450341,7450725,7451007,7451119,7451276,7451329,7451350,7451409,7451449,7451460,7451485,7451531,7451638,7451740,7451950,7452071,7452135,7452421,7452706,7454215,7454915,7457550,7458141,7459261,7459639,7459642,7459692,7459745,7459813,7459937,7459976,7460055,7460114,7460250,7460333,7460398,7460412,7460453,7460511,7460576,7460581,7460638,7460740,7460807,7460981,7461013,7461158,7461264,7463671,7463689,7463708,7463875,7464252,7464478,7465347,7468624,7469968,7470258,7470454,7470499,7470643,7470688,7470900,7471073,7471361,7471398,7471471,7471496,7472075,7476833,7477123,7477278,7477333,7477596,7477752,7477791,7477885,7477889,7478615,7478962,7479887,7480056,7481923,7482268,7482758,7483271,7483581,7484074,7484319,7484521,7484853,7484891,7485210,7485243,7486876,7486891,7487202,7487806,7487905,7487948,7488075,7488151,7488243,7488338,7488393,7488414,7488553,7491631,7494530,7494561,7494811,7494859,7495078,7495196,7495241,7495496,7495644,7496177,7496477,7496507,7496724,7496781,7497222,7497441,7498249,7498779,7498975,7500101,7502203,7502744,7503164,7503602,7503746,7504161,7504162,7504995,7505305,7506197,7506386,7507431,7507630,7508685,7509982,7510344,7510365,7511387,7511857,7512230,7513794,7514795,7514822,7514843,7514868,7514910,7515150,7515162,7515220,7515582,7515672,7515734,7516111,7516866,7516978,7517569,7521113,7523099,7525201,7525511,7526678,7526956,7527117,7528031,7528222,7528447,7528473,7528499,7528716,7529275,7530091,7530096,7530131,7531344,7532016,7533941,7534623,7534632,7534895,7535631,7535694,7535742,7535778,7535849,7536123,7536264,7536339,7536378,7536494,7536643,7536709,7536788,7536899,7537157,7537201,7538159,7538363,7538530,7538639,7539799,7540051,7541369,7542560,7543213,7543275,7543292,7543415,7543981,7544266,7544734,7544737,7544946,7545059,7545386,7545426,7548579,7548852,7549302,7549547,7549727,7550262,7550751,7551190,7551264,7551538,7553110,7553185,7553207,7553340,7553378,7553420,7553510,7553572,7553603,7553650,7553660,7553696,7553699,7553707,7553708,7553720,7553796,7553816,7553822,7553823,7553847,7553895,7553926,7553960,7554006,7554026,7554050,7554069,7554070,7554091,7554097,7554102,7554125,7554138,7554153,7554157,7554161,7554177,7554186,7554211,7554225,7554229,7554245,7554255,7554297,7554429,7554484,7555840,7556255,7556383,7556466,7556468,7556823,7557107,7557203,7558512,7559926,7560162,7560590,7561852,7562144,7562325,7562498,7562730,7562773,7563578,7563614,7563757,7563813,7563841,7563893,7564077,7564247,7564425,7564455,7564475,7564585,7564655,7564683,7564814,7564962,7564984,7566187,7567765,7567788,7568182,7568238,7568258,7570751,7571094,7571150,7571257,7571327,7571878,7571924,7571926,7571996,7572084,7572609,7572628,7572897,7573081,7573177,7573478,7573553,7573626,7573742,7573898,7574050,7574112,7574193,7574299,7574303,7574334,7574356,7574408,7574604,7574757,7574823,7575167,7575488,7575604,7576339,7576938,7577227,7577344,7577751,7577830,7578328,7578429,7578638,7578660,7578946,7579217,7579363,7580051,7580070,7580285,7581072,7581349,7581481,7581491,7581554,7581697,7581862,7582086,7582087,7582471,7582503,7582736,7582822,7582828,7582850,7582859,7582878,7582894,7582974,7583067,7583840,7584201,7584257,7584464,7584650,7584677,7584692,7584741,7584794,7584898,7584966,7587174,7587222,7587281,7587944,7588220,7588338,7588796,7588867,7589075,7589078,7589119,7590121,7590155,7590254,7590379,7591179,7591645,7591778,7592238,7592320,7592442,7592617,7592682,7593273,7594013,7594408,7594454,7594628,7594639,7594664,7594795,7595045,7595283,7595508,7595587,7595600,7595626,7596363,7597243,7598766,7599436,7599558,7600682,7600719,7601872,7602224,7602728,7603426,7603861,7604095,7604948,7606383,7608603,7609197,7609288,7609580,7609643,7609653,7609663,7609833,7611035,7611048,7611161,7611488,7611942,7612122,7612237,7612304,7612439,7612481,7613135,7613340,7613979,7614547,7614783,7614830,7614949,7615103,7615151,7615155,7615215,7615257,7615334,7615352,7615428,7615547,7615704,7615829,7615872,7615923,7615937,7616001,7616088,7616101,7616273,7616327,7616365,7616444,7616490,7616529,7616612,7616676,7616685,7616731,7616801,7616815,7616818,7616820,7617213,7617568,7617749,7617886,7617953,7618017,7618304,7618409,7620420,7620496,7620549,7620639,7620658,7621240,7621290,7621355,7621378,7621449,7621470,7621525,7621551,7621591,7621713,7621737,7621808,7621864,7621915,7621976,7622024,7622070,7622092,7622100,7622164,7622178,7622211,7622249,7622292,7622328,7622337,7622440,7622447,7622498,7622506,7622556,7622763,7623319,7624382,7624454,7624737,7625940,7627044,7627134,7627169,7627255,7627305,7627479,7627742,7627790,7628187,7628207,7628620,7629467,7629844,7630180,7632090,7632113,7632233,7632341,7632351,7632372,7632401,7632506,7633311,7633364,7634431,7636928,7637833,7638258,7638446,7642284,7642373,7642425,7642515,7642647,7642675,7642756,7642772,7642868,7642871,7642892,7642914,7642923,7642930,7642992,7643301,7643350,7643457,7643572,7643598,7644056,7644111,7644218,7644579,7644626,7644644,7644760,7645056,7645123,7645183,7645287,7645349,7645484,7645546,7645578,7645778,7645818,7645856,7645885,7645917,7645945,7646014,7646182,7646216,7646253,7646331,7646743,7646990,7647041,7647803,7648382,7648603,7648638,7648675,7648779,7648834,7648900,7648934,7649051,7649184,7649253,7649368,7649441,7649475,7649517,7649557,7649581,7649605,7649637,7649659,7649714,7649805,7649836,7649837,7649848,7649855,7649867,7649926,7649930,7649959,7649965,7650017,7650043,7650056,7650074,7650098,7650149,7650154,7650189,7650219,7650222,7650243,7650247,7650315,7650317,7650354,7650403,7650442,7650446,7650522,7650565,7650592,7650646,7650683,7650689,7650984,7652356,7653752,7654161,7654316,7654364,7657243,7657900,7658055,7658617,7658697,7658852,7658882,7658918,7658945,7658995,7659013,7659103,7659107,7659146,7659170,7659194,7659208,7659262,7659336,7659353,7659384,7659386,7659417,7659418,7659503,7659511,7659519,7659544,7659560,7659571,7659635,7659653,7659695,7659743,7659771,7659789,7659889,7660125,7660339,7660346,7660473,7660627,7661560,7661561,7661687,7661945,7661951,7661966,7661985,7662559,7662598,7662631,7662655,7662667,7662695,7662760,7662808,7662837,7662856,7662890,7662900,7662909,7662938,7663050,7663082,7663432,7664053,7664167,7664285,7664385,7664559,7664591,7664680,7665005,7665031,7665452,7665570,7665572,7666692,7666716,7666756,7666960,7666980,7666985,7667295,7667387,7667453,7667473,7667507,7667632,7667781,7667869,7667895,7667908,7668261,7668287,7668421,7668550,7668619,7668645,7668826,7668886,7668893,7668982,7668994,7669057,7669183,7669256,7669260,7669300,7669356,7669382,7669515,7669588,7669633,7669671,7669802,7669806,7669878,7669946,7670030,7670210,7670249,7670429,7670464,7670518,7670719,7670780,7670986,7671715,7671744,7671774,7671844,7671962,7672051,7672080,7672108,7672138,7672215,7672412,7673206,7673437,7673466,7673537,7673544,7673571,7673606,7673720,7673741,7673802,7673846,7673906,7673989,7674034,7674074,7674123,7674153,7674255,7674291,7674314,7674402,7674601,7674786,7674798,7674845,7674893,7675051,7675194,7675270,7675369,7675403,7675538,7675581,7675596,7675610,7675655,7675675,7675703,7675737,7675761,7675788,7675790,7675797,7675838,7675841,7675845,7675891,7675901,7675906,7675931,7675957,7675984,7676009,7676012,7676014,7676035,7676037,7676063,7676118,7676145,7676215,7676246,7676262,7676300,7676307,7676309,7676316,7676325,7676330,7676339,7676342,7676395,7676421,7676512,7676535,7676570,7676620,7676686,7676767,7676785,7676859,7676915,7676935,7677038,7677082,7677173,7677229,7677287,7677327,7677364,7677393,7677493,7677527,7677543,7677580,7677591,7677613,7677648,7677718,7677791,7677828,7677883,7677927,7677961,7677974,7678021,7678062,7678088,7678228,7678273,7678381,7678481,7678525,7678687,7678748,7678836,7678975,7679198,7679200,7679231,7679292,7679316,7679500,7679598,7679605,7679646,7679681,7679743,7679798,7679822,7679898,7679911,7680038,7680627,7680759,7680829,7680858,7680902,7680942,7680987,7681055,7681072,7681115,7681154,7681214,7681220,7681325,7681343,7681387,7681692,7681752,7681800,7681850,7681902,7682198,7682416,7682613,7682737,7682746,7682856,7682917,7683212,7683398,7683536,7683821,7683918,7684445,7684585,7684977,7685211,7685290,7685437,7685606,7685731,7686189,7687028,7687308,7687381,7687980,7688130,7688222,7688842,7689040,7689502,7689663,7689695,7689705,7689721,7689761,7689782,7689867,7689911,7689985,7690127,7690156,7690178,7690243,7690321,7690480,7690599,7690742,7691258,7691288,7691314,7691413,7692132,7692378,7692551,7692689,7693074,7693122,7693272,7693287,7693297,7693375,7693438,7693462,7693465,7693534,7693552,7693659,7693708,7693869,7693871,7694073,7694125,7694578,7694694,7694862,7695097,7695328,7695559,7695794,7695847,7695901,7695998,7696045,7696092,7696093,7696114,7696246,7696288,7696297,7696451,7696484,7696577,7696825,7696854,7697058,7697111,7697128,7697227,7697374,7697515,7697572,7697633,7697685,7697730,7697818,7697850,7697875,7698079,7698185,7698524,7699477,7699799,7699812,7700003,7700086,7700200,7700606,7700641,7700721,7701165,7702007,7702627,7703137,7703166,7703182,7703313,7703533,7703548,7703563,7703613,7703697,7703776,7704009,7704360,7704548,7704960,7705286,7705428,7706431,7706967,7707277,7707387,7707594,7707602,7708523,7709760,7710388,7710475,7710521,7710768,7711074,7711200,7711289,7711381,7711407,7711520,7711547,7711639,7711663,7711670,7711702,7711718,7711852,7711898,7712115,7712438,7712474,7712698,7712769,7712794,7712919,7713220,7713255,7713312,7713449,7713535,7713633,7714094,7714234,7714840,7714905,7715166,7715920,7716595,7716937,7717176,7717372,7717812,7717841,7718136,7719248,7719821,7719902,7720250,7720433,7720883,7721226,7721234,7721266,7721323,7721431,7721571,7721643,7721694,7721744,7721766,7721776,7721826,7721878,7721898,7721910,7721941,7721977,7722078,7722132,7722238,7722273,7722313,7722330,7722358,7722377,7722474,7722478,7722570,7722585,7722622,7722703,7722738,7722839,7722864,7722910,7722926,7725334,7725447,7725698,7725749,7726402,7726694,7728121,7728317,7728365,7729602,7730278,7730676,7730681,7730736,7730890,7730947,7731053,7731084,7731174,7731376,7731391,7731607,7731644,7731654,7731726,7731794,7731818,7731828,7731961,7732059,7732173,7732215,7732232,7732233,7732283,7732309,7732383,7732482,7732761,7732888,7732917,7732949,7733003,7733060,7733075,7733146,7733255,7733363,7733412,7733482,7733993,7734058,7734383,7734428,7734474,7734616,7734978,7735012,7735303,7735477,7735528,7735542,7737263,7738803,7739364,7739400,7739436,7739445,7739457,7739460,7739518,7739519,7739537,7739664,7739707,7739760,7739913,7739960,7740201,7740306,7740980,7741047,7741152,7741235,7741455,7742222,7743039,7745083,7745201,7745527,7746557,7746933,7747047,7747193,7747273,7747425,7747454,7749553,7750587,7750646,7750954,7751282,7752066,7752186,7752376,7752446,7752480,7753340,7753430,7753653,7755421,7755820,7757254,7757333,7758211,7761260,7761788,7763851,7765944,7766458,7767696,7769642,7769664,7769749,7769833,7769993,7770027,7770728,7770744,7771003,7771120,7771192,7771282,7771509,7771955,7771994,7772181,7772767,7772943,7772959,7772982,7773157,7773312,7773726,7775584,7775787,7775953,7776173,7776281,7776913,7778229,7779149,7780702,7782038,7783324,7785766,7788796,7790433,7790798,7790844,7791709,7791944,7792004,7792589,7792662,7793037,7795207,7797715,7798762,7803284,7803903,7804966,7805280,7805316,7805341,7805728,7805738,7806038,7806820,7806934,7806952,7807432,7807441,7807619,7807646,7807794,7808321,7808340,7808428,7809410,7809446,7809515,7809527,7809539,7809678,7809991,7810377,7810625,7812482,7813017,7813353,7813734,7814129,7815977,7818557,7818650,7819010,7819084,7819376,7819458,7819560,7819651,7819692,7819814,7819947,7820042,7820365,7820575,7820582,7820688,7820926,7821185,7821870,7826631,7827426,7827542,7829087,7832621,7832770,7833045,7833266,7833516,7833725,7833910,7834053,7834103,7835465,7835619,7835666,7835773,7836037,7838130,7839247,7841248,7845424,7848009,7848699,7850110,7850958,7851364,7851419,7851462,7851587,7853291,7854080,7854499,7854744,7854821,7855181,7855238,7855348,7855491,7855702,7857315,7858586,7859011,7859494,7860619,7861567,7861625,7862011,7862202,7862269,7862501,7862726,7865125,7868556,7868637,7868930,7869032,7869056,7869129,7869199,7869251,7869314,7869486,7869506,7869578,7869635,7869820,7869939,7869994,7870117,7870140,7870764,7871819,7872164,7872208,7875425,7875525,7876010,7876027,7876059,7876272,7877161,7877545,7877616,7877698,7877734,7877848,7878378,7878459,7878738,7878951,7878960,7879829,7879831,7880110,7880221,7880295,7880409,7880443,7880601,7880609,7880711,7880878,7881004,7881105,7881113,7881115,7881133,7881152,7881232,7881514,7881734,7881899,7882123,7882761,7883887,7884304,7884346,7884400,7884528,7884621,7884851,7885118,7885212,7885246,7885586,7885624,7886131,7886151,7887968,7888329,7888406,7888510,7888531,7888569,7888660,7888896,7889091,7890319,7891003,7891077,7891141,7891616,7892768,7895554,7895573,7896509,7896552,7897144,7897278,7897506,7898629,7899566,7899826,7900020,7903014,7907843,7908578,7909024,7910661,7912215,7913601,7915250,7915280,7916028,7916311,7917829,7918571,7918903,7920026,7920150,7921883,7921887,7921964,7922028,7922226,7922250,7922370,7922459,7923567,7923620,7924540,7925267,7925271,7926334,7927331,7929356,7929393,7932022,7935031,7935657,7937239,7940488,7941131,7941268,7941836,7941870,7944067,7944081,7946168,7946200,7946362,7946640,7946751,7946881,7946944,7947053,7947121,7949023,7949125,7951756,7951811,7952381,7953038,7954140,7954201,7954276,7954302,7954492,7956084,7956609,7956720,7956831,7957341,7959656,7960457,7960765,7961042,7961603,7961612,7961835,7962209,7962286,7962348,7962440,7962695,7963564,7963762,7965607,7965661,7965819,7966955,7967084,7967315,7967406,7967451,7967859,7968197,7968327,7968907,7969018,7969162,7969684,7969800,7969960,7970310,7971455,7971738,7971952,7971997,7972222,7972669,7973339,7974238,7974524,7974569,7976154,7976488,7976526,7976870,7977065,7977095,7977184,7977233,7977611,7977707,7978020,7978032,7978766,7980692,7980788,7981309,7981902,7982661,7983173,7983931,7983948,7983972,7984012,7984036,7984207,7984295,7985747,7985982,7986044,7986272,7986538,7986734,7987595,7991247,7991836,7991877,7991919,7991990,7992007,7992483,7992995,7993015,7993600,7994101,7995597,7995728,7998132,7998971,7999526,8001035,8001899,8001909,8002389,8002434,8002782,8003083,8003137,8003145,8003191,8003756,8003795,8004489,8005359,8005437,8006218,8006225,8006670,8006871,8007402,8007777,8010105,8010468,8010788,8010869,8012144,8012706,8012730,8013143,8013360,8014024,8014564,8014890,8015295,8015942,8016157,8016413,8016527,8016559,8016563,8016935,8017647,8018000,8018702,8019182,8021757,8021845,8022826,8023207,8023246,8023253,8023381,8024040,8024532,8024585,8025248,8025461,8026609,8027145,8027214,8027469,8028437,8028896,8029152,8029549,8029911,8029940,8030136,8030295,8030470,8031399,8032349,8032570,8032781,8032885,8033163,8033205,8033280,8033317,8033320,8033448,8033676,8033832,8033985,8034186,8034701,8034734,8035104,8035212,8037071,8037200,8037605,8037661,8037976,8038079,8038084,8038131,8038191,8038194,8038522,8038538,8038544,8038581,8039081,8039692,8039940,8039986,8040287,8040407,8040538,8040865,8041501,8041584,8041744,8043052,8043070,8043432,8043472,8044084,8044089,8044126,8044168,8044182,8044222,8044328,8044405,8044502,8044583,8044643,8044697,8044739,8044798,8044800,8044874,8044914,8044922,8044970,8045008,8045028,8045070,8045087,8045591,8045675,8045788,8045865,8045902,8045966,8046007,8047054,8047108,8047312,8049272,8050484,8050509,8050601,8050866,8051194,8051332,8052069,8052146,8052224,8052586,8052650,8052699,8052713,8052720,8052722,8052802,8052858,8052885,8052906,8052911,8052927,8052930,8053020,8053125,8053274,8053280,8053281,8053314,8053382,8053408,8053423,8053435,8053482,8053503,8053533,8053543,8053567,8053623,8053688,8053905,8053940,8053999,8054016,8054045,8054100,8054194,8054223,8054387,8054472,8054586,8054687,8054741,8056384,8056583,8056664,8056960,8057605,8057805,8057807,8057809,8057818,8057859,8057875,8057891,8057909,8057951,8057995,8058152,8058201,8058287,8058349,8058373,8058401,8058470,8058507,8058581,8058726,8058735,8058834,8058867,8058873,8058931,8058935,8059007,8059140,8059147,8059197,8059208,8059294,8059366,8059421,8059517,8059521,8059612,8059695,8059793,8059980,8061977,8062505,8062983,8063104,8063345,8065984,8066073,8066430,8066735,8066857,8066903,8067055,8067094,8067187,8067194,8067226,8067236,8067255,8067277,8067364,8067386,8067396,8068100,8068190,8068407,8068781,8068873,8069700,8069780,8069830,8069899,8070027,8070231,8070236,8070362,8070426,8070503,8070567,8070624,8070662,8070707,8070719,8070817,8070928,8070985,8071155,8071212,8071442,8071537,8071555,8071583,8071652,8071713,8071748,8071822,8071948,8072088,8072269,8072343,8072520,8072559,8072579,8072608,8072654,8072776,8072794,8072990,8073206,8073312,8073330,8073434,8073478,8073483,8073541,8073552,8073590,8073651,8073707,8073716,8073739,8073741,8073824,8073899,8074329,8074696,8074753,8074878,8075602,8075718,8075824,8076083,8076259,8076317,8076333,8076466,8076511,8076594,8076657,8076766,8076787,8076889,8076985,8077016,8077092,8077135,8077416,8077428,8077453,8077531,8077605,8077759,8077881,8077994,8078061,8078153,8079139,8079189,8079233,8079249,8079343,8079464,8079507,8079709,8079807,8079868,8079874,8079916,8079938,8079975,8079995,8080046,8080048,8080076,8080182,8080213,8080218,8080272,8080305,8080332,8080443,8080525,8080619,8080637,8080677,8080697,8080720,8080773,8080797,8080878,8080957,8081016,8081217,8081797,8081872,8082179,8082254,8082384,8082632,8082703,8082806,8082856,8083229,8083439,8083572,8083584,8083609,8083748,8083836,8083939,8083948,8083982,8083993,8084447,8084505,8084616,8084860,8085394,8085738,8085805,8086204,8086628,8087838,8088802,8089610,8089656,8089710,8089769,8090225,8090281,8090374,8090461,8090605,8090754,8090786,8090795,8090911,8090929,8090980,8091000,8091041,8091056,8091079,8091193,8091225,8091421,8091469,8091961,8092561,8092573,8092647,8092899,8094076,8094488,8096140,8096459,8096783,8096850,8096858,8096905,8096910,8096936,8097103,8097120,8097156,8097198,8097267,8097386,8097403,8097450,8097485,8097500,8097543,8097550,8097649,8097708,8097744,8097745,8097775,8097797,8097799,8097813,8097814,8097821,8097825,8097863,8097866,8097873,8097912,8097966,8097970,8097983,8097990,8097991,8097996,8098011,8098021,8098058,8098094,8098112,8098115,8098146,8098183,8098220,8098247,8098295,8098323,8098354,8098362,8098374,8098394,8098505,8098654,8098705,8098727,8098790,8098855,8098951,8098980,8099075,8099126,8099207,8099227,8099383,8099481,8099645,8099694,8099696,8099750,8099779,8099801,8099892,8099902,8099913,8099968,8099995,8100015,8100044,8100112,8100149,8100199,8100261,8100303,8100336,8100369,8100392,8100402,8100426,8100535,8100620,8100645,8100712,8100738,8100823,8100862,8100931,8100943,8100980,8101003,8101039,8101114,8101150,8101184,8101195,8101197,8101213,8101219,8101223,8101249,8101263,8101284,8101369,8101522,8101577,8101592,8101660,8101670,8101710,8101758,8101767,8101775,8101783,8101881,8101902,8101972,8102008,8102030,8102087,8102142,8102153,8102209,8102414,8102494,8102518,8102715,8102756,8103587,8104204,8104232,8104378,8104408,8104415,8104539,8104692,8104750,8104860,8104902,8105036,8105101,8105112,8105138,8105195,8105197,8105295,8105368,8105420,8105460,8105540,8105575,8105605,8105611,8105616,8105676,8105923,8105980,8106225,8106263,8106396,8107103,8107394,8107466,8107568,8107647,8107654,8107715,8107868,8107907,8108000,8108057,8109215,8110179,8110496,8110552,8110909,8111049,8111259,8111515,8112165,8112226,8112318,8112438,8112469,8112497,8113180,8114873,8115587,8115771,8116352,8116723,8117257,8117538,8118245,8118353,8118901,8119432,8119827,8119935,8119967,8119997,8120063,8120123,8120395,8120543,8120903,8121097,8122496,8122855,8122870,8123052,8123087,8123116,8123119,8123200,8123284,8123286,8123379,8123451,8123579,8123782,8124036,8124225,8124370,8125253,8126386,8126496,8126554,8126597,8126750,8126797,8126923,8127066,8127174,8127312,8127476,8127548,8127703,8127770,8127780,8127837,8127941,8128004,8128028,8128173,8128193,8128214,8128221,8128337,8128341,8128481,8128483,8128512,8128673,8128802,8128829,8128893,8129276,8129336,8129352,8129560,8129629,8129776,8129848,8129926,8130027,8130142,8130166,8130272,8130526,8130580,8130733,8131063,8131236,8131298,8131337,8131454,8131614,8131710,8132651,8132789,8133074,8133145,8135004,8136001,8136392,8137531,8137547,8137669,8139957,8140681,8142501,8142520,8142786,8143005,8143276,8144345,8145662,8146621,8146768,8146936,8147092,8147295,8147388,8147443,8147988,8148057,8148147,8148195,8148216,8148276,8148333,8148405,8148470,8148475,8148501,8148537,8148545,8149019,8149096,8149342,8149623,8149729,8149748,8149827,8150635,8150726,8150748,8150841,8150985,8151141,8151193,8151255,8151333,8151349,8151423,8151451,8151469,8151482,8151720,8152197,8152216,8153435,8153524,8153549,8154031,8154080,8154090,8154201,8154216,8154261,8154277,8154315,8154480,8154492,8154563,8154608,8154727,8154969,8155061,8155131,8155231,8155258,8155342,8155373,8155388,8155391,8155438,8155895,8157130,8157276,8158970,8159002,8159443,8161375,8161524,8164230,8164893,8164930,8166326,8166614,8166714,8166762,8166780,8166842,8168603,8171359,8171625,8172286,8172783,8172831,8173113,8173818,8173876,8173982,8174043,8174462,8174589,8174680,8176611,8177274,8178536,8178610,8178663,8178736,8178950,8179235,8179754,8180312,8180654,8181162,8181567,8181732,8181964,8182245,8183727,8184935,8185533,8186719,8187295,8187572,8187613,8187709,8188754,8188871,8189734,8189745,8189789,8190062,8192245,8193124,8193159,8193841,8194123,8194286,8194454,8194897,8198488,8200041,8200243,8201197,8201747,8202262,8203813,8204305,8204773,8208241,8208655,8208934,8209472,8209475,8209611,8209690,8209708,8209789,8210280,8210420,8213116,8215983,8218379,8218946,8219821,8219876,8219998,8221079,8221188,8221971,8225859,8227046,8227812,8227855,8229038,8230053,8230733,8231173,8231363,8236205,8236449,8237167,8237370,8237416,8237603,8238081,8238112,8238631,8238703,8238855,8239341,8239438,8239558,8239597,8239641,8239678,8239698,8239866,8239996,8240627,8241048,8241508,8241551,8242609,8243297,8243368,8243497,8243715,8244115,8244225,8244227,8244259,8244288,8244479,8245056,8245274,8245299,8245417,8245472,8245525,8245621,8245660,8245730,8245763,8245881,8245912,8245969,8245988,8246062,8246125,8246280,8246415,8246644,8246655,8246955,8248953,8249704,8249809,8250227,8250305,8250594,8250814,8250962,8251517,8251939,8252888,8252941,8253084,8253968,8254188,8254335,8254498,8256451,8256806,8257451,8259901,8259980,8260267,8260386,8260630,8263067,8263195,8263940,8264095,8265407,8265516,8266331,8266576,8266808,8266891,8268049,8268328,8268714,8271256,8271470,8271740,8272083,8272800,8273008,8273548,8273893,8274167,8274389,8274528,8274976,8275139,8278068,8278467,8278625,8278835,8281998,8283539,8283626,8285108,8285886,8285958,8286073,8286188,8286242,8286275,8286276,8286342,8286348,8286392,8286400,8286454,8286490,8286558,8286626,8286665,8286734,8286809,8286904,8286966,8286990,8287326,8287353,8287439,8287493,8287495,8287540,8287550,8287604,8287670,8287682,8287690,8287771,8287824,8287890,8288254,8288503,8288729,8288935,8289047,8289255,8289414,8289417,8289431,8289455,8289461,8289497,8289537,8290013,8290040,8291404,8291866,8291906,8292578,8292668,8292885,8292939,8293051,8293247,8293272,8293338,8293591,8293871,8294045,8294617,8295284,8296241,8296572,8296589,8296718,8296740,8296939,8297003,8297844,8298129,8298301,8298432,8298696,8298879,8299266,8299581,8301173,8301857,8302176,8302286,8302769,8304327,8304388,8304553,8307359,8308120,8308180,8308255,8308317,8308322,8308408,8308458,8308513,8308614,8308628,8310658,8310690,8310879,8311473,8312115,8312388,8313334,8313820,8313982,8314136,8314853,8315056,8315984,8316069,8316104,8317985,8319194,8319488,8322893,8323674,8324124,8326440,8326773,8329547,8329557,8329687,8329700,8332126,8332503,8332655,8332691,8332728,8332794,8332833,8332896,8332918,8332982,8333289,8333362,8333524,8333894,8334426,8334641,8335433,8335588,8335776,8335933,8336301,8337260,8337689,8337775,8337911,8338003,8338071,8338233,8338482,8339412,8339856,8343628,8344050,8344819,8344939,8346234,8346450,8347018,8347738,8347824,8348475,8348498,8348686,8348746,8348770,8348791,8349208,8349273,8351912,8355204,8356500,8357194,8357517,8357535,8357711,8357723,8357975,8358558,8358708,8358820,8358903,8359584,8359646,8359659,8359788,8360152,8360354,8362814,8365494,8366260,8366896,8367549,8368139,8368193,8368203,8368467,8368977,8369068,8369258,8371594,8373818,8376175,8377189,8377197,8377906,8380365,8383372,8383534,8383593,8383662,8383766,8383820,8383919,8383942,8383966,8383977,8383992,8384007,8384015,8384072,8384933,8387742,8387855,8388250,8389181,8391327,8391381,8391382,8391506,8391757,8392430,8395587,8397947,8399565,8402021,8402529,8402827,8402998,8403094,8403283,8404153,8404851,8405292,8405684,8405832,8406047,8406256,8407889,8408527,8408548,8409067,8410495,8410519,8410598,8410774,8411102,8411694,8411813,8411964,8412413,8412550,8412608,8412704,8413022,8413099,8413218,8414050,8414082,8414252,8415063,8416087,8416252,8416370,8416811,8417178,8417934,8418058,8418186,8418223,8418295,8418341,8418446,8418526,8418765,8418821,8419022,8419048,8419059,8419133,8419171,8419183,8419383,8419513,8419526,8419589,8419637,8419801,8420165,8420227,8420269,8420380,8420443,8420463,8420500,8420564,8420603,8420626,8420679,8420704,8420772,8421655,8421992,8422090,8422558,8422655,8422763,8422966,8423316,8423841,8424185,8424404,8424614,8424757,8426364,8426869,8427505,8427711,8428158,8428635,8431193,8431272,8433292,8433565,8433600,8433836,8434490,8434958,8435631,8435773,8436006,8436196,8436508,8436936,8436955,8438898,8439079,8439083,8439503,8439694,8439934,8439978,8440333,8441119,8441758,8442828,8442960,8443609,8443723,8443772,8444443,8444573,8444677,8444781,8445072,8449350,8449445,8450619,8455753,8457504,8457630,8459854,8461128,8461473,8461851,8463445) AND thread.forumid IN(191) AND post.visible 1
    Second one... I think this has to do with the editlog (which I thought I had turned off, but maybe someone can clue me in?

    PHP Code:
    # Time: 080624 18:31:35
    # Query_time: 16  Lock_time: 0  Rows_sent: 1  Rows_examined: 115718
    SELECT 
                                            modtable
    .usergroupid as modgroup,
                                            
    modtable.username as moderator,
                                            
    editlog.postid as postid,
                                            
    editlog.reason as reason,
                                            
    editlog.dateline as dateline,
                                            
    editlog.userid as modid,
                                            
    post.threadid as threadid,
                                            
    forum.forumid as forumid,
                                            
    thread.title as threadtitle,
                                            
    forum.title as forumtitle,
                                            
    post.title as action
                                    FROM editlog 
    as editlog
                                    LEFT JOIN post 
    as post ON (post.postid editlog.postid)
                                    
    LEFT JOIN thread AS thread ON (thread.threadid post.threadid
                                    
    LEFT JOIN user AS modtable ON (modtable.userid editlog.userid
                                    
    LEFT JOIN forum AS forum ON (forum.forumid thread.forumid)
                                    
    WHERE 
                                    post
    .userid 4395 AND post.userid != editlog.userid AND 1214346679-editlog.dateline <2592000 AND modtable.usergroupid IN (5,6,7
                                    
    ORDER BY editlog.dateline DESC
                                    LIMIT 10

    Third one... mod log?

    PHP Code:
    # Time: 080624 18:06:15
    # Query_time: 11  Lock_time: 0  Rows_sent: 10  Rows_examined: 6977119
    SELECT 
                                    modtable
    .username as moderator
                                    
    modtable.usergroupid as modgroup,
                                    
    modlog.userid as modid,
                                    
    modlog.action as action
                                    
    modlog.type as type,
                                    
    modlog.dateline as dateline,
                                    
    modlog.threadid as threadid,
                                    
    modlog.postid as postid,
                                    
    forum.forumid as forumid,
                                    
    thread.title as threadtitle,
                                    
    forum.title as forumtitle
                                    
    deletionlog.reason as delreason
                            FROM moderatorlog 
    AS modlog
                            LEFT JOIN user 
    AS modtable ON (modtable.userid modlog.userid
                            
    LEFT JOIN thread AS thread ON (thread.threadid modlog.threadid
                            
    LEFT JOIN post AS post ON (post.postid modlog.postid)
                            
    LEFT JOIN forum AS forum ON (forum.forumid thread.forumid)
                            
    LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = IF(deletionlog.type 'post'modlog.postidmodlog.threadid))
                            
    WHERE 
                            
    IF(modlog.postid,post.userid=15234,thread.postuserid=15234) AND modlog.type !=20 AND modtable.userid != 15234  AND modlog.type NOT IN (11,12,29)  AND 1214345164-modlog.dateline <2592000 AND modtable.usergroupid IN (5,6,7
                            
    ORDER BY dateline DESC
                            LIMIT 10

    Webkinz

  • #2
    The first is used in searching.

    The second two reference tables that aren't present in a default vBulletin installation, modlog and modtable. They are probably from some addon.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment


    • #3
      Originally posted by Wayne Luke View Post
      The first is used in searching.

      The second two reference tables that aren't present in a default vBulletin installation, modlog and modtable. They are probably from some addon.
      Thanks much. So let's forget the second two. I think I know where those are now that you told me that part. In the first one. What type of search is this?
      Webkinz

      Comment


      • #4
        Standard search results where a user types something into the search form. They were searching for something in forum 191 and this is the list of posts that contain the words they were searching for.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment


        • #5
          It is also worthwhile to note that the result set returned contained approximately 3460 posts to scan. This is quite a large amount of post to check:
          1) whether or not the thread housing it is in a specific forum
          and 2) whether or not it is visible (IE: not soft deleted)

          The visible part should be quite straight forward as it is on the same record; but the thread requires lookup in another table, which is probably why it took so long.

          You may help prevent getting this much search results if you make the minimum search length a bit longer. You can do this in Admin CP > vBulletin Options > Message Searching Options > Search Index Minimum Word Length. I personally have mine set to 6 characters (so small words like "words" cannot be searched), and so the results are more specific. It does, however, cause problems for people trying to search things that are short, and genuinely to their interest -- IE: in my site's case "iPhone", for example. Which is why I modified my templates and added Google CSE: http://www.google.com/coop/cse/ to allow people to search via Google instead. The trade off is that then they cannot limit search results in specific forums, and they cannot search private forums where CSE cannot index. But I think it helps the server loads, so I deem it as a work-able work around solution.

          Additionally, you can probably also reduce the numbers of results it needs to look up (w/o tracing the code manually, I'm not sure of the order of the filters) by adjusting this setting: Admin CP > vBulletin Options > Message Searching Options > Maximum Search Results to Return.
          Best Regards,
          Andy Huang

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X