[Dbix-class] Modeling/query help re prefetch needed

[Ekki Plicht (DF4OR)]

T2ssIHRoYW5rcy4KClRoaXMgd2FzIGluc29mYXIgaGVscGZ1bCBhcyBpdCBzaG93ZWQgbXkgbGFj
ayBvZiB1bmRlcnN0YW5kaW5nIG9mCkRCSXg6OkNsYXNzIDopCkkgd2lsbCBnbyBiYWNrIHRvIHRo
ZSBkcmF3aW5nIGJvYXJkIGFuZCBzb21lIGJvb2tzIGFuZCB0cnkgdG8gdW5kZXJzdGFuZApiZXR0
ZXIsIHdoYXQgaXQgZG9lcyBhbmQgd2hhdCBJIHdhbnQgdG8gYWNoaWV2ZS4KClJnZHMsCkVra2kK
CgoKT24gRnJpLCBBdWcgMjQsIDIwMTIgYXQgNjozNCBQTSwgZlJFVyBTY2htaWR0IDxmcmlvdXhA
Z21haWwuY29tPiB3cm90ZToKCj4KPiBPbiAwOC8yNC8yMDEyIDA5OjE1IEFNLCBFa2tpIFBsaWNo
dCB3cm90ZToKPgo+IEhpLgo+Cj4gSSBoYXZlIGEgdGFibGUgb2YgcHJvZHVjdHMsIGVhY2ggcHJv
ZHVjdCBoYXMgb25lIG9yIG1vcmUgdGV4dHMgaW4gYQo+IHJlbGF0ZWQgdGFibGUuIFRoZSByZWxh
dGVkIHRhYmxlIGRvZXMgbm90IG9ubHkgaGF2ZSB0aGUgdGV4dCBzdG9yZWQsIGJ1dAo+IGFsc28g
YSBsYW5ndWFnZSBjb2x1bW4sIGkuZS4gdGhlIHRhYmxlIHN0b3JlcyB0ZXh0cyBpbiBhbGwgbGFu
Z3VhZ2VzLiBBCj4gcHJvZHVjdCBjYW4gaGF2ZSBtb3JlIHRoYW4gb25lIHRleHQgaW4gb25lIGxh
bmd1YWdlLgo+Cj4gQ1JFQVRFIFRBQkxFIGBwcm9kdWN0c2AgKAo+ICAgYGlkYCBpbnQoMTEpIE5P
VCBOVUxMIEFVVE9fSU5DUkVNRU5ULAo+ICAgYGFydG51bWAgdmFyY2hhcigxMikgTk9UIE5VTEws
Cj4gICBQUklNQVJZIEtFWSAoYGlkYCksCj4gICBVTklRVUUgS0VZIGBhcnRudW1fVU5JUVVFYCAo
YGFydG51bWApLAo+ICkgRU5HSU5FPUlubm9EQiAgREVGQVVMVCBDSEFSU0VUPXV0Zjg7Cj4KPiBD
UkVBVEUgVEFCTEUgYHRleHRgICgKPiAgIGBpZGAgaW50KDExKSBOT1QgTlVMTCBBVVRPX0lOQ1JF
TUVOVCwKPiAgIGBpZF9wcm9kYCBpbnQoMTEpIERFRkFVTFQgTlVMTCwKPiAgIGBsYW5nYCB2YXJj
aGFyKDIpIERFRkFVTFQgTlVMTCBDT01NRU5UICdJU08gNjM5LTEgY29kZSBvZiBsYW5ndWFnZQo+
IHVzZWQuXG4nLAo+ICAgYHRleHRgIHRleHQgQ09NTUVOVCAnVGhlIHRleHQgZGVzY3JpYmluZyB0
aGUgcHJvZHVjdCBpdHNlbGYuXG4nLAo+ICAgUFJJTUFSWSBLRVkgKGBpZGApLAo+ICAgS0VZIGBm
a190ZXh0X3Byb2RgIChgaWRfcHJvZGApLAo+ICkgRU5HSU5FPUlubm9EQiBERUZBVUxUIENIQVJT
RVQ9dXRmODsKPgo+Cj4gSW4gYW4gb3ZlcnZpZXcgb2YgcHJvZHVjdHMsIEkgd2FudCB0byBzZWUg
aG93IG1hbnkgdGV4dHMgZWFjaCBwcm9kdWN0IF9pbl8KPiBfZWFjaF8gX2xhbmd1YWdlXyBoYXMu
IEhvdyBkbyBJIGRvIHRoaXMgd2l0aCBEQkljPwo+Cj4gSSB0cmllZCB3aXRoIHByZWZldGNoLCBi
dXQgZG9uJ3QgdW5kZXJzdGFuZCBob3cgSSBjYW4gZGlmZmVyZW50aWF0ZSB0aGUKPiBwcmVmZWN0
Y2hlZCByb3dzIGJ5IGxhbmd1YWdlLiBDdXJyZW50bHkgSSBqdXN0IGdldCB0aGUgcHJvZHVjdHMs
IGFuZCB0aGVuCj4gaXRlcmF0ZSBvdmVyIGVhY2ggcHJvZHVjdCwgZG9pbmcgbiBzZWFyY2hlcywg
b25lIGZvciBlYWNoIGxhbmd1YWdlLiBBdAo+IGN1cnJlbnRseSA1IGxhbmd1YWdlcyBhbmQgMjUg
cHJvZHVjdHMgcGVyIHBhZ2UsIEkgaGF2ZSAxMjUgcXVlcmllcyBqdXN0IHRvCj4gZ2V0IGF0IHRo
YXQgaW5mb3JtYXRpb24uIFRoZSBmZXRjaCB0aW1lIGlzIG5vdGFibGUsIGluIHRoZSByYW5nZSBv
ZiAyIG9yIDMKPiBzZWNvbmRzLgo+Cj4gT25lIGlkZWEgSSBoYWQgaXMgdG8gZ2l2ZSB1cCBzb21l
IGxldmVsIG9mIG5vcm1hbGl6YXRpb24sIHB1dCBhIHRyaWdnZXIgaW4KPiB0YWJsZSBgdGV4dGAg
d2hpY2ggdXBkYXRlcyBhIHBlciBsYW5ndWFnZSBjb3VudGVyIGluIHRhYmxlIGBwcm9kdWN0c2Au
IEJ1dAo+IEkgZG9uJ3Qga25vdyBpZiB0aGlzIGlzbid0IG92ZXJraWxsIGp1c3QgdG8gZ2V0IHRo
ZSBjb3VudHMgb2YgdGV4dHMgcGVyCj4gcHJvZHVjdCBwZXIgbGFuZ3VhZ2UuCj4KPiBBbm90aGVy
IGlkZWEgd2FzIHRvIGhhdmUgb25lIHRhYmxlIHBlciBsYW5ndWFnZSwgcmVzdWx0aW5nIGluIGEg
c2ltcGxlIDE6bgo+IHJlbGF0aW9uIGZvciBlYWNoIGxhbmd1YWdlLiBCdXQgdGhhdCB3b3VsZCBy
ZXF1aXJlIGV4dGVuZGluZyB0aGUgdGFibGVzCj4gd2hlbiB3ZSBhZGQgYSBuZXcgbGFuZ3VhZ2Uu
IFBvc3NpYmxlLCBidXQgbm90IHZlcnkgZWxlZ2FudC4KPgo+IFRoZSBgdGV4dGAgdGFibGUgZG9l
cyBub3QgdXBkYXRlIHZlcnkgb2Z0ZW4sIGluIGZhY3Qgb25seSByYXJlbHkgb25jZSBpdAo+IGlz
IHBvcHVsYXRlZC4gU28gdGhlIG51bWJlciBvZiB0ZXh0cyBwZXIgcHJvZHVjdCBkbyBub3QgY2hh
bmdlIG9mdGVuLgo+Cj4gTWF5YmUgdGhlIGRlc2lnbiBvZiB0aGUgZGF0YWJhc2UgaXMganVzdCBp
bmVmZmljaWVudCwgaXQncyBub3QgbXkgbWFpbgo+IGFyZWEgb2YgZXhwZXJ0aXNlLi4uIDopCj4K
PiBTbyBteSBxdWVzdGlvbnMgYXJlOgo+IC0gSG93IGRvIEkgZG8gYW4gZWZmZWN0aXZlIHNlYXJj
aCB3aXRoIG9yIHdpdGhvdXQgcHJlZmV0Y2ggZm9yIHRoaXMKPiByZWxhdGVkIHRhYmxlIHdpdGgg
ZGJpYywganVzdCBnZXR0aW5nIHRoZSBjb3VudHMgcGVyIGxhbmd1YWdlIGluIHRoZQo+IHJlbGF0
ZWQgdGFibGU/Cj4gLSBJcyBzdWNoIGEgZGVzaWduIHVzZWZ1bCBhdCBhbGwsIGNvbnNpZGVyZWQg
dGhhdCB0aGlzIGlzIGp1c3Qgb25lIG9mIG5pbmUKPiBzaW1pbGlhciByZWxhdGVkIHRhYmxlcz8K
Pgo+Cj4gVGhpcyBkb2Vzbid0IGFjdHVhbGx5IGhhdmUgbXVjaCB0byBkbyB3aXRoIHByZWZldGNo
Lgo+Cj4gICAkcHJvZHVjdF9ycy0+c2VhcmNoKHVuZGVmLCB7Cj4gICAgIGdyb3VwX2J5ID0+IFtx
dyhtZS5pZCB0ZXh0LmxhbmcpXSwKPiAgICAgY29sdW1ucyA9PiB7Cj4gICAgICAgIHByb2R1Y3Rf
aWQgPT4gJ21lLmlkJywKPiAgICAgICAgbGFuZyAgICAgICA9PiAndGV4dC5sYW5nJywKPiAgICAg
ICAgdGV4dF9jb3VudCA9PiB7IGNvdW50ID0+ICd0ZXh0LmlkJyB9LAo+ICAgICB9LAo+ICAgICBq
b2luID0+ICd0ZXh0JywKPiAgICAgcmVzdWx0X2NsYXNzID0+ICdEQkl4OjpDbGFzczo6UmVzdWx0
Q2xhc3M6Okhhc2hSZWZJbmZsYXRvcicsCj4gICB9KS0+YWxsOwo+Cj4gTm93IGlmIHlvdSB3YW50
ZWQgc29tZXRoaW5nIG1vcmUgY29tcGxleCwgbGlrZSB0byBjb3VudCBhIG51bWJlciBvZgo+IHJl
bGF0ZWQgdGhpbmdzLCB5b3UgbWF5IHdhbnQgdG8gbG9vayBhdCBteSBoZWxwZXIsIENvcnJlbGF0
ZVJlbGF0aW9uc2hpcDxodHRwOi8vc2VhcmNoLmNwYW4ub3JnLyU3RWZyZXcvREJJeC1DbGFzcy1I
ZWxwZXJzLTIuMDE1MDAwL2xpYi9EQkl4L0NsYXNzL0hlbHBlci9SZXN1bHRTZXQvQ29ycmVsYXRl
UmVsYXRpb25zaGlwLnBtPiwKPiB3aGljaCB3YXMgcHJldHR5IG11Y2ggbWFkZSBmb3IganVzdCB0
aGlzIHVzZSBjYXNlLCB3aGVyZSBJIGhhZCB0byBtYWtlIDcKPiByZWxhdGVkIGNvdW50cyBmb3Ig
ZWFjaCByb3cgaW4gYSB0YWJsZSBvZiAyNSByb3dzLiAgQmVmb3JlIGNvcnJlbGF0aW5nIGl0Cj4g
d2FzIDI1ICogNyArIDEgcXVlcmllcywgbm93IGl0J3MganVzdCBvbmUgZ2lnYW50aWMgb25lLiAg
RmFzdCBpbiBTUUwKPiBTZXJ2ZXIsIHN1cHBvc2VkbHkgaXQgd2lsbCBiZSBzbG93IGluIG15c3Fs
LCBidXQgSSBoYXZlIHlldCB0byBzZWUgZXZpZGVuY2UKPiBvZiB0aGF0Lgo+Cj4gSG9wZSB0aGlz
IGhlbHBzIQo+Cj4gLWZSRVcKPgo+IF9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fCj4gTGlzdDogaHR0cDovL2xpc3RzLnNjc3lzLmNvLnVrL2NnaS1iaW4vbWFp
bG1hbi9saXN0aW5mby9kYml4LWNsYXNzCj4gSVJDOiBpcmMucGVybC5vcmcjZGJpeC1jbGFzcwo+
IFNWTjogaHR0cDovL2Rldi5jYXRhbHlzdC5wZXJsLm9yZy9yZXBvcy9iYXN0L0RCSXgtQ2xhc3Mv
Cj4gU2VhcmNoYWJsZSBBcmNoaXZlOgo+IGh0dHA6Ly93d3cuZ3Jva2Jhc2UuY29tL2dyb3VwL2Ri
aXgtY2xhc3NAbGlzdHMuc2NzeXMuY28udWsKPgotLS0tLS0tLS0tLS0tLSBuZXh0IHBhcnQgLS0t
LS0tLS0tLS0tLS0KQW4gSFRNTCBhdHRhY2htZW50IHdhcyBzY3J1YmJlZC4uLgpVUkw6IGh0dHA6
Ly9saXN0cy5zY3N5cy5jby51ay9waXBlcm1haWwvZGJpeC1jbGFzcy9hdHRhY2htZW50cy8yMDEy
MDgyNy9kMGNjZGU5OS9hdHRhY2htZW50Lmh0bQo=