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 (177847, 127228, 124646, 123978, 118989, 114587, 102141, 101099, 99912, 99663, 99615, 96853, 96635, 94867, 90349, 89981, 87733, 87666, 87569, 86804, 86765, 86547, 84985, 84953, 84746, 83350, 82771, 82532, 82256, 82149, 81774, 81714, 81290, 80553, 80475, 80294, 79820, 79758, 78665, 78515, 78430, 78264, 77797, 77603, 77354, 77074, 77041, 76874, 76531, 76066, 75567, 75549, 75484, 75478, 75403, 75377, 75194, 75175, 75114, 74721, 74666, 74416, 74202, 73754, 73508, 73496, 73442, 73397, 73371, 73085, 72896, 72799, 72647, 72512, 72506, 72090, 71863, 71787, 71726, 71725, 71718, 71676, 71634, 71445, 71434, 71327, 71283, 71121, 70973, 70805, 70787, 70638, 70446, 70430, 69637, 69521, 69298, 69172, 68625, 68450, 67959, 67452, 67316, 66926, 66784, 66744, 66656, 66655, 66535, 66320, 65729, 65683, 65473, 65139, 65108, 65067, 65040, 64552, 64505, 64393, 64379, 64012, 63204, 63195, 63150, 63119, 62833, 62631, 62575, 62481, 61931, 61819, 61774, 61578, 61351, 61152, 60874, 60273, 59297, 58973, 58717, 58480, 58467, 58267, 58162, 58157, 58034, 58029, 58028, 57667, 57645, 57636, 57529, 57401, 57318, 57311, 57231, 57167, 57160, 57144, 56697, 56456, 56379, 55593, 55521, 54980, 54934, 54526, 54469, 54038, 53757, 53752, 53717, 53583, 53539, 53413, 53302, 52744, 52077, 51929, 51919, 51655, 51299, 51081, 51042, 51041, 50818, 50740, 50526, 50089, 50074, 49998, 49778, 49777, 49752, 49695, 49656, 49572, 49563, 49501))
Run Time: 0.103235
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.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 1387
- 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 2729
- 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 137
- 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 2351
- XF\App->run() in src/XF.php at line 517
- 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: 588, 0, 1714386759, {"thread-177847":["thread",177847],"thread-127228":["thread",127228],"thread-124646":["thread",124646],"thread-123978":["thread",123978],"thread-118989":["thread",118989],"thread-114587":["thread",114587],"thread-102141":["thread",102141],"thread-101099":["thread",101099],"thread-99912":["thread",99912],"thread-99663":["thread",99663],"thread-99615":["thread",99615],"thread-96853":["thread",96853],"thread-96635":["thread",96635],"thread-94867":["thread",94867],"thread-90349":["thread",90349],"thread-89981":["thread",89981],"thread-87733":["thread",87733],"thread-87666":["thread",87666],"thread-87569":["thread",87569],"thread-86804":["thread",86804],"thread-86765":["thread",86765],"thread-86547":["thread",86547],"thread-84985":["thread",84985],"thread-84953":["thread",84953],"thread-84746":["thread",84746],"thread-83350":["thread",83350],"thread-82771":["thread",82771],"thread-82532":["thread",82532],"thread-82256":["thread",82256],"thread-82149":["thread",82149],"thread-81774":["thread",81774],"thread-81714":["thread",81714],"thread-81290":["thread",81290],"thread-80553":["thread",80553],"thread-80475":["thread",80475],"thread-80294":["thread",80294],"thread-79820":["thread",79820],"thread-79758":["thread",79758],"thread-78665":["thread",78665],"thread-78515":["thread",78515],"thread-78430":["thread",78430],"thread-78264":["thread",78264],"thread-77797":["thread",77797],"thread-77603":["thread",77603],"thread-77354":["thread",77354],"thread-77074":["thread",77074],"thread-77041":["thread",77041],"thread-76874":["thread",76874],"thread-76531":["thread",76531],"thread-76066":["thread",76066],"thread-75567":["thread",75567],"thread-75549":["thread",75549],"thread-75484":["thread",75484],"thread-75478":["thread",75478],"thread-75403":["thread",75403],"thread-75377":["thread",75377],"thread-75194":["thread",75194],"thread-75175":["thread",75175],"thread-75114":["thread",75114],"thread-74721":["thread",74721],"thread-74666":["thread",74666],"thread-74416":["thread",74416],"thread-74202":["thread",74202],"thread-73754":["thread",73754],"thread-73508":["thread",73508],"thread-73496":["thread",73496],"thread-73442":["thread",73442],"thread-73397":["thread",73397],"thread-73371":["thread",73371],"thread-73085":["thread",73085],"thread-72896":["thread",72896],"thread-72799":["thread",72799],"thread-72647":["thread",72647],"thread-72512":["thread",72512],"thread-72506":["thread",72506],"thread-72090":["thread",72090],"thread-71863":["thread",71863],"thread-71787":["thread",71787],"thread-71726":["thread",71726],"thread-71725":["thread",71725],"thread-71718":["thread",71718],"thread-71676":["thread",71676],"thread-71634":["thread",71634],"thread-71445":["thread",71445],"thread-71434":["thread",71434],"thread-71327":["thread",71327],"thread-71283":["thread",71283],"thread-71121":["thread",71121],"thread-70973":["thread",70973],"thread-70805":["thread",70805],"thread-70787":["thread",70787],"thread-70638":["thread",70638],"thread-70446":["thread",70446],"thread-70430":["thread",70430],"thread-69637":["thread",69637],"thread-69521":["thread",69521],"thread-69298":["thread",69298],"thread-69172":["thread",69172],"thread-68625":["thread",68625],"thread-68450":["thread",68450],"thread-67959":["thread",67959],"thread-67452":["thread",67452],"thread-67316":["thread",67316],"thread-66926":["thread",66926],"thread-66784":["thread",66784],"thread-66744":["thread",66744],"thread-66656":["thread",66656],"thread-66655":["thread",66655],"thread-66535":["thread",66535],"thread-66320":["thread",66320],"thread-65729":["thread",65729],"thread-65683":["thread",65683],"thread-65473":["thread",65473],"thread-65139":["thread",65139],"thread-65108":["thread",65108],"thread-65067":["thread",65067],"thread-65040":["thread",65040],"thread-64552":["thread",64552],"thread-64505":["thread",64505],"thread-64393":["thread",64393],"thread-64379":["thread",64379],"thread-64012":["thread",64012],"thread-63204":["thread",63204],"thread-63195":["thread",63195],"thread-63150":["thread",63150],"thread-63119":["thread",63119],"thread-62833":["thread",62833],"thread-62631":["thread",62631],"thread-62575":["thread",62575],"thread-62481":["thread",62481],"thread-61931":["thread",61931],"thread-61819":["thread",61819],"thread-61774":["thread",61774],"thread-61578":["thread",61578],"thread-61351":["thread",61351],"thread-61152":["thread",61152],"thread-60874":["thread",60874],"thread-60273":["thread",60273],"thread-59297":["thread",59297],"thread-58973":["thread",58973],"thread-58717":["thread",58717],"thread-58480":["thread",58480],"thread-58467":["thread",58467],"thread-58267":["thread",58267],"thread-58162":["thread",58162],"thread-58157":["thread",58157],"thread-58034":["thread",58034],"thread-58029":["thread",58029],"thread-58028":["thread",58028],"thread-57667":["thread",57667],"thread-57645":["thread",57645],"thread-57636":["thread",57636],"thread-57529":["thread",57529],"thread-57401":["thread",57401],"thread-57318":["thread",57318],"thread-57311":["thread",57311],"thread-57231":["thread",57231],"thread-57167":["thread",57167],"thread-57160":["thread",57160],"thread-57144":["thread",57144],"thread-56697":["thread",56697],"thread-56456":["thread",56456],"thread-56379":["thread",56379],"thread-55593":["thread",55593],"thread-55521":["thread",55521],"thread-54980":["thread",54980],"thread-54934":["thread",54934],"thread-54526":["thread",54526],"thread-54469":["thread",54469],"thread-54038":["thread",54038],"thread-53757":["thread",53757],"thread-53752":["thread",53752],"thread-53717":["thread",53717],"thread-53583":["thread",53583],"thread-53539":["thread",53539],"thread-53413":["thread",53413],"thread-53302":["thread",53302],"thread-52744":["thread",52744],"thread-52077":["thread",52077],"thread-51929":["thread",51929],"thread-51919":["thread",51919],"thread-51655":["thread",51655],"thread-51299":["thread",51299],"thread-51081":["thread",51081],"thread-51042":["thread",51042],"thread-51041":["thread",51041],"thread-50818":["thread",50818],"thread-50740":["thread",50740],"thread-50526":["thread",50526],"thread-50089":["thread",50089],"thread-50074":["thread",50074],"thread-49998":["thread",49998],"thread-49778":["thread",49778],"thread-49777":["thread",49777],"thread-49752":["thread",49752],"thread-49695":["thread",49695],"thread-49656":["thread",49656],"thread-49572":["thread",49572],"thread-49563":["thread",49563],"thread-49501":["thread",49501]}, , 1714383159
Run Time: 0.000553
- 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 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 150
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20