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 (183635, 183627, 183589, 183538, 183461, 183312, 181282, 179757, 179754, 179084, 178249, 178247, 178203, 177848, 177446, 177321, 177098, 177032, 176813, 176217, 176036, 175648, 175570, 175216, 173986, 173597, 173285, 172450, 172211, 171780, 171467, 171433, 170025, 167720, 166417, 166365, 166153, 165117, 164691, 162641, 162538, 162376, 162231, 161601, 161093, 161035, 160925, 160718, 160697, 160239, 160002, 159773, 159566, 159550, 159493, 159401, 158973, 158059, 156799, 156685, 156340, 155353, 154421, 153957, 152300, 152070, 151925, 151816, 151751, 151552, 148201, 147252, 139207, 138107, 137192, 131937, 131840, 129398, 129357, 129336, 129335, 128906, 128192, 126289, 125967, 124812, 124811, 124621, 124133, 124117, 123620, 123203, 122843, 122595, 122245, 121506, 121347, 119636, 119595, 118898, 118611, 118532, 118196, 117624, 117485, 117447, 117085, 117079, 117006, 117003, 117002, 117001, 117000, 115396, 115019, 114718, 114473, 114114, 112163, 111666, 111644, 111434, 111323, 111046, 110998, 110700, 110638, 110617, 110611, 110455, 110448, 109691, 109102, 109057, 109050, 107956, 107825, 107732, 107727, 107072, 106500, 105987, 105842, 105449, 105234, 104662, 103933, 103858, 103590, 103567, 103493, 102684, 102683, 102513, 102508, 101785, 101784, 101783, 101450, 100861, 100355, 100328, 97386, 96325, 96056, 95883, 95702, 95537, 95084, 94789, 94783, 94350, 94059, 93867, 93677, 93527, 91667, 91011, 90339, 90246, 90232, 89815, 89379, 89332, 89168, 89128, 89100, 89052, 89046, 88799, 88662, 88651, 88544, 88050, 87986, 87894, 87805, 87617, 87337, 86920))
Run Time: 0.097622
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | 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: 53, 0, 1716147464, {"thread-183635":["thread",183635],"thread-183589":["thread",183589],"thread-183538":["thread",183538],"thread-183461":["thread",183461],"thread-183312":["thread",183312],"thread-181282":["thread",181282],"thread-179757":["thread",179757],"thread-179084":["thread",179084],"thread-178249":["thread",178249],"thread-178247":["thread",178247],"thread-177848":["thread",177848],"thread-177446":["thread",177446],"thread-177098":["thread",177098],"thread-177032":["thread",177032],"thread-176813":["thread",176813],"thread-176217":["thread",176217],"thread-176036":["thread",176036],"thread-175648":["thread",175648],"thread-175570":["thread",175570],"thread-175216":["thread",175216],"thread-173986":["thread",173986],"thread-173285":["thread",173285],"thread-172211":["thread",172211],"thread-171780":["thread",171780],"thread-171467":["thread",171467],"thread-171433":["thread",171433],"thread-170025":["thread",170025],"thread-167720":["thread",167720],"thread-166417":["thread",166417],"thread-166365":["thread",166365],"thread-165117":["thread",165117],"thread-164691":["thread",164691],"thread-162641":["thread",162641],"thread-162538":["thread",162538],"thread-162376":["thread",162376],"thread-162231":["thread",162231],"thread-161093":["thread",161093],"thread-161035":["thread",161035],"thread-160925":["thread",160925],"thread-160718":["thread",160718],"thread-160697":["thread",160697],"thread-160239":["thread",160239],"thread-160002":["thread",160002],"thread-159773":["thread",159773],"thread-159566":["thread",159566],"thread-159550":["thread",159550],"thread-159401":["thread",159401],"thread-158059":["thread",158059],"thread-156799":["thread",156799],"thread-156685":["thread",156685],"thread-156340":["thread",156340],"thread-155353":["thread",155353],"thread-152300":["thread",152300],"thread-151816":["thread",151816],"thread-148201":["thread",148201],"thread-147252":["thread",147252],"thread-139207":["thread",139207],"thread-138107":["thread",138107],"thread-137192":["thread",137192],"thread-131937":["thread",131937],"thread-131840":["thread",131840],"thread-129398":["thread",129398],"thread-129357":["thread",129357],"thread-128906":["thread",128906],"thread-128192":["thread",128192],"thread-126289":["thread",126289],"thread-125967":["thread",125967],"thread-124812":["thread",124812],"thread-124811":["thread",124811],"thread-124621":["thread",124621],"thread-124133":["thread",124133],"thread-124117":["thread",124117],"thread-123620":["thread",123620],"thread-123203":["thread",123203],"thread-122843":["thread",122843],"thread-122595":["thread",122595],"thread-122245":["thread",122245],"thread-121506":["thread",121506],"thread-121347":["thread",121347],"thread-119636":["thread",119636],"thread-119595":["thread",119595],"thread-118898":["thread",118898],"thread-118611":["thread",118611],"thread-118532":["thread",118532],"thread-118196":["thread",118196],"thread-117624":["thread",117624],"thread-117485":["thread",117485],"thread-117447":["thread",117447],"thread-117085":["thread",117085],"thread-117079":["thread",117079],"thread-117006":["thread",117006],"thread-117003":["thread",117003],"thread-117002":["thread",117002],"thread-117001":["thread",117001],"thread-117000":["thread",117000],"thread-115396":["thread",115396],"thread-115019":["thread",115019],"thread-114718":["thread",114718],"thread-114473":["thread",114473],"thread-114114":["thread",114114],"thread-112163":["thread",112163],"thread-111666":["thread",111666],"thread-111644":["thread",111644],"thread-111434":["thread",111434],"thread-111046":["thread",111046],"thread-110998":["thread",110998],"thread-110700":["thread",110700],"thread-110638":["thread",110638],"thread-110611":["thread",110611],"thread-110455":["thread",110455],"thread-110448":["thread",110448],"thread-109691":["thread",109691],"thread-109102":["thread",109102],"thread-109050":["thread",109050],"thread-107956":["thread",107956],"thread-107825":["thread",107825],"thread-107732":["thread",107732],"thread-107727":["thread",107727],"thread-107072":["thread",107072],"thread-106500":["thread",106500],"thread-105987":["thread",105987],"thread-105842":["thread",105842],"thread-105449":["thread",105449],"thread-105234":["thread",105234],"thread-104662":["thread",104662],"thread-103933":["thread",103933],"thread-103858":["thread",103858],"thread-103590":["thread",103590],"thread-103567":["thread",103567],"thread-103493":["thread",103493],"thread-102684":["thread",102684],"thread-102683":["thread",102683],"thread-102508":["thread",102508],"thread-101450":["thread",101450],"thread-100355":["thread",100355],"thread-96325":["thread",96325],"thread-96056":["thread",96056],"thread-95702":["thread",95702],"thread-95537":["thread",95537],"thread-95084":["thread",95084],"thread-94789":["thread",94789],"thread-94350":["thread",94350],"thread-94059":["thread",94059],"thread-93867":["thread",93867],"thread-93677":["thread",93677],"thread-93527":["thread",93527],"thread-91011":["thread",91011],"thread-90339":["thread",90339],"thread-90246":["thread",90246],"thread-90232":["thread",90232],"thread-89815":["thread",89815],"thread-89379":["thread",89379],"thread-89332":["thread",89332],"thread-89168":["thread",89168],"thread-89128":["thread",89128],"thread-89100":["thread",89100],"thread-89052":["thread",89052],"thread-89046":["thread",89046],"thread-88799":["thread",88799],"thread-88662":["thread",88662],"thread-88651":["thread",88651],"thread-88544":["thread",88544],"thread-88050":["thread",88050],"thread-87986":["thread",87986],"thread-87894":["thread",87894],"thread-87805":["thread",87805],"thread-87617":["thread",87617],"thread-87337":["thread",87337],"thread-86920":["thread",86920]}, , 1716143864
Run Time: 0.000313
- 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