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 (103297, 101137, 100765, 100568, 100541, 99483, 98662, 98659, 98615, 98302, 98277, 98119, 97983, 97916, 97371, 97170, 96994, 96707, 96519, 96489, 96190, 96169, 96163, 96112, 96108, 95952, 95857, 94592, 93824, 93630, 93478, 93371, 93304, 93265, 93097, 92978, 92742, 92663, 92130, 91996, 91675, 91674, 89894, 89769, 89724, 89650, 89623, 89611, 89504, 89482, 89471, 89363, 89312, 89091, 89027, 88814, 88774, 88705, 87963, 86605, 86600, 86329, 86257, 86254, 85081, 85039, 84576, 84523, 83820, 83710, 83689, 83655, 83505, 83339, 82298, 82297, 82239, 82201, 82200, 81910, 81794, 81526, 79700, 79657, 79261, 79225, 79185, 78383, 77273, 76766, 76706, 76618, 76369, 76303, 76213, 76180, 76077, 75898, 75892, 75259, 75172, 74863, 74820, 74737, 74716, 74551, 74423, 74048, 73764, 72909, 72816, 69305, 72332, 67577, 67211, 66666, 65969, 65877, 72233, 65080, 65004, 64871, 63817, 62890, 60884, 71469, 71647, 71650, 71664, 71672, 71675, 71710, 71726, 71792, 71796, 71828, 71888, 71906, 71856, 71998, 72013, 71663, 59240, 72049, 72036, 72084, 71947, 71640, 58834, 56511, 56471, 55977, 55017, 54865, 53770, 53598, 53429, 50885, 50831, 49154, 48066, 48006, 46575, 45723, 45058, 45031, 44579, 44506, 43500, 43410, 43155, 43086, 42767, 42641, 42433, 42160, 41711, 40275, 39500, 37656, 37439, 35125, 34859, 33542, 32950, 31298, 31291, 31132, 30751, 30699, 30360, 30109, 29893, 29801, 29528, 25492, 25385, 23919, 29187, 23614, 23485, 23074, 22980, 22939, 22476, 21095, 19354, 18929, 18441, 18035, 17979, 17846, 16721, 16713, 14079, 13710, 13006, 12814, 12402, 12403, 11781, 9750, 8315, 8071, 11224, 3737, 2314, 257))
Run Time: 0.003379
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 228 | 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: 238, 0, 1714740081, {"thread-103297":["thread",103297],"thread-101137":["thread",101137],"thread-100765":["thread",100765],"thread-100568":["thread",100568],"thread-100541":["thread",100541],"thread-99483":["thread",99483],"thread-98662":["thread",98662],"resource-123":["resource",123],"thread-98659":["thread",98659],"thread-98615":["thread",98615],"thread-98302":["thread",98302],"thread-98277":["thread",98277],"thread-98119":["thread",98119],"thread-97983":["thread",97983],"thread-97916":["thread",97916],"thread-97371":["thread",97371],"thread-97170":["thread",97170],"thread-96994":["thread",96994],"thread-96707":["thread",96707],"thread-96519":["thread",96519],"thread-96489":["thread",96489],"thread-96190":["thread",96190],"thread-96169":["thread",96169],"thread-96163":["thread",96163],"thread-96112":["thread",96112],"thread-96108":["thread",96108],"thread-95952":["thread",95952],"thread-95857":["thread",95857],"thread-94592":["thread",94592],"thread-93824":["thread",93824],"thread-93630":["thread",93630],"thread-93478":["thread",93478],"thread-93371":["thread",93371],"thread-93304":["thread",93304],"thread-93265":["thread",93265],"thread-93097":["thread",93097],"thread-92978":["thread",92978],"thread-92742":["thread",92742],"thread-92663":["thread",92663],"thread-92130":["thread",92130],"thread-91996":["thread",91996],"thread-91675":["thread",91675],"thread-91674":["thread",91674],"thread-89894":["thread",89894],"thread-89769":["thread",89769],"thread-89724":["thread",89724],"thread-89650":["thread",89650],"thread-89623":["thread",89623],"thread-89611":["thread",89611],"thread-89504":["thread",89504],"thread-89482":["thread",89482],"thread-89471":["thread",89471],"thread-89363":["thread",89363],"thread-89312":["thread",89312],"thread-89091":["thread",89091],"thread-89027":["thread",89027],"thread-88814":["thread",88814],"thread-88774":["thread",88774],"thread-88705":["thread",88705],"thread-87963":["thread",87963],"thread-86605":["thread",86605],"thread-86600":["thread",86600],"thread-86329":["thread",86329],"thread-86257":["thread",86257],"thread-86254":["thread",86254],"thread-85081":["thread",85081],"thread-85039":["thread",85039],"thread-84576":["thread",84576],"thread-84523":["thread",84523],"thread-83820":["thread",83820],"thread-83710":["thread",83710],"thread-83689":["thread",83689],"thread-83655":["thread",83655],"thread-83505":["thread",83505],"thread-83339":["thread",83339],"thread-82298":["thread",82298],"thread-82297":["thread",82297],"thread-82239":["thread",82239],"thread-82201":["thread",82201],"thread-82200":["thread",82200],"thread-81910":["thread",81910],"thread-81794":["thread",81794],"thread-81526":["thread",81526],"thread-79700":["thread",79700],"thread-79657":["thread",79657],"thread-79261":["thread",79261],"thread-79225":["thread",79225],"thread-79185":["thread",79185],"thread-78383":["thread",78383],"thread-77273":["thread",77273],"thread-76766":["thread",76766],"thread-76706":["thread",76706],"thread-76618":["thread",76618],"thread-76369":["thread",76369],"thread-76303":["thread",76303],"thread-76213":["thread",76213],"thread-76180":["thread",76180],"thread-76077":["thread",76077],"thread-75898":["thread",75898],"thread-75892":["thread",75892],"thread-75259":["thread",75259],"thread-75172":["thread",75172],"thread-74863":["thread",74863],"thread-74820":["thread",74820],"thread-74737":["thread",74737],"thread-74716":["thread",74716],"thread-74551":["thread",74551],"thread-74423":["thread",74423],"thread-74048":["thread",74048],"thread-73764":["thread",73764],"thread-72909":["thread",72909],"thread-72816":["thread",72816],"thread-69305":["thread",69305],"thread-72332":["thread",72332],"thread-67577":["thread",67577],"thread-67211":["thread",67211],"thread-66666":["thread",66666],"thread-65969":["thread",65969],"thread-65877":["thread",65877],"thread-72233":["thread",72233],"thread-65080":["thread",65080],"thread-65004":["thread",65004],"thread-64871":["thread",64871],"thread-63817":["thread",63817],"thread-62890":["thread",62890],"thread-60884":["thread",60884],"thread-71469":["thread",71469],"thread-71647":["thread",71647],"thread-71650":["thread",71650],"thread-71664":["thread",71664],"thread-71672":["thread",71672],"thread-71675":["thread",71675],"thread-71710":["thread",71710],"thread-71726":["thread",71726],"thread-71792":["thread",71792],"thread-71796":["thread",71796],"thread-71828":["thread",71828],"thread-71888":["thread",71888],"thread-71906":["thread",71906],"thread-71856":["thread",71856],"thread-71998":["thread",71998],"thread-72013":["thread",72013],"thread-71663":["thread",71663],"thread-59240":["thread",59240],"thread-72049":["thread",72049],"thread-72036":["thread",72036],"thread-72084":["thread",72084],"thread-71947":["thread",71947],"thread-71640":["thread",71640],"thread-58834":["thread",58834],"thread-56511":["thread",56511],"thread-56471":["thread",56471],"thread-55977":["thread",55977],"thread-55017":["thread",55017],"thread-54865":["thread",54865],"thread-53770":["thread",53770],"thread-53598":["thread",53598],"thread-53429":["thread",53429],"thread-50885":["thread",50885],"thread-50831":["thread",50831],"thread-49154":["thread",49154],"thread-48066":["thread",48066],"thread-48006":["thread",48006],"thread-46575":["thread",46575],"thread-45723":["thread",45723],"thread-45058":["thread",45058],"thread-45031":["thread",45031],"thread-44579":["thread",44579],"thread-44506":["thread",44506],"thread-43500":["thread",43500],"thread-43410":["thread",43410],"thread-43155":["thread",43155],"thread-43086":["thread",43086],"thread-42767":["thread",42767],"thread-42641":["thread",42641],"thread-42433":["thread",42433],"thread-42160":["thread",42160],"thread-41711":["thread",41711],"thread-40275":["thread",40275],"thread-39500":["thread",39500],"thread-37656":["thread",37656],"thread-37439":["thread",37439],"thread-35125":["thread",35125],"thread-34859":["thread",34859],"thread-33542":["thread",33542],"thread-32950":["thread",32950],"thread-31298":["thread",31298],"thread-31291":["thread",31291],"thread-31132":["thread",31132],"thread-30751":["thread",30751],"thread-30699":["thread",30699],"thread-30360":["thread",30360],"thread-30109":["thread",30109],"thread-29893":["thread",29893],"thread-29801":["thread",29801],"thread-29528":["thread",29528],"thread-25492":["thread",25492],"thread-25385":["thread",25385],"thread-23919":["thread",23919],"thread-29187":["thread",29187],"thread-23614":["thread",23614],"thread-23485":["thread",23485],"thread-23074":["thread",23074],"thread-22980":["thread",22980],"thread-22939":["thread",22939],"thread-22476":["thread",22476],"thread-21095":["thread",21095],"thread-19354":["thread",19354],"thread-18929":["thread",18929],"thread-18441":["thread",18441],"thread-18035":["thread",18035],"thread-17979":["thread",17979],"thread-17846":["thread",17846],"thread-16721":["thread",16721],"thread-16713":["thread",16713],"thread-14079":["thread",14079],"thread-13710":["thread",13710],"thread-13006":["thread",13006],"thread-12814":["thread",12814],"thread-12402":["thread",12402],"thread-12403":["thread",12403],"thread-11781":["thread",11781],"thread-9750":["thread",9750],"thread-8315":["thread",8315],"thread-8071":["thread",8071],"thread-11224":["thread",11224],"thread-3737":["thread",3737],"thread-2314":["thread",2314],"thread-257":["thread",257]}, NULL, 1714736481
Run Time: 0.000120
- 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