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 (9697634, 9696918, 9694902, 9692918, 9688859, 9687692, 9680292, 9678691, 9677603, 9675909, 9675017, 9675004, 9674591, 9671685, 9671257, 9670750, 9670180, 9666460, 9663099, 9655125, 9654423, 9654422, 9653268, 9643670, 9639728, 9637193, 9636527, 9631927, 9610189, 9610186, 9609301, 9585913, 9581703, 9579190, 9578911, 9574448, 9574446, 9574445, 9571670, 9567836, 9567154, 9566519, 9565667, 9562999, 9561214, 9560572, 9559636, 9558528, 9555999, 9554585, 9544311, 9538110, 9517037, 9517036, 9513719, 9511977, 9509034, 9505963, 9501918, 9496728, 9489533, 9487571, 9486901, 9485854, 9480581, 9477530, 9474855, 9468596, 9460851, 9460850, 9460187, 9460185, 9460176, 9459712, 9456237, 9456236, 9456235, 9455869, 9453590, 9452868, 9452595, 9450876, 9450874, 9448480, 9448286, 9444355, 9444072, 9442782, 9442173, 9441086, 9440077, 9438733, 9437040, 9434566, 9423478, 9422423, 9422178, 9419136, 9418974, 9418613, 9417130, 9416199, 9413885, 9408493, 9405302, 9405037, 9402712, 9402711, 9402661, 9402650, 9401323, 9396386, 9395042, 9394597, 9393982, 9385755, 9382229, 9373364, 9371878, 9369966, 9366981, 9366454, 9366451, 9360564, 9355239, 9347502, 9343713, 9343484, 9343058, 9343057, 9342423, 9340619, 9340308, 9340081, 9338323, 9338320, 9338317, 9338315, 9338262, 9338261, 9338259, 9337888, 9335827, 9335498, 9329408, 9328898, 9323068, 9318404, 9317896, 9317213, 9314887, 9314249, 9313336, 9310744, 9308478, 9307305, 9304827, 9304608, 9304392, 9304386, 9304384, 9304382, 9304317, 9304226, 9303685, 9302819, 9301368, 9299647, 9298669, 9294207, 9294202, 9294201, 9290497, 9290495, 9290494, 9290493, 9290419, 9288667, 9287893, 9287511, 9287382, 9286572, 9286307, 9286306, 9284102, 9284100, 9284044, 9283641, 9283024, 9275275, 9273147, 9271778, 9271461, 9270649, 9267514, 9266703, 9263628, 9262199, 9261479, 9259486, 9257979, 9257977, 9256155, 9254611, 9247140, 9243942, 9241031, 9241025, 9239268, 9239267, 9237970, 9236088, 9235779, 9235643, 9235512, 9235371, 9235038, 9230410, 9226794, 9225640, 9225044, 9225043, 9219093, 9218907, 9217554, 9216806, 9213866, 9212895, 9210022, 9208588, 9208187, 9204488, 9202333, 9201447, 9193609, 9188420, 9184351, 9184339, 9184338, 9182033, 9179710, 9179699, 9178870, 9178869, 9178652, 9177405, 9177400, 9177394, 9176418, 9176417, 9174074, 9173790, 9173789, 9172118, 9169781, 9169221, 9168600, 9167511, 9163065, 9163047, 9161967, 9157051, 9154772, 9152483, 9151802, 9150353, 9148607, 9145734, 9145733, 9143359, 9142081, 9138764, 9135048, 9124507, 9121476, 9121157, 9117962, 9117348, 9116912, 9115855, 9113324, 9112685, 9110901, 9108024, 9104090, 9102915, 9100561, 9098518, 9098362, 9098360, 9098359, 9097250, 9097145, 9092693, 9092690, 9092689, 9092686, 9092682, 9092676, 9092670, 9088966, 9084354, 9084250, 9078581, 9078076, 9073288, 9073180, 9073176, 9071931, 9071717, 9069933, 9069712, 9068123, 9065244, 9063664, 9063236, 9062952, 9062077, 9062012, 9061736, 9060922, 9058482, 9054120, 9053886, 9053885, 9053648, 9053622, 9051609, 9051496, 9051149, 9050933, 9050346, 9050344, 9048236, 9046393, 9046392, 9046341, 9042740, 9042724, 9042080, 9042077, 9040845, 9039453, 9037342, 9035886, 9031585, 9031557, 9025389, 9020787, 9020450, 9019415, 9018843, 9015059, 9014846, 9011762, 9011687, 9009949, 9007976, 8997667, 8997130, 8997108, 8997103, 8996117, 8991508, 8988383, 8987738, 8987737, 8987727, 8985207, 8982080, 8982000, 8981800, 8978788, 8978252, 8978144, 8977302, 8977300, 8976875, 8976874, 8972649, 8972097, 8971120, 8970076, 8968083, 8964686, 8962887, 8962195, 8961465, 8959992, 8959819, 8956084, 8953833, 8953832, 8951418, 8949681, 8948789, 8947320, 8947135, 8947133, 8944656, 8944528, 8942843, 8941555, 8940843, 8940524, 8939600, 8937446, 8936551, 8936337, 8935469, 8933303, 8930737, 8929323, 8929287, 8929258, 8928262, 8928243, 8927334, 8927045, 8926850, 8926835, 8926725, 8926724, 8926716, 8926230, 8926229, 8926228, 8923978, 8922706, 8921521, 8920862, 8920549, 8920425, 8919215, 8917637, 8916344, 8916343, 8916089, 8914027, 8914026, 8914023, 8912768, 8912634, 8908421, 8907760, 8906571, 8906385, 8903916, 8902598, 8901771, 8901592, 8900451, 8900224, 8900218, 8899637, 8899236, 8898581, 8898574, 8897982, 8897246, 8897245, 8897093, 8896752, 8896490, 8895846, 8895419, 8894862, 8894584, 8893980, 8893979, 8893947, 8893639, 8893193, 8892305, 8892304, 8892286, 8892269, 8890488, 8890485, 8890176, 8889742, 8889641, 8889640, 8889638, 8887246, 8885858, 8883668, 8882995, 8882821, 8882818, 8882807, 8882802, 8882799, 8881539, 8881366, 8878107, 8877525, 8876341, 8875542, 8875134, 8874156, 8873235, 8872376, 8872375, 8870704, 8870475, 8870007, 8870006, 8869416, 8869415, 8869062, 8868633, 8866469, 8865433, 8864419, 8863572, 8863220, 8862833, 8862691, 8861849, 8860833, 8860831, 8860829, 8860703, 8860013, 8858609, 8857516, 8857032, 8856401, 8856400, 8854877, 8853343, 8853242, 8852905, 8852904, 8852735, 8852658, 8851357, 8851105, 8850814, 8850811, 8850510, 8849959, 8847896, 8847870, 8846645, 8846644, 8846220, 8846219, 8844767, 8844221, 8842377, 8841449, 8840995, 8840871, 8840015, 8838694, 8836933, 8836932, 8836414, 8836411, 8834986, 8834983, 8833450, 8833321, 8833318, 8833316, 8833307, 8833213, 8833054, 8833053, 8833052, 8833051, 8830213, 8829649, 8826547, 8826291, 8826089, 8825441, 8825424, 8820918, 8820448, 8819768, 8819714, 8819459, 8818520, 8818402, 8818005, 8818004, 8817453, 8816503, 8816477, 8816384, 8814860, 8813172, 8813043, 8812378, 8807701, 8807634, 8807628, 8807627, 8807626, 8806884, 8806527, 8805589, 8803126, 8802781, 8802548, 8800277, 8799987, 8799015, 8798606, 8798605, 8796898, 8796893, 8794130, 8794092, 8791595, 8791345, 8790683, 8790584, 8790131, 8790130, 8789799, 8789455, 8789452, 8788830, 8788829, 8788809, 8788566, 8788391, 8787938, 8787919, 8787904, 8787885, 8787834, 8787798, 8787756, 8787729, 8785825, 8783986, 8781925, 8778134, 8776620, 8776619, 8775195, 8774393, 8773774, 8773773, 8771699, 8771695, 8771250, 8770863, 8770262, 8768788, 8768090, 8767311, 8765163, 8765110, 8764081, 8760704, 8758119, 8757698, 8757006, 8754256, 8753485, 8752741, 8752613, 8749974, 8747524, 8745296, 8744719, 8743664, 8741757, 8740941, 8740438, 8739889, 8739835, 8739199, 8733189, 8733188, 8731075, 8730856, 8730855, 8730854, 8730185, 8729877, 8728578, 8727303, 8725907, 8725464, 8725463, 8725335, 8724394, 8722055, 8721273, 8719916, 8719285, 8719284, 8719282, 8717877, 8717693, 8712186, 8708467, 8707957, 8706488, 8705080, 8705029, 8704996, 8702272, 8701495, 8700612, 8697169, 8696525, 8696515, 8694160, 8694159, 8686678, 8679641, 8679476, 8676872, 8675712, 8673492, 8673487, 8673481, 8669813, 8669706, 8667593, 8667412, 8667186, 8666015, 8662795, 8660886, 8652638, 8650584, 8642265, 8641863, 8641862, 8641860, 8641859, 8641858, 8641857, 8641856, 8641855, 8641854, 8626272, 8621027, 8616937, 8606722, 8601026, 8600510, 8596250, 8582959, 8582636, 8582635, 8582622, 8582621, 8582620, 8582619, 8582618, 8582616, 8580931, 8579437, 8573681, 8558721, 8557940, 8554092, 8553358, 8553356, 8546943, 8536473, 8536143, 8529926, 8529925, 8528542, 8521347, 8521346, 8473524, 8461566, 8420437, 8382555, 8303447, 5308637)
Run Time: 0.015794
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 783 | 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",43],["thread",9697634],["thread",9696918],["thread",9694902],["thread",9692918],["thread",9688859],["thread",9687692],["thread",9680292],["thread",9678691],["thread",9675017],["thread",9675004],["thread",9671685],["thread",9671257],["thread",9666460],["thread",9655125],["thread",9654423],["thread",9654422],["thread",9653268],["thread",9643670],["thread",9636527],["thread",9631927],["thread",9610189],["thread",9610186],["thread",9609301],["thread",9585913],["thread",9581703],["thread",9579190],["thread",9574448],["thread",9574446],["thread",9574445],["thread",9571670],["thread",9567836],["thread",9565667],["thread",9562999],["thread",9554585],["thread",9544311],["thread",9538110],["thread",9511977],["thread",9489533],["thread",9487571],["thread",9480581],["thread",9477530],["thread",9460851],["thread",9453590],["thread",9452868],["thread",9438733],["thread",9423478],["thread",9405037],["thread",9385755],["thread",9369966],["thread",9347502],["thread",9340081],["thread",9338323],["thread",9338320],["thread",9338317],["thread",9338315],["thread",9335827],["thread",9335498],["thread",9314887],["thread",9304827],["thread",9304608],["thread",9304317],["thread",9303685],["thread",9288667],["thread",9287382],["thread",9284102],["thread",9284044],["thread",9283024],["thread",9259486],["thread",9257979],["thread",9257977],["thread",9256155],["thread",9247140],["thread",9243942],["thread",9241031],["thread",9235512],["thread",9225044],["thread",9219093],["thread",9213866],["thread",9208588],["thread",9208187],["thread",9204488],["thread",9193609],["thread",9184351],["thread",9182033],["thread",9178652],["thread",9174074],["thread",9173790],["thread",9163047],["thread",9157051],["thread",9152483],["thread",9148607],["thread",9102915],["thread",9098518],["thread",9084250],["thread",9078581],["thread",9078076],["thread",9063664],["thread",9062952],["thread",9061736],["thread",9050933],["thread",9042740],["thread",9042080],["thread",9040845],["thread",9035886],["thread",8997667],["thread",8997108],["thread",8996117],["thread",8991508],["thread",8987727],["thread",8985207],["thread",8982080],["thread",8982000],["thread",8972097],["thread",8970076],["thread",8964686],["thread",8961465],["thread",8959819],["thread",8956084],["thread",8951418],["thread",8948789],["thread",8947320],["thread",8944656],["thread",8944528],["thread",8936337],["thread",8933303],["thread",8929258],["thread",8928262],["thread",8928243],["thread",8926850],["thread",8926835],["thread",8926725],["thread",8922706],["thread",8919215],["thread",8916344],["thread",8912768],["thread",8907760],["thread",8906571],["thread",8903916],["thread",8897093],["thread",8895846],["thread",8894862],["thread",8893193],["thread",8892305],["thread",8890488],["thread",8889742],["thread",8889641],["thread",8881539],["thread",8878107],["thread",8870704],["thread",8870475],["thread",8865433],["thread",8863572],["thread",8862691],["thread",8861849],["thread",8860833],["thread",8860703],["thread",8857516],["thread",8854877],["thread",8853343],["thread",8852905],["thread",8851357],["thread",8849959],["thread",8844221],["thread",8842377],["thread",8841449],["thread",8840995],["thread",8840871],["thread",8836933],["thread",8834986],["thread",8834983],["thread",8833450],["thread",8833054],["thread",8820448],["thread",8819768],["thread",8819459],["thread",8818402],["thread",8816384],["thread",8807701],["thread",8807634],["thread",8807628],["thread",8802548],["thread",8790584],["thread",8789799],["thread",8788830],["thread",8788809],["thread",8788566],["thread",8787938],["thread",8787904],["thread",8787885],["thread",8787834],["thread",8787756],["thread",8778134],["thread",8771695],["thread",8765163],["thread",8760704],["thread",8752613],["thread",8744719],["thread",8740438],["thread",8739835],["thread",8739199],["thread",8733189],["thread",8712186],["thread",8708467],["thread",8707957],["thread",8706488],["thread",8705029],["thread",8704996],["thread",8701495],["thread",8700612],["thread",8696525],["thread",8696515],["thread",8686678],["thread",8675712],["thread",8667593],["thread",8667186],["thread",8660886],["thread",8652638],["thread",8650584],["thread",8642265],["thread",8621027],["thread",8616937],["thread",8606722],["thread",8596250],["thread",8573681],["thread",8554092],["thread",8553358],["thread",8536473],["thread",8536143],["thread",8473524],["thread",8461566],["thread",8303447],["thread",5308637]], 233, tinhte_xentag_tag, , {"tags":["honda winner 150"]}, date, 0, , [], 0, 1660883070, 91bb4618142f6f4b9893e78c268809cb
Run Time: 0.000520