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 (9688822, 9686835, 9678302, 9672876, 9668075, 9667162, 9667161, 9666856, 9666815, 9666432, 9665980, 9664785, 9664784, 9662241, 9661775, 9661524, 9657894, 9654893, 9651974, 9650101, 9650100, 9648921, 9648920, 9648700, 9646915, 9646673, 9641180, 9639078, 9630400, 9629507, 9627346, 9626844, 9625938, 9623333, 9621875, 9621874, 9621219, 9616251, 9609060, 9602941, 9602940, 9599883, 9582650, 9580000, 9573920, 9573914, 9572865, 9572732, 9568818, 9567511, 9565735, 9565567, 9565566, 9565371, 9561314, 9556320, 9555463, 9549280, 9546017, 9541919, 9541175, 9541107, 9541085, 9539744, 9539393, 9538065, 9536186, 9533619, 9531288, 9529861, 9528406, 9526173, 9525943, 9522761, 9511601, 9508425, 9508420, 9508417, 9507549, 9505921, 9503941, 9503462, 9502397, 9501268, 9501267, 9498910, 9483762, 9479900, 9476479, 9475405, 9469791, 9466642, 9464691, 9464475, 9463503, 9463502, 9463355, 9463354, 9458656, 9458213, 9458182, 9455333, 9454248, 9454088, 9454086, 9453800, 9452593, 9449285, 9449283, 9445142, 9439651, 9439650, 9438579, 9438415, 9436202, 9435106, 9434485, 9431405, 9428593, 9427159, 9423345, 9423221, 9423010, 9421733, 9421732, 9421629, 9421620, 9414833, 9413726, 9413183, 9411566, 9406929, 9405237, 9402407, 9397582, 9396524, 9396296, 9396295, 9396294, 9395436, 9393924, 9393923, 9391995, 9390329, 9390328, 9389666, 9383458, 9379873, 9378455, 9376490, 9374256, 9371472, 9368631, 9368112, 9365278, 9365276, 9364218, 9362227, 9358407, 9358273, 9355377, 9353995, 9351455, 9345471, 9345470, 9341178, 9341177, 9339350, 9339349, 9337814, 9335257, 9334809, 9334524, 9331831, 9331107, 9328880, 9328738, 9328481, 9323771, 9323767, 9322663, 9321352, 9321351, 9319508, 9319362, 9316604, 9316491, 9308902, 9308901, 9307638, 9307403, 9307396, 9307389, 9307386, 9307383, 9307304, 9307303, 9306743, 9304855, 9303799, 9303798, 9303743, 9303742, 9292576, 9291963, 9291238, 9290479, 9285590, 9282229, 9280062, 9278967, 9275437, 9273929, 9273928, 9269346, 9267217, 9267215, 9263381, 9261856, 9261151, 9260611, 9260266, 9255996, 9255940, 9251799, 9251797, 9247204, 9247200, 9247199, 9247198, 9247197, 9247196, 9247195, 9246805, 9243569, 9242575, 9240077, 9234288, 9233742, 9233546, 9230627, 9224501, 9224306, 9224081, 9224080, 9224078, 9220198, 9220197, 9216903, 9211272, 9203300, 9202910, 9197153, 9197151, 9195810, 9191717, 9188553, 9187565, 9174946, 9174944, 9169760, 9163716, 9161437, 9161216, 9156793, 9156154, 9153565, 9153564, 9153563, 9150916, 9150134, 9146274, 9142719, 9142154, 9140860, 9140244, 9137793, 9137529, 9135449, 9134231, 9125336, 9122384, 9122383, 9120949, 9118028, 9118027, 9115366, 9108660, 9103872, 9102978, 9099503, 9097469, 9092059, 9092058, 9087932, 9085663, 9084587, 9081834, 9080712, 9080710, 9080709, 9080707, 9078949, 9078843, 9077630, 9077628, 9075679, 9075267, 9072612, 9067638, 9066796, 9065521, 9065519, 9064762, 9061537, 9054396, 9053644, 9053643, 9052790, 9051056, 9050229, 9047212, 9047088, 9046310, 9042606, 9036431, 9035750, 9035749, 9032500, 9032468, 9015967, 9015966, 9014196, 9012425, 9001434, 9000719, 9000177, 9000162, 8999575, 8998589, 8998584, 8998583, 8998581, 8996793, 8996686, 8996546, 8996112, 8994238, 8992050, 8991981, 8991936, 8991637, 8985618, 8985381, 8984503, 8984224, 8983839, 8980805, 8980803, 8980083, 8980082, 8978232, 8975886, 8973777, 8968718, 8964765, 8964096, 8962881, 8960503, 8959115, 8958159, 8955828, 8951780, 8949708, 8949323, 8948073, 8948071, 8946871, 8946037, 8945769, 8945768, 8945766, 8943189, 8941329, 8938001, 8934854, 8933648, 8933647, 8933641, 8933402, 8932902, 8931838, 8931018, 8931016, 8930148, 8930147, 8929265, 8929264, 8926989, 8925107, 8923378, 8923377, 8923356, 8917222, 8914688, 8913737, 8913735, 8911159, 8908921, 8906853, 8906417, 8906415, 8905478, 8902769, 8900960, 8900959, 8899803, 8899511, 8899507, 8899506, 8898303, 8896605, 8892542, 8892530, 8891829, 8886926, 8886922, 8886921, 8886052, 8881360, 8881359, 8881019, 8879729, 8879557, 8878948, 8877354, 8877215, 8877214, 8872757, 8872756, 8865664, 8865583, 8864737, 8862868, 8861274, 8859188, 8859187, 8857086, 8856793, 8856753, 8856751, 8853986, 8852843, 8849489, 8849487, 8837373, 8837150, 8835377, 8835368, 8830763, 8830762, 8830336, 8828544, 8823908, 8814908, 8814907, 8809249, 8809231, 8809229, 8801983, 8800663, 8800144, 8798913, 8797078, 8797076, 8795967, 8795590, 8794520, 8789038, 8777113, 8777108, 8776854, 8776852, 8776848, 8776846, 8776326, 8771432, 8763516, 8763512, 8763511, 8763509, 8756807, 8755074, 8747857, 8737974, 8730837, 8726633, 8725750, 8725748, 8723761, 8722528, 8718430, 8718429, 8715875, 8715850, 8714974, 8712784, 8712783, 8711717, 8711716, 8710271, 8710258, 8708205, 8707520, 8705047, 8705046, 8705045, 8696358, 8695214, 8693946, 8690862, 8689788, 8687689, 8687055, 8684417, 8682961, 8677670, 8677161, 8675758, 8675247, 8674043, 8671593, 8670186, 8670093, 8668163, 8663906, 8662755, 8662754, 8662198, 8661108, 8660743, 8658684, 8656896, 8656531, 8655295, 8654541, 8651697, 8649184, 8646357, 8633734, 8632996, 8632457, 8628281, 8627101, 8625500, 8624991, 8624990, 8624775, 8622132, 8622131, 8622129, 8618688, 8618171, 8618170, 8618059, 8617721, 8615883, 8612217, 8611588, 8609857, 8606831, 8606246, 8604356, 8603188, 8598390, 8597298, 8596939, 8591125, 8587541, 8587509, 8583660, 8583428, 8582630, 8582629, 8581225, 8580475, 8579432, 8579053, 8578215, 8577964, 8574988, 8572534, 8572457, 8570014, 8569671, 8566966, 8563484, 8560483, 8560473, 8559751, 8559589, 8559588, 8556709, 8555880, 8555622, 8555303, 8555280, 8549401, 8546488, 8546378, 8525218, 8523968, 8522385, 8520431, 8519186, 8517255, 8512528, 8503814, 8491456, 8480751, 8479105, 8473107, 8472598, 8472056, 8471834, 8469480, 8462012, 8458765, 8438096, 8407802, 8396920, 8366269, 8362731, 8353968, 8352451, 8351704, 8350724, 8344728, 8343749, 8343016, 8338854, 8331265, 8328098, 8327137, 8322316, 8315730, 8315155, 8312928, 8311704, 8310794, 8309646, 8297976, 8289201, 8289200, 8289198, 8250234, 8250228, 8250227, 8160391, 8148333, 8138456, 8137327, 8137325, 8133757, 8112804, 8067808, 8054298, 8017002, 8009642, 7921502, 7806415, 7674661, 7643456, 7502908, 7469325, 7419580, 7371845, 7340234, 7333398, 7331749, 7322035, 7256986, 6892685, 6803632, 6774743, 6403439, 6131162, 5780332, 5624070, 4188970, 3685920, 3575320, 2667044, 2620709, 630500)
Run Time: 0.021309
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 695 | 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",14],["thread",9688822],["thread",9668075],["thread",9666856],["thread",9666432],["thread",9665980],["thread",9662241],["thread",9661775],["thread",9661524],["thread",9648921],["thread",9648700],["thread",9646915],["thread",9646673],["thread",9641180],["thread",9639078],["thread",9630400],["thread",9629507],["thread",9627346],["thread",9623333],["thread",9621875],["thread",9616251],["thread",9599883],["thread",9582650],["thread",9573914],["thread",9568818],["thread",9567511],["thread",9565735],["thread",9565567],["thread",9565371],["thread",9556320],["thread",9549280],["thread",9546017],["thread",9539393],["thread",9536186],["thread",9531288],["thread",9528406],["thread",9525943],["thread",9522761],["thread",9503941],["thread",9503462],["thread",9502397],["thread",9501268],["thread",9479900],["thread",9476479],["thread",9475405],["thread",9463503],["thread",9463355],["thread",9458182],["thread",9452593],["thread",9449285],["thread",9439651],["thread",9438579],["thread",9427159],["thread",9423345],["thread",9421733],["thread",9421629],["thread",9413183],["thread",9411566],["thread",9402407],["thread",9397582],["thread",9396296],["thread",9393924],["thread",9391995],["thread",9374256],["thread",9371472],["thread",9365278],["thread",9364218],["thread",9355377],["thread",9341178],["thread",9339350],["thread",9334809],["thread",9334524],["thread",9328880],["thread",9323771],["thread",9323767],["thread",9322663],["thread",9321352],["thread",9319362],["thread",9316604],["thread",9316491],["thread",9308902],["thread",9307403],["thread",9307396],["thread",9307389],["thread",9306743],["thread",9304855],["thread",9292576],["thread",9285590],["thread",9282229],["thread",9278967],["thread",9267217],["thread",9267215],["thread",9255996],["thread",9251799],["thread",9247204],["thread",9240077],["thread",9234288],["thread",9224081],["thread",9195810],["thread",9174946],["thread",9169760],["thread",9163716],["thread",9156154],["thread",9134231],["thread",9118028],["thread",9115366],["thread",9103872],["thread",9099503],["thread",9097469],["thread",9092059],["thread",9081834],["thread",9077630],["thread",9075679],["thread",9066796],["thread",9065521],["thread",9053644],["thread",9050229],["thread",9046310],["thread",9036431],["thread",9035750],["thread",9032468],["thread",9015967],["thread",8999575],["thread",8998589],["thread",8996112],["thread",8994238],["thread",8991637],["thread",8980805],["thread",8980083],["thread",8978232],["thread",8975886],["thread",8968718],["thread",8964096],["thread",8960503],["thread",8958159],["thread",8951780],["thread",8943189],["thread",8933402],["thread",8931018],["thread",8929265],["thread",8923356],["thread",8917222],["thread",8913737],["thread",8908921],["thread",8902769],["thread",8900960],["thread",8886926],["thread",8881360],["thread",8879557],["thread",8878948],["thread",8877215],["thread",8865664],["thread",8865583],["thread",8861274],["thread",8856753],["thread",8852843],["thread",8837373],["thread",8837150],["thread",8830336],["thread",8828544],["thread",8814908],["thread",8809249],["thread",8809231],["thread",8800663],["thread",8794520],["thread",8789038],["thread",8747857],["thread",8722528],["thread",8715875],["thread",8715850],["thread",8711717],["thread",8696358],["thread",8693946],["thread",8687055],["thread",8684417],["thread",8682961],["thread",8670186],["thread",8670093],["thread",8662198],["thread",8661108],["thread",8660743],["thread",8658684],["thread",8656531],["thread",8649184],["thread",8646357],["thread",8633734],["thread",8632457],["thread",8624775],["thread",8618688],["thread",8618171],["thread",8618059],["thread",8617721],["thread",8612217],["thread",8611588],["thread",8609857],["thread",8606831],["thread",8604356],["thread",8603188],["thread",8597298],["thread",8591125],["thread",8587509],["thread",8583660],["thread",8581225],["thread",8577964],["thread",8572534],["thread",8572457],["thread",8569671],["thread",8566966],["thread",8563484],["thread",8560483],["thread",8560473],["thread",8559751],["thread",8559589],["thread",8556709],["thread",8549401],["thread",8546488],["thread",8546378],["thread",8525218],["thread",8523968],["thread",8519186],["thread",8517255],["thread",8512528],["thread",8503814],["thread",8491456],["thread",8480751],["thread",8472598],["thread",8472056],["thread",8471834],["thread",8469480],["thread",8462012],["thread",8438096],["thread",8407802],["thread",8396920],["thread",8366269],["thread",8362731],["thread",8353968],["thread",8352451],["thread",8351704],["thread",8350724],["thread",8344728],["thread",8343749],["thread",8343016],["thread",8338854],["thread",8331265],["thread",8328098],["thread",8327137],["thread",8322316],["thread",8315155],["thread",8312928],["thread",8311704],["thread",8310794],["thread",8309646],["thread",8297976],["thread",8160391],["thread",8148333],["thread",8067808],["thread",8054298],["thread",8017002],["thread",7921502],["thread",7806415],["thread",7674661],["thread",7643456],["thread",7502908],["thread",7469325],["thread",7419580],["thread",7371845],["thread",7340234],["thread",7333398],["thread",7331749],["thread",7322035],["thread",7256986],["thread",6892685],["thread",6803632],["thread",6774743],["thread",6403439],["thread",6131162],["thread",5780332],["thread",5624070],["thread",3575320],["thread",630500]], 280, tinhte_xentag_tag, , {"tags":["modem wifi"]}, date, 0, , [], 0, 1660078165, 6c832bfa18b7c7c96d69e68056d0678b
Run Time: 0.000607