如何避免与相关学说实体进行大量数据库查询？(How can I avoid a gazillion database queries with related doctrine entities?)

 在探查器工具栏上，我注意到了很多数据库查询，400 +，当我打印相关的实体信息时会发生这种情况。 我很擅长在我的实体中设置教学映射信息，所以我不知道它是否是我错误配置的东西，或者它是这样的，或者是否有更好的方法来实现它。 
 
 基本上， Estimates实体与CustomersHomes实体有两个一对一的关系。 我会发布我的代码，也许你可以发现一些东西，或者你可以告诉我，到目前为止我的代码是否朝着正确的方向发展。 
 
 估计课程： 
 
class Estimates
{
...
 /**
 * @ORM\OneToOne(targetEntity="MG\AdminBundle\Entity\CustomersHomes")
 * @ORM\JoinColumn(name="work_address_id", referencedColumnName="homes_id")
 *
 */
private $workAddress;

/**
 *
 * @ORM\OneToOne(targetEntity="MG\AdminBundle\Entity\CustomersHomes")
 * @ORM\JoinColumn(name="homes_id", referencedColumnName="homes_id")
 *
 */
private $homeAddress;

...

// getters and setters are in place below

...

}
 
 这是CustomersController.php中的action方法 
 
public function viewAction($customersId)
{
    $em = $this->getDoctrine()->getManager();
    $customer = $em->getRepository('MGAdminBundle:Customers')->find($customersId);
    if (!$customer){
        throw $this->createNotFoundException($this->get('translator')->trans('No record found for this customer.'));
    }

    $allHomes = $em->getRepository('MGAdminBundle:CustomersHomes')->getHomes($customersId,null,10);
    $billingHomes = $em->getRepository('MGAdminBundle:CustomersHomes')->getHomes($customersId, 'billing', 2);
    $allHomesCount = $em->getRepository('MGAdminBundle:CustomersHomes')->getHomesCountByCustomer($customersId);
    $customerSecondaryEmails = $customer->getEmails();
    $customerMessages = $customer->getMessages();
    $estimateRequests = $customer->getRequests();
    $estimates = $customer->getEstimates();
    return $this->render('MGAdminBundle:Customers:view.html.twig', array(
            'customer' => $customer,
            'allHomes' => $allHomes,
            'billingHomes' => $billingHomes,
            'allHomesCount' => $allHomesCount,
            'customerSecondaryEmails' => $customerSecondaryEmails,
            'messages' => $customerMessages,
            'estimateRequests' => $estimateRequests,
            'estimates' => $estimates,
            ));
}
 
 这是MGAdminBundle：客户：view.html.twig 
 
{% extends 'MGAdminBundle::layout.html.twig' %}
{% block title 'Profile: ' | trans ~ customer.firstname | upper ~ ' ' ~ customer.lastname | upper %}
{% block content %}
    {% include 'MGAdminBundle:Customers/Partials:_customer-details.html.twig' %}
    {% include 'MGAdminBundle:Customers/Partials:_secondary-contacts.html.twig' %}
    {% include 'MGAdminBundle:Customers/Partials:_addresses.html.twig' %}
    {% include 'MGAdminBundle:Customers/Partials:_estimate-requests.html.twig' %}    
    {% include 'MGAdminBundle:Customers/Partials:_messages.html.twig' %}
    {% include 'MGAdminBundle:Customers/Partials:_estimates.html.twig' %}
{% endblock %}
 
 这里是MGAdminBundle：客户/部分：_estimates.html.twig 
 
{% if estimates|length > 0 %}
    <h3>{{ 'Estimates' | trans }}</h3>
    <fieldset>

    {% for estimate in estimates %}        
        <div class="row {{ cycle(['even','odd'],loop.index) }}">
            <div class="col-sm-1">{{ estimate.estimatesId | default('-') }}</div>
            <div class="col-sm-2">{% include 'MGAdminBundle:Customers/Partials:_estimate-address.html.twig' with {'homeAddress': estimate.homeAddress, 'workAddress': estimate.workAddress} %}</div>            
            <div class="col-sm-1"></div>
            <div class="col-sm-1"></div>
            <div class="col-sm-1">{{ estimate.total }}</div>
            <div class="col-sm-1">{{ estimate.status | default('-') }}</div>
            <div class="col-sm-3">payments</div>
            <div class="col-sm-1">options</div>
        </div>
    {% endfor %}
    </fieldset>
{% endif %}
 
 最后部分打印估计地址：MGAdminBundle：Customers / Partials：_estimate-address.html.twig（我还在使用这个模板） 
 
{% if homeAddress is defined %}

    {{ homeAddress.name }}

{% endif %}

{% if workAddress is defined %}

    {{ workAddress.name }}

{% endif %}
 
 这是一个截图： 
 
 问题： 
 
 
 
 获取每个估算的家庭住址和工作地址的最佳策略是什么？ 
 
 
 是否应从存储库方法中获取属于客户的估计值？ 现在，使用客户实体内部的getter获得估算值。 
 
 
 请耐心等待，我对这一切都是新手，我甚至不知道如果我有意义。 谢谢。 

On the profiler toolbar I noticed a lot of db queries, 400+, this happens when I print a related entity info. I am very new to setting doctrine mapping information within my entities so I don't know whether it's something I have misconfigured or if that's the way it is or maybe there is a better way to do it.
 
Basically the Estimates entity has two one-to-one relations to the CustomersHomes entity. I'll post my code, maybe you can spot something or perhaps you could tell me if my code so far is going in the right direction.
 
The Estimates class:
 
class Estimates
{
...
 /**
 * @ORM\OneToOne(targetEntity="MG\AdminBundle\Entity\CustomersHomes")
 * @ORM\JoinColumn(name="work_address_id", referencedColumnName="homes_id")
 *
 */
private $workAddress;

/**
 *
 * @ORM\OneToOne(targetEntity="MG\AdminBundle\Entity\CustomersHomes")
 * @ORM\JoinColumn(name="homes_id", referencedColumnName="homes_id")
 *
 */
private $homeAddress;

...

// getters and setters are in place below

...

}
 
And here is the action method in the CustomersController.php
 
public function viewAction($customersId)
{
    $em = $this->getDoctrine()->getManager();
    $customer = $em->getRepository('MGAdminBundle:Customers')->find($customersId);
    if (!$customer){
        throw $this->createNotFoundException($this->get('translator')->trans('No record found for this customer.'));
    }

    $allHomes = $em->getRepository('MGAdminBundle:CustomersHomes')->getHomes($customersId,null,10);
    $billingHomes = $em->getRepository('MGAdminBundle:CustomersHomes')->getHomes($customersId, 'billing', 2);
    $allHomesCount = $em->getRepository('MGAdminBundle:CustomersHomes')->getHomesCountByCustomer($customersId);
    $customerSecondaryEmails = $customer->getEmails();
    $customerMessages = $customer->getMessages();
    $estimateRequests = $customer->getRequests();
    $estimates = $customer->getEstimates();
    return $this->render('MGAdminBundle:Customers:view.html.twig', array(
            'customer' => $customer,
            'allHomes' => $allHomes,
            'billingHomes' => $billingHomes,
            'allHomesCount' => $allHomesCount,
            'customerSecondaryEmails' => $customerSecondaryEmails,
            'messages' => $customerMessages,
            'estimateRequests' => $estimateRequests,
            'estimates' => $estimates,
            ));
}
 
Here is MGAdminBundle:Customers:view.html.twig
 
{% extends 'MGAdminBundle::layout.html.twig' %}
{% block title 'Profile: ' | trans ~ customer.firstname | upper ~ ' ' ~ customer.lastname | upper %}
{% block content %}
    {% include 'MGAdminBundle:Customers/Partials:_customer-details.html.twig' %}
    {% include 'MGAdminBundle:Customers/Partials:_secondary-contacts.html.twig' %}
    {% include 'MGAdminBundle:Customers/Partials:_addresses.html.twig' %}
    {% include 'MGAdminBundle:Customers/Partials:_estimate-requests.html.twig' %}    
    {% include 'MGAdminBundle:Customers/Partials:_messages.html.twig' %}
    {% include 'MGAdminBundle:Customers/Partials:_estimates.html.twig' %}
{% endblock %}
 
And here is MGAdminBundle:Customers/Partials:_estimates.html.twig
 
{% if estimates|length > 0 %}
    <h3>{{ 'Estimates' | trans }}</h3>
    <fieldset>

    {% for estimate in estimates %}        
        <div class="row {{ cycle(['even','odd'],loop.index) }}">
            <div class="col-sm-1">{{ estimate.estimatesId | default('-') }}</div>
            <div class="col-sm-2">{% include 'MGAdminBundle:Customers/Partials:_estimate-address.html.twig' with {'homeAddress': estimate.homeAddress, 'workAddress': estimate.workAddress} %}</div>            
            <div class="col-sm-1"></div>
            <div class="col-sm-1"></div>
            <div class="col-sm-1">{{ estimate.total }}</div>
            <div class="col-sm-1">{{ estimate.status | default('-') }}</div>
            <div class="col-sm-3">payments</div>
            <div class="col-sm-1">options</div>
        </div>
    {% endfor %}
    </fieldset>
{% endif %}
 
And finally the partial to print the estimate address: MGAdminBundle:Customers/Partials:_estimate-address.html.twig (I'm still working with this template)
 
{% if homeAddress is defined %}

    {{ homeAddress.name }}

{% endif %}

{% if workAddress is defined %}

    {{ workAddress.name }}

{% endif %}
 
And here is a screenshot: 
 
Questions:
 
 
 
What is the best strategy to get the home address and work address of each estimate?
 
 
Should the estimates that belong to a customer be fetched from a repository method? Right now the estimates are gotten using a getter inside the customer entity.
 
 
Please bear with me, I'm new to all of this and I don't even know If I make sense. Thank you.

原文：https://stackoverflow.com/questions/21070469