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 (14389, 14346, 14267, 14239, 14231, 14172, 14144, 14135, 14106, 14036, 14000, 13896, 13858, 13840, 13822, 13812, 13735, 13701, 13635, 13560, 13541, 13481, 13452, 13403, 13363, 13338, 13325, 13264, 13185, 13163, 12898, 12875, 12847, 12752, 12715, 12664, 12601, 12597, 12405, 12357, 12351, 12338, 12317, 12294, 12292, 12274, 12229, 12227, 12183, 12108, 12078, 12042, 11972, 11928, 11876, 11847, 11841, 11832, 11804, 11791, 11723, 11685, 11610, 11585, 11540, 11509, 11454, 11304, 11291, 11283, 11238, 11227, 11222, 11131, 11090, 11007, 10987, 10953, 10744, 10706, 10681, 10651, 10580, 10404, 10384, 10313, 10252, 10162, 10118, 9971, 9820, 9816, 9772, 9736, 9709, 9638, 9563, 9476, 9459, 9452, 9420, 9371, 9325, 9281, 9237, 9206, 9198, 9182, 9164, 9136, 9040, 9001, 8959, 8939, 8907, 8893, 8864, 8657, 8624, 8487, 8183, 8157, 8156, 8153, 8074, 8016, 7985, 7980, 7977, 7964, 7963, 7935, 7930, 7769, 7697, 7678, 7663, 7654, 7629, 7582, 7580, 7484, 7473, 7465, 7434, 7424, 7419, 7351, 7271, 7245))
Run Time: 0.020666
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 150 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | db638424249.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | db638424249.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | db638424249.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | db638424249.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,db638424249.xf_node_Node_2.node_id | 1 | |
- 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: 16, 0, 1715756729, {"thread-14389":["thread",14389],"thread-14346":["thread",14346],"thread-14267":["thread",14267],"thread-14239":["thread",14239],"thread-14231":["thread",14231],"thread-14172":["thread",14172],"thread-14144":["thread",14144],"thread-14135":["thread",14135],"thread-14106":["thread",14106],"thread-14036":["thread",14036],"thread-14000":["thread",14000],"thread-13896":["thread",13896],"thread-13858":["thread",13858],"thread-13840":["thread",13840],"thread-13822":["thread",13822],"thread-13812":["thread",13812],"thread-13735":["thread",13735],"thread-13701":["thread",13701],"thread-13635":["thread",13635],"thread-13560":["thread",13560],"thread-13541":["thread",13541],"thread-13481":["thread",13481],"thread-13452":["thread",13452],"thread-13403":["thread",13403],"thread-13363":["thread",13363],"thread-13338":["thread",13338],"thread-13325":["thread",13325],"thread-13264":["thread",13264],"thread-13185":["thread",13185],"thread-13163":["thread",13163],"thread-12898":["thread",12898],"thread-12875":["thread",12875],"thread-12847":["thread",12847],"thread-12752":["thread",12752],"thread-12715":["thread",12715],"thread-12664":["thread",12664],"thread-12601":["thread",12601],"thread-12597":["thread",12597],"thread-12405":["thread",12405],"thread-12357":["thread",12357],"thread-12351":["thread",12351],"thread-12338":["thread",12338],"thread-12317":["thread",12317],"thread-12294":["thread",12294],"thread-12292":["thread",12292],"thread-12274":["thread",12274],"thread-12229":["thread",12229],"thread-12227":["thread",12227],"thread-12183":["thread",12183],"thread-12108":["thread",12108],"thread-12078":["thread",12078],"thread-12042":["thread",12042],"thread-11972":["thread",11972],"thread-11928":["thread",11928],"thread-11876":["thread",11876],"thread-11847":["thread",11847],"thread-11841":["thread",11841],"thread-11832":["thread",11832],"thread-11804":["thread",11804],"thread-11791":["thread",11791],"thread-11723":["thread",11723],"thread-11685":["thread",11685],"thread-11610":["thread",11610],"thread-11585":["thread",11585],"thread-11540":["thread",11540],"thread-11509":["thread",11509],"thread-11454":["thread",11454],"thread-11304":["thread",11304],"thread-11291":["thread",11291],"thread-11283":["thread",11283],"thread-11238":["thread",11238],"thread-11227":["thread",11227],"thread-11222":["thread",11222],"thread-11131":["thread",11131],"thread-11090":["thread",11090],"thread-11007":["thread",11007],"thread-10987":["thread",10987],"thread-10953":["thread",10953],"thread-10744":["thread",10744],"thread-10706":["thread",10706],"thread-10681":["thread",10681],"thread-10651":["thread",10651],"thread-10580":["thread",10580],"thread-10404":["thread",10404],"thread-10384":["thread",10384],"thread-10313":["thread",10313],"thread-10252":["thread",10252],"thread-10162":["thread",10162],"thread-10118":["thread",10118],"thread-9971":["thread",9971],"thread-9820":["thread",9820],"thread-9816":["thread",9816],"thread-9772":["thread",9772],"thread-9736":["thread",9736],"thread-9709":["thread",9709],"thread-9638":["thread",9638],"thread-9563":["thread",9563],"thread-9476":["thread",9476],"thread-9459":["thread",9459],"thread-9452":["thread",9452],"thread-9420":["thread",9420],"thread-9371":["thread",9371],"thread-9325":["thread",9325],"thread-9281":["thread",9281],"thread-9237":["thread",9237],"thread-9206":["thread",9206],"thread-9198":["thread",9198],"thread-9182":["thread",9182],"thread-9164":["thread",9164],"thread-9136":["thread",9136],"thread-9040":["thread",9040],"thread-9001":["thread",9001],"thread-8959":["thread",8959],"thread-8939":["thread",8939],"thread-8907":["thread",8907],"thread-8893":["thread",8893],"thread-8864":["thread",8864],"thread-8657":["thread",8657],"thread-8624":["thread",8624],"thread-8487":["thread",8487],"thread-8183":["thread",8183],"thread-8157":["thread",8157],"thread-8156":["thread",8156],"thread-8153":["thread",8153],"thread-8074":["thread",8074],"thread-8016":["thread",8016],"thread-7985":["thread",7985],"thread-7980":["thread",7980],"thread-7977":["thread",7977],"thread-7964":["thread",7964],"thread-7963":["thread",7963],"thread-7935":["thread",7935],"thread-7930":["thread",7930],"thread-7769":["thread",7769],"thread-7697":["thread",7697],"thread-7678":["thread",7678],"thread-7663":["thread",7663],"thread-7654":["thread",7654],"thread-7629":["thread",7629],"thread-7582":["thread",7582],"thread-7580":["thread",7580],"thread-7484":["thread",7484],"thread-7473":["thread",7473],"thread-7465":["thread",7465],"thread-7434":["thread",7434],"thread-7424":["thread",7424],"thread-7419":["thread",7419],"thread-7351":["thread",7351],"thread-7271":["thread",7271],"thread-7245":["thread",7245]}, NULL, 1715753129
Run Time: 0.000466
- 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