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 (45043, 43529, 42634, 41591, 40442, 39202, 39143, 38676, 38665, 38143, 37933, 37608, 37200, 37083, 36074, 35942, 35471, 35251, 35228, 34917, 34396, 33782, 33779, 33445, 33204, 32723, 32442, 31861, 31783, 31732, 31681, 31594, 31364, 31282, 30784, 30088, 29196, 28625, 28417, 27809, 26571, 25059, 24959, 24379, 24240, 24136, 23902, 22602, 22340, 22054, 21581, 20032, 19919, 19917, 19849, 19656, 19421, 19348, 19244, 18680, 18088, 18065, 16743, 16737, 16530, 16267, 16262, 14398, 13294, 13288, 12364, 12057, 10942, 10626, 10582, 10080, 10018, 9939, 8516, 8465, 8453, 8725, 8023, 7901, 7668, 8682, 7444, 7224, 6840, 6837, 6227, 6196, 6164, 5865, 5809, 5669, 5253, 4784, 4656, 4029, 4004, 3992, 3406, 2982, 2394, 2206, 2130, 1916, 1492, 1463, 1191, 903, 220, 38))
Run Time: 0.040489
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 114 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,squattheplanet.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 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: 322, 0, 1716030048, {"thread-45043":["thread",45043],"thread-42634":["thread",42634],"thread-41591":["thread",41591],"thread-39202":["thread",39202],"thread-39143":["thread",39143],"thread-38665":["thread",38665],"thread-38143":["thread",38143],"thread-37933":["thread",37933],"thread-37608":["thread",37608],"thread-37200":["thread",37200],"thread-37083":["thread",37083],"thread-36074":["thread",36074],"thread-35942":["thread",35942],"thread-35471":["thread",35471],"thread-35251":["thread",35251],"thread-35228":["thread",35228],"thread-34917":["thread",34917],"thread-34396":["thread",34396],"thread-33782":["thread",33782],"thread-33779":["thread",33779],"thread-33445":["thread",33445],"thread-32723":["thread",32723],"thread-32442":["thread",32442],"thread-31861":["thread",31861],"thread-31783":["thread",31783],"thread-31732":["thread",31732],"thread-31681":["thread",31681],"thread-31594":["thread",31594],"thread-31364":["thread",31364],"thread-31282":["thread",31282],"thread-30784":["thread",30784],"thread-30088":["thread",30088],"thread-29196":["thread",29196],"thread-28625":["thread",28625],"thread-28417":["thread",28417],"thread-27809":["thread",27809],"thread-26571":["thread",26571],"thread-25059":["thread",25059],"thread-24959":["thread",24959],"thread-24379":["thread",24379],"thread-24136":["thread",24136],"thread-23902":["thread",23902],"thread-22602":["thread",22602],"thread-22340":["thread",22340],"thread-22054":["thread",22054],"thread-21581":["thread",21581],"thread-20032":["thread",20032],"thread-19919":["thread",19919],"thread-19917":["thread",19917],"thread-19849":["thread",19849],"thread-19656":["thread",19656],"thread-19421":["thread",19421],"thread-19348":["thread",19348],"thread-19244":["thread",19244],"thread-18680":["thread",18680],"thread-18065":["thread",18065],"thread-16743":["thread",16743],"thread-16737":["thread",16737],"thread-16530":["thread",16530],"thread-16267":["thread",16267],"thread-16262":["thread",16262],"thread-14398":["thread",14398],"thread-13294":["thread",13294],"thread-13288":["thread",13288],"thread-12364":["thread",12364],"thread-12057":["thread",12057],"thread-10942":["thread",10942],"thread-10626":["thread",10626],"thread-10582":["thread",10582],"thread-10080":["thread",10080],"thread-10018":["thread",10018],"thread-9939":["thread",9939],"thread-8516":["thread",8516],"thread-8465":["thread",8465],"thread-8453":["thread",8453],"thread-8725":["thread",8725],"thread-8023":["thread",8023],"thread-7901":["thread",7901],"thread-7668":["thread",7668],"thread-8682":["thread",8682],"thread-7444":["thread",7444],"thread-7224":["thread",7224],"thread-6840":["thread",6840],"thread-6837":["thread",6837],"thread-6227":["thread",6227],"thread-6196":["thread",6196],"thread-6164":["thread",6164],"thread-5865":["thread",5865],"thread-5809":["thread",5809],"thread-5669":["thread",5669],"thread-5253":["thread",5253],"thread-4784":["thread",4784],"thread-4656":["thread",4656],"thread-4029":["thread",4029],"thread-4004":["thread",4004],"thread-3992":["thread",3992],"thread-3406":["thread",3406],"thread-2982":["thread",2982],"thread-2394":["thread",2394],"thread-2206":["thread",2206],"thread-2130":["thread",2130],"thread-1916":["thread",1916],"thread-1492":["thread",1492],"thread-1463":["thread",1463],"thread-1191":["thread",1191],"thread-903":["thread",903],"thread-220":["thread",220],"thread-38":["thread",38]}, NULL, 1716026448
Run Time: 0.001851
- 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