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 (2731631, 2724217, 2546737, 2532273, 2527373, 2493090, 2393504, 2387035, 2380989, 2379478, 2379433, 2239971, 2181698, 2181632, 2175062, 2113677, 2106206, 2099183, 2099181, 2078411, 2064129, 2052315, 2028984, 2027781, 2026866, 2015974, 2005436, 2004039, 2002800, 2000684, 1999604, 1999596, 1999418, 1997939, 1991365, 1970983, 1970680, 1953773, 1942713, 1942707, 1941988, 1941965, 1941796, 1941775, 1941771, 1940990, 1940801, 1938430, 1938418, 1936348, 1933859, 1933513, 1923435, 1908484, 1907292, 1907290, 1907114, 1907113, 1904626, 1897976, 1895807, 1891387, 1890292, 1890284, 1888277, 1886293, 1885976, 1885524, 1884456, 1884283, 1884268, 1883009, 1883004, 1882705, 1880461, 1856561, 1852489, 1850065, 1848507, 1833538, 1832496, 1832322, 1830444, 1828421, 1806997, 1751851, 1654869, 1647177, 1638028, 1531622))
Run Time: 0.043483
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 90 | 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: 1405, 0, 1716099539, a:90:{s:14:"thread-2731631";a:2:{i:0;s:6:"thread";i:1;i:2731631;}s:14:"thread-2724217";a:2:{i:0;s:6:"thread";i:1;i:2724217;}s:14:"thread-2546737";a:2:{i:0;s:6:"thread";i:1;i:2546737;}s:14:"thread-2532273";a:2:{i:0;s:6:"thread";i:1;i:2532273;}s:14:"thread-2527373";a:2:{i:0;s:6:"thread";i:1;i:2527373;}s:14:"thread-2493090";a:2:{i:0;s:6:"thread";i:1;i:2493090;}s:14:"thread-2393504";a:2:{i:0;s:6:"thread";i:1;i:2393504;}s:14:"thread-2387035";a:2:{i:0;s:6:"thread";i:1;i:2387035;}s:14:"thread-2380989";a:2:{i:0;s:6:"thread";i:1;i:2380989;}s:14:"thread-2379478";a:2:{i:0;s:6:"thread";i:1;i:2379478;}s:14:"thread-2379433";a:2:{i:0;s:6:"thread";i:1;i:2379433;}s:14:"thread-2239971";a:2:{i:0;s:6:"thread";i:1;i:2239971;}s:14:"thread-2181698";a:2:{i:0;s:6:"thread";i:1;i:2181698;}s:14:"thread-2181632";a:2:{i:0;s:6:"thread";i:1;i:2181632;}s:14:"thread-2175062";a:2:{i:0;s:6:"thread";i:1;i:2175062;}s:14:"thread-2113677";a:2:{i:0;s:6:"thread";i:1;i:2113677;}s:14:"thread-2106206";a:2:{i:0;s:6:"thread";i:1;i:2106206;}s:14:"thread-2099183";a:2:{i:0;s:6:"thread";i:1;i:2099183;}s:14:"thread-2099181";a:2:{i:0;s:6:"thread";i:1;i:2099181;}s:14:"thread-2078411";a:2:{i:0;s:6:"thread";i:1;i:2078411;}s:14:"thread-2064129";a:2:{i:0;s:6:"thread";i:1;i:2064129;}s:14:"thread-2052315";a:2:{i:0;s:6:"thread";i:1;i:2052315;}s:14:"thread-2028984";a:2:{i:0;s:6:"thread";i:1;i:2028984;}s:14:"thread-2027781";a:2:{i:0;s:6:"thread";i:1;i:2027781;}s:14:"thread-2026866";a:2:{i:0;s:6:"thread";i:1;i:2026866;}s:14:"thread-2015974";a:2:{i:0;s:6:"thread";i:1;i:2015974;}s:14:"thread-2005436";a:2:{i:0;s:6:"thread";i:1;i:2005436;}s:14:"thread-2004039";a:2:{i:0;s:6:"thread";i:1;i:2004039;}s:14:"thread-2002800";a:2:{i:0;s:6:"thread";i:1;i:2002800;}s:14:"thread-2000684";a:2:{i:0;s:6:"thread";i:1;i:2000684;}s:14:"thread-1999604";a:2:{i:0;s:6:"thread";i:1;i:1999604;}s:14:"thread-1999596";a:2:{i:0;s:6:"thread";i:1;i:1999596;}s:14:"thread-1999418";a:2:{i:0;s:6:"thread";i:1;i:1999418;}s:14:"thread-1997939";a:2:{i:0;s:6:"thread";i:1;i:1997939;}s:14:"thread-1991365";a:2:{i:0;s:6:"thread";i:1;i:1991365;}s:14:"thread-1970983";a:2:{i:0;s:6:"thread";i:1;i:1970983;}s:14:"thread-1970680";a:2:{i:0;s:6:"thread";i:1;i:1970680;}s:14:"thread-1953773";a:2:{i:0;s:6:"thread";i:1;i:1953773;}s:14:"thread-1942713";a:2:{i:0;s:6:"thread";i:1;i:1942713;}s:14:"thread-1942707";a:2:{i:0;s:6:"thread";i:1;i:1942707;}s:14:"thread-1941988";a:2:{i:0;s:6:"thread";i:1;i:1941988;}s:14:"thread-1941965";a:2:{i:0;s:6:"thread";i:1;i:1941965;}s:14:"thread-1941796";a:2:{i:0;s:6:"thread";i:1;i:1941796;}s:14:"thread-1941775";a:2:{i:0;s:6:"thread";i:1;i:1941775;}s:14:"thread-1941771";a:2:{i:0;s:6:"thread";i:1;i:1941771;}s:14:"thread-1940990";a:2:{i:0;s:6:"thread";i:1;i:1940990;}s:14:"thread-1940801";a:2:{i:0;s:6:"thread";i:1;i:1940801;}s:14:"thread-1938430";a:2:{i:0;s:6:"thread";i:1;i:1938430;}s:14:"thread-1938418";a:2:{i:0;s:6:"thread";i:1;i:1938418;}s:14:"thread-1936348";a:2:{i:0;s:6:"thread";i:1;i:1936348;}s:14:"thread-1933859";a:2:{i:0;s:6:"thread";i:1;i:1933859;}s:14:"thread-1933513";a:2:{i:0;s:6:"thread";i:1;i:1933513;}s:14:"thread-1923435";a:2:{i:0;s:6:"thread";i:1;i:1923435;}s:14:"thread-1908484";a:2:{i:0;s:6:"thread";i:1;i:1908484;}s:14:"thread-1907292";a:2:{i:0;s:6:"thread";i:1;i:1907292;}s:14:"thread-1907290";a:2:{i:0;s:6:"thread";i:1;i:1907290;}s:14:"thread-1907114";a:2:{i:0;s:6:"thread";i:1;i:1907114;}s:14:"thread-1907113";a:2:{i:0;s:6:"thread";i:1;i:1907113;}s:14:"thread-1904626";a:2:{i:0;s:6:"thread";i:1;i:1904626;}s:14:"thread-1897976";a:2:{i:0;s:6:"thread";i:1;i:1897976;}s:14:"thread-1895807";a:2:{i:0;s:6:"thread";i:1;i:1895807;}s:14:"thread-1891387";a:2:{i:0;s:6:"thread";i:1;i:1891387;}s:14:"thread-1890292";a:2:{i:0;s:6:"thread";i:1;i:1890292;}s:14:"thread-1890284";a:2:{i:0;s:6:"thread";i:1;i:1890284;}s:14:"thread-1888277";a:2:{i:0;s:6:"thread";i:1;i:1888277;}s:14:"thread-1886293";a:2:{i:0;s:6:"thread";i:1;i:1886293;}s:14:"thread-1885976";a:2:{i:0;s:6:"thread";i:1;i:1885976;}s:14:"thread-1885524";a:2:{i:0;s:6:"thread";i:1;i:1885524;}s:14:"thread-1884456";a:2:{i:0;s:6:"thread";i:1;i:1884456;}s:14:"thread-1884283";a:2:{i:0;s:6:"thread";i:1;i:1884283;}s:14:"thread-1884268";a:2:{i:0;s:6:"thread";i:1;i:1884268;}s:14:"thread-1883009";a:2:{i:0;s:6:"thread";i:1;i:1883009;}s:14:"thread-1883004";a:2:{i:0;s:6:"thread";i:1;i:1883004;}s:14:"thread-1882705";a:2:{i:0;s:6:"thread";i:1;i:1882705;}s:14:"thread-1880461";a:2:{i:0;s:6:"thread";i:1;i:1880461;}s:14:"thread-1856561";a:2:{i:0;s:6:"thread";i:1;i:1856561;}s:14:"thread-1852489";a:2:{i:0;s:6:"thread";i:1;i:1852489;}s:14:"thread-1850065";a:2:{i:0;s:6:"thread";i:1;i:1850065;}s:14:"thread-1848507";a:2:{i:0;s:6:"thread";i:1;i:1848507;}s:14:"thread-1833538";a:2:{i:0;s:6:"thread";i:1;i:1833538;}s:14:"thread-1832496";a:2:{i:0;s:6:"thread";i:1;i:1832496;}s:14:"thread-1832322";a:2:{i:0;s:6:"thread";i:1;i:1832322;}s:14:"thread-1830444";a:2:{i:0;s:6:"thread";i:1;i:1830444;}s:14:"thread-1828421";a:2:{i:0;s:6:"thread";i:1;i:1828421;}s:14:"thread-1806997";a:2:{i:0;s:6:"thread";i:1;i:1806997;}s:14:"thread-1751851";a:2:{i:0;s:6:"thread";i:1;i:1751851;}s:14:"thread-1654869";a:2:{i:0;s:6:"thread";i:1;i:1654869;}s:14:"thread-1647177";a:2:{i:0;s:6:"thread";i:1;i:1647177;}s:14:"thread-1638028";a:2:{i:0;s:6:"thread";i:1;i:1638028;}s:14:"thread-1531622";a:2:{i:0;s:6:"thread";i:1;i:1531622;}}, , 1716095939
Run Time: 0.001660
- 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=couple&page=5, 1716095939,
Run Time: 0.000074
- 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