SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_post_FirstPost_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_4` ON (`xf_post_FirstPost_4`.`post_id` = `xf_thread`.`first_post_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_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (3293015, 3061458, 2447595, 2098015, 2091909, 2091906, 2091419, 2027352, 2027193, 2027116, 2026946, 2026766, 2021991, 2021987, 2021961, 2021867, 2021832, 2021796, 2021792, 2021694, 2021255, 2021191, 2021159, 2002830, 2000240, 2000062, 1995377, 1995232, 1995154, 1995109, 1994863, 1994784, 1991580, 1991372, 1991114, 1991053, 1987962, 1987937, 1986347, 1985181, 1985138, 1985061, 1985021, 1977887, 1976443, 1975146, 1975097, 1973816, 1973474, 1973417, 1973403, 1973266, 1973173, 1973145, 1973144, 1973132, 1973094, 1968903, 1968245, 1968078, 1968005, 1967960, 1964696, 1964515, 1964487, 1962678, 1959339, 1955384, 1950283, 1950179, 1947386, 1936092, 1911215, 1895695, 1887450, 1885740, 1884834, 1878022, 1877893, 1856752, 1849918, 1849512, 1849504, 1849327, 1849154, 1848815, 1848805, 1848795, 1848559, 1848469, 1848420, 1848268, 1848183, 1848107, 1848069, 1847603, 1847107, 1846904, 1846638, 1846552, 1846406, 1846041, 1800519, 1790259, 1787170, 1781962, 1778522, 1754072, 1754054, 1754053, 1729511, 1729076, 1720717, 1719090, 1713814, 1713797, 1706844, 1676441, 1675298, 1672025, 1649990, 1644586, 1644114, 1641308, 1638783, 1634041, 1628681, 1613561, 1609945, 1585390, 1582272, 1567678, 1553750, 1553078, 1545970, 1537860, 1537853, 1535094, 1533318, 1531004, 1528648, 1524330, 1521395, 1521010, 1515464, 1514750, 1514743, 1514570, 1514244, 1514233, 1499822, 1495130, 1490232, 1484996, 1482408, 1464343, 1463732, 1461401, 1460656, 1458065, 1435915))
Run Time: 0.043327
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 161 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | rawboard_final.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | rawboard_final.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | rawboard_final.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | rawboard_final.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,rawboard_final.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1164
- 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 2290
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 728
- XF\Repository\Tag->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/Pub/Controller/Tag.php at line 136
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
-- XFDB=noForceAllWrite
INSERT INTO xf_session_activity
(`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , XF\Pub\Controller\Tag, Tag, valid, tag_url=titty-fuck, 1751734063,
Run Time: 0.000101
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 67
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 41
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 278
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 271
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13