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 (45097, 45076, 43189, 43059, 42403, 42353, 42061, 42042, 42029, 41987, 41865, 41701, 41128, 40988, 40662, 40602, 40570, 40455, 40041, 39970, 39898, 39456, 39106, 39092, 38232, 38178, 37893, 37760, 37628, 37240, 37187, 37186, 36821, 36575, 36162, 36140, 35270, 34929, 34618, 32890, 31828, 30892, 30421, 30410, 30310, 30172, 30074, 29841, 29650, 29622, 29244, 28113, 28021, 27262, 27244, 27016, 26552, 26405, 26207, 25895, 25889, 25822, 25675, 25305, 24441, 23614, 23239, 22663, 21956, 21785, 21461, 21423, 21332, 21184, 21156, 20844, 19107, 18696, 17285, 17078, 16445, 16407, 16348, 16182, 15851, 15670, 15332, 14806, 14551, 14480, 14458, 14422, 14390, 14329, 14123, 14011, 13717, 12890, 12874, 12737, 12645, 12237, 12124, 11743, 11713, 11168, 11162, 11040, 10875, 10217, 7973, 7586, 7235, 7118, 7015, 6485, 5897, 5759, 4834, 4833, 4761, 4331, 3716, 3476, 2610, 2243, 1766, 1205, 774))
Run Time: 0.040496
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 129 | 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: 104, 0, 1716222443, {"thread-45097":["thread",45097],"thread-45076":["thread",45076],"thread-43059":["thread",43059],"thread-42403":["thread",42403],"thread-42353":["thread",42353],"thread-42061":["thread",42061],"thread-42042":["thread",42042],"thread-41987":["thread",41987],"thread-41865":["thread",41865],"thread-41701":["thread",41701],"thread-41128":["thread",41128],"thread-40988":["thread",40988],"thread-40602":["thread",40602],"thread-40570":["thread",40570],"thread-40455":["thread",40455],"thread-39970":["thread",39970],"thread-39898":["thread",39898],"thread-39456":["thread",39456],"thread-39106":["thread",39106],"thread-39092":["thread",39092],"thread-38232":["thread",38232],"thread-38178":["thread",38178],"thread-37760":["thread",37760],"thread-37628":["thread",37628],"thread-37240":["thread",37240],"thread-37187":["thread",37187],"thread-37186":["thread",37186],"thread-36821":["thread",36821],"thread-36575":["thread",36575],"thread-36140":["thread",36140],"thread-35270":["thread",35270],"thread-34929":["thread",34929],"thread-34618":["thread",34618],"thread-32890":["thread",32890],"thread-31828":["thread",31828],"thread-30892":["thread",30892],"thread-30421":["thread",30421],"thread-30410":["thread",30410],"thread-30310":["thread",30310],"thread-30172":["thread",30172],"thread-30074":["thread",30074],"thread-29841":["thread",29841],"thread-29622":["thread",29622],"thread-29244":["thread",29244],"thread-28113":["thread",28113],"thread-28021":["thread",28021],"thread-27262":["thread",27262],"thread-27244":["thread",27244],"thread-26552":["thread",26552],"thread-25895":["thread",25895],"thread-25822":["thread",25822],"thread-25305":["thread",25305],"thread-24441":["thread",24441],"thread-23614":["thread",23614],"thread-21956":["thread",21956],"thread-21785":["thread",21785],"thread-21461":["thread",21461],"thread-21423":["thread",21423],"thread-21332":["thread",21332],"thread-21184":["thread",21184],"thread-21156":["thread",21156],"thread-20844":["thread",20844],"thread-19107":["thread",19107],"thread-17285":["thread",17285],"thread-17078":["thread",17078],"thread-16445":["thread",16445],"thread-16407":["thread",16407],"thread-16182":["thread",16182],"thread-15851":["thread",15851],"thread-15670":["thread",15670],"thread-15332":["thread",15332],"thread-14806":["thread",14806],"thread-14551":["thread",14551],"thread-14480":["thread",14480],"thread-14458":["thread",14458],"thread-14390":["thread",14390],"thread-14329":["thread",14329],"thread-14123":["thread",14123],"thread-14011":["thread",14011],"thread-13717":["thread",13717],"thread-12890":["thread",12890],"thread-12874":["thread",12874],"thread-12737":["thread",12737],"thread-12645":["thread",12645],"thread-12124":["thread",12124],"thread-11743":["thread",11743],"thread-11713":["thread",11713],"thread-11040":["thread",11040],"thread-10875":["thread",10875],"thread-7973":["thread",7973],"thread-7586":["thread",7586],"thread-7235":["thread",7235],"thread-7118":["thread",7118],"thread-7015":["thread",7015],"thread-6485":["thread",6485],"thread-5759":["thread",5759],"thread-4834":["thread",4834],"thread-4833":["thread",4833],"thread-4761":["thread",4761],"thread-4331":["thread",4331],"thread-3716":["thread",3716],"thread-3476":["thread",3476],"thread-2610":["thread",2610],"thread-2243":["thread",2243],"thread-1766":["thread",1766],"thread-1205":["thread",1205],"thread-774":["thread",774]}, NULL, 1716218843
Run Time: 0.001271
- 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