Performance issue when issuing queries doctrine-dbal

[dantleech]

When we execute a query doctrine-dbal issues a single corresponding query to the RDBMS.

But then it additionally issues 2 more queries for each row when I iterate over the result set:

2756 Query     SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/stanton/routes/en/the-region/restaurants/pizzeria-la-luna') AND workspace_name = 'default' ORDER BY sort_order ASC
2756 Query     SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/stanton/routes/en/accommodations/restaurants/traube'
              ORDER BY depth, sort_order ASC

@dbu @lsmith77 any idea why? issue with doctrine-dbal?

[lsmith77]

No clue, I do not see where a query like the first one is even generated. The second one seems to be a node fetch.