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 (156207, 156206, 155572, 155571, 155567, 155566, 155358, 153846, 153832, 153808, 153806, 153798, 153795, 153791, 153764, 153762, 153165, 153053, 153052, 152719, 152718, 152717, 152716, 124115, 123946, 123745, 123629, 123591, 123348, 122023, 120901, 118781, 118779, 118754, 118094, 118090, 117769, 117654, 115501, 114523, 114020, 111370, 110653, 109831, 109461, 109290, 101489, 99146, 94729, 93411, 93357, 90350, 87664, 87662, 87660, 87659, 87658, 87657, 87656, 87655, 87230, 87229, 87228, 87227, 87226, 87225, 87224, 86844, 86821, 86808, 86788, 86782, 86772, 86771, 86769, 86694, 86692, 86690, 86689, 86667, 86666, 86616, 86568, 86567, 86566, 86524, 86523, 86518, 86488, 86461, 86417, 86415, 86413, 86396, 86299, 86298, 86288, 86281, 86214, 86213, 86130, 85805, 85646, 85643, 83003, 82874, 82672, 80501, 80356, 80163, 80038, 80003, 79953, 78921, 78920, 78918, 78812, 78784, 77364, 76362, 76348, 76201, 75879, 75713, 75701, 75650, 71548))
Run Time: 0.072892
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 127 | 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: 13810, 0, 1716100139, {"thread-156207":["thread",156207],"thread-156206":["thread",156206],"thread-155572":["thread",155572],"thread-155571":["thread",155571],"thread-155567":["thread",155567],"thread-155566":["thread",155566],"thread-155358":["thread",155358],"thread-153846":["thread",153846],"thread-153832":["thread",153832],"thread-153808":["thread",153808],"thread-153806":["thread",153806],"thread-153798":["thread",153798],"thread-153795":["thread",153795],"thread-153791":["thread",153791],"thread-153764":["thread",153764],"thread-153762":["thread",153762],"thread-153165":["thread",153165],"thread-153053":["thread",153053],"thread-153052":["thread",153052],"thread-152719":["thread",152719],"thread-152718":["thread",152718],"thread-152717":["thread",152717],"thread-152716":["thread",152716],"thread-124115":["thread",124115],"thread-123946":["thread",123946],"thread-123745":["thread",123745],"thread-123629":["thread",123629],"thread-123591":["thread",123591],"thread-123348":["thread",123348],"thread-122023":["thread",122023],"thread-120901":["thread",120901],"thread-118781":["thread",118781],"thread-118779":["thread",118779],"thread-118754":["thread",118754],"thread-118094":["thread",118094],"thread-118090":["thread",118090],"thread-117769":["thread",117769],"thread-117654":["thread",117654],"thread-115501":["thread",115501],"thread-114523":["thread",114523],"thread-114020":["thread",114020],"thread-111370":["thread",111370],"thread-110653":["thread",110653],"thread-109831":["thread",109831],"thread-109461":["thread",109461],"thread-109290":["thread",109290],"thread-101489":["thread",101489],"thread-99146":["thread",99146],"thread-94729":["thread",94729],"thread-93411":["thread",93411],"thread-93357":["thread",93357],"thread-90350":["thread",90350],"thread-87664":["thread",87664],"thread-87662":["thread",87662],"thread-87660":["thread",87660],"thread-87659":["thread",87659],"thread-87658":["thread",87658],"thread-87657":["thread",87657],"thread-87656":["thread",87656],"thread-87655":["thread",87655],"thread-87230":["thread",87230],"thread-87229":["thread",87229],"thread-87228":["thread",87228],"thread-87227":["thread",87227],"thread-87226":["thread",87226],"thread-87225":["thread",87225],"thread-87224":["thread",87224],"thread-86844":["thread",86844],"thread-86821":["thread",86821],"thread-86808":["thread",86808],"thread-86788":["thread",86788],"thread-86782":["thread",86782],"thread-86772":["thread",86772],"thread-86771":["thread",86771],"thread-86769":["thread",86769],"thread-86694":["thread",86694],"thread-86692":["thread",86692],"thread-86690":["thread",86690],"thread-86689":["thread",86689],"thread-86667":["thread",86667],"thread-86666":["thread",86666],"thread-86616":["thread",86616],"thread-86568":["thread",86568],"thread-86567":["thread",86567],"thread-86566":["thread",86566],"thread-86524":["thread",86524],"thread-86523":["thread",86523],"thread-86518":["thread",86518],"thread-86488":["thread",86488],"thread-86461":["thread",86461],"thread-86417":["thread",86417],"thread-86415":["thread",86415],"thread-86413":["thread",86413],"thread-86396":["thread",86396],"thread-86299":["thread",86299],"thread-86298":["thread",86298],"thread-86288":["thread",86288],"thread-86281":["thread",86281],"thread-86214":["thread",86214],"thread-86213":["thread",86213],"thread-86130":["thread",86130],"thread-85805":["thread",85805],"thread-85646":["thread",85646],"thread-85643":["thread",85643],"thread-83003":["thread",83003],"thread-82874":["thread",82874],"thread-82672":["thread",82672],"thread-80501":["thread",80501],"thread-80356":["thread",80356],"thread-80163":["thread",80163],"thread-80038":["thread",80038],"thread-80003":["thread",80003],"thread-79953":["thread",79953],"thread-78921":["thread",78921],"thread-78920":["thread",78920],"thread-78918":["thread",78918],"thread-78812":["thread",78812],"thread-78784":["thread",78784],"thread-77364":["thread",77364],"thread-76362":["thread",76362],"thread-76348":["thread",76348],"thread-76201":["thread",76201],"thread-75879":["thread",75879],"thread-75713":["thread",75713],"thread-75701":["thread",75701],"thread-75650":["thread",75650],"thread-71548":["thread",71548]}, , 1716096539
Run Time: 0.000250
- 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