Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          w0_.id AS id_0,
          w0_.date_added AS date_added_1,
          w0_.date_modified AS date_modified_2,
          w0_.label AS label_3,
          w0_.label_sub AS label_sub_4,
          w0_.slug AS slug_5,
          w0_.number AS number_6,
          w0_.sap_number AS sap_number_7,
          w0_.ean AS ean_8,
          w0_.sku AS sku_9,
          w0_.delivery_category AS delivery_category_10,
          w0_.`group` AS group_11,
          w0_.sku_alt AS sku_alt_12,
          w0_.weight AS weight_13,
          w0_.min_order AS min_order_14,
          w0_.intro AS intro_15,
          w0_.description AS description_16,
          w0_.restock_notify AS restock_notify_17,
          w0_.grouped_required AS grouped_required_18,
          w0_.super_options AS super_options_19,
          w0_.super_tier_prices AS super_tier_prices_20,
          w0_.bulk_options AS bulk_options_21,
          w0_.bulk_options_config AS bulk_options_config_22,
          w0_.price_deposit AS price_deposit_23,
          w0_.price_in AS price_in_24,
          w0_.price_incl AS price_incl_25,
          w0_.price_excl AS price_excl_26,
          w0_.price_sale AS price_sale_27,
          w0_.lease_price AS lease_price_28,
          w0_.lease_length AS lease_length_29,
          w0_.sell_price AS sell_price_30,
          w0_.sell_price_incl AS sell_price_incl_31,
          w0_.suggested_price AS suggested_price_32,
          w0_.notify_stock AS notify_stock_33,
          w0_.featured AS featured_34,
          w0_.discount AS discount_35,
          w0_.views AS views_36,
          w0_.seo_title AS seo_title_37,
          w0_.seo_description AS seo_description_38,
          w0_.seo_keywords AS seo_keywords_39,
          w0_.delivery AS delivery_40,
          w0_.visible AS visible_41,
          w0_.visible_no_stock AS visible_no_stock_42,
          w0_.enabled AS enabled_43,
          w0_.manage_stock AS manage_stock_44,
          w0_.bulk AS bulk_45,
          w0_.out_of_stock_quantity AS out_of_stock_quantity_46,
          w0_.quantity AS quantity_47,
          w0_.base AS base_48,
          w0_.mark_delete AS mark_delete_49,
          w0_.min_cart_quantity AS min_cart_quantity_50,
          w0_.max_cart_quantity AS max_cart_quantity_51,
          w0_.notify_on_stock_below AS notify_on_stock_below_52,
          w0_.upsell_products AS upsell_products_53,
          w0_.upsell_position AS upsell_position_54,
          w0_.crosssell_products AS crosssell_products_55,
          w0_.crosssell_position AS crosssell_position_56,
          w0_.related_products AS related_products_57,
          w0_.related_position AS related_position_58,
          w0_.meta_title AS meta_title_59,
          w0_.meta_keywords AS meta_keywords_60,
          w0_.meta_description AS meta_description_61,
          w0_.type AS type_62,
          w0_.digital AS digital_63,
          w0_.stock AS stock_64,
          w0_.stock_order_empty AS stock_order_empty_65,
          w0_.stock_amount AS stock_amount_66,
          w0_.child_stock_amount AS child_stock_amount_67,
          w0_.old_id AS old_id_68,
          w0_.demo AS demo_69,
          w0_.new AS new_70,
          w0_.exclusive AS exclusive_71,
          w0_.new_from AS new_from_72,
          w0_.new_till AS new_till_73,
          w0_.download_limit AS download_limit_74,
          w0_.download_days AS download_days_75,
          w0_.moneybird_id AS moneybird_id_76,
          w0_.prices AS prices_77,
          w0_.link_prices AS link_prices_78,
          w0_.cross_prices AS cross_prices_79,
          w0_.crosssell_skus AS crosssell_skus_80,
          w0_.upsell_skus AS upsell_skus_81,
          w0_.related_skus AS related_skus_82,
          w0_.mail_note AS mail_note_83,
          w0_.has_mail_note AS has_mail_note_84,
          w0_.bundle_linkdata AS bundle_linkdata_85,
          w0_.bundle_link AS bundle_link_86,
          w0_.compatibility AS compatibility_87,
          w0_.faq AS faq_88,
          w0_.build_type AS build_type_89,
          w0_.points_user AS points_user_90,
          w0_.points_business AS points_business_91,
          w0_.extra_description AS extra_description_92,
          w0_.external_id AS external_id_93,
          w0_.sub_enbl AS sub_enbl_94,
          w0_.sub_prd AS sub_prd_95,
          w0_.sub_type AS sub_type_96,
          w0_.sort_linked AS sort_linked_97,
          w0_.extras AS extras_98,
          w0_.cust_deliv AS cust_deliv_99,
          w0_.template_key AS template_key_100,
          w0_.extra_search AS extra_search_101,
          w0_.min AS min_102,
          w0_.max AS max_103,
          w0_.has_media AS has_media_104,
          w0_.cache_date AS cache_date_105,
          w0_.price_suffix AS price_suffix_106,
          w0_.price_label AS price_label_107,
          w0_.gtin AS gtin_108,
          w0_.position AS position_109,
          w0_.toggle_stock AS toggle_stock_110,
          w0_.in_configurator AS in_configurator_111,
          w0_.configurator_priority AS configurator_priority_112,
          w0_.in_google_merchant AS in_google_merchant_113
        FROM
          webshop_product w0_
          INNER JOIN webshop_product_link w1_ ON w0_.id = w1_.product_id
        WHERE
          1 = 1
          AND (
            (
              w0_.type = 0
              AND (
                (
                  w0_.stock_amount - w0_.out_of_stock_quantity
                ) > 0
                OR w0_.stock = 0
                OR w0_.visible_no_stock = 1
              )
            )
            OR w0_.type > 0
          )
          AND (
            (
              w0_.type = 0
              OR w0_.type = 3
              OR w0_.type = 4
            )
            OR (
              (
                w0_.type = 1
                OR w0_.type = 2
              )
              AND w0_.child_stock_amount > 0
            )
          )
          AND w0_.enabled = 1
          AND w0_.visible = 1
          AND w1_.webshop_id = 2
        ORDER BY
          w0_.date_modified DESC,
          w0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT w0_.id AS id_0, w0_.date_added AS date_added_1, w0_.date_modified AS date_modified_2, w0_.label AS label_3, w0_.label_sub AS label_sub_4, w0_.slug AS slug_5, w0_.number AS number_6, w0_.sap_number AS sap_number_7, w0_.ean AS ean_8, w0_.sku AS sku_9, w0_.delivery_category AS delivery_category_10, w0_.`group` AS group_11, w0_.sku_alt AS sku_alt_12, w0_.weight AS weight_13, w0_.min_order AS min_order_14, w0_.intro AS intro_15, w0_.description AS description_16, w0_.restock_notify AS restock_notify_17, w0_.grouped_required AS grouped_required_18, w0_.super_options AS super_options_19, w0_.super_tier_prices AS super_tier_prices_20, w0_.bulk_options AS bulk_options_21, w0_.bulk_options_config AS bulk_options_config_22, w0_.price_deposit AS price_deposit_23, w0_.price_in AS price_in_24, w0_.price_incl AS price_incl_25, w0_.price_excl AS price_excl_26, w0_.price_sale AS price_sale_27, w0_.lease_price AS lease_price_28, w0_.lease_length AS lease_length_29, w0_.sell_price AS sell_price_30, w0_.sell_price_incl AS sell_price_incl_31, w0_.suggested_price AS suggested_price_32, w0_.notify_stock AS notify_stock_33, w0_.featured AS featured_34, w0_.discount AS discount_35, w0_.views AS views_36, w0_.seo_title AS seo_title_37, w0_.seo_description AS seo_description_38, w0_.seo_keywords AS seo_keywords_39, w0_.delivery AS delivery_40, w0_.visible AS visible_41, w0_.visible_no_stock AS visible_no_stock_42, w0_.enabled AS enabled_43, w0_.manage_stock AS manage_stock_44, w0_.bulk AS bulk_45, w0_.out_of_stock_quantity AS out_of_stock_quantity_46, w0_.quantity AS quantity_47, w0_.base AS base_48, w0_.mark_delete AS mark_delete_49, w0_.min_cart_quantity AS min_cart_quantity_50, w0_.max_cart_quantity AS max_cart_quantity_51, w0_.notify_on_stock_below AS notify_on_stock_below_52, w0_.upsell_products AS upsell_products_53, w0_.upsell_position AS upsell_position_54, w0_.crosssell_products AS crosssell_products_55, w0_.crosssell_position AS crosssell_position_56, w0_.related_products AS related_products_57, w0_.related_position AS related_position_58, w0_.meta_title AS meta_title_59, w0_.meta_keywords AS meta_keywords_60, w0_.meta_description AS meta_description_61, w0_.type AS type_62, w0_.digital AS digital_63, w0_.stock AS stock_64, w0_.stock_order_empty AS stock_order_empty_65, w0_.stock_amount AS stock_amount_66, w0_.child_stock_amount AS child_stock_amount_67, w0_.old_id AS old_id_68, w0_.demo AS demo_69, w0_.new AS new_70, w0_.exclusive AS exclusive_71, w0_.new_from AS new_from_72, w0_.new_till AS new_till_73, w0_.download_limit AS download_limit_74, w0_.download_days AS download_days_75, w0_.moneybird_id AS moneybird_id_76, w0_.prices AS prices_77, w0_.link_prices AS link_prices_78, w0_.cross_prices AS cross_prices_79, w0_.crosssell_skus AS crosssell_skus_80, w0_.upsell_skus AS upsell_skus_81, w0_.related_skus AS related_skus_82, w0_.mail_note AS mail_note_83, w0_.has_mail_note AS has_mail_note_84, w0_.bundle_linkdata AS bundle_linkdata_85, w0_.bundle_link AS bundle_link_86, w0_.compatibility AS compatibility_87, w0_.faq AS faq_88, w0_.build_type AS build_type_89, w0_.points_user AS points_user_90, w0_.points_business AS points_business_91, w0_.extra_description AS extra_description_92, w0_.external_id AS external_id_93, w0_.sub_enbl AS sub_enbl_94, w0_.sub_prd AS sub_prd_95, w0_.sub_type AS sub_type_96, w0_.sort_linked AS sort_linked_97, w0_.extras AS extras_98, w0_.cust_deliv AS cust_deliv_99, w0_.template_key AS template_key_100, w0_.extra_search AS extra_search_101, w0_.min AS min_102, w0_.max AS max_103, w0_.has_media AS has_media_104, w0_.cache_date AS cache_date_105, w0_.price_suffix AS price_suffix_106, w0_.price_label AS price_label_107, w0_.gtin AS gtin_108, w0_.position AS position_109, w0_.toggle_stock AS toggle_stock_110, w0_.in_configurator AS in_configurator_111, w0_.configurator_priority AS configurator_priority_112, w0_.in_google_merchant AS in_google_merchant_113 FROM webshop_product w0_ INNER JOIN webshop_product_link w1_ ON w0_.id = w1_.product_id WHERE 1 = 1 AND ((w0_.type = 0 AND ((w0_.stock_amount - w0_.out_of_stock_quantity) > 0 OR w0_.stock = 0 OR w0_.visible_no_stock = 1)) OR w0_.type > 0) AND ((w0_.type = 0 OR w0_.type = 3 OR w0_.type = 4) OR ((w0_.type = 1 OR w0_.type = 2) AND w0_.child_stock_amount > 0)) AND w0_.enabled = 1 AND w0_.visible = 1 AND w1_.webshop_id = 2 ORDER BY w0_.date_modified DESC, w0_.id DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      date_modified_2
    FROM
      (
        SELECT
          w0_.id AS id_0,
          w0_.date_added AS date_added_1,
          w0_.date_modified AS date_modified_2,
          w0_.label AS label_3,
          w0_.label_sub AS label_sub_4,
          w0_.slug AS slug_5,
          w0_.number AS number_6,
          w0_.sap_number AS sap_number_7,
          w0_.ean AS ean_8,
          w0_.sku AS sku_9,
          w0_.delivery_category AS delivery_category_10,
          w0_.`group` AS group_11,
          w0_.sku_alt AS sku_alt_12,
          w0_.weight AS weight_13,
          w0_.min_order AS min_order_14,
          w0_.intro AS intro_15,
          w0_.description AS description_16,
          w0_.restock_notify AS restock_notify_17,
          w0_.grouped_required AS grouped_required_18,
          w0_.super_options AS super_options_19,
          w0_.super_tier_prices AS super_tier_prices_20,
          w0_.bulk_options AS bulk_options_21,
          w0_.bulk_options_config AS bulk_options_config_22,
          w0_.price_deposit AS price_deposit_23,
          w0_.price_in AS price_in_24,
          w0_.price_incl AS price_incl_25,
          w0_.price_excl AS price_excl_26,
          w0_.price_sale AS price_sale_27,
          w0_.lease_price AS lease_price_28,
          w0_.lease_length AS lease_length_29,
          w0_.sell_price AS sell_price_30,
          w0_.sell_price_incl AS sell_price_incl_31,
          w0_.suggested_price AS suggested_price_32,
          w0_.notify_stock AS notify_stock_33,
          w0_.featured AS featured_34,
          w0_.discount AS discount_35,
          w0_.views AS views_36,
          w0_.seo_title AS seo_title_37,
          w0_.seo_description AS seo_description_38,
          w0_.seo_keywords AS seo_keywords_39,
          w0_.delivery AS delivery_40,
          w0_.visible AS visible_41,
          w0_.visible_no_stock AS visible_no_stock_42,
          w0_.enabled AS enabled_43,
          w0_.manage_stock AS manage_stock_44,
          w0_.bulk AS bulk_45,
          w0_.out_of_stock_quantity AS out_of_stock_quantity_46,
          w0_.quantity AS quantity_47,
          w0_.base AS base_48,
          w0_.mark_delete AS mark_delete_49,
          w0_.min_cart_quantity AS min_cart_quantity_50,
          w0_.max_cart_quantity AS max_cart_quantity_51,
          w0_.notify_on_stock_below AS notify_on_stock_below_52,
          w0_.upsell_products AS upsell_products_53,
          w0_.upsell_position AS upsell_position_54,
          w0_.crosssell_products AS crosssell_products_55,
          w0_.crosssell_position AS crosssell_position_56,
          w0_.related_products AS related_products_57,
          w0_.related_position AS related_position_58,
          w0_.meta_title AS meta_title_59,
          w0_.meta_keywords AS meta_keywords_60,
          w0_.meta_description AS meta_description_61,
          w0_.type AS type_62,
          w0_.digital AS digital_63,
          w0_.stock AS stock_64,
          w0_.stock_order_empty AS stock_order_empty_65,
          w0_.stock_amount AS stock_amount_66,
          w0_.child_stock_amount AS child_stock_amount_67,
          w0_.old_id AS old_id_68,
          w0_.demo AS demo_69,
          w0_.new AS new_70,
          w0_.exclusive AS exclusive_71,
          w0_.new_from AS new_from_72,
          w0_.new_till AS new_till_73,
          w0_.download_limit AS download_limit_74,
          w0_.download_days AS download_days_75,
          w0_.moneybird_id AS moneybird_id_76,
          w0_.prices AS prices_77,
          w0_.link_prices AS link_prices_78,
          w0_.cross_prices AS cross_prices_79,
          w0_.crosssell_skus AS crosssell_skus_80,
          w0_.upsell_skus AS upsell_skus_81,
          w0_.related_skus AS related_skus_82,
          w0_.mail_note AS mail_note_83,
          w0_.has_mail_note AS has_mail_note_84,
          w0_.bundle_linkdata AS bundle_linkdata_85,
          w0_.bundle_link AS bundle_link_86,
          w0_.compatibility AS compatibility_87,
          w0_.faq AS faq_88,
          w0_.build_type AS build_type_89,
          w0_.points_user AS points_user_90,
          w0_.points_business AS points_business_91,
          w0_.extra_description AS extra_description_92,
          w0_.external_id AS external_id_93,
          w0_.sub_enbl AS sub_enbl_94,
          w0_.sub_prd AS sub_prd_95,
          w0_.sub_type AS sub_type_96,
          w0_.sort_linked AS sort_linked_97,
          w0_.extras AS extras_98,
          w0_.cust_deliv AS cust_deliv_99,
          w0_.template_key AS template_key_100,
          w0_.extra_search AS extra_search_101,
          w0_.min AS min_102,
          w0_.max AS max_103,
          w0_.has_media AS has_media_104,
          w0_.cache_date AS cache_date_105,
          w0_.price_suffix AS price_suffix_106,
          w0_.price_label AS price_label_107,
          w0_.gtin AS gtin_108,
          w0_.position AS position_109,
          w0_.toggle_stock AS toggle_stock_110,
          w0_.in_configurator AS in_configurator_111,
          w0_.configurator_priority AS configurator_priority_112,
          w0_.in_google_merchant AS in_google_merchant_113
        FROM
          webshop_product w0_
          INNER JOIN webshop_product_link w1_ ON w0_.id = w1_.product_id
        WHERE
          1 = 1
          AND (
            (
              w0_.type = 0
              AND (
                (
                  w0_.stock_amount - w0_.out_of_stock_quantity
                ) > 0
                OR w0_.stock = 0
                OR w0_.visible_no_stock = 1
              )
            )
            OR w0_.type > 0
          )
          AND (
            (
              w0_.type = 0
              OR w0_.type = 3
              OR w0_.type = 4
            )
            OR (
              (
                w0_.type = 1
                OR w0_.type = 2
              )
              AND w0_.child_stock_amount > 0
            )
          )
          AND w0_.enabled = 1
          AND w0_.visible = 1
          AND w1_.webshop_id = 2
      ) dctrn_result_inner
    ORDER BY
      date_modified_2 DESC,
      id_0 DESC
  ) dctrn_result
LIMIT
  8

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_modified_2 FROM (SELECT w0_.id AS id_0, w0_.date_added AS date_added_1, w0_.date_modified AS date_modified_2, w0_.label AS label_3, w0_.label_sub AS label_sub_4, w0_.slug AS slug_5, w0_.number AS number_6, w0_.sap_number AS sap_number_7, w0_.ean AS ean_8, w0_.sku AS sku_9, w0_.delivery_category AS delivery_category_10, w0_.`group` AS group_11, w0_.sku_alt AS sku_alt_12, w0_.weight AS weight_13, w0_.min_order AS min_order_14, w0_.intro AS intro_15, w0_.description AS description_16, w0_.restock_notify AS restock_notify_17, w0_.grouped_required AS grouped_required_18, w0_.super_options AS super_options_19, w0_.super_tier_prices AS super_tier_prices_20, w0_.bulk_options AS bulk_options_21, w0_.bulk_options_config AS bulk_options_config_22, w0_.price_deposit AS price_deposit_23, w0_.price_in AS price_in_24, w0_.price_incl AS price_incl_25, w0_.price_excl AS price_excl_26, w0_.price_sale AS price_sale_27, w0_.lease_price AS lease_price_28, w0_.lease_length AS lease_length_29, w0_.sell_price AS sell_price_30, w0_.sell_price_incl AS sell_price_incl_31, w0_.suggested_price AS suggested_price_32, w0_.notify_stock AS notify_stock_33, w0_.featured AS featured_34, w0_.discount AS discount_35, w0_.views AS views_36, w0_.seo_title AS seo_title_37, w0_.seo_description AS seo_description_38, w0_.seo_keywords AS seo_keywords_39, w0_.delivery AS delivery_40, w0_.visible AS visible_41, w0_.visible_no_stock AS visible_no_stock_42, w0_.enabled AS enabled_43, w0_.manage_stock AS manage_stock_44, w0_.bulk AS bulk_45, w0_.out_of_stock_quantity AS out_of_stock_quantity_46, w0_.quantity AS quantity_47, w0_.base AS base_48, w0_.mark_delete AS mark_delete_49, w0_.min_cart_quantity AS min_cart_quantity_50, w0_.max_cart_quantity AS max_cart_quantity_51, w0_.notify_on_stock_below AS notify_on_stock_below_52, w0_.upsell_products AS upsell_products_53, w0_.upsell_position AS upsell_position_54, w0_.crosssell_products AS crosssell_products_55, w0_.crosssell_position AS crosssell_position_56, w0_.related_products AS related_products_57, w0_.related_position AS related_position_58, w0_.meta_title AS meta_title_59, w0_.meta_keywords AS meta_keywords_60, w0_.meta_description AS meta_description_61, w0_.type AS type_62, w0_.digital AS digital_63, w0_.stock AS stock_64, w0_.stock_order_empty AS stock_order_empty_65, w0_.stock_amount AS stock_amount_66, w0_.child_stock_amount AS child_stock_amount_67, w0_.old_id AS old_id_68, w0_.demo AS demo_69, w0_.new AS new_70, w0_.exclusive AS exclusive_71, w0_.new_from AS new_from_72, w0_.new_till AS new_till_73, w0_.download_limit AS download_limit_74, w0_.download_days AS download_days_75, w0_.moneybird_id AS moneybird_id_76, w0_.prices AS prices_77, w0_.link_prices AS link_prices_78, w0_.cross_prices AS cross_prices_79, w0_.crosssell_skus AS crosssell_skus_80, w0_.upsell_skus AS upsell_skus_81, w0_.related_skus AS related_skus_82, w0_.mail_note AS mail_note_83, w0_.has_mail_note AS has_mail_note_84, w0_.bundle_linkdata AS bundle_linkdata_85, w0_.bundle_link AS bundle_link_86, w0_.compatibility AS compatibility_87, w0_.faq AS faq_88, w0_.build_type AS build_type_89, w0_.points_user AS points_user_90, w0_.points_business AS points_business_91, w0_.extra_description AS extra_description_92, w0_.external_id AS external_id_93, w0_.sub_enbl AS sub_enbl_94, w0_.sub_prd AS sub_prd_95, w0_.sub_type AS sub_type_96, w0_.sort_linked AS sort_linked_97, w0_.extras AS extras_98, w0_.cust_deliv AS cust_deliv_99, w0_.template_key AS template_key_100, w0_.extra_search AS extra_search_101, w0_.min AS min_102, w0_.max AS max_103, w0_.has_media AS has_media_104, w0_.cache_date AS cache_date_105, w0_.price_suffix AS price_suffix_106, w0_.price_label AS price_label_107, w0_.gtin AS gtin_108, w0_.position AS position_109, w0_.toggle_stock AS toggle_stock_110, w0_.in_configurator AS in_configurator_111, w0_.configurator_priority AS configurator_priority_112, w0_.in_google_merchant AS in_google_merchant_113 FROM webshop_product w0_ INNER JOIN webshop_product_link w1_ ON w0_.id = w1_.product_id WHERE 1 = 1 AND ((w0_.type = 0 AND ((w0_.stock_amount - w0_.out_of_stock_quantity) > 0 OR w0_.stock = 0 OR w0_.visible_no_stock = 1)) OR w0_.type > 0) AND ((w0_.type = 0 OR w0_.type = 3 OR w0_.type = 4) OR ((w0_.type = 1 OR w0_.type = 2) AND w0_.child_stock_amount > 0)) AND w0_.enabled = 1 AND w0_.visible = 1 AND w1_.webshop_id = 2) dctrn_result_inner ORDER BY date_modified_2 DESC, id_0 DESC) dctrn_result LIMIT 8;

SELECT
  t0.id AS id_1,
  t0.date_added AS date_added_2,
  t0.date_modified AS date_modified_3,
  t0.label AS label_4,
  t0.label_sub AS label_sub_5,
  t0.slug AS slug_6,
  t0.number AS number_7,
  t0.sap_number AS sap_number_8,
  t0.ean AS ean_9,
  t0.sku AS sku_10,
  t0.delivery_category AS delivery_category_11,
  t0.`group` AS group_12,
  t0.sku_alt AS sku_alt_13,
  t0.weight AS weight_14,
  t0.min_order AS min_order_15,
  t0.intro AS intro_16,
  t0.description AS description_17,
  t0.restock_notify AS restock_notify_18,
  t0.grouped_required AS grouped_required_19,
  t0.super_options AS super_options_20,
  t0.super_tier_prices AS super_tier_prices_21,
  t0.bulk_options AS bulk_options_22,
  t0.bulk_options_config AS bulk_options_config_23,
  t0.price_deposit AS price_deposit_24,
  t0.price_in AS price_in_25,
  t0.price_incl AS price_incl_26,
  t0.price_excl AS price_excl_27,
  t0.price_sale AS price_sale_28,
  t0.lease_price AS lease_price_29,
  t0.lease_length AS lease_length_30,
  t0.sell_price AS sell_price_31,
  t0.sell_price_incl AS sell_price_incl_32,
  t0.suggested_price AS suggested_price_33,
  t0.notify_stock AS notify_stock_34,
  t0.featured AS featured_35,
  t0.discount AS discount_36,
  t0.views AS views_37,
  t0.seo_title AS seo_title_38,
  t0.seo_description AS seo_description_39,
  t0.seo_keywords AS seo_keywords_40,
  t0.delivery AS delivery_41,
  t0.visible AS visible_42,
  t0.visible_no_stock AS visible_no_stock_43,
  t0.enabled AS enabled_44,
  t0.manage_stock AS manage_stock_45,
  t0.bulk AS bulk_46,
  t0.out_of_stock_quantity AS out_of_stock_quantity_47,
  t0.quantity AS quantity_48,
  t0.base AS base_49,
  t0.mark_delete AS mark_delete_50,
  t0.min_cart_quantity AS min_cart_quantity_51,
  t0.max_cart_quantity AS max_cart_quantity_52,
  t0.notify_on_stock_below AS notify_on_stock_below_53,
  t0.upsell_products AS upsell_products_54,
  t0.upsell_position AS upsell_position_55,
  t0.crosssell_products AS crosssell_products_56,
  t0.crosssell_position AS crosssell_position_57,
  t0.related_products AS related_products_58,
  t0.related_position AS related_position_59,
  t0.meta_title AS meta_title_60,
  t0.meta_keywords AS meta_keywords_61,
  t0.meta_description AS meta_description_62,
  t0.type AS type_63,
  t0.digital AS digital_64,
  t0.stock AS stock_65,
  t0.stock_order_empty AS stock_order_empty_66,
  t0.stock_amount AS stock_amount_67,
  t0.child_stock_amount AS child_stock_amount_68,
  t0.old_id AS old_id_69,
  t0.demo AS demo_70,
  t0.new AS new_71,
  t0.exclusive AS exclusive_72,
  t0.new_from AS new_from_73,
  t0.new_till AS new_till_74,
  t0.download_limit AS download_limit_75,
  t0.download_days AS download_days_76,
  t0.moneybird_id AS moneybird_id_77,
  t0.prices AS prices_78,
  t0.link_prices AS link_prices_79,
  t0.cross_prices AS cross_prices_80,
  t0.crosssell_skus AS crosssell_skus_81,
  t0.upsell_skus AS upsell_skus_82,
  t0.related_skus AS related_skus_83,
  t0.mail_note AS mail_note_84,
  t0.has_mail_note AS has_mail_note_85,
  t0.bundle_linkdata AS bundle_linkdata_86,
  t0.bundle_link AS bundle_link_87,
  t0.compatibility AS compatibility_88,
  t0.faq AS faq_89,
  t0.build_type AS build_type_90,
  t0.points_user AS points_user_91,
  t0.points_business AS points_business_92,
  t0.extra_description AS extra_description_93,
  t0.external_id AS external_id_94,
  t0.sub_enbl AS sub_enbl_95,
  t0.sub_prd AS sub_prd_96,
  t0.sub_type AS sub_type_97,
  t0.sort_linked AS sort_linked_98,
  t0.extras AS extras_99,
  t0.cust_deliv AS cust_deliv_100,
  t0.template_key AS template_key_101,
  t0.extra_search AS extra_search_102,
  t0.min AS min_103,
  t0.max AS max_104,
  t0.has_media AS has_media_105,
  t0.cache_date AS cache_date_106,
  t0.price_suffix AS price_suffix_107,
  t0.price_label AS price_label_108,
  t0.gtin AS gtin_109,
  t0.position AS position_110,
  t0.toggle_stock AS toggle_stock_111,
  t0.in_configurator AS in_configurator_112,
  t0.configurator_priority AS configurator_priority_113,
  t0.in_google_merchant AS in_google_merchant_114,
  t0.tax_id AS tax_id_115,
  t0.brand_id AS brand_id_116,
  t0.header_image_id AS header_image_id_117,
  t0.language_id AS language_id_118,
  t0.webshop_id AS webshop_id_119,
  t0.ledger_id AS ledger_id_120,
  t0.product_group_id AS product_group_id_121,
  t0.gift_card_id AS gift_card_id_122
FROM
  webshop_product t0
  INNER JOIN webshop_product_crosssell_to ON t0.id = webshop_product_crosssell_to.product_source
WHERE
  webshop_product_crosssell_to.product_target = ?
ORDER BY
  t0.price_incl ASC

SELECT t0.id AS id_1, t0.date_added AS date_added_2, t0.date_modified AS date_modified_3, t0.label AS label_4, t0.label_sub AS label_sub_5, t0.slug AS slug_6, t0.number AS number_7, t0.sap_number AS sap_number_8, t0.ean AS ean_9, t0.sku AS sku_10, t0.delivery_category AS delivery_category_11, t0.`group` AS group_12, t0.sku_alt AS sku_alt_13, t0.weight AS weight_14, t0.min_order AS min_order_15, t0.intro AS intro_16, t0.description AS description_17, t0.restock_notify AS restock_notify_18, t0.grouped_required AS grouped_required_19, t0.super_options AS super_options_20, t0.super_tier_prices AS super_tier_prices_21, t0.bulk_options AS bulk_options_22, t0.bulk_options_config AS bulk_options_config_23, t0.price_deposit AS price_deposit_24, t0.price_in AS price_in_25, t0.price_incl AS price_incl_26, t0.price_excl AS price_excl_27, t0.price_sale AS price_sale_28, t0.lease_price AS lease_price_29, t0.lease_length AS lease_length_30, t0.sell_price AS sell_price_31, t0.sell_price_incl AS sell_price_incl_32, t0.suggested_price AS suggested_price_33, t0.notify_stock AS notify_stock_34, t0.featured AS featured_35, t0.discount AS discount_36, t0.views AS views_37, t0.seo_title AS seo_title_38, t0.seo_description AS seo_description_39, t0.seo_keywords AS seo_keywords_40, t0.delivery AS delivery_41, t0.visible AS visible_42, t0.visible_no_stock AS visible_no_stock_43, t0.enabled AS enabled_44, t0.manage_stock AS manage_stock_45, t0.bulk AS bulk_46, t0.out_of_stock_quantity AS out_of_stock_quantity_47, t0.quantity AS quantity_48, t0.base AS base_49, t0.mark_delete AS mark_delete_50, t0.min_cart_quantity AS min_cart_quantity_51, t0.max_cart_quantity AS max_cart_quantity_52, t0.notify_on_stock_below AS notify_on_stock_below_53, t0.upsell_products AS upsell_products_54, t0.upsell_position AS upsell_position_55, t0.crosssell_products AS crosssell_products_56, t0.crosssell_position AS crosssell_position_57, t0.related_products AS related_products_58, t0.related_position AS related_position_59, t0.meta_title AS meta_title_60, t0.meta_keywords AS meta_keywords_61, t0.meta_description AS meta_description_62, t0.type AS type_63, t0.digital AS digital_64, t0.stock AS stock_65, t0.stock_order_empty AS stock_order_empty_66, t0.stock_amount AS stock_amount_67, t0.child_stock_amount AS child_stock_amount_68, t0.old_id AS old_id_69, t0.demo AS demo_70, t0.new AS new_71, t0.exclusive AS exclusive_72, t0.new_from AS new_from_73, t0.new_till AS new_till_74, t0.download_limit AS download_limit_75, t0.download_days AS download_days_76, t0.moneybird_id AS moneybird_id_77, t0.prices AS prices_78, t0.link_prices AS link_prices_79, t0.cross_prices AS cross_prices_80, t0.crosssell_skus AS crosssell_skus_81, t0.upsell_skus AS upsell_skus_82, t0.related_skus AS related_skus_83, t0.mail_note AS mail_note_84, t0.has_mail_note AS has_mail_note_85, t0.bundle_linkdata AS bundle_linkdata_86, t0.bundle_link AS bundle_link_87, t0.compatibility AS compatibility_88, t0.faq AS faq_89, t0.build_type AS build_type_90, t0.points_user AS points_user_91, t0.points_business AS points_business_92, t0.extra_description AS extra_description_93, t0.external_id AS external_id_94, t0.sub_enbl AS sub_enbl_95, t0.sub_prd AS sub_prd_96, t0.sub_type AS sub_type_97, t0.sort_linked AS sort_linked_98, t0.extras AS extras_99, t0.cust_deliv AS cust_deliv_100, t0.template_key AS template_key_101, t0.extra_search AS extra_search_102, t0.min AS min_103, t0.max AS max_104, t0.has_media AS has_media_105, t0.cache_date AS cache_date_106, t0.price_suffix AS price_suffix_107, t0.price_label AS price_label_108, t0.gtin AS gtin_109, t0.position AS position_110, t0.toggle_stock AS toggle_stock_111, t0.in_configurator AS in_configurator_112, t0.configurator_priority AS configurator_priority_113, t0.in_google_merchant AS in_google_merchant_114, t0.tax_id AS tax_id_115, t0.brand_id AS brand_id_116, t0.header_image_id AS header_image_id_117, t0.language_id AS language_id_118, t0.webshop_id AS webshop_id_119, t0.ledger_id AS ledger_id_120, t0.product_group_id AS product_group_id_121, t0.gift_card_id AS gift_card_id_122 FROM webshop_product t0 INNER JOIN webshop_product_crosssell_to ON t0.id = webshop_product_crosssell_to.product_source WHERE webshop_product_crosssell_to.product_target = 6451 ORDER BY t0.price_incl ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.label AS label_3,
  t0.path_label AS path_label_4,
  t0.path_label_clean AS path_label_clean_5,
  t0.description AS description_6,
  t0.block_text AS block_text_7,
  t0.slug AS slug_8,
  t0.slug_key AS slug_key_9,
  t0.product_template AS product_template_10,
  t0.footer AS footer_11,
  t0.homepage AS homepage_12,
  t0.navigation AS navigation_13,
  t0.hidden AS hidden_14,
  t0.page_priority AS page_priority_15,
  t0.seo_title AS seo_title_16,
  t0.seo_description AS seo_description_17,
  t0.seo_keywords AS seo_keywords_18,
  t0.ignored_specs AS ignored_specs_19,
  t0.spec_cache AS spec_cache_20,
  t0.lang_cats AS lang_cats_21,
  t0.base AS base_22,
  t0.num AS num_23,
  t0.show_sub AS show_sub_24,
  t0.min AS min_25,
  t0.max AS max_26,
  t0.show_all AS show_all_27,
  t0.available_when_logged_in AS available_when_logged_in_28,
  t0.available_when_logged_out AS available_when_logged_out_29,
  t0.webshop_id AS webshop_id_30,
  t0.parent_id AS parent_id_31,
  t0.header_image_id AS header_image_id_32,
  t0.header_image_mobile_id AS header_image_mobile_id_33,
  t0.icon_id AS icon_id_34
FROM
  webshop_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.label AS label_3, t0.path_label AS path_label_4, t0.path_label_clean AS path_label_clean_5, t0.description AS description_6, t0.block_text AS block_text_7, t0.slug AS slug_8, t0.slug_key AS slug_key_9, t0.product_template AS product_template_10, t0.footer AS footer_11, t0.homepage AS homepage_12, t0.navigation AS navigation_13, t0.hidden AS hidden_14, t0.page_priority AS page_priority_15, t0.seo_title AS seo_title_16, t0.seo_description AS seo_description_17, t0.seo_keywords AS seo_keywords_18, t0.ignored_specs AS ignored_specs_19, t0.spec_cache AS spec_cache_20, t0.lang_cats AS lang_cats_21, t0.base AS base_22, t0.num AS num_23, t0.show_sub AS show_sub_24, t0.min AS min_25, t0.max AS max_26, t0.show_all AS show_all_27, t0.available_when_logged_in AS available_when_logged_in_28, t0.available_when_logged_out AS available_when_logged_out_29, t0.webshop_id AS webshop_id_30, t0.parent_id AS parent_id_31, t0.header_image_id AS header_image_id_32, t0.header_image_mobile_id AS header_image_mobile_id_33, t0.icon_id AS icon_id_34 FROM webshop_category t0 WHERE t0.id = 459;