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 (169913, 159973, 159972, 159971, 126341, 126249, 126227, 124678, 121669, 121487, 121176, 120222, 120220, 119963, 119852, 119744, 119630, 119451, 119300, 119298, 119216, 119076, 119073, 118930, 118928, 118783, 118778, 118718, 117694, 117548, 117180, 115750, 115689, 115684, 115634, 115522, 115230, 115115, 114911, 114909, 114397, 114328, 114327, 114220, 114194, 114193, 114165, 114035, 114030, 113922, 112371, 111252, 111251))
Run Time: 0.031286
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 53 | 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: 26633, 0, 1716484980, {"thread-169913":["thread",169913],"thread-159973":["thread",159973],"thread-159972":["thread",159972],"thread-159971":["thread",159971],"tl_group-168":["tl_group",168],"thread-126341":["thread",126341],"thread-126249":["thread",126249],"thread-126227":["thread",126227],"thread-124678":["thread",124678],"thread-121669":["thread",121669],"thread-121487":["thread",121487],"thread-121176":["thread",121176],"thread-120222":["thread",120222],"thread-120220":["thread",120220],"thread-119963":["thread",119963],"thread-119852":["thread",119852],"thread-119744":["thread",119744],"thread-119630":["thread",119630],"thread-119451":["thread",119451],"thread-119300":["thread",119300],"thread-119298":["thread",119298],"thread-119216":["thread",119216],"thread-119076":["thread",119076],"thread-119073":["thread",119073],"thread-118930":["thread",118930],"thread-118928":["thread",118928],"thread-118783":["thread",118783],"thread-118778":["thread",118778],"thread-118718":["thread",118718],"thread-117694":["thread",117694],"thread-117548":["thread",117548],"thread-117180":["thread",117180],"thread-115750":["thread",115750],"thread-115689":["thread",115689],"thread-115684":["thread",115684],"thread-115634":["thread",115634],"thread-115522":["thread",115522],"thread-115230":["thread",115230],"thread-115115":["thread",115115],"thread-114911":["thread",114911],"thread-114909":["thread",114909],"thread-114397":["thread",114397],"thread-114328":["thread",114328],"thread-114327":["thread",114327],"thread-114220":["thread",114220],"thread-114194":["thread",114194],"thread-114193":["thread",114193],"thread-114165":["thread",114165],"thread-114035":["thread",114035],"thread-114030":["thread",114030],"thread-113922":["thread",113922],"thread-112371":["thread",112371],"thread-111252":["thread",111252],"thread-111251":["thread",111251]}, , 1716481380
Run Time: 0.000212
- 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