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 (183015, 182361, 182344, 180793, 175663, 175072, 173109, 172766, 171615, 170102, 170101, 169897, 169005, 168990, 168979, 168973, 168785, 167680, 167671, 167288, 166724, 166713, 166206, 166162, 166058, 165001, 164948, 164692, 164665, 163984, 162842, 162417, 162415, 161366, 161361, 160801, 160670, 159257, 159256, 159254, 159130, 158694, 158353, 158040, 157972, 157567, 157452, 157397, 157145, 157120, 157073, 156969, 156769, 156765, 156698, 156696, 156586, 156474, 156313, 156278, 156139, 156105, 156027, 155797, 155583, 155582, 155378, 155376, 155374, 155373, 155367, 155347, 155277, 155174, 154692, 154053, 153923, 153809, 153747, 153624, 153106, 152925, 152899, 152227, 152153, 99992))
Run Time: 0.070280
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 86 | 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: 22964, 0, 1716694575, {"thread-183015":["thread",183015],"thread-182361":["thread",182361],"thread-182344":["thread",182344],"thread-180793":["thread",180793],"thread-175663":["thread",175663],"thread-175072":["thread",175072],"thread-173109":["thread",173109],"thread-172766":["thread",172766],"thread-171615":["thread",171615],"thread-170102":["thread",170102],"thread-170101":["thread",170101],"thread-169897":["thread",169897],"thread-169005":["thread",169005],"thread-168990":["thread",168990],"thread-168979":["thread",168979],"thread-168973":["thread",168973],"thread-168785":["thread",168785],"thread-167680":["thread",167680],"thread-167671":["thread",167671],"thread-167288":["thread",167288],"thread-166724":["thread",166724],"thread-166713":["thread",166713],"thread-166206":["thread",166206],"thread-166162":["thread",166162],"thread-166058":["thread",166058],"thread-165001":["thread",165001],"thread-164948":["thread",164948],"thread-164692":["thread",164692],"thread-164665":["thread",164665],"thread-163984":["thread",163984],"thread-162842":["thread",162842],"thread-162417":["thread",162417],"thread-162415":["thread",162415],"thread-161366":["thread",161366],"thread-161361":["thread",161361],"thread-160801":["thread",160801],"thread-160670":["thread",160670],"thread-159257":["thread",159257],"thread-159256":["thread",159256],"thread-159254":["thread",159254],"thread-159130":["thread",159130],"thread-158694":["thread",158694],"thread-158353":["thread",158353],"thread-158040":["thread",158040],"thread-157972":["thread",157972],"thread-157567":["thread",157567],"thread-157452":["thread",157452],"thread-157397":["thread",157397],"thread-157145":["thread",157145],"thread-157120":["thread",157120],"thread-157073":["thread",157073],"thread-156969":["thread",156969],"thread-156769":["thread",156769],"thread-156765":["thread",156765],"thread-156698":["thread",156698],"thread-156696":["thread",156696],"thread-156586":["thread",156586],"thread-156474":["thread",156474],"thread-156313":["thread",156313],"thread-156278":["thread",156278],"thread-156139":["thread",156139],"thread-156105":["thread",156105],"thread-156027":["thread",156027],"thread-155797":["thread",155797],"thread-155583":["thread",155583],"thread-155582":["thread",155582],"thread-155378":["thread",155378],"thread-155376":["thread",155376],"thread-155374":["thread",155374],"thread-155373":["thread",155373],"thread-155367":["thread",155367],"thread-155347":["thread",155347],"thread-155277":["thread",155277],"thread-155174":["thread",155174],"thread-154692":["thread",154692],"thread-154053":["thread",154053],"thread-153923":["thread",153923],"thread-153809":["thread",153809],"thread-153747":["thread",153747],"thread-153624":["thread",153624],"thread-153106":["thread",153106],"thread-152925":["thread",152925],"thread-152899":["thread",152899],"thread-152227":["thread",152227],"thread-152153":["thread",152153],"thread-99992":["thread",99992]}, , 1716690975
Run Time: 0.000594
- 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