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 (126388, 124354, 123124, 123092, 123069, 123061, 123058, 123057, 123056, 123046, 123038, 123022, 123010, 122983, 122975, 122965, 122964, 122963, 122962, 122961, 122943, 122915, 122859, 122830, 122828, 122825, 122824, 122823, 122822, 122820, 122785, 122784, 122783, 122763, 122661, 122595, 122588, 122581, 122570, 122517, 122387, 122378, 122353, 122340, 122304, 122246, 122204, 122203, 122196, 122166, 122013, 122009, 122006, 121988, 121925, 121638, 121530, 121500, 121431, 121393, 121355, 121354, 121343, 121323, 121317, 121304, 121260, 121259, 121256, 121254, 121249, 121181, 121173, 121108, 121095, 121061, 121060, 121057, 120991, 120987, 120396, 120315, 120301, 120292, 120261, 120256, 120254, 120241, 120205, 120190, 120104, 120066, 120024, 119971, 119943, 119789, 119754, 119680, 119634, 119614, 119601, 119600, 119599, 119426, 119398, 119272, 119204, 119201, 119070, 119062, 119054, 119021, 119017, 119008, 97857))
Run Time: 0.055313
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 115 | 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: 22245, 0, 1714548291, {"thread-126388":["thread",126388],"thread-124354":["thread",124354],"thread-123124":["thread",123124],"thread-123092":["thread",123092],"thread-123069":["thread",123069],"thread-123061":["thread",123061],"thread-123058":["thread",123058],"thread-123057":["thread",123057],"thread-123056":["thread",123056],"thread-123046":["thread",123046],"thread-123038":["thread",123038],"thread-123022":["thread",123022],"thread-123010":["thread",123010],"thread-122983":["thread",122983],"thread-122975":["thread",122975],"thread-122965":["thread",122965],"thread-122964":["thread",122964],"thread-122963":["thread",122963],"thread-122962":["thread",122962],"thread-122961":["thread",122961],"thread-122943":["thread",122943],"thread-122915":["thread",122915],"thread-122859":["thread",122859],"thread-122830":["thread",122830],"thread-122828":["thread",122828],"thread-122825":["thread",122825],"thread-122824":["thread",122824],"thread-122823":["thread",122823],"thread-122822":["thread",122822],"thread-122820":["thread",122820],"thread-122785":["thread",122785],"thread-122784":["thread",122784],"thread-122783":["thread",122783],"thread-122763":["thread",122763],"thread-122661":["thread",122661],"thread-122595":["thread",122595],"thread-122588":["thread",122588],"thread-122581":["thread",122581],"thread-122570":["thread",122570],"thread-122517":["thread",122517],"thread-122387":["thread",122387],"thread-122378":["thread",122378],"thread-122353":["thread",122353],"thread-122340":["thread",122340],"thread-122304":["thread",122304],"thread-122246":["thread",122246],"thread-122204":["thread",122204],"thread-122203":["thread",122203],"thread-122196":["thread",122196],"thread-122166":["thread",122166],"thread-122013":["thread",122013],"thread-122009":["thread",122009],"thread-122006":["thread",122006],"thread-121988":["thread",121988],"thread-121925":["thread",121925],"thread-121638":["thread",121638],"thread-121530":["thread",121530],"thread-121500":["thread",121500],"thread-121431":["thread",121431],"thread-121393":["thread",121393],"thread-121355":["thread",121355],"thread-121354":["thread",121354],"thread-121343":["thread",121343],"thread-121323":["thread",121323],"thread-121317":["thread",121317],"thread-121304":["thread",121304],"thread-121260":["thread",121260],"thread-121259":["thread",121259],"thread-121256":["thread",121256],"thread-121254":["thread",121254],"thread-121249":["thread",121249],"thread-121181":["thread",121181],"thread-121173":["thread",121173],"thread-121108":["thread",121108],"thread-121095":["thread",121095],"thread-121061":["thread",121061],"thread-121060":["thread",121060],"thread-121057":["thread",121057],"thread-120991":["thread",120991],"thread-120987":["thread",120987],"thread-120396":["thread",120396],"thread-120315":["thread",120315],"thread-120301":["thread",120301],"thread-120292":["thread",120292],"thread-120261":["thread",120261],"thread-120256":["thread",120256],"thread-120254":["thread",120254],"thread-120241":["thread",120241],"thread-120205":["thread",120205],"thread-120190":["thread",120190],"thread-120104":["thread",120104],"thread-120066":["thread",120066],"thread-120024":["thread",120024],"thread-119971":["thread",119971],"thread-119943":["thread",119943],"thread-119789":["thread",119789],"thread-119754":["thread",119754],"thread-119680":["thread",119680],"thread-119634":["thread",119634],"thread-119614":["thread",119614],"thread-119601":["thread",119601],"thread-119600":["thread",119600],"thread-119599":["thread",119599],"thread-119426":["thread",119426],"thread-119398":["thread",119398],"thread-119272":["thread",119272],"thread-119204":["thread",119204],"thread-119201":["thread",119201],"thread-119070":["thread",119070],"thread-119062":["thread",119062],"thread-119054":["thread",119054],"thread-119021":["thread",119021],"thread-119017":["thread",119017],"thread-119008":["thread",119008],"thread-97857":["thread",97857]}, , 1714544691
Run Time: 0.000598
- 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