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 (2396395, 2396394, 2396393, 2396392, 2396391, 2396389, 2396390, 2396388, 2396387, 2396386, 2396385, 2396384, 2396383, 2396382, 2396381, 2396380, 2396379, 2396378, 2396377, 2396376, 2396375, 2396374, 2396373, 2396372, 2396371, 2396370, 2396369, 2396368, 2396367, 2396366, 2396365, 2396364, 2396363, 2396362, 2396361, 2396360, 2396359, 2396358, 2396357, 2396356, 2396355, 2396354, 2396353, 2396352, 2396351, 2396350, 2396349, 2396348, 2396347, 2396346, 2396345, 2396344, 2396343, 2396342, 2396341, 2396340, 2396339, 2396338, 2396337, 2396336, 2396335, 2396334, 2396333, 2396332, 2396331, 2396330, 2396329, 2396328, 2396327, 2396326, 2396325, 2396324, 2396323, 6414, 2396322, 2396321, 2396320, 2396319, 2396318, 2396317, 2396316, 2396315, 2396314, 2396313, 2396312, 2396311, 2396310, 2396309, 2396308, 2396307, 2396306, 2396305, 2396304, 2396303, 2396302, 2396301, 2396300, 2396299, 2396298, 2396297, 2396296, 2396295, 2396294, 2396293, 2396292, 2396291, 2396290, 2396289, 2396288, 2396287, 2396286, 2396285, 2396284, 2396283, 2396282, 2396281, 2396280, 2396279, 2396278, 2396277, 2396276, 2396275, 2396274, 2396273, 2396272, 2396271, 2396270, 2396269, 2396268, 2396267, 2396266, 2396265, 2396264, 2396263, 2396262, 2396261, 2396260, 2396259, 2396258, 2396257, 2396256, 2396255, 2396254, 2396253, 2396252, 2396251, 2396250, 2396249, 2396248, 2396247, 2396246, 2396245, 2396244, 2396243, 2396242, 2396241, 2396240, 2396239, 2396238, 2396237, 2396236, 2396235, 2396234, 2396233, 2396232, 2396231, 2396230, 2396229, 2396228, 2396227, 2396226, 2396225, 2396224, 2396223, 2396221, 2396222, 2396220, 2396219, 2396218, 2396217, 2396216, 2396215, 2396214, 2396213, 2396212, 2396211, 2396210, 2396209, 2396208, 2396207, 2396206, 2396205, 2396204, 2396203, 2396202, 2396201, 2396200, 2396199, 2396198, 2396197)
Run Time: 0.004243
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 | teenusernamesdb.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | teenusernamesdb.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,teenusernamesdb.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",2396395],["thread",2396394],["thread",2396393],["thread",2396392],["thread",2396391],["thread",2396389],["thread",2396390],["thread",2396388],["thread",2396387],["thread",2396386],["thread",2396385],["thread",2396384],["thread",2396383],["thread",2396382],["thread",2396381],["thread",2396380],["thread",2396379],["thread",2396378],["thread",2396377],["thread",2396376],["thread",2396375],["thread",2396374],["thread",2396373],["thread",2396372],["thread",2396371],["thread",2396370],["thread",2396369],["thread",2396368],["thread",2396367],["thread",2396366],["thread",2396365],["thread",2396364],["thread",2396363],["thread",2396362],["thread",2396361],["thread",2396360],["thread",2396359],["thread",2396358],["thread",2396357],["thread",2396356],["thread",2396355],["thread",2396354],["thread",2396353],["thread",2396352],["thread",2396351],["thread",2396350],["thread",2396349],["thread",2396348],["thread",2396347],["thread",2396346],["thread",2396345],["thread",2396344],["thread",2396343],["thread",2396342],["thread",2396341],["thread",2396340],["thread",2396339],["thread",2396338],["thread",2396337],["thread",2396336],["thread",2396335],["thread",2396334],["thread",2396333],["thread",2396332],["thread",2396331],["thread",2396330],["thread",2396329],["thread",2396328],["thread",2396327],["thread",2396326],["thread",2396325],["thread",2396324],["thread",2396323],["thread",6414],["thread",2396322],["thread",2396321],["thread",2396320],["thread",2396319],["thread",2396318],["thread",2396317],["thread",2396316],["thread",2396315],["thread",2396314],["thread",2396313],["thread",2396312],["thread",2396311],["thread",2396310],["thread",2396309],["thread",2396308],["thread",2396307],["thread",2396306],["thread",2396305],["thread",2396304],["thread",2396303],["thread",2396302],["thread",2396301],["thread",2396300],["thread",2396299],["thread",2396298],["thread",2396297],["thread",2396296],["thread",2396295],["thread",2396294],["thread",2396293],["thread",2396292],["thread",2396291],["thread",2396290],["thread",2396289],["thread",2396288],["thread",2396287],["thread",2396286],["thread",2396285],["thread",2396284],["thread",2396283],["thread",2396282],["thread",2396281],["thread",2396280],["thread",2396279],["thread",2396278],["thread",2396277],["thread",2396276],["thread",2396275],["thread",2396274],["thread",2396273],["thread",2396272],["thread",2396271],["thread",2396270],["thread",2396269],["thread",2396268],["thread",2396267],["thread",2396266],["thread",2396265],["thread",2396264],["thread",2396263],["thread",2396262],["thread",2396261],["thread",2396260],["thread",2396259],["thread",2396258],["thread",2396257],["thread",2396256],["thread",2396255],["thread",2396254],["thread",2396253],["thread",2396252],["thread",2396251],["thread",2396250],["thread",2396249],["thread",2396248],["thread",2396247],["thread",2396246],["thread",2396245],["thread",2396244],["thread",2396243],["thread",2396242],["thread",2396241],["thread",2396240],["thread",2396239],["thread",2396238],["thread",2396237],["thread",2396236],["thread",2396235],["thread",2396234],["thread",2396233],["thread",2396232],["thread",2396231],["thread",2396230],["thread",2396229],["thread",2396228],["thread",2396227],["thread",2396226],["thread",2396225],["thread",2396224],["thread",2396223],["thread",2396221],["thread",2396222],["thread",2396220],["thread",2396219],["thread",2396218],["thread",2396217],["thread",2396216],["thread",2396215],["thread",2396214],["thread",2396213],["thread",2396212],["thread",2396211],["thread",2396210],["thread",2396209],["thread",2396208],["thread",2396207],["thread",2396206],["thread",2396205],["thread",2396204],["thread",2396203],["thread",2396202],["thread",2396201],["thread",2396200],["thread",2396199],["thread",2396198],["thread",2396197]], 200, recent-posts, , [], date, 0, , [], 0, 1714157432, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.001568