https://www.2.uniqskills.com/pl/kursy/ksiegowosc-finanse/5

Method
GET
HTTP Status
200
IP
54.38.147.72
Profiled on
Token
9b4795

Query Metrics

457 Database Queries
36 Different statements
661.93 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
128.74 ms
(19.45%) 		9 
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.label AS label_2, p0_.is_active AS is_active_3, p0_.show_price AS show_price_4, p0_.buy_max_one AS buy_max_one_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.gross_show AS gross_show_8, p0_.is_publicly_available AS is_publicly_available_9, p0_.publicly_available_date_from AS publicly_available_date_from_10, p0_.publicly_available_date_to AS publicly_available_date_to_11, p0_.custom_promo1 AS custom_promo1_12, p0_.custom_promo2 AS custom_promo2_13, p0_.type_id AS type_id_14 FROM product_pack p0_ LEFT JOIN product_pack_item p1_ ON p0_.id = p1_.product_pack_id LEFT JOIN product_variant p2_ ON p1_.product_variant_id = p2_.id LEFT JOIN product_variant_course p4_ ON p2_.id = p4_.product_variant_id LEFT JOIN course c3_ ON c3_.id = p4_.course_id WHERE c3_.id IS NOT NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query
125.94 ms
(19.03%) 		82 
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_premium AS is_premium_3, t0.name AS name_4, t0.short_body AS short_body_5, t0.slug AS slug_6, t0.default_price AS default_price_7, t0.duration_hours AS duration_hours_8, t0.duration_months AS duration_months_9, t0.inscriptions AS inscriptions_10, t0.product_for_cos AS product_for_cos_11, t0.filepath AS filepath_12, t0.is_continuous AS is_continuous_13, t0.share_date AS share_date_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.landing_page AS landing_page_17, t0.action_number AS action_number_18, t0.from_source AS from_source_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.hide_after AS hide_after_22, t0.start_date AS start_date_23, t0.all_lessons_access AS all_lessons_access_24, t0.is_no_index AS is_no_index_25, t0.is_orbico_agreement AS is_orbico_agreement_26, t0.is_partner_agreement AS is_partner_agreement_27, t0.is_online_conference AS is_online_conference_28, t0.image_name AS image_name_29, t0.ad_image_name AS ad_image_name_30, t0.ad_redirect_to_url AS ad_redirect_to_url_31, t0.ad_start_date AS ad_start_date_32, t0.ad_end_date AS ad_end_date_33, t0.module_background_image_name AS module_background_image_name_34, t0.redirect_to_url AS redirect_to_url_35, t0.catalog_position AS catalog_position_36, t0.duration_weeks AS duration_weeks_37, t0.duration_per_week AS duration_per_week_38, t0.has_medical_content AS has_medical_content_39, t0.next_course_id AS next_course_id_40, t0.main_keyword_id AS main_keyword_id_41, t42.id AS id_43, t42.is_active AS is_active_44, t42.custom_scripts AS custom_scripts_45, t42.template AS template_46, t42.created_at AS created_at_47, t42.updated_at AS updated_at_48, t42.course_id AS course_id_49, t0.course_type_id AS course_type_id_50, t0.category_id AS category_id_51, t0.cooperator_id AS cooperator_id_52, t0.portal_settings_id AS portal_settings_id_53, t54.id AS id_55, t54.name AS name_56, t54.page_orientation_landscape AS page_orientation_landscape_57, t54.pdf_name AS pdf_name_58, t54.created_at AS created_at_59, t54.updated_at AS updated_at_60, t54.course_id AS course_id_61, t62.id AS id_63, t62.is_active AS is_active_64, t62.is_premium AS is_premium_65, t62.name AS name_66, t62.short_body AS short_body_67, t62.slug AS slug_68, t62.default_price AS default_price_69, t62.duration_hours AS duration_hours_70, t62.duration_months AS duration_months_71, t62.inscriptions AS inscriptions_72, t62.product_for_cos AS product_for_cos_73, t62.filepath AS filepath_74, t62.is_continuous AS is_continuous_75, t62.share_date AS share_date_76, t62.meta_title AS meta_title_77, t62.meta_description AS meta_description_78, t62.landing_page AS landing_page_79, t62.action_number AS action_number_80, t62.from_source AS from_source_81, t62.created_at AS created_at_82, t62.updated_at AS updated_at_83, t62.hide_after AS hide_after_84, t62.start_date AS start_date_85, t62.all_lessons_access AS all_lessons_access_86, t62.is_no_index AS is_no_index_87, t62.is_orbico_agreement AS is_orbico_agreement_88, t62.is_partner_agreement AS is_partner_agreement_89, t62.is_online_conference AS is_online_conference_90, t62.image_name AS image_name_91, t62.ad_image_name AS ad_image_name_92, t62.ad_redirect_to_url AS ad_redirect_to_url_93, t62.ad_start_date AS ad_start_date_94, t62.ad_end_date AS ad_end_date_95, t62.module_background_image_name AS module_background_image_name_96, t62.redirect_to_url AS redirect_to_url_97, t62.catalog_position AS catalog_position_98, t62.duration_weeks AS duration_weeks_99, t62.duration_per_week AS duration_per_week_100, t62.has_medical_content AS has_medical_content_101, t62.next_course_id AS next_course_id_102, t62.main_keyword_id AS main_keyword_id_103, t62.course_type_id AS course_type_id_104, t62.category_id AS category_id_105, t62.cooperator_id AS cooperator_id_106, t62.portal_settings_id AS portal_settings_id_107, t62.original_course_id AS original_course_id_108, t0.original_course_id AS original_course_id_109 FROM course t0 LEFT JOIN landing t42 ON t42.course_id = t0.id LEFT JOIN voucher t54 ON t54.course_id = t0.id LEFT JOIN course t62 ON t62.original_course_id = t0.id WHERE t0.category_id = ?
Parameters: 
[
  95
]
View formatted query    View runnable query    Explain query
101.39 ms
(15.32%) 		82 
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_premium AS is_premium_3, t0.name AS name_4, t0.short_body AS short_body_5, t0.slug AS slug_6, t0.default_price AS default_price_7, t0.duration_hours AS duration_hours_8, t0.duration_months AS duration_months_9, t0.inscriptions AS inscriptions_10, t0.product_for_cos AS product_for_cos_11, t0.filepath AS filepath_12, t0.is_continuous AS is_continuous_13, t0.share_date AS share_date_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.landing_page AS landing_page_17, t0.action_number AS action_number_18, t0.from_source AS from_source_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.hide_after AS hide_after_22, t0.start_date AS start_date_23, t0.all_lessons_access AS all_lessons_access_24, t0.is_no_index AS is_no_index_25, t0.is_orbico_agreement AS is_orbico_agreement_26, t0.is_partner_agreement AS is_partner_agreement_27, t0.is_online_conference AS is_online_conference_28, t0.image_name AS image_name_29, t0.ad_image_name AS ad_image_name_30, t0.ad_redirect_to_url AS ad_redirect_to_url_31, t0.ad_start_date AS ad_start_date_32, t0.ad_end_date AS ad_end_date_33, t0.module_background_image_name AS module_background_image_name_34, t0.redirect_to_url AS redirect_to_url_35, t0.catalog_position AS catalog_position_36, t0.duration_weeks AS duration_weeks_37, t0.duration_per_week AS duration_per_week_38, t0.has_medical_content AS has_medical_content_39, t0.next_course_id AS next_course_id_40, t0.main_keyword_id AS main_keyword_id_41, t42.id AS id_43, t42.is_active AS is_active_44, t42.custom_scripts AS custom_scripts_45, t42.template AS template_46, t42.created_at AS created_at_47, t42.updated_at AS updated_at_48, t42.course_id AS course_id_49, t0.course_type_id AS course_type_id_50, t0.category_id AS category_id_51, t0.cooperator_id AS cooperator_id_52, t0.portal_settings_id AS portal_settings_id_53, t54.id AS id_55, t54.name AS name_56, t54.page_orientation_landscape AS page_orientation_landscape_57, t54.pdf_name AS pdf_name_58, t54.created_at AS created_at_59, t54.updated_at AS updated_at_60, t54.course_id AS course_id_61, t62.id AS id_63, t62.is_active AS is_active_64, t62.is_premium AS is_premium_65, t62.name AS name_66, t62.short_body AS short_body_67, t62.slug AS slug_68, t62.default_price AS default_price_69, t62.duration_hours AS duration_hours_70, t62.duration_months AS duration_months_71, t62.inscriptions AS inscriptions_72, t62.product_for_cos AS product_for_cos_73, t62.filepath AS filepath_74, t62.is_continuous AS is_continuous_75, t62.share_date AS share_date_76, t62.meta_title AS meta_title_77, t62.meta_description AS meta_description_78, t62.landing_page AS landing_page_79, t62.action_number AS action_number_80, t62.from_source AS from_source_81, t62.created_at AS created_at_82, t62.updated_at AS updated_at_83, t62.hide_after AS hide_after_84, t62.start_date AS start_date_85, t62.all_lessons_access AS all_lessons_access_86, t62.is_no_index AS is_no_index_87, t62.is_orbico_agreement AS is_orbico_agreement_88, t62.is_partner_agreement AS is_partner_agreement_89, t62.is_online_conference AS is_online_conference_90, t62.image_name AS image_name_91, t62.ad_image_name AS ad_image_name_92, t62.ad_redirect_to_url AS ad_redirect_to_url_93, t62.ad_start_date AS ad_start_date_94, t62.ad_end_date AS ad_end_date_95, t62.module_background_image_name AS module_background_image_name_96, t62.redirect_to_url AS redirect_to_url_97, t62.catalog_position AS catalog_position_98, t62.duration_weeks AS duration_weeks_99, t62.duration_per_week AS duration_per_week_100, t62.has_medical_content AS has_medical_content_101, t62.next_course_id AS next_course_id_102, t62.main_keyword_id AS main_keyword_id_103, t62.course_type_id AS course_type_id_104, t62.category_id AS category_id_105, t62.cooperator_id AS cooperator_id_106, t62.portal_settings_id AS portal_settings_id_107, t62.original_course_id AS original_course_id_108, t0.original_course_id AS original_course_id_109 FROM course t0 LEFT JOIN landing t42 ON t42.course_id = t0.id LEFT JOIN voucher t54 ON t54.course_id = t0.id LEFT JOIN course t62 ON t62.original_course_id = t0.id INNER JOIN courses_additional_categories ON t0.id = courses_additional_categories.course_id WHERE courses_additional_categories.category_id = ?
Parameters: 
[
  95
]
View formatted query    View runnable query    Explain query
47.27 ms
(7.14%) 		42 
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.variable_name AS variable_name_3, t0.variable_value AS variable_value_4, t0.landing_module_id AS landing_module_id_5, t0.variable_type FROM landing_module_item t0 WHERE t0.landing_module_id = ? AND t0.variable_type IN ('text', 'file', 'json', 'boolean')
Parameters: 
[
  17364
]
View formatted query    View runnable query    Explain query
44.18 ms
(6.67%) 		41 
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_premium AS is_premium_3, t0.name AS name_4, t0.short_body AS short_body_5, t0.slug AS slug_6, t0.default_price AS default_price_7, t0.duration_hours AS duration_hours_8, t0.duration_months AS duration_months_9, t0.inscriptions AS inscriptions_10, t0.product_for_cos AS product_for_cos_11, t0.filepath AS filepath_12, t0.is_continuous AS is_continuous_13, t0.share_date AS share_date_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.landing_page AS landing_page_17, t0.action_number AS action_number_18, t0.from_source AS from_source_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.hide_after AS hide_after_22, t0.start_date AS start_date_23, t0.all_lessons_access AS all_lessons_access_24, t0.is_no_index AS is_no_index_25, t0.is_orbico_agreement AS is_orbico_agreement_26, t0.is_partner_agreement AS is_partner_agreement_27, t0.is_online_conference AS is_online_conference_28, t0.image_name AS image_name_29, t0.ad_image_name AS ad_image_name_30, t0.ad_redirect_to_url AS ad_redirect_to_url_31, t0.ad_start_date AS ad_start_date_32, t0.ad_end_date AS ad_end_date_33, t0.module_background_image_name AS module_background_image_name_34, t0.redirect_to_url AS redirect_to_url_35, t0.catalog_position AS catalog_position_36, t0.duration_weeks AS duration_weeks_37, t0.duration_per_week AS duration_per_week_38, t0.has_medical_content AS has_medical_content_39, t0.next_course_id AS next_course_id_40, t0.main_keyword_id AS main_keyword_id_41, t42.id AS id_43, t42.is_active AS is_active_44, t42.custom_scripts AS custom_scripts_45, t42.template AS template_46, t42.created_at AS created_at_47, t42.updated_at AS updated_at_48, t42.course_id AS course_id_49, t0.course_type_id AS course_type_id_50, t0.category_id AS category_id_51, t0.cooperator_id AS cooperator_id_52, t0.portal_settings_id AS portal_settings_id_53, t54.id AS id_55, t54.name AS name_56, t54.page_orientation_landscape AS page_orientation_landscape_57, t54.pdf_name AS pdf_name_58, t54.created_at AS created_at_59, t54.updated_at AS updated_at_60, t54.course_id AS course_id_61, t62.id AS id_63, t62.is_active AS is_active_64, t62.is_premium AS is_premium_65, t62.name AS name_66, t62.short_body AS short_body_67, t62.slug AS slug_68, t62.default_price AS default_price_69, t62.duration_hours AS duration_hours_70, t62.duration_months AS duration_months_71, t62.inscriptions AS inscriptions_72, t62.product_for_cos AS product_for_cos_73, t62.filepath AS filepath_74, t62.is_continuous AS is_continuous_75, t62.share_date AS share_date_76, t62.meta_title AS meta_title_77, t62.meta_description AS meta_description_78, t62.landing_page AS landing_page_79, t62.action_number AS action_number_80, t62.from_source AS from_source_81, t62.created_at AS created_at_82, t62.updated_at AS updated_at_83, t62.hide_after AS hide_after_84, t62.start_date AS start_date_85, t62.all_lessons_access AS all_lessons_access_86, t62.is_no_index AS is_no_index_87, t62.is_orbico_agreement AS is_orbico_agreement_88, t62.is_partner_agreement AS is_partner_agreement_89, t62.is_online_conference AS is_online_conference_90, t62.image_name AS image_name_91, t62.ad_image_name AS ad_image_name_92, t62.ad_redirect_to_url AS ad_redirect_to_url_93, t62.ad_start_date AS ad_start_date_94, t62.ad_end_date AS ad_end_date_95, t62.module_background_image_name AS module_background_image_name_96, t62.redirect_to_url AS redirect_to_url_97, t62.catalog_position AS catalog_position_98, t62.duration_weeks AS duration_weeks_99, t62.duration_per_week AS duration_per_week_100, t62.has_medical_content AS has_medical_content_101, t62.next_course_id AS next_course_id_102, t62.main_keyword_id AS main_keyword_id_103, t62.course_type_id AS course_type_id_104, t62.category_id AS category_id_105, t62.cooperator_id AS cooperator_id_106, t62.portal_settings_id AS portal_settings_id_107, t62.original_course_id AS original_course_id_108, t0.original_course_id AS original_course_id_109 FROM course t0 LEFT JOIN landing t42 ON t42.course_id = t0.id LEFT JOIN voucher t54 ON t54.course_id = t0.id LEFT JOIN course t62 ON t62.original_course_id = t0.id WHERE t0.original_course_id = ?
Parameters: 
[
  783
]
View formatted query    View runnable query    Explain query
20.20 ms
(3.05%) 		41 
SELECT t0.id AS id_1, t0.name AS name_2, t0.page_orientation_landscape AS page_orientation_landscape_3, t0.pdf_name AS pdf_name_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.course_id AS course_id_7 FROM voucher t0 WHERE t0.course_id = ?
Parameters: 
[
  783
]
View formatted query    View runnable query    Explain query
17.98 ms
(2.72%) 		41 
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.custom_scripts AS custom_scripts_3, t0.template AS template_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.course_id AS course_id_7 FROM landing t0 WHERE t0.course_id = ?
Parameters: 
[
  783
]
View formatted query    View runnable query    Explain query
17.80 ms
(2.69%) 		14 
SELECT t0.id AS id_1, t0.name AS name_2, t0.specific_landing_templates AS specific_landing_templates_3 FROM landing_module_type t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
13.51 ms
(2.04%) 		9 
SELECT p0_.id AS id_0, p0_.isVirtual AS isVirtual_1, p0_.is_test AS is_test_2, p0_.product_variant_no AS product_variant_no_3, p0_.product_number_no_tax AS product_number_no_tax_4, p0_.product_number_part_tax AS product_number_part_tax_5, p0_.product_variant_id AS product_variant_id_6, p0_.product_variant_no_complete AS product_variant_no_complete_7, p0_.product_variant_key AS product_variant_key_8, p0_.variant_state AS variant_state_9, p0_.tittle_on_invoice AS tittle_on_invoice_10, p0_.working_title AS working_title_11, p0_.price_net AS price_net_12, p0_.price_gross AS price_gross_13, p0_.trade_name AS trade_name_14, p0_.alt_trade_name AS alt_trade_name_15, p0_.technical_informations AS technical_informations_16, p0_.technical_information_for_mail AS technical_information_for_mail_17, p0_.label AS label_18, p0_.is_gross AS is_gross_19, p0_.currency_code AS currency_code_20, p0_.postage_type AS postage_type_21, p0_.postage_cost AS postage_cost_22, p0_.total_weight AS total_weight_23, p0_.series_type AS series_type_24, p0_.is_default AS is_default_25, p0_.tax_free_for_budget_unit AS tax_free_for_budget_unit_26, p0_.product_number_for_budget_unit AS product_number_for_budget_unit_27, p0_.show_gross_price AS show_gross_price_28, p0_.discount_online AS discount_online_29, p0_.discount_value_online AS discount_value_online_30, p0_.state_is_availible AS state_is_availible_31, p0_.state_is_forced_reservation AS state_is_forced_reservation_32, p0_.state_is_product_test AS state_is_product_test_33, p0_.state_is_trial_recurring AS state_is_trial_recurring_34, p0_.trial_recurring_duration AS trial_recurring_duration_35, p0_.is_access_without_payment AS is_access_without_payment_36, p0_.buy_max_one AS buy_max_one_37, p0_.is_addition AS is_addition_38, p0_.max_users AS max_users_39, p0_.quantity AS quantity_40, p0_.order_quantity AS order_quantity_41, p0_.event_date AS event_date_42, p0_.created_at AS created_at_43, p0_.updated_at AS updated_at_44, p0_.subscription_type AS subscription_type_45, p0_.subscription_plan AS subscription_plan_46, p0_.image AS image_47, p0_.default_product_association AS default_product_association_48, p0_.promoted AS promoted_49, p0_.is_published AS is_published_50, p0_.is_giftable AS is_giftable_51, p0_.is_hidden AS is_hidden_52, p0_.is_partial_payment_active AS is_partial_payment_active_53, p0_.installment_amount AS installment_amount_54, p0_.extended_payment_time AS extended_payment_time_55, p0_.summary_upselling_info AS summary_upselling_info_56, p0_.trial_duration AS trial_duration_57, p0_.required_pwz AS required_pwz_58, p0_.promo_name AS promo_name_59, p0_.is_digital AS is_digital_60, p0_.block_access AS block_access_61, p0_.mantis_user_id AS mantis_user_id_62, p0_.sales_variant_based_trial_duration AS sales_variant_based_trial_duration_63, p0_.sales_variant_based_trial_info AS sales_variant_based_trial_info_64, p0_.access_for_paid_only AS access_for_paid_only_65, p0_.additional_text_in_cart AS additional_text_in_cart_66, p0_.is_recurring_subscription AS is_recurring_subscription_67, p0_.document_distribution_channel AS document_distribution_channel_68, p0_.hidden_in_sbtill_paid AS hidden_in_sbtill_paid_69, p0_.participants_address AS participants_address_70, p0_.participants_announcement AS participants_announcement_71, p0_.must_have_all_exclusive_variants AS must_have_all_exclusive_variants_72, p0_.trade_name_sm AS trade_name_sm_73, p0_.comment_for_mantis AS comment_for_mantis_74, p0_.coupon_lifetime AS coupon_lifetime_75, p0_.fresh_mail_integration AS fresh_mail_integration_76, p0_.fresh_mail_recipient_list_hash AS fresh_mail_recipient_list_hash_77, p0_.order_on_site_content AS order_on_site_content_78, p0_.manual_user_verification AS manual_user_verification_79, p0_.image_url_upselling AS image_url_upselling_80, p0_.use_uploaded_image_upselling AS use_uploaded_image_upselling_81, p0_.uploaded_image_upselling AS uploaded_image_upselling_82, p0_.description_upselling AS description_upselling_83, p0_.link_to_product_upselling AS link_to_product_upselling_84, p0_.show_button_additional_address AS show_button_additional_address_85, p0_.max_quantity_in_cart AS max_quantity_in_cart_86, p0_.exclude_default_shipping_type AS exclude_default_shipping_type_87, p0_.is_completely_digital AS is_completely_digital_88, p0_.has_paper_release AS has_paper_release_89, p0_.is_npwzrequired AS is_npwzrequired_90, p0_.is_sale_disabled AS is_sale_disabled_91, p0_.technical_information_for_mail_tele AS technical_information_for_mail_tele_92, p0_.additional_information_for_mail AS additional_information_for_mail_93, p0_.description_upselling_max_height AS description_upselling_max_height_94, p0_.bur_funding_product_variant_id AS bur_funding_product_variant_id_95, p0_.product_variant_after_trial_recurring_end_id AS product_variant_after_trial_recurring_end_id_96, p0_.master_product_id AS master_product_id_97, p0_.trade_product_id AS trade_product_id_98, p0_.country_id AS country_id_99, p0_.payment_type_id AS payment_type_id_100, p0_.product_subscription_type_id AS product_subscription_type_id_101, p0_.product_variant_eu_vat_id AS product_variant_eu_vat_id_102, p0_.feed_id AS feed_id_103, p0_.events_id AS events_id_104, p0_.size_id AS size_id_105, p0_.original_id AS original_id_106, p0_.additional_access_product_variant_id AS additional_access_product_variant_id_107 FROM product_variant p0_ LEFT JOIN product_variant_course p2_ ON p0_.id = p2_.product_variant_id LEFT JOIN course c1_ ON c1_.id = p2_.course_id LEFT JOIN country c3_ ON p0_.country_id = c3_.id WHERE c1_.slug = ? AND c3_.alpha2 = ?
Parameters: 
[
  "jak-zweryfikowac-kontrahenta-by-nie-narazic-sie-na-straty-finansowe-i-nie-wziac-udzialu-w-nieswiadomym-oszustwie"
  "GB"
]
View formatted query    View runnable query    Explain query
12.95 ms
(1.96%) 		1 
SELECT c0_.id AS id_0, c0_.is_active AS is_active_1, c0_.is_premium AS is_premium_2, c0_.name AS name_3, c0_.short_body AS short_body_4, c0_.slug AS slug_5, c0_.default_price AS default_price_6, c0_.duration_hours AS duration_hours_7, c0_.duration_months AS duration_months_8, c0_.inscriptions AS inscriptions_9, c0_.product_for_cos AS product_for_cos_10, c0_.filepath AS filepath_11, c0_.is_continuous AS is_continuous_12, c0_.share_date AS share_date_13, c0_.meta_title AS meta_title_14, c0_.meta_description AS meta_description_15, c0_.landing_page AS landing_page_16, c0_.action_number AS action_number_17, c0_.from_source AS from_source_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.hide_after AS hide_after_21, c0_.start_date AS start_date_22, c0_.all_lessons_access AS all_lessons_access_23, c0_.is_no_index AS is_no_index_24, c0_.is_orbico_agreement AS is_orbico_agreement_25, c0_.is_partner_agreement AS is_partner_agreement_26, c0_.is_online_conference AS is_online_conference_27, c0_.image_name AS image_name_28, c0_.ad_image_name AS ad_image_name_29, c0_.ad_redirect_to_url AS ad_redirect_to_url_30, c0_.ad_start_date AS ad_start_date_31, c0_.ad_end_date AS ad_end_date_32, c0_.module_background_image_name AS module_background_image_name_33, c0_.redirect_to_url AS redirect_to_url_34, c0_.catalog_position AS catalog_position_35, c0_.duration_weeks AS duration_weeks_36, c0_.duration_per_week AS duration_per_week_37, c0_.has_medical_content AS has_medical_content_38, -c0_.catalog_position AS sclr_39, c0_.next_course_id AS next_course_id_40, c0_.main_keyword_id AS main_keyword_id_41, c0_.course_type_id AS course_type_id_42, c0_.category_id AS category_id_43, c0_.cooperator_id AS cooperator_id_44, c0_.portal_settings_id AS portal_settings_id_45, c0_.original_course_id AS original_course_id_46 FROM course c0_ LEFT JOIN category c1_ ON c0_.category_id = c1_.id LEFT JOIN language l2_ ON c1_.language_id = l2_.id LEFT JOIN course_type c3_ ON c0_.course_type_id = c3_.id LEFT JOIN category c4_ ON c1_.parent_id = c4_.id LEFT JOIN courses_additional_categories c6_ ON c0_.id = c6_.course_id LEFT JOIN category c5_ ON c5_.id = c6_.category_id LEFT JOIN category c7_ ON c5_.parent_id = c7_.id WHERE c0_.original_course_id IS NULL AND c0_.portal_settings_id = ? AND (c1_.category_slug = (?) OR c4_.category_slug = (?) OR c5_.category_slug = (?) OR c7_.category_slug = (?)) AND l2_.code = (?) AND ((c0_.is_active = (?) OR (c0_.is_active = 0 AND c0_.id IN (NULL)))) AND ((CURRENT_DATE < c0_.hide_after OR c0_.hide_after IS NULL)) ORDER BY sclr_39 DESC, c0_.id DESC
Parameters: 
[
  113
  "ksiegowosc-finanse"
  "ksiegowosc-finanse"
  "ksiegowosc-finanse"
  "ksiegowosc-finanse"
  "pl"
  1
]
View formatted query    View runnable query    Explain query
12.90 ms
(1.95%) 		14 
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.alpha2 AS alpha2_5, t0.alpha3 AS alpha3_6, t0.ioc AS ioc_7, t0.emoji AS emoji_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.currency_id AS currency_id_11, t0.language_id AS language_id_12, t0.continent_id AS continent_id_13, t14.id AS id_15, t14.isActive AS isActive_16, t14.euMember AS euMember_17, t14.signBeforePrice AS signBeforePrice_18, t14.signAfterPrice AS signAfterPrice_19, t14.price_currency AS price_currency_20, t14.vat_rate_b2b AS vat_rate_b2b_21, t14.vat_rate_b2c AS vat_rate_b2c_22, t14.payment_method_online_description AS payment_method_online_description_23, t14.payment_method_offline_description AS payment_method_offline_description_24, t14.link_to_payment_instructions AS link_to_payment_instructions_25, t14.braintree_merchant AS braintree_merchant_26, t14.created_at AS created_at_27, t14.updated_at AS updated_at_28, t14.online_payment_label AS online_payment_label_29, t14.logo_filename AS logo_filename_30, t14.country_id AS country_id_31 FROM country t0 LEFT JOIN country_settings t14 ON t14.country_id = t0.id WHERE t0.alpha2 = ? LIMIT 1
Parameters: 
[
  "GB"
]
View formatted query    View runnable query    Explain query
12.19 ms
(1.84%) 		12 
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.short_body AS short_body_3, t0.body AS body_4, t0.testimonials_custom AS testimonials_custom_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.position AS position_8, t0.image_name AS image_name_9, t0.banner_name AS banner_name_10, t0.banner_link AS banner_link_11, t0.banner_html AS banner_html_12, t0.updated_at AS updated_at_13, t0.default_for_us AS default_for_us_14, t0.parent_id AS parent_id_15, t16.id AS id_17, t16.is_active AS is_active_18, t16.name AS name_19, t16.portal_settings_id AS portal_settings_id_20, t16.category_id AS category_id_21, t16.product_association_id AS product_association_id_22, t16.product_main_type_id AS product_main_type_id_23, t16.template_type_id AS template_type_id_24, t0.portal_settings_id AS portal_settings_id_25, t0.recommended_product_association_id AS recommended_product_association_id_26, t0.language_id AS language_id_27, t28.id AS id_29, t28.is_active AS is_active_30, t28.name AS name_31, t28.native AS native_32, t28.slug AS slug_33, t28.code AS code_34, t28.short AS short_35, t28.created_at AS created_at_36, t28.updated_at AS updated_at_37, t38.id AS id_39, t38.title AS title_40, t38.description AS description_41, t38.head_scripts AS head_scripts_42, t38.body_scripts AS body_scripts_43, t38.created_at AS created_at_44, t38.updated_at AS updated_at_45, t38.product_association_id AS product_association_id_46, t38.category_id AS category_id_47, t38.template_type_id AS template_type_id_48 FROM category t0 LEFT JOIN templates t16 ON t16.category_id = t0.id LEFT JOIN language t28 ON t0.language_id = t28.id LEFT JOIN meta_tags t38 ON t38.category_id = t0.id WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters: 
[
  95
]
View formatted query    View runnable query    Explain query
11.91 ms
(1.80%) 		12 
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.short_body AS short_body_3, t0.body AS body_4, t0.testimonials_custom AS testimonials_custom_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.position AS position_8, t0.image_name AS image_name_9, t0.banner_name AS banner_name_10, t0.banner_link AS banner_link_11, t0.banner_html AS banner_html_12, t0.updated_at AS updated_at_13, t0.default_for_us AS default_for_us_14, t0.parent_id AS parent_id_15, t16.id AS id_17, t16.is_active AS is_active_18, t16.name AS name_19, t16.portal_settings_id AS portal_settings_id_20, t16.category_id AS category_id_21, t16.product_association_id AS product_association_id_22, t16.product_main_type_id AS product_main_type_id_23, t16.template_type_id AS template_type_id_24, t0.portal_settings_id AS portal_settings_id_25, t0.recommended_product_association_id AS recommended_product_association_id_26, t0.language_id AS language_id_27, t28.id AS id_29, t28.is_active AS is_active_30, t28.name AS name_31, t28.native AS native_32, t28.slug AS slug_33, t28.code AS code_34, t28.short AS short_35, t28.created_at AS created_at_36, t28.updated_at AS updated_at_37, t38.id AS id_39, t38.title AS title_40, t38.description AS description_41, t38.head_scripts AS head_scripts_42, t38.body_scripts AS body_scripts_43, t38.created_at AS created_at_44, t38.updated_at AS updated_at_45, t38.product_association_id AS product_association_id_46, t38.category_id AS category_id_47, t38.template_type_id AS template_type_id_48 FROM category t0 LEFT JOIN templates t16 ON t16.category_id = t0.id LEFT JOIN language t28 ON t0.language_id = t28.id LEFT JOIN meta_tags t38 ON t38.category_id = t0.id WHERE t0.id = ?
Parameters: 
[
  95
]
View formatted query    View runnable query    Explain query
11.27 ms
(1.70%) 		7 
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"
]
View formatted query    View runnable query    Explain query
11.24 ms
(1.70%) 		3 
SELECT t0.id AS id_1, t0.isVirtual AS isVirtual_2, t0.is_test AS is_test_3, t0.product_variant_no AS product_variant_no_4, t0.product_number_no_tax AS product_number_no_tax_5, t0.product_number_part_tax AS product_number_part_tax_6, t0.product_variant_id AS product_variant_id_7, t0.product_variant_no_complete AS product_variant_no_complete_8, t0.product_variant_key AS product_variant_key_9, t0.variant_state AS variant_state_10, t0.tittle_on_invoice AS tittle_on_invoice_11, t0.working_title AS working_title_12, t0.price_net AS price_net_13, t0.price_gross AS price_gross_14, t0.trade_name AS trade_name_15, t0.alt_trade_name AS alt_trade_name_16, t0.technical_informations AS technical_informations_17, t0.technical_information_for_mail AS technical_information_for_mail_18, t0.label AS label_19, t0.is_gross AS is_gross_20, t0.currency_code AS currency_code_21, t0.postage_type AS postage_type_22, t0.postage_cost AS postage_cost_23, t0.total_weight AS total_weight_24, t0.series_type AS series_type_25, t0.is_default AS is_default_26, t0.tax_free_for_budget_unit AS tax_free_for_budget_unit_27, t0.product_number_for_budget_unit AS product_number_for_budget_unit_28, t0.show_gross_price AS show_gross_price_29, t0.discount_online AS discount_online_30, t0.discount_value_online AS discount_value_online_31, t0.state_is_availible AS state_is_availible_32, t0.state_is_forced_reservation AS state_is_forced_reservation_33, t0.state_is_product_test AS state_is_product_test_34, t0.state_is_trial_recurring AS state_is_trial_recurring_35, t0.trial_recurring_duration AS trial_recurring_duration_36, t0.is_access_without_payment AS is_access_without_payment_37, t0.buy_max_one AS buy_max_one_38, t0.is_addition AS is_addition_39, t0.max_users AS max_users_40, t0.quantity AS quantity_41, t0.order_quantity AS order_quantity_42, t0.event_date AS event_date_43, t0.created_at AS created_at_44, t0.updated_at AS updated_at_45, t0.subscription_type AS subscription_type_46, t0.subscription_plan AS subscription_plan_47, t0.image AS image_48, t0.default_product_association AS default_product_association_49, t0.promoted AS promoted_50, t0.is_published AS is_published_51, t0.is_giftable AS is_giftable_52, t0.is_hidden AS is_hidden_53, t0.is_partial_payment_active AS is_partial_payment_active_54, t0.installment_amount AS installment_amount_55, t0.extended_payment_time AS extended_payment_time_56, t0.summary_upselling_info AS summary_upselling_info_57, t0.trial_duration AS trial_duration_58, t0.required_pwz AS required_pwz_59, t0.promo_name AS promo_name_60, t0.is_digital AS is_digital_61, t0.block_access AS block_access_62, t0.mantis_user_id AS mantis_user_id_63, t0.sales_variant_based_trial_duration AS sales_variant_based_trial_duration_64, t0.sales_variant_based_trial_info AS sales_variant_based_trial_info_65, t0.access_for_paid_only AS access_for_paid_only_66, t0.additional_text_in_cart AS additional_text_in_cart_67, t0.is_recurring_subscription AS is_recurring_subscription_68, t0.document_distribution_channel AS document_distribution_channel_69, t0.hidden_in_sbtill_paid AS hidden_in_sbtill_paid_70, t0.participants_address AS participants_address_71, t0.participants_announcement AS participants_announcement_72, t0.must_have_all_exclusive_variants AS must_have_all_exclusive_variants_73, t0.trade_name_sm AS trade_name_sm_74, t0.comment_for_mantis AS comment_for_mantis_75, t0.coupon_lifetime AS coupon_lifetime_76, t0.fresh_mail_integration AS fresh_mail_integration_77, t0.fresh_mail_recipient_list_hash AS fresh_mail_recipient_list_hash_78, t0.order_on_site_content AS order_on_site_content_79, t0.manual_user_verification AS manual_user_verification_80, t0.image_url_upselling AS image_url_upselling_81, t0.use_uploaded_image_upselling AS use_uploaded_image_upselling_82, t0.uploaded_image_upselling AS uploaded_image_upselling_83, t0.description_upselling AS description_upselling_84, t0.link_to_product_upselling AS link_to_product_upselling_85, t0.show_button_additional_address AS show_button_additional_address_86, t0.max_quantity_in_cart AS max_quantity_in_cart_87, t0.exclude_default_shipping_type AS exclude_default_shipping_type_88, t0.is_completely_digital AS is_completely_digital_89, t0.has_paper_release AS has_paper_release_90, t0.is_npwzrequired AS is_npwzrequired_91, t0.is_sale_disabled AS is_sale_disabled_92, t0.technical_information_for_mail_tele AS technical_information_for_mail_tele_93, t0.additional_information_for_mail AS additional_information_for_mail_94, t0.description_upselling_max_height AS description_upselling_max_height_95, t0.bur_funding_product_variant_id AS bur_funding_product_variant_id_96, t0.product_variant_after_trial_recurring_end_id AS product_variant_after_trial_recurring_end_id_97, t0.master_product_id AS master_product_id_98, t0.trade_product_id AS trade_product_id_99, t0.country_id AS country_id_100, t0.payment_type_id AS payment_type_id_101, t0.product_subscription_type_id AS product_subscription_type_id_102, t0.product_variant_eu_vat_id AS product_variant_eu_vat_id_103, t104.id AS id_105, t104.isVirtual AS isVirtual_106, t104.is_test AS is_test_107, t104.product_variant_no AS product_variant_no_108, t104.product_number_no_tax AS product_number_no_tax_109, t104.product_number_part_tax AS product_number_part_tax_110, t104.product_variant_id AS product_variant_id_111, t104.product_variant_no_complete AS product_variant_no_complete_112, t104.product_variant_key AS product_variant_key_113, t104.variant_state AS variant_state_114, t104.tittle_on_invoice AS tittle_on_invoice_115, t104.working_title AS working_title_116, t104.price_net AS price_net_117, t104.price_gross AS price_gross_118, t104.trade_name AS trade_name_119, t104.alt_trade_name AS alt_trade_name_120, t104.technical_informations AS technical_informations_121, t104.technical_information_for_mail AS technical_information_for_mail_122, t104.label AS label_123, t104.is_gross AS is_gross_124, t104.currency_code AS currency_code_125, t104.postage_type AS postage_type_126, t104.postage_cost AS postage_cost_127, t104.total_weight AS total_weight_128, t104.series_type AS series_type_129, t104.is_default AS is_default_130, t104.tax_free_for_budget_unit AS tax_free_for_budget_unit_131, t104.product_number_for_budget_unit AS product_number_for_budget_unit_132, t104.show_gross_price AS show_gross_price_133, t104.discount_online AS discount_online_134, t104.discount_value_online AS discount_value_online_135, t104.state_is_availible AS state_is_availible_136, t104.state_is_forced_reservation AS state_is_forced_reservation_137, t104.state_is_product_test AS state_is_product_test_138, t104.state_is_trial_recurring AS state_is_trial_recurring_139, t104.trial_recurring_duration AS trial_recurring_duration_140, t104.is_access_without_payment AS is_access_without_payment_141, t104.buy_max_one AS buy_max_one_142, t104.is_addition AS is_addition_143, t104.max_users AS max_users_144, t104.quantity AS quantity_145, t104.order_quantity AS order_quantity_146, t104.event_date AS event_date_147, t104.created_at AS created_at_148, t104.updated_at AS updated_at_149, t104.subscription_type AS subscription_type_150, t104.subscription_plan AS subscription_plan_151, t104.image AS image_152, t104.default_product_association AS default_product_association_153, t104.promoted AS promoted_154, t104.is_published AS is_published_155, t104.is_giftable AS is_giftable_156, t104.is_hidden AS is_hidden_157, t104.is_partial_payment_active AS is_partial_payment_active_158, t104.installment_amount AS installment_amount_159, t104.extended_payment_time AS extended_payment_time_160, t104.summary_upselling_info AS summary_upselling_info_161, t104.trial_duration AS trial_duration_162, t104.required_pwz AS required_pwz_163, t104.promo_name AS promo_name_164, t104.is_digital AS is_digital_165, t104.block_access AS block_access_166, t104.mantis_user_id AS mantis_user_id_167, t104.sales_variant_based_trial_duration AS sales_variant_based_trial_duration_168, t104.sales_variant_based_trial_info AS sales_variant_based_trial_info_169, t104.access_for_paid_only AS access_for_paid_only_170, t104.additional_text_in_cart AS additional_text_in_cart_171, t104.is_recurring_subscription AS is_recurring_subscription_172, t104.document_distribution_channel AS document_distribution_channel_173, t104.hidden_in_sbtill_paid AS hidden_in_sbtill_paid_174, t104.participants_address AS participants_address_175, t104.participants_announcement AS participants_announcement_176, t104.must_have_all_exclusive_variants AS must_have_all_exclusive_variants_177, t104.trade_name_sm AS trade_name_sm_178, t104.comment_for_mantis AS comment_for_mantis_179, t104.coupon_lifetime AS coupon_lifetime_180, t104.fresh_mail_integration AS fresh_mail_integration_181, t104.fresh_mail_recipient_list_hash AS fresh_mail_recipient_list_hash_182, t104.order_on_site_content AS order_on_site_content_183, t104.manual_user_verification AS manual_user_verification_184, t104.image_url_upselling AS image_url_upselling_185, t104.use_uploaded_image_upselling AS use_uploaded_image_upselling_186, t104.uploaded_image_upselling AS uploaded_image_upselling_187, t104.description_upselling AS description_upselling_188, t104.link_to_product_upselling AS link_to_product_upselling_189, t104.show_button_additional_address AS show_button_additional_address_190, t104.max_quantity_in_cart AS max_quantity_in_cart_191, t104.exclude_default_shipping_type AS exclude_default_shipping_type_192, t104.is_completely_digital AS is_completely_digital_193, t104.has_paper_release AS has_paper_release_194, t104.is_npwzrequired AS is_npwzrequired_195, t104.is_sale_disabled AS is_sale_disabled_196, t104.technical_information_for_mail_tele AS technical_information_for_mail_tele_197, t104.additional_information_for_mail AS additional_information_for_mail_198, t104.description_upselling_max_height AS description_upselling_max_height_199, t104.bur_funding_product_variant_id AS bur_funding_product_variant_id_200, t104.product_variant_after_trial_recurring_end_id AS product_variant_after_trial_recurring_end_id_201, t104.master_product_id AS master_product_id_202, t104.trade_product_id AS trade_product_id_203, t104.country_id AS country_id_204, t104.payment_type_id AS payment_type_id_205, t104.product_subscription_type_id AS product_subscription_type_id_206, t104.product_variant_eu_vat_id AS product_variant_eu_vat_id_207, t104.feed_id AS feed_id_208, t104.events_id AS events_id_209, t104.size_id AS size_id_210, t104.original_id AS original_id_211, t104.additional_access_product_variant_id AS additional_access_product_variant_id_212, t0.feed_id AS feed_id_213, t214.id AS id_215, t214.title AS title_216, t214.title_sm AS title_sm_217, t214.description AS description_218, t214.description_sm AS description_sm_219, t214.parameters_sm AS parameters_sm_220, t214.link AS link_221, t214.link_gm AS link_gm_222, t214.parameters_fb AS parameters_fb_223, t214.image AS image_224, t214.additional_image AS additional_image_225, t214.mobile_image AS mobile_image_226, t214.brand AS brand_227, t214.brand_sm AS brand_sm_228, t214.product_condition AS product_condition_229, t214.adult AS adult_230, t214.excluded_destination AS excluded_destination_231, t214.included_destination AS included_destination_232, t214.promotion_id AS promotion_id_233, t214.gtin AS gtin_234, t214.updated_at AS updated_at_235, t214.isActive AS isActive_236, t214.google_merchant_category_sm AS google_merchant_category_sm_237, t214.google_merchant_subcategory_sm AS google_merchant_subcategory_sm_238, t214.is_uniqskills AS is_uniqskills_239, t214.is_latino AS is_latino_240, t214.uniqskills_id AS uniqskills_id_241, t214.productURL AS productURL_242, t214.graphicsURL AS graphicsURL_243, t214.categoryURL AS categoryURL_244, t214.custom_label0_id AS custom_label0_id_245, t214.custom_label1_id AS custom_label1_id_246, t214.custom_label2_id AS custom_label2_id_247, t214.custom_label3_id AS custom_label3_id_248, t214.custom_label4_id AS custom_label4_id_249, t214.product_id AS product_id_250, t214.google_merchant_category_id AS google_merchant_category_id_251, t214.google_merchant_product_type_id AS google_merchant_product_type_id_252, t0.events_id AS events_id_253, t254.id AS id_255, t254.name AS name_256, t254.created_at AS created_at_257, t254.updated_at AS updated_at_258, t254.start_at AS start_at_259, t254.event_address AS event_address_260, t254.event_city AS event_city_261, t254.fanpage AS fanpage_262, t254.poll_link AS poll_link_263, t254.conference_lectures_link AS conference_lectures_link_264, t254.website AS website_265, t254.organizational_file_name AS organizational_file_name_266, t254.only_present_are_certified AS only_present_are_certified_267, t254.google_calendar_url AS google_calendar_url_268, t254.outlook_calendar_url AS outlook_calendar_url_269, t254.i_cal_calendar_file_name AS i_cal_calendar_file_name_270, t254.dont_send_notifications AS dont_send_notifications_271, t254.send_event_shop_notifications AS send_event_shop_notifications_272, t254.meeting_link AS meeting_link_273, t254.countdown_timer AS countdown_timer_274, t254.is_nano AS is_nano_275, t254.next_event_id AS next_event_id_276, t254.event_type_id AS event_type_id_277, t254.event_formula_id AS event_formula_id_278, t254.event_platform_id AS event_platform_id_279, t280.id AS id_281, t280.order_quantity AS order_quantity_282, t280.product_variant_id AS product_variant_id_283, t284.id AS id_285, t284.virtual_currency_on_buy_allow AS virtual_currency_on_buy_allow_286, t284.virtual_currency_on_buy_valid_for AS virtual_currency_on_buy_valid_for_287, t284.virtual_currency_on_buy_amount AS virtual_currency_on_buy_amount_288, t284.virtual_currency_on_buy_amount_is_unlimited AS virtual_currency_on_buy_amount_is_unlimited_289, t284.virtual_currency_on_pay_allow AS virtual_currency_on_pay_allow_290, t284.virtual_currency_on_pay_access_days AS virtual_currency_on_pay_access_days_291, t284.virtual_currency_on_pay_amount AS virtual_currency_on_pay_amount_292, t284.created_at AS created_at_293, t284.updated_at AS updated_at_294, t284.product_variant_id AS product_variant_id_295, t284.virtual_currency_on_buy_id AS virtual_currency_on_buy_id_296, t284.virtual_currency_on_pay_id AS virtual_currency_on_pay_id_297, t0.size_id AS size_id_298, t299.id AS id_300, t299.name AS name_301, t299.category AS category_302, t299.description AS description_303, t299.product_url AS product_url_304, t299.bestseller AS bestseller_305, t299.new_product AS new_product_306, t299.discount_price AS discount_price_307, t299.main_image_url AS main_image_url_308, t299.use_uploaded_main_image AS use_uploaded_main_image_309, t299.uploaded_main_image AS uploaded_main_image_310, t299.updated_at AS updated_at_311, t299.product_variant_id AS product_variant_id_312, t0.original_id AS original_id_313, t0.additional_access_product_variant_id AS additional_access_product_variant_id_314, t315.id AS id_316, t315.isVirtual AS isVirtual_317, t315.is_test AS is_test_318, t315.product_variant_no AS product_variant_no_319, t315.product_number_no_tax AS product_number_no_tax_320, t315.product_number_part_tax AS product_number_part_tax_321, t315.product_variant_id AS product_variant_id_322, t315.product_variant_no_complete AS product_variant_no_complete_323, t315.product_variant_key AS product_variant_key_324, t315.variant_state AS variant_state_325, t315.tittle_on_invoice AS tittle_on_invoice_326, t315.working_title AS working_title_327, t315.price_net AS price_net_328, t315.price_gross AS price_gross_329, t315.trade_name AS trade_name_330, t315.alt_trade_name AS alt_trade_name_331, t315.technical_informations AS technical_informations_332, t315.technical_information_for_mail AS technical_information_for_mail_333, t315.label AS label_334, t315.is_gross AS is_gross_335, t315.currency_code AS currency_code_336, t315.postage_type AS postage_type_337, t315.postage_cost AS postage_cost_338, t315.total_weight AS total_weight_339, t315.series_type AS series_type_340, t315.is_default AS is_default_341, t315.tax_free_for_budget_unit AS tax_free_for_budget_unit_342, t315.product_number_for_budget_unit AS product_number_for_budget_unit_343, t315.show_gross_price AS show_gross_price_344, t315.discount_online AS discount_online_345, t315.discount_value_online AS discount_value_online_346, t315.state_is_availible AS state_is_availible_347, t315.state_is_forced_reservation AS state_is_forced_reservation_348, t315.state_is_product_test AS state_is_product_test_349, t315.state_is_trial_recurring AS state_is_trial_recurring_350, t315.trial_recurring_duration AS trial_recurring_duration_351, t315.is_access_without_payment AS is_access_without_payment_352, t315.buy_max_one AS buy_max_one_353, t315.is_addition AS is_addition_354, t315.max_users AS max_users_355, t315.quantity AS quantity_356, t315.order_quantity AS order_quantity_357, t315.event_date AS event_date_358, t315.created_at AS created_at_359, t315.updated_at AS updated_at_360, t315.subscription_type AS subscription_type_361, t315.subscription_plan AS subscription_plan_362, t315.image AS image_363, t315.default_product_association AS default_product_association_364, t315.promoted AS promoted_365, t315.is_published AS is_published_366, t315.is_giftable AS is_giftable_367, t315.is_hidden AS is_hidden_368, t315.is_partial_payment_active AS is_partial_payment_active_369, t315.installment_amount AS installment_amount_370, t315.extended_payment_time AS extended_payment_time_371, t315.summary_upselling_info AS summary_upselling_info_372, t315.trial_duration AS trial_duration_373, t315.required_pwz AS required_pwz_374, t315.promo_name AS promo_name_375, t315.is_digital AS is_digital_376, t315.block_access AS block_access_377, t315.mantis_user_id AS mantis_user_id_378, t315.sales_variant_based_trial_duration AS sales_variant_based_trial_duration_379, t315.sales_variant_based_trial_info AS sales_variant_based_trial_info_380, t315.access_for_paid_only AS access_for_paid_only_381, t315.additional_text_in_cart AS additional_text_in_cart_382, t315.is_recurring_subscription AS is_recurring_subscription_383, t315.document_distribution_channel AS document_distribution_channel_384, t315.hidden_in_sbtill_paid AS hidden_in_sbtill_paid_385, t315.participants_address AS participants_address_386, t315.participants_announcement AS participants_announcement_387, t315.must_have_all_exclusive_variants AS must_have_all_exclusive_variants_388, t315.trade_name_sm AS trade_name_sm_389, t315.comment_for_mantis AS comment_for_mantis_390, t315.coupon_lifetime AS coupon_lifetime_391, t315.fresh_mail_integration AS fresh_mail_integration_392, t315.fresh_mail_recipient_list_hash AS fresh_mail_recipient_list_hash_393, t315.order_on_site_content AS order_on_site_content_394, t315.manual_user_verification AS manual_user_verification_395, t315.image_url_upselling AS image_url_upselling_396, t315.use_uploaded_image_upselling AS use_uploaded_image_upselling_397, t315.uploaded_image_upselling AS uploaded_image_upselling_398, t315.description_upselling AS description_upselling_399, t315.link_to_product_upselling AS link_to_product_upselling_400, t315.show_button_additional_address AS show_button_additional_address_401, t315.max_quantity_in_cart AS max_quantity_in_cart_402, t315.exclude_default_shipping_type AS exclude_default_shipping_type_403, t315.is_completely_digital AS is_completely_digital_404, t315.has_paper_release AS has_paper_release_405, t315.is_npwzrequired AS is_npwzrequired_406, t315.is_sale_disabled AS is_sale_disabled_407, t315.technical_information_for_mail_tele AS technical_information_for_mail_tele_408, t315.additional_information_for_mail AS additional_information_for_mail_409, t315.description_upselling_max_height AS description_upselling_max_height_410, t315.bur_funding_product_variant_id AS bur_funding_product_variant_id_411, t315.product_variant_after_trial_recurring_end_id AS product_variant_after_trial_recurring_end_id_412, t315.master_product_id AS master_product_id_413, t315.trade_product_id AS trade_product_id_414, t315.country_id AS country_id_415, t315.payment_type_id AS payment_type_id_416, t315.product_subscription_type_id AS product_subscription_type_id_417, t315.product_variant_eu_vat_id AS product_variant_eu_vat_id_418, t315.feed_id AS feed_id_419, t315.events_id AS events_id_420, t315.size_id AS size_id_421, t315.original_id AS original_id_422, t315.additional_access_product_variant_id AS additional_access_product_variant_id_423 FROM product_variant t0 LEFT JOIN product_variant t104 ON t104.product_variant_eu_vat_id = t0.id LEFT JOIN google_merchant_feed t214 ON t0.feed_id = t214.id LEFT JOIN events t254 ON t0.events_id = t254.id LEFT JOIN product_variant_order_quantity t280 ON t280.product_variant_id = t0.id LEFT JOIN product_variant_virtual_currency_settings t284 ON t284.product_variant_id = t0.id LEFT JOIN sales_manago_product_variant t299 ON t299.product_variant_id = t0.id LEFT JOIN product_variant t315 ON t315.additional_access_product_variant_id = t0.id INNER JOIN relations_product_variant ON t0.id = relations_product_variant.virtual_variant_id WHERE relations_product_variant.physical_variant_id = ?
Parameters: 
[
  15380
]
View formatted query    View runnable query    Explain query
9.93 ms
(1.50%) 		9 
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.alpha2 AS alpha2_5, t0.alpha3 AS alpha3_6, t0.ioc AS ioc_7, t0.emoji AS emoji_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.currency_id AS currency_id_11, t0.language_id AS language_id_12, t0.continent_id AS continent_id_13, t14.id AS id_15, t14.isActive AS isActive_16, t14.euMember AS euMember_17, t14.signBeforePrice AS signBeforePrice_18, t14.signAfterPrice AS signAfterPrice_19, t14.price_currency AS price_currency_20, t14.vat_rate_b2b AS vat_rate_b2b_21, t14.vat_rate_b2c AS vat_rate_b2c_22, t14.payment_method_online_description AS payment_method_online_description_23, t14.payment_method_offline_description AS payment_method_offline_description_24, t14.link_to_payment_instructions AS link_to_payment_instructions_25, t14.braintree_merchant AS braintree_merchant_26, t14.created_at AS created_at_27, t14.updated_at AS updated_at_28, t14.online_payment_label AS online_payment_label_29, t14.logo_filename AS logo_filename_30, t14.country_id AS country_id_31 FROM country t0 LEFT JOIN country_settings t14 ON t14.country_id = t0.id WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "united-states"
]
View formatted query    View runnable query    Explain query
7.86 ms
(1.19%) 		3 
SELECT o0_.id AS id_0, o0_.coupons_data AS coupons_data_1, o0_.created_at AS created_at_2, o0_.product_variant_id AS product_variant_id_3, o0_.product_pack_id AS product_pack_id_4 FROM omnibus o0_ LEFT JOIN product_variant p1_ ON o0_.product_variant_id = p1_.id WHERE p1_.id = ? AND o0_.created_at >= ? AND o0_.created_at < ?
Parameters: 
[
  15380
  "2026-02-08 05:13:49"
  "2026-03-10 05:13:49"
]
View formatted query    View runnable query    Explain query
7.82 ms
(1.18%) 		1 
SELECT s0_.id AS id_0, s0_.is_active AS is_active_1, s0_.item_order AS item_order_2, s0_.title AS title_3, s0_.slug AS slug_4, s0_.type AS type_5, s0_.body AS body_6, s0_.show_on_main_page AS show_on_main_page_7, s0_.show_in_box_list AS show_in_box_list_8, s0_.meta_title AS meta_title_9, s0_.meta_description AS meta_description_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12, s0_.portal_settings_id AS portal_settings_id_13, s0_.language_id AS language_id_14, s0_.category_id AS category_id_15, s0_.course_id AS course_id_16 FROM static_page s0_ LEFT JOIN portal_settings p1_ ON s0_.portal_settings_id = p1_.id LEFT JOIN language l2_ ON s0_.language_id = l2_.id WHERE p1_.id = ? AND l2_.code = ?
Parameters: 
[
  113
  "pl"
]
View formatted query    View runnable query    Explain query
7.74 ms
(1.17%) 		3 
SELECT t0.id AS id_1, t0.isVirtual AS isVirtual_2, t0.is_test AS is_test_3, t0.product_variant_no AS product_variant_no_4, t0.product_number_no_tax AS product_number_no_tax_5, t0.product_number_part_tax AS product_number_part_tax_6, t0.product_variant_id AS product_variant_id_7, t0.product_variant_no_complete AS product_variant_no_complete_8, t0.product_variant_key AS product_variant_key_9, t0.variant_state AS variant_state_10, t0.tittle_on_invoice AS tittle_on_invoice_11, t0.working_title AS working_title_12, t0.price_net AS price_net_13, t0.price_gross AS price_gross_14, t0.trade_name AS trade_name_15, t0.alt_trade_name AS alt_trade_name_16, t0.technical_informations AS technical_informations_17, t0.technical_information_for_mail AS technical_information_for_mail_18, t0.label AS label_19, t0.is_gross AS is_gross_20, t0.currency_code AS currency_code_21, t0.postage_type AS postage_type_22, t0.postage_cost AS postage_cost_23, t0.total_weight AS total_weight_24, t0.series_type AS series_type_25, t0.is_default AS is_default_26, t0.tax_free_for_budget_unit AS tax_free_for_budget_unit_27, t0.product_number_for_budget_unit AS product_number_for_budget_unit_28, t0.show_gross_price AS show_gross_price_29, t0.discount_online AS discount_online_30, t0.discount_value_online AS discount_value_online_31, t0.state_is_availible AS state_is_availible_32, t0.state_is_forced_reservation AS state_is_forced_reservation_33, t0.state_is_product_test AS state_is_product_test_34, t0.state_is_trial_recurring AS state_is_trial_recurring_35, t0.trial_recurring_duration AS trial_recurring_duration_36, t0.is_access_without_payment AS is_access_without_payment_37, t0.buy_max_one AS buy_max_one_38, t0.is_addition AS is_addition_39, t0.max_users AS max_users_40, t0.quantity AS quantity_41, t0.order_quantity AS order_quantity_42, t0.event_date AS event_date_43, t0.created_at AS created_at_44, t0.updated_at AS updated_at_45, t0.subscription_type AS subscription_type_46, t0.subscription_plan AS subscription_plan_47, t0.image AS image_48, t0.default_product_association AS default_product_association_49, t0.promoted AS promoted_50, t0.is_published AS is_published_51, t0.is_giftable AS is_giftable_52, t0.is_hidden AS is_hidden_53, t0.is_partial_payment_active AS is_partial_payment_active_54, t0.installment_amount AS installment_amount_55, t0.extended_payment_time AS extended_payment_time_56, t0.summary_upselling_info AS summary_upselling_info_57, t0.trial_duration AS trial_duration_58, t0.required_pwz AS required_pwz_59, t0.promo_name AS promo_name_60, t0.is_digital AS is_digital_61, t0.block_access AS block_access_62, t0.mantis_user_id AS mantis_user_id_63, t0.sales_variant_based_trial_duration AS sales_variant_based_trial_duration_64, t0.sales_variant_based_trial_info AS sales_variant_based_trial_info_65, t0.access_for_paid_only AS access_for_paid_only_66, t0.additional_text_in_cart AS additional_text_in_cart_67, t0.is_recurring_subscription AS is_recurring_subscription_68, t0.document_distribution_channel AS document_distribution_channel_69, t0.hidden_in_sbtill_paid AS hidden_in_sbtill_paid_70, t0.participants_address AS participants_address_71, t0.participants_announcement AS participants_announcement_72, t0.must_have_all_exclusive_variants AS must_have_all_exclusive_variants_73, t0.trade_name_sm AS trade_name_sm_74, t0.comment_for_mantis AS comment_for_mantis_75, t0.coupon_lifetime AS coupon_lifetime_76, t0.fresh_mail_integration AS fresh_mail_integration_77, t0.fresh_mail_recipient_list_hash AS fresh_mail_recipient_list_hash_78, t0.order_on_site_content AS order_on_site_content_79, t0.manual_user_verification AS manual_user_verification_80, t0.image_url_upselling AS image_url_upselling_81, t0.use_uploaded_image_upselling AS use_uploaded_image_upselling_82, t0.uploaded_image_upselling AS uploaded_image_upselling_83, t0.description_upselling AS description_upselling_84, t0.link_to_product_upselling AS link_to_product_upselling_85, t0.show_button_additional_address AS show_button_additional_address_86, t0.max_quantity_in_cart AS max_quantity_in_cart_87, t0.exclude_default_shipping_type AS exclude_default_shipping_type_88, t0.is_completely_digital AS is_completely_digital_89, t0.has_paper_release AS has_paper_release_90, t0.is_npwzrequired AS is_npwzrequired_91, t0.is_sale_disabled AS is_sale_disabled_92, t0.technical_information_for_mail_tele AS technical_information_for_mail_tele_93, t0.additional_information_for_mail AS additional_information_for_mail_94, t0.description_upselling_max_height AS description_upselling_max_height_95, t0.bur_funding_product_variant_id AS bur_funding_product_variant_id_96, t0.product_variant_after_trial_recurring_end_id AS product_variant_after_trial_recurring_end_id_97, t0.master_product_id AS master_product_id_98, t0.trade_product_id AS trade_product_id_99, t0.country_id AS country_id_100, t0.payment_type_id AS payment_type_id_101, t0.product_subscription_type_id AS product_subscription_type_id_102, t0.product_variant_eu_vat_id AS product_variant_eu_vat_id_103, t104.id AS id_105, t104.isVirtual AS isVirtual_106, t104.is_test AS is_test_107, t104.product_variant_no AS product_variant_no_108, t104.product_number_no_tax AS product_number_no_tax_109, t104.product_number_part_tax AS product_number_part_tax_110, t104.product_variant_id AS product_variant_id_111, t104.product_variant_no_complete AS product_variant_no_complete_112, t104.product_variant_key AS product_variant_key_113, t104.variant_state AS variant_state_114, t104.tittle_on_invoice AS tittle_on_invoice_115, t104.working_title AS working_title_116, t104.price_net AS price_net_117, t104.price_gross AS price_gross_118, t104.trade_name AS trade_name_119, t104.alt_trade_name AS alt_trade_name_120, t104.technical_informations AS technical_informations_121, t104.technical_information_for_mail AS technical_information_for_mail_122, t104.label AS label_123, t104.is_gross AS is_gross_124, t104.currency_code AS currency_code_125, t104.postage_type AS postage_type_126, t104.postage_cost AS postage_cost_127, t104.total_weight AS total_weight_128, t104.series_type AS series_type_129, t104.is_default AS is_default_130, t104.tax_free_for_budget_unit AS tax_free_for_budget_unit_131, t104.product_number_for_budget_unit AS product_number_for_budget_unit_132, t104.show_gross_price AS show_gross_price_133, t104.discount_online AS discount_online_134, t104.discount_value_online AS discount_value_online_135, t104.state_is_availible AS state_is_availible_136, t104.state_is_forced_reservation AS state_is_forced_reservation_137, t104.state_is_product_test AS state_is_product_test_138, t104.state_is_trial_recurring AS state_is_trial_recurring_139, t104.trial_recurring_duration AS trial_recurring_duration_140, t104.is_access_without_payment AS is_access_without_payment_141, t104.buy_max_one AS buy_max_one_142, t104.is_addition AS is_addition_143, t104.max_users AS max_users_144, t104.quantity AS quantity_145, t104.order_quantity AS order_quantity_146, t104.event_date AS event_date_147, t104.created_at AS created_at_148, t104.updated_at AS updated_at_149, t104.subscription_type AS subscription_type_150, t104.subscription_plan AS subscription_plan_151, t104.image AS image_152, t104.default_product_association AS default_product_association_153, t104.promoted AS promoted_154, t104.is_published AS is_published_155, t104.is_giftable AS is_giftable_156, t104.is_hidden AS is_hidden_157, t104.is_partial_payment_active AS is_partial_payment_active_158, t104.installment_amount AS installment_amount_159, t104.extended_payment_time AS extended_payment_time_160, t104.summary_upselling_info AS summary_upselling_info_161, t104.trial_duration AS trial_duration_162, t104.required_pwz AS required_pwz_163, t104.promo_name AS promo_name_164, t104.is_digital AS is_digital_165, t104.block_access AS block_access_166, t104.mantis_user_id AS mantis_user_id_167, t104.sales_variant_based_trial_duration AS sales_variant_based_trial_duration_168, t104.sales_variant_based_trial_info AS sales_variant_based_trial_info_169, t104.access_for_paid_only AS access_for_paid_only_170, t104.additional_text_in_cart AS additional_text_in_cart_171, t104.is_recurring_subscription AS is_recurring_subscription_172, t104.document_distribution_channel AS document_distribution_channel_173, t104.hidden_in_sbtill_paid AS hidden_in_sbtill_paid_174, t104.participants_address AS participants_address_175, t104.participants_announcement AS participants_announcement_176, t104.must_have_all_exclusive_variants AS must_have_all_exclusive_variants_177, t104.trade_name_sm AS trade_name_sm_178, t104.comment_for_mantis AS comment_for_mantis_179, t104.coupon_lifetime AS coupon_lifetime_180, t104.fresh_mail_integration AS fresh_mail_integration_181, t104.fresh_mail_recipient_list_hash AS fresh_mail_recipient_list_hash_182, t104.order_on_site_content AS order_on_site_content_183, t104.manual_user_verification AS manual_user_verification_184, t104.image_url_upselling AS image_url_upselling_185, t104.use_uploaded_image_upselling AS use_uploaded_image_upselling_186, t104.uploaded_image_upselling AS uploaded_image_upselling_187, t104.description_upselling AS description_upselling_188, t104.link_to_product_upselling AS link_to_product_upselling_189, t104.show_button_additional_address AS show_button_additional_address_190, t104.max_quantity_in_cart AS max_quantity_in_cart_191, t104.exclude_default_shipping_type AS exclude_default_shipping_type_192, t104.is_completely_digital AS is_completely_digital_193, t104.has_paper_release AS has_paper_release_194, t104.is_npwzrequired AS is_npwzrequired_195, t104.is_sale_disabled AS is_sale_disabled_196, t104.technical_information_for_mail_tele AS technical_information_for_mail_tele_197, t104.additional_information_for_mail AS additional_information_for_mail_198, t104.description_upselling_max_height AS description_upselling_max_height_199, t104.bur_funding_product_variant_id AS bur_funding_product_variant_id_200, t104.product_variant_after_trial_recurring_end_id AS product_variant_after_trial_recurring_end_id_201, t104.master_product_id AS master_product_id_202, t104.trade_product_id AS trade_product_id_203, t104.country_id AS country_id_204, t104.payment_type_id AS payment_type_id_205, t104.product_subscription_type_id AS product_subscription_type_id_206, t104.product_variant_eu_vat_id AS product_variant_eu_vat_id_207, t104.feed_id AS feed_id_208, t104.events_id AS events_id_209, t104.size_id AS size_id_210, t104.original_id AS original_id_211, t104.additional_access_product_variant_id AS additional_access_product_variant_id_212, t0.feed_id AS feed_id_213, t214.id AS id_215, t214.title AS title_216, t214.title_sm AS title_sm_217, t214.description AS description_218, t214.description_sm AS description_sm_219, t214.parameters_sm AS parameters_sm_220, t214.link AS link_221, t214.link_gm AS link_gm_222, t214.parameters_fb AS parameters_fb_223, t214.image AS image_224, t214.additional_image AS additional_image_225, t214.mobile_image AS mobile_image_226, t214.brand AS brand_227, t214.brand_sm AS brand_sm_228, t214.product_condition AS product_condition_229, t214.adult AS adult_230, t214.excluded_destination AS excluded_destination_231, t214.included_destination AS included_destination_232, t214.promotion_id AS promotion_id_233, t214.gtin AS gtin_234, t214.updated_at AS updated_at_235, t214.isActive AS isActive_236, t214.google_merchant_category_sm AS google_merchant_category_sm_237, t214.google_merchant_subcategory_sm AS google_merchant_subcategory_sm_238, t214.is_uniqskills AS is_uniqskills_239, t214.is_latino AS is_latino_240, t214.uniqskills_id AS uniqskills_id_241, t214.productURL AS productURL_242, t214.graphicsURL AS graphicsURL_243, t214.categoryURL AS categoryURL_244, t214.custom_label0_id AS custom_label0_id_245, t214.custom_label1_id AS custom_label1_id_246, t214.custom_label2_id AS custom_label2_id_247, t214.custom_label3_id AS custom_label3_id_248, t214.custom_label4_id AS custom_label4_id_249, t214.product_id AS product_id_250, t214.google_merchant_category_id AS google_merchant_category_id_251, t214.google_merchant_product_type_id AS google_merchant_product_type_id_252, t0.events_id AS events_id_253, t254.id AS id_255, t254.name AS name_256, t254.created_at AS created_at_257, t254.updated_at AS updated_at_258, t254.start_at AS start_at_259, t254.event_address AS event_address_260, t254.event_city AS event_city_261, t254.fanpage AS fanpage_262, t254.poll_link AS poll_link_263, t254.conference_lectures_link AS conference_lectures_link_264, t254.website AS website_265, t254.organizational_file_name AS organizational_file_name_266, t254.only_present_are_certified AS only_present_are_certified_267, t254.google_calendar_url AS google_calendar_url_268, t254.outlook_calendar_url AS outlook_calendar_url_269, t254.i_cal_calendar_file_name AS i_cal_calendar_file_name_270, t254.dont_send_notifications AS dont_send_notifications_271, t254.send_event_shop_notifications AS send_event_shop_notifications_272, t254.meeting_link AS meeting_link_273, t254.countdown_timer AS countdown_timer_274, t254.is_nano AS is_nano_275, t254.next_event_id AS next_event_id_276, t254.event_type_id AS event_type_id_277, t254.event_formula_id AS event_formula_id_278, t254.event_platform_id AS event_platform_id_279, t280.id AS id_281, t280.order_quantity AS order_quantity_282, t280.product_variant_id AS product_variant_id_283, t284.id AS id_285, t284.virtual_currency_on_buy_allow AS virtual_currency_on_buy_allow_286, t284.virtual_currency_on_buy_valid_for AS virtual_currency_on_buy_valid_for_287, t284.virtual_currency_on_buy_amount AS virtual_currency_on_buy_amount_288, t284.virtual_currency_on_buy_amount_is_unlimited AS virtual_currency_on_buy_amount_is_unlimited_289, t284.virtual_currency_on_pay_allow AS virtual_currency_on_pay_allow_290, t284.virtual_currency_on_pay_access_days AS virtual_currency_on_pay_access_days_291, t284.virtual_currency_on_pay_amount AS virtual_currency_on_pay_amount_292, t284.created_at AS created_at_293, t284.updated_at AS updated_at_294, t284.product_variant_id AS product_variant_id_295, t284.virtual_currency_on_buy_id AS virtual_currency_on_buy_id_296, t284.virtual_currency_on_pay_id AS virtual_currency_on_pay_id_297, t0.size_id AS size_id_298, t299.id AS id_300, t299.name AS name_301, t299.category AS category_302, t299.description AS description_303, t299.product_url AS product_url_304, t299.bestseller AS bestseller_305, t299.new_product AS new_product_306, t299.discount_price AS discount_price_307, t299.main_image_url AS main_image_url_308, t299.use_uploaded_main_image AS use_uploaded_main_image_309, t299.uploaded_main_image AS uploaded_main_image_310, t299.updated_at AS updated_at_311, t299.product_variant_id AS product_variant_id_312, t0.original_id AS original_id_313, t0.additional_access_product_variant_id AS additional_access_product_variant_id_314, t315.id AS id_316, t315.isVirtual AS isVirtual_317, t315.is_test AS is_test_318, t315.product_variant_no AS product_variant_no_319, t315.product_number_no_tax AS product_number_no_tax_320, t315.product_number_part_tax AS product_number_part_tax_321, t315.product_variant_id AS product_variant_id_322, t315.product_variant_no_complete AS product_variant_no_complete_323, t315.product_variant_key AS product_variant_key_324, t315.variant_state AS variant_state_325, t315.tittle_on_invoice AS tittle_on_invoice_326, t315.working_title AS working_title_327, t315.price_net AS price_net_328, t315.price_gross AS price_gross_329, t315.trade_name AS trade_name_330, t315.alt_trade_name AS alt_trade_name_331, t315.technical_informations AS technical_informations_332, t315.technical_information_for_mail AS technical_information_for_mail_333, t315.label AS label_334, t315.is_gross AS is_gross_335, t315.currency_code AS currency_code_336, t315.postage_type AS postage_type_337, t315.postage_cost AS postage_cost_338, t315.total_weight AS total_weight_339, t315.series_type AS series_type_340, t315.is_default AS is_default_341, t315.tax_free_for_budget_unit AS tax_free_for_budget_unit_342, t315.product_number_for_budget_unit AS product_number_for_budget_unit_343, t315.show_gross_price AS show_gross_price_344, t315.discount_online AS discount_online_345, t315.discount_value_online AS discount_value_online_346, t315.state_is_availible AS state_is_availible_347, t315.state_is_forced_reservation AS state_is_forced_reservation_348, t315.state_is_product_test AS state_is_product_test_349, t315.state_is_trial_recurring AS state_is_trial_recurring_350, t315.trial_recurring_duration AS trial_recurring_duration_351, t315.is_access_without_payment AS is_access_without_payment_352, t315.buy_max_one AS buy_max_one_353, t315.is_addition AS is_addition_354, t315.max_users AS max_users_355, t315.quantity AS quantity_356, t315.order_quantity AS order_quantity_357, t315.event_date AS event_date_358, t315.created_at AS created_at_359, t315.updated_at AS updated_at_360, t315.subscription_type AS subscription_type_361, t315.subscription_plan AS subscription_plan_362, t315.image AS image_363, t315.default_product_association AS default_product_association_364, t315.promoted AS promoted_365, t315.is_published AS is_published_366, t315.is_giftable AS is_giftable_367, t315.is_hidden AS is_hidden_368, t315.is_partial_payment_active AS is_partial_payment_active_369, t315.installment_amount AS installment_amount_370, t315.extended_payment_time AS extended_payment_time_371, t315.summary_upselling_info AS summary_upselling_info_372, t315.trial_duration AS trial_duration_373, t315.required_pwz AS required_pwz_374, t315.promo_name AS promo_name_375, t315.is_digital AS is_digital_376, t315.block_access AS block_access_377, t315.mantis_user_id AS mantis_user_id_378, t315.sales_variant_based_trial_duration AS sales_variant_based_trial_duration_379, t315.sales_variant_based_trial_info AS sales_variant_based_trial_info_380, t315.access_for_paid_only AS access_for_paid_only_381, t315.additional_text_in_cart AS additional_text_in_cart_382, t315.is_recurring_subscription AS is_recurring_subscription_383, t315.document_distribution_channel AS document_distribution_channel_384, t315.hidden_in_sbtill_paid AS hidden_in_sbtill_paid_385, t315.participants_address AS participants_address_386, t315.participants_announcement AS participants_announcement_387, t315.must_have_all_exclusive_variants AS must_have_all_exclusive_variants_388, t315.trade_name_sm AS trade_name_sm_389, t315.comment_for_mantis AS comment_for_mantis_390, t315.coupon_lifetime AS coupon_lifetime_391, t315.fresh_mail_integration AS fresh_mail_integration_392, t315.fresh_mail_recipient_list_hash AS fresh_mail_recipient_list_hash_393, t315.order_on_site_content AS order_on_site_content_394, t315.manual_user_verification AS manual_user_verification_395, t315.image_url_upselling AS image_url_upselling_396, t315.use_uploaded_image_upselling AS use_uploaded_image_upselling_397, t315.uploaded_image_upselling AS uploaded_image_upselling_398, t315.description_upselling AS description_upselling_399, t315.link_to_product_upselling AS link_to_product_upselling_400, t315.show_button_additional_address AS show_button_additional_address_401, t315.max_quantity_in_cart AS max_quantity_in_cart_402, t315.exclude_default_shipping_type AS exclude_default_shipping_type_403, t315.is_completely_digital AS is_completely_digital_404, t315.has_paper_release AS has_paper_release_405, t315.is_npwzrequired AS is_npwzrequired_406, t315.is_sale_disabled AS is_sale_disabled_407, t315.technical_information_for_mail_tele AS technical_information_for_mail_tele_408, t315.additional_information_for_mail AS additional_information_for_mail_409, t315.description_upselling_max_height AS description_upselling_max_height_410, t315.bur_funding_product_variant_id AS bur_funding_product_variant_id_411, t315.product_variant_after_trial_recurring_end_id AS product_variant_after_trial_recurring_end_id_412, t315.master_product_id AS master_product_id_413, t315.trade_product_id AS trade_product_id_414, t315.country_id AS country_id_415, t315.payment_type_id AS payment_type_id_416, t315.product_subscription_type_id AS product_subscription_type_id_417, t315.product_variant_eu_vat_id AS product_variant_eu_vat_id_418, t315.feed_id AS feed_id_419, t315.events_id AS events_id_420, t315.size_id AS size_id_421, t315.original_id AS original_id_422, t315.additional_access_product_variant_id AS additional_access_product_variant_id_423 FROM product_variant t0 LEFT JOIN product_variant t104 ON t104.product_variant_eu_vat_id = t0.id LEFT JOIN google_merchant_feed t214 ON t0.feed_id = t214.id LEFT JOIN events t254 ON t0.events_id = t254.id LEFT JOIN product_variant_order_quantity t280 ON t280.product_variant_id = t0.id LEFT JOIN product_variant_virtual_currency_settings t284 ON t284.product_variant_id = t0.id LEFT JOIN sales_manago_product_variant t299 ON t299.product_variant_id = t0.id LEFT JOIN product_variant t315 ON t315.additional_access_product_variant_id = t0.id INNER JOIN product_variant_course ON t0.id = product_variant_course.product_variant_id WHERE product_variant_course.course_id = ?
Parameters: 
[
  1502
]
View formatted query    View runnable query    Explain query
5.28 ms
(0.80%) 		3 
SELECT t0.id AS id_1, t0.is_gross AS is_gross_2, t0.discount AS discount_3, t0.min_amount AS min_amount_4, t0.max_amount AS max_amount_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.discount_type_id AS discount_type_id_8, t0.product_variant_id AS product_variant_id_9 FROM product_variant_multi_discount t0 WHERE t0.product_variant_id = ?
Parameters: 
[
  15380
]
View formatted query    View runnable query    Explain query
5.14 ms
(0.78%) 		3 
SELECT p0_.id AS id_0, p0_.isVirtual AS isVirtual_1, p0_.is_test AS is_test_2, p0_.product_variant_no AS product_variant_no_3, p0_.product_number_no_tax AS product_number_no_tax_4, p0_.product_number_part_tax AS product_number_part_tax_5, p0_.product_variant_id AS product_variant_id_6, p0_.product_variant_no_complete AS product_variant_no_complete_7, p0_.product_variant_key AS product_variant_key_8, p0_.variant_state AS variant_state_9, p0_.tittle_on_invoice AS tittle_on_invoice_10, p0_.working_title AS working_title_11, p0_.price_net AS price_net_12, p0_.price_gross AS price_gross_13, p0_.trade_name AS trade_name_14, p0_.alt_trade_name AS alt_trade_name_15, p0_.technical_informations AS technical_informations_16, p0_.technical_information_for_mail AS technical_information_for_mail_17, p0_.label AS label_18, p0_.is_gross AS is_gross_19, p0_.currency_code AS currency_code_20, p0_.postage_type AS postage_type_21, p0_.postage_cost AS postage_cost_22, p0_.total_weight AS total_weight_23, p0_.series_type AS series_type_24, p0_.is_default AS is_default_25, p0_.tax_free_for_budget_unit AS tax_free_for_budget_unit_26, p0_.product_number_for_budget_unit AS product_number_for_budget_unit_27, p0_.show_gross_price AS show_gross_price_28, p0_.discount_online AS discount_online_29, p0_.discount_value_online AS discount_value_online_30, p0_.state_is_availible AS state_is_availible_31, p0_.state_is_forced_reservation AS state_is_forced_reservation_32, p0_.state_is_product_test AS state_is_product_test_33, p0_.state_is_trial_recurring AS state_is_trial_recurring_34, p0_.trial_recurring_duration AS trial_recurring_duration_35, p0_.is_access_without_payment AS is_access_without_payment_36, p0_.buy_max_one AS buy_max_one_37, p0_.is_addition AS is_addition_38, p0_.max_users AS max_users_39, p0_.quantity AS quantity_40, p0_.order_quantity AS order_quantity_41, p0_.event_date AS event_date_42, p0_.created_at AS created_at_43, p0_.updated_at AS updated_at_44, p0_.subscription_type AS subscription_type_45, p0_.subscription_plan AS subscription_plan_46, p0_.image AS image_47, p0_.default_product_association AS default_product_association_48, p0_.promoted AS promoted_49, p0_.is_published AS is_published_50, p0_.is_giftable AS is_giftable_51, p0_.is_hidden AS is_hidden_52, p0_.is_partial_payment_active AS is_partial_payment_active_53, p0_.installment_amount AS installment_amount_54, p0_.extended_payment_time AS extended_payment_time_55, p0_.summary_upselling_info AS summary_upselling_info_56, p0_.trial_duration AS trial_duration_57, p0_.required_pwz AS required_pwz_58, p0_.promo_name AS promo_name_59, p0_.is_digital AS is_digital_60, p0_.block_access AS block_access_61, p0_.mantis_user_id AS mantis_user_id_62, p0_.sales_variant_based_trial_duration AS sales_variant_based_trial_duration_63, p0_.sales_variant_based_trial_info AS sales_variant_based_trial_info_64, p0_.access_for_paid_only AS access_for_paid_only_65, p0_.additional_text_in_cart AS additional_text_in_cart_66, p0_.is_recurring_subscription AS is_recurring_subscription_67, p0_.document_distribution_channel AS document_distribution_channel_68, p0_.hidden_in_sbtill_paid AS hidden_in_sbtill_paid_69, p0_.participants_address AS participants_address_70, p0_.participants_announcement AS participants_announcement_71, p0_.must_have_all_exclusive_variants AS must_have_all_exclusive_variants_72, p0_.trade_name_sm AS trade_name_sm_73, p0_.comment_for_mantis AS comment_for_mantis_74, p0_.coupon_lifetime AS coupon_lifetime_75, p0_.fresh_mail_integration AS fresh_mail_integration_76, p0_.fresh_mail_recipient_list_hash AS fresh_mail_recipient_list_hash_77, p0_.order_on_site_content AS order_on_site_content_78, p0_.manual_user_verification AS manual_user_verification_79, p0_.image_url_upselling AS image_url_upselling_80, p0_.use_uploaded_image_upselling AS use_uploaded_image_upselling_81, p0_.uploaded_image_upselling AS uploaded_image_upselling_82, p0_.description_upselling AS description_upselling_83, p0_.link_to_product_upselling AS link_to_product_upselling_84, p0_.show_button_additional_address AS show_button_additional_address_85, p0_.max_quantity_in_cart AS max_quantity_in_cart_86, p0_.exclude_default_shipping_type AS exclude_default_shipping_type_87, p0_.is_completely_digital AS is_completely_digital_88, p0_.has_paper_release AS has_paper_release_89, p0_.is_npwzrequired AS is_npwzrequired_90, p0_.is_sale_disabled AS is_sale_disabled_91, p0_.technical_information_for_mail_tele AS technical_information_for_mail_tele_92, p0_.additional_information_for_mail AS additional_information_for_mail_93, p0_.description_upselling_max_height AS description_upselling_max_height_94, p0_.bur_funding_product_variant_id AS bur_funding_product_variant_id_95, p0_.product_variant_after_trial_recurring_end_id AS product_variant_after_trial_recurring_end_id_96, p0_.master_product_id AS master_product_id_97, p0_.trade_product_id AS trade_product_id_98, p0_.country_id AS country_id_99, p0_.payment_type_id AS payment_type_id_100, p0_.product_subscription_type_id AS product_subscription_type_id_101, p0_.product_variant_eu_vat_id AS product_variant_eu_vat_id_102, p0_.feed_id AS feed_id_103, p0_.events_id AS events_id_104, p0_.size_id AS size_id_105, p0_.original_id AS original_id_106, p0_.additional_access_product_variant_id AS additional_access_product_variant_id_107 FROM product_variant p0_ LEFT JOIN country c1_ ON p0_.country_id = c1_.id LEFT JOIN product_variant_course p3_ ON p0_.id = p3_.product_variant_id LEFT JOIN course c2_ ON c2_.id = p3_.course_id WHERE c2_.slug = ? AND c1_.name = ?
Parameters: 
[
  "jak-zweryfikowac-kontrahenta-by-nie-narazic-sie-na-straty-finansowe-i-nie-wziac-udzialu-w-nieswiadomym-oszustwie"
  "United Kingdom"
]
View formatted query    View runnable query    Explain query
5.12 ms
(0.77%) 		1 
SELECT 
                        c.id
                    FROM
                        category c
                            LEFT JOIN
                        language l ON c.language_id = l.id
                    WHERE
                        l.code = ? AND c.is_active = 1
                            AND c.parent_id IS NULL
                            AND ((SELECT 
                                COUNT(1)
                            FROM
                                course categoryCourses
                            WHERE
                                categoryCourses.portal_settings_id = ?
                                    AND categoryCourses.category_id = c.id
                                    AND categoryCourses.is_active = TRUE
                                    AND ((CURRENT_DATE() < categoryCourses.hide_after
                                            OR categoryCourses.hide_after IS NULL)
                                                OR
                                        ( categoryCourses.is_active = false
                                          AND categoryCourses.id IN (NULL)
                                        ))
                            GROUP BY categoryCourses.category_id) > 0
                            OR (SELECT 
                                COUNT(1)
                            FROM
                                courses_additional_categories cac
                                    INNER JOIN
                                course categoryAdditionalCourses ON categoryAdditionalCourses.id = cac.course_id
                            WHERE
                                cac.category_id = c.id
                                    AND categoryAdditionalCourses.portal_settings_id = ?
                                    AND categoryAdditionalCourses.is_active = TRUE
                                    AND ((CURRENT_DATE() < categoryAdditionalCourses.hide_after
                                            OR categoryAdditionalCourses.hide_after IS NULL)
                                                OR
                                        ( categoryAdditionalCourses.is_active = false
                                          AND categoryAdditionalCourses.id IN (NULL)
                                        ))
                            GROUP BY categoryAdditionalCourses.category_id) > 0
                            OR (SELECT 
                                COUNT(1)
                            FROM
                                category childrenCategory
                                    INNER JOIN
                                course childrenCourses ON childrenCategory.id = childrenCourses.category_id
                            WHERE
                                childrenCategory.parent_id = c.id
                                    AND childrenCourses.portal_settings_id = ?
                                    AND childrenCourses.is_active = TRUE
                                    AND ((CURRENT_DATE() < childrenCourses.hide_after
                                            OR childrenCourses.hide_after IS NULL)
                                                OR
                                        (childrenCourses.is_active = false
                                         AND childrenCourses.id IN (NULL)
                                        ))
                            GROUP BY childrenCategory.parent_id) > 0
                            OR (SELECT 
                                COUNT(1)
                            FROM
                                category childrenCategory
                                    INNER JOIN
                                courses_additional_categories childrencac ON childrenCategory.id = childrencac.category_id
                                    INNER JOIN
                                course childrenAdditionalCourses ON childrencac.course_id = childrenAdditionalCourses.id
                            WHERE
                                childrenCategory.parent_id = c.id
                                    AND childrenAdditionalCourses.portal_settings_id = ?
                                    AND childrenAdditionalCourses.is_active = TRUE
                                    AND ((CURRENT_DATE() < childrenAdditionalCourses.hide_after
                                         OR childrenAdditionalCourses.hide_after IS NULL)
                                                OR
                                        (childrenAdditionalCourses.is_active = false
                                         AND childrenAdditionalCourses.id IN (NULL)
                                        ))
                            GROUP BY childrenCategory.parent_id))
                    ORDER BY c.position ASC
Parameters: 
[
  "pl"
  113
  113
  113
  113
]
View formatted query    View runnable query    Explain query
4.21 ms
(0.64%) 		3 
SELECT p0_.id AS id_0, p0_.isVirtual AS isVirtual_1, p0_.is_test AS is_test_2, p0_.product_variant_no AS product_variant_no_3, p0_.product_number_no_tax AS product_number_no_tax_4, p0_.product_number_part_tax AS product_number_part_tax_5, p0_.product_variant_id AS product_variant_id_6, p0_.product_variant_no_complete AS product_variant_no_complete_7, p0_.product_variant_key AS product_variant_key_8, p0_.variant_state AS variant_state_9, p0_.tittle_on_invoice AS tittle_on_invoice_10, p0_.working_title AS working_title_11, p0_.price_net AS price_net_12, p0_.price_gross AS price_gross_13, p0_.trade_name AS trade_name_14, p0_.alt_trade_name AS alt_trade_name_15, p0_.technical_informations AS technical_informations_16, p0_.technical_information_for_mail AS technical_information_for_mail_17, p0_.label AS label_18, p0_.is_gross AS is_gross_19, p0_.currency_code AS currency_code_20, p0_.postage_type AS postage_type_21, p0_.postage_cost AS postage_cost_22, p0_.total_weight AS total_weight_23, p0_.series_type AS series_type_24, p0_.is_default AS is_default_25, p0_.tax_free_for_budget_unit AS tax_free_for_budget_unit_26, p0_.product_number_for_budget_unit AS product_number_for_budget_unit_27, p0_.show_gross_price AS show_gross_price_28, p0_.discount_online AS discount_online_29, p0_.discount_value_online AS discount_value_online_30, p0_.state_is_availible AS state_is_availible_31, p0_.state_is_forced_reservation AS state_is_forced_reservation_32, p0_.state_is_product_test AS state_is_product_test_33, p0_.state_is_trial_recurring AS state_is_trial_recurring_34, p0_.trial_recurring_duration AS trial_recurring_duration_35, p0_.is_access_without_payment AS is_access_without_payment_36, p0_.buy_max_one AS buy_max_one_37, p0_.is_addition AS is_addition_38, p0_.max_users AS max_users_39, p0_.quantity AS quantity_40, p0_.order_quantity AS order_quantity_41, p0_.event_date AS event_date_42, p0_.created_at AS created_at_43, p0_.updated_at AS updated_at_44, p0_.subscription_type AS subscription_type_45, p0_.subscription_plan AS subscription_plan_46, p0_.image AS image_47, p0_.default_product_association AS default_product_association_48, p0_.promoted AS promoted_49, p0_.is_published AS is_published_50, p0_.is_giftable AS is_giftable_51, p0_.is_hidden AS is_hidden_52, p0_.is_partial_payment_active AS is_partial_payment_active_53, p0_.installment_amount AS installment_amount_54, p0_.extended_payment_time AS extended_payment_time_55, p0_.summary_upselling_info AS summary_upselling_info_56, p0_.trial_duration AS trial_duration_57, p0_.required_pwz AS required_pwz_58, p0_.promo_name AS promo_name_59, p0_.is_digital AS is_digital_60, p0_.block_access AS block_access_61, p0_.mantis_user_id AS mantis_user_id_62, p0_.sales_variant_based_trial_duration AS sales_variant_based_trial_duration_63, p0_.sales_variant_based_trial_info AS sales_variant_based_trial_info_64, p0_.access_for_paid_only AS access_for_paid_only_65, p0_.additional_text_in_cart AS additional_text_in_cart_66, p0_.is_recurring_subscription AS is_recurring_subscription_67, p0_.document_distribution_channel AS document_distribution_channel_68, p0_.hidden_in_sbtill_paid AS hidden_in_sbtill_paid_69, p0_.participants_address AS participants_address_70, p0_.participants_announcement AS participants_announcement_71, p0_.must_have_all_exclusive_variants AS must_have_all_exclusive_variants_72, p0_.trade_name_sm AS trade_name_sm_73, p0_.comment_for_mantis AS comment_for_mantis_74, p0_.coupon_lifetime AS coupon_lifetime_75, p0_.fresh_mail_integration AS fresh_mail_integration_76, p0_.fresh_mail_recipient_list_hash AS fresh_mail_recipient_list_hash_77, p0_.order_on_site_content AS order_on_site_content_78, p0_.manual_user_verification AS manual_user_verification_79, p0_.image_url_upselling AS image_url_upselling_80, p0_.use_uploaded_image_upselling AS use_uploaded_image_upselling_81, p0_.uploaded_image_upselling AS uploaded_image_upselling_82, p0_.description_upselling AS description_upselling_83, p0_.link_to_product_upselling AS link_to_product_upselling_84, p0_.show_button_additional_address AS show_button_additional_address_85, p0_.max_quantity_in_cart AS max_quantity_in_cart_86, p0_.exclude_default_shipping_type AS exclude_default_shipping_type_87, p0_.is_completely_digital AS is_completely_digital_88, p0_.has_paper_release AS has_paper_release_89, p0_.is_npwzrequired AS is_npwzrequired_90, p0_.is_sale_disabled AS is_sale_disabled_91, p0_.technical_information_for_mail_tele AS technical_information_for_mail_tele_92, p0_.additional_information_for_mail AS additional_information_for_mail_93, p0_.description_upselling_max_height AS description_upselling_max_height_94, p0_.bur_funding_product_variant_id AS bur_funding_product_variant_id_95, p0_.product_variant_after_trial_recurring_end_id AS product_variant_after_trial_recurring_end_id_96, p0_.master_product_id AS master_product_id_97, p0_.trade_product_id AS trade_product_id_98, p0_.country_id AS country_id_99, p0_.payment_type_id AS payment_type_id_100, p0_.product_subscription_type_id AS product_subscription_type_id_101, p0_.product_variant_eu_vat_id AS product_variant_eu_vat_id_102, p0_.feed_id AS feed_id_103, p0_.events_id AS events_id_104, p0_.size_id AS size_id_105, p0_.original_id AS original_id_106, p0_.additional_access_product_variant_id AS additional_access_product_variant_id_107 FROM product_variant p0_ WHERE p0_.product_variant_no_complete = ? LIMIT 1
Parameters: 
[
  "92274/2"
]
View formatted query    View runnable query    Explain query
3.94 ms
(0.59%) 		3 
SELECT t0.id AS id_1, t0.position AS position_2, t0.is_visible AS is_visible_3, t0.in_second_menu AS in_second_menu_4, t0.landing_module_type_id AS landing_module_type_id_5, t0.landing_id AS landing_id_6 FROM landing_module t0 WHERE t0.landing_id = ? ORDER BY t0.position ASC
Parameters: 
[
  1217
]
View formatted query    View runnable query    Explain query
1.85 ms
(0.28%) 		3 
SELECT t0.id AS id_1, t0.isActive AS isActive_2, t0.name AS name_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM payment_system t0 INNER JOIN product_variant_payment_system ON t0.id = product_variant_payment_system.payment_system_id WHERE product_variant_payment_system.product_variant_id = ?
Parameters: 
[
  15380
]
View formatted query    View runnable query    Explain query
1.73 ms
(0.26%) 		3 
SELECT t0.id AS id_1, t0.label AS label_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.file_name AS file_name_5, t0.product_variant_id AS product_variant_id_6 FROM additional_file t0 WHERE t0.product_variant_id IN (?, ?)
Parameters: 
[
  15379
  15380
]
View formatted query    View runnable query    Explain query
1.61 ms
(0.24%) 		1 
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.on_main_page AS on_main_page_3, t0.visible_in_footer AS visible_in_footer_4, t0.name AS name_5, t0.slug AS slug_6, t0.link AS link_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.not_for_uniqskills AS not_for_uniqskills_11, t0.nip AS nip_12 FROM cooperator t0 WHERE t0.id = ?
Parameters: 
[
  168
]
View formatted query    View runnable query    Explain query
1.59 ms
(0.24%) 		3 
SELECT t0.id AS id_1, t0.hidden_in_sbtill_paid AS hidden_in_sbtill_paid_2, t0.extended_payment_time AS extended_payment_time_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.is_active AS is_active_6, t0.product_variant_id AS product_variant_id_7, t0.client_type_id AS client_type_id_8 FROM additional_options_by_client_type t0 WHERE t0.product_variant_id IN (?, ?)
Parameters: 
[
  15379
  15380
]
View formatted query    View runnable query    Explain query
1.56 ms
(0.24%) 		1 
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.short_body AS short_body_3, t0.body AS body_4, t0.testimonials_custom AS testimonials_custom_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.position AS position_8, t0.image_name AS image_name_9, t0.banner_name AS banner_name_10, t0.banner_link AS banner_link_11, t0.banner_html AS banner_html_12, t0.updated_at AS updated_at_13, t0.default_for_us AS default_for_us_14, t0.parent_id AS parent_id_15, t16.id AS id_17, t16.is_active AS is_active_18, t16.name AS name_19, t16.portal_settings_id AS portal_settings_id_20, t16.category_id AS category_id_21, t16.product_association_id AS product_association_id_22, t16.product_main_type_id AS product_main_type_id_23, t16.template_type_id AS template_type_id_24, t0.portal_settings_id AS portal_settings_id_25, t0.recommended_product_association_id AS recommended_product_association_id_26, t0.language_id AS language_id_27, t28.id AS id_29, t28.is_active AS is_active_30, t28.name AS name_31, t28.native AS native_32, t28.slug AS slug_33, t28.code AS code_34, t28.short AS short_35, t28.created_at AS created_at_36, t28.updated_at AS updated_at_37, t38.id AS id_39, t38.title AS title_40, t38.description AS description_41, t38.head_scripts AS head_scripts_42, t38.body_scripts AS body_scripts_43, t38.created_at AS created_at_44, t38.updated_at AS updated_at_45, t38.product_association_id AS product_association_id_46, t38.category_id AS category_id_47, t38.template_type_id AS template_type_id_48 FROM category t0 LEFT JOIN templates t16 ON t16.category_id = t0.id LEFT JOIN language t28 ON t0.language_id = t28.id LEFT JOIN meta_tags t38 ON t38.category_id = t0.id WHERE t0.category_slug = ? AND t0.portal_settings_id = ? AND t0.is_active = ? LIMIT 1
Parameters: 
[
  "ksiegowosc-finanse"
  113
  1
]
View formatted query    View runnable query    Explain query
1.35 ms
(0.20%) 		1 
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.short_body AS short_body_3, t0.body AS body_4, t0.testimonials_custom AS testimonials_custom_5, t0.category_name AS category_name_6, t0.category_slug AS category_slug_7, t0.position AS position_8, t0.image_name AS image_name_9, t0.banner_name AS banner_name_10, t0.banner_link AS banner_link_11, t0.banner_html AS banner_html_12, t0.updated_at AS updated_at_13, t0.default_for_us AS default_for_us_14, t0.parent_id AS parent_id_15, t16.id AS id_17, t16.is_active AS is_active_18, t16.name AS name_19, t16.portal_settings_id AS portal_settings_id_20, t16.category_id AS category_id_21, t16.product_association_id AS product_association_id_22, t16.product_main_type_id AS product_main_type_id_23, t16.template_type_id AS template_type_id_24, t0.portal_settings_id AS portal_settings_id_25, t0.recommended_product_association_id AS recommended_product_association_id_26, t0.language_id AS language_id_27, t28.id AS id_29, t28.is_active AS is_active_30, t28.name AS name_31, t28.native AS native_32, t28.slug AS slug_33, t28.code AS code_34, t28.short AS short_35, t28.created_at AS created_at_36, t28.updated_at AS updated_at_37, t38.id AS id_39, t38.title AS title_40, t38.description AS description_41, t38.head_scripts AS head_scripts_42, t38.body_scripts AS body_scripts_43, t38.created_at AS created_at_44, t38.updated_at AS updated_at_45, t38.product_association_id AS product_association_id_46, t38.category_id AS category_id_47, t38.template_type_id AS template_type_id_48 FROM category t0 LEFT JOIN templates t16 ON t16.category_id = t0.id LEFT JOIN language t28 ON t0.language_id = t28.id LEFT JOIN meta_tags t38 ON t38.category_id = t0.id WHERE t0.category_slug = ? LIMIT 1
Parameters: 
[
  "ksiegowosc-finanse"
]
View formatted query    View runnable query    Explain query
1.33 ms
(0.20%) 		1 
SELECT c0_.id AS id_0, c0_.is_active AS is_active_1, c0_.short_body AS short_body_2, c0_.body AS body_3, c0_.testimonials_custom AS testimonials_custom_4, c0_.category_name AS category_name_5, c0_.category_slug AS category_slug_6, c0_.position AS position_7, c0_.image_name AS image_name_8, c0_.banner_name AS banner_name_9, c0_.banner_link AS banner_link_10, c0_.banner_html AS banner_html_11, c0_.updated_at AS updated_at_12, c0_.default_for_us AS default_for_us_13, c0_.parent_id AS parent_id_14, c0_.portal_settings_id AS portal_settings_id_15, c0_.recommended_product_association_id AS recommended_product_association_id_16, c0_.language_id AS language_id_17 FROM category c0_ LEFT JOIN language l1_ ON c0_.language_id = l1_.id LEFT JOIN portal_settings p2_ ON c0_.portal_settings_id = p2_.id WHERE p2_.id = ? AND l1_.code = ? AND c0_.parent_id IS NULL AND c0_.is_active = 1 ORDER BY c0_.position ASC
Parameters: 
[
  113
  "pl"
]
View formatted query    View runnable query    Explain query
1.07 ms
(0.16%) 		1 
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 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "pl"
]
View formatted query    View runnable query    Explain query
0.98 ms
(0.15%) 		1 
SELECT t0.id AS id_1, t0.payment_name AS payment_name_2, t0.icon_file_name AS icon_file_name_3, t0.information AS information_4, t0.link_to_payment_instructions AS link_to_payment_instructions_5, t0.is_auto_redirect AS is_auto_redirect_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.description AS description_9, t0.position AS position_10, t0.payment_system_id AS payment_system_id_11 FROM payment_options t0 WHERE t0.payment_system_id IN (?, ?)
Parameters: 
[
  2
  7
]
View formatted query    View runnable query    Explain query
0.85 ms
(0.13%) 		1 
SELECT l0_.id AS id_0, l0_.is_active AS is_active_1, l0_.name AS name_2, l0_.native AS native_3, l0_.slug AS slug_4, l0_.code AS code_5, l0_.short AS short_6, l0_.created_at AS created_at_7, l0_.updated_at AS updated_at_8 FROM language l0_ LEFT JOIN fm_company_settings_language f2_ ON l0_.id = f2_.language_id LEFT JOIN fm_company_settings f1_ ON f1_.id = f2_.fm_company_settings_id LEFT JOIN portal_settings p3_ ON f1_.portal_settings_id = p3_.id WHERE l0_.is_active = 1 AND p3_.id = ?
Parameters: 
[
  113
]
View formatted query    View runnable query    Explain query
0.81 ms
(0.12%) 		1 
SELECT DISTINCT c0_.name AS name_0 FROM course_keyword c0_ LEFT JOIN course c1_ ON c0_.id = c1_.main_keyword_id LEFT JOIN courses_additional_keywords c3_ ON c0_.id = c3_.course_keyword_id LEFT JOIN course c2_ ON c2_.id = c3_.course_id LEFT JOIN category c4_ ON c1_.category_id = c4_.id LEFT JOIN category c5_ ON c2_.category_id = c5_.id LEFT JOIN language l6_ ON c4_.language_id = l6_.id LEFT JOIN language l7_ ON c5_.language_id = l7_.id WHERE (l6_.code = ? OR l7_.code = ?) AND ((c4_.category_name = ? OR c5_.category_name = ?))
Parameters: 
[
  "pl"
  "pl"
  "ksiegowosc-finanse"
  "ksiegowosc-finanse"
]
View formatted query    View runnable query    Explain query
0.67 ms
(0.10%) 		1 
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.on_main_page AS on_main_page_3, t0.visible_in_footer AS visible_in_footer_4, t0.name AS name_5, t0.slug AS slug_6, t0.link AS link_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.not_for_uniqskills AS not_for_uniqskills_11, t0.nip AS nip_12 FROM cooperator t0 WHERE t0.visible_in_footer = ? AND t0.not_for_uniqskills = ?
Parameters: 
[
  1
  0
]
View formatted query    View runnable query    Explain query

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\Continent No errors.
App\Entity\Gos\CountrySettings No errors.
App\Entity\Gos\PaymentOptions No errors.
App\Entity\Gos\Address No errors.
App\Entity\Gos\ProductMainType No errors.
App\Entity\Gos\Tmpl\TemplateType No errors.
App\Entity\Gos\MetaTags No errors.
App\Entity\Gos\Uniqskills\Author No errors.
App\Entity\Gos\Uniqskills\Cooperator No errors.
App\Entity\Gos\Uniqskills\Voucher No errors.
App\Entity\Gos\NotificationForUser No errors.
App\Entity\Gos\Uniqskills\CourseKeyword No errors.
App\Entity\Gos\Uniqskills\Landing\Landing No errors.
App\Entity\Gos\Uniqskills\CourseType No errors.
App\Entity\Gos\Uniqskills\Module No errors.
App\Entity\Gos\Uniqskills\Package No errors.
App\Entity\Gos\Uniqskills\Test No errors.
App\Entity\Gos\Uniqskills\OrderError No errors.
App\Entity\Gos\Uniqskills\Testimonial No errors.
App\Entity\Gos\Uniqskills\Certificate No errors.
App\Entity\Gos\CourseNotify No errors.
App\Entity\Gos\Uniqskills\Landing\LandingModule No errors.
App\Entity\Gos\Product No errors.
App\Entity\Gos\PaymentType No errors.
App\Entity\Gos\ProductSubscriptionType No errors.
App\Entity\Gos\GoogleMerchantFeed No errors.
App\Entity\Gos\Events No errors.
App\Entity\Gos\ProductVariantSize No errors.
App\Entity\Gos\ProductPack No errors.
App\Entity\Gos\ProductPackItem No errors.
App\Entity\Gos\ProductPackType No errors.
App\Entity\Gos\ProductCart No errors.
App\Entity\Gos\Uniqskills\OrderCycle No errors.
App\Entity\Gos\ProductPackMultiDiscount No errors.
App\Entity\Gos\BaseCoupon No errors.
App\Entity\Gos\Coupon No errors.
App\Entity\Gos\Omnibus No errors.
App\Entity\Gos\GoogleMerchantTag No errors.
App\Entity\Gos\GoogleMerchantCategory No errors.
App\Entity\Gos\GoogleMerchantProductType No errors.
App\Entity\Gos\EventType No errors.
App\Entity\Gos\EventFormula No errors.
App\Entity\Gos\EventsPlatform No errors.
App\Entity\Gos\ProductVariantOrderQuantity No errors.
App\Entity\Gos\VirtualCurrency\ProductVariantVirtualCurrencySettings No errors.
App\Entity\Gos\SalesManagoProductVariant No errors.
App\Entity\Gos\ProductVariantMultiDiscount No errors.
App\Entity\Gos\ApplicationCoupon
  • The target entity 'App\Entity\Gos\BaseCoupon' specified on App\Entity\Gos\ApplicationCoupon#coupon is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Gos\SalesManagoCoupon No errors.
App\Entity\Gos\SalesManagoCatalog No errors.
App\Entity\Gos\CouponPackProduct No errors.
App\Entity\Gos\PaymentMethod No errors.
App\Entity\Gos\OrderProductVariant No errors.
App\Entity\Gos\EventProductVariantGroupItem No errors.
App\Entity\Gos\EventProductVariantGroup No errors.
App\Entity\Gos\CartParticipant No errors.
App\Entity\Gos\Participants No errors.
App\Entity\Gos\ProductVariantDescription No errors.
App\Entity\Gos\Alert No errors.
App\Entity\Gos\File No errors.
App\Entity\Gos\LeadFormResponse No errors.
App\Entity\Gos\NewsletterTemplate No errors.
App\Entity\Gos\CalendarEvent No errors.
App\Entity\Gos\PaymentReminders No errors.
App\Entity\Gos\ProductVariantUpselling No errors.
App\Entity\Gos\FastLeadTemplate No errors.
App\Entity\Gos\ShippingType No errors.
App\Entity\Gos\CertificatePathElement No errors.
App\Entity\Gos\AdditionalFile No errors.
App\Entity\Gos\UserFlag No errors.
App\Entity\Gos\ProductVariantReviewLink No errors.
App\Entity\Gos\AdditionalOptionsByClientType No errors.
App\Entity\Gos\CooperatorGroup No errors.
App\Entity\Gos\Uniqskills\Landing\LandingModuleType No errors.
App\Entity\Gos\Uniqskills\Landing\LandingModuleItem No errors.
App\Entity\Gos\Uniqskills\Landing\LandingModuleText No errors.
App\Entity\Gos\Uniqskills\Landing\LandingModuleFile No errors.
App\Entity\Gos\Uniqskills\Landing\LandingModuleJson No errors.
App\Entity\Gos\Uniqskills\Landing\LandingModuleBoolean No errors.
App\Entity\Gos\Notify No errors.
App\Entity\Gos\ProductVariantMultiDiscountType No errors.

sb entity manager

No loaded entities.

czasopisma entity manager

No loaded entities.

bc entity manager

No loaded entities.