https://www.2.uniqskills.com/sitemap.xml

Query Metrics

3 Database Queries
2 Different statements
3.52 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.69 ms
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.hash AS hash_3, t0.title AS title_4, t0.is_active AS is_active_5, t0.action_number AS action_number_6, t0.from_source AS from_source_7, t0.portal_css AS portal_css_8, t0.portal_head_scripts AS portal_head_scripts_9, t0.portal_start_body_scripts AS portal_start_body_scripts_10, t0.portal_body_scripts AS portal_body_scripts_11, t0.robots_txt AS robots_txt_12, t0.cart_additional_info AS cart_additional_info_13, t0.portal_number_sb AS portal_number_sb_14, t0.leading_color1 AS leading_color1_15, t0.leading_color2 AS leading_color2_16, t0.leading_color3 AS leading_color3_17, t0.logo AS logo_18, t0.contact_mail AS contact_mail_19, t0.registration_additional_content AS registration_additional_content_20, t0.login_additional_content AS login_additional_content_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.is_uniqskills_portal AS is_uniqskills_portal_24, t0.is_netflix_portal AS is_netflix_portal_25, t0.is_presale AS is_presale_26, t0.is_simple_price AS is_simple_price_27, t0.redirect_after_login AS redirect_after_login_28, t0.message_after_login AS message_after_login_29, t0.message_time_after_login AS message_time_after_login_30, t0.device_auth_needed AS device_auth_needed_31, t0.sender AS sender_32, t0.is_cms_portal AS is_cms_portal_33, t0.multi_access_from_max_user AS multi_access_from_max_user_34, t0.enable_new_basket AS enable_new_basket_35, t0.price_after_free_postage_cost AS price_after_free_postage_cost_36, t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37, t0.gtm AS gtm_38, t0.password_additional_content AS password_additional_content_39, t0.leading_color4 AS leading_color4_40, t0.userbar_color AS userbar_color_41, t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42, t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43, t0.userbar_html AS userbar_html_44, t0.display_userbar2 AS display_userbar2_45, t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46, t0.test_userbar_html AS test_userbar_html_47, t0.lifetime_access AS lifetime_access_48, t0.fb_pixel_id AS fb_pixel_id_49, t0.fb_pixel_access_token AS fb_pixel_access_token_50, t0.hide_field_position AS hide_field_position_51, t0.redirecting_to_focus AS redirecting_to_focus_52, t0.show_gross_price AS show_gross_price_53, t0.cs_mail AS cs_mail_54, t0.is_phone_required AS is_phone_required_55, t0.webe_mid_number AS webe_mid_number_56, t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57, t0.is_payment_before_confirmation AS is_payment_before_confirmation_58, t0.payment_reward AS payment_reward_59, t0.payment_reward_content AS payment_reward_content_60, t0.payment_reward_deadline AS payment_reward_deadline_61, t0.cart_template AS cart_template_62, t0.use_cache_in_access AS use_cache_in_access_63, t0.order_confirmation_additional_content AS order_confirmation_additional_content_64, t0.additional_content_for_mail AS additional_content_for_mail_65, t0.matomo_site_id AS matomo_site_id_66, t0.positions_order AS positions_order_67, t0.email_settings_id AS email_settings_id_68, t0.order_type_id AS order_type_id_69, t70.id AS id_71, t70.ord_tran_prefix AS ord_tran_prefix_72, t70.is_default AS is_default_73, t70.use_sb AS use_sb_74, t70.use_recaptcha_in_order AS use_recaptcha_in_order_75, t70.hide_catalog AS hide_catalog_76, t70.hide_nip_in_orders AS hide_nip_in_orders_77, t70.show_only_regulations AS show_only_regulations_78, t70.send_order_welcome_mail_only AS send_order_welcome_mail_only_79, t70.facebook_event_type AS facebook_event_type_80, t70.footer_copyright AS footer_copyright_81, t70.contact_form_recipient AS contact_form_recipient_82, t70.text_contact_thank_you AS text_contact_thank_you_83, t70.text_footer_cooperator_headers AS text_footer_cooperator_headers_84, t70.text_acceptance_regulations AS text_acceptance_regulations_85, t70.text_voucher_regulations AS text_voucher_regulations_86, t70.text_consent_processing_personal_data AS text_consent_processing_personal_data_87, t70.created_at AS created_at_88, t70.updated_at AS updated_at_89, t70.portal_settings_id AS portal_settings_id_90, t0.virtual_currency_id AS virtual_currency_id_91, t0.default_payment_system_id AS default_payment_system_id_92, t0.default_cart_client_type_id AS default_cart_client_type_id_93, t94.id AS id_95, t94.is_active AS is_active_96, t94.poll_link AS poll_link_97, t94.editorial_email AS editorial_email_98, t94.portal_settings_id AS portal_settings_id_99, t94.email_template_id AS email_template_id_100 FROM portal_settings t0 LEFT JOIN fm_company_settings t70 ON t70.portal_settings_id = t0.id LEFT JOIN onboarding_settings t94 ON t94.portal_settings_id = t0.id WHERE t0.hash = ? LIMIT 1
Parameters:
[
  "42231b0ff8a4775b3089cbe1746f32"
]
2 0.47 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.native AS native_4, t0.slug AS slug_5, t0.code AS code_6, t0.short AS short_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM language t0 INNER JOIN fm_company_settings_language ON t0.id = fm_company_settings_language.language_id WHERE fm_company_settings_language.fm_company_settings_id = ?
Parameters:
[
  1
]
3 1.36 ms
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.hash AS hash_3, t0.title AS title_4, t0.is_active AS is_active_5, t0.action_number AS action_number_6, t0.from_source AS from_source_7, t0.portal_css AS portal_css_8, t0.portal_head_scripts AS portal_head_scripts_9, t0.portal_start_body_scripts AS portal_start_body_scripts_10, t0.portal_body_scripts AS portal_body_scripts_11, t0.robots_txt AS robots_txt_12, t0.cart_additional_info AS cart_additional_info_13, t0.portal_number_sb AS portal_number_sb_14, t0.leading_color1 AS leading_color1_15, t0.leading_color2 AS leading_color2_16, t0.leading_color3 AS leading_color3_17, t0.logo AS logo_18, t0.contact_mail AS contact_mail_19, t0.registration_additional_content AS registration_additional_content_20, t0.login_additional_content AS login_additional_content_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.is_uniqskills_portal AS is_uniqskills_portal_24, t0.is_netflix_portal AS is_netflix_portal_25, t0.is_presale AS is_presale_26, t0.is_simple_price AS is_simple_price_27, t0.redirect_after_login AS redirect_after_login_28, t0.message_after_login AS message_after_login_29, t0.message_time_after_login AS message_time_after_login_30, t0.device_auth_needed AS device_auth_needed_31, t0.sender AS sender_32, t0.is_cms_portal AS is_cms_portal_33, t0.multi_access_from_max_user AS multi_access_from_max_user_34, t0.enable_new_basket AS enable_new_basket_35, t0.price_after_free_postage_cost AS price_after_free_postage_cost_36, t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37, t0.gtm AS gtm_38, t0.password_additional_content AS password_additional_content_39, t0.leading_color4 AS leading_color4_40, t0.userbar_color AS userbar_color_41, t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42, t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43, t0.userbar_html AS userbar_html_44, t0.display_userbar2 AS display_userbar2_45, t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46, t0.test_userbar_html AS test_userbar_html_47, t0.lifetime_access AS lifetime_access_48, t0.fb_pixel_id AS fb_pixel_id_49, t0.fb_pixel_access_token AS fb_pixel_access_token_50, t0.hide_field_position AS hide_field_position_51, t0.redirecting_to_focus AS redirecting_to_focus_52, t0.show_gross_price AS show_gross_price_53, t0.cs_mail AS cs_mail_54, t0.is_phone_required AS is_phone_required_55, t0.webe_mid_number AS webe_mid_number_56, t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57, t0.is_payment_before_confirmation AS is_payment_before_confirmation_58, t0.payment_reward AS payment_reward_59, t0.payment_reward_content AS payment_reward_content_60, t0.payment_reward_deadline AS payment_reward_deadline_61, t0.cart_template AS cart_template_62, t0.use_cache_in_access AS use_cache_in_access_63, t0.order_confirmation_additional_content AS order_confirmation_additional_content_64, t0.additional_content_for_mail AS additional_content_for_mail_65, t0.matomo_site_id AS matomo_site_id_66, t0.positions_order AS positions_order_67, t0.email_settings_id AS email_settings_id_68, t0.order_type_id AS order_type_id_69, t70.id AS id_71, t70.ord_tran_prefix AS ord_tran_prefix_72, t70.is_default AS is_default_73, t70.use_sb AS use_sb_74, t70.use_recaptcha_in_order AS use_recaptcha_in_order_75, t70.hide_catalog AS hide_catalog_76, t70.hide_nip_in_orders AS hide_nip_in_orders_77, t70.show_only_regulations AS show_only_regulations_78, t70.send_order_welcome_mail_only AS send_order_welcome_mail_only_79, t70.facebook_event_type AS facebook_event_type_80, t70.footer_copyright AS footer_copyright_81, t70.contact_form_recipient AS contact_form_recipient_82, t70.text_contact_thank_you AS text_contact_thank_you_83, t70.text_footer_cooperator_headers AS text_footer_cooperator_headers_84, t70.text_acceptance_regulations AS text_acceptance_regulations_85, t70.text_voucher_regulations AS text_voucher_regulations_86, t70.text_consent_processing_personal_data AS text_consent_processing_personal_data_87, t70.created_at AS created_at_88, t70.updated_at AS updated_at_89, t70.portal_settings_id AS portal_settings_id_90, t0.virtual_currency_id AS virtual_currency_id_91, t0.default_payment_system_id AS default_payment_system_id_92, t0.default_cart_client_type_id AS default_cart_client_type_id_93, t94.id AS id_95, t94.is_active AS is_active_96, t94.poll_link AS poll_link_97, t94.editorial_email AS editorial_email_98, t94.portal_settings_id AS portal_settings_id_99, t94.email_template_id AS email_template_id_100 FROM portal_settings t0 LEFT JOIN fm_company_settings t70 ON t70.portal_settings_id = t0.id LEFT JOIN onboarding_settings t94 ON t94.portal_settings_id = t0.id WHERE t0.hash = ? LIMIT 1
Parameters:
[
  "42231b0ff8a4775b3089cbe1746f32"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
sb doctrine.dbal.sb_connection
unbounce doctrine.dbal.unbounce_connection
mantis doctrine.dbal.mantis_connection
llsystem doctrine.dbal.llsystem_connection
czasopisma doctrine.dbal.czasopisma_connection
bc doctrine.dbal.bc_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
sb doctrine.orm.sb_entity_manager
czasopisma doctrine.orm.czasopisma_entity_manager
bc doctrine.orm.bc_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Gos\Country No errors.
App\Entity\Gos\Currency No errors.
App\Entity\Gos\Language No errors.
App\Entity\Gos\Cart No errors.
App\Entity\Gos\ClientType No errors.
App\Entity\Gos\ProductType No errors.
App\Entity\Gos\PortalSettings No errors.
App\Entity\Gos\EmailSettings No errors.
App\Entity\Gos\OrderType No errors.
App\Entity\Gos\Uniqskills\FmCompanySettings No errors.
App\Entity\Gos\VirtualCurrency\VirtualCurrency No errors.
App\Entity\Gos\PaymentSystem No errors.
App\Entity\Gos\OnboardingSettings No errors.
App\Entity\Gos\EmailTemplate No errors.
App\Entity\Gos\Orders No errors.
App\Entity\Gos\ProductVariant No errors.
App\Entity\Gos\AccessLevel No errors.
App\Entity\Gos\Term No errors.
App\Entity\Gos\PasswordFromImport No errors.
App\Entity\Gos\OrdersDataTemp No errors.
App\Entity\Gos\StaticPage No errors.
App\Entity\Gos\Tmpl\Template No errors.
App\Entity\Gos\ProductAssociation No errors.
App\Entity\Gos\TouchPoint No errors.
App\Entity\Gos\TouchPointAll No errors.
App\Entity\Gos\Category No errors.
App\Entity\Gos\Uniqskills\Course No errors.
FOS\UserBundle\Model\User No errors.
App\Entity\Gos\User No errors.
App\Entity\Gos\Uniqskills\PromoBox No errors.
App\Entity\Gos\Uniqskills\Slider No errors.
App\Entity\Gos\SalesManagoEvent No errors.
App\Entity\Gos\ProductVariantPack No errors.
App\Entity\Gos\UserPosition No errors.
App\Entity\Gos\Newsletter No errors.
App\Entity\Gos\UserFirstLoginInfo No errors.
App\Entity\Gos\Honorifics No errors.
App\Entity\Gos\ContactSegmentation No errors.
App\Entity\Gos\Uniqskills\Voucher No errors.
App\Entity\Gos\NotificationForUser No errors.

sb entity manager

No loaded entities.

czasopisma entity manager

No loaded entities.

bc entity manager

No loaded entities.