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 (979, 978, 959, 957, 955, 951, 941, 938, 930, 926, 915, 908, 907, 905, 903, 902, 901, 900, 889, 888, 887, 886, 885, 881, 879, 876, 874, 870, 869, 867, 866, 862, 861, 860, 859, 858, 857, 856, 854, 853, 852, 851, 849, 847, 846, 844, 843, 842, 840, 834, 832, 831, 827, 824, 822, 815, 810, 808, 805, 804, 803, 802, 801, 789, 786, 783, 781, 780, 778, 776, 774, 772, 766, 760, 758, 756, 754, 747, 726, 721, 717, 710, 705, 691, 689, 687, 673, 671, 668, 667, 659, 655, 647, 631, 610, 606, 604, 602, 596, 588, 559, 534, 533, 531, 515, 510, 504, 503, 502, 500, 45, 15))
Run Time: 0.008135
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 112 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | osma_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | osma_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | osma_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | osma_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,osma_xen.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2543
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 729
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 136
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- 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: 26, 0, 1714909833, {"thread-979":["thread",979],"thread-978":["thread",978],"thread-959":["thread",959],"thread-957":["thread",957],"thread-955":["thread",955],"thread-951":["thread",951],"thread-941":["thread",941],"thread-938":["thread",938],"thread-930":["thread",930],"thread-926":["thread",926],"thread-915":["thread",915],"thread-908":["thread",908],"thread-907":["thread",907],"thread-905":["thread",905],"thread-903":["thread",903],"thread-902":["thread",902],"thread-901":["thread",901],"thread-900":["thread",900],"thread-889":["thread",889],"thread-888":["thread",888],"thread-887":["thread",887],"thread-886":["thread",886],"thread-885":["thread",885],"thread-881":["thread",881],"thread-879":["thread",879],"thread-876":["thread",876],"thread-874":["thread",874],"thread-870":["thread",870],"thread-869":["thread",869],"thread-867":["thread",867],"thread-866":["thread",866],"thread-862":["thread",862],"thread-861":["thread",861],"thread-860":["thread",860],"thread-859":["thread",859],"thread-858":["thread",858],"thread-857":["thread",857],"thread-856":["thread",856],"thread-854":["thread",854],"thread-853":["thread",853],"thread-852":["thread",852],"thread-851":["thread",851],"thread-849":["thread",849],"thread-847":["thread",847],"thread-846":["thread",846],"thread-844":["thread",844],"thread-843":["thread",843],"thread-842":["thread",842],"thread-840":["thread",840],"thread-834":["thread",834],"thread-832":["thread",832],"thread-831":["thread",831],"thread-827":["thread",827],"thread-824":["thread",824],"thread-822":["thread",822],"thread-815":["thread",815],"thread-810":["thread",810],"thread-808":["thread",808],"thread-805":["thread",805],"thread-804":["thread",804],"thread-803":["thread",803],"thread-802":["thread",802],"thread-801":["thread",801],"thread-789":["thread",789],"thread-786":["thread",786],"thread-783":["thread",783],"thread-781":["thread",781],"thread-780":["thread",780],"thread-778":["thread",778],"thread-776":["thread",776],"thread-774":["thread",774],"thread-772":["thread",772],"thread-766":["thread",766],"thread-760":["thread",760],"thread-758":["thread",758],"thread-756":["thread",756],"thread-754":["thread",754],"thread-747":["thread",747],"thread-726":["thread",726],"thread-721":["thread",721],"thread-717":["thread",717],"thread-710":["thread",710],"thread-705":["thread",705],"thread-691":["thread",691],"thread-689":["thread",689],"thread-687":["thread",687],"thread-673":["thread",673],"thread-671":["thread",671],"thread-668":["thread",668],"thread-667":["thread",667],"thread-659":["thread",659],"thread-655":["thread",655],"thread-647":["thread",647],"thread-631":["thread",631],"thread-610":["thread",610],"thread-606":["thread",606],"thread-604":["thread",604],"thread-602":["thread",602],"thread-596":["thread",596],"thread-588":["thread",588],"thread-559":["thread",559],"thread-534":["thread",534],"thread-533":["thread",533],"thread-531":["thread",531],"thread-515":["thread",515],"thread-510":["thread",510],"thread-504":["thread",504],"thread-503":["thread",503],"thread-502":["thread",502],"thread-500":["thread",500],"thread-45":["thread",45],"thread-15":["thread",15]}, , 1714906233
Run Time: 0.000319
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 218
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1452
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1184
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 149
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20