SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
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_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 (328402, 328401, 328400, 328399, 328398, 328397, 328396, 328395, 328394, 328393, 328392, 328391, 328390, 328389, 328388, 328387, 328386, 328385, 328384, 328383, 328382, 328381, 328380, 328379, 328378, 328377, 328376, 328375, 328374, 328373, 328372, 328371, 328369, 328370, 328368, 328367, 328366, 328365, 328364, 324864, 328362, 328361, 328360, 328359, 328358, 328357, 328356, 328355, 328354, 328353, 328351, 328350, 328349, 328348, 328347, 328346, 326130, 328345, 328344, 328343, 328342, 328341, 328340, 328339, 328337, 328336, 328335, 328334, 328333, 328332, 328331, 328330, 328329, 328327, 328325, 328324, 328322, 328321, 328319, 328318, 328317, 328316, 328315, 328314, 328313, 328312, 328311, 328310, 328309, 328308, 328307, 328306, 328305, 328304, 328303, 328302, 328301, 328300, 328299, 328298, 328297, 328296, 328295, 328294, 328293, 328292, 328291, 328290, 328289, 328288, 328287, 328285, 328284, 328283, 328282, 328280, 328279, 328278, 328277, 328276, 328275, 328274, 328273, 328272, 328271, 328270, 328269, 328268, 328267, 328266, 328265, 328264, 328263, 328262, 328261, 328260, 328259, 328258, 328257, 328256, 328255, 328254, 328253, 328252, 328251, 328250, 328249, 328248, 328247, 328246, 328245, 328244, 328243, 328242, 76715, 328241, 328240, 328239, 328238, 328237, 328236, 328235, 328234, 328233, 328232, 328231, 328230, 328229, 328228, 328227, 328226, 328225, 328224, 328223, 328222, 328221, 328220, 328219, 328218, 328217, 328216, 328215, 328214, 328213, 328212, 328211, 328210, 328209, 328207, 328206, 328204, 328203, 328202, 328200, 328199, 68046, 328198, 328197, 328196, 328195)
Run Time: 0.002624
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | qbkdcom_new.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | qbkdcom_new.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,qbkdcom_new.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: [["thread",328402],["thread",328401],["thread",328400],["thread",328399],["thread",328398],["thread",328397],["thread",328396],["thread",328395],["thread",328394],["thread",328393],["thread",328392],["thread",328391],["thread",328390],["thread",328389],["thread",328388],["thread",328387],["thread",328386],["thread",328385],["thread",328384],["thread",328383],["thread",328382],["thread",328381],["thread",328380],["thread",328379],["thread",328378],["thread",328377],["thread",328376],["thread",328375],["thread",328374],["thread",328373],["thread",328372],["thread",328371],["thread",328369],["thread",328370],["thread",328368],["thread",328367],["thread",328366],["thread",328365],["thread",328364],["thread",324864],["thread",328362],["thread",328361],["thread",328360],["thread",328359],["thread",328358],["thread",328357],["thread",328356],["thread",328355],["thread",328354],["thread",328353],["thread",328351],["thread",328350],["thread",328349],["thread",328348],["thread",328347],["thread",328346],["thread",326130],["thread",328345],["thread",328344],["thread",328343],["thread",328342],["thread",328341],["thread",328340],["thread",328339],["thread",328337],["thread",328336],["thread",328335],["thread",328334],["thread",328333],["thread",328332],["thread",328331],["thread",328330],["thread",328329],["thread",328327],["thread",328325],["thread",328324],["thread",328322],["thread",328321],["thread",328319],["thread",328318],["thread",328317],["thread",328316],["thread",328315],["thread",328314],["thread",328313],["thread",328312],["thread",328311],["thread",328310],["thread",328309],["thread",328308],["thread",328307],["thread",328306],["thread",328305],["thread",328304],["thread",328303],["thread",328302],["thread",328301],["thread",328300],["thread",328299],["thread",328298],["thread",328297],["thread",328296],["thread",328295],["thread",328294],["thread",328293],["thread",328292],["thread",328291],["thread",328290],["thread",328289],["thread",328288],["thread",328287],["thread",328285],["thread",328284],["thread",328283],["thread",328282],["thread",328280],["thread",328279],["thread",328278],["thread",328277],["thread",328276],["thread",328275],["thread",328274],["thread",328273],["thread",328272],["thread",328271],["thread",328270],["thread",328269],["thread",328268],["thread",328267],["thread",328266],["thread",328265],["thread",328264],["thread",328263],["thread",328262],["thread",328261],["thread",328260],["thread",328259],["thread",328258],["thread",328257],["thread",328256],["thread",328255],["thread",328254],["thread",328253],["thread",328252],["thread",328251],["thread",328250],["thread",328249],["thread",328248],["thread",328247],["thread",328246],["thread",328245],["thread",328244],["thread",328243],["thread",328242],["thread",76715],["thread",328241],["thread",328240],["thread",328239],["thread",328238],["thread",328237],["thread",328236],["thread",328235],["thread",328234],["thread",328233],["thread",328232],["thread",328231],["thread",328230],["thread",328229],["thread",328228],["thread",328227],["thread",328226],["thread",328225],["thread",328224],["thread",328223],["thread",328222],["thread",328221],["thread",328220],["thread",328219],["thread",328218],["thread",328217],["thread",328216],["thread",328215],["thread",328214],["thread",328213],["thread",328212],["thread",328211],["thread",328210],["thread",328209],["thread",328207],["thread",328206],["thread",328204],["thread",328203],["thread",328202],["thread",328200],["thread",328199],["thread",68046],["thread",328198],["thread",328197],["thread",328196],["thread",328195]], 200, recent-posts, , [], date, 0, , [], 0, 1714236455, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000199