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 (2800693, 2714915, 2387006, 2327633, 2113510, 2027595, 2026840, 2026804, 1995104, 1994911, 1992738, 1992687, 1991058, 1988492, 1988459, 1987722, 1987711, 1987648, 1987634, 1987612, 1986414, 1986400, 1986391, 1976376, 1964653, 1950237, 1944167, 1936276, 1936219, 1935247, 1934753, 1922737, 1922491, 1919330, 1917163, 1913048, 1908973, 1908644, 1907509, 1904473, 1897662, 1895713, 1884829, 1883250, 1881017, 1855661, 1850050, 1849974, 1849572, 1847778, 1847181, 1846695, 1846689, 1839259, 1764853, 1702677, 1699234, 1690236, 1679129, 1678889, 1678888, 1678876, 1678746, 1675761, 1673325, 1671543, 1670821, 1664240, 1661123, 1659139, 1650300, 1645490, 1644850, 1639898, 1635212, 1628670, 1628018, 1617994, 1607826, 1576851, 1574858, 1564861, 1553091, 1547891, 1543781, 1542942, 1538562, 1506954, 1502244, 1481286))
Run Time: 0.055315
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: 1653, 0, 1713949111, a:90:{s:14:"thread-2800693";a:2:{i:0;s:6:"thread";i:1;i:2800693;}s:14:"thread-2714915";a:2:{i:0;s:6:"thread";i:1;i:2714915;}s:14:"thread-2387006";a:2:{i:0;s:6:"thread";i:1;i:2387006;}s:14:"thread-2327633";a:2:{i:0;s:6:"thread";i:1;i:2327633;}s:14:"thread-2113510";a:2:{i:0;s:6:"thread";i:1;i:2113510;}s:14:"thread-2027595";a:2:{i:0;s:6:"thread";i:1;i:2027595;}s:14:"thread-2026840";a:2:{i:0;s:6:"thread";i:1;i:2026840;}s:14:"thread-2026804";a:2:{i:0;s:6:"thread";i:1;i:2026804;}s:14:"thread-1995104";a:2:{i:0;s:6:"thread";i:1;i:1995104;}s:14:"thread-1994911";a:2:{i:0;s:6:"thread";i:1;i:1994911;}s:14:"thread-1992738";a:2:{i:0;s:6:"thread";i:1;i:1992738;}s:14:"thread-1992687";a:2:{i:0;s:6:"thread";i:1;i:1992687;}s:14:"thread-1991058";a:2:{i:0;s:6:"thread";i:1;i:1991058;}s:14:"thread-1988492";a:2:{i:0;s:6:"thread";i:1;i:1988492;}s:14:"thread-1988459";a:2:{i:0;s:6:"thread";i:1;i:1988459;}s:14:"thread-1987722";a:2:{i:0;s:6:"thread";i:1;i:1987722;}s:14:"thread-1987711";a:2:{i:0;s:6:"thread";i:1;i:1987711;}s:14:"thread-1987648";a:2:{i:0;s:6:"thread";i:1;i:1987648;}s:14:"thread-1987634";a:2:{i:0;s:6:"thread";i:1;i:1987634;}s:14:"thread-1987612";a:2:{i:0;s:6:"thread";i:1;i:1987612;}s:14:"thread-1986414";a:2:{i:0;s:6:"thread";i:1;i:1986414;}s:14:"thread-1986400";a:2:{i:0;s:6:"thread";i:1;i:1986400;}s:14:"thread-1986391";a:2:{i:0;s:6:"thread";i:1;i:1986391;}s:14:"thread-1976376";a:2:{i:0;s:6:"thread";i:1;i:1976376;}s:14:"thread-1964653";a:2:{i:0;s:6:"thread";i:1;i:1964653;}s:14:"thread-1950237";a:2:{i:0;s:6:"thread";i:1;i:1950237;}s:14:"thread-1944167";a:2:{i:0;s:6:"thread";i:1;i:1944167;}s:14:"thread-1936276";a:2:{i:0;s:6:"thread";i:1;i:1936276;}s:14:"thread-1936219";a:2:{i:0;s:6:"thread";i:1;i:1936219;}s:14:"thread-1935247";a:2:{i:0;s:6:"thread";i:1;i:1935247;}s:14:"thread-1934753";a:2:{i:0;s:6:"thread";i:1;i:1934753;}s:14:"thread-1922737";a:2:{i:0;s:6:"thread";i:1;i:1922737;}s:14:"thread-1922491";a:2:{i:0;s:6:"thread";i:1;i:1922491;}s:14:"thread-1919330";a:2:{i:0;s:6:"thread";i:1;i:1919330;}s:14:"thread-1917163";a:2:{i:0;s:6:"thread";i:1;i:1917163;}s:14:"thread-1913048";a:2:{i:0;s:6:"thread";i:1;i:1913048;}s:14:"thread-1908973";a:2:{i:0;s:6:"thread";i:1;i:1908973;}s:14:"thread-1908644";a:2:{i:0;s:6:"thread";i:1;i:1908644;}s:14:"thread-1907509";a:2:{i:0;s:6:"thread";i:1;i:1907509;}s:14:"thread-1904473";a:2:{i:0;s:6:"thread";i:1;i:1904473;}s:14:"thread-1897662";a:2:{i:0;s:6:"thread";i:1;i:1897662;}s:14:"thread-1895713";a:2:{i:0;s:6:"thread";i:1;i:1895713;}s:14:"thread-1884829";a:2:{i:0;s:6:"thread";i:1;i:1884829;}s:14:"thread-1883250";a:2:{i:0;s:6:"thread";i:1;i:1883250;}s:14:"thread-1881017";a:2:{i:0;s:6:"thread";i:1;i:1881017;}s:14:"thread-1855661";a:2:{i:0;s:6:"thread";i:1;i:1855661;}s:14:"thread-1850050";a:2:{i:0;s:6:"thread";i:1;i:1850050;}s:14:"thread-1849974";a:2:{i:0;s:6:"thread";i:1;i:1849974;}s:14:"thread-1849572";a:2:{i:0;s:6:"thread";i:1;i:1849572;}s:14:"thread-1847778";a:2:{i:0;s:6:"thread";i:1;i:1847778;}s:14:"thread-1847181";a:2:{i:0;s:6:"thread";i:1;i:1847181;}s:14:"thread-1846695";a:2:{i:0;s:6:"thread";i:1;i:1846695;}s:14:"thread-1846689";a:2:{i:0;s:6:"thread";i:1;i:1846689;}s:14:"thread-1839259";a:2:{i:0;s:6:"thread";i:1;i:1839259;}s:14:"thread-1764853";a:2:{i:0;s:6:"thread";i:1;i:1764853;}s:14:"thread-1702677";a:2:{i:0;s:6:"thread";i:1;i:1702677;}s:14:"thread-1699234";a:2:{i:0;s:6:"thread";i:1;i:1699234;}s:14:"thread-1690236";a:2:{i:0;s:6:"thread";i:1;i:1690236;}s:14:"thread-1679129";a:2:{i:0;s:6:"thread";i:1;i:1679129;}s:14:"thread-1678889";a:2:{i:0;s:6:"thread";i:1;i:1678889;}s:14:"thread-1678888";a:2:{i:0;s:6:"thread";i:1;i:1678888;}s:14:"thread-1678876";a:2:{i:0;s:6:"thread";i:1;i:1678876;}s:14:"thread-1678746";a:2:{i:0;s:6:"thread";i:1;i:1678746;}s:14:"thread-1675761";a:2:{i:0;s:6:"thread";i:1;i:1675761;}s:14:"thread-1673325";a:2:{i:0;s:6:"thread";i:1;i:1673325;}s:14:"thread-1671543";a:2:{i:0;s:6:"thread";i:1;i:1671543;}s:14:"thread-1670821";a:2:{i:0;s:6:"thread";i:1;i:1670821;}s:14:"thread-1664240";a:2:{i:0;s:6:"thread";i:1;i:1664240;}s:14:"thread-1661123";a:2:{i:0;s:6:"thread";i:1;i:1661123;}s:14:"thread-1659139";a:2:{i:0;s:6:"thread";i:1;i:1659139;}s:14:"thread-1650300";a:2:{i:0;s:6:"thread";i:1;i:1650300;}s:14:"thread-1645490";a:2:{i:0;s:6:"thread";i:1;i:1645490;}s:14:"thread-1644850";a:2:{i:0;s:6:"thread";i:1;i:1644850;}s:14:"thread-1639898";a:2:{i:0;s:6:"thread";i:1;i:1639898;}s:14:"thread-1635212";a:2:{i:0;s:6:"thread";i:1;i:1635212;}s:14:"thread-1628670";a:2:{i:0;s:6:"thread";i:1;i:1628670;}s:14:"thread-1628018";a:2:{i:0;s:6:"thread";i:1;i:1628018;}s:14:"thread-1617994";a:2:{i:0;s:6:"thread";i:1;i:1617994;}s:14:"thread-1607826";a:2:{i:0;s:6:"thread";i:1;i:1607826;}s:14:"thread-1576851";a:2:{i:0;s:6:"thread";i:1;i:1576851;}s:14:"thread-1574858";a:2:{i:0;s:6:"thread";i:1;i:1574858;}s:14:"thread-1564861";a:2:{i:0;s:6:"thread";i:1;i:1564861;}s:14:"thread-1553091";a:2:{i:0;s:6:"thread";i:1;i:1553091;}s:14:"thread-1547891";a:2:{i:0;s:6:"thread";i:1;i:1547891;}s:14:"thread-1543781";a:2:{i:0;s:6:"thread";i:1;i:1543781;}s:14:"thread-1542942";a:2:{i:0;s:6:"thread";i:1;i:1542942;}s:14:"thread-1538562";a:2:{i:0;s:6:"thread";i:1;i:1538562;}s:14:"thread-1506954";a:2:{i:0;s:6:"thread";i:1;i:1506954;}s:14:"thread-1502244";a:2:{i:0;s:6:"thread";i:1;i:1502244;}s:14:"thread-1481286";a:2:{i:0;s:6:"thread";i:1;i:1481286;}}, , 1713945511
Run Time: 0.001169
- 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=czech, 1713945511,
Run Time: 0.000245
- 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