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 (103503, 100792, 100558, 99954, 98922, 98533, 98100, 98003, 97947, 97779, 96471, 96363, 91995, 91782, 89618, 89471, 89318, 89306, 89281, 89172, 89105, 88946, 88891, 88738, 88731, 88728, 87418, 86909, 86746, 86518, 86409, 85190, 84281, 83607, 83341, 82647, 82633, 82201, 82200, 82065, 81922, 81774, 81760, 81146, 81084, 81014, 80673, 80462, 80409, 80169, 79443, 79408, 79289, 79266, 79242, 79201, 79125, 78893, 78825, 78604, 77947, 76898, 76883, 76766, 76565, 76529, 76331, 76320, 75846, 75453, 75375, 75234, 74995, 74820, 74718, 74715, 74678, 74598, 72719, 72511, 70202, 70181, 69598, 69221, 68409, 68133, 67364, 67211, 66932, 66420, 66377, 66333, 66286, 66254, 65734, 65546, 65512, 65495, 65252, 64793, 64502, 64133, 63982, 63893, 63747, 63064, 72187, 62481, 62414, 61733, 61732, 61609, 61552, 61453, 58636, 58611, 58338, 58158, 57573, 57269, 56800, 56284, 56168, 55677, 55608, 55375, 55017, 54816, 54770, 54547, 54383, 54155, 54154, 53947, 53863, 52892, 52692, 51613, 50524, 49952, 49169, 48066, 48006, 47958, 47872, 47635, 47129, 46925, 45741, 45645, 45458, 45438, 45261, 45165, 45025, 44729, 44583, 44506, 44081, 43985, 43793, 43500, 43418, 43155, 43093, 42821, 42042, 42041, 41504, 41479, 40864, 40293, 40271, 39807, 39490, 39021, 36172, 35961, 35819, 35818, 35773, 35493, 34998, 33637, 33401, 33024, 32897, 31859, 31659, 31043, 30456, 30199, 29893, 29690, 28794, 28780, 28771, 28109, 27606, 27499, 27472, 27268, 27169, 27091, 26950, 26804, 26772, 26649, 26494, 26247, 26198, 26155, 26055, 25883, 25626, 25625, 25520, 25383, 25351, 25233, 24819, 24512, 23855, 23770, 23554, 23424, 23285, 23275, 23205, 23024, 22980, 22788, 22429, 22425, 22261, 22193, 21815, 21403, 21356, 21127, 20998, 20997, 20852, 20372, 20369, 20319, 20266, 20240, 19925, 19735, 19365, 18827, 18293, 18187, 17998, 17983, 17978, 17846, 17774, 17274, 16674, 16152, 15787, 15457, 15047, 14654, 14589, 14563, 14215, 14126, 14070, 13816, 13724, 13453, 13259, 12837, 12403, 12402, 12146, 11902, 11825, 11806, 11781, 11214, 11042, 11037, 11036, 11004, 10927, 10926, 10809, 10722, 10666, 10468, 10451, 10439, 10437, 10345, 10303, 10276, 10264, 10215, 10213, 10155, 10145, 10126, 10089, 10081, 10069, 10063, 10047, 10043, 10041, 9916, 9901, 9869, 9797, 3173, 1142))
Run Time: 0.003424
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 319 | 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: 240, 0, 1711719266, {"thread-103503":["thread",103503],"thread-100792":["thread",100792],"thread-100558":["thread",100558],"thread-99954":["thread",99954],"thread-98922":["thread",98922],"thread-98533":["thread",98533],"thread-98100":["thread",98100],"thread-98003":["thread",98003],"thread-97947":["thread",97947],"thread-97779":["thread",97779],"thread-96471":["thread",96471],"thread-96363":["thread",96363],"thread-91995":["thread",91995],"thread-91782":["thread",91782],"thread-89618":["thread",89618],"thread-89471":["thread",89471],"thread-89318":["thread",89318],"thread-89306":["thread",89306],"thread-89281":["thread",89281],"thread-89172":["thread",89172],"thread-89105":["thread",89105],"thread-88946":["thread",88946],"thread-88891":["thread",88891],"thread-88738":["thread",88738],"thread-88728":["thread",88728],"thread-87418":["thread",87418],"thread-86909":["thread",86909],"thread-86746":["thread",86746],"thread-86518":["thread",86518],"thread-86409":["thread",86409],"thread-85190":["thread",85190],"thread-84281":["thread",84281],"thread-83607":["thread",83607],"thread-83341":["thread",83341],"thread-82647":["thread",82647],"thread-82633":["thread",82633],"thread-82201":["thread",82201],"thread-82200":["thread",82200],"thread-82065":["thread",82065],"thread-81922":["thread",81922],"thread-81774":["thread",81774],"thread-81760":["thread",81760],"thread-81146":["thread",81146],"thread-81084":["thread",81084],"thread-81014":["thread",81014],"thread-80673":["thread",80673],"thread-80462":["thread",80462],"thread-80409":["thread",80409],"thread-80169":["thread",80169],"thread-79443":["thread",79443],"thread-79408":["thread",79408],"thread-79289":["thread",79289],"thread-79266":["thread",79266],"thread-79242":["thread",79242],"thread-79201":["thread",79201],"thread-79125":["thread",79125],"thread-78893":["thread",78893],"thread-78825":["thread",78825],"thread-78604":["thread",78604],"thread-77947":["thread",77947],"thread-76898":["thread",76898],"thread-76883":["thread",76883],"thread-76766":["thread",76766],"thread-76565":["thread",76565],"thread-76529":["thread",76529],"thread-76331":["thread",76331],"thread-76320":["thread",76320],"thread-75846":["thread",75846],"thread-75453":["thread",75453],"thread-75375":["thread",75375],"thread-75234":["thread",75234],"thread-74995":["thread",74995],"thread-74820":["thread",74820],"thread-74718":["thread",74718],"thread-74715":["thread",74715],"thread-74678":["thread",74678],"thread-74598":["thread",74598],"thread-72719":["thread",72719],"thread-72511":["thread",72511],"thread-70202":["thread",70202],"thread-70181":["thread",70181],"thread-69598":["thread",69598],"thread-69221":["thread",69221],"thread-68409":["thread",68409],"thread-68133":["thread",68133],"thread-67364":["thread",67364],"thread-67211":["thread",67211],"thread-66932":["thread",66932],"thread-66420":["thread",66420],"thread-66377":["thread",66377],"thread-66333":["thread",66333],"thread-66286":["thread",66286],"thread-66254":["thread",66254],"thread-65734":["thread",65734],"thread-65546":["thread",65546],"thread-65512":["thread",65512],"thread-65495":["thread",65495],"thread-65252":["thread",65252],"thread-64793":["thread",64793],"thread-64502":["thread",64502],"thread-64133":["thread",64133],"thread-63982":["thread",63982],"thread-63893":["thread",63893],"thread-63747":["thread",63747],"thread-63064":["thread",63064],"thread-72187":["thread",72187],"thread-62481":["thread",62481],"thread-62414":["thread",62414],"thread-61733":["thread",61733],"thread-61732":["thread",61732],"thread-61609":["thread",61609],"thread-61552":["thread",61552],"thread-61453":["thread",61453],"thread-58636":["thread",58636],"thread-58611":["thread",58611],"thread-58338":["thread",58338],"thread-58158":["thread",58158],"thread-57573":["thread",57573],"thread-57269":["thread",57269],"thread-56800":["thread",56800],"thread-56284":["thread",56284],"thread-56168":["thread",56168],"thread-55677":["thread",55677],"thread-55608":["thread",55608],"thread-55375":["thread",55375],"thread-55017":["thread",55017],"thread-54816":["thread",54816],"thread-54770":["thread",54770],"thread-54547":["thread",54547],"thread-54383":["thread",54383],"thread-54155":["thread",54155],"thread-54154":["thread",54154],"thread-53947":["thread",53947],"thread-53863":["thread",53863],"thread-52892":["thread",52892],"thread-52692":["thread",52692],"thread-51613":["thread",51613],"thread-50524":["thread",50524],"thread-49952":["thread",49952],"thread-49169":["thread",49169],"thread-48066":["thread",48066],"thread-48006":["thread",48006],"thread-47958":["thread",47958],"thread-47872":["thread",47872],"thread-47635":["thread",47635],"thread-47129":["thread",47129],"thread-46925":["thread",46925],"thread-45741":["thread",45741],"thread-45645":["thread",45645],"thread-45458":["thread",45458],"thread-45438":["thread",45438],"thread-45261":["thread",45261],"thread-45165":["thread",45165],"thread-45025":["thread",45025],"thread-44729":["thread",44729],"thread-44583":["thread",44583],"thread-44506":["thread",44506],"thread-44081":["thread",44081],"thread-43985":["thread",43985],"thread-43793":["thread",43793],"thread-43500":["thread",43500],"thread-43418":["thread",43418],"thread-43155":["thread",43155],"thread-43093":["thread",43093],"thread-42821":["thread",42821],"thread-42042":["thread",42042],"thread-42041":["thread",42041],"thread-41504":["thread",41504],"thread-41479":["thread",41479],"thread-40864":["thread",40864],"thread-40293":["thread",40293],"thread-40271":["thread",40271],"thread-39807":["thread",39807],"thread-39490":["thread",39490],"thread-39021":["thread",39021],"thread-36172":["thread",36172],"thread-35961":["thread",35961],"thread-35819":["thread",35819],"thread-35818":["thread",35818],"thread-35773":["thread",35773],"thread-35493":["thread",35493],"thread-34998":["thread",34998],"thread-33637":["thread",33637],"thread-33401":["thread",33401],"thread-33024":["thread",33024],"thread-32897":["thread",32897],"thread-31859":["thread",31859],"thread-31659":["thread",31659],"thread-31043":["thread",31043],"thread-30456":["thread",30456],"thread-30199":["thread",30199],"thread-29893":["thread",29893],"thread-29690":["thread",29690],"thread-28794":["thread",28794],"thread-28780":["thread",28780],"thread-28771":["thread",28771],"thread-28109":["thread",28109],"thread-27606":["thread",27606],"thread-27499":["thread",27499],"thread-27472":["thread",27472],"thread-27268":["thread",27268],"thread-27169":["thread",27169],"thread-27091":["thread",27091],"thread-26950":["thread",26950],"thread-26804":["thread",26804],"thread-26772":["thread",26772],"thread-26649":["thread",26649],"thread-26494":["thread",26494],"thread-26247":["thread",26247],"thread-26198":["thread",26198],"thread-26155":["thread",26155],"thread-26055":["thread",26055],"thread-25883":["thread",25883],"thread-25626":["thread",25626],"thread-25625":["thread",25625],"thread-25520":["thread",25520],"thread-25383":["thread",25383],"thread-25351":["thread",25351],"thread-25233":["thread",25233],"thread-24819":["thread",24819],"thread-24512":["thread",24512],"thread-23855":["thread",23855],"thread-23770":["thread",23770],"thread-23554":["thread",23554],"thread-23424":["thread",23424],"thread-23285":["thread",23285],"thread-23275":["thread",23275],"thread-23205":["thread",23205],"thread-23024":["thread",23024],"thread-22980":["thread",22980],"thread-22788":["thread",22788],"thread-22429":["thread",22429],"thread-22425":["thread",22425],"thread-22261":["thread",22261],"thread-22193":["thread",22193],"thread-21815":["thread",21815],"thread-21403":["thread",21403],"thread-21356":["thread",21356],"thread-21127":["thread",21127],"thread-20998":["thread",20998],"thread-20997":["thread",20997],"thread-20852":["thread",20852],"thread-20372":["thread",20372],"thread-20369":["thread",20369],"thread-20319":["thread",20319],"thread-20266":["thread",20266],"thread-20240":["thread",20240],"thread-19925":["thread",19925],"thread-19735":["thread",19735],"thread-19365":["thread",19365],"thread-18827":["thread",18827],"thread-18293":["thread",18293],"thread-18187":["thread",18187],"thread-17998":["thread",17998],"thread-17983":["thread",17983],"thread-17978":["thread",17978],"thread-17846":["thread",17846],"thread-17774":["thread",17774],"thread-17274":["thread",17274],"thread-16674":["thread",16674],"thread-16152":["thread",16152],"thread-15787":["thread",15787],"thread-15457":["thread",15457],"thread-15047":["thread",15047],"thread-14654":["thread",14654],"thread-14589":["thread",14589],"thread-14563":["thread",14563],"thread-14215":["thread",14215],"thread-14126":["thread",14126],"thread-14070":["thread",14070],"thread-13816":["thread",13816],"thread-13724":["thread",13724],"thread-13453":["thread",13453],"thread-13259":["thread",13259],"thread-12837":["thread",12837],"thread-12403":["thread",12403],"thread-12402":["thread",12402],"thread-12146":["thread",12146],"thread-11902":["thread",11902],"thread-11825":["thread",11825],"thread-11806":["thread",11806],"thread-11781":["thread",11781],"thread-11214":["thread",11214],"thread-11042":["thread",11042],"thread-11037":["thread",11037],"thread-11036":["thread",11036],"thread-11004":["thread",11004],"thread-10927":["thread",10927],"thread-10926":["thread",10926],"thread-10809":["thread",10809],"thread-10722":["thread",10722],"thread-10666":["thread",10666],"thread-10468":["thread",10468],"thread-10451":["thread",10451],"thread-10439":["thread",10439],"thread-10437":["thread",10437],"thread-10345":["thread",10345],"thread-10303":["thread",10303],"thread-10276":["thread",10276],"thread-10264":["thread",10264],"thread-10215":["thread",10215],"thread-10213":["thread",10213],"thread-10155":["thread",10155],"thread-10145":["thread",10145],"thread-10126":["thread",10126],"thread-10089":["thread",10089],"thread-10081":["thread",10081],"thread-10069":["thread",10069],"thread-10063":["thread",10063],"thread-10047":["thread",10047],"thread-10043":["thread",10043],"thread-10041":["thread",10041],"thread-9916":["thread",9916],"thread-9901":["thread",9901],"thread-9869":["thread",9869],"thread-9797":["thread",9797],"thread-3173":["thread",3173],"thread-1142":["thread",1142]}, NULL, 1711715666
Run Time: 0.000135
- 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