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 (101162, 100997, 100601, 100513, 97451, 95514, 95464, 95310, 95013, 93300, 92974, 92785, 92523, 92489, 92483, 92114, 92112, 92109, 91996, 91953, 91934, 91852, 91507, 92273, 89898, 89777, 89650, 89299, 89050, 88765, 88728, 87950, 87466, 86330, 86329, 83989, 83912, 83730, 83638, 83626, 83613, 82861, 82771, 82673, 82230, 82150, 81133, 81053, 80644, 80340, 80332, 80051, 79452, 79441, 79229, 79066, 78824, 78810, 78289, 77741, 77257, 77131, 76898, 76866, 76810, 76766, 76585, 76341, 76315, 76290, 76221, 76041, 76009, 75757, 75683, 75655, 75523, 75430, 75384, 75151, 74301, 74154, 73939, 73598, 73487, 73188, 73024, 72922, 73015, 72855, 72667, 69937, 69579, 69513, 69424, 69305, 68926, 67739, 67655, 67653, 67586, 67239, 67200, 66254, 66247, 66184, 66095, 66031, 64070, 63699, 63491, 62730, 61849, 60183, 58996, 58822, 58689, 58521, 58097, 57784, 57223, 57096, 56284, 55864, 55678, 55303, 55301, 54949, 54273, 54077, 53245, 52692, 52450, 51577, 50554, 50428, 50107, 49687, 49332, 49275, 48791, 48502, 48438, 48343, 47872, 45795, 45481, 45429, 45347, 44845, 44506, 44313, 44281, 43593, 43564, 43155, 43133, 43030, 41824, 41795, 41769, 41760, 41745, 41255, 41249, 40808, 37679, 37343, 37280, 36459, 36118, 36101, 35818, 34616, 34305, 33907, 33081, 33024, 32877, 31668, 31204, 30922, 30450, 30245, 29599, 29054, 28497, 27850, 27543, 27455, 27446, 25585, 25350, 25304, 23770, 23706, 23676, 23607, 21703, 21700, 21656, 21533, 21275, 21242, 21099, 18432, 16613, 16302, 12786, 12708, 10720, 10081))
Run Time: 0.003192
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 212 | 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: 1004, 0, 1715748173, {"thread-101162":["thread",101162],"thread-100997":["thread",100997],"thread-100601":["thread",100601],"thread-100513":["thread",100513],"thread-97451":["thread",97451],"thread-95514":["thread",95514],"thread-95464":["thread",95464],"thread-95310":["thread",95310],"thread-95013":["thread",95013],"thread-93300":["thread",93300],"thread-92974":["thread",92974],"thread-92785":["thread",92785],"thread-92523":["thread",92523],"thread-92489":["thread",92489],"thread-92483":["thread",92483],"thread-92114":["thread",92114],"thread-92112":["thread",92112],"thread-92109":["thread",92109],"thread-91996":["thread",91996],"thread-91953":["thread",91953],"thread-91934":["thread",91934],"thread-91852":["thread",91852],"thread-91507":["thread",91507],"thread-92273":["thread",92273],"thread-89898":["thread",89898],"thread-89777":["thread",89777],"thread-89650":["thread",89650],"thread-89299":["thread",89299],"thread-89050":["thread",89050],"thread-88765":["thread",88765],"thread-88728":["thread",88728],"thread-87950":["thread",87950],"thread-87466":["thread",87466],"thread-86330":["thread",86330],"thread-86329":["thread",86329],"thread-83989":["thread",83989],"thread-83912":["thread",83912],"thread-83730":["thread",83730],"thread-83638":["thread",83638],"thread-83626":["thread",83626],"thread-83613":["thread",83613],"thread-82861":["thread",82861],"thread-82771":["thread",82771],"thread-82673":["thread",82673],"thread-82230":["thread",82230],"thread-82150":["thread",82150],"thread-81133":["thread",81133],"thread-81053":["thread",81053],"thread-80644":["thread",80644],"thread-80340":["thread",80340],"thread-80332":["thread",80332],"thread-80051":["thread",80051],"thread-79452":["thread",79452],"thread-79441":["thread",79441],"thread-79229":["thread",79229],"thread-79066":["thread",79066],"thread-78824":["thread",78824],"thread-78810":["thread",78810],"thread-78289":["thread",78289],"thread-77741":["thread",77741],"thread-77257":["thread",77257],"thread-77131":["thread",77131],"thread-76898":["thread",76898],"thread-76866":["thread",76866],"thread-76810":["thread",76810],"thread-76766":["thread",76766],"thread-76585":["thread",76585],"thread-76341":["thread",76341],"thread-76315":["thread",76315],"thread-76290":["thread",76290],"thread-76221":["thread",76221],"thread-76041":["thread",76041],"thread-76009":["thread",76009],"thread-75757":["thread",75757],"thread-75683":["thread",75683],"thread-75655":["thread",75655],"thread-75523":["thread",75523],"thread-75430":["thread",75430],"thread-75384":["thread",75384],"thread-75151":["thread",75151],"thread-74301":["thread",74301],"thread-74154":["thread",74154],"thread-73939":["thread",73939],"thread-73598":["thread",73598],"thread-73487":["thread",73487],"thread-73188":["thread",73188],"thread-73024":["thread",73024],"thread-72922":["thread",72922],"thread-73015":["thread",73015],"thread-72855":["thread",72855],"thread-72667":["thread",72667],"thread-69937":["thread",69937],"thread-69579":["thread",69579],"thread-69513":["thread",69513],"thread-69424":["thread",69424],"thread-69305":["thread",69305],"thread-68926":["thread",68926],"thread-67739":["thread",67739],"thread-67655":["thread",67655],"thread-67653":["thread",67653],"thread-67586":["thread",67586],"thread-67239":["thread",67239],"thread-67200":["thread",67200],"thread-66254":["thread",66254],"thread-66247":["thread",66247],"thread-66184":["thread",66184],"thread-66095":["thread",66095],"thread-66031":["thread",66031],"thread-64070":["thread",64070],"thread-63699":["thread",63699],"thread-63491":["thread",63491],"thread-62730":["thread",62730],"thread-61849":["thread",61849],"thread-60183":["thread",60183],"thread-58996":["thread",58996],"thread-58822":["thread",58822],"thread-58689":["thread",58689],"thread-58521":["thread",58521],"thread-58097":["thread",58097],"thread-57784":["thread",57784],"thread-57223":["thread",57223],"thread-57096":["thread",57096],"thread-56284":["thread",56284],"thread-55864":["thread",55864],"thread-55678":["thread",55678],"thread-55303":["thread",55303],"thread-55301":["thread",55301],"thread-54949":["thread",54949],"thread-54273":["thread",54273],"thread-54077":["thread",54077],"thread-53245":["thread",53245],"thread-52692":["thread",52692],"thread-52450":["thread",52450],"thread-51577":["thread",51577],"thread-50554":["thread",50554],"thread-50428":["thread",50428],"thread-50107":["thread",50107],"thread-49687":["thread",49687],"thread-49332":["thread",49332],"thread-49275":["thread",49275],"thread-48791":["thread",48791],"thread-48502":["thread",48502],"thread-48438":["thread",48438],"thread-48343":["thread",48343],"thread-47872":["thread",47872],"thread-45795":["thread",45795],"thread-45481":["thread",45481],"thread-45429":["thread",45429],"thread-45347":["thread",45347],"thread-44845":["thread",44845],"thread-44506":["thread",44506],"thread-44313":["thread",44313],"thread-44281":["thread",44281],"thread-43593":["thread",43593],"thread-43564":["thread",43564],"thread-43155":["thread",43155],"thread-43133":["thread",43133],"thread-43030":["thread",43030],"thread-41824":["thread",41824],"thread-41795":["thread",41795],"thread-41769":["thread",41769],"thread-41760":["thread",41760],"thread-41745":["thread",41745],"thread-41255":["thread",41255],"thread-41249":["thread",41249],"thread-40808":["thread",40808],"thread-37679":["thread",37679],"thread-37343":["thread",37343],"thread-37280":["thread",37280],"thread-36459":["thread",36459],"thread-36118":["thread",36118],"thread-36101":["thread",36101],"thread-35818":["thread",35818],"thread-34616":["thread",34616],"thread-34305":["thread",34305],"thread-33907":["thread",33907],"thread-33081":["thread",33081],"thread-33024":["thread",33024],"thread-32877":["thread",32877],"thread-31668":["thread",31668],"thread-31204":["thread",31204],"thread-30922":["thread",30922],"thread-30450":["thread",30450],"thread-30245":["thread",30245],"thread-29599":["thread",29599],"thread-29054":["thread",29054],"thread-28497":["thread",28497],"thread-27850":["thread",27850],"thread-27543":["thread",27543],"thread-27455":["thread",27455],"thread-27446":["thread",27446],"thread-25585":["thread",25585],"thread-25350":["thread",25350],"thread-25304":["thread",25304],"thread-23770":["thread",23770],"thread-23706":["thread",23706],"thread-23676":["thread",23676],"thread-23607":["thread",23607],"thread-21703":["thread",21703],"thread-21700":["thread",21700],"thread-21656":["thread",21656],"thread-21533":["thread",21533],"thread-21275":["thread",21275],"thread-21242":["thread",21242],"thread-21099":["thread",21099],"thread-18432":["thread",18432],"thread-16613":["thread",16613],"thread-16302":["thread",16302],"thread-12786":["thread",12786],"thread-12708":["thread",12708],"thread-10720":["thread",10720],"thread-10081":["thread",10081]}, NULL, 1715744573
Run Time: 0.000123
- 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