Symfony Profiler

SELECT 
  k0_.locale AS locale_0, 
  k0_.domain AS domain_1 
FROM 
  kuma_translation k0_ 
GROUP BY 
  k0_.locale, 
  k0_.domain

SELECT k0_.locale AS locale_0, k0_.domain AS domain_1 FROM kuma_translation k0_ GROUP BY k0_.locale, k0_.domain;

SELECT 
  t0.type AS type_1, 
  t0.link_url AS link_url_2, 
  t0.link_text AS link_text_3, 
  t0.link_new_window AS link_new_window_4, 
  t0.id AS id_5 
FROM 
  gcs_social_links t0 
WHERE 
  t0.type = ? 
LIMIT 
  1

SELECT t0.type AS type_1, t0.link_url AS link_url_2, t0.link_text AS link_text_3, t0.link_new_window AS link_new_window_4, t0.id AS id_5 FROM gcs_social_links t0 WHERE t0.type = 'facebook' LIMIT 1;

SELECT 
  k0_.lft AS lft_0, 
  k0_.lvl AS lvl_1, 
  k0_.rgt AS rgt_2, 
  k0_.deleted AS deleted_3, 
  k0_.hidden_from_nav AS hidden_from_nav_4, 
  k0_.ref_entity_name AS ref_entity_name_5, 
  k0_.internal_name AS internal_name_6, 
  k0_.id AS id_7, 
  k1_.lang AS lang_8, 
  k1_.online AS online_9, 
  k1_.title AS title_10, 
  k1_.slug AS slug_11, 
  k1_.url AS url_12, 
  k1_.weight AS weight_13, 
  k1_.created AS created_14, 
  k1_.updated AS updated_15, 
  k1_.id AS id_16, 
  k2_.type AS type_17, 
  k2_.owner AS owner_18, 
  k2_.created AS created_19, 
  k2_.updated AS updated_20, 
  k2_.ref_id AS ref_id_21, 
  k2_.ref_entity_name AS ref_entity_name_22, 
  k2_.id AS id_23, 
  k0_.parent_id AS parent_id_24, 
  k1_.node_id AS node_id_25, 
  k1_.public_node_version_id AS public_node_version_id_26, 
  k2_.node_translation_id AS node_translation_id_27, 
  k2_.origin_id AS origin_id_28 
FROM 
  kuma_nodes k0_ 
  LEFT JOIN kuma_node_translations k1_ ON k0_.id = k1_.node_id 
  AND (k1_.lang = ?) 
  LEFT JOIN kuma_node_versions k2_ ON k1_.public_node_version_id = k2_.id 
  AND (
    k1_.public_node_version_id = k2_.id
  ) 
  JOIN (
    SELECT 
      DISTINCT o.object_identifier as id 
    FROM 
      host7_gcs_dev.acl_object_identities as o 
      INNER JOIN host7_gcs_dev.acl_classes c ON c.id = o.class_id 
      LEFT JOIN host7_gcs_dev.acl_entries e ON (
        e.class_id = o.class_id 
        AND (
          e.object_identity_id = o.id 
          OR e.object_identity_id IS NULL
        )
      ) 
      LEFT JOIN host7_gcs_dev.acl_security_identities s ON (s.id = e.security_identity_id) 
    WHERE 
      c.class_type = "Kunstmaan\\NodeBundle\\Entity\\Node" 
      AND (
        s.identifier = "IS_AUTHENTICATED_ANONYMOUSLY"
      ) 
      AND e.mask & 1 > 0
  ) ta_ ON k0_.id = ta_.id 
WHERE 
  k0_.deleted = 0 
  AND (
    (
      k0_.hidden_from_nav <> 1 
      OR k0_.internal_name IS NOT NULL
    )
  ) 
ORDER BY 
  k1_.weight ASC, 
  k1_.title ASC

SELECT k0_.lft AS lft_0, k0_.lvl AS lvl_1, k0_.rgt AS rgt_2, k0_.deleted AS deleted_3, k0_.hidden_from_nav AS hidden_from_nav_4, k0_.ref_entity_name AS ref_entity_name_5, k0_.internal_name AS internal_name_6, k0_.id AS id_7, k1_.lang AS lang_8, k1_.online AS online_9, k1_.title AS title_10, k1_.slug AS slug_11, k1_.url AS url_12, k1_.weight AS weight_13, k1_.created AS created_14, k1_.updated AS updated_15, k1_.id AS id_16, k2_.type AS type_17, k2_.owner AS owner_18, k2_.created AS created_19, k2_.updated AS updated_20, k2_.ref_id AS ref_id_21, k2_.ref_entity_name AS ref_entity_name_22, k2_.id AS id_23, k0_.parent_id AS parent_id_24, k1_.node_id AS node_id_25, k1_.public_node_version_id AS public_node_version_id_26, k2_.node_translation_id AS node_translation_id_27, k2_.origin_id AS origin_id_28 FROM kuma_nodes k0_ LEFT JOIN kuma_node_translations k1_ ON k0_.id = k1_.node_id AND (k1_.lang = 'pl') LEFT JOIN kuma_node_versions k2_ ON k1_.public_node_version_id = k2_.id AND (k1_.public_node_version_id = k2_.id) JOIN (SELECT DISTINCT o.object_identifier as id FROM host7_gcs_dev.acl_object_identities as o
INNER JOIN host7_gcs_dev.acl_classes c ON c.id = o.class_id
LEFT JOIN host7_gcs_dev.acl_entries e ON (
    e.class_id = o.class_id AND (e.object_identity_id = o.id
    OR e.object_identity_id IS NULL)
)
LEFT JOIN host7_gcs_dev.acl_security_identities s ON (
s.id = e.security_identity_id
)
WHERE c.class_type = "Kunstmaan\\NodeBundle\\Entity\\Node"
AND (s.identifier = "IS_AUTHENTICATED_ANONYMOUSLY")
AND e.mask & 1 > 0) ta_ ON k0_.id = ta_.id WHERE k0_.deleted = 0 AND ((k0_.hidden_from_nav <> 1 OR k0_.internal_name IS NOT NULL)) ORDER BY k1_.weight ASC, k1_.title ASC;

SELECT 
  COUNT(k0_.id) AS sclr_0, 
  SUM(k0_.events) AS sclr_1 
FROM 
  kuma_exception k0_ 
WHERE 
  k0_.is_resolved = 0

SELECT COUNT(k0_.id) AS sclr_0, SUM(k0_.events) AS sclr_1 FROM kuma_exception k0_ WHERE k0_.is_resolved = 0;

SELECT 
  t0.type AS type_1, 
  t0.link_url AS link_url_2, 
  t0.link_text AS link_text_3, 
  t0.link_new_window AS link_new_window_4, 
  t0.id AS id_5 
FROM 
  gcs_social_links t0 
WHERE 
  t0.type = ? 
LIMIT 
  1

SELECT t0.type AS type_1, t0.link_url AS link_url_2, t0.link_text AS link_text_3, t0.link_new_window AS link_new_window_4, t0.id AS id_5 FROM gcs_social_links t0 WHERE t0.type = 'instagram' LIMIT 1;

SELECT 
  COUNT(k0_.id) AS sclr_0, 
  SUM(k0_.events) AS sclr_1 
FROM 
  kuma_exception k0_ 
WHERE 
  k0_.is_resolved = 0

SELECT COUNT(k0_.id) AS sclr_0, SUM(k0_.events) AS sclr_1 FROM kuma_exception k0_ WHERE k0_.is_resolved = 0;

SELECT 
  t0.type AS type_1, 
  t0.link_url AS link_url_2, 
  t0.link_text AS link_text_3, 
  t0.link_new_window AS link_new_window_4, 
  t0.id AS id_5 
FROM 
  gcs_social_links t0 
WHERE 
  t0.type = ? 
LIMIT 
  1

SELECT t0.type AS type_1, t0.link_url AS link_url_2, t0.link_text AS link_text_3, t0.link_new_window AS link_new_window_4, t0.id AS id_5 FROM gcs_social_links t0 WHERE t0.type = 'youtube' LIMIT 1;

SELECT 
  COUNT(k0_.id) AS sclr_0, 
  SUM(k0_.events) AS sclr_1 
FROM 
  kuma_exception k0_ 
WHERE 
  k0_.is_resolved = 0

SELECT COUNT(k0_.id) AS sclr_0, SUM(k0_.events) AS sclr_1 FROM kuma_exception k0_ WHERE k0_.is_resolved = 0;

SELECT 
  t0.type AS type_1, 
  t0.link_url AS link_url_2, 
  t0.link_text AS link_text_3, 
  t0.link_new_window AS link_new_window_4, 
  t0.id AS id_5 
FROM 
  gcs_social_links t0 
WHERE 
  t0.type = ? 
LIMIT 
  1

SELECT t0.type AS type_1, t0.link_url AS link_url_2, t0.link_text AS link_text_3, t0.link_new_window AS link_new_window_4, t0.id AS id_5 FROM gcs_social_links t0 WHERE t0.type = 'bip' LIMIT 1;

SELECT 
  COUNT(k0_.id) AS sclr_0, 
  SUM(k0_.events) AS sclr_1 
FROM 
  kuma_exception k0_ 
WHERE 
  k0_.is_resolved = 0

SELECT COUNT(k0_.id) AS sclr_0, SUM(k0_.events) AS sclr_1 FROM kuma_exception k0_ WHERE k0_.is_resolved = 0;

SELECT 
  t0.type AS type_1, 
  t0.link_url AS link_url_2, 
  t0.link_text AS link_text_3, 
  t0.link_new_window AS link_new_window_4, 
  t0.id AS id_5 
FROM 
  gcs_social_links t0 
WHERE 
  t0.type = ? 
LIMIT 
  1

SELECT t0.type AS type_1, t0.link_url AS link_url_2, t0.link_text AS link_text_3, t0.link_new_window AS link_new_window_4, t0.id AS id_5 FROM gcs_social_links t0 WHERE t0.type = 'rss' LIMIT 1;

SELECT 
  COUNT(k0_.id) AS sclr_0, 
  SUM(k0_.events) AS sclr_1 
FROM 
  kuma_exception k0_ 
WHERE 
  k0_.is_resolved = 0

SELECT COUNT(k0_.id) AS sclr_0, SUM(k0_.events) AS sclr_1 FROM kuma_exception k0_ WHERE k0_.is_resolved = 0;

SELECT 
  t0.type AS type_1, 
  t0.link_url AS link_url_2, 
  t0.link_text AS link_text_3, 
  t0.link_new_window AS link_new_window_4, 
  t0.id AS id_5 
FROM 
  gcs_social_links t0 
WHERE 
  t0.type = ? 
LIMIT 
  1

SELECT t0.type AS type_1, t0.link_url AS link_url_2, t0.link_text AS link_text_3, t0.link_new_window AS link_new_window_4, t0.id AS id_5 FROM gcs_social_links t0 WHERE t0.type = 'twitter' LIMIT 1;

SELECT 
  COUNT(k0_.id) AS sclr_0, 
  SUM(k0_.events) AS sclr_1 
FROM 
  kuma_exception k0_ 
WHERE 
  k0_.is_resolved = 0

SELECT COUNT(k0_.id) AS sclr_0, SUM(k0_.events) AS sclr_1 FROM kuma_exception k0_ WHERE k0_.is_resolved = 0;

SELECT 
  k0_.type AS type_0, 
  k0_.title AS title_1, 
  k0_.url AS url_2, 
  k0_.new_window AS new_window_3, 
  k0_.lft AS lft_4, 
  k0_.lvl AS lvl_5, 
  k0_.rgt AS rgt_6, 
  k0_.id AS id_7, 
  k1_.type AS type_8, 
  k1_.title AS title_9, 
  k1_.url AS url_10, 
  k1_.new_window AS new_window_11, 
  k1_.lft AS lft_12, 
  k1_.lvl AS lvl_13, 
  k1_.rgt AS rgt_14, 
  k1_.id AS id_15, 
  k2_.lang AS lang_16, 
  k2_.online AS online_17, 
  k2_.title AS title_18, 
  k2_.slug AS slug_19, 
  k2_.url AS url_20, 
  k2_.weight AS weight_21, 
  k2_.created AS created_22, 
  k2_.updated AS updated_23, 
  k2_.id AS id_24 
FROM 
  kuma_menu_item k0_ 
  INNER JOIN kuma_menu k3_ ON k0_.menu_id = k3_.id 
  LEFT JOIN kuma_menu_item k1_ ON k0_.parent_id = k1_.id 
  LEFT JOIN kuma_node_translations k2_ ON k0_.node_translation_id = k2_.id 
  LEFT JOIN kuma_nodes k4_ ON k2_.node_id = k4_.id 
WHERE 
  k3_.locale = ? 
  AND k3_.name = ? 
  AND (
    k2_.online = 1 
    OR k0_.type = ?
  ) 
ORDER BY 
  k0_.lft ASC

SELECT k0_.type AS type_0, k0_.title AS title_1, k0_.url AS url_2, k0_.new_window AS new_window_3, k0_.lft AS lft_4, k0_.lvl AS lvl_5, k0_.rgt AS rgt_6, k0_.id AS id_7, k1_.type AS type_8, k1_.title AS title_9, k1_.url AS url_10, k1_.new_window AS new_window_11, k1_.lft AS lft_12, k1_.lvl AS lvl_13, k1_.rgt AS rgt_14, k1_.id AS id_15, k2_.lang AS lang_16, k2_.online AS online_17, k2_.title AS title_18, k2_.slug AS slug_19, k2_.url AS url_20, k2_.weight AS weight_21, k2_.created AS created_22, k2_.updated AS updated_23, k2_.id AS id_24 FROM kuma_menu_item k0_ INNER JOIN kuma_menu k3_ ON k0_.menu_id = k3_.id LEFT JOIN kuma_menu_item k1_ ON k0_.parent_id = k1_.id LEFT JOIN kuma_node_translations k2_ ON k0_.node_translation_id = k2_.id LEFT JOIN kuma_nodes k4_ ON k2_.node_id = k4_.id WHERE k3_.locale = 'pl' AND k3_.name = 'main_navigation' AND (k2_.online = 1 OR k0_.type = 'url_link') ORDER BY k0_.lft ASC;

SELECT 
  COUNT(k0_.id) AS sclr_0, 
  SUM(k0_.events) AS sclr_1 
FROM 
  kuma_exception k0_ 
WHERE 
  k0_.is_resolved = 0

SELECT COUNT(k0_.id) AS sclr_0, SUM(k0_.events) AS sclr_1 FROM kuma_exception k0_ WHERE k0_.is_resolved = 0;

SELECT 
  k0_.type AS type_0, 
  k0_.title AS title_1, 
  k0_.url AS url_2, 
  k0_.new_window AS new_window_3, 
  k0_.lft AS lft_4, 
  k0_.lvl AS lvl_5, 
  k0_.rgt AS rgt_6, 
  k0_.id AS id_7, 
  k1_.type AS type_8, 
  k1_.title AS title_9, 
  k1_.url AS url_10, 
  k1_.new_window AS new_window_11, 
  k1_.lft AS lft_12, 
  k1_.lvl AS lvl_13, 
  k1_.rgt AS rgt_14, 
  k1_.id AS id_15, 
  k2_.lang AS lang_16, 
  k2_.online AS online_17, 
  k2_.title AS title_18, 
  k2_.slug AS slug_19, 
  k2_.url AS url_20, 
  k2_.weight AS weight_21, 
  k2_.created AS created_22, 
  k2_.updated AS updated_23, 
  k2_.id AS id_24 
FROM 
  kuma_menu_item k0_ 
  INNER JOIN kuma_menu k3_ ON k0_.menu_id = k3_.id 
  LEFT JOIN kuma_menu_item k1_ ON k0_.parent_id = k1_.id 
  LEFT JOIN kuma_node_translations k2_ ON k0_.node_translation_id = k2_.id 
  LEFT JOIN kuma_nodes k4_ ON k2_.node_id = k4_.id 
WHERE 
  k3_.locale = ? 
  AND k3_.name = ? 
  AND (
    k2_.online = 1 
    OR k0_.type = ?
  ) 
ORDER BY 
  k0_.lft ASC

SELECT k0_.type AS type_0, k0_.title AS title_1, k0_.url AS url_2, k0_.new_window AS new_window_3, k0_.lft AS lft_4, k0_.lvl AS lvl_5, k0_.rgt AS rgt_6, k0_.id AS id_7, k1_.type AS type_8, k1_.title AS title_9, k1_.url AS url_10, k1_.new_window AS new_window_11, k1_.lft AS lft_12, k1_.lvl AS lvl_13, k1_.rgt AS rgt_14, k1_.id AS id_15, k2_.lang AS lang_16, k2_.online AS online_17, k2_.title AS title_18, k2_.slug AS slug_19, k2_.url AS url_20, k2_.weight AS weight_21, k2_.created AS created_22, k2_.updated AS updated_23, k2_.id AS id_24 FROM kuma_menu_item k0_ INNER JOIN kuma_menu k3_ ON k0_.menu_id = k3_.id LEFT JOIN kuma_menu_item k1_ ON k0_.parent_id = k1_.id LEFT JOIN kuma_node_translations k2_ ON k0_.node_translation_id = k2_.id LEFT JOIN kuma_nodes k4_ ON k2_.node_id = k4_.id WHERE k3_.locale = 'pl' AND k3_.name = 'footer_navigation' AND (k2_.online = 1 OR k0_.type = 'url_link') ORDER BY k0_.lft ASC;