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 (177617, 135041, 122820, 104606, 79412, 78678, 78295, 77815, 75795, 72904, 72772, 72699, 72696, 72635, 72458, 72440, 72430, 71885, 71640, 71576, 71276, 71238, 71150, 71087, 70827, 70397, 70289, 69620, 68225, 68051, 67909, 67484, 67385, 67285, 67174, 66397, 66336, 62567, 62264, 61993, 61680, 61446, 61219, 60638, 60026, 59966, 59952, 59912, 58564, 55829, 55206, 53748, 53529, 53528, 53527, 53361, 52958, 52447, 51369, 51098, 51080, 50869, 50406, 50238, 50115, 50094, 50092, 50039, 50038, 50037, 49137, 48633, 48271, 46834, 33707, 33039))
Run Time: 0.039298
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 76 | 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: 4629, 0, 1714968247, {"thread-177617":["thread",177617],"thread-135041":["thread",135041],"thread-122820":["thread",122820],"thread-104606":["thread",104606],"thread-79412":["thread",79412],"thread-78678":["thread",78678],"thread-78295":["thread",78295],"thread-77815":["thread",77815],"thread-75795":["thread",75795],"thread-72904":["thread",72904],"thread-72772":["thread",72772],"thread-72699":["thread",72699],"thread-72696":["thread",72696],"thread-72635":["thread",72635],"thread-72458":["thread",72458],"thread-72440":["thread",72440],"thread-72430":["thread",72430],"thread-71885":["thread",71885],"thread-71640":["thread",71640],"thread-71576":["thread",71576],"thread-71276":["thread",71276],"thread-71238":["thread",71238],"thread-71150":["thread",71150],"thread-71087":["thread",71087],"thread-70827":["thread",70827],"thread-70397":["thread",70397],"thread-70289":["thread",70289],"thread-69620":["thread",69620],"thread-68225":["thread",68225],"thread-68051":["thread",68051],"thread-67909":["thread",67909],"thread-67484":["thread",67484],"thread-67385":["thread",67385],"thread-67285":["thread",67285],"thread-67174":["thread",67174],"thread-66397":["thread",66397],"thread-66336":["thread",66336],"thread-62567":["thread",62567],"thread-62264":["thread",62264],"thread-61993":["thread",61993],"thread-61680":["thread",61680],"thread-61446":["thread",61446],"thread-61219":["thread",61219],"thread-60638":["thread",60638],"thread-60026":["thread",60026],"thread-59966":["thread",59966],"thread-59952":["thread",59952],"thread-59912":["thread",59912],"thread-58564":["thread",58564],"thread-55829":["thread",55829],"thread-55206":["thread",55206],"thread-53748":["thread",53748],"thread-53529":["thread",53529],"thread-53528":["thread",53528],"thread-53527":["thread",53527],"thread-53361":["thread",53361],"thread-52958":["thread",52958],"thread-52447":["thread",52447],"thread-51369":["thread",51369],"thread-51098":["thread",51098],"thread-51080":["thread",51080],"thread-50869":["thread",50869],"thread-50406":["thread",50406],"thread-50238":["thread",50238],"thread-50115":["thread",50115],"thread-50094":["thread",50094],"thread-50092":["thread",50092],"thread-50039":["thread",50039],"thread-50038":["thread",50038],"thread-50037":["thread",50037],"thread-49137":["thread",49137],"thread-48633":["thread",48633],"thread-48271":["thread",48271],"thread-46834":["thread",46834],"thread-33707":["thread",33707],"thread-33039":["thread",33039]}, , 1714964647
Run Time: 0.000509
- 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