Symfony Profiler

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t0.id AS id_1,
  t0.domain AS domain_2,
  t0.origin AS origin_3,
  t0.target AS target_4,
  t0.permanent AS permanent_5
FROM
  hg_settings_redirect t0

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.origin AS origin_3, t0.target AS target_4, t0.permanent AS permanent_5 FROM hg_settings_redirect t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.cosmetics AS cosmetics_4,
  t0.taska AS taska_5,
  t0.gift_set AS gift_set_6,
  t0.hidden AS hidden_7,
  t0.single_name AS single_name_8,
  t0.plural_name AS plural_name_9,
  t0.position AS position_10,
  t0.`lead` AS lead_11,
  t0.seo_description AS seo_description_12,
  t0.title AS title_13
FROM
  product_category t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.cosmetics AS cosmetics_4, t0.taska AS taska_5, t0.gift_set AS gift_set_6, t0.hidden AS hidden_7, t0.single_name AS single_name_8, t0.plural_name AS plural_name_9, t0.position AS position_10, t0.`lead` AS lead_11, t0.seo_description AS seo_description_12, t0.title AS title_13 FROM product_category t0 WHERE t0.code = 'top10' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.cosmetics AS cosmetics_4,
  t0.taska AS taska_5,
  t0.gift_set AS gift_set_6,
  t0.hidden AS hidden_7,
  t0.single_name AS single_name_8,
  t0.plural_name AS plural_name_9,
  t0.position AS position_10,
  t0.`lead` AS lead_11,
  t0.seo_description AS seo_description_12,
  t0.title AS title_13
FROM
  product_category t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.cosmetics AS cosmetics_4, t0.taska AS taska_5, t0.gift_set AS gift_set_6, t0.hidden AS hidden_7, t0.single_name AS single_name_8, t0.plural_name AS plural_name_9, t0.position AS position_10, t0.`lead` AS lead_11, t0.seo_description AS seo_description_12, t0.title AS title_13 FROM product_category t0 WHERE t0.code = 'top10' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.slug AS slug_4,
  t0.search_terms AS search_terms_5,
  t0.text AS text_6,
  t0.text_female AS text_female_7,
  t0.text_male AS text_male_8,
  t0.highlighted AS highlighted_9,
  t0.main_page_fragrance AS main_page_fragrance_10,
  t0.highlighted_in_search AS highlighted_in_search_11,
  t0.is_on_main_page AS is_on_main_page_12,
  t0.special AS special_13,
  t0.special_name AS special_name_14,
  t0.slogan AS slogan_15,
  t0.`lead` AS lead_16,
  t0.active AS active_17,
  t0.exclude_from_arukereso AS exclude_from_arukereso_18,
  t0.image_id AS image_id_19
FROM
  brand t0
WHERE
  t0.slug = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.slug AS slug_4, t0.search_terms AS search_terms_5, t0.text AS text_6, t0.text_female AS text_female_7, t0.text_male AS text_male_8, t0.highlighted AS highlighted_9, t0.main_page_fragrance AS main_page_fragrance_10, t0.highlighted_in_search AS highlighted_in_search_11, t0.is_on_main_page AS is_on_main_page_12, t0.special AS special_13, t0.special_name AS special_name_14, t0.slogan AS slogan_15, t0.`lead` AS lead_16, t0.active AS active_17, t0.exclude_from_arukereso AS exclude_from_arukereso_18, t0.image_id AS image_id_19 FROM brand t0 WHERE t0.slug = 'top10' AND t0.active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.slug AS slug_4,
  t0.search_terms AS search_terms_5,
  t0.text AS text_6,
  t0.text_female AS text_female_7,
  t0.text_male AS text_male_8,
  t0.highlighted AS highlighted_9,
  t0.main_page_fragrance AS main_page_fragrance_10,
  t0.highlighted_in_search AS highlighted_in_search_11,
  t0.is_on_main_page AS is_on_main_page_12,
  t0.special AS special_13,
  t0.special_name AS special_name_14,
  t0.slogan AS slogan_15,
  t0.`lead` AS lead_16,
  t0.active AS active_17,
  t0.exclude_from_arukereso AS exclude_from_arukereso_18,
  t0.image_id AS image_id_19
FROM
  brand t0
WHERE
  t0.slug = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.slug AS slug_4, t0.search_terms AS search_terms_5, t0.text AS text_6, t0.text_female AS text_female_7, t0.text_male AS text_male_8, t0.highlighted AS highlighted_9, t0.main_page_fragrance AS main_page_fragrance_10, t0.highlighted_in_search AS highlighted_in_search_11, t0.is_on_main_page AS is_on_main_page_12, t0.special AS special_13, t0.special_name AS special_name_14, t0.slogan AS slogan_15, t0.`lead` AS lead_16, t0.active AS active_17, t0.exclude_from_arukereso AS exclude_from_arukereso_18, t0.image_id AS image_id_19 FROM brand t0 WHERE t0.slug = 'top10' AND t0.active = 1 LIMIT 1;

SELECT
  h0_.id AS id_0,
  h0_.lang AS lang_1,
  h0_.online AS online_2,
  h0_.title AS title_3,
  h0_.slug AS slug_4,
  h0_.url AS url_5,
  h0_.weight AS weight_6,
  h0_.created AS created_7,
  h0_.updated AS updated_8,
  h1_.id AS id_9,
  h1_.type AS type_10,
  h1_.owner AS owner_11,
  h1_.created AS created_12,
  h1_.updated AS updated_13,
  h1_.ref_id AS ref_id_14,
  h1_.ref_entity_name AS ref_entity_name_15,
  h0_.node_id AS node_id_16,
  h0_.public_node_version_id AS public_node_version_id_17,
  h1_.node_translation_id AS node_translation_id_18,
  h1_.origin_id AS origin_id_19
FROM
  hg_node_node_translations h0_
  INNER JOIN hg_node_nodes h2_ ON h0_.node_id = h2_.id
  AND (h0_.node_id = h2_.id)
  LEFT JOIN hg_node_node_versions h1_ ON h0_.public_node_version_id = h1_.id
  AND (
    h0_.public_node_version_id = h1_.id
  )
WHERE
  h2_.deleted = 0
  AND h0_.lang = ?
  AND h0_.url = ?
ORDER BY
  h0_.online DESC

SELECT h0_.id AS id_0, h0_.lang AS lang_1, h0_.online AS online_2, h0_.title AS title_3, h0_.slug AS slug_4, h0_.url AS url_5, h0_.weight AS weight_6, h0_.created AS created_7, h0_.updated AS updated_8, h1_.id AS id_9, h1_.type AS type_10, h1_.owner AS owner_11, h1_.created AS created_12, h1_.updated AS updated_13, h1_.ref_id AS ref_id_14, h1_.ref_entity_name AS ref_entity_name_15, h0_.node_id AS node_id_16, h0_.public_node_version_id AS public_node_version_id_17, h1_.node_translation_id AS node_translation_id_18, h1_.origin_id AS origin_id_19 FROM hg_node_node_translations h0_ INNER JOIN hg_node_nodes h2_ ON h0_.node_id = h2_.id AND (h0_.node_id = h2_.id) LEFT JOIN hg_node_node_versions h1_ ON h0_.public_node_version_id = h1_.id AND (h0_.public_node_version_id = h1_.id) WHERE h2_.deleted = 0 AND h0_.lang = 'hu' AND h0_.url = 'top10' ORDER BY h0_.online DESC;

SELECT
  t0.remote_url AS remote_url_1,
  t0.id AS id_2,
  t0.title AS title_3,
  t0.page_title AS page_title_4
FROM
  app_folder_pages t0
WHERE
  t0.id = ?

SELECT t0.remote_url AS remote_url_1, t0.id AS id_2, t0.title AS title_3, t0.page_title AS page_title_4 FROM app_folder_pages t0 WHERE t0.id = 12;

SELECT
  a.ancestor_id
FROM
  acl_object_identities o
  INNER JOIN acl_classes c ON c.id = o.class_id
  INNER JOIN acl_object_identity_ancestors a ON a.object_identity_id = o.id
WHERE
  (
    (
      o.object_identifier IN ('79')
      AND c.class_type = 'Hgabka\\NodeBundle\\Entity\\Node'
    )
  )

SELECT a.ancestor_id
            FROM
                acl_object_identities o
            INNER JOIN acl_classes c ON c.id = o.class_id
            INNER JOIN acl_object_identity_ancestors a ON a.object_identity_id = o.id
               WHERE ((o.object_identifier IN ('79') AND c.class_type = 'Hgabka\\NodeBundle\\Entity\\Node'));

SELECT
  o.id AS acl_id,
  o.object_identifier,
  o.parent_object_identity_id,
  o.entries_inheriting,
  c.class_type,
  e.id AS ace_id,
  e.object_identity_id,
  e.field_name,
  e.ace_order,
  e.mask,
  e.granting,
  e.granting_strategy,
  e.audit_success,
  e.audit_failure,
  s.username,
  s.identifier AS security_identifier
FROM
  acl_object_identities o
  INNER JOIN acl_classes c ON c.id = o.class_id
  LEFT JOIN 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 acl_security_identities s ON (s.id = e.security_identity_id)
WHERE
  (o.id = 803)

SELECT
                o.id AS acl_id,
                o.object_identifier,
                o.parent_object_identity_id,
                o.entries_inheriting,
                c.class_type,
                e.id AS ace_id,
                e.object_identity_id,
                e.field_name,
                e.ace_order,
                e.mask,
                e.granting,
                e.granting_strategy,
                e.audit_success,
                e.audit_failure,
                s.username,
                s.identifier AS security_identifier
            FROM
                acl_object_identities o
            INNER JOIN acl_classes c ON c.id = o.class_id
            LEFT JOIN 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 acl_security_identities s ON (
                s.id = e.security_identity_id
            )

            WHERE (o.id =803);