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 (173991, 35315, 35310, 34894, 33015, 31357, 28953, 28942, 28524, 28288, 27510, 25797, 25794, 25759, 25227, 25189, 24875, 23796, 23427, 22327, 21394, 21084, 21083, 21067, 21065, 21004, 21002, 20569, 20568, 20566, 20433, 20298, 20292, 20179, 20170, 20135, 19782, 19721, 19692, 19129, 18971, 18969, 18818, 18788, 18518, 17902, 17868, 17857, 17805, 17801, 17790, 16265, 16253, 15157, 15003, 15001, 14957, 14192, 14190, 14089, 13744, 13739, 12851, 12847, 12845, 12758, 12749, 12745, 12743, 12740, 12654, 12501, 12313, 10176, 9043, 8804, 8789, 8558, 8383, 8307, 8305, 8303, 8251, 8247, 8065, 8038, 7442, 7426, 7386, 7372, 4749, 3977, 6001, 5996, 5966, 5859, 4319, 5724, 5157, 3717, 4563, 3715, 4644, 4501, 4450, 4630, 4471, 4144, 4367, 4320, 4466, 4297, 4470, 4224, 4180, 4472, 4429, 4428, 4427, 4426, 4425, 4104, 4136, 3719, 3960, 3959, 3958, 3961, 3904, 5392, 4351, 4220, 4200, 4121, 4223, 4525, 4558, 4526, 4528, 4524, 4523, 4516, 4651, 4517, 4712, 4731, 4798, 4766, 4850, 4858, 4952, 4984, 4554, 4976, 4999, 4670, 3776, 3651, 3471, 3377, 3326, 3207, 3055, 3011, 2892, 2891, 2829, 2784, 2723, 2703, 2700, 2699, 2651, 2650, 2649, 2602, 2601, 2511, 2487, 2480, 2295, 2274, 2223, 2396, 2092, 2046, 2019, 1919, 1909, 1900, 1881, 1825, 1823, 1771, 1746, 1546, 1516, 1515, 1514, 1383))
Run Time: 0.618746
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.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 1387
- 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 2729
- 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 2351
- XF\App->run() in src/XF.php at line 517
- 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: 188, 0, 1716181014, {"thread-173991":["thread",173991],"thread-35315":["thread",35315],"thread-35310":["thread",35310],"thread-34894":["thread",34894],"thread-33015":["thread",33015],"thread-31357":["thread",31357],"thread-28953":["thread",28953],"thread-28942":["thread",28942],"thread-28524":["thread",28524],"thread-28288":["thread",28288],"thread-27510":["thread",27510],"thread-25797":["thread",25797],"thread-25794":["thread",25794],"thread-25759":["thread",25759],"thread-25227":["thread",25227],"thread-25189":["thread",25189],"thread-24875":["thread",24875],"thread-23796":["thread",23796],"thread-23427":["thread",23427],"thread-22327":["thread",22327],"thread-21394":["thread",21394],"thread-21084":["thread",21084],"thread-21083":["thread",21083],"thread-21067":["thread",21067],"thread-21065":["thread",21065],"thread-21004":["thread",21004],"thread-21002":["thread",21002],"thread-20569":["thread",20569],"thread-20568":["thread",20568],"thread-20566":["thread",20566],"thread-20433":["thread",20433],"thread-20298":["thread",20298],"thread-20292":["thread",20292],"thread-20179":["thread",20179],"thread-20170":["thread",20170],"thread-20135":["thread",20135],"thread-19782":["thread",19782],"thread-19721":["thread",19721],"thread-19692":["thread",19692],"thread-19129":["thread",19129],"thread-18971":["thread",18971],"thread-18969":["thread",18969],"thread-18818":["thread",18818],"thread-18788":["thread",18788],"thread-18518":["thread",18518],"thread-17902":["thread",17902],"thread-17868":["thread",17868],"thread-17857":["thread",17857],"thread-17805":["thread",17805],"thread-17801":["thread",17801],"thread-17790":["thread",17790],"thread-16265":["thread",16265],"thread-16253":["thread",16253],"thread-15157":["thread",15157],"thread-15003":["thread",15003],"thread-15001":["thread",15001],"thread-14957":["thread",14957],"thread-14192":["thread",14192],"thread-14190":["thread",14190],"thread-14089":["thread",14089],"thread-13744":["thread",13744],"thread-13739":["thread",13739],"thread-12851":["thread",12851],"thread-12847":["thread",12847],"thread-12845":["thread",12845],"thread-12758":["thread",12758],"thread-12749":["thread",12749],"thread-12745":["thread",12745],"thread-12743":["thread",12743],"thread-12740":["thread",12740],"thread-12654":["thread",12654],"thread-12501":["thread",12501],"thread-12313":["thread",12313],"thread-10176":["thread",10176],"thread-9043":["thread",9043],"thread-8804":["thread",8804],"thread-8789":["thread",8789],"thread-8558":["thread",8558],"thread-8383":["thread",8383],"thread-8307":["thread",8307],"thread-8305":["thread",8305],"thread-8303":["thread",8303],"thread-8251":["thread",8251],"thread-8247":["thread",8247],"thread-8065":["thread",8065],"thread-8038":["thread",8038],"thread-7442":["thread",7442],"thread-7426":["thread",7426],"thread-7386":["thread",7386],"thread-7372":["thread",7372],"thread-4749":["thread",4749],"thread-3977":["thread",3977],"thread-6001":["thread",6001],"thread-5996":["thread",5996],"thread-5966":["thread",5966],"thread-5859":["thread",5859],"thread-4319":["thread",4319],"thread-5724":["thread",5724],"thread-5157":["thread",5157],"thread-3717":["thread",3717],"thread-4563":["thread",4563],"thread-3715":["thread",3715],"thread-4644":["thread",4644],"thread-4501":["thread",4501],"thread-4450":["thread",4450],"thread-4630":["thread",4630],"thread-4471":["thread",4471],"thread-4144":["thread",4144],"thread-4367":["thread",4367],"thread-4320":["thread",4320],"thread-4466":["thread",4466],"thread-4297":["thread",4297],"thread-4470":["thread",4470],"thread-4224":["thread",4224],"thread-4180":["thread",4180],"thread-4472":["thread",4472],"thread-4429":["thread",4429],"thread-4428":["thread",4428],"thread-4427":["thread",4427],"thread-4426":["thread",4426],"thread-4425":["thread",4425],"thread-4104":["thread",4104],"thread-4136":["thread",4136],"thread-3719":["thread",3719],"thread-3960":["thread",3960],"thread-3959":["thread",3959],"thread-3958":["thread",3958],"thread-3961":["thread",3961],"thread-3904":["thread",3904],"thread-5392":["thread",5392],"thread-4351":["thread",4351],"thread-4220":["thread",4220],"thread-4200":["thread",4200],"thread-4121":["thread",4121],"thread-4223":["thread",4223],"thread-4525":["thread",4525],"thread-4558":["thread",4558],"thread-4526":["thread",4526],"thread-4528":["thread",4528],"thread-4524":["thread",4524],"thread-4523":["thread",4523],"thread-4516":["thread",4516],"thread-4651":["thread",4651],"thread-4517":["thread",4517],"thread-4712":["thread",4712],"thread-4731":["thread",4731],"thread-4798":["thread",4798],"thread-4766":["thread",4766],"thread-4850":["thread",4850],"thread-4858":["thread",4858],"thread-4952":["thread",4952],"thread-4984":["thread",4984],"thread-4554":["thread",4554],"thread-4976":["thread",4976],"thread-4999":["thread",4999],"thread-4670":["thread",4670],"thread-3776":["thread",3776],"thread-3651":["thread",3651],"thread-3471":["thread",3471],"thread-3377":["thread",3377],"thread-3326":["thread",3326],"thread-3207":["thread",3207],"thread-3055":["thread",3055],"thread-3011":["thread",3011],"thread-2892":["thread",2892],"thread-2891":["thread",2891],"thread-2829":["thread",2829],"thread-2784":["thread",2784],"thread-2723":["thread",2723],"thread-2703":["thread",2703],"thread-2700":["thread",2700],"thread-2699":["thread",2699],"thread-2651":["thread",2651],"thread-2650":["thread",2650],"thread-2649":["thread",2649],"thread-2602":["thread",2602],"thread-2601":["thread",2601],"thread-2511":["thread",2511],"thread-2487":["thread",2487],"thread-2480":["thread",2480],"thread-2295":["thread",2295],"thread-2274":["thread",2274],"thread-2223":["thread",2223],"thread-2396":["thread",2396],"thread-2092":["thread",2092],"thread-2046":["thread",2046],"thread-2019":["thread",2019],"thread-1919":["thread",1919],"thread-1909":["thread",1909],"thread-1900":["thread",1900],"thread-1881":["thread",1881],"thread-1825":["thread",1825],"thread-1823":["thread",1823],"thread-1771":["thread",1771],"thread-1746":["thread",1746],"thread-1546":["thread",1546],"thread-1516":["thread",1516],"thread-1515":["thread",1515],"thread-1514":["thread",1514],"thread-1383":["thread",1383]}, , 1716177414
Run Time: 0.008475
- 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 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20