Queries
65
Total Queries
0.0029 s
Total Query Time
SQL | Params | Execution Time |
---|---|---|
SELECT shop.id, shop.name, shop.base_url, shop.position, IF(main_shop.id IS NULL, 1, 0) is_main, IFNULL(main_shop.host, shop.host) as host, IFNULL(main_shop.hosts, shop.hosts) as hosts, IFNULL(main_shop.secure, shop.secure) as secure, IFNULL( main_shop.base_path, shop.base_path ) as base_path, IFNULL( main_shop.template_id, shop.template_id ) as template_id, IFNULL( main_shop.customer_scope, shop.customer_scope ) as customer_scope FROM s_core_shops shop LEFT JOIN s_core_shops main_shop ON shop.main_id = main_shop.id WHERE (shop.active = 1) AND ( ( shop.host = : host OR ( shop.host IS NULL AND main_shop.host = : host ) ) ) |
array:1 [ ":host" => "sw5demo.swk-web.com" ] |
0.0003 ms |
SELECT s0_.id AS id_0, s0_.main_id AS main_id_1, s0_.category_id AS category_id_2, s0_.name AS name_3, s0_.title AS title_4, s0_.position AS position_5, s0_.host AS host_6, s0_.base_path AS base_path_7, s0_.base_url AS base_url_8, s0_.hosts AS hosts_9, s0_.secure AS secure_10, s0_.template_id AS template_id_11, s0_.`default` AS default_12, s0_.active AS active_13, s0_.customer_scope AS customer_scope_14, s0_.id AS id_15, s0_.main_id AS main_id_16, s0_.category_id AS category_id_17, s0_.name AS name_18, s0_.title AS title_19, s0_.position AS position_20, s0_.host AS host_21, s0_.base_path AS base_path_22, s0_.base_url AS base_url_23, s0_.hosts AS hosts_24, s0_.secure AS secure_25, s0_.template_id AS template_id_26, s0_.`default` AS default_27, s0_.active AS active_28, s0_.customer_scope AS customer_scope_29, s1_.id AS id_30, s1_.locale AS locale_31, s1_.language AS language_32, s1_.territory AS territory_33, s2_.id AS id_34, s2_.currency AS currency_35, s2_.name AS name_36, s2_.standard AS standard_37, s2_.factor AS factor_38, s2_.templatechar AS templatechar_39, s2_.symbol_position AS symbol_position_40, s2_.position AS position_41, s3_.id AS id_42, s3_.template AS template_43, s3_.name AS name_44, s3_.description AS description_45, s3_.author AS author_46, s3_.license AS license_47, s3_.esi AS esi_48, s3_.style_support AS style_support_49, s3_.emotion AS emotion_50, s3_.version AS version_51, s3_.plugin_id AS plugin_id_52, s3_.parent_id AS parent_id_53, s4_.id AS id_54, s4_.template AS template_55, s4_.name AS name_56, s4_.description AS description_57, s4_.author AS author_58, s4_.license AS license_59, s4_.esi AS esi_60, s4_.style_support AS style_support_61, s4_.emotion AS emotion_62, s4_.version AS version_63, s4_.plugin_id AS plugin_id_64, s4_.parent_id AS parent_id_65, s5_.id AS id_66, s5_.currency AS currency_67, s5_.name AS name_68, s5_.standard AS standard_69, s5_.factor AS factor_70, s5_.templatechar AS templatechar_71, s5_.symbol_position AS symbol_position_72, s5_.position AS position_73, s6_.id AS id_74, s6_.groupkey AS groupkey_75, s6_.description AS description_76, s6_.tax AS tax_77, s6_.taxinput AS taxinput_78, s6_.mode AS mode_79, s6_.discount AS discount_80, s6_.minimumorder AS minimumorder_81, s6_.minimumordersurcharge AS minimumordersurcharge_82, s0_.main_id AS main_id_83, s0_.template_id AS template_id_84, s0_.document_template_id AS document_template_id_85, s0_.category_id AS category_id_86, s0_.locale_id AS locale_id_87, s0_.currency_id AS currency_id_88, s0_.customer_group_id AS customer_group_id_89, s0_.fallback_id AS fallback_id_90, s3_.parent_id AS parent_id_91, s3_.plugin_id AS plugin_id_92, s4_.parent_id AS parent_id_93, s4_.plugin_id AS plugin_id_94 FROM s_core_shops s0_ LEFT JOIN s_core_locales s1_ ON s0_.locale_id = s1_.id LEFT JOIN s_core_currencies s2_ ON s0_.currency_id = s2_.id LEFT JOIN s_core_templates s3_ ON s0_.template_id = s3_.id LEFT JOIN s_core_templates s4_ ON s0_.document_template_id = s4_.id LEFT JOIN s_core_shop_currencies s7_ ON s0_.id = s7_.shop_id LEFT JOIN s_core_currencies s5_ ON s5_.id = s7_.currency_id LEFT JOIN s_core_customergroups s6_ ON s0_.customer_group_id = s6_.id WHERE s0_.id = ? ORDER BY s5_.position ASC, s5_.id ASC |
array:1 [ 0 => "1" ] |
0.0006 ms |
SELECT t0.id AS id_1, t0.shopID AS shopID_2, t0.shopID AS shopID_3 FROM s_core_shops_attributes t0 WHERE t0.shopID = ? |
array:1 [ 0 => 1 ] |
0.0002 ms |
SELECT t0.id AS id_1, t0.customerGroupID AS customerGroupID_2, t0.customerGroupID AS customerGroupID_3 FROM s_core_customergroups_attributes t0 WHERE t0.customerGroupID = ? |
array:1 [ 0 => 1 ] |
0.0002 ms |
SELECT shop.id, shop.name, shop.base_url, shop.position, IF(main_shop.id IS NULL, 1, 0) is_main, IFNULL(main_shop.host, shop.host) as host, IFNULL(main_shop.hosts, shop.hosts) as hosts, IFNULL(main_shop.secure, shop.secure) as secure, IFNULL( main_shop.base_path, shop.base_path ) as base_path, IFNULL( main_shop.template_id, shop.template_id ) as template_id, IFNULL( main_shop.customer_scope, shop.customer_scope ) as customer_scope FROM s_core_shops shop LEFT JOIN s_core_shops main_shop ON shop.main_id = main_shop.id WHERE (shop.active = 1) AND ( ( shop.host = : host OR ( shop.host IS NULL AND main_shop.host = : host ) ) ) |
array:1 [ ":host" => "sw5demo.swk-web.com" ] |
0.0003 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.`key` AS key_3, t0.active AS active_4, t0.mapping_id AS mapping_id_5 FROM s_cms_static_groups t0 INNER JOIN s_core_shop_pages ON t0.id = s_core_shop_pages.group_id WHERE s_core_shop_pages.shop_id = ? ORDER BY t0.id ASC |
array:1 [ 0 => 1 ] |
0.0003 ms |
SELECT t0.id AS id_1, t0.main_id AS main_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.title AS title_5, t0.position AS position_6, t0.host AS host_7, t0.base_path AS base_path_8, t0.base_url AS base_url_9, t0.hosts AS hosts_10, t0.secure AS secure_11, t0.template_id AS template_id_12, t0.`default` AS default_13, t0.active AS active_14, t0.customer_scope AS customer_scope_15, t0.main_id AS main_id_16, t0.template_id AS template_id_17, t0.document_template_id AS document_template_id_18, t0.category_id AS category_id_19, t0.locale_id AS locale_id_20, t0.currency_id AS currency_id_21, t0.customer_group_id AS customer_group_id_22, t0.fallback_id AS fallback_id_23, t24.id AS id_25, t24.shopID AS shopID_26, t24.shopID AS shopID_27 FROM s_core_shops t0 LEFT JOIN s_core_shops_attributes t24 ON t24.shopID = t0.id WHERE t0.main_id = ? ORDER BY t0.position ASC, t0.id ASC |
array:1 [ 0 => 1 ] |
0.0003 ms |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.language AS language_3, t0.territory AS territory_4 FROM s_core_locales t0 WHERE t0.locale = ? LIMIT 1 |
array:1 [ 0 => "en_GB" ] |
0.0002 ms |
SELECT template.id, template.id, template.template, template.plugin_id, template.parent_id, plugin.name as plugin_name, plugin.namespace as plugin_namespace, plugin.source as plugin_source FROM s_core_templates template LEFT JOIN s_core_plugins plugin ON plugin.id = template.plugin_id |
[] |
0.0002 ms |
SELECT t0.id AS id_1, t0.main_id AS main_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.title AS title_5, t0.position AS position_6, t0.host AS host_7, t0.base_path AS base_path_8, t0.base_url AS base_url_9, t0.hosts AS hosts_10, t0.secure AS secure_11, t0.template_id AS template_id_12, t0.`default` AS default_13, t0.active AS active_14, t0.customer_scope AS customer_scope_15, t0.main_id AS main_id_16, t0.template_id AS template_id_17, t0.document_template_id AS document_template_id_18, t0.category_id AS category_id_19, t0.locale_id AS locale_id_20, t0.currency_id AS currency_id_21, t0.customer_group_id AS customer_group_id_22, t0.fallback_id AS fallback_id_23, t24.id AS id_25, t24.shopID AS shopID_26, t24.shopID AS shopID_27 FROM s_core_shops t0 LEFT JOIN s_core_shops_attributes t24 ON t24.shopID = t0.id WHERE t0.template_id = ? |
array:1 [ 0 => 23 ] |
0.0002 ms |
SELECT t0.type AS type_1, t0.name AS name_2, t0.position AS position_3, t0.default_value AS default_value_4, t0.selection AS selection_5, t0.field_label AS field_label_6, t0.support_text AS support_text_7, t0.allow_blank AS allow_blank_8, t0.less_compatible AS less_compatible_9, t0.attributes AS attributes_10, t0.container_id AS container_id_11, t0.id AS id_12, t0.template_id AS template_id_13, t0.template_id AS template_id_14, t0.container_id AS container_id_15 FROM s_core_templates_config_elements t0 WHERE t0.template_id = ? |
array:1 [ 0 => 23 ] |
0.0005 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.template_id AS template_id_3, t0.parent_id AS parent_id_4, t0.title AS title_5, t0.attributes AS attributes_6, t0.id AS id_7, t0.template_id AS template_id_8, t0.parent_id AS parent_id_9 FROM s_core_templates_config_layout t0 WHERE t0.template_id = ? |
array:1 [ 0 => 23 ] |
0.0003 ms |
SELECT t0.id AS id_1, t0.template_id AS template_id_2, t0.name AS name_3, t0.description AS description_4, t0.element_values AS element_values_5, t0.template_id AS template_id_6 FROM s_core_templates_config_set t0 WHERE t0.template_id = ? |
array:1 [ 0 => 23 ] |
0.0003 ms |
SELECT template.id, template.id, template.template, template.plugin_id, template.parent_id, plugin.name as plugin_name, plugin.namespace as plugin_namespace, plugin.source as plugin_source FROM s_core_templates template LEFT JOIN s_core_plugins plugin ON plugin.id = template.plugin_id |
[] |
0.0003 ms |
SELECT shop.id as __shop_id, shop.main_id as __shop_main_id, shop.name as __shop_name, shop.title as __shop_title, shop.position as __shop_position, shop.host as __shop_host, shop.base_path as __shop_base_path, shop.base_url as __shop_base_url, shop.hosts as __shop_hosts, shop.secure as __shop_secure, shop.template_id as __shop_template_id, shop.document_template_id as __shop_document_template_id, shop.category_id as __shop_category_id, shop.locale_id as __shop_locale_id, shop.currency_id as __shop_currency_id, shop.customer_group_id as __shop_customer_group_id, shop.fallback_id as __shop_fallback_id, shop.customer_scope as __shop_customer_scope, shop.default as __shop_default, shop.active as __shop_active, shopAttribute.id as __shopAttribute_id, shopAttribute.shopID as __shopAttribute_shopID, currency.id as __currency_id, currency.currency as __currency_currency, currency.name as __currency_name, currency.standard as __currency_standard, currency.factor as __currency_factor, currency.templatechar as __currency_templatechar, currency.symbol_position as __currency_symbol_position, currency.position as __currency_position, template.id as __template_id, template.template as __template_template, template.name as __template_name, template.description as __template_description, template.author as __template_author, template.license as __template_license, template.esi as __template_esi, template.style_support as __template_style_support, template.emotion as __template_emotion, template.version as __template_version, template.plugin_id as __template_plugin_id, template.parent_id as __template_parent_id, locale.id as __locale_id, locale.locale as __locale_locale, locale.language as __locale_language, locale.territory as __locale_territory, customerGroup.id as __customerGroup_id, customerGroup.groupkey as __customerGroup_groupkey, customerGroup.description as __customerGroup_description, customerGroup.tax as __customerGroup_tax, customerGroup.taxinput as __customerGroup_taxinput, customerGroup.mode as __customerGroup_mode, customerGroup.discount as __customerGroup_discount, customerGroup.minimumorder as __customerGroup_minimumorder, customerGroup.minimumordersurcharge as __customerGroup_minimumordersurcharge, customerGroupAttribute.id as __customerGroupAttribute_id, customerGroupAttribute.customerGroupID as __customerGroupAttribute_customerGroupID, category.id as __category_id, category.parent as __category_parent_id, category.position as __category_position, category.path as __category_path, category.description as __category_description, category.meta_title as __category_metatitle, category.metakeywords as __category_metakeywords, category.metadescription as __category_metadescription, category.cmsheadline as __category_cmsheadline, category.product_box_layout as __category_product_box_layout, category.cmstext as __category_cmstext, category.template as __category_template, category.blog as __category_blog, category.external as __category_external, category.external_target as __category_external_target, category.hidefilter as __category_hidefilter, category.hidetop as __category_hidetop, category.stream_id as __category_stream_id, category.hide_sortings as __category_hide_sortings, categoryAttribute.id as __categoryAttribute_id, categoryAttribute.categoryID as __categoryAttribute_categoryID, categoryAttribute.attribute1 as __categoryAttribute_attribute1, categoryAttribute.attribute2 as __categoryAttribute_attribute2, categoryAttribute.attribute3 as __categoryAttribute_attribute3, categoryAttribute.attribute4 as __categoryAttribute_attribute4, categoryAttribute.attribute5 as __categoryAttribute_attribute5, categoryAttribute.attribute6 as __categoryAttribute_attribute6, categoryAttribute.swkwe_show_soldout as __categoryAttribute_swkwe_show_soldout, categoryAttribute.swkwe_emotion_category_slider_media as __categoryAttribute_swkwe_emotion_category_slider_media, media.id as __media_id, media.albumID as __media_albumID, media.name as __media_name, media.description as __media_description, media.path as __media_path, media.type as __media_type, media.extension as __media_extension, media.file_size as __media_file_size, media.width as __media_width, media.height as __media_height, media.userID as __media_userID, media.created as __media_created, mediaSettings.id as __mediaSettings_id, mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, mediaSettings.icon as __mediaSettings_icon, mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, mediaAttribute.id as __mediaAttribute_id, mediaAttribute.mediaID as __mediaAttribute_mediaID FROM s_core_shops shop LEFT JOIN s_core_shops_attributes shopAttribute ON shopAttribute.shopID = shop.id LEFT JOIN s_core_currencies currency ON currency.id = shop.currency_id LEFT JOIN s_core_templates template ON shop.template_id = template.id LEFT JOIN s_core_locales locale ON locale.id = shop.locale_id LEFT JOIN s_core_customergroups customerGroup ON customerGroup.id = shop.customer_group_id LEFT JOIN s_categories category ON category.id = shop.category_id LEFT JOIN s_core_customergroups_attributes customerGroupAttribute ON customerGroupAttribute.customerGroupID = customerGroup.id LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id LEFT JOIN s_media media ON media.id = category.mediaID LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id WHERE shop.id IN (: ids) |
array:1 [ ":ids" => array:1 [ 0 => 1 ] ] |
0.0009 ms |
SELECT customerGroup.id as __customerGroup_id, customerGroup.groupkey as __customerGroup_groupkey, customerGroup.description as __customerGroup_description, customerGroup.tax as __customerGroup_tax, customerGroup.taxinput as __customerGroup_taxinput, customerGroup.mode as __customerGroup_mode, customerGroup.discount as __customerGroup_discount, customerGroup.minimumorder as __customerGroup_minimumorder, customerGroup.minimumordersurcharge as __customerGroup_minimumordersurcharge, customerGroupAttribute.id as __customerGroupAttribute_id, customerGroupAttribute.customerGroupID as __customerGroupAttribute_customerGroupID FROM s_core_customergroups customerGroup LEFT JOIN s_core_customergroups_attributes customerGroupAttribute ON customerGroupAttribute.customerGroupID = customerGroup.id WHERE customerGroup.groupkey IN (: keys) |
array:1 [ ":keys" => array:2 [ 0 => "EK" 1 => "EK" ] ] |
0.0004 ms |
SELECT currency.id as __currency_id, currency.currency as __currency_currency, currency.name as __currency_name, currency.standard as __currency_standard, currency.factor as __currency_factor, currency.templatechar as __currency_templatechar, currency.symbol_position as __currency_symbol_position, currency.position as __currency_position FROM s_core_currencies currency WHERE currency.id IN (: ids) |
array:1 [ ":ids" => array:1 [ 0 => 1 ] ] |
0.0002 ms |
SELECT tax.id as __tax_id, tax.tax as __tax_tax, tax.description as __tax_description FROM s_core_tax tax |
[] |
0.0001 ms |
SELECT taxRule.groupID as __taxRule_groupID, taxRule.tax as __taxRule_tax, taxRule.name as __taxRule_name FROM s_core_tax_rules taxRule WHERE ( ( taxRule.areaID = : area OR taxRule.areaID IS NULL ) ) AND ( ( taxRule.countryID = : country OR taxRule.countryID IS NULL ) ) AND ( ( taxRule.stateID = : state OR taxRule.stateID IS NULL ) ) AND ( ( taxRule.customer_groupID = : customerGroup OR taxRule.customer_groupID IS NULL ) ) AND (taxRule.groupID = : taxId) AND (taxRule.active = 1) ORDER BY taxRule.customer_groupID DESC, taxRule.areaID DESC, taxRule.countryID DESC, taxRule.stateID DESC LIMIT 1 OFFSET 0 |
array:5 [ ":area" => null ":country" => null ":state" => null ":customerGroup" => 1 ":taxId" => "1" ] |
0.0002 ms |
SELECT taxRule.groupID as __taxRule_groupID, taxRule.tax as __taxRule_tax, taxRule.name as __taxRule_name FROM s_core_tax_rules taxRule WHERE ( ( taxRule.areaID = : area OR taxRule.areaID IS NULL ) ) AND ( ( taxRule.countryID = : country OR taxRule.countryID IS NULL ) ) AND ( ( taxRule.stateID = : state OR taxRule.stateID IS NULL ) ) AND ( ( taxRule.customer_groupID = : customerGroup OR taxRule.customer_groupID IS NULL ) ) AND (taxRule.groupID = : taxId) AND (taxRule.active = 1) ORDER BY taxRule.customer_groupID DESC, taxRule.areaID DESC, taxRule.countryID DESC, taxRule.stateID DESC LIMIT 1 OFFSET 0 |
array:5 [ ":area" => null ":country" => null ":state" => null ":customerGroup" => 1 ":taxId" => "4" ] |
0.0002 ms |
SELECT priceGroupDiscount.groupID, priceGroupDiscount.id as __priceGroupDiscount_id, priceGroupDiscount.groupID as __priceGroupDiscount_groupID, priceGroupDiscount.discount as __priceGroupDiscount_discount, priceGroupDiscount.discountstart as __priceGroupDiscount_discountstart, priceGroup.id as __priceGroup_id, priceGroup.description as __priceGroup_description FROM s_core_pricegroups_discounts priceGroupDiscount INNER JOIN s_core_pricegroups priceGroup ON priceGroup.id = priceGroupDiscount.groupID WHERE priceGroupDiscount.customergroupID = : customerGroup GROUP BY priceGroupDiscount.id ORDER BY priceGroupDiscount.groupID ASC, priceGroupDiscount.discountstart ASC |
array:1 [ ":customerGroup" => 1 ] |
0.0003 ms |
SELECT 1 FROM s_core_plugins WHERE name = ? AND active = 1 |
array:1 [ 0 => "SwagCustomProducts" ] |
0.0002 ms |
SELECT emotion.id, emotion.device as devices, emotion.show_listing as showListing, emotion.fullscreen, emotion.customer_stream_ids, emotion.replacement, emotion.position, emotion.listing_visibility, GROUP_CONCAT(shops.shop_id SEPARATOR ',') as shopIds FROM s_emotion emotion LEFT JOIN s_emotion_shops shops ON shops.emotion_id = emotion.id INNER JOIN s_emotion_categories category ON category.emotion_id = emotion.id AND category.category_id = : categoryId WHERE (emotion.active = 1) AND (emotion.is_landingpage = 0) AND ( ( emotion.valid_to >= NOW() OR emotion.valid_to IS NULL ) ) AND ( ( emotion.valid_from <= NOW() OR emotion.valid_from IS NULL ) ) AND (emotion.preview_id IS NULL) GROUP BY emotion.id ORDER BY emotion.position ASC, emotion.id ASC |
array:1 [ ":categoryId" => 3 ] |
0.0005 ms |
SELECT category.id as __category_id, category.parent as __category_parent_id, category.position as __category_position, category.path as __category_path, category.description as __category_description, category.meta_title as __category_metatitle, category.metakeywords as __category_metakeywords, category.metadescription as __category_metadescription, category.cmsheadline as __category_cmsheadline, category.product_box_layout as __category_product_box_layout, category.cmstext as __category_cmstext, category.template as __category_template, category.blog as __category_blog, category.external as __category_external, category.external_target as __category_external_target, category.hidefilter as __category_hidefilter, category.hidetop as __category_hidetop, category.stream_id as __category_stream_id, category.hide_sortings as __category_hide_sortings, categoryAttribute.id as __categoryAttribute_id, categoryAttribute.categoryID as __categoryAttribute_categoryID, categoryAttribute.attribute1 as __categoryAttribute_attribute1, categoryAttribute.attribute2 as __categoryAttribute_attribute2, categoryAttribute.attribute3 as __categoryAttribute_attribute3, categoryAttribute.attribute4 as __categoryAttribute_attribute4, categoryAttribute.attribute5 as __categoryAttribute_attribute5, categoryAttribute.attribute6 as __categoryAttribute_attribute6, categoryAttribute.swkwe_show_soldout as __categoryAttribute_swkwe_show_soldout, categoryAttribute.swkwe_emotion_category_slider_media as __categoryAttribute_swkwe_emotion_category_slider_media, media.id as __media_id, media.albumID as __media_albumID, media.name as __media_name, media.description as __media_description, media.path as __media_path, media.type as __media_type, media.extension as __media_extension, media.file_size as __media_file_size, media.width as __media_width, media.height as __media_height, media.userID as __media_userID, media.created as __media_created, mediaSettings.id as __mediaSettings_id, mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, mediaSettings.icon as __mediaSettings_icon, mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, mediaAttribute.id as __mediaAttribute_id, mediaAttribute.mediaID as __mediaAttribute_mediaID, stream.id as __stream_id, stream.name as __stream_name, stream.description as __stream_description, stream.type as __stream_type, productStreamAttribute.id as __productStreamAttribute_id, productStreamAttribute.streamID as __productStreamAttribute_streamID, GROUP_CONCAT(customerGroups.customergroupID) as __category_customer_groups FROM s_categories category LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id LEFT JOIN s_media media ON media.id = category.mediaID LEFT JOIN s_product_streams stream ON category.stream_id = stream.id LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId WHERE ( category.id IN (: categories) ) AND (category.active = 1) AND ( category.shops IS NULL OR category.shops LIKE : shopId ) GROUP BY category.id |
array:2 [ ":categories" => array:1 [ 0 => 3 ] ":shopId" => "%|1|%" ] |
0.0006 ms |
SELECT s0_.show_listing AS show_listing_0, s0_.template_id AS template_id_1, s0_.id AS id_2, s0_.parent_id AS parent_id_3, s0_.active AS active_4, s0_.name AS name_5, s0_.userID AS userID_6, s0_.position AS position_7, s0_.device AS device_8, s0_.fullscreen AS fullscreen_9, s0_.valid_from AS valid_from_10, s0_.is_landingpage AS is_landingpage_11, s0_.seo_title AS seo_title_12, s0_.seo_keywords AS seo_keywords_13, s0_.seo_description AS seo_description_14, s0_.valid_to AS valid_to_15, s0_.create_date AS create_date_16, s0_.modified AS modified_17, s0_.`rows` AS rows_18, s0_.cols AS cols_19, s0_.cell_spacing AS cell_spacing_20, s0_.cell_height AS cell_height_21, s0_.article_height AS article_height_22, s0_.mode AS mode_23, s0_.preview_id AS preview_id_24, s0_.preview_secret AS preview_secret_25, s0_.listing_visibility AS listing_visibility_26, s0_.customer_stream_ids AS customer_stream_ids_27, s0_.replacement AS replacement_28 FROM s_emotion s0_ INNER JOIN s_emotion_categories s2_ ON s0_.id = s2_.emotion_id INNER JOIN s_categories s1_ ON s1_.id = s2_.category_id WHERE s1_.id = ? AND ( ( s0_.valid_from <= ? OR s0_.valid_from IS NULL ) ) AND ( ( s0_.valid_to >= ? OR s0_.valid_to IS NULL ) ) AND s0_.is_landingpage = 0 AND s0_.active = 1 |
array:3 [ 0 => 3 1 => DateTime @1734909360 {#3279 : 2024-12-23 00:16:00.191949 Europe/Berlin (+01:00) } 2 => DateTime @1734909360 {#3279} ] |
0.0003 ms |
SELECT category.id as __category_id, category.parent as __category_parent_id, category.position as __category_position, category.path as __category_path, category.description as __category_description, category.meta_title as __category_metatitle, category.metakeywords as __category_metakeywords, category.metadescription as __category_metadescription, category.cmsheadline as __category_cmsheadline, category.product_box_layout as __category_product_box_layout, category.cmstext as __category_cmstext, category.template as __category_template, category.blog as __category_blog, category.external as __category_external, category.external_target as __category_external_target, category.hidefilter as __category_hidefilter, category.hidetop as __category_hidetop, category.stream_id as __category_stream_id, category.hide_sortings as __category_hide_sortings, categoryAttribute.id as __categoryAttribute_id, categoryAttribute.categoryID as __categoryAttribute_categoryID, categoryAttribute.attribute1 as __categoryAttribute_attribute1, categoryAttribute.attribute2 as __categoryAttribute_attribute2, categoryAttribute.attribute3 as __categoryAttribute_attribute3, categoryAttribute.attribute4 as __categoryAttribute_attribute4, categoryAttribute.attribute5 as __categoryAttribute_attribute5, categoryAttribute.attribute6 as __categoryAttribute_attribute6, categoryAttribute.swkwe_show_soldout as __categoryAttribute_swkwe_show_soldout, categoryAttribute.swkwe_emotion_category_slider_media as __categoryAttribute_swkwe_emotion_category_slider_media, media.id as __media_id, media.albumID as __media_albumID, media.name as __media_name, media.description as __media_description, media.path as __media_path, media.type as __media_type, media.extension as __media_extension, media.file_size as __media_file_size, media.width as __media_width, media.height as __media_height, media.userID as __media_userID, media.created as __media_created, mediaSettings.id as __mediaSettings_id, mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, mediaSettings.icon as __mediaSettings_icon, mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, mediaAttribute.id as __mediaAttribute_id, mediaAttribute.mediaID as __mediaAttribute_mediaID, stream.id as __stream_id, stream.name as __stream_name, stream.description as __stream_description, stream.type as __stream_type, productStreamAttribute.id as __productStreamAttribute_id, productStreamAttribute.streamID as __productStreamAttribute_streamID, GROUP_CONCAT(customerGroups.customergroupID) as __category_customer_groups FROM s_categories category LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id LEFT JOIN s_media media ON media.id = category.mediaID LEFT JOIN s_product_streams stream ON category.stream_id = stream.id LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId WHERE ( category.id IN (: categories) ) AND (category.active = 1) AND ( category.shops IS NULL OR category.shops LIKE : shopId ) GROUP BY category.id |
array:2 [ ":categories" => array:1 [ 0 => 1 ] ":shopId" => "%|1|%" ] |
0.0005 ms |
SELECT category.id as __category_id, category.parent as __category_parent_id, category.position as __category_position, category.path as __category_path, category.description as __category_description, category.meta_title as __category_metatitle, category.metakeywords as __category_metakeywords, category.metadescription as __category_metadescription, category.cmsheadline as __category_cmsheadline, category.product_box_layout as __category_product_box_layout, category.cmstext as __category_cmstext, category.template as __category_template, category.blog as __category_blog, category.external as __category_external, category.external_target as __category_external_target, category.hidefilter as __category_hidefilter, category.hidetop as __category_hidetop, category.stream_id as __category_stream_id, category.hide_sortings as __category_hide_sortings, categoryAttribute.id as __categoryAttribute_id, categoryAttribute.categoryID as __categoryAttribute_categoryID, categoryAttribute.attribute1 as __categoryAttribute_attribute1, categoryAttribute.attribute2 as __categoryAttribute_attribute2, categoryAttribute.attribute3 as __categoryAttribute_attribute3, categoryAttribute.attribute4 as __categoryAttribute_attribute4, categoryAttribute.attribute5 as __categoryAttribute_attribute5, categoryAttribute.attribute6 as __categoryAttribute_attribute6, categoryAttribute.swkwe_show_soldout as __categoryAttribute_swkwe_show_soldout, categoryAttribute.swkwe_emotion_category_slider_media as __categoryAttribute_swkwe_emotion_category_slider_media, media.id as __media_id, media.albumID as __media_albumID, media.name as __media_name, media.description as __media_description, media.path as __media_path, media.type as __media_type, media.extension as __media_extension, media.file_size as __media_file_size, media.width as __media_width, media.height as __media_height, media.userID as __media_userID, media.created as __media_created, mediaSettings.id as __mediaSettings_id, mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, mediaSettings.icon as __mediaSettings_icon, mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, mediaAttribute.id as __mediaAttribute_id, mediaAttribute.mediaID as __mediaAttribute_mediaID, stream.id as __stream_id, stream.name as __stream_name, stream.description as __stream_description, stream.type as __stream_type, productStreamAttribute.id as __productStreamAttribute_id, productStreamAttribute.streamID as __productStreamAttribute_streamID, GROUP_CONCAT(customerGroups.customergroupID) as __category_customer_groups FROM s_categories category LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id LEFT JOIN s_media media ON media.id = category.mediaID LEFT JOIN s_product_streams stream ON category.stream_id = stream.id LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId WHERE ( category.id IN (: categories) ) AND (category.active = 1) AND ( category.shops IS NULL OR category.shops LIKE : shopId ) GROUP BY category.id |
array:2 [ ":categories" => array:1 [ 0 => 0 ] ":shopId" => "%|1|%" ] |
0.0005 ms |
SELECT count(category.id) FROM s_categories category WHERE parent = : id |
array:1 [ "id" => 3 ] |
0.0002 ms |
SELECT emotion.id FROM s_emotion emotion INNER JOIN s_emotion_categories categories ON categories.emotion_id = emotion.id AND categories.category_id = : id WHERE emotion.customer_stream_ids IS NOT NULL AND emotion.active = 1 LIMIT 1 |
array:1 [ ":id" => 3 ] |
0.0002 ms |
SELECT s0_.id AS id_0 FROM s_emarketing_banners s0_ WHERE ( ( s0_.valid_from <= ? OR ( s0_.valid_from = ? OR s0_.valid_from IS NULL ) ) ) AND ( ( s0_.valid_to >= ? OR ( s0_.valid_to = ? OR s0_.valid_to IS NULL ) ) ) AND s0_.categoryID = ? |
array:5 [ 0 => DateTime @1734909360 {#3280 : 2024-12-23 00:16:00.195683 Europe/Berlin (+01:00) } 1 => null 2 => DateTime @1734909360 {#3280} 3 => null 4 => 3 ] |
0.0002 ms |
SELECT template.id, template.id, template.template, template.plugin_id, template.parent_id, plugin.name as plugin_name, plugin.namespace as plugin_namespace, plugin.source as plugin_source FROM s_core_templates template LEFT JOIN s_core_plugins plugin ON plugin.id = template.plugin_id |
[] |
0.0002 ms |
SELECT template.id, template.id, template.template, template.plugin_id, template.parent_id, plugin.name as plugin_name, plugin.namespace as plugin_namespace, plugin.source as plugin_source FROM s_core_templates template LEFT JOIN s_core_plugins plugin ON plugin.id = template.plugin_id |
[] |
0.0002 ms |
SELECT element.template_id, element.name, element_value.value, element.default_value as defaultValue, element.type FROM s_core_templates_config_elements element LEFT JOIN s_core_templates_config_values element_value ON element_value.element_id = element.id AND element_value.shop_id = : shopId WHERE element.template_id IN (: ids) |
array:2 [ ":shopId" => 1 ":ids" => array:2 [ 0 => 23 1 => 22 ] ] |
0.0006 ms |
SELECT shop.id, REPLACE(locale.locale, "_", "-") as locale FROM s_core_shops shop INNER JOIN s_core_locales locale ON locale.id = shop.locale_id WHERE ( (shop.id = : shopId) OR (shop.main_id = : shopId) ) AND (active = 1) |
array:1 [ "shopId" => 1 ] |
0.0002 ms |
SELECT category.path FROM s_categories category WHERE category.id = : id |
array:1 [ ":id" => 3 ] |
0.0002 ms |
SELECT category.id, category.parent FROM s_categories category WHERE ( ( category.parent IN(: parentId) OR category.id IN (: parentId) ) ) AND (category.active = 1) AND ( category.shops IS NULL OR category.shops LIKE : shopId ) ORDER BY category.position ASC, category.id ASC |
array:2 [ ":parentId" => array:1 [ 0 => 3 ] ":shopId" => "%|1|%" ] |
0.0003 ms |
SELECT category.id as __category_id, category.parent as __category_parent_id, category.position as __category_position, category.path as __category_path, category.description as __category_description, category.meta_title as __category_metatitle, category.metakeywords as __category_metakeywords, category.metadescription as __category_metadescription, category.cmsheadline as __category_cmsheadline, category.product_box_layout as __category_product_box_layout, category.cmstext as __category_cmstext, category.template as __category_template, category.blog as __category_blog, category.external as __category_external, category.external_target as __category_external_target, category.hidefilter as __category_hidefilter, category.hidetop as __category_hidetop, category.stream_id as __category_stream_id, category.hide_sortings as __category_hide_sortings, categoryAttribute.id as __categoryAttribute_id, categoryAttribute.categoryID as __categoryAttribute_categoryID, categoryAttribute.attribute1 as __categoryAttribute_attribute1, categoryAttribute.attribute2 as __categoryAttribute_attribute2, categoryAttribute.attribute3 as __categoryAttribute_attribute3, categoryAttribute.attribute4 as __categoryAttribute_attribute4, categoryAttribute.attribute5 as __categoryAttribute_attribute5, categoryAttribute.attribute6 as __categoryAttribute_attribute6, categoryAttribute.swkwe_show_soldout as __categoryAttribute_swkwe_show_soldout, categoryAttribute.swkwe_emotion_category_slider_media as __categoryAttribute_swkwe_emotion_category_slider_media, media.id as __media_id, media.albumID as __media_albumID, media.name as __media_name, media.description as __media_description, media.path as __media_path, media.type as __media_type, media.extension as __media_extension, media.file_size as __media_file_size, media.width as __media_width, media.height as __media_height, media.userID as __media_userID, media.created as __media_created, mediaSettings.id as __mediaSettings_id, mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, mediaSettings.icon as __mediaSettings_icon, mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, mediaAttribute.id as __mediaAttribute_id, mediaAttribute.mediaID as __mediaAttribute_mediaID, stream.id as __stream_id, stream.name as __stream_name, stream.description as __stream_description, stream.type as __stream_type, productStreamAttribute.id as __productStreamAttribute_id, productStreamAttribute.streamID as __productStreamAttribute_streamID, GROUP_CONCAT(customerGroups.customergroupID) as __category_customer_groups FROM s_categories category LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id LEFT JOIN s_media media ON media.id = category.mediaID LEFT JOIN s_product_streams stream ON category.stream_id = stream.id LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId WHERE ( category.id IN (: categories) ) AND (category.active = 1) AND ( category.shops IS NULL OR category.shops LIKE : shopId ) GROUP BY category.id |
array:2 [ ":categories" => array:10 [ 0 => 3 1 => 20 2 => 3 3 => 5 4 => 6 5 => 7 6 => 15 7 => 16 8 => 17 9 => 13 ] ":shopId" => "%|1|%" ] |
0.0008 ms |
SELECT parent as id, COUNT(id) as childrenCount FROM s_categories category WHERE ( parent IN (: ids) ) AND (category.active = 1) GROUP BY parent |
array:1 [ ":ids" => array:10 [ 0 => 3 1 => 20 2 => 3 3 => 5 4 => 6 5 => 7 6 => 15 7 => 16 8 => 17 9 => 13 ] ] |
0.0002 ms |
SELECT shop.id as __shop_id, shop.main_id as __shop_main_id, shop.name as __shop_name, shop.title as __shop_title, shop.position as __shop_position, shop.host as __shop_host, shop.base_path as __shop_base_path, shop.base_url as __shop_base_url, shop.hosts as __shop_hosts, shop.secure as __shop_secure, shop.template_id as __shop_template_id, shop.document_template_id as __shop_document_template_id, shop.category_id as __shop_category_id, shop.locale_id as __shop_locale_id, shop.currency_id as __shop_currency_id, shop.customer_group_id as __shop_customer_group_id, shop.fallback_id as __shop_fallback_id, shop.customer_scope as __shop_customer_scope, shop.default as __shop_default, shop.active as __shop_active, shopAttribute.id as __shopAttribute_id, shopAttribute.shopID as __shopAttribute_shopID, currency.id as __currency_id, currency.currency as __currency_currency, currency.name as __currency_name, currency.standard as __currency_standard, currency.factor as __currency_factor, currency.templatechar as __currency_templatechar, currency.symbol_position as __currency_symbol_position, currency.position as __currency_position, template.id as __template_id, template.template as __template_template, template.name as __template_name, template.description as __template_description, template.author as __template_author, template.license as __template_license, template.esi as __template_esi, template.style_support as __template_style_support, template.emotion as __template_emotion, template.version as __template_version, template.plugin_id as __template_plugin_id, template.parent_id as __template_parent_id, locale.id as __locale_id, locale.locale as __locale_locale, locale.language as __locale_language, locale.territory as __locale_territory, customerGroup.id as __customerGroup_id, customerGroup.groupkey as __customerGroup_groupkey, customerGroup.description as __customerGroup_description, customerGroup.tax as __customerGroup_tax, customerGroup.taxinput as __customerGroup_taxinput, customerGroup.mode as __customerGroup_mode, customerGroup.discount as __customerGroup_discount, customerGroup.minimumorder as __customerGroup_minimumorder, customerGroup.minimumordersurcharge as __customerGroup_minimumordersurcharge, customerGroupAttribute.id as __customerGroupAttribute_id, customerGroupAttribute.customerGroupID as __customerGroupAttribute_customerGroupID, category.id as __category_id, category.parent as __category_parent_id, category.position as __category_position, category.path as __category_path, category.description as __category_description, category.meta_title as __category_metatitle, category.metakeywords as __category_metakeywords, category.metadescription as __category_metadescription, category.cmsheadline as __category_cmsheadline, category.product_box_layout as __category_product_box_layout, category.cmstext as __category_cmstext, category.template as __category_template, category.blog as __category_blog, category.external as __category_external, category.external_target as __category_external_target, category.hidefilter as __category_hidefilter, category.hidetop as __category_hidetop, category.stream_id as __category_stream_id, category.hide_sortings as __category_hide_sortings, categoryAttribute.id as __categoryAttribute_id, categoryAttribute.categoryID as __categoryAttribute_categoryID, categoryAttribute.attribute1 as __categoryAttribute_attribute1, categoryAttribute.attribute2 as __categoryAttribute_attribute2, categoryAttribute.attribute3 as __categoryAttribute_attribute3, categoryAttribute.attribute4 as __categoryAttribute_attribute4, categoryAttribute.attribute5 as __categoryAttribute_attribute5, categoryAttribute.attribute6 as __categoryAttribute_attribute6, categoryAttribute.swkwe_show_soldout as __categoryAttribute_swkwe_show_soldout, categoryAttribute.swkwe_emotion_category_slider_media as __categoryAttribute_swkwe_emotion_category_slider_media, media.id as __media_id, media.albumID as __media_albumID, media.name as __media_name, media.description as __media_description, media.path as __media_path, media.type as __media_type, media.extension as __media_extension, media.file_size as __media_file_size, media.width as __media_width, media.height as __media_height, media.userID as __media_userID, media.created as __media_created, mediaSettings.id as __mediaSettings_id, mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, mediaSettings.icon as __mediaSettings_icon, mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, mediaAttribute.id as __mediaAttribute_id, mediaAttribute.mediaID as __mediaAttribute_mediaID FROM s_core_shops shop LEFT JOIN s_core_shops_attributes shopAttribute ON shopAttribute.shopID = shop.id LEFT JOIN s_core_currencies currency ON currency.id = shop.currency_id LEFT JOIN s_core_templates template ON shop.template_id = template.id LEFT JOIN s_core_locales locale ON locale.id = shop.locale_id LEFT JOIN s_core_customergroups customerGroup ON customerGroup.id = shop.customer_group_id LEFT JOIN s_categories category ON category.id = shop.category_id LEFT JOIN s_core_customergroups_attributes customerGroupAttribute ON customerGroupAttribute.customerGroupID = customerGroup.id LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id LEFT JOIN s_media media ON media.id = category.mediaID LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id WHERE shop.id IN (: ids) |
array:1 [ ":ids" => array:1 [ 0 => 1 ] ] |
0.0007 ms |
SELECT customerGroup.id as __customerGroup_id, customerGroup.groupkey as __customerGroup_groupkey, customerGroup.description as __customerGroup_description, customerGroup.tax as __customerGroup_tax, customerGroup.taxinput as __customerGroup_taxinput, customerGroup.mode as __customerGroup_mode, customerGroup.discount as __customerGroup_discount, customerGroup.minimumorder as __customerGroup_minimumorder, customerGroup.minimumordersurcharge as __customerGroup_minimumordersurcharge, customerGroupAttribute.id as __customerGroupAttribute_id, customerGroupAttribute.customerGroupID as __customerGroupAttribute_customerGroupID FROM s_core_customergroups customerGroup LEFT JOIN s_core_customergroups_attributes customerGroupAttribute ON customerGroupAttribute.customerGroupID = customerGroup.id WHERE customerGroup.groupkey IN (: keys) |
array:1 [ ":keys" => array:2 [ 0 => "EK" 1 => "EK" ] ] |
0.0003 ms |
SELECT tax.id as __tax_id, tax.tax as __tax_tax, tax.description as __tax_description FROM s_core_tax tax |
[] |
0.0001 ms |
SELECT taxRule.groupID as __taxRule_groupID, taxRule.tax as __taxRule_tax, taxRule.name as __taxRule_name FROM s_core_tax_rules taxRule WHERE ( ( taxRule.areaID = : area OR taxRule.areaID IS NULL ) ) AND ( ( taxRule.countryID = : country OR taxRule.countryID IS NULL ) ) AND ( ( taxRule.stateID = : state OR taxRule.stateID IS NULL ) ) AND ( ( taxRule.customer_groupID = : customerGroup OR taxRule.customer_groupID IS NULL ) ) AND (taxRule.groupID = : taxId) AND (taxRule.active = 1) ORDER BY taxRule.customer_groupID DESC, taxRule.areaID DESC, taxRule.countryID DESC, taxRule.stateID DESC LIMIT 1 OFFSET 0 |
array:5 [ ":area" => null ":country" => null ":state" => null ":customerGroup" => 1 ":taxId" => "1" ] |
0.0002 ms |
SELECT taxRule.groupID as __taxRule_groupID, taxRule.tax as __taxRule_tax, taxRule.name as __taxRule_name FROM s_core_tax_rules taxRule WHERE ( ( taxRule.areaID = : area OR taxRule.areaID IS NULL ) ) AND ( ( taxRule.countryID = : country OR taxRule.countryID IS NULL ) ) AND ( ( taxRule.stateID = : state OR taxRule.stateID IS NULL ) ) AND ( ( taxRule.customer_groupID = : customerGroup OR taxRule.customer_groupID IS NULL ) ) AND (taxRule.groupID = : taxId) AND (taxRule.active = 1) ORDER BY taxRule.customer_groupID DESC, taxRule.areaID DESC, taxRule.countryID DESC, taxRule.stateID DESC LIMIT 1 OFFSET 0 |
array:5 [ ":area" => null ":country" => null ":state" => null ":customerGroup" => 1 ":taxId" => "4" ] |
0.0002 ms |
SELECT priceGroupDiscount.groupID, priceGroupDiscount.id as __priceGroupDiscount_id, priceGroupDiscount.groupID as __priceGroupDiscount_groupID, priceGroupDiscount.discount as __priceGroupDiscount_discount, priceGroupDiscount.discountstart as __priceGroupDiscount_discountstart, priceGroup.id as __priceGroup_id, priceGroup.description as __priceGroup_description FROM s_core_pricegroups_discounts priceGroupDiscount INNER JOIN s_core_pricegroups priceGroup ON priceGroup.id = priceGroupDiscount.groupID WHERE priceGroupDiscount.customergroupID = : customerGroup GROUP BY priceGroupDiscount.id ORDER BY priceGroupDiscount.groupID ASC, priceGroupDiscount.discountstart ASC |
array:1 [ ":customerGroup" => 1 ] |
0.0002 ms |
SELECT page.id, page.description, page.link, page.target, page.parentID, groups.key as `group`, mapping.key as mapping FROM s_cms_static page LEFT JOIN s_cms_static_groups `groups` ON groups.active = 1 LEFT JOIN s_cms_static_groups mapping ON groups.mapping_id = mapping.id LEFT JOIN s_core_shop_pages shops ON groups.id = shops.group_id AND shops.shop_id = : shopId WHERE (groups.active = 1) AND (page.active = 1) AND ( CONCAT('|', page.grouping, '|') LIKE CONCAT('%|', groups.key, '|%') ) AND ( ( mapping.id IS NULL OR shops.shop_id IS NOT NULL ) ) AND ( ( mapping.id IS NULL OR mapping.active = 1 ) ) AND ( ( page.shop_ids IS NULL OR page.shop_ids LIKE : staticShopId ) ) ORDER BY parentID ASC, mapping.key ASC, page.position ASC, page.description ASC |
array:2 [ ":shopId" => 1 ":staticShopId" => "%|1|%" ] |
0.0004 ms |
SELECT org_path, path FROM s_core_rewrite_urls WHERE subshopID =: shopId AND org_path IN (: orgPath) AND main = 1 ORDER BY id DESC |
array:2 [ ":shopId" => 1 ":orgPath" => array:15 [ 39 => "sViewport=forms&sFid=9" 21 => "sViewport=registerFC" 26 => "sViewport=newsletter" 37 => "sViewport=forms&sFid=8" 43 => "sViewport=custom&sCustom=43" 9 => "sViewport=custom&sCustom=9" 2 => "sViewport=custom&sCustom=2" 1 => "sViewport=forms&sFid=5" 6 => "sViewport=custom&sCustom=6" 41 => "sViewport=forms&sFid=10" 8 => "sViewport=custom&sCustom=8" 7 => "sViewport=custom&sCustom=7" 45 => "sViewport=custom&sCustom=45" 4 => "sViewport=custom&sCustom=4" 3 => "sViewport=custom&sCustom=3" ] ] |
0.0005 ms |
SELECT valid_from, valid_to FROM s_emotion emotion INNER JOIN s_emotion_categories mapping ON mapping.emotion_id = emotion.id AND mapping.category_id = : resourceId WHERE (emotion.active = 1) AND ( ( emotion.valid_from IS NOT NULL OR emotion.valid_to IS NOT NULL ) ) |
array:1 [ ":resourceId" => 3 ] |
0.0002 ms |
SELECT valid_from, valid_to FROM s_emotion emotion INNER JOIN s_emotion_categories mapping ON mapping.emotion_id = emotion.id AND mapping.category_id = : resourceId WHERE (emotion.active = 1) AND ( ( emotion.valid_from IS NOT NULL OR emotion.valid_to IS NOT NULL ) ) |
array:1 [ ":resourceId" => 3 ] |
0.0002 ms |
SELECT valid_from, valid_to FROM s_emotion emotion INNER JOIN s_emotion_categories mapping ON mapping.emotion_id = emotion.id AND mapping.category_id = : resourceId WHERE (emotion.active = 1) AND ( ( emotion.valid_from IS NOT NULL OR emotion.valid_to IS NOT NULL ) ) |
array:1 [ ":resourceId" => 3 ] |
0.0002 ms |
SELECT s_core_config_values.value FROM s_core_config_values INNER JOIN s_core_config_elements ON s_core_config_values.element_id = s_core_config_elements.id AND s_core_config_elements.`name` LIKE 'assetTimestamp' WHERE s_core_config_values.shop_id = : shopId |
array:1 [ "shopId" => 1 ] |
0.0004 ms |
SELECT s0_.id AS id_0, s0_.compiler_force AS compiler_force_1, s0_.compiler_create_source_map AS compiler_create_source_map_2, s0_.compiler_compress_css AS compiler_compress_css_3, s0_.compiler_compress_js AS compiler_compress_js_4, s0_.force_reload_snippets AS force_reload_snippets_5 FROM s_core_theme_settings s0_ ORDER BY s0_.id ASC LIMIT 1 OFFSET 0 |
[] |
0.0001 ms |
SELECT s_core_config_values.value FROM s_core_config_values INNER JOIN s_core_config_elements ON s_core_config_values.element_id = s_core_config_elements.id AND s_core_config_elements.`name` LIKE 'assetTimestamp' WHERE s_core_config_values.shop_id = : shopId |
array:1 [ "shopId" => 1 ] |
0.0003 ms |
SELECT s0_.id AS id_0, s0_.compiler_force AS compiler_force_1, s0_.compiler_create_source_map AS compiler_create_source_map_2, s0_.compiler_compress_css AS compiler_compress_css_3, s0_.compiler_compress_js AS compiler_compress_js_4, s0_.force_reload_snippets AS force_reload_snippets_5 FROM s_core_theme_settings s0_ ORDER BY s0_.id ASC LIMIT 1 OFFSET 0 |
[] |
0.0001 ms |
SELECT org_path, path FROM s_core_rewrite_urls WHERE subshopID =: shopId AND org_path IN (: orgPath) AND main = 1 ORDER BY id DESC |
array:2 [ ":shopId" => 1 ":orgPath" => array:15 [ 0 => "sViewport=cat&sCategory=20" 1 => "sViewport=cat&sCategory=5" 2 => "sViewport=cat&sCategory=6" 3 => "sViewport=cat&sCategory=7" 4 => "sViewport=cat&sCategory=15" 5 => "sViewport=cat&sCategory=16" 6 => "sViewport=cat&sCategory=17" 7 => "sViewport=cat&sCategory=20" 8 => "sViewport=cat&sCategory=5" 9 => "sViewport=cat&sCategory=6" 10 => "sViewport=cat&sCategory=7" 11 => "sViewport=cat&sCategory=15" 12 => "sViewport=cat&sCategory=16" 13 => "sViewport=cat&sCategory=17" 14 => "sViewport=blog&sCategory=13" ] ] |
0.0004 ms |
SELECT host, hosts FROM s_core_shops WHERE id = : id |
array:1 [ ":id" => 1 ] |
0.0001 ms |
SELECT expiry, modified FROM s_core_sessions WHERE id = ? |
array:1 [ 0 => "eebb02b3a11282bbce58c856e9a66b736d2325f940090bfe173fa7cff9943600" ] |
0.0002 ms |
SELECT ce.subscribe as name, ce.listener, ce.position, cp.name as plugin FROM s_core_subscribes ce JOIN s_core_plugins cp ON cp.id = ce.pluginID AND cp.active = 1 AND cp.namespace = ? WHERE ce.type = 0 ORDER BY name, position |
array:1 [ 1 => "Core" ] |
0.7858 ms |
SELECT ce.subscribe as name, ce.listener, ce.position, cp.name as plugin FROM s_core_subscribes ce JOIN s_core_plugins cp ON cp.id = ce.pluginID AND cp.active = 1 AND cp.namespace = ? WHERE ce.type = 0 ORDER BY name, position |
array:1 [ 1 => "Frontend" ] |
0.3760 ms |
SELECT ce.subscribe as name, ce.listener, ce.position, cp.name as plugin FROM s_core_subscribes ce JOIN s_core_plugins cp ON cp.id = ce.pluginID AND cp.active = 1 AND cp.namespace = ? WHERE ce.type = 0 ORDER BY name, position |
array:1 [ 1 => "Backend" ] |
0.3450 ms |
SELECT `s_core_snippets`.`name`, `s_core_snippets`.`value` FROM `s_core_snippets` WHERE ( namespace = 'frontend/cookie_consent/groups' ) AND (shopID = '1') AND (localeID = '1') |
[] |
0.2611 ms |
SELECT `s_core_snippets`.`name`, `s_core_snippets`.`value` FROM `s_core_snippets` WHERE ( namespace = 'frontend/cookie_consent/groups' ) AND (shopID = '1') AND (localeID = '2') |
[] |
0.1709 ms |
SELECT `s_core_snippets`.`name`, `s_core_snippets`.`value` FROM `s_core_snippets` WHERE ( namespace = 'frontend/cookie_consent/cookies' ) AND (shopID = '1') AND (localeID = '1') |
[] |
0.2971 ms |
SELECT `s_core_snippets`.`name`, `s_core_snippets`.`value` FROM `s_core_snippets` WHERE ( namespace = 'frontend/cookie_consent/cookies' ) AND (shopID = '1') AND (localeID = '2') |
[] |
0.2961 ms |
SELECT `id` FROM `s_core_config_elements` WHERE `name` LIKE 'routerlastupdate' |
[] |
0.2501 ms |
SELECT v.value FROM s_core_config_elements e, s_core_config_values v WHERE v.element_id = e.id AND e.id = ? AND v.shop_id = ? |
array:2 [ 1 => "658" 2 => 1 ] |
0.1462 ms |