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 (2308947, 2021693, 2000318, 2000314, 2000037, 1995000, 1987996, 1987969, 1987968, 1987941, 1985284, 1985171, 1985168, 1985102, 1985015, 1984970, 1973424, 1973397, 1973341, 1973318, 1973316, 1973302, 1973275, 1973255, 1973233, 1968828, 1968825, 1936133, 1918174, 1907374, 1895609, 1850668, 1846757, 1726989, 1724592, 1724590, 1695289, 1695288, 1695172, 1672847, 1633424, 1602666, 1600986, 1577279, 1562653, 1552602, 1550875, 1548096, 1542066, 1500591, 1498683, 1498672, 1498670, 1498228, 1498225, 1481877, 1481830, 1481826, 1478942, 1476796, 1471133, 1470971, 1470928, 1470559, 1468109, 1468107, 1468105, 1468104, 1461372, 1461370, 1461367, 1461365, 1460687, 1459791, 1459751, 1456689, 1450635, 1450624, 1448590, 1448589, 1443173, 1440751, 1440588, 1440587, 1435928))
Run Time: 0.062952
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 85 | 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: 99, 0, 1714096960, a:85:{s:14:"thread-2308947";a:2:{i:0;s:6:"thread";i:1;i:2308947;}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-1987996";a:2:{i:0;s:6:"thread";i:1;i:1987996;}s:14:"thread-1987969";a:2:{i:0;s:6:"thread";i:1;i:1987969;}s:14:"thread-1987968";a:2:{i:0;s:6:"thread";i:1;i:1987968;}s:14:"thread-1987941";a:2:{i:0;s:6:"thread";i:1;i:1987941;}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-1936133";a:2:{i:0;s:6:"thread";i:1;i:1936133;}s:14:"thread-1918174";a:2:{i:0;s:6:"thread";i:1;i:1918174;}s:14:"thread-1907374";a:2:{i:0;s:6:"thread";i:1;i:1907374;}s:14:"thread-1895609";a:2:{i:0;s:6:"thread";i:1;i:1895609;}s:14:"thread-1850668";a:2:{i:0;s:6:"thread";i:1;i:1850668;}s:14:"thread-1846757";a:2:{i:0;s:6:"thread";i:1;i:1846757;}s:14:"thread-1726989";a:2:{i:0;s:6:"thread";i:1;i:1726989;}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-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-1672847";a:2:{i:0;s:6:"thread";i:1;i:1672847;}s:14:"thread-1633424";a:2:{i:0;s:6:"thread";i:1;i:1633424;}s:14:"thread-1602666";a:2:{i:0;s:6:"thread";i:1;i:1602666;}s:14:"thread-1600986";a:2:{i:0;s:6:"thread";i:1;i:1600986;}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-1548096";a:2:{i:0;s:6:"thread";i:1;i:1548096;}s:14:"thread-1542066";a:2:{i:0;s:6:"thread";i:1;i:1542066;}s:14:"thread-1500591";a:2:{i:0;s:6:"thread";i:1;i:1500591;}s:14:"thread-1498683";a:2:{i:0;s:6:"thread";i:1;i:1498683;}s:14:"thread-1498672";a:2:{i:0;s:6:"thread";i:1;i:1498672;}s:14:"thread-1498670";a:2:{i:0;s:6:"thread";i:1;i:1498670;}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-1481877";a:2:{i:0;s:6:"thread";i:1;i:1481877;}s:14:"thread-1481830";a:2:{i:0;s:6:"thread";i:1;i:1481830;}s:14:"thread-1481826";a:2:{i:0;s:6:"thread";i:1;i:1481826;}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-1471133";a:2:{i:0;s:6:"thread";i:1;i:1471133;}s:14:"thread-1470971";a:2:{i:0;s:6:"thread";i:1;i:1470971;}s:14:"thread-1470928";a:2:{i:0;s:6:"thread";i:1;i:1470928;}s:14:"thread-1470559";a:2:{i:0;s:6:"thread";i:1;i:1470559;}s:14:"thread-1468109";a:2:{i:0;s:6:"thread";i:1;i:1468109;}s:14:"thread-1468107";a:2:{i:0;s:6:"thread";i:1;i:1468107;}s:14:"thread-1468105";a:2:{i:0;s:6:"thread";i:1;i:1468105;}s:14:"thread-1468104";a:2:{i:0;s:6:"thread";i:1;i:1468104;}s:14:"thread-1461372";a:2:{i:0;s:6:"thread";i:1;i:1461372;}s:14:"thread-1461370";a:2:{i:0;s:6:"thread";i:1;i:1461370;}s:14:"thread-1461367";a:2:{i:0;s:6:"thread";i:1;i:1461367;}s:14:"thread-1461365";a:2:{i:0;s:6:"thread";i:1;i:1461365;}s:14:"thread-1460687";a:2:{i:0;s:6:"thread";i:1;i:1460687;}s:14:"thread-1459791";a:2:{i:0;s:6:"thread";i:1;i:1459791;}s:14:"thread-1459751";a:2:{i:0;s:6:"thread";i:1;i:1459751;}s:14:"thread-1456689";a:2:{i:0;s:6:"thread";i:1;i:1456689;}s:14:"thread-1450635";a:2:{i:0;s:6:"thread";i:1;i:1450635;}s:14:"thread-1450624";a:2:{i:0;s:6:"thread";i:1;i:1450624;}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-1443173";a:2:{i:0;s:6:"thread";i:1;i:1443173;}s:14:"thread-1440751";a:2:{i:0;s:6:"thread";i:1;i:1440751;}s:14:"thread-1440588";a:2:{i:0;s:6:"thread";i:1;i:1440588;}s:14:"thread-1440587";a:2:{i:0;s:6:"thread";i:1;i:1440587;}s:14:"thread-1435928";a:2:{i:0;s:6:"thread";i:1;i:1435928;}}, , 1714093360
Run Time: 0.001236
- 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=family-sex, 1714093360,
Run Time: 0.000078
- 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