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 (2762065, 2756314, 2751735, 2743151, 2673913, 2673884, 2667119, 2667115, 2656361, 2640338, 2604544, 2594006, 2593911, 2592007, 2542301, 2537481, 2354117, 2340114, 2132572, 2099495, 2095057, 2068263, 2031326, 2023539, 2021886, 2021688, 2021543, 2021067, 2008792, 2006627, 2000288, 2000005, 2000001, 1995346, 1995292, 1995184, 1994987, 1994950, 1994801, 1994781, 1991453, 1987652, 1876303, 1849498, 1848997, 1848368, 1848004, 1847702, 1847076, 1846869, 1846603, 1764841, 1723932, 1723929, 1703603, 1674164, 1672012, 1665713, 1638309, 1624805, 1615568, 1613049, 1586588, 1581510, 1568425, 1541072, 1539858, 1527336, 1524730, 1522000, 1520000, 1507108, 1499960, 1499957, 1494381, 1491342, 1486250, 1475599, 1467608, 1456357, 1455391, 1445951, 1440091, 1439784, 1439266, 1436292, 1435894))
Run Time: 0.054413
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 87 | 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: 20, 0, 1714118450, a:87:{s:14:"thread-2762065";a:2:{i:0;s:6:"thread";i:1;i:2762065;}s:14:"thread-2756314";a:2:{i:0;s:6:"thread";i:1;i:2756314;}s:14:"thread-2751735";a:2:{i:0;s:6:"thread";i:1;i:2751735;}s:14:"thread-2743151";a:2:{i:0;s:6:"thread";i:1;i:2743151;}s:14:"thread-2673913";a:2:{i:0;s:6:"thread";i:1;i:2673913;}s:14:"thread-2673884";a:2:{i:0;s:6:"thread";i:1;i:2673884;}s:14:"thread-2667119";a:2:{i:0;s:6:"thread";i:1;i:2667119;}s:14:"thread-2667115";a:2:{i:0;s:6:"thread";i:1;i:2667115;}s:14:"thread-2656361";a:2:{i:0;s:6:"thread";i:1;i:2656361;}s:14:"thread-2640338";a:2:{i:0;s:6:"thread";i:1;i:2640338;}s:14:"thread-2604544";a:2:{i:0;s:6:"thread";i:1;i:2604544;}s:14:"thread-2594006";a:2:{i:0;s:6:"thread";i:1;i:2594006;}s:14:"thread-2593911";a:2:{i:0;s:6:"thread";i:1;i:2593911;}s:14:"thread-2592007";a:2:{i:0;s:6:"thread";i:1;i:2592007;}s:14:"thread-2542301";a:2:{i:0;s:6:"thread";i:1;i:2542301;}s:14:"thread-2537481";a:2:{i:0;s:6:"thread";i:1;i:2537481;}s:14:"thread-2354117";a:2:{i:0;s:6:"thread";i:1;i:2354117;}s:14:"thread-2340114";a:2:{i:0;s:6:"thread";i:1;i:2340114;}s:14:"thread-2132572";a:2:{i:0;s:6:"thread";i:1;i:2132572;}s:14:"thread-2099495";a:2:{i:0;s:6:"thread";i:1;i:2099495;}s:14:"thread-2095057";a:2:{i:0;s:6:"thread";i:1;i:2095057;}s:14:"thread-2068263";a:2:{i:0;s:6:"thread";i:1;i:2068263;}s:14:"thread-2031326";a:2:{i:0;s:6:"thread";i:1;i:2031326;}s:14:"thread-2023539";a:2:{i:0;s:6:"thread";i:1;i:2023539;}s:14:"thread-2021886";a:2:{i:0;s:6:"thread";i:1;i:2021886;}s:14:"thread-2021688";a:2:{i:0;s:6:"thread";i:1;i:2021688;}s:14:"thread-2021543";a:2:{i:0;s:6:"thread";i:1;i:2021543;}s:14:"thread-2021067";a:2:{i:0;s:6:"thread";i:1;i:2021067;}s:14:"thread-2008792";a:2:{i:0;s:6:"thread";i:1;i:2008792;}s:14:"thread-2006627";a:2:{i:0;s:6:"thread";i:1;i:2006627;}s:14:"thread-2000288";a:2:{i:0;s:6:"thread";i:1;i:2000288;}s:14:"thread-2000005";a:2:{i:0;s:6:"thread";i:1;i:2000005;}s:14:"thread-2000001";a:2:{i:0;s:6:"thread";i:1;i:2000001;}s:14:"thread-1995346";a:2:{i:0;s:6:"thread";i:1;i:1995346;}s:14:"thread-1995292";a:2:{i:0;s:6:"thread";i:1;i:1995292;}s:14:"thread-1995184";a:2:{i:0;s:6:"thread";i:1;i:1995184;}s:14:"thread-1994987";a:2:{i:0;s:6:"thread";i:1;i:1994987;}s:14:"thread-1994950";a:2:{i:0;s:6:"thread";i:1;i:1994950;}s:14:"thread-1994801";a:2:{i:0;s:6:"thread";i:1;i:1994801;}s:14:"thread-1994781";a:2:{i:0;s:6:"thread";i:1;i:1994781;}s:14:"thread-1991453";a:2:{i:0;s:6:"thread";i:1;i:1991453;}s:14:"thread-1987652";a:2:{i:0;s:6:"thread";i:1;i:1987652;}s:14:"thread-1876303";a:2:{i:0;s:6:"thread";i:1;i:1876303;}s:14:"thread-1849498";a:2:{i:0;s:6:"thread";i:1;i:1849498;}s:14:"thread-1848997";a:2:{i:0;s:6:"thread";i:1;i:1848997;}s:14:"thread-1848368";a:2:{i:0;s:6:"thread";i:1;i:1848368;}s:14:"thread-1848004";a:2:{i:0;s:6:"thread";i:1;i:1848004;}s:14:"thread-1847702";a:2:{i:0;s:6:"thread";i:1;i:1847702;}s:14:"thread-1847076";a:2:{i:0;s:6:"thread";i:1;i:1847076;}s:14:"thread-1846869";a:2:{i:0;s:6:"thread";i:1;i:1846869;}s:14:"thread-1846603";a:2:{i:0;s:6:"thread";i:1;i:1846603;}s:14:"thread-1764841";a:2:{i:0;s:6:"thread";i:1;i:1764841;}s:14:"thread-1723932";a:2:{i:0;s:6:"thread";i:1;i:1723932;}s:14:"thread-1723929";a:2:{i:0;s:6:"thread";i:1;i:1723929;}s:14:"thread-1703603";a:2:{i:0;s:6:"thread";i:1;i:1703603;}s:14:"thread-1674164";a:2:{i:0;s:6:"thread";i:1;i:1674164;}s:14:"thread-1672012";a:2:{i:0;s:6:"thread";i:1;i:1672012;}s:14:"thread-1665713";a:2:{i:0;s:6:"thread";i:1;i:1665713;}s:14:"thread-1638309";a:2:{i:0;s:6:"thread";i:1;i:1638309;}s:14:"thread-1624805";a:2:{i:0;s:6:"thread";i:1;i:1624805;}s:14:"thread-1615568";a:2:{i:0;s:6:"thread";i:1;i:1615568;}s:14:"thread-1613049";a:2:{i:0;s:6:"thread";i:1;i:1613049;}s:14:"thread-1586588";a:2:{i:0;s:6:"thread";i:1;i:1586588;}s:14:"thread-1581510";a:2:{i:0;s:6:"thread";i:1;i:1581510;}s:14:"thread-1568425";a:2:{i:0;s:6:"thread";i:1;i:1568425;}s:14:"thread-1541072";a:2:{i:0;s:6:"thread";i:1;i:1541072;}s:14:"thread-1539858";a:2:{i:0;s:6:"thread";i:1;i:1539858;}s:14:"thread-1527336";a:2:{i:0;s:6:"thread";i:1;i:1527336;}s:14:"thread-1524730";a:2:{i:0;s:6:"thread";i:1;i:1524730;}s:14:"thread-1522000";a:2:{i:0;s:6:"thread";i:1;i:1522000;}s:14:"thread-1520000";a:2:{i:0;s:6:"thread";i:1;i:1520000;}s:14:"thread-1507108";a:2:{i:0;s:6:"thread";i:1;i:1507108;}s:14:"thread-1499960";a:2:{i:0;s:6:"thread";i:1;i:1499960;}s:14:"thread-1499957";a:2:{i:0;s:6:"thread";i:1;i:1499957;}s:14:"thread-1494381";a:2:{i:0;s:6:"thread";i:1;i:1494381;}s:14:"thread-1491342";a:2:{i:0;s:6:"thread";i:1;i:1491342;}s:14:"thread-1486250";a:2:{i:0;s:6:"thread";i:1;i:1486250;}s:14:"thread-1475599";a:2:{i:0;s:6:"thread";i:1;i:1475599;}s:14:"thread-1467608";a:2:{i:0;s:6:"thread";i:1;i:1467608;}s:14:"thread-1456357";a:2:{i:0;s:6:"thread";i:1;i:1456357;}s:14:"thread-1455391";a:2:{i:0;s:6:"thread";i:1;i:1455391;}s:14:"thread-1445951";a:2:{i:0;s:6:"thread";i:1;i:1445951;}s:14:"thread-1440091";a:2:{i:0;s:6:"thread";i:1;i:1440091;}s:14:"thread-1439784";a:2:{i:0;s:6:"thread";i:1;i:1439784;}s:14:"thread-1439266";a:2:{i:0;s:6:"thread";i:1;i:1439266;}s:14:"thread-1436292";a:2:{i:0;s:6:"thread";i:1;i:1436292;}s:14:"thread-1435894";a:2:{i:0;s:6:"thread";i:1;i:1435894;}}, , 1714114850
Run Time: 0.001177
- 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=babes, 1714114850,
Run Time: 0.000158
- 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