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 (27503, 27500, 27497, 27495, 27493, 27491, 27490, 27488, 27486, 27484, 27482, 27471, 27470, 27462, 27461, 27460, 27459, 27458, 27457, 27456, 27455, 27454, 27453, 27452, 27451, 27450, 27449, 27448, 27441, 27440, 27439, 27438, 27437, 27421, 27420, 27419, 27418, 27417, 27416, 27415, 27414, 27411, 27410, 27409, 27408, 27402, 27401, 27400, 27399, 27398, 27397, 27396, 19728, 19725, 19723, 19691, 19690, 19689, 19688, 19687, 19686, 19685, 19684, 19683, 19682, 19681, 19680, 19679, 19678, 19677, 19676, 19675, 19674, 19673, 19672, 19671, 19670, 19669, 19668, 19667, 19662, 19661, 19660, 19659, 19658, 19657, 19656, 19655, 19654, 19653, 19652, 19651, 19650, 19649, 19645, 19644, 19643, 19642, 19641, 19640, 19639, 19638, 19618, 19617, 19616, 19615, 19614, 19613, 19612, 19611, 19610, 19609, 19608, 19607, 19606, 19605, 19604, 19601, 19600, 19599, 19598, 19597, 19596, 19595, 19563, 19562, 19561, 19559, 19557, 19555, 19553, 19551, 19548, 19529, 19528, 19527, 19526, 19525, 19524, 19523, 19522, 19521, 19520, 19519, 19518, 19517, 19516, 19513, 19512, 19511, 19510, 19499, 19495, 19494, 19493, 19459, 19457, 19456, 19455, 19454, 19453, 19452, 19451, 19450, 19437, 19436, 19435, 19434, 19433, 19432, 19431, 19430, 19429, 19428, 19427, 19426, 19425, 19424, 19423, 19422, 19420, 19419, 19418, 19413, 19412, 19411, 19410, 19409, 19407, 19406, 19405, 19404, 19403, 19402, 19401, 19400, 19399, 19398, 19397, 19396)
Run Time: 0.028681
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 | chanpro.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | chanpro.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | chanpro.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,chanpro.thread.node_id | 1 | Using where |
INSERT INTO xf_tag_result_cache
(tag_id, user_id, cache_date, expiry_date, results)
VALUES
(?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
cache_date = VALUES(cache_date),
expiry_date = VALUES(expiry_date),
results = VALUES(results)
Params: 1772, 0, 1714351372, 1714354972, [["thread",27503],["thread",27500],["thread",27497],["thread",27495],["thread",27493],["thread",27491],["thread",27490],["thread",27488],["thread",27486],["thread",27484],["thread",27482],["thread",27471],["thread",27470],["thread",27462],["thread",27461],["thread",27460],["thread",27459],["thread",27458],["thread",27457],["thread",27456],["thread",27455],["thread",27454],["thread",27453],["thread",27452],["thread",27451],["thread",27450],["thread",27449],["thread",27448],["thread",27441],["thread",27440],["thread",27439],["thread",27438],["thread",27437],["thread",27421],["thread",27420],["thread",27419],["thread",27418],["thread",27417],["thread",27416],["thread",27415],["thread",27414],["thread",27411],["thread",27410],["thread",27409],["thread",27408],["thread",27402],["thread",27401],["thread",27400],["thread",27399],["thread",27398],["thread",27397],["thread",27396],["thread",19728],["thread",19725],["thread",19723],["thread",19691],["thread",19690],["thread",19689],["thread",19688],["thread",19687],["thread",19686],["thread",19685],["thread",19684],["thread",19683],["thread",19682],["thread",19681],["thread",19680],["thread",19679],["thread",19678],["thread",19677],["thread",19676],["thread",19675],["thread",19674],["thread",19673],["thread",19672],["thread",19671],["thread",19670],["thread",19669],["thread",19668],["thread",19667],["thread",19662],["thread",19661],["thread",19660],["thread",19659],["thread",19658],["thread",19657],["thread",19656],["thread",19655],["thread",19654],["thread",19653],["thread",19652],["thread",19651],["thread",19650],["thread",19649],["thread",19645],["thread",19644],["thread",19643],["thread",19642],["thread",19641],["thread",19640],["thread",19639],["thread",19638],["thread",19618],["thread",19617],["thread",19616],["thread",19615],["thread",19614],["thread",19613],["thread",19612],["thread",19611],["thread",19610],["thread",19609],["thread",19608],["thread",19607],["thread",19606],["thread",19605],["thread",19604],["thread",19601],["thread",19600],["thread",19599],["thread",19598],["thread",19597],["thread",19596],["thread",19595],["thread",19563],["thread",19562],["thread",19561],["thread",19559],["thread",19557],["thread",19555],["thread",19553],["thread",19551],["thread",19548],["thread",19529],["thread",19528],["thread",19527],["thread",19526],["thread",19525],["thread",19524],["thread",19523],["thread",19522],["thread",19521],["thread",19520],["thread",19519],["thread",19518],["thread",19517],["thread",19516],["thread",19513],["thread",19512],["thread",19511],["thread",19510],["thread",19499],["thread",19495],["thread",19494],["thread",19493],["thread",19459],["thread",19457],["thread",19456],["thread",19455],["thread",19454],["thread",19453],["thread",19452],["thread",19451],["thread",19450],["thread",19437],["thread",19436],["thread",19435],["thread",19434],["thread",19433],["thread",19432],["thread",19431],["thread",19430],["thread",19429],["thread",19428],["thread",19427],["thread",19426],["thread",19425],["thread",19424],["thread",19423],["thread",19422],["thread",19420],["thread",19419],["thread",19418],["thread",19413],["thread",19412],["thread",19411],["thread",19410],["thread",19409],["thread",19407],["thread",19406],["thread",19405],["thread",19404],["thread",19403],["thread",19402],["thread",19401],["thread",19400],["thread",19399],["thread",19398],["thread",19397],["thread",19396]]
Run Time: 0.001845