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 (27881, 27483, 27394, 27197, 27088, 27010, 26707, 26652, 26599, 26361, 26360, 26333, 26180, 25902, 25877, 25876, 25875, 25872, 25870, 25868, 25867, 25707, 25692, 25689, 25688, 25677, 25670, 25656, 25654, 25637, 25590, 25584, 25582, 25535, 25534, 25391, 25300, 25299, 25298, 25297, 25290, 25288, 25286, 25283, 25282, 25280, 25220, 25213, 25184, 25170, 25159, 25154, 25122, 25121, 25106, 25074, 25052, 25050, 25014, 25002, 24808, 24243, 24229, 24219, 24216, 24184, 24174, 24085, 24018, 23936, 23874, 23840, 23085, 21936, 21838, 21837, 20756, 20514, 19178, 19047, 19043, 19038, 19037, 19014, 19012, 19003, 18960, 18957, 18919, 18830, 18776, 18731, 18728, 17567, 17529, 17011, 17010, 17009, 17008, 17007, 16941, 16424, 10532))
Run Time: 0.040605
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 103 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | vzdghdbc_xf1.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | vzdghdbc_xf1.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | vzdghdbc_xf1.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | vzdghdbc_xf1.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,vzdghdbc_xf1.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2718
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 729
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 136
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- 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: 34, 0, 1714390733, {"thread-27881":["thread",27881],"thread-27483":["thread",27483],"thread-27394":["thread",27394],"thread-27197":["thread",27197],"thread-27088":["thread",27088],"thread-27010":["thread",27010],"thread-26707":["thread",26707],"thread-26652":["thread",26652],"thread-26599":["thread",26599],"thread-26361":["thread",26361],"thread-26360":["thread",26360],"thread-26333":["thread",26333],"thread-26180":["thread",26180],"thread-25902":["thread",25902],"thread-25877":["thread",25877],"thread-25876":["thread",25876],"thread-25875":["thread",25875],"thread-25872":["thread",25872],"thread-25870":["thread",25870],"thread-25868":["thread",25868],"thread-25867":["thread",25867],"thread-25707":["thread",25707],"thread-25692":["thread",25692],"thread-25689":["thread",25689],"thread-25688":["thread",25688],"thread-25677":["thread",25677],"thread-25670":["thread",25670],"thread-25656":["thread",25656],"thread-25654":["thread",25654],"thread-25637":["thread",25637],"thread-25590":["thread",25590],"thread-25584":["thread",25584],"thread-25582":["thread",25582],"thread-25535":["thread",25535],"thread-25534":["thread",25534],"thread-25391":["thread",25391],"thread-25300":["thread",25300],"thread-25299":["thread",25299],"thread-25298":["thread",25298],"thread-25297":["thread",25297],"thread-25290":["thread",25290],"thread-25288":["thread",25288],"thread-25286":["thread",25286],"thread-25283":["thread",25283],"thread-25282":["thread",25282],"thread-25280":["thread",25280],"thread-25220":["thread",25220],"thread-25213":["thread",25213],"thread-25184":["thread",25184],"thread-25170":["thread",25170],"thread-25159":["thread",25159],"thread-25154":["thread",25154],"thread-25122":["thread",25122],"thread-25121":["thread",25121],"thread-25106":["thread",25106],"thread-25074":["thread",25074],"thread-25052":["thread",25052],"thread-25050":["thread",25050],"thread-25014":["thread",25014],"thread-25002":["thread",25002],"thread-24808":["thread",24808],"thread-24243":["thread",24243],"thread-24229":["thread",24229],"thread-24219":["thread",24219],"thread-24216":["thread",24216],"thread-24184":["thread",24184],"thread-24174":["thread",24174],"thread-24085":["thread",24085],"thread-24018":["thread",24018],"thread-23936":["thread",23936],"thread-23874":["thread",23874],"thread-23840":["thread",23840],"thread-23085":["thread",23085],"thread-21838":["thread",21838],"thread-21837":["thread",21837],"thread-20756":["thread",20756],"thread-20514":["thread",20514],"thread-19178":["thread",19178],"thread-19047":["thread",19047],"thread-19043":["thread",19043],"thread-19038":["thread",19038],"thread-19037":["thread",19037],"thread-19014":["thread",19014],"thread-19012":["thread",19012],"thread-19003":["thread",19003],"thread-18960":["thread",18960],"thread-18957":["thread",18957],"thread-18919":["thread",18919],"thread-18830":["thread",18830],"thread-18776":["thread",18776],"thread-18731":["thread",18731],"thread-18728":["thread",18728],"thread-17567":["thread",17567],"thread-17529":["thread",17529],"thread-17011":["thread",17011],"thread-17010":["thread",17010],"thread-17009":["thread",17009],"thread-17008":["thread",17008],"thread-17007":["thread",17007],"thread-16424":["thread",16424]}, , 1714387133
Run Time: 0.001637
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 221
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1510
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1242
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 149
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20