Symfony Profiler

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 = 46;

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.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.contest_state_id IN (?, ?)
  AND t0.is_active = ?
ORDER BY
  t0.created_at DESC

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.contest_state_id IN (2, 3) AND t0.is_active = 1 ORDER BY t0.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  contest_state t0
WHERE
  t0.name IN (?, ?)

SELECT t0.id AS id_1, t0.name AS name_2 FROM contest_state t0 WHERE t0.name IN ('ONGOING', 'PENDINGANNOUNCEMENT');

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.contest_state_id IN (?)
  AND t0.is_active = ?
ORDER BY
  t0.created_at DESC

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.contest_state_id IN (4) AND t0.is_active = 1 ORDER BY t0.created_at DESC;

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.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.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
FROM
  contest_state t0
WHERE
  t0.name IN (?)

SELECT t0.id AS id_1, t0.name AS name_2 FROM contest_state t0 WHERE t0.name IN ('FINISHED');

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
  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.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.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;