SELECT
post.*
,
thread.*, thread.user_id AS thread_user_id, thread.username AS thread_username,
thread.post_date AS thread_post_date,
post.user_id, post.username, post.post_date,
node.title AS node_title, node.node_name,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
permission.cache_value AS node_permission_cache
FROM xf_post AS post
INNER JOIN xf_thread AS thread ON
(thread.thread_id = post.thread_id)
INNER JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_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 post.post_id IN (2033551, 2028635, 2028626, 2028614, 2018812, 2018811, 2017283, 2017257, 2016296, 2016295, 2011620, 2011619, 2011387, 2011372, 2011277, 2011227, 2011222, 2011210, 2011207, 2011200, 2011178, 2011140, 2010417, 2007925, 2007857, 2007809, 2007805, 2005100, 2005096, 2005091, 2000980, 1997422, 1997420, 1992714, 1992712, 1988333, 1987991, 1981443, 1981149, 1980237, 1980180, 1971596, 1964703, 1964701, 1961462, 1961346, 1961337, 1959675, 1959663, 1959641, 1958144, 1947585, 1947264, 1944692, 1944679, 1944583, 1944529, 1944431, 1944420, 1944419, 1942790, 1941486, 1941442, 1941427, 1941154, 1941153, 1941103, 1941102, 1941037, 1941027, 1940872, 1940848, 1939051, 1936212, 1935403, 1935395, 1935385, 1934836, 1934834, 1934830, 1934349, 1934348, 1931582, 1931579, 1931578, 1929734, 1929670, 1929389, 1929380, 1926695, 1926691, 1925844, 1925692, 1925691, 1925657, 1925656, 1925642, 1925635, 1925432, 1923838, 1923835, 1922699, 1919765, 1919675, 1919632, 1919571, 1917657, 1917420, 1917105, 1917067, 1917063, 1915689, 1915487, 1915449, 1909046, 1906058, 1906056, 1904675, 1904589, 1901644, 1901642, 1898571, 1898253, 1898170, 1898163, 1897657, 1897656, 1894297, 1894250, 1894197, 1894179, 1894178, 1894165, 1894139, 1894125, 1894085, 1894066, 1888570, 1888414, 1884856, 1883880, 1883858, 1879888, 1879740, 1879732, 1879581, 1879580, 1879558, 1879557, 1879556, 1879543, 1879246, 1876391, 1876207, 1874597, 1869924, 1869847, 1869617, 1869616, 1856687, 1856598, 1853766, 1849630, 1849625, 1845099, 1845072, 1840585, 1840580, 1840136, 1822309, 1822304, 1819008, 1817139, 1817134, 1807173, 1804242, 1804009, 1803808, 1803579, 1803569, 1803414, 1797042, 1796669, 1796579, 1792845, 1792822, 1792263, 1786962, 1786894, 1786870, 1786783, 1786763, 1786759, 1786300, 1784689, 1783328, 1783288, 1780509, 1779373)
Run Time: 0.009837
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | PRIMARY,thread_id_post_date,thread_id_position | PRIMARY | 4 | | 199 | Using index condition; Using MRR |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | thelatebayv2_.post.user_id | 1 | |
SIMPLE | thread | eq_ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post | PRIMARY | 4 | thelatebayv2_.post.thread_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: [["post",2033551],["post",2028635],["post",2028626],["post",2028614],["post",2018812],["post",2018811],["post",2017283],["post",2017257],["post",2016296],["post",2016295],["post",2011620],["post",2011619],["post",2011387],["post",2011372],["post",2011277],["post",2011227],["post",2011222],["post",2011210],["post",2011207],["post",2011200],["post",2011178],["post",2011140],["post",2010417],["post",2007925],["post",2007857],["post",2007809],["post",2007805],["post",2005100],["post",2005096],["post",2005091],["post",2000980],["post",1997422],["post",1997420],["post",1992714],["post",1992712],["post",1988333],["post",1987991],["post",1981443],["post",1981149],["post",1980237],["post",1980180],["post",1971596],["post",1964703],["post",1964701],["post",1961462],["post",1961346],["post",1961337],["post",1959675],["post",1959663],["post",1959641],["post",1958144],["post",1947585],["post",1947264],["post",1944692],["post",1944679],["post",1944583],["post",1944529],["post",1944431],["post",1944420],["post",1944419],["post",1942790],["post",1941486],["post",1941442],["post",1941427],["post",1941154],["post",1941153],["post",1941103],["post",1941102],["post",1941037],["post",1941027],["post",1940872],["post",1940848],["post",1939051],["post",1936212],["post",1935403],["post",1935395],["post",1935385],["post",1934836],["post",1934834],["post",1934830],["post",1934349],["post",1934348],["post",1931582],["post",1931579],["post",1931578],["post",1929734],["post",1929670],["post",1929389],["post",1929380],["post",1926695],["post",1926691],["post",1925844],["post",1925692],["post",1925691],["post",1925657],["post",1925656],["post",1925642],["post",1925635],["post",1925432],["post",1923838],["post",1923835],["post",1922699],["post",1919765],["post",1919675],["post",1919632],["post",1919571],["post",1917657],["post",1917420],["post",1917105],["post",1917067],["post",1917063],["post",1915689],["post",1915487],["post",1915449],["post",1909046],["post",1906058],["post",1906056],["post",1904675],["post",1904589],["post",1901644],["post",1901642],["post",1898571],["post",1898253],["post",1898170],["post",1898163],["post",1897657],["post",1897656],["post",1894297],["post",1894250],["post",1894197],["post",1894179],["post",1894178],["post",1894165],["post",1894139],["post",1894125],["post",1894085],["thread",96086],["post",1888570],["post",1888414],["post",1884856],["post",1883880],["post",1883858],["post",1879888],["post",1879740],["post",1879732],["post",1879581],["post",1879580],["post",1879558],["post",1879557],["post",1879556],["post",1879543],["post",1879246],["post",1876391],["post",1876207],["post",1874597],["post",1869924],["post",1869847],["post",1869617],["post",1869616],["post",1856687],["post",1856598],["post",1853766],["post",1849630],["post",1849625],["post",1845099],["post",1845072],["post",1840585],["post",1840580],["post",1840136],["post",1822309],["post",1822304],["post",1819008],["post",1817139],["post",1817134],["post",1807173],["post",1804242],["post",1804009],["post",1803808],["post",1803579],["post",1803569],["post",1803414],["post",1797042],["post",1796669],["post",1796579],["post",1792845],["post",1792822],["post",1792263],["post",1786962],["post",1786894],["post",1786870],["post",1786783],["post",1786763],["post",1786759],["post",1786300],["post",1784689],["post",1783328],["post",1783288],["post",1780509],["post",1779373]], 199, , ptfe, {"node":"18"}, date, 0, , [], 0, 1716045099, ef07649eaba8f2d2113910c298329d40
Run Time: 0.000775