CakePHP 有一个效率低下的地方吗？

发布于 2024-08-30 00:01:49 字数 732 浏览 10 评论 0原文

我正在查看 CakePHP 网站上的示例，特别是用于链接模型的 hasOne。 http://book.cakephp.org/view/78/Associations-链接模型在一起

我的问题是，CakePHP 是否使用两个查询来构建使用 hasOne 链接的模型中返回的数据的数组结构？

摘自 CakePHP： //$this->User->find() 调用的示例结果。

Array
(
    [User] => Array
        (
            [id] => 121
            [name] => Gwoo the Kungwoo
            [created] => 2007-05-01 10:31:01
        )
    [Profile] => Array
        (
            [id] => 12
            [user_id] => 121
            [skill] => Baking Cakes
            [created] => 2007-05-01 10:31:01
        )
)

希望这一切都有道理。

原文

I was looking at examples on the CakePHP website, in particular hasOne used in linking models.
http://book.cakephp.org/view/78/Associations-Linking-Models-Together

My question is this, is CakePHP using two queries to build the array structure of data returned in a model that uses hasOne linkage?

Taken from CakePHP:
//Sample results from a $this->User->find() call.

Array
(
    [User] => Array
        (
            [id] => 121
            [name] => Gwoo the Kungwoo
            [created] => 2007-05-01 10:31:01
        )
    [Profile] => Array
        (
            [id] => 12
            [user_id] => 121
            [skill] => Baking Cakes
            [created] => 2007-05-01 10:31:01
        )
)

Hope this all makes sense.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

盛夏已如深秋| 2024-09-06 00:01:49

Model::find 使用联接来检索通过 hasOne 和 belongsTo 关系与源模型关联的模型记录。特定的 SQL 查询看起来像这样（使用 Car owningTo Driver 模型结构）：

SELECT `Car`.`brand`, `Car`.`colour`, `Driver`.`name`, `Driver`.`age`
    FROM `cars` AS `Car`
    LEFT JOIN `drivers` AS `Driver` ON `Car`.`id` = `Driver`.`car_id`
WHERE `Car`.`brand` = 'Aston Martin'

属于每个模型的字段可以通过表/模型别名解析为相应的数组元素：

Car. brand 变为 $result['Car']['brand']
Car.colour 变为 $result['Car']['colour' ]
Driver.name 变为 $result['Driver']['name']
Driver.age 变为 $ result['Driver']['age']

只需一个查询。

检索 hasMany 和 hasAndBelongsToMany 关联的数据需要额外的查询，有时甚至更多。

Model::find uses joins to retrieve model records associated to the source model by hasOne and belongsTo relationships. The specific SQL queries look something like (using a Car belongsTo Driver model structure):

SELECT `Car`.`brand`, `Car`.`colour`, `Driver`.`name`, `Driver`.`age`
    FROM `cars` AS `Car`
    LEFT JOIN `drivers` AS `Driver` ON `Car`.`id` = `Driver`.`car_id`
WHERE `Car`.`brand` = 'Aston Martin'

The fields belonging to each model can be parsed out into corresponding array elements by the table/model alias: