http://welovevino.org/sitemap_index.xml

Method
GET
HTTP Status
200
IP
10.0.8.4
Profiled on
2026-05-08 03:15:34
Token
69fd393657ddd

Queries

83 Total Queries
0.0115 s Total Query Time
SQL Params Execution Time 
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" => "welovevino.org"
]
0.0011 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_.locale AS locale_31, 
  s1_.language AS language_32, 
  s1_.territory AS territory_33, 
  s2_.id AS id_34, 
  s2_.currency AS currency_35, 
  s2_.name AS name_36, 
  s2_.standard AS standard_37, 
  s2_.factor AS factor_38, 
  s2_.templatechar AS templatechar_39, 
  s2_.symbol_position AS symbol_position_40, 
  s2_.position AS position_41, 
  s3_.id AS id_42, 
  s3_.template AS template_43, 
  s3_.name AS name_44, 
  s3_.description AS description_45, 
  s3_.author AS author_46, 
  s3_.license AS license_47, 
  s3_.esi AS esi_48, 
  s3_.style_support AS style_support_49, 
  s3_.emotion AS emotion_50, 
  s3_.version AS version_51, 
  s3_.plugin_id AS plugin_id_52, 
  s3_.parent_id AS parent_id_53, 
  s4_.id AS id_54, 
  s4_.template AS template_55, 
  s4_.name AS name_56, 
  s4_.description AS description_57, 
  s4_.author AS author_58, 
  s4_.license AS license_59, 
  s4_.esi AS esi_60, 
  s4_.style_support AS style_support_61, 
  s4_.emotion AS emotion_62, 
  s4_.version AS version_63, 
  s4_.plugin_id AS plugin_id_64, 
  s4_.parent_id AS parent_id_65, 
  s5_.id AS id_66, 
  s5_.currency AS currency_67, 
  s5_.name AS name_68, 
  s5_.standard AS standard_69, 
  s5_.factor AS factor_70, 
  s5_.templatechar AS templatechar_71, 
  s5_.symbol_position AS symbol_position_72, 
  s5_.position AS position_73, 
  s6_.id AS id_74, 
  s6_.groupkey AS groupkey_75, 
  s6_.description AS description_76, 
  s6_.tax AS tax_77, 
  s6_.taxinput AS taxinput_78, 
  s6_.mode AS mode_79, 
  s6_.discount AS discount_80, 
  s6_.minimumorder AS minimumorder_81, 
  s6_.minimumordersurcharge AS minimumordersurcharge_82, 
  s0_.main_id AS main_id_83, 
  s0_.template_id AS template_id_84, 
  s0_.document_template_id AS document_template_id_85, 
  s0_.category_id AS category_id_86, 
  s0_.locale_id AS locale_id_87, 
  s0_.currency_id AS currency_id_88, 
  s0_.customer_group_id AS customer_group_id_89, 
  s0_.fallback_id AS fallback_id_90, 
  s3_.parent_id AS parent_id_91, 
  s3_.plugin_id AS plugin_id_92, 
  s4_.parent_id AS parent_id_93, 
  s4_.plugin_id AS plugin_id_94 
FROM 
  s_core_shops s0_ 
  LEFT JOIN s_core_locales s1_ ON s0_.locale_id = s1_.id 
  LEFT JOIN s_core_currencies s2_ ON s0_.currency_id = s2_.id 
  LEFT JOIN s_core_templates s3_ ON s0_.template_id = s3_.id 
  LEFT JOIN s_core_templates s4_ ON s0_.document_template_id = s4_.id 
  LEFT JOIN s_core_shop_currencies s7_ ON s0_.id = s7_.shop_id 
  LEFT JOIN s_core_currencies s5_ ON s5_.id = s7_.currency_id 
  LEFT JOIN s_core_customergroups s6_ ON s0_.customer_group_id = s6_.id 
WHERE 
  s0_.id = ? 
ORDER BY 
  s5_.position ASC, 
  s5_.id ASC
 
array:1 [
  0 => "1"
]
0.0015 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.0005 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.0005 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" => "welovevino.org"
]
0.0007 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 => 1
]
0.0005 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.0005 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.0004 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.0005 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.0004 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.0009 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.0007 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.0004 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
 
array:2 [
  ":shopId" => 1
  ":pathInfo" => "sitemap_index.xml"
]
0.0006 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.0005 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.0025 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.0006 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.0004 ms 
SELECT 
  tax.id as __tax_id, 
  tax.tax as __tax_tax, 
  tax.description as __tax_description 
FROM 
  s_core_tax tax
 
[]
0.0003 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 OFFSET 0
 
array:5 [
  ":area" => null
  ":country" => null
  ":state" => null
  ":customerGroup" => 1
  ":taxId" => "1"
]
0.0005 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 OFFSET 0
 
array:5 [
  ":area" => null
  ":country" => null
  ":state" => null
  ":customerGroup" => 1
  ":taxId" => "4"
]
0.0007 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.0006 ms 
SELECT 
  NOW() AS current, 
  cf.value AS last, 
  (
    SELECT 
      1 
    FROM 
      s_search_index 
    LIMIT 
      1
  ) AS not_force 
FROM 
  s_core_config_elements ce, 
  s_core_config_values cf 
WHERE 
  ce.name = 'fuzzysearchlastupdate' 
  AND cf.element_id = ce.id 
  AND cf.shop_id = 1
 
[]
0.0010 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.0048 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.0015 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.0008 ms 
SELECT 
  tax.id as __tax_id, 
  tax.tax as __tax_tax, 
  tax.description as __tax_description 
FROM 
  s_core_tax tax
 
[]
0.0005 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 OFFSET 0
 
array:5 [
  ":area" => null
  ":country" => null
  ":state" => null
  ":customerGroup" => 1
  ":taxId" => "1"
]
0.0010 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 OFFSET 0
 
array:5 [
  ":area" => null
  ":country" => null
  ":state" => null
  ":customerGroup" => 1
  ":taxId" => "4"
]
0.0008 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.0009 ms 
SELECT 
  product.id as __product_id, 
  variant.id as __variant_id, 
  variant.ordernumber as __variant_ordernumber 
FROM 
  s_articles product 
  INNER JOIN s_articles_details variant ON variant.id = product.main_detail_id 
  AND variant.active = 1 
  AND product.active = 1 
  INNER JOIN s_articles_categories_ro productCategory ON productCategory.articleID = product.id 
  AND productCategory.categoryID IN (: productCategory) 
  LEFT JOIN s_articles_avoid_customergroups avoidCustomerGroup ON avoidCustomerGroup.articleID = product.id 
  AND avoidCustomerGroup.customerGroupId IN (
    : customerGroupIds38ba0f9d2195aa1ed719d712288c9fae
  ) 
  INNER JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id 
WHERE 
  avoidCustomerGroup.articleID IS NULL 
GROUP BY 
  product.id 
ORDER BY 
  variant.id ASC 
LIMIT 
  10000
 
array:2 [
  ":productCategory" => array:1 [
    0 => 3
  ]
  ":customerGroupIds38ba0f9d2195aa1ed719d712288c9fae" => array:1 [
    0 => 1
  ]
]
0.0040 ms 
SELECT 
  id, 
  changetime 
FROM 
  s_articles product 
WHERE 
  id IN(: productIds)
 
array:1 [
  "productIds" => array:94 [
    0 => 198
    1 => 199
    2 => 200
    3 => 201
    4 => 202
    5 => 203
    6 => 204
    7 => 205
    8 => 206
    9 => 207
    10 => 208
    11 => 209
    12 => 210
    13 => 211
    14 => 212
    15 => 213
    16 => 214
    17 => 215
    18 => 216
    19 => 217
    20 => 218
    21 => 219
    22 => 220
    23 => 221
    24 => 222
    25 => 223
    26 => 224
    27 => 225
    28 => 226
    29 => 227
    30 => 228
    31 => 229
    32 => 230
    33 => 231
    34 => 232
    35 => 233
    36 => 234
    37 => 235
    38 => 236
    39 => 237
    40 => 238
    41 => 239
    42 => 240
    43 => 241
    44 => 242
    45 => 243
    46 => 244
    47 => 245
    48 => 246
    49 => 247
    50 => 248
    51 => 249
    52 => 250
    53 => 251
    54 => 252
    55 => 253
    56 => 254
    57 => 255
    58 => 256
    59 => 257
    60 => 258
    61 => 259
    62 => 260
    63 => 261
    64 => 262
    65 => 263
    66 => 264
    67 => 265
    68 => 266
    69 => 267
    70 => 268
    71 => 269
    72 => 270
    73 => 271
    74 => 272
    75 => 273
    76 => 274
    77 => 275
    78 => 276
    79 => 277
    80 => 278
    81 => 279
    82 => 280
    83 => 281
    84 => 282
    85 => 283
    86 => 284
    87 => 285
    88 => 286
    89 => 287
    90 => 288
    91 => 289
    92 => 290
    93 => 291
  ]
]
0.0018 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" => 1
  ":orgPath" => array:94 [
    0 => "sViewport=detail&sArticle=198"
    1 => "sViewport=detail&sArticle=199"
    2 => "sViewport=detail&sArticle=200"
    3 => "sViewport=detail&sArticle=201"
    4 => "sViewport=detail&sArticle=202"
    5 => "sViewport=detail&sArticle=203"
    6 => "sViewport=detail&sArticle=204"
    7 => "sViewport=detail&sArticle=205"
    8 => "sViewport=detail&sArticle=206"
    9 => "sViewport=detail&sArticle=207"
    10 => "sViewport=detail&sArticle=208"
    11 => "sViewport=detail&sArticle=209"
    12 => "sViewport=detail&sArticle=210"
    13 => "sViewport=detail&sArticle=211"
    14 => "sViewport=detail&sArticle=212"
    15 => "sViewport=detail&sArticle=213"
    16 => "sViewport=detail&sArticle=214"
    17 => "sViewport=detail&sArticle=215"
    18 => "sViewport=detail&sArticle=216"
    19 => "sViewport=detail&sArticle=217"
    20 => "sViewport=detail&sArticle=218"
    21 => "sViewport=detail&sArticle=219"
    22 => "sViewport=detail&sArticle=220"
    23 => "sViewport=detail&sArticle=221"
    24 => "sViewport=detail&sArticle=222"
    25 => "sViewport=detail&sArticle=223"
    26 => "sViewport=detail&sArticle=224"
    27 => "sViewport=detail&sArticle=225"
    28 => "sViewport=detail&sArticle=226"
    29 => "sViewport=detail&sArticle=227"
    30 => "sViewport=detail&sArticle=228"
    31 => "sViewport=detail&sArticle=229"
    32 => "sViewport=detail&sArticle=230"
    33 => "sViewport=detail&sArticle=231"
    34 => "sViewport=detail&sArticle=232"
    35 => "sViewport=detail&sArticle=233"
    36 => "sViewport=detail&sArticle=234"
    37 => "sViewport=detail&sArticle=235"
    38 => "sViewport=detail&sArticle=236"
    39 => "sViewport=detail&sArticle=237"
    40 => "sViewport=detail&sArticle=238"
    41 => "sViewport=detail&sArticle=239"
    42 => "sViewport=detail&sArticle=240"
    43 => "sViewport=detail&sArticle=241"
    44 => "sViewport=detail&sArticle=242"
    45 => "sViewport=detail&sArticle=243"
    46 => "sViewport=detail&sArticle=244"
    47 => "sViewport=detail&sArticle=245"
    48 => "sViewport=detail&sArticle=246"
    49 => "sViewport=detail&sArticle=247"
    50 => "sViewport=detail&sArticle=248"
    51 => "sViewport=detail&sArticle=249"
    52 => "sViewport=detail&sArticle=250"
    53 => "sViewport=detail&sArticle=251"
    54 => "sViewport=detail&sArticle=252"
    55 => "sViewport=detail&sArticle=253"
    56 => "sViewport=detail&sArticle=254"
    57 => "sViewport=detail&sArticle=255"
    58 => "sViewport=detail&sArticle=257"
    59 => "sViewport=detail&sArticle=258"
    60 => "sViewport=detail&sArticle=259"
    61 => "sViewport=detail&sArticle=260"
    62 => "sViewport=detail&sArticle=261"
    63 => "sViewport=detail&sArticle=262"
    64 => "sViewport=detail&sArticle=263"
    65 => "sViewport=detail&sArticle=264"
    66 => "sViewport=detail&sArticle=265"
    67 => "sViewport=detail&sArticle=266"
    68 => "sViewport=detail&sArticle=267"
    69 => "sViewport=detail&sArticle=268"
    70 => "sViewport=detail&sArticle=269"
    71 => "sViewport=detail&sArticle=270"
    72 => "sViewport=detail&sArticle=271"
    73 => "sViewport=detail&sArticle=272"
    74 => "sViewport=detail&sArticle=273"
    75 => "sViewport=detail&sArticle=274"
    76 => "sViewport=detail&sArticle=275"
    77 => "sViewport=detail&sArticle=276"
    78 => "sViewport=detail&sArticle=277"
    79 => "sViewport=detail&sArticle=278"
    80 => "sViewport=detail&sArticle=279"
    81 => "sViewport=detail&sArticle=280"
    82 => "sViewport=detail&sArticle=281"
    83 => "sViewport=detail&sArticle=282"
    84 => "sViewport=detail&sArticle=283"
    85 => "sViewport=detail&sArticle=284"
    86 => "sViewport=detail&sArticle=285"
    87 => "sViewport=detail&sArticle=286"
    88 => "sViewport=detail&sArticle=287"
    89 => "sViewport=detail&sArticle=288"
    90 => "sViewport=detail&sArticle=289"
    91 => "sViewport=detail&sArticle=290"
    92 => "sViewport=detail&sArticle=291"
    93 => "sViewport=detail&sArticle=256"
  ]
]
0.0037 ms 
SELECT 
  product.id as __product_id, 
  variant.id as __variant_id, 
  variant.ordernumber as __variant_ordernumber 
FROM 
  s_articles product 
  INNER JOIN s_articles_details variant ON variant.id = product.main_detail_id 
  AND variant.active = 1 
  AND product.active = 1 
  INNER JOIN s_articles_categories_ro productCategory ON productCategory.articleID = product.id 
  AND productCategory.categoryID IN (: productCategory) 
  LEFT JOIN s_articles_avoid_customergroups avoidCustomerGroup ON avoidCustomerGroup.articleID = product.id 
  AND avoidCustomerGroup.customerGroupId IN (
    : customerGroupIds38ba0f9d2195aa1ed719d712288c9fae
  ) 
  INNER JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id 
WHERE 
  (
    avoidCustomerGroup.articleID IS NULL
  ) 
  AND (product.id > : lastId) 
GROUP BY 
  product.id 
ORDER BY 
  variant.id ASC 
LIMIT 
  10000
 
array:3 [
  ":productCategory" => array:1 [
    0 => 3
  ]
  ":customerGroupIds38ba0f9d2195aa1ed719d712288c9fae" => array:1 [
    0 => 1
  ]
  "lastId" => 291
]
0.0023 ms 
SELECT 
  shopGroups.key 
FROM 
  s_core_shop_pages shopPages 
  INNER JOIN s_cms_static_groups shopGroups ON shopGroups.id = shopPages.group_id 
WHERE 
  shopPages.shop_id = : shopId
 
array:1 [
  "shopId" => 1
]
0.0008 ms 
SELECT 
  (
    SELECT 
      COUNT(s0_.id) AS sclr_1 
    FROM 
      s_categories s1_ 
      LEFT JOIN s_articles_categories_ro s2_ ON s1_.id = s2_.categoryID 
      LEFT JOIN s_articles s0_ ON s0_.id = s2_.articleID 
      AND (s0_.active = 1) 
    WHERE 
      s1_.id = s3_.id 
    GROUP BY 
      s1_.id
  ) AS sclr_0, 
  (
    SELECT 
      COUNT(s4_.id) AS sclr_3 
    FROM 
      s_categories s4_ 
    WHERE 
      s4_.parent = s3_.id
  ) AS sclr_2, 
  s3_.sorting_ids AS sorting_ids_4, 
  s3_.hide_sortings AS hide_sortings_5, 
  s3_.facet_ids AS facet_ids_6, 
  s3_.shops AS shops_7, 
  s3_.id AS id_8, 
  s3_.parent AS parent_9, 
  s3_.stream_id AS stream_id_10, 
  s3_.description AS description_11, 
  s3_.position AS position_12, 
  s3_.meta_title AS meta_title_13, 
  s3_.metakeywords AS metakeywords_14, 
  s3_.metadescription AS metadescription_15, 
  s3_.cmsheadline AS cmsheadline_16, 
  s3_.cmstext AS cmstext_17, 
  s3_.active AS active_18, 
  s3_.template AS template_19, 
  s3_.product_box_layout AS product_box_layout_20, 
  s3_.blog AS blog_21, 
  s3_.path AS path_22, 
  s3_.external AS external_23, 
  s3_.external_target AS external_target_24, 
  s3_.hidefilter AS hidefilter_25, 
  s3_.hidetop AS hidetop_26, 
  s3_.changed AS changed_27, 
  s3_.added AS added_28, 
  s3_.mediaID AS mediaID_29, 
  s5_.id AS id_30, 
  s5_.albumID AS albumID_31, 
  s5_.name AS name_32, 
  s5_.description AS description_33, 
  s5_.path AS path_34, 
  s5_.type AS type_35, 
  s5_.extension AS extension_36, 
  s5_.userID AS userID_37, 
  s5_.created AS created_38, 
  s5_.file_size AS file_size_39, 
  s5_.width AS width_40, 
  s5_.height AS height_41, 
  s6_.id AS id_42, 
  s6_.categoryID AS categoryID_43, 
  s6_.attribute1 AS attribute1_44, 
  s6_.attribute2 AS attribute2_45, 
  s6_.attribute3 AS attribute3_46, 
  s6_.attribute4 AS attribute4_47, 
  s6_.attribute5 AS attribute5_48, 
  s6_.attribute6 AS attribute6_49 
FROM 
  s_categories s3_ 
  LEFT JOIN s_media s5_ ON s3_.mediaID = s5_.id 
  LEFT JOIN s_categories_attributes s6_ ON s3_.id = s6_.categoryID 
  LEFT JOIN s_categories_avoid_customergroups s8_ ON s3_.id = s8_.categoryID 
  LEFT JOIN s_core_customergroups s7_ ON s7_.id = s8_.customergroupID 
  AND (s7_.id = ?) 
WHERE 
  s3_.active = 1 
  AND (
    s3_.shops IS NULL 
    OR s3_.shops LIKE ?
  ) 
  AND s3_.parent = ? 
GROUP BY 
  s3_.parent, 
  s3_.position, 
  s3_.id 
HAVING 
  COUNT(s7_.id) = 0 
ORDER BY 
  s3_.parent ASC, 
  s3_.position ASC, 
  s3_.id ASC
 
array:3 [
  0 => 1
  1 => "%|1|%"
  2 => 3
]
0.0068 ms 
SELECT 
  (
    SELECT 
      COUNT(s0_.id) AS sclr_1 
    FROM 
      s_categories s1_ 
      LEFT JOIN s_articles_categories_ro s2_ ON s1_.id = s2_.categoryID 
      LEFT JOIN s_articles s0_ ON s0_.id = s2_.articleID 
      AND (s0_.active = 1) 
    WHERE 
      s1_.id = s3_.id 
    GROUP BY 
      s1_.id
  ) AS sclr_0, 
  (
    SELECT 
      COUNT(s4_.id) AS sclr_3 
    FROM 
      s_categories s4_ 
    WHERE 
      s4_.parent = s3_.id
  ) AS sclr_2, 
  s3_.sorting_ids AS sorting_ids_4, 
  s3_.hide_sortings AS hide_sortings_5, 
  s3_.facet_ids AS facet_ids_6, 
  s3_.shops AS shops_7, 
  s3_.id AS id_8, 
  s3_.parent AS parent_9, 
  s3_.stream_id AS stream_id_10, 
  s3_.description AS description_11, 
  s3_.position AS position_12, 
  s3_.meta_title AS meta_title_13, 
  s3_.metakeywords AS metakeywords_14, 
  s3_.metadescription AS metadescription_15, 
  s3_.cmsheadline AS cmsheadline_16, 
  s3_.cmstext AS cmstext_17, 
  s3_.active AS active_18, 
  s3_.template AS template_19, 
  s3_.product_box_layout AS product_box_layout_20, 
  s3_.blog AS blog_21, 
  s3_.path AS path_22, 
  s3_.external AS external_23, 
  s3_.external_target AS external_target_24, 
  s3_.hidefilter AS hidefilter_25, 
  s3_.hidetop AS hidetop_26, 
  s3_.changed AS changed_27, 
  s3_.added AS added_28, 
  s3_.mediaID AS mediaID_29, 
  s5_.id AS id_30, 
  s5_.albumID AS albumID_31, 
  s5_.name AS name_32, 
  s5_.description AS description_33, 
  s5_.path AS path_34, 
  s5_.type AS type_35, 
  s5_.extension AS extension_36, 
  s5_.userID AS userID_37, 
  s5_.created AS created_38, 
  s5_.file_size AS file_size_39, 
  s5_.width AS width_40, 
  s5_.height AS height_41, 
  s6_.id AS id_42, 
  s6_.categoryID AS categoryID_43, 
  s6_.attribute1 AS attribute1_44, 
  s6_.attribute2 AS attribute2_45, 
  s6_.attribute3 AS attribute3_46, 
  s6_.attribute4 AS attribute4_47, 
  s6_.attribute5 AS attribute5_48, 
  s6_.attribute6 AS attribute6_49 
FROM 
  s_categories s3_ 
  LEFT JOIN s_media s5_ ON s3_.mediaID = s5_.id 
  LEFT JOIN s_categories_attributes s6_ ON s3_.id = s6_.categoryID 
  LEFT JOIN s_categories_avoid_customergroups s8_ ON s3_.id = s8_.categoryID 
  LEFT JOIN s_core_customergroups s7_ ON s7_.id = s8_.customergroupID 
  AND (s7_.id = ?) 
WHERE 
  s3_.active = 1 
  AND s3_.parent = ? 
GROUP BY 
  s3_.parent, 
  s3_.position, 
  s3_.id 
HAVING 
  COUNT(s7_.id) = 0 
ORDER BY 
  s3_.parent ASC, 
  s3_.position ASC, 
  s3_.id ASC
 
array:2 [
  0 => 1
  1 => 7
]
0.0130 ms 
SELECT 
  (
    SELECT 
      COUNT(s0_.id) AS sclr_1 
    FROM 
      s_categories s1_ 
      LEFT JOIN s_articles_categories_ro s2_ ON s1_.id = s2_.categoryID 
      LEFT JOIN s_articles s0_ ON s0_.id = s2_.articleID 
      AND (s0_.active = 1) 
    WHERE 
      s1_.id = s3_.id 
    GROUP BY 
      s1_.id
  ) AS sclr_0, 
  (
    SELECT 
      COUNT(s4_.id) AS sclr_3 
    FROM 
      s_categories s4_ 
    WHERE 
      s4_.parent = s3_.id
  ) AS sclr_2, 
  s3_.sorting_ids AS sorting_ids_4, 
  s3_.hide_sortings AS hide_sortings_5, 
  s3_.facet_ids AS facet_ids_6, 
  s3_.shops AS shops_7, 
  s3_.id AS id_8, 
  s3_.parent AS parent_9, 
  s3_.stream_id AS stream_id_10, 
  s3_.description AS description_11, 
  s3_.position AS position_12, 
  s3_.meta_title AS meta_title_13, 
  s3_.metakeywords AS metakeywords_14, 
  s3_.metadescription AS metadescription_15, 
  s3_.cmsheadline AS cmsheadline_16, 
  s3_.cmstext AS cmstext_17, 
  s3_.active AS active_18, 
  s3_.template AS template_19, 
  s3_.product_box_layout AS product_box_layout_20, 
  s3_.blog AS blog_21, 
  s3_.path AS path_22, 
  s3_.external AS external_23, 
  s3_.external_target AS external_target_24, 
  s3_.hidefilter AS hidefilter_25, 
  s3_.hidetop AS hidetop_26, 
  s3_.changed AS changed_27, 
  s3_.added AS added_28, 
  s3_.mediaID AS mediaID_29, 
  s5_.id AS id_30, 
  s5_.albumID AS albumID_31, 
  s5_.name AS name_32, 
  s5_.description AS description_33, 
  s5_.path AS path_34, 
  s5_.type AS type_35, 
  s5_.extension AS extension_36, 
  s5_.userID AS userID_37, 
  s5_.created AS created_38, 
  s5_.file_size AS file_size_39, 
  s5_.width AS width_40, 
  s5_.height AS height_41, 
  s6_.id AS id_42, 
  s6_.categoryID AS categoryID_43, 
  s6_.attribute1 AS attribute1_44, 
  s6_.attribute2 AS attribute2_45, 
  s6_.attribute3 AS attribute3_46, 
  s6_.attribute4 AS attribute4_47, 
  s6_.attribute5 AS attribute5_48, 
  s6_.attribute6 AS attribute6_49 
FROM 
  s_categories s3_ 
  LEFT JOIN s_media s5_ ON s3_.mediaID = s5_.id 
  LEFT JOIN s_categories_attributes s6_ ON s3_.id = s6_.categoryID 
  LEFT JOIN s_categories_avoid_customergroups s8_ ON s3_.id = s8_.categoryID 
  LEFT JOIN s_core_customergroups s7_ ON s7_.id = s8_.customergroupID 
  AND (s7_.id = ?) 
WHERE 
  s3_.active = 1 
  AND s3_.parent = ? 
GROUP BY 
  s3_.parent, 
  s3_.position, 
  s3_.id 
HAVING 
  COUNT(s7_.id) = 0 
ORDER BY 
  s3_.parent ASC, 
  s3_.position ASC, 
  s3_.id ASC
 
array:2 [
  0 => 1
  1 => 9
]
0.0020 ms 
SELECT 
  (
    SELECT 
      COUNT(s0_.id) AS sclr_1 
    FROM 
      s_categories s1_ 
      LEFT JOIN s_articles_categories_ro s2_ ON s1_.id = s2_.categoryID 
      LEFT JOIN s_articles s0_ ON s0_.id = s2_.articleID 
      AND (s0_.active = 1) 
    WHERE 
      s1_.id = s3_.id 
    GROUP BY 
      s1_.id
  ) AS sclr_0, 
  (
    SELECT 
      COUNT(s4_.id) AS sclr_3 
    FROM 
      s_categories s4_ 
    WHERE 
      s4_.parent = s3_.id
  ) AS sclr_2, 
  s3_.sorting_ids AS sorting_ids_4, 
  s3_.hide_sortings AS hide_sortings_5, 
  s3_.facet_ids AS facet_ids_6, 
  s3_.shops AS shops_7, 
  s3_.id AS id_8, 
  s3_.parent AS parent_9, 
  s3_.stream_id AS stream_id_10, 
  s3_.description AS description_11, 
  s3_.position AS position_12, 
  s3_.meta_title AS meta_title_13, 
  s3_.metakeywords AS metakeywords_14, 
  s3_.metadescription AS metadescription_15, 
  s3_.cmsheadline AS cmsheadline_16, 
  s3_.cmstext AS cmstext_17, 
  s3_.active AS active_18, 
  s3_.template AS template_19, 
  s3_.product_box_layout AS product_box_layout_20, 
  s3_.blog AS blog_21, 
  s3_.path AS path_22, 
  s3_.external AS external_23, 
  s3_.external_target AS external_target_24, 
  s3_.hidefilter AS hidefilter_25, 
  s3_.hidetop AS hidetop_26, 
  s3_.changed AS changed_27, 
  s3_.added AS added_28, 
  s3_.mediaID AS mediaID_29, 
  s5_.id AS id_30, 
  s5_.albumID AS albumID_31, 
  s5_.name AS name_32, 
  s5_.description AS description_33, 
  s5_.path AS path_34, 
  s5_.type AS type_35, 
  s5_.extension AS extension_36, 
  s5_.userID AS userID_37, 
  s5_.created AS created_38, 
  s5_.file_size AS file_size_39, 
  s5_.width AS width_40, 
  s5_.height AS height_41, 
  s6_.id AS id_42, 
  s6_.categoryID AS categoryID_43, 
  s6_.attribute1 AS attribute1_44, 
  s6_.attribute2 AS attribute2_45, 
  s6_.attribute3 AS attribute3_46, 
  s6_.attribute4 AS attribute4_47, 
  s6_.attribute5 AS attribute5_48, 
  s6_.attribute6 AS attribute6_49 
FROM 
  s_categories s3_ 
  LEFT JOIN s_media s5_ ON s3_.mediaID = s5_.id 
  LEFT JOIN s_categories_attributes s6_ ON s3_.id = s6_.categoryID 
  LEFT JOIN s_categories_avoid_customergroups s8_ ON s3_.id = s8_.categoryID 
  LEFT JOIN s_core_customergroups s7_ ON s7_.id = s8_.customergroupID 
  AND (s7_.id = ?) 
WHERE 
  s3_.active = 1 
  AND s3_.parent = ? 
GROUP BY 
  s3_.parent, 
  s3_.position, 
  s3_.id 
HAVING 
  COUNT(s7_.id) = 0 
ORDER BY 
  s3_.parent ASC, 
  s3_.position ASC, 
  s3_.id ASC
 
array:2 [
  0 => 1
  1 => 8
]
0.0016 ms 
SELECT 
  (
    SELECT 
      COUNT(s0_.id) AS sclr_1 
    FROM 
      s_categories s1_ 
      LEFT JOIN s_articles_categories_ro s2_ ON s1_.id = s2_.categoryID 
      LEFT JOIN s_articles s0_ ON s0_.id = s2_.articleID 
      AND (s0_.active = 1) 
    WHERE 
      s1_.id = s3_.id 
    GROUP BY 
      s1_.id
  ) AS sclr_0, 
  (
    SELECT 
      COUNT(s4_.id) AS sclr_3 
    FROM 
      s_categories s4_ 
    WHERE 
      s4_.parent = s3_.id
  ) AS sclr_2, 
  s3_.sorting_ids AS sorting_ids_4, 
  s3_.hide_sortings AS hide_sortings_5, 
  s3_.facet_ids AS facet_ids_6, 
  s3_.shops AS shops_7, 
  s3_.id AS id_8, 
  s3_.parent AS parent_9, 
  s3_.stream_id AS stream_id_10, 
  s3_.description AS description_11, 
  s3_.position AS position_12, 
  s3_.meta_title AS meta_title_13, 
  s3_.metakeywords AS metakeywords_14, 
  s3_.metadescription AS metadescription_15, 
  s3_.cmsheadline AS cmsheadline_16, 
  s3_.cmstext AS cmstext_17, 
  s3_.active AS active_18, 
  s3_.template AS template_19, 
  s3_.product_box_layout AS product_box_layout_20, 
  s3_.blog AS blog_21, 
  s3_.path AS path_22, 
  s3_.external AS external_23, 
  s3_.external_target AS external_target_24, 
  s3_.hidefilter AS hidefilter_25, 
  s3_.hidetop AS hidetop_26, 
  s3_.changed AS changed_27, 
  s3_.added AS added_28, 
  s3_.mediaID AS mediaID_29, 
  s5_.id AS id_30, 
  s5_.albumID AS albumID_31, 
  s5_.name AS name_32, 
  s5_.description AS description_33, 
  s5_.path AS path_34, 
  s5_.type AS type_35, 
  s5_.extension AS extension_36, 
  s5_.userID AS userID_37, 
  s5_.created AS created_38, 
  s5_.file_size AS file_size_39, 
  s5_.width AS width_40, 
  s5_.height AS height_41, 
  s6_.id AS id_42, 
  s6_.categoryID AS categoryID_43, 
  s6_.attribute1 AS attribute1_44, 
  s6_.attribute2 AS attribute2_45, 
  s6_.attribute3 AS attribute3_46, 
  s6_.attribute4 AS attribute4_47, 
  s6_.attribute5 AS attribute5_48, 
  s6_.attribute6 AS attribute6_49 
FROM 
  s_categories s3_ 
  LEFT JOIN s_media s5_ ON s3_.mediaID = s5_.id 
  LEFT JOIN s_categories_attributes s6_ ON s3_.id = s6_.categoryID 
  LEFT JOIN s_categories_avoid_customergroups s8_ ON s3_.id = s8_.categoryID 
  LEFT JOIN s_core_customergroups s7_ ON s7_.id = s8_.customergroupID 
  AND (s7_.id = ?) 
WHERE 
  s3_.active = 1 
  AND s3_.parent = ? 
GROUP BY 
  s3_.parent, 
  s3_.position, 
  s3_.id 
HAVING 
  COUNT(s7_.id) = 0 
ORDER BY 
  s3_.parent ASC, 
  s3_.position ASC, 
  s3_.id ASC
 
array:2 [
  0 => 1
  1 => 5
]
0.0016 ms 
SELECT 
  (
    SELECT 
      COUNT(s0_.id) AS sclr_1 
    FROM 
      s_categories s1_ 
      LEFT JOIN s_articles_categories_ro s2_ ON s1_.id = s2_.categoryID 
      LEFT JOIN s_articles s0_ ON s0_.id = s2_.articleID 
      AND (s0_.active = 1) 
    WHERE 
      s1_.id = s3_.id 
    GROUP BY 
      s1_.id
  ) AS sclr_0, 
  (
    SELECT 
      COUNT(s4_.id) AS sclr_3 
    FROM 
      s_categories s4_ 
    WHERE 
      s4_.parent = s3_.id
  ) AS sclr_2, 
  s3_.sorting_ids AS sorting_ids_4, 
  s3_.hide_sortings AS hide_sortings_5, 
  s3_.facet_ids AS facet_ids_6, 
  s3_.shops AS shops_7, 
  s3_.id AS id_8, 
  s3_.parent AS parent_9, 
  s3_.stream_id AS stream_id_10, 
  s3_.description AS description_11, 
  s3_.position AS position_12, 
  s3_.meta_title AS meta_title_13, 
  s3_.metakeywords AS metakeywords_14, 
  s3_.metadescription AS metadescription_15, 
  s3_.cmsheadline AS cmsheadline_16, 
  s3_.cmstext AS cmstext_17, 
  s3_.active AS active_18, 
  s3_.template AS template_19, 
  s3_.product_box_layout AS product_box_layout_20, 
  s3_.blog AS blog_21, 
  s3_.path AS path_22, 
  s3_.external AS external_23, 
  s3_.external_target AS external_target_24, 
  s3_.hidefilter AS hidefilter_25, 
  s3_.hidetop AS hidetop_26, 
  s3_.changed AS changed_27, 
  s3_.added AS added_28, 
  s3_.mediaID AS mediaID_29, 
  s5_.id AS id_30, 
  s5_.albumID AS albumID_31, 
  s5_.name AS name_32, 
  s5_.description AS description_33, 
  s5_.path AS path_34, 
  s5_.type AS type_35, 
  s5_.extension AS extension_36, 
  s5_.userID AS userID_37, 
  s5_.created AS created_38, 
  s5_.file_size AS file_size_39, 
  s5_.width AS width_40, 
  s5_.height AS height_41, 
  s6_.id AS id_42, 
  s6_.categoryID AS categoryID_43, 
  s6_.attribute1 AS attribute1_44, 
  s6_.attribute2 AS attribute2_45, 
  s6_.attribute3 AS attribute3_46, 
  s6_.attribute4 AS attribute4_47, 
  s6_.attribute5 AS attribute5_48, 
  s6_.attribute6 AS attribute6_49 
FROM 
  s_categories s3_ 
  LEFT JOIN s_media s5_ ON s3_.mediaID = s5_.id 
  LEFT JOIN s_categories_attributes s6_ ON s3_.id = s6_.categoryID 
  LEFT JOIN s_categories_avoid_customergroups s8_ ON s3_.id = s8_.categoryID 
  LEFT JOIN s_core_customergroups s7_ ON s7_.id = s8_.customergroupID 
  AND (s7_.id = ?) 
WHERE 
  s3_.active = 1 
  AND s3_.parent = ? 
GROUP BY 
  s3_.parent, 
  s3_.position, 
  s3_.id 
HAVING 
  COUNT(s7_.id) = 0 
ORDER BY 
  s3_.parent ASC, 
  s3_.position ASC, 
  s3_.id ASC
 
array:2 [
  0 => 1
  1 => 18
]
0.0014 ms 
SELECT 
  (
    SELECT 
      COUNT(s0_.id) AS sclr_1 
    FROM 
      s_categories s1_ 
      LEFT JOIN s_articles_categories_ro s2_ ON s1_.id = s2_.categoryID 
      LEFT JOIN s_articles s0_ ON s0_.id = s2_.articleID 
      AND (s0_.active = 1) 
    WHERE 
      s1_.id = s3_.id 
    GROUP BY 
      s1_.id
  ) AS sclr_0, 
  (
    SELECT 
      COUNT(s4_.id) AS sclr_3 
    FROM 
      s_categories s4_ 
    WHERE 
      s4_.parent = s3_.id
  ) AS sclr_2, 
  s3_.sorting_ids AS sorting_ids_4, 
  s3_.hide_sortings AS hide_sortings_5, 
  s3_.facet_ids AS facet_ids_6, 
  s3_.shops AS shops_7, 
  s3_.id AS id_8, 
  s3_.parent AS parent_9, 
  s3_.stream_id AS stream_id_10, 
  s3_.description AS description_11, 
  s3_.position AS position_12, 
  s3_.meta_title AS meta_title_13, 
  s3_.metakeywords AS metakeywords_14, 
  s3_.metadescription AS metadescription_15, 
  s3_.cmsheadline AS cmsheadline_16, 
  s3_.cmstext AS cmstext_17, 
  s3_.active AS active_18, 
  s3_.template AS template_19, 
  s3_.product_box_layout AS product_box_layout_20, 
  s3_.blog AS blog_21, 
  s3_.path AS path_22, 
  s3_.external AS external_23, 
  s3_.external_target AS external_target_24, 
  s3_.hidefilter AS hidefilter_25, 
  s3_.hidetop AS hidetop_26, 
  s3_.changed AS changed_27, 
  s3_.added AS added_28, 
  s3_.mediaID AS mediaID_29, 
  s5_.id AS id_30, 
  s5_.albumID AS albumID_31, 
  s5_.name AS name_32, 
  s5_.description AS description_33, 
  s5_.path AS path_34, 
  s5_.type AS type_35, 
  s5_.extension AS extension_36, 
  s5_.userID AS userID_37, 
  s5_.created AS created_38, 
  s5_.file_size AS file_size_39, 
  s5_.width AS width_40, 
  s5_.height AS height_41, 
  s6_.id AS id_42, 
  s6_.categoryID AS categoryID_43, 
  s6_.attribute1 AS attribute1_44, 
  s6_.attribute2 AS attribute2_45, 
  s6_.attribute3 AS attribute3_46, 
  s6_.attribute4 AS attribute4_47, 
  s6_.attribute5 AS attribute5_48, 
  s6_.attribute6 AS attribute6_49 
FROM 
  s_categories s3_ 
  LEFT JOIN s_media s5_ ON s3_.mediaID = s5_.id 
  LEFT JOIN s_categories_attributes s6_ ON s3_.id = s6_.categoryID 
  LEFT JOIN s_categories_avoid_customergroups s8_ ON s3_.id = s8_.categoryID 
  LEFT JOIN s_core_customergroups s7_ ON s7_.id = s8_.customergroupID 
  AND (s7_.id = ?) 
WHERE 
  s3_.active = 1 
  AND s3_.parent = ? 
GROUP BY 
  s3_.parent, 
  s3_.position, 
  s3_.id 
HAVING 
  COUNT(s7_.id) = 0 
ORDER BY 
  s3_.parent ASC, 
  s3_.position ASC, 
  s3_.id ASC
 
array:2 [
  0 => 1
  1 => 17
]
0.0014 ms 
SELECT 
  (
    SELECT 
      COUNT(s0_.id) AS sclr_1 
    FROM 
      s_categories s1_ 
      LEFT JOIN s_articles_categories_ro s2_ ON s1_.id = s2_.categoryID 
      LEFT JOIN s_articles s0_ ON s0_.id = s2_.articleID 
      AND (s0_.active = 1) 
    WHERE 
      s1_.id = s3_.id 
    GROUP BY 
      s1_.id
  ) AS sclr_0, 
  (
    SELECT 
      COUNT(s4_.id) AS sclr_3 
    FROM 
      s_categories s4_ 
    WHERE 
      s4_.parent = s3_.id
  ) AS sclr_2, 
  s3_.sorting_ids AS sorting_ids_4, 
  s3_.hide_sortings AS hide_sortings_5, 
  s3_.facet_ids AS facet_ids_6, 
  s3_.shops AS shops_7, 
  s3_.id AS id_8, 
  s3_.parent AS parent_9, 
  s3_.stream_id AS stream_id_10, 
  s3_.description AS description_11, 
  s3_.position AS position_12, 
  s3_.meta_title AS meta_title_13, 
  s3_.metakeywords AS metakeywords_14, 
  s3_.metadescription AS metadescription_15, 
  s3_.cmsheadline AS cmsheadline_16, 
  s3_.cmstext AS cmstext_17, 
  s3_.active AS active_18, 
  s3_.template AS template_19, 
  s3_.product_box_layout AS product_box_layout_20, 
  s3_.blog AS blog_21, 
  s3_.path AS path_22, 
  s3_.external AS external_23, 
  s3_.external_target AS external_target_24, 
  s3_.hidefilter AS hidefilter_25, 
  s3_.hidetop AS hidetop_26, 
  s3_.changed AS changed_27, 
  s3_.added AS added_28, 
  s3_.mediaID AS mediaID_29, 
  s5_.id AS id_30, 
  s5_.albumID AS albumID_31, 
  s5_.name AS name_32, 
  s5_.description AS description_33, 
  s5_.path AS path_34, 
  s5_.type AS type_35, 
  s5_.extension AS extension_36, 
  s5_.userID AS userID_37, 
  s5_.created AS created_38, 
  s5_.file_size AS file_size_39, 
  s5_.width AS width_40, 
  s5_.height AS height_41, 
  s6_.id AS id_42, 
  s6_.categoryID AS categoryID_43, 
  s6_.attribute1 AS attribute1_44, 
  s6_.attribute2 AS attribute2_45, 
  s6_.attribute3 AS attribute3_46, 
  s6_.attribute4 AS attribute4_47, 
  s6_.attribute5 AS attribute5_48, 
  s6_.attribute6 AS attribute6_49 
FROM 
  s_categories s3_ 
  LEFT JOIN s_media s5_ ON s3_.mediaID = s5_.id 
  LEFT JOIN s_categories_attributes s6_ ON s3_.id = s6_.categoryID 
  LEFT JOIN s_categories_avoid_customergroups s8_ ON s3_.id = s8_.categoryID 
  LEFT JOIN s_core_customergroups s7_ ON s7_.id = s8_.customergroupID 
  AND (s7_.id = ?) 
WHERE 
  s3_.active = 1 
  AND s3_.parent = ? 
GROUP BY 
  s3_.parent, 
  s3_.position, 
  s3_.id 
HAVING 
  COUNT(s7_.id) = 0 
ORDER BY 
  s3_.parent ASC, 
  s3_.position ASC, 
  s3_.id ASC
 
array:2 [
  0 => 1
  1 => 16
]
0.0015 ms 
SELECT 
  (
    SELECT 
      COUNT(s0_.id) AS sclr_1 
    FROM 
      s_categories s1_ 
      LEFT JOIN s_articles_categories_ro s2_ ON s1_.id = s2_.categoryID 
      LEFT JOIN s_articles s0_ ON s0_.id = s2_.articleID 
      AND (s0_.active = 1) 
    WHERE 
      s1_.id = s3_.id 
    GROUP BY 
      s1_.id
  ) AS sclr_0, 
  (
    SELECT 
      COUNT(s4_.id) AS sclr_3 
    FROM 
      s_categories s4_ 
    WHERE 
      s4_.parent = s3_.id
  ) AS sclr_2, 
  s3_.sorting_ids AS sorting_ids_4, 
  s3_.hide_sortings AS hide_sortings_5, 
  s3_.facet_ids AS facet_ids_6, 
  s3_.shops AS shops_7, 
  s3_.id AS id_8, 
  s3_.parent AS parent_9, 
  s3_.stream_id AS stream_id_10, 
  s3_.description AS description_11, 
  s3_.position AS position_12, 
  s3_.meta_title AS meta_title_13, 
  s3_.metakeywords AS metakeywords_14, 
  s3_.metadescription AS metadescription_15, 
  s3_.cmsheadline AS cmsheadline_16, 
  s3_.cmstext AS cmstext_17, 
  s3_.active AS active_18, 
  s3_.template AS template_19, 
  s3_.product_box_layout AS product_box_layout_20, 
  s3_.blog AS blog_21, 
  s3_.path AS path_22, 
  s3_.external AS external_23, 
  s3_.external_target AS external_target_24, 
  s3_.hidefilter AS hidefilter_25, 
  s3_.hidetop AS hidetop_26, 
  s3_.changed AS changed_27, 
  s3_.added AS added_28, 
  s3_.mediaID AS mediaID_29, 
  s5_.id AS id_30, 
  s5_.albumID AS albumID_31, 
  s5_.name AS name_32, 
  s5_.description AS description_33, 
  s5_.path AS path_34, 
  s5_.type AS type_35, 
  s5_.extension AS extension_36, 
  s5_.userID AS userID_37, 
  s5_.created AS created_38, 
  s5_.file_size AS file_size_39, 
  s5_.width AS width_40, 
  s5_.height AS height_41, 
  s6_.id AS id_42, 
  s6_.categoryID AS categoryID_43, 
  s6_.attribute1 AS attribute1_44, 
  s6_.attribute2 AS attribute2_45, 
  s6_.attribute3 AS attribute3_46, 
  s6_.attribute4 AS attribute4_47, 
  s6_.attribute5 AS attribute5_48, 
  s6_.attribute6 AS attribute6_49 
FROM 
  s_categories s3_ 
  LEFT JOIN s_media s5_ ON s3_.mediaID = s5_.id 
  LEFT JOIN s_categories_attributes s6_ ON s3_.id = s6_.categoryID 
  LEFT JOIN s_categories_avoid_customergroups s8_ ON s3_.id = s8_.categoryID 
  LEFT JOIN s_core_customergroups s7_ ON s7_.id = s8_.customergroupID 
  AND (s7_.id = ?) 
WHERE 
  s3_.active = 1 
  AND s3_.parent = ? 
GROUP BY 
  s3_.parent, 
  s3_.position, 
  s3_.id 
HAVING 
  COUNT(s7_.id) = 0 
ORDER BY 
  s3_.parent ASC, 
  s3_.position ASC, 
  s3_.id ASC
 
array:2 [
  0 => 1
  1 => 15
]
0.0016 ms 
SELECT 
  s0_.sorting_ids AS sorting_ids_0, 
  s0_.hide_sortings AS hide_sortings_1, 
  s0_.facet_ids AS facet_ids_2, 
  s0_.shops AS shops_3, 
  s0_.id AS id_4, 
  s0_.parent AS parent_5, 
  s0_.stream_id AS stream_id_6, 
  s0_.description AS description_7, 
  s0_.position AS position_8, 
  s0_.meta_title AS meta_title_9, 
  s0_.metakeywords AS metakeywords_10, 
  s0_.metadescription AS metadescription_11, 
  s0_.cmsheadline AS cmsheadline_12, 
  s0_.cmstext AS cmstext_13, 
  s0_.active AS active_14, 
  s0_.template AS template_15, 
  s0_.product_box_layout AS product_box_layout_16, 
  s0_.blog AS blog_17, 
  s0_.path AS path_18, 
  s0_.external AS external_19, 
  s0_.external_target AS external_target_20, 
  s0_.hidefilter AS hidefilter_21, 
  s0_.hidetop AS hidetop_22, 
  s0_.changed AS changed_23, 
  s0_.added AS added_24, 
  s0_.mediaID AS mediaID_25, 
  s1_.id AS id_26, 
  s1_.name AS name_27, 
  s2_.id AS id_28, 
  s2_.ordernumber AS ordernumber_29, 
  s3_.id AS id_30, 
  s3_.name AS name_31, 
  s4_.id AS id_32, 
  s4_.categoryID AS categoryID_33, 
  s4_.attribute1 AS attribute1_34, 
  s4_.attribute2 AS attribute2_35, 
  s4_.attribute3 AS attribute3_36, 
  s4_.attribute4 AS attribute4_37, 
  s4_.attribute5 AS attribute5_38, 
  s4_.attribute6 AS attribute6_39, 
  s5_.show_listing AS show_listing_40, 
  s5_.template_id AS template_id_41, 
  s5_.id AS id_42, 
  s5_.parent_id AS parent_id_43, 
  s5_.active AS active_44, 
  s5_.name AS name_45, 
  s5_.userID AS userID_46, 
  s5_.position AS position_47, 
  s5_.device AS device_48, 
  s5_.fullscreen AS fullscreen_49, 
  s5_.valid_from AS valid_from_50, 
  s5_.is_landingpage AS is_landingpage_51, 
  s5_.seo_title AS seo_title_52, 
  s5_.seo_keywords AS seo_keywords_53, 
  s5_.seo_description AS seo_description_54, 
  s5_.valid_to AS valid_to_55, 
  s5_.create_date AS create_date_56, 
  s5_.modified AS modified_57, 
  s5_.`rows` AS rows_58, 
  s5_.cols AS cols_59, 
  s5_.cell_spacing AS cell_spacing_60, 
  s5_.cell_height AS cell_height_61, 
  s5_.article_height AS article_height_62, 
  s5_.mode AS mode_63, 
  s5_.preview_id AS preview_id_64, 
  s5_.preview_secret AS preview_secret_65, 
  s5_.listing_visibility AS listing_visibility_66, 
  s5_.customer_stream_ids AS customer_stream_ids_67, 
  s5_.replacement AS replacement_68, 
  s6_.id AS id_69, 
  s6_.albumID AS albumID_70, 
  s6_.name AS name_71, 
  s6_.description AS description_72, 
  s6_.path AS path_73, 
  s6_.type AS type_74, 
  s6_.extension AS extension_75, 
  s6_.userID AS userID_76, 
  s6_.created AS created_77, 
  s6_.file_size AS file_size_78, 
  s6_.width AS width_79, 
  s6_.height AS height_80, 
  s7_.id AS id_81, 
  s7_.groupkey AS groupkey_82, 
  s7_.description AS description_83, 
  s7_.tax AS tax_84, 
  s7_.taxinput AS taxinput_85, 
  s7_.mode AS mode_86, 
  s7_.discount AS discount_87, 
  s7_.minimumorder AS minimumorder_88, 
  s7_.minimumordersurcharge AS minimumordersurcharge_89 
FROM 
  s_categories s0_ 
  LEFT JOIN s_articles_categories s8_ ON s0_.id = s8_.categoryID 
  LEFT JOIN s_articles s1_ ON s1_.id = s8_.articleID 
  LEFT JOIN s_articles_details s2_ ON s1_.main_detail_id = s2_.id 
  LEFT JOIN s_articles_supplier s3_ ON s1_.supplierID = s3_.id 
  LEFT JOIN s_categories_attributes s4_ ON s0_.id = s4_.categoryID 
  LEFT JOIN s_emotion_categories s9_ ON s0_.id = s9_.category_id 
  LEFT JOIN s_emotion s5_ ON s5_.id = s9_.emotion_id 
  LEFT JOIN s_media s6_ ON s0_.mediaID = s6_.id 
  LEFT JOIN s_categories_avoid_customergroups s10_ ON s0_.id = s10_.categoryID 
  LEFT JOIN s_core_customergroups s7_ ON s7_.id = s10_.customergroupID 
WHERE 
  s0_.id = ?
 
array:1 [
  0 => 3
]
0.0020 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" => 1
  ":orgPath" => array:9 [
    0 => "sViewport=index"
    1 => "sViewport=cat&sCategory=7"
    2 => "sViewport=cat&sCategory=9"
    3 => "sViewport=cat&sCategory=8"
    4 => "sViewport=cat&sCategory=5"
    5 => "sViewport=cat&sCategory=18"
    6 => "sViewport=cat&sCategory=17"
    7 => "sViewport=cat&sCategory=16"
    8 => "sViewport=cat&sCategory=15"
  ]
]
0.0012 ms 
SELECT 
  s0_.sorting_ids AS sorting_ids_0, 
  s0_.hide_sortings AS hide_sortings_1, 
  s0_.facet_ids AS facet_ids_2, 
  s0_.shops AS shops_3, 
  s0_.id AS id_4, 
  s0_.parent AS parent_5, 
  s0_.stream_id AS stream_id_6, 
  s0_.description AS description_7, 
  s0_.position AS position_8, 
  s0_.meta_title AS meta_title_9, 
  s0_.metakeywords AS metakeywords_10, 
  s0_.metadescription AS metadescription_11, 
  s0_.cmsheadline AS cmsheadline_12, 
  s0_.cmstext AS cmstext_13, 
  s0_.active AS active_14, 
  s0_.template AS template_15, 
  s0_.product_box_layout AS product_box_layout_16, 
  s0_.blog AS blog_17, 
  s0_.path AS path_18, 
  s0_.external AS external_19, 
  s0_.external_target AS external_target_20, 
  s0_.hidefilter AS hidefilter_21, 
  s0_.hidetop AS hidetop_22, 
  s0_.changed AS changed_23, 
  s0_.added AS added_24, 
  s0_.mediaID AS mediaID_25 
FROM 
  s_categories s0_ 
WHERE 
  s0_.path LIKE ? 
  AND s0_.blog = 1
 
array:1 [
  0 => "%|3|%"
]
0.0010 ms 
SELECT 
  manufacturer.id, 
  manufacturer.name, 
  manufacturer.changed 
FROM 
  s_articles_supplier manufacturer 
  INNER JOIN s_articles product ON product.supplierID = manufacturer.id 
  INNER JOIN s_articles_categories_ro categories ON categories.articleID = product.id 
  AND categories.categoryID = : categoryId 
GROUP BY 
  manufacturer.id
 
array:1 [
  ":categoryId" => 3
]
0.0012 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" => 1
  ":orgPath" => array:38 [
    0 => "sViewport=listing&sAction=manufacturer&sSupplier=3"
    1 => "sViewport=listing&sAction=manufacturer&sSupplier=4"
    2 => "sViewport=listing&sAction=manufacturer&sSupplier=5"
    3 => "sViewport=listing&sAction=manufacturer&sSupplier=7"
    4 => "sViewport=listing&sAction=manufacturer&sSupplier=8"
    5 => "sViewport=listing&sAction=manufacturer&sSupplier=9"
    6 => "sViewport=listing&sAction=manufacturer&sSupplier=12"
    7 => "sViewport=listing&sAction=manufacturer&sSupplier=13"
    8 => "sViewport=listing&sAction=manufacturer&sSupplier=14"
    9 => "sViewport=listing&sAction=manufacturer&sSupplier=15"
    10 => "sViewport=listing&sAction=manufacturer&sSupplier=16"
    11 => "sViewport=listing&sAction=manufacturer&sSupplier=17"
    12 => "sViewport=listing&sAction=manufacturer&sSupplier=18"
    13 => "sViewport=listing&sAction=manufacturer&sSupplier=19"
    14 => "sViewport=listing&sAction=manufacturer&sSupplier=20"
    15 => "sViewport=listing&sAction=manufacturer&sSupplier=21"
    16 => "sViewport=listing&sAction=manufacturer&sSupplier=22"
    17 => "sViewport=listing&sAction=manufacturer&sSupplier=23"
    18 => "sViewport=listing&sAction=manufacturer&sSupplier=24"
    19 => "sViewport=listing&sAction=manufacturer&sSupplier=25"
    20 => "sViewport=listing&sAction=manufacturer&sSupplier=26"
    21 => "sViewport=listing&sAction=manufacturer&sSupplier=27"
    22 => "sViewport=listing&sAction=manufacturer&sSupplier=28"
    23 => "sViewport=listing&sAction=manufacturer&sSupplier=29"
    24 => "sViewport=listing&sAction=manufacturer&sSupplier=30"
    25 => "sViewport=listing&sAction=manufacturer&sSupplier=31"
    26 => "sViewport=listing&sAction=manufacturer&sSupplier=32"
    27 => "sViewport=listing&sAction=manufacturer&sSupplier=33"
    28 => "sViewport=listing&sAction=manufacturer&sSupplier=34"
    29 => "sViewport=listing&sAction=manufacturer&sSupplier=35"
    30 => "sViewport=listing&sAction=manufacturer&sSupplier=36"
    31 => "sViewport=listing&sAction=manufacturer&sSupplier=37"
    32 => "sViewport=listing&sAction=manufacturer&sSupplier=38"
    33 => "sViewport=listing&sAction=manufacturer&sSupplier=39"
    34 => "sViewport=listing&sAction=manufacturer&sSupplier=40"
    35 => "sViewport=listing&sAction=manufacturer&sSupplier=41"
    36 => "sViewport=listing&sAction=manufacturer&sSupplier=42"
    37 => "sViewport=listing&sAction=manufacturer&sSupplier=43"
  ]
]
0.0029 ms 
SELECT 
  s0_.show_listing AS show_listing_0, 
  s0_.template_id AS template_id_1, 
  s0_.id AS id_2, 
  s0_.parent_id AS parent_id_3, 
  s0_.active AS active_4, 
  s0_.name AS name_5, 
  s0_.userID AS userID_6, 
  s0_.position AS position_7, 
  s0_.device AS device_8, 
  s0_.fullscreen AS fullscreen_9, 
  s0_.valid_from AS valid_from_10, 
  s0_.is_landingpage AS is_landingpage_11, 
  s0_.seo_title AS seo_title_12, 
  s0_.seo_keywords AS seo_keywords_13, 
  s0_.seo_description AS seo_description_14, 
  s0_.valid_to AS valid_to_15, 
  s0_.create_date AS create_date_16, 
  s0_.modified AS modified_17, 
  s0_.`rows` AS rows_18, 
  s0_.cols AS cols_19, 
  s0_.cell_spacing AS cell_spacing_20, 
  s0_.cell_height AS cell_height_21, 
  s0_.article_height AS article_height_22, 
  s0_.mode AS mode_23, 
  s0_.preview_id AS preview_id_24, 
  s0_.preview_secret AS preview_secret_25, 
  s0_.listing_visibility AS listing_visibility_26, 
  s0_.customer_stream_ids AS customer_stream_ids_27, 
  s0_.replacement AS replacement_28, 
  s1_.id AS id_29, 
  s1_.main_id AS main_id_30, 
  s1_.category_id AS category_id_31, 
  s1_.name AS name_32, 
  s1_.title AS title_33, 
  s1_.position AS position_34, 
  s1_.host AS host_35, 
  s1_.base_path AS base_path_36, 
  s1_.base_url AS base_url_37, 
  s1_.hosts AS hosts_38, 
  s1_.secure AS secure_39, 
  s1_.template_id AS template_id_40, 
  s1_.`default` AS default_41, 
  s1_.active AS active_42, 
  s1_.customer_scope AS customer_scope_43, 
  s2_.id AS id_44, 
  s2_.emotionID AS emotionID_45 
FROM 
  s_emotion s0_ 
  INNER JOIN s_emotion_shops s3_ ON s0_.id = s3_.emotion_id 
  INNER JOIN s_core_shops s1_ ON s1_.id = s3_.shop_id 
  LEFT JOIN s_emotion_attributes s2_ ON s0_.id = s2_.emotionID 
WHERE 
  s0_.is_landingpage = 1 
  AND s0_.active = 1 
  AND s1_.id = ? 
  AND s0_.parent_id IS NULL
 
array:1 [
  0 => 1
]
0.0016 ms 
SELECT 
  element.id as elementId, 
  element.value, 
  elementValues.id as valueId, 
  elementValues.value as configured 
FROM 
  s_core_config_elements element 
  LEFT JOIN s_core_config_values elementValues ON elementValues.element_id = element.id 
  AND elementValues.shop_id = : shopId 
WHERE 
  element.name = : name
 
array:2 [
  ":shopId" => 1
  ":name" => "sitemapLastRefresh"
]
0.0015 ms 
UPDATE 
  s_core_config_values 
SET 
  value = : value 
WHERE 
  id = : id
 
array:2 [
  ":value" => "i:1778202934;"
  ":id" => "809"
]
0.0041 ms 
SELECT 
  category.path 
FROM 
  s_categories category 
WHERE 
  category.id = : id
 
array:1 [
  ":id" => 3
]
0.0010 ms 
SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.value AS value_3 
FROM 
  s_newsletter2go_config t0 
WHERE 
  t0.name = ? 
LIMIT 
  1
 
array:1 [
  0 => "companyId"
]
0.0009 ms 
SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.value AS value_3 
FROM 
  s_newsletter2go_config t0 
WHERE 
  t0.name = ? 
LIMIT 
  1
 
array:1 [
  0 => "trackOrders"
]
0.0005 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.0009 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.0006 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 => 22
    2 => 23
  ]
]
0.0034 ms 
SELECT 
  shop.id, 
  REPLACE(locale.locale, "_", "-") as locale 
FROM 
  s_core_shops shop 
  INNER JOIN s_core_locales locale ON locale.id = shop.locale_id 
WHERE 
  (
    (shop.id = : shopId) 
    OR (shop.main_id = : shopId)
  ) 
  AND (active = 1)
 
array:1 [
  "shopId" => 1
]
0.0011 ms 
SELECT 
  category.path 
FROM 
  s_categories category 
WHERE 
  category.id = : id
 
array:1 [
  ":id" => 3
]
0.0007 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:1 [
    0 => 3
  ]
  ":shopId" => "%|1|%"
]
0.0006 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 
FROM 
  s_categories category 
  LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id 
  LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id 
  LEFT JOIN s_media media ON media.id = category.mediaID 
  LEFT JOIN s_product_streams stream ON category.stream_id = stream.id 
  LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID 
  LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id 
  LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId 
WHERE 
  (
    category.id IN (: categories)
  ) 
  AND (category.active = 1) 
  AND (
    category.shops IS NULL 
    OR category.shops LIKE : shopId
  ) 
GROUP BY 
  category.id
 
array:2 [
  ":categories" => array:6 [
    0 => 3
    1 => 3
    2 => 7
    3 => 17
    4 => 16
    5 => 15
  ]
  ":shopId" => "%|1|%"
]
0.0018 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:6 [
    0 => 3
    1 => 3
    2 => 7
    3 => 17
    4 => 16
    5 => 15
  ]
]
0.0006 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.0023 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.0006 ms 
SELECT 
  tax.id as __tax_id, 
  tax.tax as __tax_tax, 
  tax.description as __tax_description 
FROM 
  s_core_tax tax
 
[]
0.0003 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 OFFSET 0
 
array:5 [
  ":area" => null
  ":country" => null
  ":state" => null
  ":customerGroup" => 1
  ":taxId" => "1"
]
0.0006 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 OFFSET 0
 
array:5 [
  ":area" => null
  ":country" => null
  ":state" => null
  ":customerGroup" => 1
  ":taxId" => "4"
]
0.0005 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.0005 ms 
SELECT 
  page.id, 
  page.description, 
  page.link, 
  page.target, 
  page.parentID, 
  groups.key as `group`, 
  mapping.key as mapping 
FROM 
  s_cms_static page 
  LEFT JOIN s_cms_static_groups `groups` ON groups.active = 1 
  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:2 [
  ":shopId" => 1
  ":staticShopId" => "%|1|%"
]
0.0008 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" => 1
  ":orgPath" => array:9 [
    39 => "sViewport=forms&sFid=9"
    26 => "sViewport=newsletter"
    1 => "sViewport=forms&sFid=5"
    6 => "sViewport=custom&sCustom=6"
    41 => "sViewport=forms&sFid=10"
    8 => "sViewport=custom&sCustom=8"
    7 => "sViewport=custom&sCustom=7"
    4 => "sViewport=custom&sCustom=4"
    3 => "sViewport=custom&sCustom=3"
  ]
]
0.0007 ms 
SELECT 
  expiry, 
  modified 
FROM 
  s_core_sessions 
WHERE 
  id = ?
 
array:1 [
  0 => "6893cbb18f86c3370dcbb8fa217afcbebe73e69c9626c4b300eecf426e4670e1"
]
0.0007 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 = ? 
WHERE 
  ce.type = 0 
ORDER BY 
  name, 
  position
 
array:1 [
  1 => "Core"
]
1.4110 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 = ? 
WHERE 
  ce.type = 0 
ORDER BY 
  name, 
  position
 
array:1 [
  1 => "Frontend"
]
0.6690 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 = ? 
WHERE 
  ce.type = 0 
ORDER BY 
  name, 
  position
 
array:1 [
  1 => "Backend"
]
1.0378 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')
 
[]
1.1039 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.7939 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')
 
[]
1.2469 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.8461 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')
 
[]
1.0259 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.7710 ms 
SELECT 
  `id` 
FROM 
  `s_core_config_elements` 
WHERE 
  `name` LIKE 'routerlastupdate'
 
[]
1.6460 ms 
SELECT 
  v.value 
FROM 
  s_core_config_elements e, 
  s_core_config_values v 
WHERE 
  v.element_id = e.id 
  AND e.id = ? 
  AND v.shop_id = ?
 
array:2 [
  1 => "658"
  2 => 1
]
0.8621 ms