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 (173647, 173038, 173035, 173034, 166357, 164506, 154974, 154971, 154969, 154916, 154874, 153328, 135041, 120830, 111297, 85726, 81717, 81670, 79233, 79083, 78859, 78560, 78557, 78398, 78394, 78368, 78249, 77665, 77563, 76222, 75449, 75447, 75419, 75329, 75191, 75190, 74611, 74226, 74202, 73988, 73694, 73025, 72922, 72835, 72832, 72772, 72699, 72696, 72650, 72571, 72559, 72458, 72440, 72430, 72427, 71885, 71759, 71750, 71703, 71701, 71658, 71640, 71589, 71587, 71576, 71573, 71562, 71287, 71276, 71238, 71150, 71102, 71087, 70904, 70289, 69996, 69844, 69587, 69518, 69276, 69255, 68995, 68839, 68836, 68834, 68826, 68772, 68770, 68559, 68518, 68225, 68211, 68210, 68208, 68051, 67818, 67760, 67549, 67537, 67484, 67385, 67383, 67174, 67062, 66951, 66949, 66715, 66539, 66518, 66511, 66460, 66397, 66336, 66207, 66173, 66050, 66041, 65934, 65933, 65856, 65680, 64902, 64482, 63126, 62511, 62360, 62316, 62205, 62025, 61804, 61713, 61611, 61466, 61167, 61058, 61052, 60814, 60723, 60577, 60319, 60146, 60100, 59824, 59796, 59190, 59141, 58915, 58410, 58408, 58340, 58157, 58125, 58024, 57819, 57720, 57693, 57692, 57048, 57009, 56795, 56756, 56692, 56688, 56674, 56600, 56547, 56535, 56290, 56270, 56241, 56239, 56211, 56188, 55789, 55661, 55392, 55321, 55317, 55194, 54938, 54936, 54594, 54281, 54222, 53915, 53840, 53687, 53683, 53637, 53635, 52946, 52940, 52898, 52430, 52337, 52286, 52203))
Run Time: 0.122443
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 197 | 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: 5854, 0, 1714903983, {"thread-173647":["thread",173647],"thread-173038":["thread",173038],"thread-173035":["thread",173035],"thread-173034":["thread",173034],"thread-166357":["thread",166357],"thread-164506":["thread",164506],"tl_group-211":["tl_group",211],"thread-154974":["thread",154974],"thread-154971":["thread",154971],"thread-154969":["thread",154969],"thread-154916":["thread",154916],"thread-154874":["thread",154874],"ams_article-4119":["ams_article",4119],"thread-153328":["thread",153328],"thread-135041":["thread",135041],"thread-120830":["thread",120830],"thread-111297":["thread",111297],"thread-85726":["thread",85726],"thread-81717":["thread",81717],"thread-81670":["thread",81670],"thread-79233":["thread",79233],"thread-79083":["thread",79083],"thread-78859":["thread",78859],"thread-78560":["thread",78560],"thread-78557":["thread",78557],"thread-78398":["thread",78398],"thread-78394":["thread",78394],"thread-78368":["thread",78368],"thread-78249":["thread",78249],"thread-77665":["thread",77665],"thread-76222":["thread",76222],"thread-75449":["thread",75449],"thread-75447":["thread",75447],"thread-75419":["thread",75419],"thread-75329":["thread",75329],"thread-75191":["thread",75191],"thread-75190":["thread",75190],"thread-74611":["thread",74611],"thread-74226":["thread",74226],"thread-74202":["thread",74202],"thread-73988":["thread",73988],"thread-73694":["thread",73694],"thread-73025":["thread",73025],"thread-72922":["thread",72922],"thread-72835":["thread",72835],"thread-72832":["thread",72832],"thread-72772":["thread",72772],"thread-72699":["thread",72699],"thread-72696":["thread",72696],"thread-72650":["thread",72650],"thread-72571":["thread",72571],"thread-72559":["thread",72559],"thread-72458":["thread",72458],"thread-72440":["thread",72440],"thread-72430":["thread",72430],"thread-72427":["thread",72427],"thread-71885":["thread",71885],"thread-71759":["thread",71759],"thread-71750":["thread",71750],"thread-71703":["thread",71703],"thread-71701":["thread",71701],"thread-71658":["thread",71658],"thread-71640":["thread",71640],"thread-71589":["thread",71589],"thread-71587":["thread",71587],"thread-71576":["thread",71576],"thread-71573":["thread",71573],"thread-71562":["thread",71562],"thread-71287":["thread",71287],"thread-71276":["thread",71276],"thread-71238":["thread",71238],"thread-71150":["thread",71150],"thread-71102":["thread",71102],"thread-71087":["thread",71087],"thread-70904":["thread",70904],"thread-70289":["thread",70289],"thread-69996":["thread",69996],"thread-69844":["thread",69844],"thread-69587":["thread",69587],"thread-69518":["thread",69518],"thread-69276":["thread",69276],"thread-69255":["thread",69255],"thread-68995":["thread",68995],"thread-68839":["thread",68839],"thread-68836":["thread",68836],"thread-68834":["thread",68834],"thread-68826":["thread",68826],"thread-68772":["thread",68772],"thread-68770":["thread",68770],"thread-68559":["thread",68559],"thread-68518":["thread",68518],"thread-68225":["thread",68225],"thread-68211":["thread",68211],"thread-68210":["thread",68210],"thread-68208":["thread",68208],"thread-68051":["thread",68051],"thread-67818":["thread",67818],"thread-67760":["thread",67760],"thread-67549":["thread",67549],"thread-67537":["thread",67537],"thread-67484":["thread",67484],"thread-67385":["thread",67385],"thread-67383":["thread",67383],"thread-67174":["thread",67174],"thread-67062":["thread",67062],"thread-66951":["thread",66951],"thread-66949":["thread",66949],"thread-66715":["thread",66715],"thread-66539":["thread",66539],"thread-66518":["thread",66518],"thread-66511":["thread",66511],"thread-66460":["thread",66460],"thread-66397":["thread",66397],"thread-66336":["thread",66336],"thread-66207":["thread",66207],"thread-66173":["thread",66173],"thread-66050":["thread",66050],"thread-66041":["thread",66041],"thread-65934":["thread",65934],"thread-65933":["thread",65933],"thread-65856":["thread",65856],"thread-65680":["thread",65680],"thread-64902":["thread",64902],"thread-64482":["thread",64482],"thread-63126":["thread",63126],"thread-62511":["thread",62511],"thread-62360":["thread",62360],"thread-62316":["thread",62316],"thread-62205":["thread",62205],"thread-62025":["thread",62025],"thread-61804":["thread",61804],"thread-61713":["thread",61713],"thread-61611":["thread",61611],"thread-61466":["thread",61466],"thread-61167":["thread",61167],"thread-61058":["thread",61058],"thread-61052":["thread",61052],"thread-60814":["thread",60814],"thread-60723":["thread",60723],"thread-60577":["thread",60577],"thread-60319":["thread",60319],"thread-60146":["thread",60146],"thread-60100":["thread",60100],"thread-59824":["thread",59824],"thread-59796":["thread",59796],"thread-59190":["thread",59190],"thread-59141":["thread",59141],"thread-58915":["thread",58915],"thread-58410":["thread",58410],"thread-58408":["thread",58408],"thread-58340":["thread",58340],"thread-58157":["thread",58157],"thread-58125":["thread",58125],"thread-58024":["thread",58024],"thread-57819":["thread",57819],"thread-57720":["thread",57720],"thread-57693":["thread",57693],"thread-57692":["thread",57692],"thread-57048":["thread",57048],"thread-57009":["thread",57009],"thread-56795":["thread",56795],"thread-56756":["thread",56756],"thread-56692":["thread",56692],"thread-56688":["thread",56688],"thread-56674":["thread",56674],"thread-56600":["thread",56600],"thread-56547":["thread",56547],"thread-56535":["thread",56535],"thread-56290":["thread",56290],"thread-56270":["thread",56270],"thread-56241":["thread",56241],"thread-56239":["thread",56239],"thread-56211":["thread",56211],"thread-56188":["thread",56188],"thread-55789":["thread",55789],"thread-55661":["thread",55661],"thread-55392":["thread",55392],"thread-55321":["thread",55321],"thread-55317":["thread",55317],"thread-55194":["thread",55194],"thread-54938":["thread",54938],"thread-54936":["thread",54936],"thread-54594":["thread",54594],"thread-54281":["thread",54281],"thread-54222":["thread",54222],"thread-53915":["thread",53915],"thread-53840":["thread",53840],"thread-53687":["thread",53687],"thread-53683":["thread",53683],"thread-53637":["thread",53637],"thread-53635":["thread",53635],"thread-52946":["thread",52946],"thread-52940":["thread",52940],"thread-52898":["thread",52898],"thread-52430":["thread",52430],"thread-52337":["thread",52337],"thread-52286":["thread",52286],"thread-52203":["thread",52203]}, , 1714900383
Run Time: 0.000307
- 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