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 (182075, 181876, 181203, 174422, 172303, 166862, 166491, 165297, 165276, 165187, 165186, 164862, 164861, 161969, 161924, 161852, 161510, 161507, 161458, 161245, 161239, 161030, 161028, 161023, 161014, 161010, 161006, 160996, 160995, 159749, 159374, 158509, 158476, 154908, 154841, 154561, 154454, 154452, 154451, 154445, 154444, 154442, 154440, 154439, 154438, 154437, 154435, 154434, 154432, 154431, 154417, 151820, 146620, 144761, 142963, 140262, 140167, 139154, 136269, 136268, 136231, 136230, 136135, 136133, 136089, 136080, 136038, 133664, 131598, 131383, 131071, 130933, 130904, 130837, 130822, 130633, 130604, 130525, 130297, 130272, 130268, 130163, 130151, 130124, 126761, 125929, 125568, 119216, 118930, 114655, 114165, 113534, 113307, 113167, 112938, 112820, 112741, 112464, 110607, 109502, 107205, 105524, 104170, 103287, 97439, 97313, 94026, 93816, 93074, 92796, 86948, 85341, 67068, 61542, 36150))
Run Time: 0.075477
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 115 | 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: 11039, 0, 1715316460, {"thread-182075":["thread",182075],"thread-181876":["thread",181876],"thread-181203":["thread",181203],"thread-174422":["thread",174422],"thread-172303":["thread",172303],"thread-166862":["thread",166862],"thread-166491":["thread",166491],"thread-165297":["thread",165297],"thread-165276":["thread",165276],"thread-165187":["thread",165187],"thread-165186":["thread",165186],"thread-164862":["thread",164862],"thread-164861":["thread",164861],"thread-161969":["thread",161969],"thread-161924":["thread",161924],"thread-161852":["thread",161852],"thread-161510":["thread",161510],"thread-161507":["thread",161507],"thread-161458":["thread",161458],"thread-161245":["thread",161245],"thread-161239":["thread",161239],"thread-161030":["thread",161030],"thread-161028":["thread",161028],"thread-161023":["thread",161023],"thread-161014":["thread",161014],"thread-161010":["thread",161010],"thread-161006":["thread",161006],"thread-160996":["thread",160996],"thread-160995":["thread",160995],"thread-159749":["thread",159749],"thread-159374":["thread",159374],"thread-158509":["thread",158509],"thread-158476":["thread",158476],"thread-154908":["thread",154908],"thread-154841":["thread",154841],"thread-154561":["thread",154561],"thread-154454":["thread",154454],"thread-154452":["thread",154452],"thread-154451":["thread",154451],"thread-154445":["thread",154445],"thread-154444":["thread",154444],"thread-154442":["thread",154442],"thread-154440":["thread",154440],"thread-154439":["thread",154439],"thread-154438":["thread",154438],"thread-154437":["thread",154437],"thread-154435":["thread",154435],"thread-154434":["thread",154434],"thread-154432":["thread",154432],"thread-154431":["thread",154431],"thread-154417":["thread",154417],"thread-151820":["thread",151820],"thread-146620":["thread",146620],"thread-144761":["thread",144761],"thread-142963":["thread",142963],"thread-140262":["thread",140262],"thread-140167":["thread",140167],"thread-139154":["thread",139154],"thread-136269":["thread",136269],"thread-136268":["thread",136268],"thread-136231":["thread",136231],"thread-136230":["thread",136230],"thread-136135":["thread",136135],"thread-136133":["thread",136133],"thread-136089":["thread",136089],"thread-136080":["thread",136080],"thread-136038":["thread",136038],"thread-133664":["thread",133664],"thread-131598":["thread",131598],"thread-131383":["thread",131383],"thread-131071":["thread",131071],"thread-130933":["thread",130933],"thread-130904":["thread",130904],"thread-130837":["thread",130837],"thread-130822":["thread",130822],"thread-130633":["thread",130633],"thread-130604":["thread",130604],"thread-130525":["thread",130525],"thread-130297":["thread",130297],"thread-130272":["thread",130272],"thread-130268":["thread",130268],"thread-130163":["thread",130163],"thread-130151":["thread",130151],"thread-130124":["thread",130124],"thread-126761":["thread",126761],"thread-125929":["thread",125929],"thread-125568":["thread",125568],"thread-119216":["thread",119216],"thread-118930":["thread",118930],"thread-114655":["thread",114655],"thread-114165":["thread",114165],"thread-113534":["thread",113534],"thread-113307":["thread",113307],"thread-113167":["thread",113167],"thread-112938":["thread",112938],"thread-112820":["thread",112820],"thread-112741":["thread",112741],"thread-112464":["thread",112464],"thread-110607":["thread",110607],"thread-109502":["thread",109502],"thread-107205":["thread",107205],"thread-105524":["thread",105524],"thread-104170":["thread",104170],"thread-103287":["thread",103287],"thread-97439":["thread",97439],"thread-97313":["thread",97313],"thread-94026":["thread",94026],"thread-93816":["thread",93816],"thread-93074":["thread",93074],"thread-92796":["thread",92796],"thread-86948":["thread",86948],"thread-85341":["thread",85341],"thread-67068":["thread",67068],"thread-61542":["thread",61542],"thread-36150":["thread",36150]}, , 1715312860
Run Time: 0.001135
- 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