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 (99623, 100303, 101363, 101362, 101365, 101361, 98213, 56810, 101356, 101364, 101346, 101360, 101352, 101354, 99246, 35574, 101283, 101342, 96978, 101359, 101358, 101357, 101300, 101334, 101260, 101347, 198, 101349, 53455, 55126, 101353, 101351, 101355, 100493, 77793, 13966, 79992, 101345, 101129, 101341, 101350, 101348, 101238, 101332, 101340, 101335, 101343, 101336, 101302, 101337, 101065, 92042, 101339, 101321, 101307, 100960, 101309, 101338, 101293, 98146, 101311, 101253, 101261, 101280, 101190, 101325, 101312, 101316, 101333, 99982, 101301, 101331, 99354, 101305, 101327, 101297, 101323, 101308, 101296, 101246, 101299, 101292, 101286, 101287, 101288, 101285, 101289, 101235, 101281, 101329, 60769, 101326, 101282, 101320, 101210, 100440, 101324, 101315, 101322, 101317, 96636, 99414, 100896, 101319, 101318, 101306, 101314, 101313, 99677, 101310, 61472, 101304, 100948, 101295, 98182, 98593, 101279, 101303, 101271, 100289, 101294, 101272, 101298, 101267, 74019, 101290, 101126, 87740, 101284, 101276, 101278, 101250, 101152, 101270, 100145, 101277, 101245, 101244, 101242, 101273, 97293, 101146, 101269, 101268, 101041, 100937, 101264, 90886, 101265, 101256, 101266, 96904, 101221, 101197, 101258, 78369, 101263, 101262, 99782, 101248, 101251, 101255, 101254, 101252, 101114, 35599, 101249, 101202, 81414, 101247, 62002, 98664, 101218, 101188, 101237, 85940, 100465, 101243, 101164, 101236, 101241, 101189, 101232, 101233, 101222, 101223, 101224, 101208, 101220, 101240, 83478, 68437, 53169, 101228, 101229, 101239, 587, 101231, 101135, 101234)
Run Time: 0.004367
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 | thelatebayv2_.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | thelatebayv2_.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,thelatebayv2_.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",100303],["thread",101363],["thread",101362],["thread",101365],["thread",101361],["thread",98213],["thread",56810],["thread",101356],["thread",101364],["thread",101346],["thread",101360],["thread",101352],["thread",101354],["thread",99246],["thread",35574],["thread",101283],["thread",101342],["thread",96978],["thread",101359],["thread",101358],["thread",101357],["thread",101300],["thread",101334],["thread",101260],["thread",101347],["thread",198],["thread",101349],["thread",53455],["thread",55126],["thread",101353],["thread",101351],["thread",101355],["thread",100493],["thread",77793],["thread",13966],["thread",79992],["thread",101345],["thread",101129],["thread",101341],["thread",101350],["thread",101348],["thread",101238],["thread",101332],["thread",101340],["thread",101335],["thread",101343],["thread",101336],["thread",101302],["thread",101337],["thread",101065],["thread",92042],["thread",101339],["thread",101321],["thread",101307],["thread",100960],["thread",101309],["thread",101338],["thread",101293],["thread",98146],["thread",101311],["thread",101253],["thread",101261],["thread",101280],["thread",101190],["thread",101325],["thread",101312],["thread",101316],["thread",99982],["thread",101301],["thread",101331],["thread",99354],["thread",101305],["thread",101327],["thread",101297],["thread",101323],["thread",101308],["thread",101296],["thread",101246],["thread",101299],["thread",101292],["thread",101286],["thread",101287],["thread",101288],["thread",101285],["thread",101289],["thread",101235],["thread",101281],["thread",101329],["thread",60769],["thread",101326],["thread",101282],["thread",101320],["thread",101210],["thread",100440],["thread",101324],["thread",101315],["thread",101322],["thread",101317],["thread",96636],["thread",99414],["thread",100896],["thread",101319],["thread",101318],["thread",101306],["thread",101314],["thread",101313],["thread",99677],["thread",101310],["thread",61472],["thread",101304],["thread",100948],["thread",101295],["thread",98182],["thread",98593],["thread",101279],["thread",101303],["thread",101271],["thread",100289],["thread",101294],["thread",101272],["thread",101298],["thread",101267],["thread",74019],["thread",101290],["thread",101126],["thread",87740],["thread",101284],["thread",101276],["thread",101278],["thread",101250],["thread",101152],["thread",101270],["thread",100145],["thread",101277],["thread",101245],["thread",101244],["thread",101242],["thread",101273],["thread",101146],["thread",101269],["thread",101268],["thread",101041],["thread",100937],["thread",101264],["thread",90886],["thread",101265],["thread",101256],["thread",101266],["thread",96904],["thread",101221],["thread",101197],["thread",101258],["thread",78369],["thread",101263],["thread",101262],["thread",99782],["thread",101248],["thread",101251],["thread",101255],["thread",101254],["thread",101114],["thread",35599],["thread",101249],["thread",101202],["thread",81414],["thread",101247],["thread",62002],["thread",98664],["thread",101218],["thread",101188],["thread",101237],["thread",85940],["thread",100465],["thread",101243],["thread",101164],["thread",101236],["thread",101241],["thread",101189],["thread",101232],["thread",101233],["thread",101222],["thread",101223],["thread",101224],["thread",101208],["thread",101220],["thread",101240],["thread",83478],["thread",68437],["thread",53169],["thread",101228],["thread",101229],["thread",101239],["thread",587],["thread",101231],["thread",101135],["thread",101234]], 196, recent-posts, , [], date, 0, , [], 0, 1715590951, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000303