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 (2363950, 2363945, 2207570, 2100470, 2099856, 1994222, 1994216, 1993102, 1992873, 1992818, 1992505, 1992239, 1989769, 1989097, 1989088, 1988204, 1988153, 1971425, 1970746, 1970460, 1969708, 1969617, 1966513, 1964976, 1963755, 1935797, 1932045, 1931664, 1893409, 1890695, 1847650, 1847195, 1779355, 1777788, 1777408, 1777406, 1776092, 1774764, 1770441, 1768784, 1704439, 1703548, 1700140, 1699959, 1699229, 1698533, 1698522, 1698519, 1697113, 1695159, 1694512, 1693597, 1693418, 1693287, 1693135, 1692803, 1692371, 1687080, 1683459, 1675023, 1674289, 1672635, 1672218, 1672156, 1671519, 1661009, 1660689, 1658517, 1658512, 1653287, 1630354, 1627795, 1627664, 1626281, 1592561, 1573277, 1570650, 1570315, 1569255, 1568756, 1567834, 1549848, 1549187, 1549182, 1549150, 1548233, 1548231, 1535149, 1512014, 1505526, 1504857))
Run Time: 0.042384
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 91 | 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
INSERT INTO `xf_tag_result_cache` (`tag_id`, `user_id`, `expiry_date`, `results`, `result_cache_id`, `cache_date`) VALUES (?, ?, ?, ?, ?, ?)
Params: 2534, 0, 1716029461, a:91:{s:14:"thread-2363950";a:2:{i:0;s:6:"thread";i:1;i:2363950;}s:14:"thread-2363945";a:2:{i:0;s:6:"thread";i:1;i:2363945;}s:14:"thread-2207570";a:2:{i:0;s:6:"thread";i:1;i:2207570;}s:14:"thread-2100470";a:2:{i:0;s:6:"thread";i:1;i:2100470;}s:14:"thread-2099856";a:2:{i:0;s:6:"thread";i:1;i:2099856;}s:14:"thread-1994222";a:2:{i:0;s:6:"thread";i:1;i:1994222;}s:14:"thread-1994216";a:2:{i:0;s:6:"thread";i:1;i:1994216;}s:14:"thread-1993102";a:2:{i:0;s:6:"thread";i:1;i:1993102;}s:14:"thread-1992873";a:2:{i:0;s:6:"thread";i:1;i:1992873;}s:14:"thread-1992818";a:2:{i:0;s:6:"thread";i:1;i:1992818;}s:14:"thread-1992505";a:2:{i:0;s:6:"thread";i:1;i:1992505;}s:14:"thread-1992239";a:2:{i:0;s:6:"thread";i:1;i:1992239;}s:14:"thread-1989769";a:2:{i:0;s:6:"thread";i:1;i:1989769;}s:14:"thread-1989097";a:2:{i:0;s:6:"thread";i:1;i:1989097;}s:14:"thread-1989088";a:2:{i:0;s:6:"thread";i:1;i:1989088;}s:14:"thread-1988204";a:2:{i:0;s:6:"thread";i:1;i:1988204;}s:14:"thread-1988153";a:2:{i:0;s:6:"thread";i:1;i:1988153;}s:14:"thread-1971425";a:2:{i:0;s:6:"thread";i:1;i:1971425;}s:14:"thread-1970746";a:2:{i:0;s:6:"thread";i:1;i:1970746;}s:14:"thread-1970460";a:2:{i:0;s:6:"thread";i:1;i:1970460;}s:14:"thread-1969708";a:2:{i:0;s:6:"thread";i:1;i:1969708;}s:14:"thread-1969617";a:2:{i:0;s:6:"thread";i:1;i:1969617;}s:14:"thread-1966513";a:2:{i:0;s:6:"thread";i:1;i:1966513;}s:14:"thread-1964976";a:2:{i:0;s:6:"thread";i:1;i:1964976;}s:14:"thread-1963755";a:2:{i:0;s:6:"thread";i:1;i:1963755;}s:14:"thread-1935797";a:2:{i:0;s:6:"thread";i:1;i:1935797;}s:14:"thread-1932045";a:2:{i:0;s:6:"thread";i:1;i:1932045;}s:14:"thread-1931664";a:2:{i:0;s:6:"thread";i:1;i:1931664;}s:14:"thread-1893409";a:2:{i:0;s:6:"thread";i:1;i:1893409;}s:14:"thread-1890695";a:2:{i:0;s:6:"thread";i:1;i:1890695;}s:14:"thread-1847650";a:2:{i:0;s:6:"thread";i:1;i:1847650;}s:14:"thread-1847195";a:2:{i:0;s:6:"thread";i:1;i:1847195;}s:14:"thread-1779355";a:2:{i:0;s:6:"thread";i:1;i:1779355;}s:14:"thread-1777788";a:2:{i:0;s:6:"thread";i:1;i:1777788;}s:14:"thread-1777408";a:2:{i:0;s:6:"thread";i:1;i:1777408;}s:14:"thread-1777406";a:2:{i:0;s:6:"thread";i:1;i:1777406;}s:14:"thread-1776092";a:2:{i:0;s:6:"thread";i:1;i:1776092;}s:14:"thread-1774764";a:2:{i:0;s:6:"thread";i:1;i:1774764;}s:14:"thread-1770441";a:2:{i:0;s:6:"thread";i:1;i:1770441;}s:14:"thread-1768784";a:2:{i:0;s:6:"thread";i:1;i:1768784;}s:14:"thread-1704439";a:2:{i:0;s:6:"thread";i:1;i:1704439;}s:14:"thread-1703548";a:2:{i:0;s:6:"thread";i:1;i:1703548;}s:14:"thread-1700140";a:2:{i:0;s:6:"thread";i:1;i:1700140;}s:14:"thread-1699959";a:2:{i:0;s:6:"thread";i:1;i:1699959;}s:14:"thread-1699229";a:2:{i:0;s:6:"thread";i:1;i:1699229;}s:14:"thread-1698533";a:2:{i:0;s:6:"thread";i:1;i:1698533;}s:14:"thread-1698522";a:2:{i:0;s:6:"thread";i:1;i:1698522;}s:14:"thread-1698519";a:2:{i:0;s:6:"thread";i:1;i:1698519;}s:14:"thread-1697113";a:2:{i:0;s:6:"thread";i:1;i:1697113;}s:14:"thread-1695159";a:2:{i:0;s:6:"thread";i:1;i:1695159;}s:14:"thread-1694512";a:2:{i:0;s:6:"thread";i:1;i:1694512;}s:14:"thread-1693597";a:2:{i:0;s:6:"thread";i:1;i:1693597;}s:14:"thread-1693418";a:2:{i:0;s:6:"thread";i:1;i:1693418;}s:14:"thread-1693287";a:2:{i:0;s:6:"thread";i:1;i:1693287;}s:14:"thread-1693135";a:2:{i:0;s:6:"thread";i:1;i:1693135;}s:14:"thread-1692803";a:2:{i:0;s:6:"thread";i:1;i:1692803;}s:14:"thread-1692371";a:2:{i:0;s:6:"thread";i:1;i:1692371;}s:14:"thread-1687080";a:2:{i:0;s:6:"thread";i:1;i:1687080;}s:14:"thread-1683459";a:2:{i:0;s:6:"thread";i:1;i:1683459;}s:14:"thread-1675023";a:2:{i:0;s:6:"thread";i:1;i:1675023;}s:14:"thread-1674289";a:2:{i:0;s:6:"thread";i:1;i:1674289;}s:14:"thread-1672635";a:2:{i:0;s:6:"thread";i:1;i:1672635;}s:14:"thread-1672218";a:2:{i:0;s:6:"thread";i:1;i:1672218;}s:14:"thread-1672156";a:2:{i:0;s:6:"thread";i:1;i:1672156;}s:14:"thread-1671519";a:2:{i:0;s:6:"thread";i:1;i:1671519;}s:14:"thread-1661009";a:2:{i:0;s:6:"thread";i:1;i:1661009;}s:14:"thread-1660689";a:2:{i:0;s:6:"thread";i:1;i:1660689;}s:14:"thread-1658517";a:2:{i:0;s:6:"thread";i:1;i:1658517;}s:14:"thread-1658512";a:2:{i:0;s:6:"thread";i:1;i:1658512;}s:14:"thread-1653287";a:2:{i:0;s:6:"thread";i:1;i:1653287;}s:14:"thread-1630354";a:2:{i:0;s:6:"thread";i:1;i:1630354;}s:14:"thread-1627795";a:2:{i:0;s:6:"thread";i:1;i:1627795;}s:14:"thread-1627664";a:2:{i:0;s:6:"thread";i:1;i:1627664;}s:14:"thread-1626281";a:2:{i:0;s:6:"thread";i:1;i:1626281;}s:14:"thread-1592561";a:2:{i:0;s:6:"thread";i:1;i:1592561;}s:14:"thread-1573277";a:2:{i:0;s:6:"thread";i:1;i:1573277;}s:14:"thread-1570650";a:2:{i:0;s:6:"thread";i:1;i:1570650;}s:14:"thread-1570315";a:2:{i:0;s:6:"thread";i:1;i:1570315;}s:14:"thread-1569255";a:2:{i:0;s:6:"thread";i:1;i:1569255;}s:14:"thread-1568756";a:2:{i:0;s:6:"thread";i:1;i:1568756;}s:14:"thread-1567834";a:2:{i:0;s:6:"thread";i:1;i:1567834;}s:14:"thread-1549848";a:2:{i:0;s:6:"thread";i:1;i:1549848;}s:14:"thread-1549187";a:2:{i:0;s:6:"thread";i:1;i:1549187;}s:14:"thread-1549182";a:2:{i:0;s:6:"thread";i:1;i:1549182;}s:14:"thread-1549150";a:2:{i:0;s:6:"thread";i:1;i:1549150;}s:14:"thread-1548233";a:2:{i:0;s:6:"thread";i:1;i:1548233;}s:14:"thread-1548231";a:2:{i:0;s:6:"thread";i:1;i:1548231;}s:14:"thread-1535149";a:2:{i:0;s:6:"thread";i:1;i:1535149;}s:14:"thread-1512014";a:2:{i:0;s:6:"thread";i:1;i:1512014;}s:14:"thread-1505526";a:2:{i:0;s:6:"thread";i:1;i:1505526;}s:14:"thread-1504857";a:2:{i:0;s:6:"thread";i:1;i:1504857;}}, , 1716025861
Run Time: 0.002269
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 161
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1409
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1141
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 149
- 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=redheads&page=2, 1716025861,
Run Time: 0.000070
- 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