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 (103876, 103755, 101930, 101112, 100722, 100698, 100691, 100601, 100512, 100501, 97639, 99147, 99106, 98746, 98035, 98034, 97949, 97610, 97609, 97588, 97313, 97182, 96806, 96768, 96637, 96348, 96221, 96219, 95907, 95872, 95871, 95675, 95122, 94998, 94969, 94596, 94585, 94379, 94148, 93960, 93855, 93422, 80264, 93103, 93018, 93016, 92973, 92667, 92604, 92160, 92140, 92024, 92019, 92009, 92004, 91879, 91654, 91658, 89804, 89705, 89555, 89132, 88835, 88603, 88403, 88257, 88235, 87968, 87781, 87628, 87526, 86796, 86753, 86500, 85362, 84979, 84666, 83201, 82594, 82381, 82347, 82133, 82027, 81715, 81495, 80785, 80477, 80340, 79940, 79448, 78694, 76810, 76625, 76617, 76575, 76430, 76341, 76181, 75911, 75850, 75797, 75766, 75717, 75590, 75583, 75523, 75470, 75451, 75184, 75095, 75088, 75067, 74977, 74868, 74732, 74731, 74620, 74596, 74573, 74484, 73247, 70271, 69315, 68724, 72326, 68295, 68158, 68157, 66804, 66543, 66394, 65973, 64148, 63468, 63461, 63000, 71813, 71866, 59279, 59245, 58431, 57895, 57707, 57455, 56471, 53875, 53719, 50118, 49291, 48944, 48488, 67764, 43138, 43086, 41382, 39775, 38939, 37171, 32670, 31007, 27999, 27144, 26883, 26487, 24210, 21900, 20160, 19230, 19229, 18608, 18491, 18421, 18246, 18195, 15782, 14853, 3455, 480))
Run Time: 0.002681
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 178 | 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: 1503, 0, 1713594232, {"thread-103876":["thread",103876],"thread-103755":["thread",103755],"thread-101930":["thread",101930],"thread-101112":["thread",101112],"thread-100722":["thread",100722],"thread-100698":["thread",100698],"thread-100691":["thread",100691],"thread-100601":["thread",100601],"thread-100512":["thread",100512],"thread-100501":["thread",100501],"thread-97639":["thread",97639],"thread-99147":["thread",99147],"thread-99106":["thread",99106],"thread-98746":["thread",98746],"thread-98035":["thread",98035],"thread-98034":["thread",98034],"thread-97949":["thread",97949],"thread-97610":["thread",97610],"thread-97609":["thread",97609],"thread-97588":["thread",97588],"thread-97313":["thread",97313],"thread-97182":["thread",97182],"thread-96806":["thread",96806],"thread-96768":["thread",96768],"thread-96637":["thread",96637],"thread-96348":["thread",96348],"thread-96221":["thread",96221],"thread-96219":["thread",96219],"thread-95907":["thread",95907],"thread-95872":["thread",95872],"thread-95871":["thread",95871],"thread-95675":["thread",95675],"thread-95122":["thread",95122],"thread-94998":["thread",94998],"thread-94969":["thread",94969],"thread-94596":["thread",94596],"thread-94585":["thread",94585],"thread-94379":["thread",94379],"thread-94148":["thread",94148],"thread-93960":["thread",93960],"thread-93855":["thread",93855],"thread-93422":["thread",93422],"thread-80264":["thread",80264],"thread-93103":["thread",93103],"thread-93018":["thread",93018],"thread-93016":["thread",93016],"thread-92973":["thread",92973],"thread-92667":["thread",92667],"thread-92604":["thread",92604],"thread-92160":["thread",92160],"thread-92140":["thread",92140],"thread-92024":["thread",92024],"thread-92019":["thread",92019],"thread-92009":["thread",92009],"thread-92004":["thread",92004],"thread-91879":["thread",91879],"thread-91654":["thread",91654],"thread-91658":["thread",91658],"thread-89804":["thread",89804],"thread-89705":["thread",89705],"thread-89555":["thread",89555],"thread-89132":["thread",89132],"thread-88835":["thread",88835],"thread-88603":["thread",88603],"thread-88403":["thread",88403],"thread-88257":["thread",88257],"thread-88235":["thread",88235],"thread-87968":["thread",87968],"thread-87781":["thread",87781],"thread-87628":["thread",87628],"thread-87526":["thread",87526],"thread-86796":["thread",86796],"thread-86753":["thread",86753],"thread-86500":["thread",86500],"thread-85362":["thread",85362],"thread-84979":["thread",84979],"thread-84666":["thread",84666],"thread-83201":["thread",83201],"thread-82594":["thread",82594],"thread-82381":["thread",82381],"thread-82347":["thread",82347],"thread-82133":["thread",82133],"thread-82027":["thread",82027],"thread-81715":["thread",81715],"thread-81495":["thread",81495],"thread-80785":["thread",80785],"thread-80477":["thread",80477],"thread-80340":["thread",80340],"thread-79940":["thread",79940],"thread-79448":["thread",79448],"thread-78694":["thread",78694],"thread-76810":["thread",76810],"thread-76625":["thread",76625],"thread-76617":["thread",76617],"thread-76575":["thread",76575],"thread-76430":["thread",76430],"thread-76341":["thread",76341],"thread-76181":["thread",76181],"thread-75911":["thread",75911],"thread-75850":["thread",75850],"thread-75797":["thread",75797],"thread-75766":["thread",75766],"thread-75717":["thread",75717],"thread-75590":["thread",75590],"thread-75583":["thread",75583],"thread-75523":["thread",75523],"thread-75470":["thread",75470],"thread-75451":["thread",75451],"thread-75184":["thread",75184],"thread-75095":["thread",75095],"thread-75088":["thread",75088],"thread-75067":["thread",75067],"thread-74977":["thread",74977],"thread-74868":["thread",74868],"thread-74732":["thread",74732],"thread-74731":["thread",74731],"thread-74620":["thread",74620],"thread-74596":["thread",74596],"thread-74573":["thread",74573],"thread-73247":["thread",73247],"thread-70271":["thread",70271],"thread-69315":["thread",69315],"thread-68724":["thread",68724],"thread-72326":["thread",72326],"thread-68295":["thread",68295],"thread-68158":["thread",68158],"thread-68157":["thread",68157],"thread-66804":["thread",66804],"thread-66543":["thread",66543],"thread-66394":["thread",66394],"thread-65973":["thread",65973],"thread-64148":["thread",64148],"thread-63468":["thread",63468],"thread-63461":["thread",63461],"thread-63000":["thread",63000],"thread-71813":["thread",71813],"thread-71866":["thread",71866],"thread-59279":["thread",59279],"thread-59245":["thread",59245],"thread-58431":["thread",58431],"thread-57895":["thread",57895],"thread-57707":["thread",57707],"thread-57455":["thread",57455],"thread-56471":["thread",56471],"thread-53875":["thread",53875],"thread-53719":["thread",53719],"thread-50118":["thread",50118],"thread-49291":["thread",49291],"thread-48944":["thread",48944],"thread-48488":["thread",48488],"thread-67764":["thread",67764],"thread-43138":["thread",43138],"thread-43086":["thread",43086],"thread-41382":["thread",41382],"thread-39775":["thread",39775],"thread-38939":["thread",38939],"thread-37171":["thread",37171],"thread-32670":["thread",32670],"thread-31007":["thread",31007],"thread-27999":["thread",27999],"thread-27144":["thread",27144],"thread-26883":["thread",26883],"thread-26487":["thread",26487],"thread-24210":["thread",24210],"thread-21900":["thread",21900],"thread-20160":["thread",20160],"thread-19230":["thread",19230],"thread-19229":["thread",19229],"thread-18608":["thread",18608],"thread-18421":["thread",18421],"thread-18246":["thread",18246],"thread-18195":["thread",18195],"thread-15782":["thread",15782],"thread-14853":["thread",14853],"thread-480":["thread",480]}, NULL, 1713590632
Run Time: 0.000116
- 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