php - 如何优化kohana中的子查询

Question

models.php

     ->add_subquery('(SELECT character_name FROM zid_character_details WHERE character_detail_id = (SELECT character_detail_id from zid_guild_feeds where feed_id = feeds.guild_parent_feed_id)) AS guildcharacter')
     ->add_subquery('(SELECT character_detail_id FROM zid_character_details WHERE character_detail_id = (SELECT character_detail_id from zid_guild_feeds where feed_id = feeds.guild_parent_feed_id)) AS guildcharacter_id')
     ->add_subquery('(SELECT character_icon FROM zid_character_details WHERE character_detail_id = (SELECT character_detail_id from zid_guild_feeds where feed_id = feeds.guild_parent_feed_id)) AS guildcharacter_icon')

上面是我用来从 zid_character_details 获取 character_name、character_detail_id 和 character_icon 的三个子查询> 引用 zid_guild_feeds 表的表。

谁能告诉我如何将这三个查询优化为单个或简单的查询。

谢谢

Answer 1

看看Kohana Query Builder Joins和 Kohana Query Builder Subqueries

当您需要探索各种 ORM 时，我建议您查看 Leap ORM