Query Metrics
19
Database Queries
7
Different statements
14.45 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.93 ms |
SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12, t0.currency AS currency_13, t0.test_mode_terminal AS test_mode_terminal_14, t0.fit_module_url AS fit_module_url_15, t0.sales_module_url AS sales_module_url_16, t0.file_storage_module_url AS file_storage_module_url_17, t0.kiosk_module_url AS kiosk_module_url_18, t0.printer_template_module_url AS printer_template_module_url_19, t0.parking_module_url AS parking_module_url_20 FROM config t0
Parameters:
[] |
| 2 | 0.67 ms |
SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12, t0.currency AS currency_13, t0.test_mode_terminal AS test_mode_terminal_14, t0.fit_module_url AS fit_module_url_15, t0.sales_module_url AS sales_module_url_16, t0.file_storage_module_url AS file_storage_module_url_17, t0.kiosk_module_url AS kiosk_module_url_18, t0.printer_template_module_url AS printer_template_module_url_19, t0.parking_module_url AS parking_module_url_20 FROM config t0
Parameters:
[] |
| 3 | 0.49 ms |
SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12, t0.currency AS currency_13, t0.test_mode_terminal AS test_mode_terminal_14, t0.fit_module_url AS fit_module_url_15, t0.sales_module_url AS sales_module_url_16, t0.file_storage_module_url AS file_storage_module_url_17, t0.kiosk_module_url AS kiosk_module_url_18, t0.printer_template_module_url AS printer_template_module_url_19, t0.parking_module_url AS parking_module_url_20 FROM config t0
Parameters:
[] |
| 4 | 0.47 ms |
SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12, t0.currency AS currency_13, t0.test_mode_terminal AS test_mode_terminal_14, t0.fit_module_url AS fit_module_url_15, t0.sales_module_url AS sales_module_url_16, t0.file_storage_module_url AS file_storage_module_url_17, t0.kiosk_module_url AS kiosk_module_url_18, t0.printer_template_module_url AS printer_template_module_url_19, t0.parking_module_url AS parking_module_url_20 FROM config t0
Parameters:
[] |
| 5 | 1.40 ms |
SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12, t0.currency AS currency_13, t0.test_mode_terminal AS test_mode_terminal_14, t0.fit_module_url AS fit_module_url_15, t0.sales_module_url AS sales_module_url_16, t0.file_storage_module_url AS file_storage_module_url_17, t0.kiosk_module_url AS kiosk_module_url_18, t0.printer_template_module_url AS printer_template_module_url_19, t0.parking_module_url AS parking_module_url_20 FROM config t0
Parameters:
[] |
| 6 | 0.57 ms |
SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12, t0.currency AS currency_13, t0.test_mode_terminal AS test_mode_terminal_14, t0.fit_module_url AS fit_module_url_15, t0.sales_module_url AS sales_module_url_16, t0.file_storage_module_url AS file_storage_module_url_17, t0.kiosk_module_url AS kiosk_module_url_18, t0.printer_template_module_url AS printer_template_module_url_19, t0.parking_module_url AS parking_module_url_20 FROM config t0
Parameters:
[] |
| 7 | 0.67 ms |
SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12, t0.currency AS currency_13, t0.test_mode_terminal AS test_mode_terminal_14, t0.fit_module_url AS fit_module_url_15, t0.sales_module_url AS sales_module_url_16, t0.file_storage_module_url AS file_storage_module_url_17, t0.kiosk_module_url AS kiosk_module_url_18, t0.printer_template_module_url AS printer_template_module_url_19, t0.parking_module_url AS parking_module_url_20 FROM config t0
Parameters:
[] |
| 8 | 1.09 ms |
SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12, t0.currency AS currency_13, t0.test_mode_terminal AS test_mode_terminal_14, t0.fit_module_url AS fit_module_url_15, t0.sales_module_url AS sales_module_url_16, t0.file_storage_module_url AS file_storage_module_url_17, t0.kiosk_module_url AS kiosk_module_url_18, t0.printer_template_module_url AS printer_template_module_url_19, t0.parking_module_url AS parking_module_url_20 FROM config t0
Parameters:
[] |
fit_admin_module connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.85 ms |
SELECT t0.id AS id_1, t0.credit_recharge_amounts AS credit_recharge_amounts_2, t0.is_writable_credit_recharge_amount AS is_writable_credit_recharge_amount_3, t0.writable_credit_recharge_min AS writable_credit_recharge_min_4, t0.writable_credit_recharge_max AS writable_credit_recharge_max_5, t0.allow_credit AS allow_credit_6, t0.allowed_payment_methods AS allowed_payment_methods_7, t0.allowed_payment_methods_for_kiosk AS allowed_payment_methods_for_kiosk_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM credit_config t0
Parameters:
[] |
| 2 | 0.69 ms |
SELECT t0.id AS id_1, t0.color_theme AS color_theme_2, t0.page_layout_uuid AS page_layout_uuid_3, t0.is_service_mode AS is_service_mode_4, t0.service_mode_allow_special_access AS service_mode_allow_special_access_5, t0.change_logo_hash AS change_logo_hash_6, t0.use_reservations AS use_reservations_7, t0.use_lessons AS use_lessons_8, t0.use_permanents AS use_permanents_9, t0.use_landing_page AS use_landing_page_10, t0.use_vending_machines AS use_vending_machines_11, t0.use_two_factor_auth AS use_two_factor_auth_12, t0.use_exercisers_count AS use_exercisers_count_13, t0.flags_design AS flags_design_14, t0.allow_portal_registration AS allow_portal_registration_15, t0.mobile_app_color_theme AS mobile_app_color_theme_16, t0.use_swiper_in_permanents AS use_swiper_in_permanents_17 FROM layout_config t0 LIMIT 1
Parameters:
[] |
| 3 | 0.49 ms |
SELECT t0.id AS id_1, t0.use_zlavomat AS use_zlavomat_2, t0.api_token AS api_token_3, t0.check_url AS check_url_4, t0.apply_url AS apply_url_5, t0.allow_anonym AS allow_anonym_6, t0.save_order_in_sales AS save_order_in_sales_7 FROM zlavomat_config t0
Parameters:
[] |
| 4 | 0.72 ms |
SELECT k0_.id AS id_0, k0_.uuid AS uuid_1, k0_.name AS name_2, k0_.logout_time AS logout_time_3, k0_.kiosk_module_uuid AS kiosk_module_uuid_4, k0_.sales_module_device_uuid AS sales_module_device_uuid_5, k0_.ip AS ip_6, k0_.dashboard_layout_uuid AS dashboard_layout_uuid_7, k0_.self_activation_required AS self_activation_required_8, k0_.show_entry_products AS show_entry_products_9, k0_.entry_products_on_landing_page AS entry_products_on_landing_page_10, k0_.reload_times AS reload_times_11 FROM kiosk_config k0_ WHERE k0_.ip = ? LIMIT 1
Parameters:
[
"10.10.8.9"
]
|
| 5 | 0.55 ms |
SELECT t0.id AS id_1, t0.color_theme AS color_theme_2, t0.page_layout_uuid AS page_layout_uuid_3, t0.is_service_mode AS is_service_mode_4, t0.service_mode_allow_special_access AS service_mode_allow_special_access_5, t0.change_logo_hash AS change_logo_hash_6, t0.use_reservations AS use_reservations_7, t0.use_lessons AS use_lessons_8, t0.use_permanents AS use_permanents_9, t0.use_landing_page AS use_landing_page_10, t0.use_vending_machines AS use_vending_machines_11, t0.use_two_factor_auth AS use_two_factor_auth_12, t0.use_exercisers_count AS use_exercisers_count_13, t0.flags_design AS flags_design_14, t0.allow_portal_registration AS allow_portal_registration_15, t0.mobile_app_color_theme AS mobile_app_color_theme_16, t0.use_swiper_in_permanents AS use_swiper_in_permanents_17 FROM layout_config t0 LIMIT 1
Parameters:
[] |
| 6 | 0.62 ms |
SELECT k0_.id AS id_0, k0_.uuid AS uuid_1, k0_.name AS name_2, k0_.logout_time AS logout_time_3, k0_.kiosk_module_uuid AS kiosk_module_uuid_4, k0_.sales_module_device_uuid AS sales_module_device_uuid_5, k0_.ip AS ip_6, k0_.dashboard_layout_uuid AS dashboard_layout_uuid_7, k0_.self_activation_required AS self_activation_required_8, k0_.show_entry_products AS show_entry_products_9, k0_.entry_products_on_landing_page AS entry_products_on_landing_page_10, k0_.reload_times AS reload_times_11 FROM kiosk_config k0_ WHERE k0_.ip = ? LIMIT 1
Parameters:
[
"10.10.8.9"
]
|
| 7 | 0.50 ms |
SELECT t0.id AS id_1, t0.color_theme AS color_theme_2, t0.page_layout_uuid AS page_layout_uuid_3, t0.is_service_mode AS is_service_mode_4, t0.service_mode_allow_special_access AS service_mode_allow_special_access_5, t0.change_logo_hash AS change_logo_hash_6, t0.use_reservations AS use_reservations_7, t0.use_lessons AS use_lessons_8, t0.use_permanents AS use_permanents_9, t0.use_landing_page AS use_landing_page_10, t0.use_vending_machines AS use_vending_machines_11, t0.use_two_factor_auth AS use_two_factor_auth_12, t0.use_exercisers_count AS use_exercisers_count_13, t0.flags_design AS flags_design_14, t0.allow_portal_registration AS allow_portal_registration_15, t0.mobile_app_color_theme AS mobile_app_color_theme_16, t0.use_swiper_in_permanents AS use_swiper_in_permanents_17 FROM layout_config t0 LIMIT 1
Parameters:
[] |
| 8 | 1.86 ms |
SELECT t0.id AS id_1, t0.document_key AS document_key_2, t0.value AS value_3, t0.updated_by AS updated_by_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM legal_document t0 WHERE t0.document_key = ? LIMIT 1
Parameters:
[
"vop"
]
|
translation_cache connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.73 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1764992889 "tss-translation-key:locale" ] |
| 2 | 0.55 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1764992889 "tss-translation-key:tss_translation\x01tags\x01" ] |
| 3 | 0.61 ms |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1764992889 "tss-translation-key:locale" ] |
Database Connections
| Name | Service |
|---|---|
| fit_admin_module | doctrine.dbal.fit_admin_module_connection |
| translation_cache | doctrine.dbal.translation_cache_connection |
| user_module | doctrine.dbal.user_module_connection |
| UmLogs | doctrine.dbal.UmLogs_connection |
| user_module_visitors | doctrine.dbal.user_module_visitors_connection |
| lock_acs_lite_module | doctrine.dbal.lock_acs_lite_module_connection |
| sales_module | doctrine.dbal.sales_module_connection |
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| fit_admin_module | doctrine.orm.fit_admin_module_entity_manager |
| user_module_visitors | doctrine.orm.user_module_visitors_entity_manager |
| user_module | doctrine.orm.user_module_entity_manager |
| UmLogs | doctrine.orm.UmLogs_entity_manager |
| lock_acs_lite_module | doctrine.orm.lock_acs_lite_module_entity_manager |
| sales_module | doctrine.orm.sales_module_entity_manager |
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
fit_admin_module entity manager
| Class | Mapping errors |
|---|---|
| Tss\FitModuleDatabaseBundle\Entity\CreditConfig\CreditConfig | No errors. |
| Tss\FitModuleDatabaseBundle\Entity\LayoutConfig\LayoutConfig | No errors. |
| Tss\FitModuleDatabaseBundle\Entity\ZlavomatConfig\ZlavomatConfig | No errors. |
| Tss\FitModuleDatabaseBundle\Entity\Kiosk\Kiosk | No errors. |
| Tss\FitModuleDatabaseBundle\Entity\LegalDocument\LegalDocument | No errors. |
user_module_visitors entity manager
No loaded entities.
user_module entity manager
No loaded entities.
UmLogs entity manager
No loaded entities.
lock_acs_lite_module entity manager
No loaded entities.
sales_module entity manager
No loaded entities.
default entity manager
| Class | Mapping errors |
|---|---|
| Tss\IdentityServerBundle\Entity\BaseConfig | No errors. |
| App\Entity\Config | No errors. |