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 (182323, 179909, 179529, 176909, 172318, 171082, 171005, 169519, 169518, 169460, 168411, 167226, 161903, 156859, 156167, 155255, 154926, 153842, 129824, 129133, 128984, 128780, 128554, 128545, 128488, 127873, 126992, 125625, 125612, 123648, 118940, 118028, 117946, 116507, 112667, 110768, 109908, 109121, 106972, 106785, 102411, 101803, 99571, 97181, 97135, 96353, 96035, 95565, 94381, 92772, 88577, 88386, 88368, 88346, 88343, 88342, 88341, 88340, 88176, 88172, 88161, 88159, 88152, 88145, 88137, 88081, 87967, 87961, 87906, 87905, 87900, 87383, 87098, 84626, 84420, 81676, 79219, 78851, 77504, 77187, 75672, 75395, 55488, 51579, 50961, 50922, 50146, 50136, 49679, 40326, 40325, 36645, 35347, 28557, 20603, 17485, 13779, 13777, 13691, 13688, 9770))
Run Time: 0.057726
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 101 | 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: 1632, 0, 1715701737, {"thread-182323":["thread",182323],"thread-179909":["thread",179909],"thread-179529":["thread",179529],"thread-176909":["thread",176909],"thread-172318":["thread",172318],"thread-171082":["thread",171082],"thread-171005":["thread",171005],"thread-169519":["thread",169519],"thread-168411":["thread",168411],"thread-167226":["thread",167226],"thread-161903":["thread",161903],"thread-156859":["thread",156859],"thread-156167":["thread",156167],"thread-155255":["thread",155255],"thread-154926":["thread",154926],"ams_article-4079":["ams_article",4079],"thread-153842":["thread",153842],"ams_article-3152":["ams_article",3152],"thread-129824":["thread",129824],"thread-129133":["thread",129133],"thread-128984":["thread",128984],"thread-128780":["thread",128780],"thread-128554":["thread",128554],"thread-128545":["thread",128545],"thread-128488":["thread",128488],"thread-127873":["thread",127873],"thread-126992":["thread",126992],"thread-125625":["thread",125625],"thread-125612":["thread",125612],"thread-123648":["thread",123648],"thread-118940":["thread",118940],"thread-118028":["thread",118028],"thread-117946":["thread",117946],"thread-112667":["thread",112667],"thread-110768":["thread",110768],"thread-109908":["thread",109908],"thread-109121":["thread",109121],"thread-106972":["thread",106972],"thread-102411":["thread",102411],"thread-101803":["thread",101803],"thread-99571":["thread",99571],"thread-97181":["thread",97181],"thread-97135":["thread",97135],"thread-96353":["thread",96353],"thread-96035":["thread",96035],"thread-94381":["thread",94381],"thread-92772":["thread",92772],"thread-88577":["thread",88577],"thread-88386":["thread",88386],"thread-88368":["thread",88368],"thread-88346":["thread",88346],"thread-88343":["thread",88343],"thread-88342":["thread",88342],"thread-88341":["thread",88341],"thread-88340":["thread",88340],"thread-88176":["thread",88176],"thread-88172":["thread",88172],"thread-88161":["thread",88161],"thread-88159":["thread",88159],"thread-88152":["thread",88152],"thread-88145":["thread",88145],"thread-88137":["thread",88137],"thread-88081":["thread",88081],"thread-87967":["thread",87967],"thread-87961":["thread",87961],"thread-87906":["thread",87906],"thread-87905":["thread",87905],"thread-87900":["thread",87900],"thread-87383":["thread",87383],"thread-87098":["thread",87098],"thread-84626":["thread",84626],"thread-81676":["thread",81676],"thread-79219":["thread",79219],"thread-78851":["thread",78851],"thread-77504":["thread",77504],"thread-77187":["thread",77187],"thread-55488":["thread",55488],"thread-51579":["thread",51579],"thread-50961":["thread",50961],"thread-50922":["thread",50922],"thread-50146":["thread",50146],"thread-49679":["thread",49679],"thread-40326":["thread",40326],"thread-36645":["thread",36645],"thread-35347":["thread",35347],"thread-28557":["thread",28557],"thread-20603":["thread",20603],"thread-17485":["thread",17485],"thread-13779":["thread",13779],"thread-13777":["thread",13777],"thread-13691":["thread",13691],"thread-13688":["thread",13688],"thread-9770":["thread",9770]}, , 1715698137
Run Time: 0.000759
- 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