Symfony Profiler

SELECT t0.id AS id_1, t0.preview_fragment AS preview_fragment_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.slug AS slug_5, t0.subtitle AS subtitle_6, t0.frontend_description AS frontend_description_7, t0.frontend_description_short AS frontend_description_short_8, t0.is_recommended AS is_recommended_9, t0.is_most_bought AS is_most_bought_10, t0.logo AS logo_11, t0.background AS background_12, t0.partner_logo AS partner_logo_13, t0.default_quantity_ticket AS default_quantity_ticket_14, t0.custom_scripts AS custom_scripts_15, t0.is_hidden AS is_hidden_16, t0.number_of_access_to_last_releases AS number_of_access_to_last_releases_17, t0.use_html_landing AS use_html_landing_18, t0.custom_head AS custom_head_19, t0.custom_css AS custom_css_20, t0.custom_landing AS custom_landing_21, t0.landing_full_width AS landing_full_width_22, t0.portal_settings_id AS portal_settings_id_23, t0.coupon_default_id AS coupon_default_id_24, t25.id AS id_26, t25.is_active AS is_active_27, t25.short_body AS short_body_28, t25.body AS body_29, t25.testimonials_custom AS testimonials_custom_30, t25.category_name AS category_name_31, t25.category_slug AS category_slug_32, t25.position AS position_33, t25.image_name AS image_name_34, t25.banner_name AS banner_name_35, t25.banner_link AS banner_link_36, t25.banner_html AS banner_html_37, t25.updated_at AS updated_at_38, t25.default_for_us AS default_for_us_39, t25.parent_id AS parent_id_40, t25.portal_settings_id AS portal_settings_id_41, t25.recommended_product_association_id AS recommended_product_association_id_42, t25.language_id AS language_id_43, t0.category_master_id AS category_master_id_44, t45.id AS id_46, t45.is_active AS is_active_47, t45.name AS name_48, t45.portal_settings_id AS portal_settings_id_49, t45.category_id AS category_id_50, t45.product_association_id AS product_association_id_51, t45.product_main_type_id AS product_main_type_id_52, t45.template_type_id AS template_type_id_53, t0.product_main_type_id AS product_main_type_id_54, t55.id AS id_56, t55.title AS title_57, t55.description AS description_58, t55.head_scripts AS head_scripts_59, t55.body_scripts AS body_scripts_60, t55.created_at AS created_at_61, t55.updated_at AS updated_at_62, t55.product_association_id AS product_association_id_63, t55.category_id AS category_id_64, t55.template_type_id AS template_type_id_65 FROM product_association t0 LEFT JOIN category t25 ON t25.recommended_product_association_id = t0.id LEFT JOIN templates t45 ON t45.product_association_id = t0.id LEFT JOIN meta_tags t55 ON t55.product_association_id = t0.id INNER JOIN product_association_product ON t0.id = product_association_product.product_association_id WHERE product_association_product.product_id = ?

[
  5898
]

SELECT
  t0.id AS id_1,
  t0.preview_fragment AS preview_fragment_2,
  t0.updated_at AS updated_at_3,
  t0.title AS title_4,
  t0.slug AS slug_5,
  t0.subtitle AS subtitle_6,
  t0.frontend_description AS frontend_description_7,
  t0.frontend_description_short AS frontend_description_short_8,
  t0.is_recommended AS is_recommended_9,
  t0.is_most_bought AS is_most_bought_10,
  t0.logo AS logo_11,
  t0.background AS background_12,
  t0.partner_logo AS partner_logo_13,
  t0.default_quantity_ticket AS default_quantity_ticket_14,
  t0.custom_scripts AS custom_scripts_15,
  t0.is_hidden AS is_hidden_16,
  t0.number_of_access_to_last_releases AS number_of_access_to_last_releases_17,
  t0.use_html_landing AS use_html_landing_18,
  t0.custom_head AS custom_head_19,
  t0.custom_css AS custom_css_20,
  t0.custom_landing AS custom_landing_21,
  t0.landing_full_width AS landing_full_width_22,
  t0.portal_settings_id AS portal_settings_id_23,
  t0.coupon_default_id AS coupon_default_id_24,
  t25.id AS id_26,
  t25.is_active AS is_active_27,
  t25.short_body AS short_body_28,
  t25.body AS body_29,
  t25.testimonials_custom AS testimonials_custom_30,
  t25.category_name AS category_name_31,
  t25.category_slug AS category_slug_32,
  t25.position AS position_33,
  t25.image_name AS image_name_34,
  t25.banner_name AS banner_name_35,
  t25.banner_link AS banner_link_36,
  t25.banner_html AS banner_html_37,
  t25.updated_at AS updated_at_38,
  t25.default_for_us AS default_for_us_39,
  t25.parent_id AS parent_id_40,
  t25.portal_settings_id AS portal_settings_id_41,
  t25.recommended_product_association_id AS recommended_product_association_id_42,
  t25.language_id AS language_id_43,
  t0.category_master_id AS category_master_id_44,
  t45.id AS id_46,
  t45.is_active AS is_active_47,
  t45.name AS name_48,
  t45.portal_settings_id AS portal_settings_id_49,
  t45.category_id AS category_id_50,
  t45.product_association_id AS product_association_id_51,
  t45.product_main_type_id AS product_main_type_id_52,
  t45.template_type_id AS template_type_id_53,
  t0.product_main_type_id AS product_main_type_id_54,
  t55.id AS id_56,
  t55.title AS title_57,
  t55.description AS description_58,
  t55.head_scripts AS head_scripts_59,
  t55.body_scripts AS body_scripts_60,
  t55.created_at AS created_at_61,
  t55.updated_at AS updated_at_62,
  t55.product_association_id AS product_association_id_63,
  t55.category_id AS category_id_64,
  t55.template_type_id AS template_type_id_65
FROM
  product_association t0
  LEFT JOIN category t25 ON t25.recommended_product_association_id = t0.id
  LEFT JOIN templates t45 ON t45.product_association_id = t0.id
  LEFT JOIN meta_tags t55 ON t55.product_association_id = t0.id
  INNER JOIN product_association_product ON t0.id = product_association_product.product_association_id
WHERE
  product_association_product.product_id = ?

SELECT t0.id AS id_1, t0.preview_fragment AS preview_fragment_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.slug AS slug_5, t0.subtitle AS subtitle_6, t0.frontend_description AS frontend_description_7, t0.frontend_description_short AS frontend_description_short_8, t0.is_recommended AS is_recommended_9, t0.is_most_bought AS is_most_bought_10, t0.logo AS logo_11, t0.background AS background_12, t0.partner_logo AS partner_logo_13, t0.default_quantity_ticket AS default_quantity_ticket_14, t0.custom_scripts AS custom_scripts_15, t0.is_hidden AS is_hidden_16, t0.number_of_access_to_last_releases AS number_of_access_to_last_releases_17, t0.use_html_landing AS use_html_landing_18, t0.custom_head AS custom_head_19, t0.custom_css AS custom_css_20, t0.custom_landing AS custom_landing_21, t0.landing_full_width AS landing_full_width_22, t0.portal_settings_id AS portal_settings_id_23, t0.coupon_default_id AS coupon_default_id_24, t25.id AS id_26, t25.is_active AS is_active_27, t25.short_body AS short_body_28, t25.body AS body_29, t25.testimonials_custom AS testimonials_custom_30, t25.category_name AS category_name_31, t25.category_slug AS category_slug_32, t25.position AS position_33, t25.image_name AS image_name_34, t25.banner_name AS banner_name_35, t25.banner_link AS banner_link_36, t25.banner_html AS banner_html_37, t25.updated_at AS updated_at_38, t25.default_for_us AS default_for_us_39, t25.parent_id AS parent_id_40, t25.portal_settings_id AS portal_settings_id_41, t25.recommended_product_association_id AS recommended_product_association_id_42, t25.language_id AS language_id_43, t0.category_master_id AS category_master_id_44, t45.id AS id_46, t45.is_active AS is_active_47, t45.name AS name_48, t45.portal_settings_id AS portal_settings_id_49, t45.category_id AS category_id_50, t45.product_association_id AS product_association_id_51, t45.product_main_type_id AS product_main_type_id_52, t45.template_type_id AS template_type_id_53, t0.product_main_type_id AS product_main_type_id_54, t55.id AS id_56, t55.title AS title_57, t55.description AS description_58, t55.head_scripts AS head_scripts_59, t55.body_scripts AS body_scripts_60, t55.created_at AS created_at_61, t55.updated_at AS updated_at_62, t55.product_association_id AS product_association_id_63, t55.category_id AS category_id_64, t55.template_type_id AS template_type_id_65 FROM product_association t0 LEFT JOIN category t25 ON t25.recommended_product_association_id = t0.id LEFT JOIN templates t45 ON t45.product_association_id = t0.id LEFT JOIN meta_tags t55 ON t55.product_association_id = t0.id INNER JOIN product_association_product ON t0.id = product_association_product.product_association_id WHERE product_association_product.product_id = 5898;

SELECT t0.id AS id_1, t0.source_system AS source_system_2, t0.is_virtual AS is_virtual_3, t0.is_event AS is_event_4, t0.is_product_premium AS is_product_premium_5, t0.separate_product AS separate_product_6, t0.manual_verification_user AS manual_verification_user_7, t0.description AS description_8, t0.product_no AS product_no_9, t0.department AS department_10, t0.product_state AS product_state_11, t0.vat_rate AS vat_rate_12, t0.discount_online AS discount_online_13, t0.discount_value_online AS discount_value_online_14, t0.state_is_availible AS state_is_availible_15, t0.state_is_forced_reservation AS state_is_forced_reservation_16, t0.state_is_product_test AS state_is_product_test_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.event_place_name AS event_place_name_20, t0.event_place_desc AS event_place_desc_21, t0.product_category_id AS product_category_id_22, t0.product_groups_id AS product_groups_id_23, t0.product_type_id AS product_type_id_24, t0.product_gos_type_id AS product_gos_type_id_25, t0.event_type_id AS event_type_id_26, t27.id AS id_28, t27.title AS title_29, t27.title_sm AS title_sm_30, t27.description AS description_31, t27.description_sm AS description_sm_32, t27.parameters_sm AS parameters_sm_33, t27.link AS link_34, t27.link_gm AS link_gm_35, t27.parameters_fb AS parameters_fb_36, t27.image AS image_37, t27.additional_image AS additional_image_38, t27.mobile_image AS mobile_image_39, t27.brand AS brand_40, t27.brand_sm AS brand_sm_41, t27.product_condition AS product_condition_42, t27.adult AS adult_43, t27.excluded_destination AS excluded_destination_44, t27.included_destination AS included_destination_45, t27.promotion_id AS promotion_id_46, t27.gtin AS gtin_47, t27.updated_at AS updated_at_48, t27.isActive AS isActive_49, t27.google_merchant_category_sm AS google_merchant_category_sm_50, t27.google_merchant_subcategory_sm AS google_merchant_subcategory_sm_51, t27.is_uniqskills AS is_uniqskills_52, t27.is_latino AS is_latino_53, t27.uniqskills_id AS uniqskills_id_54, t27.productURL AS productURL_55, t27.graphicsURL AS graphicsURL_56, t27.categoryURL AS categoryURL_57, t27.custom_label0_id AS custom_label0_id_58, t27.custom_label1_id AS custom_label1_id_59, t27.custom_label2_id AS custom_label2_id_60, t27.custom_label3_id AS custom_label3_id_61, t27.custom_label4_id AS custom_label4_id_62, t27.product_id AS product_id_63, t27.google_merchant_category_id AS google_merchant_category_id_64, t27.google_merchant_product_type_id AS google_merchant_product_type_id_65 FROM product t0 LEFT JOIN google_merchant_feed t27 ON t27.product_id = t0.id INNER JOIN product_association_product ON t0.id = product_association_product.product_id WHERE product_association_product.product_association_id = ?

[
  128
]

SELECT
  t0.id AS id_1,
  t0.source_system AS source_system_2,
  t0.is_virtual AS is_virtual_3,
  t0.is_event AS is_event_4,
  t0.is_product_premium AS is_product_premium_5,
  t0.separate_product AS separate_product_6,
  t0.manual_verification_user AS manual_verification_user_7,
  t0.description AS description_8,
  t0.product_no AS product_no_9,
  t0.department AS department_10,
  t0.product_state AS product_state_11,
  t0.vat_rate AS vat_rate_12,
  t0.discount_online AS discount_online_13,
  t0.discount_value_online AS discount_value_online_14,
  t0.state_is_availible AS state_is_availible_15,
  t0.state_is_forced_reservation AS state_is_forced_reservation_16,
  t0.state_is_product_test AS state_is_product_test_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.event_place_name AS event_place_name_20,
  t0.event_place_desc AS event_place_desc_21,
  t0.product_category_id AS product_category_id_22,
  t0.product_groups_id AS product_groups_id_23,
  t0.product_type_id AS product_type_id_24,
  t0.product_gos_type_id AS product_gos_type_id_25,
  t0.event_type_id AS event_type_id_26,
  t27.id AS id_28,
  t27.title AS title_29,
  t27.title_sm AS title_sm_30,
  t27.description AS description_31,
  t27.description_sm AS description_sm_32,
  t27.parameters_sm AS parameters_sm_33,
  t27.link AS link_34,
  t27.link_gm AS link_gm_35,
  t27.parameters_fb AS parameters_fb_36,
  t27.image AS image_37,
  t27.additional_image AS additional_image_38,
  t27.mobile_image AS mobile_image_39,
  t27.brand AS brand_40,
  t27.brand_sm AS brand_sm_41,
  t27.product_condition AS product_condition_42,
  t27.adult AS adult_43,
  t27.excluded_destination AS excluded_destination_44,
  t27.included_destination AS included_destination_45,
  t27.promotion_id AS promotion_id_46,
  t27.gtin AS gtin_47,
  t27.updated_at AS updated_at_48,
  t27.isActive AS isActive_49,
  t27.google_merchant_category_sm AS google_merchant_category_sm_50,
  t27.google_merchant_subcategory_sm AS google_merchant_subcategory_sm_51,
  t27.is_uniqskills AS is_uniqskills_52,
  t27.is_latino AS is_latino_53,
  t27.uniqskills_id AS uniqskills_id_54,
  t27.productURL AS productURL_55,
  t27.graphicsURL AS graphicsURL_56,
  t27.categoryURL AS categoryURL_57,
  t27.custom_label0_id AS custom_label0_id_58,
  t27.custom_label1_id AS custom_label1_id_59,
  t27.custom_label2_id AS custom_label2_id_60,
  t27.custom_label3_id AS custom_label3_id_61,
  t27.custom_label4_id AS custom_label4_id_62,
  t27.product_id AS product_id_63,
  t27.google_merchant_category_id AS google_merchant_category_id_64,
  t27.google_merchant_product_type_id AS google_merchant_product_type_id_65
FROM
  product t0
  LEFT JOIN google_merchant_feed t27 ON t27.product_id = t0.id
  INNER JOIN product_association_product ON t0.id = product_association_product.product_id
WHERE
  product_association_product.product_association_id = ?

SELECT t0.id AS id_1, t0.source_system AS source_system_2, t0.is_virtual AS is_virtual_3, t0.is_event AS is_event_4, t0.is_product_premium AS is_product_premium_5, t0.separate_product AS separate_product_6, t0.manual_verification_user AS manual_verification_user_7, t0.description AS description_8, t0.product_no AS product_no_9, t0.department AS department_10, t0.product_state AS product_state_11, t0.vat_rate AS vat_rate_12, t0.discount_online AS discount_online_13, t0.discount_value_online AS discount_value_online_14, t0.state_is_availible AS state_is_availible_15, t0.state_is_forced_reservation AS state_is_forced_reservation_16, t0.state_is_product_test AS state_is_product_test_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.event_place_name AS event_place_name_20, t0.event_place_desc AS event_place_desc_21, t0.product_category_id AS product_category_id_22, t0.product_groups_id AS product_groups_id_23, t0.product_type_id AS product_type_id_24, t0.product_gos_type_id AS product_gos_type_id_25, t0.event_type_id AS event_type_id_26, t27.id AS id_28, t27.title AS title_29, t27.title_sm AS title_sm_30, t27.description AS description_31, t27.description_sm AS description_sm_32, t27.parameters_sm AS parameters_sm_33, t27.link AS link_34, t27.link_gm AS link_gm_35, t27.parameters_fb AS parameters_fb_36, t27.image AS image_37, t27.additional_image AS additional_image_38, t27.mobile_image AS mobile_image_39, t27.brand AS brand_40, t27.brand_sm AS brand_sm_41, t27.product_condition AS product_condition_42, t27.adult AS adult_43, t27.excluded_destination AS excluded_destination_44, t27.included_destination AS included_destination_45, t27.promotion_id AS promotion_id_46, t27.gtin AS gtin_47, t27.updated_at AS updated_at_48, t27.isActive AS isActive_49, t27.google_merchant_category_sm AS google_merchant_category_sm_50, t27.google_merchant_subcategory_sm AS google_merchant_subcategory_sm_51, t27.is_uniqskills AS is_uniqskills_52, t27.is_latino AS is_latino_53, t27.uniqskills_id AS uniqskills_id_54, t27.productURL AS productURL_55, t27.graphicsURL AS graphicsURL_56, t27.categoryURL AS categoryURL_57, t27.custom_label0_id AS custom_label0_id_58, t27.custom_label1_id AS custom_label1_id_59, t27.custom_label2_id AS custom_label2_id_60, t27.custom_label3_id AS custom_label3_id_61, t27.custom_label4_id AS custom_label4_id_62, t27.product_id AS product_id_63, t27.google_merchant_category_id AS google_merchant_category_id_64, t27.google_merchant_product_type_id AS google_merchant_product_type_id_65 FROM product t0 LEFT JOIN google_merchant_feed t27 ON t27.product_id = t0.id INNER JOIN product_association_product ON t0.id = product_association_product.product_id WHERE product_association_product.product_association_id = 128;

SELECT t0.id AS id_1, t0.preview_fragment AS preview_fragment_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.slug AS slug_5, t0.subtitle AS subtitle_6, t0.frontend_description AS frontend_description_7, t0.frontend_description_short AS frontend_description_short_8, t0.is_recommended AS is_recommended_9, t0.is_most_bought AS is_most_bought_10, t0.logo AS logo_11, t0.background AS background_12, t0.partner_logo AS partner_logo_13, t0.default_quantity_ticket AS default_quantity_ticket_14, t0.custom_scripts AS custom_scripts_15, t0.is_hidden AS is_hidden_16, t0.number_of_access_to_last_releases AS number_of_access_to_last_releases_17, t0.use_html_landing AS use_html_landing_18, t0.custom_head AS custom_head_19, t0.custom_css AS custom_css_20, t0.custom_landing AS custom_landing_21, t0.landing_full_width AS landing_full_width_22, t0.portal_settings_id AS portal_settings_id_23, t0.coupon_default_id AS coupon_default_id_24, t25.id AS id_26, t25.is_active AS is_active_27, t25.short_body AS short_body_28, t25.body AS body_29, t25.testimonials_custom AS testimonials_custom_30, t25.category_name AS category_name_31, t25.category_slug AS category_slug_32, t25.position AS position_33, t25.image_name AS image_name_34, t25.banner_name AS banner_name_35, t25.banner_link AS banner_link_36, t25.banner_html AS banner_html_37, t25.updated_at AS updated_at_38, t25.default_for_us AS default_for_us_39, t25.parent_id AS parent_id_40, t25.portal_settings_id AS portal_settings_id_41, t25.recommended_product_association_id AS recommended_product_association_id_42, t25.language_id AS language_id_43, t0.category_master_id AS category_master_id_44, t45.id AS id_46, t45.is_active AS is_active_47, t45.name AS name_48, t45.portal_settings_id AS portal_settings_id_49, t45.category_id AS category_id_50, t45.product_association_id AS product_association_id_51, t45.product_main_type_id AS product_main_type_id_52, t45.template_type_id AS template_type_id_53, t0.product_main_type_id AS product_main_type_id_54, t55.id AS id_56, t55.title AS title_57, t55.description AS description_58, t55.head_scripts AS head_scripts_59, t55.body_scripts AS body_scripts_60, t55.created_at AS created_at_61, t55.updated_at AS updated_at_62, t55.product_association_id AS product_association_id_63, t55.category_id AS category_id_64, t55.template_type_id AS template_type_id_65 FROM product_association t0 LEFT JOIN category t25 ON t25.recommended_product_association_id = t0.id LEFT JOIN templates t45 ON t45.product_association_id = t0.id LEFT JOIN meta_tags t55 ON t55.product_association_id = t0.id INNER JOIN category_product_association ON t0.id = category_product_association.product_association_id WHERE category_product_association.category_id = ?

[
  7
]

SELECT
  t0.id AS id_1,
  t0.preview_fragment AS preview_fragment_2,
  t0.updated_at AS updated_at_3,
  t0.title AS title_4,
  t0.slug AS slug_5,
  t0.subtitle AS subtitle_6,
  t0.frontend_description AS frontend_description_7,
  t0.frontend_description_short AS frontend_description_short_8,
  t0.is_recommended AS is_recommended_9,
  t0.is_most_bought AS is_most_bought_10,
  t0.logo AS logo_11,
  t0.background AS background_12,
  t0.partner_logo AS partner_logo_13,
  t0.default_quantity_ticket AS default_quantity_ticket_14,
  t0.custom_scripts AS custom_scripts_15,
  t0.is_hidden AS is_hidden_16,
  t0.number_of_access_to_last_releases AS number_of_access_to_last_releases_17,
  t0.use_html_landing AS use_html_landing_18,
  t0.custom_head AS custom_head_19,
  t0.custom_css AS custom_css_20,
  t0.custom_landing AS custom_landing_21,
  t0.landing_full_width AS landing_full_width_22,
  t0.portal_settings_id AS portal_settings_id_23,
  t0.coupon_default_id AS coupon_default_id_24,
  t25.id AS id_26,
  t25.is_active AS is_active_27,
  t25.short_body AS short_body_28,
  t25.body AS body_29,
  t25.testimonials_custom AS testimonials_custom_30,
  t25.category_name AS category_name_31,
  t25.category_slug AS category_slug_32,
  t25.position AS position_33,
  t25.image_name AS image_name_34,
  t25.banner_name AS banner_name_35,
  t25.banner_link AS banner_link_36,
  t25.banner_html AS banner_html_37,
  t25.updated_at AS updated_at_38,
  t25.default_for_us AS default_for_us_39,
  t25.parent_id AS parent_id_40,
  t25.portal_settings_id AS portal_settings_id_41,
  t25.recommended_product_association_id AS recommended_product_association_id_42,
  t25.language_id AS language_id_43,
  t0.category_master_id AS category_master_id_44,
  t45.id AS id_46,
  t45.is_active AS is_active_47,
  t45.name AS name_48,
  t45.portal_settings_id AS portal_settings_id_49,
  t45.category_id AS category_id_50,
  t45.product_association_id AS product_association_id_51,
  t45.product_main_type_id AS product_main_type_id_52,
  t45.template_type_id AS template_type_id_53,
  t0.product_main_type_id AS product_main_type_id_54,
  t55.id AS id_56,
  t55.title AS title_57,
  t55.description AS description_58,
  t55.head_scripts AS head_scripts_59,
  t55.body_scripts AS body_scripts_60,
  t55.created_at AS created_at_61,
  t55.updated_at AS updated_at_62,
  t55.product_association_id AS product_association_id_63,
  t55.category_id AS category_id_64,
  t55.template_type_id AS template_type_id_65
FROM
  product_association t0
  LEFT JOIN category t25 ON t25.recommended_product_association_id = t0.id
  LEFT JOIN templates t45 ON t45.product_association_id = t0.id
  LEFT JOIN meta_tags t55 ON t55.product_association_id = t0.id
  INNER JOIN category_product_association ON t0.id = category_product_association.product_association_id
WHERE
  category_product_association.category_id = ?

SELECT t0.id AS id_1, t0.preview_fragment AS preview_fragment_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.slug AS slug_5, t0.subtitle AS subtitle_6, t0.frontend_description AS frontend_description_7, t0.frontend_description_short AS frontend_description_short_8, t0.is_recommended AS is_recommended_9, t0.is_most_bought AS is_most_bought_10, t0.logo AS logo_11, t0.background AS background_12, t0.partner_logo AS partner_logo_13, t0.default_quantity_ticket AS default_quantity_ticket_14, t0.custom_scripts AS custom_scripts_15, t0.is_hidden AS is_hidden_16, t0.number_of_access_to_last_releases AS number_of_access_to_last_releases_17, t0.use_html_landing AS use_html_landing_18, t0.custom_head AS custom_head_19, t0.custom_css AS custom_css_20, t0.custom_landing AS custom_landing_21, t0.landing_full_width AS landing_full_width_22, t0.portal_settings_id AS portal_settings_id_23, t0.coupon_default_id AS coupon_default_id_24, t25.id AS id_26, t25.is_active AS is_active_27, t25.short_body AS short_body_28, t25.body AS body_29, t25.testimonials_custom AS testimonials_custom_30, t25.category_name AS category_name_31, t25.category_slug AS category_slug_32, t25.position AS position_33, t25.image_name AS image_name_34, t25.banner_name AS banner_name_35, t25.banner_link AS banner_link_36, t25.banner_html AS banner_html_37, t25.updated_at AS updated_at_38, t25.default_for_us AS default_for_us_39, t25.parent_id AS parent_id_40, t25.portal_settings_id AS portal_settings_id_41, t25.recommended_product_association_id AS recommended_product_association_id_42, t25.language_id AS language_id_43, t0.category_master_id AS category_master_id_44, t45.id AS id_46, t45.is_active AS is_active_47, t45.name AS name_48, t45.portal_settings_id AS portal_settings_id_49, t45.category_id AS category_id_50, t45.product_association_id AS product_association_id_51, t45.product_main_type_id AS product_main_type_id_52, t45.template_type_id AS template_type_id_53, t0.product_main_type_id AS product_main_type_id_54, t55.id AS id_56, t55.title AS title_57, t55.description AS description_58, t55.head_scripts AS head_scripts_59, t55.body_scripts AS body_scripts_60, t55.created_at AS created_at_61, t55.updated_at AS updated_at_62, t55.product_association_id AS product_association_id_63, t55.category_id AS category_id_64, t55.template_type_id AS template_type_id_65 FROM product_association t0 LEFT JOIN category t25 ON t25.recommended_product_association_id = t0.id LEFT JOIN templates t45 ON t45.product_association_id = t0.id LEFT JOIN meta_tags t55 ON t55.product_association_id = t0.id INNER JOIN category_product_association ON t0.id = category_product_association.product_association_id WHERE category_product_association.category_id = 7;

SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1, p0_.technical_name AS technical_name_2, p0_.slug AS slug_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5 FROM product_main_type p0_ LEFT JOIN product_association p1_ ON p0_.id = p1_.product_main_type_id LEFT JOIN templates t2_ ON p1_.id = t2_.product_association_id LEFT JOIN category c3_ ON p1_.category_master_id = c3_.id LEFT JOIN category_product_association c5_ ON p1_.id = c5_.product_association_id LEFT JOIN category c4_ ON c4_.id = c5_.category_id LEFT JOIN templates t6_ ON c4_.id = t6_.category_id LEFT JOIN category c7_ ON c4_.parent_id = c7_.id LEFT JOIN templates t8_ ON c7_.id = t8_.category_id LEFT JOIN templates t9_ ON c3_.id = t9_.category_id LEFT JOIN category c10_ ON c3_.parent_id = c10_.id LEFT JOIN templates t11_ ON c10_.id = t11_.category_id LEFT JOIN portal_settings p12_ ON p1_.portal_settings_id = p12_.id LEFT JOIN templates t13_ ON p12_.id = t13_.portal_settings_id LEFT JOIN templates t14_ ON p0_.id = t14_.product_main_type_id WHERE (c3_.id = ? OR c10_.id = ? OR c4_.id = ? OR c7_.id = ?) AND p1_.title IS NOT NULL AND (p1_.is_hidden IS NULL OR p1_.is_hidden = 0) AND (t2_.is_active = 1 OR t9_.is_active = 1 OR t11_.is_active = 1 OR t6_.is_active = 1 OR t8_.is_active = 1 OR t13_.is_active = 1 OR t14_.is_active = 1)

[
  1
  1
  1
  1
]

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.technical_name AS technical_name_2,
  p0_.slug AS slug_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5
FROM
  product_main_type p0_
  LEFT JOIN product_association p1_ ON p0_.id = p1_.product_main_type_id
  LEFT JOIN templates t2_ ON p1_.id = t2_.product_association_id
  LEFT JOIN category c3_ ON p1_.category_master_id = c3_.id
  LEFT JOIN category_product_association c5_ ON p1_.id = c5_.product_association_id
  LEFT JOIN category c4_ ON c4_.id = c5_.category_id
  LEFT JOIN templates t6_ ON c4_.id = t6_.category_id
  LEFT JOIN category c7_ ON c4_.parent_id = c7_.id
  LEFT JOIN templates t8_ ON c7_.id = t8_.category_id
  LEFT JOIN templates t9_ ON c3_.id = t9_.category_id
  LEFT JOIN category c10_ ON c3_.parent_id = c10_.id
  LEFT JOIN templates t11_ ON c10_.id = t11_.category_id
  LEFT JOIN portal_settings p12_ ON p1_.portal_settings_id = p12_.id
  LEFT JOIN templates t13_ ON p12_.id = t13_.portal_settings_id
  LEFT JOIN templates t14_ ON p0_.id = t14_.product_main_type_id
WHERE
  (
    c3_.id = ?
    OR c10_.id = ?
    OR c4_.id = ?
    OR c7_.id = ?
  )
  AND p1_.title IS NOT NULL
  AND (
    p1_.is_hidden IS NULL
    OR p1_.is_hidden = 0
  )
  AND (
    t2_.is_active = 1
    OR t9_.is_active = 1
    OR t11_.is_active = 1
    OR t6_.is_active = 1
    OR t8_.is_active = 1
    OR t13_.is_active = 1
    OR t14_.is_active = 1
  )

SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1, p0_.technical_name AS technical_name_2, p0_.slug AS slug_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5 FROM product_main_type p0_ LEFT JOIN product_association p1_ ON p0_.id = p1_.product_main_type_id LEFT JOIN templates t2_ ON p1_.id = t2_.product_association_id LEFT JOIN category c3_ ON p1_.category_master_id = c3_.id LEFT JOIN category_product_association c5_ ON p1_.id = c5_.product_association_id LEFT JOIN category c4_ ON c4_.id = c5_.category_id LEFT JOIN templates t6_ ON c4_.id = t6_.category_id LEFT JOIN category c7_ ON c4_.parent_id = c7_.id LEFT JOIN templates t8_ ON c7_.id = t8_.category_id LEFT JOIN templates t9_ ON c3_.id = t9_.category_id LEFT JOIN category c10_ ON c3_.parent_id = c10_.id LEFT JOIN templates t11_ ON c10_.id = t11_.category_id LEFT JOIN portal_settings p12_ ON p1_.portal_settings_id = p12_.id LEFT JOIN templates t13_ ON p12_.id = t13_.portal_settings_id LEFT JOIN templates t14_ ON p0_.id = t14_.product_main_type_id WHERE (c3_.id = 1 OR c10_.id = 1 OR c4_.id = 1 OR c7_.id = 1) AND p1_.title IS NOT NULL AND (p1_.is_hidden IS NULL OR p1_.is_hidden = 0) AND (t2_.is_active = 1 OR t9_.is_active = 1 OR t11_.is_active = 1 OR t6_.is_active = 1 OR t8_.is_active = 1 OR t13_.is_active = 1 OR t14_.is_active = 1);

SELECT t0.id AS id_1, t0.position AS position_2, t0.image AS image_3, t0.updated_at AS updated_at_4, t0.product_association_id AS product_association_id_5 FROM product_image t0 WHERE t0.product_association_id = ? ORDER BY t0.position ASC

[
  123
]

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.image AS image_3,
  t0.updated_at AS updated_at_4,
  t0.product_association_id AS product_association_id_5
FROM
  product_image t0
WHERE
  t0.product_association_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.image AS image_3, t0.updated_at AS updated_at_4, t0.product_association_id AS product_association_id_5 FROM product_image t0 WHERE t0.product_association_id = 123 ORDER BY t0.position ASC;

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.portal_settings_id AS portal_settings_id_4, t0.category_id AS category_id_5, t0.product_association_id AS product_association_id_6, t0.product_main_type_id AS product_main_type_id_7, t0.template_type_id AS template_type_id_8 FROM templates t0 WHERE t0.id = ?

[
  "61"
]

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.portal_settings_id AS portal_settings_id_4,
  t0.category_id AS category_id_5,
  t0.product_association_id AS product_association_id_6,
  t0.product_main_type_id AS product_main_type_id_7,
  t0.template_type_id AS template_type_id_8
FROM
  templates t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.portal_settings_id AS portal_settings_id_4, t0.category_id AS category_id_5, t0.product_association_id AS product_association_id_6, t0.product_main_type_id AS product_main_type_id_7, t0.template_type_id AS template_type_id_8 FROM templates t0 WHERE t0.id = '61';

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_default AS is_default_3, t0.enabled_to_link AS enabled_to_link_4, t5.id AS id_6, t5.title AS title_7, t5.description AS description_8, t5.head_scripts AS head_scripts_9, t5.body_scripts AS body_scripts_10, t5.created_at AS created_at_11, t5.updated_at AS updated_at_12, t5.product_association_id AS product_association_id_13, t5.category_id AS category_id_14, t5.template_type_id AS template_type_id_15 FROM template_type t0 LEFT JOIN meta_tags t5 ON t5.template_type_id = t0.id WHERE t0.id = ?

[
  10
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_default AS is_default_3,
  t0.enabled_to_link AS enabled_to_link_4,
  t5.id AS id_6,
  t5.title AS title_7,
  t5.description AS description_8,
  t5.head_scripts AS head_scripts_9,
  t5.body_scripts AS body_scripts_10,
  t5.created_at AS created_at_11,
  t5.updated_at AS updated_at_12,
  t5.product_association_id AS product_association_id_13,
  t5.category_id AS category_id_14,
  t5.template_type_id AS template_type_id_15
FROM
  template_type t0
  LEFT JOIN meta_tags t5 ON t5.template_type_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_default AS is_default_3, t0.enabled_to_link AS enabled_to_link_4, t5.id AS id_6, t5.title AS title_7, t5.description AS description_8, t5.head_scripts AS head_scripts_9, t5.body_scripts AS body_scripts_10, t5.created_at AS created_at_11, t5.updated_at AS updated_at_12, t5.product_association_id AS product_association_id_13, t5.category_id AS category_id_14, t5.template_type_id AS template_type_id_15 FROM template_type t0 LEFT JOIN meta_tags t5 ON t5.template_type_id = t0.id WHERE t0.id = 10;

SELECT t0.id AS id_1, t0.json AS json_2, t0.product_association_id AS product_association_id_3, t0.tmpl_item_id AS tmpl_item_id_4, t0.tmpl_module_id AS tmpl_module_id_5 FROM tmpl_module_contents t0 WHERE t0.tmpl_item_id = ? AND t0.product_association_id = ? AND t0.tmpl_module_id = ? LIMIT 1

[
  26
  128
  11
]

SELECT
  t0.id AS id_1,
  t0.json AS json_2,
  t0.product_association_id AS product_association_id_3,
  t0.tmpl_item_id AS tmpl_item_id_4,
  t0.tmpl_module_id AS tmpl_module_id_5
FROM
  tmpl_module_contents t0
WHERE
  t0.tmpl_item_id = ?
  AND t0.product_association_id = ?
  AND t0.tmpl_module_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.json AS json_2, t0.product_association_id AS product_association_id_3, t0.tmpl_item_id AS tmpl_item_id_4, t0.tmpl_module_id AS tmpl_module_id_5 FROM tmpl_module_contents t0 WHERE t0.tmpl_item_id = 26 AND t0.product_association_id = 128 AND t0.tmpl_module_id = 11 LIMIT 1;

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.country_id AS country_id_99, t0.payment_type_id AS payment_type_id_100, t0.product_subscription_type_id AS product_subscription_type_id_101, t0.product_variant_eu_vat_id AS product_variant_eu_vat_id_102, t103.id AS id_104, t103.isVirtual AS isVirtual_105, t103.is_test AS is_test_106, t103.product_variant_no AS product_variant_no_107, t103.product_number_no_tax AS product_number_no_tax_108, t103.product_number_part_tax AS product_number_part_tax_109, t103.product_variant_id AS product_variant_id_110, t103.product_variant_no_complete AS product_variant_no_complete_111, t103.product_variant_key AS product_variant_key_112, t103.variant_state AS variant_state_113, t103.tittle_on_invoice AS tittle_on_invoice_114, t103.working_title AS working_title_115, t103.price_net AS price_net_116, t103.price_gross AS price_gross_117, t103.trade_name AS trade_name_118, t103.alt_trade_name AS alt_trade_name_119, t103.technical_informations AS technical_informations_120, t103.technical_information_for_mail AS technical_information_for_mail_121, t103.label AS label_122, t103.is_gross AS is_gross_123, t103.currency_code AS currency_code_124, t103.postage_type AS postage_type_125, t103.postage_cost AS postage_cost_126, t103.total_weight AS total_weight_127, t103.series_type AS series_type_128, t103.is_default AS is_default_129, t103.tax_free_for_budget_unit AS tax_free_for_budget_unit_130, t103.product_number_for_budget_unit AS product_number_for_budget_unit_131, t103.show_gross_price AS show_gross_price_132, t103.discount_online AS discount_online_133, t103.discount_value_online AS discount_value_online_134, t103.state_is_availible AS state_is_availible_135, t103.state_is_forced_reservation AS state_is_forced_reservation_136, t103.state_is_product_test AS state_is_product_test_137, t103.state_is_trial_recurring AS state_is_trial_recurring_138, t103.trial_recurring_duration AS trial_recurring_duration_139, t103.is_access_without_payment AS is_access_without_payment_140, t103.buy_max_one AS buy_max_one_141, t103.is_addition AS is_addition_142, t103.max_users AS max_users_143, t103.quantity AS quantity_144, t103.order_quantity AS order_quantity_145, t103.event_date AS event_date_146, t103.created_at AS created_at_147, t103.updated_at AS updated_at_148, t103.subscription_type AS subscription_type_149, t103.subscription_plan AS subscription_plan_150, t103.image AS image_151, t103.default_product_association AS default_product_association_152, t103.promoted AS promoted_153, t103.is_published AS is_published_154, t103.is_giftable AS is_giftable_155, t103.is_hidden AS is_hidden_156, t103.is_partial_payment_active AS is_partial_payment_active_157, t103.installment_amount AS installment_amount_158, t103.extended_payment_time AS extended_payment_time_159, t103.summary_upselling_info AS summary_upselling_info_160, t103.trial_duration AS trial_duration_161, t103.required_pwz AS required_pwz_162, t103.promo_name AS promo_name_163, t103.is_digital AS is_digital_164, t103.block_access AS block_access_165, t103.mantis_user_id AS mantis_user_id_166, t103.sales_variant_based_trial_duration AS sales_variant_based_trial_duration_167, t103.sales_variant_based_trial_info AS sales_variant_based_trial_info_168, t103.access_for_paid_only AS access_for_paid_only_169, t103.additional_text_in_cart AS additional_text_in_cart_170, t103.is_recurring_subscription AS is_recurring_subscription_171, t103.document_distribution_channel AS document_distribution_channel_172, t103.hidden_in_sbtill_paid AS hidden_in_sbtill_paid_173, t103.participants_address AS participants_address_174, t103.participants_announcement AS participants_announcement_175, t103.must_have_all_exclusive_variants AS must_have_all_exclusive_variants_176, t103.trade_name_sm AS trade_name_sm_177, t103.comment_for_mantis AS comment_for_mantis_178, t103.coupon_lifetime AS coupon_lifetime_179, t103.fresh_mail_integration AS fresh_mail_integration_180, t103.fresh_mail_recipient_list_hash AS fresh_mail_recipient_list_hash_181, t103.order_on_site_content AS order_on_site_content_182, t103.manual_user_verification AS manual_user_verification_183, t103.image_url_upselling AS image_url_upselling_184, t103.use_uploaded_image_upselling AS use_uploaded_image_upselling_185, t103.uploaded_image_upselling AS uploaded_image_upselling_186, t103.description_upselling AS description_upselling_187, t103.link_to_product_upselling AS link_to_product_upselling_188, t103.show_button_additional_address AS show_button_additional_address_189, t103.max_quantity_in_cart AS max_quantity_in_cart_190, t103.exclude_default_shipping_type AS exclude_default_shipping_type_191, t103.is_completely_digital AS is_completely_digital_192, t103.has_paper_release AS has_paper_release_193, t103.is_npwzrequired AS is_npwzrequired_194, t103.is_sale_disabled AS is_sale_disabled_195, t103.technical_information_for_mail_tele AS technical_information_for_mail_tele_196, t103.additional_information_for_mail AS additional_information_for_mail_197, t103.description_upselling_max_height AS description_upselling_max_height_198, t103.bur_funding_product_variant_id AS bur_funding_product_variant_id_199, t103.product_variant_after_trial_recurring_end_id AS product_variant_after_trial_recurring_end_id_200, t103.master_product_id AS master_product_id_201, t103.country_id AS country_id_202, t103.payment_type_id AS payment_type_id_203, t103.product_subscription_type_id AS product_subscription_type_id_204, t103.product_variant_eu_vat_id AS product_variant_eu_vat_id_205, t103.feed_id AS feed_id_206, t103.events_id AS events_id_207, t103.size_id AS size_id_208, t103.original_id AS original_id_209, t103.additional_access_product_variant_id AS additional_access_product_variant_id_210, t0.feed_id AS feed_id_211, t212.id AS id_213, t212.title AS title_214, t212.title_sm AS title_sm_215, t212.description AS description_216, t212.description_sm AS description_sm_217, t212.parameters_sm AS parameters_sm_218, t212.link AS link_219, t212.link_gm AS link_gm_220, t212.parameters_fb AS parameters_fb_221, t212.image AS image_222, t212.additional_image AS additional_image_223, t212.mobile_image AS mobile_image_224, t212.brand AS brand_225, t212.brand_sm AS brand_sm_226, t212.product_condition AS product_condition_227, t212.adult AS adult_228, t212.excluded_destination AS excluded_destination_229, t212.included_destination AS included_destination_230, t212.promotion_id AS promotion_id_231, t212.gtin AS gtin_232, t212.updated_at AS updated_at_233, t212.isActive AS isActive_234, t212.google_merchant_category_sm AS google_merchant_category_sm_235, t212.google_merchant_subcategory_sm AS google_merchant_subcategory_sm_236, t212.is_uniqskills AS is_uniqskills_237, t212.is_latino AS is_latino_238, t212.uniqskills_id AS uniqskills_id_239, t212.productURL AS productURL_240, t212.graphicsURL AS graphicsURL_241, t212.categoryURL AS categoryURL_242, t212.custom_label0_id AS custom_label0_id_243, t212.custom_label1_id AS custom_label1_id_244, t212.custom_label2_id AS custom_label2_id_245, t212.custom_label3_id AS custom_label3_id_246, t212.custom_label4_id AS custom_label4_id_247, t212.product_id AS product_id_248, t212.google_merchant_category_id AS google_merchant_category_id_249, t212.google_merchant_product_type_id AS google_merchant_product_type_id_250, t0.events_id AS events_id_251, t252.id AS id_253, t252.name AS name_254, t252.created_at AS created_at_255, t252.updated_at AS updated_at_256, t252.start_at AS start_at_257, t252.event_address AS event_address_258, t252.event_city AS event_city_259, t252.fanpage AS fanpage_260, t252.poll_link AS poll_link_261, t252.conference_lectures_link AS conference_lectures_link_262, t252.website AS website_263, t252.organizational_file_name AS organizational_file_name_264, t252.only_present_are_certified AS only_present_are_certified_265, t252.google_calendar_url AS google_calendar_url_266, t252.outlook_calendar_url AS outlook_calendar_url_267, t252.i_cal_calendar_file_name AS i_cal_calendar_file_name_268, t252.dont_send_notifications AS dont_send_notifications_269, t252.send_event_shop_notifications AS send_event_shop_notifications_270, t252.meeting_link AS meeting_link_271, t252.countdown_timer AS countdown_timer_272, t252.is_nano AS is_nano_273, t252.next_event_id AS next_event_id_274, t252.event_type_id AS event_type_id_275, t252.event_formula_id AS event_formula_id_276, t252.event_platform_id AS event_platform_id_277, t278.id AS id_279, t278.order_quantity AS order_quantity_280, t278.product_variant_id AS product_variant_id_281, t282.id AS id_283, t282.virtual_currency_on_buy_allow AS virtual_currency_on_buy_allow_284, t282.virtual_currency_on_buy_valid_for AS virtual_currency_on_buy_valid_for_285, t282.virtual_currency_on_buy_amount AS virtual_currency_on_buy_amount_286, t282.virtual_currency_on_buy_amount_is_unlimited AS virtual_currency_on_buy_amount_is_unlimited_287, t282.virtual_currency_on_pay_allow AS virtual_currency_on_pay_allow_288, t282.virtual_currency_on_pay_access_days AS virtual_currency_on_pay_access_days_289, t282.virtual_currency_on_pay_amount AS virtual_currency_on_pay_amount_290, t282.created_at AS created_at_291, t282.updated_at AS updated_at_292, t282.product_variant_id AS product_variant_id_293, t282.virtual_currency_on_buy_id AS virtual_currency_on_buy_id_294, t282.virtual_currency_on_pay_id AS virtual_currency_on_pay_id_295, t0.size_id AS size_id_296, t297.id AS id_298, t297.name AS name_299, t297.category AS category_300, t297.description AS description_301, t297.product_url AS product_url_302, t297.bestseller AS bestseller_303, t297.new_product AS new_product_304, t297.discount_price AS discount_price_305, t297.main_image_url AS main_image_url_306, t297.use_uploaded_main_image AS use_uploaded_main_image_307, t297.uploaded_main_image AS uploaded_main_image_308, t297.updated_at AS updated_at_309, t297.product_variant_id AS product_variant_id_310, t0.original_id AS original_id_311, t0.additional_access_product_variant_id AS additional_access_product_variant_id_312, t313.id AS id_314, t313.isVirtual AS isVirtual_315, t313.is_test AS is_test_316, t313.product_variant_no AS product_variant_no_317, t313.product_number_no_tax AS product_number_no_tax_318, t313.product_number_part_tax AS product_number_part_tax_319, t313.product_variant_id AS product_variant_id_320, t313.product_variant_no_complete AS product_variant_no_complete_321, t313.product_variant_key AS product_variant_key_322, t313.variant_state AS variant_state_323, t313.tittle_on_invoice AS tittle_on_invoice_324, t313.working_title AS working_title_325, t313.price_net AS price_net_326, t313.price_gross AS price_gross_327, t313.trade_name AS trade_name_328, t313.alt_trade_name AS alt_trade_name_329, t313.technical_informations AS technical_informations_330, t313.technical_information_for_mail AS technical_information_for_mail_331, t313.label AS label_332, t313.is_gross AS is_gross_333, t313.currency_code AS currency_code_334, t313.postage_type AS postage_type_335, t313.postage_cost AS postage_cost_336, t313.total_weight AS total_weight_337, t313.series_type AS series_type_338, t313.is_default AS is_default_339, t313.tax_free_for_budget_unit AS tax_free_for_budget_unit_340, t313.product_number_for_budget_unit AS product_number_for_budget_unit_341, t313.show_gross_price AS show_gross_price_342, t313.discount_online AS discount_online_343, t313.discount_value_online AS discount_value_online_344, t313.state_is_availible AS state_is_availible_345, t313.state_is_forced_reservation AS state_is_forced_reservation_346, t313.state_is_product_test AS state_is_product_test_347, t313.state_is_trial_recurring AS state_is_trial_recurring_348, t313.trial_recurring_duration AS trial_recurring_duration_349, t313.is_access_without_payment AS is_access_without_payment_350, t313.buy_max_one AS buy_max_one_351, t313.is_addition AS is_addition_352, t313.max_users AS max_users_353, t313.quantity AS quantity_354, t313.order_quantity AS order_quantity_355, t313.event_date AS event_date_356, t313.created_at AS created_at_357, t313.updated_at AS updated_at_358, t313.subscription_type AS subscription_type_359, t313.subscription_plan AS subscription_plan_360, t313.image AS image_361, t313.default_product_association AS default_product_association_362, t313.promoted AS promoted_363, t313.is_published AS is_published_364, t313.is_giftable AS is_giftable_365, t313.is_hidden AS is_hidden_366, t313.is_partial_payment_active AS is_partial_payment_active_367, t313.installment_amount AS installment_amount_368, t313.extended_payment_time AS extended_payment_time_369, t313.summary_upselling_info AS summary_upselling_info_370, t313.trial_duration AS trial_duration_371, t313.required_pwz AS required_pwz_372, t313.promo_name AS promo_name_373, t313.is_digital AS is_digital_374, t313.block_access AS block_access_375, t313.mantis_user_id AS mantis_user_id_376, t313.sales_variant_based_trial_duration AS sales_variant_based_trial_duration_377, t313.sales_variant_based_trial_info AS sales_variant_based_trial_info_378, t313.access_for_paid_only AS access_for_paid_only_379, t313.additional_text_in_cart AS additional_text_in_cart_380, t313.is_recurring_subscription AS is_recurring_subscription_381, t313.document_distribution_channel AS document_distribution_channel_382, t313.hidden_in_sbtill_paid AS hidden_in_sbtill_paid_383, t313.participants_address AS participants_address_384, t313.participants_announcement AS participants_announcement_385, t313.must_have_all_exclusive_variants AS must_have_all_exclusive_variants_386, t313.trade_name_sm AS trade_name_sm_387, t313.comment_for_mantis AS comment_for_mantis_388, t313.coupon_lifetime AS coupon_lifetime_389, t313.fresh_mail_integration AS fresh_mail_integration_390, t313.fresh_mail_recipient_list_hash AS fresh_mail_recipient_list_hash_391, t313.order_on_site_content AS order_on_site_content_392, t313.manual_user_verification AS manual_user_verification_393, t313.image_url_upselling AS image_url_upselling_394, t313.use_uploaded_image_upselling AS use_uploaded_image_upselling_395, t313.uploaded_image_upselling AS uploaded_image_upselling_396, t313.description_upselling AS description_upselling_397, t313.link_to_product_upselling AS link_to_product_upselling_398, t313.show_button_additional_address AS show_button_additional_address_399, t313.max_quantity_in_cart AS max_quantity_in_cart_400, t313.exclude_default_shipping_type AS exclude_default_shipping_type_401, t313.is_completely_digital AS is_completely_digital_402, t313.has_paper_release AS has_paper_release_403, t313.is_npwzrequired AS is_npwzrequired_404, t313.is_sale_disabled AS is_sale_disabled_405, t313.technical_information_for_mail_tele AS technical_information_for_mail_tele_406, t313.additional_information_for_mail AS additional_information_for_mail_407, t313.description_upselling_max_height AS description_upselling_max_height_408, t313.bur_funding_product_variant_id AS bur_funding_product_variant_id_409, t313.product_variant_after_trial_recurring_end_id AS product_variant_after_trial_recurring_end_id_410, t313.master_product_id AS master_product_id_411, t313.country_id AS country_id_412, t313.payment_type_id AS payment_type_id_413, t313.product_subscription_type_id AS product_subscription_type_id_414, t313.product_variant_eu_vat_id AS product_variant_eu_vat_id_415, t313.feed_id AS feed_id_416, t313.events_id AS events_id_417, t313.size_id AS size_id_418, t313.original_id AS original_id_419, t313.additional_access_product_variant_id AS additional_access_product_variant_id_420 FROM product_variant t0 LEFT JOIN product_variant t103 ON t103.product_variant_eu_vat_id = t0.id LEFT JOIN google_merchant_feed t212 ON t0.feed_id = t212.id LEFT JOIN events t252 ON t0.events_id = t252.id LEFT JOIN product_variant_order_quantity t278 ON t278.product_variant_id = t0.id LEFT JOIN product_variant_virtual_currency_settings t282 ON t282.product_variant_id = t0.id LEFT JOIN sales_manago_product_variant t297 ON t297.product_variant_id = t0.id LEFT JOIN product_variant t313 ON t313.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 = ?