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 (104118, 103876, 103787, 101828, 101025, 100884, 100732, 100702, 100698, 100697, 100657, 100569, 100518, 100150, 100074, 100073, 100072, 100071, 100053, 97639, 99868, 99508, 99498, 100981, 99494, 99344, 99076, 99074, 98618, 98555, 98035, 98033, 98031, 97331, 97256, 96813, 96637, 96431, 96247, 96219, 95675, 95122, 94353, 93855, 93018, 92899, 92667, 92604, 92140, 92024, 92019, 92004, 91879, 91654, 91658, 89804, 89555, 89132, 88603, 87968, 87781, 87628, 86796, 86753, 86500, 85362, 84666, 83201, 82594, 82381, 82347, 82133, 82027, 81980, 81978, 81715, 81675, 81495, 81067, 81052, 80477, 80019, 79940, 79590, 79448, 79123, 77820, 76810, 76750, 76625, 76617, 76575, 75911, 75850, 75590, 75523, 75470, 75451, 75349, 75184, 75088, 75067, 74977, 74822, 74731, 74620, 74596, 74484, 74065, 73247, 69315, 68724, 72326, 68158, 68156, 66804, 66740, 66394, 64520, 64148, 72109, 71488, 71812, 71843, 71844, 71598, 59602, 59375, 59241, 71590, 71599, 71602, 58655, 58299, 58141, 58025, 57707, 57455, 57092, 56471, 53875, 53402, 52572, 52357, 51881, 51880, 50347, 49570, 45528, 43109, 39775, 39614, 33607, 32808, 27999, 26883, 25487, 24210, 21900, 20160, 19230, 19229, 19188, 19155, 18608, 18421, 18246, 17193, 16654, 4770, 582, 480))
Run Time: 0.002215
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 172 | 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: 19, 0, 1714049989, {"thread-104118":["thread",104118],"thread-103876":["thread",103876],"thread-103787":["thread",103787],"thread-101828":["thread",101828],"thread-101025":["thread",101025],"thread-100884":["thread",100884],"thread-100732":["thread",100732],"thread-100702":["thread",100702],"thread-100698":["thread",100698],"thread-100697":["thread",100697],"thread-100657":["thread",100657],"thread-100569":["thread",100569],"thread-100518":["thread",100518],"thread-100150":["thread",100150],"thread-100074":["thread",100074],"thread-100073":["thread",100073],"thread-100072":["thread",100072],"thread-100071":["thread",100071],"thread-100053":["thread",100053],"thread-97639":["thread",97639],"thread-99868":["thread",99868],"thread-99508":["thread",99508],"thread-99498":["thread",99498],"thread-100981":["thread",100981],"thread-99494":["thread",99494],"thread-99344":["thread",99344],"thread-99076":["thread",99076],"thread-99074":["thread",99074],"thread-98618":["thread",98618],"thread-98555":["thread",98555],"thread-98035":["thread",98035],"thread-98033":["thread",98033],"thread-98031":["thread",98031],"thread-97331":["thread",97331],"thread-97256":["thread",97256],"thread-96813":["thread",96813],"thread-96637":["thread",96637],"thread-96431":["thread",96431],"thread-96247":["thread",96247],"thread-96219":["thread",96219],"thread-95675":["thread",95675],"thread-95122":["thread",95122],"thread-94353":["thread",94353],"thread-93855":["thread",93855],"thread-93018":["thread",93018],"thread-92899":["thread",92899],"thread-92667":["thread",92667],"thread-92604":["thread",92604],"thread-92140":["thread",92140],"thread-92024":["thread",92024],"thread-92019":["thread",92019],"thread-92004":["thread",92004],"thread-91879":["thread",91879],"thread-91654":["thread",91654],"thread-91658":["thread",91658],"thread-89804":["thread",89804],"thread-89555":["thread",89555],"thread-89132":["thread",89132],"thread-88603":["thread",88603],"thread-87968":["thread",87968],"thread-87781":["thread",87781],"thread-87628":["thread",87628],"thread-86796":["thread",86796],"thread-86753":["thread",86753],"thread-86500":["thread",86500],"thread-85362":["thread",85362],"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-81980":["thread",81980],"thread-81978":["thread",81978],"thread-81715":["thread",81715],"thread-81675":["thread",81675],"thread-81495":["thread",81495],"thread-81067":["thread",81067],"thread-81052":["thread",81052],"thread-80477":["thread",80477],"thread-80019":["thread",80019],"thread-79940":["thread",79940],"thread-79590":["thread",79590],"thread-79448":["thread",79448],"thread-79123":["thread",79123],"thread-77820":["thread",77820],"thread-76810":["thread",76810],"thread-76750":["thread",76750],"thread-76625":["thread",76625],"thread-76617":["thread",76617],"thread-76575":["thread",76575],"thread-75911":["thread",75911],"thread-75850":["thread",75850],"thread-75590":["thread",75590],"thread-75523":["thread",75523],"thread-75470":["thread",75470],"thread-75451":["thread",75451],"thread-75349":["thread",75349],"thread-75184":["thread",75184],"thread-75088":["thread",75088],"thread-75067":["thread",75067],"thread-74977":["thread",74977],"thread-74822":["thread",74822],"thread-74731":["thread",74731],"thread-74620":["thread",74620],"thread-74596":["thread",74596],"thread-74065":["thread",74065],"thread-73247":["thread",73247],"thread-69315":["thread",69315],"thread-68724":["thread",68724],"thread-72326":["thread",72326],"thread-68158":["thread",68158],"thread-68156":["thread",68156],"thread-66804":["thread",66804],"thread-66740":["thread",66740],"thread-66394":["thread",66394],"thread-64520":["thread",64520],"thread-64148":["thread",64148],"thread-72109":["thread",72109],"thread-71488":["thread",71488],"thread-71812":["thread",71812],"thread-71843":["thread",71843],"thread-71844":["thread",71844],"thread-71598":["thread",71598],"thread-59602":["thread",59602],"thread-59375":["thread",59375],"thread-59241":["thread",59241],"thread-71590":["thread",71590],"thread-71599":["thread",71599],"thread-71602":["thread",71602],"thread-58655":["thread",58655],"thread-58299":["thread",58299],"thread-58141":["thread",58141],"thread-58025":["thread",58025],"thread-57707":["thread",57707],"thread-57455":["thread",57455],"thread-57092":["thread",57092],"thread-56471":["thread",56471],"thread-53875":["thread",53875],"thread-53402":["thread",53402],"thread-52572":["thread",52572],"thread-52357":["thread",52357],"thread-51881":["thread",51881],"thread-51880":["thread",51880],"thread-50347":["thread",50347],"thread-49570":["thread",49570],"thread-45528":["thread",45528],"thread-43109":["thread",43109],"thread-39775":["thread",39775],"thread-39614":["thread",39614],"thread-33607":["thread",33607],"thread-32808":["thread",32808],"thread-27999":["thread",27999],"thread-26883":["thread",26883],"thread-25487":["thread",25487],"thread-24210":["thread",24210],"thread-21900":["thread",21900],"thread-20160":["thread",20160],"thread-19230":["thread",19230],"thread-19229":["thread",19229],"thread-19188":["thread",19188],"thread-19155":["thread",19155],"thread-18608":["thread",18608],"thread-18421":["thread",18421],"thread-18246":["thread",18246],"thread-17193":["thread",17193],"thread-16654":["thread",16654],"thread-4770":["thread",4770],"thread-582":["thread",582],"thread-480":["thread",480]}, NULL, 1714046389
Run Time: 0.000122
- 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