Symfony Profiler

SELECT 
  id, 
  locale, 
  name, 
  disabled 
FROM 
  ezcontent_language 
WHERE 
  locale IN (: locale)

SELECT id, locale, name, disabled FROM ezcontent_language WHERE locale IN ('esl-ES', 'eng-GB');

SELECT 
  COUNT(*) count 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      `ezcontentobject_tree`.`is_invisible` = : placeholder2 
      AND `ezcontentobject`.`contentclass_id` IN (13) 
      AND (
        `ezcontentobject`.`language_mask` & 7
      ) > 0 
      AND `ezcontentobject_tree`.`parent_node_id` IN (9075) 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder3 
  AND ezcontentobject_version.status = : placeholder4 
  AND `ezcontentobject_tree`.`depth` <> : placeholder5

SELECT COUNT( * ) count FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject`.`contentclass_id` IN ( 13 ) AND (`ezcontentobject`.`language_mask` & 7) > 0 AND `ezcontentobject_tree`.`parent_node_id` IN ( 9075 ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder3 AND ezcontentobject_version.status = :placeholder4 AND `ezcontentobject_tree`.`depth` <> :placeholder5;

SELECT 
  ezcontentobject_tree.*, 
  `ezcontentobject`.`language_mask`, 
  `ezcontentobject`.`initial_language_id` 
FROM 
  `ezcontentobject_tree` 
  INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id 
  INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id 
WHERE 
  (
    : placeholder1 
    AND (
      `ezcontentobject_tree`.`is_invisible` = : placeholder2 
      AND `ezcontentobject_tree`.`path_string` LIKE : placeholder3 
      AND (
        `ezcontentobject`.`contentclass_id` IN (18) 
        OR `ezcontentobject`.`contentclass_id` IN (32)
      ) 
      AND `ezcontentobject`.`section_id` IN ('1', '3')
    )
  ) 
  AND ezcontentobject.status = : placeholder4 
  AND ezcontentobject_version.status = : placeholder5 
  AND `ezcontentobject_tree`.`depth` <> : placeholder6 
LIMIT 
  1000

SELECT ezcontentobject_tree.*, `ezcontentobject`.`language_mask`, `ezcontentobject`.`initial_language_id` FROM `ezcontentobject_tree` INNER JOIN ezcontentobject ON ezcontentobject_tree.contentobject_id = ezcontentobject.id INNER JOIN ezcontentobject_version ON ezcontentobject.id = ezcontentobject_version.contentobject_id WHERE ( :placeholder1 AND ( `ezcontentobject_tree`.`is_invisible` = :placeholder2 AND `ezcontentobject_tree`.`path_string` LIKE :placeholder3 AND ( `ezcontentobject`.`contentclass_id` IN ( 18 ) OR `ezcontentobject`.`contentclass_id` IN ( 32 ) ) AND `ezcontentobject`.`section_id` IN ( '1', '3' ) ) ) AND ezcontentobject.status = :placeholder4 AND ezcontentobject_version.status = :placeholder5 AND `ezcontentobject_tree`.`depth` <> :placeholder6 LIMIT 1000;