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 (182689, 179698, 177798, 175566, 174301, 173429, 173223, 169026, 167802, 166936, 164954, 164033, 163523, 163182, 159788, 159787, 159784, 156664, 155317, 154046, 151724, 131390, 131152, 131105, 129884, 129877, 129599, 129417, 129282, 128476, 127734, 126586, 125555, 124080, 123704, 123695, 123602, 123250, 121736, 119957, 105394, 103596, 103592, 102263, 100352, 92319, 91221, 91209, 90106, 88686, 88178, 86050, 85540, 84032, 82490, 81128, 78933, 77412, 77374, 75733, 75538, 74367, 70195, 70187, 69936, 61436, 54963, 54711, 51205, 51108, 47577, 45921, 45643, 39728, 38745, 38137, 36876, 36869, 36675, 36437, 29960, 27940, 22159, 21405, 19170, 5777, 3260, 2057, 919))
Run Time: 0.063768
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 89 | 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: 224, 0, 1715499848, {"thread-182689":["thread",182689],"thread-179698":["thread",179698],"thread-177798":["thread",177798],"thread-175566":["thread",175566],"thread-174301":["thread",174301],"thread-173429":["thread",173429],"thread-173223":["thread",173223],"thread-169026":["thread",169026],"thread-167802":["thread",167802],"thread-166936":["thread",166936],"thread-164954":["thread",164954],"thread-164033":["thread",164033],"thread-163523":["thread",163523],"thread-163182":["thread",163182],"thread-159788":["thread",159788],"thread-159787":["thread",159787],"thread-159784":["thread",159784],"thread-156664":["thread",156664],"thread-155317":["thread",155317],"thread-154046":["thread",154046],"thread-151724":["thread",151724],"thread-131390":["thread",131390],"thread-131152":["thread",131152],"thread-131105":["thread",131105],"thread-129884":["thread",129884],"thread-129877":["thread",129877],"thread-129599":["thread",129599],"thread-129417":["thread",129417],"thread-129282":["thread",129282],"thread-128476":["thread",128476],"thread-127734":["thread",127734],"thread-126586":["thread",126586],"thread-125555":["thread",125555],"thread-124080":["thread",124080],"thread-123704":["thread",123704],"thread-123695":["thread",123695],"thread-123602":["thread",123602],"thread-123250":["thread",123250],"thread-121736":["thread",121736],"thread-119957":["thread",119957],"thread-105394":["thread",105394],"thread-103596":["thread",103596],"thread-103592":["thread",103592],"thread-102263":["thread",102263],"thread-100352":["thread",100352],"thread-92319":["thread",92319],"thread-91221":["thread",91221],"thread-91209":["thread",91209],"thread-90106":["thread",90106],"thread-88686":["thread",88686],"thread-88178":["thread",88178],"thread-86050":["thread",86050],"thread-85540":["thread",85540],"thread-84032":["thread",84032],"thread-82490":["thread",82490],"thread-81128":["thread",81128],"thread-78933":["thread",78933],"thread-77412":["thread",77412],"thread-77374":["thread",77374],"thread-75733":["thread",75733],"thread-75538":["thread",75538],"thread-74367":["thread",74367],"thread-70195":["thread",70195],"thread-70187":["thread",70187],"thread-69936":["thread",69936],"thread-61436":["thread",61436],"thread-54963":["thread",54963],"thread-54711":["thread",54711],"thread-51205":["thread",51205],"thread-51108":["thread",51108],"thread-47577":["thread",47577],"thread-45921":["thread",45921],"thread-45643":["thread",45643],"thread-39728":["thread",39728],"thread-38745":["thread",38745],"thread-38137":["thread",38137],"thread-36876":["thread",36876],"thread-36869":["thread",36869],"thread-36675":["thread",36675],"thread-36437":["thread",36437],"thread-29960":["thread",29960],"thread-27940":["thread",27940],"thread-22159":["thread",22159],"thread-21405":["thread",21405],"thread-19170":["thread",19170],"thread-5777":["thread",5777],"thread-3260":["thread",3260],"thread-2057":["thread",2057],"thread-919":["thread",919]}, , 1715496248
Run Time: 0.002100
- 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