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 (183136, 178372, 178366, 177216, 176400, 175535, 175534, 175533, 175321, 175190, 174357, 173506, 173174, 173104, 173006, 172439, 172203, 168739, 168730, 168665, 168272, 168173, 167418, 166432, 166383, 166375, 164140, 163551, 162943, 162398, 160824, 160572, 159910, 159040, 158710, 158708, 156316, 155192, 154442, 153196, 153015, 152502, 134743, 133904, 132561, 131307, 129397, 128279, 124271, 124268, 123755, 122463, 121460, 120786, 120784, 119961, 118665, 117025, 114443, 114065, 113562, 112219, 109421, 107549, 104985, 103033, 102415, 102220, 101931, 99689, 98577, 98500, 94878, 88427, 86579, 84781, 83287, 81703, 76725, 75424, 75410, 72809, 68869, 68802, 68086, 65151, 64109, 62910, 62177, 60475, 57463, 53561, 46781, 46670, 45237, 45236, 33503, 18815, 12745, 12541, 570, 435))
Run Time: 0.069067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 102 | 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: 1295, 0, 1714882300, {"thread-183136":["thread",183136],"thread-178372":["thread",178372],"thread-178366":["thread",178366],"thread-177216":["thread",177216],"thread-176400":["thread",176400],"thread-175535":["thread",175535],"thread-175534":["thread",175534],"thread-175533":["thread",175533],"thread-175321":["thread",175321],"thread-175190":["thread",175190],"thread-174357":["thread",174357],"thread-173506":["thread",173506],"thread-173174":["thread",173174],"thread-173104":["thread",173104],"thread-173006":["thread",173006],"thread-172439":["thread",172439],"thread-172203":["thread",172203],"thread-168739":["thread",168739],"thread-168730":["thread",168730],"thread-168665":["thread",168665],"thread-168272":["thread",168272],"thread-168173":["thread",168173],"thread-167418":["thread",167418],"thread-166432":["thread",166432],"thread-166383":["thread",166383],"thread-166375":["thread",166375],"thread-164140":["thread",164140],"thread-163551":["thread",163551],"thread-162943":["thread",162943],"thread-162398":["thread",162398],"thread-160824":["thread",160824],"thread-160572":["thread",160572],"thread-159910":["thread",159910],"thread-159040":["thread",159040],"thread-158710":["thread",158710],"thread-158708":["thread",158708],"thread-156316":["thread",156316],"thread-155192":["thread",155192],"thread-154442":["thread",154442],"thread-153196":["thread",153196],"thread-153015":["thread",153015],"thread-152502":["thread",152502],"thread-134743":["thread",134743],"thread-133904":["thread",133904],"thread-132561":["thread",132561],"thread-131307":["thread",131307],"thread-129397":["thread",129397],"thread-128279":["thread",128279],"thread-124271":["thread",124271],"thread-124268":["thread",124268],"thread-123755":["thread",123755],"thread-122463":["thread",122463],"thread-121460":["thread",121460],"thread-120786":["thread",120786],"thread-120784":["thread",120784],"thread-119961":["thread",119961],"thread-118665":["thread",118665],"thread-117025":["thread",117025],"thread-114443":["thread",114443],"thread-114065":["thread",114065],"thread-113562":["thread",113562],"thread-112219":["thread",112219],"thread-109421":["thread",109421],"thread-107549":["thread",107549],"thread-104985":["thread",104985],"thread-103033":["thread",103033],"thread-102415":["thread",102415],"thread-102220":["thread",102220],"thread-101931":["thread",101931],"thread-99689":["thread",99689],"thread-98577":["thread",98577],"thread-98500":["thread",98500],"thread-94878":["thread",94878],"thread-88427":["thread",88427],"thread-86579":["thread",86579],"thread-84781":["thread",84781],"thread-83287":["thread",83287],"thread-81703":["thread",81703],"thread-76725":["thread",76725],"thread-75424":["thread",75424],"thread-75410":["thread",75410],"thread-72809":["thread",72809],"thread-68869":["thread",68869],"thread-68802":["thread",68802],"thread-68086":["thread",68086],"thread-65151":["thread",65151],"thread-64109":["thread",64109],"thread-62910":["thread",62910],"thread-62177":["thread",62177],"thread-60475":["thread",60475],"thread-57463":["thread",57463],"thread-53561":["thread",53561],"thread-46781":["thread",46781],"thread-46670":["thread",46670],"thread-45237":["thread",45237],"thread-45236":["thread",45236],"thread-33503":["thread",33503],"thread-18815":["thread",18815],"thread-12745":["thread",12745],"thread-12541":["thread",12541],"thread-570":["thread",570],"thread-435":["thread",435]}, , 1714878700
Run Time: 0.000272
- 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