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 (2021954, 2021895, 2021745, 2021707, 2021333, 2021168, 1995197, 1995048, 1994932, 1994082, 1991557, 1985226, 1984921, 1975023, 1974064, 1973761, 1973409, 1973374, 1973170, 1944002, 1935213, 1934392, 1897516, 1895763, 1848312, 1848276, 1846216, 1689684, 1663479, 1652690, 1651328, 1649571, 1646264, 1644870, 1634687, 1632389, 1628025, 1625271, 1623992, 1623990, 1618404, 1617411, 1616775, 1612412, 1610995, 1609281, 1601350, 1577273, 1575492, 1532725, 1530868, 1530580, 1525117, 1524320, 1523617, 1520003, 1520002, 1519425, 1509045, 1508602, 1508344, 1506870, 1505626, 1504461, 1503021, 1502519, 1501254, 1499069, 1495480, 1494777, 1491478, 1491071, 1485620, 1485054, 1483655, 1482670, 1481195, 1474264, 1472094, 1470485, 1465544, 1464230))
Run Time: 0.046863
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 82 | 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: 7464, 0, 1715808296, a:82:{s:14:"thread-2021954";a:2:{i:0;s:6:"thread";i:1;i:2021954;}s:14:"thread-2021895";a:2:{i:0;s:6:"thread";i:1;i:2021895;}s:14:"thread-2021745";a:2:{i:0;s:6:"thread";i:1;i:2021745;}s:14:"thread-2021707";a:2:{i:0;s:6:"thread";i:1;i:2021707;}s:14:"thread-2021333";a:2:{i:0;s:6:"thread";i:1;i:2021333;}s:14:"thread-2021168";a:2:{i:0;s:6:"thread";i:1;i:2021168;}s:14:"thread-1995197";a:2:{i:0;s:6:"thread";i:1;i:1995197;}s:14:"thread-1995048";a:2:{i:0;s:6:"thread";i:1;i:1995048;}s:14:"thread-1994932";a:2:{i:0;s:6:"thread";i:1;i:1994932;}s:14:"thread-1994082";a:2:{i:0;s:6:"thread";i:1;i:1994082;}s:14:"thread-1991557";a:2:{i:0;s:6:"thread";i:1;i:1991557;}s:14:"thread-1985226";a:2:{i:0;s:6:"thread";i:1;i:1985226;}s:14:"thread-1984921";a:2:{i:0;s:6:"thread";i:1;i:1984921;}s:14:"thread-1975023";a:2:{i:0;s:6:"thread";i:1;i:1975023;}s:14:"thread-1974064";a:2:{i:0;s:6:"thread";i:1;i:1974064;}s:14:"thread-1973761";a:2:{i:0;s:6:"thread";i:1;i:1973761;}s:14:"thread-1973409";a:2:{i:0;s:6:"thread";i:1;i:1973409;}s:14:"thread-1973374";a:2:{i:0;s:6:"thread";i:1;i:1973374;}s:14:"thread-1973170";a:2:{i:0;s:6:"thread";i:1;i:1973170;}s:14:"thread-1944002";a:2:{i:0;s:6:"thread";i:1;i:1944002;}s:14:"thread-1935213";a:2:{i:0;s:6:"thread";i:1;i:1935213;}s:14:"thread-1934392";a:2:{i:0;s:6:"thread";i:1;i:1934392;}s:14:"thread-1897516";a:2:{i:0;s:6:"thread";i:1;i:1897516;}s:14:"thread-1895763";a:2:{i:0;s:6:"thread";i:1;i:1895763;}s:14:"thread-1848312";a:2:{i:0;s:6:"thread";i:1;i:1848312;}s:14:"thread-1848276";a:2:{i:0;s:6:"thread";i:1;i:1848276;}s:14:"thread-1846216";a:2:{i:0;s:6:"thread";i:1;i:1846216;}s:14:"thread-1689684";a:2:{i:0;s:6:"thread";i:1;i:1689684;}s:14:"thread-1663479";a:2:{i:0;s:6:"thread";i:1;i:1663479;}s:14:"thread-1652690";a:2:{i:0;s:6:"thread";i:1;i:1652690;}s:14:"thread-1651328";a:2:{i:0;s:6:"thread";i:1;i:1651328;}s:14:"thread-1649571";a:2:{i:0;s:6:"thread";i:1;i:1649571;}s:14:"thread-1646264";a:2:{i:0;s:6:"thread";i:1;i:1646264;}s:14:"thread-1644870";a:2:{i:0;s:6:"thread";i:1;i:1644870;}s:14:"thread-1634687";a:2:{i:0;s:6:"thread";i:1;i:1634687;}s:14:"thread-1632389";a:2:{i:0;s:6:"thread";i:1;i:1632389;}s:14:"thread-1628025";a:2:{i:0;s:6:"thread";i:1;i:1628025;}s:14:"thread-1625271";a:2:{i:0;s:6:"thread";i:1;i:1625271;}s:14:"thread-1623992";a:2:{i:0;s:6:"thread";i:1;i:1623992;}s:14:"thread-1623990";a:2:{i:0;s:6:"thread";i:1;i:1623990;}s:14:"thread-1618404";a:2:{i:0;s:6:"thread";i:1;i:1618404;}s:14:"thread-1617411";a:2:{i:0;s:6:"thread";i:1;i:1617411;}s:14:"thread-1616775";a:2:{i:0;s:6:"thread";i:1;i:1616775;}s:14:"thread-1612412";a:2:{i:0;s:6:"thread";i:1;i:1612412;}s:14:"thread-1610995";a:2:{i:0;s:6:"thread";i:1;i:1610995;}s:14:"thread-1609281";a:2:{i:0;s:6:"thread";i:1;i:1609281;}s:14:"thread-1601350";a:2:{i:0;s:6:"thread";i:1;i:1601350;}s:14:"thread-1577273";a:2:{i:0;s:6:"thread";i:1;i:1577273;}s:14:"thread-1575492";a:2:{i:0;s:6:"thread";i:1;i:1575492;}s:14:"thread-1532725";a:2:{i:0;s:6:"thread";i:1;i:1532725;}s:14:"thread-1530868";a:2:{i:0;s:6:"thread";i:1;i:1530868;}s:14:"thread-1530580";a:2:{i:0;s:6:"thread";i:1;i:1530580;}s:14:"thread-1525117";a:2:{i:0;s:6:"thread";i:1;i:1525117;}s:14:"thread-1524320";a:2:{i:0;s:6:"thread";i:1;i:1524320;}s:14:"thread-1523617";a:2:{i:0;s:6:"thread";i:1;i:1523617;}s:14:"thread-1520003";a:2:{i:0;s:6:"thread";i:1;i:1520003;}s:14:"thread-1520002";a:2:{i:0;s:6:"thread";i:1;i:1520002;}s:14:"thread-1519425";a:2:{i:0;s:6:"thread";i:1;i:1519425;}s:14:"thread-1509045";a:2:{i:0;s:6:"thread";i:1;i:1509045;}s:14:"thread-1508602";a:2:{i:0;s:6:"thread";i:1;i:1508602;}s:14:"thread-1508344";a:2:{i:0;s:6:"thread";i:1;i:1508344;}s:14:"thread-1506870";a:2:{i:0;s:6:"thread";i:1;i:1506870;}s:14:"thread-1505626";a:2:{i:0;s:6:"thread";i:1;i:1505626;}s:14:"thread-1504461";a:2:{i:0;s:6:"thread";i:1;i:1504461;}s:14:"thread-1503021";a:2:{i:0;s:6:"thread";i:1;i:1503021;}s:14:"thread-1502519";a:2:{i:0;s:6:"thread";i:1;i:1502519;}s:14:"thread-1501254";a:2:{i:0;s:6:"thread";i:1;i:1501254;}s:14:"thread-1499069";a:2:{i:0;s:6:"thread";i:1;i:1499069;}s:14:"thread-1495480";a:2:{i:0;s:6:"thread";i:1;i:1495480;}s:14:"thread-1494777";a:2:{i:0;s:6:"thread";i:1;i:1494777;}s:14:"thread-1491478";a:2:{i:0;s:6:"thread";i:1;i:1491478;}s:14:"thread-1491071";a:2:{i:0;s:6:"thread";i:1;i:1491071;}s:14:"thread-1485620";a:2:{i:0;s:6:"thread";i:1;i:1485620;}s:14:"thread-1485054";a:2:{i:0;s:6:"thread";i:1;i:1485054;}s:14:"thread-1483655";a:2:{i:0;s:6:"thread";i:1;i:1483655;}s:14:"thread-1482670";a:2:{i:0;s:6:"thread";i:1;i:1482670;}s:14:"thread-1481195";a:2:{i:0;s:6:"thread";i:1;i:1481195;}s:14:"thread-1474264";a:2:{i:0;s:6:"thread";i:1;i:1474264;}s:14:"thread-1472094";a:2:{i:0;s:6:"thread";i:1;i:1472094;}s:14:"thread-1470485";a:2:{i:0;s:6:"thread";i:1;i:1470485;}s:14:"thread-1465544";a:2:{i:0;s:6:"thread";i:1;i:1465544;}s:14:"thread-1464230";a:2:{i:0;s:6:"thread";i:1;i:1464230;}}, , 1715804696
Run Time: 0.000948
- 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=brown-eyes, 1715804696,
Run Time: 0.000096
- 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