Shopware Profiler

SELECT 
  t0.id AS id_1, 
  t0.oldUrl AS oldUrl_2, 
  t0.newUrl AS newUrl_3, 
  t0.active AS active_4, 
  t0.overrideShopUrl AS overrideShopUrl_5, 
  t0.temporaryRedirect AS temporaryRedirect_6, 
  t0.externalRedirect AS externalRedirect_7, 
  t0.gone AS gone_8, 
  t0.shop_id AS shop_id_9, 
  t0.shop_id AS shop_id_10 
FROM 
  s_stutt_redirect t0 
WHERE 
  t0.active = ? 
  AND t0.oldUrl = ?

array:2 [
  0 => 1
  1 => "/staging/note"
]

SELECT 
  t0.id AS id_1, 
  t0.oldUrl AS oldUrl_2, 
  t0.newUrl AS newUrl_3, 
  t0.active AS active_4, 
  t0.overrideShopUrl AS overrideShopUrl_5, 
  t0.temporaryRedirect AS temporaryRedirect_6, 
  t0.externalRedirect AS externalRedirect_7, 
  t0.gone AS gone_8, 
  t0.shop_id AS shop_id_9, 
  t0.shop_id AS shop_id_10 
FROM 
  s_stutt_redirect t0 
WHERE 
  t0.active = ? 
  AND t0.oldUrl = ?

array:2 [
  0 => 1
  1 => "/note"
]

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 
  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_.main_id AS main_id_15, 
  s0_.template_id AS template_id_16, 
  s0_.document_template_id AS document_template_id_17, 
  s0_.category_id AS category_id_18, 
  s0_.locale_id AS locale_id_19, 
  s0_.currency_id AS currency_id_20, 
  s0_.customer_group_id AS customer_group_id_21, 
  s0_.fallback_id AS fallback_id_22 
FROM 
  s_core_shops s0_ 
WHERE 
  s0_.`default` = 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 
  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" => "www.in-stylefashion.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_.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.customerGroupID AS customerGroupID_2, 
  t0.fv_pricelist AS fv_pricelist_3, 
  t0.fv_is_discountable AS fv_is_discountable_4, 
  t0.fv_special_is_discountable AS fv_special_is_discountable_5, 
  t0.fv_special AS fv_special_6, 
  t0.customerGroupID AS customerGroupID_7 
FROM 
  s_core_customergroups_attributes t0 
WHERE 
  t0.customerGroupID = ?

array:1 [
  0 => 6
]

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" => "www.in-stylefashion.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 => 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 
  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 
  id IS NOT NULL 
FROM 
  swag_payment_paypal_unified_settings_general 
WHERE 
  shop_id = : shopId

array:1 [
  "shopId" => 1
]

SELECT 
  s0_.name AS name_0 
FROM 
  s_core_plugins s0_ 
WHERE 
  s0_.active = 1 
  AND s0_.name LIKE 'Neti%'

[]

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

array:2 [
  ":shopId" => 1
  ":pathInfo" => "note"
]

SELECT 
  t0.id AS id_1, 
  t0.oldUrl AS oldUrl_2, 
  t0.newUrl AS newUrl_3, 
  t0.active AS active_4, 
  t0.overrideShopUrl AS overrideShopUrl_5, 
  t0.temporaryRedirect AS temporaryRedirect_6, 
  t0.externalRedirect AS externalRedirect_7, 
  t0.gone AS gone_8, 
  t0.shop_id AS shop_id_9, 
  t0.shop_id AS shop_id_10 
FROM 
  s_stutt_redirect t0 
WHERE 
  t0.active = ? 
  AND t0.oldUrl = ?

array:2 [
  0 => 1
  1 => "/staging/note"
]

SELECT 
  t0.id AS id_1, 
  t0.oldUrl AS oldUrl_2, 
  t0.newUrl AS newUrl_3, 
  t0.active AS active_4, 
  t0.overrideShopUrl AS overrideShopUrl_5, 
  t0.temporaryRedirect AS temporaryRedirect_6, 
  t0.externalRedirect AS externalRedirect_7, 
  t0.gone AS gone_8, 
  t0.shop_id AS shop_id_9, 
  t0.shop_id AS shop_id_10 
FROM 
  s_stutt_redirect t0 
WHERE 
  t0.active = ? 
  AND t0.oldUrl = ?

array:2 [
  0 => 1
  1 => "/note"
]

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 
  s0_.name AS name_0 
FROM 
  s_core_plugins s0_ 
WHERE 
  s0_.active = 1 
  AND s0_.name LIKE 'Neti%'

[]

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, 
  customerGroupAttribute.fv_pricelist as __customerGroupAttribute_fv_pricelist, 
  customerGroupAttribute.fv_is_discountable as __customerGroupAttribute_fv_is_discountable, 
  customerGroupAttribute.fv_special_is_discountable as __customerGroupAttribute_fv_special_is_discountable, 
  customerGroupAttribute.fv_special as __customerGroupAttribute_fv_special, 
  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.fv_olsi_id as __categoryAttribute_fv_olsi_id, 
  categoryAttribute.fv_top_category_id as __categoryAttribute_fv_top_category_id, 
  categoryAttribute.six_seo_text as __categoryAttribute_six_seo_text, 
  categoryAttribute.six_seo_text_sidebar_headline as __categoryAttribute_six_seo_text_sidebar_headline, 
  categoryAttribute.six_seo_text_sidebar as __categoryAttribute_six_seo_text_sidebar, 
  categoryAttribute.six_seo_text_footer_headline as __categoryAttribute_six_seo_text_footer_headline, 
  categoryAttribute.six_seo_text_footer as __categoryAttribute_six_seo_text_footer, 
  categoryAttribute.kib_variantlisting as __categoryAttribute_kib_variantlisting, 
  categoryAttribute.kib_variantlisting_slideout as __categoryAttribute_kib_variantlisting_slideout, 
  categoryAttribute.kib_variantlisting_textvariants as __categoryAttribute_kib_variantlisting_textvariants, 
  categoryAttribute.kib_variantlisting_zoomcover as __categoryAttribute_kib_variantlisting_zoomcover, 
  categoryAttribute.kib_variantlisting_viewdropdown as __categoryAttribute_kib_variantlisting_viewdropdown, 
  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, 
  mediaAttribute.fv_ol_file_name as __mediaAttribute_fv_ol_file_name 
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, 
  customerGroupAttribute.fv_pricelist as __customerGroupAttribute_fv_pricelist, 
  customerGroupAttribute.fv_is_discountable as __customerGroupAttribute_fv_is_discountable, 
  customerGroupAttribute.fv_special_is_discountable as __customerGroupAttribute_fv_special_is_discountable, 
  customerGroupAttribute.fv_special as __customerGroupAttribute_fv_special 
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 => "CAMBJ"
    1 => "EK"
  ]
]

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

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

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

[]

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

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

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

array:5 [
  ":area" => null
  ":country" => null
  ":state" => null
  ":customerGroup" => 6
  ":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 OFFSET 0

array:5 [
  ":area" => null
  ":country" => null
  ":state" => null
  ":customerGroup" => 6
  ":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 OFFSET 0

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

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

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

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

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.label AS label_3, 
  t0.namespace AS namespace_4, 
  t0.source AS source_5, 
  t0.description AS description_6, 
  t0.active AS active_7, 
  t0.added AS added_8, 
  t0.installation_date AS installation_date_9, 
  t0.update_date AS update_date_10, 
  t0.refresh_date AS refresh_date_11, 
  t0.author AS author_12, 
  t0.copyright AS copyright_13, 
  t0.license AS license_14, 
  t0.version AS version_15, 
  t0.support AS support_16, 
  t0.changes AS changes_17, 
  t0.link AS link_18, 
  t0.update_version AS update_version_19, 
  t0.update_source AS update_source_20, 
  t0.capability_update AS capability_update_21, 
  t0.capability_install AS capability_install_22, 
  t0.capability_enable AS capability_enable_23, 
  t0.capability_secure_uninstall AS capability_secure_uninstall_24, 
  t0.translations AS translations_25, 
  t0.in_safe_mode AS in_safe_mode_26 
FROM 
  s_core_plugins t0 
WHERE 
  t0.name = ? 
LIMIT 
  1

array:1 [
  0 => "NetiEasyCoupon"
]

SELECT 
  t0.id AS id_1, 
  t0.oldUrl AS oldUrl_2, 
  t0.newUrl AS newUrl_3, 
  t0.active AS active_4, 
  t0.overrideShopUrl AS overrideShopUrl_5, 
  t0.temporaryRedirect AS temporaryRedirect_6, 
  t0.externalRedirect AS externalRedirect_7, 
  t0.gone AS gone_8, 
  t0.shop_id AS shop_id_9, 
  t0.shop_id AS shop_id_10 
FROM 
  s_stutt_redirect t0 
WHERE 
  t0.active = ? 
  AND t0.oldUrl = ?

array:2 [
  0 => 1
  1 => "/staging/note"
]

SELECT 
  t0.id AS id_1, 
  t0.oldUrl AS oldUrl_2, 
  t0.newUrl AS newUrl_3, 
  t0.active AS active_4, 
  t0.overrideShopUrl AS overrideShopUrl_5, 
  t0.temporaryRedirect AS temporaryRedirect_6, 
  t0.externalRedirect AS externalRedirect_7, 
  t0.gone AS gone_8, 
  t0.shop_id AS shop_id_9, 
  t0.shop_id AS shop_id_10 
FROM 
  s_stutt_redirect t0 
WHERE 
  t0.active = ? 
  AND t0.oldUrl = ?

array:2 [
  0 => 1
  1 => "/note"
]

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.label AS label_3, 
  t0.namespace AS namespace_4, 
  t0.source AS source_5, 
  t0.description AS description_6, 
  t0.active AS active_7, 
  t0.added AS added_8, 
  t0.installation_date AS installation_date_9, 
  t0.update_date AS update_date_10, 
  t0.refresh_date AS refresh_date_11, 
  t0.author AS author_12, 
  t0.copyright AS copyright_13, 
  t0.license AS license_14, 
  t0.version AS version_15, 
  t0.support AS support_16, 
  t0.changes AS changes_17, 
  t0.link AS link_18, 
  t0.update_version AS update_version_19, 
  t0.update_source AS update_source_20, 
  t0.capability_update AS capability_update_21, 
  t0.capability_install AS capability_install_22, 
  t0.capability_enable AS capability_enable_23, 
  t0.capability_secure_uninstall AS capability_secure_uninstall_24, 
  t0.translations AS translations_25, 
  t0.in_safe_mode AS in_safe_mode_26 
FROM 
  s_core_plugins t0 
WHERE 
  t0.name = ? 
LIMIT 
  1

array:1 [
  0 => "NetiFoundation"
]

SELECT 
  * 
FROM 
  wbm_data_layer_modules

[]

SELECT 
  t0.id AS id_1, 
  t0.groupkey AS groupkey_2, 
  t0.description AS description_3, 
  t0.tax AS tax_4, 
  t0.taxinput AS taxinput_5, 
  t0.mode AS mode_6, 
  t0.discount AS discount_7, 
  t0.minimumorder AS minimumorder_8, 
  t0.minimumordersurcharge AS minimumordersurcharge_9, 
  t10.id AS id_11, 
  t10.customerGroupID AS customerGroupID_12, 
  t10.fv_pricelist AS fv_pricelist_13, 
  t10.fv_is_discountable AS fv_is_discountable_14, 
  t10.fv_special_is_discountable AS fv_special_is_discountable_15, 
  t10.fv_special AS fv_special_16, 
  t10.customerGroupID AS customerGroupID_17 
FROM 
  s_core_customergroups t0 
  LEFT JOIN s_core_customergroups_attributes t10 ON t10.customerGroupID = t0.id 
WHERE 
  t0.groupkey = ? 
LIMIT 
  1

array:1 [
  0 => "CAMBJ"
]

SELECT 
  category.path 
FROM 
  s_categories category 
WHERE 
  category.id = : id

array:1 [
  ":id" => 339
]

SELECT 
  payment.name, 
  payment.id 
FROM 
  s_core_paymentmeans payment 
WHERE 
  (
    payment.name IN (: paymentMethodNames)
  ) 
  AND (payment.active = 1)

array:1 [
  "paymentMethodNames" => array:1 [
    0 => "SwagPaymentPayPalUnified"
  ]
]

SELECT 
  t0.id AS id_1, 
  t0.shop_id AS shop_id_2, 
  t0.active AS active_3, 
  t0.client_id AS client_id_4, 
  t0.client_secret AS client_secret_5, 
  t0.paypal_payer_id AS paypal_payer_id_6, 
  t0.sandbox_client_id AS sandbox_client_id_7, 
  t0.sandbox_client_secret AS sandbox_client_secret_8, 
  t0.sandbox_paypal_payer_id AS sandbox_paypal_payer_id_9, 
  t0.sandbox AS sandbox_10, 
  t0.show_sidebar_logo AS show_sidebar_logo_11, 
  t0.brand_name AS brand_name_12, 
  t0.order_number_prefix AS order_number_prefix_13, 
  t0.landing_page_type AS landing_page_type_14, 
  t0.display_errors AS display_errors_15, 
  t0.use_smart_payment_buttons AS use_smart_payment_buttons_16, 
  t0.submit_cart AS submit_cart_17, 
  t0.intent AS intent_18, 
  t0.button_style_color AS button_style_color_19, 
  t0.button_style_shape AS button_style_shape_20, 
  t0.button_style_size AS button_style_size_21, 
  t0.button_locale AS button_locale_22 
FROM 
  swag_payment_paypal_unified_settings_general t0 
WHERE 
  t0.shop_id = ? 
LIMIT 
  1

array:1 [
  0 => 1
]

SELECT 
  t0.id AS id_1, 
  t0.shop_id AS shop_id_2, 
  t0.detail_active AS detail_active_3, 
  t0.cart_active AS cart_active_4, 
  t0.off_canvas_active AS off_canvas_active_5, 
  t0.login_active AS login_active_6, 
  t0.listing_active AS listing_active_7, 
  t0.button_style_color AS button_style_color_8, 
  t0.button_style_shape AS button_style_shape_9, 
  t0.button_style_size AS button_style_size_10, 
  t0.submit_cart AS submit_cart_11 
FROM 
  swag_payment_paypal_unified_settings_express t0 
WHERE 
  t0.shop_id = ? 
LIMIT 
  1

array:1 [
  0 => 1
]

UPDATE 
  s_order_basket_attributes 
  LEFT JOIN s_order_basket ON s_order_basket.id = s_order_basket_attributes.basketID 
SET 
  swag_promotion_item_discount = 0, 
  swag_promotion_direct_item_discount = 0, 
  swag_promotion_direct_promotions = NULL 
WHERE 
  s_order_basket.sessionID = : sessionId

array:1 [
  "sessionId" => "13ce9cdc4d42d88a2f8c38f2bd33f9ac763a0af12c3a5cdf14ab3e3d82a20cbd"
]

DELETE oba, 
ob 
FROM 
  s_order_basket ob 
  LEFT JOIN s_order_basket_attributes oba ON ob.id = oba.basketID 
WHERE 
  ob.sessionID = : sessionId 
  AND oba.swag_promotion_id > 0

array:1 [
  "sessionId" => "13ce9cdc4d42d88a2f8c38f2bd33f9ac763a0af12c3a5cdf14ab3e3d82a20cbd"
]

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.pluginID AS pluginID_3 
FROM 
  s_core_acl_resources t0

[]

SELECT 
  t0.id AS id_1, 
  t0.parentID AS parentID_2, 
  t0.name AS name_3, 
  t0.description AS description_4, 
  t0.source AS source_5, 
  t0.enabled AS enabled_6, 
  t0.`admin` AS admin_7, 
  t0.parentID AS parentID_8 
FROM 
  s_core_auth_roles t0

[]

SELECT 
  t0.id AS id_1, 
  t0.privilegeID AS privilegeID_2, 
  t0.roleID AS roleID_3, 
  t0.resourceID AS resourceID_4, 
  t0.roleID AS roleID_5, 
  t6.id AS id_7, 
  t6.parentID AS parentID_8, 
  t6.name AS name_9, 
  t6.description AS description_10, 
  t6.source AS source_11, 
  t6.enabled AS enabled_12, 
  t6.`admin` AS admin_13, 
  t6.parentID AS parentID_14, 
  t0.resourceID AS resourceID_15, 
  t16.id AS id_17, 
  t16.name AS name_18, 
  t16.pluginID AS pluginID_19, 
  t0.privilegeID AS privilegeID_20, 
  t21.id AS id_22, 
  t21.resourceID AS resourceID_23, 
  t21.name AS name_24, 
  t21.resourceID AS resourceID_25 
FROM 
  s_core_acl_roles t0 
  LEFT JOIN s_core_auth_roles t6 ON t0.roleID = t6.id 
  LEFT JOIN s_core_acl_resources t16 ON t0.resourceID = t16.id 
  LEFT JOIN s_core_acl_privileges t21 ON t0.privilegeID = t21.id

[]

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.label AS label_3, 
  t0.namespace AS namespace_4, 
  t0.source AS source_5, 
  t0.description AS description_6, 
  t0.active AS active_7, 
  t0.added AS added_8, 
  t0.installation_date AS installation_date_9, 
  t0.update_date AS update_date_10, 
  t0.refresh_date AS refresh_date_11, 
  t0.author AS author_12, 
  t0.copyright AS copyright_13, 
  t0.license AS license_14, 
  t0.version AS version_15, 
  t0.support AS support_16, 
  t0.changes AS changes_17, 
  t0.link AS link_18, 
  t0.update_version AS update_version_19, 
  t0.update_source AS update_source_20, 
  t0.capability_update AS capability_update_21, 
  t0.capability_install AS capability_install_22, 
  t0.capability_enable AS capability_enable_23, 
  t0.capability_secure_uninstall AS capability_secure_uninstall_24, 
  t0.translations AS translations_25, 
  t0.in_safe_mode AS in_safe_mode_26 
FROM 
  s_core_plugins t0 
WHERE 
  t0.name = ? 
LIMIT 
  1

array:1 [
  0 => "NetiMultipleVouchers"
]

UPDATE 
  s_order_basket_attributes 
  LEFT JOIN s_order_basket ON s_order_basket.id = s_order_basket_attributes.basketID 
SET 
  swag_promotion_item_discount = 0, 
  swag_promotion_direct_item_discount = 0, 
  swag_promotion_direct_promotions = NULL 
WHERE 
  s_order_basket.sessionID = : sessionId

array:1 [
  "sessionId" => "13ce9cdc4d42d88a2f8c38f2bd33f9ac763a0af12c3a5cdf14ab3e3d82a20cbd"
]

DELETE oba, 
ob 
FROM 
  s_order_basket ob 
  LEFT JOIN s_order_basket_attributes oba ON ob.id = oba.basketID 
WHERE 
  ob.sessionID = : sessionId 
  AND oba.swag_promotion_id > 0

array:1 [
  "sessionId" => "13ce9cdc4d42d88a2f8c38f2bd33f9ac763a0af12c3a5cdf14ab3e3d82a20cbd"
]

SELECT 
  promotion.id AS ak, 
  promotion.* 
FROM 
  s_plugin_promotion promotion 
WHERE 
  (active = 1) 
  AND (
    (
      DATE_ADD(NOW(), INTERVAL 1 SECOND) > valid_from 
      OR valid_from IS NULL
    )
  ) 
  AND (
    (
      DATE_SUB(NOW(), INTERVAL 1 SECOND) < valid_to 
      OR valid_to IS NULL
    )
  ) 
ORDER BY 
  exclusive DESC, 
  priority DESC

[]

SELECT 
  * 
FROM 
  s_plugin_promotion_customer_group 
WHERE 
  promotionID IN (: promotionIds)

array:1 [
  "promotionIds" => array:10 [
    0 => 15
    1 => 5
    2 => 14
    3 => 13
    4 => 2
    5 => 11
    6 => 4
    7 => 3
    8 => 102
    9 => 119
  ]
]

SELECT 
  * 
FROM 
  s_plugin_promotion_shop 
WHERE 
  promotionID IN (: promotionIds)

array:1 [
  "promotionIds" => array:10 [
    0 => 15
    1 => 5
    2 => 14
    3 => 13
    4 => 2
    5 => 11
    6 => 4
    7 => 3
    8 => 102
    9 => 119
  ]
]

SELECT 
  * 
FROM 
  s_plugin_promotion_do_not_allow_later 
WHERE 
  promotionID IN (: promotionIds)

array:1 [
  "promotionIds" => array:10 [
    0 => 15
    1 => 5
    2 => 14
    3 => 13
    4 => 2
    5 => 11
    6 => 4
    7 => 3
    8 => 102
    9 => 119
  ]
]

SELECT 
  * 
FROM 
  s_plugin_promotion_do_not_run_after 
WHERE 
  promotionID IN (: promotionIds)

array:1 [
  "promotionIds" => array:10 [
    0 => 15
    1 => 5
    2 => 14
    3 => 13
    4 => 2
    5 => 11
    6 => 4
    7 => 3
    8 => 102
    9 => 119
  ]
]

SELECT 
  fg.* 
FROM 
  s_plugin_promotion_free_goods fg 
  INNER JOIN s_articles_details ad ON ad.articleID = fg.articleID 
  AND (
    (ad.laststock = 0) 
    OR (
      ad.laststock = 1 
      AND ad.instock > 0
    )
  ) 
WHERE 
  promotionID IN (: promotionIds)

array:1 [
  "promotionIds" => array:10 [
    0 => 15
    1 => 5
    2 => 14
    3 => 13
    4 => 2
    5 => 11
    6 => 4
    7 => 3
    8 => 102
    9 => 119
  ]
]

SELECT 
  objectkey, 
  objectdata 
FROM 
  s_core_translations 
WHERE 
  (
    objectkey IN (: promotionIds)
  ) 
  AND (objectlanguage = : shopId) 
  AND (
    objecttype = "swag-promotion-settings"
  )

array:2 [
  "promotionIds" => array:10 [
    0 => 15
    1 => 5
    2 => 14
    3 => 13
    4 => 2
    5 => 11
    6 => 4
    7 => 3
    8 => 102
    9 => 119
  ]
  "shopId" => 1
]

DELETE FROM 
  s_order_basket 
WHERE 
  sessionID = : sessionId 
  AND modus IN (3, 4) 
  AND ordernumber IN (: numbers)

array:2 [
  "sessionId" => "13ce9cdc4d42d88a2f8c38f2bd33f9ac763a0af12c3a5cdf14ab3e3d82a20cbd"
  "numbers" => "sw-payment-absolute,SHIPPINGDISCOUNT,sw-payment,sw-discount"
]

SELECT 
  * 
FROM 
  s_order_basket sob 
  LEFT JOIN s_order_basket_attributes soba ON soba.basketID = sob.id 
WHERE 
  sob.sessionID = : sessionId

array:1 [
  "sessionId" => "13ce9cdc4d42d88a2f8c38f2bd33f9ac763a0af12c3a5cdf14ab3e3d82a20cbd"
]

SELECT 
  id IS NOT NULL 
FROM 
  swag_payment_paypal_unified_settings_general 
WHERE 
  shop_id = : shopId

array:1 [
  "shopId" => 1
]

SELECT 
  active 
FROM 
  swag_payment_paypal_unified_settings_general 
WHERE 
  shop_id = : shopId

array:1 [
  "shopId" => 1
]

SELECT 
  payment.name, 
  payment.id 
FROM 
  s_core_paymentmeans payment 
WHERE 
  (
    payment.name IN (: paymentMethodNames)
  ) 
  AND (payment.active = 1)

array:1 [
  "paymentMethodNames" => array:1 [
    0 => "SwagPaymentPayPalUnified"
  ]
]

SELECT 
  show_sidebar_logo 
FROM 
  swag_payment_paypal_unified_settings_general 
WHERE 
  shop_id = : shopId

array:1 [
  "shopId" => 1
]

SELECT 
  payment.name, 
  payment.id 
FROM 
  s_core_paymentmeans payment 
WHERE 
  payment.name IN (: paymentMethodNames)

array:1 [
  "paymentMethodNames" => array:1 [
    0 => "SwagPaymentPayPalUnified"
  ]
]

SELECT 
  * 
FROM 
  s_order_basket sob 
  LEFT JOIN s_order_basket_attributes soba ON soba.basketID = sob.id 
WHERE 
  sob.sessionID = : sessionId

array:1 [
  "sessionId" => "13ce9cdc4d42d88a2f8c38f2bd33f9ac763a0af12c3a5cdf14ab3e3d82a20cbd"
]

SELECT 
  * 
FROM 
  s_order_basket sob 
  LEFT JOIN s_order_basket_attributes soba ON soba.basketID = sob.id 
WHERE 
  sob.sessionID = : sessionId

array:1 [
  "sessionId" => "13ce9cdc4d42d88a2f8c38f2bd33f9ac763a0af12c3a5cdf14ab3e3d82a20cbd"
]

SELECT 
  payment.name, 
  payment.id 
FROM 
  s_core_paymentmeans payment 
WHERE 
  payment.name IN (: paymentMethodNames)

array:1 [
  "paymentMethodNames" => array:1 [
    0 => "SwagPaymentPayPalUnifiedSepa"
  ]
]

SELECT 
  payment.name, 
  payment.id 
FROM 
  s_core_paymentmeans payment 
WHERE 
  payment.name IN (: paymentMethodNames)

array:1 [
  "paymentMethodNames" => array:1 [
    0 => "SwagPaymentPayPalUnifiedPayUponInvoice"
  ]
]

SELECT 
  payment.name, 
  payment.id 
FROM 
  s_core_paymentmeans payment 
WHERE 
  (
    payment.name IN (: paymentMethodNames)
  ) 
  AND (payment.active = 1)

array:1 [
  "paymentMethodNames" => array:10 [
    0 => "SwagPaymentPayPalUnifiedBancontact"
    1 => "SwagPaymentPayPalUnifiedBlik"
    2 => "SwagPaymentPayPalUnifiedEps"
    3 => "SwagPaymentPayPalUnifiedGiropay"
    4 => "SwagPaymentPayPalUnifiedIdeal"
    5 => "SwagPaymentPayPalUnifiedMultibanco"
    6 => "SwagPaymentPayPalUnifiedMyBank"
    7 => "SwagPaymentPayPalUnifiedP24"
    8 => "SwagPaymentPayPalUnifiedSofort"
    9 => "SwagPaymentPayPalUnifiedTrustly"
  ]
]

SELECT 
  payment.name, 
  payment.id 
FROM 
  s_core_paymentmeans payment 
WHERE 
  payment.name IN (: paymentMethodNames)

array:1 [
  "paymentMethodNames" => array:1 [
    0 => "SwagPaymentPayPalUnifiedAdvancedCreditDebitCard"
  ]
]

SELECT 
  id IS NOT NULL 
FROM 
  swag_payment_paypal_unified_settings_general 
WHERE 
  shop_id = : shopId

array:1 [
  "shopId" => 1
]

SELECT 
  active 
FROM 
  swag_payment_paypal_unified_settings_general 
WHERE 
  shop_id = : shopId

array:1 [
  "shopId" => 1
]

SELECT 
  payment.name, 
  payment.id 
FROM 
  s_core_paymentmeans payment 
WHERE 
  (
    payment.name IN (: paymentMethodNames)
  ) 
  AND (payment.active = 1)

array:1 [
  "paymentMethodNames" => array:1 [
    0 => "SwagPaymentPayPalUnified"
  ]
]

SELECT 
  advertise_installments 
FROM 
  swag_payment_paypal_unified_settings_installments 
WHERE 
  shop_id = : shopId

array:1 [
  "shopId" => 1
]

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.label AS label_3, 
  t0.namespace AS namespace_4, 
  t0.source AS source_5, 
  t0.description AS description_6, 
  t0.active AS active_7, 
  t0.added AS added_8, 
  t0.installation_date AS installation_date_9, 
  t0.update_date AS update_date_10, 
  t0.refresh_date AS refresh_date_11, 
  t0.author AS author_12, 
  t0.copyright AS copyright_13, 
  t0.license AS license_14, 
  t0.version AS version_15, 
  t0.support AS support_16, 
  t0.changes AS changes_17, 
  t0.link AS link_18, 
  t0.update_version AS update_version_19, 
  t0.update_source AS update_source_20, 
  t0.capability_update AS capability_update_21, 
  t0.capability_install AS capability_install_22, 
  t0.capability_enable AS capability_enable_23, 
  t0.capability_secure_uninstall AS capability_secure_uninstall_24, 
  t0.translations AS translations_25, 
  t0.in_safe_mode AS in_safe_mode_26 
FROM 
  s_core_plugins t0 
WHERE 
  t0.name = ? 
LIMIT 
  1

array:1 [
  0 => "NetiQuickOrder"
]

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 => 25
    1 => 23
    2 => 22
  ]
]

SELECT 
  t0.id AS id_1, 
  t0.groupkey AS groupkey_2, 
  t0.description AS description_3, 
  t0.tax AS tax_4, 
  t0.taxinput AS taxinput_5, 
  t0.mode AS mode_6, 
  t0.discount AS discount_7, 
  t0.minimumorder AS minimumorder_8, 
  t0.minimumordersurcharge AS minimumordersurcharge_9, 
  t10.id AS id_11, 
  t10.customerGroupID AS customerGroupID_12, 
  t10.fv_pricelist AS fv_pricelist_13, 
  t10.fv_is_discountable AS fv_is_discountable_14, 
  t10.fv_special_is_discountable AS fv_special_is_discountable_15, 
  t10.fv_special AS fv_special_16, 
  t10.customerGroupID AS customerGroupID_17 
FROM 
  s_core_customergroups t0 
  LEFT JOIN s_core_customergroups_attributes t10 ON t10.customerGroupID = t0.id 
WHERE 
  t0.groupkey = ? 
LIMIT 
  1

array:1 [
  0 => "CAMBJ"
]

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.description AS description_3, 
  t0.template AS template_4, 
  t0.class AS class_5, 
  t0.`table` AS table_6, 
  t0.hide AS hide_7, 
  t0.additionaldescription AS additionaldescription_8, 
  t0.debit_percent AS debit_percent_9, 
  t0.surcharge AS surcharge_10, 
  t0.surchargestring AS surchargestring_11, 
  t0.position AS position_12, 
  t0.active AS active_13, 
  t0.esdactive AS esdactive_14, 
  t0.mobile_inactive AS mobile_inactive_15, 
  t0.embediframe AS embediframe_16, 
  t0.hideprospect AS hideprospect_17, 
  t0.action AS action_18, 
  t0.pluginID AS pluginID_19, 
  t0.source AS source_20, 
  t21.id AS id_22, 
  t21.paymentmeanID AS paymentmeanID_23, 
  t21.swag_paypal_unified_display_in_plus_iframe AS swag_paypal_unified_display_in_plus_iframe_24, 
  t21.swag_paypal_unified_plus_iframe_payment_logo AS swag_paypal_unified_plus_iframe_payment_logo_25, 
  t21.paymentmeanID AS paymentmeanID_26, 
  t0.pluginID AS pluginID_27 
FROM 
  s_core_paymentmeans t0 
  LEFT JOIN s_core_paymentmeans_attributes t21 ON t21.paymentmeanID = t0.id 
WHERE 
  t0.name = ? 
  AND t0.active = ? 
LIMIT 
  1

array:2 [
  0 => "mollie_applepaydirect"
  1 => true
]

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.description AS description_3, 
  t0.template AS template_4, 
  t0.class AS class_5, 
  t0.`table` AS table_6, 
  t0.hide AS hide_7, 
  t0.additionaldescription AS additionaldescription_8, 
  t0.debit_percent AS debit_percent_9, 
  t0.surcharge AS surcharge_10, 
  t0.surchargestring AS surchargestring_11, 
  t0.position AS position_12, 
  t0.active AS active_13, 
  t0.esdactive AS esdactive_14, 
  t0.mobile_inactive AS mobile_inactive_15, 
  t0.embediframe AS embediframe_16, 
  t0.hideprospect AS hideprospect_17, 
  t0.action AS action_18, 
  t0.pluginID AS pluginID_19, 
  t0.source AS source_20, 
  t21.id AS id_22, 
  t21.paymentmeanID AS paymentmeanID_23, 
  t21.swag_paypal_unified_display_in_plus_iframe AS swag_paypal_unified_display_in_plus_iframe_24, 
  t21.swag_paypal_unified_plus_iframe_payment_logo AS swag_paypal_unified_plus_iframe_payment_logo_25, 
  t21.paymentmeanID AS paymentmeanID_26, 
  t0.pluginID AS pluginID_27 
FROM 
  s_core_paymentmeans t0 
  LEFT JOIN s_core_paymentmeans_attributes t21 ON t21.paymentmeanID = t0.id 
WHERE 
  t0.name = ? 
  AND t0.active = ? 
LIMIT 
  1

array:2 [
  0 => "mollie_applepaydirect"
  1 => true
]

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.description AS description_3, 
  t0.template AS template_4, 
  t0.class AS class_5, 
  t0.`table` AS table_6, 
  t0.hide AS hide_7, 
  t0.additionaldescription AS additionaldescription_8, 
  t0.debit_percent AS debit_percent_9, 
  t0.surcharge AS surcharge_10, 
  t0.surchargestring AS surchargestring_11, 
  t0.position AS position_12, 
  t0.active AS active_13, 
  t0.esdactive AS esdactive_14, 
  t0.mobile_inactive AS mobile_inactive_15, 
  t0.embediframe AS embediframe_16, 
  t0.hideprospect AS hideprospect_17, 
  t0.action AS action_18, 
  t0.pluginID AS pluginID_19, 
  t0.source AS source_20, 
  t21.id AS id_22, 
  t21.paymentmeanID AS paymentmeanID_23, 
  t21.swag_paypal_unified_display_in_plus_iframe AS swag_paypal_unified_display_in_plus_iframe_24, 
  t21.swag_paypal_unified_plus_iframe_payment_logo AS swag_paypal_unified_plus_iframe_payment_logo_25, 
  t21.paymentmeanID AS paymentmeanID_26, 
  t0.pluginID AS pluginID_27 
FROM 
  s_core_paymentmeans t0 
  LEFT JOIN s_core_paymentmeans_attributes t21 ON t21.paymentmeanID = t0.id 
WHERE 
  t0.name = ? 
  AND t0.active = ? 
LIMIT 
  1

array:2 [
  0 => "mollie_applepaydirect"
  1 => true
]

SELECT 
  payment.name, 
  payment.id 
FROM 
  s_core_paymentmeans payment 
WHERE 
  payment.name IN (: paymentMethodNames)

array:1 [
  "paymentMethodNames" => array:1 [
    0 => "SwagPaymentPayPalUnifiedPayUponInvoice"
  ]
]

SELECT 
  payment.name, 
  payment.id 
FROM 
  s_core_paymentmeans payment 
WHERE 
  (
    payment.name IN (: paymentMethodNames)
  ) 
  AND (payment.active = 1)

array:1 [
  "paymentMethodNames" => array:10 [
    0 => "SwagPaymentPayPalUnifiedBancontact"
    1 => "SwagPaymentPayPalUnifiedBlik"
    2 => "SwagPaymentPayPalUnifiedEps"
    3 => "SwagPaymentPayPalUnifiedGiropay"
    4 => "SwagPaymentPayPalUnifiedIdeal"
    5 => "SwagPaymentPayPalUnifiedMultibanco"
    6 => "SwagPaymentPayPalUnifiedMyBank"
    7 => "SwagPaymentPayPalUnifiedP24"
    8 => "SwagPaymentPayPalUnifiedSofort"
    9 => "SwagPaymentPayPalUnifiedTrustly"
  ]
]

SELECT 
  payment.name, 
  payment.id 
FROM 
  s_core_paymentmeans payment 
WHERE 
  payment.name IN (: paymentMethodNames)

array:1 [
  "paymentMethodNames" => array:1 [
    0 => "SwagPaymentPayPalUnifiedAdvancedCreditDebitCard"
  ]
]