Queries
168
Total Queries
0.0038 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.0004 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.0002 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.0003 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.0006 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.0002 ms |
SELECT subshopID as shopId, path, org_path as orgPath, main FROM s_core_rewrite_urls WHERE path LIKE : pathInfo ORDER BY subshopID = : shopId DESC, main DESC LIMIT 1 |
array:2 [ ":shopId" => 1 ":pathInfo" => "freizeit-elektro/50/bowdenzug-mit-kugelkopf-1400-mm" ] |
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 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.0008 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 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.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" => "1" ] |
0.0003 ms |
SELECT taxRule.groupID as __taxRule_groupID, taxRule.tax as __taxRule_tax, taxRule.name as __taxRule_name FROM s_core_tax_rules taxRule WHERE ( ( taxRule.areaID = : area OR taxRule.areaID IS NULL ) ) AND ( ( taxRule.countryID = : country OR taxRule.countryID IS NULL ) ) AND ( ( taxRule.stateID = : state OR taxRule.stateID IS NULL ) ) AND ( ( taxRule.customer_groupID = : customerGroup OR taxRule.customer_groupID IS NULL ) ) AND (taxRule.groupID = : taxId) AND (taxRule.active = 1) ORDER BY taxRule.customer_groupID DESC, taxRule.areaID DESC, taxRule.countryID DESC, taxRule.stateID DESC LIMIT 1 OFFSET 0 |
array:5 [ ":area" => null ":country" => null ":state" => null ":customerGroup" => 1 ":taxId" => "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 1 FROM s_core_plugins WHERE name = ? AND active = 1 |
array:1 [ 0 => "SwagCustomProducts" ] |
0.0001 ms |
SELECT NOW() AS current, cf.value AS last, ( SELECT 1 FROM s_search_index LIMIT 1 ) AS not_force FROM s_core_config_elements ce, s_core_config_values cf WHERE ce.name = 'fuzzysearchlastupdate' AND cf.element_id = ce.id AND cf.shop_id = 1 |
[] |
0.0005 ms |
SELECT template.id, template.id, template.template, template.plugin_id, template.parent_id, plugin.name as plugin_name, plugin.namespace as plugin_namespace, plugin.source as plugin_source FROM s_core_templates template LEFT JOIN s_core_plugins plugin ON plugin.id = template.plugin_id |
[] |
0.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 t0.sorting_ids AS sorting_ids_1, t0.hide_sortings AS hide_sortings_2, t0.facet_ids AS facet_ids_3, t0.shops AS shops_4, t0.id AS id_5, t0.parent AS parent_6, t0.stream_id AS stream_id_7, t0.description AS description_8, t0.position AS position_9, t0.meta_title AS meta_title_10, t0.metakeywords AS metakeywords_11, t0.metadescription AS metadescription_12, t0.cmsheadline AS cmsheadline_13, t0.cmstext AS cmstext_14, t0.active AS active_15, t0.template AS template_16, t0.product_box_layout AS product_box_layout_17, t0.blog AS blog_18, t0.path AS path_19, t0.external AS external_20, t0.external_target AS external_target_21, t0.hidefilter AS hidefilter_22, t0.hidetop AS hidetop_23, t0.changed AS changed_24, t0.added AS added_25, t0.mediaID AS mediaID_26, t27.id AS id_28, t27.categoryID AS categoryID_29, t27.attribute1 AS attribute1_30, t27.attribute2 AS attribute2_31, t27.attribute3 AS attribute3_32, t27.attribute4 AS attribute4_33, t27.attribute5 AS attribute5_34, t27.attribute6 AS attribute6_35, t27.swkwe_show_soldout AS swkwe_show_soldout_36, t27.swkwe_emotion_category_slider_media AS swkwe_emotion_category_slider_media_37, t27.categoryID AS categoryID_38, t0.mediaID AS mediaID_39, t0.stream_id AS stream_id_40, t0.parent AS parent_41 FROM s_categories t0 LEFT JOIN s_categories_attributes t27 ON t27.categoryID = t0.id WHERE t0.id = ? |
array:1 [ 0 => "7" ] |
0.0003 ms |
SELECT t0.sorting_ids AS sorting_ids_1, t0.hide_sortings AS hide_sortings_2, t0.facet_ids AS facet_ids_3, t0.shops AS shops_4, t0.id AS id_5, t0.parent AS parent_6, t0.stream_id AS stream_id_7, t0.description AS description_8, t0.position AS position_9, t0.meta_title AS meta_title_10, t0.metakeywords AS metakeywords_11, t0.metadescription AS metadescription_12, t0.cmsheadline AS cmsheadline_13, t0.cmstext AS cmstext_14, t0.active AS active_15, t0.template AS template_16, t0.product_box_layout AS product_box_layout_17, t0.blog AS blog_18, t0.path AS path_19, t0.external AS external_20, t0.external_target AS external_target_21, t0.hidefilter AS hidefilter_22, t0.hidetop AS hidetop_23, t0.changed AS changed_24, t0.added AS added_25, t0.mediaID AS mediaID_26, t27.id AS id_28, t27.categoryID AS categoryID_29, t27.attribute1 AS attribute1_30, t27.attribute2 AS attribute2_31, t27.attribute3 AS attribute3_32, t27.attribute4 AS attribute4_33, t27.attribute5 AS attribute5_34, t27.attribute6 AS attribute6_35, t27.swkwe_show_soldout AS swkwe_show_soldout_36, t27.swkwe_emotion_category_slider_media AS swkwe_emotion_category_slider_media_37, t27.categoryID AS categoryID_38, t0.mediaID AS mediaID_39, t0.stream_id AS stream_id_40, t0.parent AS parent_41 FROM s_categories t0 LEFT JOIN s_categories_attributes t27 ON t27.categoryID = t0.id WHERE t0.id = ? |
array:1 [ 0 => 3 ] |
0.0003 ms |
SELECT s0_.description AS description_0 FROM s_categories s0_ WHERE s0_.id = ? |
array:1 [ 0 => 3 ] |
0.0002 ms |
SELECT `objectdata` FROM `s_core_translations` WHERE (`objecttype` = : type) AND (`objectkey` = : key) AND (`objectlanguage` = : language) |
array:3 [ ":type" => "category" ":key" => 3 ":language" => 1 ] |
0.0002 ms |
SELECT s0_.description AS description_0 FROM s_categories s0_ WHERE s0_.id = ? |
array:1 [ 0 => 7 ] |
0.0002 ms |
SELECT `objectdata` FROM `s_core_translations` WHERE (`objecttype` = : type) AND (`objectkey` = : key) AND (`objectlanguage` = : language) |
array:3 [ ":type" => "category" ":key" => "7" ":language" => 1 ] |
0.0001 ms |
SELECT variant.ordernumber FROM s_articles_details variant INNER JOIN s_articles product ON product.main_detail_id = variant.id WHERE variant.articleID = : id |
array:1 [ ":id" => 50 ] |
0.0001 ms |
SELECT variant.articleID FROM s_articles_details variant WHERE variant.ordernumber = : number |
array:1 [ ":number" => "5IN-01400SS" ] |
0.0001 ms |
SELECT categories.categoryID FROM s_articles_categories_ro categories WHERE ( categories.articleID = : productId ) AND ( categories.categoryID = : categoryId ) LIMIT 1 |
array:2 [ ":productId" => "50" ":categoryId" => 3 ] |
0.0002 ms |
SELECT variant.ordernumber FROM s_articles_details variant INNER JOIN s_articles product ON product.id = variant.articleID AND variant.active = 1 WHERE (variant.ordernumber = : number) AND ( ( variant.laststock * variant.instock ) >= ( variant.laststock * variant.minpurchase ) ) LIMIT 1 |
array:1 [ ":number" => "5IN-01400SS" ] |
0.0002 ms |
SELECT product.id as __product_id, product.supplierID as __product_supplierID, product.name as __product_name, product.description as __product_description, product.description_long as __product_description_long, product.shippingtime as __product_shippingtime, product.datum as __product_datum, product.active as __product_active, product.taxID as __product_taxID, product.pseudosales as __product_pseudosales, product.topseller as __product_topseller, product.metaTitle as __product_metaTitle, product.keywords as __product_keywords, product.changetime as __product_changetime, product.pricegroupID as __product_pricegroupID, product.pricegroupActive as __product_pricegroupActive, product.filtergroupID as __product_filtergroupID, product.crossbundlelook as __product_crossbundlelook, product.notification as __product_notification, product.template as __product_template, product.mode as __product_mode, product.main_detail_id as __product_main_detail_id, product.available_from as __product_available_from, product.available_to as __product_available_to, product.configurator_set_id as __product_configurator_set_id, productAttribute.id as __productAttribute_id, productAttribute.articledetailsID as __productAttribute_articledetailsID, productAttribute.attr1 as __productAttribute_attr1, productAttribute.attr2 as __productAttribute_attr2, productAttribute.attr3 as __productAttribute_attr3, productAttribute.attr4 as __productAttribute_attr4, productAttribute.attr5 as __productAttribute_attr5, productAttribute.attr6 as __productAttribute_attr6, productAttribute.attr7 as __productAttribute_attr7, productAttribute.attr8 as __productAttribute_attr8, productAttribute.attr9 as __productAttribute_attr9, productAttribute.attr10 as __productAttribute_attr10, productAttribute.attr11 as __productAttribute_attr11, productAttribute.attr12 as __productAttribute_attr12, productAttribute.attr13 as __productAttribute_attr13, productAttribute.attr14 as __productAttribute_attr14, productAttribute.attr15 as __productAttribute_attr15, productAttribute.attr16 as __productAttribute_attr16, productAttribute.attr17 as __productAttribute_attr17, productAttribute.attr18 as __productAttribute_attr18, productAttribute.attr19 as __productAttribute_attr19, productAttribute.attr20 as __productAttribute_attr20, productAttribute.swkwe_pseudovariants_position as __productAttribute_swkwe_pseudovariants_position, productAttribute.swkwe_pseudovariants_groupname as __productAttribute_swkwe_pseudovariants_groupname, productAttribute.swkwe_pseudovariant_name as __productAttribute_swkwe_pseudovariant_name, productAttribute.swkwe_show_soldout as __productAttribute_swkwe_show_soldout, productAttribute.swkwe_category_show_soldout as __productAttribute_swkwe_category_show_soldout, productAttribute.swkwe_is_set_article as __productAttribute_swkwe_is_set_article, productAttribute.swkwe_set_reserved_stock as __productAttribute_swkwe_set_reserved_stock, productAttribute.swkwe_set_price_calculation as __productAttribute_swkwe_set_price_calculation, topSeller.sales as __topSeller_sales, variant.id as __variant_id, variant.ordernumber as __variant_ordernumber, variant.suppliernumber as __variant_suppliernumber, variant.kind as __variant_kind, variant.additionaltext as __variant_additionaltext, variant.sales as __variant_sales, variant.active as __variant_active, variant.instock as __variant_instock, variant.stockmin as __variant_stockmin, variant.weight as __variant_weight, variant.position as __variant_position, variant.width as __variant_width, variant.height as __variant_height, variant.length as __variant_length, variant.ean as __variant_ean, variant.unitID as __variant_unitID, variant.releasedate as __variant_releasedate, variant.shippingfree as __variant_shippingfree, variant.shippingtime as __variant_shippingtime, variant.laststock as __product_laststock, unit.id as __unit_id, unit.description as __unit_description, unit.unit as __unit_unit, variant.packunit as __unit_packunit, variant.purchaseunit as __unit_purchaseunit, variant.referenceunit as __unit_referenceunit, variant.purchasesteps as __unit_purchasesteps, variant.minpurchase as __unit_minpurchase, variant.maxpurchase as __unit_maxpurchase, tax.id as __tax_id, tax.tax as __tax_tax, tax.description as __tax_description, priceGroup.id as __priceGroup_id, priceGroup.description as __priceGroup_description, manufacturer.id as __manufacturer_id, manufacturer.name as __manufacturer_name, manufacturer.img as __manufacturer_img, manufacturer.link as __manufacturer_link, manufacturer.description as __manufacturer_description, manufacturer.meta_title as __manufacturer_meta_title, manufacturer.meta_description as __manufacturer_meta_description, manufacturer.meta_keywords as __manufacturer_meta_keywords, manufacturerAttribute.id as __manufacturerAttribute_id, manufacturerAttribute.supplierID as __manufacturerAttribute_supplierID, esd.id as __esd_id, esd.articleID as __esd_articleID, esd.articledetailsID as __esd_articledetailsID, esd.file as __esd_file, esd.serials as __esd_serials, esd.notification as __esd_notification, esd.maxdownloads as __esd_maxdownloads, esd.datum as __esd_datum, esdAttribute.id as __esdAttribute_id, esdAttribute.esdID as __esdAttribute_esdID, ( SELECT 1 FROM s_articles_esd variantEsd WHERE variantEsd.articleID = product.id LIMIT 1 ) as __product_has_esd, ( SELECT GROUP_CONCAT( customerGroups.customergroupId SEPARATOR '|' ) FROM s_articles_avoid_customergroups customerGroups WHERE customerGroups.articleID = product.id ) as __product_blocked_customer_groups, ( SELECT COUNT(availableVariant.id) FROM s_articles_details availableVariant WHERE ( availableVariant.articleID = product.id ) AND (availableVariant.active = 1) AND ( ( availableVariant.laststock * availableVariant.instock ) >= ( availableVariant.laststock * availableVariant.minpurchase ) ) ) as __product_has_available_variants, ( SELECT COUNT( DISTINCT ROUND(prices.price, 2) ) as priceCount FROM s_articles_prices prices INNER JOIN s_articles_details priceVariant ON priceVariant.id = prices.articledetailsID and priceVariant.active = 1 WHERE (prices.from = 1) AND (prices.pricegroup = : fallback) AND (prices.articleID = product.id) AND ( ( priceVariant.laststock * priceVariant.instock ) >= ( priceVariant.laststock * priceVariant.minpurchase ) ) ) as __product_fallback_price_count, manufacturerMedia.id as __manufacturer_img_id FROM s_articles_details variant INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_units unit ON unit.id = variant.unitID LEFT JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id LEFT JOIN s_articles_esd esd ON esd.articledetailsID = variant.id INNER JOIN s_core_tax tax ON tax.id = product.taxID LEFT JOIN s_articles_supplier manufacturer ON manufacturer.id = product.supplierID LEFT JOIN s_core_pricegroups priceGroup ON priceGroup.id = product.pricegroupID LEFT JOIN s_articles_supplier_attributes manufacturerAttribute ON manufacturerAttribute.supplierID = product.supplierID LEFT JOIN s_articles_top_seller_ro topSeller ON topSeller.article_id = product.id LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id WHERE ( variant.ordernumber IN (: numbers) ) AND (variant.active = 1) AND (product.active = 1) HAVING __product_has_available_variants >= 1 |
array:2 [ ":fallback" => "EK" ":numbers" => array:1 [ 0 => "5IN-01400SS" ] ] |
0.0012 ms |
SELECT variant.ordernumber, COUNT(availableVariant.id) FROM s_articles_details variant INNER JOIN s_articles_details availableVariant ON variant.articleID = availableVariant.articleID LEFT JOIN s_articles_attributes availableVariantAttribute ON availableVariant.id = availableVariantAttribute.articledetailsID WHERE ( variant.ordernumber IN (: numbers) ) AND (availableVariant.active = 1) AND ( ( availableVariant.laststock * ( availableVariant.instock - GREATEST( 0, IF( availableVariantAttribute.swkwe_set_reserved_stock IS NOT NULL, availableVariantAttribute.swkwe_set_reserved_stock, 0 ) ) ) ) >= ( availableVariant.laststock * availableVariant.minpurchase ) ) GROUP BY variant.id |
array:1 [ ":numbers" => array:1 [ 0 => "5IN-01400SS" ] ] |
0.0003 ms |
SELECT pseudovariant.article_id as __pseudovariant_productId, pseudovariantGroup.id as __pseudovariantGroup_id, pseudovariantGroup.mainvariant_id as __pseudovariantGroup_mainProductId, pseudovariantGroup.template as __pseudovariantGroup_template FROM swkwe_pseudovariants_variantgroups pseudovariantGroup INNER JOIN swkwe_pseudovariants_variantgroups_articles pseudovariant ON pseudovariantGroup.id = pseudovariant.variantgroup_id WHERE pseudovariant.article_id IN (: productIds) |
array:1 [ ":productIds" => array:1 [ "5IN-01400SS" => 50 ] ] |
0.0002 ms |
SELECT variant.ordernumber as number, 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, image.id as __image_id, image.articleID as __image_articleID, image.img as __image_img, image.main as __image_main, image.description as __image_description, image.position as __image_position, image.width as __image_width, image.height as __image_height, image.extension as __image_extension, image.parent_id as __image_parent_id, image.media_id as __image_media_id, imageAttribute.id as __imageAttribute_id, imageAttribute.imageID as __imageAttribute_imageID, imageAttribute.attribute1 as __imageAttribute_attribute1, imageAttribute.attribute2 as __imageAttribute_attribute2, imageAttribute.attribute3 as __imageAttribute_attribute3 FROM s_articles_img image INNER JOIN s_media media ON image.media_id = media.id INNER JOIN s_articles_img childImage ON childImage.parent_id = image.id INNER JOIN s_articles_details variant ON variant.id = childImage.article_detail_id LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID WHERE childImage.article_detail_id IN (: products) ORDER BY image.main ASC, image.position ASC |
array:1 [ ":products" => array:1 [ 0 => 111 ] ] |
0.0005 ms |
SELECT 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, image.id as __image_id, image.articleID as __image_articleID, image.img as __image_img, image.main as __image_main, image.description as __image_description, image.position as __image_position, image.width as __image_width, image.height as __image_height, image.extension as __image_extension, image.parent_id as __image_parent_id, image.media_id as __image_media_id, imageAttribute.id as __imageAttribute_id, imageAttribute.imageID as __imageAttribute_imageID, imageAttribute.attribute1 as __imageAttribute_attribute1, imageAttribute.attribute2 as __imageAttribute_attribute2, imageAttribute.attribute3 as __imageAttribute_attribute3 FROM s_articles_img image INNER JOIN s_media media ON image.media_id = media.id LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id LEFT JOIN s_articles_img childImage ON childImage.parent_id = image.id INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID WHERE (image.main = 1) AND ( image.articleID IN (: products) ) |
array:1 [ ":products" => array:1 [ 0 => 50 ] ] |
0.0005 ms |
SELECT price.id as __price_id, price.pricegroup as __price_pricegroup, price.from as __price_from, price.to as __price_to, price.articleID as __price_articleID, price.articledetailsID as __price_articledetailsID, price.price as __price_price, price.pseudoprice as __price_pseudoprice, price.percent as __price_percent, priceAttribute.id as __priceAttribute_id, priceAttribute.priceID as __priceAttribute_priceID, variants.ordernumber as number, GREATEST( price.from, variants.minpurchase ) __price_from FROM s_articles_prices price INNER JOIN s_articles_details variants ON variants.id = price.articledetailsID LEFT JOIN s_articles_prices_attributes priceAttribute ON priceAttribute.priceID = price.id WHERE ( price.articledetailsID IN (: products) ) AND ( price.pricegroup = : customerGroup ) AND ( (price.to >= variants.minpurchase) OR (price.to = "beliebig") ) ORDER BY price.articledetailsID ASC, price.from ASC |
array:2 [ ":products" => array:1 [ 0 => 111 ] ":customerGroup" => "EK" ] |
0.0003 ms |
SELECT ( SELECT prices.id FROM s_articles_prices prices INNER JOIN s_articles_details variant ON variant.id = prices.articledetailsID INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_pricegroups_discounts priceGroup ON priceGroup.groupID = product.pricegroupID AND priceGroup.discountstart = 1 AND priceGroup.customergroupID = : priceGroupCustomerGroup AND product.pricegroupActive = 1 WHERE ( prices.pricegroup = : customerGroup ) AND (prices.from = 1) AND (variant.active = 1) AND ( prices.articleID = outerPrices.articleID ) AND ( ( variant.laststock * variant.instock ) >= ( variant.laststock * variant.minpurchase ) ) ORDER BY prices.price ASC LIMIT 1 ) as priceId FROM s_articles_prices outerPrices WHERE outerPrices.articleID IN (: products) GROUP BY outerPrices.articleID HAVING priceId IS NOT NULL |
array:3 [ ":customerGroup" => "EK" ":products" => array:1 [ 0 => 50 ] ":priceGroupCustomerGroup" => 1 ] |
0.0004 ms |
SELECT price.id as __price_id, price.pricegroup as __price_pricegroup, price.from as __price_from, price.to as __price_to, price.articleID as __price_articleID, price.articledetailsID as __price_articledetailsID, price.price as __price_price, price.pseudoprice as __price_pseudoprice, price.percent as __price_percent, priceAttribute.id as __priceAttribute_id, priceAttribute.priceID as __priceAttribute_priceID, unit.id as __unit_id, unit.description as __unit_description, unit.unit as __unit_unit, variant.packunit as __unit_packunit, variant.purchaseunit as __unit_purchaseunit, variant.referenceunit as __unit_referenceunit, variant.purchasesteps as __unit_purchasesteps, variant.minpurchase as __unit_minpurchase, variant.maxpurchase as __unit_maxpurchase FROM s_articles_prices price INNER JOIN s_articles_details variant ON variant.id = price.articledetailsID LEFT JOIN s_articles_prices_attributes priceAttribute ON priceAttribute.priceID = price.id INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_units unit ON unit.id = variant.unitID WHERE price.id IN (: ids) |
array:1 [ ":ids" => array:1 [ 0 => "129" ] ] |
0.0003 ms |
SELECT articleID, COUNT(id) as total, points FROM s_articles_vote vote WHERE ( vote.articleID IN (: products) ) AND (vote.active = 1) GROUP BY vote.articleID, vote.points ORDER BY vote.articleID ASC |
array:1 [ ":products" => array:1 [ 0 => 50 ] ] |
0.0003 ms |
SELECT mapping.articleID, GROUP_CONCAT(DISTINCT mapping.categoryID) FROM s_articles_categories_ro mapping WHERE mapping.articleID IN (: ids) GROUP BY mapping.articleID |
array:1 [ ":ids" => array:1 [ 0 => 50 ] ] |
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:2 [ 0 => "3" 1 => "7" ] ":shopId" => "%|1|%" ] |
0.0006 ms |
SELECT 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_media media INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id WHERE media.id IN (: ids) |
array:1 [ ":ids" => [] ] |
0.0002 ms |
SELECT vote.id as __vote_id, vote.articleID as __vote_articleID, vote.name as __vote_name, vote.headline as __vote_headline, vote.comment as __vote_comment, vote.points as __vote_points, vote.datum as __vote_datum, vote.active as __vote_active, vote.email as __vote_email, vote.answer as __vote_answer, vote.answer_date as __vote_answer_date FROM s_articles_vote vote WHERE ( vote.articleID IN (: ids) ) AND (vote.active = 1) ORDER BY vote.articleID DESC, vote.datum DESC |
array:1 [ ":ids" => array:1 [ 0 => 50 ] ] |
0.0003 ms |
SELECT product.id, relatedVariant.ordernumber as number FROM s_articles_relationships relation INNER JOIN s_articles product ON product.id = relation.articleID INNER JOIN s_articles relatedArticles ON relatedArticles.id = relation.relatedArticle INNER JOIN s_articles_details relatedVariant ON relatedVariant.id = relatedArticles.main_detail_id WHERE product.id IN (: ids) |
array:1 [ ":ids" => array:1 [ 0 => 50 ] ] |
0.0002 ms |
SELECT product.id as __product_id, product.supplierID as __product_supplierID, product.name as __product_name, product.description as __product_description, product.description_long as __product_description_long, product.shippingtime as __product_shippingtime, product.datum as __product_datum, product.active as __product_active, product.taxID as __product_taxID, product.pseudosales as __product_pseudosales, product.topseller as __product_topseller, product.metaTitle as __product_metaTitle, product.keywords as __product_keywords, product.changetime as __product_changetime, product.pricegroupID as __product_pricegroupID, product.pricegroupActive as __product_pricegroupActive, product.filtergroupID as __product_filtergroupID, product.crossbundlelook as __product_crossbundlelook, product.notification as __product_notification, product.template as __product_template, product.mode as __product_mode, product.main_detail_id as __product_main_detail_id, product.available_from as __product_available_from, product.available_to as __product_available_to, product.configurator_set_id as __product_configurator_set_id, productAttribute.id as __productAttribute_id, productAttribute.articledetailsID as __productAttribute_articledetailsID, productAttribute.attr1 as __productAttribute_attr1, productAttribute.attr2 as __productAttribute_attr2, productAttribute.attr3 as __productAttribute_attr3, productAttribute.attr4 as __productAttribute_attr4, productAttribute.attr5 as __productAttribute_attr5, productAttribute.attr6 as __productAttribute_attr6, productAttribute.attr7 as __productAttribute_attr7, productAttribute.attr8 as __productAttribute_attr8, productAttribute.attr9 as __productAttribute_attr9, productAttribute.attr10 as __productAttribute_attr10, productAttribute.attr11 as __productAttribute_attr11, productAttribute.attr12 as __productAttribute_attr12, productAttribute.attr13 as __productAttribute_attr13, productAttribute.attr14 as __productAttribute_attr14, productAttribute.attr15 as __productAttribute_attr15, productAttribute.attr16 as __productAttribute_attr16, productAttribute.attr17 as __productAttribute_attr17, productAttribute.attr18 as __productAttribute_attr18, productAttribute.attr19 as __productAttribute_attr19, productAttribute.attr20 as __productAttribute_attr20, productAttribute.swkwe_pseudovariants_position as __productAttribute_swkwe_pseudovariants_position, productAttribute.swkwe_pseudovariants_groupname as __productAttribute_swkwe_pseudovariants_groupname, productAttribute.swkwe_pseudovariant_name as __productAttribute_swkwe_pseudovariant_name, productAttribute.swkwe_show_soldout as __productAttribute_swkwe_show_soldout, productAttribute.swkwe_category_show_soldout as __productAttribute_swkwe_category_show_soldout, productAttribute.swkwe_is_set_article as __productAttribute_swkwe_is_set_article, productAttribute.swkwe_set_reserved_stock as __productAttribute_swkwe_set_reserved_stock, productAttribute.swkwe_set_price_calculation as __productAttribute_swkwe_set_price_calculation, topSeller.sales as __topSeller_sales, variant.id as __variant_id, variant.ordernumber as __variant_ordernumber, variant.suppliernumber as __variant_suppliernumber, variant.kind as __variant_kind, variant.additionaltext as __variant_additionaltext, variant.sales as __variant_sales, variant.active as __variant_active, variant.instock as __variant_instock, variant.stockmin as __variant_stockmin, variant.weight as __variant_weight, variant.position as __variant_position, variant.width as __variant_width, variant.height as __variant_height, variant.length as __variant_length, variant.ean as __variant_ean, variant.unitID as __variant_unitID, variant.releasedate as __variant_releasedate, variant.shippingfree as __variant_shippingfree, variant.shippingtime as __variant_shippingtime, variant.laststock as __product_laststock, unit.id as __unit_id, unit.description as __unit_description, unit.unit as __unit_unit, variant.packunit as __unit_packunit, variant.purchaseunit as __unit_purchaseunit, variant.referenceunit as __unit_referenceunit, variant.purchasesteps as __unit_purchasesteps, variant.minpurchase as __unit_minpurchase, variant.maxpurchase as __unit_maxpurchase, tax.id as __tax_id, tax.tax as __tax_tax, tax.description as __tax_description, priceGroup.id as __priceGroup_id, priceGroup.description as __priceGroup_description, manufacturer.id as __manufacturer_id, manufacturer.name as __manufacturer_name, manufacturer.img as __manufacturer_img, manufacturer.link as __manufacturer_link, manufacturer.description as __manufacturer_description, manufacturer.meta_title as __manufacturer_meta_title, manufacturer.meta_description as __manufacturer_meta_description, manufacturer.meta_keywords as __manufacturer_meta_keywords, manufacturerAttribute.id as __manufacturerAttribute_id, manufacturerAttribute.supplierID as __manufacturerAttribute_supplierID, esd.id as __esd_id, esd.articleID as __esd_articleID, esd.articledetailsID as __esd_articledetailsID, esd.file as __esd_file, esd.serials as __esd_serials, esd.notification as __esd_notification, esd.maxdownloads as __esd_maxdownloads, esd.datum as __esd_datum, esdAttribute.id as __esdAttribute_id, esdAttribute.esdID as __esdAttribute_esdID, ( SELECT 1 FROM s_articles_esd variantEsd WHERE variantEsd.articleID = product.id LIMIT 1 ) as __product_has_esd, ( SELECT GROUP_CONCAT( customerGroups.customergroupId SEPARATOR '|' ) FROM s_articles_avoid_customergroups customerGroups WHERE customerGroups.articleID = product.id ) as __product_blocked_customer_groups, ( SELECT COUNT(availableVariant.id) FROM s_articles_details availableVariant WHERE ( availableVariant.articleID = product.id ) AND (availableVariant.active = 1) AND ( ( availableVariant.laststock * availableVariant.instock ) >= ( availableVariant.laststock * availableVariant.minpurchase ) ) ) as __product_has_available_variants, ( SELECT COUNT( DISTINCT ROUND(prices.price, 2) ) as priceCount FROM s_articles_prices prices INNER JOIN s_articles_details priceVariant ON priceVariant.id = prices.articledetailsID and priceVariant.active = 1 WHERE (prices.from = 1) AND (prices.pricegroup = : fallback) AND (prices.articleID = product.id) AND ( ( priceVariant.laststock * priceVariant.instock ) >= ( priceVariant.laststock * priceVariant.minpurchase ) ) ) as __product_fallback_price_count, manufacturerMedia.id as __manufacturer_img_id FROM s_articles_details variant INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_units unit ON unit.id = variant.unitID LEFT JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id LEFT JOIN s_articles_esd esd ON esd.articledetailsID = variant.id INNER JOIN s_core_tax tax ON tax.id = product.taxID LEFT JOIN s_articles_supplier manufacturer ON manufacturer.id = product.supplierID LEFT JOIN s_core_pricegroups priceGroup ON priceGroup.id = product.pricegroupID LEFT JOIN s_articles_supplier_attributes manufacturerAttribute ON manufacturerAttribute.supplierID = product.supplierID LEFT JOIN s_articles_top_seller_ro topSeller ON topSeller.article_id = product.id LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id WHERE ( variant.ordernumber IN (: numbers) ) AND (variant.active = 1) AND (product.active = 1) HAVING __product_has_available_variants >= 1 |
array:2 [ ":fallback" => "EK" ":numbers" => [] ] |
0.0009 ms |
SELECT variant.ordernumber, COUNT(availableVariant.id) FROM s_articles_details variant INNER JOIN s_articles_details availableVariant ON variant.articleID = availableVariant.articleID LEFT JOIN s_articles_attributes availableVariantAttribute ON availableVariant.id = availableVariantAttribute.articledetailsID WHERE ( variant.ordernumber IN (: numbers) ) AND (availableVariant.active = 1) AND ( ( availableVariant.laststock * ( availableVariant.instock - GREATEST( 0, IF( availableVariantAttribute.swkwe_set_reserved_stock IS NOT NULL, availableVariantAttribute.swkwe_set_reserved_stock, 0 ) ) ) ) >= ( availableVariant.laststock * availableVariant.minpurchase ) ) GROUP BY variant.id |
array:1 [ ":numbers" => [] ] |
0.0002 ms |
SELECT pseudovariant.article_id as __pseudovariant_productId, pseudovariantGroup.id as __pseudovariantGroup_id, pseudovariantGroup.mainvariant_id as __pseudovariantGroup_mainProductId, pseudovariantGroup.template as __pseudovariantGroup_template FROM swkwe_pseudovariants_variantgroups pseudovariantGroup INNER JOIN swkwe_pseudovariants_variantgroups_articles pseudovariant ON pseudovariantGroup.id = pseudovariant.variantgroup_id WHERE pseudovariant.article_id IN (: productIds) |
array:1 [ ":productIds" => [] ] |
0.0002 ms |
SELECT variant.ordernumber as number, 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, image.id as __image_id, image.articleID as __image_articleID, image.img as __image_img, image.main as __image_main, image.description as __image_description, image.position as __image_position, image.width as __image_width, image.height as __image_height, image.extension as __image_extension, image.parent_id as __image_parent_id, image.media_id as __image_media_id, imageAttribute.id as __imageAttribute_id, imageAttribute.imageID as __imageAttribute_imageID, imageAttribute.attribute1 as __imageAttribute_attribute1, imageAttribute.attribute2 as __imageAttribute_attribute2, imageAttribute.attribute3 as __imageAttribute_attribute3 FROM s_articles_img image INNER JOIN s_media media ON image.media_id = media.id INNER JOIN s_articles_img childImage ON childImage.parent_id = image.id INNER JOIN s_articles_details variant ON variant.id = childImage.article_detail_id LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID WHERE childImage.article_detail_id IN (: products) ORDER BY image.main ASC, image.position ASC |
array:1 [ ":products" => [] ] |
0.0004 ms |
SELECT price.id as __price_id, price.pricegroup as __price_pricegroup, price.from as __price_from, price.to as __price_to, price.articleID as __price_articleID, price.articledetailsID as __price_articledetailsID, price.price as __price_price, price.pseudoprice as __price_pseudoprice, price.percent as __price_percent, priceAttribute.id as __priceAttribute_id, priceAttribute.priceID as __priceAttribute_priceID, variants.ordernumber as number, GREATEST( price.from, variants.minpurchase ) __price_from FROM s_articles_prices price INNER JOIN s_articles_details variants ON variants.id = price.articledetailsID LEFT JOIN s_articles_prices_attributes priceAttribute ON priceAttribute.priceID = price.id WHERE ( price.articledetailsID IN (: products) ) AND ( price.pricegroup = : customerGroup ) AND ( (price.to >= variants.minpurchase) OR (price.to = "beliebig") ) ORDER BY price.articledetailsID ASC, price.from ASC |
array:2 [ ":products" => [] ":customerGroup" => "EK" ] |
0.0003 ms |
SELECT ( SELECT prices.id FROM s_articles_prices prices INNER JOIN s_articles_details variant ON variant.id = prices.articledetailsID INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_pricegroups_discounts priceGroup ON priceGroup.groupID = product.pricegroupID AND priceGroup.discountstart = 1 AND priceGroup.customergroupID = : priceGroupCustomerGroup AND product.pricegroupActive = 1 WHERE ( prices.pricegroup = : customerGroup ) AND (prices.from = 1) AND (variant.active = 1) AND ( prices.articleID = outerPrices.articleID ) AND ( ( variant.laststock * variant.instock ) >= ( variant.laststock * variant.minpurchase ) ) ORDER BY prices.price ASC LIMIT 1 ) as priceId FROM s_articles_prices outerPrices WHERE outerPrices.articleID IN (: products) GROUP BY outerPrices.articleID HAVING priceId IS NOT NULL |
array:3 [ ":customerGroup" => "EK" ":products" => [] ":priceGroupCustomerGroup" => 1 ] |
0.0004 ms |
SELECT price.id as __price_id, price.pricegroup as __price_pricegroup, price.from as __price_from, price.to as __price_to, price.articleID as __price_articleID, price.articledetailsID as __price_articledetailsID, price.price as __price_price, price.pseudoprice as __price_pseudoprice, price.percent as __price_percent, priceAttribute.id as __priceAttribute_id, priceAttribute.priceID as __priceAttribute_priceID, unit.id as __unit_id, unit.description as __unit_description, unit.unit as __unit_unit, variant.packunit as __unit_packunit, variant.purchaseunit as __unit_purchaseunit, variant.referenceunit as __unit_referenceunit, variant.purchasesteps as __unit_purchasesteps, variant.minpurchase as __unit_minpurchase, variant.maxpurchase as __unit_maxpurchase FROM s_articles_prices price INNER JOIN s_articles_details variant ON variant.id = price.articledetailsID LEFT JOIN s_articles_prices_attributes priceAttribute ON priceAttribute.priceID = price.id INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_units unit ON unit.id = variant.unitID WHERE price.id IN (: ids) |
array:1 [ ":ids" => [] ] |
0.0003 ms |
SELECT articleID, COUNT(id) as total, points FROM s_articles_vote vote WHERE ( vote.articleID IN (: products) ) AND (vote.active = 1) GROUP BY vote.articleID, vote.points ORDER BY vote.articleID ASC |
array:1 [ ":products" => [] ] |
0.0002 ms |
SELECT mapping.articleID, GROUP_CONCAT(DISTINCT mapping.categoryID) FROM s_articles_categories_ro mapping WHERE mapping.articleID IN (: ids) GROUP BY mapping.articleID |
array:1 [ ":ids" => [] ] |
0.0002 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" => [] ":shopId" => "%|1|%" ] |
0.0004 ms |
SELECT 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_media media INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id WHERE media.id IN (: ids) |
array:1 [ ":ids" => [] ] |
0.0002 ms |
SELECT relation.article_id, 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 FROM s_product_streams_articles relation INNER JOIN s_product_streams stream ON stream.id = relation.stream_id LEFT JOIN s_product_streams_attributes productStreamAttribute ON productStreamAttribute.streamID = stream.id WHERE relation.article_id IN (: ids) |
array:1 [ ":ids" => array:1 [ 0 => 50 ] ] |
0.0003 ms |
SELECT product.id, similarVariant.ordernumber as number FROM s_articles_similar similar INNER JOIN s_articles product ON product.id = similar.articleID INNER JOIN s_articles similarArticles ON similarArticles.id = similar.relatedArticle INNER JOIN s_articles_details similarVariant ON similarVariant.id = similarArticles.main_detail_id WHERE product.id IN (: ids) |
array:1 [ ":ids" => array:1 [ 0 => 50 ] ] |
0.0002 ms |
SELECT product.id as __product_id, product.supplierID as __product_supplierID, product.name as __product_name, product.description as __product_description, product.description_long as __product_description_long, product.shippingtime as __product_shippingtime, product.datum as __product_datum, product.active as __product_active, product.taxID as __product_taxID, product.pseudosales as __product_pseudosales, product.topseller as __product_topseller, product.metaTitle as __product_metaTitle, product.keywords as __product_keywords, product.changetime as __product_changetime, product.pricegroupID as __product_pricegroupID, product.pricegroupActive as __product_pricegroupActive, product.filtergroupID as __product_filtergroupID, product.crossbundlelook as __product_crossbundlelook, product.notification as __product_notification, product.template as __product_template, product.mode as __product_mode, product.main_detail_id as __product_main_detail_id, product.available_from as __product_available_from, product.available_to as __product_available_to, product.configurator_set_id as __product_configurator_set_id, productAttribute.id as __productAttribute_id, productAttribute.articledetailsID as __productAttribute_articledetailsID, productAttribute.attr1 as __productAttribute_attr1, productAttribute.attr2 as __productAttribute_attr2, productAttribute.attr3 as __productAttribute_attr3, productAttribute.attr4 as __productAttribute_attr4, productAttribute.attr5 as __productAttribute_attr5, productAttribute.attr6 as __productAttribute_attr6, productAttribute.attr7 as __productAttribute_attr7, productAttribute.attr8 as __productAttribute_attr8, productAttribute.attr9 as __productAttribute_attr9, productAttribute.attr10 as __productAttribute_attr10, productAttribute.attr11 as __productAttribute_attr11, productAttribute.attr12 as __productAttribute_attr12, productAttribute.attr13 as __productAttribute_attr13, productAttribute.attr14 as __productAttribute_attr14, productAttribute.attr15 as __productAttribute_attr15, productAttribute.attr16 as __productAttribute_attr16, productAttribute.attr17 as __productAttribute_attr17, productAttribute.attr18 as __productAttribute_attr18, productAttribute.attr19 as __productAttribute_attr19, productAttribute.attr20 as __productAttribute_attr20, productAttribute.swkwe_pseudovariants_position as __productAttribute_swkwe_pseudovariants_position, productAttribute.swkwe_pseudovariants_groupname as __productAttribute_swkwe_pseudovariants_groupname, productAttribute.swkwe_pseudovariant_name as __productAttribute_swkwe_pseudovariant_name, productAttribute.swkwe_show_soldout as __productAttribute_swkwe_show_soldout, productAttribute.swkwe_category_show_soldout as __productAttribute_swkwe_category_show_soldout, productAttribute.swkwe_is_set_article as __productAttribute_swkwe_is_set_article, productAttribute.swkwe_set_reserved_stock as __productAttribute_swkwe_set_reserved_stock, productAttribute.swkwe_set_price_calculation as __productAttribute_swkwe_set_price_calculation, topSeller.sales as __topSeller_sales, variant.id as __variant_id, variant.ordernumber as __variant_ordernumber, variant.suppliernumber as __variant_suppliernumber, variant.kind as __variant_kind, variant.additionaltext as __variant_additionaltext, variant.sales as __variant_sales, variant.active as __variant_active, variant.instock as __variant_instock, variant.stockmin as __variant_stockmin, variant.weight as __variant_weight, variant.position as __variant_position, variant.width as __variant_width, variant.height as __variant_height, variant.length as __variant_length, variant.ean as __variant_ean, variant.unitID as __variant_unitID, variant.releasedate as __variant_releasedate, variant.shippingfree as __variant_shippingfree, variant.shippingtime as __variant_shippingtime, variant.laststock as __product_laststock, unit.id as __unit_id, unit.description as __unit_description, unit.unit as __unit_unit, variant.packunit as __unit_packunit, variant.purchaseunit as __unit_purchaseunit, variant.referenceunit as __unit_referenceunit, variant.purchasesteps as __unit_purchasesteps, variant.minpurchase as __unit_minpurchase, variant.maxpurchase as __unit_maxpurchase, tax.id as __tax_id, tax.tax as __tax_tax, tax.description as __tax_description, priceGroup.id as __priceGroup_id, priceGroup.description as __priceGroup_description, manufacturer.id as __manufacturer_id, manufacturer.name as __manufacturer_name, manufacturer.img as __manufacturer_img, manufacturer.link as __manufacturer_link, manufacturer.description as __manufacturer_description, manufacturer.meta_title as __manufacturer_meta_title, manufacturer.meta_description as __manufacturer_meta_description, manufacturer.meta_keywords as __manufacturer_meta_keywords, manufacturerAttribute.id as __manufacturerAttribute_id, manufacturerAttribute.supplierID as __manufacturerAttribute_supplierID, esd.id as __esd_id, esd.articleID as __esd_articleID, esd.articledetailsID as __esd_articledetailsID, esd.file as __esd_file, esd.serials as __esd_serials, esd.notification as __esd_notification, esd.maxdownloads as __esd_maxdownloads, esd.datum as __esd_datum, esdAttribute.id as __esdAttribute_id, esdAttribute.esdID as __esdAttribute_esdID, ( SELECT 1 FROM s_articles_esd variantEsd WHERE variantEsd.articleID = product.id LIMIT 1 ) as __product_has_esd, ( SELECT GROUP_CONCAT( customerGroups.customergroupId SEPARATOR '|' ) FROM s_articles_avoid_customergroups customerGroups WHERE customerGroups.articleID = product.id ) as __product_blocked_customer_groups, ( SELECT COUNT(availableVariant.id) FROM s_articles_details availableVariant WHERE ( availableVariant.articleID = product.id ) AND (availableVariant.active = 1) AND ( ( availableVariant.laststock * availableVariant.instock ) >= ( availableVariant.laststock * availableVariant.minpurchase ) ) ) as __product_has_available_variants, ( SELECT COUNT( DISTINCT ROUND(prices.price, 2) ) as priceCount FROM s_articles_prices prices INNER JOIN s_articles_details priceVariant ON priceVariant.id = prices.articledetailsID and priceVariant.active = 1 WHERE (prices.from = 1) AND (prices.pricegroup = : fallback) AND (prices.articleID = product.id) AND ( ( priceVariant.laststock * priceVariant.instock ) >= ( priceVariant.laststock * priceVariant.minpurchase ) ) ) as __product_fallback_price_count, manufacturerMedia.id as __manufacturer_img_id FROM s_articles_details variant INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_units unit ON unit.id = variant.unitID LEFT JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id LEFT JOIN s_articles_esd esd ON esd.articledetailsID = variant.id INNER JOIN s_core_tax tax ON tax.id = product.taxID LEFT JOIN s_articles_supplier manufacturer ON manufacturer.id = product.supplierID LEFT JOIN s_core_pricegroups priceGroup ON priceGroup.id = product.pricegroupID LEFT JOIN s_articles_supplier_attributes manufacturerAttribute ON manufacturerAttribute.supplierID = product.supplierID LEFT JOIN s_articles_top_seller_ro topSeller ON topSeller.article_id = product.id LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id WHERE ( variant.ordernumber IN (: numbers) ) AND (variant.active = 1) AND (product.active = 1) HAVING __product_has_available_variants >= 1 |
array:2 [ ":fallback" => "EK" ":numbers" => [] ] |
0.0009 ms |
SELECT variant.ordernumber, COUNT(availableVariant.id) FROM s_articles_details variant INNER JOIN s_articles_details availableVariant ON variant.articleID = availableVariant.articleID LEFT JOIN s_articles_attributes availableVariantAttribute ON availableVariant.id = availableVariantAttribute.articledetailsID WHERE ( variant.ordernumber IN (: numbers) ) AND (availableVariant.active = 1) AND ( ( availableVariant.laststock * ( availableVariant.instock - GREATEST( 0, IF( availableVariantAttribute.swkwe_set_reserved_stock IS NOT NULL, availableVariantAttribute.swkwe_set_reserved_stock, 0 ) ) ) ) >= ( availableVariant.laststock * availableVariant.minpurchase ) ) GROUP BY variant.id |
array:1 [ ":numbers" => [] ] |
0.0002 ms |
SELECT pseudovariant.article_id as __pseudovariant_productId, pseudovariantGroup.id as __pseudovariantGroup_id, pseudovariantGroup.mainvariant_id as __pseudovariantGroup_mainProductId, pseudovariantGroup.template as __pseudovariantGroup_template FROM swkwe_pseudovariants_variantgroups pseudovariantGroup INNER JOIN swkwe_pseudovariants_variantgroups_articles pseudovariant ON pseudovariantGroup.id = pseudovariant.variantgroup_id WHERE pseudovariant.article_id IN (: productIds) |
array:1 [ ":productIds" => [] ] |
0.0002 ms |
SELECT variant.ordernumber as number, 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, image.id as __image_id, image.articleID as __image_articleID, image.img as __image_img, image.main as __image_main, image.description as __image_description, image.position as __image_position, image.width as __image_width, image.height as __image_height, image.extension as __image_extension, image.parent_id as __image_parent_id, image.media_id as __image_media_id, imageAttribute.id as __imageAttribute_id, imageAttribute.imageID as __imageAttribute_imageID, imageAttribute.attribute1 as __imageAttribute_attribute1, imageAttribute.attribute2 as __imageAttribute_attribute2, imageAttribute.attribute3 as __imageAttribute_attribute3 FROM s_articles_img image INNER JOIN s_media media ON image.media_id = media.id INNER JOIN s_articles_img childImage ON childImage.parent_id = image.id INNER JOIN s_articles_details variant ON variant.id = childImage.article_detail_id LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID WHERE childImage.article_detail_id IN (: products) ORDER BY image.main ASC, image.position ASC |
array:1 [ ":products" => [] ] |
0.0004 ms |
SELECT price.id as __price_id, price.pricegroup as __price_pricegroup, price.from as __price_from, price.to as __price_to, price.articleID as __price_articleID, price.articledetailsID as __price_articledetailsID, price.price as __price_price, price.pseudoprice as __price_pseudoprice, price.percent as __price_percent, priceAttribute.id as __priceAttribute_id, priceAttribute.priceID as __priceAttribute_priceID, variants.ordernumber as number, GREATEST( price.from, variants.minpurchase ) __price_from FROM s_articles_prices price INNER JOIN s_articles_details variants ON variants.id = price.articledetailsID LEFT JOIN s_articles_prices_attributes priceAttribute ON priceAttribute.priceID = price.id WHERE ( price.articledetailsID IN (: products) ) AND ( price.pricegroup = : customerGroup ) AND ( (price.to >= variants.minpurchase) OR (price.to = "beliebig") ) ORDER BY price.articledetailsID ASC, price.from ASC |
array:2 [ ":products" => [] ":customerGroup" => "EK" ] |
0.0003 ms |
SELECT ( SELECT prices.id FROM s_articles_prices prices INNER JOIN s_articles_details variant ON variant.id = prices.articledetailsID INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_pricegroups_discounts priceGroup ON priceGroup.groupID = product.pricegroupID AND priceGroup.discountstart = 1 AND priceGroup.customergroupID = : priceGroupCustomerGroup AND product.pricegroupActive = 1 WHERE ( prices.pricegroup = : customerGroup ) AND (prices.from = 1) AND (variant.active = 1) AND ( prices.articleID = outerPrices.articleID ) AND ( ( variant.laststock * variant.instock ) >= ( variant.laststock * variant.minpurchase ) ) ORDER BY prices.price ASC LIMIT 1 ) as priceId FROM s_articles_prices outerPrices WHERE outerPrices.articleID IN (: products) GROUP BY outerPrices.articleID HAVING priceId IS NOT NULL |
array:3 [ ":customerGroup" => "EK" ":products" => [] ":priceGroupCustomerGroup" => 1 ] |
0.0003 ms |
SELECT price.id as __price_id, price.pricegroup as __price_pricegroup, price.from as __price_from, price.to as __price_to, price.articleID as __price_articleID, price.articledetailsID as __price_articledetailsID, price.price as __price_price, price.pseudoprice as __price_pseudoprice, price.percent as __price_percent, priceAttribute.id as __priceAttribute_id, priceAttribute.priceID as __priceAttribute_priceID, unit.id as __unit_id, unit.description as __unit_description, unit.unit as __unit_unit, variant.packunit as __unit_packunit, variant.purchaseunit as __unit_purchaseunit, variant.referenceunit as __unit_referenceunit, variant.purchasesteps as __unit_purchasesteps, variant.minpurchase as __unit_minpurchase, variant.maxpurchase as __unit_maxpurchase FROM s_articles_prices price INNER JOIN s_articles_details variant ON variant.id = price.articledetailsID LEFT JOIN s_articles_prices_attributes priceAttribute ON priceAttribute.priceID = price.id INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_units unit ON unit.id = variant.unitID WHERE price.id IN (: ids) |
array:1 [ ":ids" => [] ] |
0.0002 ms |
SELECT articleID, COUNT(id) as total, points FROM s_articles_vote vote WHERE ( vote.articleID IN (: products) ) AND (vote.active = 1) GROUP BY vote.articleID, vote.points ORDER BY vote.articleID ASC |
array:1 [ ":products" => [] ] |
0.0001 ms |
SELECT mapping.articleID, GROUP_CONCAT(DISTINCT mapping.categoryID) FROM s_articles_categories_ro mapping WHERE mapping.articleID IN (: ids) GROUP BY mapping.articleID |
array:1 [ ":ids" => [] ] |
0.0001 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" => [] ":shopId" => "%|1|%" ] |
0.0005 ms |
SELECT 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_media media INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id WHERE media.id IN (: ids) |
array:1 [ ":ids" => [] ] |
0.0002 ms |
SELECT download.id as __download_id, download.articleID as __download_articleID, download.description as __download_description, download.filename as __download_filename, media.file_size as __download_size, downloadAttribute.id as __downloadAttribute_id, downloadAttribute.downloadID as __downloadAttribute_downloadID FROM s_articles_downloads download LEFT JOIN s_articles_downloads_attributes downloadAttribute ON downloadAttribute.downloadID = download.id INNER JOIN s_media media ON media.path = download.filename WHERE download.articleID IN (: ids) |
array:1 [ ":ids" => array:1 [ 0 => 50 ] ] |
0.0003 ms |
SELECT link.id as __link_id, link.articleID as __link_articleID, link.description as __link_description, link.link as __link_link, link.target as __link_target, linkAttribute.id as __linkAttribute_id, linkAttribute.informationID as __linkAttribute_informationID FROM s_articles_information link LEFT JOIN s_articles_information_attributes linkAttribute ON linkAttribute.informationID = link.id WHERE link.articleID IN (: ids) |
array:1 [ ":ids" => array:1 [ 0 => 50 ] ] |
0.0003 ms |
SELECT variant.ordernumber as number, 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, image.id as __image_id, image.articleID as __image_articleID, image.img as __image_img, image.main as __image_main, image.description as __image_description, image.position as __image_position, image.width as __image_width, image.height as __image_height, image.extension as __image_extension, image.parent_id as __image_parent_id, image.media_id as __image_media_id, imageAttribute.id as __imageAttribute_id, imageAttribute.imageID as __imageAttribute_imageID, imageAttribute.attribute1 as __imageAttribute_attribute1, imageAttribute.attribute2 as __imageAttribute_attribute2, imageAttribute.attribute3 as __imageAttribute_attribute3 FROM s_articles_img image INNER JOIN s_media media ON image.media_id = media.id INNER JOIN s_articles_img childImage ON childImage.parent_id = image.id INNER JOIN s_articles_details variant ON variant.id = childImage.article_detail_id LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID WHERE childImage.article_detail_id IN (: products) ORDER BY image.main ASC, image.position ASC |
array:1 [ ":products" => array:1 [ 0 => 111 ] ] |
0.0006 ms |
SELECT 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, image.id as __image_id, image.articleID as __image_articleID, image.img as __image_img, image.main as __image_main, image.description as __image_description, image.position as __image_position, image.width as __image_width, image.height as __image_height, image.extension as __image_extension, image.parent_id as __image_parent_id, image.media_id as __image_media_id, imageAttribute.id as __imageAttribute_id, imageAttribute.imageID as __imageAttribute_imageID, imageAttribute.attribute1 as __imageAttribute_attribute1, imageAttribute.attribute2 as __imageAttribute_attribute2, imageAttribute.attribute3 as __imageAttribute_attribute3 FROM s_articles_img image INNER JOIN s_media media ON image.media_id = media.id LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id LEFT JOIN s_articles_img childImage ON childImage.parent_id = image.id INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID WHERE (image.parent_id IS NULL) AND (childImage.id IS NULL) AND ( image.articleID IN (: products) ) ORDER BY image.main ASC, image.position ASC |
array:1 [ ":products" => array:1 [ 0 => 50 ] ] |
0.0004 ms |
SELECT products.id as productId, relations.position as __relations_position, propertySet.id as __propertySet_id, propertySet.name as __propertySet_name, propertySet.position as __propertySet_position, propertySet.comparable as __propertySet_comparable, propertySet.sortmode as __propertySet_sortmode, propertySetAttribute.id as __propertySetAttribute_id, propertySetAttribute.filterID as __propertySetAttribute_filterID, propertyGroup.id as __propertyGroup_id, propertyGroup.name as __propertyGroup_name, propertyGroup.filterable as __propertyGroup_filterable, propertyGroupAttribute.id as __propertyGroupAttribute_id, propertyGroupAttribute.optionID as __propertyGroupAttribute_optionID, propertyOption.id as __propertyOption_id, propertyOption.optionID as __propertyOption_optionID, propertyOption.value as __propertyOption_value, propertyOption.position as __propertyOption_position, propertyOptionAttribute.id as __propertyOptionAttribute_id, propertyOptionAttribute.valueID as __propertyOptionAttribute_valueID, 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_filter_articles filterArticles INNER JOIN s_articles products ON products.id = filterArticles.articleID INNER JOIN s_filter_values propertyOption ON propertyOption.id = filterArticles.valueID INNER JOIN s_filter propertySet ON propertySet.id = products.filtergroupID INNER JOIN s_filter_relations relations ON relations.groupID = propertySet.id LEFT JOIN s_filter_attributes propertySetAttribute ON propertySetAttribute.filterID = propertySet.id INNER JOIN s_filter_options propertyGroup ON propertyGroup.id = propertyOption.optionID AND relations.optionID = propertyGroup.id LEFT JOIN s_media media ON propertyOption.media_id = media.id LEFT JOIN s_filter_values_attributes propertyOptionAttribute ON propertyOptionAttribute.valueID = propertyOption.id LEFT JOIN s_filter_options_attributes propertyGroupAttribute ON propertyGroupAttribute.optionID = propertyGroup.id LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID WHERE products.id IN (: ids) ORDER BY filterArticles.articleID ASC |
array:1 [ ":ids" => array:1 [ 0 => 50 ] ] |
0.0005 ms |
SELECT variants.ordernumber as number, configuratorGroup.id as __configuratorGroup_id, configuratorGroup.name as __configuratorGroup_name, configuratorGroup.description as __configuratorGroup_description, configuratorGroup.position as __configuratorGroup_position, configuratorGroupAttribute.id as __configuratorGroupAttribute_id, configuratorGroupAttribute.groupID as __configuratorGroupAttribute_groupID, configuratorOption.id as __configuratorOption_id, configuratorOption.name as __configuratorOption_name, configuratorOption.position as __configuratorOption_position, configuratorOptionAttribute.id as __configuratorOptionAttribute_id, configuratorOptionAttribute.optionID as __configuratorOptionAttribute_optionID FROM s_article_configurator_option_relations relations INNER JOIN s_articles_details variants ON variants.id = relations.article_id INNER JOIN s_article_configurator_options configuratorOption ON configuratorOption.id = relations.option_id INNER JOIN s_article_configurator_groups configuratorGroup ON configuratorGroup.id = configuratorOption.group_id LEFT JOIN s_article_configurator_options_attributes configuratorOptionAttribute ON configuratorOptionAttribute.optionID = configuratorOption.id LEFT JOIN s_article_configurator_groups_attributes configuratorGroupAttribute ON configuratorGroupAttribute.groupID = configuratorGroup.id WHERE relations.article_id IN (: ids) ORDER BY configuratorGroup.position ASC, configuratorGroup.id ASC |
array:1 [ ":ids" => array:1 [ 0 => 111 ] ] |
0.0003 ms |
SELECT pseudovariant.article_id as __pseudovariant_productId, pseudovariantGroup.id as __pseudovariantGroup_id, pseudovariantGroup.mainvariant_id as __pseudovariantGroup_mainProductId, pseudovariantGroup.template as __pseudovariantGroup_template FROM swkwe_pseudovariants_variantgroups pseudovariantGroup INNER JOIN swkwe_pseudovariants_variantgroups_articles pseudovariant ON pseudovariantGroup.id = pseudovariant.variantgroup_id WHERE pseudovariant.article_id IN (: productIds) |
array:1 [ ":productIds" => array:1 [ "5IN-01400SS" => 50 ] ] |
0.0002 ms |
SELECT product.id as __product_id, product.supplierID as __product_supplierID, product.name as __product_name, product.description as __product_description, product.description_long as __product_description_long, product.shippingtime as __product_shippingtime, product.datum as __product_datum, product.active as __product_active, product.taxID as __product_taxID, product.pseudosales as __product_pseudosales, product.topseller as __product_topseller, product.metaTitle as __product_metaTitle, product.keywords as __product_keywords, product.changetime as __product_changetime, product.pricegroupID as __product_pricegroupID, product.pricegroupActive as __product_pricegroupActive, product.filtergroupID as __product_filtergroupID, product.crossbundlelook as __product_crossbundlelook, product.notification as __product_notification, product.template as __product_template, product.mode as __product_mode, product.main_detail_id as __product_main_detail_id, product.available_from as __product_available_from, product.available_to as __product_available_to, product.configurator_set_id as __product_configurator_set_id, productAttribute.id as __productAttribute_id, productAttribute.articledetailsID as __productAttribute_articledetailsID, productAttribute.attr1 as __productAttribute_attr1, productAttribute.attr2 as __productAttribute_attr2, productAttribute.attr3 as __productAttribute_attr3, productAttribute.attr4 as __productAttribute_attr4, productAttribute.attr5 as __productAttribute_attr5, productAttribute.attr6 as __productAttribute_attr6, productAttribute.attr7 as __productAttribute_attr7, productAttribute.attr8 as __productAttribute_attr8, productAttribute.attr9 as __productAttribute_attr9, productAttribute.attr10 as __productAttribute_attr10, productAttribute.attr11 as __productAttribute_attr11, productAttribute.attr12 as __productAttribute_attr12, productAttribute.attr13 as __productAttribute_attr13, productAttribute.attr14 as __productAttribute_attr14, productAttribute.attr15 as __productAttribute_attr15, productAttribute.attr16 as __productAttribute_attr16, productAttribute.attr17 as __productAttribute_attr17, productAttribute.attr18 as __productAttribute_attr18, productAttribute.attr19 as __productAttribute_attr19, productAttribute.attr20 as __productAttribute_attr20, productAttribute.swkwe_pseudovariants_position as __productAttribute_swkwe_pseudovariants_position, productAttribute.swkwe_pseudovariants_groupname as __productAttribute_swkwe_pseudovariants_groupname, productAttribute.swkwe_pseudovariant_name as __productAttribute_swkwe_pseudovariant_name, productAttribute.swkwe_show_soldout as __productAttribute_swkwe_show_soldout, productAttribute.swkwe_category_show_soldout as __productAttribute_swkwe_category_show_soldout, productAttribute.swkwe_is_set_article as __productAttribute_swkwe_is_set_article, productAttribute.swkwe_set_reserved_stock as __productAttribute_swkwe_set_reserved_stock, productAttribute.swkwe_set_price_calculation as __productAttribute_swkwe_set_price_calculation, topSeller.sales as __topSeller_sales, variant.id as __variant_id, variant.ordernumber as __variant_ordernumber, variant.suppliernumber as __variant_suppliernumber, variant.kind as __variant_kind, variant.additionaltext as __variant_additionaltext, variant.sales as __variant_sales, variant.active as __variant_active, variant.instock as __variant_instock, variant.stockmin as __variant_stockmin, variant.weight as __variant_weight, variant.position as __variant_position, variant.width as __variant_width, variant.height as __variant_height, variant.length as __variant_length, variant.ean as __variant_ean, variant.unitID as __variant_unitID, variant.releasedate as __variant_releasedate, variant.shippingfree as __variant_shippingfree, variant.shippingtime as __variant_shippingtime, variant.laststock as __product_laststock, unit.id as __unit_id, unit.description as __unit_description, unit.unit as __unit_unit, variant.packunit as __unit_packunit, variant.purchaseunit as __unit_purchaseunit, variant.referenceunit as __unit_referenceunit, variant.purchasesteps as __unit_purchasesteps, variant.minpurchase as __unit_minpurchase, variant.maxpurchase as __unit_maxpurchase, tax.id as __tax_id, tax.tax as __tax_tax, tax.description as __tax_description, priceGroup.id as __priceGroup_id, priceGroup.description as __priceGroup_description, manufacturer.id as __manufacturer_id, manufacturer.name as __manufacturer_name, manufacturer.img as __manufacturer_img, manufacturer.link as __manufacturer_link, manufacturer.description as __manufacturer_description, manufacturer.meta_title as __manufacturer_meta_title, manufacturer.meta_description as __manufacturer_meta_description, manufacturer.meta_keywords as __manufacturer_meta_keywords, manufacturerAttribute.id as __manufacturerAttribute_id, manufacturerAttribute.supplierID as __manufacturerAttribute_supplierID, esd.id as __esd_id, esd.articleID as __esd_articleID, esd.articledetailsID as __esd_articledetailsID, esd.file as __esd_file, esd.serials as __esd_serials, esd.notification as __esd_notification, esd.maxdownloads as __esd_maxdownloads, esd.datum as __esd_datum, esdAttribute.id as __esdAttribute_id, esdAttribute.esdID as __esdAttribute_esdID, ( SELECT 1 FROM s_articles_esd variantEsd WHERE variantEsd.articleID = product.id LIMIT 1 ) as __product_has_esd, ( SELECT GROUP_CONCAT( customerGroups.customergroupId SEPARATOR '|' ) FROM s_articles_avoid_customergroups customerGroups WHERE customerGroups.articleID = product.id ) as __product_blocked_customer_groups, ( SELECT COUNT(availableVariant.id) FROM s_articles_details availableVariant WHERE ( availableVariant.articleID = product.id ) AND (availableVariant.active = 1) AND ( ( availableVariant.laststock * availableVariant.instock ) >= ( availableVariant.laststock * availableVariant.minpurchase ) ) ) as __product_has_available_variants, ( SELECT COUNT( DISTINCT ROUND(prices.price, 2) ) as priceCount FROM s_articles_prices prices INNER JOIN s_articles_details priceVariant ON priceVariant.id = prices.articledetailsID and priceVariant.active = 1 WHERE (prices.from = 1) AND (prices.pricegroup = : fallback) AND (prices.articleID = product.id) AND ( ( priceVariant.laststock * priceVariant.instock ) >= ( priceVariant.laststock * priceVariant.minpurchase ) ) ) as __product_fallback_price_count, manufacturerMedia.id as __manufacturer_img_id FROM s_articles_details variant INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_units unit ON unit.id = variant.unitID LEFT JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id LEFT JOIN s_articles_esd esd ON esd.articledetailsID = variant.id INNER JOIN s_core_tax tax ON tax.id = product.taxID LEFT JOIN s_articles_supplier manufacturer ON manufacturer.id = product.supplierID LEFT JOIN s_core_pricegroups priceGroup ON priceGroup.id = product.pricegroupID LEFT JOIN s_articles_supplier_attributes manufacturerAttribute ON manufacturerAttribute.supplierID = product.supplierID LEFT JOIN s_articles_top_seller_ro topSeller ON topSeller.article_id = product.id LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id WHERE ( variant.ordernumber IN (: numbers) ) AND (variant.active = 1) AND (product.active = 1) HAVING __product_has_available_variants >= 1 |
array:2 [ ":fallback" => "EK" ":numbers" => [] ] |
0.0010 ms |
SELECT variant.ordernumber, COUNT(availableVariant.id) FROM s_articles_details variant INNER JOIN s_articles_details availableVariant ON variant.articleID = availableVariant.articleID LEFT JOIN s_articles_attributes availableVariantAttribute ON availableVariant.id = availableVariantAttribute.articledetailsID WHERE ( variant.ordernumber IN (: numbers) ) AND (availableVariant.active = 1) AND ( ( availableVariant.laststock * ( availableVariant.instock - GREATEST( 0, IF( availableVariantAttribute.swkwe_set_reserved_stock IS NOT NULL, availableVariantAttribute.swkwe_set_reserved_stock, 0 ) ) ) ) >= ( availableVariant.laststock * availableVariant.minpurchase ) ) GROUP BY variant.id |
array:1 [ ":numbers" => [] ] |
0.0003 ms |
SELECT pseudovariant.article_id as __pseudovariant_productId, pseudovariantGroup.id as __pseudovariantGroup_id, pseudovariantGroup.mainvariant_id as __pseudovariantGroup_mainProductId, pseudovariantGroup.template as __pseudovariantGroup_template FROM swkwe_pseudovariants_variantgroups pseudovariantGroup INNER JOIN swkwe_pseudovariants_variantgroups_articles pseudovariant ON pseudovariantGroup.id = pseudovariant.variantgroup_id WHERE pseudovariant.article_id IN (: productIds) |
array:1 [ ":productIds" => [] ] |
0.0002 ms |
SELECT variant.ordernumber as number, 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, image.id as __image_id, image.articleID as __image_articleID, image.img as __image_img, image.main as __image_main, image.description as __image_description, image.position as __image_position, image.width as __image_width, image.height as __image_height, image.extension as __image_extension, image.parent_id as __image_parent_id, image.media_id as __image_media_id, imageAttribute.id as __imageAttribute_id, imageAttribute.imageID as __imageAttribute_imageID, imageAttribute.attribute1 as __imageAttribute_attribute1, imageAttribute.attribute2 as __imageAttribute_attribute2, imageAttribute.attribute3 as __imageAttribute_attribute3 FROM s_articles_img image INNER JOIN s_media media ON image.media_id = media.id INNER JOIN s_articles_img childImage ON childImage.parent_id = image.id INNER JOIN s_articles_details variant ON variant.id = childImage.article_detail_id LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID WHERE childImage.article_detail_id IN (: products) ORDER BY image.main ASC, image.position ASC |
array:1 [ ":products" => [] ] |
0.0004 ms |
SELECT price.id as __price_id, price.pricegroup as __price_pricegroup, price.from as __price_from, price.to as __price_to, price.articleID as __price_articleID, price.articledetailsID as __price_articledetailsID, price.price as __price_price, price.pseudoprice as __price_pseudoprice, price.percent as __price_percent, priceAttribute.id as __priceAttribute_id, priceAttribute.priceID as __priceAttribute_priceID, variants.ordernumber as number, GREATEST( price.from, variants.minpurchase ) __price_from FROM s_articles_prices price INNER JOIN s_articles_details variants ON variants.id = price.articledetailsID LEFT JOIN s_articles_prices_attributes priceAttribute ON priceAttribute.priceID = price.id WHERE ( price.articledetailsID IN (: products) ) AND ( price.pricegroup = : customerGroup ) AND ( (price.to >= variants.minpurchase) OR (price.to = "beliebig") ) ORDER BY price.articledetailsID ASC, price.from ASC |
array:2 [ ":products" => [] ":customerGroup" => "EK" ] |
0.0003 ms |
SELECT ( SELECT prices.id FROM s_articles_prices prices INNER JOIN s_articles_details variant ON variant.id = prices.articledetailsID INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_pricegroups_discounts priceGroup ON priceGroup.groupID = product.pricegroupID AND priceGroup.discountstart = 1 AND priceGroup.customergroupID = : priceGroupCustomerGroup AND product.pricegroupActive = 1 WHERE ( prices.pricegroup = : customerGroup ) AND (prices.from = 1) AND (variant.active = 1) AND ( prices.articleID = outerPrices.articleID ) AND ( ( variant.laststock * variant.instock ) >= ( variant.laststock * variant.minpurchase ) ) ORDER BY prices.price ASC LIMIT 1 ) as priceId FROM s_articles_prices outerPrices WHERE outerPrices.articleID IN (: products) GROUP BY outerPrices.articleID HAVING priceId IS NOT NULL |
array:3 [ ":customerGroup" => "EK" ":products" => [] ":priceGroupCustomerGroup" => 1 ] |
0.0003 ms |
SELECT price.id as __price_id, price.pricegroup as __price_pricegroup, price.from as __price_from, price.to as __price_to, price.articleID as __price_articleID, price.articledetailsID as __price_articledetailsID, price.price as __price_price, price.pseudoprice as __price_pseudoprice, price.percent as __price_percent, priceAttribute.id as __priceAttribute_id, priceAttribute.priceID as __priceAttribute_priceID, unit.id as __unit_id, unit.description as __unit_description, unit.unit as __unit_unit, variant.packunit as __unit_packunit, variant.purchaseunit as __unit_purchaseunit, variant.referenceunit as __unit_referenceunit, variant.purchasesteps as __unit_purchasesteps, variant.minpurchase as __unit_minpurchase, variant.maxpurchase as __unit_maxpurchase FROM s_articles_prices price INNER JOIN s_articles_details variant ON variant.id = price.articledetailsID LEFT JOIN s_articles_prices_attributes priceAttribute ON priceAttribute.priceID = price.id INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_units unit ON unit.id = variant.unitID WHERE price.id IN (: ids) |
array:1 [ ":ids" => [] ] |
0.0003 ms |
SELECT articleID, COUNT(id) as total, points FROM s_articles_vote vote WHERE ( vote.articleID IN (: products) ) AND (vote.active = 1) GROUP BY vote.articleID, vote.points ORDER BY vote.articleID ASC |
array:1 [ ":products" => [] ] |
0.0002 ms |
SELECT mapping.articleID, GROUP_CONCAT(DISTINCT mapping.categoryID) FROM s_articles_categories_ro mapping WHERE mapping.articleID IN (: ids) GROUP BY mapping.articleID |
array:1 [ ":ids" => [] ] |
0.0002 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" => [] ":shopId" => "%|1|%" ] |
0.0005 ms |
SELECT 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_media media INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id WHERE media.id IN (: ids) |
array:1 [ ":ids" => [] ] |
0.0003 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:1 [ 0 => "sViewport=detail&sArticle=50" ] ] |
0.0003 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:1 [ 0 => "sViewport=forms&sFid=16" ] ] |
0.0002 ms |
SELECT s0_.id AS id_0, s0_.description AS description_1, s0_.blog AS blog_2 FROM s_categories s0_ WHERE s0_.id = ? |
array:1 [ 0 => 3 ] |
0.0001 ms |
SELECT `objectdata` FROM `s_core_translations` WHERE (`objecttype` = : type) AND (`objectkey` = : key) AND (`objectlanguage` = : language) |
array:3 [ ":type" => "category" ":key" => 3 ":language" => 1 ] |
0.0001 ms |
SELECT s0_.id AS id_0, s0_.description AS description_1, s0_.blog AS blog_2 FROM s_categories s0_ WHERE s0_.id = ? |
array:1 [ 0 => 7 ] |
0.0001 ms |
SELECT `objectdata` FROM `s_core_translations` WHERE (`objecttype` = : type) AND (`objectkey` = : key) AND (`objectlanguage` = : language) |
array:3 [ ":type" => "category" ":key" => 7 ":language" => 1 ] |
0.0001 ms |
SELECT SQL_CALC_FOUND_ROWS product.id as __product_id, variant.id as __variant_id, variant.ordernumber as __variant_ordernumber FROM s_articles product INNER JOIN s_articles_details variant ON variant.id = product.main_detail_id AND variant.active = 1 AND product.active = 1 LEFT JOIN s_articles_avoid_customergroups avoidCustomerGroup ON avoidCustomerGroup.articleID = product.id AND avoidCustomerGroup.customerGroupId IN ( : customerGroupIds38ba0f9d2195aa1ed719d712288c9fae ) INNER JOIN s_articles_supplier manufacturer ON manufacturer.id = product.supplierID AND product.supplierID IN ( : manufactureredf4053a638e00168b46d1e660d0d33f ) INNER JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id WHERE avoidCustomerGroup.articleID IS NULL GROUP BY product.id ORDER BY variant.id ASC LIMIT 10 |
array:2 [ ":customerGroupIds38ba0f9d2195aa1ed719d712288c9fae" => array:1 [ 0 => 1 ] ":manufactureredf4053a638e00168b46d1e660d0d33f" => array:1 [ 0 => 1 ] ] |
0.0007 ms |
SELECT FOUND_ROWS() |
[] |
0.0002 ms |
SELECT product.id as __product_id, product.supplierID as __product_supplierID, product.name as __product_name, product.description as __product_description, product.description_long as __product_description_long, product.shippingtime as __product_shippingtime, product.datum as __product_datum, product.active as __product_active, product.taxID as __product_taxID, product.pseudosales as __product_pseudosales, product.topseller as __product_topseller, product.metaTitle as __product_metaTitle, product.keywords as __product_keywords, product.changetime as __product_changetime, product.pricegroupID as __product_pricegroupID, product.pricegroupActive as __product_pricegroupActive, product.filtergroupID as __product_filtergroupID, product.crossbundlelook as __product_crossbundlelook, product.notification as __product_notification, product.template as __product_template, product.mode as __product_mode, product.main_detail_id as __product_main_detail_id, product.available_from as __product_available_from, product.available_to as __product_available_to, product.configurator_set_id as __product_configurator_set_id, productAttribute.id as __productAttribute_id, productAttribute.articledetailsID as __productAttribute_articledetailsID, productAttribute.attr1 as __productAttribute_attr1, productAttribute.attr2 as __productAttribute_attr2, productAttribute.attr3 as __productAttribute_attr3, productAttribute.attr4 as __productAttribute_attr4, productAttribute.attr5 as __productAttribute_attr5, productAttribute.attr6 as __productAttribute_attr6, productAttribute.attr7 as __productAttribute_attr7, productAttribute.attr8 as __productAttribute_attr8, productAttribute.attr9 as __productAttribute_attr9, productAttribute.attr10 as __productAttribute_attr10, productAttribute.attr11 as __productAttribute_attr11, productAttribute.attr12 as __productAttribute_attr12, productAttribute.attr13 as __productAttribute_attr13, productAttribute.attr14 as __productAttribute_attr14, productAttribute.attr15 as __productAttribute_attr15, productAttribute.attr16 as __productAttribute_attr16, productAttribute.attr17 as __productAttribute_attr17, productAttribute.attr18 as __productAttribute_attr18, productAttribute.attr19 as __productAttribute_attr19, productAttribute.attr20 as __productAttribute_attr20, productAttribute.swkwe_pseudovariants_position as __productAttribute_swkwe_pseudovariants_position, productAttribute.swkwe_pseudovariants_groupname as __productAttribute_swkwe_pseudovariants_groupname, productAttribute.swkwe_pseudovariant_name as __productAttribute_swkwe_pseudovariant_name, productAttribute.swkwe_show_soldout as __productAttribute_swkwe_show_soldout, productAttribute.swkwe_category_show_soldout as __productAttribute_swkwe_category_show_soldout, productAttribute.swkwe_is_set_article as __productAttribute_swkwe_is_set_article, productAttribute.swkwe_set_reserved_stock as __productAttribute_swkwe_set_reserved_stock, productAttribute.swkwe_set_price_calculation as __productAttribute_swkwe_set_price_calculation, topSeller.sales as __topSeller_sales, variant.id as __variant_id, variant.ordernumber as __variant_ordernumber, variant.suppliernumber as __variant_suppliernumber, variant.kind as __variant_kind, variant.additionaltext as __variant_additionaltext, variant.sales as __variant_sales, variant.active as __variant_active, variant.instock as __variant_instock, variant.stockmin as __variant_stockmin, variant.weight as __variant_weight, variant.position as __variant_position, variant.width as __variant_width, variant.height as __variant_height, variant.length as __variant_length, variant.ean as __variant_ean, variant.unitID as __variant_unitID, variant.releasedate as __variant_releasedate, variant.shippingfree as __variant_shippingfree, variant.shippingtime as __variant_shippingtime, variant.laststock as __product_laststock, unit.id as __unit_id, unit.description as __unit_description, unit.unit as __unit_unit, variant.packunit as __unit_packunit, variant.purchaseunit as __unit_purchaseunit, variant.referenceunit as __unit_referenceunit, variant.purchasesteps as __unit_purchasesteps, variant.minpurchase as __unit_minpurchase, variant.maxpurchase as __unit_maxpurchase, tax.id as __tax_id, tax.tax as __tax_tax, tax.description as __tax_description, priceGroup.id as __priceGroup_id, priceGroup.description as __priceGroup_description, manufacturer.id as __manufacturer_id, manufacturer.name as __manufacturer_name, manufacturer.img as __manufacturer_img, manufacturer.link as __manufacturer_link, manufacturer.description as __manufacturer_description, manufacturer.meta_title as __manufacturer_meta_title, manufacturer.meta_description as __manufacturer_meta_description, manufacturer.meta_keywords as __manufacturer_meta_keywords, manufacturerAttribute.id as __manufacturerAttribute_id, manufacturerAttribute.supplierID as __manufacturerAttribute_supplierID, esd.id as __esd_id, esd.articleID as __esd_articleID, esd.articledetailsID as __esd_articledetailsID, esd.file as __esd_file, esd.serials as __esd_serials, esd.notification as __esd_notification, esd.maxdownloads as __esd_maxdownloads, esd.datum as __esd_datum, esdAttribute.id as __esdAttribute_id, esdAttribute.esdID as __esdAttribute_esdID, ( SELECT 1 FROM s_articles_esd variantEsd WHERE variantEsd.articleID = product.id LIMIT 1 ) as __product_has_esd, ( SELECT GROUP_CONCAT( customerGroups.customergroupId SEPARATOR '|' ) FROM s_articles_avoid_customergroups customerGroups WHERE customerGroups.articleID = product.id ) as __product_blocked_customer_groups, ( SELECT COUNT(availableVariant.id) FROM s_articles_details availableVariant WHERE ( availableVariant.articleID = product.id ) AND (availableVariant.active = 1) AND ( ( availableVariant.laststock * availableVariant.instock ) >= ( availableVariant.laststock * availableVariant.minpurchase ) ) ) as __product_has_available_variants, ( SELECT COUNT( DISTINCT ROUND(prices.price, 2) ) as priceCount FROM s_articles_prices prices INNER JOIN s_articles_details priceVariant ON priceVariant.id = prices.articledetailsID and priceVariant.active = 1 WHERE (prices.from = 1) AND (prices.pricegroup = : fallback) AND (prices.articleID = product.id) AND ( ( priceVariant.laststock * priceVariant.instock ) >= ( priceVariant.laststock * priceVariant.minpurchase ) ) ) as __product_fallback_price_count, manufacturerMedia.id as __manufacturer_img_id FROM s_articles_details variant INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_units unit ON unit.id = variant.unitID LEFT JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id LEFT JOIN s_articles_esd esd ON esd.articledetailsID = variant.id INNER JOIN s_core_tax tax ON tax.id = product.taxID LEFT JOIN s_articles_supplier manufacturer ON manufacturer.id = product.supplierID LEFT JOIN s_core_pricegroups priceGroup ON priceGroup.id = product.pricegroupID LEFT JOIN s_articles_supplier_attributes manufacturerAttribute ON manufacturerAttribute.supplierID = product.supplierID LEFT JOIN s_articles_top_seller_ro topSeller ON topSeller.article_id = product.id LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id WHERE ( variant.ordernumber IN (: numbers) ) AND (variant.active = 1) AND (product.active = 1) HAVING __product_has_available_variants >= 1 |
array:2 [ ":fallback" => "EK" ":numbers" => array:10 [ 0 => "SW10006" 1 => "SW10007" 2 => "SW10008" 3 => "SW10014" 4 => "SW10005.4" 5 => "SW10009.8" 6 => "SW10022" 7 => "SW10024" 8 => "SW10025" 9 => "SW10026" ] ] |
0.0017 ms |
SELECT variant.ordernumber, COUNT(availableVariant.id) FROM s_articles_details variant INNER JOIN s_articles_details availableVariant ON variant.articleID = availableVariant.articleID LEFT JOIN s_articles_attributes availableVariantAttribute ON availableVariant.id = availableVariantAttribute.articledetailsID WHERE ( variant.ordernumber IN (: numbers) ) AND (availableVariant.active = 1) AND ( ( availableVariant.laststock * ( availableVariant.instock - GREATEST( 0, IF( availableVariantAttribute.swkwe_set_reserved_stock IS NOT NULL, availableVariantAttribute.swkwe_set_reserved_stock, 0 ) ) ) ) >= ( availableVariant.laststock * availableVariant.minpurchase ) ) GROUP BY variant.id |
array:1 [ ":numbers" => array:10 [ 0 => "SW10005.4" 1 => "SW10006" 2 => "SW10007" 3 => "SW10008" 4 => "SW10009.8" 5 => "SW10014" 6 => "SW10022" 7 => "SW10024" 8 => "SW10025" 9 => "SW10026" ] ] |
0.0005 ms |
SELECT pseudovariant.article_id as __pseudovariant_productId, pseudovariantGroup.id as __pseudovariantGroup_id, pseudovariantGroup.mainvariant_id as __pseudovariantGroup_mainProductId, pseudovariantGroup.template as __pseudovariantGroup_template FROM swkwe_pseudovariants_variantgroups pseudovariantGroup INNER JOIN swkwe_pseudovariants_variantgroups_articles pseudovariant ON pseudovariantGroup.id = pseudovariant.variantgroup_id WHERE pseudovariant.article_id IN (: productIds) |
array:1 [ ":productIds" => array:10 [ "SW10005.4" => 5 "SW10006" => 6 "SW10007" => 7 "SW10008" => 8 "SW10009.8" => 9 "SW10014" => 14 "SW10022" => 22 "SW10024" => 24 "SW10025" => 25 "SW10026" => 26 ] ] |
0.0002 ms |
SELECT variant.ordernumber as number, 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, image.id as __image_id, image.articleID as __image_articleID, image.img as __image_img, image.main as __image_main, image.description as __image_description, image.position as __image_position, image.width as __image_width, image.height as __image_height, image.extension as __image_extension, image.parent_id as __image_parent_id, image.media_id as __image_media_id, imageAttribute.id as __imageAttribute_id, imageAttribute.imageID as __imageAttribute_imageID, imageAttribute.attribute1 as __imageAttribute_attribute1, imageAttribute.attribute2 as __imageAttribute_attribute2, imageAttribute.attribute3 as __imageAttribute_attribute3 FROM s_articles_img image INNER JOIN s_media media ON image.media_id = media.id INNER JOIN s_articles_img childImage ON childImage.parent_id = image.id INNER JOIN s_articles_details variant ON variant.id = childImage.article_detail_id LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID WHERE childImage.article_detail_id IN (: products) ORDER BY image.main ASC, image.position ASC |
array:1 [ ":products" => array:10 [ 0 => 23 1 => 6 2 => 7 3 => 8 4 => 34 5 => 14 6 => 65 7 => 72 8 => 73 9 => 74 ] ] |
0.0007 ms |
SELECT 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, image.id as __image_id, image.articleID as __image_articleID, image.img as __image_img, image.main as __image_main, image.description as __image_description, image.position as __image_position, image.width as __image_width, image.height as __image_height, image.extension as __image_extension, image.parent_id as __image_parent_id, image.media_id as __image_media_id, imageAttribute.id as __imageAttribute_id, imageAttribute.imageID as __imageAttribute_imageID, imageAttribute.attribute1 as __imageAttribute_attribute1, imageAttribute.attribute2 as __imageAttribute_attribute2, imageAttribute.attribute3 as __imageAttribute_attribute3 FROM s_articles_img image INNER JOIN s_media media ON image.media_id = media.id LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = image.media_id LEFT JOIN s_articles_img_attributes imageAttribute ON imageAttribute.imageID = image.id LEFT JOIN s_articles_img childImage ON childImage.parent_id = image.id INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID WHERE (image.main = 1) AND ( image.articleID IN (: products) ) |
array:1 [ ":products" => array:6 [ 0 => 6 1 => 7 2 => 8 3 => 24 4 => 25 5 => 26 ] ] |
0.0005 ms |
SELECT price.id as __price_id, price.pricegroup as __price_pricegroup, price.from as __price_from, price.to as __price_to, price.articleID as __price_articleID, price.articledetailsID as __price_articledetailsID, price.price as __price_price, price.pseudoprice as __price_pseudoprice, price.percent as __price_percent, priceAttribute.id as __priceAttribute_id, priceAttribute.priceID as __priceAttribute_priceID, variants.ordernumber as number, GREATEST( price.from, variants.minpurchase ) __price_from FROM s_articles_prices price INNER JOIN s_articles_details variants ON variants.id = price.articledetailsID LEFT JOIN s_articles_prices_attributes priceAttribute ON priceAttribute.priceID = price.id WHERE ( price.articledetailsID IN (: products) ) AND ( price.pricegroup = : customerGroup ) AND ( (price.to >= variants.minpurchase) OR (price.to = "beliebig") ) ORDER BY price.articledetailsID ASC, price.from ASC |
array:2 [ ":products" => array:10 [ 0 => 23 1 => 6 2 => 7 3 => 8 4 => 34 5 => 14 6 => 65 7 => 72 8 => 73 9 => 74 ] ":customerGroup" => "EK" ] |
0.0005 ms |
SELECT ( SELECT prices.id FROM s_articles_prices prices INNER JOIN s_articles_details variant ON variant.id = prices.articledetailsID INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_pricegroups_discounts priceGroup ON priceGroup.groupID = product.pricegroupID AND priceGroup.discountstart = 1 AND priceGroup.customergroupID = : priceGroupCustomerGroup AND product.pricegroupActive = 1 WHERE ( prices.pricegroup = : customerGroup ) AND (prices.from = 1) AND (variant.active = 1) AND ( prices.articleID = outerPrices.articleID ) AND ( ( variant.laststock * variant.instock ) >= ( variant.laststock * variant.minpurchase ) ) ORDER BY prices.price ASC LIMIT 1 ) as priceId FROM s_articles_prices outerPrices WHERE outerPrices.articleID IN (: products) GROUP BY outerPrices.articleID HAVING priceId IS NOT NULL |
array:3 [ ":customerGroup" => "EK" ":products" => array:10 [ 0 => 5 1 => 6 2 => 7 3 => 8 4 => 9 5 => 14 6 => 22 7 => 24 8 => 25 9 => 26 ] ":priceGroupCustomerGroup" => 1 ] |
0.0007 ms |
SELECT price.id as __price_id, price.pricegroup as __price_pricegroup, price.from as __price_from, price.to as __price_to, price.articleID as __price_articleID, price.articledetailsID as __price_articledetailsID, price.price as __price_price, price.pseudoprice as __price_pseudoprice, price.percent as __price_percent, priceAttribute.id as __priceAttribute_id, priceAttribute.priceID as __priceAttribute_priceID, unit.id as __unit_id, unit.description as __unit_description, unit.unit as __unit_unit, variant.packunit as __unit_packunit, variant.purchaseunit as __unit_purchaseunit, variant.referenceunit as __unit_referenceunit, variant.purchasesteps as __unit_purchasesteps, variant.minpurchase as __unit_minpurchase, variant.maxpurchase as __unit_maxpurchase FROM s_articles_prices price INNER JOIN s_articles_details variant ON variant.id = price.articledetailsID LEFT JOIN s_articles_prices_attributes priceAttribute ON priceAttribute.priceID = price.id INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_units unit ON unit.id = variant.unitID WHERE price.id IN (: ids) |
array:1 [ ":ids" => array:10 [ 0 => "22" 1 => "6" 2 => "18" 3 => "8" 4 => "31" 5 => "46" 6 => "77" 7 => "84" 8 => "85" 9 => "88" ] ] |
0.0005 ms |
SELECT articleID, COUNT(id) as total, points FROM s_articles_vote vote WHERE ( vote.articleID IN (: products) ) AND (vote.active = 1) GROUP BY vote.articleID, vote.points ORDER BY vote.articleID ASC |
array:1 [ ":products" => array:10 [ 0 => 5 1 => 6 2 => 7 3 => 8 4 => 9 5 => 14 6 => 22 7 => 24 8 => 25 9 => 26 ] ] |
0.0003 ms |
SELECT mapping.articleID, GROUP_CONCAT(DISTINCT mapping.categoryID) FROM s_articles_categories_ro mapping WHERE mapping.articleID IN (: ids) GROUP BY mapping.articleID |
array:1 [ ":ids" => array:10 [ 0 => 5 1 => 6 2 => 7 3 => 8 4 => 9 5 => 14 6 => 22 7 => 24 8 => 25 9 => 26 ] ] |
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:6 [ 0 => "3" 1 => "6" 2 => "11" 3 => "18" 6 => "12" 23 => "17" ] ":shopId" => "%|1|%" ] |
0.0007 ms |
SELECT 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_media media INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id WHERE media.id IN (: ids) |
array:1 [ ":ids" => [] ] |
0.0002 ms |
SELECT guide.id as __guide_id FROM swkwe_guides_articles guide INNER JOIN swkwe_guides_categories_articles guidesCategories ON guide.id = guidesCategories.article_id INNER JOIN swkwe_guides_products_articles guidesProducts ON guide.id = guidesProducts.article_id INNER JOIN swkwe_guides_categories_shops categoriesShops ON guidesCategories.category_id = categoriesShops.category_id WHERE (guide.active = 1) AND ( categoriesShops.shop_id = : dcValue1 ) AND ( guidesProducts.product_id = : dcValue2 ) GROUP BY guide.id ORDER BY guide.position ASC, guide.created DESC |
array:2 [ "dcValue1" => 1 "dcValue2" => 50 ] |
0.0004 ms |
SELECT guide.id as __guide_id, guide.active as __guide_active, guide.name as __guide_name, guide.slug as __guide_slug, guide.shortName as __guide_shortName, guide.subheadline as __guide_subheadline, guide.created as __guide_createdAt, guide.mediaID as __guide_mediaId, EXISTS( SELECT * FROM swkwe_guides_articles_products productMapping WHERE guide.id = productMapping.article_id ) as __guide_hasLinkedProducts, EXISTS( SELECT * FROM swkwe_guides_articles_linked_product_streams productStreamMapping WHERE guide.id = productStreamMapping.article_id ) as __guide_hasLinkedProductStreams FROM swkwe_guides_articles guide WHERE guide.id IN (: ids) |
array:1 [ ":ids" => [] ] |
0.0003 ms |
SELECT 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_media media INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id WHERE media.id IN (: ids) |
array:1 [ ":ids" => [] ] |
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.0002 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.0003 ms |
SELECT category.path FROM s_categories category WHERE category.id = : id |
array:1 [ ":id" => 7 ] |
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:2 [ 0 => 7 2 => "3" ] ":shopId" => "%|1|%" ] |
0.0002 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:11 [ 0 => 7 1 => "3" 2 => 20 3 => 3 4 => 5 5 => 6 6 => 7 7 => 15 8 => 16 9 => 17 10 => 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:11 [ 0 => 7 1 => "3" 2 => 20 3 => 3 4 => 5 5 => 6 6 => 7 7 => 15 8 => 16 9 => 17 10 => 13 ] ] |
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.0008 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.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" => "1" ] |
0.0003 ms |
SELECT taxRule.groupID as __taxRule_groupID, taxRule.tax as __taxRule_tax, taxRule.name as __taxRule_name FROM s_core_tax_rules taxRule WHERE ( ( taxRule.areaID = : area OR taxRule.areaID IS NULL ) ) AND ( ( taxRule.countryID = : country OR taxRule.countryID IS NULL ) ) AND ( ( taxRule.stateID = : state OR taxRule.stateID IS NULL ) ) AND ( ( taxRule.customer_groupID = : customerGroup OR taxRule.customer_groupID IS NULL ) ) AND (taxRule.groupID = : taxId) AND (taxRule.active = 1) ORDER BY taxRule.customer_groupID DESC, taxRule.areaID DESC, taxRule.countryID DESC, taxRule.stateID DESC LIMIT 1 OFFSET 0 |
array:5 [ ":area" => null ":country" => null ":state" => null ":customerGroup" => 1 ":taxId" => "4" ] |
0.0003 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 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.0005 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 releasedate FROM s_articles_details detail WHERE (detail.ordernumber = : resourceId) AND (detail.active = 1) AND (detail.releasedate IS NOT NULL) ORDER BY detail.releasedate DESC LIMIT 1 |
array:1 [ ":resourceId" => null ] |
0.0002 ms |
SELECT releasedate FROM s_articles_details detail WHERE (detail.ordernumber = : resourceId) AND (detail.active = 1) AND (detail.releasedate IS NOT NULL) ORDER BY detail.releasedate DESC LIMIT 1 |
array:1 [ ":resourceId" => null ] |
0.0002 ms |
SELECT releasedate FROM s_articles_details detail WHERE (detail.ordernumber = : resourceId) AND (detail.active = 1) AND (detail.releasedate IS NOT NULL) ORDER BY detail.releasedate DESC LIMIT 1 |
array:1 [ ":resourceId" => null ] |
0.0002 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:1 [ 0 => "sViewport=detail&sArticle=50" ] ] |
0.0003 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:1 [ 0 => "sViewport=detail&sArticle=50" ] ] |
0.0003 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:1 [ 0 => "sViewport=detail&sArticle=50" ] ] |
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 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:1 [ 0 => "sViewport=detail&sArticle=50" ] ] |
0.0002 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:1 [ 0 => "sViewport=compare&sAction=add_article" ] ] |
0.0002 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:1 [ 0 => "sViewport=note&sAction=add" ] ] |
0.0002 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:1 [ 0 => "sViewport=note&sAction=ajaxAdd" ] ] |
0.0002 ms |
SELECT guide.id as __guide_id FROM swkwe_guides_articles guide INNER JOIN swkwe_guides_categories_articles guidesCategories ON guide.id = guidesCategories.article_id INNER JOIN swkwe_guides_categories_shops categoriesShops ON guidesCategories.category_id = categoriesShops.category_id WHERE (guide.active = 1) AND ( categoriesShops.shop_id = : dcValue1 ) GROUP BY guide.id |
array:1 [ "dcValue1" => 1 ] |
0.0002 ms |
SELECT linkword.text as __linkword_text, linkword.article_id as __linkword_guideId FROM swkwe_guides_linkwords linkword WHERE linkword.article_id IN (: ids) |
array:1 [ ":ids" => array:3 [ 8 => 8 9 => 9 11 => 11 ] ] |
0.0002 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:1 [ 0 => "sViewport=listing&sAction=manufacturer&sSupplier=1" ] ] |
0.0002 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:1 [ 0 => "sViewport=detail&sArticle=50" ] ] |
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.0002 ms |
SELECT org_path, path FROM s_core_rewrite_urls WHERE subshopID =: shopId AND org_path IN (: orgPath) AND main = 1 ORDER BY id DESC |
array:2 [ ":shopId" => 1 ":orgPath" => array:38 [ 0 => "sViewport=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=7" 8 => "sViewport=cat&sCategory=7" 9 => "sViewport=cat&sCategory=7" 10 => "sViewport=cat&sCategory=20" 11 => "sViewport=cat&sCategory=5" 12 => "sViewport=cat&sCategory=6" 13 => "sViewport=cat&sCategory=7" 14 => "sViewport=cat&sCategory=15" 15 => "sViewport=cat&sCategory=16" 16 => "sViewport=cat&sCategory=17" 17 => "sViewport=blog&sCategory=13" 18 => "sViewport=detail&sArticle=6" 19 => "sViewport=detail&sArticle=6" 20 => "sViewport=detail&sArticle=7" 21 => "sViewport=detail&sArticle=7" 22 => "sViewport=detail&sArticle=8" 23 => "sViewport=detail&sArticle=8" 24 => "sViewport=detail&sArticle=14" 25 => "sViewport=detail&sArticle=14" 26 => "sViewport=detail&sArticle=5" 27 => "sViewport=detail&sArticle=5" 28 => "sViewport=detail&sArticle=9" 29 => "sViewport=detail&sArticle=9" 30 => "sViewport=detail&sArticle=22" 31 => "sViewport=detail&sArticle=22" 32 => "sViewport=detail&sArticle=24" 33 => "sViewport=detail&sArticle=24" 34 => "sViewport=detail&sArticle=25" 35 => "sViewport=detail&sArticle=25" 36 => "sViewport=detail&sArticle=26" 37 => "sViewport=detail&sArticle=26" ] ] |
0.0009 ms |
SELECT host, hosts FROM s_core_shops WHERE id = : id |
array:1 [ ":id" => 1 ] |
0.0002 ms |
SELECT releasedate FROM s_articles_details detail WHERE (detail.ordernumber = : resourceId) AND (detail.active = 1) AND (detail.releasedate IS NOT NULL) ORDER BY detail.releasedate DESC LIMIT 1 |
array:1 [ ":resourceId" => null ] |
0.0002 ms |
SELECT releasedate FROM s_articles_details detail WHERE (detail.ordernumber = : resourceId) AND (detail.active = 1) AND (detail.releasedate IS NOT NULL) ORDER BY detail.releasedate DESC LIMIT 1 |
array:1 [ ":resourceId" => null ] |
0.0002 ms |
SELECT releasedate FROM s_articles_details detail WHERE (detail.ordernumber = : resourceId) AND (detail.active = 1) AND (detail.releasedate IS NOT NULL) ORDER BY detail.releasedate DESC LIMIT 1 |
array:1 [ ":resourceId" => null ] |
0.0001 ms |
SELECT expiry, modified FROM s_core_sessions WHERE id = ? |
array:1 [ 0 => "32d7787be742c545af443b66b998daa8878391061a665dea1d34a0883353c908" ] |
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.6759 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.4239 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.3669 ms |
SELECT `s_core_snippets`.`name`, `s_core_snippets`.`value` FROM `s_core_snippets` WHERE ( namespace = 'frontend/listing/facet_labels' ) AND (shopID = '1') AND (localeID = '1') |
[] |
0.2720 ms |
SELECT `s_core_snippets`.`name`, `s_core_snippets`.`value` FROM `s_core_snippets` WHERE ( namespace = 'frontend/listing/facet_labels' ) AND (shopID = '1') AND (localeID = '2') |
[] |
0.1750 ms |
SELECT ordernumber FROM s_articles_details WHERE kind = 1 AND articleID = ? |
array:1 [ 1 => 50 ] |
0.2198 ms |
SELECT s_articles.id, s_articles.main_detail_id, s_articles_details.id AS did, s_articles.name AS articleName, additionaltext, s_articles.configurator_set_id FROM s_articles_details, s_articles WHERE ordernumber = : orderNumber AND s_articles.id = s_articles_details.articleID |
array:1 [ ":orderNumber" => "5IN-01400SS" ] |
0.1550 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.1969 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.1512 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.2041 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.2830 ms |
SELECT variant.ordernumber FROM s_articles_details variant INNER JOIN s_articles product ON product.main_detail_id = variant.id AND product.id = ? |
array:1 [ 1 => 50 ] |
0.2010 ms |
SELECT `id` FROM `s_core_config_elements` WHERE `name` LIKE 'routerlastupdate' |
[] |
0.2460 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.1450 ms |