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 (2816936, 2741593, 2741584, 2741575, 2430041, 2379437, 2316439, 2301413, 2215258, 2189033, 2182757, 2093108, 2082428, 2067759, 2065401, 2062234, 2027231, 2026847, 2021802, 2021260, 1995221, 1994878, 1991265, 1990905, 1984926, 1976366, 1973382, 1972414, 1969537, 1964490, 1935606, 1935111, 1911185, 1911184, 1849829, 1849337, 1836312, 1832153, 1804419, 1762843, 1710360, 1710274, 1672302, 1627921, 1627919, 1627917, 1627915, 1627914, 1627561, 1627560, 1624733, 1624730, 1615684, 1615681, 1615678, 1615676, 1615674, 1610019, 1605945, 1603186, 1603184, 1602105, 1602104, 1579821, 1527027, 1515114, 1511789, 1505688, 1504877, 1485043, 1483112, 1482342, 1482141, 1459265, 1458654, 1458463, 1458249, 1458246, 1458201, 1458182, 1457872, 1457345, 1457230, 1456664, 1456545, 1456350, 1456221, 1455921, 1455782, 1455682, 1455358, 1454765, 1437392))
Run Time: 0.048034
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 93 | 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: 508, 0, 1714984382, a:93:{s:14:"thread-2816936";a:2:{i:0;s:6:"thread";i:1;i:2816936;}s:14:"thread-2741593";a:2:{i:0;s:6:"thread";i:1;i:2741593;}s:14:"thread-2741584";a:2:{i:0;s:6:"thread";i:1;i:2741584;}s:14:"thread-2741575";a:2:{i:0;s:6:"thread";i:1;i:2741575;}s:14:"thread-2430041";a:2:{i:0;s:6:"thread";i:1;i:2430041;}s:14:"thread-2379437";a:2:{i:0;s:6:"thread";i:1;i:2379437;}s:14:"thread-2316439";a:2:{i:0;s:6:"thread";i:1;i:2316439;}s:14:"thread-2301413";a:2:{i:0;s:6:"thread";i:1;i:2301413;}s:14:"thread-2215258";a:2:{i:0;s:6:"thread";i:1;i:2215258;}s:14:"thread-2189033";a:2:{i:0;s:6:"thread";i:1;i:2189033;}s:14:"thread-2182757";a:2:{i:0;s:6:"thread";i:1;i:2182757;}s:14:"thread-2093108";a:2:{i:0;s:6:"thread";i:1;i:2093108;}s:14:"thread-2082428";a:2:{i:0;s:6:"thread";i:1;i:2082428;}s:14:"thread-2067759";a:2:{i:0;s:6:"thread";i:1;i:2067759;}s:14:"thread-2065401";a:2:{i:0;s:6:"thread";i:1;i:2065401;}s:14:"thread-2062234";a:2:{i:0;s:6:"thread";i:1;i:2062234;}s:14:"thread-2027231";a:2:{i:0;s:6:"thread";i:1;i:2027231;}s:14:"thread-2026847";a:2:{i:0;s:6:"thread";i:1;i:2026847;}s:14:"thread-2021802";a:2:{i:0;s:6:"thread";i:1;i:2021802;}s:14:"thread-2021260";a:2:{i:0;s:6:"thread";i:1;i:2021260;}s:14:"thread-1995221";a:2:{i:0;s:6:"thread";i:1;i:1995221;}s:14:"thread-1994878";a:2:{i:0;s:6:"thread";i:1;i:1994878;}s:14:"thread-1991265";a:2:{i:0;s:6:"thread";i:1;i:1991265;}s:14:"thread-1990905";a:2:{i:0;s:6:"thread";i:1;i:1990905;}s:14:"thread-1984926";a:2:{i:0;s:6:"thread";i:1;i:1984926;}s:14:"thread-1976366";a:2:{i:0;s:6:"thread";i:1;i:1976366;}s:14:"thread-1973382";a:2:{i:0;s:6:"thread";i:1;i:1973382;}s:14:"thread-1972414";a:2:{i:0;s:6:"thread";i:1;i:1972414;}s:14:"thread-1969537";a:2:{i:0;s:6:"thread";i:1;i:1969537;}s:14:"thread-1964490";a:2:{i:0;s:6:"thread";i:1;i:1964490;}s:14:"thread-1935606";a:2:{i:0;s:6:"thread";i:1;i:1935606;}s:14:"thread-1935111";a:2:{i:0;s:6:"thread";i:1;i:1935111;}s:14:"thread-1911185";a:2:{i:0;s:6:"thread";i:1;i:1911185;}s:14:"thread-1911184";a:2:{i:0;s:6:"thread";i:1;i:1911184;}s:14:"thread-1849829";a:2:{i:0;s:6:"thread";i:1;i:1849829;}s:14:"thread-1849337";a:2:{i:0;s:6:"thread";i:1;i:1849337;}s:14:"thread-1836312";a:2:{i:0;s:6:"thread";i:1;i:1836312;}s:14:"thread-1832153";a:2:{i:0;s:6:"thread";i:1;i:1832153;}s:14:"thread-1804419";a:2:{i:0;s:6:"thread";i:1;i:1804419;}s:14:"thread-1762843";a:2:{i:0;s:6:"thread";i:1;i:1762843;}s:14:"thread-1710360";a:2:{i:0;s:6:"thread";i:1;i:1710360;}s:14:"thread-1710274";a:2:{i:0;s:6:"thread";i:1;i:1710274;}s:14:"thread-1672302";a:2:{i:0;s:6:"thread";i:1;i:1672302;}s:14:"thread-1627921";a:2:{i:0;s:6:"thread";i:1;i:1627921;}s:14:"thread-1627919";a:2:{i:0;s:6:"thread";i:1;i:1627919;}s:14:"thread-1627917";a:2:{i:0;s:6:"thread";i:1;i:1627917;}s:14:"thread-1627915";a:2:{i:0;s:6:"thread";i:1;i:1627915;}s:14:"thread-1627914";a:2:{i:0;s:6:"thread";i:1;i:1627914;}s:14:"thread-1627561";a:2:{i:0;s:6:"thread";i:1;i:1627561;}s:14:"thread-1627560";a:2:{i:0;s:6:"thread";i:1;i:1627560;}s:14:"thread-1624733";a:2:{i:0;s:6:"thread";i:1;i:1624733;}s:14:"thread-1624730";a:2:{i:0;s:6:"thread";i:1;i:1624730;}s:14:"thread-1615684";a:2:{i:0;s:6:"thread";i:1;i:1615684;}s:14:"thread-1615681";a:2:{i:0;s:6:"thread";i:1;i:1615681;}s:14:"thread-1615678";a:2:{i:0;s:6:"thread";i:1;i:1615678;}s:14:"thread-1615676";a:2:{i:0;s:6:"thread";i:1;i:1615676;}s:14:"thread-1615674";a:2:{i:0;s:6:"thread";i:1;i:1615674;}s:14:"thread-1610019";a:2:{i:0;s:6:"thread";i:1;i:1610019;}s:14:"thread-1605945";a:2:{i:0;s:6:"thread";i:1;i:1605945;}s:14:"thread-1603186";a:2:{i:0;s:6:"thread";i:1;i:1603186;}s:14:"thread-1603184";a:2:{i:0;s:6:"thread";i:1;i:1603184;}s:14:"thread-1602105";a:2:{i:0;s:6:"thread";i:1;i:1602105;}s:14:"thread-1602104";a:2:{i:0;s:6:"thread";i:1;i:1602104;}s:14:"thread-1579821";a:2:{i:0;s:6:"thread";i:1;i:1579821;}s:14:"thread-1527027";a:2:{i:0;s:6:"thread";i:1;i:1527027;}s:14:"thread-1515114";a:2:{i:0;s:6:"thread";i:1;i:1515114;}s:14:"thread-1511789";a:2:{i:0;s:6:"thread";i:1;i:1511789;}s:14:"thread-1505688";a:2:{i:0;s:6:"thread";i:1;i:1505688;}s:14:"thread-1504877";a:2:{i:0;s:6:"thread";i:1;i:1504877;}s:14:"thread-1485043";a:2:{i:0;s:6:"thread";i:1;i:1485043;}s:14:"thread-1483112";a:2:{i:0;s:6:"thread";i:1;i:1483112;}s:14:"thread-1482342";a:2:{i:0;s:6:"thread";i:1;i:1482342;}s:14:"thread-1482141";a:2:{i:0;s:6:"thread";i:1;i:1482141;}s:14:"thread-1459265";a:2:{i:0;s:6:"thread";i:1;i:1459265;}s:14:"thread-1458654";a:2:{i:0;s:6:"thread";i:1;i:1458654;}s:14:"thread-1458463";a:2:{i:0;s:6:"thread";i:1;i:1458463;}s:14:"thread-1458249";a:2:{i:0;s:6:"thread";i:1;i:1458249;}s:14:"thread-1458246";a:2:{i:0;s:6:"thread";i:1;i:1458246;}s:14:"thread-1458201";a:2:{i:0;s:6:"thread";i:1;i:1458201;}s:14:"thread-1458182";a:2:{i:0;s:6:"thread";i:1;i:1458182;}s:14:"thread-1457872";a:2:{i:0;s:6:"thread";i:1;i:1457872;}s:14:"thread-1457345";a:2:{i:0;s:6:"thread";i:1;i:1457345;}s:14:"thread-1457230";a:2:{i:0;s:6:"thread";i:1;i:1457230;}s:14:"thread-1456664";a:2:{i:0;s:6:"thread";i:1;i:1456664;}s:14:"thread-1456545";a:2:{i:0;s:6:"thread";i:1;i:1456545;}s:14:"thread-1456350";a:2:{i:0;s:6:"thread";i:1;i:1456350;}s:14:"thread-1456221";a:2:{i:0;s:6:"thread";i:1;i:1456221;}s:14:"thread-1455921";a:2:{i:0;s:6:"thread";i:1;i:1455921;}s:14:"thread-1455782";a:2:{i:0;s:6:"thread";i:1;i:1455782;}s:14:"thread-1455682";a:2:{i:0;s:6:"thread";i:1;i:1455682;}s:14:"thread-1455358";a:2:{i:0;s:6:"thread";i:1;i:1455358;}s:14:"thread-1454765";a:2:{i:0;s:6:"thread";i:1;i:1454765;}s:14:"thread-1437392";a:2:{i:0;s:6:"thread";i:1;i:1437392;}}, , 1714980782
Run Time: 0.001062
- 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=nylon&page=3, 1714980782,
Run Time: 0.000069
- 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