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 (1885731, 1672671, 1666678, 1661100, 1650468, 1647715, 1646760, 1643042, 1638799, 1637209, 1636811, 1636289, 1635885, 1635204, 1634656, 1631831, 1629928, 1628976, 1628701, 1627234, 1625104, 1620294, 1616786, 1607777, 1572003, 1552884, 1552621, 1549611, 1548622, 1548322, 1548105, 1548103, 1546506, 1546322, 1543212, 1542779, 1542451, 1542439, 1542122, 1541239, 1541120, 1540752, 1540153, 1539877, 1539847, 1538562, 1538020, 1537704, 1537211, 1536969, 1536644, 1536348, 1536345, 1535382, 1535115, 1535114, 1535113, 1525383, 1524728, 1524562, 1524560, 1524298, 1523994, 1523992, 1523991, 1523606, 1523560, 1523404, 1523403, 1517670, 1517669, 1514752, 1514246, 1514227, 1499065, 1489834, 1487099, 1476783, 1474062, 1473007, 1471807, 1471735, 1460190, 1459198, 1446563, 1440317, 1440316, 1439511))
Run Time: 0.035314
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 88 | 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: 1500, 0, 1714891913, a:88:{s:14:"thread-1885731";a:2:{i:0;s:6:"thread";i:1;i:1885731;}s:14:"thread-1672671";a:2:{i:0;s:6:"thread";i:1;i:1672671;}s:14:"thread-1666678";a:2:{i:0;s:6:"thread";i:1;i:1666678;}s:14:"thread-1661100";a:2:{i:0;s:6:"thread";i:1;i:1661100;}s:14:"thread-1650468";a:2:{i:0;s:6:"thread";i:1;i:1650468;}s:14:"thread-1647715";a:2:{i:0;s:6:"thread";i:1;i:1647715;}s:14:"thread-1646760";a:2:{i:0;s:6:"thread";i:1;i:1646760;}s:14:"thread-1643042";a:2:{i:0;s:6:"thread";i:1;i:1643042;}s:14:"thread-1638799";a:2:{i:0;s:6:"thread";i:1;i:1638799;}s:14:"thread-1637209";a:2:{i:0;s:6:"thread";i:1;i:1637209;}s:14:"thread-1636811";a:2:{i:0;s:6:"thread";i:1;i:1636811;}s:14:"thread-1636289";a:2:{i:0;s:6:"thread";i:1;i:1636289;}s:14:"thread-1635885";a:2:{i:0;s:6:"thread";i:1;i:1635885;}s:14:"thread-1635204";a:2:{i:0;s:6:"thread";i:1;i:1635204;}s:14:"thread-1634656";a:2:{i:0;s:6:"thread";i:1;i:1634656;}s:14:"thread-1631831";a:2:{i:0;s:6:"thread";i:1;i:1631831;}s:14:"thread-1629928";a:2:{i:0;s:6:"thread";i:1;i:1629928;}s:14:"thread-1628976";a:2:{i:0;s:6:"thread";i:1;i:1628976;}s:14:"thread-1628701";a:2:{i:0;s:6:"thread";i:1;i:1628701;}s:14:"thread-1627234";a:2:{i:0;s:6:"thread";i:1;i:1627234;}s:14:"thread-1625104";a:2:{i:0;s:6:"thread";i:1;i:1625104;}s:14:"thread-1620294";a:2:{i:0;s:6:"thread";i:1;i:1620294;}s:14:"thread-1616786";a:2:{i:0;s:6:"thread";i:1;i:1616786;}s:14:"thread-1607777";a:2:{i:0;s:6:"thread";i:1;i:1607777;}s:14:"thread-1572003";a:2:{i:0;s:6:"thread";i:1;i:1572003;}s:14:"thread-1552884";a:2:{i:0;s:6:"thread";i:1;i:1552884;}s:14:"thread-1552621";a:2:{i:0;s:6:"thread";i:1;i:1552621;}s:14:"thread-1549611";a:2:{i:0;s:6:"thread";i:1;i:1549611;}s:14:"thread-1548622";a:2:{i:0;s:6:"thread";i:1;i:1548622;}s:14:"thread-1548322";a:2:{i:0;s:6:"thread";i:1;i:1548322;}s:14:"thread-1548105";a:2:{i:0;s:6:"thread";i:1;i:1548105;}s:14:"thread-1548103";a:2:{i:0;s:6:"thread";i:1;i:1548103;}s:14:"thread-1546506";a:2:{i:0;s:6:"thread";i:1;i:1546506;}s:14:"thread-1546322";a:2:{i:0;s:6:"thread";i:1;i:1546322;}s:14:"thread-1543212";a:2:{i:0;s:6:"thread";i:1;i:1543212;}s:14:"thread-1542779";a:2:{i:0;s:6:"thread";i:1;i:1542779;}s:14:"thread-1542451";a:2:{i:0;s:6:"thread";i:1;i:1542451;}s:14:"thread-1542439";a:2:{i:0;s:6:"thread";i:1;i:1542439;}s:14:"thread-1542122";a:2:{i:0;s:6:"thread";i:1;i:1542122;}s:14:"thread-1541239";a:2:{i:0;s:6:"thread";i:1;i:1541239;}s:14:"thread-1541120";a:2:{i:0;s:6:"thread";i:1;i:1541120;}s:14:"thread-1540752";a:2:{i:0;s:6:"thread";i:1;i:1540752;}s:14:"thread-1540153";a:2:{i:0;s:6:"thread";i:1;i:1540153;}s:14:"thread-1539877";a:2:{i:0;s:6:"thread";i:1;i:1539877;}s:14:"thread-1539847";a:2:{i:0;s:6:"thread";i:1;i:1539847;}s:14:"thread-1538562";a:2:{i:0;s:6:"thread";i:1;i:1538562;}s:14:"thread-1538020";a:2:{i:0;s:6:"thread";i:1;i:1538020;}s:14:"thread-1537704";a:2:{i:0;s:6:"thread";i:1;i:1537704;}s:14:"thread-1537211";a:2:{i:0;s:6:"thread";i:1;i:1537211;}s:14:"thread-1536969";a:2:{i:0;s:6:"thread";i:1;i:1536969;}s:14:"thread-1536644";a:2:{i:0;s:6:"thread";i:1;i:1536644;}s:14:"thread-1536348";a:2:{i:0;s:6:"thread";i:1;i:1536348;}s:14:"thread-1536345";a:2:{i:0;s:6:"thread";i:1;i:1536345;}s:14:"thread-1535382";a:2:{i:0;s:6:"thread";i:1;i:1535382;}s:14:"thread-1535115";a:2:{i:0;s:6:"thread";i:1;i:1535115;}s:14:"thread-1535114";a:2:{i:0;s:6:"thread";i:1;i:1535114;}s:14:"thread-1535113";a:2:{i:0;s:6:"thread";i:1;i:1535113;}s:14:"thread-1525383";a:2:{i:0;s:6:"thread";i:1;i:1525383;}s:14:"thread-1524728";a:2:{i:0;s:6:"thread";i:1;i:1524728;}s:14:"thread-1524562";a:2:{i:0;s:6:"thread";i:1;i:1524562;}s:14:"thread-1524560";a:2:{i:0;s:6:"thread";i:1;i:1524560;}s:14:"thread-1524298";a:2:{i:0;s:6:"thread";i:1;i:1524298;}s:14:"thread-1523994";a:2:{i:0;s:6:"thread";i:1;i:1523994;}s:14:"thread-1523992";a:2:{i:0;s:6:"thread";i:1;i:1523992;}s:14:"thread-1523991";a:2:{i:0;s:6:"thread";i:1;i:1523991;}s:14:"thread-1523606";a:2:{i:0;s:6:"thread";i:1;i:1523606;}s:14:"thread-1523560";a:2:{i:0;s:6:"thread";i:1;i:1523560;}s:14:"thread-1523404";a:2:{i:0;s:6:"thread";i:1;i:1523404;}s:14:"thread-1523403";a:2:{i:0;s:6:"thread";i:1;i:1523403;}s:14:"thread-1517670";a:2:{i:0;s:6:"thread";i:1;i:1517670;}s:14:"thread-1517669";a:2:{i:0;s:6:"thread";i:1;i:1517669;}s:14:"thread-1514752";a:2:{i:0;s:6:"thread";i:1;i:1514752;}s:14:"thread-1514246";a:2:{i:0;s:6:"thread";i:1;i:1514246;}s:14:"thread-1514227";a:2:{i:0;s:6:"thread";i:1;i:1514227;}s:14:"thread-1499065";a:2:{i:0;s:6:"thread";i:1;i:1499065;}s:14:"thread-1489834";a:2:{i:0;s:6:"thread";i:1;i:1489834;}s:14:"thread-1487099";a:2:{i:0;s:6:"thread";i:1;i:1487099;}s:14:"thread-1476783";a:2:{i:0;s:6:"thread";i:1;i:1476783;}s:14:"thread-1474062";a:2:{i:0;s:6:"thread";i:1;i:1474062;}s:14:"thread-1473007";a:2:{i:0;s:6:"thread";i:1;i:1473007;}s:14:"thread-1471807";a:2:{i:0;s:6:"thread";i:1;i:1471807;}s:14:"thread-1471735";a:2:{i:0;s:6:"thread";i:1;i:1471735;}s:14:"thread-1460190";a:2:{i:0;s:6:"thread";i:1;i:1460190;}s:14:"thread-1459198";a:2:{i:0;s:6:"thread";i:1;i:1459198;}s:14:"thread-1446563";a:2:{i:0;s:6:"thread";i:1;i:1446563;}s:14:"thread-1440317";a:2:{i:0;s:6:"thread";i:1;i:1440317;}s:14:"thread-1440316";a:2:{i:0;s:6:"thread";i:1;i:1440316;}s:14:"thread-1439511";a:2:{i:0;s:6:"thread";i:1;i:1439511;}}, , 1714888313
Run Time: 0.002856
- 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=cumshot-clean-up&page=4, 1714888313,
Run Time: 0.000111
- 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