Queries
175
Total Queries
0.0017 s
Total Query Time
SQL | Params | Execution Time |
---|---|---|
SELECT name, id, name, label, description, source, active, installation_date as installationDate, update_date as updateDate, version FROM s_core_plugins WHERE namespace =: namespace AND name not IN(: names) |
array:2 [ "namespace" => "Core" "names" => array:1 [ 0 => "PluginManager" ] ] |
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 = : namespace WHERE ce.type = 0 AND cp.name NOT IN(: names) ORDER BY name, position |
array:2 [ "namespace" => "Core" "names" => array:1 [ 0 => "PluginManager" ] ] |
0.0001 ms |
SELECT name, id, name, label, description, source, active, installation_date as installationDate, update_date as updateDate, version FROM s_core_plugins WHERE namespace =: namespace AND name not IN(: names) |
array:2 [ "namespace" => "Frontend" "names" => array:1 [ 0 => "PluginManager" ] ] |
0.0001 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 = : namespace WHERE ce.type = 0 AND cp.name NOT IN(: names) ORDER BY name, position |
array:2 [ "namespace" => "Frontend" "names" => array:1 [ 0 => "PluginManager" ] ] |
0.0001 ms |
SELECT name, id, name, label, description, source, active, installation_date as installationDate, update_date as updateDate, version FROM s_core_plugins WHERE namespace =: namespace AND name not IN(: names) |
array:2 [ "namespace" => "Backend" "names" => array:1 [ 0 => "PluginManager" ] ] |
0.0001 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 = : namespace WHERE ce.type = 0 AND cp.name NOT IN(: names) ORDER BY name, position |
array:2 [ "namespace" => "Backend" "names" => array:1 [ 0 => "PluginManager" ] ] |
0.0001 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" => "titan.sw5.dev.orangebytes.de" ] |
0.0001 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_.main_id AS main_id_31, s1_.category_id AS category_id_32, s1_.name AS name_33, s1_.title AS title_34, s1_.position AS position_35, s1_.host AS host_36, s1_.base_path AS base_path_37, s1_.base_url AS base_url_38, s1_.hosts AS hosts_39, s1_.secure AS secure_40, s1_.template_id AS template_id_41, s1_.`default` AS default_42, s1_.active AS active_43, s1_.customer_scope AS customer_scope_44, s2_.id AS id_45, s2_.locale AS locale_46, s2_.language AS language_47, s2_.territory AS territory_48, s3_.id AS id_49, s3_.currency AS currency_50, s3_.name AS name_51, s3_.standard AS standard_52, s3_.factor AS factor_53, s3_.templatechar AS templatechar_54, s3_.symbol_position AS symbol_position_55, s3_.position AS position_56, s4_.id AS id_57, s4_.groupkey AS groupkey_58, s4_.description AS description_59, s4_.tax AS tax_60, s4_.taxinput AS taxinput_61, s4_.mode AS mode_62, s4_.discount AS discount_63, s4_.minimumorder AS minimumorder_64, s4_.minimumordersurcharge AS minimumordersurcharge_65, s5_.id AS id_66, s5_.template AS template_67, s5_.name AS name_68, s5_.description AS description_69, s5_.author AS author_70, s5_.license AS license_71, s5_.esi AS esi_72, s5_.style_support AS style_support_73, s5_.emotion AS emotion_74, s5_.version AS version_75, s5_.plugin_id AS plugin_id_76, s5_.parent_id AS parent_id_77, s6_.id AS id_78, s6_.template AS template_79, s6_.name AS name_80, s6_.description AS description_81, s6_.author AS author_82, s6_.license AS license_83, s6_.esi AS esi_84, s6_.style_support AS style_support_85, s6_.emotion AS emotion_86, s6_.version AS version_87, s6_.plugin_id AS plugin_id_88, s6_.parent_id AS parent_id_89, s7_.id AS id_90, s7_.currency AS currency_91, s7_.name AS name_92, s7_.standard AS standard_93, s7_.factor AS factor_94, s7_.templatechar AS templatechar_95, s7_.symbol_position AS symbol_position_96, s7_.position AS position_97, s0_.main_id AS main_id_98, s0_.template_id AS template_id_99, s0_.document_template_id AS document_template_id_100, s0_.category_id AS category_id_101, s0_.locale_id AS locale_id_102, s0_.currency_id AS currency_id_103, s0_.customer_group_id AS customer_group_id_104, s0_.fallback_id AS fallback_id_105, s1_.main_id AS main_id_106, s1_.template_id AS template_id_107, s1_.document_template_id AS document_template_id_108, s1_.category_id AS category_id_109, s1_.locale_id AS locale_id_110, s1_.currency_id AS currency_id_111, s1_.customer_group_id AS customer_group_id_112, s1_.fallback_id AS fallback_id_113, s5_.parent_id AS parent_id_114, s5_.plugin_id AS plugin_id_115, s6_.parent_id AS parent_id_116, s6_.plugin_id AS plugin_id_117 FROM s_core_shops s0_ LEFT JOIN s_core_shops s1_ ON s0_.main_id = s1_.id LEFT JOIN s_core_locales s2_ ON s0_.locale_id = s2_.id LEFT JOIN s_core_currencies s3_ ON s0_.currency_id = s3_.id LEFT JOIN s_core_customergroups s4_ ON s0_.customer_group_id = s4_.id LEFT JOIN s_core_templates s5_ ON s1_.template_id = s5_.id LEFT JOIN s_core_templates s6_ ON s1_.document_template_id = s6_.id LEFT JOIN s_core_shop_currencies s8_ ON s1_.id = s8_.shop_id LEFT JOIN s_core_currencies s7_ ON s7_.id = s8_.currency_id WHERE s0_.id = ? ORDER BY s7_.position ASC, s7_.id ASC |
array:1 [ 0 => "3" ] |
0.0001 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 => 3 ] |
0.0001 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.0001 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.0001 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" => "titan.sw5.dev.orangebytes.de" ] |
0.0001 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 => 3 ] |
0.0001 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.0001 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.0001 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.0001 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 => 24 ] |
0.0001 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 => 24 ] |
0.0001 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 => 24 ] |
0.0001 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 => 24 ] |
0.0000 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 ) UNION ALL ( SELECT subshopID as shopId, path, org_path as orgPath, 0 as main FROM s_core_rewrite_urls WHERE path LIKE CONCAT( TRIM( TRAILING "/" FROM : pathInfo ), "%" ) ORDER BY subshopID = : shopId DESC, LENGTH(path), main DESC LIMIT 1 ) |
array:2 [ ":shopId" => 3 ":pathInfo" => "all-products/31/demo-artikel-moebel-zimmerpflanze-monstera-deliciosa-ausverkauft" ] |
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.0000 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, media.id as __media_id, media.albumID as __media_albumID, media.name as __media_name, media.description as __media_description, media.path as __media_path, media.type as __media_type, media.extension as __media_extension, media.file_size as __media_file_size, media.width as __media_width, media.height as __media_height, media.userID as __media_userID, media.created as __media_created, mediaSettings.id as __mediaSettings_id, mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, mediaSettings.icon as __mediaSettings_icon, mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, mediaAttribute.id as __mediaAttribute_id, mediaAttribute.mediaID as __mediaAttribute_mediaID FROM s_core_shops shop LEFT JOIN s_core_shops_attributes shopAttribute ON shopAttribute.shopID = shop.id LEFT JOIN s_core_currencies currency ON currency.id = shop.currency_id LEFT JOIN s_core_templates template ON shop.template_id = template.id LEFT JOIN s_core_locales locale ON locale.id = shop.locale_id LEFT JOIN s_core_customergroups customerGroup ON customerGroup.id = shop.customer_group_id LEFT JOIN s_categories category ON category.id = shop.category_id LEFT JOIN s_core_customergroups_attributes customerGroupAttribute ON customerGroupAttribute.customerGroupID = customerGroup.id LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id LEFT JOIN s_media media ON media.id = category.mediaID LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id WHERE shop.id IN (: ids) |
array:1 [ ":ids" => array:1 [ 0 => 3 ] ] |
0.0001 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, 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.0001 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.0000 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.0001 ms |
SELECT tax.id as __tax_id, tax.tax as __tax_tax, tax.description as __tax_description FROM s_core_tax tax |
[] |
0.0001 ms |
SELECT taxRule.groupID as __taxRule_groupID, taxRule.tax as __taxRule_tax, taxRule.name as __taxRule_name FROM s_core_tax_rules taxRule WHERE ( ( taxRule.areaID = : area OR taxRule.areaID IS NULL ) ) AND ( ( taxRule.countryID = : country OR taxRule.countryID IS NULL ) ) AND ( ( taxRule.stateID = : state OR taxRule.stateID IS NULL ) ) AND ( ( taxRule.customer_groupID = : customerGroup OR taxRule.customer_groupID IS NULL ) ) AND (taxRule.groupID = : taxId) AND (taxRule.active = 1) ORDER BY taxRule.customer_groupID DESC, taxRule.areaID DESC, taxRule.countryID DESC, taxRule.stateID DESC LIMIT 1 |
array:5 [ ":area" => null ":country" => null ":state" => null ":customerGroup" => 1 ":taxId" => "1" ] |
0.0001 ms |
SELECT taxRule.groupID as __taxRule_groupID, taxRule.tax as __taxRule_tax, taxRule.name as __taxRule_name FROM s_core_tax_rules taxRule WHERE ( ( taxRule.areaID = : area OR taxRule.areaID IS NULL ) ) AND ( ( taxRule.countryID = : country OR taxRule.countryID IS NULL ) ) AND ( ( taxRule.stateID = : state OR taxRule.stateID IS NULL ) ) AND ( ( taxRule.customer_groupID = : customerGroup OR taxRule.customer_groupID IS NULL ) ) AND (taxRule.groupID = : taxId) AND (taxRule.active = 1) ORDER BY taxRule.customer_groupID DESC, taxRule.areaID DESC, taxRule.countryID DESC, taxRule.stateID DESC LIMIT 1 |
array:5 [ ":area" => null ":country" => null ":state" => null ":customerGroup" => 1 ":taxId" => "4" ] |
0.0001 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.0001 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.categoryID AS categoryID_36, t0.mediaID AS mediaID_37, t0.stream_id AS stream_id_38, t0.parent AS parent_39 FROM s_categories t0 LEFT JOIN s_categories_attributes t27 ON t27.categoryID = t0.id WHERE t0.id = ? |
array:1 [ 0 => "79" ] |
0.0001 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.categoryID AS categoryID_36, t0.mediaID AS mediaID_37, t0.stream_id AS stream_id_38, t0.parent AS parent_39 FROM s_categories t0 LEFT JOIN s_categories_attributes t27 ON t27.categoryID = t0.id WHERE t0.id = ? |
array:1 [ 0 => 21 ] |
0.0001 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.categoryID AS categoryID_36, t0.mediaID AS mediaID_37, t0.stream_id AS stream_id_38, t0.parent AS parent_39 FROM s_categories t0 LEFT JOIN s_categories_attributes t27 ON t27.categoryID = t0.id WHERE t0.id = ? |
array:1 [ 0 => 10 ] |
0.0001 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.categoryID AS categoryID_36, t0.mediaID AS mediaID_37, t0.stream_id AS stream_id_38, t0.parent AS parent_39 FROM s_categories t0 LEFT JOIN s_categories_attributes t27 ON t27.categoryID = t0.id WHERE t0.id = ? |
array:1 [ 0 => 3 ] |
0.0001 ms |
SELECT s0_.description AS description_0 FROM s_categories s0_ WHERE s0_.id = ? |
array:1 [ 0 => 3 ] |
0.0001 ms |
SELECT id FROM s_core_locales WHERE locale = "en_GB" |
[] |
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" => 3 ] |
0.0001 ms |
SELECT s0_.description AS description_0 FROM s_categories s0_ WHERE s0_.id = ? |
array:1 [ 0 => 10 ] |
0.0001 ms |
SELECT `objectdata` FROM `s_core_translations` WHERE (`objecttype` = : type) AND (`objectkey` = : key) AND (`objectlanguage` = : language) |
array:3 [ ":type" => "category" ":key" => 10 ":language" => 3 ] |
0.0001 ms |
SELECT s0_.description AS description_0 FROM s_categories s0_ WHERE s0_.id = ? |
array:1 [ 0 => 21 ] |
0.0000 ms |
SELECT `objectdata` FROM `s_core_translations` WHERE (`objecttype` = : type) AND (`objectkey` = : key) AND (`objectlanguage` = : language) |
array:3 [ ":type" => "category" ":key" => 21 ":language" => 3 ] |
0.0000 ms |
SELECT s0_.description AS description_0 FROM s_categories s0_ WHERE s0_.id = ? |
array:1 [ 0 => 79 ] |
0.0000 ms |
SELECT `objectdata` FROM `s_core_translations` WHERE (`objecttype` = : type) AND (`objectkey` = : key) AND (`objectlanguage` = : language) |
array:3 [ ":type" => "category" ":key" => "79" ":language" => 3 ] |
0.0000 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" => 31 ] |
0.0003 ms |
SELECT variant.articleID FROM s_articles_details variant WHERE variant.ordernumber = : number |
array:1 [ ":number" => "10031" ] |
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" => "31" ":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" => "10031" ] |
0.0002 ms |
SELECT `active` FROM s_core_plugins WHERE name = 'Notification' |
[] |
0.0012 ms |
SELECT `notification` FROM s_articles WHERE id = : productId |
array:1 [ ":productId" => 31 ] |
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.id = product.main_detail_id ) AND (product.id = : productId) AND ( ( variant.laststock * variant.instock ) >= ( variant.laststock * variant.minpurchase ) ) LIMIT 1 |
array:1 [ ":productId" => "31" ] |
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 (product.id = : productId) AND ( ( variant.laststock * variant.instock ) >= ( variant.laststock * variant.minpurchase ) ) LIMIT 1 |
array:1 [ ":productId" => "31" ] |
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 product.id = : productId LIMIT 1 |
array:1 [ ":productId" => "31" ] |
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, 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) ) as __product_fallback_price_count, manufacturerMedia.id as __manufacturer_img_id, translation67d93f48032afarticle.objectdata as __product_translation, translation67d93f48032b4fallbackarticle.objectdata as __product_translation_fallback, translation67d93f48032b7variant.objectdata as __variant_translation, translation67d93f48032b9fallbackvariant.objectdata as __variant_translation_fallback, translation67d93f48032bcsupplier.objectdata as __manufacturer_translation, translation67d93f48032bdfallbacksupplier.objectdata as __manufacturer_translation_fallback, translation67d93f48032bfconfig_units.objectdata as __unit_translation, translation67d93f48032c2fallbackconfig_units.objectdata as __unit_translation_fallback, translation67d93f48032c3s_articles_esd_attributes.objectdata as __esdAttribute_translation, translation67d93f48032c5fallbacks_articles_esd_attributes.objectdata as __esdAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f48032b7variant ON translation67d93f48032b7variant.objecttype = : translation67d93f48032b7variant AND translation67d93f48032b7variant.objectkey = variant.id AND translation67d93f48032b7variant.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48032b9fallbackvariant ON translation67d93f48032b9fallbackvariant.objecttype = : translation67d93f48032b9fallbackvariant AND translation67d93f48032b9fallbackvariant.objectkey = variant.id AND translation67d93f48032b9fallbackvariant.objectlanguage = : languagefallback 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_core_translations translation67d93f48032afarticle ON translation67d93f48032afarticle.objecttype = : translation67d93f48032afarticle AND translation67d93f48032afarticle.objectkey = product.id AND translation67d93f48032afarticle.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48032b4fallbackarticle ON translation67d93f48032b4fallbackarticle.objecttype = : translation67d93f48032b4fallbackarticle AND translation67d93f48032b4fallbackarticle.objectkey = product.id AND translation67d93f48032b4fallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img LEFT JOIN s_core_translations translation67d93f48032bcsupplier ON translation67d93f48032bcsupplier.objecttype = : translation67d93f48032bcsupplier AND translation67d93f48032bcsupplier.objectkey = manufacturer.id AND translation67d93f48032bcsupplier.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48032bdfallbacksupplier ON translation67d93f48032bdfallbacksupplier.objecttype = : translation67d93f48032bdfallbacksupplier AND translation67d93f48032bdfallbacksupplier.objectkey = manufacturer.id AND translation67d93f48032bdfallbacksupplier.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f48032bfconfig_units ON translation67d93f48032bfconfig_units.objecttype = : translation67d93f48032bfconfig_units AND translation67d93f48032bfconfig_units.objectkey = 1 AND translation67d93f48032bfconfig_units.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48032c2fallbackconfig_units ON translation67d93f48032c2fallbackconfig_units.objecttype = : translation67d93f48032c2fallbackconfig_units AND translation67d93f48032c2fallbackconfig_units.objectkey = 1 AND translation67d93f48032c2fallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id LEFT JOIN s_core_translations translation67d93f48032c3s_articles_esd_attributes ON translation67d93f48032c3s_articles_esd_attributes.objecttype = : translation67d93f48032c3s_articles_esd_attributes AND translation67d93f48032c3s_articles_esd_attributes.objectkey = esd.id AND translation67d93f48032c3s_articles_esd_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48032c5fallbacks_articles_esd_attributes ON translation67d93f48032c5fallbacks_articles_esd_attributes.objecttype = : translation67d93f48032c5fallbacks_articles_esd_attributes AND translation67d93f48032c5fallbacks_articles_esd_attributes.objectkey = esd.id AND translation67d93f48032c5fallbacks_articles_esd_attributes.objectlanguage = : languagefallback WHERE ( variant.ordernumber IN (: numbers) ) AND (variant.active = 1) AND (product.active = 1) |
array:14 [ ":fallback" => "EK" ":numbers" => array:1 [ 0 => 10031 ] ":language" => 3 ":translation67d93f48032afarticle" => "article" ":languagefallback" => 0 ":translation67d93f48032b4fallbackarticle" => "article" ":translation67d93f48032b7variant" => "variant" ":translation67d93f48032b9fallbackvariant" => "variant" ":translation67d93f48032bcsupplier" => "supplier" ":translation67d93f48032bdfallbacksupplier" => "supplier" ":translation67d93f48032bfconfig_units" => "config_units" ":translation67d93f48032c2fallbackconfig_units" => "config_units" ":translation67d93f48032c3s_articles_esd_attributes" => "s_articles_esd_attributes" ":translation67d93f48032c5fallbacks_articles_esd_attributes" => "s_articles_esd_attributes" ] |
0.0013 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, translation67d93f48039fearticleimage.objectdata as __image_translation, translation67d93f4803a02fallbackarticleimage.objectdata as __image_translation_fallback, translation67d93f4803a05s_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f4803a06fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f48039fearticleimage ON translation67d93f48039fearticleimage.objecttype = : translation67d93f48039fearticleimage AND translation67d93f48039fearticleimage.objectkey = image.id AND translation67d93f48039fearticleimage.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4803a02fallbackarticleimage ON translation67d93f4803a02fallbackarticleimage.objecttype = : translation67d93f4803a02fallbackarticleimage AND translation67d93f4803a02fallbackarticleimage.objectkey = image.id AND translation67d93f4803a02fallbackarticleimage.objectlanguage = : languagefallback INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_core_translations translation67d93f4803a05s_media_attributes ON translation67d93f4803a05s_media_attributes.objecttype = : translation67d93f4803a05s_media_attributes AND translation67d93f4803a05s_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4803a05s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4803a06fallbacks_media_attributes ON translation67d93f4803a06fallbacks_media_attributes.objecttype = : translation67d93f4803a06fallbacks_media_attributes AND translation67d93f4803a06fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4803a06fallbacks_media_attributes.objectlanguage = : languagefallback WHERE childImage.article_detail_id IN (: products) ORDER BY image.main ASC, image.position ASC |
array:7 [ ":language" => 3 ":translation67d93f48039fearticleimage" => "articleimage" ":languagefallback" => 0 ":translation67d93f4803a02fallbackarticleimage" => "articleimage" ":translation67d93f4803a05s_media_attributes" => "s_media_attributes" ":translation67d93f4803a06fallbacks_media_attributes" => "s_media_attributes" ":products" => array:1 [ 0 => 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, translation67d93f4803d16articleimage.objectdata as __image_translation, translation67d93f4803d1afallbackarticleimage.objectdata as __image_translation_fallback, translation67d93f4803d1cs_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f4803d1efallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f4803d16articleimage ON translation67d93f4803d16articleimage.objecttype = : translation67d93f4803d16articleimage AND translation67d93f4803d16articleimage.objectkey = image.id AND translation67d93f4803d16articleimage.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4803d1afallbackarticleimage ON translation67d93f4803d1afallbackarticleimage.objecttype = : translation67d93f4803d1afallbackarticleimage AND translation67d93f4803d1afallbackarticleimage.objectkey = image.id AND translation67d93f4803d1afallbackarticleimage.objectlanguage = : languagefallback INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_core_translations translation67d93f4803d1cs_media_attributes ON translation67d93f4803d1cs_media_attributes.objecttype = : translation67d93f4803d1cs_media_attributes AND translation67d93f4803d1cs_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4803d1cs_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4803d1efallbacks_media_attributes ON translation67d93f4803d1efallbacks_media_attributes.objecttype = : translation67d93f4803d1efallbacks_media_attributes AND translation67d93f4803d1efallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4803d1efallbacks_media_attributes.objectlanguage = : languagefallback WHERE (image.main = 1) AND ( image.articleID IN (: products) ) |
array:7 [ ":language" => 3 ":translation67d93f4803d16articleimage" => "articleimage" ":languagefallback" => 0 ":translation67d93f4803d1afallbackarticleimage" => "articleimage" ":translation67d93f4803d1cs_media_attributes" => "s_media_attributes" ":translation67d93f4803d1efallbacks_media_attributes" => "s_media_attributes" ":products" => array:1 [ 0 => 31 ] ] |
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, translation67d93f480403fs_articles_prices_attributes.objectdata as __priceAttribute_translation, translation67d93f4804043fallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f480403fs_articles_prices_attributes ON translation67d93f480403fs_articles_prices_attributes.objecttype = : translation67d93f480403fs_articles_prices_attributes AND translation67d93f480403fs_articles_prices_attributes.objectkey = price.id AND translation67d93f480403fs_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4804043fallbacks_articles_prices_attributes ON translation67d93f4804043fallbacks_articles_prices_attributes.objecttype = : translation67d93f4804043fallbacks_articles_prices_attributes AND translation67d93f4804043fallbacks_articles_prices_attributes.objectkey = price.id AND translation67d93f4804043fallbacks_articles_prices_attributes.objectlanguage = : languagefallback 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:6 [ ":products" => array:1 [ 0 => 74 ] ":customerGroup" => "EK" ":language" => 3 ":translation67d93f480403fs_articles_prices_attributes" => "s_articles_prices_attributes" ":languagefallback" => 0 ":translation67d93f4804043fallbacks_articles_prices_attributes" => "s_articles_prices_attributes" ] |
0.0004 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 => 31 ] ":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, translation67d93f48043edconfig_units.objectdata as __unit_translation, translation67d93f48043f1fallbackconfig_units.objectdata as __unit_translation_fallback, translation67d93f48043f3article.objectdata as __product_translation, translation67d93f48043f5fallbackarticle.objectdata as __product_translation_fallback, translation67d93f48043f7variant.objectdata as __variant_translation, translation67d93f48043f9fallbackvariant.objectdata as __variant_translation_fallback, translation67d93f48043fas_articles_prices_attributes.objectdata as __priceAttribute_translation, translation67d93f48043fcfallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f48043f7variant ON translation67d93f48043f7variant.objecttype = : translation67d93f48043f7variant AND translation67d93f48043f7variant.objectkey = variant.id AND translation67d93f48043f7variant.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48043f9fallbackvariant ON translation67d93f48043f9fallbackvariant.objecttype = : translation67d93f48043f9fallbackvariant AND translation67d93f48043f9fallbackvariant.objectkey = variant.id AND translation67d93f48043f9fallbackvariant.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f48043f3article ON translation67d93f48043f3article.objecttype = : translation67d93f48043f3article AND translation67d93f48043f3article.objectkey = product.id AND translation67d93f48043f3article.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48043f5fallbackarticle ON translation67d93f48043f5fallbackarticle.objecttype = : translation67d93f48043f5fallbackarticle AND translation67d93f48043f5fallbackarticle.objectkey = product.id AND translation67d93f48043f5fallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f48043edconfig_units ON translation67d93f48043edconfig_units.objecttype = : translation67d93f48043edconfig_units AND translation67d93f48043edconfig_units.objectkey = 1 AND translation67d93f48043edconfig_units.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48043f1fallbackconfig_units ON translation67d93f48043f1fallbackconfig_units.objecttype = : translation67d93f48043f1fallbackconfig_units AND translation67d93f48043f1fallbackconfig_units.objectkey = 1 AND translation67d93f48043f1fallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f48043fas_articles_prices_attributes ON translation67d93f48043fas_articles_prices_attributes.objecttype = : translation67d93f48043fas_articles_prices_attributes AND translation67d93f48043fas_articles_prices_attributes.objectkey = price.id AND translation67d93f48043fas_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48043fcfallbacks_articles_prices_attributes ON translation67d93f48043fcfallbacks_articles_prices_attributes.objecttype = : translation67d93f48043fcfallbacks_articles_prices_attributes AND translation67d93f48043fcfallbacks_articles_prices_attributes.objectkey = price.id AND translation67d93f48043fcfallbacks_articles_prices_attributes.objectlanguage = : languagefallback WHERE price.id IN (: ids) |
array:11 [ ":ids" => [] ":language" => 3 ":translation67d93f48043edconfig_units" => "config_units" ":languagefallback" => 0 ":translation67d93f48043f1fallbackconfig_units" => "config_units" ":translation67d93f48043f3article" => "article" ":translation67d93f48043f5fallbackarticle" => "article" ":translation67d93f48043f7variant" => "variant" ":translation67d93f48043f9fallbackvariant" => "variant" ":translation67d93f48043fas_articles_prices_attributes" => "s_articles_prices_attributes" ":translation67d93f48043fcfallbacks_articles_prices_attributes" => "s_articles_prices_attributes" ] |
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:1 [ 0 => 31 ] ":priceGroupCustomerGroup" => 1 ] |
0.0001 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, translation67d93f4804692config_units.objectdata as __unit_translation, translation67d93f4804696fallbackconfig_units.objectdata as __unit_translation_fallback, translation67d93f4804698article.objectdata as __product_translation, translation67d93f480469afallbackarticle.objectdata as __product_translation_fallback, translation67d93f480469cvariant.objectdata as __variant_translation, translation67d93f480469dfallbackvariant.objectdata as __variant_translation_fallback, translation67d93f480469fs_articles_prices_attributes.objectdata as __priceAttribute_translation, translation67d93f48046a0fallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f480469cvariant ON translation67d93f480469cvariant.objecttype = : translation67d93f480469cvariant AND translation67d93f480469cvariant.objectkey = variant.id AND translation67d93f480469cvariant.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480469dfallbackvariant ON translation67d93f480469dfallbackvariant.objecttype = : translation67d93f480469dfallbackvariant AND translation67d93f480469dfallbackvariant.objectkey = variant.id AND translation67d93f480469dfallbackvariant.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f4804698article ON translation67d93f4804698article.objecttype = : translation67d93f4804698article AND translation67d93f4804698article.objectkey = product.id AND translation67d93f4804698article.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480469afallbackarticle ON translation67d93f480469afallbackarticle.objecttype = : translation67d93f480469afallbackarticle AND translation67d93f480469afallbackarticle.objectkey = product.id AND translation67d93f480469afallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f4804692config_units ON translation67d93f4804692config_units.objecttype = : translation67d93f4804692config_units AND translation67d93f4804692config_units.objectkey = 1 AND translation67d93f4804692config_units.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4804696fallbackconfig_units ON translation67d93f4804696fallbackconfig_units.objecttype = : translation67d93f4804696fallbackconfig_units AND translation67d93f4804696fallbackconfig_units.objectkey = 1 AND translation67d93f4804696fallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f480469fs_articles_prices_attributes ON translation67d93f480469fs_articles_prices_attributes.objecttype = : translation67d93f480469fs_articles_prices_attributes AND translation67d93f480469fs_articles_prices_attributes.objectkey = price.id AND translation67d93f480469fs_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48046a0fallbacks_articles_prices_attributes ON translation67d93f48046a0fallbacks_articles_prices_attributes.objecttype = : translation67d93f48046a0fallbacks_articles_prices_attributes AND translation67d93f48046a0fallbacks_articles_prices_attributes.objectkey = price.id AND translation67d93f48046a0fallbacks_articles_prices_attributes.objectlanguage = : languagefallback WHERE price.id IN (: ids) |
array:11 [ ":ids" => [] ":language" => 3 ":translation67d93f4804692config_units" => "config_units" ":languagefallback" => 0 ":translation67d93f4804696fallbackconfig_units" => "config_units" ":translation67d93f4804698article" => "article" ":translation67d93f480469afallbackarticle" => "article" ":translation67d93f480469cvariant" => "variant" ":translation67d93f480469dfallbackvariant" => "variant" ":translation67d93f480469fs_articles_prices_attributes" => "s_articles_prices_attributes" ":translation67d93f48046a0fallbacks_articles_prices_attributes" => "s_articles_prices_attributes" ] |
0.0004 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 => 31 ] ] |
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" => array:1 [ 0 => 31 ] ] |
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, 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, translation67d93f4804a85s_categories_attributes.objectdata as __categoryAttribute_translation, translation67d93f4804a89fallbacks_categories_attributes.objectdata as __categoryAttribute_translation_fallback, translation67d93f4804a8bs_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f4804a8dfallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback, translation67d93f4804a8fproductStream.objectdata as __stream_translation, translation67d93f4804a91fallbackproductStream.objectdata as __stream_translation_fallback, translation67d93f4804a93category.objectdata as __category_translation, translation67d93f4804a95fallbackcategory.objectdata as __category_translation_fallback FROM s_categories category LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id LEFT JOIN s_media media ON media.id = category.mediaID LEFT JOIN s_product_streams stream ON category.stream_id = stream.id LEFT JOIN s_core_translations translation67d93f4804a93category ON translation67d93f4804a93category.objecttype = : translation67d93f4804a93category AND translation67d93f4804a93category.objectkey = category.id AND translation67d93f4804a93category.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4804a95fallbackcategory ON translation67d93f4804a95fallbackcategory.objecttype = : translation67d93f4804a95fallbackcategory AND translation67d93f4804a95fallbackcategory.objectkey = category.id AND translation67d93f4804a95fallbackcategory.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f4804a85s_categories_attributes ON translation67d93f4804a85s_categories_attributes.objecttype = : translation67d93f4804a85s_categories_attributes AND translation67d93f4804a85s_categories_attributes.objectkey = category.id AND translation67d93f4804a85s_categories_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4804a89fallbacks_categories_attributes ON translation67d93f4804a89fallbacks_categories_attributes.objecttype = : translation67d93f4804a89fallbacks_categories_attributes AND translation67d93f4804a89fallbacks_categories_attributes.objectkey = category.id AND translation67d93f4804a89fallbacks_categories_attributes.objectlanguage = : languagefallback LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id LEFT JOIN s_core_translations translation67d93f4804a8bs_media_attributes ON translation67d93f4804a8bs_media_attributes.objecttype = : translation67d93f4804a8bs_media_attributes AND translation67d93f4804a8bs_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4804a8bs_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4804a8dfallbacks_media_attributes ON translation67d93f4804a8dfallbacks_media_attributes.objecttype = : translation67d93f4804a8dfallbacks_media_attributes AND translation67d93f4804a8dfallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4804a8dfallbacks_media_attributes.objectlanguage = : languagefallback LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId LEFT JOIN s_core_translations translation67d93f4804a8fproductStream ON translation67d93f4804a8fproductStream.objecttype = : translation67d93f4804a8fproductStream AND translation67d93f4804a8fproductStream.objectkey = stream.id AND translation67d93f4804a8fproductStream.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4804a91fallbackproductStream ON translation67d93f4804a91fallbackproductStream.objecttype = : translation67d93f4804a91fallbackproductStream AND translation67d93f4804a91fallbackproductStream.objectkey = stream.id AND translation67d93f4804a91fallbackproductStream.objectlanguage = : languagefallback WHERE ( category.id IN (: categories) ) AND (category.active = 1) AND ( category.shops IS NULL OR category.shops LIKE : shopId ) GROUP BY category.id |
array:12 [ ":categories" => array:27 [ 0 => "3" 1 => "5" 2 => "7" 3 => "10" 4 => "18" 5 => "19" 6 => "20" 7 => "21" 8 => "50" 9 => "51" 10 => "52" 11 => "53" 12 => "54" 13 => "55" 14 => "56" 15 => "57" 16 => "58" 17 => "59" 18 => "60" 19 => "61" 20 => "62" 21 => "63" 22 => "76" 23 => "77" 24 => "78" 25 => "79" 26 => "80" ] ":shopId" => "%|3|%" ":language" => 3 ":translation67d93f4804a85s_categories_attributes" => "s_categories_attributes" ":languagefallback" => 0 ":translation67d93f4804a89fallbacks_categories_attributes" => "s_categories_attributes" ":translation67d93f4804a8bs_media_attributes" => "s_media_attributes" ":translation67d93f4804a8dfallbacks_media_attributes" => "s_media_attributes" ":translation67d93f4804a8fproductStream" => "productStream" ":translation67d93f4804a91fallbackproductStream" => "productStream" ":translation67d93f4804a93category" => "category" ":translation67d93f4804a95fallbackcategory" => "category" ] |
0.0012 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, translation67d93f4804ff1s_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f4804ff5fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f4804ff1s_media_attributes ON translation67d93f4804ff1s_media_attributes.objecttype = : translation67d93f4804ff1s_media_attributes AND translation67d93f4804ff1s_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4804ff1s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4804ff5fallbacks_media_attributes ON translation67d93f4804ff5fallbacks_media_attributes.objecttype = : translation67d93f4804ff5fallbacks_media_attributes AND translation67d93f4804ff5fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4804ff5fallbacks_media_attributes.objectlanguage = : languagefallback WHERE media.id IN (: ids) |
array:5 [ ":language" => 3 ":translation67d93f4804ff1s_media_attributes" => "s_media_attributes" ":languagefallback" => 0 ":translation67d93f4804ff5fallbacks_media_attributes" => "s_media_attributes" ":ids" => array:1 [ 10031 => 2 ] ] |
0.0003 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 => 31 ] ] |
0.0002 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 => 31 ] ] |
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, 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) ) as __product_fallback_price_count, manufacturerMedia.id as __manufacturer_img_id, translation67d93f4805477article.objectdata as __product_translation, translation67d93f480547afallbackarticle.objectdata as __product_translation_fallback, translation67d93f480547cvariant.objectdata as __variant_translation, translation67d93f480547efallbackvariant.objectdata as __variant_translation_fallback, translation67d93f4805480supplier.objectdata as __manufacturer_translation, translation67d93f4805481fallbacksupplier.objectdata as __manufacturer_translation_fallback, translation67d93f4805483config_units.objectdata as __unit_translation, translation67d93f4805484fallbackconfig_units.objectdata as __unit_translation_fallback, translation67d93f4805486s_articles_esd_attributes.objectdata as __esdAttribute_translation, translation67d93f4805487fallbacks_articles_esd_attributes.objectdata as __esdAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f480547cvariant ON translation67d93f480547cvariant.objecttype = : translation67d93f480547cvariant AND translation67d93f480547cvariant.objectkey = variant.id AND translation67d93f480547cvariant.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480547efallbackvariant ON translation67d93f480547efallbackvariant.objecttype = : translation67d93f480547efallbackvariant AND translation67d93f480547efallbackvariant.objectkey = variant.id AND translation67d93f480547efallbackvariant.objectlanguage = : languagefallback 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_core_translations translation67d93f4805477article ON translation67d93f4805477article.objecttype = : translation67d93f4805477article AND translation67d93f4805477article.objectkey = product.id AND translation67d93f4805477article.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480547afallbackarticle ON translation67d93f480547afallbackarticle.objecttype = : translation67d93f480547afallbackarticle AND translation67d93f480547afallbackarticle.objectkey = product.id AND translation67d93f480547afallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img LEFT JOIN s_core_translations translation67d93f4805480supplier ON translation67d93f4805480supplier.objecttype = : translation67d93f4805480supplier AND translation67d93f4805480supplier.objectkey = manufacturer.id AND translation67d93f4805480supplier.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4805481fallbacksupplier ON translation67d93f4805481fallbacksupplier.objecttype = : translation67d93f4805481fallbacksupplier AND translation67d93f4805481fallbacksupplier.objectkey = manufacturer.id AND translation67d93f4805481fallbacksupplier.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f4805483config_units ON translation67d93f4805483config_units.objecttype = : translation67d93f4805483config_units AND translation67d93f4805483config_units.objectkey = 1 AND translation67d93f4805483config_units.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4805484fallbackconfig_units ON translation67d93f4805484fallbackconfig_units.objecttype = : translation67d93f4805484fallbackconfig_units AND translation67d93f4805484fallbackconfig_units.objectkey = 1 AND translation67d93f4805484fallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id LEFT JOIN s_core_translations translation67d93f4805486s_articles_esd_attributes ON translation67d93f4805486s_articles_esd_attributes.objecttype = : translation67d93f4805486s_articles_esd_attributes AND translation67d93f4805486s_articles_esd_attributes.objectkey = esd.id AND translation67d93f4805486s_articles_esd_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4805487fallbacks_articles_esd_attributes ON translation67d93f4805487fallbacks_articles_esd_attributes.objecttype = : translation67d93f4805487fallbacks_articles_esd_attributes AND translation67d93f4805487fallbacks_articles_esd_attributes.objectkey = esd.id AND translation67d93f4805487fallbacks_articles_esd_attributes.objectlanguage = : languagefallback WHERE ( variant.ordernumber IN (: numbers) ) AND (variant.active = 1) AND (product.active = 1) |
array:14 [ ":fallback" => "EK" ":numbers" => array:3 [ 0 => 10022 1 => 10023 2 => 10024 ] ":language" => 3 ":translation67d93f4805477article" => "article" ":languagefallback" => 0 ":translation67d93f480547afallbackarticle" => "article" ":translation67d93f480547cvariant" => "variant" ":translation67d93f480547efallbackvariant" => "variant" ":translation67d93f4805480supplier" => "supplier" ":translation67d93f4805481fallbacksupplier" => "supplier" ":translation67d93f4805483config_units" => "config_units" ":translation67d93f4805484fallbackconfig_units" => "config_units" ":translation67d93f4805486s_articles_esd_attributes" => "s_articles_esd_attributes" ":translation67d93f4805487fallbacks_articles_esd_attributes" => "s_articles_esd_attributes" ] |
0.0028 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, translation67d93f480602barticleimage.objectdata as __image_translation, translation67d93f480602ffallbackarticleimage.objectdata as __image_translation_fallback, translation67d93f4806031s_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f4806033fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f480602barticleimage ON translation67d93f480602barticleimage.objecttype = : translation67d93f480602barticleimage AND translation67d93f480602barticleimage.objectkey = image.id AND translation67d93f480602barticleimage.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480602ffallbackarticleimage ON translation67d93f480602ffallbackarticleimage.objecttype = : translation67d93f480602ffallbackarticleimage AND translation67d93f480602ffallbackarticleimage.objectkey = image.id AND translation67d93f480602ffallbackarticleimage.objectlanguage = : languagefallback INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_core_translations translation67d93f4806031s_media_attributes ON translation67d93f4806031s_media_attributes.objecttype = : translation67d93f4806031s_media_attributes AND translation67d93f4806031s_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4806031s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4806033fallbacks_media_attributes ON translation67d93f4806033fallbacks_media_attributes.objecttype = : translation67d93f4806033fallbacks_media_attributes AND translation67d93f4806033fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4806033fallbacks_media_attributes.objectlanguage = : languagefallback WHERE childImage.article_detail_id IN (: products) ORDER BY image.main ASC, image.position ASC |
array:7 [ ":language" => 3 ":translation67d93f480602barticleimage" => "articleimage" ":languagefallback" => 0 ":translation67d93f480602ffallbackarticleimage" => "articleimage" ":translation67d93f4806031s_media_attributes" => "s_media_attributes" ":translation67d93f4806033fallbacks_media_attributes" => "s_media_attributes" ":products" => array:3 [ 0 => 51 1 => 52 2 => 53 ] ] |
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, translation67d93f480632aarticleimage.objectdata as __image_translation, translation67d93f480632efallbackarticleimage.objectdata as __image_translation_fallback, translation67d93f4806331s_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f4806333fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f480632aarticleimage ON translation67d93f480632aarticleimage.objecttype = : translation67d93f480632aarticleimage AND translation67d93f480632aarticleimage.objectkey = image.id AND translation67d93f480632aarticleimage.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480632efallbackarticleimage ON translation67d93f480632efallbackarticleimage.objecttype = : translation67d93f480632efallbackarticleimage AND translation67d93f480632efallbackarticleimage.objectkey = image.id AND translation67d93f480632efallbackarticleimage.objectlanguage = : languagefallback INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_core_translations translation67d93f4806331s_media_attributes ON translation67d93f4806331s_media_attributes.objecttype = : translation67d93f4806331s_media_attributes AND translation67d93f4806331s_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4806331s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4806333fallbacks_media_attributes ON translation67d93f4806333fallbacks_media_attributes.objecttype = : translation67d93f4806333fallbacks_media_attributes AND translation67d93f4806333fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4806333fallbacks_media_attributes.objectlanguage = : languagefallback WHERE (image.main = 1) AND ( image.articleID IN (: products) ) |
array:7 [ ":language" => 3 ":translation67d93f480632aarticleimage" => "articleimage" ":languagefallback" => 0 ":translation67d93f480632efallbackarticleimage" => "articleimage" ":translation67d93f4806331s_media_attributes" => "s_media_attributes" ":translation67d93f4806333fallbacks_media_attributes" => "s_media_attributes" ":products" => array:3 [ 0 => 22 1 => 23 2 => 24 ] ] |
0.0006 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, translation67d93f4806663s_articles_prices_attributes.objectdata as __priceAttribute_translation, translation67d93f4806666fallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f4806663s_articles_prices_attributes ON translation67d93f4806663s_articles_prices_attributes.objecttype = : translation67d93f4806663s_articles_prices_attributes AND translation67d93f4806663s_articles_prices_attributes.objectkey = price.id AND translation67d93f4806663s_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4806666fallbacks_articles_prices_attributes ON translation67d93f4806666fallbacks_articles_prices_attributes.objecttype = : translation67d93f4806666fallbacks_articles_prices_attributes AND translation67d93f4806666fallbacks_articles_prices_attributes.objectkey = price.id AND translation67d93f4806666fallbacks_articles_prices_attributes.objectlanguage = : languagefallback 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:6 [ ":products" => array:3 [ 0 => 51 1 => 52 2 => 53 ] ":customerGroup" => "EK" ":language" => 3 ":translation67d93f4806663s_articles_prices_attributes" => "s_articles_prices_attributes" ":languagefallback" => 0 ":translation67d93f4806666fallbacks_articles_prices_attributes" => "s_articles_prices_attributes" ] |
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:3 [ 0 => 22 1 => 23 2 => 24 ] ":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, translation67d93f4806a61config_units.objectdata as __unit_translation, translation67d93f4806a65fallbackconfig_units.objectdata as __unit_translation_fallback, translation67d93f4806a67article.objectdata as __product_translation, translation67d93f4806a69fallbackarticle.objectdata as __product_translation_fallback, translation67d93f4806a6bvariant.objectdata as __variant_translation, translation67d93f4806a6cfallbackvariant.objectdata as __variant_translation_fallback, translation67d93f4806a6es_articles_prices_attributes.objectdata as __priceAttribute_translation, translation67d93f4806a6ffallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f4806a6bvariant ON translation67d93f4806a6bvariant.objecttype = : translation67d93f4806a6bvariant AND translation67d93f4806a6bvariant.objectkey = variant.id AND translation67d93f4806a6bvariant.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4806a6cfallbackvariant ON translation67d93f4806a6cfallbackvariant.objecttype = : translation67d93f4806a6cfallbackvariant AND translation67d93f4806a6cfallbackvariant.objectkey = variant.id AND translation67d93f4806a6cfallbackvariant.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f4806a67article ON translation67d93f4806a67article.objecttype = : translation67d93f4806a67article AND translation67d93f4806a67article.objectkey = product.id AND translation67d93f4806a67article.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4806a69fallbackarticle ON translation67d93f4806a69fallbackarticle.objecttype = : translation67d93f4806a69fallbackarticle AND translation67d93f4806a69fallbackarticle.objectkey = product.id AND translation67d93f4806a69fallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f4806a61config_units ON translation67d93f4806a61config_units.objecttype = : translation67d93f4806a61config_units AND translation67d93f4806a61config_units.objectkey = 1 AND translation67d93f4806a61config_units.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4806a65fallbackconfig_units ON translation67d93f4806a65fallbackconfig_units.objecttype = : translation67d93f4806a65fallbackconfig_units AND translation67d93f4806a65fallbackconfig_units.objectkey = 1 AND translation67d93f4806a65fallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f4806a6es_articles_prices_attributes ON translation67d93f4806a6es_articles_prices_attributes.objecttype = : translation67d93f4806a6es_articles_prices_attributes AND translation67d93f4806a6es_articles_prices_attributes.objectkey = price.id AND translation67d93f4806a6es_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4806a6ffallbacks_articles_prices_attributes ON translation67d93f4806a6ffallbacks_articles_prices_attributes.objecttype = : translation67d93f4806a6ffallbacks_articles_prices_attributes AND translation67d93f4806a6ffallbacks_articles_prices_attributes.objectkey = price.id AND translation67d93f4806a6ffallbacks_articles_prices_attributes.objectlanguage = : languagefallback WHERE price.id IN (: ids) |
array:11 [ ":ids" => array:3 [ 0 => "112" 1 => "113" 2 => "125" ] ":language" => 3 ":translation67d93f4806a61config_units" => "config_units" ":languagefallback" => 0 ":translation67d93f4806a65fallbackconfig_units" => "config_units" ":translation67d93f4806a67article" => "article" ":translation67d93f4806a69fallbackarticle" => "article" ":translation67d93f4806a6bvariant" => "variant" ":translation67d93f4806a6cfallbackvariant" => "variant" ":translation67d93f4806a6es_articles_prices_attributes" => "s_articles_prices_attributes" ":translation67d93f4806a6ffallbacks_articles_prices_attributes" => "s_articles_prices_attributes" ] |
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:3 [ 0 => 22 1 => 23 2 => 24 ] ] |
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" => array:3 [ 0 => 22 1 => 23 2 => 24 ] ] |
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, 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, translation67d93f4806f56s_categories_attributes.objectdata as __categoryAttribute_translation, translation67d93f4806f5afallbacks_categories_attributes.objectdata as __categoryAttribute_translation_fallback, translation67d93f4806f5ds_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f4806f5efallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback, translation67d93f4806f60productStream.objectdata as __stream_translation, translation67d93f4806f62fallbackproductStream.objectdata as __stream_translation_fallback, translation67d93f4806f64category.objectdata as __category_translation, translation67d93f4806f65fallbackcategory.objectdata as __category_translation_fallback FROM s_categories category LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id LEFT JOIN s_media media ON media.id = category.mediaID LEFT JOIN s_product_streams stream ON category.stream_id = stream.id LEFT JOIN s_core_translations translation67d93f4806f64category ON translation67d93f4806f64category.objecttype = : translation67d93f4806f64category AND translation67d93f4806f64category.objectkey = category.id AND translation67d93f4806f64category.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4806f65fallbackcategory ON translation67d93f4806f65fallbackcategory.objecttype = : translation67d93f4806f65fallbackcategory AND translation67d93f4806f65fallbackcategory.objectkey = category.id AND translation67d93f4806f65fallbackcategory.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f4806f56s_categories_attributes ON translation67d93f4806f56s_categories_attributes.objecttype = : translation67d93f4806f56s_categories_attributes AND translation67d93f4806f56s_categories_attributes.objectkey = category.id AND translation67d93f4806f56s_categories_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4806f5afallbacks_categories_attributes ON translation67d93f4806f5afallbacks_categories_attributes.objecttype = : translation67d93f4806f5afallbacks_categories_attributes AND translation67d93f4806f5afallbacks_categories_attributes.objectkey = category.id AND translation67d93f4806f5afallbacks_categories_attributes.objectlanguage = : languagefallback LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id LEFT JOIN s_core_translations translation67d93f4806f5ds_media_attributes ON translation67d93f4806f5ds_media_attributes.objecttype = : translation67d93f4806f5ds_media_attributes AND translation67d93f4806f5ds_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4806f5ds_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4806f5efallbacks_media_attributes ON translation67d93f4806f5efallbacks_media_attributes.objecttype = : translation67d93f4806f5efallbacks_media_attributes AND translation67d93f4806f5efallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4806f5efallbacks_media_attributes.objectlanguage = : languagefallback LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId LEFT JOIN s_core_translations translation67d93f4806f60productStream ON translation67d93f4806f60productStream.objecttype = : translation67d93f4806f60productStream AND translation67d93f4806f60productStream.objectkey = stream.id AND translation67d93f4806f60productStream.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4806f62fallbackproductStream ON translation67d93f4806f62fallbackproductStream.objecttype = : translation67d93f4806f62fallbackproductStream AND translation67d93f4806f62fallbackproductStream.objectkey = stream.id AND translation67d93f4806f62fallbackproductStream.objectlanguage = : languagefallback WHERE ( category.id IN (: categories) ) AND (category.active = 1) AND ( category.shops IS NULL OR category.shops LIKE : shopId ) GROUP BY category.id |
array:12 [ ":categories" => array:27 [ 0 => "3" 1 => "5" 2 => "7" 3 => "10" 4 => "18" 5 => "19" 6 => "20" 7 => "21" 8 => "50" 9 => "51" 10 => "52" 11 => "53" 12 => "54" 13 => "55" 14 => "56" 15 => "57" 16 => "58" 17 => "59" 18 => "60" 19 => "61" 20 => "62" 21 => "63" 22 => "76" 23 => "77" 24 => "78" 25 => "79" 26 => "80" ] ":shopId" => "%|3|%" ":language" => 3 ":translation67d93f4806f56s_categories_attributes" => "s_categories_attributes" ":languagefallback" => 0 ":translation67d93f4806f5afallbacks_categories_attributes" => "s_categories_attributes" ":translation67d93f4806f5ds_media_attributes" => "s_media_attributes" ":translation67d93f4806f5efallbacks_media_attributes" => "s_media_attributes" ":translation67d93f4806f60productStream" => "productStream" ":translation67d93f4806f62fallbackproductStream" => "productStream" ":translation67d93f4806f64category" => "category" ":translation67d93f4806f65fallbackcategory" => "category" ] |
0.0013 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, translation67d93f4807574s_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f4807578fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f4807574s_media_attributes ON translation67d93f4807574s_media_attributes.objecttype = : translation67d93f4807574s_media_attributes AND translation67d93f4807574s_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4807574s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4807578fallbacks_media_attributes ON translation67d93f4807578fallbacks_media_attributes.objecttype = : translation67d93f4807578fallbacks_media_attributes AND translation67d93f4807578fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4807578fallbacks_media_attributes.objectlanguage = : languagefallback WHERE media.id IN (: ids) |
array:5 [ ":language" => 3 ":translation67d93f4807574s_media_attributes" => "s_media_attributes" ":languagefallback" => 0 ":translation67d93f4807578fallbacks_media_attributes" => "s_media_attributes" ":ids" => array:1 [ 10022 => 2 ] ] |
0.0003 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, translation67d93f4807759productStream.objectdata as __stream_translation, translation67d93f480775dfallbackproductStream.objectdata as __stream_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f4807759productStream ON translation67d93f4807759productStream.objecttype = : translation67d93f4807759productStream AND translation67d93f4807759productStream.objectkey = stream.id AND translation67d93f4807759productStream.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480775dfallbackproductStream ON translation67d93f480775dfallbackproductStream.objecttype = : translation67d93f480775dfallbackproductStream AND translation67d93f480775dfallbackproductStream.objectkey = stream.id AND translation67d93f480775dfallbackproductStream.objectlanguage = : languagefallback WHERE relation.article_id IN (: ids) |
array:5 [ ":ids" => array:1 [ 0 => 31 ] ":language" => 3 ":translation67d93f4807759productStream" => "productStream" ":languagefallback" => 0 ":translation67d93f480775dfallbackproductStream" => "productStream" ] |
0.0002 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 => 31 ] ] |
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, 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) ) as __product_fallback_price_count, manufacturerMedia.id as __manufacturer_img_id, translation67d93f48079b8article.objectdata as __product_translation, translation67d93f48079bcfallbackarticle.objectdata as __product_translation_fallback, translation67d93f48079bevariant.objectdata as __variant_translation, translation67d93f48079c0fallbackvariant.objectdata as __variant_translation_fallback, translation67d93f48079c2supplier.objectdata as __manufacturer_translation, translation67d93f48079c3fallbacksupplier.objectdata as __manufacturer_translation_fallback, translation67d93f48079c5config_units.objectdata as __unit_translation, translation67d93f48079c7fallbackconfig_units.objectdata as __unit_translation_fallback, translation67d93f48079c8s_articles_esd_attributes.objectdata as __esdAttribute_translation, translation67d93f48079c9fallbacks_articles_esd_attributes.objectdata as __esdAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f48079bevariant ON translation67d93f48079bevariant.objecttype = : translation67d93f48079bevariant AND translation67d93f48079bevariant.objectkey = variant.id AND translation67d93f48079bevariant.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48079c0fallbackvariant ON translation67d93f48079c0fallbackvariant.objecttype = : translation67d93f48079c0fallbackvariant AND translation67d93f48079c0fallbackvariant.objectkey = variant.id AND translation67d93f48079c0fallbackvariant.objectlanguage = : languagefallback 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_core_translations translation67d93f48079b8article ON translation67d93f48079b8article.objecttype = : translation67d93f48079b8article AND translation67d93f48079b8article.objectkey = product.id AND translation67d93f48079b8article.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48079bcfallbackarticle ON translation67d93f48079bcfallbackarticle.objecttype = : translation67d93f48079bcfallbackarticle AND translation67d93f48079bcfallbackarticle.objectkey = product.id AND translation67d93f48079bcfallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img LEFT JOIN s_core_translations translation67d93f48079c2supplier ON translation67d93f48079c2supplier.objecttype = : translation67d93f48079c2supplier AND translation67d93f48079c2supplier.objectkey = manufacturer.id AND translation67d93f48079c2supplier.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48079c3fallbacksupplier ON translation67d93f48079c3fallbacksupplier.objecttype = : translation67d93f48079c3fallbacksupplier AND translation67d93f48079c3fallbacksupplier.objectkey = manufacturer.id AND translation67d93f48079c3fallbacksupplier.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f48079c5config_units ON translation67d93f48079c5config_units.objecttype = : translation67d93f48079c5config_units AND translation67d93f48079c5config_units.objectkey = 1 AND translation67d93f48079c5config_units.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48079c7fallbackconfig_units ON translation67d93f48079c7fallbackconfig_units.objecttype = : translation67d93f48079c7fallbackconfig_units AND translation67d93f48079c7fallbackconfig_units.objectkey = 1 AND translation67d93f48079c7fallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id LEFT JOIN s_core_translations translation67d93f48079c8s_articles_esd_attributes ON translation67d93f48079c8s_articles_esd_attributes.objecttype = : translation67d93f48079c8s_articles_esd_attributes AND translation67d93f48079c8s_articles_esd_attributes.objectkey = esd.id AND translation67d93f48079c8s_articles_esd_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48079c9fallbacks_articles_esd_attributes ON translation67d93f48079c9fallbacks_articles_esd_attributes.objecttype = : translation67d93f48079c9fallbacks_articles_esd_attributes AND translation67d93f48079c9fallbacks_articles_esd_attributes.objectkey = esd.id AND translation67d93f48079c9fallbacks_articles_esd_attributes.objectlanguage = : languagefallback WHERE ( variant.ordernumber IN (: numbers) ) AND (variant.active = 1) AND (product.active = 1) |
array:14 [ ":fallback" => "EK" ":numbers" => array:6 [ 0 => 10011 1 => 10012 2 => 10013 3 => 10014 4 => 10016 5 => 10021 ] ":language" => 3 ":translation67d93f48079b8article" => "article" ":languagefallback" => 0 ":translation67d93f48079bcfallbackarticle" => "article" ":translation67d93f48079bevariant" => "variant" ":translation67d93f48079c0fallbackvariant" => "variant" ":translation67d93f48079c2supplier" => "supplier" ":translation67d93f48079c3fallbacksupplier" => "supplier" ":translation67d93f48079c5config_units" => "config_units" ":translation67d93f48079c7fallbackconfig_units" => "config_units" ":translation67d93f48079c8s_articles_esd_attributes" => "s_articles_esd_attributes" ":translation67d93f48079c9fallbacks_articles_esd_attributes" => "s_articles_esd_attributes" ] |
0.0027 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, translation67d93f48085a6articleimage.objectdata as __image_translation, translation67d93f48085aafallbackarticleimage.objectdata as __image_translation_fallback, translation67d93f48085ads_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f48085affallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f48085a6articleimage ON translation67d93f48085a6articleimage.objecttype = : translation67d93f48085a6articleimage AND translation67d93f48085a6articleimage.objectkey = image.id AND translation67d93f48085a6articleimage.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48085aafallbackarticleimage ON translation67d93f48085aafallbackarticleimage.objecttype = : translation67d93f48085aafallbackarticleimage AND translation67d93f48085aafallbackarticleimage.objectkey = image.id AND translation67d93f48085aafallbackarticleimage.objectlanguage = : languagefallback INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_core_translations translation67d93f48085ads_media_attributes ON translation67d93f48085ads_media_attributes.objecttype = : translation67d93f48085ads_media_attributes AND translation67d93f48085ads_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f48085ads_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48085affallbacks_media_attributes ON translation67d93f48085affallbacks_media_attributes.objecttype = : translation67d93f48085affallbacks_media_attributes AND translation67d93f48085affallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f48085affallbacks_media_attributes.objectlanguage = : languagefallback WHERE childImage.article_detail_id IN (: products) ORDER BY image.main ASC, image.position ASC |
array:7 [ ":language" => 3 ":translation67d93f48085a6articleimage" => "articleimage" ":languagefallback" => 0 ":translation67d93f48085aafallbackarticleimage" => "articleimage" ":translation67d93f48085ads_media_attributes" => "s_media_attributes" ":translation67d93f48085affallbacks_media_attributes" => "s_media_attributes" ":products" => array:6 [ 0 => 30 1 => 31 2 => 34 3 => 43 4 => 45 5 => 50 ] ] |
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, translation67d93f4808888articleimage.objectdata as __image_translation, translation67d93f480888cfallbackarticleimage.objectdata as __image_translation_fallback, translation67d93f480888fs_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f4808890fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f4808888articleimage ON translation67d93f4808888articleimage.objecttype = : translation67d93f4808888articleimage AND translation67d93f4808888articleimage.objectkey = image.id AND translation67d93f4808888articleimage.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480888cfallbackarticleimage ON translation67d93f480888cfallbackarticleimage.objecttype = : translation67d93f480888cfallbackarticleimage AND translation67d93f480888cfallbackarticleimage.objectkey = image.id AND translation67d93f480888cfallbackarticleimage.objectlanguage = : languagefallback INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_core_translations translation67d93f480888fs_media_attributes ON translation67d93f480888fs_media_attributes.objecttype = : translation67d93f480888fs_media_attributes AND translation67d93f480888fs_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f480888fs_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4808890fallbacks_media_attributes ON translation67d93f4808890fallbacks_media_attributes.objecttype = : translation67d93f4808890fallbacks_media_attributes AND translation67d93f4808890fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4808890fallbacks_media_attributes.objectlanguage = : languagefallback WHERE (image.main = 1) AND ( image.articleID IN (: products) ) |
array:7 [ ":language" => 3 ":translation67d93f4808888articleimage" => "articleimage" ":languagefallback" => 0 ":translation67d93f480888cfallbackarticleimage" => "articleimage" ":translation67d93f480888fs_media_attributes" => "s_media_attributes" ":translation67d93f4808890fallbacks_media_attributes" => "s_media_attributes" ":products" => array:6 [ 0 => 11 1 => 12 2 => 13 3 => 14 4 => 16 5 => 21 ] ] |
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, variants.ordernumber as number, GREATEST( price.from, variants.minpurchase ) __price_from, translation67d93f4808c4bs_articles_prices_attributes.objectdata as __priceAttribute_translation, translation67d93f4808c4ffallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f4808c4bs_articles_prices_attributes ON translation67d93f4808c4bs_articles_prices_attributes.objecttype = : translation67d93f4808c4bs_articles_prices_attributes AND translation67d93f4808c4bs_articles_prices_attributes.objectkey = price.id AND translation67d93f4808c4bs_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4808c4ffallbacks_articles_prices_attributes ON translation67d93f4808c4ffallbacks_articles_prices_attributes.objecttype = : translation67d93f4808c4ffallbacks_articles_prices_attributes AND translation67d93f4808c4ffallbacks_articles_prices_attributes.objectkey = price.id AND translation67d93f4808c4ffallbacks_articles_prices_attributes.objectlanguage = : languagefallback 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:6 [ ":products" => array:6 [ 0 => 30 1 => 31 2 => 34 3 => 43 4 => 45 5 => 50 ] ":customerGroup" => "EK" ":language" => 3 ":translation67d93f4808c4bs_articles_prices_attributes" => "s_articles_prices_attributes" ":languagefallback" => 0 ":translation67d93f4808c4ffallbacks_articles_prices_attributes" => "s_articles_prices_attributes" ] |
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:6 [ 0 => 11 1 => 12 2 => 13 3 => 14 4 => 16 5 => 21 ] ":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, translation67d93f480907fconfig_units.objectdata as __unit_translation, translation67d93f4809083fallbackconfig_units.objectdata as __unit_translation_fallback, translation67d93f4809086article.objectdata as __product_translation, translation67d93f4809087fallbackarticle.objectdata as __product_translation_fallback, translation67d93f4809089variant.objectdata as __variant_translation, translation67d93f480908afallbackvariant.objectdata as __variant_translation_fallback, translation67d93f480908cs_articles_prices_attributes.objectdata as __priceAttribute_translation, translation67d93f480908dfallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f4809089variant ON translation67d93f4809089variant.objecttype = : translation67d93f4809089variant AND translation67d93f4809089variant.objectkey = variant.id AND translation67d93f4809089variant.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480908afallbackvariant ON translation67d93f480908afallbackvariant.objecttype = : translation67d93f480908afallbackvariant AND translation67d93f480908afallbackvariant.objectkey = variant.id AND translation67d93f480908afallbackvariant.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f4809086article ON translation67d93f4809086article.objecttype = : translation67d93f4809086article AND translation67d93f4809086article.objectkey = product.id AND translation67d93f4809086article.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4809087fallbackarticle ON translation67d93f4809087fallbackarticle.objecttype = : translation67d93f4809087fallbackarticle AND translation67d93f4809087fallbackarticle.objectkey = product.id AND translation67d93f4809087fallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f480907fconfig_units ON translation67d93f480907fconfig_units.objecttype = : translation67d93f480907fconfig_units AND translation67d93f480907fconfig_units.objectkey = 1 AND translation67d93f480907fconfig_units.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4809083fallbackconfig_units ON translation67d93f4809083fallbackconfig_units.objecttype = : translation67d93f4809083fallbackconfig_units AND translation67d93f4809083fallbackconfig_units.objectkey = 1 AND translation67d93f4809083fallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f480908cs_articles_prices_attributes ON translation67d93f480908cs_articles_prices_attributes.objecttype = : translation67d93f480908cs_articles_prices_attributes AND translation67d93f480908cs_articles_prices_attributes.objectkey = price.id AND translation67d93f480908cs_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480908dfallbacks_articles_prices_attributes ON translation67d93f480908dfallbacks_articles_prices_attributes.objecttype = : translation67d93f480908dfallbacks_articles_prices_attributes AND translation67d93f480908dfallbacks_articles_prices_attributes.objectkey = price.id AND translation67d93f480908dfallbacks_articles_prices_attributes.objectlanguage = : languagefallback WHERE price.id IN (: ids) |
array:11 [ ":ids" => array:5 [ 0 => "54" 1 => "69" 2 => "101" 3 => "103" 4 => "108" ] ":language" => 3 ":translation67d93f480907fconfig_units" => "config_units" ":languagefallback" => 0 ":translation67d93f4809083fallbackconfig_units" => "config_units" ":translation67d93f4809086article" => "article" ":translation67d93f4809087fallbackarticle" => "article" ":translation67d93f4809089variant" => "variant" ":translation67d93f480908afallbackvariant" => "variant" ":translation67d93f480908cs_articles_prices_attributes" => "s_articles_prices_attributes" ":translation67d93f480908dfallbacks_articles_prices_attributes" => "s_articles_prices_attributes" ] |
0.0006 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 => 11 ] ":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, translation67d93f4809465config_units.objectdata as __unit_translation, translation67d93f4809469fallbackconfig_units.objectdata as __unit_translation_fallback, translation67d93f480946barticle.objectdata as __product_translation, translation67d93f480946dfallbackarticle.objectdata as __product_translation_fallback, translation67d93f480946fvariant.objectdata as __variant_translation, translation67d93f4809470fallbackvariant.objectdata as __variant_translation_fallback, translation67d93f4809472s_articles_prices_attributes.objectdata as __priceAttribute_translation, translation67d93f4809474fallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f480946fvariant ON translation67d93f480946fvariant.objecttype = : translation67d93f480946fvariant AND translation67d93f480946fvariant.objectkey = variant.id AND translation67d93f480946fvariant.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4809470fallbackvariant ON translation67d93f4809470fallbackvariant.objecttype = : translation67d93f4809470fallbackvariant AND translation67d93f4809470fallbackvariant.objectkey = variant.id AND translation67d93f4809470fallbackvariant.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f480946barticle ON translation67d93f480946barticle.objecttype = : translation67d93f480946barticle AND translation67d93f480946barticle.objectkey = product.id AND translation67d93f480946barticle.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480946dfallbackarticle ON translation67d93f480946dfallbackarticle.objecttype = : translation67d93f480946dfallbackarticle AND translation67d93f480946dfallbackarticle.objectkey = product.id AND translation67d93f480946dfallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f4809465config_units ON translation67d93f4809465config_units.objecttype = : translation67d93f4809465config_units AND translation67d93f4809465config_units.objectkey = 1 AND translation67d93f4809465config_units.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4809469fallbackconfig_units ON translation67d93f4809469fallbackconfig_units.objecttype = : translation67d93f4809469fallbackconfig_units AND translation67d93f4809469fallbackconfig_units.objectkey = 1 AND translation67d93f4809469fallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f4809472s_articles_prices_attributes ON translation67d93f4809472s_articles_prices_attributes.objecttype = : translation67d93f4809472s_articles_prices_attributes AND translation67d93f4809472s_articles_prices_attributes.objectkey = price.id AND translation67d93f4809472s_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4809474fallbacks_articles_prices_attributes ON translation67d93f4809474fallbacks_articles_prices_attributes.objecttype = : translation67d93f4809474fallbacks_articles_prices_attributes AND translation67d93f4809474fallbacks_articles_prices_attributes.objectkey = price.id AND translation67d93f4809474fallbacks_articles_prices_attributes.objectlanguage = : languagefallback WHERE price.id IN (: ids) |
array:11 [ ":ids" => [] ":language" => 3 ":translation67d93f4809465config_units" => "config_units" ":languagefallback" => 0 ":translation67d93f4809469fallbackconfig_units" => "config_units" ":translation67d93f480946barticle" => "article" ":translation67d93f480946dfallbackarticle" => "article" ":translation67d93f480946fvariant" => "variant" ":translation67d93f4809470fallbackvariant" => "variant" ":translation67d93f4809472s_articles_prices_attributes" => "s_articles_prices_attributes" ":translation67d93f4809474fallbacks_articles_prices_attributes" => "s_articles_prices_attributes" ] |
0.0004 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:6 [ 0 => 11 1 => 12 2 => 13 3 => 14 4 => 16 5 => 21 ] ] |
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" => array:6 [ 0 => 11 1 => 12 2 => 13 3 => 14 4 => 16 5 => 21 ] ] |
0.0004 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, 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, translation67d93f4809908s_categories_attributes.objectdata as __categoryAttribute_translation, translation67d93f480990cfallbacks_categories_attributes.objectdata as __categoryAttribute_translation_fallback, translation67d93f480990fs_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f4809911fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback, translation67d93f4809913productStream.objectdata as __stream_translation, translation67d93f4809914fallbackproductStream.objectdata as __stream_translation_fallback, translation67d93f4809916category.objectdata as __category_translation, translation67d93f4809917fallbackcategory.objectdata as __category_translation_fallback FROM s_categories category LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id LEFT JOIN s_media media ON media.id = category.mediaID LEFT JOIN s_product_streams stream ON category.stream_id = stream.id LEFT JOIN s_core_translations translation67d93f4809916category ON translation67d93f4809916category.objecttype = : translation67d93f4809916category AND translation67d93f4809916category.objectkey = category.id AND translation67d93f4809916category.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4809917fallbackcategory ON translation67d93f4809917fallbackcategory.objecttype = : translation67d93f4809917fallbackcategory AND translation67d93f4809917fallbackcategory.objectkey = category.id AND translation67d93f4809917fallbackcategory.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f4809908s_categories_attributes ON translation67d93f4809908s_categories_attributes.objecttype = : translation67d93f4809908s_categories_attributes AND translation67d93f4809908s_categories_attributes.objectkey = category.id AND translation67d93f4809908s_categories_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480990cfallbacks_categories_attributes ON translation67d93f480990cfallbacks_categories_attributes.objecttype = : translation67d93f480990cfallbacks_categories_attributes AND translation67d93f480990cfallbacks_categories_attributes.objectkey = category.id AND translation67d93f480990cfallbacks_categories_attributes.objectlanguage = : languagefallback LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id LEFT JOIN s_core_translations translation67d93f480990fs_media_attributes ON translation67d93f480990fs_media_attributes.objecttype = : translation67d93f480990fs_media_attributes AND translation67d93f480990fs_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f480990fs_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4809911fallbacks_media_attributes ON translation67d93f4809911fallbacks_media_attributes.objecttype = : translation67d93f4809911fallbacks_media_attributes AND translation67d93f4809911fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4809911fallbacks_media_attributes.objectlanguage = : languagefallback LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId LEFT JOIN s_core_translations translation67d93f4809913productStream ON translation67d93f4809913productStream.objecttype = : translation67d93f4809913productStream AND translation67d93f4809913productStream.objectkey = stream.id AND translation67d93f4809913productStream.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4809914fallbackproductStream ON translation67d93f4809914fallbackproductStream.objecttype = : translation67d93f4809914fallbackproductStream AND translation67d93f4809914fallbackproductStream.objectkey = stream.id AND translation67d93f4809914fallbackproductStream.objectlanguage = : languagefallback WHERE ( category.id IN (: categories) ) AND (category.active = 1) AND ( category.shops IS NULL OR category.shops LIKE : shopId ) GROUP BY category.id |
array:12 [ ":categories" => array:22 [ 0 => "3" 1 => "5" 2 => "7" 3 => "9" 4 => "15" 5 => "16" 6 => "17" 7 => "35" 8 => "36" 9 => "37" 10 => "38" 11 => "39" 12 => "40" 13 => "41" 14 => "42" 15 => "43" 16 => "44" 17 => "45" 18 => "46" 19 => "47" 20 => "48" 21 => "49" ] ":shopId" => "%|3|%" ":language" => 3 ":translation67d93f4809908s_categories_attributes" => "s_categories_attributes" ":languagefallback" => 0 ":translation67d93f480990cfallbacks_categories_attributes" => "s_categories_attributes" ":translation67d93f480990fs_media_attributes" => "s_media_attributes" ":translation67d93f4809911fallbacks_media_attributes" => "s_media_attributes" ":translation67d93f4809913productStream" => "productStream" ":translation67d93f4809914fallbackproductStream" => "productStream" ":translation67d93f4809916category" => "category" ":translation67d93f4809917fallbackcategory" => "category" ] |
0.0010 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, translation67d93f4809df4s_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f4809df8fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f4809df4s_media_attributes ON translation67d93f4809df4s_media_attributes.objecttype = : translation67d93f4809df4s_media_attributes AND translation67d93f4809df4s_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4809df4s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4809df8fallbacks_media_attributes ON translation67d93f4809df8fallbacks_media_attributes.objecttype = : translation67d93f4809df8fallbacks_media_attributes AND translation67d93f4809df8fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4809df8fallbacks_media_attributes.objectlanguage = : languagefallback WHERE media.id IN (: ids) |
array:5 [ ":language" => 3 ":translation67d93f4809df4s_media_attributes" => "s_media_attributes" ":languagefallback" => 0 ":translation67d93f4809df8fallbacks_media_attributes" => "s_media_attributes" ":ids" => array:4 [ 10012 => 2 10013 => 2 10014 => 2 10021 => 2 ] ] |
0.0003 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, translation67d93f480a027s_articles_downloads_attributes.objectdata as __downloadAttribute_translation, translation67d93f480a02bfallbacks_articles_downloads_attributes.objectdata as __downloadAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f480a027s_articles_downloads_attributes ON translation67d93f480a027s_articles_downloads_attributes.objecttype = : translation67d93f480a027s_articles_downloads_attributes AND translation67d93f480a027s_articles_downloads_attributes.objectkey = download.id AND translation67d93f480a027s_articles_downloads_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480a02bfallbacks_articles_downloads_attributes ON translation67d93f480a02bfallbacks_articles_downloads_attributes.objecttype = : translation67d93f480a02bfallbacks_articles_downloads_attributes AND translation67d93f480a02bfallbacks_articles_downloads_attributes.objectkey = download.id AND translation67d93f480a02bfallbacks_articles_downloads_attributes.objectlanguage = : languagefallback WHERE download.articleID IN (: ids) |
array:5 [ ":ids" => array:1 [ 0 => 31 ] ":language" => 3 ":translation67d93f480a027s_articles_downloads_attributes" => "s_articles_downloads_attributes" ":languagefallback" => 0 ":translation67d93f480a02bfallbacks_articles_downloads_attributes" => "s_articles_downloads_attributes" ] |
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, translation67d93f480a195s_articles_information_attributes.objectdata as __linkAttribute_translation, translation67d93f480a199fallbacks_articles_information_attributes.objectdata as __linkAttribute_translation_fallback FROM s_articles_information link LEFT JOIN s_articles_information_attributes linkAttribute ON linkAttribute.informationID = link.id LEFT JOIN s_core_translations translation67d93f480a195s_articles_information_attributes ON translation67d93f480a195s_articles_information_attributes.objecttype = : translation67d93f480a195s_articles_information_attributes AND translation67d93f480a195s_articles_information_attributes.objectkey = link.id AND translation67d93f480a195s_articles_information_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480a199fallbacks_articles_information_attributes ON translation67d93f480a199fallbacks_articles_information_attributes.objecttype = : translation67d93f480a199fallbacks_articles_information_attributes AND translation67d93f480a199fallbacks_articles_information_attributes.objectkey = link.id AND translation67d93f480a199fallbacks_articles_information_attributes.objectlanguage = : languagefallback WHERE link.articleID IN (: ids) |
array:5 [ ":ids" => array:1 [ 0 => 31 ] ":language" => 3 ":translation67d93f480a195s_articles_information_attributes" => "s_articles_information_attributes" ":languagefallback" => 0 ":translation67d93f480a199fallbacks_articles_information_attributes" => "s_articles_information_attributes" ] |
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, translation67d93f480a2ebarticleimage.objectdata as __image_translation, translation67d93f480a2effallbackarticleimage.objectdata as __image_translation_fallback, translation67d93f480a2f1s_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f480a2f3fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f480a2ebarticleimage ON translation67d93f480a2ebarticleimage.objecttype = : translation67d93f480a2ebarticleimage AND translation67d93f480a2ebarticleimage.objectkey = image.id AND translation67d93f480a2ebarticleimage.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480a2effallbackarticleimage ON translation67d93f480a2effallbackarticleimage.objecttype = : translation67d93f480a2effallbackarticleimage AND translation67d93f480a2effallbackarticleimage.objectkey = image.id AND translation67d93f480a2effallbackarticleimage.objectlanguage = : languagefallback INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_core_translations translation67d93f480a2f1s_media_attributes ON translation67d93f480a2f1s_media_attributes.objecttype = : translation67d93f480a2f1s_media_attributes AND translation67d93f480a2f1s_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f480a2f1s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480a2f3fallbacks_media_attributes ON translation67d93f480a2f3fallbacks_media_attributes.objecttype = : translation67d93f480a2f3fallbacks_media_attributes AND translation67d93f480a2f3fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f480a2f3fallbacks_media_attributes.objectlanguage = : languagefallback WHERE childImage.article_detail_id IN (: products) ORDER BY image.main ASC, image.position ASC |
array:7 [ ":language" => 3 ":translation67d93f480a2ebarticleimage" => "articleimage" ":languagefallback" => 0 ":translation67d93f480a2effallbackarticleimage" => "articleimage" ":translation67d93f480a2f1s_media_attributes" => "s_media_attributes" ":translation67d93f480a2f3fallbacks_media_attributes" => "s_media_attributes" ":products" => array:1 [ 0 => 74 ] ] |
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, translation67d93f480a5b6articleimage.objectdata as __image_translation, translation67d93f480a5bafallbackarticleimage.objectdata as __image_translation_fallback, translation67d93f480a5bcs_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f480a5befallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f480a5b6articleimage ON translation67d93f480a5b6articleimage.objecttype = : translation67d93f480a5b6articleimage AND translation67d93f480a5b6articleimage.objectkey = image.id AND translation67d93f480a5b6articleimage.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480a5bafallbackarticleimage ON translation67d93f480a5bafallbackarticleimage.objecttype = : translation67d93f480a5bafallbackarticleimage AND translation67d93f480a5bafallbackarticleimage.objectkey = image.id AND translation67d93f480a5bafallbackarticleimage.objectlanguage = : languagefallback INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_core_translations translation67d93f480a5bcs_media_attributes ON translation67d93f480a5bcs_media_attributes.objecttype = : translation67d93f480a5bcs_media_attributes AND translation67d93f480a5bcs_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f480a5bcs_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480a5befallbacks_media_attributes ON translation67d93f480a5befallbacks_media_attributes.objecttype = : translation67d93f480a5befallbacks_media_attributes AND translation67d93f480a5befallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f480a5befallbacks_media_attributes.objectlanguage = : languagefallback 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:7 [ ":language" => 3 ":translation67d93f480a5b6articleimage" => "articleimage" ":languagefallback" => 0 ":translation67d93f480a5bafallbackarticleimage" => "articleimage" ":translation67d93f480a5bcs_media_attributes" => "s_media_attributes" ":translation67d93f480a5befallbacks_media_attributes" => "s_media_attributes" ":products" => array:1 [ 0 => 31 ] ] |
0.0005 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, translation67d93f480a8e2propertygroup.objectdata as __propertySet_translation, translation67d93f480a8e6fallbackpropertygroup.objectdata as __propertySet_translation_fallback, translation67d93f480a8e9propertyoption.objectdata as __propertyGroup_translation, translation67d93f480a8eafallbackpropertyoption.objectdata as __propertyGroup_translation_fallback, translation67d93f480a8ecpropertyvalue.objectdata as __propertyOption_translation, translation67d93f480a8eefallbackpropertyvalue.objectdata as __propertyOption_translation_fallback, translation67d93f480a8f0s_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f480a8f1fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f480a8e2propertygroup ON translation67d93f480a8e2propertygroup.objecttype = : translation67d93f480a8e2propertygroup AND translation67d93f480a8e2propertygroup.objectkey = propertySet.id AND translation67d93f480a8e2propertygroup.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480a8e6fallbackpropertygroup ON translation67d93f480a8e6fallbackpropertygroup.objecttype = : translation67d93f480a8e6fallbackpropertygroup AND translation67d93f480a8e6fallbackpropertygroup.objectkey = propertySet.id AND translation67d93f480a8e6fallbackpropertygroup.objectlanguage = : languagefallback 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_core_translations translation67d93f480a8ecpropertyvalue ON translation67d93f480a8ecpropertyvalue.objecttype = : translation67d93f480a8ecpropertyvalue AND translation67d93f480a8ecpropertyvalue.objectkey = propertyOption.id AND translation67d93f480a8ecpropertyvalue.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480a8eefallbackpropertyvalue ON translation67d93f480a8eefallbackpropertyvalue.objecttype = : translation67d93f480a8eefallbackpropertyvalue AND translation67d93f480a8eefallbackpropertyvalue.objectkey = propertyOption.id AND translation67d93f480a8eefallbackpropertyvalue.objectlanguage = : languagefallback LEFT JOIN s_filter_options_attributes propertyGroupAttribute ON propertyGroupAttribute.optionID = propertyGroup.id LEFT JOIN s_core_translations translation67d93f480a8e9propertyoption ON translation67d93f480a8e9propertyoption.objecttype = : translation67d93f480a8e9propertyoption AND translation67d93f480a8e9propertyoption.objectkey = propertyGroup.id AND translation67d93f480a8e9propertyoption.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480a8eafallbackpropertyoption ON translation67d93f480a8eafallbackpropertyoption.objecttype = : translation67d93f480a8eafallbackpropertyoption AND translation67d93f480a8eafallbackpropertyoption.objectkey = propertyGroup.id AND translation67d93f480a8eafallbackpropertyoption.objectlanguage = : languagefallback LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_core_translations translation67d93f480a8f0s_media_attributes ON translation67d93f480a8f0s_media_attributes.objecttype = : translation67d93f480a8f0s_media_attributes AND translation67d93f480a8f0s_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f480a8f0s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480a8f1fallbacks_media_attributes ON translation67d93f480a8f1fallbacks_media_attributes.objecttype = : translation67d93f480a8f1fallbacks_media_attributes AND translation67d93f480a8f1fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f480a8f1fallbacks_media_attributes.objectlanguage = : languagefallback WHERE products.id IN (: ids) ORDER BY filterArticles.articleID ASC |
array:11 [ ":ids" => array:1 [ 0 => 31 ] ":language" => 3 ":translation67d93f480a8e2propertygroup" => "propertygroup" ":languagefallback" => 0 ":translation67d93f480a8e6fallbackpropertygroup" => "propertygroup" ":translation67d93f480a8e9propertyoption" => "propertyoption" ":translation67d93f480a8eafallbackpropertyoption" => "propertyoption" ":translation67d93f480a8ecpropertyvalue" => "propertyvalue" ":translation67d93f480a8eefallbackpropertyvalue" => "propertyvalue" ":translation67d93f480a8f0s_media_attributes" => "s_media_attributes" ":translation67d93f480a8f1fallbacks_media_attributes" => "s_media_attributes" ] |
0.0012 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, translation67d93f480af0fconfiguratorgroup.objectdata as __configuratorGroup_translation, translation67d93f480af13fallbackconfiguratorgroup.objectdata as __configuratorGroup_translation_fallback, translation67d93f480af15configuratoroption.objectdata as __configuratorOption_translation, translation67d93f480af17fallbackconfiguratoroption.objectdata as __configuratorOption_translation_fallback 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_core_translations translation67d93f480af15configuratoroption ON translation67d93f480af15configuratoroption.objecttype = : translation67d93f480af15configuratoroption AND translation67d93f480af15configuratoroption.objectkey = configuratorOption.id AND translation67d93f480af15configuratoroption.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480af17fallbackconfiguratoroption ON translation67d93f480af17fallbackconfiguratoroption.objecttype = : translation67d93f480af17fallbackconfiguratoroption AND translation67d93f480af17fallbackconfiguratoroption.objectkey = configuratorOption.id AND translation67d93f480af17fallbackconfiguratoroption.objectlanguage = : languagefallback LEFT JOIN s_article_configurator_groups_attributes configuratorGroupAttribute ON configuratorGroupAttribute.groupID = configuratorGroup.id LEFT JOIN s_core_translations translation67d93f480af0fconfiguratorgroup ON translation67d93f480af0fconfiguratorgroup.objecttype = : translation67d93f480af0fconfiguratorgroup AND translation67d93f480af0fconfiguratorgroup.objectkey = configuratorGroup.id AND translation67d93f480af0fconfiguratorgroup.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480af13fallbackconfiguratorgroup ON translation67d93f480af13fallbackconfiguratorgroup.objecttype = : translation67d93f480af13fallbackconfiguratorgroup AND translation67d93f480af13fallbackconfiguratorgroup.objectkey = configuratorGroup.id AND translation67d93f480af13fallbackconfiguratorgroup.objectlanguage = : languagefallback WHERE relations.article_id IN (: ids) ORDER BY configuratorGroup.position ASC, configuratorGroup.id ASC |
array:7 [ ":ids" => array:1 [ 0 => 74 ] ":language" => 3 ":translation67d93f480af0fconfiguratorgroup" => "configuratorgroup" ":languagefallback" => 0 ":translation67d93f480af13fallbackconfiguratorgroup" => "configuratorgroup" ":translation67d93f480af15configuratoroption" => "configuratoroption" ":translation67d93f480af17fallbackconfiguratoroption" => "configuratoroption" ] |
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" => 3 ":orgPath" => array:1 [ 0 => "sViewport=detail&sArticle=31" ] ] |
0.0004 ms |
SELECT org_path, path FROM s_core_rewrite_urls WHERE subshopID =: shopId AND org_path IN (: orgPath) AND main = 1 ORDER BY id DESC |
array:2 [ ":shopId" => 3 ":orgPath" => array:1 [ 0 => "sViewport=forms&sFid=16" ] ] |
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 => 3 ] |
0.0000 ms |
SELECT `objectdata` FROM `s_core_translations` WHERE (`objecttype` = : type) AND (`objectkey` = : key) AND (`objectlanguage` = : language) |
array:3 [ ":type" => "category" ":key" => 3 ":language" => 3 ] |
0.0000 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 => 10 ] |
0.0000 ms |
SELECT `objectdata` FROM `s_core_translations` WHERE (`objecttype` = : type) AND (`objectkey` = : key) AND (`objectlanguage` = : language) |
array:3 [ ":type" => "category" ":key" => 10 ":language" => 3 ] |
0.0000 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 => 21 ] |
0.0000 ms |
SELECT `objectdata` FROM `s_core_translations` WHERE (`objecttype` = : type) AND (`objectkey` = : key) AND (`objectlanguage` = : language) |
array:3 [ ":type" => "category" ":key" => 21 ":language" => 3 ] |
0.0000 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 => 79 ] |
0.0000 ms |
SELECT `objectdata` FROM `s_core_translations` WHERE (`objecttype` = : type) AND (`objectkey` = : key) AND (`objectlanguage` = : language) |
array:3 [ ":type" => "category" ":key" => 79 ":language" => 3 ] |
0.0000 ms |
SELECT category.path FROM s_categories category WHERE category.id = : id |
array:1 [ ":id" => 79 ] |
0.0000 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.0000 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.0000 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:3 [ 0 => 24 1 => 23 2 => 22 ] ] |
0.0001 ms |
SELECT category.path FROM s_categories category WHERE category.id = : id |
array:1 [ ":id" => 79 ] |
0.0000 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:4 [ 0 => 79 2 => "21" 3 => "10" 4 => "3" ] ":shopId" => "%|3|%" ] |
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, 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, translation67d93f480db15s_categories_attributes.objectdata as __categoryAttribute_translation, translation67d93f480db19fallbacks_categories_attributes.objectdata as __categoryAttribute_translation_fallback, translation67d93f480db1bs_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f480db1dfallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback, translation67d93f480db1fproductStream.objectdata as __stream_translation, translation67d93f480db21fallbackproductStream.objectdata as __stream_translation_fallback, translation67d93f480db23category.objectdata as __category_translation, translation67d93f480db24fallbackcategory.objectdata as __category_translation_fallback FROM s_categories category LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id LEFT JOIN s_media media ON media.id = category.mediaID LEFT JOIN s_product_streams stream ON category.stream_id = stream.id LEFT JOIN s_core_translations translation67d93f480db23category ON translation67d93f480db23category.objecttype = : translation67d93f480db23category AND translation67d93f480db23category.objectkey = category.id AND translation67d93f480db23category.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480db24fallbackcategory ON translation67d93f480db24fallbackcategory.objecttype = : translation67d93f480db24fallbackcategory AND translation67d93f480db24fallbackcategory.objectkey = category.id AND translation67d93f480db24fallbackcategory.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f480db15s_categories_attributes ON translation67d93f480db15s_categories_attributes.objecttype = : translation67d93f480db15s_categories_attributes AND translation67d93f480db15s_categories_attributes.objectkey = category.id AND translation67d93f480db15s_categories_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480db19fallbacks_categories_attributes ON translation67d93f480db19fallbacks_categories_attributes.objecttype = : translation67d93f480db19fallbacks_categories_attributes AND translation67d93f480db19fallbacks_categories_attributes.objectkey = category.id AND translation67d93f480db19fallbacks_categories_attributes.objectlanguage = : languagefallback LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id LEFT JOIN s_core_translations translation67d93f480db1bs_media_attributes ON translation67d93f480db1bs_media_attributes.objecttype = : translation67d93f480db1bs_media_attributes AND translation67d93f480db1bs_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f480db1bs_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480db1dfallbacks_media_attributes ON translation67d93f480db1dfallbacks_media_attributes.objecttype = : translation67d93f480db1dfallbacks_media_attributes AND translation67d93f480db1dfallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f480db1dfallbacks_media_attributes.objectlanguage = : languagefallback LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId LEFT JOIN s_core_translations translation67d93f480db1fproductStream ON translation67d93f480db1fproductStream.objecttype = : translation67d93f480db1fproductStream AND translation67d93f480db1fproductStream.objectkey = stream.id AND translation67d93f480db1fproductStream.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480db21fallbackproductStream ON translation67d93f480db21fallbackproductStream.objecttype = : translation67d93f480db21fallbackproductStream AND translation67d93f480db21fallbackproductStream.objectkey = stream.id AND translation67d93f480db21fallbackproductStream.objectlanguage = : languagefallback WHERE ( category.id IN (: categories) ) AND (category.active = 1) AND ( category.shops IS NULL OR category.shops LIKE : shopId ) GROUP BY category.id |
array:12 [ ":categories" => array:22 [ 0 => 79 1 => "21" 2 => "10" 3 => "3" 4 => 18 5 => 19 6 => 20 7 => 21 8 => 76 9 => 77 10 => 78 11 => 79 12 => 80 13 => 3 14 => 5 15 => 7 16 => 8 17 => 9 18 => 10 19 => 11 20 => 81 21 => 12 ] ":shopId" => "%|3|%" ":language" => 3 ":translation67d93f480db15s_categories_attributes" => "s_categories_attributes" ":languagefallback" => 0 ":translation67d93f480db19fallbacks_categories_attributes" => "s_categories_attributes" ":translation67d93f480db1bs_media_attributes" => "s_media_attributes" ":translation67d93f480db1dfallbacks_media_attributes" => "s_media_attributes" ":translation67d93f480db1fproductStream" => "productStream" ":translation67d93f480db21fallbackproductStream" => "productStream" ":translation67d93f480db23category" => "category" ":translation67d93f480db24fallbackcategory" => "category" ] |
0.0010 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:22 [ 0 => 79 1 => "21" 2 => "10" 3 => "3" 4 => 18 5 => 19 6 => 20 7 => 21 8 => 76 9 => 77 10 => 78 11 => 79 12 => 80 13 => 3 14 => 5 15 => 7 16 => 8 17 => 9 18 => 10 19 => 11 20 => 81 21 => 12 ] ] |
0.0001 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, media.id as __media_id, media.albumID as __media_albumID, media.name as __media_name, media.description as __media_description, media.path as __media_path, media.type as __media_type, media.extension as __media_extension, media.file_size as __media_file_size, media.width as __media_width, media.height as __media_height, media.userID as __media_userID, media.created as __media_created, mediaSettings.id as __mediaSettings_id, mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, mediaSettings.icon as __mediaSettings_icon, mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, mediaAttribute.id as __mediaAttribute_id, mediaAttribute.mediaID as __mediaAttribute_mediaID FROM s_core_shops shop LEFT JOIN s_core_shops_attributes shopAttribute ON shopAttribute.shopID = shop.id LEFT JOIN s_core_currencies currency ON currency.id = shop.currency_id LEFT JOIN s_core_templates template ON shop.template_id = template.id LEFT JOIN s_core_locales locale ON locale.id = shop.locale_id LEFT JOIN s_core_customergroups customerGroup ON customerGroup.id = shop.customer_group_id LEFT JOIN s_categories category ON category.id = shop.category_id LEFT JOIN s_core_customergroups_attributes customerGroupAttribute ON customerGroupAttribute.customerGroupID = customerGroup.id LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id LEFT JOIN s_media media ON media.id = category.mediaID LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id WHERE shop.id IN (: ids) |
array:1 [ ":ids" => array:1 [ 0 => 3 ] ] |
0.0001 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, 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.0001 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.0001 ms |
SELECT tax.id as __tax_id, tax.tax as __tax_tax, tax.description as __tax_description FROM s_core_tax tax |
[] |
0.0000 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 |
array:5 [ ":area" => null ":country" => null ":state" => null ":customerGroup" => 1 ":taxId" => "1" ] |
0.0000 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 |
array:5 [ ":area" => null ":country" => null ":state" => null ":customerGroup" => 1 ":taxId" => "4" ] |
0.0000 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.0000 ms |
SELECT page.id, page.description, page.link, page.target, page.parentID, groups.key as `group`, mapping.key as mapping, translation67d93f480e4a3page.objectdata as __page_translation, translation67d93f480e4a7fallbackpage.objectdata as __page_translation_fallback FROM s_cms_static page LEFT JOIN s_cms_static_groups `groups` ON groups.active = 1 LEFT JOIN s_core_translations translation67d93f480e4a3page ON translation67d93f480e4a3page.objecttype = : translation67d93f480e4a3page AND translation67d93f480e4a3page.objectkey = page.id AND translation67d93f480e4a3page.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f480e4a7fallbackpage ON translation67d93f480e4a7fallbackpage.objecttype = : translation67d93f480e4a7fallbackpage AND translation67d93f480e4a7fallbackpage.objectkey = page.id AND translation67d93f480e4a7fallbackpage.objectlanguage = : languagefallback 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:6 [ ":language" => 3 ":translation67d93f480e4a3page" => "page" ":languagefallback" => 0 ":translation67d93f480e4a7fallbackpage" => "page" ":shopId" => 3 ":staticShopId" => "%|3|%" ] |
0.0007 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" => 3 ":orgPath" => array:13 [ 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" 45 => "sViewport=custom&sCustom=45" 4 => "sViewport=custom&sCustom=4" ] ] |
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" => 3 ":orgPath" => array:1 [ 0 => "sViewport=detail&sArticle=31" ] ] |
0.0000 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" => 3 ":orgPath" => array:1 [ 0 => "sViewport=detail&sArticle=31" ] ] |
0.0000 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" => 3 ":orgPath" => array:1 [ 0 => "sViewport=detail&sArticle=31" ] ] |
0.0000 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.0001 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 |
[] |
0.0000 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.namespace AS namespace_4, t0.source AS source_5, t0.description AS description_6, t0.active AS active_7, t0.added AS added_8, t0.installation_date AS installation_date_9, t0.update_date AS update_date_10, t0.refresh_date AS refresh_date_11, t0.author AS author_12, t0.copyright AS copyright_13, t0.license AS license_14, t0.version AS version_15, t0.support AS support_16, t0.changes AS changes_17, t0.link AS link_18, t0.update_version AS update_version_19, t0.update_source AS update_source_20, t0.capability_update AS capability_update_21, t0.capability_install AS capability_install_22, t0.capability_enable AS capability_enable_23, t0.capability_secure_uninstall AS capability_secure_uninstall_24, t0.translations AS translations_25, t0.in_safe_mode AS in_safe_mode_26 FROM s_core_plugins t0 WHERE t0.id = ? LIMIT 1 |
array:1 [ 0 => "52" ] |
0.0001 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.0001 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.0001 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.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" => 3 ":orgPath" => array:1 [ 0 => "sViewport=address&sAction=index" ] ] |
0.0001 ms |
SELECT host, hosts FROM s_core_shops WHERE id = : id |
array:1 [ ":id" => 1 ] |
0.0001 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.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" => 3 ":orgPath" => array:1 [ 0 => "sViewport=listing&sAction=manufacturer&sSupplier=2" ] ] |
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" => 3 ":orgPath" => array:1 [ 0 => "sViewport=detail&sArticle=31" ] ] |
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" => 3 ":orgPath" => array:1 [ 0 => "sViewport=compare&sAction=add_article" ] ] |
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" => 3 ":orgPath" => array:1 [ 0 => "sViewport=note&sAction=add" ] ] |
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" => 3 ":orgPath" => array:1 [ 0 => "sViewport=note&sAction=ajaxAdd" ] ] |
0.0000 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" => 3 ":orgPath" => array:1 [ 0 => "sViewport=listing&sAction=manufacturer&sSupplier=2" ] ] |
0.0000 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" => 3 ":orgPath" => array:1 [ 0 => "sViewport=detail&sArticle=31" ] ] |
0.0000 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.0001 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, 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) ) as __product_fallback_price_count, manufacturerMedia.id as __manufacturer_img_id, translation67d93f4813572article.objectdata as __product_translation, translation67d93f4813575fallbackarticle.objectdata as __product_translation_fallback, translation67d93f4813578variant.objectdata as __variant_translation, translation67d93f4813579fallbackvariant.objectdata as __variant_translation_fallback, translation67d93f481357bsupplier.objectdata as __manufacturer_translation, translation67d93f481357dfallbacksupplier.objectdata as __manufacturer_translation_fallback, translation67d93f481357fconfig_units.objectdata as __unit_translation, translation67d93f4813580fallbackconfig_units.objectdata as __unit_translation_fallback, translation67d93f4813582s_articles_esd_attributes.objectdata as __esdAttribute_translation, translation67d93f4813583fallbacks_articles_esd_attributes.objectdata as __esdAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f4813578variant ON translation67d93f4813578variant.objecttype = : translation67d93f4813578variant AND translation67d93f4813578variant.objectkey = variant.id AND translation67d93f4813578variant.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4813579fallbackvariant ON translation67d93f4813579fallbackvariant.objecttype = : translation67d93f4813579fallbackvariant AND translation67d93f4813579fallbackvariant.objectkey = variant.id AND translation67d93f4813579fallbackvariant.objectlanguage = : languagefallback 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_core_translations translation67d93f4813572article ON translation67d93f4813572article.objecttype = : translation67d93f4813572article AND translation67d93f4813572article.objectkey = product.id AND translation67d93f4813572article.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4813575fallbackarticle ON translation67d93f4813575fallbackarticle.objecttype = : translation67d93f4813575fallbackarticle AND translation67d93f4813575fallbackarticle.objectkey = product.id AND translation67d93f4813575fallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img LEFT JOIN s_core_translations translation67d93f481357bsupplier ON translation67d93f481357bsupplier.objecttype = : translation67d93f481357bsupplier AND translation67d93f481357bsupplier.objectkey = manufacturer.id AND translation67d93f481357bsupplier.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f481357dfallbacksupplier ON translation67d93f481357dfallbacksupplier.objecttype = : translation67d93f481357dfallbacksupplier AND translation67d93f481357dfallbacksupplier.objectkey = manufacturer.id AND translation67d93f481357dfallbacksupplier.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f481357fconfig_units ON translation67d93f481357fconfig_units.objecttype = : translation67d93f481357fconfig_units AND translation67d93f481357fconfig_units.objectkey = 1 AND translation67d93f481357fconfig_units.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4813580fallbackconfig_units ON translation67d93f4813580fallbackconfig_units.objecttype = : translation67d93f4813580fallbackconfig_units AND translation67d93f4813580fallbackconfig_units.objectkey = 1 AND translation67d93f4813580fallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id LEFT JOIN s_core_translations translation67d93f4813582s_articles_esd_attributes ON translation67d93f4813582s_articles_esd_attributes.objecttype = : translation67d93f4813582s_articles_esd_attributes AND translation67d93f4813582s_articles_esd_attributes.objectkey = esd.id AND translation67d93f4813582s_articles_esd_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4813583fallbacks_articles_esd_attributes ON translation67d93f4813583fallbacks_articles_esd_attributes.objecttype = : translation67d93f4813583fallbacks_articles_esd_attributes AND translation67d93f4813583fallbacks_articles_esd_attributes.objectkey = esd.id AND translation67d93f4813583fallbacks_articles_esd_attributes.objectlanguage = : languagefallback WHERE ( variant.ordernumber IN (: numbers) ) AND (variant.active = 1) AND (product.active = 1) |
array:14 [ ":fallback" => "EK" ":numbers" => array:18 [ 0 => 10030 1 => 10029 2 => 10028 3 => 10027 4 => 10026 5 => 10025 6 => 10024 7 => 10023 8 => 10022 9 => 10021 10 => 10020 11 => 10014 12 => 10013 13 => 10012 14 => 10009 15 => 10005 16 => 10003 17 => 10002 ] ":language" => 3 ":translation67d93f4813572article" => "article" ":languagefallback" => 0 ":translation67d93f4813575fallbackarticle" => "article" ":translation67d93f4813578variant" => "variant" ":translation67d93f4813579fallbackvariant" => "variant" ":translation67d93f481357bsupplier" => "supplier" ":translation67d93f481357dfallbacksupplier" => "supplier" ":translation67d93f481357fconfig_units" => "config_units" ":translation67d93f4813580fallbackconfig_units" => "config_units" ":translation67d93f4813582s_articles_esd_attributes" => "s_articles_esd_attributes" ":translation67d93f4813583fallbacks_articles_esd_attributes" => "s_articles_esd_attributes" ] |
0.0057 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, translation67d93f4814e21articleimage.objectdata as __image_translation, translation67d93f4814e25fallbackarticleimage.objectdata as __image_translation_fallback, translation67d93f4814e27s_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f4814e29fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f4814e21articleimage ON translation67d93f4814e21articleimage.objecttype = : translation67d93f4814e21articleimage AND translation67d93f4814e21articleimage.objectkey = image.id AND translation67d93f4814e21articleimage.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4814e25fallbackarticleimage ON translation67d93f4814e25fallbackarticleimage.objecttype = : translation67d93f4814e25fallbackarticleimage AND translation67d93f4814e25fallbackarticleimage.objectkey = image.id AND translation67d93f4814e25fallbackarticleimage.objectlanguage = : languagefallback INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_core_translations translation67d93f4814e27s_media_attributes ON translation67d93f4814e27s_media_attributes.objecttype = : translation67d93f4814e27s_media_attributes AND translation67d93f4814e27s_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4814e27s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4814e29fallbacks_media_attributes ON translation67d93f4814e29fallbacks_media_attributes.objecttype = : translation67d93f4814e29fallbacks_media_attributes AND translation67d93f4814e29fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f4814e29fallbacks_media_attributes.objectlanguage = : languagefallback WHERE childImage.article_detail_id IN (: products) ORDER BY image.main ASC, image.position ASC |
array:7 [ ":language" => 3 ":translation67d93f4814e21articleimage" => "articleimage" ":languagefallback" => 0 ":translation67d93f4814e25fallbackarticleimage" => "articleimage" ":translation67d93f4814e27s_media_attributes" => "s_media_attributes" ":translation67d93f4814e29fallbacks_media_attributes" => "s_media_attributes" ":products" => array:18 [ 0 => 13 1 => 14 2 => 19 3 => 26 4 => 31 5 => 34 6 => 43 7 => 49 8 => 50 9 => 51 10 => 52 11 => 53 12 => 62 13 => 65 14 => 66 15 => 67 16 => 72 17 => 73 ] ] |
0.0008 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, translation67d93f4815205articleimage.objectdata as __image_translation, translation67d93f4815209fallbackarticleimage.objectdata as __image_translation_fallback, translation67d93f481520cs_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f481520efallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f4815205articleimage ON translation67d93f4815205articleimage.objecttype = : translation67d93f4815205articleimage AND translation67d93f4815205articleimage.objectkey = image.id AND translation67d93f4815205articleimage.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4815209fallbackarticleimage ON translation67d93f4815209fallbackarticleimage.objecttype = : translation67d93f4815209fallbackarticleimage AND translation67d93f4815209fallbackarticleimage.objectkey = image.id AND translation67d93f4815209fallbackarticleimage.objectlanguage = : languagefallback INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_core_translations translation67d93f481520cs_media_attributes ON translation67d93f481520cs_media_attributes.objecttype = : translation67d93f481520cs_media_attributes AND translation67d93f481520cs_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f481520cs_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f481520efallbacks_media_attributes ON translation67d93f481520efallbacks_media_attributes.objecttype = : translation67d93f481520efallbacks_media_attributes AND translation67d93f481520efallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f481520efallbacks_media_attributes.objectlanguage = : languagefallback WHERE (image.main = 1) AND ( image.articleID IN (: products) ) |
array:7 [ ":language" => 3 ":translation67d93f4815205articleimage" => "articleimage" ":languagefallback" => 0 ":translation67d93f4815209fallbackarticleimage" => "articleimage" ":translation67d93f481520cs_media_attributes" => "s_media_attributes" ":translation67d93f481520efallbacks_media_attributes" => "s_media_attributes" ":products" => array:18 [ 0 => 2 1 => 3 2 => 5 3 => 9 4 => 12 5 => 13 6 => 14 7 => 20 8 => 21 9 => 22 10 => 23 11 => 24 12 => 25 13 => 26 14 => 27 15 => 28 16 => 29 17 => 30 ] ] |
0.0008 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, translation67d93f4815814s_articles_prices_attributes.objectdata as __priceAttribute_translation, translation67d93f4815818fallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f4815814s_articles_prices_attributes ON translation67d93f4815814s_articles_prices_attributes.objecttype = : translation67d93f4815814s_articles_prices_attributes AND translation67d93f4815814s_articles_prices_attributes.objectkey = price.id AND translation67d93f4815814s_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4815818fallbacks_articles_prices_attributes ON translation67d93f4815818fallbacks_articles_prices_attributes.objecttype = : translation67d93f4815818fallbacks_articles_prices_attributes AND translation67d93f4815818fallbacks_articles_prices_attributes.objectkey = price.id AND translation67d93f4815818fallbacks_articles_prices_attributes.objectlanguage = : languagefallback 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:6 [ ":products" => array:18 [ 0 => 13 1 => 14 2 => 19 3 => 26 4 => 31 5 => 34 6 => 43 7 => 49 8 => 50 9 => 51 10 => 52 11 => 53 12 => 62 13 => 65 14 => 66 15 => 67 16 => 72 17 => 73 ] ":customerGroup" => "EK" ":language" => 3 ":translation67d93f4815814s_articles_prices_attributes" => "s_articles_prices_attributes" ":languagefallback" => 0 ":translation67d93f4815818fallbacks_articles_prices_attributes" => "s_articles_prices_attributes" ] |
0.0006 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:18 [ 0 => 2 1 => 3 2 => 5 3 => 9 4 => 12 5 => 13 6 => 14 7 => 20 8 => 21 9 => 22 10 => 23 11 => 24 12 => 25 13 => 26 14 => 27 15 => 28 16 => 29 17 => 30 ] ":priceGroupCustomerGroup" => 1 ] |
0.0006 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, translation67d93f4815d79config_units.objectdata as __unit_translation, translation67d93f4815d7dfallbackconfig_units.objectdata as __unit_translation_fallback, translation67d93f4815d80article.objectdata as __product_translation, translation67d93f4815d81fallbackarticle.objectdata as __product_translation_fallback, translation67d93f4815d83variant.objectdata as __variant_translation, translation67d93f4815d84fallbackvariant.objectdata as __variant_translation_fallback, translation67d93f4815d86s_articles_prices_attributes.objectdata as __priceAttribute_translation, translation67d93f4815d87fallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f4815d83variant ON translation67d93f4815d83variant.objecttype = : translation67d93f4815d83variant AND translation67d93f4815d83variant.objectkey = variant.id AND translation67d93f4815d83variant.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4815d84fallbackvariant ON translation67d93f4815d84fallbackvariant.objecttype = : translation67d93f4815d84fallbackvariant AND translation67d93f4815d84fallbackvariant.objectkey = variant.id AND translation67d93f4815d84fallbackvariant.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f4815d80article ON translation67d93f4815d80article.objecttype = : translation67d93f4815d80article AND translation67d93f4815d80article.objectkey = product.id AND translation67d93f4815d80article.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4815d81fallbackarticle ON translation67d93f4815d81fallbackarticle.objecttype = : translation67d93f4815d81fallbackarticle AND translation67d93f4815d81fallbackarticle.objectkey = product.id AND translation67d93f4815d81fallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f4815d79config_units ON translation67d93f4815d79config_units.objecttype = : translation67d93f4815d79config_units AND translation67d93f4815d79config_units.objectkey = 1 AND translation67d93f4815d79config_units.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4815d7dfallbackconfig_units ON translation67d93f4815d7dfallbackconfig_units.objecttype = : translation67d93f4815d7dfallbackconfig_units AND translation67d93f4815d7dfallbackconfig_units.objectkey = 1 AND translation67d93f4815d7dfallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f4815d86s_articles_prices_attributes ON translation67d93f4815d86s_articles_prices_attributes.objecttype = : translation67d93f4815d86s_articles_prices_attributes AND translation67d93f4815d86s_articles_prices_attributes.objectkey = price.id AND translation67d93f4815d86s_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4815d87fallbacks_articles_prices_attributes ON translation67d93f4815d87fallbacks_articles_prices_attributes.objecttype = : translation67d93f4815d87fallbacks_articles_prices_attributes AND translation67d93f4815d87fallbacks_articles_prices_attributes.objectkey = price.id AND translation67d93f4815d87fallbacks_articles_prices_attributes.objectlanguage = : languagefallback WHERE price.id IN (: ids) |
array:11 [ ":ids" => array:17 [ 0 => "14" 1 => "16" 2 => "37" 3 => "54" 4 => "69" 5 => "101" 6 => "107" 7 => "108" 8 => "112" 9 => "113" 10 => "125" 11 => "129" 12 => "132" 13 => "133" 14 => "138" 15 => "158" 16 => "159" ] ":language" => 3 ":translation67d93f4815d79config_units" => "config_units" ":languagefallback" => 0 ":translation67d93f4815d7dfallbackconfig_units" => "config_units" ":translation67d93f4815d80article" => "article" ":translation67d93f4815d81fallbackarticle" => "article" ":translation67d93f4815d83variant" => "variant" ":translation67d93f4815d84fallbackvariant" => "variant" ":translation67d93f4815d86s_articles_prices_attributes" => "s_articles_prices_attributes" ":translation67d93f4815d87fallbacks_articles_prices_attributes" => "s_articles_prices_attributes" ] |
0.0007 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 => 5 ] ":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, translation67d93f4816246config_units.objectdata as __unit_translation, translation67d93f481624afallbackconfig_units.objectdata as __unit_translation_fallback, translation67d93f481624carticle.objectdata as __product_translation, translation67d93f481624efallbackarticle.objectdata as __product_translation_fallback, translation67d93f4816250variant.objectdata as __variant_translation, translation67d93f4816251fallbackvariant.objectdata as __variant_translation_fallback, translation67d93f4816253s_articles_prices_attributes.objectdata as __priceAttribute_translation, translation67d93f4816254fallbacks_articles_prices_attributes.objectdata as __priceAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f4816250variant ON translation67d93f4816250variant.objecttype = : translation67d93f4816250variant AND translation67d93f4816250variant.objectkey = variant.id AND translation67d93f4816250variant.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4816251fallbackvariant ON translation67d93f4816251fallbackvariant.objecttype = : translation67d93f4816251fallbackvariant AND translation67d93f4816251fallbackvariant.objectkey = variant.id AND translation67d93f4816251fallbackvariant.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f481624carticle ON translation67d93f481624carticle.objecttype = : translation67d93f481624carticle AND translation67d93f481624carticle.objectkey = product.id AND translation67d93f481624carticle.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f481624efallbackarticle ON translation67d93f481624efallbackarticle.objecttype = : translation67d93f481624efallbackarticle AND translation67d93f481624efallbackarticle.objectkey = product.id AND translation67d93f481624efallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f4816246config_units ON translation67d93f4816246config_units.objecttype = : translation67d93f4816246config_units AND translation67d93f4816246config_units.objectkey = 1 AND translation67d93f4816246config_units.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f481624afallbackconfig_units ON translation67d93f481624afallbackconfig_units.objecttype = : translation67d93f481624afallbackconfig_units AND translation67d93f481624afallbackconfig_units.objectkey = 1 AND translation67d93f481624afallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f4816253s_articles_prices_attributes ON translation67d93f4816253s_articles_prices_attributes.objecttype = : translation67d93f4816253s_articles_prices_attributes AND translation67d93f4816253s_articles_prices_attributes.objectkey = price.id AND translation67d93f4816253s_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f4816254fallbacks_articles_prices_attributes ON translation67d93f4816254fallbacks_articles_prices_attributes.objecttype = : translation67d93f4816254fallbacks_articles_prices_attributes AND translation67d93f4816254fallbacks_articles_prices_attributes.objectkey = price.id AND translation67d93f4816254fallbacks_articles_prices_attributes.objectlanguage = : languagefallback WHERE price.id IN (: ids) |
array:11 [ ":ids" => [] ":language" => 3 ":translation67d93f4816246config_units" => "config_units" ":languagefallback" => 0 ":translation67d93f481624afallbackconfig_units" => "config_units" ":translation67d93f481624carticle" => "article" ":translation67d93f481624efallbackarticle" => "article" ":translation67d93f4816250variant" => "variant" ":translation67d93f4816251fallbackvariant" => "variant" ":translation67d93f4816253s_articles_prices_attributes" => "s_articles_prices_attributes" ":translation67d93f4816254fallbacks_articles_prices_attributes" => "s_articles_prices_attributes" ] |
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:18 [ 0 => 2 1 => 3 2 => 5 3 => 9 4 => 12 5 => 13 6 => 14 7 => 20 8 => 21 9 => 22 10 => 23 11 => 24 12 => 25 13 => 26 14 => 27 15 => 28 16 => 29 17 => 30 ] ] |
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:18 [ 0 => 2 1 => 3 2 => 5 3 => 9 4 => 12 5 => 13 6 => 14 7 => 20 8 => 21 9 => 22 10 => 23 11 => 24 12 => 25 13 => 26 14 => 27 15 => 28 16 => 29 17 => 30 ] ] |
0.0007 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, 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, translation67d93f48168ads_categories_attributes.objectdata as __categoryAttribute_translation, translation67d93f48168b1fallbacks_categories_attributes.objectdata as __categoryAttribute_translation_fallback, translation67d93f48168b4s_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f48168b5fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback, translation67d93f48168b7productStream.objectdata as __stream_translation, translation67d93f48168b9fallbackproductStream.objectdata as __stream_translation_fallback, translation67d93f48168bbcategory.objectdata as __category_translation, translation67d93f48168bcfallbackcategory.objectdata as __category_translation_fallback FROM s_categories category LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id LEFT JOIN s_media media ON media.id = category.mediaID LEFT JOIN s_product_streams stream ON category.stream_id = stream.id LEFT JOIN s_core_translations translation67d93f48168bbcategory ON translation67d93f48168bbcategory.objecttype = : translation67d93f48168bbcategory AND translation67d93f48168bbcategory.objectkey = category.id AND translation67d93f48168bbcategory.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48168bcfallbackcategory ON translation67d93f48168bcfallbackcategory.objecttype = : translation67d93f48168bcfallbackcategory AND translation67d93f48168bcfallbackcategory.objectkey = category.id AND translation67d93f48168bcfallbackcategory.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d93f48168ads_categories_attributes ON translation67d93f48168ads_categories_attributes.objecttype = : translation67d93f48168ads_categories_attributes AND translation67d93f48168ads_categories_attributes.objectkey = category.id AND translation67d93f48168ads_categories_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48168b1fallbacks_categories_attributes ON translation67d93f48168b1fallbacks_categories_attributes.objecttype = : translation67d93f48168b1fallbacks_categories_attributes AND translation67d93f48168b1fallbacks_categories_attributes.objectkey = category.id AND translation67d93f48168b1fallbacks_categories_attributes.objectlanguage = : languagefallback LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id LEFT JOIN s_core_translations translation67d93f48168b4s_media_attributes ON translation67d93f48168b4s_media_attributes.objecttype = : translation67d93f48168b4s_media_attributes AND translation67d93f48168b4s_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f48168b4s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48168b5fallbacks_media_attributes ON translation67d93f48168b5fallbacks_media_attributes.objecttype = : translation67d93f48168b5fallbacks_media_attributes AND translation67d93f48168b5fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f48168b5fallbacks_media_attributes.objectlanguage = : languagefallback LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId LEFT JOIN s_core_translations translation67d93f48168b7productStream ON translation67d93f48168b7productStream.objecttype = : translation67d93f48168b7productStream AND translation67d93f48168b7productStream.objectkey = stream.id AND translation67d93f48168b7productStream.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f48168b9fallbackproductStream ON translation67d93f48168b9fallbackproductStream.objecttype = : translation67d93f48168b9fallbackproductStream AND translation67d93f48168b9fallbackproductStream.objectkey = stream.id AND translation67d93f48168b9fallbackproductStream.objectlanguage = : languagefallback WHERE ( category.id IN (: categories) ) AND (category.active = 1) AND ( category.shops IS NULL OR category.shops LIKE : shopId ) GROUP BY category.id |
array:12 [ ":categories" => array:59 [ 0 => "3" 1 => "5" 2 => "7" 3 => "8" 4 => "13" 5 => "14" 6 => "25" 7 => "26" 8 => "27" 9 => "28" 10 => "29" 11 => "30" 12 => "31" 13 => "32" 14 => "33" 15 => "34" 67 => "9" 68 => "15" 69 => "16" 70 => "17" 71 => "35" 72 => "36" 73 => "37" 74 => "38" 75 => "39" 76 => "40" 77 => "41" 78 => "42" 79 => "43" 80 => "44" 81 => "45" 82 => "46" 83 => "47" 84 => "48" 85 => "49" 177 => "10" 178 => "18" 179 => "19" 180 => "20" 181 => "21" 182 => "50" 183 => "51" 184 => "52" 185 => "53" 186 => "54" 187 => "55" 188 => "56" 189 => "57" 190 => "58" 191 => "59" 192 => "60" 193 => "61" 194 => "62" 195 => "63" 196 => "76" 197 => "77" 198 => "78" 199 => "79" 200 => "80" ] ":shopId" => "%|3|%" ":language" => 3 ":translation67d93f48168ads_categories_attributes" => "s_categories_attributes" ":languagefallback" => 0 ":translation67d93f48168b1fallbacks_categories_attributes" => "s_categories_attributes" ":translation67d93f48168b4s_media_attributes" => "s_media_attributes" ":translation67d93f48168b5fallbacks_media_attributes" => "s_media_attributes" ":translation67d93f48168b7productStream" => "productStream" ":translation67d93f48168b9fallbackproductStream" => "productStream" ":translation67d93f48168bbcategory" => "category" ":translation67d93f48168bcfallbackcategory" => "category" ] |
0.0015 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, translation67d93f481703bs_media_attributes.objectdata as __mediaAttribute_translation, translation67d93f481703ffallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback 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 LEFT JOIN s_core_translations translation67d93f481703bs_media_attributes ON translation67d93f481703bs_media_attributes.objecttype = : translation67d93f481703bs_media_attributes AND translation67d93f481703bs_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f481703bs_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d93f481703ffallbacks_media_attributes ON translation67d93f481703ffallbacks_media_attributes.objecttype = : translation67d93f481703ffallbacks_media_attributes AND translation67d93f481703ffallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d93f481703ffallbacks_media_attributes.objectlanguage = : languagefallback WHERE media.id IN (: ids) |
array:5 [ ":language" => 3 ":translation67d93f481703bs_media_attributes" => "s_media_attributes" ":languagefallback" => 0 ":translation67d93f481703ffallbacks_media_attributes" => "s_media_attributes" ":ids" => array:11 [ 10002 => 2 10003 => 2 10005 => 2 10009 => 2 10012 => 2 10013 => 2 10014 => 2 10021 => 2 10022 => 2 10028 => 2 10030 => 2 ] ] |
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 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" => 3 ":orgPath" => array:36 [ 0 => "sViewport=detail&sArticle=30" 1 => "sViewport=detail&sArticle=30" 2 => "sViewport=detail&sArticle=29" 3 => "sViewport=detail&sArticle=29" 4 => "sViewport=detail&sArticle=28" 5 => "sViewport=detail&sArticle=28" 6 => "sViewport=detail&sArticle=27" 7 => "sViewport=detail&sArticle=27" 8 => "sViewport=detail&sArticle=26" 9 => "sViewport=detail&sArticle=26" 10 => "sViewport=detail&sArticle=25" 11 => "sViewport=detail&sArticle=25" 12 => "sViewport=detail&sArticle=24" 13 => "sViewport=detail&sArticle=24" 14 => "sViewport=detail&sArticle=23" 15 => "sViewport=detail&sArticle=23" 16 => "sViewport=detail&sArticle=22" 17 => "sViewport=detail&sArticle=22" 18 => "sViewport=detail&sArticle=21" 19 => "sViewport=detail&sArticle=21" 20 => "sViewport=detail&sArticle=20" 21 => "sViewport=detail&sArticle=20" 22 => "sViewport=detail&sArticle=14" 23 => "sViewport=detail&sArticle=14" 24 => "sViewport=detail&sArticle=13" 25 => "sViewport=detail&sArticle=13" 26 => "sViewport=detail&sArticle=12" 27 => "sViewport=detail&sArticle=12" 28 => "sViewport=detail&sArticle=9" 29 => "sViewport=detail&sArticle=9" 30 => "sViewport=detail&sArticle=5" 31 => "sViewport=detail&sArticle=5" 32 => "sViewport=detail&sArticle=3" 33 => "sViewport=detail&sArticle=3" 34 => "sViewport=detail&sArticle=2" 35 => "sViewport=detail&sArticle=2" ] ] |
0.0006 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.0001 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 |
[] |
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" => 3 ":orgPath" => array:114 [ 0 => "sViewport=cat&sCategory=5" 1 => "sViewport=cat&sCategory=7" 2 => "sViewport=cat&sCategory=8" 3 => "sViewport=cat&sCategory=9" 4 => "sViewport=cat&sCategory=10" 5 => "sViewport=cat&sCategory=11" 6 => "sViewport=blog&sCategory=81" 7 => "sViewport=cat&sCategory=12" 8 => "sViewport=cat&sCategory=5" 9 => "sViewport=cat&sCategory=7" 10 => "sViewport=cat&sCategory=8" 11 => "sViewport=cat&sCategory=13" 12 => "sViewport=cat&sCategory=25" 13 => "sViewport=cat&sCategory=26" 14 => "sViewport=cat&sCategory=27" 15 => "sViewport=cat&sCategory=28" 16 => "sViewport=cat&sCategory=29" 17 => "sViewport=cat&sCategory=14" 18 => "sViewport=cat&sCategory=30" 19 => "sViewport=cat&sCategory=31" 20 => "sViewport=cat&sCategory=32" 21 => "sViewport=cat&sCategory=33" 22 => "sViewport=cat&sCategory=34" 23 => "sViewport=cat&sCategory=9" 24 => "sViewport=cat&sCategory=15" 25 => "sViewport=cat&sCategory=35" 26 => "sViewport=cat&sCategory=36" 27 => "sViewport=cat&sCategory=37" 28 => "sViewport=cat&sCategory=38" 29 => "sViewport=cat&sCategory=39" 30 => "sViewport=cat&sCategory=16" 31 => "sViewport=cat&sCategory=40" 32 => "sViewport=cat&sCategory=41" 33 => "sViewport=cat&sCategory=42" 34 => "sViewport=cat&sCategory=43" 35 => "sViewport=cat&sCategory=44" 36 => "sViewport=cat&sCategory=17" 37 => "sViewport=cat&sCategory=45" 38 => "sViewport=cat&sCategory=46" 39 => "sViewport=cat&sCategory=47" 40 => "sViewport=cat&sCategory=48" 41 => "sViewport=cat&sCategory=49" 42 => "sViewport=cat&sCategory=10" 43 => "sViewport=cat&sCategory=18" 44 => "sViewport=cat&sCategory=50" 45 => "sViewport=cat&sCategory=51" 46 => "sViewport=cat&sCategory=52" 47 => "sViewport=cat&sCategory=53" 48 => "sViewport=cat&sCategory=54" 49 => "sViewport=cat&sCategory=19" 50 => "sViewport=cat&sCategory=55" 51 => "sViewport=cat&sCategory=56" 52 => "sViewport=cat&sCategory=57" 53 => "sViewport=cat&sCategory=58" 54 => "sViewport=cat&sCategory=59" 55 => "sViewport=cat&sCategory=20" 56 => "sViewport=cat&sCategory=60" 57 => "sViewport=cat&sCategory=61" 58 => "sViewport=cat&sCategory=62" 59 => "sViewport=cat&sCategory=63" 60 => "sViewport=cat&sCategory=21" 61 => "sViewport=cat&sCategory=76" 62 => "sViewport=cat&sCategory=77" 63 => "sViewport=cat&sCategory=78" 64 => "sViewport=cat&sCategory=79" 65 => "sViewport=cat&sCategory=80" 66 => "sViewport=cat&sCategory=11" 67 => "sViewport=blog&sCategory=81" 68 => "sViewport=cat&sCategory=12" 69 => "sViewport=cat&sCategory=22" 70 => "sViewport=cat&sCategory=23" 71 => "sViewport=cat&sCategory=24" 72 => "sViewport=cat&sCategory=79" 73 => "sViewport=cat&sCategory=10" 74 => "sViewport=cat&sCategory=10" 75 => "sViewport=cat&sCategory=21" 76 => "sViewport=cat&sCategory=21" 77 => "sViewport=cat&sCategory=79" 78 => "sViewport=cat&sCategory=79" 79 => "sViewport=cat&sCategory=5" 80 => "sViewport=cat&sCategory=7" 81 => "sViewport=cat&sCategory=8" 82 => "sViewport=cat&sCategory=9" 83 => "sViewport=cat&sCategory=10" 84 => "sViewport=cat&sCategory=18" 85 => "sViewport=cat&sCategory=19" 86 => "sViewport=cat&sCategory=20" 87 => "sViewport=cat&sCategory=21" 88 => "sViewport=cat&sCategory=76" 89 => "sViewport=cat&sCategory=77" 90 => "sViewport=cat&sCategory=78" 91 => "sViewport=cat&sCategory=79" 92 => "sViewport=cat&sCategory=80" 93 => "sViewport=cat&sCategory=11" 94 => "sViewport=blog&sCategory=81" 95 => "sViewport=cat&sCategory=12" 96 => "sViewport=detail&sArticle=22" 97 => "sViewport=detail&sArticle=22" 98 => "sViewport=detail&sArticle=23" 99 => "sViewport=detail&sArticle=23" 100 => "sViewport=detail&sArticle=24" 101 => "sViewport=detail&sArticle=24" 102 => "sViewport=detail&sArticle=11" 103 => "sViewport=detail&sArticle=11" 104 => "sViewport=detail&sArticle=12" 105 => "sViewport=detail&sArticle=12" 106 => "sViewport=detail&sArticle=13" 107 => "sViewport=detail&sArticle=13" 108 => "sViewport=detail&sArticle=14" 109 => "sViewport=detail&sArticle=14" 110 => "sViewport=detail&sArticle=16" 111 => "sViewport=detail&sArticle=16" 112 => "sViewport=detail&sArticle=21" 113 => "sViewport=detail&sArticle=21" ] ] |
0.0011 ms |
SELECT expiry, modified FROM s_core_sessions WHERE id = ? |
array:1 [ 0 => null ] |
0.0001 ms |
SELECT `s_core_snippets`.`name`, `s_core_snippets`.`value` FROM `s_core_snippets` WHERE ( namespace = 'frontend/listing/facet_labels' ) AND (shopID = '3') AND (localeID = '2') |
[] |
0.0310 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.0191 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.0169 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 => 31 ] |
0.1760 ms |
SELECT `s_core_snippets`.`name`, `s_core_snippets`.`value` FROM `s_core_snippets` WHERE ( namespace = 'frontend/cookie_consent/groups' ) AND (shopID = '3') AND (localeID = '2') |
[] |
0.0520 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.0532 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.0250 ms |
SELECT `s_core_snippets`.`name`, `s_core_snippets`.`value` FROM `s_core_snippets` WHERE ( namespace = 'frontend/cookie_consent/cookies' ) AND (shopID = '3') AND (localeID = '2') |
[] |
0.0191 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.0160 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.0169 ms |
SELECT * FROM s_order_comparisons WHERE sessionID = ? |
array:1 [ 1 => "57689566afdb645bdc7a2d47a0ce41d3" ] |
0.1700 ms |
SELECT COUNT(*) FROM s_order_notes n, s_articles a WHERE ( sUniqueID = ? OR ( userID != 0 AND userID = ? ) ) AND a.id = n.articleID AND a.active = 1 |
array:2 [ 1 => "57689566afdb645bdc7a2d47a0ce41d3" 2 => 0 ] |
0.1800 ms |
SELECT DISTINCT alsoBought.sales as sales, alsoBought.related_article_id as id, detail.ordernumber as `number` FROM s_articles_also_bought_ro alsoBought INNER JOIN s_articles articles ON alsoBought.related_article_id = articles.id AND articles.active = 1 INNER JOIN s_articles_details detail ON detail.id = articles.main_detail_id INNER JOIN s_articles_categories_ro articleCategories ON alsoBought.related_article_id = articleCategories.articleID AND articleCategories.categoryID = : categoryId INNER JOIN s_categories categories ON categories.id = articleCategories.categoryID LEFT JOIN s_articles_avoid_customergroups customerGroups ON customerGroups.articleID = articles.id AND customerGroups.customergroupID = : customerGroupId WHERE alsoBought.article_id = : articleId AND customerGroups.articleID IS NULL AND alsoBought.related_article_id NOT IN (31) ORDER BY alsoBought.sales DESC, alsoBought.related_article_id DESC LIMIT 40 |
array:3 [ ":articleId" => 31 ":categoryId" => 3 ":customerGroupId" => 1 ] |
0.3700 ms |
SELECT similarShown.viewed as hits, similarShown.related_article_id as id, detail.ordernumber as `number` FROM s_articles_similar_shown_ro as similarShown INNER JOIN s_articles as a ON a.id = similarShown.related_article_id AND a.active = 1 INNER JOIN s_articles_details as detail ON detail.id = a.main_detail_id INNER JOIN s_articles_categories_ro ac ON ac.articleID = similarShown.related_article_id AND ac.categoryID = : categoryId INNER JOIN s_categories c ON c.id = ac.categoryID AND c.active = 1 LEFT JOIN s_articles_avoid_customergroups ag ON ag.articleID = a.id AND ag.customergroupID = : customerGroupId WHERE similarShown.article_id = : articleId AND ag.articleID IS NULL AND similarShown.related_article_id NOT IN (31, 31) GROUP BY similarShown.viewed, similarShown.related_article_id ORDER BY similarShown.viewed DESC, similarShown.related_article_id DESC LIMIT 40 |
array:3 [ ":articleId" => 31 ":categoryId" => 3 ":customerGroupId" => 1 ] |
0.5169 ms |