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" => "ratgeber"
]

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

[]

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'
  )

[]

SELECT 
  id as id, 
  metakeywords, 
  description 
FROM 
  s_categories

[]

SELECT 
  objectkey, 
  objectdata 
FROM 
  s_core_translations 
WHERE 
  (
    objectkey IN (: ids)
  ) 
  AND (objecttype = : type)

array:2 [
  ":type" => "category"
  ":ids" => array:18 [
    0 => "1"
    1 => "3"
    2 => "5"
    3 => "6"
    4 => "7"
    5 => "8"
    6 => "9"
    7 => "10"
    8 => "11"
    9 => "12"
    10 => "13"
    11 => "14"
    12 => "15"
    13 => "16"
    14 => "17"
    15 => "18"
    16 => "19"
    17 => "20"
  ]
]

INSERT IGNORE INTO `s_search_keywords` (`keyword`) 
VALUES 
  ('root'), 
  ('deutsch'), 
  ('lebensmittel'), 
  ('bekleidung'), 
  ('freizeit'), 
  ('elektro'), 
  ('backwaren'), 
  ('fisch'), 
  ('suesses'), 
  ('damen'), 
  ('herren'), 
  ('blog'), 
  ('unterkategorie'), 
  ('set'), 
  ('produkte'), 
  ('pseudovarianten'), 
  ('kaufxzahly'), 
  ('notizbuecher'), 
  ('inaktive'), 
  ('kategorie'), 
  ('test')

[]

INSERT IGNORE INTO s_search_index (keywordID, elementID, fieldID) 
SELECT 
  sk.id as keywordID, 
  1 as elementID, 
  2 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('root') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  3 as elementID, 
  2 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('deutsch') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  5 as elementID, 
  2 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('lebensmittel') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  6 as elementID, 
  2 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('bekleidung') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  7 as elementID, 
  2 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('freizeit', 'elektro') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  8 as elementID, 
  2 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('backwaren') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  9 as elementID, 
  2 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('fisch') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  10 as elementID, 
  2 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('suesses') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  11 as elementID, 
  2 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('damen') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  12 as elementID, 
  2 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('herren') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  13 as elementID, 
  2 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('blog') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  14 as elementID, 
  2 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('blog', 'unterkategorie') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  15 as elementID, 
  2 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('set', 'produkte') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  16 as elementID, 
  2 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('pseudovarianten') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  17 as elementID, 
  2 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('kaufxzahly') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  18 as elementID, 
  2 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('notizbuecher') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  19 as elementID, 
  2 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('inaktive', 'kategorie') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  20 as elementID, 
  2 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('test')

[]

SELECT 
  id as id, 
  name 
FROM 
  s_articles_supplier

[]

INSERT IGNORE INTO `s_search_keywords` (`keyword`) 
VALUES 
  ('shopware'), 
  ('fashion'), 
  ('food'), 
  ('freetime')

[]

INSERT IGNORE INTO s_search_index (keywordID, elementID, fieldID) 
SELECT 
  sk.id as keywordID, 
  1 as elementID, 
  6 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('shopware', 'fashion') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  2 as elementID, 
  6 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('shopware', 'food') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  3 as elementID, 
  6 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('shopware', 'freetime')

[]

SELECT 
  id as id, 
  ordernumber 
FROM 
  s_articles_details

[]

INSERT IGNORE INTO `s_search_keywords` (`keyword`) 
VALUES 
  ('123456'), 
  ('1452'), 
  ('000004007'), 
  ('5in'), 
  ('01200ss'), 
  ('01300ss'), 
  ('01400ss'), 
  ('01700ss'), 
  ('99999'), 
  ('akon_kv'), 
  ('akon_ls'), 
  ('anh'), 
  ('001'), 
  ('b1234'), 
  ('6013'), 
  ('6019'), 
  ('6020'), 
  ('6022'), 
  ('ket'), 
  ('sw10001'), 
  ('sw10002'), 
  ('sw10003'), 
  ('sw10004'), 
  ('sw10005'), 
  ('sw10006'), 
  ('sw10007'), 
  ('sw10008'), 
  ('sw10009'), 
  ('sw10010'), 
  ('sw10011'), 
  ('sw10012'), 
  ('sw10013'), 
  ('sw10014'), 
  ('sw10015'), 
  ('sw10016'), 
  ('sw10017'), 
  ('sw10018'), 
  ('sw10019'), 
  ('sw10020'), 
  ('sw10021'), 
  ('sw10022'), 
  ('sw10023'), 
  ('sw10024'), 
  ('sw100240'), 
  ('sw10025'), 
  ('sw10026'), 
  ('sw10027'), 
  ('sw10028'), 
  ('sw10029'), 
  ('sw10030'), 
  ('sw10031'), 
  ('sw10032'), 
  ('sw10033'), 
  ('sw10034'), 
  ('sw10036'), 
  ('sw10037'), 
  ('sw10038'), 
  ('sw10039'), 
  ('sw10040'), 
  ('sw10041'), 
  ('sw10042'), 
  ('sw10043'), 
  ('sw10052'), 
  ('sw10054'), 
  ('sw10055'), 
  ('sw10056'), 
  ('sw10057'), 
  ('sw10061'), 
  ('sw10062'), 
  ('sw10063'), 
  ('sw10064'), 
  ('sw10065'), 
  ('sw10066'), 
  ('sw10067'), 
  ('sw10068'), 
  ('sw10069'), 
  ('sw10070'), 
  ('sw10071'), 
  ('sw10077'), 
  ('sw10078'), 
  ('sw10079'), 
  ('test1'), 
  ('test2'), 
  ('test3')

[]

INSERT IGNORE INTO s_search_index (keywordID, elementID, fieldID) 
SELECT 
  sk.id as keywordID, 
  169 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('123456') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  106 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('1452', '000004007') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  109 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('5in', '01200ss') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  110 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('5in', '01300ss') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  111 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('5in', '01400ss') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  112 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('5in', '01700ss') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  170 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('99999') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  108 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('akon_kv') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  107 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('akon_ls') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  238 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('anh', '001') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  168 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('b1234') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  116 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('6013') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  114 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('6019') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  113 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('6020') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  115 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('6022') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  239 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('ket', '001') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  1 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10001') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  193 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10001') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  194 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10001') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  2 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10002') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  3 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10003') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  4 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10004') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  38 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10004') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  39 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10004') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  16 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10005') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  20 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10005') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  21 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10005') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  22 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10005') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  23 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10005') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  24 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10005') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  6 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10006') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  7 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10007') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  17 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10007') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  18 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10007') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  19 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10007') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  8 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10008') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  26 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10009') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  27 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10009') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  36 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10009') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  37 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10009') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  28 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10009') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  29 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10009') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  30 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10009') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  31 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10009') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  32 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10009') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  33 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10009') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  34 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10009') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  35 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10009') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  10 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10010') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  11 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10011') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  12 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10012') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  13 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10013') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  14 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10014') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  40 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10014') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  41 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10014') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  42 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10015') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  43 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10016') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  44 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10017') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  45 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10018') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  48 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10018') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  57 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10018') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  58 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10018') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  49 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10018') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  50 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10018') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  51 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10018') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  52 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10018') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  53 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10018') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  54 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10018') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  55 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10018') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  56 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10018') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  46 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10019') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  59 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10019') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  60 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10019') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  61 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10019') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  47 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10020') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  62 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10020') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  63 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10020') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  64 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10021') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  65 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10022') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  66 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10022') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  67 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10022') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  68 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10022') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  69 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10022') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  70 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10022') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  71 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10023') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  72 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10024') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  195 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw100240') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  73 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10025') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  74 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10026') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  75 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10026') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  76 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10026') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  77 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10026') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  78 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10027') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  79 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10028') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  80 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10028') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  81 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10028') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  82 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10028') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  83 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10029') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  84 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10029') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  85 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10029') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  86 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10029') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  87 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10029') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  88 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10029') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  89 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10030') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  90 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10031') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  91 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10031') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  92 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10031') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  93 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10032') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  94 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10033') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  95 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10034') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  97 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10036') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  98 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10037') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  100 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10038') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  101 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10039') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  102 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10040') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  103 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10041') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  104 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10042') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  105 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10043') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  164 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10052') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  166 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10054') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  167 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10055') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  171 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10056') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  172 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10057') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  179 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10061') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  191 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10061') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  192 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10061') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  180 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10062') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  183 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10062') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  184 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10062') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  185 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10063') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  186 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10064') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  187 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10065') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  188 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10066') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  199 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10066') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  200 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10066') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  201 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10066') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  202 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10066') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  203 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10066') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  204 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10066') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  205 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10066') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  206 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10066') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  189 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10067') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  196 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10067') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  197 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10067') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  198 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10067') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  190 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10068') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  210 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10069') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  211 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10070') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  212 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10071') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  218 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10077') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  221 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10077') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  219 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10078') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  222 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10079') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  223 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10079') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  232 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10079') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  233 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10079') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  234 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10079') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  235 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10079') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  236 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10079') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  237 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10079') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  224 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10079') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  225 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10079') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  226 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10079') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  227 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10079') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  228 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10079') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  229 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10079') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  230 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10079') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  231 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('sw10079') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  176 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('test1') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  177 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('test2') 
UNION ALL 
SELECT 
  sk.id as keywordID, 
  178 as elementID, 
  5 as fieldID 
FROM 
  s_search_keywords sk 
WHERE 
  sk.keyword IN ('test3')