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 (12039, 12019, 11706, 11705, 11528, 11471, 11254, 11210, 11173, 11114, 11077, 10810, 10379, 9607, 9416, 9257, 8958, 8788, 8747, 8492, 8023, 8022, 7985, 7723, 7649, 7464, 7191, 7115, 7088, 6924, 6888, 6886, 6866, 6762, 6634, 6470, 6437, 6430, 6338, 6281, 6198, 6159, 6146, 6100, 6092, 5877, 5858, 5709, 5657, 5641, 5444, 5407, 5369, 5255, 5227, 5213, 5212, 4926, 4919, 4787, 4461, 4449, 4275, 4201, 4200, 4010, 3989, 3963, 3929, 3895, 3723, 3664, 3653, 3608, 3579, 3354, 3264, 3245, 3154, 3149, 3120, 3112, 3030, 3013, 2978, 2939, 2909, 2894, 2866, 2845, 2833, 2817, 2644, 2572, 923, 842, 717, 675, 654, 461, 361, 340, 329, 317, 292, 222, 199, 175, 170, 127))
Run Time: 0.005960
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 110 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xencybim.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xencybim.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xencybim.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xencybim.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xencybim.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: 260, 0, 1716785233, {"thread-12039":["thread",12039],"thread-12019":["thread",12019],"thread-11706":["thread",11706],"thread-11705":["thread",11705],"thread-11528":["thread",11528],"thread-11471":["thread",11471],"thread-11254":["thread",11254],"thread-11210":["thread",11210],"thread-11173":["thread",11173],"thread-11114":["thread",11114],"thread-11077":["thread",11077],"thread-10810":["thread",10810],"thread-10379":["thread",10379],"thread-9607":["thread",9607],"thread-9416":["thread",9416],"thread-9257":["thread",9257],"thread-8958":["thread",8958],"thread-8788":["thread",8788],"thread-8747":["thread",8747],"thread-8492":["thread",8492],"thread-8023":["thread",8023],"thread-8022":["thread",8022],"thread-7985":["thread",7985],"thread-7723":["thread",7723],"thread-7649":["thread",7649],"thread-7464":["thread",7464],"thread-7191":["thread",7191],"thread-7115":["thread",7115],"thread-7088":["thread",7088],"thread-6924":["thread",6924],"thread-6888":["thread",6888],"thread-6886":["thread",6886],"thread-6866":["thread",6866],"thread-6762":["thread",6762],"thread-6634":["thread",6634],"thread-6470":["thread",6470],"thread-6437":["thread",6437],"thread-6430":["thread",6430],"thread-6338":["thread",6338],"thread-6281":["thread",6281],"thread-6198":["thread",6198],"thread-6159":["thread",6159],"thread-6146":["thread",6146],"thread-6100":["thread",6100],"thread-6092":["thread",6092],"thread-5877":["thread",5877],"thread-5858":["thread",5858],"thread-5709":["thread",5709],"thread-5657":["thread",5657],"thread-5641":["thread",5641],"thread-5444":["thread",5444],"thread-5407":["thread",5407],"thread-5369":["thread",5369],"thread-5255":["thread",5255],"thread-5227":["thread",5227],"thread-5213":["thread",5213],"thread-5212":["thread",5212],"thread-4926":["thread",4926],"thread-4919":["thread",4919],"thread-4787":["thread",4787],"thread-4461":["thread",4461],"thread-4449":["thread",4449],"thread-4275":["thread",4275],"thread-4201":["thread",4201],"thread-4200":["thread",4200],"thread-4010":["thread",4010],"thread-3989":["thread",3989],"thread-3963":["thread",3963],"thread-3929":["thread",3929],"thread-3895":["thread",3895],"thread-3723":["thread",3723],"thread-3664":["thread",3664],"thread-3653":["thread",3653],"thread-3608":["thread",3608],"thread-3579":["thread",3579],"thread-3354":["thread",3354],"thread-3264":["thread",3264],"thread-3245":["thread",3245],"thread-3154":["thread",3154],"thread-3149":["thread",3149],"thread-3120":["thread",3120],"thread-3112":["thread",3112],"thread-3030":["thread",3030],"thread-3013":["thread",3013],"thread-2978":["thread",2978],"thread-2939":["thread",2939],"thread-2909":["thread",2909],"thread-2894":["thread",2894],"thread-2866":["thread",2866],"thread-2845":["thread",2845],"thread-2833":["thread",2833],"thread-2817":["thread",2817],"thread-2644":["thread",2644],"thread-2572":["thread",2572],"thread-923":["thread",923],"thread-842":["thread",842],"thread-717":["thread",717],"thread-675":["thread",675],"thread-654":["thread",654],"thread-461":["thread",461],"thread-361":["thread",361],"thread-340":["thread",340],"thread-329":["thread",329],"thread-317":["thread",317],"thread-292":["thread",292],"thread-222":["thread",222],"thread-199":["thread",199],"thread-175":["thread",175],"thread-170":["thread",170],"thread-127":["thread",127]}, , 1716781633
Run Time: 0.000256
- 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