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 (102902, 101566, 101531, 99483, 99036, 98615, 98596, 98380, 98332, 98166, 98151, 98119, 97983, 97751, 97407, 97371, 96531, 96265, 96251, 96190, 96169, 96163, 96154, 96112, 96108, 96000, 95986, 95980, 95952, 95786, 95778, 95753, 95681, 95037, 94921, 94865, 94723, 94693, 94042, 93675, 93097, 92637, 92544, 92124, 92104, 92012, 91874, 91764, 89847, 89822, 89623, 89547, 89539, 89504, 89363, 89173, 88891, 88728, 88657, 88492, 87993, 87211, 86834, 86257, 86174, 84251, 83820, 82883, 82720, 82103, 81946, 81943, 81935, 81932, 81910, 81529, 81145, 80887, 80419, 80167, 80143, 79847, 79846, 79708, 79700, 79480, 79097, 78797, 78773, 78692, 77338, 77334, 76862, 76565, 76548, 76271, 76081, 75860, 75264, 74968, 74904, 74834, 74424, 74324, 74271, 73874, 73597, 73380, 73296, 73283, 73024, 91440, 69705, 69589, 68868, 68824, 67997, 67714, 67701, 66720, 66666, 66382, 66136, 65969, 65877, 65842, 65823, 64657, 64223, 62890, 62614, 61401, 71871, 71891, 71889, 71902, 72090, 71945, 57841, 57823, 56471, 56427, 56075, 55977, 55322, 54884, 54865, 54629, 53646, 53429, 53223, 53203, 53179, 52691, 52421, 51933, 51808, 51624, 50885, 50809, 49527, 49409, 49203, 49167, 48604, 48594, 48470, 48006, 47960, 47279, 46962, 46696, 46441, 45805, 45723, 45131, 44816, 44306, 43784, 43155, 43086, 41843, 41711, 41491, 40723, 40472, 40088, 39724, 38091, 38012, 37727, 37485, 36268, 36161, 36067, 35961, 35607, 35486, 35466, 35404, 35069, 34982, 34599, 34189, 34080, 33565, 33532, 33472, 33422, 32681, 32464, 32179, 32106, 31727, 31624, 30878, 30460, 30023, 28521, 28393, 26996, 26773, 26734, 26549, 26277, 25883, 25833, 25665, 25631, 25580, 25385, 24700, 24689, 24392, 24224, 24223, 24093, 23614, 23604, 23492, 23485, 23463, 23458, 23074, 23062, 22980, 22628, 22476, 22238, 21560, 20819, 20807, 20457, 20369, 20245, 20135, 19602, 19424, 19354, 18810, 18010, 17979, 17444, 17073, 17016, 16713, 16365, 16169, 16155, 14348, 14079, 13337, 14067, 10453, 9750, 9323, 8378, 8315, 8265, 8071, 7993, 7786, 7603, 5942, 5394, 5370, 5333, 5232, 4958, 4365, 3737, 2750, 1507, 1050, 977, 935, 257, 162))
Run Time: 0.003983
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 298 | 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: 777, 0, 1714217440, {"thread-102902":["thread",102902],"thread-101566":["thread",101566],"thread-101531":["thread",101531],"thread-99483":["thread",99483],"thread-99036":["thread",99036],"thread-98615":["thread",98615],"thread-98596":["thread",98596],"thread-98380":["thread",98380],"thread-98332":["thread",98332],"thread-98166":["thread",98166],"thread-98151":["thread",98151],"thread-98119":["thread",98119],"thread-97983":["thread",97983],"thread-97751":["thread",97751],"thread-97407":["thread",97407],"thread-97371":["thread",97371],"thread-96531":["thread",96531],"thread-96265":["thread",96265],"thread-96251":["thread",96251],"thread-96190":["thread",96190],"thread-96169":["thread",96169],"thread-96163":["thread",96163],"thread-96154":["thread",96154],"thread-96112":["thread",96112],"thread-96108":["thread",96108],"thread-96000":["thread",96000],"thread-95986":["thread",95986],"thread-95980":["thread",95980],"thread-95952":["thread",95952],"thread-95786":["thread",95786],"thread-95778":["thread",95778],"thread-95753":["thread",95753],"thread-95681":["thread",95681],"thread-95037":["thread",95037],"thread-94921":["thread",94921],"thread-94865":["thread",94865],"thread-94723":["thread",94723],"thread-94693":["thread",94693],"thread-94042":["thread",94042],"thread-93675":["thread",93675],"thread-93097":["thread",93097],"thread-92637":["thread",92637],"thread-92544":["thread",92544],"thread-92124":["thread",92124],"thread-92104":["thread",92104],"thread-92012":["thread",92012],"thread-91874":["thread",91874],"thread-91764":["thread",91764],"thread-89847":["thread",89847],"thread-89822":["thread",89822],"thread-89623":["thread",89623],"thread-89547":["thread",89547],"thread-89539":["thread",89539],"thread-89504":["thread",89504],"thread-89363":["thread",89363],"thread-89173":["thread",89173],"thread-88891":["thread",88891],"thread-88728":["thread",88728],"thread-88657":["thread",88657],"thread-88492":["thread",88492],"thread-87993":["thread",87993],"thread-87211":["thread",87211],"thread-86834":["thread",86834],"thread-86257":["thread",86257],"thread-86174":["thread",86174],"thread-84251":["thread",84251],"thread-83820":["thread",83820],"thread-82883":["thread",82883],"thread-82720":["thread",82720],"thread-82103":["thread",82103],"thread-81946":["thread",81946],"thread-81943":["thread",81943],"thread-81935":["thread",81935],"thread-81932":["thread",81932],"thread-81910":["thread",81910],"thread-81529":["thread",81529],"thread-81145":["thread",81145],"thread-80887":["thread",80887],"thread-80419":["thread",80419],"thread-80167":["thread",80167],"thread-80143":["thread",80143],"thread-79847":["thread",79847],"thread-79846":["thread",79846],"thread-79708":["thread",79708],"thread-79700":["thread",79700],"thread-79480":["thread",79480],"thread-79097":["thread",79097],"thread-78797":["thread",78797],"thread-78773":["thread",78773],"thread-78692":["thread",78692],"thread-77338":["thread",77338],"thread-77334":["thread",77334],"thread-76862":["thread",76862],"thread-76565":["thread",76565],"thread-76548":["thread",76548],"thread-76271":["thread",76271],"thread-76081":["thread",76081],"thread-75860":["thread",75860],"thread-75264":["thread",75264],"thread-74968":["thread",74968],"thread-74904":["thread",74904],"thread-74834":["thread",74834],"thread-74424":["thread",74424],"thread-74324":["thread",74324],"thread-74271":["thread",74271],"thread-73874":["thread",73874],"thread-73597":["thread",73597],"thread-73380":["thread",73380],"thread-73296":["thread",73296],"thread-73283":["thread",73283],"thread-73024":["thread",73024],"thread-91440":["thread",91440],"thread-69705":["thread",69705],"thread-69589":["thread",69589],"thread-68868":["thread",68868],"thread-68824":["thread",68824],"thread-67997":["thread",67997],"thread-67714":["thread",67714],"thread-67701":["thread",67701],"thread-66720":["thread",66720],"thread-66666":["thread",66666],"thread-66382":["thread",66382],"thread-66136":["thread",66136],"thread-65969":["thread",65969],"thread-65877":["thread",65877],"thread-65842":["thread",65842],"thread-65823":["thread",65823],"thread-64657":["thread",64657],"thread-64223":["thread",64223],"thread-62890":["thread",62890],"thread-62614":["thread",62614],"thread-61401":["thread",61401],"thread-71871":["thread",71871],"thread-71891":["thread",71891],"thread-71889":["thread",71889],"thread-71902":["thread",71902],"thread-72090":["thread",72090],"thread-71945":["thread",71945],"thread-57841":["thread",57841],"thread-57823":["thread",57823],"thread-56471":["thread",56471],"thread-56427":["thread",56427],"thread-56075":["thread",56075],"thread-55977":["thread",55977],"thread-55322":["thread",55322],"thread-54884":["thread",54884],"thread-54865":["thread",54865],"thread-54629":["thread",54629],"thread-53646":["thread",53646],"thread-53429":["thread",53429],"thread-53223":["thread",53223],"thread-53203":["thread",53203],"thread-53179":["thread",53179],"thread-52691":["thread",52691],"thread-52421":["thread",52421],"thread-51933":["thread",51933],"thread-51808":["thread",51808],"thread-51624":["thread",51624],"thread-50885":["thread",50885],"thread-50809":["thread",50809],"thread-49527":["thread",49527],"thread-49409":["thread",49409],"thread-49203":["thread",49203],"thread-49167":["thread",49167],"thread-48604":["thread",48604],"thread-48594":["thread",48594],"thread-48470":["thread",48470],"thread-48006":["thread",48006],"thread-47960":["thread",47960],"thread-47279":["thread",47279],"thread-46962":["thread",46962],"thread-46696":["thread",46696],"thread-46441":["thread",46441],"thread-45805":["thread",45805],"thread-45723":["thread",45723],"thread-45131":["thread",45131],"thread-44816":["thread",44816],"thread-44306":["thread",44306],"thread-43784":["thread",43784],"thread-43155":["thread",43155],"thread-43086":["thread",43086],"thread-41843":["thread",41843],"thread-41711":["thread",41711],"thread-41491":["thread",41491],"thread-40723":["thread",40723],"thread-40472":["thread",40472],"thread-40088":["thread",40088],"thread-39724":["thread",39724],"thread-38091":["thread",38091],"thread-38012":["thread",38012],"thread-37727":["thread",37727],"thread-37485":["thread",37485],"thread-36268":["thread",36268],"thread-36161":["thread",36161],"thread-36067":["thread",36067],"thread-35961":["thread",35961],"thread-35607":["thread",35607],"thread-35486":["thread",35486],"thread-35466":["thread",35466],"thread-35404":["thread",35404],"thread-35069":["thread",35069],"thread-34982":["thread",34982],"thread-34599":["thread",34599],"thread-34189":["thread",34189],"thread-34080":["thread",34080],"thread-33565":["thread",33565],"thread-33532":["thread",33532],"thread-33472":["thread",33472],"thread-33422":["thread",33422],"thread-32681":["thread",32681],"thread-32464":["thread",32464],"thread-32179":["thread",32179],"thread-32106":["thread",32106],"thread-31727":["thread",31727],"thread-31624":["thread",31624],"thread-30878":["thread",30878],"thread-30460":["thread",30460],"thread-30023":["thread",30023],"thread-28521":["thread",28521],"thread-28393":["thread",28393],"thread-26996":["thread",26996],"thread-26773":["thread",26773],"thread-26734":["thread",26734],"thread-26549":["thread",26549],"thread-26277":["thread",26277],"thread-25883":["thread",25883],"thread-25833":["thread",25833],"thread-25665":["thread",25665],"thread-25631":["thread",25631],"thread-25580":["thread",25580],"thread-25385":["thread",25385],"thread-24700":["thread",24700],"thread-24689":["thread",24689],"thread-24392":["thread",24392],"thread-24224":["thread",24224],"thread-24223":["thread",24223],"thread-24093":["thread",24093],"thread-23614":["thread",23614],"thread-23604":["thread",23604],"thread-23492":["thread",23492],"thread-23485":["thread",23485],"thread-23463":["thread",23463],"thread-23458":["thread",23458],"thread-23074":["thread",23074],"thread-23062":["thread",23062],"thread-22980":["thread",22980],"thread-22628":["thread",22628],"thread-22476":["thread",22476],"thread-22238":["thread",22238],"thread-21560":["thread",21560],"thread-20819":["thread",20819],"thread-20807":["thread",20807],"thread-20457":["thread",20457],"thread-20369":["thread",20369],"thread-20245":["thread",20245],"thread-20135":["thread",20135],"thread-19602":["thread",19602],"thread-19424":["thread",19424],"thread-19354":["thread",19354],"thread-18810":["thread",18810],"thread-18010":["thread",18010],"thread-17979":["thread",17979],"thread-17444":["thread",17444],"thread-17073":["thread",17073],"thread-17016":["thread",17016],"thread-16713":["thread",16713],"thread-16365":["thread",16365],"thread-16169":["thread",16169],"thread-16155":["thread",16155],"thread-14348":["thread",14348],"thread-14079":["thread",14079],"thread-13337":["thread",13337],"thread-14067":["thread",14067],"thread-10453":["thread",10453],"thread-9750":["thread",9750],"thread-9323":["thread",9323],"thread-8378":["thread",8378],"thread-8315":["thread",8315],"thread-8265":["thread",8265],"thread-8071":["thread",8071],"thread-7993":["thread",7993],"thread-7786":["thread",7786],"thread-7603":["thread",7603],"thread-5942":["thread",5942],"thread-5394":["thread",5394],"thread-5370":["thread",5370],"thread-5333":["thread",5333],"thread-5232":["thread",5232],"thread-4958":["thread",4958],"thread-4365":["thread",4365],"thread-3737":["thread",3737],"thread-2750":["thread",2750],"thread-1507":["thread",1507],"thread-1050":["thread",1050],"thread-977":["thread",977],"thread-935":["thread",935],"thread-257":["thread",257],"thread-162":["thread",162]}, NULL, 1714213840
Run Time: 0.000129
- 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