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 (93313, 78240, 78172, 78094, 77673, 76111, 74545, 74256, 74160, 73776, 72226, 72225, 72204, 72193, 71798, 71067, 70919, 70827, 70690, 70512, 70491, 70195, 69761, 69698, 69697, 69695, 69562, 69319, 69196, 68273, 68259, 68067, 66984, 66752, 66509, 66475, 66384, 66223, 66028, 65910, 65875, 65475, 64986, 64854, 64822, 64171, 63780, 63666, 62933, 62623, 62218, 60450, 60442, 58827, 58599, 58562, 58227, 58110, 57974, 57352, 57221, 56771, 56692, 55800, 55797, 55206, 54364, 53326, 53273, 53263, 53201, 53129, 52885, 52250, 51780, 51756, 51637, 51632, 51042, 51041, 50480, 50220, 50186, 50143, 49998, 49634, 49629, 49626, 49572, 49469, 49348, 49264, 49215, 49208))
Run Time: 0.054087
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 94 | 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: 7597, 0, 1715987207, {"thread-93313":["thread",93313],"thread-78240":["thread",78240],"thread-78172":["thread",78172],"thread-78094":["thread",78094],"thread-77673":["thread",77673],"thread-76111":["thread",76111],"thread-74545":["thread",74545],"thread-74256":["thread",74256],"thread-74160":["thread",74160],"thread-73776":["thread",73776],"thread-72226":["thread",72226],"thread-72225":["thread",72225],"thread-72204":["thread",72204],"thread-72193":["thread",72193],"thread-71798":["thread",71798],"thread-71067":["thread",71067],"thread-70919":["thread",70919],"thread-70827":["thread",70827],"thread-70690":["thread",70690],"thread-70512":["thread",70512],"thread-70491":["thread",70491],"thread-70195":["thread",70195],"thread-69761":["thread",69761],"thread-69698":["thread",69698],"thread-69697":["thread",69697],"thread-69695":["thread",69695],"thread-69562":["thread",69562],"thread-69319":["thread",69319],"thread-69196":["thread",69196],"thread-68273":["thread",68273],"thread-68259":["thread",68259],"thread-68067":["thread",68067],"thread-66984":["thread",66984],"thread-66752":["thread",66752],"thread-66509":["thread",66509],"thread-66475":["thread",66475],"thread-66384":["thread",66384],"thread-66223":["thread",66223],"thread-66028":["thread",66028],"thread-65910":["thread",65910],"thread-65875":["thread",65875],"thread-65475":["thread",65475],"thread-64986":["thread",64986],"thread-64854":["thread",64854],"thread-64822":["thread",64822],"thread-64171":["thread",64171],"thread-63780":["thread",63780],"thread-63666":["thread",63666],"thread-62933":["thread",62933],"thread-62623":["thread",62623],"thread-62218":["thread",62218],"thread-60450":["thread",60450],"thread-60442":["thread",60442],"thread-58827":["thread",58827],"thread-58599":["thread",58599],"thread-58562":["thread",58562],"thread-58227":["thread",58227],"thread-58110":["thread",58110],"thread-57974":["thread",57974],"thread-57352":["thread",57352],"thread-57221":["thread",57221],"thread-56771":["thread",56771],"thread-56692":["thread",56692],"thread-55800":["thread",55800],"thread-55797":["thread",55797],"thread-55206":["thread",55206],"thread-54364":["thread",54364],"thread-53326":["thread",53326],"thread-53273":["thread",53273],"thread-53263":["thread",53263],"thread-53201":["thread",53201],"thread-53129":["thread",53129],"thread-52885":["thread",52885],"thread-52250":["thread",52250],"thread-51780":["thread",51780],"thread-51756":["thread",51756],"thread-51637":["thread",51637],"thread-51632":["thread",51632],"thread-51042":["thread",51042],"thread-51041":["thread",51041],"thread-50480":["thread",50480],"thread-50220":["thread",50220],"thread-50186":["thread",50186],"thread-50143":["thread",50143],"thread-49998":["thread",49998],"thread-49634":["thread",49634],"thread-49629":["thread",49629],"thread-49626":["thread",49626],"thread-49572":["thread",49572],"thread-49469":["thread",49469],"thread-49348":["thread",49348],"thread-49264":["thread",49264],"thread-49215":["thread",49215],"thread-49208":["thread",49208]}, , 1715983607
Run Time: 0.001033
- 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