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 (2802614, 2777786, 2771970, 2770342, 2756884, 2745523, 2745517, 2705228, 2690842, 2673834, 2667171, 2667160, 2667155, 2664681, 2650322, 2650314, 2650290, 2624618, 2624606, 2624228, 2518497, 2414046, 2279511, 2256773, 2256520, 2256504, 2246937, 2224173, 2218849, 2207986, 2207980, 2200354, 2130200, 2115188, 2114563, 2107641, 2107623, 2107617, 2103180, 2102784, 2100841, 2099385, 2093366, 2093333, 2093054, 2084988, 2084977, 2084452, 2078374, 2035365, 1998053, 1968022, 1918972, 1909728, 1909725, 1909712, 1909466, 1909443, 1908443, 1908419, 1908185, 1907064, 1907048, 1789292, 1773626, 1759414, 1759413, 1758974, 1698995, 1649529, 1556005, 1552498, 1539573, 1514226, 1511589, 1499619, 1468254, 1458462, 1458236, 1458211, 1457875, 1457871, 1437270))
Run Time: 0.031227
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 83 | 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: 494, 0, 1713486674, a:83:{s:14:"thread-2802614";a:2:{i:0;s:6:"thread";i:1;i:2802614;}s:14:"thread-2777786";a:2:{i:0;s:6:"thread";i:1;i:2777786;}s:14:"thread-2771970";a:2:{i:0;s:6:"thread";i:1;i:2771970;}s:14:"thread-2770342";a:2:{i:0;s:6:"thread";i:1;i:2770342;}s:14:"thread-2756884";a:2:{i:0;s:6:"thread";i:1;i:2756884;}s:14:"thread-2745523";a:2:{i:0;s:6:"thread";i:1;i:2745523;}s:14:"thread-2745517";a:2:{i:0;s:6:"thread";i:1;i:2745517;}s:14:"thread-2705228";a:2:{i:0;s:6:"thread";i:1;i:2705228;}s:14:"thread-2690842";a:2:{i:0;s:6:"thread";i:1;i:2690842;}s:14:"thread-2673834";a:2:{i:0;s:6:"thread";i:1;i:2673834;}s:14:"thread-2667171";a:2:{i:0;s:6:"thread";i:1;i:2667171;}s:14:"thread-2667160";a:2:{i:0;s:6:"thread";i:1;i:2667160;}s:14:"thread-2667155";a:2:{i:0;s:6:"thread";i:1;i:2667155;}s:14:"thread-2664681";a:2:{i:0;s:6:"thread";i:1;i:2664681;}s:14:"thread-2650322";a:2:{i:0;s:6:"thread";i:1;i:2650322;}s:14:"thread-2650314";a:2:{i:0;s:6:"thread";i:1;i:2650314;}s:14:"thread-2650290";a:2:{i:0;s:6:"thread";i:1;i:2650290;}s:14:"thread-2624618";a:2:{i:0;s:6:"thread";i:1;i:2624618;}s:14:"thread-2624606";a:2:{i:0;s:6:"thread";i:1;i:2624606;}s:14:"thread-2624228";a:2:{i:0;s:6:"thread";i:1;i:2624228;}s:14:"thread-2518497";a:2:{i:0;s:6:"thread";i:1;i:2518497;}s:14:"thread-2414046";a:2:{i:0;s:6:"thread";i:1;i:2414046;}s:14:"thread-2279511";a:2:{i:0;s:6:"thread";i:1;i:2279511;}s:14:"thread-2256773";a:2:{i:0;s:6:"thread";i:1;i:2256773;}s:14:"thread-2256520";a:2:{i:0;s:6:"thread";i:1;i:2256520;}s:14:"thread-2256504";a:2:{i:0;s:6:"thread";i:1;i:2256504;}s:14:"thread-2246937";a:2:{i:0;s:6:"thread";i:1;i:2246937;}s:14:"thread-2224173";a:2:{i:0;s:6:"thread";i:1;i:2224173;}s:14:"thread-2218849";a:2:{i:0;s:6:"thread";i:1;i:2218849;}s:14:"thread-2207986";a:2:{i:0;s:6:"thread";i:1;i:2207986;}s:14:"thread-2207980";a:2:{i:0;s:6:"thread";i:1;i:2207980;}s:14:"thread-2200354";a:2:{i:0;s:6:"thread";i:1;i:2200354;}s:14:"thread-2130200";a:2:{i:0;s:6:"thread";i:1;i:2130200;}s:14:"thread-2115188";a:2:{i:0;s:6:"thread";i:1;i:2115188;}s:14:"thread-2114563";a:2:{i:0;s:6:"thread";i:1;i:2114563;}s:14:"thread-2107641";a:2:{i:0;s:6:"thread";i:1;i:2107641;}s:14:"thread-2107623";a:2:{i:0;s:6:"thread";i:1;i:2107623;}s:14:"thread-2107617";a:2:{i:0;s:6:"thread";i:1;i:2107617;}s:14:"thread-2103180";a:2:{i:0;s:6:"thread";i:1;i:2103180;}s:14:"thread-2102784";a:2:{i:0;s:6:"thread";i:1;i:2102784;}s:14:"thread-2100841";a:2:{i:0;s:6:"thread";i:1;i:2100841;}s:14:"thread-2099385";a:2:{i:0;s:6:"thread";i:1;i:2099385;}s:14:"thread-2093366";a:2:{i:0;s:6:"thread";i:1;i:2093366;}s:14:"thread-2093333";a:2:{i:0;s:6:"thread";i:1;i:2093333;}s:14:"thread-2093054";a:2:{i:0;s:6:"thread";i:1;i:2093054;}s:14:"thread-2084988";a:2:{i:0;s:6:"thread";i:1;i:2084988;}s:14:"thread-2084977";a:2:{i:0;s:6:"thread";i:1;i:2084977;}s:14:"thread-2084452";a:2:{i:0;s:6:"thread";i:1;i:2084452;}s:14:"thread-2078374";a:2:{i:0;s:6:"thread";i:1;i:2078374;}s:14:"thread-2035365";a:2:{i:0;s:6:"thread";i:1;i:2035365;}s:14:"thread-1998053";a:2:{i:0;s:6:"thread";i:1;i:1998053;}s:14:"thread-1968022";a:2:{i:0;s:6:"thread";i:1;i:1968022;}s:14:"thread-1918972";a:2:{i:0;s:6:"thread";i:1;i:1918972;}s:14:"thread-1909728";a:2:{i:0;s:6:"thread";i:1;i:1909728;}s:14:"thread-1909725";a:2:{i:0;s:6:"thread";i:1;i:1909725;}s:14:"thread-1909712";a:2:{i:0;s:6:"thread";i:1;i:1909712;}s:14:"thread-1909466";a:2:{i:0;s:6:"thread";i:1;i:1909466;}s:14:"thread-1909443";a:2:{i:0;s:6:"thread";i:1;i:1909443;}s:14:"thread-1908443";a:2:{i:0;s:6:"thread";i:1;i:1908443;}s:14:"thread-1908419";a:2:{i:0;s:6:"thread";i:1;i:1908419;}s:14:"thread-1908185";a:2:{i:0;s:6:"thread";i:1;i:1908185;}s:14:"thread-1907064";a:2:{i:0;s:6:"thread";i:1;i:1907064;}s:14:"thread-1907048";a:2:{i:0;s:6:"thread";i:1;i:1907048;}s:14:"thread-1789292";a:2:{i:0;s:6:"thread";i:1;i:1789292;}s:14:"thread-1773626";a:2:{i:0;s:6:"thread";i:1;i:1773626;}s:14:"thread-1759414";a:2:{i:0;s:6:"thread";i:1;i:1759414;}s:14:"thread-1759413";a:2:{i:0;s:6:"thread";i:1;i:1759413;}s:14:"thread-1758974";a:2:{i:0;s:6:"thread";i:1;i:1758974;}s:14:"thread-1698995";a:2:{i:0;s:6:"thread";i:1;i:1698995;}s:14:"thread-1649529";a:2:{i:0;s:6:"thread";i:1;i:1649529;}s:14:"thread-1556005";a:2:{i:0;s:6:"thread";i:1;i:1556005;}s:14:"thread-1552498";a:2:{i:0;s:6:"thread";i:1;i:1552498;}s:14:"thread-1539573";a:2:{i:0;s:6:"thread";i:1;i:1539573;}s:14:"thread-1514226";a:2:{i:0;s:6:"thread";i:1;i:1514226;}s:14:"thread-1511589";a:2:{i:0;s:6:"thread";i:1;i:1511589;}s:14:"thread-1499619";a:2:{i:0;s:6:"thread";i:1;i:1499619;}s:14:"thread-1468254";a:2:{i:0;s:6:"thread";i:1;i:1468254;}s:14:"thread-1458462";a:2:{i:0;s:6:"thread";i:1;i:1458462;}s:14:"thread-1458236";a:2:{i:0;s:6:"thread";i:1;i:1458236;}s:14:"thread-1458211";a:2:{i:0;s:6:"thread";i:1;i:1458211;}s:14:"thread-1457875";a:2:{i:0;s:6:"thread";i:1;i:1457875;}s:14:"thread-1457871";a:2:{i:0;s:6:"thread";i:1;i:1457871;}s:14:"thread-1437270";a:2:{i:0;s:6:"thread";i:1;i:1437270;}}, , 1713483074
Run Time: 0.001813
- 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=muscle, 1713483074,
Run Time: 0.000075
- 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