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 (183556, 183300, 183271, 183256, 182922, 182207, 182157, 181780, 180442, 180149, 179933, 179890, 179823, 179230, 179203, 179154, 178641, 177633, 177267, 176448, 176099, 174185, 173518, 172514, 171870, 171749, 171465, 169869, 169302, 169185, 167467, 167457, 167376, 167049, 166914, 166090, 166009, 165758, 165707, 165408, 164855, 164363, 162203, 161173, 160972, 160203, 159793, 159570, 159553, 158425, 158128, 158043, 157707, 157451, 157028, 156552, 156165, 155303, 155150, 154376, 154272, 154192, 154061, 153928, 153898, 153341, 153225, 152059, 55888, 25911))
Run Time: 0.062453
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 70 | 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: 3394, 0, 1716178391, {"thread-183556":["thread",183556],"thread-183300":["thread",183300],"thread-183271":["thread",183271],"thread-183256":["thread",183256],"thread-182922":["thread",182922],"thread-182207":["thread",182207],"thread-182157":["thread",182157],"thread-181780":["thread",181780],"thread-180442":["thread",180442],"thread-180149":["thread",180149],"thread-179933":["thread",179933],"thread-179890":["thread",179890],"thread-179823":["thread",179823],"thread-179230":["thread",179230],"thread-179203":["thread",179203],"thread-179154":["thread",179154],"thread-178641":["thread",178641],"thread-177633":["thread",177633],"thread-177267":["thread",177267],"thread-176448":["thread",176448],"thread-176099":["thread",176099],"thread-174185":["thread",174185],"thread-173518":["thread",173518],"thread-172514":["thread",172514],"thread-171870":["thread",171870],"thread-171749":["thread",171749],"thread-171465":["thread",171465],"thread-169869":["thread",169869],"thread-169302":["thread",169302],"thread-169185":["thread",169185],"thread-167467":["thread",167467],"thread-167457":["thread",167457],"thread-167376":["thread",167376],"thread-167049":["thread",167049],"thread-166914":["thread",166914],"thread-166090":["thread",166090],"thread-166009":["thread",166009],"thread-165758":["thread",165758],"thread-165707":["thread",165707],"thread-165408":["thread",165408],"thread-164855":["thread",164855],"thread-164363":["thread",164363],"thread-162203":["thread",162203],"thread-161173":["thread",161173],"thread-160972":["thread",160972],"thread-160203":["thread",160203],"thread-159793":["thread",159793],"thread-159570":["thread",159570],"thread-159553":["thread",159553],"thread-158425":["thread",158425],"thread-158128":["thread",158128],"thread-158043":["thread",158043],"thread-157707":["thread",157707],"thread-157451":["thread",157451],"thread-157028":["thread",157028],"thread-156552":["thread",156552],"thread-156165":["thread",156165],"thread-155303":["thread",155303],"thread-155150":["thread",155150],"thread-154376":["thread",154376],"thread-154272":["thread",154272],"thread-154192":["thread",154192],"thread-154061":["thread",154061],"thread-153928":["thread",153928],"thread-153898":["thread",153898],"thread-153341":["thread",153341],"thread-153225":["thread",153225],"thread-152059":["thread",152059],"thread-55888":["thread",55888],"thread-25911":["thread",25911]}, , 1716174791
Run Time: 0.005195
- 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