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 (58859, 53487, 53115, 52737, 51372, 51326, 51325, 51324, 50691, 50571, 50545, 50459, 50447, 50429, 50330, 50256, 50245, 50227, 50208, 50204, 50195, 50194, 49816, 49353, 49352, 49345, 49326, 49325, 49250, 49159, 49153, 49152, 49147, 49127, 49047, 49037, 49035, 49029, 49023, 48963, 48962, 48836, 48835, 48815, 48812, 48792, 48716, 48713, 48711, 48710, 48709, 48695, 48687, 48684, 48683, 48620, 48569, 48568, 48560, 48559, 48558, 48556, 48553, 48551, 48550, 48547, 48545, 48539, 48538, 48537, 48532, 48529, 48508, 48507, 48446, 48445, 48444, 48442, 48437, 48430, 48429, 48428, 48423, 48419, 48411, 48410, 48408, 48406, 48405, 48404, 48402, 48399, 48398, 48396, 48392, 48391, 48388, 48386, 48382, 48373, 48372, 48371, 48370, 48369, 48367, 48364, 48359, 48351, 48300, 48299, 48298, 48290, 48283, 48281, 48276, 48267, 48264, 48261, 48256, 48255, 46423, 48251, 48249, 48245, 48244, 48243, 48216, 48160))
Run Time: 0.047982
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 128 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | xenforosilver.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | xenforosilver.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | xenforosilver.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | xenforosilver.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,xenforosilver.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: 20, 0, 1714771847, {"thread-58859":["thread",58859],"thread-53487":["thread",53487],"thread-53115":["thread",53115],"thread-52737":["thread",52737],"thread-51372":["thread",51372],"thread-51326":["thread",51326],"thread-51325":["thread",51325],"thread-51324":["thread",51324],"thread-50691":["thread",50691],"thread-50571":["thread",50571],"thread-50545":["thread",50545],"thread-50459":["thread",50459],"thread-50447":["thread",50447],"thread-50429":["thread",50429],"thread-50330":["thread",50330],"thread-50256":["thread",50256],"thread-50245":["thread",50245],"thread-50227":["thread",50227],"thread-50208":["thread",50208],"thread-50204":["thread",50204],"thread-50195":["thread",50195],"thread-50194":["thread",50194],"thread-49816":["thread",49816],"thread-49353":["thread",49353],"thread-49352":["thread",49352],"thread-49345":["thread",49345],"thread-49326":["thread",49326],"thread-49325":["thread",49325],"thread-49250":["thread",49250],"thread-49159":["thread",49159],"thread-49153":["thread",49153],"thread-49152":["thread",49152],"thread-49147":["thread",49147],"thread-49127":["thread",49127],"thread-49047":["thread",49047],"thread-49037":["thread",49037],"thread-49035":["thread",49035],"thread-49029":["thread",49029],"thread-49023":["thread",49023],"thread-48963":["thread",48963],"thread-48962":["thread",48962],"thread-48836":["thread",48836],"thread-48835":["thread",48835],"thread-48815":["thread",48815],"thread-48812":["thread",48812],"thread-48792":["thread",48792],"thread-48716":["thread",48716],"thread-48713":["thread",48713],"thread-48711":["thread",48711],"thread-48710":["thread",48710],"thread-48709":["thread",48709],"thread-48695":["thread",48695],"thread-48687":["thread",48687],"thread-48684":["thread",48684],"thread-48683":["thread",48683],"thread-48620":["thread",48620],"thread-48569":["thread",48569],"thread-48568":["thread",48568],"thread-48560":["thread",48560],"thread-48559":["thread",48559],"thread-48558":["thread",48558],"thread-48556":["thread",48556],"thread-48553":["thread",48553],"thread-48551":["thread",48551],"thread-48550":["thread",48550],"thread-48547":["thread",48547],"thread-48545":["thread",48545],"thread-48539":["thread",48539],"thread-48538":["thread",48538],"thread-48537":["thread",48537],"thread-48532":["thread",48532],"thread-48529":["thread",48529],"thread-48508":["thread",48508],"thread-48507":["thread",48507],"thread-48446":["thread",48446],"thread-48445":["thread",48445],"thread-48444":["thread",48444],"thread-48442":["thread",48442],"thread-48437":["thread",48437],"thread-48430":["thread",48430],"thread-48429":["thread",48429],"thread-48428":["thread",48428],"thread-48423":["thread",48423],"thread-48419":["thread",48419],"thread-48411":["thread",48411],"thread-48410":["thread",48410],"thread-48408":["thread",48408],"thread-48406":["thread",48406],"thread-48405":["thread",48405],"thread-48404":["thread",48404],"thread-48402":["thread",48402],"thread-48399":["thread",48399],"thread-48398":["thread",48398],"thread-48396":["thread",48396],"thread-48392":["thread",48392],"thread-48391":["thread",48391],"thread-48388":["thread",48388],"thread-48386":["thread",48386],"thread-48382":["thread",48382],"thread-48373":["thread",48373],"thread-48372":["thread",48372],"thread-48371":["thread",48371],"thread-48370":["thread",48370],"thread-48369":["thread",48369],"thread-48367":["thread",48367],"thread-48364":["thread",48364],"thread-48359":["thread",48359],"thread-48351":["thread",48351],"thread-48300":["thread",48300],"thread-48299":["thread",48299],"thread-48298":["thread",48298],"thread-48290":["thread",48290],"thread-48283":["thread",48283],"thread-48281":["thread",48281],"thread-48276":["thread",48276],"thread-48267":["thread",48267],"thread-48264":["thread",48264],"thread-48261":["thread",48261],"thread-48256":["thread",48256],"thread-48255":["thread",48255],"thread-46423":["thread",46423],"thread-48251":["thread",48251],"thread-48249":["thread",48249],"thread-48245":["thread",48245],"thread-48244":["thread",48244],"thread-48243":["thread",48243],"thread-48216":["thread",48216],"thread-48160":["thread",48160]}, NULL, 1714768247
Run Time: 0.000976
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- 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