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" => "titan.sw5.dev.orangebytes.de"
]

SELECT 
  s0_.id AS id_0, 
  s0_.main_id AS main_id_1, 
  s0_.category_id AS category_id_2, 
  s0_.name AS name_3, 
  s0_.title AS title_4, 
  s0_.position AS position_5, 
  s0_.host AS host_6, 
  s0_.base_path AS base_path_7, 
  s0_.base_url AS base_url_8, 
  s0_.hosts AS hosts_9, 
  s0_.secure AS secure_10, 
  s0_.template_id AS template_id_11, 
  s0_.`default` AS default_12, 
  s0_.active AS active_13, 
  s0_.customer_scope AS customer_scope_14, 
  s0_.id AS id_15, 
  s0_.main_id AS main_id_16, 
  s0_.category_id AS category_id_17, 
  s0_.name AS name_18, 
  s0_.title AS title_19, 
  s0_.position AS position_20, 
  s0_.host AS host_21, 
  s0_.base_path AS base_path_22, 
  s0_.base_url AS base_url_23, 
  s0_.hosts AS hosts_24, 
  s0_.secure AS secure_25, 
  s0_.template_id AS template_id_26, 
  s0_.`default` AS default_27, 
  s0_.active AS active_28, 
  s0_.customer_scope AS customer_scope_29, 
  s1_.id AS id_30, 
  s1_.main_id AS main_id_31, 
  s1_.category_id AS category_id_32, 
  s1_.name AS name_33, 
  s1_.title AS title_34, 
  s1_.position AS position_35, 
  s1_.host AS host_36, 
  s1_.base_path AS base_path_37, 
  s1_.base_url AS base_url_38, 
  s1_.hosts AS hosts_39, 
  s1_.secure AS secure_40, 
  s1_.template_id AS template_id_41, 
  s1_.`default` AS default_42, 
  s1_.active AS active_43, 
  s1_.customer_scope AS customer_scope_44, 
  s2_.id AS id_45, 
  s2_.locale AS locale_46, 
  s2_.language AS language_47, 
  s2_.territory AS territory_48, 
  s3_.id AS id_49, 
  s3_.currency AS currency_50, 
  s3_.name AS name_51, 
  s3_.standard AS standard_52, 
  s3_.factor AS factor_53, 
  s3_.templatechar AS templatechar_54, 
  s3_.symbol_position AS symbol_position_55, 
  s3_.position AS position_56, 
  s4_.id AS id_57, 
  s4_.groupkey AS groupkey_58, 
  s4_.description AS description_59, 
  s4_.tax AS tax_60, 
  s4_.taxinput AS taxinput_61, 
  s4_.mode AS mode_62, 
  s4_.discount AS discount_63, 
  s4_.minimumorder AS minimumorder_64, 
  s4_.minimumordersurcharge AS minimumordersurcharge_65, 
  s5_.id AS id_66, 
  s5_.template AS template_67, 
  s5_.name AS name_68, 
  s5_.description AS description_69, 
  s5_.author AS author_70, 
  s5_.license AS license_71, 
  s5_.esi AS esi_72, 
  s5_.style_support AS style_support_73, 
  s5_.emotion AS emotion_74, 
  s5_.version AS version_75, 
  s5_.plugin_id AS plugin_id_76, 
  s5_.parent_id AS parent_id_77, 
  s6_.id AS id_78, 
  s6_.template AS template_79, 
  s6_.name AS name_80, 
  s6_.description AS description_81, 
  s6_.author AS author_82, 
  s6_.license AS license_83, 
  s6_.esi AS esi_84, 
  s6_.style_support AS style_support_85, 
  s6_.emotion AS emotion_86, 
  s6_.version AS version_87, 
  s6_.plugin_id AS plugin_id_88, 
  s6_.parent_id AS parent_id_89, 
  s7_.id AS id_90, 
  s7_.currency AS currency_91, 
  s7_.name AS name_92, 
  s7_.standard AS standard_93, 
  s7_.factor AS factor_94, 
  s7_.templatechar AS templatechar_95, 
  s7_.symbol_position AS symbol_position_96, 
  s7_.position AS position_97, 
  s0_.main_id AS main_id_98, 
  s0_.template_id AS template_id_99, 
  s0_.document_template_id AS document_template_id_100, 
  s0_.category_id AS category_id_101, 
  s0_.locale_id AS locale_id_102, 
  s0_.currency_id AS currency_id_103, 
  s0_.customer_group_id AS customer_group_id_104, 
  s0_.fallback_id AS fallback_id_105, 
  s1_.main_id AS main_id_106, 
  s1_.template_id AS template_id_107, 
  s1_.document_template_id AS document_template_id_108, 
  s1_.category_id AS category_id_109, 
  s1_.locale_id AS locale_id_110, 
  s1_.currency_id AS currency_id_111, 
  s1_.customer_group_id AS customer_group_id_112, 
  s1_.fallback_id AS fallback_id_113, 
  s5_.parent_id AS parent_id_114, 
  s5_.plugin_id AS plugin_id_115, 
  s6_.parent_id AS parent_id_116, 
  s6_.plugin_id AS plugin_id_117 
FROM 
  s_core_shops s0_ 
  LEFT JOIN s_core_shops s1_ ON s0_.main_id = s1_.id 
  LEFT JOIN s_core_locales s2_ ON s0_.locale_id = s2_.id 
  LEFT JOIN s_core_currencies s3_ ON s0_.currency_id = s3_.id 
  LEFT JOIN s_core_customergroups s4_ ON s0_.customer_group_id = s4_.id 
  LEFT JOIN s_core_templates s5_ ON s1_.template_id = s5_.id 
  LEFT JOIN s_core_templates s6_ ON s1_.document_template_id = s6_.id 
  LEFT JOIN s_core_shop_currencies s8_ ON s1_.id = s8_.shop_id 
  LEFT JOIN s_core_currencies s7_ ON s7_.id = s8_.currency_id 
WHERE 
  s0_.id = ? 
ORDER BY 
  s7_.position ASC, 
  s7_.id ASC

array:1 [
  0 => "3"
]

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

array:1 [
  0 => 3
]

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" => "titan.sw5.dev.orangebytes.de"
]

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

array:1 [
  0 => 3
]

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

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
]

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
]

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
]

(
  SELECT 
    subshopID as shopId, 
    path, 
    org_path as orgPath, 
    main 
  FROM 
    s_core_rewrite_urls 
  WHERE 
    path LIKE : pathInfo 
  ORDER BY 
    subshopID = : shopId DESC, 
    main DESC 
  LIMIT 
    1
) 
UNION ALL 
  (
    SELECT 
      subshopID as shopId, 
      path, 
      org_path as orgPath, 
      0 as main 
    FROM 
      s_core_rewrite_urls 
    WHERE 
      path LIKE CONCAT(
        TRIM(
          TRAILING "/" 
          FROM 
            : pathInfo
        ), 
        "%"
      ) 
    ORDER BY 
      subshopID = : shopId DESC, 
      LENGTH(path), 
      main DESC 
    LIMIT 
      1
  )

array:2 [
  ":shopId" => 3
  ":pathInfo" => "account"
]

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, 
  media.id as __media_id, 
  media.albumID as __media_albumID, 
  media.name as __media_name, 
  media.description as __media_description, 
  media.path as __media_path, 
  media.type as __media_type, 
  media.extension as __media_extension, 
  media.file_size as __media_file_size, 
  media.width as __media_width, 
  media.height as __media_height, 
  media.userID as __media_userID, 
  media.created as __media_created, 
  mediaSettings.id as __mediaSettings_id, 
  mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, 
  mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, 
  mediaSettings.icon as __mediaSettings_icon, 
  mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, 
  mediaAttribute.id as __mediaAttribute_id, 
  mediaAttribute.mediaID as __mediaAttribute_mediaID 
FROM 
  s_core_shops shop 
  LEFT JOIN s_core_shops_attributes shopAttribute ON shopAttribute.shopID = shop.id 
  LEFT JOIN s_core_currencies currency ON currency.id = shop.currency_id 
  LEFT JOIN s_core_templates template ON shop.template_id = template.id 
  LEFT JOIN s_core_locales locale ON locale.id = shop.locale_id 
  LEFT JOIN s_core_customergroups customerGroup ON customerGroup.id = shop.customer_group_id 
  LEFT JOIN s_categories category ON category.id = shop.category_id 
  LEFT JOIN s_core_customergroups_attributes customerGroupAttribute ON customerGroupAttribute.customerGroupID = customerGroup.id 
  LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id 
  LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id 
  LEFT JOIN s_media media ON media.id = category.mediaID 
  LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID 
  LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id 
WHERE 
  shop.id IN (: ids)

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

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

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 
  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 
  coreConfigElements.name, 
  coreConfigValues.value 
FROM 
  s_core_config_values coreConfigValues 
  INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  (corePlugins.name = : dcValue1) 
  AND (
    coreConfigValues.shop_id = : dcValue2
  )

array:2 [
  "dcValue1" => "InputFilter"
  "dcValue2" => 3
]

SELECT 
  coreConfigElements.name, 
  coreConfigValues.value 
FROM 
  s_core_config_values coreConfigValues 
  INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id 
  INNER JOIN s_core_shops coreShops ON coreConfigValues.shop_id = coreShops.main_id 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  (corePlugins.name = : dcValue1) 
  AND (coreShops.id = : dcValue2)

array:2 [
  "dcValue1" => "InputFilter"
  "dcValue2" => 3
]

SELECT 
  coreConfigElements.name, 
  coreConfigValues.value 
FROM 
  s_core_config_values coreConfigValues 
  INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  (
    corePlugins.name = : pluginName3425890772
  ) 
  AND (
    coreConfigValues.shop_id = : shopId2212294583
  )

array:2 [
  "pluginName3425890772" => "InputFilter"
  "shopId2212294583" => 1
]

SELECT 
  coreConfigElements.name, 
  coreConfigElements.value 
FROM 
  s_core_config_elements coreConfigElements 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  corePlugins.name = : pluginName3425890772

array:1 [
  "pluginName3425890772" => "InputFilter"
]

SELECT 
  coreConfigElements.name, 
  coreConfigValues.value 
FROM 
  s_core_config_values coreConfigValues 
  INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  (corePlugins.name = : dcValue1) 
  AND (
    coreConfigValues.shop_id = : dcValue2
  )

array:2 [
  "dcValue1" => "Statistics"
  "dcValue2" => 3
]

SELECT 
  coreConfigElements.name, 
  coreConfigValues.value 
FROM 
  s_core_config_values coreConfigValues 
  INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id 
  INNER JOIN s_core_shops coreShops ON coreConfigValues.shop_id = coreShops.main_id 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  (corePlugins.name = : dcValue1) 
  AND (coreShops.id = : dcValue2)

array:2 [
  "dcValue1" => "Statistics"
  "dcValue2" => 3
]

SELECT 
  coreConfigElements.name, 
  coreConfigValues.value 
FROM 
  s_core_config_values coreConfigValues 
  INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  (
    corePlugins.name = : pluginName2911799538
  ) 
  AND (
    coreConfigValues.shop_id = : shopId2212294583
  )

array:2 [
  "pluginName2911799538" => "Statistics"
  "shopId2212294583" => 1
]

SELECT 
  coreConfigElements.name, 
  coreConfigElements.value 
FROM 
  s_core_config_elements coreConfigElements 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  corePlugins.name = : pluginName2911799538

array:1 [
  "pluginName2911799538" => "Statistics"
]

SELECT 
  id 
FROM 
  s_core_locales 
WHERE 
  locale = "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 
  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 
  element.template_id, 
  element.name, 
  element_value.value, 
  element.default_value as defaultValue, 
  element.type 
FROM 
  s_core_templates_config_elements element 
  LEFT JOIN s_core_templates_config_values element_value ON element_value.element_id = element.id 
  AND element_value.shop_id = : shopId 
WHERE 
  element.template_id IN (: ids)

array:2 [
  ":shopId" => 1
  ":ids" => array:3 [
    0 => 24
    1 => 23
    2 => 22
  ]
]

SELECT 
  id 
FROM 
  s_core_customergroups 
WHERE 
  `groupkey` = ?

array:1 [
  0 => null
]

SELECT 
  id 
FROM 
  s_core_countries country

[]

SELECT 
  country.id as __country_id, 
  country.countryname as __country_countryname, 
  country.countryiso as __country_countryiso, 
  country.areaID as __country_areaID, 
  country.countryen as __country_countryen, 
  country.position as __country_position, 
  country.notice as __country_notice, 
  country.taxfree as __country_taxfree, 
  country.taxfree_ustid as __country_taxfree_ustid, 
  country.taxfree_ustid_checked as __country_taxfree_ustid_checked, 
  country.active as __country_active, 
  country.iso3 as __country_iso3, 
  country.display_state_in_registration as __country_display_state_in_registration, 
  country.force_state_in_registration as __country_force_state_in_registration, 
  country.allow_shipping as __country_allow_shipping, 
  countryAttribute.id as __countryAttribute_id, 
  countryAttribute.countryID as __countryAttribute_countryID, 
  translation69e32194be5d8config_countries.objectdata as __country_translation, 
  translation69e32194be5defallbackconfig_countries.objectdata as __country_translation_fallback, 
  translation69e32194be5e1s_core_countries_attributes.objectdata as __countryAttribute_translation, 
  translation69e32194be5e3fallbacks_core_countries_attributes.objectdata as __countryAttribute_translation_fallback 
FROM 
  s_core_countries country 
  LEFT JOIN s_core_countries_attributes countryAttribute ON countryAttribute.countryID = country.id 
  LEFT JOIN s_core_translations translation69e32194be5d8config_countries ON translation69e32194be5d8config_countries.objecttype = : translation69e32194be5d8config_countries 
  AND translation69e32194be5d8config_countries.objectkey = 1 
  AND translation69e32194be5d8config_countries.objectlanguage = : language 
  LEFT JOIN s_core_translations translation69e32194be5defallbackconfig_countries ON translation69e32194be5defallbackconfig_countries.objecttype = : translation69e32194be5defallbackconfig_countries 
  AND translation69e32194be5defallbackconfig_countries.objectkey = 1 
  AND translation69e32194be5defallbackconfig_countries.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation69e32194be5e1s_core_countries_attributes ON translation69e32194be5e1s_core_countries_attributes.objecttype = : translation69e32194be5e1s_core_countries_attributes 
  AND translation69e32194be5e1s_core_countries_attributes.objectkey = country.id 
  AND translation69e32194be5e1s_core_countries_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation69e32194be5e3fallbacks_core_countries_attributes ON translation69e32194be5e3fallbacks_core_countries_attributes.objecttype = : translation69e32194be5e3fallbacks_core_countries_attributes 
  AND translation69e32194be5e3fallbacks_core_countries_attributes.objectkey = country.id 
  AND translation69e32194be5e3fallbacks_core_countries_attributes.objectlanguage = : languagefallback 
WHERE 
  country.id IN (: ids)

array:7 [
  ":ids" => array:250 [
    0 => "2"
    1 => "3"
    2 => "4"
    3 => "15"
    4 => "16"
    5 => "20"
    6 => "28"
    7 => "32"
    8 => "36"
    9 => "37"
    10 => "46"
    11 => "47"
    12 => "48"
    13 => "49"
    14 => "50"
    15 => "51"
    16 => "52"
    17 => "53"
    18 => "54"
    19 => "55"
    20 => "56"
    21 => "57"
    22 => "58"
    23 => "59"
    24 => "60"
    25 => "61"
    26 => "62"
    27 => "63"
    28 => "64"
    29 => "65"
    30 => "66"
    31 => "67"
    32 => "68"
    33 => "69"
    34 => "70"
    35 => "71"
    36 => "72"
    37 => "73"
    38 => "74"
    39 => "75"
    40 => "76"
    41 => "77"
    42 => "78"
    43 => "79"
    44 => "80"
    45 => "81"
    46 => "82"
    47 => "83"
    48 => "84"
    49 => "85"
    50 => "86"
    51 => "87"
    52 => "88"
    53 => "89"
    54 => "90"
    55 => "91"
    56 => "92"
    57 => "93"
    58 => "94"
    59 => "95"
    60 => "96"
    61 => "97"
    62 => "98"
    63 => "99"
    64 => "100"
    65 => "101"
    66 => "102"
    67 => "103"
    68 => "104"
    69 => "105"
    70 => "106"
    71 => "107"
    72 => "108"
    73 => "109"
    74 => "110"
    75 => "111"
    76 => "112"
    77 => "113"
    78 => "114"
    79 => "115"
    80 => "116"
    81 => "117"
    82 => "118"
    83 => "119"
    84 => "120"
    85 => "121"
    86 => "122"
    87 => "123"
    88 => "124"
    89 => "125"
    90 => "126"
    91 => "127"
    92 => "128"
    93 => "129"
    94 => "130"
    95 => "131"
    96 => "132"
    97 => "133"
    98 => "134"
    99 => "135"
    100 => "136"
    101 => "137"
    102 => "138"
    103 => "139"
    104 => "140"
    105 => "141"
    106 => "142"
    107 => "143"
    108 => "144"
    109 => "145"
    110 => "146"
    111 => "147"
    112 => "148"
    113 => "149"
    114 => "150"
    115 => "151"
    116 => "152"
    117 => "153"
    118 => "154"
    119 => "155"
    120 => "156"
    121 => "157"
    122 => "158"
    123 => "159"
    124 => "160"
    125 => "161"
    126 => "162"
    127 => "163"
    128 => "164"
    129 => "165"
    130 => "166"
    131 => "167"
    132 => "168"
    133 => "169"
    134 => "170"
    135 => "171"
    136 => "172"
    137 => "173"
    138 => "174"
    139 => "175"
    140 => "176"
    141 => "177"
    142 => "178"
    143 => "179"
    144 => "180"
    145 => "181"
    146 => "182"
    147 => "183"
    148 => "184"
    149 => "185"
    150 => "186"
    151 => "187"
    152 => "188"
    153 => "189"
    154 => "190"
    155 => "191"
    156 => "192"
    157 => "193"
    158 => "194"
    159 => "195"
    160 => "196"
    161 => "197"
    162 => "198"
    163 => "199"
    164 => "200"
    165 => "201"
    166 => "202"
    167 => "203"
    168 => "204"
    169 => "205"
    170 => "206"
    171 => "207"
    172 => "208"
    173 => "209"
    174 => "210"
    175 => "211"
    176 => "212"
    177 => "213"
    178 => "214"
    179 => "215"
    180 => "216"
    181 => "217"
    182 => "218"
    183 => "219"
    184 => "220"
    185 => "221"
    186 => "222"
    187 => "223"
    188 => "224"
    189 => "225"
    190 => "226"
    191 => "227"
    192 => "228"
    193 => "229"
    194 => "230"
    195 => "231"
    196 => "232"
    197 => "233"
    198 => "234"
    199 => "235"
    200 => "236"
    201 => "237"
    202 => "238"
    203 => "239"
    204 => "240"
    205 => "241"
    206 => "242"
    207 => "243"
    208 => "244"
    209 => "245"
    210 => "246"
    211 => "247"
    212 => "248"
    213 => "249"
    214 => "250"
    215 => "251"
    216 => "252"
    217 => "253"
    218 => "254"
    219 => "5"
    220 => "7"
    221 => "8"
    222 => "9"
    223 => "10"
    224 => "11"
    225 => "12"
    226 => "13"
    227 => "14"
    228 => "18"
    229 => "21"
    230 => "22"
    231 => "23"
    232 => "24"
    233 => "25"
    234 => "26"
    235 => "27"
    236 => "29"
    237 => "30"
    238 => "31"
    239 => "33"
    240 => "34"
    241 => "35"
    242 => "38"
    243 => "39"
    244 => "40"
    245 => "41"
    246 => "42"
    247 => "43"
    248 => "44"
    249 => "45"
  ]
  ":language" => 3
  ":translation69e32194be5d8config_countries" => "config_countries"
  ":languagefallback" => 0
  ":translation69e32194be5defallbackconfig_countries" => "config_countries"
  ":translation69e32194be5e1s_core_countries_attributes" => "s_core_countries_attributes"
  ":translation69e32194be5e3fallbacks_core_countries_attributes" => "s_core_countries_attributes"
]

SELECT 
  countryState.id as __countryState_id, 
  countryState.countryID as __countryState_countryID, 
  countryState.name as __countryState_name, 
  countryState.shortcode as __countryState_shortcode, 
  countryState.position as __countryState_position, 
  countryState.active as __countryState_active, 
  countryStateAttribute.id as __countryStateAttribute_id, 
  countryStateAttribute.stateID as __countryStateAttribute_stateID, 
  translation69e32194c0c39config_country_states.objectdata as __countryState_translation, 
  translation69e32194c0c3efallbackconfig_country_states.objectdata as __countryState_translation_fallback, 
  translation69e32194c0c41s_core_countries_states_attributes.objectdata as __countryStateAttribute_translation, 
  translation69e32194c0c43fallbacks_core_countries_states_attributes.objectdata as __countryStateAttribute_translation_fallback 
FROM 
  s_core_countries_states countryState 
  LEFT JOIN s_core_countries_states_attributes countryStateAttribute ON countryStateAttribute.stateID = countryState.id 
  LEFT JOIN s_core_translations translation69e32194c0c39config_country_states ON translation69e32194c0c39config_country_states.objecttype = : translation69e32194c0c39config_country_states 
  AND translation69e32194c0c39config_country_states.objectkey = 1 
  AND translation69e32194c0c39config_country_states.objectlanguage = : language 
  LEFT JOIN s_core_translations translation69e32194c0c3efallbackconfig_country_states ON translation69e32194c0c3efallbackconfig_country_states.objecttype = : translation69e32194c0c3efallbackconfig_country_states 
  AND translation69e32194c0c3efallbackconfig_country_states.objectkey = 1 
  AND translation69e32194c0c3efallbackconfig_country_states.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation69e32194c0c41s_core_countries_states_attributes ON translation69e32194c0c41s_core_countries_states_attributes.objecttype = : translation69e32194c0c41s_core_countries_states_attributes 
  AND translation69e32194c0c41s_core_countries_states_attributes.objectkey = countryStateAttribute.stateID 
  AND translation69e32194c0c41s_core_countries_states_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation69e32194c0c43fallbacks_core_countries_states_attributes ON translation69e32194c0c43fallbacks_core_countries_states_attributes.objecttype = : translation69e32194c0c43fallbacks_core_countries_states_attributes 
  AND translation69e32194c0c43fallbacks_core_countries_states_attributes.objectkey = countryStateAttribute.stateID 
  AND translation69e32194c0c43fallbacks_core_countries_states_attributes.objectlanguage = : languagefallback 
WHERE 
  countryState.countryID IN (: ids)

array:7 [
  ":language" => 3
  ":translation69e32194c0c39config_country_states" => "config_country_states"
  ":languagefallback" => 0
  ":translation69e32194c0c3efallbackconfig_country_states" => "config_country_states"
  ":translation69e32194c0c41s_core_countries_states_attributes" => "s_core_countries_states_attributes"
  ":translation69e32194c0c43fallbacks_core_countries_states_attributes" => "s_core_countries_states_attributes"
  ":ids" => array:250 [
    0 => "2"
    1 => "3"
    2 => "4"
    3 => "15"
    4 => "16"
    5 => "20"
    6 => "28"
    7 => "32"
    8 => "36"
    9 => "37"
    10 => "46"
    11 => "47"
    12 => "48"
    13 => "49"
    14 => "50"
    15 => "51"
    16 => "52"
    17 => "53"
    18 => "54"
    19 => "55"
    20 => "56"
    21 => "57"
    22 => "58"
    23 => "59"
    24 => "60"
    25 => "61"
    26 => "62"
    27 => "63"
    28 => "64"
    29 => "65"
    30 => "66"
    31 => "67"
    32 => "68"
    33 => "69"
    34 => "70"
    35 => "71"
    36 => "72"
    37 => "73"
    38 => "74"
    39 => "75"
    40 => "76"
    41 => "77"
    42 => "78"
    43 => "79"
    44 => "80"
    45 => "81"
    46 => "82"
    47 => "83"
    48 => "84"
    49 => "85"
    50 => "86"
    51 => "87"
    52 => "88"
    53 => "89"
    54 => "90"
    55 => "91"
    56 => "92"
    57 => "93"
    58 => "94"
    59 => "95"
    60 => "96"
    61 => "97"
    62 => "98"
    63 => "99"
    64 => "100"
    65 => "101"
    66 => "102"
    67 => "103"
    68 => "104"
    69 => "105"
    70 => "106"
    71 => "107"
    72 => "108"
    73 => "109"
    74 => "110"
    75 => "111"
    76 => "112"
    77 => "113"
    78 => "114"
    79 => "115"
    80 => "116"
    81 => "117"
    82 => "118"
    83 => "119"
    84 => "120"
    85 => "121"
    86 => "122"
    87 => "123"
    88 => "124"
    89 => "125"
    90 => "126"
    91 => "127"
    92 => "128"
    93 => "129"
    94 => "130"
    95 => "131"
    96 => "132"
    97 => "133"
    98 => "134"
    99 => "135"
    100 => "136"
    101 => "137"
    102 => "138"
    103 => "139"
    104 => "140"
    105 => "141"
    106 => "142"
    107 => "143"
    108 => "144"
    109 => "145"
    110 => "146"
    111 => "147"
    112 => "148"
    113 => "149"
    114 => "150"
    115 => "151"
    116 => "152"
    117 => "153"
    118 => "154"
    119 => "155"
    120 => "156"
    121 => "157"
    122 => "158"
    123 => "159"
    124 => "160"
    125 => "161"
    126 => "162"
    127 => "163"
    128 => "164"
    129 => "165"
    130 => "166"
    131 => "167"
    132 => "168"
    133 => "169"
    134 => "170"
    135 => "171"
    136 => "172"
    137 => "173"
    138 => "174"
    139 => "175"
    140 => "176"
    141 => "177"
    142 => "178"
    143 => "179"
    144 => "180"
    145 => "181"
    146 => "182"
    147 => "183"
    148 => "184"
    149 => "185"
    150 => "186"
    151 => "187"
    152 => "188"
    153 => "189"
    154 => "190"
    155 => "191"
    156 => "192"
    157 => "193"
    158 => "194"
    159 => "195"
    160 => "196"
    161 => "197"
    162 => "198"
    163 => "199"
    164 => "200"
    165 => "201"
    166 => "202"
    167 => "203"
    168 => "204"
    169 => "205"
    170 => "206"
    171 => "207"
    172 => "208"
    173 => "209"
    174 => "210"
    175 => "211"
    176 => "212"
    177 => "213"
    178 => "214"
    179 => "215"
    180 => "216"
    181 => "217"
    182 => "218"
    183 => "219"
    184 => "220"
    185 => "221"
    186 => "222"
    187 => "223"
    188 => "224"
    189 => "225"
    190 => "226"
    191 => "227"
    192 => "228"
    193 => "229"
    194 => "230"
    195 => "231"
    196 => "232"
    197 => "233"
    198 => "234"
    199 => "235"
    200 => "236"
    201 => "237"
    202 => "238"
    203 => "239"
    204 => "240"
    205 => "241"
    206 => "242"
    207 => "243"
    208 => "244"
    209 => "245"
    210 => "246"
    211 => "247"
    212 => "248"
    213 => "249"
    214 => "250"
    215 => "251"
    216 => "252"
    217 => "253"
    218 => "254"
    219 => "5"
    220 => "7"
    221 => "8"
    222 => "9"
    223 => "10"
    224 => "11"
    225 => "12"
    226 => "13"
    227 => "14"
    228 => "18"
    229 => "21"
    230 => "22"
    231 => "23"
    232 => "24"
    233 => "25"
    234 => "26"
    235 => "27"
    236 => "29"
    237 => "30"
    238 => "31"
    239 => "33"
    240 => "34"
    241 => "35"
    242 => "38"
    243 => "39"
    244 => "40"
    245 => "41"
    246 => "42"
    247 => "43"
    248 => "44"
    249 => "45"
  ]
]

SELECT 
  coreConfigElements.name, 
  coreConfigValues.value 
FROM 
  s_core_config_values coreConfigValues 
  INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  (corePlugins.name = : dcValue1) 
  AND (
    coreConfigValues.shop_id = : dcValue2
  )

array:2 [
  "dcValue1" => "AdvancedMenu"
  "dcValue2" => 3
]

SELECT 
  coreConfigElements.name, 
  coreConfigValues.value 
FROM 
  s_core_config_values coreConfigValues 
  INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id 
  INNER JOIN s_core_shops coreShops ON coreConfigValues.shop_id = coreShops.main_id 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  (corePlugins.name = : dcValue1) 
  AND (coreShops.id = : dcValue2)

array:2 [
  "dcValue1" => "AdvancedMenu"
  "dcValue2" => 3
]

SELECT 
  coreConfigElements.name, 
  coreConfigValues.value 
FROM 
  s_core_config_values coreConfigValues 
  INNER JOIN s_core_config_elements coreConfigElements ON coreConfigValues.element_id = coreConfigElements.id 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  (
    corePlugins.name = : pluginName932600150
  ) 
  AND (
    coreConfigValues.shop_id = : shopId2212294583
  )

array:2 [
  "pluginName932600150" => "AdvancedMenu"
  "shopId2212294583" => 1
]

SELECT 
  coreConfigElements.name, 
  coreConfigElements.value 
FROM 
  s_core_config_elements coreConfigElements 
  INNER JOIN s_core_config_forms coreConfigForms ON coreConfigElements.form_id = coreConfigForms.id 
  INNER JOIN s_core_plugins corePlugins ON coreConfigForms.plugin_id = corePlugins.id 
WHERE 
  corePlugins.name = : pluginName932600150

array:1 [
  "pluginName932600150" => "AdvancedMenu"
]

SELECT 
  DISTINCT category.id 
FROM 
  s_categories category 
WHERE 
  (category.path LIKE : path) 
  AND (category.active = 1) 
  AND (
    ROUND(
      LENGTH(path) - LENGTH(
        REPLACE (path, "|", "")
      ) -1
    ) <= : depth
  ) 
ORDER BY 
  category.position ASC

array:2 [
  ":depth" => 5
  ":path" => "%|3|%"
]

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, 
  translation69e32194c2c7as_categories_attributes.objectdata as __categoryAttribute_translation, 
  translation69e32194c2c7efallbacks_categories_attributes.objectdata as __categoryAttribute_translation_fallback, 
  translation69e32194c2c82s_media_attributes.objectdata as __mediaAttribute_translation, 
  translation69e32194c2c84fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback, 
  translation69e32194c2c86productStream.objectdata as __stream_translation, 
  translation69e32194c2c88fallbackproductStream.objectdata as __stream_translation_fallback, 
  translation69e32194c2c8acategory.objectdata as __category_translation, 
  translation69e32194c2c8cfallbackcategory.objectdata as __category_translation_fallback 
FROM 
  s_categories category 
  LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id 
  LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id 
  LEFT JOIN s_media media ON media.id = category.mediaID 
  LEFT JOIN s_product_streams stream ON category.stream_id = stream.id 
  LEFT JOIN s_core_translations translation69e32194c2c8acategory ON translation69e32194c2c8acategory.objecttype = : translation69e32194c2c8acategory 
  AND translation69e32194c2c8acategory.objectkey = category.id 
  AND translation69e32194c2c8acategory.objectlanguage = : language 
  LEFT JOIN s_core_translations translation69e32194c2c8cfallbackcategory ON translation69e32194c2c8cfallbackcategory.objecttype = : translation69e32194c2c8cfallbackcategory 
  AND translation69e32194c2c8cfallbackcategory.objectkey = category.id 
  AND translation69e32194c2c8cfallbackcategory.objectlanguage = : languagefallback 
  LEFT JOIN s_core_translations translation69e32194c2c7as_categories_attributes ON translation69e32194c2c7as_categories_attributes.objecttype = : translation69e32194c2c7as_categories_attributes 
  AND translation69e32194c2c7as_categories_attributes.objectkey = category.id 
  AND translation69e32194c2c7as_categories_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation69e32194c2c7efallbacks_categories_attributes ON translation69e32194c2c7efallbacks_categories_attributes.objecttype = : translation69e32194c2c7efallbacks_categories_attributes 
  AND translation69e32194c2c7efallbacks_categories_attributes.objectkey = category.id 
  AND translation69e32194c2c7efallbacks_categories_attributes.objectlanguage = : languagefallback 
  LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID 
  LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id 
  LEFT JOIN s_core_translations translation69e32194c2c82s_media_attributes ON translation69e32194c2c82s_media_attributes.objecttype = : translation69e32194c2c82s_media_attributes 
  AND translation69e32194c2c82s_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation69e32194c2c82s_media_attributes.objectlanguage = : language 
  LEFT JOIN s_core_translations translation69e32194c2c84fallbacks_media_attributes ON translation69e32194c2c84fallbacks_media_attributes.objecttype = : translation69e32194c2c84fallbacks_media_attributes 
  AND translation69e32194c2c84fallbacks_media_attributes.objectkey = mediaAttribute.mediaID 
  AND translation69e32194c2c84fallbacks_media_attributes.objectlanguage = : languagefallback 
  LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId 
  LEFT JOIN s_core_translations translation69e32194c2c86productStream ON translation69e32194c2c86productStream.objecttype = : translation69e32194c2c86productStream 
  AND translation69e32194c2c86productStream.objectkey = stream.id 
  AND translation69e32194c2c86productStream.objectlanguage = : language 
  LEFT JOIN s_core_translations translation69e32194c2c88fallbackproductStream ON translation69e32194c2c88fallbackproductStream.objecttype = : translation69e32194c2c88fallbackproductStream 
  AND translation69e32194c2c88fallbackproductStream.objectkey = stream.id 
  AND translation69e32194c2c88fallbackproductStream.objectlanguage = : languagefallback 
WHERE 
  (
    category.id IN (: categories)
  ) 
  AND (category.active = 1) 
  AND (
    category.shops IS NULL 
    OR category.shops LIKE : shopId
  ) 
GROUP BY 
  category.id

array:12 [
  ":categories" => array:73 [
    0 => "80"
    1 => "58"
    2 => "57"
    3 => "56"
    4 => "55"
    5 => "54"
    6 => "53"
    7 => "52"
    8 => "51"
    9 => "50"
    10 => "49"
    11 => "48"
    12 => "47"
    13 => "46"
    14 => "45"
    15 => "44"
    16 => "43"
    17 => "59"
    18 => "60"
    19 => "79"
    20 => "78"
    21 => "77"
    22 => "76"
    23 => "75"
    24 => "74"
    25 => "73"
    26 => "72"
    27 => "70"
    28 => "69"
    29 => "68"
    30 => "67"
    31 => "66"
    32 => "63"
    33 => "62"
    34 => "61"
    35 => "42"
    36 => "41"
    37 => "25"
    38 => "23"
    39 => "22"
    40 => "21"
    41 => "20"
    42 => "19"
    43 => "18"
    44 => "17"
    45 => "16"
    46 => "15"
    47 => "14"
    48 => "13"
    49 => "24"
    50 => "26"
    51 => "27"
    52 => "40"
    53 => "39"
    54 => "38"
    55 => "37"
    56 => "36"
    57 => "35"
    58 => "34"
    59 => "33"
    60 => "32"
    61 => "31"
    62 => "30"
    63 => "29"
    64 => "28"
    65 => "5"
    66 => "7"
    67 => "8"
    68 => "9"
    69 => "10"
    70 => "11"
    71 => "81"
    72 => "12"
  ]
  ":shopId" => "%|3|%"
  ":language" => 3
  ":translation69e32194c2c7as_categories_attributes" => "s_categories_attributes"
  ":languagefallback" => 0
  ":translation69e32194c2c7efallbacks_categories_attributes" => "s_categories_attributes"
  ":translation69e32194c2c82s_media_attributes" => "s_media_attributes"
  ":translation69e32194c2c84fallbacks_media_attributes" => "s_media_attributes"
  ":translation69e32194c2c86productStream" => "productStream"
  ":translation69e32194c2c88fallbackproductStream" => "productStream"
  ":translation69e32194c2c8acategory" => "category"
  ":translation69e32194c2c8cfallbackcategory" => "category"
]