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 (100206, 99903, 99830, 99440, 99115, 98958, 98712, 98124, 98047, 98006, 97968, 97559, 97539, 97514, 97450, 97385, 97156, 97127, 97096, 97054, 96960, 96897, 96891, 96568, 96553, 95801, 95511, 93654, 93174, 89362, 88402, 91444, 87421, 84273, 84103, 83979, 82781, 82771, 82662, 81856, 81233, 81080, 80442, 79582, 79441, 78919, 78850, 77307, 76966, 76770, 76686, 76328, 75874, 75350, 75056, 74936, 74654, 74439, 73600, 73569, 73489, 72999, 69355, 69276, 67937, 65969, 65131, 64802, 64579, 64218, 63461, 62582, 62430, 61361, 58447, 58056, 55888, 55567, 54915, 53202, 50159, 48148, 45887, 45099, 45016, 44592, 43871, 43444, 41946, 41945, 39765, 39565, 39244, 38864, 38122, 37881, 37180, 36428, 35974, 34673, 34047, 32961, 30544, 28570, 26853, 25530, 24716, 24712, 24004, 23587, 21970, 20963, 20207, 20183, 20177, 19633, 19628, 19588, 19424, 19086, 18999, 18627, 18598, 17089, 16984, 16881, 16502, 16365, 16280, 16242, 16000, 15894, 15472, 15333, 14709, 14648, 14090, 14057, 13722, 13497, 13429, 13275, 12612, 12477, 12403, 11621, 11037, 10645, 9974, 9914, 9327, 9084, 9022, 8285, 6407, 5828, 5386, 5257, 5177, 4967, 4415, 4359, 4188, 3894, 3813, 3687, 3058, 2819, 2657, 2054, 2028, 1354, 1103, 941, 823, 787, 643, 509, 401, 400, 350, 285, 180, 172))
Run Time: 0.002529
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 184 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,blutschwerter_forum.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 2870
- 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 138
- 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 2487
- XF\App->run() in src/XF.php at line 524
- 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: 1747, 0, 1713542265, {"thread-100206":["thread",100206],"thread-99903":["thread",99903],"thread-99830":["thread",99830],"thread-99440":["thread",99440],"thread-99115":["thread",99115],"thread-98958":["thread",98958],"thread-98712":["thread",98712],"thread-98124":["thread",98124],"thread-98047":["thread",98047],"thread-98006":["thread",98006],"thread-97968":["thread",97968],"thread-97559":["thread",97559],"thread-97539":["thread",97539],"thread-97514":["thread",97514],"thread-97450":["thread",97450],"thread-97385":["thread",97385],"thread-97156":["thread",97156],"thread-97127":["thread",97127],"thread-97096":["thread",97096],"thread-97054":["thread",97054],"thread-96960":["thread",96960],"thread-96897":["thread",96897],"thread-96891":["thread",96891],"thread-96568":["thread",96568],"thread-96553":["thread",96553],"thread-95801":["thread",95801],"thread-95511":["thread",95511],"thread-93654":["thread",93654],"thread-93174":["thread",93174],"thread-89362":["thread",89362],"thread-88402":["thread",88402],"thread-91444":["thread",91444],"thread-87421":["thread",87421],"thread-84273":["thread",84273],"thread-84103":["thread",84103],"thread-83979":["thread",83979],"thread-82781":["thread",82781],"thread-82771":["thread",82771],"thread-82662":["thread",82662],"thread-81856":["thread",81856],"thread-81233":["thread",81233],"thread-81080":["thread",81080],"thread-80442":["thread",80442],"thread-79582":["thread",79582],"thread-79441":["thread",79441],"thread-78919":["thread",78919],"thread-78850":["thread",78850],"thread-77307":["thread",77307],"thread-76966":["thread",76966],"thread-76770":["thread",76770],"thread-76686":["thread",76686],"thread-76328":["thread",76328],"thread-75874":["thread",75874],"thread-75350":["thread",75350],"thread-75056":["thread",75056],"thread-74936":["thread",74936],"thread-74654":["thread",74654],"thread-74439":["thread",74439],"thread-73600":["thread",73600],"thread-73569":["thread",73569],"thread-73489":["thread",73489],"thread-72999":["thread",72999],"thread-69355":["thread",69355],"thread-69276":["thread",69276],"thread-67937":["thread",67937],"thread-65969":["thread",65969],"thread-65131":["thread",65131],"thread-64802":["thread",64802],"thread-64579":["thread",64579],"thread-64218":["thread",64218],"thread-63461":["thread",63461],"thread-62582":["thread",62582],"thread-62430":["thread",62430],"thread-61361":["thread",61361],"thread-58447":["thread",58447],"thread-58056":["thread",58056],"thread-55888":["thread",55888],"thread-55567":["thread",55567],"thread-54915":["thread",54915],"thread-53202":["thread",53202],"thread-50159":["thread",50159],"thread-48148":["thread",48148],"thread-45887":["thread",45887],"thread-45099":["thread",45099],"thread-45016":["thread",45016],"thread-44592":["thread",44592],"thread-43871":["thread",43871],"thread-43444":["thread",43444],"thread-41946":["thread",41946],"thread-41945":["thread",41945],"thread-39765":["thread",39765],"thread-39565":["thread",39565],"thread-39244":["thread",39244],"thread-38864":["thread",38864],"thread-38122":["thread",38122],"thread-37881":["thread",37881],"thread-37180":["thread",37180],"thread-36428":["thread",36428],"thread-35974":["thread",35974],"thread-34673":["thread",34673],"thread-34047":["thread",34047],"thread-32961":["thread",32961],"thread-30544":["thread",30544],"thread-28570":["thread",28570],"thread-26853":["thread",26853],"thread-25530":["thread",25530],"thread-24716":["thread",24716],"thread-24712":["thread",24712],"thread-24004":["thread",24004],"thread-23587":["thread",23587],"thread-21970":["thread",21970],"thread-20963":["thread",20963],"thread-20207":["thread",20207],"thread-20183":["thread",20183],"thread-20177":["thread",20177],"thread-19633":["thread",19633],"thread-19628":["thread",19628],"thread-19588":["thread",19588],"thread-19424":["thread",19424],"thread-19086":["thread",19086],"thread-18999":["thread",18999],"thread-18627":["thread",18627],"thread-18598":["thread",18598],"thread-17089":["thread",17089],"thread-16984":["thread",16984],"thread-16881":["thread",16881],"thread-16502":["thread",16502],"thread-16365":["thread",16365],"thread-16280":["thread",16280],"thread-16242":["thread",16242],"thread-16000":["thread",16000],"thread-15894":["thread",15894],"thread-15472":["thread",15472],"thread-15333":["thread",15333],"thread-14709":["thread",14709],"thread-14648":["thread",14648],"thread-14090":["thread",14090],"thread-14057":["thread",14057],"thread-13722":["thread",13722],"thread-13497":["thread",13497],"thread-13429":["thread",13429],"thread-13275":["thread",13275],"thread-12612":["thread",12612],"thread-12477":["thread",12477],"thread-12403":["thread",12403],"thread-11621":["thread",11621],"thread-11037":["thread",11037],"thread-10645":["thread",10645],"thread-9974":["thread",9974],"thread-9914":["thread",9914],"thread-9327":["thread",9327],"thread-9084":["thread",9084],"thread-9022":["thread",9022],"thread-8285":["thread",8285],"thread-6407":["thread",6407],"thread-5828":["thread",5828],"thread-5386":["thread",5386],"thread-5257":["thread",5257],"thread-5177":["thread",5177],"thread-4967":["thread",4967],"thread-4415":["thread",4415],"thread-4359":["thread",4359],"thread-4188":["thread",4188],"thread-3894":["thread",3894],"thread-3813":["thread",3813],"thread-3687":["thread",3687],"thread-3058":["thread",3058],"thread-2819":["thread",2819],"thread-2657":["thread",2657],"thread-2054":["thread",2054],"thread-2028":["thread",2028],"thread-1354":["thread",1354],"thread-1103":["thread",1103],"thread-941":["thread",941],"thread-823":["thread",823],"thread-787":["thread",787],"thread-643":["thread",643],"thread-509":["thread",509],"thread-401":["thread",401],"thread-400":["thread",400],"thread-350":["thread",350],"thread-285":["thread",285],"thread-180":["thread",180],"thread-172":["thread",172]}, NULL, 1713538665
Run Time: 0.000124
- 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 1526
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1258
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20