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 (182517, 182473, 182447, 181866, 181815, 181802, 181789, 180704, 178352, 177059, 175819, 175167, 173642, 170874, 170000, 169314, 169122, 169085, 168645, 168615, 168613, 168597, 167749, 167089, 166936, 165689, 165340, 164330, 157295, 157294, 155722, 155675, 155480, 155270, 154060, 153277, 152249, 152041, 151968, 148057, 147479, 145869, 144521, 138075, 134211, 133558, 132920, 129435, 126292, 117393, 115768, 115084, 115083, 114829, 112191, 112048, 111324, 109501, 108860, 106908, 106349, 106348, 106344, 106319, 100755, 100331, 98080, 97227, 96861, 95621, 95612, 95610, 94612, 93764, 93616, 92366, 89333, 84332, 77279, 74815, 62959, 59079, 54711, 46805, 45326, 44088, 31984, 25700, 23670, 18401, 15109, 12799))
Run Time: 0.051319
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 92 | 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: 2199, 0, 1715845853, {"thread-182517":["thread",182517],"thread-182473":["thread",182473],"thread-182447":["thread",182447],"thread-181866":["thread",181866],"thread-181815":["thread",181815],"thread-181802":["thread",181802],"thread-181789":["thread",181789],"thread-180704":["thread",180704],"thread-178352":["thread",178352],"thread-177059":["thread",177059],"thread-175819":["thread",175819],"thread-175167":["thread",175167],"thread-173642":["thread",173642],"thread-170874":["thread",170874],"thread-170000":["thread",170000],"thread-169314":["thread",169314],"thread-169122":["thread",169122],"thread-169085":["thread",169085],"thread-168645":["thread",168645],"thread-168615":["thread",168615],"thread-168613":["thread",168613],"thread-168597":["thread",168597],"thread-167749":["thread",167749],"thread-167089":["thread",167089],"thread-166936":["thread",166936],"thread-165689":["thread",165689],"thread-165340":["thread",165340],"thread-164330":["thread",164330],"thread-157295":["thread",157295],"thread-157294":["thread",157294],"thread-155722":["thread",155722],"thread-155675":["thread",155675],"thread-155480":["thread",155480],"thread-155270":["thread",155270],"thread-154060":["thread",154060],"thread-153277":["thread",153277],"thread-152249":["thread",152249],"thread-152041":["thread",152041],"thread-151968":["thread",151968],"thread-148057":["thread",148057],"thread-147479":["thread",147479],"thread-145869":["thread",145869],"thread-144521":["thread",144521],"thread-138075":["thread",138075],"thread-134211":["thread",134211],"thread-133558":["thread",133558],"thread-132920":["thread",132920],"thread-129435":["thread",129435],"thread-126292":["thread",126292],"thread-117393":["thread",117393],"thread-115768":["thread",115768],"thread-115084":["thread",115084],"thread-115083":["thread",115083],"thread-114829":["thread",114829],"thread-112191":["thread",112191],"thread-112048":["thread",112048],"thread-111324":["thread",111324],"thread-109501":["thread",109501],"thread-108860":["thread",108860],"thread-106908":["thread",106908],"thread-106349":["thread",106349],"thread-106348":["thread",106348],"thread-106344":["thread",106344],"thread-106319":["thread",106319],"thread-100755":["thread",100755],"thread-100331":["thread",100331],"thread-98080":["thread",98080],"thread-97227":["thread",97227],"thread-96861":["thread",96861],"thread-95621":["thread",95621],"thread-95612":["thread",95612],"thread-95610":["thread",95610],"thread-94612":["thread",94612],"thread-93764":["thread",93764],"thread-93616":["thread",93616],"thread-92366":["thread",92366],"thread-89333":["thread",89333],"thread-84332":["thread",84332],"thread-77279":["thread",77279],"thread-74815":["thread",74815],"thread-62959":["thread",62959],"thread-59079":["thread",59079],"thread-54711":["thread",54711],"thread-46805":["thread",46805],"thread-45326":["thread",45326],"thread-44088":["thread",44088],"thread-31984":["thread",31984],"thread-25700":["thread",25700],"thread-23670":["thread",23670],"thread-18401":["thread",18401],"thread-15109":["thread",15109],"thread-12799":["thread",12799]}, , 1715842253
Run Time: 0.001882
- 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