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 (2021693, 2000318, 2000314, 2000037, 1995000, 1985284, 1985171, 1985168, 1985102, 1985015, 1984970, 1973424, 1973397, 1973341, 1973318, 1973316, 1973302, 1973275, 1973255, 1973233, 1968828, 1968825, 1918174, 1894249, 1850668, 1834951, 1724592, 1724590, 1704402, 1695289, 1695288, 1695172, 1633424, 1618041, 1600986, 1600707, 1577279, 1562653, 1552602, 1550875, 1548601, 1548600, 1548096, 1542987, 1542153, 1542152, 1542148, 1541339, 1530890, 1518394, 1514091, 1501177, 1498672, 1498228, 1498225, 1496822, 1496820, 1488660, 1488658, 1485673, 1485671, 1485669, 1478942, 1476796, 1472393, 1470971, 1468107, 1467453, 1461801, 1461372, 1460683, 1458678, 1458136, 1458135, 1456689, 1455610, 1452987, 1448590, 1448589, 1443697))
Run Time: 0.132917
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 80 | 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: 3616, 0, 1714976242, a:80:{s:14:"thread-2021693";a:2:{i:0;s:6:"thread";i:1;i:2021693;}s:14:"thread-2000318";a:2:{i:0;s:6:"thread";i:1;i:2000318;}s:14:"thread-2000314";a:2:{i:0;s:6:"thread";i:1;i:2000314;}s:14:"thread-2000037";a:2:{i:0;s:6:"thread";i:1;i:2000037;}s:14:"thread-1995000";a:2:{i:0;s:6:"thread";i:1;i:1995000;}s:14:"thread-1985284";a:2:{i:0;s:6:"thread";i:1;i:1985284;}s:14:"thread-1985171";a:2:{i:0;s:6:"thread";i:1;i:1985171;}s:14:"thread-1985168";a:2:{i:0;s:6:"thread";i:1;i:1985168;}s:14:"thread-1985102";a:2:{i:0;s:6:"thread";i:1;i:1985102;}s:14:"thread-1985015";a:2:{i:0;s:6:"thread";i:1;i:1985015;}s:14:"thread-1984970";a:2:{i:0;s:6:"thread";i:1;i:1984970;}s:14:"thread-1973424";a:2:{i:0;s:6:"thread";i:1;i:1973424;}s:14:"thread-1973397";a:2:{i:0;s:6:"thread";i:1;i:1973397;}s:14:"thread-1973341";a:2:{i:0;s:6:"thread";i:1;i:1973341;}s:14:"thread-1973318";a:2:{i:0;s:6:"thread";i:1;i:1973318;}s:14:"thread-1973316";a:2:{i:0;s:6:"thread";i:1;i:1973316;}s:14:"thread-1973302";a:2:{i:0;s:6:"thread";i:1;i:1973302;}s:14:"thread-1973275";a:2:{i:0;s:6:"thread";i:1;i:1973275;}s:14:"thread-1973255";a:2:{i:0;s:6:"thread";i:1;i:1973255;}s:14:"thread-1973233";a:2:{i:0;s:6:"thread";i:1;i:1973233;}s:14:"thread-1968828";a:2:{i:0;s:6:"thread";i:1;i:1968828;}s:14:"thread-1968825";a:2:{i:0;s:6:"thread";i:1;i:1968825;}s:14:"thread-1918174";a:2:{i:0;s:6:"thread";i:1;i:1918174;}s:14:"thread-1894249";a:2:{i:0;s:6:"thread";i:1;i:1894249;}s:14:"thread-1850668";a:2:{i:0;s:6:"thread";i:1;i:1850668;}s:14:"thread-1834951";a:2:{i:0;s:6:"thread";i:1;i:1834951;}s:14:"thread-1724592";a:2:{i:0;s:6:"thread";i:1;i:1724592;}s:14:"thread-1724590";a:2:{i:0;s:6:"thread";i:1;i:1724590;}s:14:"thread-1704402";a:2:{i:0;s:6:"thread";i:1;i:1704402;}s:14:"thread-1695289";a:2:{i:0;s:6:"thread";i:1;i:1695289;}s:14:"thread-1695288";a:2:{i:0;s:6:"thread";i:1;i:1695288;}s:14:"thread-1695172";a:2:{i:0;s:6:"thread";i:1;i:1695172;}s:14:"thread-1633424";a:2:{i:0;s:6:"thread";i:1;i:1633424;}s:14:"thread-1618041";a:2:{i:0;s:6:"thread";i:1;i:1618041;}s:14:"thread-1600986";a:2:{i:0;s:6:"thread";i:1;i:1600986;}s:14:"thread-1600707";a:2:{i:0;s:6:"thread";i:1;i:1600707;}s:14:"thread-1577279";a:2:{i:0;s:6:"thread";i:1;i:1577279;}s:14:"thread-1562653";a:2:{i:0;s:6:"thread";i:1;i:1562653;}s:14:"thread-1552602";a:2:{i:0;s:6:"thread";i:1;i:1552602;}s:14:"thread-1550875";a:2:{i:0;s:6:"thread";i:1;i:1550875;}s:14:"thread-1548601";a:2:{i:0;s:6:"thread";i:1;i:1548601;}s:14:"thread-1548600";a:2:{i:0;s:6:"thread";i:1;i:1548600;}s:14:"thread-1548096";a:2:{i:0;s:6:"thread";i:1;i:1548096;}s:14:"thread-1542987";a:2:{i:0;s:6:"thread";i:1;i:1542987;}s:14:"thread-1542153";a:2:{i:0;s:6:"thread";i:1;i:1542153;}s:14:"thread-1542152";a:2:{i:0;s:6:"thread";i:1;i:1542152;}s:14:"thread-1542148";a:2:{i:0;s:6:"thread";i:1;i:1542148;}s:14:"thread-1541339";a:2:{i:0;s:6:"thread";i:1;i:1541339;}s:14:"thread-1530890";a:2:{i:0;s:6:"thread";i:1;i:1530890;}s:14:"thread-1518394";a:2:{i:0;s:6:"thread";i:1;i:1518394;}s:14:"thread-1514091";a:2:{i:0;s:6:"thread";i:1;i:1514091;}s:14:"thread-1501177";a:2:{i:0;s:6:"thread";i:1;i:1501177;}s:14:"thread-1498672";a:2:{i:0;s:6:"thread";i:1;i:1498672;}s:14:"thread-1498228";a:2:{i:0;s:6:"thread";i:1;i:1498228;}s:14:"thread-1498225";a:2:{i:0;s:6:"thread";i:1;i:1498225;}s:14:"thread-1496822";a:2:{i:0;s:6:"thread";i:1;i:1496822;}s:14:"thread-1496820";a:2:{i:0;s:6:"thread";i:1;i:1496820;}s:14:"thread-1488660";a:2:{i:0;s:6:"thread";i:1;i:1488660;}s:14:"thread-1488658";a:2:{i:0;s:6:"thread";i:1;i:1488658;}s:14:"thread-1485673";a:2:{i:0;s:6:"thread";i:1;i:1485673;}s:14:"thread-1485671";a:2:{i:0;s:6:"thread";i:1;i:1485671;}s:14:"thread-1485669";a:2:{i:0;s:6:"thread";i:1;i:1485669;}s:14:"thread-1478942";a:2:{i:0;s:6:"thread";i:1;i:1478942;}s:14:"thread-1476796";a:2:{i:0;s:6:"thread";i:1;i:1476796;}s:14:"thread-1472393";a:2:{i:0;s:6:"thread";i:1;i:1472393;}s:14:"thread-1470971";a:2:{i:0;s:6:"thread";i:1;i:1470971;}s:14:"thread-1468107";a:2:{i:0;s:6:"thread";i:1;i:1468107;}s:14:"thread-1467453";a:2:{i:0;s:6:"thread";i:1;i:1467453;}s:14:"thread-1461801";a:2:{i:0;s:6:"thread";i:1;i:1461801;}s:14:"thread-1461372";a:2:{i:0;s:6:"thread";i:1;i:1461372;}s:14:"thread-1460683";a:2:{i:0;s:6:"thread";i:1;i:1460683;}s:14:"thread-1458678";a:2:{i:0;s:6:"thread";i:1;i:1458678;}s:14:"thread-1458136";a:2:{i:0;s:6:"thread";i:1;i:1458136;}s:14:"thread-1458135";a:2:{i:0;s:6:"thread";i:1;i:1458135;}s:14:"thread-1456689";a:2:{i:0;s:6:"thread";i:1;i:1456689;}s:14:"thread-1455610";a:2:{i:0;s:6:"thread";i:1;i:1455610;}s:14:"thread-1452987";a:2:{i:0;s:6:"thread";i:1;i:1452987;}s:14:"thread-1448590";a:2:{i:0;s:6:"thread";i:1;i:1448590;}s:14:"thread-1448589";a:2:{i:0;s:6:"thread";i:1;i:1448589;}s:14:"thread-1443697";a:2:{i:0;s:6:"thread";i:1;i:1443697;}}, , 1714972642
Run Time: 0.000762
- 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, L , L , XF\Pub\Controller\Tag, Tag, valid, tag_url=son, 1714972642,
Run Time: 0.000151
- 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