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 (182823, 165706, 119191, 108738, 99571, 99195, 98250, 98181, 97762, 97609, 97607, 97602, 97601, 97599, 97597, 97596, 97595, 97594, 97593, 97558, 97525, 97441, 97440, 97376, 97236, 97233, 97183, 97181, 97180, 97179, 97178, 97135, 96946, 96913, 96864, 96848, 96772, 96718, 96677, 96617, 96612, 96562, 96526, 96523, 96522, 96485, 96468, 96457, 96424, 96401, 96379, 96356, 96353, 96312, 96296, 96274, 96273, 96160, 96145, 96035, 80820, 80819, 80806, 80703, 80701, 80561, 80498, 80224, 80217, 80213, 80204, 80155, 80141, 80138, 80074, 79944, 79698, 79651, 79647, 79477, 79423, 79219, 79216, 79110, 79106, 79095, 79089, 79058, 79056, 79028, 79027, 79026, 79025, 79024, 79023, 79022, 79021, 78996, 78988, 78851, 78634, 78577, 78544, 78403, 78235, 78233, 78232, 78230, 78226, 78225, 77942, 77503, 28363, 27868, 3905))
Run Time: 0.051798
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 115 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.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 2729
- 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 2351
- XF\App->run() in src/XF.php at line 517
- 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: 1090, 0, 1717042355, {"thread-182823":["thread",182823],"thread-165706":["thread",165706],"thread-119191":["thread",119191],"thread-108738":["thread",108738],"thread-99571":["thread",99571],"thread-99195":["thread",99195],"thread-98250":["thread",98250],"thread-98181":["thread",98181],"thread-97762":["thread",97762],"thread-97609":["thread",97609],"thread-97607":["thread",97607],"thread-97602":["thread",97602],"thread-97601":["thread",97601],"thread-97599":["thread",97599],"thread-97597":["thread",97597],"thread-97596":["thread",97596],"thread-97595":["thread",97595],"thread-97594":["thread",97594],"thread-97593":["thread",97593],"thread-97558":["thread",97558],"thread-97525":["thread",97525],"thread-97441":["thread",97441],"thread-97440":["thread",97440],"thread-97376":["thread",97376],"thread-97236":["thread",97236],"thread-97233":["thread",97233],"thread-97183":["thread",97183],"thread-97181":["thread",97181],"thread-97180":["thread",97180],"thread-97179":["thread",97179],"thread-97178":["thread",97178],"thread-97135":["thread",97135],"thread-96946":["thread",96946],"thread-96913":["thread",96913],"thread-96864":["thread",96864],"thread-96848":["thread",96848],"thread-96772":["thread",96772],"thread-96718":["thread",96718],"thread-96677":["thread",96677],"thread-96617":["thread",96617],"thread-96612":["thread",96612],"thread-96562":["thread",96562],"thread-96526":["thread",96526],"thread-96523":["thread",96523],"thread-96522":["thread",96522],"thread-96485":["thread",96485],"thread-96468":["thread",96468],"thread-96457":["thread",96457],"thread-96424":["thread",96424],"thread-96401":["thread",96401],"thread-96379":["thread",96379],"thread-96356":["thread",96356],"thread-96353":["thread",96353],"thread-96312":["thread",96312],"thread-96296":["thread",96296],"thread-96274":["thread",96274],"thread-96273":["thread",96273],"thread-96160":["thread",96160],"thread-96145":["thread",96145],"thread-96035":["thread",96035],"thread-80820":["thread",80820],"thread-80819":["thread",80819],"thread-80806":["thread",80806],"thread-80703":["thread",80703],"thread-80701":["thread",80701],"thread-80561":["thread",80561],"thread-80498":["thread",80498],"thread-80224":["thread",80224],"thread-80217":["thread",80217],"thread-80213":["thread",80213],"thread-80204":["thread",80204],"thread-80155":["thread",80155],"thread-80141":["thread",80141],"thread-80138":["thread",80138],"thread-80074":["thread",80074],"thread-79944":["thread",79944],"thread-79698":["thread",79698],"thread-79651":["thread",79651],"thread-79647":["thread",79647],"thread-79477":["thread",79477],"thread-79423":["thread",79423],"thread-79219":["thread",79219],"thread-79216":["thread",79216],"thread-79110":["thread",79110],"thread-79106":["thread",79106],"thread-79095":["thread",79095],"thread-79089":["thread",79089],"thread-79058":["thread",79058],"thread-79056":["thread",79056],"thread-79028":["thread",79028],"thread-79027":["thread",79027],"thread-79026":["thread",79026],"thread-79025":["thread",79025],"thread-79024":["thread",79024],"thread-79023":["thread",79023],"thread-79022":["thread",79022],"thread-79021":["thread",79021],"thread-78996":["thread",78996],"thread-78988":["thread",78988],"thread-78851":["thread",78851],"thread-78634":["thread",78634],"thread-78577":["thread",78577],"thread-78544":["thread",78544],"thread-78403":["thread",78403],"thread-78235":["thread",78235],"thread-78233":["thread",78233],"thread-78232":["thread",78232],"thread-78230":["thread",78230],"thread-78226":["thread",78226],"thread-78225":["thread",78225],"thread-77942":["thread",77942],"thread-77503":["thread",77503],"thread-28363":["thread",28363],"thread-27868":["thread",27868],"thread-3905":["thread",3905]}, , 1717038755
Run Time: 0.000182
- 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 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20