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 (7188935, 7173896, 7137242, 7105214, 7080521, 7072401, 7055720, 7046408, 7035180, 7022201, 6996597, 6995034, 6973249, 6855833, 6383426, 6312473, 6312468, 6312466, 6295137, 242065, 241140, 227611, 227045, 226953, 225360, 221745, 218751, 218241, 214667, 200631, 196481, 188983, 188982, 188790, 186140, 186023, 184299, 183406, 180277, 178077, 176331, 174808, 174343, 174225, 172157, 162077, 161854, 161853, 161770, 160421, 13236, 12878, 12727, 12693, 12443, 12297, 11152, 11096, 11095, 11003, 10806, 10770, 10573, 10560, 10555, 10456, 10055, 9867, 9827, 9645, 9113, 8904, 8762, 8533, 8368, 8325, 8178, 8172, 7758, 7540, 7476, 7474, 6599, 6309, 4885, 4475, 3528, 3260, 2994, 2743, 2710, 1703, 1553, 1141, 807, 613, 432, 346))
Run Time: 0.006403
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 98 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,production_xf.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 2870
- 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 138
- 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 2487
- 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: 344, 0, 1714544950, {"thread-7173896":["thread",7173896],"thread-7137242":["thread",7137242],"thread-7105214":["thread",7105214],"thread-7080521":["thread",7080521],"thread-7072401":["thread",7072401],"thread-7055720":["thread",7055720],"thread-7046408":["thread",7046408],"thread-7035180":["thread",7035180],"thread-7022201":["thread",7022201],"thread-6996597":["thread",6996597],"thread-6995034":["thread",6995034],"thread-6973249":["thread",6973249],"thread-6855833":["thread",6855833],"thread-6383426":["thread",6383426],"thread-242065":["thread",242065],"thread-241140":["thread",241140],"thread-227611":["thread",227611],"thread-227045":["thread",227045],"thread-226953":["thread",226953],"thread-225360":["thread",225360],"thread-221745":["thread",221745],"thread-218751":["thread",218751],"thread-218241":["thread",218241],"thread-200631":["thread",200631],"thread-196481":["thread",196481],"thread-188983":["thread",188983],"thread-188982":["thread",188982],"thread-186023":["thread",186023],"thread-184299":["thread",184299],"thread-183406":["thread",183406],"thread-180277":["thread",180277],"thread-178077":["thread",178077],"thread-176331":["thread",176331],"thread-174808":["thread",174808],"thread-174343":["thread",174343],"thread-174225":["thread",174225],"thread-161854":["thread",161854],"thread-161853":["thread",161853],"thread-161770":["thread",161770],"thread-160421":["thread",160421],"thread-13236":["thread",13236],"thread-12878":["thread",12878],"thread-12727":["thread",12727],"thread-12693":["thread",12693],"thread-12443":["thread",12443],"thread-12297":["thread",12297],"thread-11152":["thread",11152],"thread-11096":["thread",11096],"thread-11095":["thread",11095],"thread-11003":["thread",11003],"thread-10806":["thread",10806],"thread-10770":["thread",10770],"thread-10573":["thread",10573],"thread-10560":["thread",10560],"thread-10555":["thread",10555],"thread-10456":["thread",10456],"thread-10055":["thread",10055],"thread-9867":["thread",9867],"thread-9827":["thread",9827],"thread-9645":["thread",9645],"thread-9113":["thread",9113],"thread-8904":["thread",8904],"thread-8762":["thread",8762],"thread-8533":["thread",8533],"thread-8368":["thread",8368],"thread-8325":["thread",8325],"thread-8178":["thread",8178],"thread-8172":["thread",8172],"thread-7758":["thread",7758],"thread-7540":["thread",7540],"thread-7476":["thread",7476],"thread-7474":["thread",7474],"thread-6599":["thread",6599],"thread-6309":["thread",6309],"thread-4885":["thread",4885],"thread-4475":["thread",4475],"thread-3528":["thread",3528],"thread-3260":["thread",3260],"thread-2994":["thread",2994],"thread-2743":["thread",2743],"thread-2710":["thread",2710],"thread-1703":["thread",1703],"thread-1553":["thread",1553],"thread-1141":["thread",1141],"thread-807":["thread",807],"thread-613":["thread",613],"thread-432":["thread",432],"thread-346":["thread",346]}, NULL, 1714541350
Run Time: 0.000508
- 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 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20