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 (180250, 117055, 110477, 110394, 110114, 110098, 108694, 108290, 107855, 107662, 103074, 103027, 103025, 103024, 99880, 95290, 95149, 94488, 94137, 94107, 93517, 93330, 93323, 93321, 91631, 91578, 91526, 91519, 91476, 91451, 91446, 91397, 91255, 90985, 89509, 87695, 87464, 87436, 86840, 86804, 86716, 86194, 85095, 84954, 84817, 83321, 80796, 79858, 79826, 78217, 77188, 76471, 76450, 76347, 71952, 71234, 70823, 68236, 67568, 65534, 65205, 64269, 62641, 62454, 62274, 62143, 61728, 61521, 61330, 61258, 61228, 61201, 61131, 61129, 60469, 60174, 60173, 60172, 60094, 60093, 60092, 60091, 60090, 60034, 59886, 59734, 59126, 59050, 59034, 58321, 57813, 57170, 56770, 56769, 56768, 56760, 56407, 55753, 55696, 55614, 55602, 55243, 55177, 54724, 54662, 54237, 54208, 53938, 53766, 53590, 53577, 53485, 53460, 53196, 53063, 52722, 52587, 52260, 52191, 52080, 51998, 51927, 51877, 51738, 51455, 51423, 51348, 51347, 51275, 51210, 51173, 51043, 51023, 50957, 50917, 50610, 50521, 50477, 50476, 50453, 50241, 50176, 50168, 50085, 50033, 50029, 50012, 50011, 50010, 48890, 48747, 48608, 48556, 48482, 44808, 43565, 41896, 40022))
Run Time: 0.091056
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 158 | 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: 7809, 0, 1715090582, {"thread-180250":["thread",180250],"tl_group-363":["tl_group",363],"thread-117055":["thread",117055],"thread-110477":["thread",110477],"thread-110394":["thread",110394],"thread-110114":["thread",110114],"thread-110098":["thread",110098],"thread-108694":["thread",108694],"thread-108290":["thread",108290],"thread-107855":["thread",107855],"thread-107662":["thread",107662],"thread-103074":["thread",103074],"thread-103027":["thread",103027],"thread-103025":["thread",103025],"thread-103024":["thread",103024],"thread-99880":["thread",99880],"thread-95290":["thread",95290],"thread-95149":["thread",95149],"thread-94488":["thread",94488],"thread-94137":["thread",94137],"thread-94107":["thread",94107],"thread-93517":["thread",93517],"thread-93330":["thread",93330],"thread-93323":["thread",93323],"thread-93321":["thread",93321],"thread-91631":["thread",91631],"thread-91578":["thread",91578],"thread-91526":["thread",91526],"thread-91519":["thread",91519],"thread-91476":["thread",91476],"thread-91451":["thread",91451],"thread-91446":["thread",91446],"thread-91397":["thread",91397],"thread-91255":["thread",91255],"thread-90985":["thread",90985],"thread-89509":["thread",89509],"thread-87695":["thread",87695],"thread-87464":["thread",87464],"thread-87436":["thread",87436],"thread-86840":["thread",86840],"thread-86804":["thread",86804],"thread-86716":["thread",86716],"thread-86194":["thread",86194],"thread-85095":["thread",85095],"thread-84954":["thread",84954],"thread-84817":["thread",84817],"thread-83321":["thread",83321],"thread-80796":["thread",80796],"thread-79858":["thread",79858],"thread-79826":["thread",79826],"thread-78217":["thread",78217],"thread-77188":["thread",77188],"thread-76471":["thread",76471],"thread-76450":["thread",76450],"thread-76347":["thread",76347],"thread-71952":["thread",71952],"thread-71234":["thread",71234],"thread-70823":["thread",70823],"thread-68236":["thread",68236],"thread-67568":["thread",67568],"thread-65534":["thread",65534],"thread-65205":["thread",65205],"thread-64269":["thread",64269],"thread-62641":["thread",62641],"thread-62454":["thread",62454],"thread-62274":["thread",62274],"thread-62143":["thread",62143],"thread-61728":["thread",61728],"thread-61521":["thread",61521],"thread-61330":["thread",61330],"thread-61258":["thread",61258],"thread-61228":["thread",61228],"thread-61201":["thread",61201],"thread-61131":["thread",61131],"thread-61129":["thread",61129],"thread-60469":["thread",60469],"thread-60174":["thread",60174],"thread-60173":["thread",60173],"thread-60172":["thread",60172],"thread-60094":["thread",60094],"thread-60093":["thread",60093],"thread-60092":["thread",60092],"thread-60091":["thread",60091],"thread-60090":["thread",60090],"thread-60034":["thread",60034],"thread-59886":["thread",59886],"thread-59734":["thread",59734],"thread-59126":["thread",59126],"thread-59050":["thread",59050],"thread-59034":["thread",59034],"thread-58321":["thread",58321],"thread-57813":["thread",57813],"thread-57170":["thread",57170],"thread-56770":["thread",56770],"thread-56769":["thread",56769],"thread-56768":["thread",56768],"thread-56760":["thread",56760],"thread-56407":["thread",56407],"thread-55753":["thread",55753],"thread-55696":["thread",55696],"thread-55614":["thread",55614],"thread-55602":["thread",55602],"thread-55243":["thread",55243],"thread-55177":["thread",55177],"thread-54724":["thread",54724],"thread-54662":["thread",54662],"thread-54237":["thread",54237],"thread-54208":["thread",54208],"thread-53938":["thread",53938],"thread-53766":["thread",53766],"thread-53590":["thread",53590],"thread-53577":["thread",53577],"thread-53485":["thread",53485],"thread-53460":["thread",53460],"thread-53196":["thread",53196],"thread-53063":["thread",53063],"thread-52722":["thread",52722],"thread-52587":["thread",52587],"thread-52260":["thread",52260],"thread-52191":["thread",52191],"thread-52080":["thread",52080],"thread-51998":["thread",51998],"thread-51927":["thread",51927],"thread-51877":["thread",51877],"thread-51738":["thread",51738],"thread-51455":["thread",51455],"thread-51423":["thread",51423],"thread-51348":["thread",51348],"thread-51347":["thread",51347],"thread-51275":["thread",51275],"thread-51210":["thread",51210],"thread-51173":["thread",51173],"thread-51043":["thread",51043],"thread-51023":["thread",51023],"thread-50957":["thread",50957],"thread-50917":["thread",50917],"thread-50610":["thread",50610],"thread-50521":["thread",50521],"thread-50477":["thread",50477],"thread-50476":["thread",50476],"thread-50453":["thread",50453],"thread-50241":["thread",50241],"thread-50176":["thread",50176],"thread-50168":["thread",50168],"thread-50085":["thread",50085],"thread-50033":["thread",50033],"thread-50029":["thread",50029],"thread-50012":["thread",50012],"thread-50011":["thread",50011],"thread-50010":["thread",50010],"thread-48890":["thread",48890],"thread-48747":["thread",48747],"thread-48608":["thread",48608],"thread-48556":["thread",48556],"thread-48482":["thread",48482],"thread-44808":["thread",44808],"thread-43565":["thread",43565],"thread-41896":["thread",41896],"thread-40022":["thread",40022]}, , 1715086982
Run Time: 0.000314
- 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