Skip to content

Instantly share code, notes, and snippets.

@rande
Created May 23, 2011 20:59
Show Gist options
  • Save rande/987590 to your computer and use it in GitHub Desktop.
Save rande/987590 to your computer and use it in GitHub Desktop.
With :
$this->get('doctrine.orm.default_entity_manager')->find('Application\Sonata\NewsBundle\Entity\Comment', 1);
$this->get('doctrine.orm.default_entity_manager')->find('Application\Sonata\NewsBundle\Entity\Post', 5);
Then only 1 query :
63 Query SELECT t0.name AS name1, t0.url AS url2, t0.email AS email3, t0.message AS message4, t0.status AS status5, t0.created_at AS created_at6, t0.updated_at AS updated_at7, t0.id AS id8, t0.post_id AS post_id9 FROM news__comment t0 WHERE t0.id = 1
With :
$this->get('doctrine.orm.default_entity_manager')->find('Application\Sonata\NewsBundle\Entity\Post', 5);
$this->get('doctrine.orm.default_entity_manager')->find('Application\Sonata\NewsBundle\Entity\Comment', 1);
64 Query SELECT t0.title AS title1, t0.abstract AS abstract2, t0.content AS content3, t0.enabled AS enabled4, t0.slug AS slug5, t0.publication_date_start AS publication_date_start6, t0.comments_enabled AS comments_enabled7, t0.comments_close_at AS comments_close_at8, t0.comments_default_status AS comments_default_status9, t0.created_at AS created_at10, t0.updated_at AS updated_at11, t0.id AS id12, t0.image_id AS image_id13, t0.author_id AS author_id14 FROM news__post t0 WHERE t0.id = 5
64 Query SELECT t0.name AS name1, t0.url AS url2, t0.email AS email3, t0.message AS message4, t0.status AS status5, t0.created_at AS created_at6, t0.updated_at AS updated_at7, t0.id AS id8, t0.post_id AS post_id9 FROM news__comment t0 WHERE t0.id = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment