With an ORM object relation of one-to-one with lazy="true" the expected behaviour is that the sql query doesn't join the "child" table, but Lucee always do the join.
Test case repo: https://github.com/davidsf/cfml-one2one-lazy
Tested in Lucee 4.5.5.006 and Lucee 5.2.5
More info in: https://dev.lucee.org/t/orm-one-to-one-lazy-loading/2993
I've analyzed this ticket & confirmed the issue happened on lucee 4.5 & 5.2.x versions. In lucee, ORM object relation of one-to-one with lazy="true" joins with child table. But it shouldn't join child table while lazy = true . will confirm about this issue. I've added LDEV1591.ZIP file from above link.