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 (183441, 183308, 182978, 182946, 182821, 182768, 182519, 181801, 181718, 181638, 181624, 181331, 181198, 180003, 179777, 179540, 179035, 178693, 178496, 178413, 177853, 177684, 176510, 175247, 174496, 174154, 174130, 172417, 172379, 172342, 172087, 169929, 169920, 169612, 169172, 167868, 167241, 165362, 165352, 165260, 164743, 163663, 163661, 163310, 162180, 161565, 160888, 160699, 160185, 157429, 157345, 156678, 155867, 155409, 155118, 154597, 154435, 153624, 153278, 152368, 152188, 151886, 151706, 141653, 119988, 119764, 92286, 90917, 64395))
Run Time: 0.026300
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 69 | 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: 20469, 0, 1716101059, {"thread-183441":["thread",183441],"thread-183308":["thread",183308],"thread-182978":["thread",182978],"thread-182946":["thread",182946],"thread-182821":["thread",182821],"thread-182768":["thread",182768],"thread-182519":["thread",182519],"thread-181801":["thread",181801],"thread-181718":["thread",181718],"thread-181638":["thread",181638],"thread-181624":["thread",181624],"thread-181331":["thread",181331],"thread-181198":["thread",181198],"thread-180003":["thread",180003],"thread-179777":["thread",179777],"thread-179540":["thread",179540],"thread-179035":["thread",179035],"thread-178693":["thread",178693],"thread-178496":["thread",178496],"thread-178413":["thread",178413],"thread-177853":["thread",177853],"thread-177684":["thread",177684],"thread-176510":["thread",176510],"thread-175247":["thread",175247],"thread-174496":["thread",174496],"thread-174154":["thread",174154],"thread-174130":["thread",174130],"thread-172417":["thread",172417],"thread-172379":["thread",172379],"thread-172342":["thread",172342],"thread-172087":["thread",172087],"thread-169929":["thread",169929],"thread-169920":["thread",169920],"thread-169612":["thread",169612],"thread-169172":["thread",169172],"thread-167868":["thread",167868],"thread-167241":["thread",167241],"thread-165362":["thread",165362],"thread-165352":["thread",165352],"thread-165260":["thread",165260],"thread-164743":["thread",164743],"thread-163663":["thread",163663],"thread-163661":["thread",163661],"thread-163310":["thread",163310],"thread-162180":["thread",162180],"thread-161565":["thread",161565],"thread-160888":["thread",160888],"thread-160699":["thread",160699],"thread-160185":["thread",160185],"thread-157429":["thread",157429],"thread-157345":["thread",157345],"thread-156678":["thread",156678],"thread-155867":["thread",155867],"thread-155409":["thread",155409],"thread-155118":["thread",155118],"thread-154597":["thread",154597],"thread-154435":["thread",154435],"thread-153624":["thread",153624],"thread-153278":["thread",153278],"thread-152368":["thread",152368],"thread-152188":["thread",152188],"thread-151886":["thread",151886],"thread-141653":["thread",141653],"thread-119988":["thread",119988],"thread-119764":["thread",119764],"thread-92286":["thread",92286],"thread-90917":["thread",90917],"thread-64395":["thread",64395]}, , 1716097459
Run Time: 0.000230
- 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