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 (7213663, 7212400, 7207008, 7206596, 7202233, 7198000, 7193035, 7189629, 7186394, 7184094, 7182073, 7178385, 7176751, 7175609, 7175466, 7172930, 7160743, 7160705, 7157624, 7155912, 7151012, 7150990, 7146601, 7140965, 7140583, 7140397, 7123066, 7122354, 7108881, 7108063, 7107291, 7106669, 7106292, 7100594, 7096203, 7095213, 7087023, 7086947, 7084927, 7084531, 7083705, 7075856, 7072929, 7051560, 7048137, 7047996, 7047559, 7046227, 7045562, 7035696, 7033974, 7032890, 7029783, 7026872, 7013557, 7011969, 6998090, 6984637, 6983093, 6973808, 6958018, 6957304, 6383426, 241958, 239564, 234711, 231461, 225382, 225360, 222733, 217719, 212680, 207632, 201376, 199144, 199044, 196555, 194007, 192692, 187664, 187179, 181341, 174343, 170328, 165979, 162141, 162140, 134))
Run Time: 0.005597
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 88 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,production_xf.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 1430
- 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 2870
- 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 138
- 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 2487
- XF\App->run() in src/XF.php at line 524
- 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: 115, 0, 1714829054, {"thread-7213663":["thread",7213663],"thread-7212400":["thread",7212400],"thread-7207008":["thread",7207008],"thread-7206596":["thread",7206596],"thread-7202233":["thread",7202233],"thread-7198000":["thread",7198000],"thread-7193035":["thread",7193035],"thread-7189629":["thread",7189629],"thread-7186394":["thread",7186394],"thread-7184094":["thread",7184094],"thread-7182073":["thread",7182073],"thread-7178385":["thread",7178385],"thread-7176751":["thread",7176751],"thread-7175609":["thread",7175609],"thread-7175466":["thread",7175466],"thread-7172930":["thread",7172930],"thread-7160743":["thread",7160743],"thread-7160705":["thread",7160705],"thread-7157624":["thread",7157624],"thread-7155912":["thread",7155912],"thread-7151012":["thread",7151012],"thread-7150990":["thread",7150990],"thread-7146601":["thread",7146601],"thread-7140965":["thread",7140965],"thread-7140583":["thread",7140583],"thread-7140397":["thread",7140397],"thread-7123066":["thread",7123066],"thread-7122354":["thread",7122354],"thread-7108881":["thread",7108881],"thread-7108063":["thread",7108063],"thread-7107291":["thread",7107291],"thread-7106669":["thread",7106669],"thread-7106292":["thread",7106292],"thread-7100594":["thread",7100594],"thread-7096203":["thread",7096203],"thread-7095213":["thread",7095213],"thread-7087023":["thread",7087023],"thread-7086947":["thread",7086947],"thread-7084927":["thread",7084927],"thread-7084531":["thread",7084531],"thread-7083705":["thread",7083705],"thread-7075856":["thread",7075856],"thread-7072929":["thread",7072929],"xfmg_media-3721":["xfmg_media",3721],"thread-7051560":["thread",7051560],"thread-7048137":["thread",7048137],"thread-7047996":["thread",7047996],"thread-7047559":["thread",7047559],"thread-7046227":["thread",7046227],"thread-7045562":["thread",7045562],"thread-7035696":["thread",7035696],"thread-7033974":["thread",7033974],"thread-7032890":["thread",7032890],"thread-7029783":["thread",7029783],"thread-7026872":["thread",7026872],"thread-7013557":["thread",7013557],"thread-7011969":["thread",7011969],"thread-6998090":["thread",6998090],"thread-6984637":["thread",6984637],"thread-6983093":["thread",6983093],"thread-6973808":["thread",6973808],"thread-6958018":["thread",6958018],"thread-6957304":["thread",6957304],"thread-6383426":["thread",6383426],"thread-241958":["thread",241958],"thread-239564":["thread",239564],"thread-234711":["thread",234711],"thread-231461":["thread",231461],"thread-225382":["thread",225382],"thread-225360":["thread",225360],"thread-222733":["thread",222733],"thread-217719":["thread",217719],"thread-212680":["thread",212680],"thread-207632":["thread",207632],"thread-201376":["thread",201376],"thread-199144":["thread",199144],"thread-199044":["thread",199044],"thread-196555":["thread",196555],"thread-194007":["thread",194007],"thread-192692":["thread",192692],"thread-187664":["thread",187664],"thread-187179":["thread",187179],"thread-181341":["thread",181341],"thread-174343":["thread",174343],"thread-170328":["thread",170328],"thread-165979":["thread",165979],"thread-162141":["thread",162141],"thread-162140":["thread",162140],"thread-134":["thread",134]}, NULL, 1714825454
Run Time: 0.000558
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20