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 (164441, 164435, 164399, 164389, 164214, 164213, 156114, 156104, 156092, 155981, 155818, 155758, 155058, 154901, 154900, 154899, 152380, 150965, 150610, 150597, 149164, 149163, 149161, 147724, 147508, 146056, 145370, 145369, 145025, 144858, 144579, 144534, 144453, 144451, 144450, 143723, 143696, 143428, 143426, 143423, 143422, 143420, 143034, 143033, 143030, 142860, 142859, 142858, 142827, 142825, 142823, 142822, 142590, 142520, 142422, 142421, 142420, 142372, 142370, 142367, 142366, 142330, 142125, 142074, 142071, 142070, 142026, 142025, 142024, 141974, 141973, 141972, 141971, 141959, 141887, 141886, 141885, 141884, 140737, 140736, 140735, 137146, 136252, 136132, 135969, 135608, 135224))
Run Time: 0.051340
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 87 | 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: 34821, 0, 1715988213, {"thread-164441":["thread",164441],"thread-164435":["thread",164435],"thread-164399":["thread",164399],"thread-164389":["thread",164389],"thread-164214":["thread",164214],"thread-164213":["thread",164213],"thread-156114":["thread",156114],"thread-156104":["thread",156104],"thread-156092":["thread",156092],"thread-155981":["thread",155981],"thread-155818":["thread",155818],"thread-155758":["thread",155758],"thread-155058":["thread",155058],"thread-154901":["thread",154901],"thread-154900":["thread",154900],"thread-154899":["thread",154899],"thread-152380":["thread",152380],"thread-150965":["thread",150965],"ams_article-3863":["ams_article",3863],"ams_article-3836":["ams_article",3836],"thread-150610":["thread",150610],"thread-150597":["thread",150597],"thread-149164":["thread",149164],"thread-149163":["thread",149163],"thread-149161":["thread",149161],"thread-147724":["thread",147724],"thread-147508":["thread",147508],"thread-146056":["thread",146056],"thread-145370":["thread",145370],"thread-145369":["thread",145369],"thread-145025":["thread",145025],"thread-144858":["thread",144858],"thread-144579":["thread",144579],"thread-144534":["thread",144534],"thread-144453":["thread",144453],"thread-144451":["thread",144451],"thread-144450":["thread",144450],"thread-143723":["thread",143723],"thread-143696":["thread",143696],"thread-143428":["thread",143428],"thread-143426":["thread",143426],"thread-143423":["thread",143423],"thread-143422":["thread",143422],"thread-143420":["thread",143420],"thread-143034":["thread",143034],"thread-143033":["thread",143033],"thread-143030":["thread",143030],"thread-142860":["thread",142860],"thread-142859":["thread",142859],"thread-142858":["thread",142858],"thread-142827":["thread",142827],"thread-142825":["thread",142825],"thread-142823":["thread",142823],"thread-142822":["thread",142822],"thread-142590":["thread",142590],"thread-142520":["thread",142520],"thread-142422":["thread",142422],"thread-142421":["thread",142421],"thread-142420":["thread",142420],"thread-142372":["thread",142372],"thread-142370":["thread",142370],"thread-142367":["thread",142367],"thread-142366":["thread",142366],"thread-142330":["thread",142330],"thread-142125":["thread",142125],"thread-142074":["thread",142074],"thread-142071":["thread",142071],"thread-142070":["thread",142070],"thread-142026":["thread",142026],"thread-142025":["thread",142025],"thread-142024":["thread",142024],"thread-141974":["thread",141974],"thread-141973":["thread",141973],"thread-141972":["thread",141972],"thread-141971":["thread",141971],"thread-141959":["thread",141959],"thread-141887":["thread",141887],"thread-141886":["thread",141886],"thread-141885":["thread",141885],"thread-141884":["thread",141884],"thread-140737":["thread",140737],"thread-140736":["thread",140736],"thread-140735":["thread",140735],"thread-137146":["thread",137146],"thread-136252":["thread",136252],"thread-136132":["thread",136132],"thread-135969":["thread",135969],"thread-135608":["thread",135608],"thread-135224":["thread",135224]}, , 1715984613
Run Time: 0.000362
- 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