symfony - Getting only ID from entity relations without fetching whole object in Doctrine

Question

Assume I've an entity, which references itself to map parent-child-relations

class Food
{
    /**
     * @ORMId
     * @ORMColumn(type="integer")
     * @ORMGeneratedValue(strategy="AUTO")
     */
    protected $id;

    /**
     * @ORMManyToOne(targetEntity="Food", inversedBy="foodChildren")
     * @ORMJoinColumn(name="food_group_id", nullable=true)
     */
    protected $foodGroup;

    /**
     * @ORMOneToMany(targetEntity="Food", mappedBy="foodGroup", fetch="LAZY", cascade={"remove"})
     */
    protected $foodChildren;

I have a use case where I want to get food_group_id of an entity without getting full parent object from database. Using fetch="LAZY" doesn't keep Doctrine from querying again. Is there a way to return only the ID when getting $food->getFoodGroup()?

question from:https://stackoverflow.com/questions/19139970/getting-only-id-from-entity-relations-without-fetching-whole-object-in-doctrine

Answer 1

Don't complicate your life, you can just do

$food->getFoodGroup()->getId()

This WILL NOT perform any additional query or trigger lazy load!

Why? Because your $food->foodGroup is a proxy object which knows about it's ID. It will only do lazy load if you call a getter method of some field which hasn't been loaded.