SELECT `xf_post`.*, `xf_thread_Thread_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_post`
LEFT JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_post`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread_Thread_1`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_post`.`post_id` IN (2551475, 2404299, 2298147, 2268238, 2267835, 2225238, 2180830, 2179230, 2156818, 2154025, 2152376, 2152193, 2142942, 1971941, 1951604, 1951149, 1951146, 1860916, 1746416, 1739559, 1708558, 1644601, 1644594, 1634124, 1631656, 1622675, 1603653, 1595670, 1590945, 1590897, 1590861, 1583743, 1583597, 1582530, 1581122, 1579984, 1579756, 1579673, 1578585, 1571127, 1570785, 1570566, 1557070, 1556257, 1555185, 1555026, 1554705, 1554368, 1552837, 1550593, 1549947, 1549937, 1549589, 1549416, 1548146, 1547823, 1546625, 1546036, 1534947, 1528133, 1521359, 1513656, 1513568, 1513268, 1511228, 1509734, 1509073, 1508399, 1508233, 1507659, 1507647, 1502822, 1501911, 1501060, 1500629, 1500627, 1500524, 1500522, 1500508, 1500494, 1495797, 1493184, 1492486, 1491616, 1491603, 1491218, 1490995, 1489734, 1488810, 1488801, 1488348, 1488248, 1488068, 1487993, 1487618, 1486094, 1485551, 1485022, 1484382, 1483783, 1483609, 1483346, 1482845, 1482661, 1482054, 1481847, 1481288, 1480059, 1479496, 1479480, 1479363, 1478477, 1478357, 1478348, 1478146, 1477903, 1477901, 1477896, 1477468, 1477350, 1476882, 1476199, 1476114, 1476059, 1476056, 1476050, 1476007, 1474539, 1474250, 1474049, 1473995, 1473970, 1473580, 1473566, 1473534, 1473456, 1473387, 1473382, 1473327, 1473214, 1473173, 1472968, 1472463, 1472416, 1472396, 1472391, 1472389, 1472385, 1472165, 1472027, 1472015, 1471920, 1471573, 1471571, 1470780, 1470513, 1470444, 1470441, 1470434, 1470428, 1470419, 1470288, 1470279, 1470158, 1469987, 1469976, 1469826, 1469817, 1469806, 1469781, 1469742, 1469563, 1469548, 1469537, 1469383, 1469363, 1469349, 1469311, 1469219, 1469147, 1469141, 1468923, 1468922, 1468489, 1468353, 1468110, 1468101, 1466175, 1465455, 1463123, 1462835, 1460284, 1460016, 1459757, 1458381, 1456598, 1456471, 1455615, 1455222, 1452517))
Run Time: 0.003179
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | xf_thread_Thread_1 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_post.thread_id | 1 | |
SIMPLE | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_thread_Thread_1.node_id | 1 | |
SIMPLE | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_forum_Forum_2.node_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_post.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,forum.xf_node_Node_3.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2718
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 135
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 264
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 181
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 191
- XF\ResultSet->limitResults() in src/XF/Search/Search.php at line 214
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
- XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 651
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_thread_Thread_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_post`
LEFT JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_post`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread_Thread_1`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_post`.`post_id` IN (2551475, 2404299, 2298147, 2268238, 2267835, 2225238, 2180830, 2179230, 2156818, 2154025, 2152376, 2142942, 1971941, 1951604, 1951149, 1951146, 1746416, 1739559, 1708558, 1644601, 1634124, 1631656, 1622675, 1603653, 1590945, 1590897, 1590861, 1583743, 1583597, 1579756, 1579673, 1570566, 1556257, 1555026, 1554368, 1550593, 1548146, 1546036, 1534947, 1528133, 1513656, 1513268, 1509734, 1501911, 1500524, 1492486, 1488248, 1488068, 1487993, 1487618, 1484382, 1483783, 1483609, 1482845, 1482661, 1482054, 1480059, 1479480, 1479363, 1478477, 1478357, 1478348, 1477901, 1477350, 1476114, 1473382, 1472027, 1471920, 1469826, 1469563, 1469537, 1469383, 1469363, 1469311, 1460284, 1458381, 1456598, 1455615))
Run Time: 0.001263
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | range | PRIMARY | PRIMARY | 4 | | 78 | Using where |
SIMPLE | xf_thread_Thread_1 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_post.thread_id | 1 | |
SIMPLE | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_thread_Thread_1.node_id | 1 | |
SIMPLE | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_forum_Forum_2.node_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_post.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,forum.xf_node_Node_3.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2718
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 135
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 264
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 181
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 191
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 652
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20