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 (182992, 182234, 181706, 181176, 180585, 179826, 179276, 178589, 178359, 178056, 177705, 177508, 176566, 173652, 173577, 173240, 173233, 173091, 172113, 171917, 171635, 171567, 171324, 171153, 170951, 170556, 170290, 169841, 169329, 169252, 169012, 168831, 168451, 167735, 167232, 166723, 166458, 166308, 166266, 166262, 166095, 166059, 166057, 166055, 166054, 166053, 166051, 165644, 165614, 164404, 164287, 163589, 163411, 163034, 162607, 162560, 162028, 161397, 161154, 160925, 160730, 160449, 160378, 160193, 159975, 159936, 159895, 159716, 159650, 158755, 158568, 156973, 156238, 155995, 154469, 154276, 152724, 152450, 151987, 151818, 40441))
Run Time: 0.045172
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 81 | 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: 5928, 0, 1714630010, {"thread-182992":["thread",182992],"thread-182234":["thread",182234],"thread-181706":["thread",181706],"thread-181176":["thread",181176],"thread-180585":["thread",180585],"thread-179826":["thread",179826],"thread-179276":["thread",179276],"thread-178589":["thread",178589],"thread-178359":["thread",178359],"thread-178056":["thread",178056],"thread-177705":["thread",177705],"thread-177508":["thread",177508],"thread-176566":["thread",176566],"thread-173652":["thread",173652],"thread-173577":["thread",173577],"thread-173240":["thread",173240],"thread-173233":["thread",173233],"thread-173091":["thread",173091],"thread-172113":["thread",172113],"thread-171917":["thread",171917],"thread-171635":["thread",171635],"thread-171567":["thread",171567],"thread-171324":["thread",171324],"thread-171153":["thread",171153],"thread-170951":["thread",170951],"thread-170290":["thread",170290],"thread-169841":["thread",169841],"thread-169329":["thread",169329],"thread-169252":["thread",169252],"thread-169012":["thread",169012],"thread-168831":["thread",168831],"thread-168451":["thread",168451],"thread-167735":["thread",167735],"thread-167232":["thread",167232],"thread-166723":["thread",166723],"thread-166458":["thread",166458],"thread-166308":["thread",166308],"thread-166266":["thread",166266],"thread-166262":["thread",166262],"thread-166095":["thread",166095],"thread-166059":["thread",166059],"thread-166057":["thread",166057],"thread-166055":["thread",166055],"thread-166054":["thread",166054],"thread-166053":["thread",166053],"thread-166051":["thread",166051],"thread-165644":["thread",165644],"thread-165614":["thread",165614],"thread-164404":["thread",164404],"thread-164287":["thread",164287],"thread-163589":["thread",163589],"thread-163034":["thread",163034],"thread-162607":["thread",162607],"thread-162560":["thread",162560],"thread-162028":["thread",162028],"thread-161397":["thread",161397],"thread-161154":["thread",161154],"thread-160925":["thread",160925],"thread-160730":["thread",160730],"thread-160449":["thread",160449],"thread-160378":["thread",160378],"thread-160193":["thread",160193],"thread-159975":["thread",159975],"thread-159936":["thread",159936],"thread-159895":["thread",159895],"thread-159716":["thread",159716],"thread-159650":["thread",159650],"thread-158755":["thread",158755],"thread-158568":["thread",158568],"thread-156973":["thread",156973],"thread-156238":["thread",156238],"thread-155995":["thread",155995],"thread-154469":["thread",154469],"thread-154276":["thread",154276],"thread-152724":["thread",152724],"thread-152450":["thread",152450],"thread-151987":["thread",151987],"thread-151818":["thread",151818],"thread-40441":["thread",40441]}, , 1714626410
Run Time: 0.000898
- 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