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 (55126, 103410, 103375, 103378, 103399, 53378, 103398, 103414, 56810, 103405, 103415, 103417, 103374, 92042, 103416, 79348, 98146, 100714, 103394, 103262, 103105, 103413, 103406, 103404, 103366, 103216, 103412, 103411, 103396, 103401, 85940, 103377, 103354, 103380, 103203, 102655, 103409, 103309, 61472, 103313, 103099, 103408, 103242, 103297, 101979, 103403, 103407, 103402, 103397, 90886, 103364, 95774, 103393, 100493, 98855, 103385, 103400, 103163, 103395, 103390, 35599, 103379, 103387, 35574, 92907, 103392, 103391, 103386, 103389, 103388, 103370, 103381, 103382, 103383, 77793, 103355, 103384, 102315, 102509, 103376, 103304, 103336, 103368, 103307, 103372, 103371, 103373, 103358, 103254, 103363, 103365, 103353, 103367, 103218, 103369, 82646, 103073, 103315, 102512, 103335, 103360, 103356, 102685, 103342, 103350, 103359, 103347, 99218, 102491, 103138, 102847, 76760, 103351, 103331, 103333, 103330, 103345, 103340, 103352, 103344, 103325, 103337, 103341, 103346, 103332, 103348, 102527, 103287, 101697, 103338, 103343, 103312, 103245, 103339, 103334, 103223, 103321, 103329, 103324, 103322, 95741, 103303, 103327, 103317, 103308, 103328, 103326, 103306, 103323, 103319, 53424, 84371, 103244, 103181, 103316, 103318, 103320, 103311, 19121, 99713, 103302, 103282, 103310, 103285, 102586, 103305, 57310, 103085, 103296, 103295, 103292, 103298, 103291, 103301, 103228, 103300, 100489, 103294, 103261, 103283, 103230, 103293, 103290, 103232, 103213, 103284, 99292, 103246, 103212, 103289, 103286, 93694, 103233, 103250, 95255, 103241, 103074, 103264, 103281, 103280)
Run Time: 0.005548
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",55126],["thread",103410],["thread",103375],["thread",103378],["thread",103399],["thread",53378],["thread",103398],["thread",103414],["thread",56810],["thread",103405],["thread",103415],["thread",103417],["thread",103374],["thread",92042],["thread",103416],["thread",79348],["thread",98146],["thread",100714],["thread",103394],["thread",103262],["thread",103105],["thread",103413],["thread",103406],["thread",103404],["thread",103366],["thread",103216],["thread",103412],["thread",103396],["thread",103401],["thread",85940],["thread",103377],["thread",103354],["thread",103380],["thread",103203],["thread",102655],["thread",103409],["thread",103309],["thread",61472],["thread",103313],["thread",103099],["thread",103408],["thread",103242],["thread",103297],["thread",101979],["thread",103403],["thread",103407],["thread",103402],["thread",103397],["thread",90886],["thread",103364],["thread",95774],["thread",103393],["thread",100493],["thread",98855],["thread",103385],["thread",103400],["thread",103163],["thread",103395],["thread",103390],["thread",35599],["thread",103379],["thread",103387],["thread",35574],["thread",92907],["thread",103392],["thread",103391],["thread",103386],["thread",103389],["thread",103388],["thread",103370],["thread",103381],["thread",103382],["thread",103383],["thread",77793],["thread",103355],["thread",103384],["thread",102315],["thread",102509],["thread",103376],["thread",103304],["thread",103336],["thread",103368],["thread",103307],["thread",103372],["thread",103371],["thread",103373],["thread",103358],["thread",103254],["thread",103363],["thread",103365],["thread",103367],["thread",103218],["thread",103369],["thread",82646],["thread",103073],["thread",103315],["thread",102512],["thread",103335],["thread",103360],["thread",103356],["thread",102685],["thread",103342],["thread",103350],["thread",103359],["thread",103347],["thread",99218],["thread",102491],["thread",103138],["thread",102847],["thread",76760],["thread",103351],["thread",103331],["thread",103333],["thread",103330],["thread",103345],["thread",103340],["thread",103352],["thread",103344],["thread",103325],["thread",103337],["thread",103341],["thread",103346],["thread",103332],["thread",103348],["thread",102527],["thread",103287],["thread",101697],["thread",103338],["thread",103343],["thread",103312],["thread",103245],["thread",103339],["thread",103334],["thread",103223],["thread",103321],["thread",103329],["thread",103324],["thread",95741],["thread",103303],["thread",103327],["thread",103317],["thread",103308],["thread",103328],["thread",103326],["thread",103306],["thread",103323],["thread",103319],["thread",53424],["thread",84371],["thread",103244],["thread",103181],["thread",103316],["thread",103318],["thread",103320],["thread",103311],["thread",19121],["thread",99713],["thread",103302],["thread",103282],["thread",103310],["thread",103285],["thread",103305],["thread",57310],["thread",103085],["thread",103296],["thread",103295],["thread",103292],["thread",103298],["thread",103291],["thread",103301],["thread",103228],["thread",103300],["thread",100489],["thread",103294],["thread",103261],["thread",103283],["thread",103230],["thread",103293],["thread",103290],["thread",103232],["thread",103213],["thread",103284],["thread",99292],["thread",103246],["thread",103212],["thread",103289],["thread",103286],["thread",93694],["thread",103233],["thread",103250],["thread",95255],["thread",103241],["thread",103074],["thread",103264],["thread",103281],["thread",103280]], 196, recent-posts, , [], date, 0, , [], 0, 1752208688, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000274