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 (9671300, 9670162, 9670161, 9651928, 9650106, 9649496, 9647142, 9647141, 9646488, 9643835, 9643834, 9643631, 9629574, 9613515, 9604153, 9582970, 9582969, 9580803, 9563971, 9554933, 9542406, 9536426, 9532848, 9528699, 9528177, 9528018, 9526561, 9525546, 9523397, 9522518, 9519456, 9516544, 9510441, 9506083, 9503744, 9502634, 9500653, 9498898, 9498023, 9496198, 9493883, 9493812, 9493122, 9493121, 9482088, 9447406, 9436599, 9436597, 9428041, 9424656, 9420077, 9420075, 9411701, 9407347, 9405007, 9397079, 9390416, 9379563, 9374527, 9357907, 9355355, 9355354, 9352271, 9338846, 9337600, 9336605, 9332699, 9329592, 9317788, 9313841, 9311554, 9298803, 9284824, 9281807, 9280086, 9280082, 9268340, 9264828, 9261363, 9260877, 9258277, 9251518, 9249184, 9234050, 9233129, 9224819, 9222043, 9222042, 9210284, 9210283, 9204027, 9195697, 9192825, 9189548, 9189427, 9188773, 9179537, 9174247, 9169124, 9169079, 9164603, 9149089, 9138688, 9129083, 9125312, 9119062, 9119050, 9111442, 9107869, 9088322, 9088152, 9087556, 9085886, 9075913, 9071028, 9065239, 9064260, 9058094, 9055285, 9055284, 9055283, 9055280, 9055279, 9036218, 9034360, 9031666, 9029671, 9023255, 9013636, 9011615, 9011505, 9007833, 8999792, 8999657, 8999499, 8998771, 8997909, 8995124, 8994284, 8990525, 8989556, 8988676, 8969134, 8967332, 8949807, 8939828, 8939467, 8938619, 8925928, 8923591, 8922679, 8921259, 8916365, 8912072, 8911687, 8910676, 8909696, 8906924, 8904696, 8904424, 8904005, 8903943, 8903374, 8893459, 8891670, 8890958, 8873503, 8872358, 8872357, 8870884, 8870815, 8870814, 8860342, 8854365, 8852175, 8851249, 8848412, 8848411, 8838196, 8831613, 8830963, 8830644, 8830614, 8830613, 8828709, 8828606, 8826501, 8825179, 8821881, 8821149, 8821147, 8804761, 8803028, 8801153, 8801151, 8798789, 8796906, 8790283, 8777912, 8776879, 8775406, 8759516, 8757884, 8756733, 8752310, 8751558, 8747624, 8746401, 8736682, 8734369, 8733591, 8733590, 8731096, 8727225, 8727224, 8721507, 8715708, 8713305, 8711132, 8710834, 8709059, 8706845, 8698905, 8694667, 8689266, 8688513, 8688502, 8679806, 8678345, 8673764, 8665493, 8664376, 8662828, 8661512, 8661203, 8656318, 8655716, 8650673, 8644499, 8643489, 8640762, 8633903, 8633279, 8632611, 8629406, 8628813, 8624250, 8620950, 8616978, 8613666, 8612706, 8610278, 8609650, 8607590, 8605361, 8602764, 8602735, 8598715, 8598714, 8595926, 8591099, 8590707, 8589676, 8588964, 8587749, 8587586, 8587049, 8585829, 8579482, 8578089, 8577237, 8575799, 8574043, 8573234, 8573186, 8572785, 8570962, 8569344, 8567763, 8567723, 8566369, 8565508, 8557967, 8552226, 8551712, 8547978, 8542218, 8541435, 8540957, 8540908, 8538863, 8532723, 8532722, 8530882, 8530416, 8522336, 8522204, 8516530, 8514757, 8514406, 8510625, 8506526, 8501905, 8501331, 8483869, 8483868, 8483455, 8483280, 8482764, 8481477, 8481288, 8473302, 8471903, 8471901, 8468788, 8468446, 8468325, 8464268, 8463363, 8459809, 8459808, 8459806, 8459655, 8457100, 8453799, 8453173, 8450200, 8449915, 8439463, 8438419, 8436044, 8432395, 8429563, 8427025, 8425553, 8420626, 8418665, 8416159, 8410589, 8409362, 8408385, 8407853, 8400020, 8398596, 8397663, 8388674, 8379971, 8378859, 8378806, 8378258, 8376119, 8375918, 8373773, 8373135, 8372731, 8371366, 8369959, 8365743, 8365119, 8355679, 8352704, 8352697, 8352455, 8352028, 8350863, 8350273, 8348211, 8345356, 8340216, 8338590, 8334810, 8332664, 8331749, 8330174, 8329146, 8328503, 8327438, 8326985, 8325754, 8325392, 8325043, 8321875, 8318409, 8309408, 8307779, 8307744, 8306818, 8306264, 8305576, 8304333, 8303262, 8302057, 8300276, 8299837, 8299766, 8296989, 8295005, 8294967, 8294071, 8293027, 8290534, 8290015, 8288997, 8288270, 8287410, 8283270, 8282944, 8281456, 8281450, 8278944, 8278942, 8278753, 8276912, 8274989, 8274502, 8272713, 8268550, 8268224, 8265935, 8264533, 8262591, 8260602, 8260576, 8258036, 8256560, 8255167, 8254876, 8254700, 8254227, 8252644, 8251329, 8250813, 8248166, 8247530, 8247374, 8245724, 8245708, 8244082, 8243185, 8240977, 8238052, 8236973, 8235161, 8233483, 8233110, 8232440, 8232439, 8231003, 8230936, 8228266, 8227859, 8225157, 8224268, 8224148, 8223984, 8221671, 8221670, 8220207, 8219594, 8216625, 8216068, 8215366, 8214785, 8214301, 8209063, 8206173, 8206082, 8203218, 8200642, 8198668, 8197257, 8196886, 8196858, 8195551, 8194847, 8192743, 8190926, 8190355, 8189470, 8189372, 8189358, 8187837, 8187551, 8187550, 8187235, 8187134, 8183832, 8181896, 8179253, 8178230, 8175124, 8172028, 8170822, 8170248, 8168776, 8162452, 8157464, 8155997, 8155814, 8153140, 8135369, 8135149, 8133669, 8131975, 8131405, 8129114, 8106840, 8089259, 8081841, 8080847, 8073797, 8061500, 8060239, 8055129, 8051571, 8047800, 8041636, 8036188, 8032654, 8026212, 8023234, 8019795, 8019673, 8000831, 7984248, 7979349, 7975743, 7961557, 7959709, 7954658, 7934258, 7932286, 7926153, 7923437, 7921604, 7919960, 7919748, 7918141, 7914853, 7893983, 7871045, 7866838, 7858053, 7857552, 7857253, 7854808, 7839619, 7837852, 7819988, 7815682, 7811952, 7802476, 7793056, 7774015, 7769212, 7762184, 7732381, 7709566, 7707458, 7698215, 7695012, 7690318, 7672466, 7660979, 7647480, 7619818, 7585012, 7584869, 7583871, 7579953, 7574664, 7553994, 7538216, 7537278, 7535248, 7534107, 7518033, 7508911, 7502870, 7500135, 7498452, 7473904, 7471535, 7458660, 7455760, 7447704, 7447628, 7442719, 7441952, 7433769, 7430511, 7428194, 7426672, 7425327, 7415172, 7413703, 7392426, 7379643, 7377837, 7377178, 7376061, 7368841, 7367380, 7354117, 7339599, 7339296, 7337717, 7319220, 7306814, 7295834, 7290241, 7255317, 7243763, 7139509, 7077698, 6971725, 6926718, 6761436, 6742104, 6573455, 6208825, 5701611, 5550007, 5132591, 4676240, 3964319, 2664416, 2614499)
Run Time: 0.018594
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 628 | 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",28],["thread",9671300],["thread",9670162],["thread",9651928],["thread",9650106],["thread",9647142],["thread",9646488],["thread",9643835],["thread",9629574],["thread",9604153],["thread",9582970],["thread",9580803],["thread",9554933],["thread",9528177],["thread",9510441],["thread",9506083],["thread",9502634],["thread",9482088],["thread",9428041],["thread",9424656],["thread",9420077],["thread",9397079],["thread",9374527],["thread",9357907],["thread",9355355],["thread",9352271],["thread",9336605],["thread",9332699],["thread",9313841],["thread",9260877],["thread",9234050],["thread",9210284],["thread",9149089],["thread",9129083],["thread",9119050],["thread",9107869],["thread",9088152],["thread",9085886],["thread",9071028],["thread",9065239],["thread",9064260],["thread",9055285],["thread",9036218],["thread",9007833],["thread",8999657],["thread",8997909],["thread",8990525],["thread",8989556],["thread",8988676],["thread",8939467],["thread",8922679],["thread",8916365],["thread",8912072],["thread",8909696],["thread",8904696],["thread",8904005],["thread",8891670],["thread",8890958],["thread",8870814],["thread",8851249],["thread",8848412],["thread",8830963],["thread",8830644],["thread",8830614],["thread",8828709],["thread",8828606],["thread",8826501],["thread",8821149],["thread",8801153],["thread",8798789],["thread",8777912],["thread",8775406],["thread",8759516],["thread",8736682],["thread",8734369],["thread",8711132],["thread",8689266],["thread",8678345],["thread",8664376],["thread",8662828],["thread",8661203],["thread",8656318],["thread",8655716],["thread",8644499],["thread",8633903],["thread",8629406],["thread",8624250],["thread",8616978],["thread",8613666],["thread",8612706],["thread",8609650],["thread",8607590],["thread",8602735],["thread",8598715],["thread",8595926],["thread",8590707],["thread",8588964],["thread",8587749],["thread",8587586],["thread",8587049],["thread",8579482],["thread",8577237],["thread",8575799],["thread",8574043],["thread",8573234],["thread",8573186],["thread",8572785],["thread",8569344],["thread",8567763],["thread",8567723],["thread",8566369],["thread",8557967],["thread",8552226],["thread",8551712],["thread",8542218],["thread",8540957],["thread",8540908],["thread",8538863],["thread",8532723],["thread",8522336],["thread",8514757],["thread",8510625],["thread",8506526],["thread",8483869],["thread",8483280],["thread",8482764],["thread",8481477],["thread",8481288],["thread",8473302],["thread",8468446],["thread",8457100],["thread",8453799],["thread",8453173],["thread",8439463],["thread",8436044],["thread",8429563],["thread",8427025],["thread",8420626],["thread",8418665],["thread",8416159],["thread",8410589],["thread",8409362],["thread",8408385],["thread",8407853],["thread",8400020],["thread",8397663],["thread",8388674],["thread",8379971],["thread",8378806],["thread",8378258],["thread",8376119],["thread",8375918],["thread",8373773],["thread",8373135],["thread",8372731],["thread",8371366],["thread",8369959],["thread",8365743],["thread",8355679],["thread",8352704],["thread",8352697],["thread",8352455],["thread",8352028],["thread",8350863],["thread",8350273],["thread",8348211],["thread",8345356],["thread",8338590],["thread",8334810],["thread",8332664],["thread",8331749],["thread",8330174],["thread",8329146],["thread",8328503],["thread",8327438],["thread",8326985],["thread",8325754],["thread",8321875],["thread",8318409],["thread",8309408],["thread",8307779],["thread",8307744],["thread",8306818],["thread",8304333],["thread",8303262],["thread",8300276],["thread",8299837],["thread",8299766],["thread",8296989],["thread",8295005],["thread",8294967],["thread",8294071],["thread",8293027],["thread",8290534],["thread",8290015],["thread",8288997],["thread",8288270],["thread",8283270],["thread",8282944],["thread",8281456],["thread",8281450],["thread",8278944],["thread",8278753],["thread",8276912],["thread",8274989],["thread",8274502],["thread",8272713],["thread",8265935],["thread",8264533],["thread",8262591],["thread",8260602],["thread",8260576],["thread",8258036],["thread",8256560],["thread",8255167],["thread",8254876],["thread",8254700],["thread",8254227],["thread",8252644],["thread",8251329],["thread",8250813],["thread",8248166],["thread",8247530],["thread",8247374],["thread",8245724],["thread",8245708],["thread",8244082],["thread",8243185],["thread",8240977],["thread",8238052],["thread",8236973],["thread",8235161],["thread",8233483],["thread",8233110],["thread",8231003],["thread",8230936],["thread",8228266],["thread",8227859],["thread",8225157],["thread",8224268],["thread",8223984],["thread",8221671],["thread",8220207],["thread",8219594],["thread",8216625],["thread",8216068],["thread",8215366],["thread",8214785],["thread",8214301],["thread",8209063],["thread",8206173],["thread",8206082],["thread",8203218],["thread",8198668],["thread",8197257],["thread",8196886],["thread",8196858],["thread",8195551],["thread",8194847],["thread",8192743],["thread",8190926],["thread",8190355],["thread",8189470],["thread",8189372],["thread",8189358],["thread",8187837],["thread",8187551],["thread",8187134],["thread",8183832],["thread",8181896],["thread",8179253],["thread",8178230],["thread",8175124],["thread",8172028],["thread",8170822],["thread",8170248],["thread",8168776],["thread",8162452],["thread",8157464],["thread",8155997],["thread",8155814],["thread",8153140],["thread",8135369],["thread",8135149],["thread",8133669],["thread",8131975],["thread",8131405],["thread",8129114],["thread",8106840],["thread",8089259],["thread",8081841],["thread",8073797],["thread",8061500],["thread",8060239],["thread",8055129],["thread",8051571],["thread",8047800],["thread",8041636],["thread",8036188],["thread",8032654],["thread",8026212],["thread",8023234],["thread",8019795],["thread",8019673],["thread",8000831],["thread",7984248],["thread",7979349],["thread",7975743],["thread",7961557],["thread",7959709],["thread",7954658],["thread",7934258],["thread",7932286],["thread",7926153],["thread",7923437],["thread",7921604],["thread",7919960],["thread",7919748],["thread",7918141],["thread",7914853],["thread",7893983],["thread",7871045],["thread",7866838],["thread",7858053],["thread",7857552],["thread",7857253],["thread",7854808],["thread",7839619],["thread",7837852],["thread",7819988],["thread",7815682],["thread",7811952],["thread",7802476],["thread",7793056],["thread",7774015],["thread",7769212],["thread",7762184],["thread",7732381],["thread",7709566],["thread",7707458],["thread",7698215],["thread",7695012],["thread",7690318],["thread",7672466],["thread",7660979],["thread",7647480],["thread",7619818],["thread",7585012],["thread",7584869],["thread",7583871],["thread",7579953],["thread",7553994],["thread",7538216],["thread",7537278],["thread",7535248],["thread",7534107],["thread",7518033],["thread",7508911],["thread",7502870],["thread",7500135],["thread",7498452],["thread",7473904],["thread",7471535],["thread",7458660],["thread",7455760],["thread",7447704],["thread",7447628],["thread",7442719],["thread",7441952],["thread",7433769],["thread",7430511],["thread",7428194],["thread",7426672],["thread",7425327],["thread",7415172],["thread",7413703],["thread",7392426],["thread",7379643],["thread",7377837],["thread",7377178],["thread",7376061],["thread",7368841],["thread",7367380],["thread",7354117],["thread",7339599],["thread",7337717],["thread",7319220],["thread",7306814],["thread",7295834],["thread",7290241],["thread",7255317],["thread",7243763],["thread",7139509],["thread",6971725],["thread",6926718],["thread",6761436],["thread",6742104],["thread",6573455],["thread",6208825],["thread",5701611],["thread",5550007],["thread",5132591],["thread",4676240],["thread",3964319],["thread",2614499]], 405, tinhte_xentag_tag, , {"tags":["\u0111\u0129a game"]}, date, 0, , [], 0, 1652796747, 5da437632588f7dbbf634a131fdc7c4d
Run Time: 0.000750