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 (11799, 11798, 11797, 11796, 11795, 11794, 11793, 11792, 11791, 11790, 11789, 11788, 11787, 11786, 11785, 11784, 11783, 11782, 11781, 11780, 11779, 11778, 11777, 11776, 11775, 11774, 11773, 11772, 11771, 11770, 11769, 11768, 11767, 11766, 11765, 11764, 11763, 11762, 11761, 11760, 11759, 11758, 11757, 11756, 11755, 11754, 11753, 11752, 11751, 11750, 11749, 11748, 11747, 11746, 11745, 11744, 11743, 11742, 11741, 11740, 11739, 11738, 11737, 11736, 11735, 11734, 11733, 11732, 11731, 11730, 11729, 11728, 11727, 11726, 11725, 11724, 11723, 11722, 11721, 11720, 11719, 11718, 11717, 11716, 11715, 11714, 11713, 11712, 11711, 11710, 11709, 11708, 11707, 11706, 11705, 11704, 11703, 11702, 11701, 11700, 11699, 11698, 11697, 11696, 11695, 11694, 11693, 11692, 11691, 11690, 11689, 11688, 11687, 11686, 11685, 11684, 11683, 11682, 11681, 11680, 11679, 11678, 11677, 11676, 11675, 11674, 11673, 11672, 11671, 11670, 11669, 11668, 11667, 11666, 11665, 11664, 11663, 11662, 11661, 11660, 11659, 11658, 11657, 11656, 11655, 11654, 11653, 11652, 11651, 11650, 11649, 11648, 11646, 11645, 11644, 11643, 11642, 11641, 11640, 11639, 11638, 11637, 11636, 11635, 11634, 11633, 11632, 11631, 11630, 11629, 11628, 11627, 11626, 11625, 11624, 11623, 11622, 11621, 11620, 11619, 11618, 11617, 11616, 11615, 11614, 11613, 11612, 11611, 11610, 11609, 11608, 11607, 11606, 11605, 11604, 11603, 11602, 11601, 11600, 11599)
Run Time: 0.000532
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 | tugrghshosting_diendanduoc.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | tugrghshosting_diendanduoc.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,tugrghshosting_diendanduoc.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",11799],["thread",11798],["thread",11797],["thread",11796],["thread",11795],["thread",11794],["thread",11793],["thread",11792],["thread",11791],["thread",11790],["thread",11789],["thread",11788],["thread",11787],["thread",11786],["thread",11785],["thread",11784],["thread",11783],["thread",11782],["thread",11781],["thread",11780],["thread",11779],["thread",11778],["thread",11777],["thread",11776],["thread",11775],["thread",11774],["thread",11773],["thread",11772],["thread",11771],["thread",11770],["thread",11769],["thread",11768],["thread",11767],["thread",11766],["thread",11765],["thread",11764],["thread",11763],["thread",11762],["thread",11761],["thread",11760],["thread",11759],["thread",11758],["thread",11757],["thread",11756],["thread",11755],["thread",11754],["thread",11753],["thread",11752],["thread",11751],["thread",11750],["thread",11749],["thread",11748],["thread",11747],["thread",11746],["thread",11745],["thread",11744],["thread",11743],["thread",11742],["thread",11741],["thread",11740],["thread",11739],["thread",11738],["thread",11737],["thread",11736],["thread",11735],["thread",11734],["thread",11733],["thread",11732],["thread",11731],["thread",11730],["thread",11729],["thread",11728],["thread",11727],["thread",11726],["thread",11725],["thread",11724],["thread",11723],["thread",11722],["thread",11721],["thread",11720],["thread",11719],["thread",11718],["thread",11717],["thread",11716],["thread",11715],["thread",11714],["thread",11713],["thread",11712],["thread",11711],["thread",11710],["thread",11709],["thread",11708],["thread",11707],["thread",11706],["thread",11705],["thread",11704],["thread",11703],["thread",11702],["thread",11701],["thread",11700],["thread",11699],["thread",11698],["thread",11697],["thread",11696],["thread",11695],["thread",11694],["thread",11693],["thread",11692],["thread",11691],["thread",11690],["thread",11689],["thread",11688],["thread",11687],["thread",11686],["thread",11685],["thread",11684],["thread",11683],["thread",11682],["thread",11681],["thread",11680],["thread",11679],["thread",11678],["thread",11677],["thread",11676],["thread",11675],["thread",11674],["thread",11673],["thread",11672],["thread",11671],["thread",11670],["thread",11669],["thread",11668],["thread",11667],["thread",11666],["thread",11665],["thread",11664],["thread",11663],["thread",11662],["thread",11661],["thread",11660],["thread",11659],["thread",11658],["thread",11657],["thread",11656],["thread",11655],["thread",11654],["thread",11653],["thread",11652],["thread",11651],["thread",11650],["thread",11649],["thread",11648],["thread",11646],["thread",11645],["thread",11644],["thread",11643],["thread",11642],["thread",11641],["thread",11640],["thread",11639],["thread",11638],["thread",11637],["thread",11636],["thread",11635],["thread",11634],["thread",11633],["thread",11632],["thread",11631],["thread",11630],["thread",11629],["thread",11628],["thread",11627],["thread",11626],["thread",11625],["thread",11624],["thread",11623],["thread",11622],["thread",11621],["thread",11620],["thread",11619],["thread",11618],["thread",11617],["thread",11616],["thread",11615],["thread",11614],["thread",11613],["thread",11612],["thread",11611],["thread",11610],["thread",11609],["thread",11608],["thread",11607],["thread",11606],["thread",11605],["thread",11604],["thread",11603],["thread",11602],["thread",11601],["thread",11600],["thread",11599]], 200, recent-posts, , [], date, 0, , [], 0, 1610807945, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000256