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 (2099760, 2000202, 1986442, 1975066, 1964580, 1964539, 1938096, 1891651, 1889604, 1882575, 1877843, 1876496, 1856786, 1856732, 1856684, 1855574, 1852908, 1849584, 1849181, 1849031, 1848701, 1847996, 1847419, 1847294, 1847056, 1846741, 1846358, 1713805, 1674599, 1669287, 1669262, 1666368, 1652612, 1652126, 1652037, 1651319, 1648615, 1644672, 1639334, 1639296, 1638321, 1631975, 1626851, 1620297, 1611953, 1610997, 1609233, 1604779, 1548608, 1542824, 1542120, 1541553, 1534363, 1530184, 1528361, 1524567, 1523669, 1523617, 1523105, 1522559, 1521720, 1521004, 1519949, 1519918, 1518939, 1517651, 1517592, 1515604, 1515519, 1514570, 1507091, 1505217, 1502156, 1499065, 1496597, 1493687, 1491480, 1491314, 1490185, 1489402, 1474509, 1474262, 1473809, 1468311, 1468308))
Run Time: 0.040758
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 85 | 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: 1948, 0, 1715911143, a:85:{s:14:"thread-2099760";a:2:{i:0;s:6:"thread";i:1;i:2099760;}s:14:"thread-2000202";a:2:{i:0;s:6:"thread";i:1;i:2000202;}s:14:"thread-1986442";a:2:{i:0;s:6:"thread";i:1;i:1986442;}s:14:"thread-1975066";a:2:{i:0;s:6:"thread";i:1;i:1975066;}s:14:"thread-1964580";a:2:{i:0;s:6:"thread";i:1;i:1964580;}s:14:"thread-1964539";a:2:{i:0;s:6:"thread";i:1;i:1964539;}s:14:"thread-1938096";a:2:{i:0;s:6:"thread";i:1;i:1938096;}s:14:"thread-1891651";a:2:{i:0;s:6:"thread";i:1;i:1891651;}s:14:"thread-1889604";a:2:{i:0;s:6:"thread";i:1;i:1889604;}s:14:"thread-1882575";a:2:{i:0;s:6:"thread";i:1;i:1882575;}s:14:"thread-1877843";a:2:{i:0;s:6:"thread";i:1;i:1877843;}s:14:"thread-1876496";a:2:{i:0;s:6:"thread";i:1;i:1876496;}s:14:"thread-1856786";a:2:{i:0;s:6:"thread";i:1;i:1856786;}s:14:"thread-1856732";a:2:{i:0;s:6:"thread";i:1;i:1856732;}s:14:"thread-1856684";a:2:{i:0;s:6:"thread";i:1;i:1856684;}s:14:"thread-1855574";a:2:{i:0;s:6:"thread";i:1;i:1855574;}s:14:"thread-1852908";a:2:{i:0;s:6:"thread";i:1;i:1852908;}s:14:"thread-1849584";a:2:{i:0;s:6:"thread";i:1;i:1849584;}s:14:"thread-1849181";a:2:{i:0;s:6:"thread";i:1;i:1849181;}s:14:"thread-1849031";a:2:{i:0;s:6:"thread";i:1;i:1849031;}s:14:"thread-1848701";a:2:{i:0;s:6:"thread";i:1;i:1848701;}s:14:"thread-1847996";a:2:{i:0;s:6:"thread";i:1;i:1847996;}s:14:"thread-1847419";a:2:{i:0;s:6:"thread";i:1;i:1847419;}s:14:"thread-1847294";a:2:{i:0;s:6:"thread";i:1;i:1847294;}s:14:"thread-1847056";a:2:{i:0;s:6:"thread";i:1;i:1847056;}s:14:"thread-1846741";a:2:{i:0;s:6:"thread";i:1;i:1846741;}s:14:"thread-1846358";a:2:{i:0;s:6:"thread";i:1;i:1846358;}s:14:"thread-1713805";a:2:{i:0;s:6:"thread";i:1;i:1713805;}s:14:"thread-1674599";a:2:{i:0;s:6:"thread";i:1;i:1674599;}s:14:"thread-1669287";a:2:{i:0;s:6:"thread";i:1;i:1669287;}s:14:"thread-1669262";a:2:{i:0;s:6:"thread";i:1;i:1669262;}s:14:"thread-1666368";a:2:{i:0;s:6:"thread";i:1;i:1666368;}s:14:"thread-1652612";a:2:{i:0;s:6:"thread";i:1;i:1652612;}s:14:"thread-1652126";a:2:{i:0;s:6:"thread";i:1;i:1652126;}s:14:"thread-1652037";a:2:{i:0;s:6:"thread";i:1;i:1652037;}s:14:"thread-1651319";a:2:{i:0;s:6:"thread";i:1;i:1651319;}s:14:"thread-1648615";a:2:{i:0;s:6:"thread";i:1;i:1648615;}s:14:"thread-1644672";a:2:{i:0;s:6:"thread";i:1;i:1644672;}s:14:"thread-1639334";a:2:{i:0;s:6:"thread";i:1;i:1639334;}s:14:"thread-1639296";a:2:{i:0;s:6:"thread";i:1;i:1639296;}s:14:"thread-1638321";a:2:{i:0;s:6:"thread";i:1;i:1638321;}s:14:"thread-1631975";a:2:{i:0;s:6:"thread";i:1;i:1631975;}s:14:"thread-1626851";a:2:{i:0;s:6:"thread";i:1;i:1626851;}s:14:"thread-1620297";a:2:{i:0;s:6:"thread";i:1;i:1620297;}s:14:"thread-1611953";a:2:{i:0;s:6:"thread";i:1;i:1611953;}s:14:"thread-1610997";a:2:{i:0;s:6:"thread";i:1;i:1610997;}s:14:"thread-1609233";a:2:{i:0;s:6:"thread";i:1;i:1609233;}s:14:"thread-1604779";a:2:{i:0;s:6:"thread";i:1;i:1604779;}s:14:"thread-1548608";a:2:{i:0;s:6:"thread";i:1;i:1548608;}s:14:"thread-1542824";a:2:{i:0;s:6:"thread";i:1;i:1542824;}s:14:"thread-1542120";a:2:{i:0;s:6:"thread";i:1;i:1542120;}s:14:"thread-1541553";a:2:{i:0;s:6:"thread";i:1;i:1541553;}s:14:"thread-1534363";a:2:{i:0;s:6:"thread";i:1;i:1534363;}s:14:"thread-1530184";a:2:{i:0;s:6:"thread";i:1;i:1530184;}s:14:"thread-1528361";a:2:{i:0;s:6:"thread";i:1;i:1528361;}s:14:"thread-1524567";a:2:{i:0;s:6:"thread";i:1;i:1524567;}s:14:"thread-1523669";a:2:{i:0;s:6:"thread";i:1;i:1523669;}s:14:"thread-1523617";a:2:{i:0;s:6:"thread";i:1;i:1523617;}s:14:"thread-1523105";a:2:{i:0;s:6:"thread";i:1;i:1523105;}s:14:"thread-1522559";a:2:{i:0;s:6:"thread";i:1;i:1522559;}s:14:"thread-1521720";a:2:{i:0;s:6:"thread";i:1;i:1521720;}s:14:"thread-1521004";a:2:{i:0;s:6:"thread";i:1;i:1521004;}s:14:"thread-1519949";a:2:{i:0;s:6:"thread";i:1;i:1519949;}s:14:"thread-1519918";a:2:{i:0;s:6:"thread";i:1;i:1519918;}s:14:"thread-1518939";a:2:{i:0;s:6:"thread";i:1;i:1518939;}s:14:"thread-1517651";a:2:{i:0;s:6:"thread";i:1;i:1517651;}s:14:"thread-1517592";a:2:{i:0;s:6:"thread";i:1;i:1517592;}s:14:"thread-1515604";a:2:{i:0;s:6:"thread";i:1;i:1515604;}s:14:"thread-1515519";a:2:{i:0;s:6:"thread";i:1;i:1515519;}s:14:"thread-1514570";a:2:{i:0;s:6:"thread";i:1;i:1514570;}s:14:"thread-1507091";a:2:{i:0;s:6:"thread";i:1;i:1507091;}s:14:"thread-1505217";a:2:{i:0;s:6:"thread";i:1;i:1505217;}s:14:"thread-1502156";a:2:{i:0;s:6:"thread";i:1;i:1502156;}s:14:"thread-1499065";a:2:{i:0;s:6:"thread";i:1;i:1499065;}s:14:"thread-1496597";a:2:{i:0;s:6:"thread";i:1;i:1496597;}s:14:"thread-1493687";a:2:{i:0;s:6:"thread";i:1;i:1493687;}s:14:"thread-1491480";a:2:{i:0;s:6:"thread";i:1;i:1491480;}s:14:"thread-1491314";a:2:{i:0;s:6:"thread";i:1;i:1491314;}s:14:"thread-1490185";a:2:{i:0;s:6:"thread";i:1;i:1490185;}s:14:"thread-1489402";a:2:{i:0;s:6:"thread";i:1;i:1489402;}s:14:"thread-1474509";a:2:{i:0;s:6:"thread";i:1;i:1474509;}s:14:"thread-1474262";a:2:{i:0;s:6:"thread";i:1;i:1474262;}s:14:"thread-1473809";a:2:{i:0;s:6:"thread";i:1;i:1473809;}s:14:"thread-1468311";a:2:{i:0;s:6:"thread";i:1;i:1468311;}s:14:"thread-1468308";a:2:{i:0;s:6:"thread";i:1;i:1468308;}}, , 1715907543
Run Time: 0.001359
- 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=bedroom, 1715907543,
Run Time: 0.000079
- 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