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 (101154, 100788, 100176, 100163, 99851, 92796, 98651, 97950, 97686, 97488, 97251, 96933, 96644, 95886, 95453, 94614, 92812, 91862, 89698, 89110, 88334, 86605, 85081, 85039, 84584, 84523, 83505, 83409, 82537, 82484, 81868, 80017, 79261, 79225, 79209, 77264, 76932, 76874, 76847, 76731, 76706, 76618, 76516, 76404, 76369, 76368, 76322, 76303, 76251, 76250, 76213, 76180, 76162, 76098, 76097, 76078, 76077, 75915, 75914, 75891, 75843, 75834, 75702, 75619, 75552, 75551, 75507, 75506, 75441, 75408, 75350, 75349, 75315, 75259, 75258, 75233, 75232, 74863, 74828, 74827, 74738, 74717, 74716, 74639, 74622, 74614, 74551, 74515, 74458, 74456, 74439, 74425, 74424, 74358, 74357, 74325, 74324, 74162, 74078, 73541, 73349, 73116, 72909, 72908, 72690, 72684, 72403, 72393, 72384, 72346, 72332, 72304, 72298, 72293, 72290, 72283, 72255, 72241, 72233, 72211, 72188, 72182, 72127, 72112, 71658, 71657, 71660, 71730, 71747, 71769, 71788, 71802, 71834, 71520, 71799, 71537, 71676, 71476, 71481, 71519, 71567, 71634, 71475, 71514, 71518, 71532, 71662, 71647, 71650, 71664, 71717, 71716, 71672, 71675, 71775, 71827, 71891, 71828, 71888, 71904, 71906, 71937, 71944, 71917, 71924, 71943, 71942, 71946, 71953, 71952, 71998, 72005, 72013, 71899, 71756, 71745, 71875, 71954, 72050, 71916, 72006, 71635, 71995, 71663, 71648, 71659, 71963, 71758, 72032, 72056, 72049, 72065, 71889, 72017, 72048, 72047, 71873, 71833, 71832, 71950, 72036, 72081, 72084, 71909, 72100, 72104, 71565, 71563, 71582, 71593, 72025, 71945, 71947, 71640, 57727, 56640, 55042, 55035, 52565, 51740, 45052, 44582, 44231, 44221, 38116, 37519, 36184, 36149, 34870, 34789, 34520, 34434, 34304, 31142, 29572, 29265, 19521, 5217, 4259, 4150, 3264, 2378, 1420, 1414, 277))
Run Time: 0.003240
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 245 | 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: 2156, 0, 1714824429, {"thread-101154":["thread",101154],"thread-100788":["thread",100788],"thread-100176":["thread",100176],"thread-100163":["thread",100163],"thread-99851":["thread",99851],"thread-92796":["thread",92796],"thread-98651":["thread",98651],"thread-97950":["thread",97950],"thread-97686":["thread",97686],"thread-97488":["thread",97488],"thread-97251":["thread",97251],"thread-96933":["thread",96933],"thread-96644":["thread",96644],"thread-95886":["thread",95886],"thread-95453":["thread",95453],"thread-94614":["thread",94614],"thread-92812":["thread",92812],"thread-91862":["thread",91862],"thread-89698":["thread",89698],"thread-89110":["thread",89110],"thread-88334":["thread",88334],"thread-86605":["thread",86605],"thread-85081":["thread",85081],"thread-85039":["thread",85039],"thread-84584":["thread",84584],"thread-84523":["thread",84523],"thread-83505":["thread",83505],"thread-83409":["thread",83409],"thread-82537":["thread",82537],"thread-82484":["thread",82484],"thread-81868":["thread",81868],"thread-80017":["thread",80017],"thread-79261":["thread",79261],"thread-79225":["thread",79225],"thread-79209":["thread",79209],"thread-77264":["thread",77264],"thread-76932":["thread",76932],"thread-76874":["thread",76874],"thread-76847":["thread",76847],"thread-76731":["thread",76731],"thread-76706":["thread",76706],"thread-76618":["thread",76618],"thread-76516":["thread",76516],"thread-76404":["thread",76404],"thread-76369":["thread",76369],"thread-76368":["thread",76368],"thread-76322":["thread",76322],"thread-76303":["thread",76303],"thread-76251":["thread",76251],"thread-76250":["thread",76250],"thread-76213":["thread",76213],"thread-76180":["thread",76180],"thread-76162":["thread",76162],"thread-76098":["thread",76098],"thread-76097":["thread",76097],"thread-76078":["thread",76078],"thread-76077":["thread",76077],"thread-75915":["thread",75915],"thread-75914":["thread",75914],"thread-75891":["thread",75891],"thread-75843":["thread",75843],"thread-75834":["thread",75834],"thread-75702":["thread",75702],"thread-75619":["thread",75619],"thread-75552":["thread",75552],"thread-75551":["thread",75551],"thread-75507":["thread",75507],"thread-75506":["thread",75506],"thread-75441":["thread",75441],"thread-75408":["thread",75408],"thread-75350":["thread",75350],"thread-75349":["thread",75349],"thread-75315":["thread",75315],"thread-75259":["thread",75259],"thread-75258":["thread",75258],"thread-75233":["thread",75233],"thread-75232":["thread",75232],"thread-74863":["thread",74863],"thread-74828":["thread",74828],"thread-74827":["thread",74827],"thread-74738":["thread",74738],"thread-74717":["thread",74717],"thread-74716":["thread",74716],"thread-74639":["thread",74639],"thread-74622":["thread",74622],"thread-74614":["thread",74614],"thread-74551":["thread",74551],"thread-74515":["thread",74515],"thread-74458":["thread",74458],"thread-74456":["thread",74456],"thread-74439":["thread",74439],"thread-74425":["thread",74425],"thread-74424":["thread",74424],"thread-74358":["thread",74358],"thread-74357":["thread",74357],"thread-74325":["thread",74325],"thread-74324":["thread",74324],"thread-74162":["thread",74162],"thread-74078":["thread",74078],"thread-73541":["thread",73541],"thread-73349":["thread",73349],"thread-73116":["thread",73116],"thread-72909":["thread",72909],"thread-72908":["thread",72908],"thread-72690":["thread",72690],"thread-72684":["thread",72684],"thread-72403":["thread",72403],"thread-72393":["thread",72393],"thread-72384":["thread",72384],"thread-72346":["thread",72346],"thread-72332":["thread",72332],"thread-72304":["thread",72304],"thread-72298":["thread",72298],"thread-72293":["thread",72293],"thread-72290":["thread",72290],"thread-72283":["thread",72283],"thread-72255":["thread",72255],"thread-72241":["thread",72241],"thread-72233":["thread",72233],"thread-72211":["thread",72211],"thread-72188":["thread",72188],"thread-72182":["thread",72182],"thread-72127":["thread",72127],"thread-72112":["thread",72112],"thread-71658":["thread",71658],"thread-71657":["thread",71657],"thread-71660":["thread",71660],"thread-71730":["thread",71730],"thread-71747":["thread",71747],"thread-71769":["thread",71769],"thread-71788":["thread",71788],"thread-71802":["thread",71802],"thread-71834":["thread",71834],"thread-71520":["thread",71520],"thread-71799":["thread",71799],"thread-71537":["thread",71537],"thread-71676":["thread",71676],"thread-71476":["thread",71476],"thread-71481":["thread",71481],"thread-71519":["thread",71519],"thread-71567":["thread",71567],"thread-71634":["thread",71634],"thread-71475":["thread",71475],"thread-71514":["thread",71514],"thread-71518":["thread",71518],"thread-71532":["thread",71532],"thread-71662":["thread",71662],"thread-71647":["thread",71647],"thread-71650":["thread",71650],"thread-71664":["thread",71664],"thread-71717":["thread",71717],"thread-71716":["thread",71716],"thread-71672":["thread",71672],"thread-71675":["thread",71675],"thread-71775":["thread",71775],"thread-71827":["thread",71827],"thread-71891":["thread",71891],"thread-71828":["thread",71828],"thread-71888":["thread",71888],"thread-71904":["thread",71904],"thread-71906":["thread",71906],"thread-71937":["thread",71937],"thread-71944":["thread",71944],"thread-71917":["thread",71917],"thread-71924":["thread",71924],"thread-71943":["thread",71943],"thread-71942":["thread",71942],"thread-71946":["thread",71946],"thread-71953":["thread",71953],"thread-71952":["thread",71952],"thread-71998":["thread",71998],"thread-72005":["thread",72005],"thread-72013":["thread",72013],"thread-71899":["thread",71899],"thread-71756":["thread",71756],"thread-71745":["thread",71745],"thread-71875":["thread",71875],"thread-71954":["thread",71954],"thread-72050":["thread",72050],"thread-71916":["thread",71916],"thread-72006":["thread",72006],"thread-71635":["thread",71635],"thread-71995":["thread",71995],"thread-71663":["thread",71663],"thread-71648":["thread",71648],"thread-71659":["thread",71659],"thread-71963":["thread",71963],"thread-71758":["thread",71758],"thread-72032":["thread",72032],"thread-72056":["thread",72056],"thread-72049":["thread",72049],"thread-72065":["thread",72065],"thread-71889":["thread",71889],"thread-72017":["thread",72017],"thread-72048":["thread",72048],"thread-72047":["thread",72047],"thread-71873":["thread",71873],"thread-71833":["thread",71833],"thread-71832":["thread",71832],"thread-71950":["thread",71950],"thread-72036":["thread",72036],"thread-72081":["thread",72081],"thread-72084":["thread",72084],"thread-71909":["thread",71909],"thread-72100":["thread",72100],"thread-72104":["thread",72104],"thread-71565":["thread",71565],"thread-71563":["thread",71563],"thread-71582":["thread",71582],"thread-71593":["thread",71593],"thread-72025":["thread",72025],"thread-71945":["thread",71945],"thread-71947":["thread",71947],"thread-71640":["thread",71640],"thread-57727":["thread",57727],"thread-56640":["thread",56640],"thread-55042":["thread",55042],"thread-55035":["thread",55035],"thread-52565":["thread",52565],"thread-51740":["thread",51740],"thread-45052":["thread",45052],"thread-44582":["thread",44582],"thread-44231":["thread",44231],"thread-44221":["thread",44221],"thread-38116":["thread",38116],"thread-37519":["thread",37519],"thread-36184":["thread",36184],"thread-36149":["thread",36149],"thread-34870":["thread",34870],"thread-34789":["thread",34789],"thread-34520":["thread",34520],"thread-34434":["thread",34434],"thread-34304":["thread",34304],"thread-31142":["thread",31142],"thread-29572":["thread",29572],"thread-29265":["thread",29265],"thread-19521":["thread",19521],"thread-5217":["thread",5217],"thread-4259":["thread",4259],"thread-4150":["thread",4150],"thread-3264":["thread",3264],"thread-2378":["thread",2378],"thread-1420":["thread",1420],"thread-1414":["thread",1414],"thread-277":["thread",277]}, NULL, 1714820829
Run Time: 0.000148
- 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