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 (243561, 241846, 236734, 234462, 228699, 228393, 226789, 219275, 214482, 208397, 206000, 205528, 199046, 191849, 187201, 180442, 179951, 179824, 179640, 176665, 176659, 176282, 175500, 175460, 173211, 172868, 172151, 172031, 169842, 166135, 164878, 164688, 162530, 159575, 153916, 153367, 153301, 152736, 152153, 150675, 149459, 149170, 147532, 145712, 143838, 143445, 143357, 139729, 138335, 138311, 134771, 134640, 131784, 129303, 127950, 124717, 124244, 124119, 123908, 122724, 121832, 121611, 121301, 118953, 118821, 116743, 116211, 115652, 115057, 115000, 114459, 113335, 113005, 113002, 112841, 112649, 112634, 112405, 112398, 112326, 111903, 111832, 111690, 111676, 111466, 111308, 111120, 110980, 110062, 109997, 109971, 109772, 108971, 108326, 108323, 108274, 108147, 108145, 107707, 107678, 106735, 105978, 105953, 105783, 105441, 105440, 105411, 105401, 105007, 104800, 104612, 104588, 104587, 104286, 104285, 104223, 104129, 103630, 103613, 103455, 103322, 103003, 102918, 102819, 102593, 102592, 102382, 102346, 102238, 102222, 102197, 102098, 102082, 101935, 101908, 101818, 101627, 100984, 100763, 100525, 100524, 99517, 99372, 99121, 99072, 99032, 98911, 98743, 98571, 98021, 97581, 97576, 97445, 96925, 96722, 96637, 96545, 96160, 95600))
Run Time: 0.009215
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 159 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | sammyboy_xenforo.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | sammyboy_xenforo.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | sammyboy_xenforo.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | sammyboy_xenforo.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,sammyboy_xenforo.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 1430
- 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 2866
- 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 2483
- XF\App->run() in src/XF.php at line 525
- 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: 764, 0, 1714537646, {"thread-243561":["thread",243561],"thread-241846":["thread",241846],"thread-236734":["thread",236734],"thread-234462":["thread",234462],"thread-228699":["thread",228699],"thread-228393":["thread",228393],"thread-226789":["thread",226789],"thread-219275":["thread",219275],"thread-214482":["thread",214482],"thread-208397":["thread",208397],"thread-206000":["thread",206000],"thread-205528":["thread",205528],"thread-199046":["thread",199046],"thread-191849":["thread",191849],"thread-187201":["thread",187201],"thread-180442":["thread",180442],"thread-179951":["thread",179951],"thread-179824":["thread",179824],"thread-179640":["thread",179640],"thread-176665":["thread",176665],"thread-176659":["thread",176659],"thread-176282":["thread",176282],"thread-175500":["thread",175500],"thread-175460":["thread",175460],"thread-173211":["thread",173211],"thread-172868":["thread",172868],"thread-172151":["thread",172151],"thread-172031":["thread",172031],"thread-169842":["thread",169842],"thread-166135":["thread",166135],"thread-164878":["thread",164878],"thread-164688":["thread",164688],"thread-162530":["thread",162530],"thread-159575":["thread",159575],"thread-153916":["thread",153916],"thread-153367":["thread",153367],"thread-153301":["thread",153301],"thread-152736":["thread",152736],"thread-152153":["thread",152153],"thread-150675":["thread",150675],"thread-149459":["thread",149459],"thread-149170":["thread",149170],"thread-147532":["thread",147532],"thread-145712":["thread",145712],"thread-143838":["thread",143838],"thread-143445":["thread",143445],"thread-143357":["thread",143357],"thread-139729":["thread",139729],"thread-138335":["thread",138335],"thread-138311":["thread",138311],"thread-134771":["thread",134771],"thread-134640":["thread",134640],"thread-131784":["thread",131784],"thread-129303":["thread",129303],"thread-127950":["thread",127950],"thread-124717":["thread",124717],"thread-124244":["thread",124244],"thread-124119":["thread",124119],"thread-123908":["thread",123908],"thread-122724":["thread",122724],"thread-121832":["thread",121832],"thread-121611":["thread",121611],"thread-121301":["thread",121301],"thread-118953":["thread",118953],"thread-118821":["thread",118821],"thread-116743":["thread",116743],"thread-116211":["thread",116211],"thread-115652":["thread",115652],"thread-115057":["thread",115057],"thread-115000":["thread",115000],"thread-114459":["thread",114459],"thread-113335":["thread",113335],"thread-113005":["thread",113005],"thread-113002":["thread",113002],"thread-112841":["thread",112841],"thread-112649":["thread",112649],"thread-112634":["thread",112634],"thread-112405":["thread",112405],"thread-112398":["thread",112398],"thread-112326":["thread",112326],"thread-111903":["thread",111903],"thread-111832":["thread",111832],"thread-111690":["thread",111690],"thread-111676":["thread",111676],"thread-111466":["thread",111466],"thread-111308":["thread",111308],"thread-111120":["thread",111120],"thread-110980":["thread",110980],"thread-110062":["thread",110062],"thread-109997":["thread",109997],"thread-109971":["thread",109971],"thread-109772":["thread",109772],"thread-108971":["thread",108971],"thread-108326":["thread",108326],"thread-108323":["thread",108323],"thread-108274":["thread",108274],"thread-108147":["thread",108147],"thread-108145":["thread",108145],"thread-107707":["thread",107707],"thread-107678":["thread",107678],"thread-106735":["thread",106735],"thread-105978":["thread",105978],"thread-105953":["thread",105953],"thread-105783":["thread",105783],"thread-105441":["thread",105441],"thread-105440":["thread",105440],"thread-105411":["thread",105411],"thread-105401":["thread",105401],"thread-105007":["thread",105007],"thread-104800":["thread",104800],"thread-104612":["thread",104612],"thread-104588":["thread",104588],"thread-104587":["thread",104587],"thread-104286":["thread",104286],"thread-104285":["thread",104285],"thread-104223":["thread",104223],"thread-104129":["thread",104129],"thread-103630":["thread",103630],"thread-103613":["thread",103613],"thread-103455":["thread",103455],"thread-103322":["thread",103322],"thread-103003":["thread",103003],"thread-102918":["thread",102918],"thread-102819":["thread",102819],"thread-102593":["thread",102593],"thread-102592":["thread",102592],"thread-102382":["thread",102382],"thread-102346":["thread",102346],"thread-102238":["thread",102238],"thread-102222":["thread",102222],"thread-102197":["thread",102197],"thread-102098":["thread",102098],"thread-102082":["thread",102082],"thread-101935":["thread",101935],"thread-101908":["thread",101908],"thread-101818":["thread",101818],"thread-101627":["thread",101627],"thread-100984":["thread",100984],"thread-100763":["thread",100763],"thread-100525":["thread",100525],"thread-100524":["thread",100524],"thread-99517":["thread",99517],"thread-99372":["thread",99372],"thread-99121":["thread",99121],"thread-99072":["thread",99072],"thread-99032":["thread",99032],"thread-98911":["thread",98911],"thread-98743":["thread",98743],"thread-98571":["thread",98571],"thread-98021":["thread",98021],"thread-97581":["thread",97581],"thread-97576":["thread",97576],"thread-97445":["thread",97445],"thread-96925":["thread",96925],"thread-96722":["thread",96722],"thread-96637":["thread",96637],"thread-96545":["thread",96545],"thread-96160":["thread",96160],"thread-95600":["thread",95600]}, NULL, 1714534046
Run Time: 0.000420
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- 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 2483
- XF\App->run() in src/XF.php at line 525
- XF::runApp() in index.php at line 20