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 
  subshopID as shopId, 
  path, 
  org_path as orgPath, 
  main 
FROM 
  s_core_rewrite_urls 
WHERE 
  path LIKE : pathInfo 
ORDER BY 
  subshopID = : shopId DESC, 
  main DESC 
LIMIT 
  1

array:2 [
  ":shopId" => 1
  ":pathInfo" => "bekleidung/"
]

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 
  t0.sorting_ids AS sorting_ids_1, 
  t0.hide_sortings AS hide_sortings_2, 
  t0.facet_ids AS facet_ids_3, 
  t0.shops AS shops_4, 
  t0.id AS id_5, 
  t0.parent AS parent_6, 
  t0.stream_id AS stream_id_7, 
  t0.description AS description_8, 
  t0.position AS position_9, 
  t0.meta_title AS meta_title_10, 
  t0.metakeywords AS metakeywords_11, 
  t0.metadescription AS metadescription_12, 
  t0.cmsheadline AS cmsheadline_13, 
  t0.cmstext AS cmstext_14, 
  t0.active AS active_15, 
  t0.template AS template_16, 
  t0.product_box_layout AS product_box_layout_17, 
  t0.blog AS blog_18, 
  t0.path AS path_19, 
  t0.external AS external_20, 
  t0.external_target AS external_target_21, 
  t0.hidefilter AS hidefilter_22, 
  t0.hidetop AS hidetop_23, 
  t0.changed AS changed_24, 
  t0.added AS added_25, 
  t0.mediaID AS mediaID_26, 
  t27.id AS id_28, 
  t27.categoryID AS categoryID_29, 
  t27.attribute1 AS attribute1_30, 
  t27.attribute2 AS attribute2_31, 
  t27.attribute3 AS attribute3_32, 
  t27.attribute4 AS attribute4_33, 
  t27.attribute5 AS attribute5_34, 
  t27.attribute6 AS attribute6_35, 
  t27.swkwe_show_soldout AS swkwe_show_soldout_36, 
  t27.swkwe_emotion_category_slider_media AS swkwe_emotion_category_slider_media_37, 
  t27.categoryID AS categoryID_38, 
  t0.mediaID AS mediaID_39, 
  t0.stream_id AS stream_id_40, 
  t0.parent AS parent_41 
FROM 
  s_categories t0 
  LEFT JOIN s_categories_attributes t27 ON t27.categoryID = t0.id 
WHERE 
  t0.id = ?

array:1 [
  0 => "6"
]

SELECT 
  t0.sorting_ids AS sorting_ids_1, 
  t0.hide_sortings AS hide_sortings_2, 
  t0.facet_ids AS facet_ids_3, 
  t0.shops AS shops_4, 
  t0.id AS id_5, 
  t0.parent AS parent_6, 
  t0.stream_id AS stream_id_7, 
  t0.description AS description_8, 
  t0.position AS position_9, 
  t0.meta_title AS meta_title_10, 
  t0.metakeywords AS metakeywords_11, 
  t0.metadescription AS metadescription_12, 
  t0.cmsheadline AS cmsheadline_13, 
  t0.cmstext AS cmstext_14, 
  t0.active AS active_15, 
  t0.template AS template_16, 
  t0.product_box_layout AS product_box_layout_17, 
  t0.blog AS blog_18, 
  t0.path AS path_19, 
  t0.external AS external_20, 
  t0.external_target AS external_target_21, 
  t0.hidefilter AS hidefilter_22, 
  t0.hidetop AS hidetop_23, 
  t0.changed AS changed_24, 
  t0.added AS added_25, 
  t0.mediaID AS mediaID_26, 
  t27.id AS id_28, 
  t27.categoryID AS categoryID_29, 
  t27.attribute1 AS attribute1_30, 
  t27.attribute2 AS attribute2_31, 
  t27.attribute3 AS attribute3_32, 
  t27.attribute4 AS attribute4_33, 
  t27.attribute5 AS attribute5_34, 
  t27.attribute6 AS attribute6_35, 
  t27.swkwe_show_soldout AS swkwe_show_soldout_36, 
  t27.swkwe_emotion_category_slider_media AS swkwe_emotion_category_slider_media_37, 
  t27.categoryID AS categoryID_38, 
  t0.mediaID AS mediaID_39, 
  t0.stream_id AS stream_id_40, 
  t0.parent AS parent_41 
FROM 
  s_categories t0 
  LEFT JOIN s_categories_attributes t27 ON t27.categoryID = t0.id 
WHERE 
  t0.id = ?

array:1 [
  0 => 3
]

SELECT 
  s0_.description AS description_0 
FROM 
  s_categories s0_ 
WHERE 
  s0_.id = ?

array:1 [
  0 => 3
]

SELECT 
  `objectdata` 
FROM 
  `s_core_translations` 
WHERE 
  (`objecttype` = : type) 
  AND (`objectkey` = : key) 
  AND (`objectlanguage` = : language)

array:3 [
  ":type" => "category"
  ":key" => 3
  ":language" => 1
]

SELECT 
  s0_.description AS description_0 
FROM 
  s_categories s0_ 
WHERE 
  s0_.id = ?

array:1 [
  0 => 6
]

SELECT 
  `objectdata` 
FROM 
  `s_core_translations` 
WHERE 
  (`objecttype` = : type) 
  AND (`objectkey` = : key) 
  AND (`objectlanguage` = : language)

array:3 [
  ":type" => "category"
  ":key" => "6"
  ":language" => 1
]

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:1 [
    0 => "6"
  ]
  ":shopId" => "%|1|%"
]

SELECT 
  s0_.show_listing AS show_listing_0, 
  s0_.template_id AS template_id_1, 
  s0_.id AS id_2, 
  s0_.parent_id AS parent_id_3, 
  s0_.active AS active_4, 
  s0_.name AS name_5, 
  s0_.userID AS userID_6, 
  s0_.position AS position_7, 
  s0_.device AS device_8, 
  s0_.fullscreen AS fullscreen_9, 
  s0_.valid_from AS valid_from_10, 
  s0_.is_landingpage AS is_landingpage_11, 
  s0_.seo_title AS seo_title_12, 
  s0_.seo_keywords AS seo_keywords_13, 
  s0_.seo_description AS seo_description_14, 
  s0_.valid_to AS valid_to_15, 
  s0_.create_date AS create_date_16, 
  s0_.modified AS modified_17, 
  s0_.`rows` AS rows_18, 
  s0_.cols AS cols_19, 
  s0_.cell_spacing AS cell_spacing_20, 
  s0_.cell_height AS cell_height_21, 
  s0_.article_height AS article_height_22, 
  s0_.mode AS mode_23, 
  s0_.preview_id AS preview_id_24, 
  s0_.preview_secret AS preview_secret_25, 
  s0_.listing_visibility AS listing_visibility_26, 
  s0_.customer_stream_ids AS customer_stream_ids_27, 
  s0_.replacement AS replacement_28 
FROM 
  s_emotion s0_ 
  INNER JOIN s_emotion_categories s2_ ON s0_.id = s2_.emotion_id 
  INNER JOIN s_categories s1_ ON s1_.id = s2_.category_id 
WHERE 
  s1_.id = ? 
  AND (
    (
      s0_.valid_from <= ? 
      OR s0_.valid_from IS NULL
    )
  ) 
  AND (
    (
      s0_.valid_to >= ? 
      OR s0_.valid_to IS NULL
    )
  ) 
  AND s0_.is_landingpage = 0 
  AND s0_.active = 1

array:3 [
  0 => 6
  1 => DateTime @1730420757 {#3391
    date: 2024-11-01 01:25:57.767342 Europe/Berlin (+01:00)
  }
  2 => DateTime @1730420757 {#3391}
]

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:1 [
    0 => 3
  ]
  ":shopId" => "%|1|%"
]

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:1 [
    0 => 1
  ]
  ":shopId" => "%|1|%"
]

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:1 [
    0 => 0
  ]
  ":shopId" => "%|1|%"
]

SELECT 
  count(category.id) 
FROM 
  s_categories category 
WHERE 
  parent = : id

array:1 [
  "id" => 6
]

SELECT 
  s0_.id AS id_0 
FROM 
  s_emarketing_banners s0_ 
WHERE 
  (
    (
      s0_.valid_from <= ? 
      OR (
        s0_.valid_from = ? 
        OR s0_.valid_from IS NULL
      )
    )
  ) 
  AND (
    (
      s0_.valid_to >= ? 
      OR (
        s0_.valid_to = ? 
        OR s0_.valid_to IS NULL
      )
    )
  ) 
  AND s0_.categoryID = ?

array:5 [
  0 => DateTime @1730420757 {#3392
    date: 2024-11-01 01:25:57.771290 Europe/Berlin (+01:00)
  }
  1 => null
  2 => DateTime @1730420757 {#3392}
  3 => null
  4 => "6"
]

SELECT 
  s0_.id AS id_0, 
  s0_.description AS description_1, 
  s0_.blog AS blog_2 
FROM 
  s_categories s0_ 
WHERE 
  s0_.id = ?

array:1 [
  0 => 3
]

SELECT 
  `objectdata` 
FROM 
  `s_core_translations` 
WHERE 
  (`objecttype` = : type) 
  AND (`objectkey` = : key) 
  AND (`objectlanguage` = : language)

array:3 [
  ":type" => "category"
  ":key" => 3
  ":language" => 1
]

SELECT 
  s0_.id AS id_0, 
  s0_.description AS description_1, 
  s0_.blog AS blog_2 
FROM 
  s_categories s0_ 
WHERE 
  s0_.id = ?

array:1 [
  0 => 6
]

SELECT 
  `objectdata` 
FROM 
  `s_core_translations` 
WHERE 
  (`objecttype` = : type) 
  AND (`objectkey` = : key) 
  AND (`objectlanguage` = : language)

array:3 [
  ":type" => "category"
  ":key" => "6"
  ":language" => 1
]

SELECT 
  emotion.id, 
  emotion.device as devices, 
  emotion.show_listing as showListing, 
  emotion.fullscreen, 
  emotion.customer_stream_ids, 
  emotion.replacement, 
  emotion.position, 
  emotion.listing_visibility, 
  GROUP_CONCAT(shops.shop_id SEPARATOR ',') as shopIds 
FROM 
  s_emotion emotion 
  LEFT JOIN s_emotion_shops shops ON shops.emotion_id = emotion.id 
  INNER JOIN s_emotion_categories category ON category.emotion_id = emotion.id 
  AND category.category_id = : categoryId 
WHERE 
  (emotion.active = 1) 
  AND (emotion.is_landingpage = 0) 
  AND (
    (
      emotion.valid_to >= NOW() 
      OR emotion.valid_to IS NULL
    )
  ) 
  AND (
    (
      emotion.valid_from <= NOW() 
      OR emotion.valid_from IS NULL
    )
  ) 
  AND (emotion.preview_id IS NULL) 
GROUP BY 
  emotion.id 
ORDER BY 
  emotion.position ASC, 
  emotion.id ASC

array:1 [
  ":categoryId" => "6"
]

SELECT 
  id, 
  facet_ids 
FROM 
  s_categories categories 
WHERE 
  categories.id IN (: ids)

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

SELECT 
  id 
FROM 
  s_search_custom_facet customFacet 
WHERE 
  customFacet.display_in_categories = 1 
ORDER BY 
  customFacet.position ASC

[]

SELECT 
  customFacet.id as __customFacet_id, 
  customFacet.unique_key as __customFacet_unique_key, 
  customFacet.active as __customFacet_active, 
  customFacet.position as __customFacet_position, 
  customFacet.name as __customFacet_name, 
  customFacet.facet as __customFacet_facet 
FROM 
  s_search_custom_facet customFacet 
WHERE 
  (customFacet.active = 1) 
  AND (
    customFacet.id IN (: ids)
  )

array:1 [
  ":ids" => array:11 [
    0 => 2
    1 => 3
    2 => 4
    3 => 5
    4 => 6
    5 => 7
    6 => 8
    7 => 9
    8 => 10
    9 => 11
    10 => 12
  ]
]

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

[]

SET 
  @parent = (
    SELECT 
      id 
    FROM 
      s_core_config_elements 
    WHERE 
      name = 'fuzzysearchlastupdate'
  ); 
DELETE FROM 
  `s_core_config_values` 
WHERE 
  element_id = @parent; INSERT INTO `s_core_config_values` (`element_id`, `shop_id`, `value`) 
VALUES 
  (
    @parent, 
    1, 
    CONCAT(
      's:', 
      LENGTH(NOW()), 
      ':"', 
      NOW(), 
      '";'
    )
  );

[]

TRUNCATE TABLE `s_search_index`

[]

SELECT 
  STRAIGHT_JOIN st.id AS tableID, 
  st.table, 
  st.where, 
  st.referenz_table, 
  st.foreign_key, 
  GROUP_CONCAT(sf.id SEPARATOR ', ') AS fieldIDs, 
  GROUP_CONCAT(sf.field SEPARATOR ', ') AS `fields`, 
  GROUP_CONCAT(sf.do_not_split SEPARATOR ', ') AS `doNotSplit` 
FROM 
  s_search_fields sf FORCE INDEX (tableID) 
  INNER JOIN s_search_tables st ON st.id = sf.tableID 
  AND sf.relevance != 0 
GROUP BY 
  sf.tableID

[]

SELECT 
  id as id, 
  name, 
  keywords 
FROM 
  s_articles

[]

INSERT IGNORE INTO `s_search_keywords` (`keyword`) 
VALUES 
  ('bugaboo'), 
  ('fox'), 
  ('set'), 
  ('hauptartikel'), 
  ('mail'), 
  ('benachrichtigung'), 
  ('esd'), 
  ('download'), 
  ('artikel'), 
  ('standard'), 
  ('konfigurator'), 
  ('variantenartikel'), 
  ('kennzeichnung'), 
  ('versandkostenfrei'), 
  ('hervorhebung'), 
  ('eigenschaften'), 
  ('ressourcen'), 
  ('auswahl'), 
  ('grundpreisberechnung'), 
  ('abverkauf'), 
  ('cross'), 
  ('selling'), 
  ('bewertungen'), 
  ('bild'), 
  ('pseudovarianten'), 
  ('variante'), 
  ('varianten'), 
  ('kaufxzahly'), 
  ('iphone'), 
  ('produkt'), 
  ('slot'), 
  ('wickeltasche'), 
  ('1aus7'), 
  ('subset'), 
  ('grosser'), 
  ('buybox'), 
  ('volle'), 
  ('breite'), 
  ('waschbaer'), 
  ('buendchen'), 
  ('gruen'), 
  ('blau'), 
  ('jersey'), 
  ('frontlader'), 
  ('ventil'), 
  ('m45'), 
  ('bowdenzug'), 
  ('bedienhebel'), 
  ('90l'), 
  ('min'), 
  ('fuer'), 
  ('load'), 
  ('sensing'), 
  ('akon'), 
  ('konstant'), 
  ('version'), 
  ('kugelkopf'), 
  ('1200'), 
  ('1300'), 
  ('1400'), 
  ('1700'), 
  ('ohne'), 
  ('taster'), 
  ('zwei'), 
  ('drei'), 
  ('test'), 
  ('testartikel'), 
  ('einzelartikel'), 
  ('kaufbar'), 
  ('container'), 
  ('schrauben'), 
  ('duebel'), 
  ('gemischt'), 
  ('nod'), 
  ('bett'), 
  ('test1'), 
  ('test2'), 
  ('test3'), 
  ('test4'), 
  ('ics'), 
  ('mk18'), 
  ('edition'), 
  ('gin'), 
  ('original'), 
  ('owl'), 
  ('arminia'), 
  ('longdrinkglas'), 
  ('donkey'), 
  ('mono'), 
  ('kinderwagen'), 
  ('inkl'), 
  ('turtle'), 
  ('air'), 
  ('cybex'), 
  ('cloud'), 
  ('size'), 
  ('babyschale'), 
  ('kombikinderwagen'), 
  ('komplett'), 
  ('image'), 
  ('select'), 
  ('6er'), 
  ('pack'), 
  ('einzelstueck'), 
  ('tuersprechanlage'), 
  ('evo'), 
  ('komplettset'), 
  ('wuenschen'), 
  ('monitor'), 
  ('wifi'), 
  ('weiss'), 
  ('this'), 
  ('anhaenger'), 
  ('kette'), 
  ('ohrring')

[]

INSERT IGNORE INTO s_search_index (keywordID, elementID, fieldID) 
SELECT 
  sk.id as keywordID, 
  1 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('bugaboo', 'fox', 'set') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  2 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'hauptartikel', 'mail', 'benachrichtigung'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  3 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'hauptartikel', 'esd', 'download'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  4 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'artikel', 'standard', 'konfigurator'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  5 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('variantenartikel') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  6 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'hauptartikel', 'kennzeichnung', 
    'versandkostenfrei', 'hervorhebung'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  7 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('hauptartikel', 'eigenschaften') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  8 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('hauptartikel', 'ressourcen') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  9 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'artikel', 'auswahl', 'konfigurator'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  10 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'hauptartikel', 'grundpreisberechnung'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  11 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('hauptartikel', 'abverkauf') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  12 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'hauptartikel', 'cross', 'selling'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  13 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('hauptartikel', 'bewertungen') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  14 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'artikel', 'bild', 'konfigurator'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  15 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('pseudovarianten', 'standard') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  16 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'pseudovarianten', 'standard', 'variante'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  17 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'pseudovarianten', 'standard', 'variante'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  18 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('pseudovarianten', 'varianten') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  19 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'pseudovarianten', 'varianten', 'variante'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  20 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'pseudovarianten', 'varianten', 'variante'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  21 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('hauptartikel', 'kaufxzahly') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  22 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'variantenartikel', 'kaufxzahly'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  23 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('iphone') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  24 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('set', 'produkt', 'slot') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  25 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('set', 'produkt', 'slot') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  26 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'set', 'produkt', 'varianten', 'slot'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  27 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('bugaboo', 'wickeltasche') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  28 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('set', 'produkt', 'slot') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  29 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'set', 'produkt', 'varianten', 'slot'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  30 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('set', 'produkt', 'slot') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  31 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('set', 'produkt', 'slot') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  32 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('set', 'produkt', 'slot') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  33 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('1aus7') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  34 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('set', 'produkt', 'slot') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  36 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'set', 'produkt', 'subset', 'grosser', 
    'buybox'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  37 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'set', 'produkt', 'volle', 'breite'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  39 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('waschbaer', 'set') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  40 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('buendchen', 'gruen') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  41 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('waschbaer') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  42 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('buendchen', 'blau') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  43 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('jersey', 'blau') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  44 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('jersey', 'gruen') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  45 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'frontlader', 'ventil', 'm45', 'bowdenzug', 
    'bedienhebel'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  46 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'frontlader', 'ventil', '90l', 'min', 
    'fuer', 'load', 'sensing', 'akon'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  47 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'frontlader', 'ventil', '90l', 'min', 
    'fuer', 'konstant', 'version', 'akon'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  48 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('bowdenzug', 'kugelkopf', '1200') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  49 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('bowdenzug', 'kugelkopf', '1300') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  50 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('bowdenzug', 'kugelkopf', '1400') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  51 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('bowdenzug', 'kugelkopf', '1700') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  52 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'bedienhebel', 'fuer', 'frontlader', 
    'ventil', 'ohne', 'taster'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  53 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'bedienhebel', 'fuer', 'frontlader', 
    'ventil', 'taster'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  54 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'bedienhebel', 'fuer', 'frontlader', 
    'ventil', 'zwei', 'taster'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  55 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'bedienhebel', 'fuer', 'frontlader', 
    'ventil', 'drei', 'taster'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  56 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('test') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  58 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('testartikel') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  59 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('einzelartikel', 'kaufbar') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  60 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('container') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  61 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('schrauben') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  62 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('duebel') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  63 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('test', 'set', 'gemischt', 'nod') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  64 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('test', 'bett') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  68 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('test1') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  69 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('test2') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  70 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('test3') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  71 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('test4') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  72 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('ics', 'mk18') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  73 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'edition', 'gin', 'original', 'owl'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  74 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('arminia', 'longdrinkglas') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  75 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'bugaboo', 'donkey', 'mono', 'kinderwagen', 
    'set', 'inkl', 'turtle', 'air'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  76 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'bugaboo', 'donkey', 'mono', 'kinderwagen', 
    'set', 'inkl', 'cybex', 'cloud', 'size', 
    'babyschale'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  77 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'bugaboo', 'donkey', 'mono', 'kombikinderwagen', 
    'komplett'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  78 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('set', 'image', 'select') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  79 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('test', 'set', '6er', 'pack') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  80 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('einzelstueck') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  81 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'tuersprechanlage', 'evo', 'komplettset', 
    'wuenschen'
  ) 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  87 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('evo', 'monitor', 'standard') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  88 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('evo', 'monitor', 'wifi', 'weiss') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  89 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('this', 'test') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  90 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('anhaenger') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  91 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('kette') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  92 as elementID, 
  3 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN (
    'set', 'kette', 'anhaenger', 'ohrring'
  )