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 (180356, 179733, 177138, 177004, 176980, 167495, 166986, 164852, 163907, 162265, 162021, 161741, 161066, 157005, 156456, 156294, 152957, 147067, 146561, 145540, 138341, 134299, 130114, 126794, 126538, 123235, 122931, 122620, 121929, 120173, 119762, 119515, 118382, 118349, 117345, 117145, 115955, 115305, 115304, 114975, 114059, 112867, 109175, 108405, 108390, 108002, 107592, 107538, 106849, 105854, 105733, 105508, 105273, 104441, 102021, 101115, 101108, 101086, 100930, 99256, 99241, 95855, 95274, 94650, 93404, 93222, 92491, 88296, 87909, 85686, 83405, 82933, 82911, 82181, 80811, 79422, 79188, 76539, 76407, 76108, 75350, 75139, 71434, 69796, 69791, 69790, 69098, 68493, 68490, 67400, 67098, 65054, 64489, 61975, 60904, 59880, 58666, 54284, 54255, 54026, 53481, 49469, 47707, 47575, 47128, 43027, 40579, 40066, 38324, 31356, 30117, 26509, 26026, 23977, 23670, 22560))
Run Time: 0.060551
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 116 | 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: 3071, 0, 1716119596, {"thread-180356":["thread",180356],"thread-179733":["thread",179733],"thread-177138":["thread",177138],"thread-177004":["thread",177004],"thread-176980":["thread",176980],"thread-167495":["thread",167495],"thread-166986":["thread",166986],"thread-164852":["thread",164852],"thread-163907":["thread",163907],"thread-162265":["thread",162265],"thread-162021":["thread",162021],"thread-161741":["thread",161741],"thread-161066":["thread",161066],"thread-157005":["thread",157005],"thread-156456":["thread",156456],"thread-156294":["thread",156294],"thread-152957":["thread",152957],"thread-147067":["thread",147067],"thread-146561":["thread",146561],"thread-145540":["thread",145540],"thread-138341":["thread",138341],"thread-134299":["thread",134299],"thread-130114":["thread",130114],"thread-126794":["thread",126794],"thread-126538":["thread",126538],"thread-123235":["thread",123235],"thread-122931":["thread",122931],"thread-122620":["thread",122620],"thread-121929":["thread",121929],"thread-120173":["thread",120173],"thread-119762":["thread",119762],"thread-119515":["thread",119515],"thread-118382":["thread",118382],"thread-118349":["thread",118349],"thread-117345":["thread",117345],"thread-117145":["thread",117145],"thread-115955":["thread",115955],"thread-115305":["thread",115305],"thread-115304":["thread",115304],"thread-114975":["thread",114975],"thread-114059":["thread",114059],"thread-112867":["thread",112867],"thread-109175":["thread",109175],"thread-108405":["thread",108405],"thread-108390":["thread",108390],"thread-108002":["thread",108002],"thread-107592":["thread",107592],"thread-107538":["thread",107538],"thread-106849":["thread",106849],"thread-105854":["thread",105854],"thread-105733":["thread",105733],"thread-105508":["thread",105508],"thread-105273":["thread",105273],"thread-104441":["thread",104441],"thread-102021":["thread",102021],"thread-101115":["thread",101115],"thread-101108":["thread",101108],"thread-101086":["thread",101086],"thread-100930":["thread",100930],"thread-99256":["thread",99256],"thread-99241":["thread",99241],"thread-95855":["thread",95855],"thread-95274":["thread",95274],"thread-94650":["thread",94650],"thread-93404":["thread",93404],"thread-93222":["thread",93222],"thread-92491":["thread",92491],"thread-88296":["thread",88296],"thread-87909":["thread",87909],"thread-85686":["thread",85686],"thread-83405":["thread",83405],"thread-82933":["thread",82933],"thread-82911":["thread",82911],"thread-82181":["thread",82181],"thread-80811":["thread",80811],"thread-79422":["thread",79422],"thread-79188":["thread",79188],"thread-76539":["thread",76539],"thread-76407":["thread",76407],"thread-76108":["thread",76108],"thread-75350":["thread",75350],"thread-75139":["thread",75139],"thread-71434":["thread",71434],"thread-69796":["thread",69796],"thread-69791":["thread",69791],"thread-69790":["thread",69790],"thread-69098":["thread",69098],"thread-68493":["thread",68493],"thread-68490":["thread",68490],"thread-67400":["thread",67400],"thread-67098":["thread",67098],"thread-65054":["thread",65054],"thread-64489":["thread",64489],"thread-61975":["thread",61975],"thread-60904":["thread",60904],"thread-59880":["thread",59880],"thread-58666":["thread",58666],"thread-54284":["thread",54284],"thread-54255":["thread",54255],"thread-54026":["thread",54026],"thread-53481":["thread",53481],"thread-49469":["thread",49469],"thread-47707":["thread",47707],"thread-47575":["thread",47575],"thread-47128":["thread",47128],"thread-43027":["thread",43027],"thread-40579":["thread",40579],"thread-40066":["thread",40066],"thread-38324":["thread",38324],"thread-31356":["thread",31356],"thread-30117":["thread",30117],"thread-26509":["thread",26509],"thread-26026":["thread",26026],"thread-23977":["thread",23977],"thread-23670":["thread",23670],"thread-22560":["thread",22560]}, , 1716115996
Run Time: 0.000441
- 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