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 (9684821, 9683746, 9675674, 9675672, 9674337, 9669992, 9669520, 9669519, 9667364, 9657790, 9655940, 9655068, 9654832, 9653058, 9650727, 9650726, 9648282, 9645070, 9643611, 9641038, 9639237, 9638353, 9634752, 9634751, 9634594, 9634593, 9634469, 9634466, 9634454, 9634365, 9633947, 9633946, 9633659, 9633627, 9633445, 9633444, 9633139, 9633031, 9632592, 9632518, 9632311, 9632292, 9631843, 9631461, 9631449, 9631390, 9631389, 9628253, 9628055, 9627424, 9625758, 9624064, 9623042, 9622960, 9621469, 9621468, 9620838, 9620837, 9620507, 9619651, 9619650, 9619649, 9618594, 9618008, 9616359, 9616244, 9616243, 9616242, 9616117, 9615219, 9609098, 9605923, 9602658, 9602657, 9602365, 9600750, 9600749, 9600611, 9600236, 9586268, 9586267, 9585713, 9581002, 9579908, 9579907, 9578541, 9578332, 9577950, 9576755, 9576535, 9575313, 9574204, 9573705, 9573462, 9573131, 9572317, 9569880, 9569527, 9569526, 9568471, 9567984, 9567937, 9567808, 9562195, 9557425, 9557221, 9557070, 9557029, 9556831, 9556624, 9556224, 9556217, 9553610, 9553052, 9552894, 9552893, 9552892, 9552891, 9552696, 9552003, 9552002, 9551278, 9549855, 9549854, 9548961, 9548959, 9548957, 9548891, 9548646, 9546299, 9540167, 9540165, 9538450, 9530683, 9530682, 9525890, 9525889, 9523218, 9522412, 9522411, 9521695, 9519574, 9519573, 9516869, 9514554, 9509539, 9509049, 9509048, 9509047, 9508014, 9508013, 9508010, 9508008, 9507406, 9506789, 9506496, 9506495, 9506493, 9504236, 9502520, 9499231, 9498689, 9498687, 9498686, 9496969, 9496739, 9496495, 9494485, 9494482, 9493243, 9493242, 9493241, 9490186, 9490185, 9489536, 9488219, 9488218, 9488184, 9487351, 9486368, 9476753, 9474755, 9472473, 9470997, 9469625, 9468569, 9464342, 9464341, 9463397, 9461697, 9454770, 9454711, 9453499, 9452506, 9452505, 9450520, 9450518, 9449645, 9449627, 9431597, 9428455, 9428454, 9428452, 9428403, 9426085, 9426081, 9424206, 9424174, 9422594, 9421350, 9421349, 9421348, 9421347, 9420050, 9418358, 9418357, 9417927, 9417912, 9417880, 9417877, 9417875, 9417872, 9417535, 9416488, 9415879, 9415810, 9415736, 9415360, 9414648, 9413196, 9412038, 9411213, 9411212, 9409945, 9409944, 9409943, 9409651, 9409649, 9409413, 9409412, 9409317, 9409315, 9405521, 9400843, 9400720, 9396582, 9396453, 9395741, 9390925, 9390924, 9390208, 9380014, 9377344, 9377343, 9376013, 9375669, 9374413, 9374412, 9373829, 9371413, 9369527, 9368573, 9367847, 9365199, 9364873, 9364372, 9364366, 9361765, 9361760, 9354994, 9352277, 9350991, 9350238, 9350234, 9347800, 9347798, 9346246, 9346243, 9346242, 9345725, 9345723, 9337004, 9335914, 9335913, 9334271, 9334270, 9333646, 9331712, 9331711, 9330264, 9329830, 9327536, 9325263, 9324837, 9322273, 9318043, 9314810, 9314809, 9314452, 9314451, 9313846, 9313576, 9313262, 9313255, 9313230, 9313209, 9313198, 9313192, 9313182, 9313170, 9313168, 9313166, 9313021, 9312010, 9308354, 9308353, 9308264, 9307074, 9307073, 9306470, 9306469, 9306242, 9303164, 9301025, 9298549, 9297895, 9297262, 9296953, 9296952, 9295060, 9291933, 9290257, 9289382, 9289172, 9289170, 9289169, 9282100, 9281461, 9280743, 9280742, 9280741, 9279702, 9277452, 9277451, 9277412, 9277396, 9277394, 9273536, 9272208, 9262279, 9262264, 9261332, 9260060, 9259831, 9258040, 9258039, 9253736, 9253734, 9248134, 9248133, 9245034, 9245031, 9245030, 9243452, 9243449, 9243443, 9242874, 9242780, 9242779, 9241771, 9241042, 9240348, 9239374, 9235581, 9225993, 9222644, 9221424, 9218041, 9218040, 9218039, 9218038, 9216198, 9214944, 9214943, 9214927, 9211861, 9211496, 9211469, 9210693, 9210271, 9209601, 9208760, 9208759, 9208619, 9206940, 9206927, 9206926, 9204854, 9204401, 9200497, 9195211, 9195210, 9193504, 9193491, 9193490, 9192950, 9192948, 9192673, 9192502, 9190455, 9190454, 9189297, 9189279, 9189278, 9189276, 9183156, 9182287, 9181168, 9181167, 9178764, 9178292, 9177952, 9177951, 9177611, 9174420, 9173255, 9172429, 9172202, 9172178, 9171037, 9169727, 9169247, 9166482, 9166162, 9166160, 9166154, 9166139, 9163216, 9162028, 9160473, 9159753, 9159751, 9158121, 9158002, 9158001, 9158000, 9157995, 9157985, 9157984, 9157982, 9157980, 9157979, 9154268, 9152973, 9152214, 9150868, 9150867, 9150281, 9150000, 9148304, 9146548, 9145652, 9143626, 9143625, 9143014, 9140792, 9140639, 9139010, 9134834, 9133710, 9131695, 9128016, 9124439, 9124438, 9123335, 9123334, 9123333, 9123256, 9123174, 9123172, 9120865, 9119229, 9116362, 9115323, 9111121, 9108596, 9108434, 9108433, 9107671, 9107669, 9107597, 9106879, 9106803, 9106082, 9105672, 9102167, 9098462, 9098461, 9098065, 9096828, 9096300, 9094248, 9093912, 9093311, 9091807, 9090910, 9088881, 9088879, 9087625, 9087415, 9087271, 9085557, 9085556, 9085555, 9084860, 9082081, 9081550, 9073178, 9068167, 9067413, 9067044, 9067043, 9066498, 9058363, 9056527, 9055658, 9055657, 9053931, 9052434, 9052358, 9051918, 9051666, 9050870, 9046225, 9044212, 9041860, 9038675, 9038669, 9038667, 9038665, 9036915, 9035834, 9035832, 9035829, 9032220, 9031541, 9031540, 9030737, 9030736, 9030734, 9030732, 9030731, 9030429, 9029506, 9029494, 9027888, 9027167, 9026977, 9025677, 9024616, 9023603, 9023517, 9022814, 9022812, 9022598, 9022406, 9022400, 9021501, 9020378, 9019672, 9019658, 9018493, 9016898, 9016897, 9016226, 9014473, 9014027, 9012249, 9011252, 9009782, 9009780, 9009779, 9005786, 9005569, 9004286, 9003809, 9002973, 9002529, 9002109, 9001651, 9001491, 8998974, 8997572, 8997415, 8997414, 8996644, 8995832, 8995831, 8995830, 8994733, 8994607, 8994581, 8994293, 8994093, 8993583, 8986979, 8986316, 8986315, 8982035, 8982034, 8979320, 8976449, 8976159, 8970829, 8969112, 8967651, 8967649, 8965644, 8964400, 8963094, 8962086, 8961727, 8959759, 8959758, 8958160, 8956629, 8949501, 8947932, 8947853, 8947388, 8946220, 8945157, 8944693, 8942628, 8942621, 8942618, 8942087, 8941995, 8940944, 8940943, 8938850, 8938247, 8937457, 8937303, 8937282, 8937239, 8937237, 8936205, 8935487, 8935060, 8934865, 8933929, 8933923, 8933913, 8933384, 8933368, 8933365, 8932945, 8930057, 8929682, 8928560, 8926386, 8925500, 8925499, 8921655, 8916463, 8916462, 8915341, 8915340, 8912922, 8911082, 8908703, 8908701, 8907380, 8906344, 8906324, 8905821, 8902150, 8902149, 8901238, 8900172, 8899947, 8893671, 8893669, 8893668, 8892315, 8892255, 8891040, 8891028, 8891026, 8891017, 8891013, 8891012, 8891010, 8890731, 8890080, 8887183, 8885823, 8885797, 8885796, 8885130, 8883006, 8882557, 8881196, 8877873, 8877871, 8876185, 8876182, 8876181, 8875671, 8871970, 8862895, 8862892, 8862890, 8862782, 8862776, 8861392, 8860923, 8858466, 8858309, 8858308, 8857386, 8856575, 8856489, 8851494, 8850710, 8850678, 8849272, 8849269, 8849268, 8846810, 8843175, 8843045, 8841566, 8840707, 8840594, 8840593, 8840198, 8836415, 8836413, 8836216, 8836164, 8834849, 8833600, 8830773, 8830772, 8828858, 8828857, 8828856, 8828852, 8828012, 8827966, 8827414, 8827413, 8827041, 8824952, 8824951, 8824288, 8824281, 8824279, 8824207, 8822092, 8821746, 8819193, 8816272, 8815882, 8815881, 8814051, 8812262, 8812018, 8812016, 8810016, 8808507, 8808154, 8806054, 8801309, 8800845, 8800021, 8795000, 8794002, 8792965, 8792807, 8791555, 8791554, 8790315, 8787252, 8782186, 8781305, 8779417, 8777468, 8774489, 8774488, 8773701, 8773700, 8772362, 8772361, 8769110, 8769035, 8769034, 8768743, 8766836, 8765180, 8764368, 8763785, 8763384, 8763383, 8762435, 8762187, 8760110, 8760109, 8760108, 8758275, 8758273, 8757266, 8756990, 8756325, 8749694, 8749693, 8748777, 8746122, 8746121, 8746120, 8746119, 8743949, 8742739, 8741408, 8741407, 8741406, 8741403, 8740274, 8738224, 8738222, 8735550, 8734121, 8706634, 8701404, 8697928, 8697926, 8697915, 8683485, 8637941, 8587144, 8549922, 8546044, 8545473, 8545471, 8487334, 8269943, 8189292, 8189291, 8189289, 8189288, 8189287, 8042101, 7593798, 7589741, 7550153, 7523189, 7505604, 7468002, 7402485, 7346000, 7310842, 6923011, 6764661)
Run Time: 0.020976
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 865 | 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",119],["thread",9684821],["thread",9674337],["thread",9667364],["thread",9657790],["thread",9650727],["thread",9648282],["thread",9645070],["thread",9643611],["thread",9634752],["thread",9634469],["thread",9633031],["thread",9632518],["thread",9632311],["thread",9632292],["thread",9631843],["thread",9631461],["thread",9631449],["thread",9631390],["thread",9628055],["thread",9623042],["thread",9622960],["thread",9621469],["thread",9620838],["thread",9619651],["thread",9618008],["thread",9616359],["thread",9616244],["thread",9616117],["thread",9605923],["thread",9602365],["thread",9600750],["thread",9600611],["thread",9586268],["thread",9579908],["thread",9578541],["thread",9577950],["thread",9576755],["thread",9575313],["thread",9569527],["thread",9562195],["thread",9553610],["thread",9553052],["thread",9552894],["thread",9552003],["thread",9549855],["thread",9548961],["thread",9548891],["thread",9546299],["thread",9538450],["thread",9530683],["thread",9523218],["thread",9516869],["thread",9509539],["thread",9509049],["thread",9508014],["thread",9507406],["thread",9502520],["thread",9499231],["thread",9496739],["thread",9494485],["thread",9493243],["thread",9490186],["thread",9488219],["thread",9488184],["thread",9487351],["thread",9486368],["thread",9476753],["thread",9474755],["thread",9472473],["thread",9469625],["thread",9468569],["thread",9454711],["thread",9453499],["thread",9452506],["thread",9450520],["thread",9449645],["thread",9449627],["thread",9431597],["thread",9428403],["thread",9426085],["thread",9426081],["thread",9424206],["thread",9424174],["thread",9418358],["thread",9417927],["thread",9417535],["thread",9415879],["thread",9415810],["thread",9415736],["thread",9412038],["thread",9411213],["thread",9409945],["thread",9409651],["thread",9409413],["thread",9400843],["thread",9400720],["thread",9396582],["thread",9390925],["thread",9390208],["thread",9375669],["thread",9373829],["thread",9371413],["thread",9369527],["thread",9367847],["thread",9364372],["thread",9364366],["thread",9361765],["thread",9361760],["thread",9352277],["thread",9350238],["thread",9350234],["thread",9346246],["thread",9345725],["thread",9337004],["thread",9335914],["thread",9334271],["thread",9333646],["thread",9327536],["thread",9325263],["thread",9324837],["thread",9322273],["thread",9318043],["thread",9313846],["thread",9313576],["thread",9313262],["thread",9313255],["thread",9313198],["thread",9313192],["thread",9313182],["thread",9313170],["thread",9313168],["thread",9312010],["thread",9308354],["thread",9308264],["thread",9307074],["thread",9306470],["thread",9303164],["thread",9301025],["thread",9298549],["thread",9297895],["thread",9297262],["thread",9296953],["thread",9295060],["thread",9291933],["thread",9281461],["thread",9280743],["thread",9261332],["thread",9260060],["thread",9259831],["thread",9245034],["thread",9243452],["thread",9241771],["thread",9241042],["thread",9222644],["thread",9221424],["thread",9218041],["thread",9211861],["thread",9211496],["thread",9211469],["thread",9210693],["thread",9210271],["thread",9206940],["thread",9206927],["thread",9204854],["thread",9195211],["thread",9193504],["thread",9193491],["thread",9183156],["thread",9177952],["thread",9177611],["thread",9172202],["thread",9166162],["thread",9163216],["thread",9159753],["thread",9154268],["thread",9150868],["thread",9150281],["thread",9150000],["thread",9145652],["thread",9140792],["thread",9123335],["thread",9123256],["thread",9123174],["thread",9119229],["thread",9116362],["thread",9111121],["thread",9108596],["thread",9107671],["thread",9107597],["thread",9093311],["thread",9091807],["thread",9090910],["thread",9088881],["thread",9084860],["thread",9067413],["thread",9066498],["thread",9052434],["thread",9052358],["thread",9051918],["thread",9051666],["thread",9046225],["thread",9038675],["thread",9038669],["thread",9038667],["thread",9038665],["thread",9036915],["thread",9032220],["thread",9024616],["thread",9022814],["thread",9016226],["thread",9012249],["thread",9009782],["thread",9005569],["thread",9003809],["thread",9002973],["thread",9002529],["thread",9002109],["thread",9001651],["thread",9001491],["thread",8997415],["thread",8994607],["thread",8982035],["thread",8970829],["thread",8963094],["thread",8949501],["thread",8946220],["thread",8942628],["thread",8942621],["thread",8942618],["thread",8942087],["thread",8940944],["thread",8935487],["thread",8925500],["thread",8916463],["thread",8915341],["thread",8907380],["thread",8892315],["thread",8891026],["thread",8890731],["thread",8885797],["thread",8885130],["thread",8871970],["thread",8858309],["thread",8857386],["thread",8856489],["thread",8851494],["thread",8849272],["thread",8840198],["thread",8836216],["thread",8836164],["thread",8827966],["thread",8821746],["thread",8815882],["thread",8814051],["thread",8812018],["thread",8808154],["thread",8792965],["thread",8792807],["thread",8790315],["thread",8777468],["thread",8774489],["thread",8765180],["thread",8763785],["thread",8763384],["thread",8762435],["thread",8760110],["thread",8756990],["thread",8749694],["thread",8735550],["thread",8706634],["thread",8697928],["thread",8697926],["thread",8697915],["thread",8683485],["thread",8637941],["thread",8587144],["thread",8549922],["thread",8545473],["thread",8487334],["thread",8269943],["thread",8042101],["thread",7593798],["thread",7589741],["thread",7550153],["thread",7505604],["thread",7468002],["thread",7402485],["thread",7346000],["thread",7310842],["thread",6923011],["thread",6764661]], 292, tinhte_xentag_tag, , {"tags":["n\u1ed9i th\u1ea5t g\u1ed7 s\u1ed3i"]}, date, 0, , [], 0, 1656276911, af4e5153890c806c3244dbe97d0e07e5
Run Time: 0.000735