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 (2756045, 2712417, 2712406, 2398518, 2396663, 2334381, 2330832, 2328760, 2326649, 2323327, 2291921, 2290418, 2277667, 2277661, 2260202, 2257054, 2241645, 2177509, 2111154, 2093381, 2093339, 2078295, 2070708, 2068185, 2060240, 2059685, 2054297, 2020316, 1997466, 1913926, 1913891, 1907883, 1852142, 1852034, 1836283, 1819459, 1818808, 1818631, 1807631, 1804946, 1794410, 1779918, 1767850, 1723906, 1693757, 1686718, 1652148, 1620628, 1620095, 1550764, 1549163, 1539754, 1535771, 1535256, 1529051, 1525269, 1525169, 1521516, 1513666, 1501304, 1477044, 1465046, 1464386, 1464059, 1437901, 1437883, 1437862, 1437805, 1437725, 1437720, 1437683, 1437680, 1437650, 1437455, 1437454, 1437445, 1436714, 1436350, 1395607, 1315950, 1195674, 1195313))
Run Time: 0.051169
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: 325, 0, 1714104422, a:82:{s:14:"thread-2756045";a:2:{i:0;s:6:"thread";i:1;i:2756045;}s:14:"thread-2712417";a:2:{i:0;s:6:"thread";i:1;i:2712417;}s:14:"thread-2712406";a:2:{i:0;s:6:"thread";i:1;i:2712406;}s:14:"thread-2398518";a:2:{i:0;s:6:"thread";i:1;i:2398518;}s:14:"thread-2396663";a:2:{i:0;s:6:"thread";i:1;i:2396663;}s:14:"thread-2334381";a:2:{i:0;s:6:"thread";i:1;i:2334381;}s:14:"thread-2330832";a:2:{i:0;s:6:"thread";i:1;i:2330832;}s:14:"thread-2328760";a:2:{i:0;s:6:"thread";i:1;i:2328760;}s:14:"thread-2326649";a:2:{i:0;s:6:"thread";i:1;i:2326649;}s:14:"thread-2323327";a:2:{i:0;s:6:"thread";i:1;i:2323327;}s:14:"thread-2291921";a:2:{i:0;s:6:"thread";i:1;i:2291921;}s:14:"thread-2290418";a:2:{i:0;s:6:"thread";i:1;i:2290418;}s:14:"thread-2277667";a:2:{i:0;s:6:"thread";i:1;i:2277667;}s:14:"thread-2277661";a:2:{i:0;s:6:"thread";i:1;i:2277661;}s:14:"thread-2260202";a:2:{i:0;s:6:"thread";i:1;i:2260202;}s:14:"thread-2257054";a:2:{i:0;s:6:"thread";i:1;i:2257054;}s:14:"thread-2241645";a:2:{i:0;s:6:"thread";i:1;i:2241645;}s:14:"thread-2177509";a:2:{i:0;s:6:"thread";i:1;i:2177509;}s:14:"thread-2111154";a:2:{i:0;s:6:"thread";i:1;i:2111154;}s:14:"thread-2093381";a:2:{i:0;s:6:"thread";i:1;i:2093381;}s:14:"thread-2093339";a:2:{i:0;s:6:"thread";i:1;i:2093339;}s:14:"thread-2078295";a:2:{i:0;s:6:"thread";i:1;i:2078295;}s:14:"thread-2070708";a:2:{i:0;s:6:"thread";i:1;i:2070708;}s:14:"thread-2068185";a:2:{i:0;s:6:"thread";i:1;i:2068185;}s:14:"thread-2060240";a:2:{i:0;s:6:"thread";i:1;i:2060240;}s:14:"thread-2059685";a:2:{i:0;s:6:"thread";i:1;i:2059685;}s:14:"thread-2054297";a:2:{i:0;s:6:"thread";i:1;i:2054297;}s:14:"thread-2020316";a:2:{i:0;s:6:"thread";i:1;i:2020316;}s:14:"thread-1997466";a:2:{i:0;s:6:"thread";i:1;i:1997466;}s:14:"thread-1913926";a:2:{i:0;s:6:"thread";i:1;i:1913926;}s:14:"thread-1913891";a:2:{i:0;s:6:"thread";i:1;i:1913891;}s:14:"thread-1907883";a:2:{i:0;s:6:"thread";i:1;i:1907883;}s:14:"thread-1852142";a:2:{i:0;s:6:"thread";i:1;i:1852142;}s:14:"thread-1852034";a:2:{i:0;s:6:"thread";i:1;i:1852034;}s:14:"thread-1836283";a:2:{i:0;s:6:"thread";i:1;i:1836283;}s:14:"thread-1819459";a:2:{i:0;s:6:"thread";i:1;i:1819459;}s:14:"thread-1818808";a:2:{i:0;s:6:"thread";i:1;i:1818808;}s:14:"thread-1818631";a:2:{i:0;s:6:"thread";i:1;i:1818631;}s:14:"thread-1807631";a:2:{i:0;s:6:"thread";i:1;i:1807631;}s:14:"thread-1804946";a:2:{i:0;s:6:"thread";i:1;i:1804946;}s:14:"thread-1794410";a:2:{i:0;s:6:"thread";i:1;i:1794410;}s:14:"thread-1779918";a:2:{i:0;s:6:"thread";i:1;i:1779918;}s:14:"thread-1767850";a:2:{i:0;s:6:"thread";i:1;i:1767850;}s:14:"thread-1723906";a:2:{i:0;s:6:"thread";i:1;i:1723906;}s:14:"thread-1693757";a:2:{i:0;s:6:"thread";i:1;i:1693757;}s:14:"thread-1686718";a:2:{i:0;s:6:"thread";i:1;i:1686718;}s:14:"thread-1652148";a:2:{i:0;s:6:"thread";i:1;i:1652148;}s:14:"thread-1620628";a:2:{i:0;s:6:"thread";i:1;i:1620628;}s:14:"thread-1620095";a:2:{i:0;s:6:"thread";i:1;i:1620095;}s:14:"thread-1550764";a:2:{i:0;s:6:"thread";i:1;i:1550764;}s:14:"thread-1549163";a:2:{i:0;s:6:"thread";i:1;i:1549163;}s:14:"thread-1539754";a:2:{i:0;s:6:"thread";i:1;i:1539754;}s:14:"thread-1535771";a:2:{i:0;s:6:"thread";i:1;i:1535771;}s:14:"thread-1535256";a:2:{i:0;s:6:"thread";i:1;i:1535256;}s:14:"thread-1529051";a:2:{i:0;s:6:"thread";i:1;i:1529051;}s:14:"thread-1525269";a:2:{i:0;s:6:"thread";i:1;i:1525269;}s:14:"thread-1525169";a:2:{i:0;s:6:"thread";i:1;i:1525169;}s:14:"thread-1521516";a:2:{i:0;s:6:"thread";i:1;i:1521516;}s:14:"thread-1513666";a:2:{i:0;s:6:"thread";i:1;i:1513666;}s:14:"thread-1501304";a:2:{i:0;s:6:"thread";i:1;i:1501304;}s:14:"thread-1477044";a:2:{i:0;s:6:"thread";i:1;i:1477044;}s:14:"thread-1465046";a:2:{i:0;s:6:"thread";i:1;i:1465046;}s:14:"thread-1464386";a:2:{i:0;s:6:"thread";i:1;i:1464386;}s:14:"thread-1464059";a:2:{i:0;s:6:"thread";i:1;i:1464059;}s:14:"thread-1437901";a:2:{i:0;s:6:"thread";i:1;i:1437901;}s:14:"thread-1437883";a:2:{i:0;s:6:"thread";i:1;i:1437883;}s:14:"thread-1437862";a:2:{i:0;s:6:"thread";i:1;i:1437862;}s:14:"thread-1437805";a:2:{i:0;s:6:"thread";i:1;i:1437805;}s:14:"thread-1437725";a:2:{i:0;s:6:"thread";i:1;i:1437725;}s:14:"thread-1437720";a:2:{i:0;s:6:"thread";i:1;i:1437720;}s:14:"thread-1437683";a:2:{i:0;s:6:"thread";i:1;i:1437683;}s:14:"thread-1437680";a:2:{i:0;s:6:"thread";i:1;i:1437680;}s:14:"thread-1437650";a:2:{i:0;s:6:"thread";i:1;i:1437650;}s:14:"thread-1437455";a:2:{i:0;s:6:"thread";i:1;i:1437455;}s:14:"thread-1437454";a:2:{i:0;s:6:"thread";i:1;i:1437454;}s:14:"thread-1437445";a:2:{i:0;s:6:"thread";i:1;i:1437445;}s:14:"thread-1436714";a:2:{i:0;s:6:"thread";i:1;i:1436714;}s:14:"thread-1436350";a:2:{i:0;s:6:"thread";i:1;i:1436350;}s:14:"thread-1395607";a:2:{i:0;s:6:"thread";i:1;i:1395607;}s:14:"thread-1315950";a:2:{i:0;s:6:"thread";i:1;i:1315950;}s:14:"thread-1195674";a:2:{i:0;s:6:"thread";i:1;i:1195674;}s:14:"thread-1195313";a:2:{i:0;s:6:"thread";i:1;i:1195313;}}, , 1714100822
Run Time: 0.002576
- 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=torture, 1714100822,
Run Time: 0.000135
- 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