Skip to content

【ORM】模型远程一对多 #3164

@Muspcn

Description

@Muspcn

所属功能组件

其它

ThinkPHP 版本

8.0.3

操作系统

liunx

错误信息

Image "topthink/think-orm": "v3.0.14", 出现情况,远程一对多查询时,第一个包裹领取了商品a后,第二个报个无法领取a Image

执行sql
[2025-08-15 15:58:11][sql] SELECT COUNT(*) AS think_count FROM order_print_logisticsWHERE site_id= 100003 [ RunTime:0.000300s ] [2025-08-15 15:58:11][sql] SELECTlogistics_id,site_id,delivery_code,shop_code,delivery_number,print_plat,is_print_data,status,parent_delivery_number,print_num,relation_id,create_timeFROMorder_print_logisticsWHERE site_id= 100003 ORDER BYlogistics_idDESC LIMIT 0,20 [ RunTime:0.000234s ] [2025-08-15 15:58:11][sql] SELECT * FROMorder_print_logistics_pidWHERE logistics_idIN (67,66,65,64,63,62,61,60,59,58,57,56,55,54,53,52,51,50,49,48) [ RunTime:0.000259s ] [2025-08-15 15:58:11][sql] SELECTitem_id,order_id,item_status,refund_status,goods_name,sku_name,num,sku_codeFROMorder_print_order_item order_itemWHERE order_item.item_idIN ('3070','3071','3088','3084','3085','3094','3095','3123','3124') [ RunTime:0.000264s ]
sql上看查询都没问题,该查的数据都查询到了

关联orm
`
public function orderItem()
{
return $this->hasManyThrough(OrderItem::class, LogisticsPid::class, 'logistics_id', 'item_id', 'logistics_id', 'item_id');
}

`

其它说明

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions