http://titan.sw5.dev.orangebytes.de/en/all-products/19/demo-artikel-elektronik-kopfhoerer-kabellos-schwarz-cross-selling?c=42

Queries

165 Total Queries
0.0019 s Total Query Time
SQL Params Execution Time
SELECT 
  name, 
  id, 
  name, 
  label, 
  description, 
  source, 
  active, 
  installation_date as installationDate, 
  update_date as updateDate, 
  version 
FROM 
  s_core_plugins 
WHERE 
  namespace =: namespace 
  AND name not IN(: names)
array:2 [
  "namespace" => "Core"
  "names" => array:1 [
    0 => "PluginManager"
  ]
]
0.0002 ms
SELECT 
  ce.subscribe as name, 
  ce.listener, 
  ce.position, 
  cp.name as plugin 
FROM 
  s_core_subscribes ce 
  JOIN s_core_plugins cp ON cp.id = ce.pluginID 
  AND cp.active = 1 
  AND cp.namespace = : namespace 
WHERE 
  ce.type = 0 
  AND cp.name NOT IN(: names) 
ORDER BY 
  name, 
  position
array:2 [
  "namespace" => "Core"
  "names" => array:1 [
    0 => "PluginManager"
  ]
]
0.0001 ms
SELECT 
  name, 
  id, 
  name, 
  label, 
  description, 
  source, 
  active, 
  installation_date as installationDate, 
  update_date as updateDate, 
  version 
FROM 
  s_core_plugins 
WHERE 
  namespace =: namespace 
  AND name not IN(: names)
array:2 [
  "namespace" => "Frontend"
  "names" => array:1 [
    0 => "PluginManager"
  ]
]
0.0001 ms
SELECT 
  ce.subscribe as name, 
  ce.listener, 
  ce.position, 
  cp.name as plugin 
FROM 
  s_core_subscribes ce 
  JOIN s_core_plugins cp ON cp.id = ce.pluginID 
  AND cp.active = 1 
  AND cp.namespace = : namespace 
WHERE 
  ce.type = 0 
  AND cp.name NOT IN(: names) 
ORDER BY 
  name, 
  position
array:2 [
  "namespace" => "Frontend"
  "names" => array:1 [
    0 => "PluginManager"
  ]
]
0.0001 ms
SELECT 
  name, 
  id, 
  name, 
  label, 
  description, 
  source, 
  active, 
  installation_date as installationDate, 
  update_date as updateDate, 
  version 
FROM 
  s_core_plugins 
WHERE 
  namespace =: namespace 
  AND name not IN(: names)
array:2 [
  "namespace" => "Backend"
  "names" => array:1 [
    0 => "PluginManager"
  ]
]
0.0001 ms
SELECT 
  ce.subscribe as name, 
  ce.listener, 
  ce.position, 
  cp.name as plugin 
FROM 
  s_core_subscribes ce 
  JOIN s_core_plugins cp ON cp.id = ce.pluginID 
  AND cp.active = 1 
  AND cp.namespace = : namespace 
WHERE 
  ce.type = 0 
  AND cp.name NOT IN(: names) 
ORDER BY 
  name, 
  position
array:2 [
  "namespace" => "Backend"
  "names" => array:1 [
    0 => "PluginManager"
  ]
]
0.0001 ms
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" => "titan.sw5.dev.orangebytes.de"
]
0.0001 ms
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_.main_id AS main_id_31, 
  s1_.category_id AS category_id_32, 
  s1_.name AS name_33, 
  s1_.title AS title_34, 
  s1_.position AS position_35, 
  s1_.host AS host_36, 
  s1_.base_path AS base_path_37, 
  s1_.base_url AS base_url_38, 
  s1_.hosts AS hosts_39, 
  s1_.secure AS secure_40, 
  s1_.template_id AS template_id_41, 
  s1_.`default` AS default_42, 
  s1_.active AS active_43, 
  s1_.customer_scope AS customer_scope_44, 
  s2_.id AS id_45, 
  s2_.locale AS locale_46, 
  s2_.language AS language_47, 
  s2_.territory AS territory_48, 
  s3_.id AS id_49, 
  s3_.currency AS currency_50, 
  s3_.name AS name_51, 
  s3_.standard AS standard_52, 
  s3_.factor AS factor_53, 
  s3_.templatechar AS templatechar_54, 
  s3_.symbol_position AS symbol_position_55, 
  s3_.position AS position_56, 
  s4_.id AS id_57, 
  s4_.groupkey AS groupkey_58, 
  s4_.description AS description_59, 
  s4_.tax AS tax_60, 
  s4_.taxinput AS taxinput_61, 
  s4_.mode AS mode_62, 
  s4_.discount AS discount_63, 
  s4_.minimumorder AS minimumorder_64, 
  s4_.minimumordersurcharge AS minimumordersurcharge_65, 
  s5_.id AS id_66, 
  s5_.template AS template_67, 
  s5_.name AS name_68, 
  s5_.description AS description_69, 
  s5_.author AS author_70, 
  s5_.license AS license_71, 
  s5_.esi AS esi_72, 
  s5_.style_support AS style_support_73, 
  s5_.emotion AS emotion_74, 
  s5_.version AS version_75, 
  s5_.plugin_id AS plugin_id_76, 
  s5_.parent_id AS parent_id_77, 
  s6_.id AS id_78, 
  s6_.template AS template_79, 
  s6_.name AS name_80, 
  s6_.description AS description_81, 
  s6_.author AS author_82, 
  s6_.license AS license_83, 
  s6_.esi AS esi_84, 
  s6_.style_support AS style_support_85, 
  s6_.emotion AS emotion_86, 
  s6_.version AS version_87, 
  s6_.plugin_id AS plugin_id_88, 
  s6_.parent_id AS parent_id_89, 
  s7_.id AS id_90, 
  s7_.currency AS currency_91, 
  s7_.name AS name_92, 
  s7_.standard AS standard_93, 
  s7_.factor AS factor_94, 
  s7_.templatechar AS templatechar_95, 
  s7_.symbol_position AS symbol_position_96, 
  s7_.position AS position_97, 
  s0_.main_id AS main_id_98, 
  s0_.template_id AS template_id_99, 
  s0_.document_template_id AS document_template_id_100, 
  s0_.category_id AS category_id_101, 
  s0_.locale_id AS locale_id_102, 
  s0_.currency_id AS currency_id_103, 
  s0_.customer_group_id AS customer_group_id_104, 
  s0_.fallback_id AS fallback_id_105, 
  s1_.main_id AS main_id_106, 
  s1_.template_id AS template_id_107, 
  s1_.document_template_id AS document_template_id_108, 
  s1_.category_id AS category_id_109, 
  s1_.locale_id AS locale_id_110, 
  s1_.currency_id AS currency_id_111, 
  s1_.customer_group_id AS customer_group_id_112, 
  s1_.fallback_id AS fallback_id_113, 
  s5_.parent_id AS parent_id_114, 
  s5_.plugin_id AS plugin_id_115, 
  s6_.parent_id AS parent_id_116, 
  s6_.plugin_id AS plugin_id_117 
FROM 
  s_core_shops s0_ 
  LEFT JOIN s_core_shops s1_ ON s0_.main_id = s1_.id 
  LEFT JOIN s_core_locales s2_ ON s0_.locale_id = s2_.id 
  LEFT JOIN s_core_currencies s3_ ON s0_.currency_id = s3_.id 
  LEFT JOIN s_core_customergroups s4_ ON s0_.customer_group_id = s4_.id 
  LEFT JOIN s_core_templates s5_ ON s1_.template_id = s5_.id 
  LEFT JOIN s_core_templates s6_ ON s1_.document_template_id = s6_.id 
  LEFT JOIN s_core_shop_currencies s8_ ON s1_.id = s8_.shop_id 
  LEFT JOIN s_core_currencies s7_ ON s7_.id = s8_.currency_id 
WHERE 
  s0_.id = ? 
ORDER BY 
  s7_.position ASC, 
  s7_.id ASC
array:1 [
  0 => "3"
]
0.0001 ms
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 => 3
]
0.0001 ms
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
]
0.0001 ms
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
]
0.0001 ms
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" => "titan.sw5.dev.orangebytes.de"
]
0.0001 ms
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 => 3
]
0.0001 ms
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
]
0.0001 ms
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"
]
0.0001 ms
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
[]
0.0001 ms
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 => 24
]
0.0001 ms
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 => 24
]
0.0001 ms
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 => 24
]
0.0001 ms
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 => 24
]
0.0001 ms
(
  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
) 
UNION ALL 
  (
    SELECT 
      subshopID as shopId, 
      path, 
      org_path as orgPath, 
      0 as main 
    FROM 
      s_core_rewrite_urls 
    WHERE 
      path LIKE CONCAT(
        TRIM(
          TRAILING "/" 
          FROM 
            : pathInfo
        ), 
        "%"
      ) 
    ORDER BY 
      subshopID = : shopId DESC, 
      LENGTH(path), 
      main DESC 
    LIMIT 
      1
  )
array:2 [
  ":shopId" => 3
  ":pathInfo" => "all-products/19/demo-artikel-elektronik-kopfhoerer-kabellos-schwarz-cross-selling"
]
0.0003 ms
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
[]
0.0001 ms
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, 
  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 => 3
  ]
]
0.0002 ms
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, 
  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"
  ]
]
0.0001 ms
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"
  ]
]
0.0001 ms
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
  ]
]
0.0001 ms
SELECT 
  tax.id as __tax_id, 
  tax.tax as __tax_tax, 
  tax.description as __tax_description 
FROM 
  s_core_tax tax
[]
0.0001 ms
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
array:5 [
  ":area" => null
  ":country" => null
  ":state" => null
  ":customerGroup" => 1
  ":taxId" => "1"
]
0.0000 ms
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
array:5 [
  ":area" => null
  ":country" => null
  ":state" => null
  ":customerGroup" => 1
  ":taxId" => "4"
]
0.0001 ms
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
]
0.0001 ms
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.categoryID AS categoryID_36, 
  t0.mediaID AS mediaID_37, 
  t0.stream_id AS stream_id_38, 
  t0.parent AS parent_39 
FROM 
  s_categories t0 
  LEFT JOIN s_categories_attributes t27 ON t27.categoryID = t0.id 
WHERE 
  t0.id = ?
array:1 [
  0 => "42"
]
0.0003 ms
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.categoryID AS categoryID_36, 
  t0.mediaID AS mediaID_37, 
  t0.stream_id AS stream_id_38, 
  t0.parent AS parent_39 
FROM 
  s_categories t0 
  LEFT JOIN s_categories_attributes t27 ON t27.categoryID = t0.id 
WHERE 
  t0.id = ?
array:1 [
  0 => 16
]
0.0002 ms
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.categoryID AS categoryID_36, 
  t0.mediaID AS mediaID_37, 
  t0.stream_id AS stream_id_38, 
  t0.parent AS parent_39 
FROM 
  s_categories t0 
  LEFT JOIN s_categories_attributes t27 ON t27.categoryID = t0.id 
WHERE 
  t0.id = ?
array:1 [
  0 => 9
]
0.0002 ms
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.categoryID AS categoryID_36, 
  t0.mediaID AS mediaID_37, 
  t0.stream_id AS stream_id_38, 
  t0.parent AS parent_39 
FROM 
  s_categories t0 
  LEFT JOIN s_categories_attributes t27 ON t27.categoryID = t0.id 
WHERE 
  t0.id = ?
array:1 [
  0 => 3
]
0.0001 ms
SELECT 
  s0_.description AS description_0 
FROM 
  s_categories s0_ 
WHERE 
  s0_.id = ?
array:1 [
  0 => 3
]
0.0001 ms
SELECT 
  id 
FROM 
  s_core_locales 
WHERE 
  locale = "en_GB"
[]
0.0001 ms
SELECT 
  `objectdata` 
FROM 
  `s_core_translations` 
WHERE 
  (`objecttype` = : type) 
  AND (`objectkey` = : key) 
  AND (`objectlanguage` = : language)
array:3 [
  ":type" => "category"
  ":key" => 3
  ":language" => 3
]
0.0001 ms
SELECT 
  s0_.description AS description_0 
FROM 
  s_categories s0_ 
WHERE 
  s0_.id = ?
array:1 [
  0 => 9
]
0.0001 ms
SELECT 
  `objectdata` 
FROM 
  `s_core_translations` 
WHERE 
  (`objecttype` = : type) 
  AND (`objectkey` = : key) 
  AND (`objectlanguage` = : language)
array:3 [
  ":type" => "category"
  ":key" => 9
  ":language" => 3
]
0.0001 ms
SELECT 
  s0_.description AS description_0 
FROM 
  s_categories s0_ 
WHERE 
  s0_.id = ?
array:1 [
  0 => 16
]
0.0001 ms
SELECT 
  `objectdata` 
FROM 
  `s_core_translations` 
WHERE 
  (`objecttype` = : type) 
  AND (`objectkey` = : key) 
  AND (`objectlanguage` = : language)
array:3 [
  ":type" => "category"
  ":key" => 16
  ":language" => 3
]
0.0001 ms
SELECT 
  s0_.description AS description_0 
FROM 
  s_categories s0_ 
WHERE 
  s0_.id = ?
array:1 [
  0 => 42
]
0.0001 ms
SELECT 
  `objectdata` 
FROM 
  `s_core_translations` 
WHERE 
  (`objecttype` = : type) 
  AND (`objectkey` = : key) 
  AND (`objectlanguage` = : language)
array:3 [
  ":type" => "category"
  ":key" => "42"
  ":language" => 3
]
0.0001 ms
SELECT 
  variant.ordernumber 
FROM 
  s_articles_details variant 
  INNER JOIN s_articles product ON product.main_detail_id = variant.id 
WHERE 
  variant.articleID = : id
array:1 [
  ":id" => 19
]
0.0003 ms
SELECT 
  variant.articleID 
FROM 
  s_articles_details variant 
WHERE 
  variant.ordernumber = : number
array:1 [
  ":number" => "10019"
]
0.0001 ms
SELECT 
  categories.categoryID 
FROM 
  s_articles_categories_ro categories 
WHERE 
  (
    categories.articleID = : productId
  ) 
  AND (
    categories.categoryID = : categoryId
  ) 
LIMIT 
  1
array:2 [
  ":productId" => "19"
  ":categoryId" => 3
]
0.0002 ms
SELECT 
  variant.ordernumber 
FROM 
  s_articles_details variant 
  INNER JOIN s_articles product ON product.id = variant.articleID 
  AND variant.active = 1 
WHERE 
  (variant.ordernumber = : number) 
  AND (
    (
      variant.laststock * variant.instock
    ) >= (
      variant.laststock * variant.minpurchase
    )
  ) 
LIMIT 
  1
array:1 [
  ":number" => "10019"
]
0.0002 ms
SELECT 
  product.id as __product_id, 
  product.supplierID as __product_supplierID, 
  product.name as __product_name, 
  product.description as __product_description, 
  product.description_long as __product_description_long, 
  product.shippingtime as __product_shippingtime, 
  product.datum as __product_datum, 
  product.active as __product_active, 
  product.taxID as __product_taxID, 
  product.pseudosales as __product_pseudosales, 
  product.topseller as __product_topseller, 
  product.metaTitle as __product_metaTitle, 
  product.keywords as __product_keywords, 
  product.changetime as __product_changetime, 
  product.pricegroupID as __product_pricegroupID, 
  product.pricegroupActive as __product_pricegroupActive, 
  product.filtergroupID as __product_filtergroupID, 
  product.crossbundlelook as __product_crossbundlelook, 
  product.notification as __product_notification, 
  product.template as __product_template, 
  product.mode as __product_mode, 
  product.main_detail_id as __product_main_detail_id, 
  product.available_from as __product_available_from, 
  product.available_to as __product_available_to, 
  product.configurator_set_id as __product_configurator_set_id, 
  productAttribute.id as __productAttribute_id, 
  productAttribute.articledetailsID as __productAttribute_articledetailsID, 
  productAttribute.attr1 as __productAttribute_attr1, 
  productAttribute.attr2 as __productAttribute_attr2, 
  productAttribute.attr3 as __productAttribute_attr3, 
  productAttribute.attr4 as __productAttribute_attr4, 
  productAttribute.attr5 as __productAttribute_attr5, 
  productAttribute.attr6 as __productAttribute_attr6, 
  productAttribute.attr7 as __productAttribute_attr7, 
  productAttribute.attr8 as __productAttribute_attr8, 
  productAttribute.attr9 as __productAttribute_attr9, 
  productAttribute.attr10 as __productAttribute_attr10, 
  productAttribute.attr11 as __productAttribute_attr11, 
  productAttribute.attr12 as __productAttribute_attr12, 
  productAttribute.attr13 as __productAttribute_attr13, 
  productAttribute.attr14 as __productAttribute_attr14, 
  productAttribute.attr15 as __productAttribute_attr15, 
  productAttribute.attr16 as __productAttribute_attr16, 
  productAttribute.attr17 as __productAttribute_attr17, 
  productAttribute.attr18 as __productAttribute_attr18, 
  productAttribute.attr19 as __productAttribute_attr19, 
  productAttribute.attr20 as __productAttribute_attr20, 
  topSeller.sales as __topSeller_sales, 
  variant.id as __variant_id, 
  variant.ordernumber as __variant_ordernumber, 
  variant.suppliernumber as __variant_suppliernumber, 
  variant.kind as __variant_kind, 
  variant.additionaltext as __variant_additionaltext, 
  variant.sales as __variant_sales, 
  variant.active as __variant_active, 
  variant.instock as __variant_instock, 
  variant.stockmin as __variant_stockmin, 
  variant.weight as __variant_weight, 
  variant.position as __variant_position, 
  variant.width as __variant_width, 
  variant.height as __variant_height, 
  variant.length as __variant_length, 
  variant.ean as __variant_ean, 
  variant.unitID as __variant_unitID, 
  variant.releasedate as __variant_releasedate, 
  variant.shippingfree as __variant_shippingfree, 
  variant.shippingtime as __variant_shippingtime, 
  variant.laststock as __product_laststock, 
  unit.id as __unit_id, 
  unit.description as __unit_description, 
  unit.unit as __unit_unit, 
  variant.packunit as __unit_packunit, 
  variant.purchaseunit as __unit_purchaseunit, 
  variant.referenceunit as __unit_referenceunit, 
  variant.purchasesteps as __unit_purchasesteps, 
  variant.minpurchase as __unit_minpurchase, 
  variant.maxpurchase as __unit_maxpurchase, 
  tax.id as __tax_id, 
  tax.tax as __tax_tax, 
  tax.description as __tax_description, 
  priceGroup.id as __priceGroup_id, 
  priceGroup.description as __priceGroup_description, 
  manufacturer.id as __manufacturer_id, 
  manufacturer.name as __manufacturer_name, 
  manufacturer.img as __manufacturer_img, 
  manufacturer.link as __manufacturer_link, 
  manufacturer.description as __manufacturer_description, 
  manufacturer.meta_title as __manufacturer_meta_title, 
  manufacturer.meta_description as __manufacturer_meta_description, 
  manufacturer.meta_keywords as __manufacturer_meta_keywords, 
  manufacturerAttribute.id as __manufacturerAttribute_id, 
  manufacturerAttribute.supplierID as __manufacturerAttribute_supplierID, 
  esd.id as __esd_id, 
  esd.articleID as __esd_articleID, 
  esd.articledetailsID as __esd_articledetailsID, 
  esd.file as __esd_file, 
  esd.serials as __esd_serials, 
  esd.notification as __esd_notification, 
  esd.maxdownloads as __esd_maxdownloads, 
  esd.datum as __esd_datum, 
  esdAttribute.id as __esdAttribute_id, 
  esdAttribute.esdID as __esdAttribute_esdID, 
  (
    SELECT 
      1 
    FROM 
      s_articles_esd variantEsd 
    WHERE 
      variantEsd.articleID = product.id 
    LIMIT 
      1
  ) as __product_has_esd, 
  (
    SELECT 
      GROUP_CONCAT(
        customerGroups.customergroupId SEPARATOR '|'
      ) 
    FROM 
      s_articles_avoid_customergroups customerGroups 
    WHERE 
      customerGroups.articleID = product.id
  ) as __product_blocked_customer_groups, 
  (
    SELECT 
      COUNT(availableVariant.id) 
    FROM 
      s_articles_details availableVariant 
    WHERE 
      (
        availableVariant.articleID = product.id
      ) 
      AND (availableVariant.active = 1) 
      AND (
        (
          availableVariant.laststock * availableVariant.instock
        ) >= (
          availableVariant.laststock * availableVariant.minpurchase
        )
      )
  ) as __product_has_available_variants, 
  (
    SELECT 
      COUNT(
        DISTINCT ROUND(prices.price, 2)
      ) as priceCount 
    FROM 
      s_articles_prices prices 
      INNER JOIN s_articles_details priceVariant ON priceVariant.id = prices.articledetailsID 
      and priceVariant.active = 1 
    WHERE 
      (prices.from = 1) 
      AND (prices.pricegroup = : fallback) 
      AND (prices.articleID = product.id)
  ) as __product_fallback_price_count, 
  manufacturerMedia.id as __manufacturer_img_id, 
  translation6afe1f095d1efarticle.objectdata as __product_translation, 
  translation6afe1f095d1f4fallbackarticle.objectdata as __product_translation_fallback, 
  translation6afe1f095d1f7variant.objectdata as __variant_translation, 
  translation6afe1f095d1f9fallbackvariant.objectdata as __variant_translation_fallback, 
  translation6afe1f095d1fbsupplier.objectdata as __manufacturer_translation, 
  translation6afe1f095d1fdfallbacksupplier.objectdata as __manufacturer_translation_fallback, 
  translation6afe1f095d1ffconfig_units.objectdata as __unit_translation, 
  translation6afe1f095d201fallbackconfig_units.objectdata as __unit_translation_fallback, 
  translation6afe1f095d203s_articles_esd_attributes.objectdata as __esdAttribute_translation, 
  translation6afe1f095d204fallbacks_articles_esd_attributes.objectdata as __esdAttribute_translation_fallback 
FROM 
  s_articles_details variant 
  INNER JOIN s_articles product ON product.id = variant.articleID 
  LEFT JOIN s_core_units unit ON unit.id = variant.unitID 
  LEFT JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id 
  LEFT JOIN s_articles_esd esd ON esd.articledetailsID = variant.id 
  LEFT JOIN s_core_translations translation6afe1f095d1f7variant ON translation6afe1f095d1f7variant.objecttype = : translation6afe1f095d1f7variant 
  AND translation6afe1f095d1f7variant.objectkey = variant.id 
  AND translation6afe1f095d1f7variant.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095d1f9fallbackvariant ON translation6afe1f095d1f9fallbackvariant.objecttype = : translation6afe1f095d1f9fallbackvariant 
  AND translation6afe1f095d1f9fallbackvariant.objectkey = variant.id 
  AND translation6afe1f095d1f9fallbackvariant.objectlanguage = : languagefallback 
  INNER JOIN s_core_tax tax ON tax.id = product.taxID 
  LEFT JOIN s_articles_supplier manufacturer ON manufacturer.id = product.supplierID 
  LEFT JOIN s_core_pricegroups priceGroup ON priceGroup.id = product.pricegroupID 
  LEFT JOIN s_articles_supplier_attributes manufacturerAttribute ON manufacturerAttribute.supplierID = product.supplierID 
  LEFT JOIN s_articles_top_seller_ro topSeller ON topSeller.article_id = product.id 
  LEFT JOIN s_core_translations translation6afe1f095d1efarticle ON translation6afe1f095d1efarticle.objecttype = : translation6afe1f095d1efarticle 
  AND translation6afe1f095d1efarticle.objectkey = product.id 
  AND translation6afe1f095d1efarticle.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095d1f4fallbackarticle ON translation6afe1f095d1f4fallbackarticle.objecttype = : translation6afe1f095d1f4fallbackarticle 
  AND translation6afe1f095d1f4fallbackarticle.objectkey = product.id 
  AND translation6afe1f095d1f4fallbackarticle.objectlanguage = : languagefallback 
  LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img 
  LEFT JOIN s_core_translations translation6afe1f095d1fbsupplier ON translation6afe1f095d1fbsupplier.objecttype = : translation6afe1f095d1fbsupplier 
  AND translation6afe1f095d1fbsupplier.objectkey = manufacturer.id 
  AND translation6afe1f095d1fbsupplier.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095d1fdfallbacksupplier ON translation6afe1f095d1fdfallbacksupplier.objecttype = : translation6afe1f095d1fdfallbacksupplier 
  AND translation6afe1f095d1fdfallbacksupplier.objectkey = manufacturer.id 
  AND translation6afe1f095d1fdfallbacksupplier.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f095d1ffconfig_units ON translation6afe1f095d1ffconfig_units.objecttype = : translation6afe1f095d1ffconfig_units 
  AND translation6afe1f095d1ffconfig_units.objectkey = 1 
  AND translation6afe1f095d1ffconfig_units.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095d201fallbackconfig_units ON translation6afe1f095d201fallbackconfig_units.objecttype = : translation6afe1f095d201fallbackconfig_units 
  AND translation6afe1f095d201fallbackconfig_units.objectkey = 1 
  AND translation6afe1f095d201fallbackconfig_units.objectlanguage = : languagefallback 
  LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id 
  LEFT JOIN s_core_translations translation6afe1f095d203s_articles_esd_attributes ON translation6afe1f095d203s_articles_esd_attributes.objecttype = : translation6afe1f095d203s_articles_esd_attributes 
  AND translation6afe1f095d203s_articles_esd_attributes.objectkey = esd.id 
  AND translation6afe1f095d203s_articles_esd_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095d204fallbacks_articles_esd_attributes ON translation6afe1f095d204fallbacks_articles_esd_attributes.objecttype = : translation6afe1f095d204fallbacks_articles_esd_attributes 
  AND translation6afe1f095d204fallbacks_articles_esd_attributes.objectkey = esd.id 
  AND translation6afe1f095d204fallbacks_articles_esd_attributes.objectlanguage = : languagefallback 
WHERE 
  (
    variant.ordernumber IN (: numbers)
  ) 
  AND (variant.active = 1) 
  AND (product.active = 1)
array:14 [
  ":fallback" => "EK"
  ":numbers" => array:1 [
    0 => 10019
  ]
  ":language" => 3
  ":translation6afe1f095d1efarticle" => "article"
  ":languagefallback" => 0
  ":translation6afe1f095d1f4fallbackarticle" => "article"
  ":translation6afe1f095d1f7variant" => "variant"
  ":translation6afe1f095d1f9fallbackvariant" => "variant"
  ":translation6afe1f095d1fbsupplier" => "supplier"
  ":translation6afe1f095d1fdfallbacksupplier" => "supplier"
  ":translation6afe1f095d1ffconfig_units" => "config_units"
  ":translation6afe1f095d201fallbackconfig_units" => "config_units"
  ":translation6afe1f095d203s_articles_esd_attributes" => "s_articles_esd_attributes"
  ":translation6afe1f095d204fallbacks_articles_esd_attributes" => "s_articles_esd_attributes"
]
0.0016 ms
SELECT 
  variant.ordernumber as number, 
  media.id as __media_id, 
  media.albumID as __media_albumID, 
  media.name as __media_name, 
  media.description as __media_description, 
  media.path as __media_path, 
  media.type as __media_type, 
  media.extension as __media_extension, 
  media.file_size as __media_file_size, 
  media.width as __media_width, 
  media.height as __media_height, 
  media.userID as __media_userID, 
  media.created as __media_created, 
  mediaSettings.id as __mediaSettings_id, 
  mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, 
  mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, 
  mediaSettings.icon as __mediaSettings_icon, 
  mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, 
  mediaAttribute.id as __mediaAttribute_id, 
  mediaAttribute.mediaID as __mediaAttribute_mediaID, 
  image.id as __image_id, 
  image.articleID as __image_articleID, 
  image.img as __image_img, 
  image.main as __image_main, 
  image.description as __image_description, 
  image.position as __image_position, 
  image.width as __image_width, 
  image.height as __image_height, 
  image.extension as __image_extension, 
  image.parent_id as __image_parent_id, 
  image.media_id as __image_media_id, 
  imageAttribute.id as __imageAttribute_id, 
  imageAttribute.imageID as __imageAttribute_imageID, 
  imageAttribute.attribute1 as __imageAttribute_attribute1, 
  imageAttribute.attribute2 as __imageAttribute_attribute2, 
  imageAttribute.attribute3 as __imageAttribute_attribute3, 
  translation6afe1f095dac7articleimage.objectdata as __image_translation, 
  translation6afe1f095dacbfallbackarticleimage.objectdata as __image_translation_fallback, 
  translation6afe1f095daces_media_attributes.objectdata as __mediaAttribute_translation, 
  translation6afe1f095dad0fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 
FROM 
  s_articles_img image 
  INNER JOIN s_media media ON image.media_id = media.id 
  INNER JOIN s_articles_img childImage ON childImage.parent_id = image.id 
  INNER JOIN s_articles_details variant ON variant.id = childImage.article_detail_id 
  LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id 
  LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id 
  LEFT JOIN s_core_translations translation6afe1f095dac7articleimage ON translation6afe1f095dac7articleimage.objecttype = : translation6afe1f095dac7articleimage 
  AND translation6afe1f095dac7articleimage.objectkey = image.id 
  AND translation6afe1f095dac7articleimage.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095dacbfallbackarticleimage ON translation6afe1f095dacbfallbackarticleimage.objecttype = : translation6afe1f095dacbfallbackarticleimage 
  AND translation6afe1f095dacbfallbackarticleimage.objectkey = image.id 
  AND translation6afe1f095dacbfallbackarticleimage.objectlanguage = : languagefallback 
  INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID 
  LEFT JOIN s_core_translations translation6afe1f095daces_media_attributes ON translation6afe1f095daces_media_attributes.objecttype = : translation6afe1f095daces_media_attributes 
  AND translation6afe1f095daces_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f095daces_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095dad0fallbacks_media_attributes ON translation6afe1f095dad0fallbacks_media_attributes.objecttype = : translation6afe1f095dad0fallbacks_media_attributes 
  AND translation6afe1f095dad0fallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f095dad0fallbacks_media_attributes.objectlanguage = : languagefallback 
WHERE 
  childImage.article_detail_id IN (: products) 
ORDER BY 
  image.main ASC, 
  image.position ASC
array:7 [
  ":language" => 3
  ":translation6afe1f095dac7articleimage" => "articleimage"
  ":languagefallback" => 0
  ":translation6afe1f095dacbfallbackarticleimage" => "articleimage"
  ":translation6afe1f095daces_media_attributes" => "s_media_attributes"
  ":translation6afe1f095dad0fallbacks_media_attributes" => "s_media_attributes"
  ":products" => array:1 [
    0 => 48
  ]
]
0.0008 ms
SELECT 
  media.id as __media_id, 
  media.albumID as __media_albumID, 
  media.name as __media_name, 
  media.description as __media_description, 
  media.path as __media_path, 
  media.type as __media_type, 
  media.extension as __media_extension, 
  media.file_size as __media_file_size, 
  media.width as __media_width, 
  media.height as __media_height, 
  media.userID as __media_userID, 
  media.created as __media_created, 
  mediaSettings.id as __mediaSettings_id, 
  mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, 
  mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, 
  mediaSettings.icon as __mediaSettings_icon, 
  mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, 
  mediaAttribute.id as __mediaAttribute_id, 
  mediaAttribute.mediaID as __mediaAttribute_mediaID, 
  image.id as __image_id, 
  image.articleID as __image_articleID, 
  image.img as __image_img, 
  image.main as __image_main, 
  image.description as __image_description, 
  image.position as __image_position, 
  image.width as __image_width, 
  image.height as __image_height, 
  image.extension as __image_extension, 
  image.parent_id as __image_parent_id, 
  image.media_id as __image_media_id, 
  imageAttribute.id as __imageAttribute_id, 
  imageAttribute.imageID as __imageAttribute_imageID, 
  imageAttribute.attribute1 as __imageAttribute_attribute1, 
  imageAttribute.attribute2 as __imageAttribute_attribute2, 
  imageAttribute.attribute3 as __imageAttribute_attribute3, 
  translation6afe1f095de79articleimage.objectdata as __image_translation, 
  translation6afe1f095de7dfallbackarticleimage.objectdata as __image_translation_fallback, 
  translation6afe1f095de7fs_media_attributes.objectdata as __mediaAttribute_translation, 
  translation6afe1f095de81fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 
FROM 
  s_articles_img image 
  INNER JOIN s_media media ON image.media_id = media.id 
  LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id 
  LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id 
  LEFT JOIN s_articles_img childImage ON childImage.parent_id = image.id 
  LEFT JOIN s_core_translations translation6afe1f095de79articleimage ON translation6afe1f095de79articleimage.objecttype = : translation6afe1f095de79articleimage 
  AND translation6afe1f095de79articleimage.objectkey = image.id 
  AND translation6afe1f095de79articleimage.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095de7dfallbackarticleimage ON translation6afe1f095de7dfallbackarticleimage.objecttype = : translation6afe1f095de7dfallbackarticleimage 
  AND translation6afe1f095de7dfallbackarticleimage.objectkey = image.id 
  AND translation6afe1f095de7dfallbackarticleimage.objectlanguage = : languagefallback 
  INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID 
  LEFT JOIN s_core_translations translation6afe1f095de7fs_media_attributes ON translation6afe1f095de7fs_media_attributes.objecttype = : translation6afe1f095de7fs_media_attributes 
  AND translation6afe1f095de7fs_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f095de7fs_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095de81fallbacks_media_attributes ON translation6afe1f095de81fallbacks_media_attributes.objecttype = : translation6afe1f095de81fallbacks_media_attributes 
  AND translation6afe1f095de81fallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f095de81fallbacks_media_attributes.objectlanguage = : languagefallback 
WHERE 
  (image.main = 1) 
  AND (
    image.articleID IN (: products)
  )
array:7 [
  ":language" => 3
  ":translation6afe1f095de79articleimage" => "articleimage"
  ":languagefallback" => 0
  ":translation6afe1f095de7dfallbackarticleimage" => "articleimage"
  ":translation6afe1f095de7fs_media_attributes" => "s_media_attributes"
  ":translation6afe1f095de81fallbacks_media_attributes" => "s_media_attributes"
  ":products" => array:1 [
    0 => 19
  ]
]
0.0006 ms
SELECT 
  price.id as __price_id, 
  price.pricegroup as __price_pricegroup, 
  price.from as __price_from, 
  price.to as __price_to, 
  price.articleID as __price_articleID, 
  price.articledetailsID as __price_articledetailsID, 
  price.price as __price_price, 
  price.pseudoprice as __price_pseudoprice, 
  price.percent as __price_percent, 
  priceAttribute.id as __priceAttribute_id, 
  priceAttribute.priceID as __priceAttribute_priceID, 
  variants.ordernumber as number, 
  GREATEST(
    price.from, variants.minpurchase
  ) __price_from, 
  translation6afe1f095e22as_articles_prices_attributes.objectdata as __priceAttribute_translation, 
  translation6afe1f095e22efallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 
FROM 
  s_articles_prices price 
  INNER JOIN s_articles_details variants ON variants.id = price.articledetailsID 
  LEFT JOIN s_articles_prices_attributes priceAttribute ON priceAttribute.priceID = price.id 
  LEFT JOIN s_core_translations translation6afe1f095e22as_articles_prices_attributes ON translation6afe1f095e22as_articles_prices_attributes.objecttype = : translation6afe1f095e22as_articles_prices_attributes 
  AND translation6afe1f095e22as_articles_prices_attributes.objectkey = price.id 
  AND translation6afe1f095e22as_articles_prices_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095e22efallbacks_articles_prices_attributes ON translation6afe1f095e22efallbacks_articles_prices_attributes.objecttype = : translation6afe1f095e22efallbacks_articles_prices_attributes 
  AND translation6afe1f095e22efallbacks_articles_prices_attributes.objectkey = price.id 
  AND translation6afe1f095e22efallbacks_articles_prices_attributes.objectlanguage = : languagefallback 
WHERE 
  (
    price.articledetailsID IN (: products)
  ) 
  AND (
    price.pricegroup = : customerGroup
  ) 
  AND (
    (price.to >= variants.minpurchase) 
    OR (price.to = "beliebig")
  ) 
ORDER BY 
  price.articledetailsID ASC, 
  price.from ASC
array:6 [
  ":products" => array:1 [
    0 => 48
  ]
  ":customerGroup" => "EK"
  ":language" => 3
  ":translation6afe1f095e22as_articles_prices_attributes" => "s_articles_prices_attributes"
  ":languagefallback" => 0
  ":translation6afe1f095e22efallbacks_articles_prices_attributes" => "s_articles_prices_attributes"
]
0.0004 ms
SELECT 
  (
    SELECT 
      prices.id 
    FROM 
      s_articles_prices prices 
      INNER JOIN s_articles_details variant ON variant.id = prices.articledetailsID 
      INNER JOIN s_articles product ON product.id = variant.articleID 
      LEFT JOIN s_core_pricegroups_discounts priceGroup ON priceGroup.groupID = product.pricegroupID 
      AND priceGroup.discountstart = 1 
      AND priceGroup.customergroupID = : priceGroupCustomerGroup 
      AND product.pricegroupActive = 1 
    WHERE 
      (
        prices.pricegroup = : customerGroup
      ) 
      AND (prices.from = 1) 
      AND (variant.active = 1) 
      AND (
        prices.articleID = outerPrices.articleID
      ) 
      AND (
        (
          variant.laststock * variant.instock
        ) >= (
          variant.laststock * variant.minpurchase
        )
      ) 
    ORDER BY 
      prices.price ASC 
    LIMIT 
      1
  ) as priceId 
FROM 
  s_articles_prices outerPrices 
WHERE 
  outerPrices.articleID IN (: products) 
GROUP BY 
  outerPrices.articleID 
HAVING 
  priceId IS NOT NULL
array:3 [
  ":customerGroup" => "EK"
  ":products" => array:1 [
    0 => 19
  ]
  ":priceGroupCustomerGroup" => 1
]
0.0003 ms
SELECT 
  price.id as __price_id, 
  price.pricegroup as __price_pricegroup, 
  price.from as __price_from, 
  price.to as __price_to, 
  price.articleID as __price_articleID, 
  price.articledetailsID as __price_articledetailsID, 
  price.price as __price_price, 
  price.pseudoprice as __price_pseudoprice, 
  price.percent as __price_percent, 
  priceAttribute.id as __priceAttribute_id, 
  priceAttribute.priceID as __priceAttribute_priceID, 
  unit.id as __unit_id, 
  unit.description as __unit_description, 
  unit.unit as __unit_unit, 
  variant.packunit as __unit_packunit, 
  variant.purchaseunit as __unit_purchaseunit, 
  variant.referenceunit as __unit_referenceunit, 
  variant.purchasesteps as __unit_purchasesteps, 
  variant.minpurchase as __unit_minpurchase, 
  variant.maxpurchase as __unit_maxpurchase, 
  translation6afe1f095e5dcconfig_units.objectdata as __unit_translation, 
  translation6afe1f095e5e0fallbackconfig_units.objectdata as __unit_translation_fallback, 
  translation6afe1f095e5e3article.objectdata as __product_translation, 
  translation6afe1f095e5e5fallbackarticle.objectdata as __product_translation_fallback, 
  translation6afe1f095e5e7variant.objectdata as __variant_translation, 
  translation6afe1f095e5e8fallbackvariant.objectdata as __variant_translation_fallback, 
  translation6afe1f095e5eas_articles_prices_attributes.objectdata as __priceAttribute_translation, 
  translation6afe1f095e5ebfallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 
FROM 
  s_articles_prices price 
  INNER JOIN s_articles_details variant ON variant.id = price.articledetailsID 
  LEFT JOIN s_articles_prices_attributes priceAttribute ON priceAttribute.priceID = price.id 
  INNER JOIN s_articles product ON product.id = variant.articleID 
  LEFT JOIN s_core_units unit ON unit.id = variant.unitID 
  LEFT JOIN s_core_translations translation6afe1f095e5e7variant ON translation6afe1f095e5e7variant.objecttype = : translation6afe1f095e5e7variant 
  AND translation6afe1f095e5e7variant.objectkey = variant.id 
  AND translation6afe1f095e5e7variant.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095e5e8fallbackvariant ON translation6afe1f095e5e8fallbackvariant.objecttype = : translation6afe1f095e5e8fallbackvariant 
  AND translation6afe1f095e5e8fallbackvariant.objectkey = variant.id 
  AND translation6afe1f095e5e8fallbackvariant.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f095e5e3article ON translation6afe1f095e5e3article.objecttype = : translation6afe1f095e5e3article 
  AND translation6afe1f095e5e3article.objectkey = product.id 
  AND translation6afe1f095e5e3article.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095e5e5fallbackarticle ON translation6afe1f095e5e5fallbackarticle.objecttype = : translation6afe1f095e5e5fallbackarticle 
  AND translation6afe1f095e5e5fallbackarticle.objectkey = product.id 
  AND translation6afe1f095e5e5fallbackarticle.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f095e5dcconfig_units ON translation6afe1f095e5dcconfig_units.objecttype = : translation6afe1f095e5dcconfig_units 
  AND translation6afe1f095e5dcconfig_units.objectkey = 1 
  AND translation6afe1f095e5dcconfig_units.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095e5e0fallbackconfig_units ON translation6afe1f095e5e0fallbackconfig_units.objecttype = : translation6afe1f095e5e0fallbackconfig_units 
  AND translation6afe1f095e5e0fallbackconfig_units.objectkey = 1 
  AND translation6afe1f095e5e0fallbackconfig_units.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f095e5eas_articles_prices_attributes ON translation6afe1f095e5eas_articles_prices_attributes.objecttype = : translation6afe1f095e5eas_articles_prices_attributes 
  AND translation6afe1f095e5eas_articles_prices_attributes.objectkey = price.id 
  AND translation6afe1f095e5eas_articles_prices_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095e5ebfallbacks_articles_prices_attributes ON translation6afe1f095e5ebfallbacks_articles_prices_attributes.objecttype = : translation6afe1f095e5ebfallbacks_articles_prices_attributes 
  AND translation6afe1f095e5ebfallbacks_articles_prices_attributes.objectkey = price.id 
  AND translation6afe1f095e5ebfallbacks_articles_prices_attributes.objectlanguage = : languagefallback 
WHERE 
  price.id IN (: ids)
array:11 [
  ":ids" => array:1 [
    0 => "106"
  ]
  ":language" => 3
  ":translation6afe1f095e5dcconfig_units" => "config_units"
  ":languagefallback" => 0
  ":translation6afe1f095e5e0fallbackconfig_units" => "config_units"
  ":translation6afe1f095e5e3article" => "article"
  ":translation6afe1f095e5e5fallbackarticle" => "article"
  ":translation6afe1f095e5e7variant" => "variant"
  ":translation6afe1f095e5e8fallbackvariant" => "variant"
  ":translation6afe1f095e5eas_articles_prices_attributes" => "s_articles_prices_attributes"
  ":translation6afe1f095e5ebfallbacks_articles_prices_attributes" => "s_articles_prices_attributes"
]
0.0005 ms
SELECT 
  articleID, 
  COUNT(id) as total, 
  points 
FROM 
  s_articles_vote vote 
WHERE 
  (
    vote.articleID IN (: products)
  ) 
  AND (vote.active = 1) 
GROUP BY 
  vote.articleID, 
  vote.points 
ORDER BY 
  vote.articleID ASC
array:1 [
  ":products" => array:1 [
    0 => 19
  ]
]
0.0002 ms
SELECT 
  mapping.articleID, 
  GROUP_CONCAT(DISTINCT mapping.categoryID) 
FROM 
  s_articles_categories_ro mapping 
WHERE 
  mapping.articleID IN (: ids) 
GROUP BY 
  mapping.articleID
array:1 [
  ":ids" => array:1 [
    0 => 19
  ]
]
0.0002 ms
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, 
  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, 
  translation6afe1f095ea6cs_categories_attributes.objectdata as __categoryAttribute_translation, 
  translation6afe1f095ea70fallbacks_categories_attributes.objectdata as __categoryAttribute_translation_fallback, 
  translation6afe1f095ea73s_media_attributes.objectdata as __mediaAttribute_translation, 
  translation6afe1f095ea75fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback, 
  translation6afe1f095ea77productStream.objectdata as __stream_translation, 
  translation6afe1f095ea7dfallbackproductStream.objectdata as __stream_translation_fallback, 
  translation6afe1f095ea80category.objectdata as __category_translation, 
  translation6afe1f095ea81fallbackcategory.objectdata as __category_translation_fallback 
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_core_translations translation6afe1f095ea80category ON translation6afe1f095ea80category.objecttype = : translation6afe1f095ea80category 
  AND translation6afe1f095ea80category.objectkey = category.id 
  AND translation6afe1f095ea80category.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095ea81fallbackcategory ON translation6afe1f095ea81fallbackcategory.objecttype = : translation6afe1f095ea81fallbackcategory 
  AND translation6afe1f095ea81fallbackcategory.objectkey = category.id 
  AND translation6afe1f095ea81fallbackcategory.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f095ea6cs_categories_attributes ON translation6afe1f095ea6cs_categories_attributes.objecttype = : translation6afe1f095ea6cs_categories_attributes 
  AND translation6afe1f095ea6cs_categories_attributes.objectkey = category.id 
  AND translation6afe1f095ea6cs_categories_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095ea70fallbacks_categories_attributes ON translation6afe1f095ea70fallbacks_categories_attributes.objecttype = : translation6afe1f095ea70fallbacks_categories_attributes 
  AND translation6afe1f095ea70fallbacks_categories_attributes.objectkey = category.id 
  AND translation6afe1f095ea70fallbacks_categories_attributes.objectlanguage = : languagefallback 
  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_core_translations translation6afe1f095ea73s_media_attributes ON translation6afe1f095ea73s_media_attributes.objecttype = : translation6afe1f095ea73s_media_attributes 
  AND translation6afe1f095ea73s_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f095ea73s_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095ea75fallbacks_media_attributes ON translation6afe1f095ea75fallbacks_media_attributes.objecttype = : translation6afe1f095ea75fallbacks_media_attributes 
  AND translation6afe1f095ea75fallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f095ea75fallbacks_media_attributes.objectlanguage = : languagefallback 
  LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId 
  LEFT JOIN s_core_translations translation6afe1f095ea77productStream ON translation6afe1f095ea77productStream.objecttype = : translation6afe1f095ea77productStream 
  AND translation6afe1f095ea77productStream.objectkey = stream.id 
  AND translation6afe1f095ea77productStream.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095ea7dfallbackproductStream ON translation6afe1f095ea7dfallbackproductStream.objecttype = : translation6afe1f095ea7dfallbackproductStream 
  AND translation6afe1f095ea7dfallbackproductStream.objectkey = stream.id 
  AND translation6afe1f095ea7dfallbackproductStream.objectlanguage = : languagefallback 
WHERE 
  (
    category.id IN (: categories)
  ) 
  AND (category.active = 1) 
  AND (
    category.shops IS NULL 
    OR category.shops LIKE : shopId
  ) 
GROUP BY 
  category.id
array:12 [
  ":categories" => array:22 [
    0 => "3"
    1 => "5"
    2 => "7"
    3 => "9"
    4 => "15"
    5 => "16"
    6 => "17"
    7 => "35"
    8 => "36"
    9 => "37"
    10 => "38"
    11 => "39"
    12 => "40"
    13 => "41"
    14 => "42"
    15 => "43"
    16 => "44"
    17 => "45"
    18 => "46"
    19 => "47"
    20 => "48"
    21 => "49"
  ]
  ":shopId" => "%|3|%"
  ":language" => 3
  ":translation6afe1f095ea6cs_categories_attributes" => "s_categories_attributes"
  ":languagefallback" => 0
  ":translation6afe1f095ea70fallbacks_categories_attributes" => "s_categories_attributes"
  ":translation6afe1f095ea73s_media_attributes" => "s_media_attributes"
  ":translation6afe1f095ea75fallbacks_media_attributes" => "s_media_attributes"
  ":translation6afe1f095ea77productStream" => "productStream"
  ":translation6afe1f095ea7dfallbackproductStream" => "productStream"
  ":translation6afe1f095ea80category" => "category"
  ":translation6afe1f095ea81fallbackcategory" => "category"
]
0.0011 ms
SELECT 
  media.id as __media_id, 
  media.albumID as __media_albumID, 
  media.name as __media_name, 
  media.description as __media_description, 
  media.path as __media_path, 
  media.type as __media_type, 
  media.extension as __media_extension, 
  media.file_size as __media_file_size, 
  media.width as __media_width, 
  media.height as __media_height, 
  media.userID as __media_userID, 
  media.created as __media_created, 
  mediaSettings.id as __mediaSettings_id, 
  mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, 
  mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, 
  mediaSettings.icon as __mediaSettings_icon, 
  mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, 
  mediaAttribute.id as __mediaAttribute_id, 
  mediaAttribute.mediaID as __mediaAttribute_mediaID, 
  translation6afe1f095efd0s_media_attributes.objectdata as __mediaAttribute_translation, 
  translation6afe1f095efd5fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 
FROM 
  s_media media 
  INNER 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_core_translations translation6afe1f095efd0s_media_attributes ON translation6afe1f095efd0s_media_attributes.objecttype = : translation6afe1f095efd0s_media_attributes 
  AND translation6afe1f095efd0s_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f095efd0s_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095efd5fallbacks_media_attributes ON translation6afe1f095efd5fallbacks_media_attributes.objecttype = : translation6afe1f095efd5fallbacks_media_attributes 
  AND translation6afe1f095efd5fallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f095efd5fallbacks_media_attributes.objectlanguage = : languagefallback 
WHERE 
  media.id IN (: ids)
array:5 [
  ":language" => 3
  ":translation6afe1f095efd0s_media_attributes" => "s_media_attributes"
  ":languagefallback" => 0
  ":translation6afe1f095efd5fallbacks_media_attributes" => "s_media_attributes"
  ":ids" => array:1 [
    10019 => 2
  ]
]
0.0003 ms
SELECT 
  vote.id as __vote_id, 
  vote.articleID as __vote_articleID, 
  vote.name as __vote_name, 
  vote.headline as __vote_headline, 
  vote.comment as __vote_comment, 
  vote.points as __vote_points, 
  vote.datum as __vote_datum, 
  vote.active as __vote_active, 
  vote.email as __vote_email, 
  vote.answer as __vote_answer, 
  vote.answer_date as __vote_answer_date 
FROM 
  s_articles_vote vote 
WHERE 
  (
    vote.articleID IN (: ids)
  ) 
  AND (vote.active = 1) 
ORDER BY 
  vote.articleID DESC, 
  vote.datum DESC
array:1 [
  ":ids" => array:1 [
    0 => 19
  ]
]
0.0002 ms
SELECT 
  product.id, 
  relatedVariant.ordernumber as number 
FROM 
  s_articles_relationships relation 
  INNER JOIN s_articles product ON product.id = relation.articleID 
  INNER JOIN s_articles relatedArticles ON relatedArticles.id = relation.relatedArticle 
  INNER JOIN s_articles_details relatedVariant ON relatedVariant.id = relatedArticles.main_detail_id 
WHERE 
  product.id IN (: ids)
array:1 [
  ":ids" => array:1 [
    0 => 19
  ]
]
0.0002 ms
SELECT 
  product.id as __product_id, 
  product.supplierID as __product_supplierID, 
  product.name as __product_name, 
  product.description as __product_description, 
  product.description_long as __product_description_long, 
  product.shippingtime as __product_shippingtime, 
  product.datum as __product_datum, 
  product.active as __product_active, 
  product.taxID as __product_taxID, 
  product.pseudosales as __product_pseudosales, 
  product.topseller as __product_topseller, 
  product.metaTitle as __product_metaTitle, 
  product.keywords as __product_keywords, 
  product.changetime as __product_changetime, 
  product.pricegroupID as __product_pricegroupID, 
  product.pricegroupActive as __product_pricegroupActive, 
  product.filtergroupID as __product_filtergroupID, 
  product.crossbundlelook as __product_crossbundlelook, 
  product.notification as __product_notification, 
  product.template as __product_template, 
  product.mode as __product_mode, 
  product.main_detail_id as __product_main_detail_id, 
  product.available_from as __product_available_from, 
  product.available_to as __product_available_to, 
  product.configurator_set_id as __product_configurator_set_id, 
  productAttribute.id as __productAttribute_id, 
  productAttribute.articledetailsID as __productAttribute_articledetailsID, 
  productAttribute.attr1 as __productAttribute_attr1, 
  productAttribute.attr2 as __productAttribute_attr2, 
  productAttribute.attr3 as __productAttribute_attr3, 
  productAttribute.attr4 as __productAttribute_attr4, 
  productAttribute.attr5 as __productAttribute_attr5, 
  productAttribute.attr6 as __productAttribute_attr6, 
  productAttribute.attr7 as __productAttribute_attr7, 
  productAttribute.attr8 as __productAttribute_attr8, 
  productAttribute.attr9 as __productAttribute_attr9, 
  productAttribute.attr10 as __productAttribute_attr10, 
  productAttribute.attr11 as __productAttribute_attr11, 
  productAttribute.attr12 as __productAttribute_attr12, 
  productAttribute.attr13 as __productAttribute_attr13, 
  productAttribute.attr14 as __productAttribute_attr14, 
  productAttribute.attr15 as __productAttribute_attr15, 
  productAttribute.attr16 as __productAttribute_attr16, 
  productAttribute.attr17 as __productAttribute_attr17, 
  productAttribute.attr18 as __productAttribute_attr18, 
  productAttribute.attr19 as __productAttribute_attr19, 
  productAttribute.attr20 as __productAttribute_attr20, 
  topSeller.sales as __topSeller_sales, 
  variant.id as __variant_id, 
  variant.ordernumber as __variant_ordernumber, 
  variant.suppliernumber as __variant_suppliernumber, 
  variant.kind as __variant_kind, 
  variant.additionaltext as __variant_additionaltext, 
  variant.sales as __variant_sales, 
  variant.active as __variant_active, 
  variant.instock as __variant_instock, 
  variant.stockmin as __variant_stockmin, 
  variant.weight as __variant_weight, 
  variant.position as __variant_position, 
  variant.width as __variant_width, 
  variant.height as __variant_height, 
  variant.length as __variant_length, 
  variant.ean as __variant_ean, 
  variant.unitID as __variant_unitID, 
  variant.releasedate as __variant_releasedate, 
  variant.shippingfree as __variant_shippingfree, 
  variant.shippingtime as __variant_shippingtime, 
  variant.laststock as __product_laststock, 
  unit.id as __unit_id, 
  unit.description as __unit_description, 
  unit.unit as __unit_unit, 
  variant.packunit as __unit_packunit, 
  variant.purchaseunit as __unit_purchaseunit, 
  variant.referenceunit as __unit_referenceunit, 
  variant.purchasesteps as __unit_purchasesteps, 
  variant.minpurchase as __unit_minpurchase, 
  variant.maxpurchase as __unit_maxpurchase, 
  tax.id as __tax_id, 
  tax.tax as __tax_tax, 
  tax.description as __tax_description, 
  priceGroup.id as __priceGroup_id, 
  priceGroup.description as __priceGroup_description, 
  manufacturer.id as __manufacturer_id, 
  manufacturer.name as __manufacturer_name, 
  manufacturer.img as __manufacturer_img, 
  manufacturer.link as __manufacturer_link, 
  manufacturer.description as __manufacturer_description, 
  manufacturer.meta_title as __manufacturer_meta_title, 
  manufacturer.meta_description as __manufacturer_meta_description, 
  manufacturer.meta_keywords as __manufacturer_meta_keywords, 
  manufacturerAttribute.id as __manufacturerAttribute_id, 
  manufacturerAttribute.supplierID as __manufacturerAttribute_supplierID, 
  esd.id as __esd_id, 
  esd.articleID as __esd_articleID, 
  esd.articledetailsID as __esd_articledetailsID, 
  esd.file as __esd_file, 
  esd.serials as __esd_serials, 
  esd.notification as __esd_notification, 
  esd.maxdownloads as __esd_maxdownloads, 
  esd.datum as __esd_datum, 
  esdAttribute.id as __esdAttribute_id, 
  esdAttribute.esdID as __esdAttribute_esdID, 
  (
    SELECT 
      1 
    FROM 
      s_articles_esd variantEsd 
    WHERE 
      variantEsd.articleID = product.id 
    LIMIT 
      1
  ) as __product_has_esd, 
  (
    SELECT 
      GROUP_CONCAT(
        customerGroups.customergroupId SEPARATOR '|'
      ) 
    FROM 
      s_articles_avoid_customergroups customerGroups 
    WHERE 
      customerGroups.articleID = product.id
  ) as __product_blocked_customer_groups, 
  (
    SELECT 
      COUNT(availableVariant.id) 
    FROM 
      s_articles_details availableVariant 
    WHERE 
      (
        availableVariant.articleID = product.id
      ) 
      AND (availableVariant.active = 1) 
      AND (
        (
          availableVariant.laststock * availableVariant.instock
        ) >= (
          availableVariant.laststock * availableVariant.minpurchase
        )
      )
  ) as __product_has_available_variants, 
  (
    SELECT 
      COUNT(
        DISTINCT ROUND(prices.price, 2)
      ) as priceCount 
    FROM 
      s_articles_prices prices 
      INNER JOIN s_articles_details priceVariant ON priceVariant.id = prices.articledetailsID 
      and priceVariant.active = 1 
    WHERE 
      (prices.from = 1) 
      AND (prices.pricegroup = : fallback) 
      AND (prices.articleID = product.id)
  ) as __product_fallback_price_count, 
  manufacturerMedia.id as __manufacturer_img_id, 
  translation6afe1f095f4c4article.objectdata as __product_translation, 
  translation6afe1f095f4c7fallbackarticle.objectdata as __product_translation_fallback, 
  translation6afe1f095f4cavariant.objectdata as __variant_translation, 
  translation6afe1f095f4ccfallbackvariant.objectdata as __variant_translation_fallback, 
  translation6afe1f095f4cesupplier.objectdata as __manufacturer_translation, 
  translation6afe1f095f4cffallbacksupplier.objectdata as __manufacturer_translation_fallback, 
  translation6afe1f095f4d1config_units.objectdata as __unit_translation, 
  translation6afe1f095f4d3fallbackconfig_units.objectdata as __unit_translation_fallback, 
  translation6afe1f095f4d4s_articles_esd_attributes.objectdata as __esdAttribute_translation, 
  translation6afe1f095f4d6fallbacks_articles_esd_attributes.objectdata as __esdAttribute_translation_fallback 
FROM 
  s_articles_details variant 
  INNER JOIN s_articles product ON product.id = variant.articleID 
  LEFT JOIN s_core_units unit ON unit.id = variant.unitID 
  LEFT JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id 
  LEFT JOIN s_articles_esd esd ON esd.articledetailsID = variant.id 
  LEFT JOIN s_core_translations translation6afe1f095f4cavariant ON translation6afe1f095f4cavariant.objecttype = : translation6afe1f095f4cavariant 
  AND translation6afe1f095f4cavariant.objectkey = variant.id 
  AND translation6afe1f095f4cavariant.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095f4ccfallbackvariant ON translation6afe1f095f4ccfallbackvariant.objecttype = : translation6afe1f095f4ccfallbackvariant 
  AND translation6afe1f095f4ccfallbackvariant.objectkey = variant.id 
  AND translation6afe1f095f4ccfallbackvariant.objectlanguage = : languagefallback 
  INNER JOIN s_core_tax tax ON tax.id = product.taxID 
  LEFT JOIN s_articles_supplier manufacturer ON manufacturer.id = product.supplierID 
  LEFT JOIN s_core_pricegroups priceGroup ON priceGroup.id = product.pricegroupID 
  LEFT JOIN s_articles_supplier_attributes manufacturerAttribute ON manufacturerAttribute.supplierID = product.supplierID 
  LEFT JOIN s_articles_top_seller_ro topSeller ON topSeller.article_id = product.id 
  LEFT JOIN s_core_translations translation6afe1f095f4c4article ON translation6afe1f095f4c4article.objecttype = : translation6afe1f095f4c4article 
  AND translation6afe1f095f4c4article.objectkey = product.id 
  AND translation6afe1f095f4c4article.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095f4c7fallbackarticle ON translation6afe1f095f4c7fallbackarticle.objecttype = : translation6afe1f095f4c7fallbackarticle 
  AND translation6afe1f095f4c7fallbackarticle.objectkey = product.id 
  AND translation6afe1f095f4c7fallbackarticle.objectlanguage = : languagefallback 
  LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img 
  LEFT JOIN s_core_translations translation6afe1f095f4cesupplier ON translation6afe1f095f4cesupplier.objecttype = : translation6afe1f095f4cesupplier 
  AND translation6afe1f095f4cesupplier.objectkey = manufacturer.id 
  AND translation6afe1f095f4cesupplier.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095f4cffallbacksupplier ON translation6afe1f095f4cffallbacksupplier.objecttype = : translation6afe1f095f4cffallbacksupplier 
  AND translation6afe1f095f4cffallbacksupplier.objectkey = manufacturer.id 
  AND translation6afe1f095f4cffallbacksupplier.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f095f4d1config_units ON translation6afe1f095f4d1config_units.objecttype = : translation6afe1f095f4d1config_units 
  AND translation6afe1f095f4d1config_units.objectkey = 1 
  AND translation6afe1f095f4d1config_units.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095f4d3fallbackconfig_units ON translation6afe1f095f4d3fallbackconfig_units.objecttype = : translation6afe1f095f4d3fallbackconfig_units 
  AND translation6afe1f095f4d3fallbackconfig_units.objectkey = 1 
  AND translation6afe1f095f4d3fallbackconfig_units.objectlanguage = : languagefallback 
  LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id 
  LEFT JOIN s_core_translations translation6afe1f095f4d4s_articles_esd_attributes ON translation6afe1f095f4d4s_articles_esd_attributes.objecttype = : translation6afe1f095f4d4s_articles_esd_attributes 
  AND translation6afe1f095f4d4s_articles_esd_attributes.objectkey = esd.id 
  AND translation6afe1f095f4d4s_articles_esd_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095f4d6fallbacks_articles_esd_attributes ON translation6afe1f095f4d6fallbacks_articles_esd_attributes.objecttype = : translation6afe1f095f4d6fallbacks_articles_esd_attributes 
  AND translation6afe1f095f4d6fallbacks_articles_esd_attributes.objectkey = esd.id 
  AND translation6afe1f095f4d6fallbacks_articles_esd_attributes.objectlanguage = : languagefallback 
WHERE 
  (
    variant.ordernumber IN (: numbers)
  ) 
  AND (variant.active = 1) 
  AND (product.active = 1)
array:14 [
  ":fallback" => "EK"
  ":numbers" => array:6 [
    0 => 10011
    1 => 10012
    2 => 10013
    3 => 10015
    4 => 10016
    5 => 10018
  ]
  ":language" => 3
  ":translation6afe1f095f4c4article" => "article"
  ":languagefallback" => 0
  ":translation6afe1f095f4c7fallbackarticle" => "article"
  ":translation6afe1f095f4cavariant" => "variant"
  ":translation6afe1f095f4ccfallbackvariant" => "variant"
  ":translation6afe1f095f4cesupplier" => "supplier"
  ":translation6afe1f095f4cffallbacksupplier" => "supplier"
  ":translation6afe1f095f4d1config_units" => "config_units"
  ":translation6afe1f095f4d3fallbackconfig_units" => "config_units"
  ":translation6afe1f095f4d4s_articles_esd_attributes" => "s_articles_esd_attributes"
  ":translation6afe1f095f4d6fallbacks_articles_esd_attributes" => "s_articles_esd_attributes"
]
0.0018 ms
SELECT 
  variant.ordernumber as number, 
  media.id as __media_id, 
  media.albumID as __media_albumID, 
  media.name as __media_name, 
  media.description as __media_description, 
  media.path as __media_path, 
  media.type as __media_type, 
  media.extension as __media_extension, 
  media.file_size as __media_file_size, 
  media.width as __media_width, 
  media.height as __media_height, 
  media.userID as __media_userID, 
  media.created as __media_created, 
  mediaSettings.id as __mediaSettings_id, 
  mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, 
  mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, 
  mediaSettings.icon as __mediaSettings_icon, 
  mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, 
  mediaAttribute.id as __mediaAttribute_id, 
  mediaAttribute.mediaID as __mediaAttribute_mediaID, 
  image.id as __image_id, 
  image.articleID as __image_articleID, 
  image.img as __image_img, 
  image.main as __image_main, 
  image.description as __image_description, 
  image.position as __image_position, 
  image.width as __image_width, 
  image.height as __image_height, 
  image.extension as __image_extension, 
  image.parent_id as __image_parent_id, 
  image.media_id as __image_media_id, 
  imageAttribute.id as __imageAttribute_id, 
  imageAttribute.imageID as __imageAttribute_imageID, 
  imageAttribute.attribute1 as __imageAttribute_attribute1, 
  imageAttribute.attribute2 as __imageAttribute_attribute2, 
  imageAttribute.attribute3 as __imageAttribute_attribute3, 
  translation6afe1f095fd5carticleimage.objectdata as __image_translation, 
  translation6afe1f095fd60fallbackarticleimage.objectdata as __image_translation_fallback, 
  translation6afe1f095fd63s_media_attributes.objectdata as __mediaAttribute_translation, 
  translation6afe1f095fd65fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 
FROM 
  s_articles_img image 
  INNER JOIN s_media media ON image.media_id = media.id 
  INNER JOIN s_articles_img childImage ON childImage.parent_id = image.id 
  INNER JOIN s_articles_details variant ON variant.id = childImage.article_detail_id 
  LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id 
  LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id 
  LEFT JOIN s_core_translations translation6afe1f095fd5carticleimage ON translation6afe1f095fd5carticleimage.objecttype = : translation6afe1f095fd5carticleimage 
  AND translation6afe1f095fd5carticleimage.objectkey = image.id 
  AND translation6afe1f095fd5carticleimage.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095fd60fallbackarticleimage ON translation6afe1f095fd60fallbackarticleimage.objecttype = : translation6afe1f095fd60fallbackarticleimage 
  AND translation6afe1f095fd60fallbackarticleimage.objectkey = image.id 
  AND translation6afe1f095fd60fallbackarticleimage.objectlanguage = : languagefallback 
  INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID 
  LEFT JOIN s_core_translations translation6afe1f095fd63s_media_attributes ON translation6afe1f095fd63s_media_attributes.objecttype = : translation6afe1f095fd63s_media_attributes 
  AND translation6afe1f095fd63s_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f095fd63s_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f095fd65fallbacks_media_attributes ON translation6afe1f095fd65fallbacks_media_attributes.objecttype = : translation6afe1f095fd65fallbacks_media_attributes 
  AND translation6afe1f095fd65fallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f095fd65fallbacks_media_attributes.objectlanguage = : languagefallback 
WHERE 
  childImage.article_detail_id IN (: products) 
ORDER BY 
  image.main ASC, 
  image.position ASC
array:7 [
  ":language" => 3
  ":translation6afe1f095fd5carticleimage" => "articleimage"
  ":languagefallback" => 0
  ":translation6afe1f095fd60fallbackarticleimage" => "articleimage"
  ":translation6afe1f095fd63s_media_attributes" => "s_media_attributes"
  ":translation6afe1f095fd65fallbacks_media_attributes" => "s_media_attributes"
  ":products" => array:6 [
    0 => 30
    1 => 31
    2 => 34
    3 => 44
    4 => 45
    5 => 47
  ]
]
0.0008 ms
SELECT 
  media.id as __media_id, 
  media.albumID as __media_albumID, 
  media.name as __media_name, 
  media.description as __media_description, 
  media.path as __media_path, 
  media.type as __media_type, 
  media.extension as __media_extension, 
  media.file_size as __media_file_size, 
  media.width as __media_width, 
  media.height as __media_height, 
  media.userID as __media_userID, 
  media.created as __media_created, 
  mediaSettings.id as __mediaSettings_id, 
  mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, 
  mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, 
  mediaSettings.icon as __mediaSettings_icon, 
  mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, 
  mediaAttribute.id as __mediaAttribute_id, 
  mediaAttribute.mediaID as __mediaAttribute_mediaID, 
  image.id as __image_id, 
  image.articleID as __image_articleID, 
  image.img as __image_img, 
  image.main as __image_main, 
  image.description as __image_description, 
  image.position as __image_position, 
  image.width as __image_width, 
  image.height as __image_height, 
  image.extension as __image_extension, 
  image.parent_id as __image_parent_id, 
  image.media_id as __image_media_id, 
  imageAttribute.id as __imageAttribute_id, 
  imageAttribute.imageID as __imageAttribute_imageID, 
  imageAttribute.attribute1 as __imageAttribute_attribute1, 
  imageAttribute.attribute2 as __imageAttribute_attribute2, 
  imageAttribute.attribute3 as __imageAttribute_attribute3, 
  translation6afe1f09600ecarticleimage.objectdata as __image_translation, 
  translation6afe1f09600f0fallbackarticleimage.objectdata as __image_translation_fallback, 
  translation6afe1f09600f3s_media_attributes.objectdata as __mediaAttribute_translation, 
  translation6afe1f09600f5fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 
FROM 
  s_articles_img image 
  INNER JOIN s_media media ON image.media_id = media.id 
  LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id 
  LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id 
  LEFT JOIN s_articles_img childImage ON childImage.parent_id = image.id 
  LEFT JOIN s_core_translations translation6afe1f09600ecarticleimage ON translation6afe1f09600ecarticleimage.objecttype = : translation6afe1f09600ecarticleimage 
  AND translation6afe1f09600ecarticleimage.objectkey = image.id 
  AND translation6afe1f09600ecarticleimage.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f09600f0fallbackarticleimage ON translation6afe1f09600f0fallbackarticleimage.objecttype = : translation6afe1f09600f0fallbackarticleimage 
  AND translation6afe1f09600f0fallbackarticleimage.objectkey = image.id 
  AND translation6afe1f09600f0fallbackarticleimage.objectlanguage = : languagefallback 
  INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID 
  LEFT JOIN s_core_translations translation6afe1f09600f3s_media_attributes ON translation6afe1f09600f3s_media_attributes.objecttype = : translation6afe1f09600f3s_media_attributes 
  AND translation6afe1f09600f3s_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f09600f3s_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f09600f5fallbacks_media_attributes ON translation6afe1f09600f5fallbacks_media_attributes.objecttype = : translation6afe1f09600f5fallbacks_media_attributes 
  AND translation6afe1f09600f5fallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f09600f5fallbacks_media_attributes.objectlanguage = : languagefallback 
WHERE 
  (image.main = 1) 
  AND (
    image.articleID IN (: products)
  )
array:7 [
  ":language" => 3
  ":translation6afe1f09600ecarticleimage" => "articleimage"
  ":languagefallback" => 0
  ":translation6afe1f09600f0fallbackarticleimage" => "articleimage"
  ":translation6afe1f09600f3s_media_attributes" => "s_media_attributes"
  ":translation6afe1f09600f5fallbacks_media_attributes" => "s_media_attributes"
  ":products" => array:6 [
    0 => 11
    1 => 12
    2 => 13
    3 => 15
    4 => 16
    5 => 18
  ]
]
0.0007 ms
SELECT 
  price.id as __price_id, 
  price.pricegroup as __price_pricegroup, 
  price.from as __price_from, 
  price.to as __price_to, 
  price.articleID as __price_articleID, 
  price.articledetailsID as __price_articledetailsID, 
  price.price as __price_price, 
  price.pseudoprice as __price_pseudoprice, 
  price.percent as __price_percent, 
  priceAttribute.id as __priceAttribute_id, 
  priceAttribute.priceID as __priceAttribute_priceID, 
  variants.ordernumber as number, 
  GREATEST(
    price.from, variants.minpurchase
  ) __price_from, 
  translation6afe1f09604cas_articles_prices_attributes.objectdata as __priceAttribute_translation, 
  translation6afe1f09604cefallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 
FROM 
  s_articles_prices price 
  INNER JOIN s_articles_details variants ON variants.id = price.articledetailsID 
  LEFT JOIN s_articles_prices_attributes priceAttribute ON priceAttribute.priceID = price.id 
  LEFT JOIN s_core_translations translation6afe1f09604cas_articles_prices_attributes ON translation6afe1f09604cas_articles_prices_attributes.objecttype = : translation6afe1f09604cas_articles_prices_attributes 
  AND translation6afe1f09604cas_articles_prices_attributes.objectkey = price.id 
  AND translation6afe1f09604cas_articles_prices_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f09604cefallbacks_articles_prices_attributes ON translation6afe1f09604cefallbacks_articles_prices_attributes.objecttype = : translation6afe1f09604cefallbacks_articles_prices_attributes 
  AND translation6afe1f09604cefallbacks_articles_prices_attributes.objectkey = price.id 
  AND translation6afe1f09604cefallbacks_articles_prices_attributes.objectlanguage = : languagefallback 
WHERE 
  (
    price.articledetailsID IN (: products)
  ) 
  AND (
    price.pricegroup = : customerGroup
  ) 
  AND (
    (price.to >= variants.minpurchase) 
    OR (price.to = "beliebig")
  ) 
ORDER BY 
  price.articledetailsID ASC, 
  price.from ASC
array:6 [
  ":products" => array:6 [
    0 => 30
    1 => 31
    2 => 34
    3 => 44
    4 => 45
    5 => 47
  ]
  ":customerGroup" => "EK"
  ":language" => 3
  ":translation6afe1f09604cas_articles_prices_attributes" => "s_articles_prices_attributes"
  ":languagefallback" => 0
  ":translation6afe1f09604cefallbacks_articles_prices_attributes" => "s_articles_prices_attributes"
]
0.0005 ms
SELECT 
  (
    SELECT 
      prices.id 
    FROM 
      s_articles_prices prices 
      INNER JOIN s_articles_details variant ON variant.id = prices.articledetailsID 
      INNER JOIN s_articles product ON product.id = variant.articleID 
      LEFT JOIN s_core_pricegroups_discounts priceGroup ON priceGroup.groupID = product.pricegroupID 
      AND priceGroup.discountstart = 1 
      AND priceGroup.customergroupID = : priceGroupCustomerGroup 
      AND product.pricegroupActive = 1 
    WHERE 
      (
        prices.pricegroup = : customerGroup
      ) 
      AND (prices.from = 1) 
      AND (variant.active = 1) 
      AND (
        prices.articleID = outerPrices.articleID
      ) 
      AND (
        (
          variant.laststock * variant.instock
        ) >= (
          variant.laststock * variant.minpurchase
        )
      ) 
    ORDER BY 
      prices.price ASC 
    LIMIT 
      1
  ) as priceId 
FROM 
  s_articles_prices outerPrices 
WHERE 
  outerPrices.articleID IN (: products) 
GROUP BY 
  outerPrices.articleID 
HAVING 
  priceId IS NOT NULL
array:3 [
  ":customerGroup" => "EK"
  ":products" => array:6 [
    0 => 11
    1 => 12
    2 => 13
    3 => 15
    4 => 16
    5 => 18
  ]
  ":priceGroupCustomerGroup" => 1
]
0.0004 ms
SELECT 
  price.id as __price_id, 
  price.pricegroup as __price_pricegroup, 
  price.from as __price_from, 
  price.to as __price_to, 
  price.articleID as __price_articleID, 
  price.articledetailsID as __price_articledetailsID, 
  price.price as __price_price, 
  price.pseudoprice as __price_pseudoprice, 
  price.percent as __price_percent, 
  priceAttribute.id as __priceAttribute_id, 
  priceAttribute.priceID as __priceAttribute_priceID, 
  unit.id as __unit_id, 
  unit.description as __unit_description, 
  unit.unit as __unit_unit, 
  variant.packunit as __unit_packunit, 
  variant.purchaseunit as __unit_purchaseunit, 
  variant.referenceunit as __unit_referenceunit, 
  variant.purchasesteps as __unit_purchasesteps, 
  variant.minpurchase as __unit_minpurchase, 
  variant.maxpurchase as __unit_maxpurchase, 
  translation6afe1f09608ccconfig_units.objectdata as __unit_translation, 
  translation6afe1f09608d0fallbackconfig_units.objectdata as __unit_translation_fallback, 
  translation6afe1f09608d3article.objectdata as __product_translation, 
  translation6afe1f09608d5fallbackarticle.objectdata as __product_translation_fallback, 
  translation6afe1f09608d7variant.objectdata as __variant_translation, 
  translation6afe1f09608d8fallbackvariant.objectdata as __variant_translation_fallback, 
  translation6afe1f09608das_articles_prices_attributes.objectdata as __priceAttribute_translation, 
  translation6afe1f09608dbfallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 
FROM 
  s_articles_prices price 
  INNER JOIN s_articles_details variant ON variant.id = price.articledetailsID 
  LEFT JOIN s_articles_prices_attributes priceAttribute ON priceAttribute.priceID = price.id 
  INNER JOIN s_articles product ON product.id = variant.articleID 
  LEFT JOIN s_core_units unit ON unit.id = variant.unitID 
  LEFT JOIN s_core_translations translation6afe1f09608d7variant ON translation6afe1f09608d7variant.objecttype = : translation6afe1f09608d7variant 
  AND translation6afe1f09608d7variant.objectkey = variant.id 
  AND translation6afe1f09608d7variant.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f09608d8fallbackvariant ON translation6afe1f09608d8fallbackvariant.objecttype = : translation6afe1f09608d8fallbackvariant 
  AND translation6afe1f09608d8fallbackvariant.objectkey = variant.id 
  AND translation6afe1f09608d8fallbackvariant.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f09608d3article ON translation6afe1f09608d3article.objecttype = : translation6afe1f09608d3article 
  AND translation6afe1f09608d3article.objectkey = product.id 
  AND translation6afe1f09608d3article.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f09608d5fallbackarticle ON translation6afe1f09608d5fallbackarticle.objecttype = : translation6afe1f09608d5fallbackarticle 
  AND translation6afe1f09608d5fallbackarticle.objectkey = product.id 
  AND translation6afe1f09608d5fallbackarticle.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f09608ccconfig_units ON translation6afe1f09608ccconfig_units.objecttype = : translation6afe1f09608ccconfig_units 
  AND translation6afe1f09608ccconfig_units.objectkey = 1 
  AND translation6afe1f09608ccconfig_units.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f09608d0fallbackconfig_units ON translation6afe1f09608d0fallbackconfig_units.objecttype = : translation6afe1f09608d0fallbackconfig_units 
  AND translation6afe1f09608d0fallbackconfig_units.objectkey = 1 
  AND translation6afe1f09608d0fallbackconfig_units.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f09608das_articles_prices_attributes ON translation6afe1f09608das_articles_prices_attributes.objecttype = : translation6afe1f09608das_articles_prices_attributes 
  AND translation6afe1f09608das_articles_prices_attributes.objectkey = price.id 
  AND translation6afe1f09608das_articles_prices_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f09608dbfallbacks_articles_prices_attributes ON translation6afe1f09608dbfallbacks_articles_prices_attributes.objecttype = : translation6afe1f09608dbfallbacks_articles_prices_attributes 
  AND translation6afe1f09608dbfallbacks_articles_prices_attributes.objectkey = price.id 
  AND translation6afe1f09608dbfallbacks_articles_prices_attributes.objectlanguage = : languagefallback 
WHERE 
  price.id IN (: ids)
array:11 [
  ":ids" => array:5 [
    0 => "54"
    1 => "69"
    2 => "102"
    3 => "103"
    4 => "105"
  ]
  ":language" => 3
  ":translation6afe1f09608ccconfig_units" => "config_units"
  ":languagefallback" => 0
  ":translation6afe1f09608d0fallbackconfig_units" => "config_units"
  ":translation6afe1f09608d3article" => "article"
  ":translation6afe1f09608d5fallbackarticle" => "article"
  ":translation6afe1f09608d7variant" => "variant"
  ":translation6afe1f09608d8fallbackvariant" => "variant"
  ":translation6afe1f09608das_articles_prices_attributes" => "s_articles_prices_attributes"
  ":translation6afe1f09608dbfallbacks_articles_prices_attributes" => "s_articles_prices_attributes"
]
0.0007 ms
SELECT 
  (
    SELECT 
      prices.id 
    FROM 
      s_articles_prices prices 
      INNER JOIN s_articles_details variant ON variant.id = prices.articledetailsID 
      INNER JOIN s_articles product ON product.id = variant.articleID 
      LEFT JOIN s_core_pricegroups_discounts priceGroup ON priceGroup.groupID = product.pricegroupID 
      AND priceGroup.discountstart = 1 
      AND priceGroup.customergroupID = : priceGroupCustomerGroup 
      AND product.pricegroupActive = 1 
    WHERE 
      (
        prices.pricegroup = : customerGroup
      ) 
      AND (prices.from = 1) 
      AND (variant.active = 1) 
      AND (
        prices.articleID = outerPrices.articleID
      ) 
      AND (
        (
          variant.laststock * variant.instock
        ) >= (
          variant.laststock * variant.minpurchase
        )
      ) 
    ORDER BY 
      prices.price ASC 
    LIMIT 
      1
  ) as priceId 
FROM 
  s_articles_prices outerPrices 
WHERE 
  outerPrices.articleID IN (: products) 
GROUP BY 
  outerPrices.articleID 
HAVING 
  priceId IS NOT NULL
array:3 [
  ":customerGroup" => "EK"
  ":products" => array:1 [
    0 => 11
  ]
  ":priceGroupCustomerGroup" => 1
]
0.0003 ms
SELECT 
  price.id as __price_id, 
  price.pricegroup as __price_pricegroup, 
  price.from as __price_from, 
  price.to as __price_to, 
  price.articleID as __price_articleID, 
  price.articledetailsID as __price_articledetailsID, 
  price.price as __price_price, 
  price.pseudoprice as __price_pseudoprice, 
  price.percent as __price_percent, 
  priceAttribute.id as __priceAttribute_id, 
  priceAttribute.priceID as __priceAttribute_priceID, 
  unit.id as __unit_id, 
  unit.description as __unit_description, 
  unit.unit as __unit_unit, 
  variant.packunit as __unit_packunit, 
  variant.purchaseunit as __unit_purchaseunit, 
  variant.referenceunit as __unit_referenceunit, 
  variant.purchasesteps as __unit_purchasesteps, 
  variant.minpurchase as __unit_minpurchase, 
  variant.maxpurchase as __unit_maxpurchase, 
  translation6afe1f0960d33config_units.objectdata as __unit_translation, 
  translation6afe1f0960d37fallbackconfig_units.objectdata as __unit_translation_fallback, 
  translation6afe1f0960d3aarticle.objectdata as __product_translation, 
  translation6afe1f0960d3cfallbackarticle.objectdata as __product_translation_fallback, 
  translation6afe1f0960d3evariant.objectdata as __variant_translation, 
  translation6afe1f0960d3ffallbackvariant.objectdata as __variant_translation_fallback, 
  translation6afe1f0960d41s_articles_prices_attributes.objectdata as __priceAttribute_translation, 
  translation6afe1f0960d42fallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 
FROM 
  s_articles_prices price 
  INNER JOIN s_articles_details variant ON variant.id = price.articledetailsID 
  LEFT JOIN s_articles_prices_attributes priceAttribute ON priceAttribute.priceID = price.id 
  INNER JOIN s_articles product ON product.id = variant.articleID 
  LEFT JOIN s_core_units unit ON unit.id = variant.unitID 
  LEFT JOIN s_core_translations translation6afe1f0960d3evariant ON translation6afe1f0960d3evariant.objecttype = : translation6afe1f0960d3evariant 
  AND translation6afe1f0960d3evariant.objectkey = variant.id 
  AND translation6afe1f0960d3evariant.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0960d3ffallbackvariant ON translation6afe1f0960d3ffallbackvariant.objecttype = : translation6afe1f0960d3ffallbackvariant 
  AND translation6afe1f0960d3ffallbackvariant.objectkey = variant.id 
  AND translation6afe1f0960d3ffallbackvariant.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f0960d3aarticle ON translation6afe1f0960d3aarticle.objecttype = : translation6afe1f0960d3aarticle 
  AND translation6afe1f0960d3aarticle.objectkey = product.id 
  AND translation6afe1f0960d3aarticle.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0960d3cfallbackarticle ON translation6afe1f0960d3cfallbackarticle.objecttype = : translation6afe1f0960d3cfallbackarticle 
  AND translation6afe1f0960d3cfallbackarticle.objectkey = product.id 
  AND translation6afe1f0960d3cfallbackarticle.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f0960d33config_units ON translation6afe1f0960d33config_units.objecttype = : translation6afe1f0960d33config_units 
  AND translation6afe1f0960d33config_units.objectkey = 1 
  AND translation6afe1f0960d33config_units.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0960d37fallbackconfig_units ON translation6afe1f0960d37fallbackconfig_units.objecttype = : translation6afe1f0960d37fallbackconfig_units 
  AND translation6afe1f0960d37fallbackconfig_units.objectkey = 1 
  AND translation6afe1f0960d37fallbackconfig_units.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f0960d41s_articles_prices_attributes ON translation6afe1f0960d41s_articles_prices_attributes.objecttype = : translation6afe1f0960d41s_articles_prices_attributes 
  AND translation6afe1f0960d41s_articles_prices_attributes.objectkey = price.id 
  AND translation6afe1f0960d41s_articles_prices_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0960d42fallbacks_articles_prices_attributes ON translation6afe1f0960d42fallbacks_articles_prices_attributes.objecttype = : translation6afe1f0960d42fallbacks_articles_prices_attributes 
  AND translation6afe1f0960d42fallbacks_articles_prices_attributes.objectkey = price.id 
  AND translation6afe1f0960d42fallbacks_articles_prices_attributes.objectlanguage = : languagefallback 
WHERE 
  price.id IN (: ids)
array:11 [
  ":ids" => []
  ":language" => 3
  ":translation6afe1f0960d33config_units" => "config_units"
  ":languagefallback" => 0
  ":translation6afe1f0960d37fallbackconfig_units" => "config_units"
  ":translation6afe1f0960d3aarticle" => "article"
  ":translation6afe1f0960d3cfallbackarticle" => "article"
  ":translation6afe1f0960d3evariant" => "variant"
  ":translation6afe1f0960d3ffallbackvariant" => "variant"
  ":translation6afe1f0960d41s_articles_prices_attributes" => "s_articles_prices_attributes"
  ":translation6afe1f0960d42fallbacks_articles_prices_attributes" => "s_articles_prices_attributes"
]
0.0005 ms
SELECT 
  articleID, 
  COUNT(id) as total, 
  points 
FROM 
  s_articles_vote vote 
WHERE 
  (
    vote.articleID IN (: products)
  ) 
  AND (vote.active = 1) 
GROUP BY 
  vote.articleID, 
  vote.points 
ORDER BY 
  vote.articleID ASC
array:1 [
  ":products" => array:6 [
    0 => 11
    1 => 12
    2 => 13
    3 => 15
    4 => 16
    5 => 18
  ]
]
0.0002 ms
SELECT 
  mapping.articleID, 
  GROUP_CONCAT(DISTINCT mapping.categoryID) 
FROM 
  s_articles_categories_ro mapping 
WHERE 
  mapping.articleID IN (: ids) 
GROUP BY 
  mapping.articleID
array:1 [
  ":ids" => array:6 [
    0 => 11
    1 => 12
    2 => 13
    3 => 15
    4 => 16
    5 => 18
  ]
]
0.0003 ms
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, 
  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, 
  translation6afe1f096128as_categories_attributes.objectdata as __categoryAttribute_translation, 
  translation6afe1f096128efallbacks_categories_attributes.objectdata as __categoryAttribute_translation_fallback, 
  translation6afe1f0961291s_media_attributes.objectdata as __mediaAttribute_translation, 
  translation6afe1f0961292fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback, 
  translation6afe1f0961295productStream.objectdata as __stream_translation, 
  translation6afe1f0961296fallbackproductStream.objectdata as __stream_translation_fallback, 
  translation6afe1f0961298category.objectdata as __category_translation, 
  translation6afe1f096129afallbackcategory.objectdata as __category_translation_fallback 
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_core_translations translation6afe1f0961298category ON translation6afe1f0961298category.objecttype = : translation6afe1f0961298category 
  AND translation6afe1f0961298category.objectkey = category.id 
  AND translation6afe1f0961298category.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096129afallbackcategory ON translation6afe1f096129afallbackcategory.objecttype = : translation6afe1f096129afallbackcategory 
  AND translation6afe1f096129afallbackcategory.objectkey = category.id 
  AND translation6afe1f096129afallbackcategory.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f096128as_categories_attributes ON translation6afe1f096128as_categories_attributes.objecttype = : translation6afe1f096128as_categories_attributes 
  AND translation6afe1f096128as_categories_attributes.objectkey = category.id 
  AND translation6afe1f096128as_categories_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096128efallbacks_categories_attributes ON translation6afe1f096128efallbacks_categories_attributes.objecttype = : translation6afe1f096128efallbacks_categories_attributes 
  AND translation6afe1f096128efallbacks_categories_attributes.objectkey = category.id 
  AND translation6afe1f096128efallbacks_categories_attributes.objectlanguage = : languagefallback 
  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_core_translations translation6afe1f0961291s_media_attributes ON translation6afe1f0961291s_media_attributes.objecttype = : translation6afe1f0961291s_media_attributes 
  AND translation6afe1f0961291s_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f0961291s_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0961292fallbacks_media_attributes ON translation6afe1f0961292fallbacks_media_attributes.objecttype = : translation6afe1f0961292fallbacks_media_attributes 
  AND translation6afe1f0961292fallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f0961292fallbacks_media_attributes.objectlanguage = : languagefallback 
  LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId 
  LEFT JOIN s_core_translations translation6afe1f0961295productStream ON translation6afe1f0961295productStream.objecttype = : translation6afe1f0961295productStream 
  AND translation6afe1f0961295productStream.objectkey = stream.id 
  AND translation6afe1f0961295productStream.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0961296fallbackproductStream ON translation6afe1f0961296fallbackproductStream.objecttype = : translation6afe1f0961296fallbackproductStream 
  AND translation6afe1f0961296fallbackproductStream.objectkey = stream.id 
  AND translation6afe1f0961296fallbackproductStream.objectlanguage = : languagefallback 
WHERE 
  (
    category.id IN (: categories)
  ) 
  AND (category.active = 1) 
  AND (
    category.shops IS NULL 
    OR category.shops LIKE : shopId
  ) 
GROUP BY 
  category.id
array:12 [
  ":categories" => array:22 [
    0 => "3"
    1 => "5"
    2 => "7"
    3 => "9"
    4 => "15"
    5 => "16"
    6 => "17"
    7 => "35"
    8 => "36"
    9 => "37"
    10 => "38"
    11 => "39"
    12 => "40"
    13 => "41"
    14 => "42"
    15 => "43"
    16 => "44"
    17 => "45"
    18 => "46"
    19 => "47"
    20 => "48"
    21 => "49"
  ]
  ":shopId" => "%|3|%"
  ":language" => 3
  ":translation6afe1f096128as_categories_attributes" => "s_categories_attributes"
  ":languagefallback" => 0
  ":translation6afe1f096128efallbacks_categories_attributes" => "s_categories_attributes"
  ":translation6afe1f0961291s_media_attributes" => "s_media_attributes"
  ":translation6afe1f0961292fallbacks_media_attributes" => "s_media_attributes"
  ":translation6afe1f0961295productStream" => "productStream"
  ":translation6afe1f0961296fallbackproductStream" => "productStream"
  ":translation6afe1f0961298category" => "category"
  ":translation6afe1f096129afallbackcategory" => "category"
]
0.0011 ms
SELECT 
  media.id as __media_id, 
  media.albumID as __media_albumID, 
  media.name as __media_name, 
  media.description as __media_description, 
  media.path as __media_path, 
  media.type as __media_type, 
  media.extension as __media_extension, 
  media.file_size as __media_file_size, 
  media.width as __media_width, 
  media.height as __media_height, 
  media.userID as __media_userID, 
  media.created as __media_created, 
  mediaSettings.id as __mediaSettings_id, 
  mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, 
  mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, 
  mediaSettings.icon as __mediaSettings_icon, 
  mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, 
  mediaAttribute.id as __mediaAttribute_id, 
  mediaAttribute.mediaID as __mediaAttribute_mediaID, 
  translation6afe1f09617fas_media_attributes.objectdata as __mediaAttribute_translation, 
  translation6afe1f09617fefallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 
FROM 
  s_media media 
  INNER 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_core_translations translation6afe1f09617fas_media_attributes ON translation6afe1f09617fas_media_attributes.objecttype = : translation6afe1f09617fas_media_attributes 
  AND translation6afe1f09617fas_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f09617fas_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f09617fefallbacks_media_attributes ON translation6afe1f09617fefallbacks_media_attributes.objecttype = : translation6afe1f09617fefallbacks_media_attributes 
  AND translation6afe1f09617fefallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f09617fefallbacks_media_attributes.objectlanguage = : languagefallback 
WHERE 
  media.id IN (: ids)
array:5 [
  ":language" => 3
  ":translation6afe1f09617fas_media_attributes" => "s_media_attributes"
  ":languagefallback" => 0
  ":translation6afe1f09617fefallbacks_media_attributes" => "s_media_attributes"
  ":ids" => array:4 [
    10012 => 2
    10013 => 2
    10015 => 2
    10018 => 2
  ]
]
0.0003 ms
SELECT 
  relation.article_id, 
  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, 
  translation6afe1f0961a4aproductStream.objectdata as __stream_translation, 
  translation6afe1f0961a4efallbackproductStream.objectdata as __stream_translation_fallback 
FROM 
  s_product_streams_articles relation 
  INNER JOIN s_product_streams stream ON stream.id = relation.stream_id 
  LEFT JOIN s_product_streams_attributes productStreamAttribute ON productStreamAttribute.streamID = stream.id 
  LEFT JOIN s_core_translations translation6afe1f0961a4aproductStream ON translation6afe1f0961a4aproductStream.objecttype = : translation6afe1f0961a4aproductStream 
  AND translation6afe1f0961a4aproductStream.objectkey = stream.id 
  AND translation6afe1f0961a4aproductStream.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0961a4efallbackproductStream ON translation6afe1f0961a4efallbackproductStream.objecttype = : translation6afe1f0961a4efallbackproductStream 
  AND translation6afe1f0961a4efallbackproductStream.objectkey = stream.id 
  AND translation6afe1f0961a4efallbackproductStream.objectlanguage = : languagefallback 
WHERE 
  relation.article_id IN (: ids)
array:5 [
  ":ids" => array:1 [
    0 => 19
  ]
  ":language" => 3
  ":translation6afe1f0961a4aproductStream" => "productStream"
  ":languagefallback" => 0
  ":translation6afe1f0961a4efallbackproductStream" => "productStream"
]
0.0003 ms
SELECT 
  product.id, 
  similarVariant.ordernumber as number 
FROM 
  s_articles_similar similar 
  INNER JOIN s_articles product ON product.id = similar.articleID 
  INNER JOIN s_articles similarArticles ON similarArticles.id = similar.relatedArticle 
  INNER JOIN s_articles_details similarVariant ON similarVariant.id = similarArticles.main_detail_id 
WHERE 
  product.id IN (: ids)
array:1 [
  ":ids" => array:1 [
    0 => 19
  ]
]
0.0002 ms
SELECT 
  product.id as __product_id, 
  product.supplierID as __product_supplierID, 
  product.name as __product_name, 
  product.description as __product_description, 
  product.description_long as __product_description_long, 
  product.shippingtime as __product_shippingtime, 
  product.datum as __product_datum, 
  product.active as __product_active, 
  product.taxID as __product_taxID, 
  product.pseudosales as __product_pseudosales, 
  product.topseller as __product_topseller, 
  product.metaTitle as __product_metaTitle, 
  product.keywords as __product_keywords, 
  product.changetime as __product_changetime, 
  product.pricegroupID as __product_pricegroupID, 
  product.pricegroupActive as __product_pricegroupActive, 
  product.filtergroupID as __product_filtergroupID, 
  product.crossbundlelook as __product_crossbundlelook, 
  product.notification as __product_notification, 
  product.template as __product_template, 
  product.mode as __product_mode, 
  product.main_detail_id as __product_main_detail_id, 
  product.available_from as __product_available_from, 
  product.available_to as __product_available_to, 
  product.configurator_set_id as __product_configurator_set_id, 
  productAttribute.id as __productAttribute_id, 
  productAttribute.articledetailsID as __productAttribute_articledetailsID, 
  productAttribute.attr1 as __productAttribute_attr1, 
  productAttribute.attr2 as __productAttribute_attr2, 
  productAttribute.attr3 as __productAttribute_attr3, 
  productAttribute.attr4 as __productAttribute_attr4, 
  productAttribute.attr5 as __productAttribute_attr5, 
  productAttribute.attr6 as __productAttribute_attr6, 
  productAttribute.attr7 as __productAttribute_attr7, 
  productAttribute.attr8 as __productAttribute_attr8, 
  productAttribute.attr9 as __productAttribute_attr9, 
  productAttribute.attr10 as __productAttribute_attr10, 
  productAttribute.attr11 as __productAttribute_attr11, 
  productAttribute.attr12 as __productAttribute_attr12, 
  productAttribute.attr13 as __productAttribute_attr13, 
  productAttribute.attr14 as __productAttribute_attr14, 
  productAttribute.attr15 as __productAttribute_attr15, 
  productAttribute.attr16 as __productAttribute_attr16, 
  productAttribute.attr17 as __productAttribute_attr17, 
  productAttribute.attr18 as __productAttribute_attr18, 
  productAttribute.attr19 as __productAttribute_attr19, 
  productAttribute.attr20 as __productAttribute_attr20, 
  topSeller.sales as __topSeller_sales, 
  variant.id as __variant_id, 
  variant.ordernumber as __variant_ordernumber, 
  variant.suppliernumber as __variant_suppliernumber, 
  variant.kind as __variant_kind, 
  variant.additionaltext as __variant_additionaltext, 
  variant.sales as __variant_sales, 
  variant.active as __variant_active, 
  variant.instock as __variant_instock, 
  variant.stockmin as __variant_stockmin, 
  variant.weight as __variant_weight, 
  variant.position as __variant_position, 
  variant.width as __variant_width, 
  variant.height as __variant_height, 
  variant.length as __variant_length, 
  variant.ean as __variant_ean, 
  variant.unitID as __variant_unitID, 
  variant.releasedate as __variant_releasedate, 
  variant.shippingfree as __variant_shippingfree, 
  variant.shippingtime as __variant_shippingtime, 
  variant.laststock as __product_laststock, 
  unit.id as __unit_id, 
  unit.description as __unit_description, 
  unit.unit as __unit_unit, 
  variant.packunit as __unit_packunit, 
  variant.purchaseunit as __unit_purchaseunit, 
  variant.referenceunit as __unit_referenceunit, 
  variant.purchasesteps as __unit_purchasesteps, 
  variant.minpurchase as __unit_minpurchase, 
  variant.maxpurchase as __unit_maxpurchase, 
  tax.id as __tax_id, 
  tax.tax as __tax_tax, 
  tax.description as __tax_description, 
  priceGroup.id as __priceGroup_id, 
  priceGroup.description as __priceGroup_description, 
  manufacturer.id as __manufacturer_id, 
  manufacturer.name as __manufacturer_name, 
  manufacturer.img as __manufacturer_img, 
  manufacturer.link as __manufacturer_link, 
  manufacturer.description as __manufacturer_description, 
  manufacturer.meta_title as __manufacturer_meta_title, 
  manufacturer.meta_description as __manufacturer_meta_description, 
  manufacturer.meta_keywords as __manufacturer_meta_keywords, 
  manufacturerAttribute.id as __manufacturerAttribute_id, 
  manufacturerAttribute.supplierID as __manufacturerAttribute_supplierID, 
  esd.id as __esd_id, 
  esd.articleID as __esd_articleID, 
  esd.articledetailsID as __esd_articledetailsID, 
  esd.file as __esd_file, 
  esd.serials as __esd_serials, 
  esd.notification as __esd_notification, 
  esd.maxdownloads as __esd_maxdownloads, 
  esd.datum as __esd_datum, 
  esdAttribute.id as __esdAttribute_id, 
  esdAttribute.esdID as __esdAttribute_esdID, 
  (
    SELECT 
      1 
    FROM 
      s_articles_esd variantEsd 
    WHERE 
      variantEsd.articleID = product.id 
    LIMIT 
      1
  ) as __product_has_esd, 
  (
    SELECT 
      GROUP_CONCAT(
        customerGroups.customergroupId SEPARATOR '|'
      ) 
    FROM 
      s_articles_avoid_customergroups customerGroups 
    WHERE 
      customerGroups.articleID = product.id
  ) as __product_blocked_customer_groups, 
  (
    SELECT 
      COUNT(availableVariant.id) 
    FROM 
      s_articles_details availableVariant 
    WHERE 
      (
        availableVariant.articleID = product.id
      ) 
      AND (availableVariant.active = 1) 
      AND (
        (
          availableVariant.laststock * availableVariant.instock
        ) >= (
          availableVariant.laststock * availableVariant.minpurchase
        )
      )
  ) as __product_has_available_variants, 
  (
    SELECT 
      COUNT(
        DISTINCT ROUND(prices.price, 2)
      ) as priceCount 
    FROM 
      s_articles_prices prices 
      INNER JOIN s_articles_details priceVariant ON priceVariant.id = prices.articledetailsID 
      and priceVariant.active = 1 
    WHERE 
      (prices.from = 1) 
      AND (prices.pricegroup = : fallback) 
      AND (prices.articleID = product.id)
  ) as __product_fallback_price_count, 
  manufacturerMedia.id as __manufacturer_img_id, 
  translation6afe1f0961d75article.objectdata as __product_translation, 
  translation6afe1f0961d7afallbackarticle.objectdata as __product_translation_fallback, 
  translation6afe1f0961d7dvariant.objectdata as __variant_translation, 
  translation6afe1f0961d7ffallbackvariant.objectdata as __variant_translation_fallback, 
  translation6afe1f0961d82supplier.objectdata as __manufacturer_translation, 
  translation6afe1f0961d84fallbacksupplier.objectdata as __manufacturer_translation_fallback, 
  translation6afe1f0961d87config_units.objectdata as __unit_translation, 
  translation6afe1f0961d89fallbackconfig_units.objectdata as __unit_translation_fallback, 
  translation6afe1f0961d8bs_articles_esd_attributes.objectdata as __esdAttribute_translation, 
  translation6afe1f0961d8efallbacks_articles_esd_attributes.objectdata as __esdAttribute_translation_fallback 
FROM 
  s_articles_details variant 
  INNER JOIN s_articles product ON product.id = variant.articleID 
  LEFT JOIN s_core_units unit ON unit.id = variant.unitID 
  LEFT JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id 
  LEFT JOIN s_articles_esd esd ON esd.articledetailsID = variant.id 
  LEFT JOIN s_core_translations translation6afe1f0961d7dvariant ON translation6afe1f0961d7dvariant.objecttype = : translation6afe1f0961d7dvariant 
  AND translation6afe1f0961d7dvariant.objectkey = variant.id 
  AND translation6afe1f0961d7dvariant.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0961d7ffallbackvariant ON translation6afe1f0961d7ffallbackvariant.objecttype = : translation6afe1f0961d7ffallbackvariant 
  AND translation6afe1f0961d7ffallbackvariant.objectkey = variant.id 
  AND translation6afe1f0961d7ffallbackvariant.objectlanguage = : languagefallback 
  INNER JOIN s_core_tax tax ON tax.id = product.taxID 
  LEFT JOIN s_articles_supplier manufacturer ON manufacturer.id = product.supplierID 
  LEFT JOIN s_core_pricegroups priceGroup ON priceGroup.id = product.pricegroupID 
  LEFT JOIN s_articles_supplier_attributes manufacturerAttribute ON manufacturerAttribute.supplierID = product.supplierID 
  LEFT JOIN s_articles_top_seller_ro topSeller ON topSeller.article_id = product.id 
  LEFT JOIN s_core_translations translation6afe1f0961d75article ON translation6afe1f0961d75article.objecttype = : translation6afe1f0961d75article 
  AND translation6afe1f0961d75article.objectkey = product.id 
  AND translation6afe1f0961d75article.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0961d7afallbackarticle ON translation6afe1f0961d7afallbackarticle.objecttype = : translation6afe1f0961d7afallbackarticle 
  AND translation6afe1f0961d7afallbackarticle.objectkey = product.id 
  AND translation6afe1f0961d7afallbackarticle.objectlanguage = : languagefallback 
  LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img 
  LEFT JOIN s_core_translations translation6afe1f0961d82supplier ON translation6afe1f0961d82supplier.objecttype = : translation6afe1f0961d82supplier 
  AND translation6afe1f0961d82supplier.objectkey = manufacturer.id 
  AND translation6afe1f0961d82supplier.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0961d84fallbacksupplier ON translation6afe1f0961d84fallbacksupplier.objecttype = : translation6afe1f0961d84fallbacksupplier 
  AND translation6afe1f0961d84fallbacksupplier.objectkey = manufacturer.id 
  AND translation6afe1f0961d84fallbacksupplier.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f0961d87config_units ON translation6afe1f0961d87config_units.objecttype = : translation6afe1f0961d87config_units 
  AND translation6afe1f0961d87config_units.objectkey = 1 
  AND translation6afe1f0961d87config_units.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0961d89fallbackconfig_units ON translation6afe1f0961d89fallbackconfig_units.objecttype = : translation6afe1f0961d89fallbackconfig_units 
  AND translation6afe1f0961d89fallbackconfig_units.objectkey = 1 
  AND translation6afe1f0961d89fallbackconfig_units.objectlanguage = : languagefallback 
  LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id 
  LEFT JOIN s_core_translations translation6afe1f0961d8bs_articles_esd_attributes ON translation6afe1f0961d8bs_articles_esd_attributes.objecttype = : translation6afe1f0961d8bs_articles_esd_attributes 
  AND translation6afe1f0961d8bs_articles_esd_attributes.objectkey = esd.id 
  AND translation6afe1f0961d8bs_articles_esd_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0961d8efallbacks_articles_esd_attributes ON translation6afe1f0961d8efallbacks_articles_esd_attributes.objecttype = : translation6afe1f0961d8efallbacks_articles_esd_attributes 
  AND translation6afe1f0961d8efallbacks_articles_esd_attributes.objectkey = esd.id 
  AND translation6afe1f0961d8efallbacks_articles_esd_attributes.objectlanguage = : languagefallback 
WHERE 
  (
    variant.ordernumber IN (: numbers)
  ) 
  AND (variant.active = 1) 
  AND (product.active = 1)
array:14 [
  ":fallback" => "EK"
  ":numbers" => []
  ":language" => 3
  ":translation6afe1f0961d75article" => "article"
  ":languagefallback" => 0
  ":translation6afe1f0961d7afallbackarticle" => "article"
  ":translation6afe1f0961d7dvariant" => "variant"
  ":translation6afe1f0961d7ffallbackvariant" => "variant"
  ":translation6afe1f0961d82supplier" => "supplier"
  ":translation6afe1f0961d84fallbacksupplier" => "supplier"
  ":translation6afe1f0961d87config_units" => "config_units"
  ":translation6afe1f0961d89fallbackconfig_units" => "config_units"
  ":translation6afe1f0961d8bs_articles_esd_attributes" => "s_articles_esd_attributes"
  ":translation6afe1f0961d8efallbacks_articles_esd_attributes" => "s_articles_esd_attributes"
]
0.0014 ms
SELECT 
  variant.ordernumber as number, 
  media.id as __media_id, 
  media.albumID as __media_albumID, 
  media.name as __media_name, 
  media.description as __media_description, 
  media.path as __media_path, 
  media.type as __media_type, 
  media.extension as __media_extension, 
  media.file_size as __media_file_size, 
  media.width as __media_width, 
  media.height as __media_height, 
  media.userID as __media_userID, 
  media.created as __media_created, 
  mediaSettings.id as __mediaSettings_id, 
  mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, 
  mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, 
  mediaSettings.icon as __mediaSettings_icon, 
  mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, 
  mediaAttribute.id as __mediaAttribute_id, 
  mediaAttribute.mediaID as __mediaAttribute_mediaID, 
  image.id as __image_id, 
  image.articleID as __image_articleID, 
  image.img as __image_img, 
  image.main as __image_main, 
  image.description as __image_description, 
  image.position as __image_position, 
  image.width as __image_width, 
  image.height as __image_height, 
  image.extension as __image_extension, 
  image.parent_id as __image_parent_id, 
  image.media_id as __image_media_id, 
  imageAttribute.id as __imageAttribute_id, 
  imageAttribute.imageID as __imageAttribute_imageID, 
  imageAttribute.attribute1 as __imageAttribute_attribute1, 
  imageAttribute.attribute2 as __imageAttribute_attribute2, 
  imageAttribute.attribute3 as __imageAttribute_attribute3, 
  translation6afe1f096239farticleimage.objectdata as __image_translation, 
  translation6afe1f09623a3fallbackarticleimage.objectdata as __image_translation_fallback, 
  translation6afe1f09623a6s_media_attributes.objectdata as __mediaAttribute_translation, 
  translation6afe1f09623a8fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 
FROM 
  s_articles_img image 
  INNER JOIN s_media media ON image.media_id = media.id 
  INNER JOIN s_articles_img childImage ON childImage.parent_id = image.id 
  INNER JOIN s_articles_details variant ON variant.id = childImage.article_detail_id 
  LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id 
  LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id 
  LEFT JOIN s_core_translations translation6afe1f096239farticleimage ON translation6afe1f096239farticleimage.objecttype = : translation6afe1f096239farticleimage 
  AND translation6afe1f096239farticleimage.objectkey = image.id 
  AND translation6afe1f096239farticleimage.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f09623a3fallbackarticleimage ON translation6afe1f09623a3fallbackarticleimage.objecttype = : translation6afe1f09623a3fallbackarticleimage 
  AND translation6afe1f09623a3fallbackarticleimage.objectkey = image.id 
  AND translation6afe1f09623a3fallbackarticleimage.objectlanguage = : languagefallback 
  INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID 
  LEFT JOIN s_core_translations translation6afe1f09623a6s_media_attributes ON translation6afe1f09623a6s_media_attributes.objecttype = : translation6afe1f09623a6s_media_attributes 
  AND translation6afe1f09623a6s_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f09623a6s_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f09623a8fallbacks_media_attributes ON translation6afe1f09623a8fallbacks_media_attributes.objecttype = : translation6afe1f09623a8fallbacks_media_attributes 
  AND translation6afe1f09623a8fallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f09623a8fallbacks_media_attributes.objectlanguage = : languagefallback 
WHERE 
  childImage.article_detail_id IN (: products) 
ORDER BY 
  image.main ASC, 
  image.position ASC
array:7 [
  ":language" => 3
  ":translation6afe1f096239farticleimage" => "articleimage"
  ":languagefallback" => 0
  ":translation6afe1f09623a3fallbackarticleimage" => "articleimage"
  ":translation6afe1f09623a6s_media_attributes" => "s_media_attributes"
  ":translation6afe1f09623a8fallbacks_media_attributes" => "s_media_attributes"
  ":products" => []
]
0.0005 ms
SELECT 
  price.id as __price_id, 
  price.pricegroup as __price_pricegroup, 
  price.from as __price_from, 
  price.to as __price_to, 
  price.articleID as __price_articleID, 
  price.articledetailsID as __price_articledetailsID, 
  price.price as __price_price, 
  price.pseudoprice as __price_pseudoprice, 
  price.percent as __price_percent, 
  priceAttribute.id as __priceAttribute_id, 
  priceAttribute.priceID as __priceAttribute_priceID, 
  variants.ordernumber as number, 
  GREATEST(
    price.from, variants.minpurchase
  ) __price_from, 
  translation6afe1f096260bs_articles_prices_attributes.objectdata as __priceAttribute_translation, 
  translation6afe1f096260ffallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 
FROM 
  s_articles_prices price 
  INNER JOIN s_articles_details variants ON variants.id = price.articledetailsID 
  LEFT JOIN s_articles_prices_attributes priceAttribute ON priceAttribute.priceID = price.id 
  LEFT JOIN s_core_translations translation6afe1f096260bs_articles_prices_attributes ON translation6afe1f096260bs_articles_prices_attributes.objecttype = : translation6afe1f096260bs_articles_prices_attributes 
  AND translation6afe1f096260bs_articles_prices_attributes.objectkey = price.id 
  AND translation6afe1f096260bs_articles_prices_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096260ffallbacks_articles_prices_attributes ON translation6afe1f096260ffallbacks_articles_prices_attributes.objecttype = : translation6afe1f096260ffallbacks_articles_prices_attributes 
  AND translation6afe1f096260ffallbacks_articles_prices_attributes.objectkey = price.id 
  AND translation6afe1f096260ffallbacks_articles_prices_attributes.objectlanguage = : languagefallback 
WHERE 
  (
    price.articledetailsID IN (: products)
  ) 
  AND (
    price.pricegroup = : customerGroup
  ) 
  AND (
    (price.to >= variants.minpurchase) 
    OR (price.to = "beliebig")
  ) 
ORDER BY 
  price.articledetailsID ASC, 
  price.from ASC
array:6 [
  ":products" => []
  ":customerGroup" => "EK"
  ":language" => 3
  ":translation6afe1f096260bs_articles_prices_attributes" => "s_articles_prices_attributes"
  ":languagefallback" => 0
  ":translation6afe1f096260ffallbacks_articles_prices_attributes" => "s_articles_prices_attributes"
]
0.0003 ms
SELECT 
  (
    SELECT 
      prices.id 
    FROM 
      s_articles_prices prices 
      INNER JOIN s_articles_details variant ON variant.id = prices.articledetailsID 
      INNER JOIN s_articles product ON product.id = variant.articleID 
      LEFT JOIN s_core_pricegroups_discounts priceGroup ON priceGroup.groupID = product.pricegroupID 
      AND priceGroup.discountstart = 1 
      AND priceGroup.customergroupID = : priceGroupCustomerGroup 
      AND product.pricegroupActive = 1 
    WHERE 
      (
        prices.pricegroup = : customerGroup
      ) 
      AND (prices.from = 1) 
      AND (variant.active = 1) 
      AND (
        prices.articleID = outerPrices.articleID
      ) 
      AND (
        (
          variant.laststock * variant.instock
        ) >= (
          variant.laststock * variant.minpurchase
        )
      ) 
    ORDER BY 
      prices.price ASC 
    LIMIT 
      1
  ) as priceId 
FROM 
  s_articles_prices outerPrices 
WHERE 
  outerPrices.articleID IN (: products) 
GROUP BY 
  outerPrices.articleID 
HAVING 
  priceId IS NOT NULL
array:3 [
  ":customerGroup" => "EK"
  ":products" => []
  ":priceGroupCustomerGroup" => 1
]
0.0001 ms
SELECT 
  price.id as __price_id, 
  price.pricegroup as __price_pricegroup, 
  price.from as __price_from, 
  price.to as __price_to, 
  price.articleID as __price_articleID, 
  price.articledetailsID as __price_articledetailsID, 
  price.price as __price_price, 
  price.pseudoprice as __price_pseudoprice, 
  price.percent as __price_percent, 
  priceAttribute.id as __priceAttribute_id, 
  priceAttribute.priceID as __priceAttribute_priceID, 
  unit.id as __unit_id, 
  unit.description as __unit_description, 
  unit.unit as __unit_unit, 
  variant.packunit as __unit_packunit, 
  variant.purchaseunit as __unit_purchaseunit, 
  variant.referenceunit as __unit_referenceunit, 
  variant.purchasesteps as __unit_purchasesteps, 
  variant.minpurchase as __unit_minpurchase, 
  variant.maxpurchase as __unit_maxpurchase, 
  translation6afe1f096282cconfig_units.objectdata as __unit_translation, 
  translation6afe1f0962830fallbackconfig_units.objectdata as __unit_translation_fallback, 
  translation6afe1f0962832article.objectdata as __product_translation, 
  translation6afe1f0962834fallbackarticle.objectdata as __product_translation_fallback, 
  translation6afe1f0962836variant.objectdata as __variant_translation, 
  translation6afe1f0962838fallbackvariant.objectdata as __variant_translation_fallback, 
  translation6afe1f0962839s_articles_prices_attributes.objectdata as __priceAttribute_translation, 
  translation6afe1f096283bfallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 
FROM 
  s_articles_prices price 
  INNER JOIN s_articles_details variant ON variant.id = price.articledetailsID 
  LEFT JOIN s_articles_prices_attributes priceAttribute ON priceAttribute.priceID = price.id 
  INNER JOIN s_articles product ON product.id = variant.articleID 
  LEFT JOIN s_core_units unit ON unit.id = variant.unitID 
  LEFT JOIN s_core_translations translation6afe1f0962836variant ON translation6afe1f0962836variant.objecttype = : translation6afe1f0962836variant 
  AND translation6afe1f0962836variant.objectkey = variant.id 
  AND translation6afe1f0962836variant.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0962838fallbackvariant ON translation6afe1f0962838fallbackvariant.objecttype = : translation6afe1f0962838fallbackvariant 
  AND translation6afe1f0962838fallbackvariant.objectkey = variant.id 
  AND translation6afe1f0962838fallbackvariant.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f0962832article ON translation6afe1f0962832article.objecttype = : translation6afe1f0962832article 
  AND translation6afe1f0962832article.objectkey = product.id 
  AND translation6afe1f0962832article.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0962834fallbackarticle ON translation6afe1f0962834fallbackarticle.objecttype = : translation6afe1f0962834fallbackarticle 
  AND translation6afe1f0962834fallbackarticle.objectkey = product.id 
  AND translation6afe1f0962834fallbackarticle.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f096282cconfig_units ON translation6afe1f096282cconfig_units.objecttype = : translation6afe1f096282cconfig_units 
  AND translation6afe1f096282cconfig_units.objectkey = 1 
  AND translation6afe1f096282cconfig_units.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0962830fallbackconfig_units ON translation6afe1f0962830fallbackconfig_units.objecttype = : translation6afe1f0962830fallbackconfig_units 
  AND translation6afe1f0962830fallbackconfig_units.objectkey = 1 
  AND translation6afe1f0962830fallbackconfig_units.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f0962839s_articles_prices_attributes ON translation6afe1f0962839s_articles_prices_attributes.objecttype = : translation6afe1f0962839s_articles_prices_attributes 
  AND translation6afe1f0962839s_articles_prices_attributes.objectkey = price.id 
  AND translation6afe1f0962839s_articles_prices_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096283bfallbacks_articles_prices_attributes ON translation6afe1f096283bfallbacks_articles_prices_attributes.objecttype = : translation6afe1f096283bfallbacks_articles_prices_attributes 
  AND translation6afe1f096283bfallbacks_articles_prices_attributes.objectkey = price.id 
  AND translation6afe1f096283bfallbacks_articles_prices_attributes.objectlanguage = : languagefallback 
WHERE 
  price.id IN (: ids)
array:11 [
  ":ids" => []
  ":language" => 3
  ":translation6afe1f096282cconfig_units" => "config_units"
  ":languagefallback" => 0
  ":translation6afe1f0962830fallbackconfig_units" => "config_units"
  ":translation6afe1f0962832article" => "article"
  ":translation6afe1f0962834fallbackarticle" => "article"
  ":translation6afe1f0962836variant" => "variant"
  ":translation6afe1f0962838fallbackvariant" => "variant"
  ":translation6afe1f0962839s_articles_prices_attributes" => "s_articles_prices_attributes"
  ":translation6afe1f096283bfallbacks_articles_prices_attributes" => "s_articles_prices_attributes"
]
0.0005 ms
SELECT 
  articleID, 
  COUNT(id) as total, 
  points 
FROM 
  s_articles_vote vote 
WHERE 
  (
    vote.articleID IN (: products)
  ) 
  AND (vote.active = 1) 
GROUP BY 
  vote.articleID, 
  vote.points 
ORDER BY 
  vote.articleID ASC
array:1 [
  ":products" => []
]
0.0001 ms
SELECT 
  mapping.articleID, 
  GROUP_CONCAT(DISTINCT mapping.categoryID) 
FROM 
  s_articles_categories_ro mapping 
WHERE 
  mapping.articleID IN (: ids) 
GROUP BY 
  mapping.articleID
array:1 [
  ":ids" => []
]
0.0001 ms
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, 
  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, 
  translation6afe1f0962b97s_categories_attributes.objectdata as __categoryAttribute_translation, 
  translation6afe1f0962b9bfallbacks_categories_attributes.objectdata as __categoryAttribute_translation_fallback, 
  translation6afe1f0962b9es_media_attributes.objectdata as __mediaAttribute_translation, 
  translation6afe1f0962ba0fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback, 
  translation6afe1f0962ba2productStream.objectdata as __stream_translation, 
  translation6afe1f0962ba4fallbackproductStream.objectdata as __stream_translation_fallback, 
  translation6afe1f0962ba5category.objectdata as __category_translation, 
  translation6afe1f0962ba7fallbackcategory.objectdata as __category_translation_fallback 
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_core_translations translation6afe1f0962ba5category ON translation6afe1f0962ba5category.objecttype = : translation6afe1f0962ba5category 
  AND translation6afe1f0962ba5category.objectkey = category.id 
  AND translation6afe1f0962ba5category.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0962ba7fallbackcategory ON translation6afe1f0962ba7fallbackcategory.objecttype = : translation6afe1f0962ba7fallbackcategory 
  AND translation6afe1f0962ba7fallbackcategory.objectkey = category.id 
  AND translation6afe1f0962ba7fallbackcategory.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f0962b97s_categories_attributes ON translation6afe1f0962b97s_categories_attributes.objecttype = : translation6afe1f0962b97s_categories_attributes 
  AND translation6afe1f0962b97s_categories_attributes.objectkey = category.id 
  AND translation6afe1f0962b97s_categories_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0962b9bfallbacks_categories_attributes ON translation6afe1f0962b9bfallbacks_categories_attributes.objecttype = : translation6afe1f0962b9bfallbacks_categories_attributes 
  AND translation6afe1f0962b9bfallbacks_categories_attributes.objectkey = category.id 
  AND translation6afe1f0962b9bfallbacks_categories_attributes.objectlanguage = : languagefallback 
  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_core_translations translation6afe1f0962b9es_media_attributes ON translation6afe1f0962b9es_media_attributes.objecttype = : translation6afe1f0962b9es_media_attributes 
  AND translation6afe1f0962b9es_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f0962b9es_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0962ba0fallbacks_media_attributes ON translation6afe1f0962ba0fallbacks_media_attributes.objecttype = : translation6afe1f0962ba0fallbacks_media_attributes 
  AND translation6afe1f0962ba0fallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f0962ba0fallbacks_media_attributes.objectlanguage = : languagefallback 
  LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId 
  LEFT JOIN s_core_translations translation6afe1f0962ba2productStream ON translation6afe1f0962ba2productStream.objecttype = : translation6afe1f0962ba2productStream 
  AND translation6afe1f0962ba2productStream.objectkey = stream.id 
  AND translation6afe1f0962ba2productStream.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0962ba4fallbackproductStream ON translation6afe1f0962ba4fallbackproductStream.objecttype = : translation6afe1f0962ba4fallbackproductStream 
  AND translation6afe1f0962ba4fallbackproductStream.objectkey = stream.id 
  AND translation6afe1f0962ba4fallbackproductStream.objectlanguage = : languagefallback 
WHERE 
  (
    category.id IN (: categories)
  ) 
  AND (category.active = 1) 
  AND (
    category.shops IS NULL 
    OR category.shops LIKE : shopId
  ) 
GROUP BY 
  category.id
array:12 [
  ":categories" => []
  ":shopId" => "%|3|%"
  ":language" => 3
  ":translation6afe1f0962b97s_categories_attributes" => "s_categories_attributes"
  ":languagefallback" => 0
  ":translation6afe1f0962b9bfallbacks_categories_attributes" => "s_categories_attributes"
  ":translation6afe1f0962b9es_media_attributes" => "s_media_attributes"
  ":translation6afe1f0962ba0fallbacks_media_attributes" => "s_media_attributes"
  ":translation6afe1f0962ba2productStream" => "productStream"
  ":translation6afe1f0962ba4fallbackproductStream" => "productStream"
  ":translation6afe1f0962ba5category" => "category"
  ":translation6afe1f0962ba7fallbackcategory" => "category"
]
0.0008 ms
SELECT 
  media.id as __media_id, 
  media.albumID as __media_albumID, 
  media.name as __media_name, 
  media.description as __media_description, 
  media.path as __media_path, 
  media.type as __media_type, 
  media.extension as __media_extension, 
  media.file_size as __media_file_size, 
  media.width as __media_width, 
  media.height as __media_height, 
  media.userID as __media_userID, 
  media.created as __media_created, 
  mediaSettings.id as __mediaSettings_id, 
  mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, 
  mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, 
  mediaSettings.icon as __mediaSettings_icon, 
  mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, 
  mediaAttribute.id as __mediaAttribute_id, 
  mediaAttribute.mediaID as __mediaAttribute_mediaID, 
  translation6afe1f0962eefs_media_attributes.objectdata as __mediaAttribute_translation, 
  translation6afe1f0962ef4fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 
FROM 
  s_media media 
  INNER 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_core_translations translation6afe1f0962eefs_media_attributes ON translation6afe1f0962eefs_media_attributes.objecttype = : translation6afe1f0962eefs_media_attributes 
  AND translation6afe1f0962eefs_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f0962eefs_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0962ef4fallbacks_media_attributes ON translation6afe1f0962ef4fallbacks_media_attributes.objecttype = : translation6afe1f0962ef4fallbacks_media_attributes 
  AND translation6afe1f0962ef4fallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f0962ef4fallbacks_media_attributes.objectlanguage = : languagefallback 
WHERE 
  media.id IN (: ids)
array:5 [
  ":language" => 3
  ":translation6afe1f0962eefs_media_attributes" => "s_media_attributes"
  ":languagefallback" => 0
  ":translation6afe1f0962ef4fallbacks_media_attributes" => "s_media_attributes"
  ":ids" => []
]
0.0003 ms
SELECT 
  download.id as __download_id, 
  download.articleID as __download_articleID, 
  download.description as __download_description, 
  download.filename as __download_filename, 
  media.file_size as __download_size, 
  downloadAttribute.id as __downloadAttribute_id, 
  downloadAttribute.downloadID as __downloadAttribute_downloadID, 
  translation6afe1f09630a1s_articles_downloads_attributes.objectdata as __downloadAttribute_translation, 
  translation6afe1f09630a5fallbacks_articles_downloads_attributes.objectdata as __downloadAttribute_translation_fallback 
FROM 
  s_articles_downloads download 
  LEFT JOIN s_articles_downloads_attributes downloadAttribute ON downloadAttribute.downloadID = download.id 
  INNER JOIN s_media media ON media.path = download.filename 
  LEFT JOIN s_core_translations translation6afe1f09630a1s_articles_downloads_attributes ON translation6afe1f09630a1s_articles_downloads_attributes.objecttype = : translation6afe1f09630a1s_articles_downloads_attributes 
  AND translation6afe1f09630a1s_articles_downloads_attributes.objectkey = download.id 
  AND translation6afe1f09630a1s_articles_downloads_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f09630a5fallbacks_articles_downloads_attributes ON translation6afe1f09630a5fallbacks_articles_downloads_attributes.objecttype = : translation6afe1f09630a5fallbacks_articles_downloads_attributes 
  AND translation6afe1f09630a5fallbacks_articles_downloads_attributes.objectkey = download.id 
  AND translation6afe1f09630a5fallbacks_articles_downloads_attributes.objectlanguage = : languagefallback 
WHERE 
  download.articleID IN (: ids)
array:5 [
  ":ids" => array:1 [
    0 => 19
  ]
  ":language" => 3
  ":translation6afe1f09630a1s_articles_downloads_attributes" => "s_articles_downloads_attributes"
  ":languagefallback" => 0
  ":translation6afe1f09630a5fallbacks_articles_downloads_attributes" => "s_articles_downloads_attributes"
]
0.0003 ms
SELECT 
  link.id as __link_id, 
  link.articleID as __link_articleID, 
  link.description as __link_description, 
  link.link as __link_link, 
  link.target as __link_target, 
  linkAttribute.id as __linkAttribute_id, 
  linkAttribute.informationID as __linkAttribute_informationID, 
  translation6afe1f0963270s_articles_information_attributes.objectdata as __linkAttribute_translation, 
  translation6afe1f0963274fallbacks_articles_information_attributes.objectdata as __linkAttribute_translation_fallback 
FROM 
  s_articles_information link 
  LEFT JOIN s_articles_information_attributes linkAttribute ON linkAttribute.informationID = link.id 
  LEFT JOIN s_core_translations translation6afe1f0963270s_articles_information_attributes ON translation6afe1f0963270s_articles_information_attributes.objecttype = : translation6afe1f0963270s_articles_information_attributes 
  AND translation6afe1f0963270s_articles_information_attributes.objectkey = link.id 
  AND translation6afe1f0963270s_articles_information_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0963274fallbacks_articles_information_attributes ON translation6afe1f0963274fallbacks_articles_information_attributes.objecttype = : translation6afe1f0963274fallbacks_articles_information_attributes 
  AND translation6afe1f0963274fallbacks_articles_information_attributes.objectkey = link.id 
  AND translation6afe1f0963274fallbacks_articles_information_attributes.objectlanguage = : languagefallback 
WHERE 
  link.articleID IN (: ids)
array:5 [
  ":ids" => array:1 [
    0 => 19
  ]
  ":language" => 3
  ":translation6afe1f0963270s_articles_information_attributes" => "s_articles_information_attributes"
  ":languagefallback" => 0
  ":translation6afe1f0963274fallbacks_articles_information_attributes" => "s_articles_information_attributes"
]
0.0003 ms
SELECT 
  variant.ordernumber as number, 
  media.id as __media_id, 
  media.albumID as __media_albumID, 
  media.name as __media_name, 
  media.description as __media_description, 
  media.path as __media_path, 
  media.type as __media_type, 
  media.extension as __media_extension, 
  media.file_size as __media_file_size, 
  media.width as __media_width, 
  media.height as __media_height, 
  media.userID as __media_userID, 
  media.created as __media_created, 
  mediaSettings.id as __mediaSettings_id, 
  mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, 
  mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, 
  mediaSettings.icon as __mediaSettings_icon, 
  mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, 
  mediaAttribute.id as __mediaAttribute_id, 
  mediaAttribute.mediaID as __mediaAttribute_mediaID, 
  image.id as __image_id, 
  image.articleID as __image_articleID, 
  image.img as __image_img, 
  image.main as __image_main, 
  image.description as __image_description, 
  image.position as __image_position, 
  image.width as __image_width, 
  image.height as __image_height, 
  image.extension as __image_extension, 
  image.parent_id as __image_parent_id, 
  image.media_id as __image_media_id, 
  imageAttribute.id as __imageAttribute_id, 
  imageAttribute.imageID as __imageAttribute_imageID, 
  imageAttribute.attribute1 as __imageAttribute_attribute1, 
  imageAttribute.attribute2 as __imageAttribute_attribute2, 
  imageAttribute.attribute3 as __imageAttribute_attribute3, 
  translation6afe1f0963405articleimage.objectdata as __image_translation, 
  translation6afe1f0963409fallbackarticleimage.objectdata as __image_translation_fallback, 
  translation6afe1f096340cs_media_attributes.objectdata as __mediaAttribute_translation, 
  translation6afe1f096340efallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 
FROM 
  s_articles_img image 
  INNER JOIN s_media media ON image.media_id = media.id 
  INNER JOIN s_articles_img childImage ON childImage.parent_id = image.id 
  INNER JOIN s_articles_details variant ON variant.id = childImage.article_detail_id 
  LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id 
  LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id 
  LEFT JOIN s_core_translations translation6afe1f0963405articleimage ON translation6afe1f0963405articleimage.objecttype = : translation6afe1f0963405articleimage 
  AND translation6afe1f0963405articleimage.objectkey = image.id 
  AND translation6afe1f0963405articleimage.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0963409fallbackarticleimage ON translation6afe1f0963409fallbackarticleimage.objecttype = : translation6afe1f0963409fallbackarticleimage 
  AND translation6afe1f0963409fallbackarticleimage.objectkey = image.id 
  AND translation6afe1f0963409fallbackarticleimage.objectlanguage = : languagefallback 
  INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID 
  LEFT JOIN s_core_translations translation6afe1f096340cs_media_attributes ON translation6afe1f096340cs_media_attributes.objecttype = : translation6afe1f096340cs_media_attributes 
  AND translation6afe1f096340cs_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f096340cs_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096340efallbacks_media_attributes ON translation6afe1f096340efallbacks_media_attributes.objecttype = : translation6afe1f096340efallbacks_media_attributes 
  AND translation6afe1f096340efallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f096340efallbacks_media_attributes.objectlanguage = : languagefallback 
WHERE 
  childImage.article_detail_id IN (: products) 
ORDER BY 
  image.main ASC, 
  image.position ASC
array:7 [
  ":language" => 3
  ":translation6afe1f0963405articleimage" => "articleimage"
  ":languagefallback" => 0
  ":translation6afe1f0963409fallbackarticleimage" => "articleimage"
  ":translation6afe1f096340cs_media_attributes" => "s_media_attributes"
  ":translation6afe1f096340efallbacks_media_attributes" => "s_media_attributes"
  ":products" => array:1 [
    0 => 48
  ]
]
0.0008 ms
SELECT 
  media.id as __media_id, 
  media.albumID as __media_albumID, 
  media.name as __media_name, 
  media.description as __media_description, 
  media.path as __media_path, 
  media.type as __media_type, 
  media.extension as __media_extension, 
  media.file_size as __media_file_size, 
  media.width as __media_width, 
  media.height as __media_height, 
  media.userID as __media_userID, 
  media.created as __media_created, 
  mediaSettings.id as __mediaSettings_id, 
  mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, 
  mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, 
  mediaSettings.icon as __mediaSettings_icon, 
  mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, 
  mediaAttribute.id as __mediaAttribute_id, 
  mediaAttribute.mediaID as __mediaAttribute_mediaID, 
  image.id as __image_id, 
  image.articleID as __image_articleID, 
  image.img as __image_img, 
  image.main as __image_main, 
  image.description as __image_description, 
  image.position as __image_position, 
  image.width as __image_width, 
  image.height as __image_height, 
  image.extension as __image_extension, 
  image.parent_id as __image_parent_id, 
  image.media_id as __image_media_id, 
  imageAttribute.id as __imageAttribute_id, 
  imageAttribute.imageID as __imageAttribute_imageID, 
  imageAttribute.attribute1 as __imageAttribute_attribute1, 
  imageAttribute.attribute2 as __imageAttribute_attribute2, 
  imageAttribute.attribute3 as __imageAttribute_attribute3, 
  translation6afe1f0963783articleimage.objectdata as __image_translation, 
  translation6afe1f0963787fallbackarticleimage.objectdata as __image_translation_fallback, 
  translation6afe1f096378as_media_attributes.objectdata as __mediaAttribute_translation, 
  translation6afe1f096378cfallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 
FROM 
  s_articles_img image 
  INNER JOIN s_media media ON image.media_id = media.id 
  LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id 
  LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id 
  LEFT JOIN s_articles_img childImage ON childImage.parent_id = image.id 
  LEFT JOIN s_core_translations translation6afe1f0963783articleimage ON translation6afe1f0963783articleimage.objecttype = : translation6afe1f0963783articleimage 
  AND translation6afe1f0963783articleimage.objectkey = image.id 
  AND translation6afe1f0963783articleimage.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0963787fallbackarticleimage ON translation6afe1f0963787fallbackarticleimage.objecttype = : translation6afe1f0963787fallbackarticleimage 
  AND translation6afe1f0963787fallbackarticleimage.objectkey = image.id 
  AND translation6afe1f0963787fallbackarticleimage.objectlanguage = : languagefallback 
  INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID 
  LEFT JOIN s_core_translations translation6afe1f096378as_media_attributes ON translation6afe1f096378as_media_attributes.objecttype = : translation6afe1f096378as_media_attributes 
  AND translation6afe1f096378as_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f096378as_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096378cfallbacks_media_attributes ON translation6afe1f096378cfallbacks_media_attributes.objecttype = : translation6afe1f096378cfallbacks_media_attributes 
  AND translation6afe1f096378cfallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f096378cfallbacks_media_attributes.objectlanguage = : languagefallback 
WHERE 
  (image.parent_id IS NULL) 
  AND (childImage.id IS NULL) 
  AND (
    image.articleID IN (: products)
  ) 
ORDER BY 
  image.main ASC, 
  image.position ASC
array:7 [
  ":language" => 3
  ":translation6afe1f0963783articleimage" => "articleimage"
  ":languagefallback" => 0
  ":translation6afe1f0963787fallbackarticleimage" => "articleimage"
  ":translation6afe1f096378as_media_attributes" => "s_media_attributes"
  ":translation6afe1f096378cfallbacks_media_attributes" => "s_media_attributes"
  ":products" => array:1 [
    0 => 19
  ]
]
0.0006 ms
SELECT 
  products.id as productId, 
  relations.position as __relations_position, 
  propertySet.id as __propertySet_id, 
  propertySet.name as __propertySet_name, 
  propertySet.position as __propertySet_position, 
  propertySet.comparable as __propertySet_comparable, 
  propertySet.sortmode as __propertySet_sortmode, 
  propertySetAttribute.id as __propertySetAttribute_id, 
  propertySetAttribute.filterID as __propertySetAttribute_filterID, 
  propertyGroup.id as __propertyGroup_id, 
  propertyGroup.name as __propertyGroup_name, 
  propertyGroup.filterable as __propertyGroup_filterable, 
  propertyGroupAttribute.id as __propertyGroupAttribute_id, 
  propertyGroupAttribute.optionID as __propertyGroupAttribute_optionID, 
  propertyOption.id as __propertyOption_id, 
  propertyOption.optionID as __propertyOption_optionID, 
  propertyOption.value as __propertyOption_value, 
  propertyOption.position as __propertyOption_position, 
  propertyOptionAttribute.id as __propertyOptionAttribute_id, 
  propertyOptionAttribute.valueID as __propertyOptionAttribute_valueID, 
  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, 
  translation6afe1f0963b5epropertygroup.objectdata as __propertySet_translation, 
  translation6afe1f0963b62fallbackpropertygroup.objectdata as __propertySet_translation_fallback, 
  translation6afe1f0963b65propertyoption.objectdata as __propertyGroup_translation, 
  translation6afe1f0963b66fallbackpropertyoption.objectdata as __propertyGroup_translation_fallback, 
  translation6afe1f0963b69propertyvalue.objectdata as __propertyOption_translation, 
  translation6afe1f0963b6afallbackpropertyvalue.objectdata as __propertyOption_translation_fallback, 
  translation6afe1f0963b6cs_media_attributes.objectdata as __mediaAttribute_translation, 
  translation6afe1f0963b6efallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 
FROM 
  s_filter_articles filterArticles 
  INNER JOIN s_articles products ON products.id = filterArticles.articleID 
  INNER JOIN s_filter_values propertyOption ON propertyOption.id = filterArticles.valueID 
  INNER JOIN s_filter propertySet ON propertySet.id = products.filtergroupID 
  INNER JOIN s_filter_relations relations ON relations.groupID = propertySet.id 
  LEFT JOIN s_filter_attributes propertySetAttribute ON propertySetAttribute.filterID = propertySet.id 
  LEFT JOIN s_core_translations translation6afe1f0963b5epropertygroup ON translation6afe1f0963b5epropertygroup.objecttype = : translation6afe1f0963b5epropertygroup 
  AND translation6afe1f0963b5epropertygroup.objectkey = propertySet.id 
  AND translation6afe1f0963b5epropertygroup.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0963b62fallbackpropertygroup ON translation6afe1f0963b62fallbackpropertygroup.objecttype = : translation6afe1f0963b62fallbackpropertygroup 
  AND translation6afe1f0963b62fallbackpropertygroup.objectkey = propertySet.id 
  AND translation6afe1f0963b62fallbackpropertygroup.objectlanguage = : languagefallback 
  INNER JOIN s_filter_options propertyGroup ON propertyGroup.id = propertyOption.optionID 
  AND relations.optionID = propertyGroup.id 
  LEFT JOIN s_media media ON propertyOption.media_id = media.id 
  LEFT JOIN s_filter_values_attributes propertyOptionAttribute ON propertyOptionAttribute.valueID = propertyOption.id 
  LEFT JOIN s_core_translations translation6afe1f0963b69propertyvalue ON translation6afe1f0963b69propertyvalue.objecttype = : translation6afe1f0963b69propertyvalue 
  AND translation6afe1f0963b69propertyvalue.objectkey = propertyOption.id 
  AND translation6afe1f0963b69propertyvalue.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0963b6afallbackpropertyvalue ON translation6afe1f0963b6afallbackpropertyvalue.objecttype = : translation6afe1f0963b6afallbackpropertyvalue 
  AND translation6afe1f0963b6afallbackpropertyvalue.objectkey = propertyOption.id 
  AND translation6afe1f0963b6afallbackpropertyvalue.objectlanguage = : languagefallback 
  LEFT JOIN s_filter_options_attributes propertyGroupAttribute ON propertyGroupAttribute.optionID = propertyGroup.id 
  LEFT JOIN s_core_translations translation6afe1f0963b65propertyoption ON translation6afe1f0963b65propertyoption.objecttype = : translation6afe1f0963b65propertyoption 
  AND translation6afe1f0963b65propertyoption.objectkey = propertyGroup.id 
  AND translation6afe1f0963b65propertyoption.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0963b66fallbackpropertyoption ON translation6afe1f0963b66fallbackpropertyoption.objecttype = : translation6afe1f0963b66fallbackpropertyoption 
  AND translation6afe1f0963b66fallbackpropertyoption.objectkey = propertyGroup.id 
  AND translation6afe1f0963b66fallbackpropertyoption.objectlanguage = : languagefallback 
  LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id 
  LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID 
  LEFT JOIN s_core_translations translation6afe1f0963b6cs_media_attributes ON translation6afe1f0963b6cs_media_attributes.objecttype = : translation6afe1f0963b6cs_media_attributes 
  AND translation6afe1f0963b6cs_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f0963b6cs_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0963b6efallbacks_media_attributes ON translation6afe1f0963b6efallbacks_media_attributes.objecttype = : translation6afe1f0963b6efallbacks_media_attributes 
  AND translation6afe1f0963b6efallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f0963b6efallbacks_media_attributes.objectlanguage = : languagefallback 
WHERE 
  products.id IN (: ids) 
ORDER BY 
  filterArticles.articleID ASC
array:11 [
  ":ids" => array:1 [
    0 => 19
  ]
  ":language" => 3
  ":translation6afe1f0963b5epropertygroup" => "propertygroup"
  ":languagefallback" => 0
  ":translation6afe1f0963b62fallbackpropertygroup" => "propertygroup"
  ":translation6afe1f0963b65propertyoption" => "propertyoption"
  ":translation6afe1f0963b66fallbackpropertyoption" => "propertyoption"
  ":translation6afe1f0963b69propertyvalue" => "propertyvalue"
  ":translation6afe1f0963b6afallbackpropertyvalue" => "propertyvalue"
  ":translation6afe1f0963b6cs_media_attributes" => "s_media_attributes"
  ":translation6afe1f0963b6efallbacks_media_attributes" => "s_media_attributes"
]
0.0010 ms
SELECT 
  variants.ordernumber as number, 
  configuratorGroup.id as __configuratorGroup_id, 
  configuratorGroup.name as __configuratorGroup_name, 
  configuratorGroup.description as __configuratorGroup_description, 
  configuratorGroup.position as __configuratorGroup_position, 
  configuratorGroupAttribute.id as __configuratorGroupAttribute_id, 
  configuratorGroupAttribute.groupID as __configuratorGroupAttribute_groupID, 
  configuratorOption.id as __configuratorOption_id, 
  configuratorOption.name as __configuratorOption_name, 
  configuratorOption.position as __configuratorOption_position, 
  configuratorOptionAttribute.id as __configuratorOptionAttribute_id, 
  configuratorOptionAttribute.optionID as __configuratorOptionAttribute_optionID, 
  translation6afe1f0964121configuratorgroup.objectdata as __configuratorGroup_translation, 
  translation6afe1f0964125fallbackconfiguratorgroup.objectdata as __configuratorGroup_translation_fallback, 
  translation6afe1f0964128configuratoroption.objectdata as __configuratorOption_translation, 
  translation6afe1f0964129fallbackconfiguratoroption.objectdata as __configuratorOption_translation_fallback 
FROM 
  s_article_configurator_option_relations relations 
  INNER JOIN s_articles_details variants ON variants.id = relations.article_id 
  INNER JOIN s_article_configurator_options configuratorOption ON configuratorOption.id = relations.option_id 
  INNER JOIN s_article_configurator_groups configuratorGroup ON configuratorGroup.id = configuratorOption.group_id 
  LEFT JOIN s_article_configurator_options_attributes configuratorOptionAttribute ON configuratorOptionAttribute.optionID = configuratorOption.id 
  LEFT JOIN s_core_translations translation6afe1f0964128configuratoroption ON translation6afe1f0964128configuratoroption.objecttype = : translation6afe1f0964128configuratoroption 
  AND translation6afe1f0964128configuratoroption.objectkey = configuratorOption.id 
  AND translation6afe1f0964128configuratoroption.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0964129fallbackconfiguratoroption ON translation6afe1f0964129fallbackconfiguratoroption.objecttype = : translation6afe1f0964129fallbackconfiguratoroption 
  AND translation6afe1f0964129fallbackconfiguratoroption.objectkey = configuratorOption.id 
  AND translation6afe1f0964129fallbackconfiguratoroption.objectlanguage = : languagefallback 
  LEFT JOIN s_article_configurator_groups_attributes configuratorGroupAttribute ON configuratorGroupAttribute.groupID = configuratorGroup.id 
  LEFT JOIN s_core_translations translation6afe1f0964121configuratorgroup ON translation6afe1f0964121configuratorgroup.objecttype = : translation6afe1f0964121configuratorgroup 
  AND translation6afe1f0964121configuratorgroup.objectkey = configuratorGroup.id 
  AND translation6afe1f0964121configuratorgroup.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f0964125fallbackconfiguratorgroup ON translation6afe1f0964125fallbackconfiguratorgroup.objecttype = : translation6afe1f0964125fallbackconfiguratorgroup 
  AND translation6afe1f0964125fallbackconfiguratorgroup.objectkey = configuratorGroup.id 
  AND translation6afe1f0964125fallbackconfiguratorgroup.objectlanguage = : languagefallback 
WHERE 
  relations.article_id IN (: ids) 
ORDER BY 
  configuratorGroup.position ASC, 
  configuratorGroup.id ASC
array:7 [
  ":ids" => array:1 [
    0 => 48
  ]
  ":language" => 3
  ":translation6afe1f0964121configuratorgroup" => "configuratorgroup"
  ":languagefallback" => 0
  ":translation6afe1f0964125fallbackconfiguratorgroup" => "configuratorgroup"
  ":translation6afe1f0964128configuratoroption" => "configuratoroption"
  ":translation6afe1f0964129fallbackconfiguratoroption" => "configuratoroption"
]
0.0006 ms
SELECT 
  org_path, 
  path 
FROM 
  s_core_rewrite_urls 
WHERE 
  subshopID =: shopId 
  AND org_path IN (: orgPath) 
  AND main = 1 
ORDER BY 
  id DESC
array:2 [
  ":shopId" => 3
  ":orgPath" => array:1 [
    0 => "sViewport=detail&sArticle=19"
  ]
]
0.0002 ms
SELECT 
  org_path, 
  path 
FROM 
  s_core_rewrite_urls 
WHERE 
  subshopID =: shopId 
  AND org_path IN (: orgPath) 
  AND main = 1 
ORDER BY 
  id DESC
array:2 [
  ":shopId" => 3
  ":orgPath" => array:1 [
    0 => "sViewport=forms&sFid=16"
  ]
]
0.0001 ms
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
]
0.0001 ms
SELECT 
  `objectdata` 
FROM 
  `s_core_translations` 
WHERE 
  (`objecttype` = : type) 
  AND (`objectkey` = : key) 
  AND (`objectlanguage` = : language)
array:3 [
  ":type" => "category"
  ":key" => 3
  ":language" => 3
]
0.0001 ms
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 => 9
]
0.0002 ms
SELECT 
  `objectdata` 
FROM 
  `s_core_translations` 
WHERE 
  (`objecttype` = : type) 
  AND (`objectkey` = : key) 
  AND (`objectlanguage` = : language)
array:3 [
  ":type" => "category"
  ":key" => 9
  ":language" => 3
]
0.0001 ms
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 => 16
]
0.0001 ms
SELECT 
  `objectdata` 
FROM 
  `s_core_translations` 
WHERE 
  (`objecttype` = : type) 
  AND (`objectkey` = : key) 
  AND (`objectlanguage` = : language)
array:3 [
  ":type" => "category"
  ":key" => 16
  ":language" => 3
]
0.0000 ms
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 => 42
]
0.0001 ms
SELECT 
  `objectdata` 
FROM 
  `s_core_translations` 
WHERE 
  (`objecttype` = : type) 
  AND (`objectkey` = : key) 
  AND (`objectlanguage` = : language)
array:3 [
  ":type" => "category"
  ":key" => 42
  ":language" => 3
]
0.0000 ms
SELECT 
  category.path 
FROM 
  s_categories category 
WHERE 
  category.id = : id
array:1 [
  ":id" => 42
]
0.0001 ms
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
[]
0.0001 ms
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
[]
0.0001 ms
SELECT 
  element.template_id, 
  element.name, 
  element_value.value, 
  element.default_value as defaultValue, 
  element.type 
FROM 
  s_core_templates_config_elements element 
  LEFT JOIN s_core_templates_config_values element_value ON element_value.element_id = element.id 
  AND element_value.shop_id = : shopId 
WHERE 
  element.template_id IN (: ids)
array:2 [
  ":shopId" => 1
  ":ids" => array:3 [
    0 => 24
    1 => 23
    2 => 22
  ]
]
0.0001 ms
SELECT 
  category.path 
FROM 
  s_categories category 
WHERE 
  category.id = : id
array:1 [
  ":id" => 42
]
0.0001 ms
SELECT 
  category.id, 
  category.parent 
FROM 
  s_categories category 
WHERE 
  (
    (
      category.parent IN(: parentId) 
      OR category.id IN (: parentId)
    )
  ) 
  AND (category.active = 1) 
  AND (
    category.shops IS NULL 
    OR category.shops LIKE : shopId
  ) 
ORDER BY 
  category.position ASC, 
  category.id ASC
array:2 [
  ":parentId" => array:4 [
    0 => 42
    2 => "16"
    3 => "9"
    4 => "3"
  ]
  ":shopId" => "%|3|%"
]
0.0003 ms
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, 
  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, 
  translation6afe1f0967697s_categories_attributes.objectdata as __categoryAttribute_translation, 
  translation6afe1f096769bfallbacks_categories_attributes.objectdata as __categoryAttribute_translation_fallback, 
  translation6afe1f096769ds_media_attributes.objectdata as __mediaAttribute_translation, 
  translation6afe1f096769ffallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback, 
  translation6afe1f09676a1productStream.objectdata as __stream_translation, 
  translation6afe1f09676a3fallbackproductStream.objectdata as __stream_translation_fallback, 
  translation6afe1f09676a5category.objectdata as __category_translation, 
  translation6afe1f09676a7fallbackcategory.objectdata as __category_translation_fallback 
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_core_translations translation6afe1f09676a5category ON translation6afe1f09676a5category.objecttype = : translation6afe1f09676a5category 
  AND translation6afe1f09676a5category.objectkey = category.id 
  AND translation6afe1f09676a5category.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f09676a7fallbackcategory ON translation6afe1f09676a7fallbackcategory.objecttype = : translation6afe1f09676a7fallbackcategory 
  AND translation6afe1f09676a7fallbackcategory.objectkey = category.id 
  AND translation6afe1f09676a7fallbackcategory.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f0967697s_categories_attributes ON translation6afe1f0967697s_categories_attributes.objecttype = : translation6afe1f0967697s_categories_attributes 
  AND translation6afe1f0967697s_categories_attributes.objectkey = category.id 
  AND translation6afe1f0967697s_categories_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096769bfallbacks_categories_attributes ON translation6afe1f096769bfallbacks_categories_attributes.objecttype = : translation6afe1f096769bfallbacks_categories_attributes 
  AND translation6afe1f096769bfallbacks_categories_attributes.objectkey = category.id 
  AND translation6afe1f096769bfallbacks_categories_attributes.objectlanguage = : languagefallback 
  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_core_translations translation6afe1f096769ds_media_attributes ON translation6afe1f096769ds_media_attributes.objecttype = : translation6afe1f096769ds_media_attributes 
  AND translation6afe1f096769ds_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f096769ds_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096769ffallbacks_media_attributes ON translation6afe1f096769ffallbacks_media_attributes.objecttype = : translation6afe1f096769ffallbacks_media_attributes 
  AND translation6afe1f096769ffallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f096769ffallbacks_media_attributes.objectlanguage = : languagefallback 
  LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId 
  LEFT JOIN s_core_translations translation6afe1f09676a1productStream ON translation6afe1f09676a1productStream.objecttype = : translation6afe1f09676a1productStream 
  AND translation6afe1f09676a1productStream.objectkey = stream.id 
  AND translation6afe1f09676a1productStream.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f09676a3fallbackproductStream ON translation6afe1f09676a3fallbackproductStream.objecttype = : translation6afe1f09676a3fallbackproductStream 
  AND translation6afe1f09676a3fallbackproductStream.objectkey = stream.id 
  AND translation6afe1f09676a3fallbackproductStream.objectlanguage = : languagefallback 
WHERE 
  (
    category.id IN (: categories)
  ) 
  AND (category.active = 1) 
  AND (
    category.shops IS NULL 
    OR category.shops LIKE : shopId
  ) 
GROUP BY 
  category.id
array:12 [
  ":categories" => array:21 [
    0 => 42
    1 => "16"
    2 => "9"
    3 => "3"
    4 => 15
    5 => 16
    6 => 17
    7 => 40
    8 => 41
    9 => 42
    10 => 43
    11 => 44
    12 => 3
    13 => 5
    14 => 7
    15 => 8
    16 => 9
    17 => 10
    18 => 11
    19 => 81
    20 => 12
  ]
  ":shopId" => "%|3|%"
  ":language" => 3
  ":translation6afe1f0967697s_categories_attributes" => "s_categories_attributes"
  ":languagefallback" => 0
  ":translation6afe1f096769bfallbacks_categories_attributes" => "s_categories_attributes"
  ":translation6afe1f096769ds_media_attributes" => "s_media_attributes"
  ":translation6afe1f096769ffallbacks_media_attributes" => "s_media_attributes"
  ":translation6afe1f09676a1productStream" => "productStream"
  ":translation6afe1f09676a3fallbackproductStream" => "productStream"
  ":translation6afe1f09676a5category" => "category"
  ":translation6afe1f09676a7fallbackcategory" => "category"
]
0.0012 ms
SELECT 
  parent as id, 
  COUNT(id) as childrenCount 
FROM 
  s_categories category 
WHERE 
  (
    parent IN (: ids)
  ) 
  AND (category.active = 1) 
GROUP BY 
  parent
array:1 [
  ":ids" => array:21 [
    0 => 42
    1 => "16"
    2 => "9"
    3 => "3"
    4 => 15
    5 => 16
    6 => 17
    7 => 40
    8 => 41
    9 => 42
    10 => 43
    11 => 44
    12 => 3
    13 => 5
    14 => 7
    15 => 8
    16 => 9
    17 => 10
    18 => 11
    19 => 81
    20 => 12
  ]
]
0.0003 ms
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, 
  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 => 3
  ]
]
0.0002 ms
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, 
  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"
  ]
]
0.0002 ms
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"
  ]
]
0.0001 ms
SELECT 
  tax.id as __tax_id, 
  tax.tax as __tax_tax, 
  tax.description as __tax_description 
FROM 
  s_core_tax tax
[]
0.0001 ms
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
array:5 [
  ":area" => null
  ":country" => null
  ":state" => null
  ":customerGroup" => 1
  ":taxId" => "1"
]
0.0001 ms
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
array:5 [
  ":area" => null
  ":country" => null
  ":state" => null
  ":customerGroup" => 1
  ":taxId" => "4"
]
0.0001 ms
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
]
0.0000 ms
SELECT 
  page.id, 
  page.description, 
  page.link, 
  page.target, 
  page.parentID, 
  groups.key as `group`, 
  mapping.key as mapping, 
  translation6afe1f09682c8page.objectdata as __page_translation, 
  translation6afe1f09682ccfallbackpage.objectdata as __page_translation_fallback 
FROM 
  s_cms_static page 
  LEFT JOIN s_cms_static_groups `groups` ON groups.active = 1 
  LEFT JOIN s_core_translations translation6afe1f09682c8page ON translation6afe1f09682c8page.objecttype = : translation6afe1f09682c8page 
  AND translation6afe1f09682c8page.objectkey = page.id 
  AND translation6afe1f09682c8page.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f09682ccfallbackpage ON translation6afe1f09682ccfallbackpage.objecttype = : translation6afe1f09682ccfallbackpage 
  AND translation6afe1f09682ccfallbackpage.objectkey = page.id 
  AND translation6afe1f09682ccfallbackpage.objectlanguage = : languagefallback 
  LEFT JOIN s_cms_static_groups mapping ON groups.mapping_id = mapping.id 
  LEFT JOIN s_core_shop_pages shops ON groups.id = shops.group_id 
  AND shops.shop_id = : shopId 
WHERE 
  (groups.active = 1) 
  AND (page.active = 1) 
  AND (
    CONCAT('|', page.grouping, '|') LIKE CONCAT('%|', groups.key, '|%')
  ) 
  AND (
    (
      mapping.id IS NULL 
      OR shops.shop_id IS NOT NULL
    )
  ) 
  AND (
    (
      mapping.id IS NULL 
      OR mapping.active = 1
    )
  ) 
  AND (
    (
      page.shop_ids IS NULL 
      OR page.shop_ids LIKE : staticShopId
    )
  ) 
ORDER BY 
  parentID ASC, 
  mapping.key ASC, 
  page.position ASC, 
  page.description ASC
array:6 [
  ":language" => 3
  ":translation6afe1f09682c8page" => "page"
  ":languagefallback" => 0
  ":translation6afe1f09682ccfallbackpage" => "page"
  ":shopId" => 3
  ":staticShopId" => "%|3|%"
]
0.0006 ms
SELECT 
  org_path, 
  path 
FROM 
  s_core_rewrite_urls 
WHERE 
  subshopID =: shopId 
  AND org_path IN (: orgPath) 
  AND main = 1 
ORDER BY 
  id DESC
array:2 [
  ":shopId" => 3
  ":orgPath" => array:13 [
    39 => "sViewport=forms&sFid=9"
    21 => "sViewport=registerFC"
    26 => "sViewport=newsletter"
    37 => "sViewport=forms&sFid=8"
    43 => "sViewport=custom&sCustom=43"
    9 => "sViewport=custom&sCustom=9"
    2 => "sViewport=custom&sCustom=2"
    1 => "sViewport=forms&sFid=5"
    6 => "sViewport=custom&sCustom=6"
    41 => "sViewport=forms&sFid=10"
    8 => "sViewport=custom&sCustom=8"
    45 => "sViewport=custom&sCustom=45"
    4 => "sViewport=custom&sCustom=4"
  ]
]
0.0001 ms
SELECT 
  org_path, 
  path 
FROM 
  s_core_rewrite_urls 
WHERE 
  subshopID =: shopId 
  AND org_path IN (: orgPath) 
  AND main = 1 
ORDER BY 
  id DESC
array:2 [
  ":shopId" => 3
  ":orgPath" => array:1 [
    0 => "sViewport=detail&sArticle=19"
  ]
]
0.0001 ms
SELECT 
  org_path, 
  path 
FROM 
  s_core_rewrite_urls 
WHERE 
  subshopID =: shopId 
  AND org_path IN (: orgPath) 
  AND main = 1 
ORDER BY 
  id DESC
array:2 [
  ":shopId" => 3
  ":orgPath" => array:1 [
    0 => "sViewport=detail&sArticle=19"
  ]
]
0.0001 ms
SELECT 
  org_path, 
  path 
FROM 
  s_core_rewrite_urls 
WHERE 
  subshopID =: shopId 
  AND org_path IN (: orgPath) 
  AND main = 1 
ORDER BY 
  id DESC
array:2 [
  ":shopId" => 3
  ":orgPath" => array:1 [
    0 => "sViewport=detail&sArticle=19"
  ]
]
0.0001 ms
SELECT 
  s_core_config_values.value 
FROM 
  s_core_config_values 
  INNER JOIN s_core_config_elements ON s_core_config_values.element_id = s_core_config_elements.id 
  AND s_core_config_elements.`name` LIKE 'assetTimestamp' 
WHERE 
  s_core_config_values.shop_id = : shopId
array:1 [
  "shopId" => 1
]
0.0001 ms
SELECT 
  s0_.id AS id_0, 
  s0_.compiler_force AS compiler_force_1, 
  s0_.compiler_create_source_map AS compiler_create_source_map_2, 
  s0_.compiler_compress_css AS compiler_compress_css_3, 
  s0_.compiler_compress_js AS compiler_compress_js_4, 
  s0_.force_reload_snippets AS force_reload_snippets_5 
FROM 
  s_core_theme_settings s0_ 
ORDER BY 
  s0_.id ASC 
LIMIT 
  1
[]
0.0001 ms
SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.label AS label_3, 
  t0.namespace AS namespace_4, 
  t0.source AS source_5, 
  t0.description AS description_6, 
  t0.active AS active_7, 
  t0.added AS added_8, 
  t0.installation_date AS installation_date_9, 
  t0.update_date AS update_date_10, 
  t0.refresh_date AS refresh_date_11, 
  t0.author AS author_12, 
  t0.copyright AS copyright_13, 
  t0.license AS license_14, 
  t0.version AS version_15, 
  t0.support AS support_16, 
  t0.changes AS changes_17, 
  t0.link AS link_18, 
  t0.update_version AS update_version_19, 
  t0.update_source AS update_source_20, 
  t0.capability_update AS capability_update_21, 
  t0.capability_install AS capability_install_22, 
  t0.capability_enable AS capability_enable_23, 
  t0.capability_secure_uninstall AS capability_secure_uninstall_24, 
  t0.translations AS translations_25, 
  t0.in_safe_mode AS in_safe_mode_26 
FROM 
  s_core_plugins t0 
WHERE 
  t0.id = ? 
LIMIT 
  1
array:1 [
  0 => "52"
]
0.0001 ms
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
[]
0.0001 ms
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
[]
0.0001 ms
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
[]
0.0001 ms
SELECT 
  org_path, 
  path 
FROM 
  s_core_rewrite_urls 
WHERE 
  subshopID =: shopId 
  AND org_path IN (: orgPath) 
  AND main = 1 
ORDER BY 
  id DESC
array:2 [
  ":shopId" => 3
  ":orgPath" => array:1 [
    0 => "sViewport=address&sAction=index"
  ]
]
0.0001 ms
SELECT 
  host, 
  hosts 
FROM 
  s_core_shops 
WHERE 
  id = : id
array:1 [
  ":id" => 1
]
0.0001 ms
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
[]
0.0001 ms
SELECT 
  org_path, 
  path 
FROM 
  s_core_rewrite_urls 
WHERE 
  subshopID =: shopId 
  AND org_path IN (: orgPath) 
  AND main = 1 
ORDER BY 
  id DESC
array:2 [
  ":shopId" => 3
  ":orgPath" => array:1 [
    0 => "sViewport=listing&sAction=manufacturer&sSupplier=2"
  ]
]
0.0001 ms
SELECT 
  org_path, 
  path 
FROM 
  s_core_rewrite_urls 
WHERE 
  subshopID =: shopId 
  AND org_path IN (: orgPath) 
  AND main = 1 
ORDER BY 
  id DESC
array:2 [
  ":shopId" => 3
  ":orgPath" => array:1 [
    0 => "sViewport=detail&sArticle=19"
  ]
]
0.0001 ms
SELECT 
  org_path, 
  path 
FROM 
  s_core_rewrite_urls 
WHERE 
  subshopID =: shopId 
  AND org_path IN (: orgPath) 
  AND main = 1 
ORDER BY 
  id DESC
array:2 [
  ":shopId" => 3
  ":orgPath" => array:1 [
    0 => "sViewport=compare&sAction=add_article"
  ]
]
0.0001 ms
SELECT 
  org_path, 
  path 
FROM 
  s_core_rewrite_urls 
WHERE 
  subshopID =: shopId 
  AND org_path IN (: orgPath) 
  AND main = 1 
ORDER BY 
  id DESC
array:2 [
  ":shopId" => 3
  ":orgPath" => array:1 [
    0 => "sViewport=note&sAction=add"
  ]
]
0.0001 ms
SELECT 
  org_path, 
  path 
FROM 
  s_core_rewrite_urls 
WHERE 
  subshopID =: shopId 
  AND org_path IN (: orgPath) 
  AND main = 1 
ORDER BY 
  id DESC
array:2 [
  ":shopId" => 3
  ":orgPath" => array:1 [
    0 => "sViewport=note&sAction=ajaxAdd"
  ]
]
0.0001 ms
SELECT 
  org_path, 
  path 
FROM 
  s_core_rewrite_urls 
WHERE 
  subshopID =: shopId 
  AND org_path IN (: orgPath) 
  AND main = 1 
ORDER BY 
  id DESC
array:2 [
  ":shopId" => 3
  ":orgPath" => array:1 [
    0 => "sViewport=listing&sAction=manufacturer&sSupplier=2"
  ]
]
0.0001 ms
SELECT 
  org_path, 
  path 
FROM 
  s_core_rewrite_urls 
WHERE 
  subshopID =: shopId 
  AND org_path IN (: orgPath) 
  AND main = 1 
ORDER BY 
  id DESC
array:2 [
  ":shopId" => 3
  ":orgPath" => array:1 [
    0 => "sViewport=detail&sArticle=19"
  ]
]
0.0001 ms
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
[]
0.0001 ms
SELECT 
  product.id as __product_id, 
  product.supplierID as __product_supplierID, 
  product.name as __product_name, 
  product.description as __product_description, 
  product.description_long as __product_description_long, 
  product.shippingtime as __product_shippingtime, 
  product.datum as __product_datum, 
  product.active as __product_active, 
  product.taxID as __product_taxID, 
  product.pseudosales as __product_pseudosales, 
  product.topseller as __product_topseller, 
  product.metaTitle as __product_metaTitle, 
  product.keywords as __product_keywords, 
  product.changetime as __product_changetime, 
  product.pricegroupID as __product_pricegroupID, 
  product.pricegroupActive as __product_pricegroupActive, 
  product.filtergroupID as __product_filtergroupID, 
  product.crossbundlelook as __product_crossbundlelook, 
  product.notification as __product_notification, 
  product.template as __product_template, 
  product.mode as __product_mode, 
  product.main_detail_id as __product_main_detail_id, 
  product.available_from as __product_available_from, 
  product.available_to as __product_available_to, 
  product.configurator_set_id as __product_configurator_set_id, 
  productAttribute.id as __productAttribute_id, 
  productAttribute.articledetailsID as __productAttribute_articledetailsID, 
  productAttribute.attr1 as __productAttribute_attr1, 
  productAttribute.attr2 as __productAttribute_attr2, 
  productAttribute.attr3 as __productAttribute_attr3, 
  productAttribute.attr4 as __productAttribute_attr4, 
  productAttribute.attr5 as __productAttribute_attr5, 
  productAttribute.attr6 as __productAttribute_attr6, 
  productAttribute.attr7 as __productAttribute_attr7, 
  productAttribute.attr8 as __productAttribute_attr8, 
  productAttribute.attr9 as __productAttribute_attr9, 
  productAttribute.attr10 as __productAttribute_attr10, 
  productAttribute.attr11 as __productAttribute_attr11, 
  productAttribute.attr12 as __productAttribute_attr12, 
  productAttribute.attr13 as __productAttribute_attr13, 
  productAttribute.attr14 as __productAttribute_attr14, 
  productAttribute.attr15 as __productAttribute_attr15, 
  productAttribute.attr16 as __productAttribute_attr16, 
  productAttribute.attr17 as __productAttribute_attr17, 
  productAttribute.attr18 as __productAttribute_attr18, 
  productAttribute.attr19 as __productAttribute_attr19, 
  productAttribute.attr20 as __productAttribute_attr20, 
  topSeller.sales as __topSeller_sales, 
  variant.id as __variant_id, 
  variant.ordernumber as __variant_ordernumber, 
  variant.suppliernumber as __variant_suppliernumber, 
  variant.kind as __variant_kind, 
  variant.additionaltext as __variant_additionaltext, 
  variant.sales as __variant_sales, 
  variant.active as __variant_active, 
  variant.instock as __variant_instock, 
  variant.stockmin as __variant_stockmin, 
  variant.weight as __variant_weight, 
  variant.position as __variant_position, 
  variant.width as __variant_width, 
  variant.height as __variant_height, 
  variant.length as __variant_length, 
  variant.ean as __variant_ean, 
  variant.unitID as __variant_unitID, 
  variant.releasedate as __variant_releasedate, 
  variant.shippingfree as __variant_shippingfree, 
  variant.shippingtime as __variant_shippingtime, 
  variant.laststock as __product_laststock, 
  unit.id as __unit_id, 
  unit.description as __unit_description, 
  unit.unit as __unit_unit, 
  variant.packunit as __unit_packunit, 
  variant.purchaseunit as __unit_purchaseunit, 
  variant.referenceunit as __unit_referenceunit, 
  variant.purchasesteps as __unit_purchasesteps, 
  variant.minpurchase as __unit_minpurchase, 
  variant.maxpurchase as __unit_maxpurchase, 
  tax.id as __tax_id, 
  tax.tax as __tax_tax, 
  tax.description as __tax_description, 
  priceGroup.id as __priceGroup_id, 
  priceGroup.description as __priceGroup_description, 
  manufacturer.id as __manufacturer_id, 
  manufacturer.name as __manufacturer_name, 
  manufacturer.img as __manufacturer_img, 
  manufacturer.link as __manufacturer_link, 
  manufacturer.description as __manufacturer_description, 
  manufacturer.meta_title as __manufacturer_meta_title, 
  manufacturer.meta_description as __manufacturer_meta_description, 
  manufacturer.meta_keywords as __manufacturer_meta_keywords, 
  manufacturerAttribute.id as __manufacturerAttribute_id, 
  manufacturerAttribute.supplierID as __manufacturerAttribute_supplierID, 
  esd.id as __esd_id, 
  esd.articleID as __esd_articleID, 
  esd.articledetailsID as __esd_articledetailsID, 
  esd.file as __esd_file, 
  esd.serials as __esd_serials, 
  esd.notification as __esd_notification, 
  esd.maxdownloads as __esd_maxdownloads, 
  esd.datum as __esd_datum, 
  esdAttribute.id as __esdAttribute_id, 
  esdAttribute.esdID as __esdAttribute_esdID, 
  (
    SELECT 
      1 
    FROM 
      s_articles_esd variantEsd 
    WHERE 
      variantEsd.articleID = product.id 
    LIMIT 
      1
  ) as __product_has_esd, 
  (
    SELECT 
      GROUP_CONCAT(
        customerGroups.customergroupId SEPARATOR '|'
      ) 
    FROM 
      s_articles_avoid_customergroups customerGroups 
    WHERE 
      customerGroups.articleID = product.id
  ) as __product_blocked_customer_groups, 
  (
    SELECT 
      COUNT(availableVariant.id) 
    FROM 
      s_articles_details availableVariant 
    WHERE 
      (
        availableVariant.articleID = product.id
      ) 
      AND (availableVariant.active = 1) 
      AND (
        (
          availableVariant.laststock * availableVariant.instock
        ) >= (
          availableVariant.laststock * availableVariant.minpurchase
        )
      )
  ) as __product_has_available_variants, 
  (
    SELECT 
      COUNT(
        DISTINCT ROUND(prices.price, 2)
      ) as priceCount 
    FROM 
      s_articles_prices prices 
      INNER JOIN s_articles_details priceVariant ON priceVariant.id = prices.articledetailsID 
      and priceVariant.active = 1 
    WHERE 
      (prices.from = 1) 
      AND (prices.pricegroup = : fallback) 
      AND (prices.articleID = product.id)
  ) as __product_fallback_price_count, 
  manufacturerMedia.id as __manufacturer_img_id, 
  translation6afe1f096dbf2article.objectdata as __product_translation, 
  translation6afe1f096dbf6fallbackarticle.objectdata as __product_translation_fallback, 
  translation6afe1f096dbf8variant.objectdata as __variant_translation, 
  translation6afe1f096dbfafallbackvariant.objectdata as __variant_translation_fallback, 
  translation6afe1f096dbfcsupplier.objectdata as __manufacturer_translation, 
  translation6afe1f096dbfefallbacksupplier.objectdata as __manufacturer_translation_fallback, 
  translation6afe1f096dc00config_units.objectdata as __unit_translation, 
  translation6afe1f096dc01fallbackconfig_units.objectdata as __unit_translation_fallback, 
  translation6afe1f096dc04s_articles_esd_attributes.objectdata as __esdAttribute_translation, 
  translation6afe1f096dc05fallbacks_articles_esd_attributes.objectdata as __esdAttribute_translation_fallback 
FROM 
  s_articles_details variant 
  INNER JOIN s_articles product ON product.id = variant.articleID 
  LEFT JOIN s_core_units unit ON unit.id = variant.unitID 
  LEFT JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id 
  LEFT JOIN s_articles_esd esd ON esd.articledetailsID = variant.id 
  LEFT JOIN s_core_translations translation6afe1f096dbf8variant ON translation6afe1f096dbf8variant.objecttype = : translation6afe1f096dbf8variant 
  AND translation6afe1f096dbf8variant.objectkey = variant.id 
  AND translation6afe1f096dbf8variant.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096dbfafallbackvariant ON translation6afe1f096dbfafallbackvariant.objecttype = : translation6afe1f096dbfafallbackvariant 
  AND translation6afe1f096dbfafallbackvariant.objectkey = variant.id 
  AND translation6afe1f096dbfafallbackvariant.objectlanguage = : languagefallback 
  INNER JOIN s_core_tax tax ON tax.id = product.taxID 
  LEFT JOIN s_articles_supplier manufacturer ON manufacturer.id = product.supplierID 
  LEFT JOIN s_core_pricegroups priceGroup ON priceGroup.id = product.pricegroupID 
  LEFT JOIN s_articles_supplier_attributes manufacturerAttribute ON manufacturerAttribute.supplierID = product.supplierID 
  LEFT JOIN s_articles_top_seller_ro topSeller ON topSeller.article_id = product.id 
  LEFT JOIN s_core_translations translation6afe1f096dbf2article ON translation6afe1f096dbf2article.objecttype = : translation6afe1f096dbf2article 
  AND translation6afe1f096dbf2article.objectkey = product.id 
  AND translation6afe1f096dbf2article.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096dbf6fallbackarticle ON translation6afe1f096dbf6fallbackarticle.objecttype = : translation6afe1f096dbf6fallbackarticle 
  AND translation6afe1f096dbf6fallbackarticle.objectkey = product.id 
  AND translation6afe1f096dbf6fallbackarticle.objectlanguage = : languagefallback 
  LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img 
  LEFT JOIN s_core_translations translation6afe1f096dbfcsupplier ON translation6afe1f096dbfcsupplier.objecttype = : translation6afe1f096dbfcsupplier 
  AND translation6afe1f096dbfcsupplier.objectkey = manufacturer.id 
  AND translation6afe1f096dbfcsupplier.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096dbfefallbacksupplier ON translation6afe1f096dbfefallbacksupplier.objecttype = : translation6afe1f096dbfefallbacksupplier 
  AND translation6afe1f096dbfefallbacksupplier.objectkey = manufacturer.id 
  AND translation6afe1f096dbfefallbacksupplier.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f096dc00config_units ON translation6afe1f096dc00config_units.objecttype = : translation6afe1f096dc00config_units 
  AND translation6afe1f096dc00config_units.objectkey = 1 
  AND translation6afe1f096dc00config_units.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096dc01fallbackconfig_units ON translation6afe1f096dc01fallbackconfig_units.objecttype = : translation6afe1f096dc01fallbackconfig_units 
  AND translation6afe1f096dc01fallbackconfig_units.objectkey = 1 
  AND translation6afe1f096dc01fallbackconfig_units.objectlanguage = : languagefallback 
  LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id 
  LEFT JOIN s_core_translations translation6afe1f096dc04s_articles_esd_attributes ON translation6afe1f096dc04s_articles_esd_attributes.objecttype = : translation6afe1f096dc04s_articles_esd_attributes 
  AND translation6afe1f096dc04s_articles_esd_attributes.objectkey = esd.id 
  AND translation6afe1f096dc04s_articles_esd_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096dc05fallbacks_articles_esd_attributes ON translation6afe1f096dc05fallbacks_articles_esd_attributes.objecttype = : translation6afe1f096dc05fallbacks_articles_esd_attributes 
  AND translation6afe1f096dc05fallbacks_articles_esd_attributes.objectkey = esd.id 
  AND translation6afe1f096dc05fallbacks_articles_esd_attributes.objectlanguage = : languagefallback 
WHERE 
  (
    variant.ordernumber IN (: numbers)
  ) 
  AND (variant.active = 1) 
  AND (product.active = 1)
array:14 [
  ":fallback" => "EK"
  ":numbers" => array:8 [
    0 => 10020
    1 => 10021
    2 => 10018
    3 => 10016
    4 => 10015
    5 => 10014
    6 => 10013
    7 => 10002
  ]
  ":language" => 3
  ":translation6afe1f096dbf2article" => "article"
  ":languagefallback" => 0
  ":translation6afe1f096dbf6fallbackarticle" => "article"
  ":translation6afe1f096dbf8variant" => "variant"
  ":translation6afe1f096dbfafallbackvariant" => "variant"
  ":translation6afe1f096dbfcsupplier" => "supplier"
  ":translation6afe1f096dbfefallbacksupplier" => "supplier"
  ":translation6afe1f096dc00config_units" => "config_units"
  ":translation6afe1f096dc01fallbackconfig_units" => "config_units"
  ":translation6afe1f096dc04s_articles_esd_attributes" => "s_articles_esd_attributes"
  ":translation6afe1f096dc05fallbacks_articles_esd_attributes" => "s_articles_esd_attributes"
]
0.0021 ms
SELECT 
  variant.ordernumber as number, 
  media.id as __media_id, 
  media.albumID as __media_albumID, 
  media.name as __media_name, 
  media.description as __media_description, 
  media.path as __media_path, 
  media.type as __media_type, 
  media.extension as __media_extension, 
  media.file_size as __media_file_size, 
  media.width as __media_width, 
  media.height as __media_height, 
  media.userID as __media_userID, 
  media.created as __media_created, 
  mediaSettings.id as __mediaSettings_id, 
  mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, 
  mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, 
  mediaSettings.icon as __mediaSettings_icon, 
  mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, 
  mediaAttribute.id as __mediaAttribute_id, 
  mediaAttribute.mediaID as __mediaAttribute_mediaID, 
  image.id as __image_id, 
  image.articleID as __image_articleID, 
  image.img as __image_img, 
  image.main as __image_main, 
  image.description as __image_description, 
  image.position as __image_position, 
  image.width as __image_width, 
  image.height as __image_height, 
  image.extension as __image_extension, 
  image.parent_id as __image_parent_id, 
  image.media_id as __image_media_id, 
  imageAttribute.id as __imageAttribute_id, 
  imageAttribute.imageID as __imageAttribute_imageID, 
  imageAttribute.attribute1 as __imageAttribute_attribute1, 
  imageAttribute.attribute2 as __imageAttribute_attribute2, 
  imageAttribute.attribute3 as __imageAttribute_attribute3, 
  translation6afe1f096e5caarticleimage.objectdata as __image_translation, 
  translation6afe1f096e5cefallbackarticleimage.objectdata as __image_translation_fallback, 
  translation6afe1f096e5d1s_media_attributes.objectdata as __mediaAttribute_translation, 
  translation6afe1f096e5d3fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 
FROM 
  s_articles_img image 
  INNER JOIN s_media media ON image.media_id = media.id 
  INNER JOIN s_articles_img childImage ON childImage.parent_id = image.id 
  INNER JOIN s_articles_details variant ON variant.id = childImage.article_detail_id 
  LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id 
  LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id 
  LEFT JOIN s_core_translations translation6afe1f096e5caarticleimage ON translation6afe1f096e5caarticleimage.objecttype = : translation6afe1f096e5caarticleimage 
  AND translation6afe1f096e5caarticleimage.objectkey = image.id 
  AND translation6afe1f096e5caarticleimage.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096e5cefallbackarticleimage ON translation6afe1f096e5cefallbackarticleimage.objecttype = : translation6afe1f096e5cefallbackarticleimage 
  AND translation6afe1f096e5cefallbackarticleimage.objectkey = image.id 
  AND translation6afe1f096e5cefallbackarticleimage.objectlanguage = : languagefallback 
  INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID 
  LEFT JOIN s_core_translations translation6afe1f096e5d1s_media_attributes ON translation6afe1f096e5d1s_media_attributes.objecttype = : translation6afe1f096e5d1s_media_attributes 
  AND translation6afe1f096e5d1s_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f096e5d1s_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096e5d3fallbacks_media_attributes ON translation6afe1f096e5d3fallbacks_media_attributes.objecttype = : translation6afe1f096e5d3fallbacks_media_attributes 
  AND translation6afe1f096e5d3fallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f096e5d3fallbacks_media_attributes.objectlanguage = : languagefallback 
WHERE 
  childImage.article_detail_id IN (: products) 
ORDER BY 
  image.main ASC, 
  image.position ASC
array:7 [
  ":language" => 3
  ":translation6afe1f096e5caarticleimage" => "articleimage"
  ":languagefallback" => 0
  ":translation6afe1f096e5cefallbackarticleimage" => "articleimage"
  ":translation6afe1f096e5d1s_media_attributes" => "s_media_attributes"
  ":translation6afe1f096e5d3fallbacks_media_attributes" => "s_media_attributes"
  ":products" => array:8 [
    0 => 13
    1 => 34
    2 => 43
    3 => 44
    4 => 45
    5 => 47
    6 => 49
    7 => 50
  ]
]
0.0008 ms
SELECT 
  media.id as __media_id, 
  media.albumID as __media_albumID, 
  media.name as __media_name, 
  media.description as __media_description, 
  media.path as __media_path, 
  media.type as __media_type, 
  media.extension as __media_extension, 
  media.file_size as __media_file_size, 
  media.width as __media_width, 
  media.height as __media_height, 
  media.userID as __media_userID, 
  media.created as __media_created, 
  mediaSettings.id as __mediaSettings_id, 
  mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, 
  mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, 
  mediaSettings.icon as __mediaSettings_icon, 
  mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, 
  mediaAttribute.id as __mediaAttribute_id, 
  mediaAttribute.mediaID as __mediaAttribute_mediaID, 
  image.id as __image_id, 
  image.articleID as __image_articleID, 
  image.img as __image_img, 
  image.main as __image_main, 
  image.description as __image_description, 
  image.position as __image_position, 
  image.width as __image_width, 
  image.height as __image_height, 
  image.extension as __image_extension, 
  image.parent_id as __image_parent_id, 
  image.media_id as __image_media_id, 
  imageAttribute.id as __imageAttribute_id, 
  imageAttribute.imageID as __imageAttribute_imageID, 
  imageAttribute.attribute1 as __imageAttribute_attribute1, 
  imageAttribute.attribute2 as __imageAttribute_attribute2, 
  imageAttribute.attribute3 as __imageAttribute_attribute3, 
  translation6afe1f096e98carticleimage.objectdata as __image_translation, 
  translation6afe1f096e990fallbackarticleimage.objectdata as __image_translation_fallback, 
  translation6afe1f096e993s_media_attributes.objectdata as __mediaAttribute_translation, 
  translation6afe1f096e994fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 
FROM 
  s_articles_img image 
  INNER JOIN s_media media ON image.media_id = media.id 
  LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id 
  LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id 
  LEFT JOIN s_articles_img childImage ON childImage.parent_id = image.id 
  LEFT JOIN s_core_translations translation6afe1f096e98carticleimage ON translation6afe1f096e98carticleimage.objecttype = : translation6afe1f096e98carticleimage 
  AND translation6afe1f096e98carticleimage.objectkey = image.id 
  AND translation6afe1f096e98carticleimage.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096e990fallbackarticleimage ON translation6afe1f096e990fallbackarticleimage.objecttype = : translation6afe1f096e990fallbackarticleimage 
  AND translation6afe1f096e990fallbackarticleimage.objectkey = image.id 
  AND translation6afe1f096e990fallbackarticleimage.objectlanguage = : languagefallback 
  INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID 
  LEFT JOIN s_core_translations translation6afe1f096e993s_media_attributes ON translation6afe1f096e993s_media_attributes.objecttype = : translation6afe1f096e993s_media_attributes 
  AND translation6afe1f096e993s_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f096e993s_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096e994fallbacks_media_attributes ON translation6afe1f096e994fallbacks_media_attributes.objecttype = : translation6afe1f096e994fallbacks_media_attributes 
  AND translation6afe1f096e994fallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f096e994fallbacks_media_attributes.objectlanguage = : languagefallback 
WHERE 
  (image.main = 1) 
  AND (
    image.articleID IN (: products)
  )
array:7 [
  ":language" => 3
  ":translation6afe1f096e98carticleimage" => "articleimage"
  ":languagefallback" => 0
  ":translation6afe1f096e990fallbackarticleimage" => "articleimage"
  ":translation6afe1f096e993s_media_attributes" => "s_media_attributes"
  ":translation6afe1f096e994fallbacks_media_attributes" => "s_media_attributes"
  ":products" => array:8 [
    0 => 2
    1 => 13
    2 => 14
    3 => 15
    4 => 16
    5 => 18
    6 => 20
    7 => 21
  ]
]
0.0007 ms
SELECT 
  price.id as __price_id, 
  price.pricegroup as __price_pricegroup, 
  price.from as __price_from, 
  price.to as __price_to, 
  price.articleID as __price_articleID, 
  price.articledetailsID as __price_articledetailsID, 
  price.price as __price_price, 
  price.pseudoprice as __price_pseudoprice, 
  price.percent as __price_percent, 
  priceAttribute.id as __priceAttribute_id, 
  priceAttribute.priceID as __priceAttribute_priceID, 
  variants.ordernumber as number, 
  GREATEST(
    price.from, variants.minpurchase
  ) __price_from, 
  translation6afe1f096edbds_articles_prices_attributes.objectdata as __priceAttribute_translation, 
  translation6afe1f096edc1fallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 
FROM 
  s_articles_prices price 
  INNER JOIN s_articles_details variants ON variants.id = price.articledetailsID 
  LEFT JOIN s_articles_prices_attributes priceAttribute ON priceAttribute.priceID = price.id 
  LEFT JOIN s_core_translations translation6afe1f096edbds_articles_prices_attributes ON translation6afe1f096edbds_articles_prices_attributes.objecttype = : translation6afe1f096edbds_articles_prices_attributes 
  AND translation6afe1f096edbds_articles_prices_attributes.objectkey = price.id 
  AND translation6afe1f096edbds_articles_prices_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096edc1fallbacks_articles_prices_attributes ON translation6afe1f096edc1fallbacks_articles_prices_attributes.objecttype = : translation6afe1f096edc1fallbacks_articles_prices_attributes 
  AND translation6afe1f096edc1fallbacks_articles_prices_attributes.objectkey = price.id 
  AND translation6afe1f096edc1fallbacks_articles_prices_attributes.objectlanguage = : languagefallback 
WHERE 
  (
    price.articledetailsID IN (: products)
  ) 
  AND (
    price.pricegroup = : customerGroup
  ) 
  AND (
    (price.to >= variants.minpurchase) 
    OR (price.to = "beliebig")
  ) 
ORDER BY 
  price.articledetailsID ASC, 
  price.from ASC
array:6 [
  ":products" => array:8 [
    0 => 13
    1 => 34
    2 => 43
    3 => 44
    4 => 45
    5 => 47
    6 => 49
    7 => 50
  ]
  ":customerGroup" => "EK"
  ":language" => 3
  ":translation6afe1f096edbds_articles_prices_attributes" => "s_articles_prices_attributes"
  ":languagefallback" => 0
  ":translation6afe1f096edc1fallbacks_articles_prices_attributes" => "s_articles_prices_attributes"
]
0.0005 ms
SELECT 
  (
    SELECT 
      prices.id 
    FROM 
      s_articles_prices prices 
      INNER JOIN s_articles_details variant ON variant.id = prices.articledetailsID 
      INNER JOIN s_articles product ON product.id = variant.articleID 
      LEFT JOIN s_core_pricegroups_discounts priceGroup ON priceGroup.groupID = product.pricegroupID 
      AND priceGroup.discountstart = 1 
      AND priceGroup.customergroupID = : priceGroupCustomerGroup 
      AND product.pricegroupActive = 1 
    WHERE 
      (
        prices.pricegroup = : customerGroup
      ) 
      AND (prices.from = 1) 
      AND (variant.active = 1) 
      AND (
        prices.articleID = outerPrices.articleID
      ) 
      AND (
        (
          variant.laststock * variant.instock
        ) >= (
          variant.laststock * variant.minpurchase
        )
      ) 
    ORDER BY 
      prices.price ASC 
    LIMIT 
      1
  ) as priceId 
FROM 
  s_articles_prices outerPrices 
WHERE 
  outerPrices.articleID IN (: products) 
GROUP BY 
  outerPrices.articleID 
HAVING 
  priceId IS NOT NULL
array:3 [
  ":customerGroup" => "EK"
  ":products" => array:8 [
    0 => 2
    1 => 13
    2 => 14
    3 => 15
    4 => 16
    5 => 18
    6 => 20
    7 => 21
  ]
  ":priceGroupCustomerGroup" => 1
]
0.0005 ms
SELECT 
  price.id as __price_id, 
  price.pricegroup as __price_pricegroup, 
  price.from as __price_from, 
  price.to as __price_to, 
  price.articleID as __price_articleID, 
  price.articledetailsID as __price_articledetailsID, 
  price.price as __price_price, 
  price.pseudoprice as __price_pseudoprice, 
  price.percent as __price_percent, 
  priceAttribute.id as __priceAttribute_id, 
  priceAttribute.priceID as __priceAttribute_priceID, 
  unit.id as __unit_id, 
  unit.description as __unit_description, 
  unit.unit as __unit_unit, 
  variant.packunit as __unit_packunit, 
  variant.purchaseunit as __unit_purchaseunit, 
  variant.referenceunit as __unit_referenceunit, 
  variant.purchasesteps as __unit_purchasesteps, 
  variant.minpurchase as __unit_minpurchase, 
  variant.maxpurchase as __unit_maxpurchase, 
  translation6afe1f096f21cconfig_units.objectdata as __unit_translation, 
  translation6afe1f096f220fallbackconfig_units.objectdata as __unit_translation_fallback, 
  translation6afe1f096f223article.objectdata as __product_translation, 
  translation6afe1f096f225fallbackarticle.objectdata as __product_translation_fallback, 
  translation6afe1f096f226variant.objectdata as __variant_translation, 
  translation6afe1f096f228fallbackvariant.objectdata as __variant_translation_fallback, 
  translation6afe1f096f229s_articles_prices_attributes.objectdata as __priceAttribute_translation, 
  translation6afe1f096f22bfallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 
FROM 
  s_articles_prices price 
  INNER JOIN s_articles_details variant ON variant.id = price.articledetailsID 
  LEFT JOIN s_articles_prices_attributes priceAttribute ON priceAttribute.priceID = price.id 
  INNER JOIN s_articles product ON product.id = variant.articleID 
  LEFT JOIN s_core_units unit ON unit.id = variant.unitID 
  LEFT JOIN s_core_translations translation6afe1f096f226variant ON translation6afe1f096f226variant.objecttype = : translation6afe1f096f226variant 
  AND translation6afe1f096f226variant.objectkey = variant.id 
  AND translation6afe1f096f226variant.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096f228fallbackvariant ON translation6afe1f096f228fallbackvariant.objecttype = : translation6afe1f096f228fallbackvariant 
  AND translation6afe1f096f228fallbackvariant.objectkey = variant.id 
  AND translation6afe1f096f228fallbackvariant.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f096f223article ON translation6afe1f096f223article.objecttype = : translation6afe1f096f223article 
  AND translation6afe1f096f223article.objectkey = product.id 
  AND translation6afe1f096f223article.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096f225fallbackarticle ON translation6afe1f096f225fallbackarticle.objecttype = : translation6afe1f096f225fallbackarticle 
  AND translation6afe1f096f225fallbackarticle.objectkey = product.id 
  AND translation6afe1f096f225fallbackarticle.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f096f21cconfig_units ON translation6afe1f096f21cconfig_units.objecttype = : translation6afe1f096f21cconfig_units 
  AND translation6afe1f096f21cconfig_units.objectkey = 1 
  AND translation6afe1f096f21cconfig_units.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096f220fallbackconfig_units ON translation6afe1f096f220fallbackconfig_units.objecttype = : translation6afe1f096f220fallbackconfig_units 
  AND translation6afe1f096f220fallbackconfig_units.objectkey = 1 
  AND translation6afe1f096f220fallbackconfig_units.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f096f229s_articles_prices_attributes ON translation6afe1f096f229s_articles_prices_attributes.objecttype = : translation6afe1f096f229s_articles_prices_attributes 
  AND translation6afe1f096f229s_articles_prices_attributes.objectkey = price.id 
  AND translation6afe1f096f229s_articles_prices_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096f22bfallbacks_articles_prices_attributes ON translation6afe1f096f22bfallbacks_articles_prices_attributes.objecttype = : translation6afe1f096f22bfallbacks_articles_prices_attributes 
  AND translation6afe1f096f22bfallbacks_articles_prices_attributes.objectkey = price.id 
  AND translation6afe1f096f22bfallbacks_articles_prices_attributes.objectlanguage = : languagefallback 
WHERE 
  price.id IN (: ids)
array:11 [
  ":ids" => array:8 [
    0 => "14"
    1 => "69"
    2 => "101"
    3 => "102"
    4 => "103"
    5 => "105"
    6 => "107"
    7 => "108"
  ]
  ":language" => 3
  ":translation6afe1f096f21cconfig_units" => "config_units"
  ":languagefallback" => 0
  ":translation6afe1f096f220fallbackconfig_units" => "config_units"
  ":translation6afe1f096f223article" => "article"
  ":translation6afe1f096f225fallbackarticle" => "article"
  ":translation6afe1f096f226variant" => "variant"
  ":translation6afe1f096f228fallbackvariant" => "variant"
  ":translation6afe1f096f229s_articles_prices_attributes" => "s_articles_prices_attributes"
  ":translation6afe1f096f22bfallbacks_articles_prices_attributes" => "s_articles_prices_attributes"
]
0.0007 ms
SELECT 
  articleID, 
  COUNT(id) as total, 
  points 
FROM 
  s_articles_vote vote 
WHERE 
  (
    vote.articleID IN (: products)
  ) 
  AND (vote.active = 1) 
GROUP BY 
  vote.articleID, 
  vote.points 
ORDER BY 
  vote.articleID ASC
array:1 [
  ":products" => array:8 [
    0 => 2
    1 => 13
    2 => 14
    3 => 15
    4 => 16
    5 => 18
    6 => 20
    7 => 21
  ]
]
0.0002 ms
SELECT 
  mapping.articleID, 
  GROUP_CONCAT(DISTINCT mapping.categoryID) 
FROM 
  s_articles_categories_ro mapping 
WHERE 
  mapping.articleID IN (: ids) 
GROUP BY 
  mapping.articleID
array:1 [
  ":ids" => array:8 [
    0 => 2
    1 => 13
    2 => 14
    3 => 15
    4 => 16
    5 => 18
    6 => 20
    7 => 21
  ]
]
0.0004 ms
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, 
  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, 
  translation6afe1f096f842s_categories_attributes.objectdata as __categoryAttribute_translation, 
  translation6afe1f096f845fallbacks_categories_attributes.objectdata as __categoryAttribute_translation_fallback, 
  translation6afe1f096f848s_media_attributes.objectdata as __mediaAttribute_translation, 
  translation6afe1f096f84afallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback, 
  translation6afe1f096f84cproductStream.objectdata as __stream_translation, 
  translation6afe1f096f84efallbackproductStream.objectdata as __stream_translation_fallback, 
  translation6afe1f096f850category.objectdata as __category_translation, 
  translation6afe1f096f851fallbackcategory.objectdata as __category_translation_fallback 
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_core_translations translation6afe1f096f850category ON translation6afe1f096f850category.objecttype = : translation6afe1f096f850category 
  AND translation6afe1f096f850category.objectkey = category.id 
  AND translation6afe1f096f850category.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096f851fallbackcategory ON translation6afe1f096f851fallbackcategory.objecttype = : translation6afe1f096f851fallbackcategory 
  AND translation6afe1f096f851fallbackcategory.objectkey = category.id 
  AND translation6afe1f096f851fallbackcategory.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation6afe1f096f842s_categories_attributes ON translation6afe1f096f842s_categories_attributes.objecttype = : translation6afe1f096f842s_categories_attributes 
  AND translation6afe1f096f842s_categories_attributes.objectkey = category.id 
  AND translation6afe1f096f842s_categories_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096f845fallbacks_categories_attributes ON translation6afe1f096f845fallbacks_categories_attributes.objecttype = : translation6afe1f096f845fallbacks_categories_attributes 
  AND translation6afe1f096f845fallbacks_categories_attributes.objectkey = category.id 
  AND translation6afe1f096f845fallbacks_categories_attributes.objectlanguage = : languagefallback 
  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_core_translations translation6afe1f096f848s_media_attributes ON translation6afe1f096f848s_media_attributes.objecttype = : translation6afe1f096f848s_media_attributes 
  AND translation6afe1f096f848s_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f096f848s_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096f84afallbacks_media_attributes ON translation6afe1f096f84afallbacks_media_attributes.objecttype = : translation6afe1f096f84afallbacks_media_attributes 
  AND translation6afe1f096f84afallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f096f84afallbacks_media_attributes.objectlanguage = : languagefallback 
  LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId 
  LEFT JOIN s_core_translations translation6afe1f096f84cproductStream ON translation6afe1f096f84cproductStream.objecttype = : translation6afe1f096f84cproductStream 
  AND translation6afe1f096f84cproductStream.objectkey = stream.id 
  AND translation6afe1f096f84cproductStream.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096f84efallbackproductStream ON translation6afe1f096f84efallbackproductStream.objecttype = : translation6afe1f096f84efallbackproductStream 
  AND translation6afe1f096f84efallbackproductStream.objectkey = stream.id 
  AND translation6afe1f096f84efallbackproductStream.objectlanguage = : languagefallback 
WHERE 
  (
    category.id IN (: categories)
  ) 
  AND (category.active = 1) 
  AND (
    category.shops IS NULL 
    OR category.shops LIKE : shopId
  ) 
GROUP BY 
  category.id
array:12 [
  ":categories" => array:35 [
    0 => "3"
    1 => "5"
    2 => "7"
    3 => "8"
    4 => "13"
    5 => "14"
    6 => "25"
    7 => "26"
    8 => "27"
    9 => "28"
    10 => "29"
    11 => "30"
    12 => "31"
    13 => "32"
    14 => "33"
    15 => "34"
    19 => "9"
    20 => "15"
    21 => "16"
    22 => "17"
    23 => "35"
    24 => "36"
    25 => "37"
    26 => "38"
    27 => "39"
    28 => "40"
    29 => "41"
    30 => "42"
    31 => "43"
    32 => "44"
    33 => "45"
    34 => "46"
    35 => "47"
    36 => "48"
    37 => "49"
  ]
  ":shopId" => "%|3|%"
  ":language" => 3
  ":translation6afe1f096f842s_categories_attributes" => "s_categories_attributes"
  ":languagefallback" => 0
  ":translation6afe1f096f845fallbacks_categories_attributes" => "s_categories_attributes"
  ":translation6afe1f096f848s_media_attributes" => "s_media_attributes"
  ":translation6afe1f096f84afallbacks_media_attributes" => "s_media_attributes"
  ":translation6afe1f096f84cproductStream" => "productStream"
  ":translation6afe1f096f84efallbackproductStream" => "productStream"
  ":translation6afe1f096f850category" => "category"
  ":translation6afe1f096f851fallbackcategory" => "category"
]
0.0013 ms
SELECT 
  media.id as __media_id, 
  media.albumID as __media_albumID, 
  media.name as __media_name, 
  media.description as __media_description, 
  media.path as __media_path, 
  media.type as __media_type, 
  media.extension as __media_extension, 
  media.file_size as __media_file_size, 
  media.width as __media_width, 
  media.height as __media_height, 
  media.userID as __media_userID, 
  media.created as __media_created, 
  mediaSettings.id as __mediaSettings_id, 
  mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, 
  mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, 
  mediaSettings.icon as __mediaSettings_icon, 
  mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, 
  mediaAttribute.id as __mediaAttribute_id, 
  mediaAttribute.mediaID as __mediaAttribute_mediaID, 
  translation6afe1f096feb7s_media_attributes.objectdata as __mediaAttribute_translation, 
  translation6afe1f096febbfallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 
FROM 
  s_media media 
  INNER 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_core_translations translation6afe1f096feb7s_media_attributes ON translation6afe1f096feb7s_media_attributes.objecttype = : translation6afe1f096feb7s_media_attributes 
  AND translation6afe1f096feb7s_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f096feb7s_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation6afe1f096febbfallbacks_media_attributes ON translation6afe1f096febbfallbacks_media_attributes.objecttype = : translation6afe1f096febbfallbacks_media_attributes 
  AND translation6afe1f096febbfallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation6afe1f096febbfallbacks_media_attributes.objectlanguage = : languagefallback 
WHERE 
  media.id IN (: ids)
array:5 [
  ":language" => 3
  ":translation6afe1f096feb7s_media_attributes" => "s_media_attributes"
  ":languagefallback" => 0
  ":translation6afe1f096febbfallbacks_media_attributes" => "s_media_attributes"
  ":ids" => array:6 [
    10002 => 2
    10013 => 2
    10014 => 2
    10015 => 2
    10018 => 2
    10021 => 2
  ]
]
0.0003 ms
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
[]
0.0001 ms
SELECT 
  org_path, 
  path 
FROM 
  s_core_rewrite_urls 
WHERE 
  subshopID =: shopId 
  AND org_path IN (: orgPath) 
  AND main = 1 
ORDER BY 
  id DESC
array:2 [
  ":shopId" => 3
  ":orgPath" => array:16 [
    0 => "sViewport=detail&sArticle=20"
    1 => "sViewport=detail&sArticle=20"
    2 => "sViewport=detail&sArticle=21"
    3 => "sViewport=detail&sArticle=21"
    4 => "sViewport=detail&sArticle=18"
    5 => "sViewport=detail&sArticle=18"
    6 => "sViewport=detail&sArticle=16"
    7 => "sViewport=detail&sArticle=16"
    8 => "sViewport=detail&sArticle=15"
    9 => "sViewport=detail&sArticle=15"
    10 => "sViewport=detail&sArticle=14"
    11 => "sViewport=detail&sArticle=14"
    12 => "sViewport=detail&sArticle=13"
    13 => "sViewport=detail&sArticle=13"
    14 => "sViewport=detail&sArticle=2"
    15 => "sViewport=detail&sArticle=2"
  ]
]
0.0003 ms
SELECT 
  s_core_config_values.value 
FROM 
  s_core_config_values 
  INNER JOIN s_core_config_elements ON s_core_config_values.element_id = s_core_config_elements.id 
  AND s_core_config_elements.`name` LIKE 'assetTimestamp' 
WHERE 
  s_core_config_values.shop_id = : shopId
array:1 [
  "shopId" => 1
]
0.0001 ms
SELECT 
  s0_.id AS id_0, 
  s0_.compiler_force AS compiler_force_1, 
  s0_.compiler_create_source_map AS compiler_create_source_map_2, 
  s0_.compiler_compress_css AS compiler_compress_css_3, 
  s0_.compiler_compress_js AS compiler_compress_js_4, 
  s0_.force_reload_snippets AS force_reload_snippets_5 
FROM 
  s_core_theme_settings s0_ 
ORDER BY 
  s0_.id ASC 
LIMIT 
  1
[]
0.0001 ms
SELECT 
  org_path, 
  path 
FROM 
  s_core_rewrite_urls 
WHERE 
  subshopID =: shopId 
  AND org_path IN (: orgPath) 
  AND main = 1 
ORDER BY 
  id DESC
array:2 [
  ":shopId" => 3
  ":orgPath" => array:107 [
    0 => "sViewport=cat&sCategory=5"
    1 => "sViewport=cat&sCategory=7"
    2 => "sViewport=cat&sCategory=8"
    3 => "sViewport=cat&sCategory=9"
    4 => "sViewport=cat&sCategory=10"
    5 => "sViewport=cat&sCategory=11"
    6 => "sViewport=blog&sCategory=81"
    7 => "sViewport=cat&sCategory=12"
    8 => "sViewport=cat&sCategory=5"
    9 => "sViewport=cat&sCategory=7"
    10 => "sViewport=cat&sCategory=8"
    11 => "sViewport=cat&sCategory=13"
    12 => "sViewport=cat&sCategory=25"
    13 => "sViewport=cat&sCategory=26"
    14 => "sViewport=cat&sCategory=27"
    15 => "sViewport=cat&sCategory=28"
    16 => "sViewport=cat&sCategory=29"
    17 => "sViewport=cat&sCategory=14"
    18 => "sViewport=cat&sCategory=30"
    19 => "sViewport=cat&sCategory=31"
    20 => "sViewport=cat&sCategory=32"
    21 => "sViewport=cat&sCategory=33"
    22 => "sViewport=cat&sCategory=34"
    23 => "sViewport=cat&sCategory=9"
    24 => "sViewport=cat&sCategory=15"
    25 => "sViewport=cat&sCategory=35"
    26 => "sViewport=cat&sCategory=36"
    27 => "sViewport=cat&sCategory=37"
    28 => "sViewport=cat&sCategory=38"
    29 => "sViewport=cat&sCategory=39"
    30 => "sViewport=cat&sCategory=16"
    31 => "sViewport=cat&sCategory=40"
    32 => "sViewport=cat&sCategory=41"
    33 => "sViewport=cat&sCategory=42"
    34 => "sViewport=cat&sCategory=43"
    35 => "sViewport=cat&sCategory=44"
    36 => "sViewport=cat&sCategory=17"
    37 => "sViewport=cat&sCategory=45"
    38 => "sViewport=cat&sCategory=46"
    39 => "sViewport=cat&sCategory=47"
    40 => "sViewport=cat&sCategory=48"
    41 => "sViewport=cat&sCategory=49"
    42 => "sViewport=cat&sCategory=10"
    43 => "sViewport=cat&sCategory=18"
    44 => "sViewport=cat&sCategory=50"
    45 => "sViewport=cat&sCategory=51"
    46 => "sViewport=cat&sCategory=52"
    47 => "sViewport=cat&sCategory=53"
    48 => "sViewport=cat&sCategory=54"
    49 => "sViewport=cat&sCategory=19"
    50 => "sViewport=cat&sCategory=55"
    51 => "sViewport=cat&sCategory=56"
    52 => "sViewport=cat&sCategory=57"
    53 => "sViewport=cat&sCategory=58"
    54 => "sViewport=cat&sCategory=59"
    55 => "sViewport=cat&sCategory=20"
    56 => "sViewport=cat&sCategory=60"
    57 => "sViewport=cat&sCategory=61"
    58 => "sViewport=cat&sCategory=62"
    59 => "sViewport=cat&sCategory=63"
    60 => "sViewport=cat&sCategory=21"
    61 => "sViewport=cat&sCategory=76"
    62 => "sViewport=cat&sCategory=77"
    63 => "sViewport=cat&sCategory=78"
    64 => "sViewport=cat&sCategory=79"
    65 => "sViewport=cat&sCategory=80"
    66 => "sViewport=cat&sCategory=11"
    67 => "sViewport=blog&sCategory=81"
    68 => "sViewport=cat&sCategory=12"
    69 => "sViewport=cat&sCategory=22"
    70 => "sViewport=cat&sCategory=23"
    71 => "sViewport=cat&sCategory=24"
    72 => "sViewport=cat&sCategory=42"
    73 => "sViewport=cat&sCategory=9"
    74 => "sViewport=cat&sCategory=9"
    75 => "sViewport=cat&sCategory=16"
    76 => "sViewport=cat&sCategory=16"
    77 => "sViewport=cat&sCategory=42"
    78 => "sViewport=cat&sCategory=42"
    79 => "sViewport=cat&sCategory=5"
    80 => "sViewport=cat&sCategory=7"
    81 => "sViewport=cat&sCategory=8"
    82 => "sViewport=cat&sCategory=9"
    83 => "sViewport=cat&sCategory=15"
    84 => "sViewport=cat&sCategory=16"
    85 => "sViewport=cat&sCategory=40"
    86 => "sViewport=cat&sCategory=41"
    87 => "sViewport=cat&sCategory=42"
    88 => "sViewport=cat&sCategory=43"
    89 => "sViewport=cat&sCategory=44"
    90 => "sViewport=cat&sCategory=17"
    91 => "sViewport=cat&sCategory=10"
    92 => "sViewport=cat&sCategory=11"
    93 => "sViewport=blog&sCategory=81"
    94 => "sViewport=cat&sCategory=12"
    95 => "sViewport=detail&sArticle=11"
    96 => "sViewport=detail&sArticle=11"
    97 => "sViewport=detail&sArticle=12"
    98 => "sViewport=detail&sArticle=12"
    99 => "sViewport=detail&sArticle=13"
    100 => "sViewport=detail&sArticle=13"
    101 => "sViewport=detail&sArticle=15"
    102 => "sViewport=detail&sArticle=15"
    103 => "sViewport=detail&sArticle=16"
    104 => "sViewport=detail&sArticle=16"
    105 => "sViewport=detail&sArticle=18"
    106 => "sViewport=detail&sArticle=18"
  ]
]
0.0008 ms
SELECT 
  expiry, 
  modified 
FROM 
  s_core_sessions 
WHERE 
  id = ?
array:1 [
  0 => "6c107cbc9f5460a8c16de96fd8309d7e"
]
0.0002 ms
SELECT 
  `s_core_snippets`.`name`, 
  `s_core_snippets`.`value` 
FROM 
  `s_core_snippets` 
WHERE 
  (
    namespace = 'frontend/listing/facet_labels'
  ) 
  AND (shopID = '3') 
  AND (localeID = '2')
[]
0.1171 ms
SELECT 
  `s_core_snippets`.`name`, 
  `s_core_snippets`.`value` 
FROM 
  `s_core_snippets` 
WHERE 
  (
    namespace = 'frontend/listing/facet_labels'
  ) 
  AND (shopID = '1') 
  AND (localeID = '2')
[]
0.0610 ms
SELECT 
  `s_core_snippets`.`name`, 
  `s_core_snippets`.`value` 
FROM 
  `s_core_snippets` 
WHERE 
  (
    namespace = 'frontend/listing/facet_labels'
  ) 
  AND (shopID = '1') 
  AND (localeID = '1')
[]
0.0579 ms
SELECT 
  variant.ordernumber 
FROM 
  s_articles_details variant 
  INNER JOIN s_articles product ON product.main_detail_id = variant.id 
  AND product.id = ?
array:1 [
  1 => 19
]
0.1259 ms
SELECT 
  `s_core_snippets`.`name`, 
  `s_core_snippets`.`value` 
FROM 
  `s_core_snippets` 
WHERE 
  (
    namespace = 'frontend/cookie_consent/groups'
  ) 
  AND (shopID = '3') 
  AND (localeID = '2')
[]
0.0510 ms
SELECT 
  `s_core_snippets`.`name`, 
  `s_core_snippets`.`value` 
FROM 
  `s_core_snippets` 
WHERE 
  (
    namespace = 'frontend/cookie_consent/groups'
  ) 
  AND (shopID = '1') 
  AND (localeID = '2')
[]
0.0582 ms
SELECT 
  `s_core_snippets`.`name`, 
  `s_core_snippets`.`value` 
FROM 
  `s_core_snippets` 
WHERE 
  (
    namespace = 'frontend/cookie_consent/groups'
  ) 
  AND (shopID = '1') 
  AND (localeID = '1')
[]
0.0560 ms
SELECT 
  `s_core_snippets`.`name`, 
  `s_core_snippets`.`value` 
FROM 
  `s_core_snippets` 
WHERE 
  (
    namespace = 'frontend/cookie_consent/cookies'
  ) 
  AND (shopID = '3') 
  AND (localeID = '2')
[]
0.0610 ms
SELECT 
  `s_core_snippets`.`name`, 
  `s_core_snippets`.`value` 
FROM 
  `s_core_snippets` 
WHERE 
  (
    namespace = 'frontend/cookie_consent/cookies'
  ) 
  AND (shopID = '1') 
  AND (localeID = '2')
[]
0.0479 ms
SELECT 
  `s_core_snippets`.`name`, 
  `s_core_snippets`.`value` 
FROM 
  `s_core_snippets` 
WHERE 
  (
    namespace = 'frontend/cookie_consent/cookies'
  ) 
  AND (shopID = '1') 
  AND (localeID = '1')
[]
0.0470 ms
SELECT 
  * 
FROM 
  s_order_comparisons 
WHERE 
  sessionID = ?
array:1 [
  1 => "6c107cbc9f5460a8c16de96fd8309d7e"
]
0.1900 ms
SELECT 
  COUNT(*) 
FROM 
  s_order_notes n, 
  s_articles a 
WHERE 
  (
    sUniqueID = ? 
    OR (
      userID != 0 
      AND userID = ?
    )
  ) 
  AND a.id = n.articleID 
  AND a.active = 1
array:2 [
  1 => "6c107cbc9f5460a8c16de96fd8309d7e"
  2 => 0
]
0.2129 ms
SELECT 
  DISTINCT alsoBought.sales as sales, 
  alsoBought.related_article_id as id, 
  detail.ordernumber as `number` 
FROM 
  s_articles_also_bought_ro alsoBought 
  INNER JOIN s_articles articles ON alsoBought.related_article_id = articles.id 
  AND articles.active = 1 
  INNER JOIN s_articles_details detail ON detail.id = articles.main_detail_id 
  INNER JOIN s_articles_categories_ro articleCategories ON alsoBought.related_article_id = articleCategories.articleID 
  AND articleCategories.categoryID = : categoryId 
  INNER JOIN s_categories categories ON categories.id = articleCategories.categoryID 
  LEFT JOIN s_articles_avoid_customergroups customerGroups ON customerGroups.articleID = articles.id 
  AND customerGroups.customergroupID = : customerGroupId 
WHERE 
  alsoBought.article_id = : articleId 
  AND customerGroups.articleID IS NULL 
  AND alsoBought.related_article_id NOT IN (19) 
ORDER BY 
  alsoBought.sales DESC, 
  alsoBought.related_article_id DESC 
LIMIT 
  40
array:3 [
  ":articleId" => 19
  ":categoryId" => 3
  ":customerGroupId" => 1
]
0.3321 ms
SELECT 
  similarShown.viewed as hits, 
  similarShown.related_article_id as id, 
  detail.ordernumber as `number` 
FROM 
  s_articles_similar_shown_ro as similarShown 
  INNER JOIN s_articles as a ON a.id = similarShown.related_article_id 
  AND a.active = 1 
  INNER JOIN s_articles_details as detail ON detail.id = a.main_detail_id 
  INNER JOIN s_articles_categories_ro ac ON ac.articleID = similarShown.related_article_id 
  AND ac.categoryID = : categoryId 
  INNER JOIN s_categories c ON c.id = ac.categoryID 
  AND c.active = 1 
  LEFT JOIN s_articles_avoid_customergroups ag ON ag.articleID = a.id 
  AND ag.customergroupID = : customerGroupId 
WHERE 
  similarShown.article_id = : articleId 
  AND ag.articleID IS NULL 
  AND similarShown.related_article_id NOT IN (19, 19) 
GROUP BY 
  similarShown.viewed, 
  similarShown.related_article_id 
ORDER BY 
  similarShown.viewed DESC, 
  similarShown.related_article_id DESC 
LIMIT 
  40
array:3 [
  ":articleId" => 19
  ":categoryId" => 3
  ":customerGroupId" => 1
]
0.3941 ms