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 (183627, 183626, 183623, 183620, 183208, 181598, 179904, 179670, 179136, 178727, 177949, 177632, 176531, 176371, 176036, 174000, 173397, 169528, 168713, 168361, 167763, 167544, 167039, 166535, 166098, 165581, 164878, 164702, 164701, 164533, 164492, 164050, 161109, 160014, 160002, 159599, 159507, 157695, 157580, 155910, 155690, 155574, 154543, 153642, 153548, 153547, 152861, 152792, 152259, 152002, 151817, 151724, 134565, 89079, 89052, 79307, 59147, 55023, 50134, 50133, 50132, 50066, 48251, 30098, 27111, 12549, 303, 208))
Run Time: 0.020164
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 68 | 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: 59, 0, 1716129501, {"thread-183626":["thread",183626],"thread-183623":["thread",183623],"thread-183620":["thread",183620],"thread-183208":["thread",183208],"thread-181598":["thread",181598],"thread-179904":["thread",179904],"thread-179670":["thread",179670],"thread-179136":["thread",179136],"thread-178727":["thread",178727],"thread-177949":["thread",177949],"thread-176531":["thread",176531],"thread-176371":["thread",176371],"thread-176036":["thread",176036],"thread-174000":["thread",174000],"thread-173397":["thread",173397],"thread-169528":["thread",169528],"thread-168713":["thread",168713],"thread-168361":["thread",168361],"thread-167763":["thread",167763],"thread-167544":["thread",167544],"thread-167039":["thread",167039],"thread-166535":["thread",166535],"thread-166098":["thread",166098],"thread-165581":["thread",165581],"thread-164878":["thread",164878],"thread-164492":["thread",164492],"thread-164050":["thread",164050],"thread-161109":["thread",161109],"thread-160014":["thread",160014],"thread-160002":["thread",160002],"thread-157695":["thread",157695],"thread-157580":["thread",157580],"thread-155910":["thread",155910],"thread-155690":["thread",155690],"thread-155574":["thread",155574],"thread-154543":["thread",154543],"thread-153642":["thread",153642],"thread-153548":["thread",153548],"thread-153547":["thread",153547],"thread-152861":["thread",152861],"thread-152002":["thread",152002],"thread-151724":["thread",151724],"thread-134565":["thread",134565],"thread-89079":["thread",89079],"thread-89052":["thread",89052],"thread-79307":["thread",79307],"thread-59147":["thread",59147],"thread-55023":["thread",55023],"thread-50134":["thread",50134],"thread-50133":["thread",50133],"thread-50132":["thread",50132],"thread-50066":["thread",50066],"thread-48251":["thread",48251],"thread-30098":["thread",30098],"thread-27111":["thread",27111],"thread-12549":["thread",12549],"thread-303":["thread",303],"thread-208":["thread",208]}, , 1716125901
Run Time: 0.000381
- 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