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 (173989, 173059, 154314, 154312, 153535, 152453, 146145, 143001, 142976, 142503, 140917, 140315, 139277, 138454, 138447, 138446, 138443, 137788, 137785, 135863, 134525, 131969, 131438, 127673, 127612, 127327, 127324, 127321, 126908, 126745, 124524, 98750, 95823, 82359, 82290, 73937, 71185, 70609, 69922, 69503, 69034, 68727, 68481, 68350, 68269, 68025, 67976, 67636, 67523, 67520, 67465, 67269, 67050, 66884, 66815, 66266, 65529, 64245, 64244, 64151, 62865, 62661))
Run Time: 0.038146
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 62 | 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: 11255, 0, 1715917556, {"thread-173989":["thread",173989],"thread-173059":["thread",173059],"thread-154314":["thread",154314],"thread-154312":["thread",154312],"thread-153535":["thread",153535],"thread-152453":["thread",152453],"thread-146145":["thread",146145],"thread-143001":["thread",143001],"thread-142976":["thread",142976],"thread-142503":["thread",142503],"thread-140917":["thread",140917],"thread-140315":["thread",140315],"thread-139277":["thread",139277],"thread-138454":["thread",138454],"thread-138447":["thread",138447],"thread-138446":["thread",138446],"thread-138443":["thread",138443],"thread-137788":["thread",137788],"thread-137785":["thread",137785],"thread-135863":["thread",135863],"thread-134525":["thread",134525],"thread-131969":["thread",131969],"thread-131438":["thread",131438],"thread-127673":["thread",127673],"thread-127612":["thread",127612],"thread-127327":["thread",127327],"thread-127324":["thread",127324],"thread-127321":["thread",127321],"thread-126908":["thread",126908],"thread-126745":["thread",126745],"thread-124524":["thread",124524],"thread-98750":["thread",98750],"thread-95823":["thread",95823],"thread-82359":["thread",82359],"thread-82290":["thread",82290],"thread-73937":["thread",73937],"thread-71185":["thread",71185],"thread-70609":["thread",70609],"thread-69922":["thread",69922],"thread-69503":["thread",69503],"thread-69034":["thread",69034],"thread-68727":["thread",68727],"thread-68481":["thread",68481],"thread-68350":["thread",68350],"thread-68269":["thread",68269],"thread-68025":["thread",68025],"thread-67976":["thread",67976],"thread-67636":["thread",67636],"thread-67523":["thread",67523],"thread-67520":["thread",67520],"thread-67465":["thread",67465],"thread-67269":["thread",67269],"thread-67050":["thread",67050],"thread-66884":["thread",66884],"thread-66815":["thread",66815],"thread-66266":["thread",66266],"thread-65529":["thread",65529],"thread-64245":["thread",64245],"thread-64244":["thread",64244],"thread-64151":["thread",64151],"thread-62865":["thread",62865],"thread-62661":["thread",62661]}, , 1715913956
Run Time: 0.000175
- 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