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 (114834, 114774, 114078, 113753, 113639, 113529, 113230, 112183, 112182, 112052, 111789, 111630, 111624, 111622, 108170, 108161, 107945, 107891, 107832, 107521, 107518, 107386, 107180, 107102, 106888, 106830, 105793, 105593, 105558, 105314, 105253, 105250, 100967, 100964, 100187, 100013, 99917, 99861, 99688, 99686, 99377, 98616, 98598, 97432, 97379, 97369, 94686, 94633, 94628, 93987, 93777, 93610, 92522, 92241, 92197, 92018, 91848, 91712, 91500, 91463, 91130, 91058, 91043, 90255, 90248, 89847, 89687, 89570, 89451, 89409, 89306, 88357, 88166))
Run Time: 0.056353
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 73 | 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: 19069, 0, 1715934386, {"thread-114834":["thread",114834],"thread-114774":["thread",114774],"thread-114078":["thread",114078],"thread-113753":["thread",113753],"thread-113639":["thread",113639],"thread-113529":["thread",113529],"thread-113230":["thread",113230],"thread-112183":["thread",112183],"thread-112182":["thread",112182],"thread-112052":["thread",112052],"thread-111789":["thread",111789],"thread-111630":["thread",111630],"thread-111624":["thread",111624],"thread-111622":["thread",111622],"thread-108170":["thread",108170],"thread-108161":["thread",108161],"thread-107945":["thread",107945],"thread-107891":["thread",107891],"thread-107832":["thread",107832],"thread-107521":["thread",107521],"thread-107518":["thread",107518],"thread-107386":["thread",107386],"thread-107180":["thread",107180],"thread-107102":["thread",107102],"thread-106888":["thread",106888],"thread-106830":["thread",106830],"thread-105793":["thread",105793],"thread-105593":["thread",105593],"thread-105558":["thread",105558],"thread-105314":["thread",105314],"thread-105253":["thread",105253],"thread-105250":["thread",105250],"thread-100967":["thread",100967],"thread-100964":["thread",100964],"thread-100187":["thread",100187],"thread-100013":["thread",100013],"thread-99917":["thread",99917],"thread-99861":["thread",99861],"thread-99688":["thread",99688],"thread-99686":["thread",99686],"thread-99377":["thread",99377],"thread-98616":["thread",98616],"thread-98598":["thread",98598],"thread-97432":["thread",97432],"thread-97379":["thread",97379],"thread-97369":["thread",97369],"thread-94686":["thread",94686],"thread-94633":["thread",94633],"thread-94628":["thread",94628],"thread-93987":["thread",93987],"thread-93777":["thread",93777],"thread-93610":["thread",93610],"thread-92522":["thread",92522],"thread-92241":["thread",92241],"thread-92197":["thread",92197],"thread-92018":["thread",92018],"thread-91848":["thread",91848],"thread-91712":["thread",91712],"thread-91500":["thread",91500],"thread-91463":["thread",91463],"thread-91130":["thread",91130],"thread-91058":["thread",91058],"thread-91043":["thread",91043],"thread-90255":["thread",90255],"thread-90248":["thread",90248],"thread-89847":["thread",89847],"thread-89687":["thread",89687],"thread-89570":["thread",89570],"thread-89451":["thread",89451],"thread-89409":["thread",89409],"thread-89306":["thread",89306],"thread-88357":["thread",88357],"thread-88166":["thread",88166]}, , 1715930786
Run Time: 0.000868
- 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