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 = ?

[
  371
]

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 = 371;

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 = ?

[
  130
]

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 = 130;

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.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.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.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.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
  130
  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 = 130 AND t0.tmpl_module_id = 11 LIMIT 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.parent_id = ? ORDER BY t0.position ASC

[
  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.parent_id = ?
ORDER BY
  t0.position ASC

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 = 1 ORDER BY t0.position ASC;

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_association_product_variant ON t0.id = product_association_product_variant.product_variant_id WHERE product_association_product_variant.product_association_id = ?