Queries
163
Total Queries
0.0036 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.0003 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.0001 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/20/demo-artikel-elektronik-pc-monitor-schwarz" ] |
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.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.0002 ms |
SELECT shop.id as __shop_id, shop.main_id as __shop_main_id, shop.name as __shop_name, shop.title as __shop_title, shop.position as __shop_position, shop.host as __shop_host, shop.base_path as __shop_base_path, shop.base_url as __shop_base_url, shop.hosts as __shop_hosts, shop.secure as __shop_secure, shop.template_id as __shop_template_id, shop.document_template_id as __shop_document_template_id, shop.category_id as __shop_category_id, shop.locale_id as __shop_locale_id, shop.currency_id as __shop_currency_id, shop.customer_group_id as __shop_customer_group_id, shop.fallback_id as __shop_fallback_id, shop.customer_scope as __shop_customer_scope, shop.default as __shop_default, shop.active as __shop_active, shopAttribute.id as __shopAttribute_id, shopAttribute.shopID as __shopAttribute_shopID, currency.id as __currency_id, currency.currency as __currency_currency, currency.name as __currency_name, currency.standard as __currency_standard, currency.factor as __currency_factor, currency.templatechar as __currency_templatechar, currency.symbol_position as __currency_symbol_position, currency.position as __currency_position, template.id as __template_id, template.template as __template_template, template.name as __template_name, template.description as __template_description, template.author as __template_author, template.license as __template_license, template.esi as __template_esi, template.style_support as __template_style_support, template.emotion as __template_emotion, template.version as __template_version, template.plugin_id as __template_plugin_id, template.parent_id as __template_parent_id, locale.id as __locale_id, locale.locale as __locale_locale, locale.language as __locale_language, locale.territory as __locale_territory, customerGroup.id as __customerGroup_id, customerGroup.groupkey as __customerGroup_groupkey, customerGroup.description as __customerGroup_description, customerGroup.tax as __customerGroup_tax, customerGroup.taxinput as __customerGroup_taxinput, customerGroup.mode as __customerGroup_mode, customerGroup.discount as __customerGroup_discount, customerGroup.minimumorder as __customerGroup_minimumorder, customerGroup.minimumordersurcharge as __customerGroup_minimumordersurcharge, customerGroupAttribute.id as __customerGroupAttribute_id, customerGroupAttribute.customerGroupID as __customerGroupAttribute_customerGroupID, category.id as __category_id, category.parent as __category_parent_id, category.position as __category_position, category.path as __category_path, category.description as __category_description, category.meta_title as __category_metatitle, category.metakeywords as __category_metakeywords, category.metadescription as __category_metadescription, category.cmsheadline as __category_cmsheadline, category.product_box_layout as __category_product_box_layout, category.cmstext as __category_cmstext, category.template as __category_template, category.blog as __category_blog, category.external as __category_external, category.external_target as __category_external_target, category.hidefilter as __category_hidefilter, category.hidetop as __category_hidetop, category.stream_id as __category_stream_id, category.hide_sortings as __category_hide_sortings, categoryAttribute.id as __categoryAttribute_id, categoryAttribute.categoryID as __categoryAttribute_categoryID, categoryAttribute.attribute1 as __categoryAttribute_attribute1, categoryAttribute.attribute2 as __categoryAttribute_attribute2, categoryAttribute.attribute3 as __categoryAttribute_attribute3, categoryAttribute.attribute4 as __categoryAttribute_attribute4, categoryAttribute.attribute5 as __categoryAttribute_attribute5, categoryAttribute.attribute6 as __categoryAttribute_attribute6, 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.0002 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 => "44" ] |
0.0003 ms |
SELECT t0.sorting_ids AS sorting_ids_1, t0.hide_sortings AS hide_sortings_2, t0.facet_ids AS facet_ids_3, t0.shops AS shops_4, t0.id AS id_5, t0.parent AS parent_6, t0.stream_id AS stream_id_7, t0.description AS description_8, t0.position AS position_9, t0.meta_title AS meta_title_10, t0.metakeywords AS metakeywords_11, t0.metadescription AS metadescription_12, t0.cmsheadline AS cmsheadline_13, t0.cmstext AS cmstext_14, t0.active AS active_15, t0.template AS template_16, t0.product_box_layout AS product_box_layout_17, t0.blog AS blog_18, t0.path AS path_19, t0.external AS external_20, t0.external_target AS external_target_21, t0.hidefilter AS hidefilter_22, t0.hidetop AS hidetop_23, t0.changed AS changed_24, t0.added AS added_25, t0.mediaID AS mediaID_26, t27.id AS id_28, t27.categoryID AS categoryID_29, t27.attribute1 AS attribute1_30, t27.attribute2 AS attribute2_31, t27.attribute3 AS attribute3_32, t27.attribute4 AS attribute4_33, t27.attribute5 AS attribute5_34, t27.attribute6 AS attribute6_35, t27.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 => 16 ] |
0.0003 ms |
SELECT t0.sorting_ids AS sorting_ids_1, t0.hide_sortings AS hide_sortings_2, t0.facet_ids AS facet_ids_3, t0.shops AS shops_4, t0.id AS id_5, t0.parent AS parent_6, t0.stream_id AS stream_id_7, t0.description AS description_8, t0.position AS position_9, t0.meta_title AS meta_title_10, t0.metakeywords AS metakeywords_11, t0.metadescription AS metadescription_12, t0.cmsheadline AS cmsheadline_13, t0.cmstext AS cmstext_14, t0.active AS active_15, t0.template AS template_16, t0.product_box_layout AS product_box_layout_17, t0.blog AS blog_18, t0.path AS path_19, t0.external AS external_20, t0.external_target AS external_target_21, t0.hidefilter AS hidefilter_22, t0.hidetop AS hidetop_23, t0.changed AS changed_24, t0.added AS added_25, t0.mediaID AS mediaID_26, t27.id AS id_28, t27.categoryID AS categoryID_29, t27.attribute1 AS attribute1_30, t27.attribute2 AS attribute2_31, t27.attribute3 AS attribute3_32, t27.attribute4 AS attribute4_33, t27.attribute5 AS attribute5_34, t27.attribute6 AS attribute6_35, t27.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 => 9 ] |
0.0002 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.0002 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.0002 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.0002 ms |
SELECT s0_.description AS description_0 FROM s_categories s0_ WHERE s0_.id = ? |
array:1 [ 0 => 9 ] |
0.0001 ms |
SELECT `objectdata` FROM `s_core_translations` WHERE (`objecttype` = : type) AND (`objectkey` = : key) AND (`objectlanguage` = : language) |
array:3 [ ":type" => "category" ":key" => 9 ":language" => 3 ] |
0.0001 ms |
SELECT s0_.description AS description_0 FROM s_categories s0_ WHERE s0_.id = ? |
array:1 [ 0 => 16 ] |
0.0001 ms |
SELECT `objectdata` FROM `s_core_translations` WHERE (`objecttype` = : type) AND (`objectkey` = : key) AND (`objectlanguage` = : language) |
array:3 [ ":type" => "category" ":key" => 16 ":language" => 3 ] |
0.0001 ms |
SELECT s0_.description AS description_0 FROM s_categories s0_ WHERE s0_.id = ? |
array:1 [ 0 => 44 ] |
0.0001 ms |
SELECT `objectdata` FROM `s_core_translations` WHERE (`objecttype` = : type) AND (`objectkey` = : key) AND (`objectlanguage` = : language) |
array:3 [ ":type" => "category" ":key" => "44" ":language" => 3 ] |
0.0001 ms |
SELECT variant.ordernumber FROM s_articles_details variant INNER JOIN s_articles product ON product.main_detail_id = variant.id WHERE variant.articleID = : id |
array:1 [ ":id" => 20 ] |
0.0015 ms |
SELECT variant.articleID FROM s_articles_details variant WHERE variant.ordernumber = : number |
array:1 [ ":number" => "10020" ] |
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" => "20" ":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" => "10020" ] |
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, translation6823059b082e1article.objectdata as __product_translation, translation6823059b082e6fallbackarticle.objectdata as __product_translation_fallback, translation6823059b082e9variant.objectdata as __variant_translation, translation6823059b082ebfallbackvariant.objectdata as __variant_translation_fallback, translation6823059b082eesupplier.objectdata as __manufacturer_translation, translation6823059b082effallbacksupplier.objectdata as __manufacturer_translation_fallback, translation6823059b082f1config_units.objectdata as __unit_translation, translation6823059b082f3fallbackconfig_units.objectdata as __unit_translation_fallback, translation6823059b082f5s_articles_esd_attributes.objectdata as __esdAttribute_translation, translation6823059b082f7fallbacks_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 translation6823059b082e9variant ON translation6823059b082e9variant.objecttype = : translation6823059b082e9variant AND translation6823059b082e9variant.objectkey = variant.id AND translation6823059b082e9variant.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b082ebfallbackvariant ON translation6823059b082ebfallbackvariant.objecttype = : translation6823059b082ebfallbackvariant AND translation6823059b082ebfallbackvariant.objectkey = variant.id AND translation6823059b082ebfallbackvariant.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 translation6823059b082e1article ON translation6823059b082e1article.objecttype = : translation6823059b082e1article AND translation6823059b082e1article.objectkey = product.id AND translation6823059b082e1article.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b082e6fallbackarticle ON translation6823059b082e6fallbackarticle.objecttype = : translation6823059b082e6fallbackarticle AND translation6823059b082e6fallbackarticle.objectkey = product.id AND translation6823059b082e6fallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img LEFT JOIN s_core_translations translation6823059b082eesupplier ON translation6823059b082eesupplier.objecttype = : translation6823059b082eesupplier AND translation6823059b082eesupplier.objectkey = manufacturer.id AND translation6823059b082eesupplier.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b082effallbacksupplier ON translation6823059b082effallbacksupplier.objecttype = : translation6823059b082effallbacksupplier AND translation6823059b082effallbacksupplier.objectkey = manufacturer.id AND translation6823059b082effallbacksupplier.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b082f1config_units ON translation6823059b082f1config_units.objecttype = : translation6823059b082f1config_units AND translation6823059b082f1config_units.objectkey = 1 AND translation6823059b082f1config_units.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b082f3fallbackconfig_units ON translation6823059b082f3fallbackconfig_units.objecttype = : translation6823059b082f3fallbackconfig_units AND translation6823059b082f3fallbackconfig_units.objectkey = 1 AND translation6823059b082f3fallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id LEFT JOIN s_core_translations translation6823059b082f5s_articles_esd_attributes ON translation6823059b082f5s_articles_esd_attributes.objecttype = : translation6823059b082f5s_articles_esd_attributes AND translation6823059b082f5s_articles_esd_attributes.objectkey = esd.id AND translation6823059b082f5s_articles_esd_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b082f7fallbacks_articles_esd_attributes ON translation6823059b082f7fallbacks_articles_esd_attributes.objecttype = : translation6823059b082f7fallbacks_articles_esd_attributes AND translation6823059b082f7fallbacks_articles_esd_attributes.objectkey = esd.id AND translation6823059b082f7fallbacks_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 => 10020 ] ":language" => 3 ":translation6823059b082e1article" => "article" ":languagefallback" => 0 ":translation6823059b082e6fallbackarticle" => "article" ":translation6823059b082e9variant" => "variant" ":translation6823059b082ebfallbackvariant" => "variant" ":translation6823059b082eesupplier" => "supplier" ":translation6823059b082effallbacksupplier" => "supplier" ":translation6823059b082f1config_units" => "config_units" ":translation6823059b082f3fallbackconfig_units" => "config_units" ":translation6823059b082f5s_articles_esd_attributes" => "s_articles_esd_attributes" ":translation6823059b082f7fallbacks_articles_esd_attributes" => "s_articles_esd_attributes" ] |
0.0033 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, translation6823059b09d8farticleimage.objectdata as __image_translation, translation6823059b09d93fallbackarticleimage.objectdata as __image_translation_fallback, translation6823059b09d96s_media_attributes.objectdata as __mediaAttribute_translation, translation6823059b09d98fallbacks_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 translation6823059b09d8farticleimage ON translation6823059b09d8farticleimage.objecttype = : translation6823059b09d8farticleimage AND translation6823059b09d8farticleimage.objectkey = image.id AND translation6823059b09d8farticleimage.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b09d93fallbackarticleimage ON translation6823059b09d93fallbackarticleimage.objecttype = : translation6823059b09d93fallbackarticleimage AND translation6823059b09d93fallbackarticleimage.objectkey = image.id AND translation6823059b09d93fallbackarticleimage.objectlanguage = : languagefallback INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_core_translations translation6823059b09d96s_media_attributes ON translation6823059b09d96s_media_attributes.objecttype = : translation6823059b09d96s_media_attributes AND translation6823059b09d96s_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b09d96s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b09d98fallbacks_media_attributes ON translation6823059b09d98fallbacks_media_attributes.objecttype = : translation6823059b09d98fallbacks_media_attributes AND translation6823059b09d98fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b09d98fallbacks_media_attributes.objectlanguage = : languagefallback WHERE childImage.article_detail_id IN (: products) ORDER BY image.main ASC, image.position ASC |
array:7 [ ":language" => 3 ":translation6823059b09d8farticleimage" => "articleimage" ":languagefallback" => 0 ":translation6823059b09d93fallbackarticleimage" => "articleimage" ":translation6823059b09d96s_media_attributes" => "s_media_attributes" ":translation6823059b09d98fallbacks_media_attributes" => "s_media_attributes" ":products" => array:1 [ 0 => 49 ] ] |
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, 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, translation6823059b0a1f9articleimage.objectdata as __image_translation, translation6823059b0a1fdfallbackarticleimage.objectdata as __image_translation_fallback, translation6823059b0a200s_media_attributes.objectdata as __mediaAttribute_translation, translation6823059b0a202fallbacks_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 translation6823059b0a1f9articleimage ON translation6823059b0a1f9articleimage.objecttype = : translation6823059b0a1f9articleimage AND translation6823059b0a1f9articleimage.objectkey = image.id AND translation6823059b0a1f9articleimage.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0a1fdfallbackarticleimage ON translation6823059b0a1fdfallbackarticleimage.objecttype = : translation6823059b0a1fdfallbackarticleimage AND translation6823059b0a1fdfallbackarticleimage.objectkey = image.id AND translation6823059b0a1fdfallbackarticleimage.objectlanguage = : languagefallback INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_core_translations translation6823059b0a200s_media_attributes ON translation6823059b0a200s_media_attributes.objecttype = : translation6823059b0a200s_media_attributes AND translation6823059b0a200s_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0a200s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0a202fallbacks_media_attributes ON translation6823059b0a202fallbacks_media_attributes.objecttype = : translation6823059b0a202fallbacks_media_attributes AND translation6823059b0a202fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0a202fallbacks_media_attributes.objectlanguage = : languagefallback WHERE (image.main = 1) AND ( image.articleID IN (: products) ) |
array:7 [ ":language" => 3 ":translation6823059b0a1f9articleimage" => "articleimage" ":languagefallback" => 0 ":translation6823059b0a1fdfallbackarticleimage" => "articleimage" ":translation6823059b0a200s_media_attributes" => "s_media_attributes" ":translation6823059b0a202fallbacks_media_attributes" => "s_media_attributes" ":products" => array:1 [ 0 => 20 ] ] |
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, translation6823059b0ab07s_articles_prices_attributes.objectdata as __priceAttribute_translation, translation6823059b0ab0bfallbacks_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 translation6823059b0ab07s_articles_prices_attributes ON translation6823059b0ab07s_articles_prices_attributes.objecttype = : translation6823059b0ab07s_articles_prices_attributes AND translation6823059b0ab07s_articles_prices_attributes.objectkey = price.id AND translation6823059b0ab07s_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0ab0bfallbacks_articles_prices_attributes ON translation6823059b0ab0bfallbacks_articles_prices_attributes.objecttype = : translation6823059b0ab0bfallbacks_articles_prices_attributes AND translation6823059b0ab0bfallbacks_articles_prices_attributes.objectkey = price.id AND translation6823059b0ab0bfallbacks_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 => 49 ] ":customerGroup" => "EK" ":language" => 3 ":translation6823059b0ab07s_articles_prices_attributes" => "s_articles_prices_attributes" ":languagefallback" => 0 ":translation6823059b0ab0bfallbacks_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 => 20 ] ":priceGroupCustomerGroup" => 1 ] |
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, 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, translation6823059b0b146config_units.objectdata as __unit_translation, translation6823059b0b14afallbackconfig_units.objectdata as __unit_translation_fallback, translation6823059b0b14darticle.objectdata as __product_translation, translation6823059b0b14ffallbackarticle.objectdata as __product_translation_fallback, translation6823059b0b151variant.objectdata as __variant_translation, translation6823059b0b152fallbackvariant.objectdata as __variant_translation_fallback, translation6823059b0b154s_articles_prices_attributes.objectdata as __priceAttribute_translation, translation6823059b0b156fallbacks_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 translation6823059b0b151variant ON translation6823059b0b151variant.objecttype = : translation6823059b0b151variant AND translation6823059b0b151variant.objectkey = variant.id AND translation6823059b0b151variant.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0b152fallbackvariant ON translation6823059b0b152fallbackvariant.objecttype = : translation6823059b0b152fallbackvariant AND translation6823059b0b152fallbackvariant.objectkey = variant.id AND translation6823059b0b152fallbackvariant.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b0b14darticle ON translation6823059b0b14darticle.objecttype = : translation6823059b0b14darticle AND translation6823059b0b14darticle.objectkey = product.id AND translation6823059b0b14darticle.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0b14ffallbackarticle ON translation6823059b0b14ffallbackarticle.objecttype = : translation6823059b0b14ffallbackarticle AND translation6823059b0b14ffallbackarticle.objectkey = product.id AND translation6823059b0b14ffallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b0b146config_units ON translation6823059b0b146config_units.objecttype = : translation6823059b0b146config_units AND translation6823059b0b146config_units.objectkey = 1 AND translation6823059b0b146config_units.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0b14afallbackconfig_units ON translation6823059b0b14afallbackconfig_units.objecttype = : translation6823059b0b14afallbackconfig_units AND translation6823059b0b14afallbackconfig_units.objectkey = 1 AND translation6823059b0b14afallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b0b154s_articles_prices_attributes ON translation6823059b0b154s_articles_prices_attributes.objecttype = : translation6823059b0b154s_articles_prices_attributes AND translation6823059b0b154s_articles_prices_attributes.objectkey = price.id AND translation6823059b0b154s_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0b156fallbacks_articles_prices_attributes ON translation6823059b0b156fallbacks_articles_prices_attributes.objecttype = : translation6823059b0b156fallbacks_articles_prices_attributes AND translation6823059b0b156fallbacks_articles_prices_attributes.objectkey = price.id AND translation6823059b0b156fallbacks_articles_prices_attributes.objectlanguage = : languagefallback WHERE price.id IN (: ids) |
array:11 [ ":ids" => array:1 [ 0 => "107" ] ":language" => 3 ":translation6823059b0b146config_units" => "config_units" ":languagefallback" => 0 ":translation6823059b0b14afallbackconfig_units" => "config_units" ":translation6823059b0b14darticle" => "article" ":translation6823059b0b14ffallbackarticle" => "article" ":translation6823059b0b151variant" => "variant" ":translation6823059b0b152fallbackvariant" => "variant" ":translation6823059b0b154s_articles_prices_attributes" => "s_articles_prices_attributes" ":translation6823059b0b156fallbacks_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:1 [ 0 => 20 ] ] |
0.0003 ms |
SELECT mapping.articleID, GROUP_CONCAT(DISTINCT mapping.categoryID) FROM s_articles_categories_ro mapping WHERE mapping.articleID IN (: ids) GROUP BY mapping.articleID |
array:1 [ ":ids" => array:1 [ 0 => 20 ] ] |
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, translation6823059b0bae5s_categories_attributes.objectdata as __categoryAttribute_translation, translation6823059b0bae9fallbacks_categories_attributes.objectdata as __categoryAttribute_translation_fallback, translation6823059b0baecs_media_attributes.objectdata as __mediaAttribute_translation, translation6823059b0baeefallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback, translation6823059b0baf1productStream.objectdata as __stream_translation, translation6823059b0baf2fallbackproductStream.objectdata as __stream_translation_fallback, translation6823059b0baf4category.objectdata as __category_translation, translation6823059b0baf6fallbackcategory.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 translation6823059b0baf4category ON translation6823059b0baf4category.objecttype = : translation6823059b0baf4category AND translation6823059b0baf4category.objectkey = category.id AND translation6823059b0baf4category.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0baf6fallbackcategory ON translation6823059b0baf6fallbackcategory.objecttype = : translation6823059b0baf6fallbackcategory AND translation6823059b0baf6fallbackcategory.objectkey = category.id AND translation6823059b0baf6fallbackcategory.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b0bae5s_categories_attributes ON translation6823059b0bae5s_categories_attributes.objecttype = : translation6823059b0bae5s_categories_attributes AND translation6823059b0bae5s_categories_attributes.objectkey = category.id AND translation6823059b0bae5s_categories_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0bae9fallbacks_categories_attributes ON translation6823059b0bae9fallbacks_categories_attributes.objecttype = : translation6823059b0bae9fallbacks_categories_attributes AND translation6823059b0bae9fallbacks_categories_attributes.objectkey = category.id AND translation6823059b0bae9fallbacks_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 translation6823059b0baecs_media_attributes ON translation6823059b0baecs_media_attributes.objecttype = : translation6823059b0baecs_media_attributes AND translation6823059b0baecs_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0baecs_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0baeefallbacks_media_attributes ON translation6823059b0baeefallbacks_media_attributes.objecttype = : translation6823059b0baeefallbacks_media_attributes AND translation6823059b0baeefallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0baeefallbacks_media_attributes.objectlanguage = : languagefallback LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId LEFT JOIN s_core_translations translation6823059b0baf1productStream ON translation6823059b0baf1productStream.objecttype = : translation6823059b0baf1productStream AND translation6823059b0baf1productStream.objectkey = stream.id AND translation6823059b0baf1productStream.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0baf2fallbackproductStream ON translation6823059b0baf2fallbackproductStream.objecttype = : translation6823059b0baf2fallbackproductStream AND translation6823059b0baf2fallbackproductStream.objectkey = stream.id AND translation6823059b0baf2fallbackproductStream.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 ":translation6823059b0bae5s_categories_attributes" => "s_categories_attributes" ":languagefallback" => 0 ":translation6823059b0bae9fallbacks_categories_attributes" => "s_categories_attributes" ":translation6823059b0baecs_media_attributes" => "s_media_attributes" ":translation6823059b0baeefallbacks_media_attributes" => "s_media_attributes" ":translation6823059b0baf1productStream" => "productStream" ":translation6823059b0baf2fallbackproductStream" => "productStream" ":translation6823059b0baf4category" => "category" ":translation6823059b0baf6fallbackcategory" => "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, translation6823059b0c061s_media_attributes.objectdata as __mediaAttribute_translation, translation6823059b0c065fallbacks_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 translation6823059b0c061s_media_attributes ON translation6823059b0c061s_media_attributes.objecttype = : translation6823059b0c061s_media_attributes AND translation6823059b0c061s_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0c061s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0c065fallbacks_media_attributes ON translation6823059b0c065fallbacks_media_attributes.objecttype = : translation6823059b0c065fallbacks_media_attributes AND translation6823059b0c065fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0c065fallbacks_media_attributes.objectlanguage = : languagefallback WHERE media.id IN (: ids) |
array:5 [ ":language" => 3 ":translation6823059b0c061s_media_attributes" => "s_media_attributes" ":languagefallback" => 0 ":translation6823059b0c065fallbacks_media_attributes" => "s_media_attributes" ":ids" => [] ] |
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 => 20 ] ] |
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 => 20 ] ] |
0.0005 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, translation6823059b0c9f0article.objectdata as __product_translation, translation6823059b0c9f4fallbackarticle.objectdata as __product_translation_fallback, translation6823059b0c9f6variant.objectdata as __variant_translation, translation6823059b0c9f8fallbackvariant.objectdata as __variant_translation_fallback, translation6823059b0c9fasupplier.objectdata as __manufacturer_translation, translation6823059b0c9fcfallbacksupplier.objectdata as __manufacturer_translation_fallback, translation6823059b0c9fdconfig_units.objectdata as __unit_translation, translation6823059b0c9fffallbackconfig_units.objectdata as __unit_translation_fallback, translation6823059b0ca01s_articles_esd_attributes.objectdata as __esdAttribute_translation, translation6823059b0ca02fallbacks_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 translation6823059b0c9f6variant ON translation6823059b0c9f6variant.objecttype = : translation6823059b0c9f6variant AND translation6823059b0c9f6variant.objectkey = variant.id AND translation6823059b0c9f6variant.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0c9f8fallbackvariant ON translation6823059b0c9f8fallbackvariant.objecttype = : translation6823059b0c9f8fallbackvariant AND translation6823059b0c9f8fallbackvariant.objectkey = variant.id AND translation6823059b0c9f8fallbackvariant.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 translation6823059b0c9f0article ON translation6823059b0c9f0article.objecttype = : translation6823059b0c9f0article AND translation6823059b0c9f0article.objectkey = product.id AND translation6823059b0c9f0article.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0c9f4fallbackarticle ON translation6823059b0c9f4fallbackarticle.objecttype = : translation6823059b0c9f4fallbackarticle AND translation6823059b0c9f4fallbackarticle.objectkey = product.id AND translation6823059b0c9f4fallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img LEFT JOIN s_core_translations translation6823059b0c9fasupplier ON translation6823059b0c9fasupplier.objecttype = : translation6823059b0c9fasupplier AND translation6823059b0c9fasupplier.objectkey = manufacturer.id AND translation6823059b0c9fasupplier.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0c9fcfallbacksupplier ON translation6823059b0c9fcfallbacksupplier.objecttype = : translation6823059b0c9fcfallbacksupplier AND translation6823059b0c9fcfallbacksupplier.objectkey = manufacturer.id AND translation6823059b0c9fcfallbacksupplier.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b0c9fdconfig_units ON translation6823059b0c9fdconfig_units.objecttype = : translation6823059b0c9fdconfig_units AND translation6823059b0c9fdconfig_units.objectkey = 1 AND translation6823059b0c9fdconfig_units.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0c9fffallbackconfig_units ON translation6823059b0c9fffallbackconfig_units.objecttype = : translation6823059b0c9fffallbackconfig_units AND translation6823059b0c9fffallbackconfig_units.objectkey = 1 AND translation6823059b0c9fffallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id LEFT JOIN s_core_translations translation6823059b0ca01s_articles_esd_attributes ON translation6823059b0ca01s_articles_esd_attributes.objecttype = : translation6823059b0ca01s_articles_esd_attributes AND translation6823059b0ca01s_articles_esd_attributes.objectkey = esd.id AND translation6823059b0ca01s_articles_esd_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0ca02fallbacks_articles_esd_attributes ON translation6823059b0ca02fallbacks_articles_esd_attributes.objecttype = : translation6823059b0ca02fallbacks_articles_esd_attributes AND translation6823059b0ca02fallbacks_articles_esd_attributes.objectkey = esd.id AND translation6823059b0ca02fallbacks_articles_esd_attributes.objectlanguage = : languagefallback WHERE ( variant.ordernumber IN (: numbers) ) AND (variant.active = 1) AND (product.active = 1) |
array:14 [ ":fallback" => "EK" ":numbers" => [] ":language" => 3 ":translation6823059b0c9f0article" => "article" ":languagefallback" => 0 ":translation6823059b0c9f4fallbackarticle" => "article" ":translation6823059b0c9f6variant" => "variant" ":translation6823059b0c9f8fallbackvariant" => "variant" ":translation6823059b0c9fasupplier" => "supplier" ":translation6823059b0c9fcfallbacksupplier" => "supplier" ":translation6823059b0c9fdconfig_units" => "config_units" ":translation6823059b0c9fffallbackconfig_units" => "config_units" ":translation6823059b0ca01s_articles_esd_attributes" => "s_articles_esd_attributes" ":translation6823059b0ca02fallbacks_articles_esd_attributes" => "s_articles_esd_attributes" ] |
0.0012 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, translation6823059b0cf12articleimage.objectdata as __image_translation, translation6823059b0cf16fallbackarticleimage.objectdata as __image_translation_fallback, translation6823059b0cf19s_media_attributes.objectdata as __mediaAttribute_translation, translation6823059b0cf1bfallbacks_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 translation6823059b0cf12articleimage ON translation6823059b0cf12articleimage.objecttype = : translation6823059b0cf12articleimage AND translation6823059b0cf12articleimage.objectkey = image.id AND translation6823059b0cf12articleimage.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0cf16fallbackarticleimage ON translation6823059b0cf16fallbackarticleimage.objecttype = : translation6823059b0cf16fallbackarticleimage AND translation6823059b0cf16fallbackarticleimage.objectkey = image.id AND translation6823059b0cf16fallbackarticleimage.objectlanguage = : languagefallback INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_core_translations translation6823059b0cf19s_media_attributes ON translation6823059b0cf19s_media_attributes.objecttype = : translation6823059b0cf19s_media_attributes AND translation6823059b0cf19s_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0cf19s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0cf1bfallbacks_media_attributes ON translation6823059b0cf1bfallbacks_media_attributes.objecttype = : translation6823059b0cf1bfallbacks_media_attributes AND translation6823059b0cf1bfallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0cf1bfallbacks_media_attributes.objectlanguage = : languagefallback WHERE childImage.article_detail_id IN (: products) ORDER BY image.main ASC, image.position ASC |
array:7 [ ":language" => 3 ":translation6823059b0cf12articleimage" => "articleimage" ":languagefallback" => 0 ":translation6823059b0cf16fallbackarticleimage" => "articleimage" ":translation6823059b0cf19s_media_attributes" => "s_media_attributes" ":translation6823059b0cf1bfallbacks_media_attributes" => "s_media_attributes" ":products" => [] ] |
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, translation6823059b0d13cs_articles_prices_attributes.objectdata as __priceAttribute_translation, translation6823059b0d140fallbacks_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 translation6823059b0d13cs_articles_prices_attributes ON translation6823059b0d13cs_articles_prices_attributes.objecttype = : translation6823059b0d13cs_articles_prices_attributes AND translation6823059b0d13cs_articles_prices_attributes.objectkey = price.id AND translation6823059b0d13cs_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0d140fallbacks_articles_prices_attributes ON translation6823059b0d140fallbacks_articles_prices_attributes.objecttype = : translation6823059b0d140fallbacks_articles_prices_attributes AND translation6823059b0d140fallbacks_articles_prices_attributes.objectkey = price.id AND translation6823059b0d140fallbacks_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" => [] ":customerGroup" => "EK" ":language" => 3 ":translation6823059b0d13cs_articles_prices_attributes" => "s_articles_prices_attributes" ":languagefallback" => 0 ":translation6823059b0d140fallbacks_articles_prices_attributes" => "s_articles_prices_attributes" ] |
0.0003 ms |
SELECT ( SELECT prices.id FROM s_articles_prices prices INNER JOIN s_articles_details variant ON variant.id = prices.articledetailsID INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_pricegroups_discounts priceGroup ON priceGroup.groupID = product.pricegroupID AND priceGroup.discountstart = 1 AND priceGroup.customergroupID = : priceGroupCustomerGroup AND product.pricegroupActive = 1 WHERE ( prices.pricegroup = : customerGroup ) AND (prices.from = 1) AND (variant.active = 1) AND ( prices.articleID = outerPrices.articleID ) AND ( ( variant.laststock * variant.instock ) >= ( variant.laststock * variant.minpurchase ) ) ORDER BY prices.price ASC LIMIT 1 ) as priceId FROM s_articles_prices outerPrices WHERE outerPrices.articleID IN (: products) GROUP BY outerPrices.articleID HAVING priceId IS NOT NULL |
array:3 [ ":customerGroup" => "EK" ":products" => [] ":priceGroupCustomerGroup" => 1 ] |
0.0003 ms |
SELECT price.id as __price_id, price.pricegroup as __price_pricegroup, price.from as __price_from, price.to as __price_to, price.articleID as __price_articleID, price.articledetailsID as __price_articledetailsID, price.price as __price_price, price.pseudoprice as __price_pseudoprice, price.percent as __price_percent, priceAttribute.id as __priceAttribute_id, priceAttribute.priceID as __priceAttribute_priceID, unit.id as __unit_id, unit.description as __unit_description, unit.unit as __unit_unit, variant.packunit as __unit_packunit, variant.purchaseunit as __unit_purchaseunit, variant.referenceunit as __unit_referenceunit, variant.purchasesteps as __unit_purchasesteps, variant.minpurchase as __unit_minpurchase, variant.maxpurchase as __unit_maxpurchase, translation6823059b0d3edconfig_units.objectdata as __unit_translation, translation6823059b0d3f1fallbackconfig_units.objectdata as __unit_translation_fallback, translation6823059b0d3f4article.objectdata as __product_translation, translation6823059b0d3f5fallbackarticle.objectdata as __product_translation_fallback, translation6823059b0d3f7variant.objectdata as __variant_translation, translation6823059b0d3f9fallbackvariant.objectdata as __variant_translation_fallback, translation6823059b0d3fas_articles_prices_attributes.objectdata as __priceAttribute_translation, translation6823059b0d3fcfallbacks_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 translation6823059b0d3f7variant ON translation6823059b0d3f7variant.objecttype = : translation6823059b0d3f7variant AND translation6823059b0d3f7variant.objectkey = variant.id AND translation6823059b0d3f7variant.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0d3f9fallbackvariant ON translation6823059b0d3f9fallbackvariant.objecttype = : translation6823059b0d3f9fallbackvariant AND translation6823059b0d3f9fallbackvariant.objectkey = variant.id AND translation6823059b0d3f9fallbackvariant.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b0d3f4article ON translation6823059b0d3f4article.objecttype = : translation6823059b0d3f4article AND translation6823059b0d3f4article.objectkey = product.id AND translation6823059b0d3f4article.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0d3f5fallbackarticle ON translation6823059b0d3f5fallbackarticle.objecttype = : translation6823059b0d3f5fallbackarticle AND translation6823059b0d3f5fallbackarticle.objectkey = product.id AND translation6823059b0d3f5fallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b0d3edconfig_units ON translation6823059b0d3edconfig_units.objecttype = : translation6823059b0d3edconfig_units AND translation6823059b0d3edconfig_units.objectkey = 1 AND translation6823059b0d3edconfig_units.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0d3f1fallbackconfig_units ON translation6823059b0d3f1fallbackconfig_units.objecttype = : translation6823059b0d3f1fallbackconfig_units AND translation6823059b0d3f1fallbackconfig_units.objectkey = 1 AND translation6823059b0d3f1fallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b0d3fas_articles_prices_attributes ON translation6823059b0d3fas_articles_prices_attributes.objecttype = : translation6823059b0d3fas_articles_prices_attributes AND translation6823059b0d3fas_articles_prices_attributes.objectkey = price.id AND translation6823059b0d3fas_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0d3fcfallbacks_articles_prices_attributes ON translation6823059b0d3fcfallbacks_articles_prices_attributes.objecttype = : translation6823059b0d3fcfallbacks_articles_prices_attributes AND translation6823059b0d3fcfallbacks_articles_prices_attributes.objectkey = price.id AND translation6823059b0d3fcfallbacks_articles_prices_attributes.objectlanguage = : languagefallback WHERE price.id IN (: ids) |
array:11 [ ":ids" => [] ":language" => 3 ":translation6823059b0d3edconfig_units" => "config_units" ":languagefallback" => 0 ":translation6823059b0d3f1fallbackconfig_units" => "config_units" ":translation6823059b0d3f4article" => "article" ":translation6823059b0d3f5fallbackarticle" => "article" ":translation6823059b0d3f7variant" => "variant" ":translation6823059b0d3f9fallbackvariant" => "variant" ":translation6823059b0d3fas_articles_prices_attributes" => "s_articles_prices_attributes" ":translation6823059b0d3fcfallbacks_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" => [] ] |
0.0002 ms |
SELECT mapping.articleID, GROUP_CONCAT(DISTINCT mapping.categoryID) FROM s_articles_categories_ro mapping WHERE mapping.articleID IN (: ids) GROUP BY mapping.articleID |
array:1 [ ":ids" => [] ] |
0.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, translation6823059b0d79fs_categories_attributes.objectdata as __categoryAttribute_translation, translation6823059b0d7a2fallbacks_categories_attributes.objectdata as __categoryAttribute_translation_fallback, translation6823059b0d7a5s_media_attributes.objectdata as __mediaAttribute_translation, translation6823059b0d7a6fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback, translation6823059b0d7a8productStream.objectdata as __stream_translation, translation6823059b0d7aafallbackproductStream.objectdata as __stream_translation_fallback, translation6823059b0d7accategory.objectdata as __category_translation, translation6823059b0d7aefallbackcategory.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 translation6823059b0d7accategory ON translation6823059b0d7accategory.objecttype = : translation6823059b0d7accategory AND translation6823059b0d7accategory.objectkey = category.id AND translation6823059b0d7accategory.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0d7aefallbackcategory ON translation6823059b0d7aefallbackcategory.objecttype = : translation6823059b0d7aefallbackcategory AND translation6823059b0d7aefallbackcategory.objectkey = category.id AND translation6823059b0d7aefallbackcategory.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b0d79fs_categories_attributes ON translation6823059b0d79fs_categories_attributes.objecttype = : translation6823059b0d79fs_categories_attributes AND translation6823059b0d79fs_categories_attributes.objectkey = category.id AND translation6823059b0d79fs_categories_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0d7a2fallbacks_categories_attributes ON translation6823059b0d7a2fallbacks_categories_attributes.objecttype = : translation6823059b0d7a2fallbacks_categories_attributes AND translation6823059b0d7a2fallbacks_categories_attributes.objectkey = category.id AND translation6823059b0d7a2fallbacks_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 translation6823059b0d7a5s_media_attributes ON translation6823059b0d7a5s_media_attributes.objecttype = : translation6823059b0d7a5s_media_attributes AND translation6823059b0d7a5s_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0d7a5s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0d7a6fallbacks_media_attributes ON translation6823059b0d7a6fallbacks_media_attributes.objecttype = : translation6823059b0d7a6fallbacks_media_attributes AND translation6823059b0d7a6fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0d7a6fallbacks_media_attributes.objectlanguage = : languagefallback LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId LEFT JOIN s_core_translations translation6823059b0d7a8productStream ON translation6823059b0d7a8productStream.objecttype = : translation6823059b0d7a8productStream AND translation6823059b0d7a8productStream.objectkey = stream.id AND translation6823059b0d7a8productStream.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0d7aafallbackproductStream ON translation6823059b0d7aafallbackproductStream.objecttype = : translation6823059b0d7aafallbackproductStream AND translation6823059b0d7aafallbackproductStream.objectkey = stream.id AND translation6823059b0d7aafallbackproductStream.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" => [] ":shopId" => "%|3|%" ":language" => 3 ":translation6823059b0d79fs_categories_attributes" => "s_categories_attributes" ":languagefallback" => 0 ":translation6823059b0d7a2fallbacks_categories_attributes" => "s_categories_attributes" ":translation6823059b0d7a5s_media_attributes" => "s_media_attributes" ":translation6823059b0d7a6fallbacks_media_attributes" => "s_media_attributes" ":translation6823059b0d7a8productStream" => "productStream" ":translation6823059b0d7aafallbackproductStream" => "productStream" ":translation6823059b0d7accategory" => "category" ":translation6823059b0d7aefallbackcategory" => "category" ] |
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, translation6823059b0dad0s_media_attributes.objectdata as __mediaAttribute_translation, translation6823059b0dad4fallbacks_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 translation6823059b0dad0s_media_attributes ON translation6823059b0dad0s_media_attributes.objecttype = : translation6823059b0dad0s_media_attributes AND translation6823059b0dad0s_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0dad0s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0dad4fallbacks_media_attributes ON translation6823059b0dad4fallbacks_media_attributes.objecttype = : translation6823059b0dad4fallbacks_media_attributes AND translation6823059b0dad4fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0dad4fallbacks_media_attributes.objectlanguage = : languagefallback WHERE media.id IN (: ids) |
array:5 [ ":language" => 3 ":translation6823059b0dad0s_media_attributes" => "s_media_attributes" ":languagefallback" => 0 ":translation6823059b0dad4fallbacks_media_attributes" => "s_media_attributes" ":ids" => [] ] |
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, translation6823059b0dc48productStream.objectdata as __stream_translation, translation6823059b0dc4bfallbackproductStream.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 translation6823059b0dc48productStream ON translation6823059b0dc48productStream.objecttype = : translation6823059b0dc48productStream AND translation6823059b0dc48productStream.objectkey = stream.id AND translation6823059b0dc48productStream.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0dc4bfallbackproductStream ON translation6823059b0dc4bfallbackproductStream.objecttype = : translation6823059b0dc4bfallbackproductStream AND translation6823059b0dc4bfallbackproductStream.objectkey = stream.id AND translation6823059b0dc4bfallbackproductStream.objectlanguage = : languagefallback WHERE relation.article_id IN (: ids) |
array:5 [ ":ids" => array:1 [ 0 => 20 ] ":language" => 3 ":translation6823059b0dc48productStream" => "productStream" ":languagefallback" => 0 ":translation6823059b0dc4bfallbackproductStream" => "productStream" ] |
0.0008 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 => 20 ] ] |
0.0004 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, translation6823059b0e218article.objectdata as __product_translation, translation6823059b0e21bfallbackarticle.objectdata as __product_translation_fallback, translation6823059b0e21evariant.objectdata as __variant_translation, translation6823059b0e220fallbackvariant.objectdata as __variant_translation_fallback, translation6823059b0e221supplier.objectdata as __manufacturer_translation, translation6823059b0e223fallbacksupplier.objectdata as __manufacturer_translation_fallback, translation6823059b0e225config_units.objectdata as __unit_translation, translation6823059b0e226fallbackconfig_units.objectdata as __unit_translation_fallback, translation6823059b0e228s_articles_esd_attributes.objectdata as __esdAttribute_translation, translation6823059b0e22afallbacks_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 translation6823059b0e21evariant ON translation6823059b0e21evariant.objecttype = : translation6823059b0e21evariant AND translation6823059b0e21evariant.objectkey = variant.id AND translation6823059b0e21evariant.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0e220fallbackvariant ON translation6823059b0e220fallbackvariant.objecttype = : translation6823059b0e220fallbackvariant AND translation6823059b0e220fallbackvariant.objectkey = variant.id AND translation6823059b0e220fallbackvariant.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 translation6823059b0e218article ON translation6823059b0e218article.objecttype = : translation6823059b0e218article AND translation6823059b0e218article.objectkey = product.id AND translation6823059b0e218article.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0e21bfallbackarticle ON translation6823059b0e21bfallbackarticle.objecttype = : translation6823059b0e21bfallbackarticle AND translation6823059b0e21bfallbackarticle.objectkey = product.id AND translation6823059b0e21bfallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img LEFT JOIN s_core_translations translation6823059b0e221supplier ON translation6823059b0e221supplier.objecttype = : translation6823059b0e221supplier AND translation6823059b0e221supplier.objectkey = manufacturer.id AND translation6823059b0e221supplier.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0e223fallbacksupplier ON translation6823059b0e223fallbacksupplier.objecttype = : translation6823059b0e223fallbacksupplier AND translation6823059b0e223fallbacksupplier.objectkey = manufacturer.id AND translation6823059b0e223fallbacksupplier.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b0e225config_units ON translation6823059b0e225config_units.objecttype = : translation6823059b0e225config_units AND translation6823059b0e225config_units.objectkey = 1 AND translation6823059b0e225config_units.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0e226fallbackconfig_units ON translation6823059b0e226fallbackconfig_units.objecttype = : translation6823059b0e226fallbackconfig_units AND translation6823059b0e226fallbackconfig_units.objectkey = 1 AND translation6823059b0e226fallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id LEFT JOIN s_core_translations translation6823059b0e228s_articles_esd_attributes ON translation6823059b0e228s_articles_esd_attributes.objecttype = : translation6823059b0e228s_articles_esd_attributes AND translation6823059b0e228s_articles_esd_attributes.objectkey = esd.id AND translation6823059b0e228s_articles_esd_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0e22afallbacks_articles_esd_attributes ON translation6823059b0e22afallbacks_articles_esd_attributes.objecttype = : translation6823059b0e22afallbacks_articles_esd_attributes AND translation6823059b0e22afallbacks_articles_esd_attributes.objectkey = esd.id AND translation6823059b0e22afallbacks_articles_esd_attributes.objectlanguage = : languagefallback WHERE ( variant.ordernumber IN (: numbers) ) AND (variant.active = 1) AND (product.active = 1) |
array:14 [ ":fallback" => "EK" ":numbers" => [] ":language" => 3 ":translation6823059b0e218article" => "article" ":languagefallback" => 0 ":translation6823059b0e21bfallbackarticle" => "article" ":translation6823059b0e21evariant" => "variant" ":translation6823059b0e220fallbackvariant" => "variant" ":translation6823059b0e221supplier" => "supplier" ":translation6823059b0e223fallbacksupplier" => "supplier" ":translation6823059b0e225config_units" => "config_units" ":translation6823059b0e226fallbackconfig_units" => "config_units" ":translation6823059b0e228s_articles_esd_attributes" => "s_articles_esd_attributes" ":translation6823059b0e22afallbacks_articles_esd_attributes" => "s_articles_esd_attributes" ] |
0.0012 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, translation6823059b0e71darticleimage.objectdata as __image_translation, translation6823059b0e720fallbackarticleimage.objectdata as __image_translation_fallback, translation6823059b0e723s_media_attributes.objectdata as __mediaAttribute_translation, translation6823059b0e724fallbacks_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 translation6823059b0e71darticleimage ON translation6823059b0e71darticleimage.objecttype = : translation6823059b0e71darticleimage AND translation6823059b0e71darticleimage.objectkey = image.id AND translation6823059b0e71darticleimage.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0e720fallbackarticleimage ON translation6823059b0e720fallbackarticleimage.objecttype = : translation6823059b0e720fallbackarticleimage AND translation6823059b0e720fallbackarticleimage.objectkey = image.id AND translation6823059b0e720fallbackarticleimage.objectlanguage = : languagefallback INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_core_translations translation6823059b0e723s_media_attributes ON translation6823059b0e723s_media_attributes.objecttype = : translation6823059b0e723s_media_attributes AND translation6823059b0e723s_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0e723s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0e724fallbacks_media_attributes ON translation6823059b0e724fallbacks_media_attributes.objecttype = : translation6823059b0e724fallbacks_media_attributes AND translation6823059b0e724fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0e724fallbacks_media_attributes.objectlanguage = : languagefallback WHERE childImage.article_detail_id IN (: products) ORDER BY image.main ASC, image.position ASC |
array:7 [ ":language" => 3 ":translation6823059b0e71darticleimage" => "articleimage" ":languagefallback" => 0 ":translation6823059b0e720fallbackarticleimage" => "articleimage" ":translation6823059b0e723s_media_attributes" => "s_media_attributes" ":translation6823059b0e724fallbacks_media_attributes" => "s_media_attributes" ":products" => [] ] |
0.0004 ms |
SELECT price.id as __price_id, price.pricegroup as __price_pricegroup, price.from as __price_from, price.to as __price_to, price.articleID as __price_articleID, price.articledetailsID as __price_articledetailsID, price.price as __price_price, price.pseudoprice as __price_pseudoprice, price.percent as __price_percent, priceAttribute.id as __priceAttribute_id, priceAttribute.priceID as __priceAttribute_priceID, variants.ordernumber as number, GREATEST( price.from, variants.minpurchase ) __price_from, translation6823059b0e932s_articles_prices_attributes.objectdata as __priceAttribute_translation, translation6823059b0e935fallbacks_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 translation6823059b0e932s_articles_prices_attributes ON translation6823059b0e932s_articles_prices_attributes.objecttype = : translation6823059b0e932s_articles_prices_attributes AND translation6823059b0e932s_articles_prices_attributes.objectkey = price.id AND translation6823059b0e932s_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0e935fallbacks_articles_prices_attributes ON translation6823059b0e935fallbacks_articles_prices_attributes.objecttype = : translation6823059b0e935fallbacks_articles_prices_attributes AND translation6823059b0e935fallbacks_articles_prices_attributes.objectkey = price.id AND translation6823059b0e935fallbacks_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" => [] ":customerGroup" => "EK" ":language" => 3 ":translation6823059b0e932s_articles_prices_attributes" => "s_articles_prices_attributes" ":languagefallback" => 0 ":translation6823059b0e935fallbacks_articles_prices_attributes" => "s_articles_prices_attributes" ] |
0.0003 ms |
SELECT ( SELECT prices.id FROM s_articles_prices prices INNER JOIN s_articles_details variant ON variant.id = prices.articledetailsID INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_pricegroups_discounts priceGroup ON priceGroup.groupID = product.pricegroupID AND priceGroup.discountstart = 1 AND priceGroup.customergroupID = : priceGroupCustomerGroup AND product.pricegroupActive = 1 WHERE ( prices.pricegroup = : customerGroup ) AND (prices.from = 1) AND (variant.active = 1) AND ( prices.articleID = outerPrices.articleID ) AND ( ( variant.laststock * variant.instock ) >= ( variant.laststock * variant.minpurchase ) ) ORDER BY prices.price ASC LIMIT 1 ) as priceId FROM s_articles_prices outerPrices WHERE outerPrices.articleID IN (: products) GROUP BY outerPrices.articleID HAVING priceId IS NOT NULL |
array:3 [ ":customerGroup" => "EK" ":products" => [] ":priceGroupCustomerGroup" => 1 ] |
0.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, translation6823059b0eb43config_units.objectdata as __unit_translation, translation6823059b0eb47fallbackconfig_units.objectdata as __unit_translation_fallback, translation6823059b0eb4aarticle.objectdata as __product_translation, translation6823059b0eb4cfallbackarticle.objectdata as __product_translation_fallback, translation6823059b0eb4evariant.objectdata as __variant_translation, translation6823059b0eb4ffallbackvariant.objectdata as __variant_translation_fallback, translation6823059b0eb51s_articles_prices_attributes.objectdata as __priceAttribute_translation, translation6823059b0eb52fallbacks_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 translation6823059b0eb4evariant ON translation6823059b0eb4evariant.objecttype = : translation6823059b0eb4evariant AND translation6823059b0eb4evariant.objectkey = variant.id AND translation6823059b0eb4evariant.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0eb4ffallbackvariant ON translation6823059b0eb4ffallbackvariant.objecttype = : translation6823059b0eb4ffallbackvariant AND translation6823059b0eb4ffallbackvariant.objectkey = variant.id AND translation6823059b0eb4ffallbackvariant.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b0eb4aarticle ON translation6823059b0eb4aarticle.objecttype = : translation6823059b0eb4aarticle AND translation6823059b0eb4aarticle.objectkey = product.id AND translation6823059b0eb4aarticle.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0eb4cfallbackarticle ON translation6823059b0eb4cfallbackarticle.objecttype = : translation6823059b0eb4cfallbackarticle AND translation6823059b0eb4cfallbackarticle.objectkey = product.id AND translation6823059b0eb4cfallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b0eb43config_units ON translation6823059b0eb43config_units.objecttype = : translation6823059b0eb43config_units AND translation6823059b0eb43config_units.objectkey = 1 AND translation6823059b0eb43config_units.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0eb47fallbackconfig_units ON translation6823059b0eb47fallbackconfig_units.objecttype = : translation6823059b0eb47fallbackconfig_units AND translation6823059b0eb47fallbackconfig_units.objectkey = 1 AND translation6823059b0eb47fallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b0eb51s_articles_prices_attributes ON translation6823059b0eb51s_articles_prices_attributes.objecttype = : translation6823059b0eb51s_articles_prices_attributes AND translation6823059b0eb51s_articles_prices_attributes.objectkey = price.id AND translation6823059b0eb51s_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0eb52fallbacks_articles_prices_attributes ON translation6823059b0eb52fallbacks_articles_prices_attributes.objecttype = : translation6823059b0eb52fallbacks_articles_prices_attributes AND translation6823059b0eb52fallbacks_articles_prices_attributes.objectkey = price.id AND translation6823059b0eb52fallbacks_articles_prices_attributes.objectlanguage = : languagefallback WHERE price.id IN (: ids) |
array:11 [ ":ids" => [] ":language" => 3 ":translation6823059b0eb43config_units" => "config_units" ":languagefallback" => 0 ":translation6823059b0eb47fallbackconfig_units" => "config_units" ":translation6823059b0eb4aarticle" => "article" ":translation6823059b0eb4cfallbackarticle" => "article" ":translation6823059b0eb4evariant" => "variant" ":translation6823059b0eb4ffallbackvariant" => "variant" ":translation6823059b0eb51s_articles_prices_attributes" => "s_articles_prices_attributes" ":translation6823059b0eb52fallbacks_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" => [] ] |
0.0001 ms |
SELECT mapping.articleID, GROUP_CONCAT(DISTINCT mapping.categoryID) FROM s_articles_categories_ro mapping WHERE mapping.articleID IN (: ids) GROUP BY mapping.articleID |
array:1 [ ":ids" => [] ] |
0.0001 ms |
SELECT category.id as __category_id, category.parent as __category_parent_id, category.position as __category_position, category.path as __category_path, category.description as __category_description, category.meta_title as __category_metatitle, category.metakeywords as __category_metakeywords, category.metadescription as __category_metadescription, category.cmsheadline as __category_cmsheadline, category.product_box_layout as __category_product_box_layout, category.cmstext as __category_cmstext, category.template as __category_template, category.blog as __category_blog, category.external as __category_external, category.external_target as __category_external_target, category.hidefilter as __category_hidefilter, category.hidetop as __category_hidetop, category.stream_id as __category_stream_id, category.hide_sortings as __category_hide_sortings, categoryAttribute.id as __categoryAttribute_id, categoryAttribute.categoryID as __categoryAttribute_categoryID, categoryAttribute.attribute1 as __categoryAttribute_attribute1, categoryAttribute.attribute2 as __categoryAttribute_attribute2, categoryAttribute.attribute3 as __categoryAttribute_attribute3, categoryAttribute.attribute4 as __categoryAttribute_attribute4, categoryAttribute.attribute5 as __categoryAttribute_attribute5, categoryAttribute.attribute6 as __categoryAttribute_attribute6, 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, translation6823059b0ee8as_categories_attributes.objectdata as __categoryAttribute_translation, translation6823059b0ee8efallbacks_categories_attributes.objectdata as __categoryAttribute_translation_fallback, translation6823059b0ee91s_media_attributes.objectdata as __mediaAttribute_translation, translation6823059b0ee93fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback, translation6823059b0ee95productStream.objectdata as __stream_translation, translation6823059b0ee96fallbackproductStream.objectdata as __stream_translation_fallback, translation6823059b0ee98category.objectdata as __category_translation, translation6823059b0ee99fallbackcategory.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 translation6823059b0ee98category ON translation6823059b0ee98category.objecttype = : translation6823059b0ee98category AND translation6823059b0ee98category.objectkey = category.id AND translation6823059b0ee98category.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0ee99fallbackcategory ON translation6823059b0ee99fallbackcategory.objecttype = : translation6823059b0ee99fallbackcategory AND translation6823059b0ee99fallbackcategory.objectkey = category.id AND translation6823059b0ee99fallbackcategory.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b0ee8as_categories_attributes ON translation6823059b0ee8as_categories_attributes.objecttype = : translation6823059b0ee8as_categories_attributes AND translation6823059b0ee8as_categories_attributes.objectkey = category.id AND translation6823059b0ee8as_categories_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0ee8efallbacks_categories_attributes ON translation6823059b0ee8efallbacks_categories_attributes.objecttype = : translation6823059b0ee8efallbacks_categories_attributes AND translation6823059b0ee8efallbacks_categories_attributes.objectkey = category.id AND translation6823059b0ee8efallbacks_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 translation6823059b0ee91s_media_attributes ON translation6823059b0ee91s_media_attributes.objecttype = : translation6823059b0ee91s_media_attributes AND translation6823059b0ee91s_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0ee91s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0ee93fallbacks_media_attributes ON translation6823059b0ee93fallbacks_media_attributes.objecttype = : translation6823059b0ee93fallbacks_media_attributes AND translation6823059b0ee93fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0ee93fallbacks_media_attributes.objectlanguage = : languagefallback LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId LEFT JOIN s_core_translations translation6823059b0ee95productStream ON translation6823059b0ee95productStream.objecttype = : translation6823059b0ee95productStream AND translation6823059b0ee95productStream.objectkey = stream.id AND translation6823059b0ee95productStream.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0ee96fallbackproductStream ON translation6823059b0ee96fallbackproductStream.objecttype = : translation6823059b0ee96fallbackproductStream AND translation6823059b0ee96fallbackproductStream.objectkey = stream.id AND translation6823059b0ee96fallbackproductStream.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" => [] ":shopId" => "%|3|%" ":language" => 3 ":translation6823059b0ee8as_categories_attributes" => "s_categories_attributes" ":languagefallback" => 0 ":translation6823059b0ee8efallbacks_categories_attributes" => "s_categories_attributes" ":translation6823059b0ee91s_media_attributes" => "s_media_attributes" ":translation6823059b0ee93fallbacks_media_attributes" => "s_media_attributes" ":translation6823059b0ee95productStream" => "productStream" ":translation6823059b0ee96fallbackproductStream" => "productStream" ":translation6823059b0ee98category" => "category" ":translation6823059b0ee99fallbackcategory" => "category" ] |
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, translation6823059b0f16bs_media_attributes.objectdata as __mediaAttribute_translation, translation6823059b0f16ffallbacks_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 translation6823059b0f16bs_media_attributes ON translation6823059b0f16bs_media_attributes.objecttype = : translation6823059b0f16bs_media_attributes AND translation6823059b0f16bs_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0f16bs_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0f16ffallbacks_media_attributes ON translation6823059b0f16ffallbacks_media_attributes.objecttype = : translation6823059b0f16ffallbacks_media_attributes AND translation6823059b0f16ffallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0f16ffallbacks_media_attributes.objectlanguage = : languagefallback WHERE media.id IN (: ids) |
array:5 [ ":language" => 3 ":translation6823059b0f16bs_media_attributes" => "s_media_attributes" ":languagefallback" => 0 ":translation6823059b0f16ffallbacks_media_attributes" => "s_media_attributes" ":ids" => [] ] |
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, translation6823059b0f6a7s_articles_downloads_attributes.objectdata as __downloadAttribute_translation, translation6823059b0f6abfallbacks_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 translation6823059b0f6a7s_articles_downloads_attributes ON translation6823059b0f6a7s_articles_downloads_attributes.objecttype = : translation6823059b0f6a7s_articles_downloads_attributes AND translation6823059b0f6a7s_articles_downloads_attributes.objectkey = download.id AND translation6823059b0f6a7s_articles_downloads_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0f6abfallbacks_articles_downloads_attributes ON translation6823059b0f6abfallbacks_articles_downloads_attributes.objecttype = : translation6823059b0f6abfallbacks_articles_downloads_attributes AND translation6823059b0f6abfallbacks_articles_downloads_attributes.objectkey = download.id AND translation6823059b0f6abfallbacks_articles_downloads_attributes.objectlanguage = : languagefallback WHERE download.articleID IN (: ids) |
array:5 [ ":ids" => array:1 [ 0 => 20 ] ":language" => 3 ":translation6823059b0f6a7s_articles_downloads_attributes" => "s_articles_downloads_attributes" ":languagefallback" => 0 ":translation6823059b0f6abfallbacks_articles_downloads_attributes" => "s_articles_downloads_attributes" ] |
0.0007 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, translation6823059b0fab9s_articles_information_attributes.objectdata as __linkAttribute_translation, translation6823059b0fabdfallbacks_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 translation6823059b0fab9s_articles_information_attributes ON translation6823059b0fab9s_articles_information_attributes.objecttype = : translation6823059b0fab9s_articles_information_attributes AND translation6823059b0fab9s_articles_information_attributes.objectkey = link.id AND translation6823059b0fab9s_articles_information_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0fabdfallbacks_articles_information_attributes ON translation6823059b0fabdfallbacks_articles_information_attributes.objecttype = : translation6823059b0fabdfallbacks_articles_information_attributes AND translation6823059b0fabdfallbacks_articles_information_attributes.objectkey = link.id AND translation6823059b0fabdfallbacks_articles_information_attributes.objectlanguage = : languagefallback WHERE link.articleID IN (: ids) |
array:5 [ ":ids" => array:1 [ 0 => 20 ] ":language" => 3 ":translation6823059b0fab9s_articles_information_attributes" => "s_articles_information_attributes" ":languagefallback" => 0 ":translation6823059b0fabdfallbacks_articles_information_attributes" => "s_articles_information_attributes" ] |
0.0007 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, translation6823059b0fdfearticleimage.objectdata as __image_translation, translation6823059b0fe02fallbackarticleimage.objectdata as __image_translation_fallback, translation6823059b0fe05s_media_attributes.objectdata as __mediaAttribute_translation, translation6823059b0fe07fallbacks_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 translation6823059b0fdfearticleimage ON translation6823059b0fdfearticleimage.objecttype = : translation6823059b0fdfearticleimage AND translation6823059b0fdfearticleimage.objectkey = image.id AND translation6823059b0fdfearticleimage.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0fe02fallbackarticleimage ON translation6823059b0fe02fallbackarticleimage.objecttype = : translation6823059b0fe02fallbackarticleimage AND translation6823059b0fe02fallbackarticleimage.objectkey = image.id AND translation6823059b0fe02fallbackarticleimage.objectlanguage = : languagefallback INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_core_translations translation6823059b0fe05s_media_attributes ON translation6823059b0fe05s_media_attributes.objecttype = : translation6823059b0fe05s_media_attributes AND translation6823059b0fe05s_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0fe05s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b0fe07fallbacks_media_attributes ON translation6823059b0fe07fallbacks_media_attributes.objecttype = : translation6823059b0fe07fallbacks_media_attributes AND translation6823059b0fe07fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b0fe07fallbacks_media_attributes.objectlanguage = : languagefallback WHERE childImage.article_detail_id IN (: products) ORDER BY image.main ASC, image.position ASC |
array:7 [ ":language" => 3 ":translation6823059b0fdfearticleimage" => "articleimage" ":languagefallback" => 0 ":translation6823059b0fe02fallbackarticleimage" => "articleimage" ":translation6823059b0fe05s_media_attributes" => "s_media_attributes" ":translation6823059b0fe07fallbacks_media_attributes" => "s_media_attributes" ":products" => array:1 [ 0 => 49 ] ] |
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, translation6823059b10141articleimage.objectdata as __image_translation, translation6823059b10145fallbackarticleimage.objectdata as __image_translation_fallback, translation6823059b10147s_media_attributes.objectdata as __mediaAttribute_translation, translation6823059b10149fallbacks_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 translation6823059b10141articleimage ON translation6823059b10141articleimage.objecttype = : translation6823059b10141articleimage AND translation6823059b10141articleimage.objectkey = image.id AND translation6823059b10141articleimage.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b10145fallbackarticleimage ON translation6823059b10145fallbackarticleimage.objecttype = : translation6823059b10145fallbackarticleimage AND translation6823059b10145fallbackarticleimage.objectkey = image.id AND translation6823059b10145fallbackarticleimage.objectlanguage = : languagefallback INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_core_translations translation6823059b10147s_media_attributes ON translation6823059b10147s_media_attributes.objecttype = : translation6823059b10147s_media_attributes AND translation6823059b10147s_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b10147s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b10149fallbacks_media_attributes ON translation6823059b10149fallbacks_media_attributes.objecttype = : translation6823059b10149fallbacks_media_attributes AND translation6823059b10149fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b10149fallbacks_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 ":translation6823059b10141articleimage" => "articleimage" ":languagefallback" => 0 ":translation6823059b10145fallbackarticleimage" => "articleimage" ":translation6823059b10147s_media_attributes" => "s_media_attributes" ":translation6823059b10149fallbacks_media_attributes" => "s_media_attributes" ":products" => array:1 [ 0 => 20 ] ] |
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, translation6823059b10517propertygroup.objectdata as __propertySet_translation, translation6823059b1051afallbackpropertygroup.objectdata as __propertySet_translation_fallback, translation6823059b1051dpropertyoption.objectdata as __propertyGroup_translation, translation6823059b1051ffallbackpropertyoption.objectdata as __propertyGroup_translation_fallback, translation6823059b10521propertyvalue.objectdata as __propertyOption_translation, translation6823059b10522fallbackpropertyvalue.objectdata as __propertyOption_translation_fallback, translation6823059b10524s_media_attributes.objectdata as __mediaAttribute_translation, translation6823059b10526fallbacks_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 translation6823059b10517propertygroup ON translation6823059b10517propertygroup.objecttype = : translation6823059b10517propertygroup AND translation6823059b10517propertygroup.objectkey = propertySet.id AND translation6823059b10517propertygroup.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b1051afallbackpropertygroup ON translation6823059b1051afallbackpropertygroup.objecttype = : translation6823059b1051afallbackpropertygroup AND translation6823059b1051afallbackpropertygroup.objectkey = propertySet.id AND translation6823059b1051afallbackpropertygroup.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 translation6823059b10521propertyvalue ON translation6823059b10521propertyvalue.objecttype = : translation6823059b10521propertyvalue AND translation6823059b10521propertyvalue.objectkey = propertyOption.id AND translation6823059b10521propertyvalue.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b10522fallbackpropertyvalue ON translation6823059b10522fallbackpropertyvalue.objecttype = : translation6823059b10522fallbackpropertyvalue AND translation6823059b10522fallbackpropertyvalue.objectkey = propertyOption.id AND translation6823059b10522fallbackpropertyvalue.objectlanguage = : languagefallback LEFT JOIN s_filter_options_attributes propertyGroupAttribute ON propertyGroupAttribute.optionID = propertyGroup.id LEFT JOIN s_core_translations translation6823059b1051dpropertyoption ON translation6823059b1051dpropertyoption.objecttype = : translation6823059b1051dpropertyoption AND translation6823059b1051dpropertyoption.objectkey = propertyGroup.id AND translation6823059b1051dpropertyoption.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b1051ffallbackpropertyoption ON translation6823059b1051ffallbackpropertyoption.objecttype = : translation6823059b1051ffallbackpropertyoption AND translation6823059b1051ffallbackpropertyoption.objectkey = propertyGroup.id AND translation6823059b1051ffallbackpropertyoption.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 translation6823059b10524s_media_attributes ON translation6823059b10524s_media_attributes.objecttype = : translation6823059b10524s_media_attributes AND translation6823059b10524s_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b10524s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b10526fallbacks_media_attributes ON translation6823059b10526fallbacks_media_attributes.objecttype = : translation6823059b10526fallbacks_media_attributes AND translation6823059b10526fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b10526fallbacks_media_attributes.objectlanguage = : languagefallback WHERE products.id IN (: ids) ORDER BY filterArticles.articleID ASC |
array:11 [ ":ids" => array:1 [ 0 => 20 ] ":language" => 3 ":translation6823059b10517propertygroup" => "propertygroup" ":languagefallback" => 0 ":translation6823059b1051afallbackpropertygroup" => "propertygroup" ":translation6823059b1051dpropertyoption" => "propertyoption" ":translation6823059b1051ffallbackpropertyoption" => "propertyoption" ":translation6823059b10521propertyvalue" => "propertyvalue" ":translation6823059b10522fallbackpropertyvalue" => "propertyvalue" ":translation6823059b10524s_media_attributes" => "s_media_attributes" ":translation6823059b10526fallbacks_media_attributes" => "s_media_attributes" ] |
0.0030 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, translation6823059b11239configuratorgroup.objectdata as __configuratorGroup_translation, translation6823059b1123dfallbackconfiguratorgroup.objectdata as __configuratorGroup_translation_fallback, translation6823059b11240configuratoroption.objectdata as __configuratorOption_translation, translation6823059b11242fallbackconfiguratoroption.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 translation6823059b11240configuratoroption ON translation6823059b11240configuratoroption.objecttype = : translation6823059b11240configuratoroption AND translation6823059b11240configuratoroption.objectkey = configuratorOption.id AND translation6823059b11240configuratoroption.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b11242fallbackconfiguratoroption ON translation6823059b11242fallbackconfiguratoroption.objecttype = : translation6823059b11242fallbackconfiguratoroption AND translation6823059b11242fallbackconfiguratoroption.objectkey = configuratorOption.id AND translation6823059b11242fallbackconfiguratoroption.objectlanguage = : languagefallback LEFT JOIN s_article_configurator_groups_attributes configuratorGroupAttribute ON configuratorGroupAttribute.groupID = configuratorGroup.id LEFT JOIN s_core_translations translation6823059b11239configuratorgroup ON translation6823059b11239configuratorgroup.objecttype = : translation6823059b11239configuratorgroup AND translation6823059b11239configuratorgroup.objectkey = configuratorGroup.id AND translation6823059b11239configuratorgroup.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b1123dfallbackconfiguratorgroup ON translation6823059b1123dfallbackconfiguratorgroup.objecttype = : translation6823059b1123dfallbackconfiguratorgroup AND translation6823059b1123dfallbackconfiguratorgroup.objectkey = configuratorGroup.id AND translation6823059b1123dfallbackconfiguratorgroup.objectlanguage = : languagefallback WHERE relations.article_id IN (: ids) ORDER BY configuratorGroup.position ASC, configuratorGroup.id ASC |
array:7 [ ":ids" => array:1 [ 0 => 49 ] ":language" => 3 ":translation6823059b11239configuratorgroup" => "configuratorgroup" ":languagefallback" => 0 ":translation6823059b1123dfallbackconfiguratorgroup" => "configuratorgroup" ":translation6823059b11240configuratoroption" => "configuratoroption" ":translation6823059b11242fallbackconfiguratoroption" => "configuratoroption" ] |
0.0019 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=20" ] ] |
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=forms&sFid=16" ] ] |
0.0002 ms |
SELECT s0_.id AS id_0, s0_.description AS description_1, s0_.blog AS blog_2 FROM s_categories s0_ WHERE s0_.id = ? |
array:1 [ 0 => 3 ] |
0.0001 ms |
SELECT `objectdata` FROM `s_core_translations` WHERE (`objecttype` = : type) AND (`objectkey` = : key) AND (`objectlanguage` = : language) |
array:3 [ ":type" => "category" ":key" => 3 ":language" => 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 => 9 ] |
0.0001 ms |
SELECT `objectdata` FROM `s_core_translations` WHERE (`objecttype` = : type) AND (`objectkey` = : key) AND (`objectlanguage` = : language) |
array:3 [ ":type" => "category" ":key" => 9 ":language" => 3 ] |
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 => 16 ] |
0.0001 ms |
SELECT `objectdata` FROM `s_core_translations` WHERE (`objecttype` = : type) AND (`objectkey` = : key) AND (`objectlanguage` = : language) |
array:3 [ ":type" => "category" ":key" => 16 ":language" => 3 ] |
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 => 44 ] |
0.0001 ms |
SELECT `objectdata` FROM `s_core_translations` WHERE (`objecttype` = : type) AND (`objectkey` = : key) AND (`objectlanguage` = : language) |
array:3 [ ":type" => "category" ":key" => 44 ":language" => 3 ] |
0.0000 ms |
SELECT category.path FROM s_categories category WHERE category.id = : id |
array:1 [ ":id" => 44 ] |
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 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" => 44 ] |
0.0001 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 => 44 2 => "16" 3 => "9" 4 => "3" ] ":shopId" => "%|3|%" ] |
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, translation6823059b144b0s_categories_attributes.objectdata as __categoryAttribute_translation, translation6823059b144b4fallbacks_categories_attributes.objectdata as __categoryAttribute_translation_fallback, translation6823059b144b7s_media_attributes.objectdata as __mediaAttribute_translation, translation6823059b144b9fallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback, translation6823059b144bbproductStream.objectdata as __stream_translation, translation6823059b144bcfallbackproductStream.objectdata as __stream_translation_fallback, translation6823059b144becategory.objectdata as __category_translation, translation6823059b144bffallbackcategory.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 translation6823059b144becategory ON translation6823059b144becategory.objecttype = : translation6823059b144becategory AND translation6823059b144becategory.objectkey = category.id AND translation6823059b144becategory.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b144bffallbackcategory ON translation6823059b144bffallbackcategory.objecttype = : translation6823059b144bffallbackcategory AND translation6823059b144bffallbackcategory.objectkey = category.id AND translation6823059b144bffallbackcategory.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b144b0s_categories_attributes ON translation6823059b144b0s_categories_attributes.objecttype = : translation6823059b144b0s_categories_attributes AND translation6823059b144b0s_categories_attributes.objectkey = category.id AND translation6823059b144b0s_categories_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b144b4fallbacks_categories_attributes ON translation6823059b144b4fallbacks_categories_attributes.objecttype = : translation6823059b144b4fallbacks_categories_attributes AND translation6823059b144b4fallbacks_categories_attributes.objectkey = category.id AND translation6823059b144b4fallbacks_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 translation6823059b144b7s_media_attributes ON translation6823059b144b7s_media_attributes.objecttype = : translation6823059b144b7s_media_attributes AND translation6823059b144b7s_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b144b7s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b144b9fallbacks_media_attributes ON translation6823059b144b9fallbacks_media_attributes.objecttype = : translation6823059b144b9fallbacks_media_attributes AND translation6823059b144b9fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b144b9fallbacks_media_attributes.objectlanguage = : languagefallback LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId LEFT JOIN s_core_translations translation6823059b144bbproductStream ON translation6823059b144bbproductStream.objecttype = : translation6823059b144bbproductStream AND translation6823059b144bbproductStream.objectkey = stream.id AND translation6823059b144bbproductStream.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b144bcfallbackproductStream ON translation6823059b144bcfallbackproductStream.objecttype = : translation6823059b144bcfallbackproductStream AND translation6823059b144bcfallbackproductStream.objectkey = stream.id AND translation6823059b144bcfallbackproductStream.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:21 [ 0 => 44 1 => "16" 2 => "9" 3 => "3" 4 => 15 5 => 16 6 => 17 7 => 40 8 => 41 9 => 42 10 => 43 11 => 44 12 => 3 13 => 5 14 => 7 15 => 8 16 => 9 17 => 10 18 => 11 19 => 81 20 => 12 ] ":shopId" => "%|3|%" ":language" => 3 ":translation6823059b144b0s_categories_attributes" => "s_categories_attributes" ":languagefallback" => 0 ":translation6823059b144b4fallbacks_categories_attributes" => "s_categories_attributes" ":translation6823059b144b7s_media_attributes" => "s_media_attributes" ":translation6823059b144b9fallbacks_media_attributes" => "s_media_attributes" ":translation6823059b144bbproductStream" => "productStream" ":translation6823059b144bcfallbackproductStream" => "productStream" ":translation6823059b144becategory" => "category" ":translation6823059b144bffallbackcategory" => "category" ] |
0.0012 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:21 [ 0 => 44 1 => "16" 2 => "9" 3 => "3" 4 => 15 5 => 16 6 => 17 7 => 40 8 => 41 9 => 42 10 => 43 11 => 44 12 => 3 13 => 5 14 => 7 15 => 8 16 => 9 17 => 10 18 => 11 19 => 81 20 => 12 ] ] |
0.0003 ms |
SELECT shop.id as __shop_id, shop.main_id as __shop_main_id, shop.name as __shop_name, shop.title as __shop_title, shop.position as __shop_position, shop.host as __shop_host, shop.base_path as __shop_base_path, shop.base_url as __shop_base_url, shop.hosts as __shop_hosts, shop.secure as __shop_secure, shop.template_id as __shop_template_id, shop.document_template_id as __shop_document_template_id, shop.category_id as __shop_category_id, shop.locale_id as __shop_locale_id, shop.currency_id as __shop_currency_id, shop.customer_group_id as __shop_customer_group_id, shop.fallback_id as __shop_fallback_id, shop.customer_scope as __shop_customer_scope, shop.default as __shop_default, shop.active as __shop_active, shopAttribute.id as __shopAttribute_id, shopAttribute.shopID as __shopAttribute_shopID, currency.id as __currency_id, currency.currency as __currency_currency, currency.name as __currency_name, currency.standard as __currency_standard, currency.factor as __currency_factor, currency.templatechar as __currency_templatechar, currency.symbol_position as __currency_symbol_position, currency.position as __currency_position, template.id as __template_id, template.template as __template_template, template.name as __template_name, template.description as __template_description, template.author as __template_author, template.license as __template_license, template.esi as __template_esi, template.style_support as __template_style_support, template.emotion as __template_emotion, template.version as __template_version, template.plugin_id as __template_plugin_id, template.parent_id as __template_parent_id, locale.id as __locale_id, locale.locale as __locale_locale, locale.language as __locale_language, locale.territory as __locale_territory, customerGroup.id as __customerGroup_id, customerGroup.groupkey as __customerGroup_groupkey, customerGroup.description as __customerGroup_description, customerGroup.tax as __customerGroup_tax, customerGroup.taxinput as __customerGroup_taxinput, customerGroup.mode as __customerGroup_mode, customerGroup.discount as __customerGroup_discount, customerGroup.minimumorder as __customerGroup_minimumorder, customerGroup.minimumordersurcharge as __customerGroup_minimumordersurcharge, customerGroupAttribute.id as __customerGroupAttribute_id, customerGroupAttribute.customerGroupID as __customerGroupAttribute_customerGroupID, category.id as __category_id, category.parent as __category_parent_id, category.position as __category_position, category.path as __category_path, category.description as __category_description, category.meta_title as __category_metatitle, category.metakeywords as __category_metakeywords, category.metadescription as __category_metadescription, category.cmsheadline as __category_cmsheadline, category.product_box_layout as __category_product_box_layout, category.cmstext as __category_cmstext, category.template as __category_template, category.blog as __category_blog, category.external as __category_external, category.external_target as __category_external_target, category.hidefilter as __category_hidefilter, category.hidetop as __category_hidetop, category.stream_id as __category_stream_id, category.hide_sortings as __category_hide_sortings, categoryAttribute.id as __categoryAttribute_id, categoryAttribute.categoryID as __categoryAttribute_categoryID, categoryAttribute.attribute1 as __categoryAttribute_attribute1, categoryAttribute.attribute2 as __categoryAttribute_attribute2, categoryAttribute.attribute3 as __categoryAttribute_attribute3, categoryAttribute.attribute4 as __categoryAttribute_attribute4, categoryAttribute.attribute5 as __categoryAttribute_attribute5, categoryAttribute.attribute6 as __categoryAttribute_attribute6, 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.0002 ms |
SELECT shop.id as __shop_id, shop.main_id as __shop_main_id, shop.name as __shop_name, shop.title as __shop_title, shop.position as __shop_position, shop.host as __shop_host, shop.base_path as __shop_base_path, shop.base_url as __shop_base_url, shop.hosts as __shop_hosts, shop.secure as __shop_secure, shop.template_id as __shop_template_id, shop.document_template_id as __shop_document_template_id, shop.category_id as __shop_category_id, shop.locale_id as __shop_locale_id, shop.currency_id as __shop_currency_id, shop.customer_group_id as __shop_customer_group_id, shop.fallback_id as __shop_fallback_id, shop.customer_scope as __shop_customer_scope, shop.default as __shop_default, shop.active as __shop_active, shopAttribute.id as __shopAttribute_id, shopAttribute.shopID as __shopAttribute_shopID, currency.id as __currency_id, currency.currency as __currency_currency, currency.name as __currency_name, currency.standard as __currency_standard, currency.factor as __currency_factor, currency.templatechar as __currency_templatechar, currency.symbol_position as __currency_symbol_position, currency.position as __currency_position, template.id as __template_id, template.template as __template_template, template.name as __template_name, template.description as __template_description, template.author as __template_author, template.license as __template_license, template.esi as __template_esi, template.style_support as __template_style_support, template.emotion as __template_emotion, template.version as __template_version, template.plugin_id as __template_plugin_id, template.parent_id as __template_parent_id, locale.id as __locale_id, locale.locale as __locale_locale, locale.language as __locale_language, locale.territory as __locale_territory, customerGroup.id as __customerGroup_id, customerGroup.groupkey as __customerGroup_groupkey, customerGroup.description as __customerGroup_description, customerGroup.tax as __customerGroup_tax, customerGroup.taxinput as __customerGroup_taxinput, customerGroup.mode as __customerGroup_mode, customerGroup.discount as __customerGroup_discount, customerGroup.minimumorder as __customerGroup_minimumorder, customerGroup.minimumordersurcharge as __customerGroup_minimumordersurcharge, customerGroupAttribute.id as __customerGroupAttribute_id, customerGroupAttribute.customerGroupID as __customerGroupAttribute_customerGroupID, category.id as __category_id, category.parent as __category_parent_id, category.position as __category_position, category.path as __category_path, category.description as __category_description, category.meta_title as __category_metatitle, category.metakeywords as __category_metakeywords, category.metadescription as __category_metadescription, category.cmsheadline as __category_cmsheadline, category.product_box_layout as __category_product_box_layout, category.cmstext as __category_cmstext, category.template as __category_template, category.blog as __category_blog, category.external as __category_external, category.external_target as __category_external_target, category.hidefilter as __category_hidefilter, category.hidetop as __category_hidetop, category.stream_id as __category_stream_id, category.hide_sortings as __category_hide_sortings, categoryAttribute.id as __categoryAttribute_id, categoryAttribute.categoryID as __categoryAttribute_categoryID, categoryAttribute.attribute1 as __categoryAttribute_attribute1, categoryAttribute.attribute2 as __categoryAttribute_attribute2, categoryAttribute.attribute3 as __categoryAttribute_attribute3, categoryAttribute.attribute4 as __categoryAttribute_attribute4, categoryAttribute.attribute5 as __categoryAttribute_attribute5, categoryAttribute.attribute6 as __categoryAttribute_attribute6, 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.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 page.id, page.description, page.link, page.target, page.parentID, groups.key as `group`, mapping.key as mapping, translation6823059b1510fpage.objectdata as __page_translation, translation6823059b15113fallbackpage.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 translation6823059b1510fpage ON translation6823059b1510fpage.objecttype = : translation6823059b1510fpage AND translation6823059b1510fpage.objectkey = page.id AND translation6823059b1510fpage.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b15113fallbackpage ON translation6823059b15113fallbackpage.objecttype = : translation6823059b15113fallbackpage AND translation6823059b15113fallbackpage.objectkey = page.id AND translation6823059b15113fallbackpage.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 ":translation6823059b1510fpage" => "page" ":languagefallback" => 0 ":translation6823059b15113fallbackpage" => "page" ":shopId" => 3 ":staticShopId" => "%|3|%" ] |
0.0006 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=20" ] ] |
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=20" ] ] |
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=20" ] ] |
0.0001 ms |
SELECT s_core_config_values.value FROM s_core_config_values INNER JOIN s_core_config_elements ON s_core_config_values.element_id = s_core_config_elements.id AND s_core_config_elements.`name` LIKE 'assetTimestamp' WHERE s_core_config_values.shop_id = : shopId |
array:1 [ "shopId" => 1 ] |
0.0002 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.0015 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.0002 ms |
SELECT template.id, template.id, template.template, template.plugin_id, template.parent_id, plugin.name as plugin_name, plugin.namespace as plugin_namespace, plugin.source as plugin_source FROM s_core_templates template LEFT JOIN s_core_plugins plugin ON plugin.id = template.plugin_id |
[] |
0.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.0002 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=detail&sArticle=20" ] ] |
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.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=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.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=1" ] ] |
0.0002 ms |
SELECT org_path, path FROM s_core_rewrite_urls WHERE subshopID =: shopId AND org_path IN (: orgPath) AND main = 1 ORDER BY id DESC |
array:2 [ ":shopId" => 3 ":orgPath" => array:1 [ 0 => "sViewport=detail&sArticle=20" ] ] |
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 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, translation6823059b2924barticle.objectdata as __product_translation, translation6823059b2924efallbackarticle.objectdata as __product_translation_fallback, translation6823059b29251variant.objectdata as __variant_translation, translation6823059b29252fallbackvariant.objectdata as __variant_translation_fallback, translation6823059b29254supplier.objectdata as __manufacturer_translation, translation6823059b29256fallbacksupplier.objectdata as __manufacturer_translation_fallback, translation6823059b29258config_units.objectdata as __unit_translation, translation6823059b29259fallbackconfig_units.objectdata as __unit_translation_fallback, translation6823059b2925bs_articles_esd_attributes.objectdata as __esdAttribute_translation, translation6823059b2925cfallbacks_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 translation6823059b29251variant ON translation6823059b29251variant.objecttype = : translation6823059b29251variant AND translation6823059b29251variant.objectkey = variant.id AND translation6823059b29251variant.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b29252fallbackvariant ON translation6823059b29252fallbackvariant.objecttype = : translation6823059b29252fallbackvariant AND translation6823059b29252fallbackvariant.objectkey = variant.id AND translation6823059b29252fallbackvariant.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 translation6823059b2924barticle ON translation6823059b2924barticle.objecttype = : translation6823059b2924barticle AND translation6823059b2924barticle.objectkey = product.id AND translation6823059b2924barticle.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2924efallbackarticle ON translation6823059b2924efallbackarticle.objecttype = : translation6823059b2924efallbackarticle AND translation6823059b2924efallbackarticle.objectkey = product.id AND translation6823059b2924efallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img LEFT JOIN s_core_translations translation6823059b29254supplier ON translation6823059b29254supplier.objecttype = : translation6823059b29254supplier AND translation6823059b29254supplier.objectkey = manufacturer.id AND translation6823059b29254supplier.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b29256fallbacksupplier ON translation6823059b29256fallbacksupplier.objecttype = : translation6823059b29256fallbacksupplier AND translation6823059b29256fallbacksupplier.objectkey = manufacturer.id AND translation6823059b29256fallbacksupplier.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b29258config_units ON translation6823059b29258config_units.objecttype = : translation6823059b29258config_units AND translation6823059b29258config_units.objectkey = 1 AND translation6823059b29258config_units.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b29259fallbackconfig_units ON translation6823059b29259fallbackconfig_units.objecttype = : translation6823059b29259fallbackconfig_units AND translation6823059b29259fallbackconfig_units.objectkey = 1 AND translation6823059b29259fallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id LEFT JOIN s_core_translations translation6823059b2925bs_articles_esd_attributes ON translation6823059b2925bs_articles_esd_attributes.objecttype = : translation6823059b2925bs_articles_esd_attributes AND translation6823059b2925bs_articles_esd_attributes.objectkey = esd.id AND translation6823059b2925bs_articles_esd_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2925cfallbacks_articles_esd_attributes ON translation6823059b2925cfallbacks_articles_esd_attributes.objecttype = : translation6823059b2925cfallbacks_articles_esd_attributes AND translation6823059b2925cfallbacks_articles_esd_attributes.objectkey = esd.id AND translation6823059b2925cfallbacks_articles_esd_attributes.objectlanguage = : languagefallback WHERE ( variant.ordernumber IN (: numbers) ) AND (variant.active = 1) AND (product.active = 1) |
array:14 [ ":fallback" => "EK" ":numbers" => array:25 [ 0 => 10021 1 => 10001 2 => 10027 3 => 10019 4 => 10016 5 => 10015 6 => 10014 7 => 10013 8 => 10002 9 => 10031 10 => 10030 11 => 10029 12 => 10028 13 => 10026 14 => 10025 15 => 10024 16 => 10023 17 => 10022 18 => 10018 19 => 10012 20 => 10010 21 => 10009 22 => 10006 23 => 10005 24 => 10003 ] ":language" => 3 ":translation6823059b2924barticle" => "article" ":languagefallback" => 0 ":translation6823059b2924efallbackarticle" => "article" ":translation6823059b29251variant" => "variant" ":translation6823059b29252fallbackvariant" => "variant" ":translation6823059b29254supplier" => "supplier" ":translation6823059b29256fallbacksupplier" => "supplier" ":translation6823059b29258config_units" => "config_units" ":translation6823059b29259fallbackconfig_units" => "config_units" ":translation6823059b2925bs_articles_esd_attributes" => "s_articles_esd_attributes" ":translation6823059b2925cfallbacks_articles_esd_attributes" => "s_articles_esd_attributes" ] |
0.0058 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, translation6823059b2ac97articleimage.objectdata as __image_translation, translation6823059b2ac9bfallbackarticleimage.objectdata as __image_translation_fallback, translation6823059b2ac9es_media_attributes.objectdata as __mediaAttribute_translation, translation6823059b2aca0fallbacks_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 translation6823059b2ac97articleimage ON translation6823059b2ac97articleimage.objecttype = : translation6823059b2ac97articleimage AND translation6823059b2ac97articleimage.objectkey = image.id AND translation6823059b2ac97articleimage.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2ac9bfallbackarticleimage ON translation6823059b2ac9bfallbackarticleimage.objecttype = : translation6823059b2ac9bfallbackarticleimage AND translation6823059b2ac9bfallbackarticleimage.objectkey = image.id AND translation6823059b2ac9bfallbackarticleimage.objectlanguage = : languagefallback INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_core_translations translation6823059b2ac9es_media_attributes ON translation6823059b2ac9es_media_attributes.objecttype = : translation6823059b2ac9es_media_attributes AND translation6823059b2ac9es_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b2ac9es_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2aca0fallbacks_media_attributes ON translation6823059b2aca0fallbacks_media_attributes.objecttype = : translation6823059b2aca0fallbacks_media_attributes AND translation6823059b2aca0fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b2aca0fallbacks_media_attributes.objectlanguage = : languagefallback WHERE childImage.article_detail_id IN (: products) ORDER BY image.main ASC, image.position ASC |
array:7 [ ":language" => 3 ":translation6823059b2ac97articleimage" => "articleimage" ":languagefallback" => 0 ":translation6823059b2ac9bfallbackarticleimage" => "articleimage" ":translation6823059b2ac9es_media_attributes" => "s_media_attributes" ":translation6823059b2aca0fallbacks_media_attributes" => "s_media_attributes" ":products" => array:25 [ 0 => 1 1 => 13 2 => 14 3 => 19 4 => 20 5 => 26 6 => 27 7 => 31 8 => 34 9 => 43 10 => 44 11 => 45 12 => 47 13 => 48 14 => 50 15 => 51 16 => 52 17 => 53 18 => 62 19 => 65 20 => 66 21 => 67 22 => 72 23 => 73 24 => 74 ] ] |
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, translation6823059b2b00carticleimage.objectdata as __image_translation, translation6823059b2b010fallbackarticleimage.objectdata as __image_translation_fallback, translation6823059b2b012s_media_attributes.objectdata as __mediaAttribute_translation, translation6823059b2b014fallbacks_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 translation6823059b2b00carticleimage ON translation6823059b2b00carticleimage.objecttype = : translation6823059b2b00carticleimage AND translation6823059b2b00carticleimage.objectkey = image.id AND translation6823059b2b00carticleimage.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2b010fallbackarticleimage ON translation6823059b2b010fallbackarticleimage.objecttype = : translation6823059b2b010fallbackarticleimage AND translation6823059b2b010fallbackarticleimage.objectkey = image.id AND translation6823059b2b010fallbackarticleimage.objectlanguage = : languagefallback INNER JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_core_translations translation6823059b2b012s_media_attributes ON translation6823059b2b012s_media_attributes.objecttype = : translation6823059b2b012s_media_attributes AND translation6823059b2b012s_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b2b012s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2b014fallbacks_media_attributes ON translation6823059b2b014fallbacks_media_attributes.objecttype = : translation6823059b2b014fallbacks_media_attributes AND translation6823059b2b014fallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b2b014fallbacks_media_attributes.objectlanguage = : languagefallback WHERE (image.main = 1) AND ( image.articleID IN (: products) ) |
array:7 [ ":language" => 3 ":translation6823059b2b00carticleimage" => "articleimage" ":languagefallback" => 0 ":translation6823059b2b010fallbackarticleimage" => "articleimage" ":translation6823059b2b012s_media_attributes" => "s_media_attributes" ":translation6823059b2b014fallbacks_media_attributes" => "s_media_attributes" ":products" => array:25 [ 0 => 1 1 => 2 2 => 3 3 => 5 4 => 6 5 => 9 6 => 10 7 => 12 8 => 13 9 => 14 10 => 15 11 => 16 12 => 18 13 => 19 14 => 21 15 => 22 16 => 23 17 => 24 18 => 25 19 => 26 20 => 27 21 => 28 22 => 29 23 => 30 24 => 31 ] ] |
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, translation6823059b2b680s_articles_prices_attributes.objectdata as __priceAttribute_translation, translation6823059b2b684fallbacks_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 translation6823059b2b680s_articles_prices_attributes ON translation6823059b2b680s_articles_prices_attributes.objecttype = : translation6823059b2b680s_articles_prices_attributes AND translation6823059b2b680s_articles_prices_attributes.objectkey = price.id AND translation6823059b2b680s_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2b684fallbacks_articles_prices_attributes ON translation6823059b2b684fallbacks_articles_prices_attributes.objecttype = : translation6823059b2b684fallbacks_articles_prices_attributes AND translation6823059b2b684fallbacks_articles_prices_attributes.objectkey = price.id AND translation6823059b2b684fallbacks_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:25 [ 0 => 1 1 => 13 2 => 14 3 => 19 4 => 20 5 => 26 6 => 27 7 => 31 8 => 34 9 => 43 10 => 44 11 => 45 12 => 47 13 => 48 14 => 50 15 => 51 16 => 52 17 => 53 18 => 62 19 => 65 20 => 66 21 => 67 22 => 72 23 => 73 24 => 74 ] ":customerGroup" => "EK" ":language" => 3 ":translation6823059b2b680s_articles_prices_attributes" => "s_articles_prices_attributes" ":languagefallback" => 0 ":translation6823059b2b684fallbacks_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:25 [ 0 => 1 1 => 2 2 => 3 3 => 5 4 => 6 5 => 9 6 => 10 7 => 12 8 => 13 9 => 14 10 => 15 11 => 16 12 => 18 13 => 19 14 => 21 15 => 22 16 => 23 17 => 24 18 => 25 19 => 26 20 => 27 21 => 28 22 => 29 23 => 30 24 => 31 ] ":priceGroupCustomerGroup" => 1 ] |
0.0007 ms |
SELECT price.id as __price_id, price.pricegroup as __price_pricegroup, price.from as __price_from, price.to as __price_to, price.articleID as __price_articleID, price.articledetailsID as __price_articledetailsID, price.price as __price_price, price.pseudoprice as __price_pseudoprice, price.percent as __price_percent, priceAttribute.id as __priceAttribute_id, priceAttribute.priceID as __priceAttribute_priceID, unit.id as __unit_id, unit.description as __unit_description, unit.unit as __unit_unit, variant.packunit as __unit_packunit, variant.purchaseunit as __unit_purchaseunit, variant.referenceunit as __unit_referenceunit, variant.purchasesteps as __unit_purchasesteps, variant.minpurchase as __unit_minpurchase, variant.maxpurchase as __unit_maxpurchase, translation6823059b2bc61config_units.objectdata as __unit_translation, translation6823059b2bc65fallbackconfig_units.objectdata as __unit_translation_fallback, translation6823059b2bc68article.objectdata as __product_translation, translation6823059b2bc6afallbackarticle.objectdata as __product_translation_fallback, translation6823059b2bc6cvariant.objectdata as __variant_translation, translation6823059b2bc6dfallbackvariant.objectdata as __variant_translation_fallback, translation6823059b2bc6es_articles_prices_attributes.objectdata as __priceAttribute_translation, translation6823059b2bc70fallbacks_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 translation6823059b2bc6cvariant ON translation6823059b2bc6cvariant.objecttype = : translation6823059b2bc6cvariant AND translation6823059b2bc6cvariant.objectkey = variant.id AND translation6823059b2bc6cvariant.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2bc6dfallbackvariant ON translation6823059b2bc6dfallbackvariant.objecttype = : translation6823059b2bc6dfallbackvariant AND translation6823059b2bc6dfallbackvariant.objectkey = variant.id AND translation6823059b2bc6dfallbackvariant.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b2bc68article ON translation6823059b2bc68article.objecttype = : translation6823059b2bc68article AND translation6823059b2bc68article.objectkey = product.id AND translation6823059b2bc68article.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2bc6afallbackarticle ON translation6823059b2bc6afallbackarticle.objecttype = : translation6823059b2bc6afallbackarticle AND translation6823059b2bc6afallbackarticle.objectkey = product.id AND translation6823059b2bc6afallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b2bc61config_units ON translation6823059b2bc61config_units.objecttype = : translation6823059b2bc61config_units AND translation6823059b2bc61config_units.objectkey = 1 AND translation6823059b2bc61config_units.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2bc65fallbackconfig_units ON translation6823059b2bc65fallbackconfig_units.objecttype = : translation6823059b2bc65fallbackconfig_units AND translation6823059b2bc65fallbackconfig_units.objectkey = 1 AND translation6823059b2bc65fallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b2bc6es_articles_prices_attributes ON translation6823059b2bc6es_articles_prices_attributes.objecttype = : translation6823059b2bc6es_articles_prices_attributes AND translation6823059b2bc6es_articles_prices_attributes.objectkey = price.id AND translation6823059b2bc6es_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2bc70fallbacks_articles_prices_attributes ON translation6823059b2bc70fallbacks_articles_prices_attributes.objecttype = : translation6823059b2bc70fallbacks_articles_prices_attributes AND translation6823059b2bc70fallbacks_articles_prices_attributes.objectkey = price.id AND translation6823059b2bc70fallbacks_articles_prices_attributes.objectlanguage = : languagefallback WHERE price.id IN (: ids) |
array:11 [ ":ids" => array:23 [ 0 => "2" 1 => "14" 2 => "16" 3 => "23" 4 => "37" 5 => "43" 6 => "54" 7 => "69" 8 => "101" 9 => "102" 10 => "103" 11 => "105" 12 => "106" 13 => "108" 14 => "112" 15 => "113" 16 => "125" 17 => "129" 18 => "132" 19 => "133" 20 => "138" 21 => "158" 22 => "159" ] ":language" => 3 ":translation6823059b2bc61config_units" => "config_units" ":languagefallback" => 0 ":translation6823059b2bc65fallbackconfig_units" => "config_units" ":translation6823059b2bc68article" => "article" ":translation6823059b2bc6afallbackarticle" => "article" ":translation6823059b2bc6cvariant" => "variant" ":translation6823059b2bc6dfallbackvariant" => "variant" ":translation6823059b2bc6es_articles_prices_attributes" => "s_articles_prices_attributes" ":translation6823059b2bc70fallbacks_articles_prices_attributes" => "s_articles_prices_attributes" ] |
0.0008 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:2 [ 0 => 5 1 => 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, translation6823059b2c19econfig_units.objectdata as __unit_translation, translation6823059b2c1a2fallbackconfig_units.objectdata as __unit_translation_fallback, translation6823059b2c1a4article.objectdata as __product_translation, translation6823059b2c1a6fallbackarticle.objectdata as __product_translation_fallback, translation6823059b2c1a8variant.objectdata as __variant_translation, translation6823059b2c1a9fallbackvariant.objectdata as __variant_translation_fallback, translation6823059b2c1aas_articles_prices_attributes.objectdata as __priceAttribute_translation, translation6823059b2c1acfallbacks_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 translation6823059b2c1a8variant ON translation6823059b2c1a8variant.objecttype = : translation6823059b2c1a8variant AND translation6823059b2c1a8variant.objectkey = variant.id AND translation6823059b2c1a8variant.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2c1a9fallbackvariant ON translation6823059b2c1a9fallbackvariant.objecttype = : translation6823059b2c1a9fallbackvariant AND translation6823059b2c1a9fallbackvariant.objectkey = variant.id AND translation6823059b2c1a9fallbackvariant.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b2c1a4article ON translation6823059b2c1a4article.objecttype = : translation6823059b2c1a4article AND translation6823059b2c1a4article.objectkey = product.id AND translation6823059b2c1a4article.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2c1a6fallbackarticle ON translation6823059b2c1a6fallbackarticle.objecttype = : translation6823059b2c1a6fallbackarticle AND translation6823059b2c1a6fallbackarticle.objectkey = product.id AND translation6823059b2c1a6fallbackarticle.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b2c19econfig_units ON translation6823059b2c19econfig_units.objecttype = : translation6823059b2c19econfig_units AND translation6823059b2c19econfig_units.objectkey = 1 AND translation6823059b2c19econfig_units.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2c1a2fallbackconfig_units ON translation6823059b2c1a2fallbackconfig_units.objecttype = : translation6823059b2c1a2fallbackconfig_units AND translation6823059b2c1a2fallbackconfig_units.objectkey = 1 AND translation6823059b2c1a2fallbackconfig_units.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b2c1aas_articles_prices_attributes ON translation6823059b2c1aas_articles_prices_attributes.objecttype = : translation6823059b2c1aas_articles_prices_attributes AND translation6823059b2c1aas_articles_prices_attributes.objectkey = price.id AND translation6823059b2c1aas_articles_prices_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2c1acfallbacks_articles_prices_attributes ON translation6823059b2c1acfallbacks_articles_prices_attributes.objecttype = : translation6823059b2c1acfallbacks_articles_prices_attributes AND translation6823059b2c1acfallbacks_articles_prices_attributes.objectkey = price.id AND translation6823059b2c1acfallbacks_articles_prices_attributes.objectlanguage = : languagefallback WHERE price.id IN (: ids) |
array:11 [ ":ids" => [] ":language" => 3 ":translation6823059b2c19econfig_units" => "config_units" ":languagefallback" => 0 ":translation6823059b2c1a2fallbackconfig_units" => "config_units" ":translation6823059b2c1a4article" => "article" ":translation6823059b2c1a6fallbackarticle" => "article" ":translation6823059b2c1a8variant" => "variant" ":translation6823059b2c1a9fallbackvariant" => "variant" ":translation6823059b2c1aas_articles_prices_attributes" => "s_articles_prices_attributes" ":translation6823059b2c1acfallbacks_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:25 [ 0 => 1 1 => 2 2 => 3 3 => 5 4 => 6 5 => 9 6 => 10 7 => 12 8 => 13 9 => 14 10 => 15 11 => 16 12 => 18 13 => 19 14 => 21 15 => 22 16 => 23 17 => 24 18 => 25 19 => 26 20 => 27 21 => 28 22 => 29 23 => 30 24 => 31 ] ] |
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:25 [ 0 => 1 1 => 2 2 => 3 3 => 5 4 => 6 5 => 9 6 => 10 7 => 12 8 => 13 9 => 14 10 => 15 11 => 16 12 => 18 13 => 19 14 => 21 15 => 22 16 => 23 17 => 24 18 => 25 19 => 26 20 => 27 21 => 28 22 => 29 23 => 30 24 => 31 ] ] |
0.0009 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, translation6823059b2c8c3s_categories_attributes.objectdata as __categoryAttribute_translation, translation6823059b2c8c7fallbacks_categories_attributes.objectdata as __categoryAttribute_translation_fallback, translation6823059b2c8c9s_media_attributes.objectdata as __mediaAttribute_translation, translation6823059b2c8cbfallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback, translation6823059b2c8cdproductStream.objectdata as __stream_translation, translation6823059b2c8cffallbackproductStream.objectdata as __stream_translation_fallback, translation6823059b2c8d1category.objectdata as __category_translation, translation6823059b2c8d2fallbackcategory.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 translation6823059b2c8d1category ON translation6823059b2c8d1category.objecttype = : translation6823059b2c8d1category AND translation6823059b2c8d1category.objectkey = category.id AND translation6823059b2c8d1category.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2c8d2fallbackcategory ON translation6823059b2c8d2fallbackcategory.objecttype = : translation6823059b2c8d2fallbackcategory AND translation6823059b2c8d2fallbackcategory.objectkey = category.id AND translation6823059b2c8d2fallbackcategory.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation6823059b2c8c3s_categories_attributes ON translation6823059b2c8c3s_categories_attributes.objecttype = : translation6823059b2c8c3s_categories_attributes AND translation6823059b2c8c3s_categories_attributes.objectkey = category.id AND translation6823059b2c8c3s_categories_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2c8c7fallbacks_categories_attributes ON translation6823059b2c8c7fallbacks_categories_attributes.objecttype = : translation6823059b2c8c7fallbacks_categories_attributes AND translation6823059b2c8c7fallbacks_categories_attributes.objectkey = category.id AND translation6823059b2c8c7fallbacks_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 translation6823059b2c8c9s_media_attributes ON translation6823059b2c8c9s_media_attributes.objecttype = : translation6823059b2c8c9s_media_attributes AND translation6823059b2c8c9s_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b2c8c9s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2c8cbfallbacks_media_attributes ON translation6823059b2c8cbfallbacks_media_attributes.objecttype = : translation6823059b2c8cbfallbacks_media_attributes AND translation6823059b2c8cbfallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b2c8cbfallbacks_media_attributes.objectlanguage = : languagefallback LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId LEFT JOIN s_core_translations translation6823059b2c8cdproductStream ON translation6823059b2c8cdproductStream.objecttype = : translation6823059b2c8cdproductStream AND translation6823059b2c8cdproductStream.objectkey = stream.id AND translation6823059b2c8cdproductStream.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2c8cffallbackproductStream ON translation6823059b2c8cffallbackproductStream.objecttype = : translation6823059b2c8cffallbackproductStream AND translation6823059b2c8cffallbackproductStream.objectkey = stream.id AND translation6823059b2c8cffallbackproductStream.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" 115 => "9" 116 => "15" 117 => "16" 118 => "17" 119 => "35" 120 => "36" 121 => "37" 122 => "38" 123 => "39" 124 => "40" 125 => "41" 126 => "42" 127 => "43" 128 => "44" 129 => "45" 130 => "46" 131 => "47" 132 => "48" 133 => "49" 291 => "10" 292 => "18" 293 => "19" 294 => "20" 295 => "21" 296 => "50" 297 => "51" 298 => "52" 299 => "53" 300 => "54" 301 => "55" 302 => "56" 303 => "57" 304 => "58" 305 => "59" 306 => "60" 307 => "61" 308 => "62" 309 => "63" 310 => "76" 311 => "77" 312 => "78" 313 => "79" 314 => "80" ] ":shopId" => "%|3|%" ":language" => 3 ":translation6823059b2c8c3s_categories_attributes" => "s_categories_attributes" ":languagefallback" => 0 ":translation6823059b2c8c7fallbacks_categories_attributes" => "s_categories_attributes" ":translation6823059b2c8c9s_media_attributes" => "s_media_attributes" ":translation6823059b2c8cbfallbacks_media_attributes" => "s_media_attributes" ":translation6823059b2c8cdproductStream" => "productStream" ":translation6823059b2c8cffallbackproductStream" => "productStream" ":translation6823059b2c8d1category" => "category" ":translation6823059b2c8d2fallbackcategory" => "category" ] |
0.0014 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, translation6823059b2d029s_media_attributes.objectdata as __mediaAttribute_translation, translation6823059b2d02dfallbacks_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 translation6823059b2d029s_media_attributes ON translation6823059b2d029s_media_attributes.objecttype = : translation6823059b2d029s_media_attributes AND translation6823059b2d029s_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b2d029s_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation6823059b2d02dfallbacks_media_attributes ON translation6823059b2d02dfallbacks_media_attributes.objecttype = : translation6823059b2d02dfallbacks_media_attributes AND translation6823059b2d02dfallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation6823059b2d02dfallbacks_media_attributes.objectlanguage = : languagefallback WHERE media.id IN (: ids) |
array:5 [ ":language" => 3 ":translation6823059b2d029s_media_attributes" => "s_media_attributes" ":languagefallback" => 0 ":translation6823059b2d02dfallbacks_media_attributes" => "s_media_attributes" ":ids" => array:17 [ 10001 => 2 10002 => 2 10003 => 2 10005 => 2 10009 => 2 10010 => 2 10012 => 2 10013 => 2 10014 => 2 10015 => 2 10018 => 2 10019 => 2 10021 => 2 10022 => 2 10028 => 2 10030 => 2 10031 => 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.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:50 [ 0 => "sViewport=detail&sArticle=21" 1 => "sViewport=detail&sArticle=21" 2 => "sViewport=detail&sArticle=1" 3 => "sViewport=detail&sArticle=1" 4 => "sViewport=detail&sArticle=27" 5 => "sViewport=detail&sArticle=27" 6 => "sViewport=detail&sArticle=19" 7 => "sViewport=detail&sArticle=19" 8 => "sViewport=detail&sArticle=16" 9 => "sViewport=detail&sArticle=16" 10 => "sViewport=detail&sArticle=15" 11 => "sViewport=detail&sArticle=15" 12 => "sViewport=detail&sArticle=14" 13 => "sViewport=detail&sArticle=14" 14 => "sViewport=detail&sArticle=13" 15 => "sViewport=detail&sArticle=13" 16 => "sViewport=detail&sArticle=2" 17 => "sViewport=detail&sArticle=2" 18 => "sViewport=detail&sArticle=31" 19 => "sViewport=detail&sArticle=31" 20 => "sViewport=detail&sArticle=30" 21 => "sViewport=detail&sArticle=30" 22 => "sViewport=detail&sArticle=29" 23 => "sViewport=detail&sArticle=29" 24 => "sViewport=detail&sArticle=28" 25 => "sViewport=detail&sArticle=28" 26 => "sViewport=detail&sArticle=26" 27 => "sViewport=detail&sArticle=26" 28 => "sViewport=detail&sArticle=25" 29 => "sViewport=detail&sArticle=25" 30 => "sViewport=detail&sArticle=24" 31 => "sViewport=detail&sArticle=24" 32 => "sViewport=detail&sArticle=23" 33 => "sViewport=detail&sArticle=23" 34 => "sViewport=detail&sArticle=22" 35 => "sViewport=detail&sArticle=22" 36 => "sViewport=detail&sArticle=18" 37 => "sViewport=detail&sArticle=18" 38 => "sViewport=detail&sArticle=12" 39 => "sViewport=detail&sArticle=12" 40 => "sViewport=detail&sArticle=10" 41 => "sViewport=detail&sArticle=10" 42 => "sViewport=detail&sArticle=9" 43 => "sViewport=detail&sArticle=9" 44 => "sViewport=detail&sArticle=6" 45 => "sViewport=detail&sArticle=6" 46 => "sViewport=detail&sArticle=5" 47 => "sViewport=detail&sArticle=5" 48 => "sViewport=detail&sArticle=3" 49 => "sViewport=detail&sArticle=3" ] ] |
0.0007 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:95 [ 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=44" 73 => "sViewport=cat&sCategory=9" 74 => "sViewport=cat&sCategory=9" 75 => "sViewport=cat&sCategory=16" 76 => "sViewport=cat&sCategory=16" 77 => "sViewport=cat&sCategory=44" 78 => "sViewport=cat&sCategory=44" 79 => "sViewport=cat&sCategory=5" 80 => "sViewport=cat&sCategory=7" 81 => "sViewport=cat&sCategory=8" 82 => "sViewport=cat&sCategory=9" 83 => "sViewport=cat&sCategory=15" 84 => "sViewport=cat&sCategory=16" 85 => "sViewport=cat&sCategory=40" 86 => "sViewport=cat&sCategory=41" 87 => "sViewport=cat&sCategory=42" 88 => "sViewport=cat&sCategory=43" 89 => "sViewport=cat&sCategory=44" 90 => "sViewport=cat&sCategory=17" 91 => "sViewport=cat&sCategory=10" 92 => "sViewport=cat&sCategory=11" 93 => "sViewport=blog&sCategory=81" 94 => "sViewport=cat&sCategory=12" ] ] |
0.0010 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.1998 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.1090 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.1800 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 => 20 ] |
0.1540 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.0250 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.0200 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.0181 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.0169 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.0448 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.0448 ms |
SELECT * FROM s_order_comparisons WHERE sessionID = ? |
array:1 [ 1 => "f136fed5db6f997261148f25c6b1f94e" ] |
0.8059 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 => "f136fed5db6f997261148f25c6b1f94e" 2 => 0 ] |
0.4818 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 (20) ORDER BY alsoBought.sales DESC, alsoBought.related_article_id DESC LIMIT 40 |
array:3 [ ":articleId" => 20 ":categoryId" => 3 ":customerGroupId" => 1 ] |
0.5920 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 (20, 20) GROUP BY similarShown.viewed, similarShown.related_article_id ORDER BY similarShown.viewed DESC, similarShown.related_article_id DESC LIMIT 40 |
array:3 [ ":articleId" => 20 ":categoryId" => 3 ":customerGroupId" => 1 ] |
0.8690 ms |