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 (982, 980, 979, 978, 959, 958, 957, 956, 955, 952, 951, 949, 948, 946, 945, 941, 939, 938, 937, 936, 934, 933, 932, 931, 930, 928, 927, 926, 922, 920, 919, 918, 916, 909, 908, 907, 906, 905, 903, 902, 901, 900, 899, 896, 893, 892, 891, 890, 888, 887, 886, 885, 883, 881, 879, 877, 874, 873, 871, 870, 869, 868, 867, 866, 865, 864, 863, 862, 861, 860, 859, 858, 857, 856, 854, 853, 852, 851, 849, 847, 846, 845, 844, 843, 842, 839, 838, 836, 835, 834, 831, 830, 824, 823, 822, 819, 816, 815, 811, 810, 809, 808, 806, 805, 804, 803, 801, 799, 797, 795, 793, 791, 789, 788, 786, 783, 778, 760, 758, 754, 753, 751, 748, 747, 745, 739, 738, 737, 733, 711, 710, 708, 691, 690, 689, 666, 659, 655, 640, 631, 630, 625, 622, 616, 607, 604, 602, 600, 596, 594, 589, 585, 560, 552, 545, 514, 495, 488, 487, 73))
Run Time: 0.065219
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 160 | 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: 132, 0, 1714534951, {"thread-982":["thread",982],"thread-980":["thread",980],"thread-979":["thread",979],"thread-978":["thread",978],"thread-959":["thread",959],"thread-958":["thread",958],"thread-957":["thread",957],"thread-956":["thread",956],"thread-955":["thread",955],"thread-952":["thread",952],"thread-951":["thread",951],"thread-949":["thread",949],"thread-948":["thread",948],"thread-946":["thread",946],"thread-945":["thread",945],"thread-941":["thread",941],"thread-939":["thread",939],"thread-938":["thread",938],"thread-937":["thread",937],"thread-936":["thread",936],"thread-934":["thread",934],"thread-933":["thread",933],"thread-932":["thread",932],"thread-931":["thread",931],"thread-930":["thread",930],"thread-928":["thread",928],"thread-927":["thread",927],"thread-926":["thread",926],"thread-922":["thread",922],"thread-920":["thread",920],"thread-919":["thread",919],"thread-918":["thread",918],"thread-916":["thread",916],"thread-909":["thread",909],"thread-908":["thread",908],"thread-907":["thread",907],"thread-906":["thread",906],"thread-905":["thread",905],"thread-903":["thread",903],"thread-902":["thread",902],"thread-901":["thread",901],"thread-900":["thread",900],"thread-899":["thread",899],"thread-896":["thread",896],"thread-893":["thread",893],"thread-892":["thread",892],"thread-891":["thread",891],"thread-890":["thread",890],"thread-888":["thread",888],"thread-887":["thread",887],"thread-886":["thread",886],"thread-885":["thread",885],"thread-883":["thread",883],"thread-881":["thread",881],"thread-879":["thread",879],"thread-877":["thread",877],"thread-874":["thread",874],"thread-873":["thread",873],"thread-871":["thread",871],"thread-870":["thread",870],"thread-869":["thread",869],"thread-868":["thread",868],"thread-867":["thread",867],"thread-866":["thread",866],"thread-865":["thread",865],"thread-864":["thread",864],"thread-863":["thread",863],"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-845":["thread",845],"thread-844":["thread",844],"thread-843":["thread",843],"thread-842":["thread",842],"thread-839":["thread",839],"thread-838":["thread",838],"thread-836":["thread",836],"thread-835":["thread",835],"thread-834":["thread",834],"thread-831":["thread",831],"thread-830":["thread",830],"thread-824":["thread",824],"thread-823":["thread",823],"thread-822":["thread",822],"thread-819":["thread",819],"thread-816":["thread",816],"thread-815":["thread",815],"thread-811":["thread",811],"thread-810":["thread",810],"thread-809":["thread",809],"thread-808":["thread",808],"thread-806":["thread",806],"thread-805":["thread",805],"thread-804":["thread",804],"thread-803":["thread",803],"thread-801":["thread",801],"thread-799":["thread",799],"thread-797":["thread",797],"thread-795":["thread",795],"thread-793":["thread",793],"thread-791":["thread",791],"thread-789":["thread",789],"thread-788":["thread",788],"thread-786":["thread",786],"thread-783":["thread",783],"thread-778":["thread",778],"thread-760":["thread",760],"thread-758":["thread",758],"thread-754":["thread",754],"thread-753":["thread",753],"thread-751":["thread",751],"thread-748":["thread",748],"thread-747":["thread",747],"thread-745":["thread",745],"thread-739":["thread",739],"thread-738":["thread",738],"thread-737":["thread",737],"thread-733":["thread",733],"thread-711":["thread",711],"thread-710":["thread",710],"thread-708":["thread",708],"thread-691":["thread",691],"thread-690":["thread",690],"thread-689":["thread",689],"thread-666":["thread",666],"thread-659":["thread",659],"thread-655":["thread",655],"thread-640":["thread",640],"thread-631":["thread",631],"thread-630":["thread",630],"thread-625":["thread",625],"thread-622":["thread",622],"thread-616":["thread",616],"thread-607":["thread",607],"thread-604":["thread",604],"thread-602":["thread",602],"thread-600":["thread",600],"thread-596":["thread",596],"thread-594":["thread",594],"thread-589":["thread",589],"thread-585":["thread",585],"thread-560":["thread",560],"thread-552":["thread",552],"thread-545":["thread",545],"thread-514":["thread",514],"thread-495":["thread",495],"thread-488":["thread",488],"thread-487":["thread",487],"thread-73":["thread",73]}, , 1714531351
Run Time: 0.027398
- 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