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 (213235, 160409, 159565, 13697, 13339, 13206, 13192, 13003, 12959, 12910, 12864, 12767, 12624, 12478, 12298, 12289, 12100, 12081, 12079, 12051, 12002, 11725, 11613, 11512, 11501, 11422, 11381, 11352, 11275, 11210, 11111, 11057, 10983, 10980, 10884, 10790, 10758, 10581, 10568, 10228, 10167, 10003, 9975, 9952, 9893, 9892, 9856, 9700, 9464, 9213, 9108, 8885, 8701, 8523, 8493, 8336, 8011, 7929, 7659, 7658, 7239, 6918, 6877, 6593, 6274, 6078, 5996, 5850, 5617, 5489, 5291, 4944, 4853, 4789, 4600, 4525, 4471, 4178, 4006, 3900, 3838, 3690, 3613, 3472, 3462, 3238, 2863, 2795, 2767, 2721, 2621, 2590, 2492, 2416, 2306, 2296, 2294, 1792, 1659, 1542, 1385, 1375, 1326, 1248, 1214, 1075, 920, 623, 213))
Run Time: 0.007078
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 109 | 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: 147, 0, 1714725094, {"thread-213235":["thread",213235],"thread-160409":["thread",160409],"thread-159565":["thread",159565],"thread-13697":["thread",13697],"thread-13339":["thread",13339],"thread-13206":["thread",13206],"thread-13192":["thread",13192],"thread-13003":["thread",13003],"thread-12959":["thread",12959],"thread-12910":["thread",12910],"thread-12864":["thread",12864],"thread-12767":["thread",12767],"thread-12624":["thread",12624],"thread-12478":["thread",12478],"thread-12298":["thread",12298],"thread-12289":["thread",12289],"thread-12100":["thread",12100],"thread-12081":["thread",12081],"thread-12079":["thread",12079],"thread-12051":["thread",12051],"thread-12002":["thread",12002],"thread-11725":["thread",11725],"thread-11613":["thread",11613],"thread-11512":["thread",11512],"thread-11501":["thread",11501],"thread-11422":["thread",11422],"thread-11381":["thread",11381],"thread-11352":["thread",11352],"thread-11275":["thread",11275],"thread-11210":["thread",11210],"thread-11111":["thread",11111],"thread-11057":["thread",11057],"thread-10983":["thread",10983],"thread-10980":["thread",10980],"thread-10884":["thread",10884],"thread-10790":["thread",10790],"thread-10758":["thread",10758],"thread-10581":["thread",10581],"thread-10568":["thread",10568],"thread-10228":["thread",10228],"thread-10167":["thread",10167],"thread-10003":["thread",10003],"thread-9975":["thread",9975],"thread-9952":["thread",9952],"thread-9893":["thread",9893],"thread-9892":["thread",9892],"thread-9856":["thread",9856],"thread-9700":["thread",9700],"thread-9464":["thread",9464],"thread-9213":["thread",9213],"thread-9108":["thread",9108],"thread-8885":["thread",8885],"thread-8701":["thread",8701],"thread-8523":["thread",8523],"thread-8493":["thread",8493],"thread-8336":["thread",8336],"thread-8011":["thread",8011],"thread-7929":["thread",7929],"thread-7659":["thread",7659],"thread-7658":["thread",7658],"thread-7239":["thread",7239],"thread-6918":["thread",6918],"thread-6877":["thread",6877],"thread-6593":["thread",6593],"thread-6274":["thread",6274],"thread-6078":["thread",6078],"thread-5996":["thread",5996],"thread-5850":["thread",5850],"thread-5617":["thread",5617],"thread-5489":["thread",5489],"thread-5291":["thread",5291],"thread-4944":["thread",4944],"thread-4853":["thread",4853],"thread-4789":["thread",4789],"thread-4600":["thread",4600],"thread-4525":["thread",4525],"thread-4471":["thread",4471],"thread-4178":["thread",4178],"thread-4006":["thread",4006],"thread-3900":["thread",3900],"thread-3838":["thread",3838],"thread-3690":["thread",3690],"thread-3613":["thread",3613],"thread-3472":["thread",3472],"thread-3462":["thread",3462],"thread-3238":["thread",3238],"thread-2863":["thread",2863],"thread-2795":["thread",2795],"thread-2767":["thread",2767],"thread-2721":["thread",2721],"thread-2621":["thread",2621],"thread-2590":["thread",2590],"thread-2492":["thread",2492],"thread-2416":["thread",2416],"thread-2306":["thread",2306],"thread-2296":["thread",2296],"thread-2294":["thread",2294],"thread-1792":["thread",1792],"thread-1659":["thread",1659],"thread-1542":["thread",1542],"thread-1385":["thread",1385],"thread-1375":["thread",1375],"thread-1326":["thread",1326],"thread-1248":["thread",1248],"thread-1214":["thread",1214],"thread-1075":["thread",1075],"thread-920":["thread",920],"thread-623":["thread",623],"thread-213":["thread",213]}, NULL, 1714721494
Run Time: 0.000406
- 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