Query Metrics
47
Database Queries
26
Different statements
27.28 ms
Query time
1
Invalid entities
84
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.85 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.language AS language_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.pagination AS pagination_9, t0.dark_mode_enabled AS dark_mode_enabled_10, t0.is_subscription_owner AS is_subscription_owner_11, t0.checkin_app_token AS checkin_app_token_12, t0.hidden_notifications AS hidden_notifications_13, t0.is_support_user AS is_support_user_14, t0.support_user_login_key AS support_user_login_key_15, t0.support_user_login_key_creation_time AS support_user_login_key_creation_time_16, t0.two_factor_secret AS two_factor_secret_17, t0.two_factor_enabled AS two_factor_enabled_18, t0.two_factor_devices AS two_factor_devices_19, t0.two_factor_email_code AS two_factor_email_code_20, t0.two_factor_email_code_expires_at AS two_factor_email_code_expires_at_21, t0.two_factor_authenticated_at AS two_factor_authenticated_at_22, t0.two_factor_last_email_at AS two_factor_last_email_at_23, t0.registration_list_column_settings AS registration_list_column_settings_24 FROM user t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 2 | 0.79 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"
]
|
| 3 | 0.93 ms |
SELECT t0.id AS id_1, t0.registration_number AS registration_number_2, t0.add_date AS add_date_3, t0.modification_date AS modification_date_4, t0.status AS status_5, t0.language AS language_6, t0.invicode AS invicode_7, t0.hash AS hash_8, t0.data_update_token AS data_update_token_9, t0.data_update_last_used_at AS data_update_last_used_at_10, t0.data_update_last_used_ip AS data_update_last_used_ip_11, t0.offer_update_token AS offer_update_token_12, t0.nip_eu AS nip_eu_13, t0.non_transactional_messages_allowed_date AS non_transactional_messages_allowed_date_14, t0.non_transactional_messages_allowed AS non_transactional_messages_allowed_15, t0.ticket_id AS ticket_id_16, t0.currency_id AS currency_id_17, t0.payment_method_id AS payment_method_id_18, t0.discount_code_id AS discount_code_id_19, t0.group_master_registration_id AS group_master_registration_id_20 FROM registration t0 WHERE t0.id = ?
Parameters:
[
"43"
]
|
| 4 | 0.85 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"
]
|
| 5 | 0.63 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.54 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:
[] |
| 7 | 0.81 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
]
|
| 8 | 0.76 ms |
SELECT t0_.id AS id_0, t0_.visible AS visible_1, t0_.add_date AS add_date_2, t0_.agenda_first AS agenda_first_3, t0_.block_same_emails AS block_same_emails_4, t0_.blocking_rules AS blocking_rules_5, t0_.regform_configuration AS regform_configuration_6, t0_.agenda_free_places_type AS agenda_free_places_type_7, t0_.agenda_description_type AS agenda_description_type_8, t0_.automatic_payment_confirmation_send AS automatic_payment_confirmation_send_9, t0_.payment_reminder_enable AS payment_reminder_enable_10, t0_.enable_summary_step AS enable_summary_step_11, t0_.cancellation_enable AS cancellation_enable_12, t0_.default_template AS default_template_13, t0_.use_default_regform_configuration AS use_default_regform_configuration_14, t0_.use_default_agenda_configuration AS use_default_agenda_configuration_15, t0_.use_default_summary_configuration AS use_default_summary_configuration_16, t0_.use_default_confirmation_configuration AS use_default_confirmation_configuration_17, t0_.use_default_registration_confirmation_configuration AS use_default_registration_confirmation_configuration_18, t0_.use_default_payment_confirmation_configuration AS use_default_payment_confirmation_configuration_19, t0_.use_default_payment_reminder_configuration AS use_default_payment_reminder_configuration_20, t0_.use_default_payment_cancellation_configuration AS use_default_payment_cancellation_configuration_21, t0_.special_conditions AS special_conditions_22, t0_.payment_reminder_delay_in_days AS payment_reminder_delay_in_days_23, t0_.cancellation_time AS cancellation_time_24, t0_.cancellation_in_days AS cancellation_in_days_25 FROM ticket_template t0_ WHERE t0_.default_template = ?
Parameters:
[
1
]
|
| 9 | 0.97 ms |
SELECT r0_.id AS id_0, r0_.order_number AS order_number_1, r0_.type AS type_2, r0_.visible AS visible_3, r0_.required AS required_4, r0_.vat_eu AS vat_eu_5, r0_.show_on_offer_section AS show_on_offer_section_6, r1_.id AS id_7, r1_.name AS name_8, r1_.description AS description_9, r1_.locale AS locale_10, r1_.translatable_id AS translatable_id_11 FROM registration_form_payment_field r0_ LEFT JOIN registration_form_payment_field_translation r1_ ON r0_.id = r1_.translatable_id WHERE r0_.visible = ? ORDER BY r0_.order_number ASC
Parameters:
[
1
]
|
| 10 | 0.92 ms |
SELECT r0_.id AS id_0, r0_.type AS type_1, r0_.order_number AS order_number_2, r0_.mask AS mask_3, r0_.params AS params_4, r0_.width AS width_5, r0_.value AS value_6, r0_.visible AS visible_7, r0_.required AS required_8, r0_.force_uppercase AS force_uppercase_9, r0_.lock_when_filled AS lock_when_filled_10, r1_.id AS id_11, r1_.name AS name_12, r1_.description AS description_13, r1_.value_names AS value_names_14, r1_.clause_url_enable AS clause_url_enable_15, r1_.clause_content AS clause_content_16, r1_.clause_url_text AS clause_url_text_17, r1_.locale AS locale_18, r1_.clause_file_id AS clause_file_id_19, r1_.translatable_id AS translatable_id_20 FROM registration_form_field r0_ LEFT JOIN registration_form_field_translation r1_ ON r0_.id = r1_.translatable_id ORDER BY r0_.order_number ASC
Parameters:
[] |
| 11 | 0.61 ms |
SELECT t0.id AS id_1, t0.registration_number AS registration_number_2, t0.add_date AS add_date_3, t0.modification_date AS modification_date_4, t0.status AS status_5, t0.language AS language_6, t0.invicode AS invicode_7, t0.hash AS hash_8, t0.data_update_token AS data_update_token_9, t0.data_update_last_used_at AS data_update_last_used_at_10, t0.data_update_last_used_ip AS data_update_last_used_ip_11, t0.offer_update_token AS offer_update_token_12, t0.nip_eu AS nip_eu_13, t0.non_transactional_messages_allowed_date AS non_transactional_messages_allowed_date_14, t0.non_transactional_messages_allowed AS non_transactional_messages_allowed_15, t0.ticket_id AS ticket_id_16, t0.currency_id AS currency_id_17, t0.payment_method_id AS payment_method_id_18, t0.discount_code_id AS discount_code_id_19, t0.group_master_registration_id AS group_master_registration_id_20 FROM registration t0 WHERE t0.group_master_registration_id = ?
Parameters:
[
43
]
|
| 12 | 0.80 ms |
SELECT r0_.id AS id_0, r0_.order_number AS order_number_1, r0_.type AS type_2, r0_.registration_limit AS registration_limit_3, r0_.visible AS visible_4, r0_.required AS required_5, r0_.width AS width_6, r1_.id AS id_7, r1_.name AS name_8, r1_.description AS description_9, r1_.locale AS locale_10, r1_.translatable_id AS translatable_id_11 FROM registration_form_agenda r0_ LEFT JOIN registration_form_agenda_translation r1_ ON r0_.id = r1_.translatable_id ORDER BY r0_.order_number ASC
Parameters:
[] |
| 13 | 0.84 ms |
SELECT t0_.id AS id_0, t0_.visible AS visible_1, t0_.add_date AS add_date_2, t0_.agenda_first AS agenda_first_3, t0_.block_same_emails AS block_same_emails_4, t0_.blocking_rules AS blocking_rules_5, t0_.regform_configuration AS regform_configuration_6, t0_.agenda_free_places_type AS agenda_free_places_type_7, t0_.agenda_description_type AS agenda_description_type_8, t0_.automatic_payment_confirmation_send AS automatic_payment_confirmation_send_9, t0_.payment_reminder_enable AS payment_reminder_enable_10, t0_.enable_summary_step AS enable_summary_step_11, t0_.cancellation_enable AS cancellation_enable_12, t0_.default_template AS default_template_13, t0_.use_default_regform_configuration AS use_default_regform_configuration_14, t0_.use_default_agenda_configuration AS use_default_agenda_configuration_15, t0_.use_default_summary_configuration AS use_default_summary_configuration_16, t0_.use_default_confirmation_configuration AS use_default_confirmation_configuration_17, t0_.use_default_registration_confirmation_configuration AS use_default_registration_confirmation_configuration_18, t0_.use_default_payment_confirmation_configuration AS use_default_payment_confirmation_configuration_19, t0_.use_default_payment_reminder_configuration AS use_default_payment_reminder_configuration_20, t0_.use_default_payment_cancellation_configuration AS use_default_payment_cancellation_configuration_21, t0_.special_conditions AS special_conditions_22, t0_.payment_reminder_delay_in_days AS payment_reminder_delay_in_days_23, t0_.cancellation_time AS cancellation_time_24, t0_.cancellation_in_days AS cancellation_in_days_25 FROM ticket_template t0_ WHERE t0_.special_conditions LIKE ? LIMIT 1
Parameters:
[
"%registration_acceptance%"
]
|
| 14 | 0.59 ms |
SELECT t0_.id AS id_0, t0_.order_number AS order_number_1, t0_.registration_limit AS registration_limit_2, t0_.hidden AS hidden_3, t0_.password AS password_4, t0_.show_for_languages AS show_for_languages_5, t0_.hash AS hash_6, t1_.id AS id_7, t1_.name AS name_8, t1_.description AS description_9, t1_.locale AS locale_10, t0_.template_id AS template_id_11, t1_.translatable_id AS translatable_id_12 FROM ticket t0_ LEFT JOIN ticket_translation t1_ ON t0_.id = t1_.translatable_id ORDER BY t0_.order_number ASC
Parameters:
[] |
| 15 | 0.75 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.config AS config_3, t0.is_visible AS is_visible_4, t0.order_number AS order_number_5 FROM payment_method t0 WHERE t0.is_visible = ? ORDER BY t0.order_number ASC
Parameters:
[
1
]
|
| 16 | 0.59 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM payment_method_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
| 17 | 0.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM payment_method_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
2
]
|
| 18 | 0.49 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM payment_method_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
3
]
|
| 19 | 0.52 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM payment_method_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
4
]
|
| 20 | 0.57 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.registration_id AS registration_id_3, t0.registration_form_field_id AS registration_form_field_id_4, t0.file_id AS file_id_5 FROM registration_field t0 WHERE t0.registration_id = ?
Parameters:
[
43
]
|
| 21 | 0.48 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.registration_id AS registration_id_3, t0.registration_payment_field_id AS registration_payment_field_id_4 FROM registration_payment_field t0 WHERE t0.registration_id = ?
Parameters:
[
43
]
|
| 22 | 0.53 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.enabled AS enabled_4 FROM currency t0 WHERE t0.enabled = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
| 23 | 0.52 ms |
SELECT t0.id AS id_1, t0.price AS price_2, t0.no_rebate_price AS no_rebate_price_3, t0.registration_id AS registration_id_4, t0.transaction_id AS transaction_id_5, t0.registration_agenda_field_id AS registration_agenda_field_id_6 FROM registration_agenda t0 WHERE t0.registration_id = ?
Parameters:
[
43
]
|
| 24 | 0.43 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:
[
"payment_settings"
]
|
| 25 | 0.39 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:
[
9
]
|
| 26 | 0.39 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.config AS config_3, t0.is_visible AS is_visible_4, t0.order_number AS order_number_5 FROM payment_method t0
Parameters:
[] |
| 27 | 0.36 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:
[] |
| 28 | 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.has_regform = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 1 "pl" ] |
| 29 | 0.35 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:
[
"FakturowniaSettings"
]
|
| 30 | 0.36 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:
[
"GUSSettings"
]
|
| 31 | 0.52 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:
[
"media_platform"
]
|
| 32 | 0.47 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:
[
0
]
|
| 33 | 0.38 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.order_number AS order_number_3, t0.mask AS mask_4, t0.params AS params_5, t0.width AS width_6, t0.value AS value_7, t0.visible AS visible_8, t0.required AS required_9, t0.force_uppercase AS force_uppercase_10, t0.lock_when_filled AS lock_when_filled_11 FROM registration_form_field t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"name"
]
|
| 34 | 0.41 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.order_number AS order_number_3, t0.mask AS mask_4, t0.params AS params_5, t0.width AS width_6, t0.value AS value_7, t0.visible AS visible_8, t0.required AS required_9, t0.force_uppercase AS force_uppercase_10, t0.lock_when_filled AS lock_when_filled_11 FROM registration_form_field t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"surname"
]
|
| 35 | 0.45 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.enter_date AS enter_date_3, t0.exit_date AS exit_date_4, t0.option_id AS option_id_5, t0.forced_entry AS forced_entry_6, t0.registration_id AS registration_id_7 FROM guest_service_event t0 WHERE t0.registration_id = ?
Parameters:
[
43
]
|
| 36 | 0.50 ms |
SELECT t0.id AS id_1, t0.changes AS changes_2, t0.is_text AS is_text_3, t0.ip AS ip_4, t0.username AS username_5, t0.add_date AS add_date_6, t0.registration_id AS registration_id_7 FROM registration_change t0 WHERE t0.registration_id = ? ORDER BY t0.add_date DESC
Parameters:
[
43
]
|
| 37 | 0.49 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:
[
"system"
]
|
| 38 | 0.52 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:
[
"system"
]
|
| 39 | 0.45 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:
[
"system"
]
|
| 40 | 0.51 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:
[] |
| 41 | 0.44 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:
[
"system"
]
|
| 42 | 0.43 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:
[
"system"
]
|
| 43 | 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:
[] |
| 44 | 0.85 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:
[
"system"
]
|
| 45 | 0.55 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:
[
"system"
]
|
| 46 | 0.50 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:
[
"system"
]
|
| 47 | 0.73 ms |
SELECT t0.id AS id_1, t0.add_date AS add_date_2, t0.adder AS adder_3, t0.comment AS comment_4, t0.registration_id AS registration_id_5 FROM registration_comment t0 WHERE t0.registration_id = ?
Parameters:
[
43
]
|
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\RegistrationFormPaymentField | 9 |
| App\Core\Doctrine\Entity\RegistrationForm\RegistrationFormPaymentFieldTranslation | 9 |
| App\Core\Doctrine\Entity\RegistrationForm\RegistrationFormAgenda | 9 |
| App\Core\Doctrine\Entity\RegistrationForm\RegistrationFormAgendaTranslation | 9 |
| App\Core\Doctrine\Entity\RegistrationForm\RegistrationFormField | 5 |
| App\Core\Doctrine\Entity\RegistrationForm\RegistrationFormFieldTranslation | 5 |
| App\Core\Doctrine\Entity\Setting\Setting | 4 |
| App\Core\Doctrine\Entity\Ticket\Ticket | 4 |
| App\Core\Doctrine\Entity\Ticket\TicketTranslation | 4 |
| App\Core\Doctrine\Entity\Payment\PaymentMethod | 4 |
| App\Core\Doctrine\Entity\Payment\PaymentMethodTranslation | 4 |
| App\Core\Doctrine\Entity\TicketTemplate\TicketTemplate | 3 |
| App\Core\Doctrine\Entity\Registration\RegistrationField | 3 |
| App\Core\Doctrine\Entity\Registration\RegistrationChange | 3 |
| App\Core\Doctrine\Entity\Registration\Registration | 2 |
| App\Core\Doctrine\Entity\Setting\SettingTranslation | 2 |
| App\Core\Doctrine\Entity\User\User | 1 |
| App\Core\Doctrine\Entity\Payment\Currency | 1 |
| App\Core\Doctrine\Entity\Registration\RegistrationAgenda | 1 |
| App\Core\Doctrine\Entity\Payment\Transaction\Transaction | 1 |
| App\Core\Doctrine\Entity\Page\Page | 1 |