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 (9671419, 9664874, 9663802, 9654051, 9627179, 9622045, 9622044, 9613153, 9612234, 9607427, 9607426, 9607425, 9582403, 9573866, 9566429, 9565170, 9564582, 9554708, 9554707, 9549926, 9548007, 9548002, 9548001, 9541456, 9541455, 9539302, 9532123, 9524110, 9509480, 9505415, 9504297, 9504296, 9501995, 9485016, 9482678, 9480950, 9478303, 9472622, 9471683, 9463520, 9463519, 9462337, 9451183, 9444752, 9444716, 9438007, 9436800, 9426238, 9411509, 9407746, 9407745, 9407742, 9407697, 9402034, 9398496, 9395280, 9395277, 9393010, 9393008, 9385776, 9385775, 9383635, 9383634, 9383633, 9356498, 9350560, 9350558, 9346685, 9344547, 9339373, 9338989, 9338988, 9336112, 9331188, 9329787, 9327955, 9327214, 9327213, 9327212, 9321367, 9318942, 9318940, 9318939, 9317622, 9317621, 9315948, 9315154, 9309644, 9309643, 9308916, 9308915, 9308914, 9307359, 9302753, 9295508, 9295484, 9292460, 9278742, 9278394, 9275005, 9274961, 9274513, 9270897, 9270896, 9266129, 9265596, 9265595, 9264227, 9261019, 9258862, 9258669, 9253424, 9253423, 9252470, 9247781, 9247339, 9247338, 9247337, 9247111, 9246920, 9246919, 9246916, 9245756, 9245405, 9245076, 9245066, 9245046, 9244847, 9244712, 9244711, 9244688, 9244674, 9244671, 9244377, 9244376, 9244375, 9244374, 9244373, 9237578, 9237577, 9234755, 9234156, 9232046, 9232043, 9230653, 9229804, 9229803, 9229494, 9229493, 9227712, 9226427, 9225471, 9225470, 9217114, 9209391, 9206900, 9206266, 9206261, 9204213, 9202236, 9200150, 9200149, 9196180, 9192999, 9191304, 9190591, 9190584, 9189877, 9189115, 9182460, 9176338, 9175123, 9175122, 9175111, 9158014, 9157295, 9157294, 9157094, 9157093, 9155390, 9152705, 9152280, 9151399, 9148547, 9148015, 9147606, 9144456, 9144266, 9144155, 9144130, 9144074, 9144050, 9144027, 9143999, 9143852, 9143815, 9143792, 9143743, 9143515, 9143508, 9143375, 9143050, 9140961, 9136544, 9136515, 9136513, 9136510, 9136086, 9134328, 9132734, 9130359, 9121773, 9118775, 9118774, 9118773, 9114128, 9114125, 9114124, 9103014, 9100009, 9100008, 9098196, 9098195, 9096267, 9091954, 9090636, 9090306, 9090184, 9090183, 9090181, 9087950, 9087921, 9079834, 9079829, 9076697, 9075542, 9075541, 9075357, 9075193, 9074009, 9067245, 9065220, 9065219, 9065218, 9064407, 9063342, 9056216, 9046659, 9042088, 9042087, 9042086, 9042084, 9042083, 9042082, 9036805, 9036804, 9036803, 9036801, 9033925, 9033924, 9026686, 9023099, 9013389, 9013388, 9013387, 9013386, 9002478, 8991707, 8989877, 8989876, 8989193, 8989052, 8988788, 8977712, 8977341, 8965069, 8964171, 8964170, 8952340, 8952339, 8950539, 8950400, 8949942, 8948108, 8948107, 8948105, 8947778, 8940401, 8940400, 8935573, 8934558, 8933567, 8929047, 8921475, 8919708, 8919707, 8914567, 8911615, 8911614, 8910797, 8910796, 8909371, 8905789, 8905022, 8901391, 8895278, 8891241, 8890719, 8889490, 8889240, 8889239, 8887194, 8887192, 8887165, 8886432, 8886431, 8886095, 8885158, 8883753, 8880392, 8879828, 8877485, 8876865, 8876199, 8870985, 8868402, 8867605, 8866492, 8866491, 8864770, 8859135, 8855235, 8853719, 8849806, 8849804, 8848261, 8846721, 8845591, 8843558, 8839900, 8839899, 8837772, 8837771, 8836209, 8835820, 8835819, 8833685, 8833683, 8829690, 8829024, 8829023, 8828305, 8825346, 8825345, 8822414, 8821970, 8821967, 8821941, 8821940, 8821932, 8817405, 8815707, 8812109, 8806111, 8805832, 8800052, 8797981, 8797533, 8797158, 8796495, 8795713, 8794701, 8794695, 8793659, 8791231, 8791230, 8790069, 8789870, 8789869, 8789866, 8789865, 8789214, 8789213, 8787924, 8784093, 8783340, 8783337, 8782919, 8782916, 8780930, 8780492, 8778608, 8778176, 8778175, 8777760, 8775725, 8774084, 8774083, 8773742, 8773380, 8772970, 8772968, 8768301, 8768204, 8763105, 8755347, 8753493, 8752747, 8752745, 8751546, 8749250, 8749249, 8747184, 8747183, 8746967, 8746207, 8746206, 8745660, 8745653, 8743459, 8736492, 8734853, 8732520, 8732519, 8732214, 8732213, 8730979, 8730977, 8726136, 8726135, 8725226, 8721555, 8719812, 8714602, 8713842, 8711972, 8711971, 8707971, 8707854, 8705506, 8687224, 8675803, 8643014, 8636447, 8626684, 8614229, 8607809, 8605255, 8591452, 8584359, 8580885, 8563667, 8541556, 8536875, 8490591, 8490199, 8487991, 8482093, 8475510, 8474155, 8471070, 8467334, 8463808, 8446872, 8442648, 8418583, 8384409, 8358668, 8357201, 8348455, 8327480, 8300605, 8292725, 8276762, 8273957, 8233768, 7614847, 6617704, 5006488)
Run Time: 0.013930
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 479 | 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",73],["thread",9671419],["thread",9664874],["thread",9613153],["thread",9612234],["thread",9607427],["thread",9582403],["thread",9573866],["thread",9566429],["thread",9565170],["thread",9564582],["thread",9549926],["thread",9548007],["thread",9541456],["thread",9539302],["thread",9509480],["thread",9485016],["thread",9478303],["thread",9472622],["thread",9471683],["thread",9436800],["thread",9407746],["thread",9398496],["thread",9356498],["thread",9350560],["thread",9344547],["thread",9339373],["thread",9338989],["thread",9327955],["thread",9327214],["thread",9327213],["thread",9318942],["thread",9315948],["thread",9309644],["thread",9302753],["thread",9295508],["thread",9278742],["thread",9278394],["thread",9270897],["thread",9265596],["thread",9264227],["thread",9247781],["thread",9247111],["thread",9245405],["thread",9245076],["thread",9245066],["thread",9245046],["thread",9244847],["thread",9244688],["thread",9234755],["thread",9234156],["thread",9232046],["thread",9225471],["thread",9217114],["thread",9206266],["thread",9196180],["thread",9192999],["thread",9189115],["thread",9176338],["thread",9175123],["thread",9157295],["thread",9157094],["thread",9155390],["thread",9152705],["thread",9151399],["thread",9148547],["thread",9144155],["thread",9144027],["thread",9143999],["thread",9143852],["thread",9143743],["thread",9143375],["thread",9143050],["thread",9130359],["thread",9098196],["thread",9090184],["thread",9075357],["thread",9075193],["thread",9067245],["thread",9046659],["thread",9036805],["thread",9033925],["thread",9002478],["thread",8989193],["thread",8964171],["thread",8950539],["thread",8948108],["thread",8947778],["thread",8940401],["thread",8934558],["thread",8901391],["thread",8895278],["thread",8889490],["thread",8889240],["thread",8887194],["thread",8883753],["thread",8853719],["thread",8843558],["thread",8839900],["thread",8837772],["thread",8835820],["thread",8829024],["thread",8812109],["thread",8796495],["thread",8793659],["thread",8790069],["thread",8789870],["thread",8787924],["thread",8778176],["thread",8773742],["thread",8768204],["thread",8752747],["thread",8746967],["thread",8746207],["thread",8745660],["thread",8732519],["thread",8726136],["thread",8725226],["thread",8721555],["thread",8714602],["thread",8711972],["thread",8707971],["thread",8707854],["thread",8675803],["thread",8643014],["thread",8626684],["thread",8614229],["thread",8607809],["thread",8591452],["thread",8584359],["thread",8580885],["thread",8563667],["thread",8536875],["thread",8487991],["thread",8475510],["thread",8474155],["thread",8471070],["thread",8463808],["thread",8446872],["thread",8442648],["thread",8418583],["thread",8384409],["thread",8358668],["thread",8357201],["thread",8348455],["thread",8300605],["thread",8292725],["thread",8276762],["thread",8273957],["thread",8233768],["thread",7614847],["thread",6617704],["thread",5006488]], 153, tinhte_xentag_tag, , {"tags":["sim s\u1ed1 g\u00e1nh"]}, date, 0, , [], 0, 1653656048, 5c24d713342875d6fcdae7737fc56437
Run Time: 0.000510