Shopware Profiler

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

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

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

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

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

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

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" => "pk.neonlines.dev"
]

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

array:1 [
  0 => "1"
]

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

array:1 [
  0 => 1
]

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

array:1 [
  0 => 1
]

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

array:1 [
  ":host" => "pk.neonlines.dev"
]

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

array:1 [
  0 => 1
]

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

array:1 [
  0 => 1
]

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

array:1 [
  0 => "en_GB"
]

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

[]

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

array:1 [
  0 => 25
]

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 => 25
]

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 => 25
]

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 => 25
]

(
  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" => 1
  ":pathInfo" => "sitemap_index.xml"
]

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

[]

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

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

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

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

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

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

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

[]

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

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

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

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

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

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

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

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

SELECT 
  * 
FROM 
  ontius_ss_settings 
LIMIT 
  1

[]

SELECT 
  * 
FROM 
  ontius_ss_templates template 
WHERE 
  (template.name = ?)

array:1 [
  0 => "default"
]

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

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

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

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

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

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

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

[]

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

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

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

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

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

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

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

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

SELECT 
  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
  ]
]

SELECT 
  id, 
  changetime 
FROM 
  s_articles product 
WHERE 
  id IN(: productIds)

array:1 [
  "productIds" => array:309 [
    0 => 1
    1 => 2
    2 => 3
    3 => 4
    4 => 8
    5 => 9
    6 => 10
    7 => 11
    8 => 12
    9 => 13
    10 => 14
    11 => 15
    12 => 16
    13 => 19
    14 => 20
    15 => 24
    16 => 25
    17 => 27
    18 => 28
    19 => 71
    20 => 72
    21 => 73
    22 => 74
    23 => 75
    24 => 76
    25 => 77
    26 => 78
    27 => 79
    28 => 80
    29 => 81
    30 => 82
    31 => 83
    32 => 84
    33 => 85
    34 => 86
    35 => 87
    36 => 88
    37 => 89
    38 => 90
    39 => 91
    40 => 92
    41 => 93
    42 => 95
    43 => 97
    44 => 99
    45 => 100
    46 => 101
    47 => 102
    48 => 103
    49 => 104
    50 => 105
    51 => 106
    52 => 107
    53 => 108
    54 => 109
    55 => 110
    56 => 111
    57 => 112
    58 => 113
    59 => 114
    60 => 115
    61 => 118
    62 => 120
    63 => 121
    64 => 122
    65 => 123
    66 => 126
    67 => 127
    68 => 128
    69 => 129
    70 => 130
    71 => 131
    72 => 132
    73 => 133
    74 => 134
    75 => 152
    76 => 165
    77 => 166
    78 => 180
    79 => 183
    80 => 184
    81 => 185
    82 => 186
    83 => 188
    84 => 189
    85 => 190
    86 => 193
    87 => 194
    88 => 200
    89 => 195
    90 => 204
    91 => 205
    92 => 207
    93 => 208
    94 => 209
    95 => 211
    96 => 212
    97 => 213
    98 => 214
    99 => 218
    100 => 220
    101 => 221
    102 => 224
    103 => 225
    104 => 226
    105 => 227
    106 => 229
    107 => 232
    108 => 233
    109 => 234
    110 => 235
    111 => 236
    112 => 237
    113 => 239
    114 => 240
    115 => 243
    116 => 244
    117 => 246
    118 => 247
    119 => 248
    120 => 249
    121 => 258
    122 => 269
    123 => 270
    124 => 271
    125 => 272
    126 => 273
    127 => 274
    128 => 275
    129 => 276
    130 => 277
    131 => 289
    132 => 294
    133 => 295
    134 => 297
    135 => 298
    136 => 299
    137 => 300
    138 => 301
    139 => 307
    140 => 308
    141 => 309
    142 => 310
    143 => 311
    144 => 312
    145 => 313
    146 => 314
    147 => 315
    148 => 316
    149 => 318
    150 => 319
    151 => 320
    152 => 321
    153 => 322
    154 => 323
    155 => 324
    156 => 325
    157 => 327
    158 => 329
    159 => 330
    160 => 332
    161 => 333
    162 => 334
    163 => 335
    164 => 336
    165 => 337
    166 => 338
    167 => 340
    168 => 342
    169 => 344
    170 => 345
    171 => 346
    172 => 348
    173 => 359
    174 => 360
    175 => 361
    176 => 362
    177 => 366
    178 => 367
    179 => 368
    180 => 369
    181 => 371
    182 => 372
    183 => 373
    184 => 375
    185 => 377
    186 => 378
    187 => 380
    188 => 381
    189 => 382
    190 => 383
    191 => 393
    192 => 422
    193 => 423
    194 => 432
    195 => 433
    196 => 434
    197 => 435
    198 => 436
    199 => 437
    200 => 438
    201 => 439
    202 => 440
    203 => 441
    204 => 442
    205 => 443
    206 => 444
    207 => 445
    208 => 447
    209 => 448
    210 => 449
    211 => 450
    212 => 451
    213 => 452
    214 => 453
    215 => 454
    216 => 455
    217 => 456
    218 => 460
    219 => 461
    220 => 462
    221 => 463
    222 => 465
    223 => 470
    224 => 471
    225 => 472
    226 => 473
    227 => 474
    228 => 475
    229 => 476
    230 => 477
    231 => 478
    232 => 479
    233 => 480
    234 => 481
    235 => 482
    236 => 483
    237 => 484
    238 => 485
    239 => 486
    240 => 487
    241 => 488
    242 => 489
    243 => 490
    244 => 491
    245 => 494
    246 => 495
    247 => 499
    248 => 500
    249 => 501
    250 => 504
    251 => 505
    252 => 506
    253 => 507
    254 => 508
    255 => 511
    256 => 514
    257 => 515
    258 => 516
    259 => 518
    260 => 519
    261 => 520
    262 => 521
    263 => 522
    264 => 523
    265 => 524
    266 => 525
    267 => 526
    268 => 527
    269 => 528
    270 => 529
    271 => 531
    272 => 532
    273 => 534
    274 => 535
    275 => 533
    276 => 537
    277 => 539
    278 => 544
    279 => 557
    280 => 558
    281 => 559
    282 => 560
    283 => 561
    284 => 562
    285 => 563
    286 => 564
    287 => 565
    288 => 566
    289 => 567
    290 => 568
    291 => 569
    292 => 570
    293 => 571
    294 => 572
    295 => 573
    296 => 574
    297 => 575
    298 => 577
    299 => 578
    300 => 579
    301 => 580
    302 => 581
    303 => 582
    304 => 583
    305 => 584
    306 => 585
    307 => 586
    308 => 587
  ]
]

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:309 [
    0 => "sViewport=detail&sArticle=276"
    1 => "sViewport=detail&sArticle=275"
    2 => "sViewport=detail&sArticle=232"
    3 => "sViewport=detail&sArticle=227"
    4 => "sViewport=detail&sArticle=226"
    5 => "sViewport=detail&sArticle=225"
    6 => "sViewport=detail&sArticle=337"
    7 => "sViewport=detail&sArticle=336"
    8 => "sViewport=detail&sArticle=333"
    9 => "sViewport=detail&sArticle=120"
    10 => "sViewport=detail&sArticle=115"
    11 => "sViewport=detail&sArticle=224"
    12 => "sViewport=detail&sArticle=213"
    13 => "sViewport=detail&sArticle=229"
    14 => "sViewport=detail&sArticle=456"
    15 => "sViewport=detail&sArticle=447"
    16 => "sViewport=detail&sArticle=448"
    17 => "sViewport=detail&sArticle=450"
    18 => "sViewport=detail&sArticle=451"
    19 => "sViewport=detail&sArticle=452"
    20 => "sViewport=detail&sArticle=453"
    21 => "sViewport=detail&sArticle=454"
    22 => "sViewport=detail&sArticle=455"
    23 => "sViewport=detail&sArticle=423"
    24 => "sViewport=detail&sArticle=470"
    25 => "sViewport=detail&sArticle=471"
    26 => "sViewport=detail&sArticle=472"
    27 => "sViewport=detail&sArticle=473"
    28 => "sViewport=detail&sArticle=475"
    29 => "sViewport=detail&sArticle=480"
    30 => "sViewport=detail&sArticle=477"
    31 => "sViewport=detail&sArticle=476"
    32 => "sViewport=detail&sArticle=481"
    33 => "sViewport=detail&sArticle=482"
    34 => "sViewport=detail&sArticle=335"
    35 => "sViewport=detail&sArticle=334"
    36 => "sViewport=detail&sArticle=313"
    37 => "sViewport=detail&sArticle=314"
    38 => "sViewport=detail&sArticle=234"
    39 => "sViewport=detail&sArticle=121"
    40 => "sViewport=detail&sArticle=485"
    41 => "sViewport=detail&sArticle=486"
    42 => "sViewport=detail&sArticle=487"
    43 => "sViewport=detail&sArticle=488"
    44 => "sViewport=detail&sArticle=494"
    45 => "sViewport=detail&sArticle=474"
    46 => "sViewport=detail&sArticle=479"
    47 => "sViewport=detail&sArticle=478"
    48 => "sViewport=detail&sArticle=258"
    49 => "sViewport=detail&sArticle=449"
    50 => "sViewport=detail&sArticle=299"
    51 => "sViewport=detail&sArticle=298"
    52 => "sViewport=detail&sArticle=248"
    53 => "sViewport=detail&sArticle=233"
    54 => "sViewport=detail&sArticle=507"
    55 => "sViewport=detail&sArticle=123"
    56 => "sViewport=detail&sArticle=122"
    57 => "sViewport=detail&sArticle=393"
    58 => "sViewport=detail&sArticle=489"
    59 => "sViewport=detail&sArticle=500"
    60 => "sViewport=detail&sArticle=460"
    61 => "sViewport=detail&sArticle=465"
    62 => "sViewport=detail&sArticle=483"
    63 => "sViewport=detail&sArticle=484"
    64 => "sViewport=detail&sArticle=505"
    65 => "sViewport=detail&sArticle=214"
    66 => "sViewport=detail&sArticle=220"
    67 => "sViewport=detail&sArticle=218"
    68 => "sViewport=detail&sArticle=212"
    69 => "sViewport=detail&sArticle=211"
    70 => "sViewport=detail&sArticle=209"
    71 => "sViewport=detail&sArticle=208"
    72 => "sViewport=detail&sArticle=207"
    73 => "sViewport=detail&sArticle=194"
    74 => "sViewport=detail&sArticle=188"
    75 => "sViewport=detail&sArticle=185"
    76 => "sViewport=detail&sArticle=184"
    77 => "sViewport=detail&sArticle=183"
    78 => "sViewport=detail&sArticle=166"
    79 => "sViewport=detail&sArticle=118"
    80 => "sViewport=detail&sArticle=490"
    81 => "sViewport=detail&sArticle=491"
    82 => "sViewport=detail&sArticle=523"
    83 => "sViewport=detail&sArticle=504"
    84 => "sViewport=detail&sArticle=111"
    85 => "sViewport=detail&sArticle=516"
    86 => "sViewport=detail&sArticle=519"
    87 => "sViewport=detail&sArticle=506"
    88 => "sViewport=detail&sArticle=235"
    89 => "sViewport=detail&sArticle=236"
    90 => "sViewport=detail&sArticle=237"
    91 => "sViewport=detail&sArticle=239"
    92 => "sViewport=detail&sArticle=240"
    93 => "sViewport=detail&sArticle=246"
    94 => "sViewport=detail&sArticle=307"
    95 => "sViewport=detail&sArticle=309"
    96 => "sViewport=detail&sArticle=311"
    97 => "sViewport=detail&sArticle=247"
    98 => "sViewport=detail&sArticle=249"
    99 => "sViewport=detail&sArticle=528"
    100 => "sViewport=detail&sArticle=190"
    101 => "sViewport=detail&sArticle=524"
    102 => "sViewport=detail&sArticle=520"
    103 => "sViewport=detail&sArticle=527"
    104 => "sViewport=detail&sArticle=526"
    105 => "sViewport=detail&sArticle=525"
    106 => "sViewport=detail&sArticle=522"
    107 => "sViewport=detail&sArticle=518"
    108 => "sViewport=detail&sArticle=189"
    109 => "sViewport=detail&sArticle=193"
    110 => "sViewport=detail&sArticle=273"
    111 => "sViewport=detail&sArticle=501"
    112 => "sViewport=detail&sArticle=463"
    113 => "sViewport=detail&sArticle=462"
    114 => "sViewport=detail&sArticle=109"
    115 => "sViewport=detail&sArticle=108"
    116 => "sViewport=detail&sArticle=107"
    117 => "sViewport=detail&sArticle=103"
    118 => "sViewport=detail&sArticle=300"
    119 => "sViewport=detail&sArticle=186"
    120 => "sViewport=detail&sArticle=529"
    121 => "sViewport=detail&sArticle=244"
    122 => "sViewport=detail&sArticle=243"
    123 => "sViewport=detail&sArticle=221"
    124 => "sViewport=detail&sArticle=205"
    125 => "sViewport=detail&sArticle=200"
    126 => "sViewport=detail&sArticle=165"
    127 => "sViewport=detail&sArticle=445"
    128 => "sViewport=detail&sArticle=444"
    129 => "sViewport=detail&sArticle=442"
    130 => "sViewport=detail&sArticle=439"
    131 => "sViewport=detail&sArticle=443"
    132 => "sViewport=detail&sArticle=495"
    133 => "sViewport=detail&sArticle=441"
    134 => "sViewport=detail&sArticle=440"
    135 => "sViewport=detail&sArticle=438"
    136 => "sViewport=detail&sArticle=437"
    137 => "sViewport=detail&sArticle=435"
    138 => "sViewport=detail&sArticle=436"
    139 => "sViewport=detail&sArticle=434"
    140 => "sViewport=detail&sArticle=422"
    141 => "sViewport=detail&sArticle=433"
    142 => "sViewport=detail&sArticle=432"
    143 => "sViewport=detail&sArticle=204"
    144 => "sViewport=detail&sArticle=180"
    145 => "sViewport=detail&sArticle=461"
    146 => "sViewport=detail&sArticle=114"
    147 => "sViewport=detail&sArticle=113"
    148 => "sViewport=detail&sArticle=106"
    149 => "sViewport=detail&sArticle=105"
    150 => "sViewport=detail&sArticle=104"
    151 => "sViewport=detail&sArticle=332"
    152 => "sViewport=detail&sArticle=508"
    153 => "sViewport=detail&sArticle=312"
    154 => "sViewport=detail&sArticle=308"
    155 => "sViewport=detail&sArticle=310"
    156 => "sViewport=detail&sArticle=301"
    157 => "sViewport=detail&sArticle=297"
    158 => "sViewport=detail&sArticle=295"
    159 => "sViewport=detail&sArticle=294"
    160 => "sViewport=detail&sArticle=277"
    161 => "sViewport=detail&sArticle=274"
    162 => "sViewport=detail&sArticle=272"
    163 => "sViewport=detail&sArticle=271"
    164 => "sViewport=detail&sArticle=270"
    165 => "sViewport=detail&sArticle=269"
    166 => "sViewport=detail&sArticle=521"
    167 => "sViewport=detail&sArticle=195"
    168 => "sViewport=detail&sArticle=289"
    169 => "sViewport=detail&sArticle=499"
    170 => "sViewport=detail&sArticle=112"
    171 => "sViewport=detail&sArticle=110"
    172 => "sViewport=detail&sArticle=532"
    173 => "sViewport=detail&sArticle=531"
    174 => "sViewport=detail&sArticle=340"
    175 => "sViewport=detail&sArticle=338"
    176 => "sViewport=detail&sArticle=564"
    177 => "sViewport=detail&sArticle=4"
    178 => "sViewport=detail&sArticle=515"
    179 => "sViewport=detail&sArticle=368"
    180 => "sViewport=detail&sArticle=127"
    181 => "sViewport=detail&sArticle=12"
    182 => "sViewport=detail&sArticle=375"
    183 => "sViewport=detail&sArticle=383"
    184 => "sViewport=detail&sArticle=316"
    185 => "sViewport=detail&sArticle=557"
    186 => "sViewport=detail&sArticle=10"
    187 => "sViewport=detail&sArticle=126"
    188 => "sViewport=detail&sArticle=320"
    189 => "sViewport=detail&sArticle=8"
    190 => "sViewport=detail&sArticle=563"
    191 => "sViewport=detail&sArticle=373"
    192 => "sViewport=detail&sArticle=371"
    193 => "sViewport=detail&sArticle=342"
    194 => "sViewport=detail&sArticle=322"
    195 => "sViewport=detail&sArticle=315"
    196 => "sViewport=detail&sArticle=325"
    197 => "sViewport=detail&sArticle=128"
    198 => "sViewport=detail&sArticle=321"
    199 => "sViewport=detail&sArticle=562"
    200 => "sViewport=detail&sArticle=319"
    201 => "sViewport=detail&sArticle=1"
    202 => "sViewport=detail&sArticle=561"
    203 => "sViewport=detail&sArticle=560"
    204 => "sViewport=detail&sArticle=9"
    205 => "sViewport=detail&sArticle=327"
    206 => "sViewport=detail&sArticle=3"
    207 => "sViewport=detail&sArticle=2"
    208 => "sViewport=detail&sArticle=559"
    209 => "sViewport=detail&sArticle=367"
    210 => "sViewport=detail&sArticle=369"
    211 => "sViewport=detail&sArticle=558"
    212 => "sViewport=detail&sArticle=318"
    213 => "sViewport=detail&sArticle=11"
    214 => "sViewport=detail&sArticle=372"
    215 => "sViewport=detail&sArticle=324"
    216 => "sViewport=detail&sArticle=129"
    217 => "sViewport=detail&sArticle=323"
    218 => "sViewport=detail&sArticle=366"
    219 => "sViewport=detail&sArticle=345"
    220 => "sViewport=detail&sArticle=346"
    221 => "sViewport=detail&sArticle=377"
    222 => "sViewport=detail&sArticle=14"
    223 => "sViewport=detail&sArticle=19"
    224 => "sViewport=detail&sArticle=378"
    225 => "sViewport=detail&sArticle=13"
    226 => "sViewport=detail&sArticle=566"
    227 => "sViewport=detail&sArticle=15"
    228 => "sViewport=detail&sArticle=344"
    229 => "sViewport=detail&sArticle=131"
    230 => "sViewport=detail&sArticle=132"
    231 => "sViewport=detail&sArticle=130"
    232 => "sViewport=detail&sArticle=348"
    233 => "sViewport=detail&sArticle=16"
    234 => "sViewport=detail&sArticle=567"
    235 => "sViewport=detail&sArticle=533"
    236 => "sViewport=detail&sArticle=535"
    237 => "sViewport=detail&sArticle=534"
    238 => "sViewport=detail&sArticle=539"
    239 => "sViewport=detail&sArticle=544"
    240 => "sViewport=detail&sArticle=537"
    241 => "sViewport=detail&sArticle=72"
    242 => "sViewport=detail&sArticle=71"
    243 => "sViewport=detail&sArticle=568"
    244 => "sViewport=detail&sArticle=73"
    245 => "sViewport=detail&sArticle=74"
    246 => "sViewport=detail&sArticle=570"
    247 => "sViewport=detail&sArticle=569"
    248 => "sViewport=detail&sArticle=514"
    249 => "sViewport=detail&sArticle=76"
    250 => "sViewport=detail&sArticle=77"
    251 => "sViewport=detail&sArticle=571"
    252 => "sViewport=detail&sArticle=75"
    253 => "sViewport=detail&sArticle=572"
    254 => "sViewport=detail&sArticle=83"
    255 => "sViewport=detail&sArticle=80"
    256 => "sViewport=detail&sArticle=578"
    257 => "sViewport=detail&sArticle=78"
    258 => "sViewport=detail&sArticle=84"
    259 => "sViewport=detail&sArticle=577"
    260 => "sViewport=detail&sArticle=81"
    261 => "sViewport=detail&sArticle=79"
    262 => "sViewport=detail&sArticle=85"
    263 => "sViewport=detail&sArticle=82"
    264 => "sViewport=detail&sArticle=580"
    265 => "sViewport=detail&sArticle=88"
    266 => "sViewport=detail&sArticle=86"
    267 => "sViewport=detail&sArticle=581"
    268 => "sViewport=detail&sArticle=583"
    269 => "sViewport=detail&sArticle=89"
    270 => "sViewport=detail&sArticle=582"
    271 => "sViewport=detail&sArticle=91"
    272 => "sViewport=detail&sArticle=92"
    273 => "sViewport=detail&sArticle=587"
    274 => "sViewport=detail&sArticle=101"
    275 => "sViewport=detail&sArticle=102"
    276 => "sViewport=detail&sArticle=100"
    277 => "sViewport=detail&sArticle=99"
    278 => "sViewport=detail&sArticle=93"
    279 => "sViewport=detail&sArticle=87"
    280 => "sViewport=detail&sArticle=586"
    281 => "sViewport=detail&sArticle=90"
    282 => "sViewport=detail&sArticle=95"
    283 => "sViewport=detail&sArticle=584"
    284 => "sViewport=detail&sArticle=97"
    285 => "sViewport=detail&sArticle=585"
    286 => "sViewport=detail&sArticle=579"
    287 => "sViewport=detail&sArticle=575"
    288 => "sViewport=detail&sArticle=511"
    289 => "sViewport=detail&sArticle=574"
    290 => "sViewport=detail&sArticle=573"
    291 => "sViewport=detail&sArticle=28"
    292 => "sViewport=detail&sArticle=382"
    293 => "sViewport=detail&sArticle=381"
    294 => "sViewport=detail&sArticle=330"
    295 => "sViewport=detail&sArticle=380"
    296 => "sViewport=detail&sArticle=134"
    297 => "sViewport=detail&sArticle=360"
    298 => "sViewport=detail&sArticle=20"
    299 => "sViewport=detail&sArticle=362"
    300 => "sViewport=detail&sArticle=359"
    301 => "sViewport=detail&sArticle=361"
    302 => "sViewport=detail&sArticle=565"
    303 => "sViewport=detail&sArticle=24"
    304 => "sViewport=detail&sArticle=25"
    305 => "sViewport=detail&sArticle=133"
    306 => "sViewport=detail&sArticle=329"
    307 => "sViewport=detail&sArticle=27"
    308 => "sViewport=detail&sArticle=152"
  ]
]

SELECT 
  * 
FROM 
  s_sitemap_exclude

[]

SELECT 
  * 
FROM 
  s_sitemap_custom

[]

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

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
]

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, 
  s6_.pk_leadtext_overline AS pk_leadtext_overline_50, 
  s6_.pk_leadtext_headline AS pk_leadtext_headline_51, 
  s6_.pk_leadtext_text AS pk_leadtext_text_52, 
  s6_.pk_morecategories AS pk_morecategories_53, 
  s6_.pk_leadtext_subline AS pk_leadtext_subline_54 
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
]

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, 
  s6_.pk_leadtext_overline AS pk_leadtext_overline_50, 
  s6_.pk_leadtext_headline AS pk_leadtext_headline_51, 
  s6_.pk_leadtext_text AS pk_leadtext_text_52, 
  s6_.pk_morecategories AS pk_morecategories_53, 
  s6_.pk_leadtext_subline AS pk_leadtext_subline_54 
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