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 (174134, 174014, 173876, 157578, 146775, 143477, 142480, 142239, 139713, 139702, 132613, 127228, 127205, 126280, 125702, 123063, 122374, 122186, 122164, 121968, 121872, 120762, 120659, 120623, 120463, 120356, 120307, 120306, 120305, 119637, 119486, 119414, 119326, 119170, 119078, 119016, 118963, 118925, 118445, 118416, 118411, 118157, 117917, 117723, 117677, 117672, 116868, 116858, 116821, 116743, 116257, 116097, 116081, 115927, 115908, 115496, 115339, 115306, 115130, 114200, 113966, 112842, 112836, 112372, 112069, 111439, 109358, 108396, 106148, 105462, 105403, 105141, 104812, 103213, 102843, 102141, 101911, 101817, 101725, 101575, 100625, 100566, 100516, 99865, 98632, 98447, 97580, 96466, 96316, 95819, 95574, 94964, 94867, 94443, 93765, 93250, 92898, 92249, 91924, 91579, 91142, 91031, 91030, 90937, 90621, 90452, 90386, 90328, 90324, 90144, 90096, 90083, 90002, 89751, 89681, 89123, 88948, 88610, 88327, 88276, 88264, 87881, 87314, 87096, 87001, 86147, 85975, 85597, 85368, 83866, 83845, 83101, 81246, 81061, 80597, 80326, 80233, 80023, 79726, 76885, 76846, 75330, 37599))
Run Time: 0.082597
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 143 | 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: 5339, 0, 1717151643, {"thread-174134":["thread",174134],"thread-174014":["thread",174014],"thread-173876":["thread",173876],"thread-157578":["thread",157578],"thread-146775":["thread",146775],"thread-143477":["thread",143477],"thread-142480":["thread",142480],"thread-142239":["thread",142239],"thread-139713":["thread",139713],"thread-139702":["thread",139702],"thread-132613":["thread",132613],"thread-127228":["thread",127228],"thread-127205":["thread",127205],"thread-126280":["thread",126280],"thread-125702":["thread",125702],"thread-123063":["thread",123063],"thread-122374":["thread",122374],"thread-122186":["thread",122186],"thread-122164":["thread",122164],"thread-121968":["thread",121968],"thread-121872":["thread",121872],"thread-120762":["thread",120762],"thread-120659":["thread",120659],"thread-120623":["thread",120623],"thread-120463":["thread",120463],"thread-120356":["thread",120356],"thread-120307":["thread",120307],"thread-120306":["thread",120306],"thread-120305":["thread",120305],"thread-119637":["thread",119637],"thread-119486":["thread",119486],"thread-119414":["thread",119414],"thread-119326":["thread",119326],"thread-119170":["thread",119170],"thread-119078":["thread",119078],"thread-119016":["thread",119016],"thread-118963":["thread",118963],"thread-118925":["thread",118925],"thread-118445":["thread",118445],"thread-118416":["thread",118416],"thread-118411":["thread",118411],"thread-118157":["thread",118157],"thread-117917":["thread",117917],"thread-117723":["thread",117723],"thread-117677":["thread",117677],"thread-117672":["thread",117672],"thread-116868":["thread",116868],"thread-116858":["thread",116858],"thread-116821":["thread",116821],"thread-116743":["thread",116743],"thread-116257":["thread",116257],"thread-116097":["thread",116097],"thread-116081":["thread",116081],"thread-115927":["thread",115927],"thread-115908":["thread",115908],"thread-115496":["thread",115496],"thread-115339":["thread",115339],"thread-115306":["thread",115306],"thread-115130":["thread",115130],"thread-114200":["thread",114200],"thread-113966":["thread",113966],"thread-112842":["thread",112842],"thread-112836":["thread",112836],"thread-112372":["thread",112372],"thread-112069":["thread",112069],"thread-111439":["thread",111439],"thread-109358":["thread",109358],"thread-108396":["thread",108396],"thread-106148":["thread",106148],"thread-105462":["thread",105462],"thread-105403":["thread",105403],"thread-105141":["thread",105141],"thread-104812":["thread",104812],"thread-103213":["thread",103213],"thread-102843":["thread",102843],"thread-102141":["thread",102141],"thread-101911":["thread",101911],"thread-101817":["thread",101817],"thread-101725":["thread",101725],"thread-101575":["thread",101575],"thread-100625":["thread",100625],"thread-100566":["thread",100566],"thread-100516":["thread",100516],"thread-99865":["thread",99865],"thread-98632":["thread",98632],"thread-98447":["thread",98447],"thread-97580":["thread",97580],"thread-96466":["thread",96466],"thread-96316":["thread",96316],"thread-95819":["thread",95819],"thread-95574":["thread",95574],"thread-94964":["thread",94964],"thread-94867":["thread",94867],"thread-94443":["thread",94443],"thread-93765":["thread",93765],"thread-93250":["thread",93250],"thread-92898":["thread",92898],"thread-92249":["thread",92249],"thread-91924":["thread",91924],"thread-91579":["thread",91579],"thread-91142":["thread",91142],"thread-91031":["thread",91031],"thread-91030":["thread",91030],"thread-90937":["thread",90937],"thread-90621":["thread",90621],"thread-90452":["thread",90452],"thread-90386":["thread",90386],"thread-90328":["thread",90328],"thread-90324":["thread",90324],"thread-90144":["thread",90144],"thread-90096":["thread",90096],"thread-90083":["thread",90083],"thread-90002":["thread",90002],"thread-89751":["thread",89751],"thread-89681":["thread",89681],"thread-89123":["thread",89123],"thread-88948":["thread",88948],"thread-88610":["thread",88610],"thread-88327":["thread",88327],"thread-88276":["thread",88276],"thread-88264":["thread",88264],"thread-87881":["thread",87881],"thread-87314":["thread",87314],"thread-87096":["thread",87096],"thread-87001":["thread",87001],"thread-86147":["thread",86147],"thread-85975":["thread",85975],"thread-85597":["thread",85597],"thread-85368":["thread",85368],"thread-83866":["thread",83866],"thread-83845":["thread",83845],"thread-83101":["thread",83101],"thread-81246":["thread",81246],"thread-81061":["thread",81061],"thread-80597":["thread",80597],"thread-80326":["thread",80326],"thread-80233":["thread",80233],"thread-80023":["thread",80023],"thread-79726":["thread",79726],"thread-76885":["thread",76885],"thread-76846":["thread",76846],"thread-75330":["thread",75330],"thread-37599":["thread",37599]}, , 1717148043
Run Time: 0.000210
- 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