Symfony Profiler

SELECT 
  i.id, 
  i.title, 
  i.parent_id, 
  i.navigation_title, 
  i.type, 
  i.hidden, 
  i.data, 
  m.url, 
  m.data AS meta_data, 
  m.seo_follow, 
  m.seo_index, 
  i.allow_children, 
  IF(
    COUNT(e.id) > 0, 
    1, 
    0
  ) AS has_extra, 
  GROUP_CONCAT(b.extra_id) AS extra_ids, 
  IF(
    COUNT(p.id), 
    1, 
    0
  ) AS has_children 
FROM 
  pages AS i 
  INNER JOIN meta AS m ON i.meta_id = m.id 
  LEFT OUTER JOIN pages_blocks AS b ON b.revision_id = i.revision_id 
  LEFT OUTER JOIN modules_extras AS e ON e.id = b.extra_id 
  AND e.type = ? 
  LEFT OUTER JOIN pages AS p ON p.parent_id = i.id 
  AND p.status = "active" 
  AND p.hidden = "N" 
  AND p.data NOT LIKE "%s:9:\"is_action\";b:1;%" 
  AND p.language = i.language 
WHERE 
  i.parent_id IN (2, 404, 1, 3, 405, 406) 
  AND i.status = ? 
  AND i.language = ? 
GROUP BY 
  i.revision_id 
ORDER BY 
  i.sequence ASC

SELECT 
  i.id, 
  i.module, 
  i.action 
FROM 
  modules_extras AS i 
WHERE 
  i.type = ? 
  AND i.hidden = ?

SELECT 
  i.id, 
  i.title, 
  i.parent_id, 
  i.navigation_title, 
  i.type, 
  i.hidden, 
  i.data, 
  m.url, 
  m.data AS meta_data, 
  m.seo_follow, 
  m.seo_index, 
  i.allow_children, 
  IF(
    COUNT(e.id) > 0, 
    1, 
    0
  ) AS has_extra, 
  GROUP_CONCAT(b.extra_id) AS extra_ids, 
  IF(
    COUNT(p.id), 
    1, 
    0
  ) AS has_children 
FROM 
  pages AS i 
  INNER JOIN meta AS m ON i.meta_id = m.id 
  LEFT OUTER JOIN pages_blocks AS b ON b.revision_id = i.revision_id 
  LEFT OUTER JOIN modules_extras AS e ON e.id = b.extra_id 
  AND e.type = ? 
  LEFT OUTER JOIN pages AS p ON p.parent_id = i.id 
  AND p.status = "active" 
  AND p.hidden = "N" 
  AND p.data NOT LIKE "%s:9:\"is_action\";b:1;%" 
  AND p.language = i.language 
WHERE 
  i.parent_id IN (2, 404, 1, 3, 405, 406) 
  AND i.status = ? 
  AND i.language = ? 
GROUP BY 
  i.revision_id 
ORDER BY 
  i.sequence ASC

SELECT 
  `key`, 
  `value` 
FROM 
  custom_variables 
WHERE 
  `language` = ? 
  AND `type` = ? 
  AND `serialized` = ?

SELECT 
  p.id, 
  p.parent_id, 
  p.revision_id, 
  p.template_id, 
  p.title, 
  p.navigation_title, 
  p.navigation_title_overwrite, 
  p.data, 
  p.hidden, 
  m.title AS meta_title, 
  m.title_overwrite AS meta_title_overwrite, 
  m.keywords AS meta_keywords, 
  m.keywords_overwrite AS meta_keywords_overwrite, 
  m.description AS meta_description, 
  m.description_overwrite AS meta_description_overwrite, 
  m.custom AS meta_custom, 
  m.url, 
  m.url_overwrite, 
  m.data AS meta_data, 
  m.seo_follow AS meta_seo_follow, 
  m.seo_index AS meta_seo_index, 
  t.path AS template_path, 
  t.data AS template_data 
FROM 
  pages AS p 
  INNER JOIN meta AS m ON p.meta_id = m.id 
  INNER JOIN themes_templates AS t ON p.template_id = t.id 
WHERE 
  p.revision_id = ? 
  AND p.language = ? 
LIMIT 
  1

SELECT 
  `key`, 
  `value` 
FROM 
  custom_variables 
WHERE 
  `language` = ? 
  AND `type` = ? 
  AND `serialized` = ?