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 (101450, 56810, 101447, 55126, 101448, 100079, 101441, 101407, 101435, 100303, 101436, 101434, 101438, 101446, 101440, 100493, 100714, 35574, 101426, 101439, 100028, 101445, 101412, 100960, 101419, 101002, 101437, 101444, 101443, 13966, 101417, 61472, 77793, 101410, 101431, 101418, 101423, 99590, 101427, 101422, 101433, 587, 101356, 101416, 101190, 101432, 83478, 81153, 75470, 101430, 101424, 101268, 99982, 101425, 101428, 101403, 101409, 101421, 92042, 101405, 101398, 101415, 101401, 101293, 101311, 35599, 101413, 101400, 101408, 101411, 101374, 101404, 101406, 96588, 98286, 101402, 101371, 78777, 98213, 101395, 101399, 101397, 100311, 99218, 101389, 99984, 101355, 99677, 101392, 101347, 101382, 101396, 198, 94675, 101388, 101391, 101393, 101300, 101387, 101390, 101394, 101373, 12061, 101141, 101381, 101385, 99782, 96978, 100880, 97430, 101362, 101380, 101386, 101189, 101384, 101383, 101379, 101375, 101378, 101363, 101126, 101352, 101342, 101366, 101361, 101297, 101360, 101335, 101334, 101364, 101377, 101343, 101340, 101349, 101370, 101376, 100839, 53455, 100948, 101310, 101369, 101346, 99623, 101341, 101365, 101368, 101302, 68437, 99246, 101367, 101359, 101354, 101283, 101358, 101357, 101260, 101353, 101351, 79992, 101345, 101129, 101350, 101348, 101238, 101332, 101336, 101337, 101065, 101339, 101321, 101307, 101309, 101338, 98146, 101253, 101261, 101280, 101325, 101312, 101316, 101333, 101301, 101331, 99354, 101305, 101327, 101323, 101308, 101296, 101246, 101299, 101292, 101286, 101287, 101288, 101285, 101289, 101235, 101281, 101329)
Run Time: 0.003529
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using index condition |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | thelatebayv2_.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | thelatebayv2_.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,thelatebayv2_.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",101450],["thread",56810],["thread",101447],["thread",55126],["thread",101448],["thread",100079],["thread",101441],["thread",101407],["thread",101435],["thread",100303],["thread",101436],["thread",101434],["thread",101438],["thread",101446],["thread",101440],["thread",100493],["thread",100714],["thread",35574],["thread",101426],["thread",101439],["thread",101445],["thread",101412],["thread",100960],["thread",101419],["thread",101002],["thread",101437],["thread",101444],["thread",101443],["thread",13966],["thread",101417],["thread",61472],["thread",77793],["thread",101410],["thread",101431],["thread",101418],["thread",101423],["thread",99590],["thread",101427],["thread",101422],["thread",101433],["thread",587],["thread",101356],["thread",101416],["thread",101190],["thread",101432],["thread",83478],["thread",81153],["thread",75470],["thread",101430],["thread",101424],["thread",101268],["thread",99982],["thread",101425],["thread",101428],["thread",101403],["thread",101409],["thread",101421],["thread",92042],["thread",101405],["thread",101398],["thread",101415],["thread",101401],["thread",101293],["thread",101311],["thread",35599],["thread",101413],["thread",101400],["thread",101408],["thread",101411],["thread",101374],["thread",101404],["thread",101406],["thread",96588],["thread",98286],["thread",101402],["thread",101371],["thread",78777],["thread",98213],["thread",101395],["thread",101399],["thread",101397],["thread",100311],["thread",99218],["thread",101389],["thread",99984],["thread",101355],["thread",99677],["thread",101392],["thread",101347],["thread",101382],["thread",101396],["thread",198],["thread",94675],["thread",101388],["thread",101391],["thread",101393],["thread",101300],["thread",101387],["thread",101390],["thread",101394],["thread",101373],["thread",12061],["thread",101141],["thread",101381],["thread",101385],["thread",99782],["thread",96978],["thread",100880],["thread",97430],["thread",101362],["thread",101380],["thread",101386],["thread",101189],["thread",101384],["thread",101383],["thread",101379],["thread",101375],["thread",101378],["thread",101363],["thread",101126],["thread",101352],["thread",101342],["thread",101366],["thread",101361],["thread",101297],["thread",101360],["thread",101335],["thread",101334],["thread",101364],["thread",101377],["thread",101343],["thread",101340],["thread",101349],["thread",101370],["thread",101376],["thread",100839],["thread",53455],["thread",100948],["thread",101310],["thread",101369],["thread",101346],["thread",101341],["thread",101365],["thread",101368],["thread",101302],["thread",68437],["thread",99246],["thread",101367],["thread",101359],["thread",101354],["thread",101283],["thread",101358],["thread",101357],["thread",101260],["thread",101353],["thread",101351],["thread",79992],["thread",101345],["thread",101129],["thread",101350],["thread",101348],["thread",101238],["thread",101332],["thread",101336],["thread",101337],["thread",101065],["thread",101339],["thread",101321],["thread",101307],["thread",101309],["thread",101338],["thread",98146],["thread",101253],["thread",101261],["thread",101280],["thread",101325],["thread",101312],["thread",101316],["thread",101301],["thread",101331],["thread",99354],["thread",101305],["thread",101327],["thread",101323],["thread",101308],["thread",101296],["thread",101246],["thread",101299],["thread",101292],["thread",101286],["thread",101287],["thread",101288],["thread",101285],["thread",101289],["thread",101235],["thread",101281],["thread",101329]], 197, recent-posts, , [], date, 0, , [], 0, 1716906397, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000782