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, 98579, 98378, 98333, 98331, 98141, 98124, 98047, 98045, 98044, 98006, 98001, 97968, 97681, 97564, 97559, 97539, 97514, 97490, 97450, 97385, 97156, 97127, 97054, 96960, 96897, 96891, 96568, 96553, 96458, 96337, 96154, 96004, 96003, 96002, 95994, 69225, 95952, 95893, 95886, 95857, 95849, 95828, 95807, 95713, 95691, 95667, 95565, 95511, 95482, 95366, 95359, 95214, 95162, 95037, 94865, 94755, 94746, 94723, 94707, 94626, 94592, 94504, 94366, 94150, 94074, 94048, 94042, 94012, 93654, 93637, 93303, 93174, 92978, 92784, 91889, 91508, 89362, 88765, 88402, 88104, 91444, 87421, 86514, 894, 84273, 84103, 83979, 83795, 82781, 82771, 82662, 81856, 81799, 81233, 81080, 80660, 80442, 80415, 80133, 79874, 79582, 79441, 79169, 78919, 78850, 77307, 76966, 76770, 76686, 76474, 76328, 75874, 75703, 75350, 75056, 74936, 74654, 74470, 74439, 74434, 74411, 73600, 73489, 72999, 69809, 69355, 69276, 68789, 67937, 65969, 65912, 65131, 64802, 64579, 64369, 64218, 63737, 63461, 62582, 62430, 61361, 71469, 58447, 58056, 57570, 55888, 55567, 54915, 53202, 50865, 50159, 48893, 48148, 45887, 45099, 45016, 44592, 43991, 43871, 43609, 43444, 43404, 41946, 41945, 39765, 39565, 39244, 38864, 38122, 37881, 37180, 37172, 37171, 36428, 35974, 34673, 34616, 34047, 32961, 32464, 30544, 28662, 28570, 28457, 27726, 27521, 27005, 26853, 26773, 25608, 25530, 25483, 25438, 25226, 25132, 24809, 24716, 24712, 24641, 24625, 24004, 23676, 23587, 22726, 22723, 22544, 21970, 21739, 21656, 21620, 21560, 21229, 20963, 20457, 20207, 20183, 20177, 19633, 19628, 19588, 19541, 19508, 19424, 19086, 18999, 18849, 18797, 18627, 18598, 17841, 17612, 17384, 17089, 17032, 16984, 16881, 16780, 16502, 16365, 16280, 16242, 16169, 16027, 16000, 15894, 15699, 15472, 15333, 15051, 14858, 14709, 14648, 14586, 14527, 14462, 14457, 14340, 14090, 14057, 13722, 13497, 13429, 13275, 13006, 12828, 12749, 12612, 12477, 12403, 11621, 11468, 11037, 10645, 10410, 10212, 9974, 9927, 9914, 9327, 9084, 9073, 9022, 8667, 8315, 8285, 8093, 7689, 7569, 6913, 6407, 5828, 5386, 5257, 5177, 4967, 4793, 4415, 4359, 4199, 4188, 4133, 3894, 3813, 3687, 3402, 3058, 2882, 2819, 2657, 2523, 2510, 2441, 2054, 2028, 1905, 1614, 1610, 1354, 1231, 1215, 1136, 1103, 941, 823, 787, 691, 643, 509, 468, 401, 400, 399, 350, 285, 284, 271, 257, 180, 172, 72))
Run Time: 0.004868
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 347 | 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: 1748, 0, 1713856743, {"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-98579":["thread",98579],"thread-98378":["thread",98378],"thread-98333":["thread",98333],"thread-98331":["thread",98331],"thread-98141":["thread",98141],"thread-98124":["thread",98124],"thread-98047":["thread",98047],"thread-98045":["thread",98045],"thread-98044":["thread",98044],"thread-98006":["thread",98006],"thread-98001":["thread",98001],"thread-97968":["thread",97968],"thread-97681":["thread",97681],"thread-97564":["thread",97564],"thread-97559":["thread",97559],"thread-97539":["thread",97539],"thread-97514":["thread",97514],"thread-97490":["thread",97490],"thread-97450":["thread",97450],"thread-97385":["thread",97385],"thread-97156":["thread",97156],"thread-97127":["thread",97127],"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-96458":["thread",96458],"thread-96337":["thread",96337],"thread-96154":["thread",96154],"thread-96004":["thread",96004],"thread-96003":["thread",96003],"thread-96002":["thread",96002],"thread-95994":["thread",95994],"thread-69225":["thread",69225],"thread-95952":["thread",95952],"thread-95893":["thread",95893],"thread-95886":["thread",95886],"thread-95857":["thread",95857],"thread-95849":["thread",95849],"thread-95828":["thread",95828],"thread-95807":["thread",95807],"thread-95713":["thread",95713],"thread-95691":["thread",95691],"thread-95667":["thread",95667],"thread-95565":["thread",95565],"thread-95511":["thread",95511],"thread-95482":["thread",95482],"thread-95366":["thread",95366],"thread-95359":["thread",95359],"thread-95214":["thread",95214],"thread-95162":["thread",95162],"thread-95037":["thread",95037],"thread-94865":["thread",94865],"thread-94755":["thread",94755],"thread-94746":["thread",94746],"thread-94723":["thread",94723],"thread-94707":["thread",94707],"thread-94626":["thread",94626],"thread-94592":["thread",94592],"thread-94504":["thread",94504],"thread-94366":["thread",94366],"thread-94150":["thread",94150],"thread-94074":["thread",94074],"thread-94048":["thread",94048],"thread-94042":["thread",94042],"thread-94012":["thread",94012],"thread-93654":["thread",93654],"thread-93637":["thread",93637],"thread-93303":["thread",93303],"thread-93174":["thread",93174],"thread-92978":["thread",92978],"thread-92784":["thread",92784],"thread-91889":["thread",91889],"thread-91508":["thread",91508],"thread-89362":["thread",89362],"thread-88765":["thread",88765],"thread-88402":["thread",88402],"thread-88104":["thread",88104],"thread-91444":["thread",91444],"thread-87421":["thread",87421],"thread-86514":["thread",86514],"thread-894":["thread",894],"thread-84273":["thread",84273],"thread-84103":["thread",84103],"thread-83979":["thread",83979],"thread-83795":["thread",83795],"thread-82781":["thread",82781],"thread-82771":["thread",82771],"thread-82662":["thread",82662],"thread-81856":["thread",81856],"thread-81799":["thread",81799],"thread-81233":["thread",81233],"thread-81080":["thread",81080],"thread-80660":["thread",80660],"thread-80442":["thread",80442],"thread-80415":["thread",80415],"thread-80133":["thread",80133],"thread-79874":["thread",79874],"thread-79582":["thread",79582],"thread-79441":["thread",79441],"thread-79169":["thread",79169],"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-76474":["thread",76474],"thread-76328":["thread",76328],"thread-75874":["thread",75874],"thread-75703":["thread",75703],"thread-75350":["thread",75350],"thread-75056":["thread",75056],"thread-74936":["thread",74936],"thread-74654":["thread",74654],"thread-74470":["thread",74470],"thread-74439":["thread",74439],"thread-74434":["thread",74434],"thread-74411":["thread",74411],"thread-73600":["thread",73600],"thread-73489":["thread",73489],"thread-72999":["thread",72999],"thread-69809":["thread",69809],"thread-69355":["thread",69355],"thread-69276":["thread",69276],"thread-68789":["thread",68789],"thread-67937":["thread",67937],"thread-65969":["thread",65969],"thread-65912":["thread",65912],"thread-65131":["thread",65131],"thread-64802":["thread",64802],"thread-64579":["thread",64579],"thread-64369":["thread",64369],"thread-64218":["thread",64218],"thread-63737":["thread",63737],"thread-63461":["thread",63461],"thread-62582":["thread",62582],"thread-62430":["thread",62430],"thread-61361":["thread",61361],"thread-71469":["thread",71469],"thread-58447":["thread",58447],"thread-58056":["thread",58056],"thread-57570":["thread",57570],"thread-55888":["thread",55888],"thread-55567":["thread",55567],"thread-54915":["thread",54915],"thread-53202":["thread",53202],"thread-50865":["thread",50865],"thread-50159":["thread",50159],"thread-48893":["thread",48893],"thread-48148":["thread",48148],"thread-45887":["thread",45887],"thread-45099":["thread",45099],"thread-45016":["thread",45016],"thread-44592":["thread",44592],"thread-43991":["thread",43991],"thread-43871":["thread",43871],"thread-43609":["thread",43609],"thread-43444":["thread",43444],"thread-43404":["thread",43404],"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-37172":["thread",37172],"thread-37171":["thread",37171],"thread-36428":["thread",36428],"thread-35974":["thread",35974],"thread-34673":["thread",34673],"thread-34616":["thread",34616],"thread-34047":["thread",34047],"thread-32961":["thread",32961],"thread-32464":["thread",32464],"thread-30544":["thread",30544],"thread-28662":["thread",28662],"thread-28570":["thread",28570],"thread-28457":["thread",28457],"thread-27726":["thread",27726],"thread-27521":["thread",27521],"thread-27005":["thread",27005],"thread-26853":["thread",26853],"thread-26773":["thread",26773],"thread-25608":["thread",25608],"thread-25530":["thread",25530],"thread-25483":["thread",25483],"thread-25438":["thread",25438],"thread-25226":["thread",25226],"thread-25132":["thread",25132],"thread-24809":["thread",24809],"thread-24716":["thread",24716],"thread-24712":["thread",24712],"thread-24641":["thread",24641],"thread-24625":["thread",24625],"thread-24004":["thread",24004],"thread-23676":["thread",23676],"thread-23587":["thread",23587],"thread-22726":["thread",22726],"thread-22723":["thread",22723],"thread-22544":["thread",22544],"thread-21970":["thread",21970],"thread-21739":["thread",21739],"thread-21656":["thread",21656],"thread-21620":["thread",21620],"thread-21560":["thread",21560],"thread-21229":["thread",21229],"thread-20963":["thread",20963],"thread-20457":["thread",20457],"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-19541":["thread",19541],"thread-19508":["thread",19508],"thread-19424":["thread",19424],"thread-19086":["thread",19086],"thread-18999":["thread",18999],"thread-18849":["thread",18849],"thread-18797":["thread",18797],"thread-18627":["thread",18627],"thread-18598":["thread",18598],"thread-17841":["thread",17841],"thread-17612":["thread",17612],"thread-17384":["thread",17384],"thread-17089":["thread",17089],"thread-17032":["thread",17032],"thread-16984":["thread",16984],"thread-16881":["thread",16881],"thread-16780":["thread",16780],"thread-16502":["thread",16502],"thread-16365":["thread",16365],"thread-16280":["thread",16280],"thread-16242":["thread",16242],"thread-16169":["thread",16169],"thread-16027":["thread",16027],"thread-16000":["thread",16000],"thread-15894":["thread",15894],"thread-15699":["thread",15699],"thread-15472":["thread",15472],"thread-15333":["thread",15333],"thread-15051":["thread",15051],"thread-14858":["thread",14858],"thread-14709":["thread",14709],"thread-14648":["thread",14648],"thread-14586":["thread",14586],"thread-14527":["thread",14527],"thread-14462":["thread",14462],"thread-14457":["thread",14457],"thread-14340":["thread",14340],"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-13006":["thread",13006],"thread-12828":["thread",12828],"thread-12749":["thread",12749],"thread-12612":["thread",12612],"thread-12477":["thread",12477],"thread-12403":["thread",12403],"thread-11621":["thread",11621],"thread-11468":["thread",11468],"thread-11037":["thread",11037],"thread-10645":["thread",10645],"thread-10410":["thread",10410],"thread-10212":["thread",10212],"thread-9974":["thread",9974],"thread-9927":["thread",9927],"thread-9914":["thread",9914],"thread-9327":["thread",9327],"thread-9084":["thread",9084],"thread-9073":["thread",9073],"thread-9022":["thread",9022],"thread-8667":["thread",8667],"thread-8315":["thread",8315],"thread-8285":["thread",8285],"thread-8093":["thread",8093],"thread-7689":["thread",7689],"thread-7569":["thread",7569],"thread-6913":["thread",6913],"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-4793":["thread",4793],"thread-4415":["thread",4415],"thread-4359":["thread",4359],"thread-4199":["thread",4199],"thread-4188":["thread",4188],"thread-4133":["thread",4133],"thread-3894":["thread",3894],"thread-3813":["thread",3813],"thread-3687":["thread",3687],"thread-3402":["thread",3402],"thread-3058":["thread",3058],"thread-2882":["thread",2882],"thread-2819":["thread",2819],"thread-2657":["thread",2657],"thread-2523":["thread",2523],"thread-2510":["thread",2510],"thread-2441":["thread",2441],"thread-2054":["thread",2054],"thread-2028":["thread",2028],"thread-1905":["thread",1905],"thread-1614":["thread",1614],"thread-1610":["thread",1610],"thread-1354":["thread",1354],"thread-1231":["thread",1231],"thread-1215":["thread",1215],"thread-1136":["thread",1136],"thread-1103":["thread",1103],"thread-941":["thread",941],"thread-823":["thread",823],"thread-787":["thread",787],"thread-691":["thread",691],"thread-643":["thread",643],"thread-509":["thread",509],"thread-468":["thread",468],"thread-401":["thread",401],"thread-400":["thread",400],"thread-399":["thread",399],"thread-350":["thread",350],"thread-285":["thread",285],"thread-284":["thread",284],"thread-271":["thread",271],"thread-257":["thread",257],"thread-180":["thread",180],"thread-172":["thread",172],"thread-72":["thread",72]}, NULL, 1713853143
Run Time: 0.000159
- 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