Tweet
I keep getting them and my DB server is having troubles with it.
Rows_sent: 2280 Rows_examined: 16952
SELECT
thread.threadid, thread.forumid, post.userid
FROM thread AS thread
INNER JOIN post AS post ON(thread.threadid = post.threadid )
WHERE post.postid IN(247717,466494,861931,1072990,2000320,2000642,2000965,2001126,2001302,2001437,2001864,20 02156,2002504,2002886,2003236,2003359,2003489,2003881,2003897,2004107,2004148,2004164,2004 368,2004757,2005994,2006024,2006040,2006135,2006141,2006555,2007627,2007863,2007908,201272 0,2014131,2014158,2014508,2014846,2014934,2014956,2015068,2015111,2018109,2018479,2018895, 2019150,2019423,2020086,2020236,2022209,2022345,2022665,2022806,2023209,2023662,2024945,20 25261,2025943,2025952,2027240,2027353,2028969,2029068,2029193,2029196,2029251,2029315,2030 261,2030358,2030446,2030566,2031300,2031386,2031796,2032439,2032567,2032660,2033239,203351 2,2033561,2033669,2034103,2035002,2035200,2035537,2036732,2037183,2037362,2039911,2040096, 2040610,2040647,2041257,2041277,2041650,2043159,2043387,2044064,2044302,2044410,2046921,20 49061,2049082,2049206,2049343,2049762,2049789,2049945,2049975,2050005,2050091,2050174,2050 623,2051234,2051304,2051402,2052158,2052253,2052760,2053761,2053884,2054007,2054174,205443 9,2055971,2056180,2056366,2058571,2059245,2060905,2061231,2061245,2061636,2061973,2062150, 2063094,2063403,2063779,2064323,2064328,2066448,2067430,2068185,2068211,2068558,2068676,20 68692,2068787,2068847,2068908,2069291,2069589,2069636,2069916,2070107,2070646,2070881,2070 925,2071493,2072718,2072843,2075394,2076166,2076866,2077093,2077310,2077428,2077444,207746 8,2078103,2078142,2078751,2079442,2081399,2081533,2081582,2081711,2081770,2082025,2082046, 2083204,2083871,2083995,2084308,2084401,2084751,2085696,2086030,2086480,2086846,2088008,20 88014,2088584,2088956,2089081,2089162,2089530,2089867,2090173,2090541,2090777,2090915,2091 324,2091544,2091562,2092411,2092432,2093361,2094471,2096534,2100832,2101238,2101430,210150 8,2101745,2102694,2103032,2104531,2105039,2105464,2105574,2105776,2106914,2107062,2107067, 2107299,2108454,2108505,2108604,2110003,2110848,2112714,2112767,2113095,2113898,2114025,21 14971,2115618,2115648,2115767,2116174,2117671,2118162,2118224,2120442,2120475,2121005,2121 791,2122119,2122135,2122613,2122988,2123149,2123345,2123365,2123395,2124058,2125207,212526 3,2127842,2128090,2128211,2128380,2128383,2128403,2128655,2128728,2130068,2130481,2130746, 2131470,2132000,2132047,2132494,2133582,2134950,2135290,2136533,2136645,2136685,2136775,21 37193,2138112,2140446,2140592,2141934,2145074,2145300,2146276,2146350,2146691,2146746,2146 868,2148389,2149759,2149781,2149955,2149990,2150107,2150182,2150694,2151820,2152566,215323 1,2154073,2154093,2154379,2154718,2155094,2155448,2158860,2159133,2159692,2160468,2160709, 2160795,2161053,2161229,2161753,2162663,2164862,2164868,2165812,2165843,2166302,2166417,21 66747,2166769,2167533,2168639,2170847,2171020,2173124,2173330,2173855,2173887,2174204,2180 099,2181008,2181890,2183635,2184562,2184632,2184880,2184915,2186059,2186518,2186817,218713 4,2187306,2187790,2188070,2188230,2188682,2189925,2190227,2190284,2190290,2191593,2192047, 2192074,2192241,2192978,2193937,2193990,2194061,2194638,2195247,2195435,2195551,2195824,21 96643,2198632,2199249,2200332,2201300,2201724,2202356,2202479,2202826,2203394,2204238,2204 699,2205377,2205869,2205889,2206582,2207017,2209069,2209931,2211668,2211787,2212916,221298 5,2213833,2214148,2214468,2214748,2216178,2219280,2219501,2219666,2220285,2221183,2221606, 2221749,2222579,2223447,2227401,2227402,2227487,2227574,2227578,2227779,2228547,2228583,22 28998,2229022,2229510,2229572,2230300,2230971,2231677,2231808,2232164,2232225,2232312,2232 570,2233138,2233240,2233263,2233542,2236038,2236481,2237360,2237500,2238211,2238274,223835 7,2238415,2238847,2239165,2239237,2239498,2239785,2240100,2240942,2241002,2244447,2244448, 2244995,2244996,2245317,2245872,2246402,2248486,2248939,2248942,2249604,2251081,2251419,22 51998,2252161,2252237,2252425,2252686,2252773,2253170,2253203,2253397,2253439,2253900,2254 533,2254855,2255196,2255611,2256345,2256812,2257070,2257117,2258018,2260042,2261732,226211 0,2264775,2265452,2266183,2267149,2268068,2268246,2268265,2268296,2268333,2269189,2269517, 2269632,2269636,2269676,2270901,2271742,2271953,2272744,2273316,2274079,2274908,2275985,22 76008,2276022,2276104,2277098,2277304,2277449,2278155,2278162,2278824,2278911,2279815,2279 895,2281938,2282054,2283598,2284328,2285824,2286663,2286911,2286944,2287475,2287592,228828 4,2288363,2289465,2289482,2289703,2291078,2291845,2291956,2292179,2292448,2292660,2296886, 2297640,2298618,2298657,2298760,2300418,2301305,2301449,2301465,2301647,2302334,2303140,23 03342,2303873,2304047,2304158,2304643,2305020,2305216,2305725,2305892,2306579,2307312,2309 471,2310212,2310623,2310828,2311026,2311084,2311094,2312195,2314841,2314935,2315141,231744 4,2317630,2318856,2319649,2320119,2321193,2322408,2322468,2325201,2326191,2326264,2326354, 2327056,2327247,2329200,2330538,2330964,2331491,2331690,2332075,2332701,2332967,2335088,23 35595,2337880,2338486,2339421,2339440,2339443,2340008,2340824,2341278,2343231,2345129,2345 334,2346192,2346844,2347744,2348243,2348780,2348921,2349384,2349716,2349730,2349756,235006 9,2351247,2351339,2351508,2352196,2352735,2352786,2352963,2353590,2353774,2355709,2356548, 2356738,2357444,2358755,2359504,2360979,2360997,2361066,2361296,2361652,2362475,2362489,23 66840,2367617,2368900,2369289,2369662,2370764,2370777,2371242,2371272,2371713,2372085,2372 122,2372612,2376409,2376598,2377257,2377339,2378424,2378649,2378699,2378709,2378733,237900 2,2379020,2379436,2379939,2381199,2382632,2382639,2384592,2384784,2388698,2394127,23945
That list of numbers goes on forever.
What is this query?
Rows_sent: 2280 Rows_examined: 16952
SELECT
thread.threadid, thread.forumid, post.userid
FROM thread AS thread
INNER JOIN post AS post ON(thread.threadid = post.threadid )
WHERE post.postid IN(247717,466494,861931,1072990,2000320,2000642,2000965,2001126,2001302,2001437,2001864,20 02156,2002504,2002886,2003236,2003359,2003489,2003881,2003897,2004107,2004148,2004164,2004 368,2004757,2005994,2006024,2006040,2006135,2006141,2006555,2007627,2007863,2007908,201272 0,2014131,2014158,2014508,2014846,2014934,2014956,2015068,2015111,2018109,2018479,2018895, 2019150,2019423,2020086,2020236,2022209,2022345,2022665,2022806,2023209,2023662,2024945,20 25261,2025943,2025952,2027240,2027353,2028969,2029068,2029193,2029196,2029251,2029315,2030 261,2030358,2030446,2030566,2031300,2031386,2031796,2032439,2032567,2032660,2033239,203351 2,2033561,2033669,2034103,2035002,2035200,2035537,2036732,2037183,2037362,2039911,2040096, 2040610,2040647,2041257,2041277,2041650,2043159,2043387,2044064,2044302,2044410,2046921,20 49061,2049082,2049206,2049343,2049762,2049789,2049945,2049975,2050005,2050091,2050174,2050 623,2051234,2051304,2051402,2052158,2052253,2052760,2053761,2053884,2054007,2054174,205443 9,2055971,2056180,2056366,2058571,2059245,2060905,2061231,2061245,2061636,2061973,2062150, 2063094,2063403,2063779,2064323,2064328,2066448,2067430,2068185,2068211,2068558,2068676,20 68692,2068787,2068847,2068908,2069291,2069589,2069636,2069916,2070107,2070646,2070881,2070 925,2071493,2072718,2072843,2075394,2076166,2076866,2077093,2077310,2077428,2077444,207746 8,2078103,2078142,2078751,2079442,2081399,2081533,2081582,2081711,2081770,2082025,2082046, 2083204,2083871,2083995,2084308,2084401,2084751,2085696,2086030,2086480,2086846,2088008,20 88014,2088584,2088956,2089081,2089162,2089530,2089867,2090173,2090541,2090777,2090915,2091 324,2091544,2091562,2092411,2092432,2093361,2094471,2096534,2100832,2101238,2101430,210150 8,2101745,2102694,2103032,2104531,2105039,2105464,2105574,2105776,2106914,2107062,2107067, 2107299,2108454,2108505,2108604,2110003,2110848,2112714,2112767,2113095,2113898,2114025,21 14971,2115618,2115648,2115767,2116174,2117671,2118162,2118224,2120442,2120475,2121005,2121 791,2122119,2122135,2122613,2122988,2123149,2123345,2123365,2123395,2124058,2125207,212526 3,2127842,2128090,2128211,2128380,2128383,2128403,2128655,2128728,2130068,2130481,2130746, 2131470,2132000,2132047,2132494,2133582,2134950,2135290,2136533,2136645,2136685,2136775,21 37193,2138112,2140446,2140592,2141934,2145074,2145300,2146276,2146350,2146691,2146746,2146 868,2148389,2149759,2149781,2149955,2149990,2150107,2150182,2150694,2151820,2152566,215323 1,2154073,2154093,2154379,2154718,2155094,2155448,2158860,2159133,2159692,2160468,2160709, 2160795,2161053,2161229,2161753,2162663,2164862,2164868,2165812,2165843,2166302,2166417,21 66747,2166769,2167533,2168639,2170847,2171020,2173124,2173330,2173855,2173887,2174204,2180 099,2181008,2181890,2183635,2184562,2184632,2184880,2184915,2186059,2186518,2186817,218713 4,2187306,2187790,2188070,2188230,2188682,2189925,2190227,2190284,2190290,2191593,2192047, 2192074,2192241,2192978,2193937,2193990,2194061,2194638,2195247,2195435,2195551,2195824,21 96643,2198632,2199249,2200332,2201300,2201724,2202356,2202479,2202826,2203394,2204238,2204 699,2205377,2205869,2205889,2206582,2207017,2209069,2209931,2211668,2211787,2212916,221298 5,2213833,2214148,2214468,2214748,2216178,2219280,2219501,2219666,2220285,2221183,2221606, 2221749,2222579,2223447,2227401,2227402,2227487,2227574,2227578,2227779,2228547,2228583,22 28998,2229022,2229510,2229572,2230300,2230971,2231677,2231808,2232164,2232225,2232312,2232 570,2233138,2233240,2233263,2233542,2236038,2236481,2237360,2237500,2238211,2238274,223835 7,2238415,2238847,2239165,2239237,2239498,2239785,2240100,2240942,2241002,2244447,2244448, 2244995,2244996,2245317,2245872,2246402,2248486,2248939,2248942,2249604,2251081,2251419,22 51998,2252161,2252237,2252425,2252686,2252773,2253170,2253203,2253397,2253439,2253900,2254 533,2254855,2255196,2255611,2256345,2256812,2257070,2257117,2258018,2260042,2261732,226211 0,2264775,2265452,2266183,2267149,2268068,2268246,2268265,2268296,2268333,2269189,2269517, 2269632,2269636,2269676,2270901,2271742,2271953,2272744,2273316,2274079,2274908,2275985,22 76008,2276022,2276104,2277098,2277304,2277449,2278155,2278162,2278824,2278911,2279815,2279 895,2281938,2282054,2283598,2284328,2285824,2286663,2286911,2286944,2287475,2287592,228828 4,2288363,2289465,2289482,2289703,2291078,2291845,2291956,2292179,2292448,2292660,2296886, 2297640,2298618,2298657,2298760,2300418,2301305,2301449,2301465,2301647,2302334,2303140,23 03342,2303873,2304047,2304158,2304643,2305020,2305216,2305725,2305892,2306579,2307312,2309 471,2310212,2310623,2310828,2311026,2311084,2311094,2312195,2314841,2314935,2315141,231744 4,2317630,2318856,2319649,2320119,2321193,2322408,2322468,2325201,2326191,2326264,2326354, 2327056,2327247,2329200,2330538,2330964,2331491,2331690,2332075,2332701,2332967,2335088,23 35595,2337880,2338486,2339421,2339440,2339443,2340008,2340824,2341278,2343231,2345129,2345 334,2346192,2346844,2347744,2348243,2348780,2348921,2349384,2349716,2349730,2349756,235006 9,2351247,2351339,2351508,2352196,2352735,2352786,2352963,2353590,2353774,2355709,2356548, 2356738,2357444,2358755,2359504,2360979,2360997,2361066,2361296,2361652,2362475,2362489,23 66840,2367617,2368900,2369289,2369662,2370764,2370777,2371242,2371272,2371713,2372085,2372 122,2372612,2376409,2376598,2377257,2377339,2378424,2378649,2378699,2378709,2378733,237900 2,2379020,2379436,2379939,2381199,2382632,2382639,2384592,2384784,2388698,2394127,23945
That list of numbers goes on forever.
What is this query?
Comment