Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.is_active AS is_active_1,
  t0_.name AS name_2,
  t0_.portal_settings_id AS portal_settings_id_3,
  t0_.category_id AS category_id_4,
  t0_.product_association_id AS product_association_id_5,
  t0_.product_main_type_id AS product_main_type_id_6,
  t0_.template_type_id AS template_type_id_7
FROM
  templates t0_
  LEFT JOIN template_type t1_ ON t0_.template_type_id = t1_.id
WHERE
  t1_.name = ?
  AND t1_.enabled_to_link = 1
LIMIT
  1

SELECT t0_.id AS id_0, t0_.is_active AS is_active_1, t0_.name AS name_2, t0_.portal_settings_id AS portal_settings_id_3, t0_.category_id AS category_id_4, t0_.product_association_id AS product_association_id_5, t0_.product_main_type_id AS product_main_type_id_6, t0_.template_type_id AS template_type_id_7 FROM templates t0_ LEFT JOIN template_type t1_ ON t0_.template_type_id = t1_.id WHERE t1_.name = 'strona-glowna' AND t1_.enabled_to_link = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.is_active AS is_active_3,
  t0.template_id AS template_id_4,
  t0.tmpl_module_id AS tmpl_module_id_5
FROM
  tmpl_items t0
WHERE
  t0.template_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.is_active AS is_active_3, t0.template_id AS template_id_4, t0.tmpl_module_id AS tmpl_module_id_5 FROM tmpl_items t0 WHERE t0.template_id = 52 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 IS NULL
  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 = 10 AND t0.product_association_id IS NULL AND t0.tmpl_module_id = 15 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.has_sidebar AS has_sidebar_3,
  t0.enabled_in_static_page AS enabled_in_static_page_4
FROM
  tmpl_modules t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.has_sidebar AS has_sidebar_3, t0.enabled_in_static_page AS enabled_in_static_page_4 FROM tmpl_modules t0 WHERE t0.id = 15;

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 IS NULL
  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 = 11 AND t0.product_association_id IS NULL AND t0.tmpl_module_id = 17 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.has_sidebar AS has_sidebar_3,
  t0.enabled_in_static_page AS enabled_in_static_page_4
FROM
  tmpl_modules t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.has_sidebar AS has_sidebar_3, t0.enabled_in_static_page AS enabled_in_static_page_4 FROM tmpl_modules t0 WHERE t0.id = 17;

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
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?, ?)

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 WHERE t0.id IN ('5', '6', '12', '15', '41', '22', '34');

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

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

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

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