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 (328354, 328353, 328351, 328350, 328349, 328348, 328347, 328346, 326130, 328345, 328344, 328343, 328342, 328341, 328340, 328339, 328337, 328336, 328335, 328334, 328333, 328332, 328331, 328330, 328329, 328327, 328325, 328324, 328322, 328321, 328319, 328318, 328317, 328316, 328315, 328314, 328313, 328312, 328311, 328310, 328309, 328308, 328307, 328306, 328305, 328304, 328303, 328302, 328301, 328300, 328299, 328298, 328297, 328296, 328295, 328294, 328293, 328292, 328291, 328290, 328289, 328288, 328287, 328285, 328284, 328283, 328282, 328280, 328279, 328278, 328277, 328276, 328275, 328274, 328273, 328272, 328271, 328270, 328269, 328268, 328267, 328266, 328265, 328264, 328263, 328262, 328261, 328260, 328259, 328258, 328257, 328256, 328255, 328254, 328253, 328252, 328251, 328250, 328249, 328248, 328247, 328246, 328245, 328244, 328243, 328242, 76715, 328241, 328240, 328239, 328238, 328237, 328236, 328235, 328234, 328233, 328232, 328231, 328230, 328229, 328228, 328227, 328226, 328225, 328224, 328223, 328222, 328221, 328220, 328219, 328218, 328217, 328216, 328215, 328214, 328213, 328212, 328211, 328210, 328209, 328207, 328206, 328204, 328203, 328202, 328200, 328199, 68046, 328198, 328197, 328196, 328195, 328194, 328193, 328192, 328191, 328190, 328189, 328188, 328187, 328186, 328185, 328184, 328183, 328182, 328181, 328180, 328179, 328178, 328061, 328177, 328176, 328175, 328174, 328173, 328172, 328171, 328170, 328169, 328168, 328167, 328166, 328164, 328163, 328162, 328161, 328160, 328159, 328158, 328157, 328156, 328155, 328154, 328153, 328152, 328151, 328150, 328149, 328148, 328147)
Run Time: 0.003371
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 | qbkdcom_new.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | qbkdcom_new.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,qbkdcom_new.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",328354],["thread",328353],["thread",328351],["thread",328350],["thread",328349],["thread",328348],["thread",328347],["thread",328346],["thread",326130],["thread",328345],["thread",328344],["thread",328343],["thread",328342],["thread",328341],["thread",328340],["thread",328339],["thread",328337],["thread",328336],["thread",328335],["thread",328334],["thread",328333],["thread",328332],["thread",328331],["thread",328330],["thread",328329],["thread",328327],["thread",328325],["thread",328324],["thread",328322],["thread",328321],["thread",328319],["thread",328318],["thread",328317],["thread",328316],["thread",328315],["thread",328314],["thread",328313],["thread",328312],["thread",328311],["thread",328310],["thread",328309],["thread",328308],["thread",328307],["thread",328306],["thread",328305],["thread",328304],["thread",328303],["thread",328302],["thread",328301],["thread",328300],["thread",328299],["thread",328298],["thread",328297],["thread",328296],["thread",328295],["thread",328294],["thread",328293],["thread",328292],["thread",328291],["thread",328290],["thread",328289],["thread",328288],["thread",328287],["thread",328285],["thread",328284],["thread",328283],["thread",328282],["thread",328280],["thread",328279],["thread",328278],["thread",328277],["thread",328276],["thread",328275],["thread",328274],["thread",328273],["thread",328272],["thread",328271],["thread",328270],["thread",328269],["thread",328268],["thread",328267],["thread",328266],["thread",328265],["thread",328264],["thread",328263],["thread",328262],["thread",328261],["thread",328260],["thread",328259],["thread",328258],["thread",328257],["thread",328256],["thread",328255],["thread",328254],["thread",328253],["thread",328252],["thread",328251],["thread",328250],["thread",328249],["thread",328248],["thread",328247],["thread",328246],["thread",328245],["thread",328244],["thread",328243],["thread",328242],["thread",76715],["thread",328241],["thread",328240],["thread",328239],["thread",328238],["thread",328237],["thread",328236],["thread",328235],["thread",328234],["thread",328233],["thread",328232],["thread",328231],["thread",328230],["thread",328229],["thread",328228],["thread",328227],["thread",328226],["thread",328225],["thread",328224],["thread",328223],["thread",328222],["thread",328221],["thread",328220],["thread",328219],["thread",328218],["thread",328217],["thread",328216],["thread",328215],["thread",328214],["thread",328213],["thread",328212],["thread",328211],["thread",328210],["thread",328209],["thread",328207],["thread",328206],["thread",328204],["thread",328203],["thread",328202],["thread",328200],["thread",328199],["thread",68046],["thread",328198],["thread",328197],["thread",328196],["thread",328195],["thread",328194],["thread",328193],["thread",328192],["thread",328191],["thread",328190],["thread",328189],["thread",328188],["thread",328187],["thread",328186],["thread",328185],["thread",328184],["thread",328183],["thread",328182],["thread",328181],["thread",328180],["thread",328179],["thread",328178],["thread",328061],["thread",328177],["thread",328176],["thread",328175],["thread",328174],["thread",328173],["thread",328172],["thread",328171],["thread",328170],["thread",328169],["thread",328168],["thread",328167],["thread",328166],["thread",328164],["thread",328163],["thread",328162],["thread",328161],["thread",328160],["thread",328159],["thread",328158],["thread",328157],["thread",328156],["thread",328155],["thread",328154],["thread",328153],["thread",328152],["thread",328151],["thread",328150],["thread",328149],["thread",328148],["thread",328147]], 200, recent-posts, , [], date, 0, , [], 0, 1714196269, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000247