Query Metrics
56
Database Queries
16
Different statements
39.15 ms
Query time
1
Invalid entities
30
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.68 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"language_settings"
]
|
| 2 | 3.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"event_settings"
]
|
| 3 | 0.73 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"event_settings"
]
|
| 4 | 0.72 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"language_settings"
]
|
| 5 | 0.80 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM setting_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
6
]
|
| 6 | 0.62 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM setting_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
6
]
|
| 7 | 0.55 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.enabled AS enabled_3 FROM currency c0_ WHERE c0_.enabled = 1
Parameters:
[] |
| 8 | 0.50 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.enabled AS enabled_3 FROM currency c0_ WHERE c0_.enabled = 1
Parameters:
[] |
| 9 | 0.42 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.enabled AS enabled_3 FROM currency c0_ WHERE c0_.enabled = 1
Parameters:
[] |
| 10 | 0.40 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.enabled AS enabled_3 FROM currency c0_ WHERE c0_.enabled = 1
Parameters:
[] |
| 11 | 0.54 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"AnalyticalPlatforms"
]
|
| 12 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"group_registration"
]
|
| 13 | 0.67 ms |
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.registration_limit AS registration_limit_3, t0.hidden AS hidden_4, t0.password AS password_5, t0.show_for_languages AS show_for_languages_6, t0.hash AS hash_7, t0.template_id AS template_id_8 FROM ticket t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 14 | 0.58 ms |
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.registration_limit AS registration_limit_3, t0.hidden AS hidden_4, t0.password AS password_5, t0.show_for_languages AS show_for_languages_6, t0.hash AS hash_7, t0.template_id AS template_id_8 FROM ticket t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 15 | 0.54 ms |
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.registration_limit AS registration_limit_3, t0.hidden AS hidden_4, t0.password AS password_5, t0.show_for_languages AS show_for_languages_6, t0.hash AS hash_7, t0.template_id AS template_id_8 FROM ticket t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 16 | 0.95 ms |
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.type AS type_3, t0.registration_limit AS registration_limit_4, t0.visible AS visible_5, t0.required AS required_6, t0.width AS width_7 FROM registration_form_agenda t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 17 | 0.80 ms |
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.type AS type_3, t0.registration_limit AS registration_limit_4, t0.visible AS visible_5, t0.required AS required_6, t0.width AS width_7 FROM registration_form_agenda t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 18 | 0.79 ms |
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.type AS type_3, t0.registration_limit AS registration_limit_4, t0.visible AS visible_5, t0.required AS required_6, t0.width AS width_7 FROM registration_form_agenda t0 WHERE t0.id = ?
Parameters:
[
7
]
|
| 19 | 0.61 ms |
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.type AS type_3, t0.registration_limit AS registration_limit_4, t0.visible AS visible_5, t0.required AS required_6, t0.width AS width_7 FROM registration_form_agenda t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 20 | 0.49 ms |
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.type AS type_3, t0.registration_limit AS registration_limit_4, t0.visible AS visible_5, t0.required AS required_6, t0.width AS width_7 FROM registration_form_agenda t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 21 | 0.60 ms |
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.type AS type_3, t0.registration_limit AS registration_limit_4, t0.visible AS visible_5, t0.required AS required_6, t0.width AS width_7 FROM registration_form_agenda t0 WHERE t0.id = ?
Parameters:
[
9
]
|
| 22 | 0.50 ms |
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.type AS type_3, t0.registration_limit AS registration_limit_4, t0.visible AS visible_5, t0.required AS required_6, t0.width AS width_7 FROM registration_form_agenda t0 WHERE t0.id = ?
Parameters:
[
10
]
|
| 23 | 0.43 ms |
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.registration_limit AS registration_limit_3, t0.hidden AS hidden_4, t0.password AS password_5, t0.show_for_languages AS show_for_languages_6, t0.hash AS hash_7, t0.template_id AS template_id_8 FROM ticket t0 WHERE t0.id = ?
Parameters:
[
"3"
]
|
| 24 | 0.72 ms |
SELECT t0.id AS id_1, t0.redirect AS redirect_2, t0.parent_id AS parent_id_3, t0.list_order AS list_order_4, t0.is_homepage AS is_homepage_5, t0.is_visible AS is_visible_6, t0.has_banner AS has_banner_7, t0.has_regform AS has_regform_8, t0.is_in_menu AS is_in_menu_9, t0.url AS url_10, t0.title AS title_11, t0.content AS content_12, t0.main_css AS main_css_13, t0.section_css AS section_css_14, t0.locale AS locale_15 FROM page t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"/"
]
|
| 25 | 0.52 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.enabled AS enabled_3 FROM currency c0_ WHERE c0_.enabled = 1
Parameters:
[] |
| 26 | 0.51 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"BrandingSettings"
]
|
| 27 | 0.67 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"cookies_settings"
]
|
| 28 | 0.75 ms |
SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.content AS content_2, a0_.add_date AS add_date_3 FROM additional_frontend_code a0_ WHERE a0_.type = ? ORDER BY a0_.add_date DESC LIMIT 1
Parameters:
[
"header"
]
|
| 29 | 0.53 ms |
SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.content AS content_2, a0_.add_date AS add_date_3 FROM additional_frontend_code a0_ WHERE a0_.type = ? ORDER BY a0_.add_date DESC LIMIT 1
Parameters:
[
"footer"
]
|
| 30 | 0.75 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.page_id AS page_id_3, t0.block_id AS block_id_4 FROM page_block t0 WHERE t0.page_id = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
| 31 | 0.50 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.settings AS settings_5, t0.items AS items_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM content_block t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 32 | 0.40 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.is_active AS is_active_4, t0.settings AS settings_5, t0.items AS items_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM content_block t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 33 | 0.51 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM content_block_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
| 34 | 0.50 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM content_block_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
2
]
|
| 35 | 0.76 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.enabled AS enabled_3 FROM currency c0_ WHERE c0_.enabled = 1
Parameters:
[] |
| 36 | 0.80 ms |
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.ticket_id = ? AND r0_.status IN (?, ?, ?, ?)
Parameters:
[ 1 "completed" "paid" "not_paid" "accepted" ] |
| 37 | 0.75 ms |
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.ticket_id = ? AND r0_.status IN (?, ?, ?, ?)
Parameters:
[ 2 "completed" "paid" "not_paid" "accepted" ] |
| 38 | 0.68 ms |
SELECT count(r0_.id) AS sclr_0 FROM registration r0_ WHERE r0_.ticket_id = ? AND r0_.status IN (?, ?, ?, ?)
Parameters:
[ 3 "completed" "paid" "not_paid" "accepted" ] |
| 39 | 0.76 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[ "group_registration_select_single" "pl" ] |
| 40 | 0.48 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[ "group_registration_select_single_desc" "pl" ] |
| 41 | 0.55 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[ "ticketChoose" "pl" ] |
| 42 | 0.45 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[ "select" "pl" ] |
| 43 | 0.61 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM ticket_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
| 44 | 0.63 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM ticket_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
2
]
|
| 45 | 0.51 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[ "ticketPassword" "pl" ] |
| 46 | 0.45 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[ "beginReg" "pl" ] |
| 47 | 0.76 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[ "group_registration_select_group" "pl" ] |
| 48 | 4.00 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[ "group_registration_select_group_desc" "pl" ] |
| 49 | 0.57 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM ticket_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
3
]
|
| 50 | 0.52 ms |
SELECT t0.id AS id_1, t0.redirect AS redirect_2, t0.parent_id AS parent_id_3, t0.list_order AS list_order_4, t0.is_homepage AS is_homepage_5, t0.is_visible AS is_visible_6, t0.has_banner AS has_banner_7, t0.has_regform AS has_regform_8, t0.is_in_menu AS is_in_menu_9, t0.url AS url_10, t0.title AS title_11, t0.content AS content_12, t0.main_css AS main_css_13, t0.section_css AS section_css_14, t0.locale AS locale_15 FROM page t0 WHERE t0.is_homepage = ?
Parameters:
[
1
]
|
| 51 | 0.47 ms |
SELECT t0.id AS id_1, t0.redirect AS redirect_2, t0.parent_id AS parent_id_3, t0.list_order AS list_order_4, t0.is_homepage AS is_homepage_5, t0.is_visible AS is_visible_6, t0.has_banner AS has_banner_7, t0.has_regform AS has_regform_8, t0.is_in_menu AS is_in_menu_9, t0.url AS url_10, t0.title AS title_11, t0.content AS content_12, t0.main_css AS main_css_13, t0.section_css AS section_css_14, t0.locale AS locale_15 FROM page t0 WHERE t0.locale = ? ORDER BY t0.list_order ASC
Parameters:
[
"pl"
]
|
| 52 | 0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"social_media"
]
|
| 53 | 0.51 ms |
SELECT t0.id AS id_1, t0.original_name AS original_name_2, t0.filename AS filename_3, t0.type AS type_4, t0.size AS size_5, t0.mime_type AS mime_type_6, t0.add_date AS add_date_7, t0.protected AS protected_8, t0.ready AS ready_9, t0.temporary AS temporary_10 FROM file t0 WHERE t0.id = ?
Parameters:
[
24
]
|
| 54 | 0.61 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[ "cookies_text" "pl" ] |
| 55 | 0.49 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[ "cookies_accept" "pl" ] |
| 56 | 0.57 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.language AS language_3, t0.value AS value_4 FROM translation t0 WHERE t0.name = ? AND t0.language = ? LIMIT 1
Parameters:
[ "cookies_accept_required" "pl" ] |
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 |
|---|---|
| App\Core\Doctrine\Entity\RegistrationForm\RegistrationFormAgenda | 7 |
| App\Core\Doctrine\Entity\Setting\Setting | 4 |
| App\Core\Doctrine\Entity\Ticket\Ticket | 4 |
| App\Core\Doctrine\Entity\Ticket\TicketTranslation | 3 |
| App\Core\Doctrine\Entity\TicketTemplate\TicketTemplate | 2 |
| App\Core\Doctrine\Entity\Page\PageBlock | 2 |
| App\Core\Doctrine\Entity\ContentBlock\ContentBlock | 2 |
| App\Core\Doctrine\Entity\ContentBlock\ContentBlockTranslation | 2 |
| App\Core\Doctrine\Entity\Setting\SettingTranslation | 1 |
| App\Core\Doctrine\Entity\Payment\Currency | 1 |
| App\Core\Doctrine\Entity\Page\Page | 1 |
| App\Core\Doctrine\Entity\File\File | 1 |