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 (2396542, 2396541, 2396540, 2396539, 2396538, 2396537, 2396536, 2396535, 2396534, 2396533, 2396532, 2396531, 2396529, 2396530, 2396528, 2396527, 2396526, 2396525, 2396524, 2396523, 2396521, 2396522, 2396520, 2396519, 2396518, 2396517, 2396516, 2396515, 2396514, 2396513, 2396512, 2396511, 2396510, 2396509, 2396508, 2396507, 2396506, 2396505, 2396504, 2396503, 2396501, 2396502, 2396500, 2396499, 2396498, 2396496, 2396497, 2396495, 2396494, 2396493, 2396492, 2396491, 2396490, 2396489, 2396488, 2396487, 2396486, 2396485, 2396484, 2396483, 2396482, 2396481, 2396480, 2396479, 2396478, 2396477, 2396476, 2396475, 2396473, 2396474, 2396472, 2396471, 2396470, 2396469, 2396468, 2396467, 2396466, 2396465, 2396464, 2396463, 2396462, 2396461, 2396460, 2396459, 2396458, 2396457, 2396456, 2396455, 2396454, 2396453, 2396452, 2396451, 2396450, 2396449, 2396448, 2396447, 2396446, 2396445, 2396444, 2396443, 2396442, 2396441, 2396440, 2396439, 2396438, 2396437, 2396436, 2396435, 2396434, 2396433, 2396432, 2396431, 2396430, 2396429, 2396428, 2396426, 2396427, 2396425, 2396423, 2396424, 2396422, 2396421, 2396420, 2396419, 2396418, 2396417, 2396416, 2396415, 2396414, 2396413, 2396412, 2396411, 2396410, 2396409, 2396408, 2396407, 2396406, 2396405, 2396404, 2396403, 2396402, 2396401, 2396400, 2396399, 2396398, 2396397, 2396396, 2396395, 2396394, 2396393, 2396392, 2396391, 2396389, 2396390, 2396388, 2396387, 2396386, 2396385, 2396384, 2396383, 2396382, 2396381, 2396380, 2396379, 2396378, 2396377, 2396376, 2396375, 2396374, 2396373, 2396372, 2396371, 2396370, 2396369, 2396368, 2396367, 2396366, 2396365, 2396364, 2396363, 2396362, 2396361, 2396360, 2396359, 2396358, 2396357, 2396356, 2396355, 2396354, 2396353, 2396352, 2396351, 2396350, 2396349, 2396348, 2396347, 2396346, 2396345, 2396344, 2396343)
Run Time: 0.003761
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 | teenusernamesdb.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | teenusernamesdb.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,teenusernamesdb.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",2396542],["thread",2396541],["thread",2396540],["thread",2396539],["thread",2396538],["thread",2396537],["thread",2396536],["thread",2396535],["thread",2396534],["thread",2396533],["thread",2396532],["thread",2396531],["thread",2396529],["thread",2396530],["thread",2396528],["thread",2396527],["thread",2396526],["thread",2396525],["thread",2396524],["thread",2396523],["thread",2396521],["thread",2396522],["thread",2396520],["thread",2396519],["thread",2396518],["thread",2396517],["thread",2396516],["thread",2396515],["thread",2396514],["thread",2396513],["thread",2396512],["thread",2396511],["thread",2396510],["thread",2396509],["thread",2396508],["thread",2396507],["thread",2396506],["thread",2396505],["thread",2396504],["thread",2396503],["thread",2396501],["thread",2396502],["thread",2396500],["thread",2396499],["thread",2396498],["thread",2396496],["thread",2396497],["thread",2396495],["thread",2396494],["thread",2396493],["thread",2396492],["thread",2396491],["thread",2396490],["thread",2396489],["thread",2396488],["thread",2396487],["thread",2396486],["thread",2396485],["thread",2396484],["thread",2396483],["thread",2396482],["thread",2396481],["thread",2396480],["thread",2396479],["thread",2396478],["thread",2396477],["thread",2396476],["thread",2396475],["thread",2396473],["thread",2396474],["thread",2396472],["thread",2396471],["thread",2396470],["thread",2396469],["thread",2396468],["thread",2396467],["thread",2396466],["thread",2396465],["thread",2396464],["thread",2396463],["thread",2396462],["thread",2396461],["thread",2396460],["thread",2396459],["thread",2396458],["thread",2396457],["thread",2396456],["thread",2396455],["thread",2396454],["thread",2396453],["thread",2396452],["thread",2396451],["thread",2396450],["thread",2396449],["thread",2396448],["thread",2396447],["thread",2396446],["thread",2396445],["thread",2396444],["thread",2396443],["thread",2396442],["thread",2396441],["thread",2396440],["thread",2396439],["thread",2396438],["thread",2396437],["thread",2396436],["thread",2396435],["thread",2396434],["thread",2396433],["thread",2396432],["thread",2396431],["thread",2396430],["thread",2396429],["thread",2396428],["thread",2396426],["thread",2396427],["thread",2396425],["thread",2396423],["thread",2396424],["thread",2396422],["thread",2396421],["thread",2396420],["thread",2396419],["thread",2396418],["thread",2396417],["thread",2396416],["thread",2396415],["thread",2396414],["thread",2396413],["thread",2396412],["thread",2396411],["thread",2396410],["thread",2396409],["thread",2396408],["thread",2396407],["thread",2396406],["thread",2396405],["thread",2396404],["thread",2396403],["thread",2396402],["thread",2396401],["thread",2396400],["thread",2396399],["thread",2396398],["thread",2396397],["thread",2396396],["thread",2396395],["thread",2396394],["thread",2396393],["thread",2396392],["thread",2396391],["thread",2396389],["thread",2396390],["thread",2396388],["thread",2396387],["thread",2396386],["thread",2396385],["thread",2396384],["thread",2396383],["thread",2396382],["thread",2396381],["thread",2396380],["thread",2396379],["thread",2396378],["thread",2396377],["thread",2396376],["thread",2396375],["thread",2396374],["thread",2396373],["thread",2396372],["thread",2396371],["thread",2396370],["thread",2396369],["thread",2396368],["thread",2396367],["thread",2396366],["thread",2396365],["thread",2396364],["thread",2396363],["thread",2396362],["thread",2396361],["thread",2396360],["thread",2396359],["thread",2396358],["thread",2396357],["thread",2396356],["thread",2396355],["thread",2396354],["thread",2396353],["thread",2396352],["thread",2396351],["thread",2396350],["thread",2396349],["thread",2396348],["thread",2396347],["thread",2396346],["thread",2396345],["thread",2396344],["thread",2396343]], 200, recent-posts, , [], date, 0, , [], 0, 1714162846, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.004831