framework icon indicating copy to clipboard operation
framework copied to clipboard

【ORM】模型远程一对多

Open Muspcn opened this issue 5 months ago • 0 comments

所属功能组件

其它

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

Muspcn avatar Aug 15 '25 07:08 Muspcn