GET https://hotpeppers.e-online.cz/cs/souteze

Query Metrics

64 Database Queries
13 Different statements
82.87 ms Query time
1 Invalid entities
78 Managed entities

Queries

Group similar statements

# Time Info
1 0.76 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.code AS code_2 FROM language l0_ WHERE l0_.code = ?
Parameters:
[
  "cs"
]
2 0.62 ms
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
Parameters:
[]
3 0.91 ms
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
Parameters:
[
  1
  1
]
4 0.84 ms
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 = ?
Parameters:
[
  1
]
5 0.63 ms
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 = ?
Parameters:
[
  21
]
6 0.52 ms
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 = ?
Parameters:
[
  22
]
7 0.50 ms
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 = ?
Parameters:
[
  23
]
8 0.52 ms
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 = ?
Parameters:
[
  24
]
9 0.60 ms
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
Parameters:
[
  1
  "footer"
]
10 0.63 ms
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
Parameters:
[
  1
  1
]
11 5.21 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM contest_state t0 WHERE t0.name IN (?, ?)
Parameters:
[
  "ONGOING"
  "PENDINGANNOUNCEMENT"
]
12 7.19 ms
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
Parameters:
[
  2
  3
  1
]
13 0.86 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM contest_state t0 WHERE t0.name IN (?)
Parameters:
[
  "FINISHED"
]
14 3.22 ms
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
Parameters:
[
  4
  1
]
15 2.04 ms
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
Parameters:
[
  1
  "9148b3e2-07d0-dfee-9067-869c0eba8df4"
]
16 1.80 ms
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
Parameters:
[
  1
  "9148b3e2-07d0-dfee-9067-869c0eba8df4"
]
17 1.76 ms
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 = ?
Parameters:
[
  1
]
18 3.08 ms
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
Parameters:
[
  2
  "5fe441f1-94c9-57da-b8a6-0a6a2c854014"
]
19 2.48 ms
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
Parameters:
[
  3
  "5fe441f1-94c9-57da-b8a6-0a6a2c854014"
]
20 2.22 ms
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
Parameters:
[
  2
  "5fe441f1-94c9-57da-b8a6-0a6a2c854014"
]
21 2.37 ms
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
Parameters:
[
  3
  "5fe441f1-94c9-57da-b8a6-0a6a2c854014"
]
22 5.98 ms
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 = ?
Parameters:
[
  46
]
23 1.13 ms
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 = ?
Parameters:
[
  45
]
24 0.97 ms
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 = ?
Parameters:
[
  44
]
25 0.89 ms
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 = ?
Parameters:
[
  43
]
26 1.00 ms
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 = ?
Parameters:
[
  42
]
27 1.02 ms
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 = ?
Parameters:
[
  41
]
28 0.91 ms
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 = ?
Parameters:
[
  40
]
29 0.93 ms
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 = ?
Parameters:
[
  39
]
30 0.90 ms
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 = ?
Parameters:
[
  38
]
31 0.79 ms
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 = ?
Parameters:
[
  36
]
32 0.77 ms
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 = ?
Parameters:
[
  35
]
33 0.79 ms
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 = ?
Parameters:
[
  34
]
34 0.78 ms
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 = ?
Parameters:
[
  33
]
35 0.75 ms
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 = ?
Parameters:
[
  30
]
36 0.74 ms
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 = ?
Parameters:
[
  29
]
37 0.68 ms
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 = ?
Parameters:
[
  28
]
38 0.70 ms
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 = ?
Parameters:
[
  27
]
39 0.74 ms
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 = ?
Parameters:
[
  26
]
40 0.96 ms
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 = ?
Parameters:
[
  25
]
41 0.72 ms
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 = ?
Parameters:
[
  24
]
42 0.75 ms
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 = ?
Parameters:
[
  23
]
43 0.69 ms
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 = ?
Parameters:
[
  22
]
44 0.74 ms
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 = ?
Parameters:
[
  21
]
45 0.69 ms
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 = ?
Parameters:
[
  20
]
46 0.90 ms
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 = ?
Parameters:
[
  19
]
47 0.79 ms
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 = ?
Parameters:
[
  18
]
48 0.92 ms
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 = ?
Parameters:
[
  17
]
49 0.71 ms
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 = ?
Parameters:
[
  16
]
50 0.72 ms
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 = ?
Parameters:
[
  15
]
51 1.12 ms
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 = ?
Parameters:
[
  14
]
52 0.73 ms
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 = ?
Parameters:
[
  13
]
53 0.70 ms
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 = ?
Parameters:
[
  10
]
54 0.74 ms
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 = ?
Parameters:
[
  9
]
55 0.74 ms
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 = ?
Parameters:
[
  8
]
56 0.91 ms
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 = ?
Parameters:
[
  7
]
57 0.73 ms
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 = ?
Parameters:
[
  6
]
58 0.82 ms
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 = ?
Parameters:
[
  5
]
59 0.82 ms
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 = ?
Parameters:
[
  4
]
60 0.87 ms
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 = ?
Parameters:
[
  3
]
61 0.88 ms
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 = ?
Parameters:
[
  2
]
62 0.78 ms
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 = ?
Parameters:
[
  1
]
63 2.39 ms
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
Parameters:
[
  1
  "6b05ab47-a00b-56ac-b68f-db20fdf04b2c"
]
64 2.82 ms
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
Parameters:
[
  1
  "f34e3439-0eec-5e98-9c2d-2b5ad0d9d019"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
Kiwi\ContestBundle\Entity\Contest 41
Kiwi\ContestBundle\Entity\ContestTranslation 15
Kiwi\WebBundle\Entity\NavigationItem 4
Kiwi\AdminBundle\Entity\Language 3
Kiwi\ContestBundle\Entity\ContestState 3
Kiwi\AdminBundle\Entity\KiwiUser 2
Kiwi\WebBundle\Entity\Page 2
Kiwi\WebBundle\Entity\PageExcerpt 2
Kiwi\WebBundle\Entity\PageSEO 2
Kiwi\AdminBundle\Entity\Project 1
Kiwi\WebBundle\Entity\Navigation 1
Kiwi\ContestBundle\Entity\ContestType 1
Kiwi\WebBundle\Entity\PageState 1

Entities Mapping

Class Mapping errors
Kiwi\AdminBundle\Entity\Language No errors.
Kiwi\AdminBundle\Entity\Project No errors.
Kiwi\AdminBundle\Entity\KiwiUser No errors.
Kiwi\AdminBundle\Entity\Module No errors.
Kiwi\AdminBundle\Entity\Invite No errors.
Kiwi\AdminBundle\Entity\ProjectInformation No errors.
Kiwi\WebBundle\Entity\Navigation No errors.
Kiwi\WebBundle\Entity\NavigationItem
  • The field Kiwi\WebBundle\Entity\NavigationItem#childrens is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Kiwi\WebBundle\Entity\NavigationItem#parent does not contain the required 'inversedBy="childrens"' attribute.
Kiwi\ContestBundle\Entity\ContestState No errors.
Kiwi\ContestBundle\Entity\Contest No errors.
Kiwi\ContestBundle\Entity\ContestType No errors.
Kiwi\ContestBundle\Entity\ContestQuestion No errors.
Kiwi\ContestBundle\Entity\ContestRegisteredUser No errors.
Kiwi\ContestBundle\Entity\ContestAdditionalCondition No errors.
Kiwi\ContestBundle\Entity\ContestTranslation No errors.
Kiwi\WebBundle\Entity\Page No errors.
Kiwi\WebBundle\Entity\PageExcerpt No errors.
Kiwi\WebBundle\Entity\PageSEO No errors.
Kiwi\WebBundle\Entity\PageState No errors.