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 (3801, 3771, 3744, 3725, 3723, 3687, 3669, 3665, 3657, 3656, 3655, 3640, 3595, 3587, 3575, 3565, 3558, 3549, 3548, 3541, 3525, 3516, 3478, 3468, 3467, 3455, 3451, 3448, 3447, 3445, 3443, 3440, 3436, 3421, 3406, 3404, 3395, 3388, 3386, 3371, 3369, 3367, 3360, 3358, 3350, 3349, 3339, 3334, 3331, 3282, 3274, 3263, 3262, 3257, 3253, 3216, 3180, 3169, 3154, 3149, 3136, 3115, 3100, 3083, 3073, 3071, 3069, 3068, 3065, 3062, 3034, 3018, 2975, 2944, 2934, 2881, 2860, 2855, 2845, 2838, 2181, 2179, 2077, 1942, 1764, 1683, 1674, 1649, 1612, 1609, 1601, 1567, 1524, 1514, 1485, 1484, 1441, 1321, 1262, 1173, 118))
Run Time: 0.001816
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 101 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | davidderin_XenForo.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,davidderin_XenForo.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 1428
- 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/addons/MaZ/PotentialTagHelper/XF/Pub/Controller/Tag.php at line 27
- MaZ\PotentialTagHelper\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 258
- 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
UPDATE `xf_tag_result_cache` SET `expiry_date` = ?, `results` = ? WHERE `result_cache_id` = 255
Params: 1716137123, {"thread-3801":["thread",3801],"thread-3771":["thread",3771],"thread-3744":["thread",3744],"thread-3725":["thread",3725],"thread-3723":["thread",3723],"thread-3687":["thread",3687],"thread-3669":["thread",3669],"thread-3665":["thread",3665],"thread-3657":["thread",3657],"thread-3656":["thread",3656],"thread-3655":["thread",3655],"thread-3640":["thread",3640],"thread-3595":["thread",3595],"thread-3587":["thread",3587],"thread-3575":["thread",3575],"thread-3565":["thread",3565],"thread-3558":["thread",3558],"thread-3549":["thread",3549],"thread-3548":["thread",3548],"thread-3541":["thread",3541],"thread-3525":["thread",3525],"thread-3516":["thread",3516],"thread-3478":["thread",3478],"thread-3468":["thread",3468],"thread-3467":["thread",3467],"thread-3455":["thread",3455],"thread-3451":["thread",3451],"thread-3448":["thread",3448],"thread-3447":["thread",3447],"thread-3445":["thread",3445],"thread-3443":["thread",3443],"thread-3440":["thread",3440],"thread-3436":["thread",3436],"thread-3421":["thread",3421],"thread-3406":["thread",3406],"thread-3404":["thread",3404],"thread-3395":["thread",3395],"thread-3388":["thread",3388],"thread-3386":["thread",3386],"thread-3371":["thread",3371],"thread-3369":["thread",3369],"thread-3367":["thread",3367],"thread-3360":["thread",3360],"thread-3358":["thread",3358],"thread-3350":["thread",3350],"thread-3349":["thread",3349],"thread-3339":["thread",3339],"thread-3334":["thread",3334],"thread-3331":["thread",3331],"thread-3282":["thread",3282],"thread-3274":["thread",3274],"thread-3263":["thread",3263],"thread-3262":["thread",3262],"thread-3257":["thread",3257],"thread-3253":["thread",3253],"thread-3216":["thread",3216],"thread-3180":["thread",3180],"thread-3169":["thread",3169],"thread-3154":["thread",3154],"thread-3149":["thread",3149],"thread-3136":["thread",3136],"thread-3115":["thread",3115],"thread-3100":["thread",3100],"thread-3083":["thread",3083],"thread-3073":["thread",3073],"thread-3071":["thread",3071],"thread-3069":["thread",3069],"thread-3068":["thread",3068],"thread-3065":["thread",3065],"thread-3062":["thread",3062],"thread-3034":["thread",3034],"thread-3018":["thread",3018],"thread-2975":["thread",2975],"thread-2944":["thread",2944],"thread-2934":["thread",2934],"thread-2881":["thread",2881],"thread-2860":["thread",2860],"thread-2855":["thread",2855],"thread-2845":["thread",2845],"thread-2838":["thread",2838],"thread-2181":["thread",2181],"thread-2179":["thread",2179],"thread-2077":["thread",2077],"thread-1942":["thread",1942],"thread-1764":["thread",1764],"thread-1683":["thread",1683],"thread-1674":["thread",1674],"thread-1649":["thread",1649],"thread-1612":["thread",1612],"thread-1609":["thread",1609],"thread-1601":["thread",1601],"thread-1567":["thread",1567],"thread-1524":["thread",1524],"thread-1514":["thread",1514],"thread-1485":["thread",1485],"thread-1484":["thread",1484],"thread-1441":["thread",1441],"thread-1321":["thread",1321],"thread-1262":["thread",1262],"thread-1173":["thread",1173],"thread-118":["thread",118]}
Run Time: 0.000146
- 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 323
- XF\Db\AbstractAdapter->update() in src/XF/Mvc/Entity/Entity.php at line 1531
- 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/addons/MaZ/PotentialTagHelper/XF/Pub/Controller/Tag.php at line 27
- MaZ\PotentialTagHelper\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 258
- 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