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 (45086, 43189, 42918, 42834, 42789, 42603, 42341, 41969, 41608, 41370, 41106, 40366, 39667, 39153, 38792, 38632, 38627, 38553, 38459, 38232, 37656, 37483, 37298, 37287, 36908, 36905, 36590, 36325, 36020, 35812, 35447, 35053, 34970, 34908, 34710, 34701, 34629, 34359, 34059, 33610, 33394, 33253, 33250, 32357, 32110, 32108, 31463, 30820, 30675, 30475, 30366, 30238, 30205, 30193, 30172, 30164, 29862, 29847, 29605, 29473, 29472, 29138, 29026, 29008, 29007, 28806, 28620, 28504, 28098, 27597, 27394, 26684, 26589, 26522, 26488, 25746, 24825, 24823, 24781, 22053, 21322, 21168, 20364, 19180, 18749, 32794, 17991, 17702, 17528, 17458, 16696, 15750, 15602, 14641, 14065, 13751, 12160, 10759, 10244, 10243, 10242, 10241, 10240, 9793, 8209, 8190, 8052, 7972, 7952, 7937, 7615, 7096, 6981, 6641, 6640, 6639, 6396, 5931, 5647, 5530, 5385, 5162, 5074, 5064, 5063, 5051, 4145, 4066, 4037, 3197, 2929, 2402, 1832, 1302, 701, 579))
Run Time: 0.046729
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 136 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,squattheplanet.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 1430
- 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 2866
- 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 2483
- XF\App->run() in src/XF.php at line 524
- 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: 184, 0, 1716114809, {"thread-45086":["thread",45086],"thread-42918":["thread",42918],"thread-42789":["thread",42789],"thread-42603":["thread",42603],"thread-41969":["thread",41969],"thread-41608":["thread",41608],"thread-41370":["thread",41370],"thread-41106":["thread",41106],"thread-40366":["thread",40366],"thread-39667":["thread",39667],"thread-39153":["thread",39153],"thread-38792":["thread",38792],"thread-38632":["thread",38632],"thread-38627":["thread",38627],"thread-38553":["thread",38553],"thread-38459":["thread",38459],"thread-38232":["thread",38232],"thread-37656":["thread",37656],"thread-37483":["thread",37483],"thread-37298":["thread",37298],"thread-37287":["thread",37287],"thread-36908":["thread",36908],"thread-36590":["thread",36590],"thread-36325":["thread",36325],"thread-36020":["thread",36020],"thread-35812":["thread",35812],"thread-35447":["thread",35447],"thread-35053":["thread",35053],"thread-34970":["thread",34970],"thread-34908":["thread",34908],"thread-34710":["thread",34710],"thread-34701":["thread",34701],"thread-34629":["thread",34629],"thread-34359":["thread",34359],"thread-34059":["thread",34059],"thread-33610":["thread",33610],"thread-33394":["thread",33394],"thread-33250":["thread",33250],"thread-32357":["thread",32357],"thread-32110":["thread",32110],"thread-32108":["thread",32108],"thread-31463":["thread",31463],"thread-30820":["thread",30820],"thread-30675":["thread",30675],"thread-30475":["thread",30475],"thread-30366":["thread",30366],"thread-30205":["thread",30205],"thread-30193":["thread",30193],"thread-30172":["thread",30172],"thread-30164":["thread",30164],"thread-29862":["thread",29862],"thread-29847":["thread",29847],"thread-29605":["thread",29605],"thread-29473":["thread",29473],"thread-29472":["thread",29472],"thread-29138":["thread",29138],"thread-29026":["thread",29026],"thread-29008":["thread",29008],"thread-29007":["thread",29007],"thread-28806":["thread",28806],"thread-28620":["thread",28620],"thread-28504":["thread",28504],"thread-28098":["thread",28098],"thread-27597":["thread",27597],"thread-27394":["thread",27394],"thread-26684":["thread",26684],"thread-26589":["thread",26589],"thread-26522":["thread",26522],"thread-26488":["thread",26488],"thread-25746":["thread",25746],"thread-24825":["thread",24825],"thread-24823":["thread",24823],"thread-24781":["thread",24781],"thread-22053":["thread",22053],"thread-21322":["thread",21322],"thread-21168":["thread",21168],"thread-20364":["thread",20364],"thread-19180":["thread",19180],"thread-32794":["thread",32794],"thread-17991":["thread",17991],"thread-17702":["thread",17702],"thread-17528":["thread",17528],"thread-17458":["thread",17458],"thread-16696":["thread",16696],"thread-15750":["thread",15750],"thread-14641":["thread",14641],"thread-14065":["thread",14065],"thread-13751":["thread",13751],"thread-12160":["thread",12160],"thread-10759":["thread",10759],"thread-10244":["thread",10244],"thread-10243":["thread",10243],"thread-10242":["thread",10242],"thread-10241":["thread",10241],"thread-10240":["thread",10240],"thread-9793":["thread",9793],"thread-8209":["thread",8209],"thread-8190":["thread",8190],"thread-8052":["thread",8052],"thread-7972":["thread",7972],"thread-7952":["thread",7952],"thread-7937":["thread",7937],"thread-7615":["thread",7615],"thread-7096":["thread",7096],"thread-6981":["thread",6981],"thread-6641":["thread",6641],"thread-6640":["thread",6640],"thread-6639":["thread",6639],"thread-6396":["thread",6396],"thread-5647":["thread",5647],"thread-5530":["thread",5530],"thread-5385":["thread",5385],"thread-5162":["thread",5162],"thread-5074":["thread",5074],"thread-5064":["thread",5064],"thread-5063":["thread",5063],"thread-4066":["thread",4066],"thread-4037":["thread",4037],"thread-3197":["thread",3197],"thread-2929":["thread",2929],"thread-2402":["thread",2402],"thread-1832":["thread",1832],"thread-1302":["thread",1302],"thread-579":["thread",579]}, NULL, 1716111209
Run Time: 0.002386
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- 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 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20