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 (108683, 108551, 108047, 107876, 107302, 106946, 105903, 105660, 105081, 104891, 104790, 104746, 102999, 101997, 101702, 100981, 100032, 99942, 98766, 98511, 98470, 98012, 97926, 97538, 97495, 97403, 97296, 95911, 95300, 94955, 94796, 94665, 94553, 94328, 91460, 90879, 90729, 90645, 90050, 89337, 89333, 89240, 89182, 88868, 88331, 87758, 87711, 87092, 86509, 86183, 86125, 85844, 85707, 85688, 84923, 84298, 83425, 81906, 81457, 81153, 81077, 80549, 80310, 80249, 80064, 79962, 78855, 78213, 77117, 76586, 76358, 75964, 75808, 74303, 74051, 73868, 73638, 73323, 73009, 72081, 71219, 70820, 70591, 70313, 69198, 69195, 68590, 68449, 68434, 68378, 68353, 67882, 67542, 65488, 65430, 64943, 64101))
Run Time: 0.005596
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 97 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,terrylove_forums.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 1430
- 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 2866
- 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 2483
- XF\App->run() in src/XF.php at line 524
- 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: 39, 0, 1714201653, {"thread-108683":["thread",108683],"thread-108551":["thread",108551],"thread-108047":["thread",108047],"thread-107876":["thread",107876],"thread-107302":["thread",107302],"thread-106946":["thread",106946],"thread-105903":["thread",105903],"thread-105660":["thread",105660],"thread-105081":["thread",105081],"thread-104891":["thread",104891],"thread-104790":["thread",104790],"thread-104746":["thread",104746],"thread-102999":["thread",102999],"thread-101997":["thread",101997],"thread-101702":["thread",101702],"thread-100981":["thread",100981],"thread-100032":["thread",100032],"thread-99942":["thread",99942],"thread-98766":["thread",98766],"thread-98511":["thread",98511],"thread-98470":["thread",98470],"thread-98012":["thread",98012],"thread-97926":["thread",97926],"thread-97538":["thread",97538],"thread-97495":["thread",97495],"thread-97403":["thread",97403],"thread-97296":["thread",97296],"thread-95911":["thread",95911],"thread-95300":["thread",95300],"thread-94955":["thread",94955],"thread-94796":["thread",94796],"thread-94665":["thread",94665],"thread-94553":["thread",94553],"thread-94328":["thread",94328],"thread-91460":["thread",91460],"thread-90879":["thread",90879],"thread-90729":["thread",90729],"thread-90645":["thread",90645],"thread-90050":["thread",90050],"thread-89337":["thread",89337],"thread-89333":["thread",89333],"thread-89240":["thread",89240],"thread-89182":["thread",89182],"thread-88868":["thread",88868],"thread-88331":["thread",88331],"thread-87758":["thread",87758],"thread-87711":["thread",87711],"thread-87092":["thread",87092],"thread-86509":["thread",86509],"thread-86183":["thread",86183],"thread-86125":["thread",86125],"thread-85844":["thread",85844],"thread-85707":["thread",85707],"thread-85688":["thread",85688],"thread-84923":["thread",84923],"thread-84298":["thread",84298],"thread-83425":["thread",83425],"thread-81906":["thread",81906],"thread-81457":["thread",81457],"thread-81153":["thread",81153],"thread-81077":["thread",81077],"thread-80549":["thread",80549],"thread-80310":["thread",80310],"thread-80249":["thread",80249],"thread-80064":["thread",80064],"thread-79962":["thread",79962],"thread-78855":["thread",78855],"thread-78213":["thread",78213],"thread-77117":["thread",77117],"thread-76586":["thread",76586],"thread-76358":["thread",76358],"thread-75964":["thread",75964],"thread-75808":["thread",75808],"thread-74303":["thread",74303],"thread-74051":["thread",74051],"thread-73868":["thread",73868],"thread-73638":["thread",73638],"thread-73323":["thread",73323],"thread-73009":["thread",73009],"thread-72081":["thread",72081],"thread-71219":["thread",71219],"thread-70820":["thread",70820],"thread-70591":["thread",70591],"thread-70313":["thread",70313],"thread-69198":["thread",69198],"thread-69195":["thread",69195],"thread-68590":["thread",68590],"thread-68449":["thread",68449],"thread-68434":["thread",68434],"thread-68378":["thread",68378],"thread-68353":["thread",68353],"thread-67882":["thread",67882],"thread-67542":["thread",67542],"thread-65488":["thread",65488],"thread-65430":["thread",65430],"thread-64943":["thread",64943],"thread-64101":["thread",64101]}, NULL, 1714198053
Run Time: 0.000296
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- 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 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20