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 (183683, 183675, 182851, 182333, 182323, 181452, 181405, 180884, 180723, 179635, 179264, 176711, 175109, 175084, 174889, 174507, 173470, 173279, 172583, 169307, 168780, 165957, 165148, 164780, 163554, 158847, 158193, 155907, 154706, 153628, 153247, 153190, 152226, 148935, 147442, 147214, 144729, 140513, 140321, 138209, 136092, 134686, 132824, 131948, 130132, 128883, 128768, 127355, 127323, 126193, 126077, 125743, 124486, 124364, 123431, 123386, 122817, 122816, 122678, 122582, 122416, 119488, 116489, 115368, 114664, 108565, 108323, 106434, 103595, 103225, 96739, 88123, 85517, 83936, 82098, 82014, 81813, 79880, 78635, 73533, 71531, 64173, 61716, 60136, 57258, 57240, 56881, 56609, 56462, 55908, 55702, 55671, 55373, 55372, 55335, 54089, 53883, 53872, 53358, 53356, 53348, 44154, 43217, 43198, 40949, 39521, 39350, 39300, 38230, 36353, 36352, 36320, 32692, 32151, 32042, 30853, 30618, 30375, 29610, 27973, 27824, 9164))
Run Time: 0.056259
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 122 | 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: 1554, 0, 1716359260, {"thread-183683":["thread",183683],"thread-183675":["thread",183675],"thread-182851":["thread",182851],"thread-182333":["thread",182333],"thread-182323":["thread",182323],"thread-181452":["thread",181452],"thread-181405":["thread",181405],"thread-180884":["thread",180884],"thread-180723":["thread",180723],"thread-179635":["thread",179635],"thread-179264":["thread",179264],"thread-176711":["thread",176711],"thread-175109":["thread",175109],"thread-175084":["thread",175084],"thread-174889":["thread",174889],"thread-174507":["thread",174507],"thread-173470":["thread",173470],"thread-173279":["thread",173279],"thread-172583":["thread",172583],"thread-169307":["thread",169307],"thread-168780":["thread",168780],"thread-165957":["thread",165957],"thread-165148":["thread",165148],"thread-164780":["thread",164780],"thread-163554":["thread",163554],"thread-158847":["thread",158847],"thread-158193":["thread",158193],"thread-155907":["thread",155907],"thread-154706":["thread",154706],"thread-153628":["thread",153628],"thread-153247":["thread",153247],"thread-153190":["thread",153190],"thread-152226":["thread",152226],"thread-148935":["thread",148935],"thread-147442":["thread",147442],"thread-147214":["thread",147214],"thread-144729":["thread",144729],"thread-140513":["thread",140513],"thread-140321":["thread",140321],"thread-138209":["thread",138209],"thread-136092":["thread",136092],"thread-134686":["thread",134686],"thread-132824":["thread",132824],"thread-131948":["thread",131948],"thread-130132":["thread",130132],"thread-128883":["thread",128883],"thread-128768":["thread",128768],"thread-127355":["thread",127355],"thread-127323":["thread",127323],"thread-126193":["thread",126193],"thread-126077":["thread",126077],"thread-125743":["thread",125743],"thread-124486":["thread",124486],"thread-124364":["thread",124364],"thread-123431":["thread",123431],"thread-123386":["thread",123386],"thread-122817":["thread",122817],"thread-122816":["thread",122816],"thread-122678":["thread",122678],"thread-122582":["thread",122582],"thread-122416":["thread",122416],"thread-119488":["thread",119488],"thread-116489":["thread",116489],"thread-115368":["thread",115368],"thread-114664":["thread",114664],"thread-108565":["thread",108565],"thread-108323":["thread",108323],"thread-106434":["thread",106434],"thread-103595":["thread",103595],"thread-103225":["thread",103225],"thread-96739":["thread",96739],"thread-88123":["thread",88123],"thread-85517":["thread",85517],"thread-83936":["thread",83936],"thread-82098":["thread",82098],"thread-82014":["thread",82014],"thread-81813":["thread",81813],"thread-79880":["thread",79880],"thread-78635":["thread",78635],"thread-73533":["thread",73533],"thread-71531":["thread",71531],"thread-64173":["thread",64173],"thread-61716":["thread",61716],"thread-60136":["thread",60136],"thread-57258":["thread",57258],"thread-57240":["thread",57240],"thread-56881":["thread",56881],"thread-56609":["thread",56609],"thread-56462":["thread",56462],"thread-55908":["thread",55908],"thread-55702":["thread",55702],"thread-55671":["thread",55671],"thread-55373":["thread",55373],"thread-55372":["thread",55372],"thread-55335":["thread",55335],"thread-54089":["thread",54089],"thread-53883":["thread",53883],"thread-53872":["thread",53872],"thread-53358":["thread",53358],"thread-53356":["thread",53356],"thread-53348":["thread",53348],"thread-44154":["thread",44154],"thread-43217":["thread",43217],"thread-43198":["thread",43198],"thread-40949":["thread",40949],"thread-39521":["thread",39521],"thread-39350":["thread",39350],"thread-39300":["thread",39300],"thread-38230":["thread",38230],"thread-36353":["thread",36353],"thread-36352":["thread",36352],"thread-36320":["thread",36320],"thread-32692":["thread",32692],"thread-32151":["thread",32151],"thread-32042":["thread",32042],"thread-30853":["thread",30853],"thread-30618":["thread",30618],"thread-30375":["thread",30375],"thread-29610":["thread",29610],"thread-27973":["thread",27973],"thread-27824":["thread",27824],"thread-9164":["thread",9164]}, , 1716355660
Run Time: 0.000480
- 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