Query Metrics
64
Database Queries
13
Different statements
82.87 ms
Query time
1
Invalid entities
78
Managed entities
Queries
| #▲ | 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 |