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 (130190, 122492, 114246, 107114, 104797, 102384, 102225, 96910, 96242, 96208, 96206, 94716, 94237, 93323, 93111, 92840, 92830, 92551, 91540, 91113, 90806, 90148, 90118, 89951, 89652, 89616, 89495, 89090, 88561, 88526, 88480, 88046, 87761, 87701, 87461, 86985, 86805, 86611, 86160, 85796, 85791, 85740, 85470, 85223, 84992, 84833, 84831, 84727, 84723, 84688, 84683, 84349, 83790, 83267, 83255, 83008, 82656, 81447, 80886, 80738, 80529, 80527, 80359, 78254, 72086))
Run Time: 0.043419
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 65 | 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: 13963, 0, 1715231836, {"thread-130190":["thread",130190],"thread-122492":["thread",122492],"thread-114246":["thread",114246],"thread-107114":["thread",107114],"thread-104797":["thread",104797],"thread-102384":["thread",102384],"thread-102225":["thread",102225],"thread-96910":["thread",96910],"thread-96242":["thread",96242],"thread-96208":["thread",96208],"thread-96206":["thread",96206],"thread-94716":["thread",94716],"thread-94237":["thread",94237],"thread-93323":["thread",93323],"thread-93111":["thread",93111],"thread-92840":["thread",92840],"thread-92830":["thread",92830],"thread-92551":["thread",92551],"thread-91540":["thread",91540],"thread-91113":["thread",91113],"thread-90806":["thread",90806],"thread-90148":["thread",90148],"thread-90118":["thread",90118],"thread-89951":["thread",89951],"thread-89652":["thread",89652],"thread-89616":["thread",89616],"thread-89495":["thread",89495],"thread-89090":["thread",89090],"thread-88561":["thread",88561],"thread-88526":["thread",88526],"thread-88480":["thread",88480],"thread-88046":["thread",88046],"thread-87761":["thread",87761],"thread-87701":["thread",87701],"thread-87461":["thread",87461],"thread-86985":["thread",86985],"thread-86805":["thread",86805],"thread-86611":["thread",86611],"thread-86160":["thread",86160],"thread-85796":["thread",85796],"thread-85791":["thread",85791],"thread-85740":["thread",85740],"thread-85470":["thread",85470],"thread-85223":["thread",85223],"thread-84992":["thread",84992],"thread-84833":["thread",84833],"thread-84831":["thread",84831],"thread-84727":["thread",84727],"thread-84723":["thread",84723],"thread-84688":["thread",84688],"thread-84683":["thread",84683],"thread-84349":["thread",84349],"thread-83790":["thread",83790],"thread-83267":["thread",83267],"thread-83255":["thread",83255],"thread-83008":["thread",83008],"thread-82656":["thread",82656],"thread-81447":["thread",81447],"thread-80886":["thread",80886],"thread-80738":["thread",80738],"thread-80529":["thread",80529],"thread-80527":["thread",80527],"thread-80359":["thread",80359],"thread-78254":["thread",78254],"thread-72086":["thread",72086]}, , 1715228236
Run Time: 0.000993
- 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