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 (181775, 181704, 181127, 180114, 180085, 179073, 179072, 178514, 178484, 178467, 174220, 174103, 173465, 173452, 173360, 173331, 164437, 158580, 115945, 94744, 92355, 85687, 84752, 84751, 83419, 83417, 81885, 81757, 81372, 81196, 81191, 81166, 81108, 81061, 80944, 80233, 80154, 79304, 79242, 79136, 79112, 78974, 78963, 78898, 78875, 78817, 78807, 78771, 78646, 78614, 78601, 78363, 78228, 78224, 78073, 78068, 78011, 77990, 77980, 77977, 77970, 77967, 77964, 77791, 77776, 77748, 77714, 77707, 64251, 64197, 63660, 63638, 63203))
Run Time: 0.068621
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: 11502, 0, 1714662403, {"thread-181775":["thread",181775],"thread-181704":["thread",181704],"thread-181127":["thread",181127],"thread-180114":["thread",180114],"thread-180085":["thread",180085],"thread-179073":["thread",179073],"thread-179072":["thread",179072],"tl_group-339":["tl_group",339],"thread-178514":["thread",178514],"thread-178484":["thread",178484],"thread-178467":["thread",178467],"thread-174220":["thread",174220],"thread-174103":["thread",174103],"thread-173465":["thread",173465],"thread-173452":["thread",173452],"thread-173360":["thread",173360],"thread-173331":["thread",173331],"thread-164437":["thread",164437],"thread-158580":["thread",158580],"thread-115945":["thread",115945],"thread-94744":["thread",94744],"thread-92355":["thread",92355],"thread-85687":["thread",85687],"thread-84752":["thread",84752],"thread-84751":["thread",84751],"thread-83419":["thread",83419],"thread-83417":["thread",83417],"thread-81885":["thread",81885],"thread-81757":["thread",81757],"thread-81372":["thread",81372],"thread-81196":["thread",81196],"thread-81191":["thread",81191],"thread-81166":["thread",81166],"thread-81108":["thread",81108],"thread-81061":["thread",81061],"thread-80944":["thread",80944],"thread-80233":["thread",80233],"thread-80154":["thread",80154],"thread-79304":["thread",79304],"thread-79242":["thread",79242],"thread-79136":["thread",79136],"thread-79112":["thread",79112],"thread-78974":["thread",78974],"thread-78963":["thread",78963],"thread-78898":["thread",78898],"thread-78875":["thread",78875],"thread-78817":["thread",78817],"thread-78807":["thread",78807],"thread-78771":["thread",78771],"thread-78646":["thread",78646],"thread-78614":["thread",78614],"thread-78601":["thread",78601],"thread-78363":["thread",78363],"thread-78228":["thread",78228],"thread-78224":["thread",78224],"thread-78073":["thread",78073],"thread-78068":["thread",78068],"thread-78011":["thread",78011],"thread-77990":["thread",77990],"thread-77980":["thread",77980],"thread-77977":["thread",77977],"thread-77970":["thread",77970],"thread-77967":["thread",77967],"thread-77964":["thread",77964],"thread-77791":["thread",77791],"thread-77776":["thread",77776],"thread-77748":["thread",77748],"thread-77714":["thread",77714],"thread-77707":["thread",77707],"thread-64251":["thread",64251],"thread-64197":["thread",64197],"thread-63660":["thread",63660],"thread-63638":["thread",63638],"thread-63203":["thread",63203]}, , 1714658803
Run Time: 0.000879
- 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