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 (44915, 42565, 41979, 41919, 40441, 40421, 37104, 37040, 36798, 36673, 36496, 35971, 34946, 34462, 34291, 34160, 33992, 32353, 32163, 32062, 32013, 31414, 31250, 31243, 31230, 31071, 30803, 30523, 29431, 28643, 28590, 28560, 28152, 27960, 27918, 27497, 27457, 27112, 26146, 26132, 25996, 25981, 25089, 25018, 23568, 23554, 23395, 22763, 22458, 21197, 20418, 20109, 18892, 18820, 18819, 18709, 18395, 18052, 17830, 17763, 17734, 16967, 16584, 16573, 16501, 16442, 15829, 15549, 14689, 14644, 14510, 14478, 14375, 14238, 12853, 12743, 12647, 12196, 11992, 11496, 11296, 10538, 7432, 7396, 7290, 6851, 6178, 5221, 5185, 4992, 4892, 4392, 3538, 3273, 3250, 2966, 2928, 2518, 2236, 2180, 2144, 2121, 12296, 1288, 1061, 611, 602, 431, 353, 232, 148, 147, 133, 85))
Run Time: 0.048059
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: 126, 0, 1715944728, {"thread-44915":["thread",44915],"thread-42565":["thread",42565],"thread-41979":["thread",41979],"thread-41919":["thread",41919],"thread-40441":["thread",40441],"thread-40421":["thread",40421],"thread-37104":["thread",37104],"thread-37040":["thread",37040],"thread-36798":["thread",36798],"thread-36673":["thread",36673],"thread-36496":["thread",36496],"thread-35971":["thread",35971],"thread-34946":["thread",34946],"thread-34462":["thread",34462],"thread-34291":["thread",34291],"thread-34160":["thread",34160],"thread-33992":["thread",33992],"thread-32353":["thread",32353],"thread-32163":["thread",32163],"thread-32062":["thread",32062],"thread-32013":["thread",32013],"thread-31414":["thread",31414],"thread-31250":["thread",31250],"thread-31243":["thread",31243],"thread-31230":["thread",31230],"thread-31071":["thread",31071],"thread-30803":["thread",30803],"thread-30523":["thread",30523],"thread-29431":["thread",29431],"thread-28643":["thread",28643],"thread-28590":["thread",28590],"thread-28560":["thread",28560],"thread-28152":["thread",28152],"thread-27960":["thread",27960],"thread-27918":["thread",27918],"thread-27497":["thread",27497],"thread-27457":["thread",27457],"thread-27112":["thread",27112],"thread-26146":["thread",26146],"thread-26132":["thread",26132],"thread-25996":["thread",25996],"thread-25981":["thread",25981],"thread-25089":["thread",25089],"thread-25018":["thread",25018],"thread-23568":["thread",23568],"thread-23554":["thread",23554],"thread-23395":["thread",23395],"thread-22763":["thread",22763],"thread-22458":["thread",22458],"thread-21197":["thread",21197],"thread-20418":["thread",20418],"thread-20109":["thread",20109],"thread-18892":["thread",18892],"thread-18820":["thread",18820],"thread-18819":["thread",18819],"thread-18709":["thread",18709],"thread-18395":["thread",18395],"thread-18052":["thread",18052],"thread-17830":["thread",17830],"thread-17763":["thread",17763],"thread-17734":["thread",17734],"thread-16967":["thread",16967],"thread-16584":["thread",16584],"thread-16573":["thread",16573],"thread-16501":["thread",16501],"thread-16442":["thread",16442],"thread-15829":["thread",15829],"thread-15549":["thread",15549],"thread-14689":["thread",14689],"thread-14644":["thread",14644],"thread-14510":["thread",14510],"thread-14478":["thread",14478],"thread-14375":["thread",14375],"thread-14238":["thread",14238],"thread-12853":["thread",12853],"thread-12743":["thread",12743],"thread-12647":["thread",12647],"thread-12196":["thread",12196],"thread-11496":["thread",11496],"thread-11296":["thread",11296],"thread-10538":["thread",10538],"thread-7432":["thread",7432],"thread-7396":["thread",7396],"thread-7290":["thread",7290],"thread-6851":["thread",6851],"thread-6178":["thread",6178],"thread-5221":["thread",5221],"thread-5185":["thread",5185],"thread-4992":["thread",4992],"thread-4892":["thread",4892],"thread-4392":["thread",4392],"thread-3538":["thread",3538],"thread-3273":["thread",3273],"thread-3250":["thread",3250],"thread-2966":["thread",2966],"thread-2928":["thread",2928],"thread-2518":["thread",2518],"thread-2236":["thread",2236],"thread-2180":["thread",2180],"thread-2144":["thread",2144],"thread-2121":["thread",2121],"thread-12296":["thread",12296],"thread-1288":["thread",1288],"thread-1061":["thread",1061],"thread-611":["thread",611],"thread-602":["thread",602],"thread-431":["thread",431],"thread-353":["thread",353],"thread-232":["thread",232],"thread-148":["thread",148],"thread-147":["thread",147],"thread-133":["thread",133],"thread-85":["thread",85]}, NULL, 1715941128
Run Time: 0.000599
- 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