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 (9694760, 9694191, 9693256, 9692707, 9692247, 9692141, 9689727, 9689724, 9689722, 9689721, 9689720, 9689718, 9689717, 9687306, 9683408, 9683048, 9678194, 9675737, 9675736, 9672176, 9670540, 9670539, 9670536, 9670534, 9669719, 9669671, 9669050, 9668439, 9667782, 9667517, 9667164, 9666498, 9666497, 9666495, 9666494, 9663587, 9662764, 9662341, 9660549, 9659763, 9659762, 9659671, 9659670, 9659669, 9659668, 9659667, 9659247, 9659204, 9659201, 9659190, 9659188, 9658875, 9658091, 9658038, 9658028, 9658000, 9657992, 9656446, 9656405, 9655836, 9655835, 9655833, 9655824, 9655183, 9654696, 9650471, 9650244, 9647938, 9643858, 9641182, 9640511, 9640498, 9636203, 9633225, 9632854, 9631044, 9630649, 9630065, 9622622, 9621755, 9616235, 9615739, 9611173, 9611171, 9608703, 9608212, 9602809, 9600275, 9596437, 9596309, 9596018, 9595984, 9591444, 9590101, 9588104, 9585597, 9584716, 9584236, 9582870, 9581926, 9581859, 9579683, 9579682, 9577654, 9577638, 9577630, 9577620, 9574407, 9574403, 9574395, 9573702, 9572869, 9572704, 9569915, 9569835, 9569831, 9569828, 9569826, 9568937, 9566781, 9565540, 9565172, 9564316, 9563201, 9563045, 9561816, 9559323, 9558966, 9558261, 9557079, 9556144, 9554523, 9554522, 9553988, 9552574, 9552572, 9552332, 9547396, 9547351, 9547350, 9545940, 9545939, 9545922, 9545235, 9545232, 9543989, 9543317, 9543316, 9543313, 9543311, 9541657, 9539360, 9538724, 9536615, 9536614, 9534422, 9533980, 9531124, 9527277, 9527276, 9527275, 9525563, 9524824, 9523128, 9523002, 9522368, 9521900, 9521360, 9520194, 9520009, 9517899, 9517695, 9517694, 9509446, 9507875, 9507809, 9496153, 9493598, 9490808, 9487870, 9485747, 9485696, 9484591, 9484456, 9477431, 9470528, 9469587, 9469137, 9469133, 9469072, 9469071, 9468530, 9468528, 9465749, 9465209, 9464078, 9459921, 9459506, 9459345, 9459043, 9458703, 9458520, 9458457, 9458327, 9456928, 9456927, 9455608, 9450789, 9450788, 9450693, 9450690, 9449643, 9445065, 9445064, 9445063, 9444621, 9436941, 9436588, 9435223, 9435222, 9433838, 9433539, 9427393, 9427005, 9426328, 9426282, 9420008, 9418348, 9418345, 9418181, 9414545, 9414368, 9412029, 9408884, 9408042, 9407555, 9406022, 9405108, 9404772, 9403870, 9403308, 9402909, 9398155, 9396925, 9396447, 9396438, 9392531, 9391054, 9391047, 9388043, 9386667, 9386666, 9384016, 9383472, 9382943, 9380287, 9378393, 9377474, 9376294, 9376264, 9375466, 9374625, 9374622, 9374621, 9373692, 9373209, 9366269, 9366074, 9361880, 9361868, 9357405, 9357395, 9357393, 9355093, 9346374, 9344606, 9339206, 9339205, 9339154, 9337496, 9335646, 9333193, 9333184, 9333183, 9327066, 9327064, 9322019, 9318766, 9312304, 9304283, 9299734, 9295230, 9295040, 9294910, 9293858, 9293488, 9293487, 9293132, 9292930, 9292737, 9291000, 9290932, 9290662, 9290496, 9289866, 9284150, 9283185, 9279286, 9270185, 9268627, 9267946, 9267861, 9262932, 9258018, 9254666, 9254468, 9254467, 9253610, 9253267, 9247960, 9247538, 9230303, 9223042, 9215527, 9213578, 9209692, 9206540, 9199913, 9196427, 9195636, 9193165, 9193162, 9193155, 9193153, 9192217, 9191117, 9190500, 9188336, 9183328, 9181512, 9174663, 9174510, 9172885, 9169890, 9167225, 9167224, 9166763, 9165783, 9165782, 9164563, 9162236, 9161476, 9161471, 9161184, 9161181, 9159231, 9158856, 9155895, 9154658, 9150873, 9150863, 9150862, 9150781, 9150287, 9150286, 9150139, 9149549, 9148183, 9146635, 9146622, 9146620, 9146607, 9146443, 9145631, 9145630, 9145557, 9136817, 9134014, 9130860, 9127588, 9126351, 9126145, 9126141, 9125891, 9125890, 9124251, 9123125, 9120344, 9120343, 9120002, 9119593, 9119582, 9117827, 9117826, 9117824, 9117822, 9117816, 9117814, 9117810, 9117804, 9117798, 9117785, 9117662, 9113968, 9113896, 9113320, 9112765, 9112741, 9112738, 9111989, 9108360, 9106904, 9106897, 9106895, 9106894, 9102901, 9102067, 9101503, 9101501, 9100279, 9099585, 9095758, 9095555, 9094132, 9093996, 9087450, 9085474, 9083156, 9083154, 9072978, 9067735, 9067118, 9067083, 9066926, 9066183, 9066149, 9063307, 9061678, 9061677, 9061676, 9049378, 9043656, 9043599, 9043585, 9042553, 9038842, 9038841, 9038839, 9038753, 9034935, 9034646, 9034645, 9034644, 9030158, 9027637, 9017707, 9017309, 9017243, 9012174, 9009339, 9007293, 9006075, 9004255, 9004254, 9003076, 9003075, 8994993, 8981371, 8980168, 8979353, 8979352, 8979085, 8977203, 8975283, 8975202, 8972070, 8969855, 8967374, 8964006, 8961551, 8961530, 8961526, 8961334, 8959369, 8959176, 8949734, 8949286, 8948882, 8947252, 8947250, 8947249, 8944905, 8940111, 8933892, 8932805, 8931940, 8922675, 8922428, 8920360, 8920344, 8914029, 8906301, 8904217, 8904216, 8901602, 8901601, 8890518, 8877713, 8877710, 8876061, 8875548, 8873158, 8864301, 8859719, 8856189, 8844575, 8829107, 8819988, 8808149, 8793953, 8793950, 8793949, 8793948, 8775852, 8761358, 8758587, 8758585, 8758583, 8756902, 8753915, 8747264, 8745562, 8723334, 8723333, 8722751, 8722750, 8694129, 8669154, 8669146, 8669125, 8607877, 8568284, 8568283, 8568281, 8557665, 8522028, 8454916, 8429655, 8373386, 8370984, 8350463, 8348080, 8302195, 8300690, 8297334, 8288984, 8256130, 8226966, 8226617, 8220753, 8220714, 8220295, 8163231, 8144808, 8143583, 8136509, 8108086, 8098298, 8050376, 7635808, 7631105, 7518008, 7483020, 7346539, 7332185, 7317766, 7299522, 7099800, 7059223)
Run Time: 0.020137
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 579 | 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],["thread",9694760],["thread",9694191],["thread",9693256],["thread",9692707],["thread",9692247],["thread",9692141],["thread",9687306],["thread",9683408],["thread",9683048],["thread",9678194],["thread",9672176],["thread",9670540],["thread",9670536],["thread",9670534],["thread",9669719],["thread",9669671],["thread",9669050],["thread",9667782],["thread",9667517],["thread",9667164],["thread",9663587],["thread",9662764],["thread",9662341],["thread",9660549],["thread",9659763],["thread",9659247],["thread",9659204],["thread",9659201],["thread",9659190],["thread",9659188],["thread",9658875],["thread",9658091],["thread",9658038],["thread",9658028],["thread",9658000],["thread",9657992],["thread",9656446],["thread",9656405],["thread",9655836],["thread",9655835],["thread",9655833],["thread",9655824],["thread",9655183],["thread",9654696],["thread",9650471],["thread",9650244],["thread",9647938],["thread",9643858],["thread",9641182],["thread",9640511],["thread",9640498],["thread",9636203],["thread",9633225],["thread",9632854],["thread",9631044],["thread",9630649],["thread",9622622],["thread",9621755],["thread",9615739],["thread",9608703],["thread",9608212],["thread",9602809],["thread",9600275],["thread",9596309],["thread",9595984],["thread",9591444],["thread",9590101],["thread",9588104],["thread",9585597],["thread",9584716],["thread",9584236],["thread",9582870],["thread",9581926],["thread",9579683],["thread",9577654],["thread",9577638],["thread",9577630],["thread",9577620],["thread",9574407],["thread",9574403],["thread",9574395],["thread",9573702],["thread",9572869],["thread",9572704],["thread",9569915],["thread",9569835],["thread",9569831],["thread",9569828],["thread",9569826],["thread",9568937],["thread",9566781],["thread",9565540],["thread",9565172],["thread",9564316],["thread",9563201],["thread",9563045],["thread",9561816],["thread",9559323],["thread",9558966],["thread",9557079],["thread",9554523],["thread",9552574],["thread",9552572],["thread",9552332],["thread",9547396],["thread",9547351],["thread",9545940],["thread",9545922],["thread",9545235],["thread",9545232],["thread",9543989],["thread",9543317],["thread",9543316],["thread",9543311],["thread",9541657],["thread",9538724],["thread",9536615],["thread",9533980],["thread",9531124],["thread",9527277],["thread",9525563],["thread",9524824],["thread",9522368],["thread",9521900],["thread",9521360],["thread",9520194],["thread",9517695],["thread",9509446],["thread",9507809],["thread",9496153],["thread",9485747],["thread",9485696],["thread",9484591],["thread",9484456],["thread",9477431],["thread",9470528],["thread",9469137],["thread",9469072],["thread",9468530],["thread",9465749],["thread",9465209],["thread",9459921],["thread",9459506],["thread",9459043],["thread",9456928],["thread",9455608],["thread",9450789],["thread",9450693],["thread",9450690],["thread",9449643],["thread",9445065],["thread",9445064],["thread",9436941],["thread",9436588],["thread",9433838],["thread",9427005],["thread",9426282],["thread",9420008],["thread",9418348],["thread",9418345],["thread",9414545],["thread",9414368],["thread",9412029],["thread",9408884],["thread",9408042],["thread",9407555],["thread",9406022],["thread",9405108],["thread",9404772],["thread",9403870],["thread",9403308],["thread",9402909],["thread",9398155],["thread",9396925],["thread",9396447],["thread",9396438],["thread",9391054],["thread",9391047],["thread",9386667],["thread",9384016],["thread",9377474],["thread",9376294],["thread",9376264],["thread",9375466],["thread",9374625],["thread",9373692],["thread",9361868],["thread",9357405],["thread",9355093],["thread",9346374],["thread",9344606],["thread",9339154],["thread",9337496],["thread",9333193],["thread",9333184],["thread",9333183],["thread",9327066],["thread",9327064],["thread",9322019],["thread",9318766],["thread",9312304],["thread",9304283],["thread",9299734],["thread",9295230],["thread",9295040],["thread",9294910],["thread",9293488],["thread",9292930],["thread",9291000],["thread",9290932],["thread",9290662],["thread",9289866],["thread",9268627],["thread",9267946],["thread",9267861],["thread",9262932],["thread",9258018],["thread",9254666],["thread",9254468],["thread",9253610],["thread",9253267],["thread",9247960],["thread",9230303],["thread",9223042],["thread",9215527],["thread",9213578],["thread",9206540],["thread",9199913],["thread",9196427],["thread",9195636],["thread",9193165],["thread",9193162],["thread",9193155],["thread",9193153],["thread",9192217],["thread",9191117],["thread",9190500],["thread",9188336],["thread",9183328],["thread",9181512],["thread",9172885],["thread",9169890],["thread",9166763],["thread",9165783],["thread",9165782],["thread",9162236],["thread",9161476],["thread",9161471],["thread",9161184],["thread",9161181],["thread",9158856],["thread",9155895],["thread",9154658],["thread",9150873],["thread",9150863],["thread",9150781],["thread",9150287],["thread",9150139],["thread",9149549],["thread",9148183],["thread",9146635],["thread",9146622],["thread",9146607],["thread",9146443],["thread",9145631],["thread",9145557],["thread",9136817],["thread",9134014],["thread",9130860],["thread",9127588],["thread",9126141],["thread",9125891],["thread",9124251],["thread",9120002],["thread",9119593],["thread",9119582],["thread",9117827],["thread",9117826],["thread",9117816],["thread",9117814],["thread",9117804],["thread",9117798],["thread",9117785],["thread",9113896],["thread",9113320],["thread",9112765],["thread",9108360],["thread",9102901],["thread",9102067],["thread",9101503],["thread",9100279],["thread",9099585],["thread",9094132],["thread",9087450],["thread",9085474],["thread",9072978],["thread",9067735],["thread",9067118],["thread",9067083],["thread",9066926],["thread",9066183],["thread",9066149],["thread",9063307],["thread",9049378],["thread",9043656],["thread",9043599],["thread",9043585],["thread",9038842],["thread",9034935],["thread",9034646],["thread",9030158],["thread",9017707],["thread",9007293],["thread",9004255],["thread",8994993],["thread",8981371],["thread",8980168],["thread",8979353],["thread",8975283],["thread",8975202],["thread",8972070],["thread",8969855],["thread",8967374],["thread",8964006],["thread",8959369],["thread",8959176],["thread",8949734],["thread",8949286],["thread",8948882],["thread",8947252],["thread",8940111],["thread",8933892],["thread",8932805],["thread",8931940],["thread",8922675],["thread",8922428],["thread",8920344],["thread",8914029],["thread",8904217],["thread",8901602],["thread",8877713],["thread",8876061],["thread",8875548],["thread",8873158],["thread",8856189],["thread",8844575],["thread",8775852],["thread",8761358],["thread",8758587],["thread",8756902],["thread",8753915],["thread",8747264],["thread",8745562],["thread",8723334],["thread",8722751],["thread",8669154],["thread",8669146],["thread",8669125],["thread",8568284],["thread",8557665],["thread",8522028],["thread",8454916],["thread",8429655],["thread",8373386],["thread",8370984],["thread",8350463],["thread",8348080],["thread",8302195],["thread",8300690],["thread",8297334],["thread",8288984],["thread",8256130],["thread",8226966],["thread",8226617],["thread",8220753],["thread",8220714],["thread",8220295],["thread",8163231],["thread",8144808],["thread",8143583],["thread",8108086],["thread",8098298],["thread",8050376],["thread",7635808],["thread",7631105],["thread",7518008],["thread",7483020],["thread",7346539],["thread",7332185],["thread",7317766],["thread",7099800],["thread",7059223]], 393, tinhte_xentag_tag, , {"tags":["cho thu\u00ea m\u00e1y in"]}, date, 0, , [], 0, 1660385939, 69a27ce36e51fa26325602c19df69111
Run Time: 0.000611