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,
uix_last_post_user.avatar_date AS uix_last_post_user_avatar_date,
uix_last_post_user.username AS uix_last_post_user_username,
uix_last_post_user.avatar_width AS uix_last_post_user_avatar_width,
uix_last_post_user.avatar_height AS uix_last_post_user_avatar_height,
uix_last_post_user.gravatar AS uix_last_post_user_gravatar,
uix_last_post_user.gender AS uix_last_post_user_gender,
uix_last_post_user.is_banned AS uix_last_post_user_is_banned
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)LEFT JOIN xf_user AS uix_last_post_user ON (uix_last_post_user.user_id = thread.last_post_user_id)
WHERE thread.thread_id IN (534281, 523812, 482726, 534287, 493318, 452682, 534283, 534288, 529041, 534192, 434018, 515241, 462930, 287197, 531471, 209815, 404775, 533844, 293747, 445164, 306115, 451600, 288838, 418582, 459103, 452271, 442387, 447285, 534274, 396477, 438544, 533806, 507049, 374165, 530548, 451329, 295946, 534265, 534269, 479898, 534279, 250557, 534272, 464244, 534286, 534285, 534284, 522822, 396905, 463660, 534116, 449963, 534168, 534282, 531929, 533147, 533169, 296444, 502669, 450591, 501719, 534278, 534240, 531516, 527463, 534277, 534268, 153242, 534249, 533983, 534259, 525492, 534275, 450284, 454839, 534273, 534215, 531391, 527754, 534271, 395151, 532049, 534267, 466731, 345397, 458654, 501672, 526231, 457683, 275262, 478105, 418583, 533170, 511107, 534264, 453467, 68782, 258168, 534266, 348850, 534263, 450285, 507421, 223196, 534262, 534218, 534261, 534247, 511225, 534256, 273203, 534258, 534142, 320017, 534257, 153498, 85561, 534214, 534253, 357769, 409184, 530446, 449753, 533348, 530100, 534255, 267073, 297768, 304055, 124287, 529505, 534254, 534189, 460875, 534131, 232368, 534243, 534237, 433390, 534248, 527477, 528915, 534241, 534251, 534252, 534244, 534207, 484389, 307484, 265045, 534238, 366390, 534197, 533427, 534242, 524244, 521922, 265258, 534245, 534246, 534167, 532851, 217022, 361228, 407877, 304341, 534216, 431925, 533028, 534236, 530713, 533765, 429886, 261434, 534198, 404319, 330182, 531502, 534239, 534232, 322273, 450631, 530918, 294163, 348349, 534219, 534231, 521666, 534126, 374293, 534235, 534234, 534076, 534080, 534233, 534230, 465565, 533393, 534229, 457170, 396908, 534209, 533919, 485704, 431638, 534222, 530188, 452722, 534228, 534185, 534227, 532529, 527321, 534190, 534225, 450280, 534221, 197586, 534223, 534210, 534205, 423144, 533585, 534213, 176191, 534002, 534217, 533014, 532435, 280376, 534191, 459832, 534212, 534211, 452804, 534057, 379278, 299864, 534188, 534208, 403771, 534206, 534204, 534195, 534088, 534194, 534202, 533485, 534017, 371143)
Run Time: 0.001691
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 250 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | audiclub_xf.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | audiclub_xf.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,audiclub_xf.thread.node_id | 1 | Using where |
SIMPLE | uix_last_post_user | eq_ref | PRIMARY | PRIMARY | 4 | audiclub_xf.thread.last_post_user_id | 1 | |
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",534281],["thread",523812],["thread",482726],["thread",534287],["thread",493318],["thread",452682],["thread",534283],["thread",534288],["thread",529041],["thread",534192],["thread",434018],["thread",515241],["thread",462930],["thread",287197],["thread",531471],["thread",209815],["thread",404775],["thread",533844],["thread",293747],["thread",445164],["thread",306115],["thread",451600],["thread",288838],["thread",418582],["thread",459103],["thread",452271],["thread",442387],["thread",447285],["thread",534274],["thread",396477],["thread",438544],["thread",533806],["thread",507049],["thread",374165],["thread",530548],["thread",451329],["thread",295946],["thread",534265],["thread",534269],["thread",479898],["thread",534279],["thread",250557],["thread",534272],["thread",464244],["thread",534286],["thread",534284],["thread",522822],["thread",396905],["thread",463660],["thread",534116],["thread",449963],["thread",534168],["thread",534282],["thread",531929],["thread",533147],["thread",533169],["thread",296444],["thread",502669],["thread",450591],["thread",501719],["thread",534278],["thread",534240],["thread",531516],["thread",527463],["thread",534277],["thread",534268],["thread",153242],["thread",534249],["thread",533983],["thread",534259],["thread",525492],["thread",534275],["thread",450284],["thread",454839],["thread",534273],["thread",534215],["thread",531391],["thread",527754],["thread",534271],["thread",395151],["thread",532049],["thread",534267],["thread",466731],["thread",345397],["thread",458654],["thread",501672],["thread",526231],["thread",457683],["thread",275262],["thread",478105],["thread",418583],["thread",533170],["thread",511107],["thread",534264],["thread",453467],["thread",68782],["thread",258168],["thread",534266],["thread",348850],["thread",534263],["thread",450285],["thread",507421],["thread",223196],["thread",534262],["thread",534218],["thread",534261],["thread",534247],["thread",511225],["thread",534256],["thread",273203],["thread",534258],["thread",534142],["thread",320017],["thread",534257],["thread",153498],["thread",85561],["thread",534214],["thread",534253],["thread",357769],["thread",409184],["thread",530446],["thread",449753],["thread",533348],["thread",530100],["thread",534255],["thread",267073],["thread",297768],["thread",304055],["thread",124287],["thread",529505],["thread",534254],["thread",534189],["thread",460875],["thread",534131],["thread",232368],["thread",534243],["thread",534237],["thread",433390],["thread",534248],["thread",527477],["thread",528915],["thread",534241],["thread",534251],["thread",534252],["thread",534244],["thread",534207],["thread",484389],["thread",307484],["thread",265045],["thread",534238],["thread",366390],["thread",534197],["thread",533427],["thread",534242],["thread",524244],["thread",521922],["thread",265258],["thread",534245],["thread",534246],["thread",534167],["thread",532851],["thread",217022],["thread",361228],["thread",407877],["thread",304341],["thread",534216],["thread",431925],["thread",533028],["thread",534236],["thread",530713],["thread",533765],["thread",429886],["thread",261434],["thread",534198],["thread",404319],["thread",330182],["thread",531502],["thread",534239],["thread",534232],["thread",322273],["thread",450631],["thread",530918],["thread",294163],["thread",348349],["thread",534219],["thread",534231],["thread",521666],["thread",534126],["thread",374293],["thread",534235],["thread",534234],["thread",534076],["thread",534080],["thread",534233],["thread",534230],["thread",465565],["thread",533393],["thread",534229],["thread",457170],["thread",396908],["thread",534209],["thread",533919],["thread",485704],["thread",431638],["thread",534222],["thread",530188],["thread",452722],["thread",534228],["thread",534185],["thread",534227],["thread",532529],["thread",527321],["thread",534190],["thread",534225],["thread",450280],["thread",534221],["thread",197586],["thread",534223],["thread",534210],["thread",534205],["thread",423144],["thread",533585],["thread",534213],["thread",176191],["thread",534002],["thread",534217],["thread",533014],["thread",532435],["thread",280376],["thread",534191],["thread",459832],["thread",534212],["thread",534211],["thread",452804],["thread",534057],["thread",379278],["thread",299864],["thread",534188],["thread",534208],["thread",403771],["thread",534206],["thread",534204],["thread",534195],["thread",534088],["thread",534194],["thread",534202],["thread",533485],["thread",534017],["thread",371143]], 249, recent-posts, , [], date, 0, , [], 0, 1713990195, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000812