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 (81369, 81368, 81362, 79788, 79771, 79303, 79255, 79140, 78954, 78953, 75454, 65842, 65547, 50533, 50490, 50078, 48806, 48459, 48448, 48447, 40923, 40921, 39367, 39366, 39360, 39359, 39358, 35458, 35457, 35438, 35437, 35416, 35193, 35129, 35128, 33204, 33109, 33094, 33093, 32998, 32997, 32996, 32994, 32184, 32183, 32182, 32181, 32179, 32178, 32177, 32176, 32175, 32173, 32171, 32169, 32168, 32166, 32165, 32164, 32163, 32162, 32160, 32159, 32158, 32157, 32156, 32155, 32154, 31941, 31812, 31810, 31667, 31666, 31665, 31655, 31654, 31653, 31652, 31649, 31648, 31647, 31646, 31568, 31550, 31358, 31344, 31342, 31336, 30232, 29731))
Run Time: 0.030832
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 90 | 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: 4151, 0, 1715806105, {"thread-81369":["thread",81369],"thread-81368":["thread",81368],"thread-81362":["thread",81362],"thread-79788":["thread",79788],"thread-79771":["thread",79771],"thread-79303":["thread",79303],"thread-79255":["thread",79255],"thread-79140":["thread",79140],"thread-78954":["thread",78954],"thread-78953":["thread",78953],"thread-75454":["thread",75454],"thread-65842":["thread",65842],"thread-65547":["thread",65547],"thread-50533":["thread",50533],"thread-50490":["thread",50490],"thread-50078":["thread",50078],"thread-48806":["thread",48806],"thread-48459":["thread",48459],"thread-48448":["thread",48448],"thread-48447":["thread",48447],"thread-40923":["thread",40923],"thread-40921":["thread",40921],"thread-39367":["thread",39367],"thread-39366":["thread",39366],"thread-39360":["thread",39360],"thread-39359":["thread",39359],"thread-39358":["thread",39358],"thread-35458":["thread",35458],"thread-35457":["thread",35457],"thread-35438":["thread",35438],"thread-35437":["thread",35437],"thread-35416":["thread",35416],"thread-35193":["thread",35193],"thread-35129":["thread",35129],"thread-35128":["thread",35128],"thread-33204":["thread",33204],"thread-33109":["thread",33109],"thread-33094":["thread",33094],"thread-33093":["thread",33093],"thread-32998":["thread",32998],"thread-32997":["thread",32997],"thread-32996":["thread",32996],"thread-32994":["thread",32994],"thread-32184":["thread",32184],"thread-32183":["thread",32183],"thread-32182":["thread",32182],"thread-32181":["thread",32181],"thread-32179":["thread",32179],"thread-32178":["thread",32178],"thread-32177":["thread",32177],"thread-32176":["thread",32176],"thread-32175":["thread",32175],"thread-32173":["thread",32173],"thread-32171":["thread",32171],"thread-32169":["thread",32169],"thread-32168":["thread",32168],"thread-32166":["thread",32166],"thread-32165":["thread",32165],"thread-32164":["thread",32164],"thread-32163":["thread",32163],"thread-32162":["thread",32162],"thread-32160":["thread",32160],"thread-32159":["thread",32159],"thread-32158":["thread",32158],"thread-32157":["thread",32157],"thread-32156":["thread",32156],"thread-32155":["thread",32155],"thread-32154":["thread",32154],"thread-31941":["thread",31941],"thread-31812":["thread",31812],"thread-31810":["thread",31810],"thread-31667":["thread",31667],"thread-31666":["thread",31666],"thread-31665":["thread",31665],"thread-31655":["thread",31655],"thread-31654":["thread",31654],"thread-31653":["thread",31653],"thread-31652":["thread",31652],"thread-31649":["thread",31649],"thread-31648":["thread",31648],"thread-31647":["thread",31647],"thread-31646":["thread",31646],"thread-31568":["thread",31568],"thread-31550":["thread",31550],"thread-31358":["thread",31358],"thread-31344":["thread",31344],"thread-31342":["thread",31342],"thread-31336":["thread",31336],"thread-30232":["thread",30232],"thread-29731":["thread",29731]}, , 1715802505
Run Time: 0.000210
- 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