Shopware Profiler

SELECT 
  shop.id, 
  shop.name, 
  shop.base_url, 
  shop.position, 
  IF(main_shop.id IS NULL, 1, 0) is_main, 
  IFNULL(main_shop.host, shop.host) as host, 
  IFNULL(main_shop.hosts, shop.hosts) as hosts, 
  IFNULL(main_shop.secure, shop.secure) as secure, 
  IFNULL(
    main_shop.base_path, shop.base_path
  ) as base_path, 
  IFNULL(
    main_shop.template_id, shop.template_id
  ) as template_id, 
  IFNULL(
    main_shop.customer_scope, shop.customer_scope
  ) as customer_scope 
FROM 
  s_core_shops shop 
  LEFT JOIN s_core_shops main_shop ON shop.main_id = main_shop.id 
WHERE 
  (shop.active = 1) 
  AND (
    (
      shop.host = : host 
      OR (
        shop.host IS NULL 
        AND main_shop.host = : host
      )
    )
  )

array:1 [
  ":host" => "sw5demo.swk-web.com"
]

SELECT 
  s0_.id AS id_0, 
  s0_.main_id AS main_id_1, 
  s0_.category_id AS category_id_2, 
  s0_.name AS name_3, 
  s0_.title AS title_4, 
  s0_.position AS position_5, 
  s0_.host AS host_6, 
  s0_.base_path AS base_path_7, 
  s0_.base_url AS base_url_8, 
  s0_.hosts AS hosts_9, 
  s0_.secure AS secure_10, 
  s0_.template_id AS template_id_11, 
  s0_.`default` AS default_12, 
  s0_.active AS active_13, 
  s0_.customer_scope AS customer_scope_14, 
  s0_.id AS id_15, 
  s0_.main_id AS main_id_16, 
  s0_.category_id AS category_id_17, 
  s0_.name AS name_18, 
  s0_.title AS title_19, 
  s0_.position AS position_20, 
  s0_.host AS host_21, 
  s0_.base_path AS base_path_22, 
  s0_.base_url AS base_url_23, 
  s0_.hosts AS hosts_24, 
  s0_.secure AS secure_25, 
  s0_.template_id AS template_id_26, 
  s0_.`default` AS default_27, 
  s0_.active AS active_28, 
  s0_.customer_scope AS customer_scope_29, 
  s1_.id AS id_30, 
  s1_.locale AS locale_31, 
  s1_.language AS language_32, 
  s1_.territory AS territory_33, 
  s2_.id AS id_34, 
  s2_.currency AS currency_35, 
  s2_.name AS name_36, 
  s2_.standard AS standard_37, 
  s2_.factor AS factor_38, 
  s2_.templatechar AS templatechar_39, 
  s2_.symbol_position AS symbol_position_40, 
  s2_.position AS position_41, 
  s3_.id AS id_42, 
  s3_.template AS template_43, 
  s3_.name AS name_44, 
  s3_.description AS description_45, 
  s3_.author AS author_46, 
  s3_.license AS license_47, 
  s3_.esi AS esi_48, 
  s3_.style_support AS style_support_49, 
  s3_.emotion AS emotion_50, 
  s3_.version AS version_51, 
  s3_.plugin_id AS plugin_id_52, 
  s3_.parent_id AS parent_id_53, 
  s4_.id AS id_54, 
  s4_.template AS template_55, 
  s4_.name AS name_56, 
  s4_.description AS description_57, 
  s4_.author AS author_58, 
  s4_.license AS license_59, 
  s4_.esi AS esi_60, 
  s4_.style_support AS style_support_61, 
  s4_.emotion AS emotion_62, 
  s4_.version AS version_63, 
  s4_.plugin_id AS plugin_id_64, 
  s4_.parent_id AS parent_id_65, 
  s5_.id AS id_66, 
  s5_.currency AS currency_67, 
  s5_.name AS name_68, 
  s5_.standard AS standard_69, 
  s5_.factor AS factor_70, 
  s5_.templatechar AS templatechar_71, 
  s5_.symbol_position AS symbol_position_72, 
  s5_.position AS position_73, 
  s6_.id AS id_74, 
  s6_.groupkey AS groupkey_75, 
  s6_.description AS description_76, 
  s6_.tax AS tax_77, 
  s6_.taxinput AS taxinput_78, 
  s6_.mode AS mode_79, 
  s6_.discount AS discount_80, 
  s6_.minimumorder AS minimumorder_81, 
  s6_.minimumordersurcharge AS minimumordersurcharge_82, 
  s0_.main_id AS main_id_83, 
  s0_.template_id AS template_id_84, 
  s0_.document_template_id AS document_template_id_85, 
  s0_.category_id AS category_id_86, 
  s0_.locale_id AS locale_id_87, 
  s0_.currency_id AS currency_id_88, 
  s0_.customer_group_id AS customer_group_id_89, 
  s0_.fallback_id AS fallback_id_90, 
  s3_.parent_id AS parent_id_91, 
  s3_.plugin_id AS plugin_id_92, 
  s4_.parent_id AS parent_id_93, 
  s4_.plugin_id AS plugin_id_94 
FROM 
  s_core_shops s0_ 
  LEFT JOIN s_core_locales s1_ ON s0_.locale_id = s1_.id 
  LEFT JOIN s_core_currencies s2_ ON s0_.currency_id = s2_.id 
  LEFT JOIN s_core_templates s3_ ON s0_.template_id = s3_.id 
  LEFT JOIN s_core_templates s4_ ON s0_.document_template_id = s4_.id 
  LEFT JOIN s_core_shop_currencies s7_ ON s0_.id = s7_.shop_id 
  LEFT JOIN s_core_currencies s5_ ON s5_.id = s7_.currency_id 
  LEFT JOIN s_core_customergroups s6_ ON s0_.customer_group_id = s6_.id 
WHERE 
  s0_.id = ? 
ORDER BY 
  s5_.position ASC, 
  s5_.id ASC

array:1 [
  0 => "1"
]

SELECT 
  t0.id AS id_1, 
  t0.shopID AS shopID_2, 
  t0.shopID AS shopID_3 
FROM 
  s_core_shops_attributes t0 
WHERE 
  t0.shopID = ?

array:1 [
  0 => 1
]

SELECT 
  t0.id AS id_1, 
  t0.customerGroupID AS customerGroupID_2, 
  t0.customerGroupID AS customerGroupID_3 
FROM 
  s_core_customergroups_attributes t0 
WHERE 
  t0.customerGroupID = ?

array:1 [
  0 => 1
]

SELECT 
  shop.id, 
  shop.name, 
  shop.base_url, 
  shop.position, 
  IF(main_shop.id IS NULL, 1, 0) is_main, 
  IFNULL(main_shop.host, shop.host) as host, 
  IFNULL(main_shop.hosts, shop.hosts) as hosts, 
  IFNULL(main_shop.secure, shop.secure) as secure, 
  IFNULL(
    main_shop.base_path, shop.base_path
  ) as base_path, 
  IFNULL(
    main_shop.template_id, shop.template_id
  ) as template_id, 
  IFNULL(
    main_shop.customer_scope, shop.customer_scope
  ) as customer_scope 
FROM 
  s_core_shops shop 
  LEFT JOIN s_core_shops main_shop ON shop.main_id = main_shop.id 
WHERE 
  (shop.active = 1) 
  AND (
    (
      shop.host = : host 
      OR (
        shop.host IS NULL 
        AND main_shop.host = : host
      )
    )
  )

array:1 [
  ":host" => "sw5demo.swk-web.com"
]

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.`key` AS key_3, 
  t0.active AS active_4, 
  t0.mapping_id AS mapping_id_5 
FROM 
  s_cms_static_groups t0 
  INNER JOIN s_core_shop_pages ON t0.id = s_core_shop_pages.group_id 
WHERE 
  s_core_shop_pages.shop_id = ? 
ORDER BY 
  t0.id ASC

array:1 [
  0 => 1
]

SELECT 
  t0.id AS id_1, 
  t0.main_id AS main_id_2, 
  t0.category_id AS category_id_3, 
  t0.name AS name_4, 
  t0.title AS title_5, 
  t0.position AS position_6, 
  t0.host AS host_7, 
  t0.base_path AS base_path_8, 
  t0.base_url AS base_url_9, 
  t0.hosts AS hosts_10, 
  t0.secure AS secure_11, 
  t0.template_id AS template_id_12, 
  t0.`default` AS default_13, 
  t0.active AS active_14, 
  t0.customer_scope AS customer_scope_15, 
  t0.main_id AS main_id_16, 
  t0.template_id AS template_id_17, 
  t0.document_template_id AS document_template_id_18, 
  t0.category_id AS category_id_19, 
  t0.locale_id AS locale_id_20, 
  t0.currency_id AS currency_id_21, 
  t0.customer_group_id AS customer_group_id_22, 
  t0.fallback_id AS fallback_id_23, 
  t24.id AS id_25, 
  t24.shopID AS shopID_26, 
  t24.shopID AS shopID_27 
FROM 
  s_core_shops t0 
  LEFT JOIN s_core_shops_attributes t24 ON t24.shopID = t0.id 
WHERE 
  t0.main_id = ? 
ORDER BY 
  t0.position ASC, 
  t0.id ASC

array:1 [
  0 => 1
]

SELECT 
  t0.id AS id_1, 
  t0.locale AS locale_2, 
  t0.language AS language_3, 
  t0.territory AS territory_4 
FROM 
  s_core_locales t0 
WHERE 
  t0.locale = ? 
LIMIT 
  1

array:1 [
  0 => "en_GB"
]

SELECT 
  template.id, 
  template.id, 
  template.template, 
  template.plugin_id, 
  template.parent_id, 
  plugin.name as plugin_name, 
  plugin.namespace as plugin_namespace, 
  plugin.source as plugin_source 
FROM 
  s_core_templates template 
  LEFT JOIN s_core_plugins plugin ON plugin.id = template.plugin_id

[]

SELECT 
  t0.id AS id_1, 
  t0.main_id AS main_id_2, 
  t0.category_id AS category_id_3, 
  t0.name AS name_4, 
  t0.title AS title_5, 
  t0.position AS position_6, 
  t0.host AS host_7, 
  t0.base_path AS base_path_8, 
  t0.base_url AS base_url_9, 
  t0.hosts AS hosts_10, 
  t0.secure AS secure_11, 
  t0.template_id AS template_id_12, 
  t0.`default` AS default_13, 
  t0.active AS active_14, 
  t0.customer_scope AS customer_scope_15, 
  t0.main_id AS main_id_16, 
  t0.template_id AS template_id_17, 
  t0.document_template_id AS document_template_id_18, 
  t0.category_id AS category_id_19, 
  t0.locale_id AS locale_id_20, 
  t0.currency_id AS currency_id_21, 
  t0.customer_group_id AS customer_group_id_22, 
  t0.fallback_id AS fallback_id_23, 
  t24.id AS id_25, 
  t24.shopID AS shopID_26, 
  t24.shopID AS shopID_27 
FROM 
  s_core_shops t0 
  LEFT JOIN s_core_shops_attributes t24 ON t24.shopID = t0.id 
WHERE 
  t0.template_id = ?

array:1 [
  0 => 23
]

SELECT 
  t0.type AS type_1, 
  t0.name AS name_2, 
  t0.position AS position_3, 
  t0.default_value AS default_value_4, 
  t0.selection AS selection_5, 
  t0.field_label AS field_label_6, 
  t0.support_text AS support_text_7, 
  t0.allow_blank AS allow_blank_8, 
  t0.less_compatible AS less_compatible_9, 
  t0.attributes AS attributes_10, 
  t0.container_id AS container_id_11, 
  t0.id AS id_12, 
  t0.template_id AS template_id_13, 
  t0.template_id AS template_id_14, 
  t0.container_id AS container_id_15 
FROM 
  s_core_templates_config_elements t0 
WHERE 
  t0.template_id = ?

array:1 [
  0 => 23
]

SELECT 
  t0.name AS name_1, 
  t0.type AS type_2, 
  t0.template_id AS template_id_3, 
  t0.parent_id AS parent_id_4, 
  t0.title AS title_5, 
  t0.attributes AS attributes_6, 
  t0.id AS id_7, 
  t0.template_id AS template_id_8, 
  t0.parent_id AS parent_id_9 
FROM 
  s_core_templates_config_layout t0 
WHERE 
  t0.template_id = ?

array:1 [
  0 => 23
]

SELECT 
  t0.id AS id_1, 
  t0.template_id AS template_id_2, 
  t0.name AS name_3, 
  t0.description AS description_4, 
  t0.element_values AS element_values_5, 
  t0.template_id AS template_id_6 
FROM 
  s_core_templates_config_set t0 
WHERE 
  t0.template_id = ?

array:1 [
  0 => 23
]

SELECT 
  template.id, 
  template.id, 
  template.template, 
  template.plugin_id, 
  template.parent_id, 
  plugin.name as plugin_name, 
  plugin.namespace as plugin_namespace, 
  plugin.source as plugin_source 
FROM 
  s_core_templates template 
  LEFT JOIN s_core_plugins plugin ON plugin.id = template.plugin_id

[]

SELECT 
  shop.id as __shop_id, 
  shop.main_id as __shop_main_id, 
  shop.name as __shop_name, 
  shop.title as __shop_title, 
  shop.position as __shop_position, 
  shop.host as __shop_host, 
  shop.base_path as __shop_base_path, 
  shop.base_url as __shop_base_url, 
  shop.hosts as __shop_hosts, 
  shop.secure as __shop_secure, 
  shop.template_id as __shop_template_id, 
  shop.document_template_id as __shop_document_template_id, 
  shop.category_id as __shop_category_id, 
  shop.locale_id as __shop_locale_id, 
  shop.currency_id as __shop_currency_id, 
  shop.customer_group_id as __shop_customer_group_id, 
  shop.fallback_id as __shop_fallback_id, 
  shop.customer_scope as __shop_customer_scope, 
  shop.default as __shop_default, 
  shop.active as __shop_active, 
  shopAttribute.id as __shopAttribute_id, 
  shopAttribute.shopID as __shopAttribute_shopID, 
  currency.id as __currency_id, 
  currency.currency as __currency_currency, 
  currency.name as __currency_name, 
  currency.standard as __currency_standard, 
  currency.factor as __currency_factor, 
  currency.templatechar as __currency_templatechar, 
  currency.symbol_position as __currency_symbol_position, 
  currency.position as __currency_position, 
  template.id as __template_id, 
  template.template as __template_template, 
  template.name as __template_name, 
  template.description as __template_description, 
  template.author as __template_author, 
  template.license as __template_license, 
  template.esi as __template_esi, 
  template.style_support as __template_style_support, 
  template.emotion as __template_emotion, 
  template.version as __template_version, 
  template.plugin_id as __template_plugin_id, 
  template.parent_id as __template_parent_id, 
  locale.id as __locale_id, 
  locale.locale as __locale_locale, 
  locale.language as __locale_language, 
  locale.territory as __locale_territory, 
  customerGroup.id as __customerGroup_id, 
  customerGroup.groupkey as __customerGroup_groupkey, 
  customerGroup.description as __customerGroup_description, 
  customerGroup.tax as __customerGroup_tax, 
  customerGroup.taxinput as __customerGroup_taxinput, 
  customerGroup.mode as __customerGroup_mode, 
  customerGroup.discount as __customerGroup_discount, 
  customerGroup.minimumorder as __customerGroup_minimumorder, 
  customerGroup.minimumordersurcharge as __customerGroup_minimumordersurcharge, 
  customerGroupAttribute.id as __customerGroupAttribute_id, 
  customerGroupAttribute.customerGroupID as __customerGroupAttribute_customerGroupID, 
  category.id as __category_id, 
  category.parent as __category_parent_id, 
  category.position as __category_position, 
  category.path as __category_path, 
  category.description as __category_description, 
  category.meta_title as __category_metatitle, 
  category.metakeywords as __category_metakeywords, 
  category.metadescription as __category_metadescription, 
  category.cmsheadline as __category_cmsheadline, 
  category.product_box_layout as __category_product_box_layout, 
  category.cmstext as __category_cmstext, 
  category.template as __category_template, 
  category.blog as __category_blog, 
  category.external as __category_external, 
  category.external_target as __category_external_target, 
  category.hidefilter as __category_hidefilter, 
  category.hidetop as __category_hidetop, 
  category.stream_id as __category_stream_id, 
  category.hide_sortings as __category_hide_sortings, 
  categoryAttribute.id as __categoryAttribute_id, 
  categoryAttribute.categoryID as __categoryAttribute_categoryID, 
  categoryAttribute.attribute1 as __categoryAttribute_attribute1, 
  categoryAttribute.attribute2 as __categoryAttribute_attribute2, 
  categoryAttribute.attribute3 as __categoryAttribute_attribute3, 
  categoryAttribute.attribute4 as __categoryAttribute_attribute4, 
  categoryAttribute.attribute5 as __categoryAttribute_attribute5, 
  categoryAttribute.attribute6 as __categoryAttribute_attribute6, 
  categoryAttribute.swkwe_show_soldout as __categoryAttribute_swkwe_show_soldout, 
  categoryAttribute.swkwe_emotion_category_slider_media as __categoryAttribute_swkwe_emotion_category_slider_media, 
  media.id as __media_id, 
  media.albumID as __media_albumID, 
  media.name as __media_name, 
  media.description as __media_description, 
  media.path as __media_path, 
  media.type as __media_type, 
  media.extension as __media_extension, 
  media.file_size as __media_file_size, 
  media.width as __media_width, 
  media.height as __media_height, 
  media.userID as __media_userID, 
  media.created as __media_created, 
  mediaSettings.id as __mediaSettings_id, 
  mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, 
  mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, 
  mediaSettings.icon as __mediaSettings_icon, 
  mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, 
  mediaAttribute.id as __mediaAttribute_id, 
  mediaAttribute.mediaID as __mediaAttribute_mediaID 
FROM 
  s_core_shops shop 
  LEFT JOIN s_core_shops_attributes shopAttribute ON shopAttribute.shopID = shop.id 
  LEFT JOIN s_core_currencies currency ON currency.id = shop.currency_id 
  LEFT JOIN s_core_templates template ON shop.template_id = template.id 
  LEFT JOIN s_core_locales locale ON locale.id = shop.locale_id 
  LEFT JOIN s_core_customergroups customerGroup ON customerGroup.id = shop.customer_group_id 
  LEFT JOIN s_categories category ON category.id = shop.category_id 
  LEFT JOIN s_core_customergroups_attributes customerGroupAttribute ON customerGroupAttribute.customerGroupID = customerGroup.id 
  LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id 
  LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id 
  LEFT JOIN s_media media ON media.id = category.mediaID 
  LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID 
  LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id 
WHERE 
  shop.id IN (: ids)

array:1 [
  ":ids" => array:1 [
    0 => 1
  ]
]

SELECT 
  customerGroup.id as __customerGroup_id, 
  customerGroup.groupkey as __customerGroup_groupkey, 
  customerGroup.description as __customerGroup_description, 
  customerGroup.tax as __customerGroup_tax, 
  customerGroup.taxinput as __customerGroup_taxinput, 
  customerGroup.mode as __customerGroup_mode, 
  customerGroup.discount as __customerGroup_discount, 
  customerGroup.minimumorder as __customerGroup_minimumorder, 
  customerGroup.minimumordersurcharge as __customerGroup_minimumordersurcharge, 
  customerGroupAttribute.id as __customerGroupAttribute_id, 
  customerGroupAttribute.customerGroupID as __customerGroupAttribute_customerGroupID 
FROM 
  s_core_customergroups customerGroup 
  LEFT JOIN s_core_customergroups_attributes customerGroupAttribute ON customerGroupAttribute.customerGroupID = customerGroup.id 
WHERE 
  customerGroup.groupkey IN (: keys)

array:1 [
  ":keys" => array:2 [
    0 => "EK"
    1 => "EK"
  ]
]

SELECT 
  currency.id as __currency_id, 
  currency.currency as __currency_currency, 
  currency.name as __currency_name, 
  currency.standard as __currency_standard, 
  currency.factor as __currency_factor, 
  currency.templatechar as __currency_templatechar, 
  currency.symbol_position as __currency_symbol_position, 
  currency.position as __currency_position 
FROM 
  s_core_currencies currency 
WHERE 
  currency.id IN (: ids)

array:1 [
  ":ids" => array:1 [
    0 => 1
  ]
]

SELECT 
  tax.id as __tax_id, 
  tax.tax as __tax_tax, 
  tax.description as __tax_description 
FROM 
  s_core_tax tax

[]

SELECT 
  taxRule.groupID as __taxRule_groupID, 
  taxRule.tax as __taxRule_tax, 
  taxRule.name as __taxRule_name 
FROM 
  s_core_tax_rules taxRule 
WHERE 
  (
    (
      taxRule.areaID = : area 
      OR taxRule.areaID IS NULL
    )
  ) 
  AND (
    (
      taxRule.countryID = : country 
      OR taxRule.countryID IS NULL
    )
  ) 
  AND (
    (
      taxRule.stateID = : state 
      OR taxRule.stateID IS NULL
    )
  ) 
  AND (
    (
      taxRule.customer_groupID = : customerGroup 
      OR taxRule.customer_groupID IS NULL
    )
  ) 
  AND (taxRule.groupID = : taxId) 
  AND (taxRule.active = 1) 
ORDER BY 
  taxRule.customer_groupID DESC, 
  taxRule.areaID DESC, 
  taxRule.countryID DESC, 
  taxRule.stateID DESC 
LIMIT 
  1 OFFSET 0

array:5 [
  ":area" => null
  ":country" => null
  ":state" => null
  ":customerGroup" => 1
  ":taxId" => "1"
]

SELECT 
  taxRule.groupID as __taxRule_groupID, 
  taxRule.tax as __taxRule_tax, 
  taxRule.name as __taxRule_name 
FROM 
  s_core_tax_rules taxRule 
WHERE 
  (
    (
      taxRule.areaID = : area 
      OR taxRule.areaID IS NULL
    )
  ) 
  AND (
    (
      taxRule.countryID = : country 
      OR taxRule.countryID IS NULL
    )
  ) 
  AND (
    (
      taxRule.stateID = : state 
      OR taxRule.stateID IS NULL
    )
  ) 
  AND (
    (
      taxRule.customer_groupID = : customerGroup 
      OR taxRule.customer_groupID IS NULL
    )
  ) 
  AND (taxRule.groupID = : taxId) 
  AND (taxRule.active = 1) 
ORDER BY 
  taxRule.customer_groupID DESC, 
  taxRule.areaID DESC, 
  taxRule.countryID DESC, 
  taxRule.stateID DESC 
LIMIT 
  1 OFFSET 0

array:5 [
  ":area" => null
  ":country" => null
  ":state" => null
  ":customerGroup" => 1
  ":taxId" => "4"
]

SELECT 
  priceGroupDiscount.groupID, 
  priceGroupDiscount.id as __priceGroupDiscount_id, 
  priceGroupDiscount.groupID as __priceGroupDiscount_groupID, 
  priceGroupDiscount.discount as __priceGroupDiscount_discount, 
  priceGroupDiscount.discountstart as __priceGroupDiscount_discountstart, 
  priceGroup.id as __priceGroup_id, 
  priceGroup.description as __priceGroup_description 
FROM 
  s_core_pricegroups_discounts priceGroupDiscount 
  INNER JOIN s_core_pricegroups priceGroup ON priceGroup.id = priceGroupDiscount.groupID 
WHERE 
  priceGroupDiscount.customergroupID = : customerGroup 
GROUP BY 
  priceGroupDiscount.id 
ORDER BY 
  priceGroupDiscount.groupID ASC, 
  priceGroupDiscount.discountstart ASC

array:1 [
  ":customerGroup" => 1
]

SELECT 
  1 
FROM 
  s_core_plugins 
WHERE 
  name = ? 
  AND active = 1

array:1 [
  0 => "SwagCustomProducts"
]

SELECT 
  NOW() AS current, 
  cf.value AS last, 
  (
    SELECT 
      1 
    FROM 
      s_search_index 
    LIMIT 
      1
  ) AS not_force 
FROM 
  s_core_config_elements ce, 
  s_core_config_values cf 
WHERE 
  ce.name = 'fuzzysearchlastupdate' 
  AND cf.element_id = ce.id 
  AND cf.shop_id = 1

[]

SELECT 
  emotion.id AS __emotion_id, 
  emotion.active AS __emotion_active, 
  emotion.name AS __emotion_name, 
  emotion.cols AS __emotion_cols, 
  emotion.cell_spacing AS __emotion_cell_spacing, 
  emotion.cell_height AS __emotion_cell_height, 
  emotion.article_height AS __emotion_article_height, 
  emotion.rows AS __emotion_rows, 
  emotion.valid_from AS __emotion_valid_from, 
  emotion.valid_to AS __emotion_valid_to, 
  emotion.userID AS __emotion_user_id, 
  emotion.show_listing AS __emotion_show_listing, 
  emotion.is_landingpage AS __emotion_is_landingpage, 
  emotion.seo_title AS __emotion_seo_title, 
  emotion.seo_keywords AS __emotion_seo_keywords, 
  emotion.seo_description AS __emotion_seo_description, 
  emotion.create_date AS __emotion_create_date, 
  emotion.modified AS __emotion_modified, 
  emotion.template_id AS __emotion_template_id, 
  emotion.device AS __emotion_device, 
  emotion.fullscreen AS __emotion_fullscreen, 
  emotion.mode AS __emotion_mode, 
  emotion.position AS __emotion_position, 
  emotion.parent_id AS __emotion_parent_id, 
  emotion.preview_id AS __emotion_preview_id, 
  emotion.preview_secret AS __emotion_preview_secret, 
  emotionAttribute.id as __emotionAttribute_id, 
  emotionAttribute.emotionID as __emotionAttribute_emotionID, 
  GROUP_CONCAT(
    emotion_categories.category_id SEPARATOR ','
  ) as __emotion_category_ids, 
  GROUP_CONCAT(
    emotion_shops.shop_id SEPARATOR ','
  ) as __emotion_shop_ids, 
  emotionTemplate.id AS __emotionTemplate_id, 
  emotionTemplate.name AS __emotionTemplate_name, 
  emotionTemplate.file AS __emotionTemplate_file 
FROM 
  s_emotion emotion 
  LEFT JOIN s_emotion_attributes emotionAttribute ON emotion.id = emotionAttribute.emotionID 
  LEFT JOIN s_emotion_categories emotion_categories ON emotion.id = emotion_categories.emotion_id 
  LEFT JOIN s_emotion_shops emotion_shops ON emotion.id = emotion_shops.emotion_id 
  LEFT JOIN s_emotion_templates emotionTemplate ON emotion.template_id = emotionTemplate.id 
WHERE 
  emotion.id IN (: emotionIds) 
GROUP BY 
  emotion.id

array:1 [
  "emotionIds" => array:1 [
    0 => 4
  ]
]

SELECT 
  emotionElement.emotionID, 
  emotionElement.id AS __emotionElement_id, 
  emotionElement.emotionID AS __emotionElement_emotion_id, 
  emotionElement.componentID AS __emotionElement_component_id, 
  emotionElement.start_row AS __emotionElement_start_row, 
  emotionElement.start_col AS __emotionElement_start_col, 
  emotionElement.end_row AS __emotionElement_end_row, 
  emotionElement.end_col AS __emotionElement_end_col, 
  emotionElement.css_class AS __emotionElement_css_class, 
  emotionLibraryComponent.id AS __emotionLibraryComponent_id, 
  emotionLibraryComponent.name AS __emotionLibraryComponent_name, 
  emotionLibraryComponent.x_type AS __emotionLibraryComponent_x_type, 
  emotionLibraryComponent.convert_function AS __emotionLibraryComponent_convert_function, 
  emotionLibraryComponent.description AS __emotionLibraryComponent_description, 
  emotionLibraryComponent.template AS __emotionLibraryComponent_template, 
  emotionLibraryComponent.cls AS __emotionLibraryComponent_cls, 
  emotionLibraryComponent.pluginID AS __emotionLibraryComponent_plugin_id 
FROM 
  s_emotion_element emotionElement 
  INNER JOIN s_library_component emotionLibraryComponent ON emotionElement.componentID = emotionLibraryComponent.id 
WHERE 
  emotionElement.emotionID IN (: emotionIds) 
ORDER BY 
  emotionElement.start_row ASC, 
  emotionElement.start_col ASC

array:1 [
  "emotionIds" => array:1 [
    0 => 4
  ]
]

SELECT 
  emotionElementValue.elementID, 
  emotionElementValue.id AS __emotionElementValue_id, 
  emotionElementValue.emotionID AS __emotionElementValue_emotion_id, 
  emotionElementValue.elementID AS __emotionElementValue_element_id, 
  emotionElementValue.componentID AS __emotionElementValue_component_id, 
  emotionElementValue.fieldID AS __emotionElementValue_field_id, 
  emotionElementValue.value AS __emotionElementValue_value, 
  emotionLibraryComponentField.id AS __emotionLibraryComponentField_id, 
  emotionLibraryComponentField.componentID AS __emotionLibraryComponentField_component_id, 
  emotionLibraryComponentField.name AS __emotionLibraryComponentField_name, 
  emotionLibraryComponentField.x_type AS __emotionLibraryComponentField_x_type, 
  emotionLibraryComponentField.value_type AS __emotionLibraryComponentField_value_type, 
  emotionLibraryComponentField.field_label AS __emotionLibraryComponentField_field_label, 
  emotionLibraryComponentField.support_text AS __emotionLibraryComponentField_support_text, 
  emotionLibraryComponentField.help_title AS __emotionLibraryComponentField_help_title, 
  emotionLibraryComponentField.help_text AS __emotionLibraryComponentField_help_text, 
  emotionLibraryComponentField.store AS __emotionLibraryComponentField_store, 
  emotionLibraryComponentField.display_field AS __emotionLibraryComponentField_display_field, 
  emotionLibraryComponentField.value_field AS __emotionLibraryComponentField_value_field, 
  emotionLibraryComponentField.default_value AS __emotionLibraryComponentField_default_value, 
  emotionLibraryComponentField.allow_blank AS __emotionLibraryComponentField_allow_blank, 
  emotionLibraryComponentField.translatable AS __emotionLibraryComponentField_translatable, 
  emotionLibraryComponentField.position AS __emotionLibraryComponentField_position 
FROM 
  s_emotion_element_value emotionElementValue 
  INNER JOIN s_library_component_field emotionLibraryComponentField ON emotionElementValue.fieldID = emotionLibraryComponentField.id 
WHERE 
  emotionElementValue.elementID IN (: elementIds)

array:1 [
  "elementIds" => array:11 [
    0 => "2"
    1 => "3"
    2 => "4"
    3 => "5"
    4 => "6"
    5 => "7"
    6 => "8"
    7 => "45"
    8 => "62"
    9 => "63"
    10 => "64"
  ]
]

SELECT 
  emotionElementViewport.elementID, 
  emotionElementViewport.id AS __emotionElementViewport_id, 
  emotionElementViewport.emotionID AS __emotionElementViewport_emotion_id, 
  emotionElementViewport.elementID AS __emotionElementViewport_element_id, 
  emotionElementViewport.alias AS __emotionElementViewport_alias, 
  emotionElementViewport.start_row AS __emotionElementViewport_start_row, 
  emotionElementViewport.start_col AS __emotionElementViewport_start_col, 
  emotionElementViewport.end_row AS __emotionElementViewport_end_row, 
  emotionElementViewport.end_col AS __emotionElementViewport_end_col, 
  emotionElementViewport.visible AS __emotionElementViewport_visible 
FROM 
  s_emotion_element_viewports emotionElementViewport 
WHERE 
  emotionElementViewport.elementID IN (: elementIds)

array:1 [
  "elementIds" => array:11 [
    0 => "2"
    1 => "3"
    2 => "4"
    3 => "5"
    4 => "6"
    5 => "7"
    6 => "8"
    7 => "45"
    8 => "62"
    9 => "63"
    10 => "64"
  ]
]

SELECT 
  category.id as __category_id, 
  category.parent as __category_parent_id, 
  category.position as __category_position, 
  category.path as __category_path, 
  category.description as __category_description, 
  category.meta_title as __category_metatitle, 
  category.metakeywords as __category_metakeywords, 
  category.metadescription as __category_metadescription, 
  category.cmsheadline as __category_cmsheadline, 
  category.product_box_layout as __category_product_box_layout, 
  category.cmstext as __category_cmstext, 
  category.template as __category_template, 
  category.blog as __category_blog, 
  category.external as __category_external, 
  category.external_target as __category_external_target, 
  category.hidefilter as __category_hidefilter, 
  category.hidetop as __category_hidetop, 
  category.stream_id as __category_stream_id, 
  category.hide_sortings as __category_hide_sortings, 
  categoryAttribute.id as __categoryAttribute_id, 
  categoryAttribute.categoryID as __categoryAttribute_categoryID, 
  categoryAttribute.attribute1 as __categoryAttribute_attribute1, 
  categoryAttribute.attribute2 as __categoryAttribute_attribute2, 
  categoryAttribute.attribute3 as __categoryAttribute_attribute3, 
  categoryAttribute.attribute4 as __categoryAttribute_attribute4, 
  categoryAttribute.attribute5 as __categoryAttribute_attribute5, 
  categoryAttribute.attribute6 as __categoryAttribute_attribute6, 
  categoryAttribute.swkwe_show_soldout as __categoryAttribute_swkwe_show_soldout, 
  categoryAttribute.swkwe_emotion_category_slider_media as __categoryAttribute_swkwe_emotion_category_slider_media, 
  media.id as __media_id, 
  media.albumID as __media_albumID, 
  media.name as __media_name, 
  media.description as __media_description, 
  media.path as __media_path, 
  media.type as __media_type, 
  media.extension as __media_extension, 
  media.file_size as __media_file_size, 
  media.width as __media_width, 
  media.height as __media_height, 
  media.userID as __media_userID, 
  media.created as __media_created, 
  mediaSettings.id as __mediaSettings_id, 
  mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, 
  mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, 
  mediaSettings.icon as __mediaSettings_icon, 
  mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, 
  mediaAttribute.id as __mediaAttribute_id, 
  mediaAttribute.mediaID as __mediaAttribute_mediaID, 
  stream.id as __stream_id, 
  stream.name as __stream_name, 
  stream.description as __stream_description, 
  stream.type as __stream_type, 
  productStreamAttribute.id as __productStreamAttribute_id, 
  productStreamAttribute.streamID as __productStreamAttribute_streamID, 
  GROUP_CONCAT(customerGroups.customergroupID) as __category_customer_groups 
FROM 
  s_categories category 
  LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id 
  LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id 
  LEFT JOIN s_media media ON media.id = category.mediaID 
  LEFT JOIN s_product_streams stream ON category.stream_id = stream.id 
  LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID 
  LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id 
  LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId 
WHERE 
  (
    category.id IN (: categories)
  ) 
  AND (category.active = 1) 
  AND (
    category.shops IS NULL 
    OR category.shops LIKE : shopId
  ) 
GROUP BY 
  category.id

array:2 [
  ":categories" => array:10 [
    0 => 11
    1 => 3
    2 => 6
    3 => 14
    4 => 8
    5 => 10
    6 => 12
    7 => 7
    8 => 9
    9 => 5
  ]
  ":shopId" => "%|1|%"
]

SELECT 
  blog.id as id, 
  blog.title, 
  blog.short_description as shortDescription, 
  blog.description as description, 
  blog.display_date as displayDate, 
  blog.category_id as categoryId, 
  blog.meta_keywords as metaKeywords, 
  blog.meta_description as metaDescription, 
  blog.meta_title as metaTitle, 
  mappingMedia.media_id as mediaId 
FROM 
  s_blog blog 
  LEFT JOIN s_blog_media mappingMedia ON mappingMedia.blog_id = blog.id 
  AND mappingMedia.preview = 1 
  LEFT JOIN s_categories category ON category.id = blog.category_id 
WHERE 
  (blog.active = 1) 
  AND (blog.display_date < : now) 
  AND (
    (blog.category_id = : categoryId) 
    OR (
      category.path LIKE : subCategoryPath
    )
  ) 
ORDER BY 
  blog.display_date DESC 
LIMIT 
  10

array:3 [
  "now" => DateTime @1732739571 {#5125
    date: 2024-11-27 21:32:51.159856 Europe/Berlin (+01:00)
  }
  "subCategoryPath" => "%|13|%"
  "categoryId" => "13"
]

SELECT 
  blog.id as id, 
  blog.title, 
  blog.short_description as shortDescription, 
  blog.description as description, 
  blog.display_date as displayDate, 
  blog.category_id as categoryId, 
  blog.meta_keywords as metaKeywords, 
  blog.meta_description as metaDescription, 
  blog.meta_title as metaTitle, 
  mappingMedia.media_id as mediaId 
FROM 
  s_blog blog 
  LEFT JOIN s_blog_media mappingMedia ON mappingMedia.blog_id = blog.id 
  AND mappingMedia.preview = 1 
  LEFT JOIN s_categories category ON category.id = blog.category_id 
WHERE 
  (blog.active = 1) 
  AND (blog.display_date < : now) 
  AND (
    (blog.category_id = : categoryId) 
    OR (
      category.path LIKE : subCategoryPath
    )
  ) 
ORDER BY 
  blog.display_date DESC 
LIMIT 
  27

array:3 [
  "now" => DateTime @1732739571 {#5126
    date: 2024-11-27 21:32:51.160477 Europe/Berlin (+01:00)
  }
  "subCategoryPath" => "%|13|%"
  "categoryId" => "13"
]

SELECT 
  SQL_CALC_FOUND_ROWS product.id as __product_id, 
  variant.id as __variant_id, 
  variant.ordernumber as __variant_ordernumber 
FROM 
  s_articles product 
  INNER JOIN s_articles_details variant ON variant.id = product.main_detail_id 
  AND variant.active = 1 
  AND product.active = 1 
  INNER JOIN s_articles_categories_ro productCategory ON productCategory.articleID = product.id 
  AND productCategory.categoryID IN (: productCategory) 
  LEFT JOIN s_articles_avoid_customergroups avoidCustomerGroup ON avoidCustomerGroup.articleID = product.id 
  AND avoidCustomerGroup.customerGroupId IN (
    : customerGroupIds38ba0f9d2195aa1ed719d712288c9fae
  ) 
  INNER JOIN s_articles_details availableVariant ON availableVariant.articleID = product.id 
  AND availableVariant.active = 1 
  AND (
    (
      availableVariant.laststock * availableVariant.instock
    ) >= (
      availableVariant.laststock * availableVariant.minpurchase
    )
  ) 
  INNER JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id 
  LEFT JOIN s_articles_attributes availableVariantAttribute ON availableVariant.id = availableVariantAttribute.articledetailsID 
WHERE 
  (
    avoidCustomerGroup.articleID IS NULL
  ) 
  AND (
    (
      availableVariant.laststock * (
        availableVariant.instock - GREATEST(
          0, 
          IF(
            availableVariantAttribute.swkwe_set_reserved_stock IS NOT NULL, 
            availableVariantAttribute.swkwe_set_reserved_stock, 
            0
          )
        )
      )
    ) >= (
      availableVariant.laststock * availableVariant.minpurchase
    )
  ) 
GROUP BY 
  product.id 
ORDER BY 
  rand() ASC, 
  variant.id ASC 
LIMIT 
  53

array:2 [
  ":productCategory" => array:1 [
    0 => 3
  ]
  ":customerGroupIds38ba0f9d2195aa1ed719d712288c9fae" => array:1 [
    0 => 1
  ]
]

SELECT 
  FOUND_ROWS()

[]

SELECT 
  SQL_CALC_FOUND_ROWS product.id as __product_id, 
  variant.id as __variant_id, 
  variant.ordernumber as __variant_ordernumber 
FROM 
  s_articles product 
  INNER JOIN s_articles_details variant ON variant.id = product.main_detail_id 
  AND variant.active = 1 
  AND product.active = 1 
  INNER JOIN s_articles_categories_ro productCategory ON productCategory.articleID = product.id 
  AND productCategory.categoryID IN (: productCategory) 
  LEFT JOIN s_articles_avoid_customergroups avoidCustomerGroup ON avoidCustomerGroup.articleID = product.id 
  AND avoidCustomerGroup.customerGroupId IN (
    : customerGroupIds38ba0f9d2195aa1ed719d712288c9fae
  ) 
  INNER JOIN s_articles_details availableVariant ON availableVariant.articleID = product.id 
  AND availableVariant.active = 1 
  AND (
    (
      availableVariant.laststock * availableVariant.instock
    ) >= (
      availableVariant.laststock * availableVariant.minpurchase
    )
  ) 
  INNER JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id 
  LEFT JOIN s_articles_attributes availableVariantAttribute ON availableVariant.id = availableVariantAttribute.articledetailsID 
WHERE 
  (
    avoidCustomerGroup.articleID IS NULL
  ) 
  AND (
    (
      availableVariant.laststock * (
        availableVariant.instock - GREATEST(
          0, 
          IF(
            availableVariantAttribute.swkwe_set_reserved_stock IS NOT NULL, 
            availableVariantAttribute.swkwe_set_reserved_stock, 
            0
          )
        )
      )
    ) >= (
      availableVariant.laststock * availableVariant.minpurchase
    )
  ) 
GROUP BY 
  product.id 
ORDER BY 
  rand() ASC, 
  variant.id ASC 
LIMIT 
  1

array:2 [
  ":productCategory" => array:1 [
    0 => 14
  ]
  ":customerGroupIds38ba0f9d2195aa1ed719d712288c9fae" => array:1 [
    0 => 1
  ]
]

SELECT 
  FOUND_ROWS()

[]

SELECT 
  SQL_CALC_FOUND_ROWS product.id as __product_id, 
  variant.id as __variant_id, 
  variant.ordernumber as __variant_ordernumber 
FROM 
  s_articles product 
  INNER JOIN s_articles_details variant ON variant.id = product.main_detail_id 
  AND variant.active = 1 
  AND product.active = 1 
  INNER JOIN s_articles_categories_ro productCategory ON productCategory.articleID = product.id 
  AND productCategory.categoryID IN (: productCategory) 
  LEFT JOIN s_articles_avoid_customergroups avoidCustomerGroup ON avoidCustomerGroup.articleID = product.id 
  AND avoidCustomerGroup.customerGroupId IN (
    : customerGroupIds38ba0f9d2195aa1ed719d712288c9fae
  ) 
  INNER JOIN s_articles_details availableVariant ON availableVariant.articleID = product.id 
  AND availableVariant.active = 1 
  AND (
    (
      availableVariant.laststock * availableVariant.instock
    ) >= (
      availableVariant.laststock * availableVariant.minpurchase
    )
  ) 
  LEFT JOIN s_articles_top_seller_ro topSeller ON topSeller.article_id = product.id 
  INNER JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id 
  LEFT JOIN s_articles_attributes availableVariantAttribute ON availableVariant.id = availableVariantAttribute.articledetailsID 
WHERE 
  (
    avoidCustomerGroup.articleID IS NULL
  ) 
  AND (
    (
      availableVariant.laststock * (
        availableVariant.instock - GREATEST(
          0, 
          IF(
            availableVariantAttribute.swkwe_set_reserved_stock IS NOT NULL, 
            availableVariantAttribute.swkwe_set_reserved_stock, 
            0
          )
        )
      )
    ) >= (
      availableVariant.laststock * availableVariant.minpurchase
    )
  ) 
GROUP BY 
  product.id 
ORDER BY 
  topSeller.sales DESC, 
  variant.id ASC 
LIMIT 
  25

array:2 [
  ":productCategory" => array:1 [
    0 => 3
  ]
  ":customerGroupIds38ba0f9d2195aa1ed719d712288c9fae" => array:1 [
    0 => 1
  ]
]

SELECT 
  FOUND_ROWS()

[]

SELECT 
  variant.id as variantId, 
  variant.ordernumber as number, 
  variant.articleID as productId 
FROM 
  s_articles_details variant 
WHERE 
  variant.ordernumber IN(: numbers)

array:1 [
  ":numbers" => array:8 [
    0 => "teamsport-friedrichsort-shop.de"
    1 => "teamsport-friedrichsort-shop.de"
    2 => "SW10006"
    3 => "SW10007"
    4 => "SW10056"
    5 => "SW10006"
    6 => "SW10007.1"
    7 => "SW10031.2"
  ]
]

SELECT 
  product.id as __product_id, 
  product.supplierID as __product_supplierID, 
  product.name as __product_name, 
  product.description as __product_description, 
  product.description_long as __product_description_long, 
  product.shippingtime as __product_shippingtime, 
  product.datum as __product_datum, 
  product.active as __product_active, 
  product.taxID as __product_taxID, 
  product.pseudosales as __product_pseudosales, 
  product.topseller as __product_topseller, 
  product.metaTitle as __product_metaTitle, 
  product.keywords as __product_keywords, 
  product.changetime as __product_changetime, 
  product.pricegroupID as __product_pricegroupID, 
  product.pricegroupActive as __product_pricegroupActive, 
  product.filtergroupID as __product_filtergroupID, 
  product.crossbundlelook as __product_crossbundlelook, 
  product.notification as __product_notification, 
  product.template as __product_template, 
  product.mode as __product_mode, 
  product.main_detail_id as __product_main_detail_id, 
  product.available_from as __product_available_from, 
  product.available_to as __product_available_to, 
  product.configurator_set_id as __product_configurator_set_id, 
  productAttribute.id as __productAttribute_id, 
  productAttribute.articledetailsID as __productAttribute_articledetailsID, 
  productAttribute.attr1 as __productAttribute_attr1, 
  productAttribute.attr2 as __productAttribute_attr2, 
  productAttribute.attr3 as __productAttribute_attr3, 
  productAttribute.attr4 as __productAttribute_attr4, 
  productAttribute.attr5 as __productAttribute_attr5, 
  productAttribute.attr6 as __productAttribute_attr6, 
  productAttribute.attr7 as __productAttribute_attr7, 
  productAttribute.attr8 as __productAttribute_attr8, 
  productAttribute.attr9 as __productAttribute_attr9, 
  productAttribute.attr10 as __productAttribute_attr10, 
  productAttribute.attr11 as __productAttribute_attr11, 
  productAttribute.attr12 as __productAttribute_attr12, 
  productAttribute.attr13 as __productAttribute_attr13, 
  productAttribute.attr14 as __productAttribute_attr14, 
  productAttribute.attr15 as __productAttribute_attr15, 
  productAttribute.attr16 as __productAttribute_attr16, 
  productAttribute.attr17 as __productAttribute_attr17, 
  productAttribute.attr18 as __productAttribute_attr18, 
  productAttribute.attr19 as __productAttribute_attr19, 
  productAttribute.attr20 as __productAttribute_attr20, 
  productAttribute.swkwe_pseudovariants_position as __productAttribute_swkwe_pseudovariants_position, 
  productAttribute.swkwe_pseudovariants_groupname as __productAttribute_swkwe_pseudovariants_groupname, 
  productAttribute.swkwe_pseudovariant_name as __productAttribute_swkwe_pseudovariant_name, 
  productAttribute.swkwe_show_soldout as __productAttribute_swkwe_show_soldout, 
  productAttribute.swkwe_category_show_soldout as __productAttribute_swkwe_category_show_soldout, 
  productAttribute.swkwe_is_set_article as __productAttribute_swkwe_is_set_article, 
  productAttribute.swkwe_set_reserved_stock as __productAttribute_swkwe_set_reserved_stock, 
  productAttribute.swkwe_set_price_calculation as __productAttribute_swkwe_set_price_calculation, 
  topSeller.sales as __topSeller_sales, 
  variant.id as __variant_id, 
  variant.ordernumber as __variant_ordernumber, 
  variant.suppliernumber as __variant_suppliernumber, 
  variant.kind as __variant_kind, 
  variant.additionaltext as __variant_additionaltext, 
  variant.sales as __variant_sales, 
  variant.active as __variant_active, 
  variant.instock as __variant_instock, 
  variant.stockmin as __variant_stockmin, 
  variant.weight as __variant_weight, 
  variant.position as __variant_position, 
  variant.width as __variant_width, 
  variant.height as __variant_height, 
  variant.length as __variant_length, 
  variant.ean as __variant_ean, 
  variant.unitID as __variant_unitID, 
  variant.releasedate as __variant_releasedate, 
  variant.shippingfree as __variant_shippingfree, 
  variant.shippingtime as __variant_shippingtime, 
  variant.laststock as __product_laststock, 
  unit.id as __unit_id, 
  unit.description as __unit_description, 
  unit.unit as __unit_unit, 
  variant.packunit as __unit_packunit, 
  variant.purchaseunit as __unit_purchaseunit, 
  variant.referenceunit as __unit_referenceunit, 
  variant.purchasesteps as __unit_purchasesteps, 
  variant.minpurchase as __unit_minpurchase, 
  variant.maxpurchase as __unit_maxpurchase, 
  tax.id as __tax_id, 
  tax.tax as __tax_tax, 
  tax.description as __tax_description, 
  priceGroup.id as __priceGroup_id, 
  priceGroup.description as __priceGroup_description, 
  manufacturer.id as __manufacturer_id, 
  manufacturer.name as __manufacturer_name, 
  manufacturer.img as __manufacturer_img, 
  manufacturer.link as __manufacturer_link, 
  manufacturer.description as __manufacturer_description, 
  manufacturer.meta_title as __manufacturer_meta_title, 
  manufacturer.meta_description as __manufacturer_meta_description, 
  manufacturer.meta_keywords as __manufacturer_meta_keywords, 
  manufacturerAttribute.id as __manufacturerAttribute_id, 
  manufacturerAttribute.supplierID as __manufacturerAttribute_supplierID, 
  esd.id as __esd_id, 
  esd.articleID as __esd_articleID, 
  esd.articledetailsID as __esd_articledetailsID, 
  esd.file as __esd_file, 
  esd.serials as __esd_serials, 
  esd.notification as __esd_notification, 
  esd.maxdownloads as __esd_maxdownloads, 
  esd.datum as __esd_datum, 
  esdAttribute.id as __esdAttribute_id, 
  esdAttribute.esdID as __esdAttribute_esdID, 
  (
    SELECT 
      1 
    FROM 
      s_articles_esd variantEsd 
    WHERE 
      variantEsd.articleID = product.id 
    LIMIT 
      1
  ) as __product_has_esd, 
  (
    SELECT 
      GROUP_CONCAT(
        customerGroups.customergroupId SEPARATOR '|'
      ) 
    FROM 
      s_articles_avoid_customergroups customerGroups 
    WHERE 
      customerGroups.articleID = product.id
  ) as __product_blocked_customer_groups, 
  (
    SELECT 
      COUNT(availableVariant.id) 
    FROM 
      s_articles_details availableVariant 
    WHERE 
      (
        availableVariant.articleID = product.id
      ) 
      AND (availableVariant.active = 1) 
      AND (
        (
          availableVariant.laststock * availableVariant.instock
        ) >= (
          availableVariant.laststock * availableVariant.minpurchase
        )
      )
  ) as __product_has_available_variants, 
  (
    SELECT 
      COUNT(
        DISTINCT ROUND(prices.price, 2)
      ) as priceCount 
    FROM 
      s_articles_prices prices 
      INNER JOIN s_articles_details priceVariant ON priceVariant.id = prices.articledetailsID 
      and priceVariant.active = 1 
    WHERE 
      (prices.from = 1) 
      AND (prices.pricegroup = : fallback) 
      AND (prices.articleID = product.id) 
      AND (
        (
          priceVariant.laststock * priceVariant.instock
        ) >= (
          priceVariant.laststock * priceVariant.minpurchase
        )
      )
  ) as __product_fallback_price_count, 
  manufacturerMedia.id as __manufacturer_img_id 
FROM 
  s_articles_details variant 
  INNER JOIN s_articles product ON product.id = variant.articleID 
  LEFT JOIN s_core_units unit ON unit.id = variant.unitID 
  LEFT JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id 
  LEFT JOIN s_articles_esd esd ON esd.articledetailsID = variant.id 
  INNER JOIN s_core_tax tax ON tax.id = product.taxID 
  LEFT JOIN s_articles_supplier manufacturer ON manufacturer.id = product.supplierID 
  LEFT JOIN s_core_pricegroups priceGroup ON priceGroup.id = product.pricegroupID 
  LEFT JOIN s_articles_supplier_attributes manufacturerAttribute ON manufacturerAttribute.supplierID = product.supplierID 
  LEFT JOIN s_articles_top_seller_ro topSeller ON topSeller.article_id = product.id 
  LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img 
  LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id 
WHERE 
  (
    variant.ordernumber IN (: numbers)
  ) 
  AND (variant.active = 1) 
  AND (product.active = 1) 
HAVING 
  __product_has_available_variants >= 1

array:2 [
  ":fallback" => "EK"
  ":numbers" => array:61 [
    0 => "SW10006"
    1 => "SW10007"
    2 => "SW10056"
    3 => "SW10007.1"
    4 => "SW10031.2"
    5 => "SW10066"
    6 => "5IN-01300SS"
    7 => "SW10001"
    8 => "ket-001"
    9 => "SW10062"
    10 => "SW10017"
    11 => "SW10032"
    12 => "1452-000004007"
    13 => "SW10029"
    14 => "test2"
    15 => "se-01"
    16 => "SW10021"
    17 => "SW10009.8"
    18 => "SW10031"
    19 => "IP-6020"
    20 => "SW10014"
    21 => "Akon_KV"
    22 => "SW10068"
    23 => "SW10071"
    24 => "SW10067"
    25 => "SW10043"
    26 => "SW10008"
    27 => "SW10005.4"
    28 => "IP-6019"
    29 => "test1"
    30 => "SW10040"
    31 => "SW10079"
    32 => "5IN-01400SS"
    33 => "SW10042"
    34 => "SW10019"
    35 => "SW10083"
    36 => "B1234"
    37 => "SW10022"
    38 => "SW10004.2"
    39 => "SW10010"
    40 => "SW10003"
    41 => "SW10025"
    42 => "SW10027"
    43 => "SW10036"
    44 => "SW10012"
    45 => "SW10016"
    46 => "SW10061"
    47 => "test3"
    48 => "SW10028"
    49 => "SW10023"
    50 => "SW10030"
    51 => "SW10054"
    52 => "SW10018"
    53 => "SW10034"
    54 => "anh-001"
    55 => "Akon_LS"
    56 => "SW10015"
    57 => "SW10020"
    58 => "SW10024"
    59 => "SW10026"
    60 => "SW10033"
  ]
]

SELECT 
  variant.ordernumber, 
  COUNT(availableVariant.id) 
FROM 
  s_articles_details variant 
  INNER JOIN s_articles_details availableVariant ON variant.articleID = availableVariant.articleID 
  LEFT JOIN s_articles_attributes availableVariantAttribute ON availableVariant.id = availableVariantAttribute.articledetailsID 
WHERE 
  (
    variant.ordernumber IN (: numbers)
  ) 
  AND (availableVariant.active = 1) 
  AND (
    (
      availableVariant.laststock * (
        availableVariant.instock - GREATEST(
          0, 
          IF(
            availableVariantAttribute.swkwe_set_reserved_stock IS NOT NULL, 
            availableVariantAttribute.swkwe_set_reserved_stock, 
            0
          )
        )
      )
    ) >= (
      availableVariant.laststock * availableVariant.minpurchase
    )
  ) 
GROUP BY 
  variant.id

array:1 [
  ":numbers" => array:61 [
    0 => "SW10003"
    1 => "SW10001"
    2 => "SW10006"
    3 => "SW10007"
    4 => "SW10008"
    5 => "SW10010"
    6 => "SW10012"
    7 => "SW10014"
    8 => "SW10007.1"
    9 => "SW10005.4"
    10 => "SW10009.8"
    11 => "SW10004.2"
    12 => "SW10015"
    13 => "SW10016"
    14 => "SW10017"
    15 => "SW10018"
    16 => "SW10019"
    17 => "SW10020"
    18 => "SW10021"
    19 => "SW10022"
    20 => "SW10023"
    21 => "SW10024"
    22 => "SW10025"
    23 => "SW10026"
    24 => "SW10027"
    25 => "SW10028"
    26 => "SW10029"
    27 => "SW10030"
    28 => "SW10031"
    29 => "SW10031.2"
    30 => "SW10032"
    31 => "SW10033"
    32 => "SW10034"
    33 => "SW10036"
    34 => "SW10040"
    35 => "SW10042"
    36 => "SW10043"
    37 => "1452-000004007"
    38 => "Akon_LS"
    39 => "Akon_KV"
    40 => "5IN-01300SS"
    41 => "5IN-01400SS"
    42 => "IP-6020"
    43 => "IP-6019"
    44 => "SW10054"
    45 => "B1234"
    46 => "SW10056"
    47 => "test1"
    48 => "test2"
    49 => "test3"
    50 => "SW10061"
    51 => "SW10062"
    52 => "SW10066"
    53 => "SW10067"
    54 => "SW10068"
    55 => "SW10071"
    56 => "SW10079"
    57 => "anh-001"
    58 => "ket-001"
    59 => "se-01"
    60 => "SW10083"
  ]
]

SELECT 
  pseudovariant.article_id as __pseudovariant_productId, 
  pseudovariantGroup.id as __pseudovariantGroup_id, 
  pseudovariantGroup.mainvariant_id as __pseudovariantGroup_mainProductId, 
  pseudovariantGroup.template as __pseudovariantGroup_template 
FROM 
  swkwe_pseudovariants_variantgroups pseudovariantGroup 
  INNER JOIN swkwe_pseudovariants_variantgroups_articles pseudovariant ON pseudovariantGroup.id = pseudovariant.variantgroup_id 
WHERE 
  pseudovariant.article_id IN (: productIds)

array:1 [
  ":productIds" => array:61 [
    "SW10003" => 3
    "SW10001" => 1
    "SW10006" => 6
    "SW10007" => 7
    "SW10008" => 8
    "SW10010" => 10
    "SW10012" => 12
    "SW10014" => 14
    "SW10007.1" => 7
    "SW10005.4" => 5
    "SW10009.8" => 9
    "SW10004.2" => 4
    "SW10015" => 15
    "SW10016" => 16
    "SW10017" => 17
    "SW10018" => 18
    "SW10019" => 19
    "SW10020" => 20
    "SW10021" => 21
    "SW10022" => 22
    "SW10023" => 23
    "SW10024" => 24
    "SW10025" => 25
    "SW10026" => 26
    "SW10027" => 27
    "SW10028" => 28
    "SW10029" => 29
    "SW10030" => 30
    "SW10031" => 31
    "SW10031.2" => 31
    "SW10032" => 32
    "SW10033" => 33
    "SW10034" => 34
    "SW10036" => 36
    "SW10040" => 41
    "SW10042" => 43
    "SW10043" => 44
    "1452-000004007" => 45
    "Akon_LS" => 46
    "Akon_KV" => 47
    "5IN-01300SS" => 49
    "5IN-01400SS" => 50
    "IP-6020" => 52
    "IP-6019" => 53
    "SW10054" => 58
    "B1234" => 60
    "SW10056" => 63
    "test1" => 68
    "test2" => 69
    "test3" => 70
    "SW10061" => 71
    "SW10062" => 72
    "SW10066" => 76
    "SW10067" => 77
    "SW10068" => 78
    "SW10071" => 81
    "SW10079" => 89
    "anh-001" => 90
    "ket-001" => 91
    "se-01" => 92
    "SW10083" => 93
  ]
]

SELECT 
  variant.ordernumber as number, 
  media.id as __media_id, 
  media.albumID as __media_albumID, 
  media.name as __media_name, 
  media.description as __media_description, 
  media.path as __media_path, 
  media.type as __media_type, 
  media.extension as __media_extension, 
  media.file_size as __media_file_size, 
  media.width as __media_width, 
  media.height as __media_height, 
  media.userID as __media_userID, 
  media.created as __media_created, 
  mediaSettings.id as __mediaSettings_id, 
  mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, 
  mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, 
  mediaSettings.icon as __mediaSettings_icon, 
  mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, 
  mediaAttribute.id as __mediaAttribute_id, 
  mediaAttribute.mediaID as __mediaAttribute_mediaID, 
  image.id as __image_id, 
  image.articleID as __image_articleID, 
  image.img as __image_img, 
  image.main as __image_main, 
  image.description as __image_description, 
  image.position as __image_position, 
  image.width as __image_width, 
  image.height as __image_height, 
  image.extension as __image_extension, 
  image.parent_id as __image_parent_id, 
  image.media_id as __image_media_id, 
  imageAttribute.id as __imageAttribute_id, 
  imageAttribute.imageID as __imageAttribute_imageID, 
  imageAttribute.attribute1 as __imageAttribute_attribute1, 
  imageAttribute.attribute2 as __imageAttribute_attribute2, 
  imageAttribute.attribute3 as __imageAttribute_attribute3 
FROM 
  s_articles_img image 
  INNER JOIN s_media media ON image.media_id = media.id 
  INNER JOIN s_articles_img childImage ON childImage.parent_id = image.id 
  INNER JOIN s_articles_details variant ON variant.id = childImage.article_detail_id 
  LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id 
  LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id 
  INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID 
WHERE 
  childImage.article_detail_id IN (: products) 
ORDER BY 
  image.main ASC, 
  image.position ASC

array:1 [
  ":products" => array:61 [
    0 => 3
    1 => 1
    2 => 6
    3 => 7
    4 => 8
    5 => 10
    6 => 12
    7 => 14
    8 => 17
    9 => 23
    10 => 34
    11 => 39
    12 => 42
    13 => 43
    14 => 44
    15 => 45
    16 => 46
    17 => 47
    18 => 64
    19 => 65
    20 => 71
    21 => 72
    22 => 73
    23 => 74
    24 => 78
    25 => 79
    26 => 83
    27 => 89
    28 => 90
    29 => 92
    30 => 93
    31 => 94
    32 => 95
    33 => 97
    34 => 102
    35 => 104
    36 => 105
    37 => 106
    38 => 107
    39 => 108
    40 => 110
    41 => 111
    42 => 113
    43 => 114
    44 => 166
    45 => 168
    46 => 171
    47 => 176
    48 => 177
    49 => 178
    50 => 179
    51 => 180
    52 => 188
    53 => 189
    54 => 190
    55 => 212
    56 => 222
    57 => 238
    58 => 239
    59 => 240
    60 => 241
  ]
]

SELECT 
  media.id as __media_id, 
  media.albumID as __media_albumID, 
  media.name as __media_name, 
  media.description as __media_description, 
  media.path as __media_path, 
  media.type as __media_type, 
  media.extension as __media_extension, 
  media.file_size as __media_file_size, 
  media.width as __media_width, 
  media.height as __media_height, 
  media.userID as __media_userID, 
  media.created as __media_created, 
  mediaSettings.id as __mediaSettings_id, 
  mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, 
  mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, 
  mediaSettings.icon as __mediaSettings_icon, 
  mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, 
  mediaAttribute.id as __mediaAttribute_id, 
  mediaAttribute.mediaID as __mediaAttribute_mediaID, 
  image.id as __image_id, 
  image.articleID as __image_articleID, 
  image.img as __image_img, 
  image.main as __image_main, 
  image.description as __image_description, 
  image.position as __image_position, 
  image.width as __image_width, 
  image.height as __image_height, 
  image.extension as __image_extension, 
  image.parent_id as __image_parent_id, 
  image.media_id as __image_media_id, 
  imageAttribute.id as __imageAttribute_id, 
  imageAttribute.imageID as __imageAttribute_imageID, 
  imageAttribute.attribute1 as __imageAttribute_attribute1, 
  imageAttribute.attribute2 as __imageAttribute_attribute2, 
  imageAttribute.attribute3 as __imageAttribute_attribute3 
FROM 
  s_articles_img image 
  INNER JOIN s_media media ON image.media_id = media.id 
  LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id 
  LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id 
  LEFT JOIN s_articles_img childImage ON childImage.parent_id = image.id 
  INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID 
WHERE 
  (image.main = 1) 
  AND (
    image.articleID IN (: products)
  )

array:1 [
  ":products" => array:50 [
    0 => 3
    1 => 1
    2 => 6
    3 => 7
    4 => 8
    5 => 10
    6 => 12
    8 => 15
    9 => 16
    10 => 17
    11 => 18
    12 => 19
    13 => 20
    14 => 21
    15 => 23
    16 => 24
    17 => 25
    18 => 26
    19 => 27
    20 => 28
    21 => 30
    22 => 32
    23 => 33
    24 => 34
    25 => 36
    26 => 41
    27 => 43
    28 => 44
    29 => 45
    30 => 46
    31 => 47
    32 => 49
    33 => 50
    34 => 52
    35 => 53
    36 => 58
    37 => 60
    38 => 68
    39 => 69
    40 => 70
    41 => 72
    42 => 76
    43 => 77
    44 => 78
    45 => 81
    46 => 89
    47 => 90
    48 => 91
    49 => 92
    50 => 93
  ]
]

SELECT 
  media.id as __media_id, 
  media.albumID as __media_albumID, 
  media.name as __media_name, 
  media.description as __media_description, 
  media.path as __media_path, 
  media.type as __media_type, 
  media.extension as __media_extension, 
  media.file_size as __media_file_size, 
  media.width as __media_width, 
  media.height as __media_height, 
  media.userID as __media_userID, 
  media.created as __media_created, 
  mediaSettings.id as __mediaSettings_id, 
  mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, 
  mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, 
  mediaSettings.icon as __mediaSettings_icon, 
  mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, 
  mediaAttribute.id as __mediaAttribute_id, 
  mediaAttribute.mediaID as __mediaAttribute_mediaID, 
  image.id as __image_id, 
  image.articleID as __image_articleID, 
  image.img as __image_img, 
  image.main as __image_main, 
  image.description as __image_description, 
  image.position as __image_position, 
  image.width as __image_width, 
  image.height as __image_height, 
  image.extension as __image_extension, 
  image.parent_id as __image_parent_id, 
  image.media_id as __image_media_id, 
  imageAttribute.id as __imageAttribute_id, 
  imageAttribute.imageID as __imageAttribute_imageID, 
  imageAttribute.attribute1 as __imageAttribute_attribute1, 
  imageAttribute.attribute2 as __imageAttribute_attribute2, 
  imageAttribute.attribute3 as __imageAttribute_attribute3 
FROM 
  s_articles_img image 
  INNER JOIN s_media media ON image.media_id = media.id 
  LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id 
  LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id 
  LEFT JOIN s_articles_img childImage ON childImage.parent_id = image.id 
  INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID 
WHERE 
  (image.main = 1) 
  AND (
    image.articleID IN (: products)
  )