SELECT
post.*
,
thread.*, thread.user_id AS thread_user_id, thread.username AS thread_username,
thread.post_date AS thread_post_date,
post.user_id, post.username, post.post_date,
node.title AS node_title, node.node_name,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
permission.cache_value AS node_permission_cache
FROM xf_post AS post
INNER JOIN xf_thread AS thread ON
(thread.thread_id = post.thread_id)
INNER JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_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 post.post_id IN (360926, 360894, 360846, 360845, 360834, 360829, 360769, 360768, 360556, 360550, 360549, 360546, 360545, 360516, 360515, 360473, 360462, 360405, 360401, 360397, 360383, 360363, 360357, 360319, 360318, 360308, 360306, 360231, 360230, 360228, 359970, 359969, 359968, 359857, 359695, 359694, 359676, 359672, 359605, 359363, 359361, 359357, 359354, 359353, 359327, 359311, 359293, 359264, 359258, 359257, 359255, 359245, 359244, 359240, 359224, 359195, 359192, 359180, 359172, 359154, 359153, 359147, 359141, 359132, 359093, 359059, 358771, 358701, 358644, 358568, 358528, 358473, 358440, 358435, 358407, 358296, 358200, 358196, 358072, 358071, 358053, 357831, 357823, 357821, 357819, 357816, 357814, 357803, 357802, 357733, 357229, 357213, 357207, 357204, 357203, 357200, 357199, 357197, 357196, 357195, 357194, 357192, 357191, 357189, 357060, 357037, 357027, 357025, 357022, 357021, 357019, 357018, 357005, 356959, 356928, 356927, 356785, 356724, 356718, 356677, 356263, 356257, 356253, 356134, 355984, 355973, 355965, 355932, 355920, 355915, 355910, 355909, 355880, 355879, 355872, 355831, 355825, 355824, 355823, 355788, 355781, 355771, 355770, 355652, 355605, 355602, 355601, 355424, 355139, 355054, 355049, 355046, 355045, 354741, 354739, 354530, 354233, 354214, 354187, 354181, 354171, 354103, 353895, 353858, 353732, 353730, 353728, 353427, 353423, 353419, 353380, 353375, 353374, 353369, 353368, 353367, 353363, 353352, 353328, 353287, 353104, 352906, 352903, 352844, 352790, 352665, 352573, 352412, 352407, 352379, 352317, 352297, 352098, 352074, 351991, 351729, 351707, 351703, 351690, 351688)
Run Time: 0.004638
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | PRIMARY,thread_id_post_date,thread_id_position | PRIMARY | 4 | | 200 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | admin_xfschaats.post.user_id | 1 | |
SIMPLE | thread | eq_ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post | PRIMARY | 4 | admin_xfschaats.post.thread_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | admin_xfschaats.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xfschaats.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: [["post",360926],["post",360894],["post",360846],["post",360845],["post",360834],["post",360829],["post",360769],["post",360768],["post",360556],["post",360550],["post",360549],["post",360546],["post",360545],["post",360516],["post",360515],["post",360473],["post",360462],["post",360405],["post",360401],["post",360397],["post",360383],["post",360363],["post",360357],["post",360319],["post",360318],["post",360308],["post",360306],["post",360231],["post",360230],["post",360228],["post",359970],["post",359969],["post",359968],["post",359857],["post",359695],["post",359694],["post",359676],["post",359672],["post",359605],["post",359363],["post",359361],["post",359357],["post",359354],["post",359353],["post",359327],["post",359311],["post",359293],["post",359264],["post",359258],["post",359257],["post",359255],["post",359245],["post",359244],["post",359240],["post",359224],["post",359195],["post",359192],["post",359180],["post",359172],["post",359154],["post",359153],["post",359147],["post",359141],["post",359132],["post",359093],["post",359059],["post",358771],["post",358701],["post",358644],["post",358568],["post",358528],["post",358473],["post",358440],["post",358435],["post",358407],["post",358296],["post",358200],["post",358196],["post",358072],["post",358071],["post",358053],["post",357831],["post",357823],["post",357821],["post",357819],["post",357816],["post",357814],["post",357803],["post",357802],["post",357733],["post",357229],["post",357213],["post",357207],["post",357204],["post",357203],["post",357200],["post",357199],["post",357197],["post",357196],["post",357195],["post",357194],["post",357192],["post",357191],["post",357189],["post",357060],["post",357037],["post",357027],["post",357025],["post",357022],["post",357021],["post",357019],["post",357018],["post",357005],["post",356959],["post",356928],["post",356927],["post",356785],["post",356724],["post",356718],["post",356677],["post",356263],["post",356257],["post",356253],["post",356134],["post",355984],["post",355973],["post",355965],["post",355932],["post",355920],["post",355915],["post",355910],["post",355909],["post",355880],["post",355879],["post",355872],["post",355831],["post",355825],["post",355824],["post",355823],["post",355788],["post",355781],["post",355771],["post",355770],["post",355652],["post",355605],["post",355602],["post",355601],["post",355424],["post",355139],["post",355054],["post",355049],["post",355046],["post",355045],["post",354741],["post",354739],["post",354530],["post",354233],["post",354214],["post",354187],["post",354181],["post",354171],["post",354103],["post",353895],["post",353858],["post",353732],["post",353730],["post",353728],["post",353427],["post",353423],["post",353419],["post",353380],["post",353375],["post",353374],["post",353369],["post",353368],["post",353367],["post",353363],["post",353352],["post",353328],["post",353287],["post",353104],["post",352906],["post",352903],["post",352844],["post",352790],["post",352665],["post",352573],["post",352412],["post",352407],["post",352379],["post",352317],["post",352297],["post",352098],["post",352074],["post",351991],["post",351729],["post",351707],["post",351703],["post",351690],["post",351688]], 200, , junioren, [], date, 0, 2130, [], 0, 1716079809, 1d330feb08427c3d7f605f22dadb60d7
Run Time: 0.000743