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

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

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

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
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.portal_settings_id AS portal_settings_id_4,
  t0.category_id AS category_id_5,
  t0.product_association_id AS product_association_id_6,
  t0.product_main_type_id AS product_main_type_id_7,
  t0.template_type_id AS template_type_id_8
FROM
  templates t0
WHERE
  t0.id = ?

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

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

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.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
  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.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 = 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 = 2 AND t0.product_association_id = 47 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
  INNER JOIN category_product_association ON t0.id = category_product_association.category_id
WHERE
  category_product_association.product_association_id = ?

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 INNER JOIN category_product_association ON t0.id = category_product_association.category_id WHERE category_product_association.product_association_id = 47;

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;