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 (160283, 160120, 158883, 157942, 156997, 156962, 156147, 155720, 155077, 154825, 154718, 154288, 152596, 152475, 152107, 152106, 152104, 152102, 151896, 151518, 151404, 151254, 151253, 150555, 150553, 150552, 149906, 149748, 148490, 148234, 148233, 148232, 148231, 148230, 148227, 148225, 148220, 148219, 148126, 147574, 147380, 146883, 146780, 146506, 146208, 146120, 145996, 145409, 145269, 145229, 145228, 145187, 145040, 144959, 144860, 144611, 144538, 144509, 144460, 144077, 143810, 143557, 143551, 143412, 143045, 142756, 142270, 141415, 141414, 141358, 141357, 141083, 139625))
Run Time: 0.048216
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 73 | 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: 35897, 0, 1714884754, {"ams_article-4591":["ams_article",4591],"thread-160283":["thread",160283],"thread-160120":["thread",160120],"thread-158883":["thread",158883],"ams_article-4341":["ams_article",4341],"thread-157942":["thread",157942],"thread-156997":["thread",156997],"thread-156962":["thread",156962],"thread-156147":["thread",156147],"thread-155720":["thread",155720],"thread-155077":["thread",155077],"thread-154825":["thread",154825],"thread-154718":["thread",154718],"thread-154288":["thread",154288],"ams_article-3981":["ams_article",3981],"thread-152596":["thread",152596],"thread-152475":["thread",152475],"thread-152107":["thread",152107],"thread-152106":["thread",152106],"thread-152104":["thread",152104],"thread-152102":["thread",152102],"thread-151896":["thread",151896],"thread-151518":["thread",151518],"thread-151404":["thread",151404],"thread-151254":["thread",151254],"thread-151253":["thread",151253],"thread-150555":["thread",150555],"thread-150553":["thread",150553],"thread-150552":["thread",150552],"thread-149906":["thread",149906],"thread-149748":["thread",149748],"thread-148490":["thread",148490],"thread-148234":["thread",148234],"thread-148233":["thread",148233],"thread-148232":["thread",148232],"thread-148231":["thread",148231],"thread-148230":["thread",148230],"thread-148227":["thread",148227],"thread-148225":["thread",148225],"thread-148220":["thread",148220],"thread-148219":["thread",148219],"thread-148126":["thread",148126],"thread-147574":["thread",147574],"thread-147380":["thread",147380],"thread-146883":["thread",146883],"ams_article-3541":["ams_article",3541],"thread-146780":["thread",146780],"thread-146506":["thread",146506],"thread-146208":["thread",146208],"thread-146120":["thread",146120],"thread-145996":["thread",145996],"thread-145409":["thread",145409],"thread-145269":["thread",145269],"thread-145229":["thread",145229],"thread-145228":["thread",145228],"thread-145187":["thread",145187],"thread-145040":["thread",145040],"thread-144959":["thread",144959],"thread-144860":["thread",144860],"thread-144611":["thread",144611],"thread-144538":["thread",144538],"thread-144509":["thread",144509],"thread-144460":["thread",144460],"thread-144077":["thread",144077],"thread-143810":["thread",143810],"thread-143557":["thread",143557],"thread-143551":["thread",143551],"thread-143412":["thread",143412],"ams_article-3330":["ams_article",3330],"thread-143045":["thread",143045],"thread-142756":["thread",142756],"thread-142270":["thread",142270],"ams_article-3262":["ams_article",3262],"thread-141415":["thread",141415],"thread-141414":["thread",141414],"thread-141358":["thread",141358],"thread-141357":["thread",141357],"thread-141083":["thread",141083],"thread-139625":["thread",139625]}, , 1714881154
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 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