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 (7215269, 7203842, 7189962, 7186542, 7186185, 7176451, 7167279, 7155454, 7153777, 7145742, 7080521, 7062510, 7053776, 7024998, 7023011, 7015346, 7011879, 6998843, 6610902, 212690, 205920, 198487, 187664, 179693, 176666, 13626, 13549, 13085, 12828, 12718, 12355, 12202, 12190, 12175, 12096, 12058, 11685, 11239, 11153, 10990, 10928, 10864, 10319, 10222, 10123, 10035, 9906, 9883, 9525, 9500, 9417, 9242, 9234, 8979, 8821, 8502, 8215, 8082, 7893, 7455, 7328, 7327, 7320, 7302, 6801, 6555, 6517, 6455, 5921, 5741, 5316, 5293, 5077, 4827, 4798, 4514, 3876, 3517, 3161, 2670, 2630, 2527, 2364, 2116, 1868, 1821, 1713, 1416, 1352, 1271, 1040, 959, 501, 92))
Run Time: 0.005814
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 94 | 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: 28, 0, 1714368126, {"thread-7215269":["thread",7215269],"thread-7203842":["thread",7203842],"thread-7189962":["thread",7189962],"thread-7186542":["thread",7186542],"thread-7186185":["thread",7186185],"thread-7176451":["thread",7176451],"thread-7167279":["thread",7167279],"thread-7155454":["thread",7155454],"thread-7153777":["thread",7153777],"thread-7145742":["thread",7145742],"thread-7080521":["thread",7080521],"thread-7062510":["thread",7062510],"thread-7053776":["thread",7053776],"thread-7024998":["thread",7024998],"thread-7023011":["thread",7023011],"thread-7015346":["thread",7015346],"thread-7011879":["thread",7011879],"thread-6998843":["thread",6998843],"thread-6610902":["thread",6610902],"thread-212690":["thread",212690],"thread-205920":["thread",205920],"thread-198487":["thread",198487],"thread-187664":["thread",187664],"thread-179693":["thread",179693],"thread-176666":["thread",176666],"thread-13626":["thread",13626],"thread-13549":["thread",13549],"thread-13085":["thread",13085],"thread-12828":["thread",12828],"thread-12718":["thread",12718],"thread-12355":["thread",12355],"thread-12202":["thread",12202],"thread-12190":["thread",12190],"thread-12175":["thread",12175],"thread-12096":["thread",12096],"thread-12058":["thread",12058],"thread-11685":["thread",11685],"thread-11239":["thread",11239],"thread-11153":["thread",11153],"thread-10990":["thread",10990],"thread-10928":["thread",10928],"thread-10864":["thread",10864],"thread-10319":["thread",10319],"thread-10222":["thread",10222],"thread-10123":["thread",10123],"thread-10035":["thread",10035],"thread-9906":["thread",9906],"thread-9883":["thread",9883],"thread-9525":["thread",9525],"thread-9500":["thread",9500],"thread-9417":["thread",9417],"thread-9242":["thread",9242],"thread-9234":["thread",9234],"thread-8979":["thread",8979],"thread-8821":["thread",8821],"thread-8502":["thread",8502],"thread-8215":["thread",8215],"thread-8082":["thread",8082],"thread-7893":["thread",7893],"thread-7455":["thread",7455],"thread-7328":["thread",7328],"thread-7327":["thread",7327],"thread-7320":["thread",7320],"thread-7302":["thread",7302],"thread-6801":["thread",6801],"thread-6555":["thread",6555],"thread-6517":["thread",6517],"thread-6455":["thread",6455],"thread-5921":["thread",5921],"thread-5741":["thread",5741],"thread-5316":["thread",5316],"thread-5293":["thread",5293],"thread-5077":["thread",5077],"thread-4827":["thread",4827],"thread-4798":["thread",4798],"thread-4514":["thread",4514],"thread-3876":["thread",3876],"thread-3517":["thread",3517],"thread-3161":["thread",3161],"thread-2670":["thread",2670],"thread-2630":["thread",2630],"thread-2527":["thread",2527],"thread-2364":["thread",2364],"thread-2116":["thread",2116],"thread-1868":["thread",1868],"thread-1821":["thread",1821],"thread-1713":["thread",1713],"thread-1416":["thread",1416],"thread-1352":["thread",1352],"thread-1271":["thread",1271],"thread-1040":["thread",1040],"thread-959":["thread",959],"thread-501":["thread",501],"thread-92":["thread",92]}, NULL, 1714364526
Run Time: 0.000637
- 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