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 (2830501, 2816936, 2784491, 2781990, 2756056, 2723671, 2673780, 2667138, 2667133, 2442596, 2394277, 2368623, 2346888, 2339330, 2323319, 2323317, 2321621, 2319480, 2319476, 2319471, 2241608, 2241585, 2118304, 1991495, 1988973, 1967841, 1967599, 1967307, 1967182, 1966410, 1963337, 1963202, 1963029, 1931643, 1931177, 1931020, 1930576, 1930551, 1900516, 1900515, 1832153, 1820520, 1800442, 1781693, 1781680, 1781301, 1780277, 1779899, 1778063, 1778060, 1763447, 1763047, 1758522, 1758516, 1758514, 1756970, 1756958, 1724208, 1689247, 1672061, 1647232, 1641596, 1540601, 1529022, 1515119, 1515089, 1514734, 1514552, 1512603, 1512575, 1512572, 1512570, 1511881, 1511595, 1504916, 1501595, 1483074, 1483027, 1480822, 1480813, 1475893, 1468672, 1436667, 1436666, 1436297, 1436053, 1435978))
Run Time: 0.038814
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: 182, 0, 1714019677, a:87:{s:14:"thread-2830501";a:2:{i:0;s:6:"thread";i:1;i:2830501;}s:14:"thread-2816936";a:2:{i:0;s:6:"thread";i:1;i:2816936;}s:14:"thread-2784491";a:2:{i:0;s:6:"thread";i:1;i:2784491;}s:14:"thread-2781990";a:2:{i:0;s:6:"thread";i:1;i:2781990;}s:14:"thread-2756056";a:2:{i:0;s:6:"thread";i:1;i:2756056;}s:14:"thread-2723671";a:2:{i:0;s:6:"thread";i:1;i:2723671;}s:14:"thread-2673780";a:2:{i:0;s:6:"thread";i:1;i:2673780;}s:14:"thread-2667138";a:2:{i:0;s:6:"thread";i:1;i:2667138;}s:14:"thread-2667133";a:2:{i:0;s:6:"thread";i:1;i:2667133;}s:14:"thread-2442596";a:2:{i:0;s:6:"thread";i:1;i:2442596;}s:14:"thread-2394277";a:2:{i:0;s:6:"thread";i:1;i:2394277;}s:14:"thread-2368623";a:2:{i:0;s:6:"thread";i:1;i:2368623;}s:14:"thread-2346888";a:2:{i:0;s:6:"thread";i:1;i:2346888;}s:14:"thread-2339330";a:2:{i:0;s:6:"thread";i:1;i:2339330;}s:14:"thread-2323319";a:2:{i:0;s:6:"thread";i:1;i:2323319;}s:14:"thread-2323317";a:2:{i:0;s:6:"thread";i:1;i:2323317;}s:14:"thread-2321621";a:2:{i:0;s:6:"thread";i:1;i:2321621;}s:14:"thread-2319480";a:2:{i:0;s:6:"thread";i:1;i:2319480;}s:14:"thread-2319476";a:2:{i:0;s:6:"thread";i:1;i:2319476;}s:14:"thread-2319471";a:2:{i:0;s:6:"thread";i:1;i:2319471;}s:14:"thread-2241608";a:2:{i:0;s:6:"thread";i:1;i:2241608;}s:14:"thread-2241585";a:2:{i:0;s:6:"thread";i:1;i:2241585;}s:14:"thread-2118304";a:2:{i:0;s:6:"thread";i:1;i:2118304;}s:14:"thread-1991495";a:2:{i:0;s:6:"thread";i:1;i:1991495;}s:14:"thread-1988973";a:2:{i:0;s:6:"thread";i:1;i:1988973;}s:14:"thread-1967841";a:2:{i:0;s:6:"thread";i:1;i:1967841;}s:14:"thread-1967599";a:2:{i:0;s:6:"thread";i:1;i:1967599;}s:14:"thread-1967307";a:2:{i:0;s:6:"thread";i:1;i:1967307;}s:14:"thread-1967182";a:2:{i:0;s:6:"thread";i:1;i:1967182;}s:14:"thread-1966410";a:2:{i:0;s:6:"thread";i:1;i:1966410;}s:14:"thread-1963337";a:2:{i:0;s:6:"thread";i:1;i:1963337;}s:14:"thread-1963202";a:2:{i:0;s:6:"thread";i:1;i:1963202;}s:14:"thread-1963029";a:2:{i:0;s:6:"thread";i:1;i:1963029;}s:14:"thread-1931643";a:2:{i:0;s:6:"thread";i:1;i:1931643;}s:14:"thread-1931177";a:2:{i:0;s:6:"thread";i:1;i:1931177;}s:14:"thread-1931020";a:2:{i:0;s:6:"thread";i:1;i:1931020;}s:14:"thread-1930576";a:2:{i:0;s:6:"thread";i:1;i:1930576;}s:14:"thread-1930551";a:2:{i:0;s:6:"thread";i:1;i:1930551;}s:14:"thread-1900516";a:2:{i:0;s:6:"thread";i:1;i:1900516;}s:14:"thread-1900515";a:2:{i:0;s:6:"thread";i:1;i:1900515;}s:14:"thread-1832153";a:2:{i:0;s:6:"thread";i:1;i:1832153;}s:14:"thread-1820520";a:2:{i:0;s:6:"thread";i:1;i:1820520;}s:14:"thread-1800442";a:2:{i:0;s:6:"thread";i:1;i:1800442;}s:14:"thread-1781693";a:2:{i:0;s:6:"thread";i:1;i:1781693;}s:14:"thread-1781680";a:2:{i:0;s:6:"thread";i:1;i:1781680;}s:14:"thread-1781301";a:2:{i:0;s:6:"thread";i:1;i:1781301;}s:14:"thread-1780277";a:2:{i:0;s:6:"thread";i:1;i:1780277;}s:14:"thread-1779899";a:2:{i:0;s:6:"thread";i:1;i:1779899;}s:14:"thread-1778063";a:2:{i:0;s:6:"thread";i:1;i:1778063;}s:14:"thread-1778060";a:2:{i:0;s:6:"thread";i:1;i:1778060;}s:14:"thread-1763447";a:2:{i:0;s:6:"thread";i:1;i:1763447;}s:14:"thread-1763047";a:2:{i:0;s:6:"thread";i:1;i:1763047;}s:14:"thread-1758522";a:2:{i:0;s:6:"thread";i:1;i:1758522;}s:14:"thread-1758516";a:2:{i:0;s:6:"thread";i:1;i:1758516;}s:14:"thread-1758514";a:2:{i:0;s:6:"thread";i:1;i:1758514;}s:14:"thread-1756970";a:2:{i:0;s:6:"thread";i:1;i:1756970;}s:14:"thread-1756958";a:2:{i:0;s:6:"thread";i:1;i:1756958;}s:14:"thread-1724208";a:2:{i:0;s:6:"thread";i:1;i:1724208;}s:14:"thread-1689247";a:2:{i:0;s:6:"thread";i:1;i:1689247;}s:14:"thread-1672061";a:2:{i:0;s:6:"thread";i:1;i:1672061;}s:14:"thread-1647232";a:2:{i:0;s:6:"thread";i:1;i:1647232;}s:14:"thread-1641596";a:2:{i:0;s:6:"thread";i:1;i:1641596;}s:14:"thread-1540601";a:2:{i:0;s:6:"thread";i:1;i:1540601;}s:14:"thread-1529022";a:2:{i:0;s:6:"thread";i:1;i:1529022;}s:14:"thread-1515119";a:2:{i:0;s:6:"thread";i:1;i:1515119;}s:14:"thread-1515089";a:2:{i:0;s:6:"thread";i:1;i:1515089;}s:14:"thread-1514734";a:2:{i:0;s:6:"thread";i:1;i:1514734;}s:14:"thread-1514552";a:2:{i:0;s:6:"thread";i:1;i:1514552;}s:14:"thread-1512603";a:2:{i:0;s:6:"thread";i:1;i:1512603;}s:14:"thread-1512575";a:2:{i:0;s:6:"thread";i:1;i:1512575;}s:14:"thread-1512572";a:2:{i:0;s:6:"thread";i:1;i:1512572;}s:14:"thread-1512570";a:2:{i:0;s:6:"thread";i:1;i:1512570;}s:14:"thread-1511881";a:2:{i:0;s:6:"thread";i:1;i:1511881;}s:14:"thread-1511595";a:2:{i:0;s:6:"thread";i:1;i:1511595;}s:14:"thread-1504916";a:2:{i:0;s:6:"thread";i:1;i:1504916;}s:14:"thread-1501595";a:2:{i:0;s:6:"thread";i:1;i:1501595;}s:14:"thread-1483074";a:2:{i:0;s:6:"thread";i:1;i:1483074;}s:14:"thread-1483027";a:2:{i:0;s:6:"thread";i:1;i:1483027;}s:14:"thread-1480822";a:2:{i:0;s:6:"thread";i:1;i:1480822;}s:14:"thread-1480813";a:2:{i:0;s:6:"thread";i:1;i:1480813;}s:14:"thread-1475893";a:2:{i:0;s:6:"thread";i:1;i:1475893;}s:14:"thread-1468672";a:2:{i:0;s:6:"thread";i:1;i:1468672;}s:14:"thread-1436667";a:2:{i:0;s:6:"thread";i:1;i:1436667;}s:14:"thread-1436666";a:2:{i:0;s:6:"thread";i:1;i:1436666;}s:14:"thread-1436297";a:2:{i:0;s:6:"thread";i:1;i:1436297;}s:14:"thread-1436053";a:2:{i:0;s:6:"thread";i:1;i:1436053;}s:14:"thread-1435978";a:2:{i:0;s:6:"thread";i:1;i:1435978;}}, , 1714016077
Run Time: 0.000174
- 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=vintage, 1714016077,
Run Time: 0.000077
- 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