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 (1562436, 1562430, 1562311, 1562305, 1561992, 1561562, 1561558, 1561364, 1561213, 1561207, 1561046, 1558613, 1558431, 1558184, 1558182, 1558052, 1551548, 1551546, 1551181, 1551168, 1550837, 1550828, 1550597, 1550015, 1549518, 1547766, 1546903, 1546516, 1545973, 1545390, 1545347, 1544944, 1544930, 1544677, 1543737, 1543729, 1543426, 1543417, 1543160, 1542856, 1542451, 1542156, 1541181, 1540585, 1540577, 1539149, 1538926, 1538639, 1538613, 1538250, 1538249, 1538234, 1537946, 1537941, 1537238, 1536810, 1536802, 1536449, 1536440, 1536175, 1536165, 1535711, 1535709, 1535435, 1535421, 1535067, 1534806, 1534798, 1534463, 1534458, 1534159, 1534150, 1533636, 1533629, 1533354, 1533338, 1533002, 1532638, 1532603, 1532291, 1532236, 1531837, 1531831, 1531153, 1530883, 1530562, 1530354, 1529658, 1529082, 1527177, 1526955, 1526714, 1526444, 1526160, 1525639, 1525215, 1524863, 1524604, 1524345, 1523681, 1523427, 1523096, 1338774))
Run Time: 0.104709
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 103 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | f6kf_hdvietn116n.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | f6kf_hdvietn116n.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | f6kf_hdvietn116n.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | f6kf_hdvietn116n.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,f6kf_hdvietn116n.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1387
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2719
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 731
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 137
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20
INSERT INTO `xf_tag_result_cache` (`tag_id`, `user_id`, `expiry_date`, `results`, `result_cache_id`, `cache_date`) VALUES (?, ?, ?, ?, ?, ?)
Params: 17479, 0, 1715869057, {"thread-1562436":["thread",1562436],"thread-1562430":["thread",1562430],"thread-1562311":["thread",1562311],"thread-1562305":["thread",1562305],"thread-1561992":["thread",1561992],"thread-1561562":["thread",1561562],"thread-1561558":["thread",1561558],"thread-1561364":["thread",1561364],"thread-1561213":["thread",1561213],"thread-1561207":["thread",1561207],"thread-1561046":["thread",1561046],"thread-1558613":["thread",1558613],"thread-1558431":["thread",1558431],"thread-1558184":["thread",1558184],"thread-1558182":["thread",1558182],"thread-1558052":["thread",1558052],"thread-1551548":["thread",1551548],"thread-1551546":["thread",1551546],"thread-1551181":["thread",1551181],"thread-1551168":["thread",1551168],"thread-1550837":["thread",1550837],"thread-1550828":["thread",1550828],"thread-1550597":["thread",1550597],"thread-1550015":["thread",1550015],"thread-1549518":["thread",1549518],"thread-1547766":["thread",1547766],"thread-1546903":["thread",1546903],"thread-1546516":["thread",1546516],"thread-1545973":["thread",1545973],"thread-1545390":["thread",1545390],"thread-1545347":["thread",1545347],"thread-1544944":["thread",1544944],"thread-1544930":["thread",1544930],"thread-1544677":["thread",1544677],"thread-1543737":["thread",1543737],"thread-1543729":["thread",1543729],"thread-1543426":["thread",1543426],"thread-1543417":["thread",1543417],"thread-1543160":["thread",1543160],"thread-1542856":["thread",1542856],"thread-1542451":["thread",1542451],"thread-1542156":["thread",1542156],"thread-1541181":["thread",1541181],"thread-1540585":["thread",1540585],"thread-1540577":["thread",1540577],"thread-1539149":["thread",1539149],"thread-1538926":["thread",1538926],"thread-1538639":["thread",1538639],"thread-1538613":["thread",1538613],"thread-1538250":["thread",1538250],"thread-1538249":["thread",1538249],"thread-1538234":["thread",1538234],"thread-1537946":["thread",1537946],"thread-1537941":["thread",1537941],"thread-1537238":["thread",1537238],"thread-1536810":["thread",1536810],"thread-1536802":["thread",1536802],"thread-1536449":["thread",1536449],"thread-1536440":["thread",1536440],"thread-1536175":["thread",1536175],"thread-1536165":["thread",1536165],"thread-1535711":["thread",1535711],"thread-1535709":["thread",1535709],"thread-1535435":["thread",1535435],"thread-1535421":["thread",1535421],"thread-1535067":["thread",1535067],"thread-1534806":["thread",1534806],"thread-1534798":["thread",1534798],"thread-1534463":["thread",1534463],"thread-1534458":["thread",1534458],"thread-1534159":["thread",1534159],"thread-1534150":["thread",1534150],"thread-1533636":["thread",1533636],"thread-1533629":["thread",1533629],"thread-1533354":["thread",1533354],"thread-1533338":["thread",1533338],"thread-1533002":["thread",1533002],"thread-1532638":["thread",1532638],"thread-1532603":["thread",1532603],"thread-1532291":["thread",1532291],"thread-1532236":["thread",1532236],"thread-1531837":["thread",1531837],"thread-1531831":["thread",1531831],"thread-1531153":["thread",1531153],"thread-1530883":["thread",1530883],"thread-1530562":["thread",1530562],"thread-1530354":["thread",1530354],"thread-1529658":["thread",1529658],"thread-1529082":["thread",1529082],"thread-1527177":["thread",1527177],"thread-1526955":["thread",1526955],"thread-1526714":["thread",1526714],"thread-1526444":["thread",1526444],"thread-1526160":["thread",1526160],"thread-1525639":["thread",1525639],"thread-1525215":["thread",1525215],"thread-1524863":["thread",1524863],"thread-1524604":["thread",1524604],"thread-1524345":["thread",1524345],"thread-1523681":["thread",1523681],"thread-1523427":["thread",1523427],"thread-1523096":["thread",1523096]}, , 1715865457
Run Time: 0.002660
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 220
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1512
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1244
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 150
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20