SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
post.message, post.attach_count,
NULL AS thread_read_date,
0 AS user_post_count,
permission.cache_value AS node_permission_cache
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_post AS post ON
(post.post_id = thread.first_post_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)
WHERE thread.thread_id IN (9683089, 9683048, 9682808, 9681298, 9680840, 9675122, 9675051, 9672453, 9671332, 9666516, 9666515, 9666514, 9666513, 9666512, 9666183, 9666178, 9666176, 9666175, 9662866, 9662654, 9662653, 9662652, 9662651, 9662650, 9662649, 9660557, 9660076, 9659254, 9659074, 9658849, 9657757, 9656530, 9650822, 9650588, 9650400, 9650371, 9650328, 9650320, 9650233, 9649430, 9649294, 9649218, 9648962, 9644983, 9640510, 9625652, 9617789, 9617788, 9617787, 9617785, 9614330, 9613689, 9611631, 9611168, 9603731, 9602273, 9601951, 9596713, 9586785, 9577169, 9576037, 9575522, 9572801, 9566796, 9566031, 9565546, 9559983, 9556146, 9556145, 9556144, 9556034, 9555232, 9552333, 9549920, 9547995, 9547638, 9547275, 9546020, 9543041, 9542571, 9542555, 9541025, 9539094, 9532547, 9532546, 9532361, 9526411, 9496169, 9491053, 9490990, 9490956, 9490927, 9490897, 9489195, 9489135, 9489030, 9485843, 9485840, 9485705, 9485704, 9483879, 9479379, 9468920, 9462987, 9462984, 9447267, 9444626, 9443608, 9443598, 9443191, 9439719, 9437700, 9437517, 9435424, 9435423, 9435178, 9435174, 9434903, 9432466, 9431634, 9430419, 9426281, 9425324, 9425307, 9419599, 9415406, 9410907, 9407851, 9407555, 9403487, 9402915, 9402914, 9401938, 9401932, 9399892, 9399886, 9399510, 9399496, 9399309, 9399029, 9399025, 9398907, 9398849, 9397896, 9397490, 9396458, 9396143, 9395570, 9395400, 9393507, 9391685, 9391684, 9386947, 9382943, 9380225, 9378407, 9378404, 9378405, 9376284, 9376264, 9374625, 9374622, 9374621, 9373692, 9369854, 9369853, 9367626, 9367604, 9363774, 9361095, 9357318, 9357315, 9357308, 9357305, 9357301, 9350038, 9349254, 9343090, 9342399, 9342370, 9342369, 9340975, 9340177, 9329825, 9326863, 9326862, 9326149, 9326147, 9326144, 9326141, 9326136, 9326135, 9326134, 9325616, 9325005, 9323201, 9323185, 9321693, 9320568, 9320543, 9320038, 9320032, 9319526, 9319518, 9319513, 9319501, 9319474, 9317425, 9313147, 9312521, 9310412, 9309773, 9304266, 9304265, 9300274, 9293879, 9293488, 9293487, 9290401, 9290205, 9282689, 9275432, 9275405, 9275404, 9275403, 9275361, 9271244, 9259420, 9259334, 9256965, 9253286, 9252130, 9249641, 9238724, 9227519, 9219064, 9218468, 9218463, 9216108, 9216107, 9211739, 9205881, 9205119, 9204766, 9204438, 9204085, 9203991, 9202642, 9200483, 9199088, 9198007, 9197208, 9178218, 9171623, 9171620, 9170278, 9170073, 9163356, 9132855, 9129402, 9127229, 9121401, 9119012, 9117167, 9116846, 9115189, 9113968, 9112743, 9112741, 9112738, 9111966, 9087954, 9085587, 9077493, 9072685, 9067414, 9061283, 9060022, 9042151, 9040975, 9037770, 9035491, 9033721, 9012174, 9007092, 9006075, 8990082, 8990076, 8986053, 8982250, 8982249, 8981677, 8981676, 8981674, 8981666, 8979030, 8978263, 8946279, 8944957, 8944944, 8941312, 8916948, 8916947, 8913938, 8911159, 8909121, 8908879, 8908878, 8908877, 8906739, 8903287, 8902612, 8902610, 8902609, 8884942, 8884939, 8877673, 8869494, 8862383, 8859132, 8857352, 8856809, 8853441, 8845243, 8845242, 8845241, 8845240, 8845239, 8820514, 8810921, 8808681, 8808680, 8807996, 8807995, 8803354, 8803353, 8803352, 8802484, 8802483, 8792477, 8783476, 8773465, 8758538, 8758519, 8757957, 8755709, 8755708, 8754111, 8754109, 8753927, 8745819, 8745818, 8734381, 8734380, 8728212, 8724237, 8723635, 8715669, 8711732, 8711730, 8709478, 8709477, 8706700, 8705741, 8705102, 8704827, 8694411, 8684092, 8660547, 8652822, 8651457, 8646269, 8643148, 8641620, 8640936, 8640707, 8635936, 8629018, 8628808, 8604731, 8604730, 8596777, 8593675, 8578935, 8575428, 8557665, 8552316, 8539624, 8528301, 8520930, 8519749, 8506177, 8505594, 8492475, 8488330, 8485560, 8477045, 8477018, 8476929, 8476928, 8473416, 8468687, 8468686, 8468684, 8454628, 8454626, 8447052, 8444862, 8444665, 8426320, 8424507, 8413374, 8407617, 8391640, 8391623, 8388919, 8388304, 8388279, 8387365, 8374896, 8370774, 8364902, 8342906, 8330725, 8313319, 8287838, 8284521, 8275917, 8257621, 8257372, 8255953, 8251720, 8237181, 8237151, 8211349, 8155463, 8137028, 7907837, 7870387, 7709334, 7479035, 7477658, 7353773, 7325492, 7126509)
Run Time: 0.014926
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 445 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,5s_db1.thread.node_id | 1 | Using where |
INSERT INTO `xf_search` (`search_results`, `result_count`, `search_type`, `search_query`, `search_constraints`, `search_order`, `search_grouping`, `user_results`, `warnings`, `user_id`, `search_date`, `query_hash`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: [["tinhte_xentag_forum",158],["tinhte_xentag_forum",159],["thread",9683089],["thread",9683048],["thread",9682808],["thread",9680840],["thread",9675122],["thread",9675051],["thread",9672453],["thread",9671332],["thread",9666516],["thread",9662866],["thread",9660557],["thread",9660076],["thread",9659254],["thread",9659074],["thread",9658849],["thread",9656530],["thread",9650822],["thread",9650588],["thread",9650400],["thread",9650371],["thread",9650328],["thread",9650320],["thread",9650233],["thread",9649430],["thread",9649294],["thread",9649218],["thread",9648962],["thread",9640510],["thread",9625652],["thread",9617789],["thread",9614330],["thread",9611631],["thread",9602273],["thread",9601951],["thread",9596713],["thread",9586785],["thread",9576037],["thread",9575522],["thread",9572801],["thread",9566796],["thread",9566031],["thread",9565546],["thread",9556034],["thread",9552333],["thread",9549920],["thread",9547995],["thread",9547638],["thread",9546020],["thread",9543041],["thread",9542571],["thread",9542555],["thread",9541025],["thread",9539094],["thread",9532547],["thread",9532361],["thread",9526411],["thread",9496169],["thread",9491053],["thread",9490956],["thread",9490927],["thread",9490897],["thread",9489195],["thread",9489135],["thread",9489030],["thread",9485843],["thread",9485705],["thread",9483879],["thread",9468920],["thread",9462987],["thread",9447267],["thread",9444626],["thread",9443608],["thread",9443191],["thread",9437517],["thread",9435424],["thread",9431634],["thread",9430419],["thread",9426281],["thread",9419599],["thread",9415406],["thread",9410907],["thread",9407851],["thread",9407555],["thread",9403487],["thread",9402915],["thread",9401938],["thread",9401932],["thread",9399892],["thread",9399886],["thread",9399510],["thread",9399496],["thread",9399309],["thread",9399029],["thread",9399025],["thread",9398907],["thread",9398849],["thread",9397896],["thread",9397490],["thread",9396458],["thread",9396143],["thread",9395570],["thread",9395400],["thread",9391685],["thread",9378407],["thread",9376264],["thread",9374625],["thread",9373692],["thread",9369854],["thread",9367626],["thread",9367604],["thread",9361095],["thread",9357318],["thread",9357315],["thread",9357308],["thread",9357305],["thread",9357301],["thread",9349254],["thread",9343090],["thread",9342399],["thread",9342370],["thread",9329825],["thread",9325616],["thread",9325005],["thread",9323201],["thread",9323185],["thread",9321693],["thread",9320568],["thread",9320543],["thread",9320038],["thread",9320032],["thread",9319526],["thread",9319518],["thread",9319513],["thread",9319501],["thread",9319474],["thread",9312521],["thread",9309773],["thread",9300274],["thread",9293879],["thread",9293488],["thread",9290401],["thread",9290205],["thread",9282689],["thread",9275432],["thread",9275405],["thread",9275361],["thread",9252130],["thread",9249641],["thread",9219064],["thread",9218468],["thread",9218463],["thread",9211739],["thread",9205881],["thread",9205119],["thread",9204766],["thread",9204438],["thread",9204085],["thread",9202642],["thread",9200483],["thread",9199088],["thread",9198007],["thread",9197208],["thread",9178218],["thread",9171620],["thread",9163356],["thread",9129402],["thread",9127229],["thread",9117167],["thread",9115189],["thread",9111966],["thread",9087954],["thread",9077493],["thread",9061283],["thread",9060022],["thread",9042151],["thread",9033721],["thread",9007092],["thread",8990082],["thread",8986053],["thread",8982250],["thread",8981666],["thread",8979030],["thread",8946279],["thread",8944957],["thread",8944944],["thread",8941312],["thread",8916948],["thread",8908879],["thread",8906739],["thread",8884942],["thread",8877673],["thread",8862383],["thread",8859132],["thread",8857352],["thread",8853441],["thread",8808681],["thread",8807996],["thread",8803354],["thread",8802484],["thread",8792477],["thread",8758538],["thread",8758519],["thread",8755709],["thread",8745819],["thread",8728212],["thread",8724237],["thread",8723635],["thread",8706700],["thread",8705102],["thread",8704827],["thread",8651457],["thread",8646269],["thread",8640936],["thread",8640707],["thread",8635936],["thread",8629018],["thread",8628808],["thread",8604731],["thread",8596777],["thread",8593675],["thread",8578935],["thread",8575428],["thread",8557665],["thread",8552316],["thread",8539624],["thread",8528301],["thread",8520930],["thread",8519749],["thread",8506177],["thread",8505594],["thread",8492475],["thread",8488330],["thread",8477045],["thread",8477018],["thread",8473416],["thread",8468687],["thread",8454628],["thread",8454626],["thread",8447052],["thread",8444862],["thread",8426320],["thread",8424507],["thread",8413374],["thread",8407617],["thread",8391640],["thread",8391623],["thread",8388304],["thread",8388279],["thread",8387365],["thread",8374896],["thread",8370774],["thread",8364902],["thread",8342906],["thread",8330725],["thread",8313319],["thread",8287838],["thread",8275917],["thread",8257621],["thread",8257372],["thread",8255953],["thread",8251720],["thread",8211349],["thread",8155463],["thread",8137028],["thread",7907837],["thread",7870387],["thread",7709334],["thread",7479035],["thread",7477658],["thread",7353773],["thread",7325492],["thread",7126509]], 274, tinhte_xentag_tag, , {"tags":["s\u1eeda m\u00e1y in"]}, date, 0, , [], 0, 1656315613, d2164badadb272e6df3ac56a8f75d8ef
Run Time: 0.000876