Symfony Profiler

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.name = ?
LIMIT
  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.name = 'category' LIMIT 1;

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.template_type_id = ?
LIMIT
  1

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.template_type_id = 6 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.category_slug = ?
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.category_slug = 'psychologia-i-mindfulness' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.technical_name AS technical_name_3,
  t0.slug AS slug_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t7.id AS id_8,
  t7.is_active AS is_active_9,
  t7.name AS name_10,
  t7.portal_settings_id AS portal_settings_id_11,
  t7.category_id AS category_id_12,
  t7.product_association_id AS product_association_id_13,
  t7.product_main_type_id AS product_main_type_id_14,
  t7.template_type_id AS template_type_id_15
FROM
  product_main_type t0
  LEFT JOIN templates t7 ON t7.product_main_type_id = t0.id
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.technical_name AS technical_name_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t7.id AS id_8, t7.is_active AS is_active_9, t7.name AS name_10, t7.portal_settings_id AS portal_settings_id_11, t7.category_id AS category_id_12, t7.product_association_id AS product_association_id_13, t7.product_main_type_id AS product_main_type_id_14, t7.template_type_id AS template_type_id_15 FROM product_main_type t0 LEFT JOIN templates t7 ON t7.product_main_type_id = t0.id WHERE t0.slug = 'page' 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.category_slug = ?
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.category_slug = 'page' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.preview_fragment AS preview_fragment_1,
  p0_.updated_at AS updated_at_2,
  p0_.title AS title_3,
  p0_.slug AS slug_4,
  p0_.subtitle AS subtitle_5,
  p0_.frontend_description AS frontend_description_6,
  p0_.frontend_description_short AS frontend_description_short_7,
  p0_.is_recommended AS is_recommended_8,
  p0_.is_most_bought AS is_most_bought_9,
  p0_.logo AS logo_10,
  p0_.background AS background_11,
  p0_.partner_logo AS partner_logo_12,
  p0_.default_quantity_ticket AS default_quantity_ticket_13,
  p0_.custom_scripts AS custom_scripts_14,
  p0_.is_hidden AS is_hidden_15,
  p0_.number_of_access_to_last_releases AS number_of_access_to_last_releases_16,
  p0_.use_html_landing AS use_html_landing_17,
  p0_.custom_head AS custom_head_18,
  p0_.custom_css AS custom_css_19,
  p0_.custom_landing AS custom_landing_20,
  p0_.landing_full_width AS landing_full_width_21,
  p0_.portal_settings_id AS portal_settings_id_22,
  p0_.coupon_default_id AS coupon_default_id_23,
  p0_.category_master_id AS category_master_id_24,
  p0_.product_main_type_id AS product_main_type_id_25
FROM
  product_association p0_
WHERE
  p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT p0_.id AS id_0, p0_.preview_fragment AS preview_fragment_1, p0_.updated_at AS updated_at_2, p0_.title AS title_3, p0_.slug AS slug_4, p0_.subtitle AS subtitle_5, p0_.frontend_description AS frontend_description_6, p0_.frontend_description_short AS frontend_description_short_7, p0_.is_recommended AS is_recommended_8, p0_.is_most_bought AS is_most_bought_9, p0_.logo AS logo_10, p0_.background AS background_11, p0_.partner_logo AS partner_logo_12, p0_.default_quantity_ticket AS default_quantity_ticket_13, p0_.custom_scripts AS custom_scripts_14, p0_.is_hidden AS is_hidden_15, p0_.number_of_access_to_last_releases AS number_of_access_to_last_releases_16, p0_.use_html_landing AS use_html_landing_17, p0_.custom_head AS custom_head_18, p0_.custom_css AS custom_css_19, p0_.custom_landing AS custom_landing_20, p0_.landing_full_width AS landing_full_width_21, p0_.portal_settings_id AS portal_settings_id_22, p0_.coupon_default_id AS coupon_default_id_23, p0_.category_master_id AS category_master_id_24, p0_.product_main_type_id AS product_main_type_id_25 FROM product_association p0_ WHERE p0_.id IN ('5', '15', '18', '68', '71', '72', '119', '120', '123', '125', '131', '135', '136', '144');

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;