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 (7212348, 7207858, 7204875, 7201583, 7200524, 7195894, 7195864, 7194034, 7192912, 7185973, 7185694, 7184633, 7184529, 7180442, 7167656, 7162682, 7158024, 7156784, 7155127, 7153777, 7150636, 7149461, 7146588, 7127773, 7125307, 7099693, 7012195, 7002890, 6988560, 6503449, 224977, 188198, 178504, 13422, 13139, 13095, 12843, 12662, 12649, 12534, 12374, 12140, 11959, 11751, 11518, 10695, 10653, 10634, 10481, 10228, 9241, 9162, 9134, 9108, 9099, 8629, 8308, 7496, 7330, 7286, 6605, 5907, 5795, 5383, 4968, 4564, 4542, 4242, 3922, 3758, 3734, 3459, 3386, 3364, 2708, 2638, 2481, 1483, 1481, 926, 795, 474, 436))
Run Time: 0.007751
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 83 | 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: 492, 0, 1716005844, {"thread-7212348":["thread",7212348],"thread-7207858":["thread",7207858],"thread-7204875":["thread",7204875],"thread-7201583":["thread",7201583],"thread-7200524":["thread",7200524],"thread-7195894":["thread",7195894],"thread-7195864":["thread",7195864],"thread-7194034":["thread",7194034],"thread-7192912":["thread",7192912],"thread-7185973":["thread",7185973],"thread-7185694":["thread",7185694],"thread-7184633":["thread",7184633],"thread-7184529":["thread",7184529],"thread-7180442":["thread",7180442],"thread-7167656":["thread",7167656],"thread-7162682":["thread",7162682],"thread-7158024":["thread",7158024],"thread-7156784":["thread",7156784],"thread-7155127":["thread",7155127],"thread-7153777":["thread",7153777],"thread-7150636":["thread",7150636],"thread-7149461":["thread",7149461],"thread-7146588":["thread",7146588],"thread-7127773":["thread",7127773],"thread-7125307":["thread",7125307],"thread-7099693":["thread",7099693],"thread-7012195":["thread",7012195],"thread-7002890":["thread",7002890],"thread-6988560":["thread",6988560],"thread-6503449":["thread",6503449],"thread-224977":["thread",224977],"thread-188198":["thread",188198],"thread-178504":["thread",178504],"thread-13422":["thread",13422],"thread-13139":["thread",13139],"thread-13095":["thread",13095],"thread-12843":["thread",12843],"thread-12662":["thread",12662],"thread-12649":["thread",12649],"thread-12534":["thread",12534],"thread-12374":["thread",12374],"thread-12140":["thread",12140],"thread-11959":["thread",11959],"thread-11751":["thread",11751],"thread-11518":["thread",11518],"thread-10695":["thread",10695],"thread-10653":["thread",10653],"thread-10634":["thread",10634],"thread-10481":["thread",10481],"thread-10228":["thread",10228],"thread-9241":["thread",9241],"thread-9162":["thread",9162],"thread-9134":["thread",9134],"thread-9108":["thread",9108],"thread-9099":["thread",9099],"thread-8629":["thread",8629],"thread-8308":["thread",8308],"thread-7496":["thread",7496],"thread-7330":["thread",7330],"thread-7286":["thread",7286],"thread-6605":["thread",6605],"thread-5907":["thread",5907],"thread-5795":["thread",5795],"thread-5383":["thread",5383],"thread-4968":["thread",4968],"thread-4564":["thread",4564],"thread-4542":["thread",4542],"thread-4242":["thread",4242],"thread-3922":["thread",3922],"thread-3758":["thread",3758],"thread-3734":["thread",3734],"thread-3459":["thread",3459],"thread-3386":["thread",3386],"thread-3364":["thread",3364],"thread-2708":["thread",2708],"thread-2638":["thread",2638],"thread-2481":["thread",2481],"thread-1483":["thread",1483],"thread-1481":["thread",1481],"thread-926":["thread",926],"thread-795":["thread",795],"thread-474":["thread",474],"thread-436":["thread",436]}, NULL, 1716002244
Run Time: 0.000562
- 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