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 (101393, 100847, 100750, 100558, 100323, 99483, 99161, 98932, 98651, 98634, 98492, 98069, 98059, 97935, 97928, 97796, 97690, 97181, 97042, 96875, 96786, 96587, 96363, 95028, 94936, 94934, 93419, 93140, 92733, 92696, 92196, 89815, 89434, 89172, 88946, 88282, 87761, 87748, 87466, 87200, 86518, 85190, 81995, 78604, 77401, 76338, 76239, 75234, 74598, 73939, 72841, 72762, 70267, 70206, 69598, 68493, 72304, 72283, 66932, 66377, 72241, 64070, 62125, 62027, 61609, 61552, 71520, 71522, 71521, 71542, 72032, 72025, 58822, 57085, 55677, 54882, 53095, 52892, 52881, 52584, 52006, 51866, 51770, 51624, 51559, 51540, 51248, 50327, 45795, 45638, 44641, 44279, 43773, 43237, 43166, 42551, 39807, 37987, 37343, 36459, 34624, 34143, 34139, 34005, 33128, 33099, 31961, 31758, 31111, 30637, 30623, 30546, 30208, 29900, 29812, 29618, 29588, 29525, 29467, 29414, 29114, 29054, 28897, 28819, 28794, 28787, 28767, 28763, 28762, 28725, 28724, 28698, 28660, 28646, 28642, 28623, 28611, 28580, 28550, 28544, 28543, 28542, 28541, 28536, 28534, 28333, 26373, 26132, 25585, 23760, 23714, 23706, 23493, 23285, 23255, 23103, 23045, 22788, 21703, 21696, 21435, 21275, 21072, 18925, 18384, 17867, 17203, 16985, 16324, 10264, 9393, 6558, 5475, 3745, 197))
Run Time: 0.002253
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 175 | 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: 2484, 0, 1715590170, {"thread-101393":["thread",101393],"thread-100847":["thread",100847],"thread-100750":["thread",100750],"thread-100558":["thread",100558],"thread-100323":["thread",100323],"thread-99483":["thread",99483],"thread-99161":["thread",99161],"thread-98932":["thread",98932],"thread-98651":["thread",98651],"thread-98634":["thread",98634],"thread-98492":["thread",98492],"thread-98069":["thread",98069],"thread-98059":["thread",98059],"thread-97935":["thread",97935],"thread-97928":["thread",97928],"thread-97796":["thread",97796],"thread-97690":["thread",97690],"thread-97181":["thread",97181],"thread-97042":["thread",97042],"thread-96875":["thread",96875],"thread-96786":["thread",96786],"thread-96587":["thread",96587],"thread-96363":["thread",96363],"thread-95028":["thread",95028],"thread-94936":["thread",94936],"thread-94934":["thread",94934],"thread-93419":["thread",93419],"thread-93140":["thread",93140],"thread-92733":["thread",92733],"thread-92696":["thread",92696],"thread-92196":["thread",92196],"thread-89815":["thread",89815],"thread-89434":["thread",89434],"thread-89172":["thread",89172],"thread-88946":["thread",88946],"thread-88282":["thread",88282],"thread-87761":["thread",87761],"thread-87748":["thread",87748],"thread-87466":["thread",87466],"thread-87200":["thread",87200],"thread-86518":["thread",86518],"thread-85190":["thread",85190],"thread-81995":["thread",81995],"thread-78604":["thread",78604],"thread-77401":["thread",77401],"thread-76338":["thread",76338],"thread-76239":["thread",76239],"thread-75234":["thread",75234],"thread-74598":["thread",74598],"thread-73939":["thread",73939],"thread-72841":["thread",72841],"thread-72762":["thread",72762],"thread-70267":["thread",70267],"thread-70206":["thread",70206],"thread-69598":["thread",69598],"thread-68493":["thread",68493],"thread-72304":["thread",72304],"thread-72283":["thread",72283],"thread-66932":["thread",66932],"thread-66377":["thread",66377],"thread-72241":["thread",72241],"thread-64070":["thread",64070],"thread-62125":["thread",62125],"thread-62027":["thread",62027],"thread-61609":["thread",61609],"thread-61552":["thread",61552],"thread-71520":["thread",71520],"thread-71522":["thread",71522],"thread-71521":["thread",71521],"thread-71542":["thread",71542],"thread-72032":["thread",72032],"thread-72025":["thread",72025],"thread-58822":["thread",58822],"thread-57085":["thread",57085],"thread-55677":["thread",55677],"thread-54882":["thread",54882],"thread-53095":["thread",53095],"thread-52892":["thread",52892],"thread-52881":["thread",52881],"thread-52584":["thread",52584],"thread-52006":["thread",52006],"thread-51866":["thread",51866],"thread-51770":["thread",51770],"thread-51624":["thread",51624],"thread-51559":["thread",51559],"thread-51540":["thread",51540],"thread-51248":["thread",51248],"thread-50327":["thread",50327],"thread-45795":["thread",45795],"thread-45638":["thread",45638],"thread-44641":["thread",44641],"thread-44279":["thread",44279],"thread-43773":["thread",43773],"thread-43237":["thread",43237],"thread-43166":["thread",43166],"thread-42551":["thread",42551],"thread-39807":["thread",39807],"thread-37987":["thread",37987],"thread-37343":["thread",37343],"thread-36459":["thread",36459],"thread-34624":["thread",34624],"thread-34143":["thread",34143],"thread-34139":["thread",34139],"thread-34005":["thread",34005],"thread-33128":["thread",33128],"thread-33099":["thread",33099],"thread-31961":["thread",31961],"thread-31758":["thread",31758],"thread-31111":["thread",31111],"thread-30637":["thread",30637],"thread-30623":["thread",30623],"thread-30546":["thread",30546],"thread-30208":["thread",30208],"thread-29900":["thread",29900],"thread-29812":["thread",29812],"thread-29618":["thread",29618],"thread-29588":["thread",29588],"thread-29525":["thread",29525],"thread-29467":["thread",29467],"thread-29414":["thread",29414],"thread-29114":["thread",29114],"thread-29054":["thread",29054],"thread-28897":["thread",28897],"thread-28819":["thread",28819],"thread-28794":["thread",28794],"thread-28787":["thread",28787],"thread-28767":["thread",28767],"thread-28763":["thread",28763],"thread-28762":["thread",28762],"thread-28725":["thread",28725],"thread-28724":["thread",28724],"thread-28698":["thread",28698],"thread-28660":["thread",28660],"thread-28646":["thread",28646],"thread-28642":["thread",28642],"thread-28623":["thread",28623],"thread-28611":["thread",28611],"thread-28580":["thread",28580],"thread-28550":["thread",28550],"thread-28544":["thread",28544],"thread-28543":["thread",28543],"thread-28542":["thread",28542],"thread-28541":["thread",28541],"thread-28536":["thread",28536],"thread-28534":["thread",28534],"thread-28333":["thread",28333],"thread-26373":["thread",26373],"thread-26132":["thread",26132],"thread-25585":["thread",25585],"thread-23760":["thread",23760],"thread-23714":["thread",23714],"thread-23706":["thread",23706],"thread-23493":["thread",23493],"thread-23285":["thread",23285],"thread-23255":["thread",23255],"thread-23103":["thread",23103],"thread-23045":["thread",23045],"thread-22788":["thread",22788],"thread-21703":["thread",21703],"thread-21696":["thread",21696],"thread-21435":["thread",21435],"thread-21275":["thread",21275],"thread-21072":["thread",21072],"thread-18925":["thread",18925],"thread-18384":["thread",18384],"thread-17867":["thread",17867],"thread-17203":["thread",17203],"thread-16985":["thread",16985],"thread-16324":["thread",16324],"thread-10264":["thread",10264],"thread-9393":["thread",9393],"thread-6558":["thread",6558],"thread-5475":["thread",5475],"thread-3745":["thread",3745],"thread-197":["thread",197]}, NULL, 1715586570
Run Time: 0.000095
- 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