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 (182470, 181514, 179184, 178843, 178006, 176456, 176200, 176086, 175687, 175512, 174416, 173213, 173143, 172568, 171501, 170962, 170565, 170261, 169779, 169751, 166457, 165523, 164539, 163969, 163402, 163226, 162384, 162201, 161784, 161548, 160416, 159421, 159413, 159328, 158847, 158624, 158389, 157958, 157951, 157786, 157260, 156463, 156348, 156117, 155726, 155723, 155551, 153558, 126736, 121728, 118036, 111003, 84064, 83860, 81559, 79347, 61333, 53096, 37861, 1300))
Run Time: 0.029018
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 60 | 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: 328, 0, 1716978995, {"thread-182470":["thread",182470],"thread-181514":["thread",181514],"thread-179184":["thread",179184],"thread-178843":["thread",178843],"thread-178006":["thread",178006],"thread-176456":["thread",176456],"thread-176200":["thread",176200],"thread-176086":["thread",176086],"thread-175687":["thread",175687],"thread-175512":["thread",175512],"thread-174416":["thread",174416],"thread-173213":["thread",173213],"thread-173143":["thread",173143],"thread-172568":["thread",172568],"thread-171501":["thread",171501],"thread-170962":["thread",170962],"thread-170565":["thread",170565],"thread-170261":["thread",170261],"thread-169779":["thread",169779],"thread-169751":["thread",169751],"thread-166457":["thread",166457],"thread-165523":["thread",165523],"thread-164539":["thread",164539],"thread-163969":["thread",163969],"thread-163402":["thread",163402],"thread-163226":["thread",163226],"thread-162384":["thread",162384],"thread-162201":["thread",162201],"thread-161784":["thread",161784],"thread-161548":["thread",161548],"thread-160416":["thread",160416],"thread-159421":["thread",159421],"thread-159413":["thread",159413],"thread-159328":["thread",159328],"thread-158847":["thread",158847],"thread-158624":["thread",158624],"thread-158389":["thread",158389],"thread-157958":["thread",157958],"thread-157951":["thread",157951],"thread-157786":["thread",157786],"thread-157260":["thread",157260],"thread-156463":["thread",156463],"thread-156348":["thread",156348],"thread-156117":["thread",156117],"thread-155726":["thread",155726],"thread-155723":["thread",155723],"thread-155551":["thread",155551],"thread-153558":["thread",153558],"thread-126736":["thread",126736],"thread-121728":["thread",121728],"thread-118036":["thread",118036],"thread-111003":["thread",111003],"thread-84064":["thread",84064],"thread-83860":["thread",83860],"thread-81559":["thread",81559],"thread-79347":["thread",79347],"thread-61333":["thread",61333],"thread-53096":["thread",53096],"thread-37861":["thread",37861],"thread-1300":["thread",1300]}, , 1716975395
Run Time: 0.001265
- 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