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 (2756047, 2180991, 2027350, 2027298, 2027231, 2026847, 2026737, 2021802, 2021595, 2021583, 2021347, 2021260, 2000014, 1994998, 1994878, 1994804, 1993215, 1992973, 1991335, 1991265, 1987979, 1987634, 1986391, 1986338, 1984961, 1984926, 1976366, 1975083, 1975045, 1973382, 1961778, 1959363, 1959313, 1955942, 1955857, 1950367, 1950356, 1950343, 1950157, 1950046, 1944217, 1944040, 1941376, 1938114, 1938091, 1935852, 1935560, 1935430, 1935273, 1935122, 1935111, 1934986, 1934890, 1921864, 1918269, 1917242, 1916707, 1913234, 1913119, 1911185, 1911184, 1900712, 1896604, 1891713, 1891681, 1880937, 1849829, 1849799, 1849677, 1849612, 1849532, 1849337, 1849291, 1847191, 1818984, 1758271, 1703885, 1644985, 1555655, 1437469, 1436089, 1435903))
Run Time: 0.040642
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: 36, 0, 1714714874, a:82:{s:14:"thread-2756047";a:2:{i:0;s:6:"thread";i:1;i:2756047;}s:14:"thread-2180991";a:2:{i:0;s:6:"thread";i:1;i:2180991;}s:14:"thread-2027350";a:2:{i:0;s:6:"thread";i:1;i:2027350;}s:14:"thread-2027298";a:2:{i:0;s:6:"thread";i:1;i:2027298;}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-2026737";a:2:{i:0;s:6:"thread";i:1;i:2026737;}s:14:"thread-2021802";a:2:{i:0;s:6:"thread";i:1;i:2021802;}s:14:"thread-2021595";a:2:{i:0;s:6:"thread";i:1;i:2021595;}s:14:"thread-2021583";a:2:{i:0;s:6:"thread";i:1;i:2021583;}s:14:"thread-2021347";a:2:{i:0;s:6:"thread";i:1;i:2021347;}s:14:"thread-2021260";a:2:{i:0;s:6:"thread";i:1;i:2021260;}s:14:"thread-2000014";a:2:{i:0;s:6:"thread";i:1;i:2000014;}s:14:"thread-1994998";a:2:{i:0;s:6:"thread";i:1;i:1994998;}s:14:"thread-1994878";a:2:{i:0;s:6:"thread";i:1;i:1994878;}s:14:"thread-1994804";a:2:{i:0;s:6:"thread";i:1;i:1994804;}s:14:"thread-1993215";a:2:{i:0;s:6:"thread";i:1;i:1993215;}s:14:"thread-1992973";a:2:{i:0;s:6:"thread";i:1;i:1992973;}s:14:"thread-1991335";a:2:{i:0;s:6:"thread";i:1;i:1991335;}s:14:"thread-1991265";a:2:{i:0;s:6:"thread";i:1;i:1991265;}s:14:"thread-1987979";a:2:{i:0;s:6:"thread";i:1;i:1987979;}s:14:"thread-1987634";a:2:{i:0;s:6:"thread";i:1;i:1987634;}s:14:"thread-1986391";a:2:{i:0;s:6:"thread";i:1;i:1986391;}s:14:"thread-1986338";a:2:{i:0;s:6:"thread";i:1;i:1986338;}s:14:"thread-1984961";a:2:{i:0;s:6:"thread";i:1;i:1984961;}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-1975083";a:2:{i:0;s:6:"thread";i:1;i:1975083;}s:14:"thread-1975045";a:2:{i:0;s:6:"thread";i:1;i:1975045;}s:14:"thread-1973382";a:2:{i:0;s:6:"thread";i:1;i:1973382;}s:14:"thread-1961778";a:2:{i:0;s:6:"thread";i:1;i:1961778;}s:14:"thread-1959363";a:2:{i:0;s:6:"thread";i:1;i:1959363;}s:14:"thread-1959313";a:2:{i:0;s:6:"thread";i:1;i:1959313;}s:14:"thread-1955942";a:2:{i:0;s:6:"thread";i:1;i:1955942;}s:14:"thread-1955857";a:2:{i:0;s:6:"thread";i:1;i:1955857;}s:14:"thread-1950367";a:2:{i:0;s:6:"thread";i:1;i:1950367;}s:14:"thread-1950356";a:2:{i:0;s:6:"thread";i:1;i:1950356;}s:14:"thread-1950343";a:2:{i:0;s:6:"thread";i:1;i:1950343;}s:14:"thread-1950157";a:2:{i:0;s:6:"thread";i:1;i:1950157;}s:14:"thread-1950046";a:2:{i:0;s:6:"thread";i:1;i:1950046;}s:14:"thread-1944217";a:2:{i:0;s:6:"thread";i:1;i:1944217;}s:14:"thread-1944040";a:2:{i:0;s:6:"thread";i:1;i:1944040;}s:14:"thread-1941376";a:2:{i:0;s:6:"thread";i:1;i:1941376;}s:14:"thread-1938114";a:2:{i:0;s:6:"thread";i:1;i:1938114;}s:14:"thread-1938091";a:2:{i:0;s:6:"thread";i:1;i:1938091;}s:14:"thread-1935852";a:2:{i:0;s:6:"thread";i:1;i:1935852;}s:14:"thread-1935560";a:2:{i:0;s:6:"thread";i:1;i:1935560;}s:14:"thread-1935430";a:2:{i:0;s:6:"thread";i:1;i:1935430;}s:14:"thread-1935273";a:2:{i:0;s:6:"thread";i:1;i:1935273;}s:14:"thread-1935122";a:2:{i:0;s:6:"thread";i:1;i:1935122;}s:14:"thread-1935111";a:2:{i:0;s:6:"thread";i:1;i:1935111;}s:14:"thread-1934986";a:2:{i:0;s:6:"thread";i:1;i:1934986;}s:14:"thread-1934890";a:2:{i:0;s:6:"thread";i:1;i:1934890;}s:14:"thread-1921864";a:2:{i:0;s:6:"thread";i:1;i:1921864;}s:14:"thread-1918269";a:2:{i:0;s:6:"thread";i:1;i:1918269;}s:14:"thread-1917242";a:2:{i:0;s:6:"thread";i:1;i:1917242;}s:14:"thread-1916707";a:2:{i:0;s:6:"thread";i:1;i:1916707;}s:14:"thread-1913234";a:2:{i:0;s:6:"thread";i:1;i:1913234;}s:14:"thread-1913119";a:2:{i:0;s:6:"thread";i:1;i:1913119;}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-1900712";a:2:{i:0;s:6:"thread";i:1;i:1900712;}s:14:"thread-1896604";a:2:{i:0;s:6:"thread";i:1;i:1896604;}s:14:"thread-1891713";a:2:{i:0;s:6:"thread";i:1;i:1891713;}s:14:"thread-1891681";a:2:{i:0;s:6:"thread";i:1;i:1891681;}s:14:"thread-1880937";a:2:{i:0;s:6:"thread";i:1;i:1880937;}s:14:"thread-1849829";a:2:{i:0;s:6:"thread";i:1;i:1849829;}s:14:"thread-1849799";a:2:{i:0;s:6:"thread";i:1;i:1849799;}s:14:"thread-1849677";a:2:{i:0;s:6:"thread";i:1;i:1849677;}s:14:"thread-1849612";a:2:{i:0;s:6:"thread";i:1;i:1849612;}s:14:"thread-1849532";a:2:{i:0;s:6:"thread";i:1;i:1849532;}s:14:"thread-1849337";a:2:{i:0;s:6:"thread";i:1;i:1849337;}s:14:"thread-1849291";a:2:{i:0;s:6:"thread";i:1;i:1849291;}s:14:"thread-1847191";a:2:{i:0;s:6:"thread";i:1;i:1847191;}s:14:"thread-1818984";a:2:{i:0;s:6:"thread";i:1;i:1818984;}s:14:"thread-1758271";a:2:{i:0;s:6:"thread";i:1;i:1758271;}s:14:"thread-1703885";a:2:{i:0;s:6:"thread";i:1;i:1703885;}s:14:"thread-1644985";a:2:{i:0;s:6:"thread";i:1;i:1644985;}s:14:"thread-1555655";a:2:{i:0;s:6:"thread";i:1;i:1555655;}s:14:"thread-1437469";a:2:{i:0;s:6:"thread";i:1;i:1437469;}s:14:"thread-1436089";a:2:{i:0;s:6:"thread";i:1;i:1436089;}s:14:"thread-1435903";a:2:{i:0;s:6:"thread";i:1;i:1435903;}}, , 1714711274
Run Time: 0.000146
- 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=strap-on, 1714711274,
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