Symfony Profiler

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.code AS code_2
FROM
  language l0_
WHERE
  l0_.code = ?

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.code AS code_2 FROM language l0_ WHERE l0_.code = 'cs';

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.short_description AS short_description_6,
  t0.content AS content_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.is_active AS is_active_10,
  t0.rules AS rules_11,
  t0.start_date AS start_date_12,
  t0.end_date AS end_date_13,
  t0.announcemenet_date AS announcemenet_date_14,
  t0.list_image_url AS list_image_url_15,
  t0.list_image_alt AS list_image_alt_16,
  t0.banner_image_url AS banner_image_url_17,
  t0.banner_image_alt AS banner_image_alt_18,
  t0.number_of_winners AS number_of_winners_19,
  t0.allow_unregistered_users AS allow_unregistered_users_20,
  t0.contest_type_id AS contest_type_id_21,
  t0.contest_state_id AS contest_state_id_22,
  t0.language_id AS language_id_23,
  t0.created_by_id AS created_by_id_24
FROM
  contest t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.short_description AS short_description_6, t0.content AS content_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.is_active AS is_active_10, t0.rules AS rules_11, t0.start_date AS start_date_12, t0.end_date AS end_date_13, t0.announcemenet_date AS announcemenet_date_14, t0.list_image_url AS list_image_url_15, t0.list_image_alt AS list_image_alt_16, t0.banner_image_url AS banner_image_url_17, t0.banner_image_alt AS banner_image_alt_18, t0.number_of_winners AS number_of_winners_19, t0.allow_unregistered_users AS allow_unregistered_users_20, t0.contest_type_id AS contest_type_id_21, t0.contest_state_id AS contest_state_id_22, t0.language_id AS language_id_23, t0.created_by_id AS created_by_id_24 FROM contest t0 WHERE t0.slug = 'soutez-o-listky-na-oktagon-74' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  contest_state t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM contest_state t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.domains AS domains_3,
  t0.template AS template_4
FROM
  project t0
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.domains AS domains_3, t0.template AS template_4 FROM project t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_main AS is_main_3,
  t0.language_id AS language_id_4
FROM
  navigation t0
WHERE
  t0.language_id = ?
  AND t0.is_main = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_main AS is_main_3, t0.language_id AS language_id_4 FROM navigation t0 WHERE t0.language_id = 1 AND t0.is_main = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.url AS url_3,
  t0.target AS target_4,
  t0.item_order AS item_order_5,
  t0.navigation_id AS navigation_id_6,
  t0.parent_id AS parent_id_7
FROM
  navigation_item t0
WHERE
  t0.navigation_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.url AS url_3, t0.target AS target_4, t0.item_order AS item_order_5, t0.navigation_id AS navigation_id_6, t0.parent_id AS parent_id_7 FROM navigation_item t0 WHERE t0.navigation_id = 1;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.url AS url_3,
  t0.target AS target_4,
  t0.item_order AS item_order_5,
  t0.navigation_id AS navigation_id_6,
  t0.parent_id AS parent_id_7
FROM
  navigation_item t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.url AS url_3, t0.target AS target_4, t0.item_order AS item_order_5, t0.navigation_id AS navigation_id_6, t0.parent_id AS parent_id_7 FROM navigation_item t0 WHERE t0.parent_id = 21;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.url AS url_3,
  t0.target AS target_4,
  t0.item_order AS item_order_5,
  t0.navigation_id AS navigation_id_6,
  t0.parent_id AS parent_id_7
FROM
  navigation_item t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.url AS url_3, t0.target AS target_4, t0.item_order AS item_order_5, t0.navigation_id AS navigation_id_6, t0.parent_id AS parent_id_7 FROM navigation_item t0 WHERE t0.parent_id = 22;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.url AS url_3,
  t0.target AS target_4,
  t0.item_order AS item_order_5,
  t0.navigation_id AS navigation_id_6,
  t0.parent_id AS parent_id_7
FROM
  navigation_item t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.url AS url_3, t0.target AS target_4, t0.item_order AS item_order_5, t0.navigation_id AS navigation_id_6, t0.parent_id AS parent_id_7 FROM navigation_item t0 WHERE t0.parent_id = 23;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.url AS url_3,
  t0.target AS target_4,
  t0.item_order AS item_order_5,
  t0.navigation_id AS navigation_id_6,
  t0.parent_id AS parent_id_7
FROM
  navigation_item t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.url AS url_3, t0.target AS target_4, t0.item_order AS item_order_5, t0.navigation_id AS navigation_id_6, t0.parent_id AS parent_id_7 FROM navigation_item t0 WHERE t0.parent_id = 24;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_main AS is_main_3,
  t0.language_id AS language_id_4
FROM
  navigation t0
WHERE
  t0.language_id = ?
  AND t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_main AS is_main_3, t0.language_id AS language_id_4 FROM navigation t0 WHERE t0.language_id = 1 AND t0.name = 'footer' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_main AS is_main_3,
  t0.language_id AS language_id_4
FROM
  navigation t0
WHERE
  t0.language_id = ?
  AND t0.is_main = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_main AS is_main_3, t0.language_id AS language_id_4 FROM navigation t0 WHERE t0.language_id = 1 AND t0.is_main = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_homepage AS is_homepage_4,
  t0.blocks AS blocks_5,
  t0.redirect AS redirect_6,
  t0.layout AS layout_7,
  t0.language_group_id AS language_group_id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.uuid AS uuid_11,
  t0.is_current AS is_current_12,
  t0.project_id AS project_id_13,
  t0.language_id AS language_id_14,
  t0.page_excerpt_id AS page_excerpt_id_15,
  t0.page_seo_id AS page_seo_id_16,
  t0.created_by_id AS created_by_id_17,
  t0.page_state_id AS page_state_id_18
FROM
  page t0
WHERE
  t0.language_id = ?
  AND t0.language_group_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_homepage AS is_homepage_4, t0.blocks AS blocks_5, t0.redirect AS redirect_6, t0.layout AS layout_7, t0.language_group_id AS language_group_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.uuid AS uuid_11, t0.is_current AS is_current_12, t0.project_id AS project_id_13, t0.language_id AS language_id_14, t0.page_excerpt_id AS page_excerpt_id_15, t0.page_seo_id AS page_seo_id_16, t0.created_by_id AS created_by_id_17, t0.page_state_id AS page_state_id_18 FROM page t0 WHERE t0.language_id = 1 AND t0.language_group_id = '9148b3e2-07d0-dfee-9067-869c0eba8df4' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_homepage AS is_homepage_4,
  t0.blocks AS blocks_5,
  t0.redirect AS redirect_6,
  t0.layout AS layout_7,
  t0.language_group_id AS language_group_id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.uuid AS uuid_11,
  t0.is_current AS is_current_12,
  t0.project_id AS project_id_13,
  t0.language_id AS language_id_14,
  t0.page_excerpt_id AS page_excerpt_id_15,
  t0.page_seo_id AS page_seo_id_16,
  t0.created_by_id AS created_by_id_17,
  t0.page_state_id AS page_state_id_18
FROM
  page t0
WHERE
  t0.language_id = ?
  AND t0.language_group_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_homepage AS is_homepage_4, t0.blocks AS blocks_5, t0.redirect AS redirect_6, t0.layout AS layout_7, t0.language_group_id AS language_group_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.uuid AS uuid_11, t0.is_current AS is_current_12, t0.project_id AS project_id_13, t0.language_id AS language_id_14, t0.page_excerpt_id AS page_excerpt_id_15, t0.page_seo_id AS page_seo_id_16, t0.created_by_id AS created_by_id_17, t0.page_state_id AS page_state_id_18 FROM page t0 WHERE t0.language_id = 1 AND t0.language_group_id = '9148b3e2-07d0-dfee-9067-869c0eba8df4' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  language t0
  INNER JOIN language_project ON t0.id = language_project.language_id
WHERE
  language_project.project_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM language t0 INNER JOIN language_project ON t0.id = language_project.language_id WHERE language_project.project_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_homepage AS is_homepage_4,
  t0.blocks AS blocks_5,
  t0.redirect AS redirect_6,
  t0.layout AS layout_7,
  t0.language_group_id AS language_group_id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.uuid AS uuid_11,
  t0.is_current AS is_current_12,
  t0.project_id AS project_id_13,
  t0.language_id AS language_id_14,
  t0.page_excerpt_id AS page_excerpt_id_15,
  t0.page_seo_id AS page_seo_id_16,
  t0.created_by_id AS created_by_id_17,
  t0.page_state_id AS page_state_id_18
FROM
  page t0
WHERE
  t0.language_id = ?
  AND t0.language_group_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_homepage AS is_homepage_4, t0.blocks AS blocks_5, t0.redirect AS redirect_6, t0.layout AS layout_7, t0.language_group_id AS language_group_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.uuid AS uuid_11, t0.is_current AS is_current_12, t0.project_id AS project_id_13, t0.language_id AS language_id_14, t0.page_excerpt_id AS page_excerpt_id_15, t0.page_seo_id AS page_seo_id_16, t0.created_by_id AS created_by_id_17, t0.page_state_id AS page_state_id_18 FROM page t0 WHERE t0.language_id = 2 AND t0.language_group_id = 'cd9db695-cab9-50ed-b950-52598ef9b20a' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_homepage AS is_homepage_4,
  t0.blocks AS blocks_5,
  t0.redirect AS redirect_6,
  t0.layout AS layout_7,
  t0.language_group_id AS language_group_id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.uuid AS uuid_11,
  t0.is_current AS is_current_12,
  t0.project_id AS project_id_13,
  t0.language_id AS language_id_14,
  t0.page_excerpt_id AS page_excerpt_id_15,
  t0.page_seo_id AS page_seo_id_16,
  t0.created_by_id AS created_by_id_17,
  t0.page_state_id AS page_state_id_18
FROM
  page t0
WHERE
  t0.language_id = ?
  AND t0.language_group_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_homepage AS is_homepage_4, t0.blocks AS blocks_5, t0.redirect AS redirect_6, t0.layout AS layout_7, t0.language_group_id AS language_group_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.uuid AS uuid_11, t0.is_current AS is_current_12, t0.project_id AS project_id_13, t0.language_id AS language_id_14, t0.page_excerpt_id AS page_excerpt_id_15, t0.page_seo_id AS page_seo_id_16, t0.created_by_id AS created_by_id_17, t0.page_state_id AS page_state_id_18 FROM page t0 WHERE t0.language_id = 3 AND t0.language_group_id = 'cd9db695-cab9-50ed-b950-52598ef9b20a' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_homepage AS is_homepage_4,
  t0.blocks AS blocks_5,
  t0.redirect AS redirect_6,
  t0.layout AS layout_7,
  t0.language_group_id AS language_group_id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.uuid AS uuid_11,
  t0.is_current AS is_current_12,
  t0.project_id AS project_id_13,
  t0.language_id AS language_id_14,
  t0.page_excerpt_id AS page_excerpt_id_15,
  t0.page_seo_id AS page_seo_id_16,
  t0.created_by_id AS created_by_id_17,
  t0.page_state_id AS page_state_id_18
FROM
  page t0
WHERE
  t0.language_id = ?
  AND t0.language_group_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_homepage AS is_homepage_4, t0.blocks AS blocks_5, t0.redirect AS redirect_6, t0.layout AS layout_7, t0.language_group_id AS language_group_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.uuid AS uuid_11, t0.is_current AS is_current_12, t0.project_id AS project_id_13, t0.language_id AS language_id_14, t0.page_excerpt_id AS page_excerpt_id_15, t0.page_seo_id AS page_seo_id_16, t0.created_by_id AS created_by_id_17, t0.page_state_id AS page_state_id_18 FROM page t0 WHERE t0.language_id = 2 AND t0.language_group_id = 'cd9db695-cab9-50ed-b950-52598ef9b20a' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_homepage AS is_homepage_4,
  t0.blocks AS blocks_5,
  t0.redirect AS redirect_6,
  t0.layout AS layout_7,
  t0.language_group_id AS language_group_id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.uuid AS uuid_11,
  t0.is_current AS is_current_12,
  t0.project_id AS project_id_13,
  t0.language_id AS language_id_14,
  t0.page_excerpt_id AS page_excerpt_id_15,
  t0.page_seo_id AS page_seo_id_16,
  t0.created_by_id AS created_by_id_17,
  t0.page_state_id AS page_state_id_18
FROM
  page t0
WHERE
  t0.language_id = ?
  AND t0.language_group_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_homepage AS is_homepage_4, t0.blocks AS blocks_5, t0.redirect AS redirect_6, t0.layout AS layout_7, t0.language_group_id AS language_group_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.uuid AS uuid_11, t0.is_current AS is_current_12, t0.project_id AS project_id_13, t0.language_id AS language_id_14, t0.page_excerpt_id AS page_excerpt_id_15, t0.page_seo_id AS page_seo_id_16, t0.created_by_id AS created_by_id_17, t0.page_state_id AS page_state_id_18 FROM page t0 WHERE t0.language_id = 3 AND t0.language_group_id = 'cd9db695-cab9-50ed-b950-52598ef9b20a' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.short_description AS short_description_4,
  t0.rules AS rules_5,
  t0.list_image_url AS list_image_url_6,
  t0.list_image_alt AS list_image_alt_7,
  t0.banner_image_url AS banner_image_url_8,
  t0.banner_image_alt AS banner_image_alt_9,
  t0.locale AS locale_10,
  t0.translatable_id AS translatable_id_11
FROM
  contest_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.rules AS rules_5, t0.list_image_url AS list_image_url_6, t0.list_image_alt AS list_image_alt_7, t0.banner_image_url AS banner_image_url_8, t0.banner_image_alt AS banner_image_alt_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM contest_translation t0 WHERE t0.translatable_id = 29;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.phone AS phone_4,
  t0.registration_date AS registration_date_5,
  t0.accepted_advertising AS accepted_advertising_6,
  t0.accepted_gdpr AS accepted_gdpr_7,
  t0.accepted_rules AS accepted_rules_8,
  t0.correct_answers AS correct_answers_9,
  t0.incorrect_answers AS incorrect_answers_10,
  t0.answers AS answers_11,
  t0.social_nicknames AS social_nicknames_12,
  t0.locale AS locale_13,
  t0.contest_id AS contest_id_14
FROM
  contest_registered_user t0
  INNER JOIN contest_contest_registered_user ON t0.id = contest_contest_registered_user.contest_registered_user_id
WHERE
  contest_contest_registered_user.contest_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.phone AS phone_4, t0.registration_date AS registration_date_5, t0.accepted_advertising AS accepted_advertising_6, t0.accepted_gdpr AS accepted_gdpr_7, t0.accepted_rules AS accepted_rules_8, t0.correct_answers AS correct_answers_9, t0.incorrect_answers AS incorrect_answers_10, t0.answers AS answers_11, t0.social_nicknames AS social_nicknames_12, t0.locale AS locale_13, t0.contest_id AS contest_id_14 FROM contest_registered_user t0 INNER JOIN contest_contest_registered_user ON t0.id = contest_contest_registered_user.contest_registered_user_id WHERE contest_contest_registered_user.contest_id = 29;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_homepage AS is_homepage_4,
  t0.blocks AS blocks_5,
  t0.redirect AS redirect_6,
  t0.layout AS layout_7,
  t0.language_group_id AS language_group_id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.uuid AS uuid_11,
  t0.is_current AS is_current_12,
  t0.project_id AS project_id_13,
  t0.language_id AS language_id_14,
  t0.page_excerpt_id AS page_excerpt_id_15,
  t0.page_seo_id AS page_seo_id_16,
  t0.created_by_id AS created_by_id_17,
  t0.page_state_id AS page_state_id_18
FROM
  page t0
WHERE
  t0.language_id = ?
  AND t0.language_group_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_homepage AS is_homepage_4, t0.blocks AS blocks_5, t0.redirect AS redirect_6, t0.layout AS layout_7, t0.language_group_id AS language_group_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.uuid AS uuid_11, t0.is_current AS is_current_12, t0.project_id AS project_id_13, t0.language_id AS language_id_14, t0.page_excerpt_id AS page_excerpt_id_15, t0.page_seo_id AS page_seo_id_16, t0.created_by_id AS created_by_id_17, t0.page_state_id AS page_state_id_18 FROM page t0 WHERE t0.language_id = 1 AND t0.language_group_id = '6b05ab47-a00b-56ac-b68f-db20fdf04b2c' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_homepage AS is_homepage_4,
  t0.blocks AS blocks_5,
  t0.redirect AS redirect_6,
  t0.layout AS layout_7,
  t0.language_group_id AS language_group_id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.uuid AS uuid_11,
  t0.is_current AS is_current_12,
  t0.project_id AS project_id_13,
  t0.language_id AS language_id_14,
  t0.page_excerpt_id AS page_excerpt_id_15,
  t0.page_seo_id AS page_seo_id_16,
  t0.created_by_id AS created_by_id_17,
  t0.page_state_id AS page_state_id_18
FROM
  page t0
WHERE
  t0.language_id = ?
  AND t0.language_group_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_homepage AS is_homepage_4, t0.blocks AS blocks_5, t0.redirect AS redirect_6, t0.layout AS layout_7, t0.language_group_id AS language_group_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.uuid AS uuid_11, t0.is_current AS is_current_12, t0.project_id AS project_id_13, t0.language_id AS language_id_14, t0.page_excerpt_id AS page_excerpt_id_15, t0.page_seo_id AS page_seo_id_16, t0.created_by_id AS created_by_id_17, t0.page_state_id AS page_state_id_18 FROM page t0 WHERE t0.language_id = 1 AND t0.language_group_id = 'f34e3439-0eec-5e98-9c2d-2b5ad0d9d019' LIMIT 1;