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 (176055, 171808, 170703, 158488, 155071, 152494, 150749, 150619, 131745, 130258, 130144, 128462, 128406, 127850, 127186, 126505, 126445, 126122, 123157, 123119, 123079, 121726, 120560, 120380, 119904, 118616, 117199, 116832, 116336, 116288, 114825, 114381, 112409, 111442, 110001, 109970, 109143, 109120, 108747, 108703, 105976, 104367, 103790, 103371, 103340, 103302, 102638, 101223, 98467, 97820, 96423, 96084, 94677, 92187, 92186, 90606, 89257, 89159, 85461, 85398, 83889, 83375, 82834, 81423, 78464, 78128, 76074, 75662, 74732, 74486, 73451, 73420, 72889, 69820, 69649, 66329, 66148, 65659, 65017, 64703, 63930, 63423, 63399, 63152, 62375, 62151, 62112, 62037, 61592, 59458, 58752, 58644, 58422, 57909, 57902, 57898, 56588, 56084, 55747, 55176, 54282, 54103, 54082, 54047, 53108, 51047, 50685, 49855, 49720, 49597, 48317, 47952, 47065, 46871, 46754, 46612, 46471, 45254, 44773, 44247, 43865, 43466, 42665, 39983, 39764, 39544, 38629, 38580, 38108, 37248, 37070, 35903, 35808, 34933, 34364, 34236, 34121, 34065, 33446, 33356, 31268, 31081, 29438, 28515, 27863, 27858, 27812, 27393, 27346, 27295, 25469, 23488, 12476, 9133))
Run Time: 0.079938
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 154 | 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: 3317, 0, 1716091701, {"thread-176055":["thread",176055],"thread-171808":["thread",171808],"thread-170703":["thread",170703],"thread-158488":["thread",158488],"thread-155071":["thread",155071],"thread-152494":["thread",152494],"thread-150749":["thread",150749],"thread-150619":["thread",150619],"thread-131745":["thread",131745],"thread-130258":["thread",130258],"thread-130144":["thread",130144],"thread-128462":["thread",128462],"thread-128406":["thread",128406],"thread-127850":["thread",127850],"thread-127186":["thread",127186],"thread-126505":["thread",126505],"thread-126445":["thread",126445],"thread-126122":["thread",126122],"thread-123157":["thread",123157],"thread-123119":["thread",123119],"thread-123079":["thread",123079],"thread-121726":["thread",121726],"thread-120560":["thread",120560],"thread-120380":["thread",120380],"thread-119904":["thread",119904],"thread-118616":["thread",118616],"thread-117199":["thread",117199],"thread-116832":["thread",116832],"thread-116336":["thread",116336],"thread-116288":["thread",116288],"thread-114825":["thread",114825],"thread-114381":["thread",114381],"thread-112409":["thread",112409],"thread-111442":["thread",111442],"thread-110001":["thread",110001],"thread-109970":["thread",109970],"thread-109143":["thread",109143],"thread-109120":["thread",109120],"thread-108747":["thread",108747],"thread-108703":["thread",108703],"thread-105976":["thread",105976],"thread-104367":["thread",104367],"thread-103790":["thread",103790],"thread-103371":["thread",103371],"thread-103340":["thread",103340],"thread-103302":["thread",103302],"thread-102638":["thread",102638],"thread-101223":["thread",101223],"thread-98467":["thread",98467],"thread-97820":["thread",97820],"thread-96423":["thread",96423],"thread-96084":["thread",96084],"thread-94677":["thread",94677],"thread-92187":["thread",92187],"thread-92186":["thread",92186],"thread-90606":["thread",90606],"thread-89257":["thread",89257],"thread-89159":["thread",89159],"thread-85461":["thread",85461],"thread-85398":["thread",85398],"thread-83889":["thread",83889],"thread-83375":["thread",83375],"thread-82834":["thread",82834],"thread-81423":["thread",81423],"thread-78464":["thread",78464],"thread-78128":["thread",78128],"thread-76074":["thread",76074],"thread-75662":["thread",75662],"thread-74732":["thread",74732],"thread-74486":["thread",74486],"thread-73451":["thread",73451],"thread-73420":["thread",73420],"thread-72889":["thread",72889],"thread-69820":["thread",69820],"thread-69649":["thread",69649],"thread-66329":["thread",66329],"thread-66148":["thread",66148],"thread-65659":["thread",65659],"thread-65017":["thread",65017],"thread-64703":["thread",64703],"thread-63930":["thread",63930],"thread-63423":["thread",63423],"thread-63399":["thread",63399],"thread-63152":["thread",63152],"thread-62375":["thread",62375],"thread-62151":["thread",62151],"thread-62112":["thread",62112],"thread-62037":["thread",62037],"thread-61592":["thread",61592],"thread-59458":["thread",59458],"thread-58752":["thread",58752],"thread-58644":["thread",58644],"thread-58422":["thread",58422],"thread-57909":["thread",57909],"thread-57902":["thread",57902],"thread-57898":["thread",57898],"thread-56588":["thread",56588],"thread-56084":["thread",56084],"thread-55747":["thread",55747],"thread-55176":["thread",55176],"thread-54282":["thread",54282],"thread-54103":["thread",54103],"thread-54082":["thread",54082],"thread-54047":["thread",54047],"thread-53108":["thread",53108],"thread-51047":["thread",51047],"thread-50685":["thread",50685],"thread-49855":["thread",49855],"thread-49720":["thread",49720],"thread-49597":["thread",49597],"thread-48317":["thread",48317],"thread-47952":["thread",47952],"thread-47065":["thread",47065],"thread-46871":["thread",46871],"thread-46754":["thread",46754],"thread-46612":["thread",46612],"thread-46471":["thread",46471],"thread-45254":["thread",45254],"thread-44773":["thread",44773],"thread-44247":["thread",44247],"thread-43865":["thread",43865],"thread-43466":["thread",43466],"thread-42665":["thread",42665],"thread-39983":["thread",39983],"thread-39764":["thread",39764],"thread-39544":["thread",39544],"thread-38629":["thread",38629],"thread-38580":["thread",38580],"thread-38108":["thread",38108],"thread-37248":["thread",37248],"thread-37070":["thread",37070],"thread-35903":["thread",35903],"thread-35808":["thread",35808],"thread-34933":["thread",34933],"thread-34364":["thread",34364],"thread-34236":["thread",34236],"thread-34121":["thread",34121],"thread-34065":["thread",34065],"thread-33446":["thread",33446],"thread-33356":["thread",33356],"thread-31268":["thread",31268],"thread-31081":["thread",31081],"thread-29438":["thread",29438],"thread-28515":["thread",28515],"thread-27863":["thread",27863],"thread-27858":["thread",27858],"thread-27812":["thread",27812],"thread-27393":["thread",27393],"thread-27346":["thread",27346],"thread-27295":["thread",27295],"thread-25469":["thread",25469],"thread-23488":["thread",23488],"thread-12476":["thread",12476],"thread-9133":["thread",9133]}, , 1716088101
Run Time: 0.000303
- 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