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 (183299, 180565, 178618, 178364, 177151, 176964, 176127, 175791, 175774, 175409, 173442, 173166, 170271, 170146, 169887, 168699, 165028, 164208, 163981, 163945, 163938, 161653, 158637, 158130, 157188, 156824, 155362, 155349, 155279, 154368, 153123, 152931, 144272, 143784, 138307, 135073, 132633, 131731, 129999, 127389, 124901, 121875, 121186, 118821, 118471, 117421, 117159, 113061, 112683, 108995, 108577, 98463, 98381, 98188, 91480, 90724, 84628, 83473, 78632, 78332, 78327, 77269, 75750, 75714, 74774, 74421, 71490, 69068, 68171, 68089, 63589, 56924, 56603, 56601, 56224, 53344, 52795, 50237, 49262, 48523, 48248, 47542, 47484, 46628, 44564, 38930, 38522, 35858, 33247, 31910, 31203, 20832, 18933, 18025, 18024, 17642, 337))
Run Time: 0.061901
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 97 | 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: 1320, 0, 1715984845, {"thread-183299":["thread",183299],"thread-180565":["thread",180565],"thread-178618":["thread",178618],"thread-178364":["thread",178364],"thread-177151":["thread",177151],"thread-176964":["thread",176964],"thread-176127":["thread",176127],"thread-175791":["thread",175791],"thread-175774":["thread",175774],"thread-175409":["thread",175409],"thread-173442":["thread",173442],"thread-173166":["thread",173166],"thread-170271":["thread",170271],"thread-170146":["thread",170146],"thread-169887":["thread",169887],"thread-168699":["thread",168699],"thread-165028":["thread",165028],"thread-164208":["thread",164208],"thread-163981":["thread",163981],"thread-163945":["thread",163945],"thread-163938":["thread",163938],"tl_group-202":["tl_group",202],"thread-161653":["thread",161653],"thread-158637":["thread",158637],"thread-158130":["thread",158130],"thread-157188":["thread",157188],"thread-156824":["thread",156824],"thread-155362":["thread",155362],"thread-155349":["thread",155349],"thread-155279":["thread",155279],"thread-154368":["thread",154368],"thread-153123":["thread",153123],"thread-152931":["thread",152931],"thread-144272":["thread",144272],"thread-143784":["thread",143784],"thread-138307":["thread",138307],"thread-135073":["thread",135073],"thread-132633":["thread",132633],"thread-131731":["thread",131731],"thread-129999":["thread",129999],"thread-127389":["thread",127389],"thread-124901":["thread",124901],"thread-121875":["thread",121875],"thread-121186":["thread",121186],"thread-118821":["thread",118821],"thread-118471":["thread",118471],"thread-117421":["thread",117421],"thread-117159":["thread",117159],"thread-113061":["thread",113061],"thread-112683":["thread",112683],"thread-108995":["thread",108995],"thread-108577":["thread",108577],"thread-98463":["thread",98463],"thread-98381":["thread",98381],"thread-98188":["thread",98188],"thread-91480":["thread",91480],"thread-90724":["thread",90724],"thread-84628":["thread",84628],"thread-83473":["thread",83473],"thread-78632":["thread",78632],"thread-78332":["thread",78332],"thread-78327":["thread",78327],"thread-77269":["thread",77269],"thread-75750":["thread",75750],"thread-75714":["thread",75714],"thread-74774":["thread",74774],"thread-74421":["thread",74421],"thread-71490":["thread",71490],"thread-69068":["thread",69068],"thread-68171":["thread",68171],"thread-68089":["thread",68089],"thread-63589":["thread",63589],"thread-56924":["thread",56924],"thread-56603":["thread",56603],"thread-56601":["thread",56601],"thread-56224":["thread",56224],"thread-53344":["thread",53344],"thread-52795":["thread",52795],"thread-50237":["thread",50237],"thread-49262":["thread",49262],"thread-48523":["thread",48523],"thread-48248":["thread",48248],"thread-47542":["thread",47542],"thread-47484":["thread",47484],"thread-46628":["thread",46628],"thread-44564":["thread",44564],"thread-38930":["thread",38930],"thread-38522":["thread",38522],"thread-35858":["thread",35858],"thread-33247":["thread",33247],"thread-31910":["thread",31910],"thread-31203":["thread",31203],"thread-20832":["thread",20832],"thread-18933":["thread",18933],"thread-18025":["thread",18025],"thread-18024":["thread",18024],"thread-17642":["thread",17642],"thread-337":["thread",337]}, , 1715981245
Run Time: 0.000559
- 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