Query Metrics
35
Database Queries
13
Different statements
34.20 ms
Query time
1
Invalid entities
51
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.21 ms |
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.code AS code_2 FROM language l0_ WHERE l0_.code = ?
Parameters:
[
"en"
]
|
| 2 | 1.72 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.slug = ? LIMIT 1
Parameters:
[
"soutez-o-1-1-vip-listek-na-erofest-2026"
]
|
| 3 | 1.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM contest_state t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 4 | 0.67 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:
[] |
| 5 | 1.06 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:
[ 2 1 ] |
| 6 | 1.28 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:
[
2
]
|
| 7 | 1.09 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:
[
213
]
|
| 8 | 0.62 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:
[
214
]
|
| 9 | 0.61 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:
[
215
]
|
| 10 | 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:
[
216
]
|
| 11 | 0.55 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:
[
217
]
|
| 12 | 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:
[
218
]
|
| 13 | 0.49 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:
[
219
]
|
| 14 | 0.48 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:
[
220
]
|
| 15 | 0.51 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:
[
221
]
|
| 16 | 0.53 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:
[
222
]
|
| 17 | 0.49 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:
[
223
]
|
| 18 | 0.55 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:
[
224
]
|
| 19 | 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:
[
225
]
|
| 20 | 0.49 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:
[
226
]
|
| 21 | 0.48 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:
[
227
]
|
| 22 | 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:
[
228
]
|
| 23 | 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:
[
229
]
|
| 24 | 0.53 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:
[
230
]
|
| 25 | 0.49 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:
[
231
]
|
| 26 | 0.58 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:
[ 2 "footer" ] |
| 27 | 0.56 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:
[ 2 1 ] |
| 28 | 0.87 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM language t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 29 | 5.28 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 "9148b3e2-07d0-dfee-9067-869c0eba8df4" ] |
| 30 | 1.83 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 "9148b3e2-07d0-dfee-9067-869c0eba8df4" ] |
| 31 | 1.12 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
]
|
| 32 | 1.50 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
]
|
| 33 | 2.22 ms |
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 = ?
Parameters:
[
44
]
|
| 34 | 1.74 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 "6b05ab47-a00b-56ac-b68f-db20fdf04b2c" ] |
| 35 | 0.99 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 "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\WebBundle\Entity\NavigationItem | 19 |
| Kiwi\ContestBundle\Entity\ContestRegisteredUser | 10 |
| Kiwi\AdminBundle\Entity\Language | 3 |
| Kiwi\WebBundle\Entity\Page | 3 |
| Kiwi\WebBundle\Entity\PageExcerpt | 3 |
| Kiwi\WebBundle\Entity\PageSEO | 3 |
| Kiwi\AdminBundle\Entity\KiwiUser | 2 |
| Kiwi\ContestBundle\Entity\ContestTranslation | 2 |
| Kiwi\ContestBundle\Entity\Contest | 1 |
| Kiwi\ContestBundle\Entity\ContestType | 1 |
| Kiwi\ContestBundle\Entity\ContestState | 1 |
| Kiwi\AdminBundle\Entity\Project | 1 |
| Kiwi\WebBundle\Entity\Navigation | 1 |
| Kiwi\WebBundle\Entity\PageState | 1 |