Queries
88
Total Queries
0.0096 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" => "account/payment" ] |
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.0001 ms |
SELECT shop.id as __shop_id, shop.main_id as __shop_main_id, shop.name as __shop_name, shop.title as __shop_title, shop.position as __shop_position, shop.host as __shop_host, shop.base_path as __shop_base_path, shop.base_url as __shop_base_url, shop.hosts as __shop_hosts, shop.secure as __shop_secure, shop.template_id as __shop_template_id, shop.document_template_id as __shop_document_template_id, shop.category_id as __shop_category_id, shop.locale_id as __shop_locale_id, shop.currency_id as __shop_currency_id, shop.customer_group_id as __shop_customer_group_id, shop.fallback_id as __shop_fallback_id, shop.customer_scope as __shop_customer_scope, shop.default as __shop_default, shop.active as __shop_active, shopAttribute.id as __shopAttribute_id, shopAttribute.shopID as __shopAttribute_shopID, currency.id as __currency_id, currency.currency as __currency_currency, currency.name as __currency_name, currency.standard as __currency_standard, currency.factor as __currency_factor, currency.templatechar as __currency_templatechar, currency.symbol_position as __currency_symbol_position, currency.position as __currency_position, template.id as __template_id, template.template as __template_template, template.name as __template_name, template.description as __template_description, template.author as __template_author, template.license as __template_license, template.esi as __template_esi, template.style_support as __template_style_support, template.emotion as __template_emotion, template.version as __template_version, template.plugin_id as __template_plugin_id, template.parent_id as __template_parent_id, locale.id as __locale_id, locale.locale as __locale_locale, locale.language as __locale_language, locale.territory as __locale_territory, customerGroup.id as __customerGroup_id, customerGroup.groupkey as __customerGroup_groupkey, customerGroup.description as __customerGroup_description, customerGroup.tax as __customerGroup_tax, customerGroup.taxinput as __customerGroup_taxinput, customerGroup.mode as __customerGroup_mode, customerGroup.discount as __customerGroup_discount, customerGroup.minimumorder as __customerGroup_minimumorder, customerGroup.minimumordersurcharge as __customerGroup_minimumordersurcharge, customerGroupAttribute.id as __customerGroupAttribute_id, customerGroupAttribute.customerGroupID as __customerGroupAttribute_customerGroupID, category.id as __category_id, category.parent as __category_parent_id, category.position as __category_position, category.path as __category_path, category.description as __category_description, category.meta_title as __category_metatitle, category.metakeywords as __category_metakeywords, category.metadescription as __category_metadescription, category.cmsheadline as __category_cmsheadline, category.product_box_layout as __category_product_box_layout, category.cmstext as __category_cmstext, category.template as __category_template, category.blog as __category_blog, category.external as __category_external, category.external_target as __category_external_target, category.hidefilter as __category_hidefilter, category.hidetop as __category_hidetop, category.stream_id as __category_stream_id, category.hide_sortings as __category_hide_sortings, categoryAttribute.id as __categoryAttribute_id, categoryAttribute.categoryID as __categoryAttribute_categoryID, categoryAttribute.attribute1 as __categoryAttribute_attribute1, categoryAttribute.attribute2 as __categoryAttribute_attribute2, categoryAttribute.attribute3 as __categoryAttribute_attribute3, categoryAttribute.attribute4 as __categoryAttribute_attribute4, categoryAttribute.attribute5 as __categoryAttribute_attribute5, categoryAttribute.attribute6 as __categoryAttribute_attribute6, media.id as __media_id, media.albumID as __media_albumID, media.name as __media_name, media.description as __media_description, media.path as __media_path, media.type as __media_type, media.extension as __media_extension, media.file_size as __media_file_size, media.width as __media_width, media.height as __media_height, media.userID as __media_userID, media.created as __media_created, mediaSettings.id as __mediaSettings_id, mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, mediaSettings.icon as __mediaSettings_icon, mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, mediaAttribute.id as __mediaAttribute_id, mediaAttribute.mediaID as __mediaAttribute_mediaID FROM s_core_shops shop LEFT JOIN s_core_shops_attributes shopAttribute ON shopAttribute.shopID = shop.id LEFT JOIN s_core_currencies currency ON currency.id = shop.currency_id LEFT JOIN s_core_templates template ON shop.template_id = template.id LEFT JOIN s_core_locales locale ON locale.id = shop.locale_id LEFT JOIN s_core_customergroups customerGroup ON customerGroup.id = shop.customer_group_id LEFT JOIN s_categories category ON category.id = shop.category_id LEFT JOIN s_core_customergroups_attributes customerGroupAttribute ON customerGroupAttribute.customerGroupID = customerGroup.id LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id LEFT JOIN s_media media ON media.id = category.mediaID LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id WHERE shop.id IN (: ids) |
array:1 [ ":ids" => array:1 [ 0 => "1" ] ] |
0.0001 ms |
SELECT customerGroup.id as __customerGroup_id, customerGroup.groupkey as __customerGroup_groupkey, customerGroup.description as __customerGroup_description, customerGroup.tax as __customerGroup_tax, customerGroup.taxinput as __customerGroup_taxinput, customerGroup.mode as __customerGroup_mode, customerGroup.discount as __customerGroup_discount, customerGroup.minimumorder as __customerGroup_minimumorder, customerGroup.minimumordersurcharge as __customerGroup_minimumordersurcharge, customerGroupAttribute.id as __customerGroupAttribute_id, customerGroupAttribute.customerGroupID as __customerGroupAttribute_customerGroupID FROM s_core_customergroups customerGroup LEFT JOIN s_core_customergroups_attributes customerGroupAttribute ON customerGroupAttribute.customerGroupID = customerGroup.id WHERE customerGroup.groupkey IN (: keys) |
array:1 [ ":keys" => array:2 [ 0 => "EK" 1 => "EK" ] ] |
0.0001 ms |
SELECT 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 id FROM s_core_locales WHERE locale = "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.0000 ms |
SELECT template.id, template.id, template.template, template.plugin_id, template.parent_id, plugin.name as plugin_name, plugin.namespace as plugin_namespace, plugin.source as plugin_source FROM s_core_templates template LEFT JOIN s_core_plugins plugin ON plugin.id = template.plugin_id |
[] |
0.0000 ms |
SELECT element.template_id, element.name, element_value.value, element.default_value as defaultValue, element.type FROM s_core_templates_config_elements element LEFT JOIN s_core_templates_config_values element_value ON element_value.element_id = element.id AND element_value.shop_id = : shopId WHERE element.template_id IN (: ids) |
array:2 [ ":shopId" => 1 ":ids" => array:3 [ 0 => 24 1 => 23 2 => 22 ] ] |
0.0001 ms |
SELECT id FROM s_core_customergroups WHERE `groupkey` = ? |
array:1 [ 0 => null ] |
0.0005 ms |
SELECT id FROM s_core_countries country |
[] |
0.0036 ms |
SELECT country.id as __country_id, country.countryname as __country_countryname, country.countryiso as __country_countryiso, country.areaID as __country_areaID, country.countryen as __country_countryen, country.position as __country_position, country.notice as __country_notice, country.taxfree as __country_taxfree, country.taxfree_ustid as __country_taxfree_ustid, country.taxfree_ustid_checked as __country_taxfree_ustid_checked, country.active as __country_active, country.iso3 as __country_iso3, country.display_state_in_registration as __country_display_state_in_registration, country.force_state_in_registration as __country_force_state_in_registration, country.allow_shipping as __country_allow_shipping, countryAttribute.id as __countryAttribute_id, countryAttribute.countryID as __countryAttribute_countryID, translation67d41d1dd1e07config_countries.objectdata as __country_translation, translation67d41d1dd1e22fallbackconfig_countries.objectdata as __country_translation_fallback, translation67d41d1dd1e30s_core_countries_attributes.objectdata as __countryAttribute_translation, translation67d41d1dd1e3afallbacks_core_countries_attributes.objectdata as __countryAttribute_translation_fallback FROM s_core_countries country LEFT JOIN s_core_countries_attributes countryAttribute ON countryAttribute.countryID = country.id LEFT JOIN s_core_translations translation67d41d1dd1e07config_countries ON translation67d41d1dd1e07config_countries.objecttype = : translation67d41d1dd1e07config_countries AND translation67d41d1dd1e07config_countries.objectkey = 1 AND translation67d41d1dd1e07config_countries.objectlanguage = : language LEFT JOIN s_core_translations translation67d41d1dd1e22fallbackconfig_countries ON translation67d41d1dd1e22fallbackconfig_countries.objecttype = : translation67d41d1dd1e22fallbackconfig_countries AND translation67d41d1dd1e22fallbackconfig_countries.objectkey = 1 AND translation67d41d1dd1e22fallbackconfig_countries.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d41d1dd1e30s_core_countries_attributes ON translation67d41d1dd1e30s_core_countries_attributes.objecttype = : translation67d41d1dd1e30s_core_countries_attributes AND translation67d41d1dd1e30s_core_countries_attributes.objectkey = country.id AND translation67d41d1dd1e30s_core_countries_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d41d1dd1e3afallbacks_core_countries_attributes ON translation67d41d1dd1e3afallbacks_core_countries_attributes.objecttype = : translation67d41d1dd1e3afallbacks_core_countries_attributes AND translation67d41d1dd1e3afallbacks_core_countries_attributes.objectkey = country.id AND translation67d41d1dd1e3afallbacks_core_countries_attributes.objectlanguage = : languagefallback WHERE country.id IN (: ids) |
array:7 [ ":ids" => array:250 [ 0 => "2" 1 => "3" 2 => "4" 3 => "15" 4 => "16" 5 => "20" 6 => "28" 7 => "32" 8 => "36" 9 => "37" 10 => "46" 11 => "47" 12 => "48" 13 => "49" 14 => "50" 15 => "51" 16 => "52" 17 => "53" 18 => "54" 19 => "55" 20 => "56" 21 => "57" 22 => "58" 23 => "59" 24 => "60" 25 => "61" 26 => "62" 27 => "63" 28 => "64" 29 => "65" 30 => "66" 31 => "67" 32 => "68" 33 => "69" 34 => "70" 35 => "71" 36 => "72" 37 => "73" 38 => "74" 39 => "75" 40 => "76" 41 => "77" 42 => "78" 43 => "79" 44 => "80" 45 => "81" 46 => "82" 47 => "83" 48 => "84" 49 => "85" 50 => "86" 51 => "87" 52 => "88" 53 => "89" 54 => "90" 55 => "91" 56 => "92" 57 => "93" 58 => "94" 59 => "95" 60 => "96" 61 => "97" 62 => "98" 63 => "99" 64 => "100" 65 => "101" 66 => "102" 67 => "103" 68 => "104" 69 => "105" 70 => "106" 71 => "107" 72 => "108" 73 => "109" 74 => "110" 75 => "111" 76 => "112" 77 => "113" 78 => "114" 79 => "115" 80 => "116" 81 => "117" 82 => "118" 83 => "119" 84 => "120" 85 => "121" 86 => "122" 87 => "123" 88 => "124" 89 => "125" 90 => "126" 91 => "127" 92 => "128" 93 => "129" 94 => "130" 95 => "131" 96 => "132" 97 => "133" 98 => "134" 99 => "135" 100 => "136" 101 => "137" 102 => "138" 103 => "139" 104 => "140" 105 => "141" 106 => "142" 107 => "143" 108 => "144" 109 => "145" 110 => "146" 111 => "147" 112 => "148" 113 => "149" 114 => "150" 115 => "151" 116 => "152" 117 => "153" 118 => "154" 119 => "155" 120 => "156" 121 => "157" 122 => "158" 123 => "159" 124 => "160" 125 => "161" 126 => "162" 127 => "163" 128 => "164" 129 => "165" 130 => "166" 131 => "167" 132 => "168" 133 => "169" 134 => "170" 135 => "171" 136 => "172" 137 => "173" 138 => "174" 139 => "175" 140 => "176" 141 => "177" 142 => "178" 143 => "179" 144 => "180" 145 => "181" 146 => "182" 147 => "183" 148 => "184" 149 => "185" 150 => "186" 151 => "187" 152 => "188" 153 => "189" 154 => "190" 155 => "191" 156 => "192" 157 => "193" 158 => "194" 159 => "195" 160 => "196" 161 => "197" 162 => "198" 163 => "199" 164 => "200" 165 => "201" 166 => "202" 167 => "203" 168 => "204" 169 => "205" 170 => "206" 171 => "207" 172 => "208" 173 => "209" 174 => "210" 175 => "211" 176 => "212" 177 => "213" 178 => "214" 179 => "215" 180 => "216" 181 => "217" 182 => "218" 183 => "219" 184 => "220" 185 => "221" 186 => "222" 187 => "223" 188 => "224" 189 => "225" 190 => "226" 191 => "227" 192 => "228" 193 => "229" 194 => "230" 195 => "231" 196 => "232" 197 => "233" 198 => "234" 199 => "235" 200 => "236" 201 => "237" 202 => "238" 203 => "239" 204 => "240" 205 => "241" 206 => "242" 207 => "243" 208 => "244" 209 => "245" 210 => "246" 211 => "247" 212 => "248" 213 => "249" 214 => "250" 215 => "251" 216 => "252" 217 => "253" 218 => "254" 219 => "5" 220 => "7" 221 => "8" 222 => "9" 223 => "10" 224 => "11" 225 => "12" 226 => "13" 227 => "14" 228 => "18" 229 => "21" 230 => "22" 231 => "23" 232 => "24" 233 => "25" 234 => "26" 235 => "27" 236 => "29" 237 => "30" 238 => "31" 239 => "33" 240 => "34" 241 => "35" 242 => "38" 243 => "39" 244 => "40" 245 => "41" 246 => "42" 247 => "43" 248 => "44" 249 => "45" ] ":language" => 3 ":translation67d41d1dd1e07config_countries" => "config_countries" ":languagefallback" => 0 ":translation67d41d1dd1e22fallbackconfig_countries" => "config_countries" ":translation67d41d1dd1e30s_core_countries_attributes" => "s_core_countries_attributes" ":translation67d41d1dd1e3afallbacks_core_countries_attributes" => "s_core_countries_attributes" ] |
0.0072 ms |
SELECT countryState.id as __countryState_id, countryState.countryID as __countryState_countryID, countryState.name as __countryState_name, countryState.shortcode as __countryState_shortcode, countryState.position as __countryState_position, countryState.active as __countryState_active, countryStateAttribute.id as __countryStateAttribute_id, countryStateAttribute.stateID as __countryStateAttribute_stateID, translation67d41d1dd487aconfig_country_states.objectdata as __countryState_translation, translation67d41d1dd4885fallbackconfig_country_states.objectdata as __countryState_translation_fallback, translation67d41d1dd4888s_core_countries_states_attributes.objectdata as __countryStateAttribute_translation, translation67d41d1dd4889fallbacks_core_countries_states_attributes.objectdata as __countryStateAttribute_translation_fallback FROM s_core_countries_states countryState LEFT JOIN s_core_countries_states_attributes countryStateAttribute ON countryStateAttribute.stateID = countryState.id LEFT JOIN s_core_translations translation67d41d1dd487aconfig_country_states ON translation67d41d1dd487aconfig_country_states.objecttype = : translation67d41d1dd487aconfig_country_states AND translation67d41d1dd487aconfig_country_states.objectkey = 1 AND translation67d41d1dd487aconfig_country_states.objectlanguage = : language LEFT JOIN s_core_translations translation67d41d1dd4885fallbackconfig_country_states ON translation67d41d1dd4885fallbackconfig_country_states.objecttype = : translation67d41d1dd4885fallbackconfig_country_states AND translation67d41d1dd4885fallbackconfig_country_states.objectkey = 1 AND translation67d41d1dd4885fallbackconfig_country_states.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d41d1dd4888s_core_countries_states_attributes ON translation67d41d1dd4888s_core_countries_states_attributes.objecttype = : translation67d41d1dd4888s_core_countries_states_attributes AND translation67d41d1dd4888s_core_countries_states_attributes.objectkey = countryStateAttribute.stateID AND translation67d41d1dd4888s_core_countries_states_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d41d1dd4889fallbacks_core_countries_states_attributes ON translation67d41d1dd4889fallbacks_core_countries_states_attributes.objecttype = : translation67d41d1dd4889fallbacks_core_countries_states_attributes AND translation67d41d1dd4889fallbacks_core_countries_states_attributes.objectkey = countryStateAttribute.stateID AND translation67d41d1dd4889fallbacks_core_countries_states_attributes.objectlanguage = : languagefallback WHERE countryState.countryID IN (: ids) |
array:7 [ ":language" => 3 ":translation67d41d1dd487aconfig_country_states" => "config_country_states" ":languagefallback" => 0 ":translation67d41d1dd4885fallbackconfig_country_states" => "config_country_states" ":translation67d41d1dd4888s_core_countries_states_attributes" => "s_core_countries_states_attributes" ":translation67d41d1dd4889fallbacks_core_countries_states_attributes" => "s_core_countries_states_attributes" ":ids" => array:250 [ 0 => "2" 1 => "3" 2 => "4" 3 => "15" 4 => "16" 5 => "20" 6 => "28" 7 => "32" 8 => "36" 9 => "37" 10 => "46" 11 => "47" 12 => "48" 13 => "49" 14 => "50" 15 => "51" 16 => "52" 17 => "53" 18 => "54" 19 => "55" 20 => "56" 21 => "57" 22 => "58" 23 => "59" 24 => "60" 25 => "61" 26 => "62" 27 => "63" 28 => "64" 29 => "65" 30 => "66" 31 => "67" 32 => "68" 33 => "69" 34 => "70" 35 => "71" 36 => "72" 37 => "73" 38 => "74" 39 => "75" 40 => "76" 41 => "77" 42 => "78" 43 => "79" 44 => "80" 45 => "81" 46 => "82" 47 => "83" 48 => "84" 49 => "85" 50 => "86" 51 => "87" 52 => "88" 53 => "89" 54 => "90" 55 => "91" 56 => "92" 57 => "93" 58 => "94" 59 => "95" 60 => "96" 61 => "97" 62 => "98" 63 => "99" 64 => "100" 65 => "101" 66 => "102" 67 => "103" 68 => "104" 69 => "105" 70 => "106" 71 => "107" 72 => "108" 73 => "109" 74 => "110" 75 => "111" 76 => "112" 77 => "113" 78 => "114" 79 => "115" 80 => "116" 81 => "117" 82 => "118" 83 => "119" 84 => "120" 85 => "121" 86 => "122" 87 => "123" 88 => "124" 89 => "125" 90 => "126" 91 => "127" 92 => "128" 93 => "129" 94 => "130" 95 => "131" 96 => "132" 97 => "133" 98 => "134" 99 => "135" 100 => "136" 101 => "137" 102 => "138" 103 => "139" 104 => "140" 105 => "141" 106 => "142" 107 => "143" 108 => "144" 109 => "145" 110 => "146" 111 => "147" 112 => "148" 113 => "149" 114 => "150" 115 => "151" 116 => "152" 117 => "153" 118 => "154" 119 => "155" 120 => "156" 121 => "157" 122 => "158" 123 => "159" 124 => "160" 125 => "161" 126 => "162" 127 => "163" 128 => "164" 129 => "165" 130 => "166" 131 => "167" 132 => "168" 133 => "169" 134 => "170" 135 => "171" 136 => "172" 137 => "173" 138 => "174" 139 => "175" 140 => "176" 141 => "177" 142 => "178" 143 => "179" 144 => "180" 145 => "181" 146 => "182" 147 => "183" 148 => "184" 149 => "185" 150 => "186" 151 => "187" 152 => "188" 153 => "189" 154 => "190" 155 => "191" 156 => "192" 157 => "193" 158 => "194" 159 => "195" 160 => "196" 161 => "197" 162 => "198" 163 => "199" 164 => "200" 165 => "201" 166 => "202" 167 => "203" 168 => "204" 169 => "205" 170 => "206" 171 => "207" 172 => "208" 173 => "209" 174 => "210" 175 => "211" 176 => "212" 177 => "213" 178 => "214" 179 => "215" 180 => "216" 181 => "217" 182 => "218" 183 => "219" 184 => "220" 185 => "221" 186 => "222" 187 => "223" 188 => "224" 189 => "225" 190 => "226" 191 => "227" 192 => "228" 193 => "229" 194 => "230" 195 => "231" 196 => "232" 197 => "233" 198 => "234" 199 => "235" 200 => "236" 201 => "237" 202 => "238" 203 => "239" 204 => "240" 205 => "241" 206 => "242" 207 => "243" 208 => "244" 209 => "245" 210 => "246" 211 => "247" 212 => "248" 213 => "249" 214 => "250" 215 => "251" 216 => "252" 217 => "253" 218 => "254" 219 => "5" 220 => "7" 221 => "8" 222 => "9" 223 => "10" 224 => "11" 225 => "12" 226 => "13" 227 => "14" 228 => "18" 229 => "21" 230 => "22" 231 => "23" 232 => "24" 233 => "25" 234 => "26" 235 => "27" 236 => "29" 237 => "30" 238 => "31" 239 => "33" 240 => "34" 241 => "35" 242 => "38" 243 => "39" 244 => "40" 245 => "41" 246 => "42" 247 => "43" 248 => "44" 249 => "45" ] ] |
0.0031 ms |
SELECT category.path FROM s_categories category WHERE category.id = : id |
array:1 [ ":id" => 3 ] |
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 shop.id, REPLACE(locale.locale, "_", "-") as locale FROM s_core_shops shop INNER JOIN s_core_locales locale ON locale.id = shop.locale_id WHERE ( (shop.id = : shopId) OR (shop.main_id = : shopId) ) AND (active = 1) |
array:1 [ "shopId" => 1 ] |
0.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_.template AS template_58, s4_.name AS name_59, s4_.description AS description_60, s4_.author AS author_61, s4_.license AS license_62, s4_.esi AS esi_63, s4_.style_support AS style_support_64, s4_.emotion AS emotion_65, s4_.version AS version_66, s4_.plugin_id AS plugin_id_67, s4_.parent_id AS parent_id_68, s5_.id AS id_69, s5_.template AS template_70, s5_.name AS name_71, s5_.description AS description_72, s5_.author AS author_73, s5_.license AS license_74, s5_.esi AS esi_75, s5_.style_support AS style_support_76, s5_.emotion AS emotion_77, s5_.version AS version_78, s5_.plugin_id AS plugin_id_79, s5_.parent_id AS parent_id_80, s6_.id AS id_81, s6_.currency AS currency_82, s6_.name AS name_83, s6_.standard AS standard_84, s6_.factor AS factor_85, s6_.templatechar AS templatechar_86, s6_.symbol_position AS symbol_position_87, s6_.position AS position_88, s7_.id AS id_89, s7_.groupkey AS groupkey_90, s7_.description AS description_91, s7_.tax AS tax_92, s7_.taxinput AS taxinput_93, s7_.mode AS mode_94, s7_.discount AS discount_95, s7_.minimumorder AS minimumorder_96, s7_.minimumordersurcharge AS minimumordersurcharge_97, s8_.id AS id_98, s8_.template AS template_99, s8_.name AS name_100, s8_.description AS description_101, s8_.author AS author_102, s8_.license AS license_103, s8_.esi AS esi_104, s8_.style_support AS style_support_105, s8_.emotion AS emotion_106, s8_.version AS version_107, s8_.plugin_id AS plugin_id_108, s8_.parent_id AS parent_id_109, s0_.main_id AS main_id_110, s0_.template_id AS template_id_111, s0_.document_template_id AS document_template_id_112, s0_.category_id AS category_id_113, s0_.locale_id AS locale_id_114, s0_.currency_id AS currency_id_115, s0_.customer_group_id AS customer_group_id_116, s0_.fallback_id AS fallback_id_117, s1_.main_id AS main_id_118, s1_.template_id AS template_id_119, s1_.document_template_id AS document_template_id_120, s1_.category_id AS category_id_121, s1_.locale_id AS locale_id_122, s1_.currency_id AS currency_id_123, s1_.customer_group_id AS customer_group_id_124, s1_.fallback_id AS fallback_id_125, s4_.parent_id AS parent_id_126, s4_.plugin_id AS plugin_id_127, s5_.parent_id AS parent_id_128, s5_.plugin_id AS plugin_id_129, s8_.parent_id AS parent_id_130, s8_.plugin_id AS plugin_id_131 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_templates s4_ ON s0_.template_id = s4_.id LEFT JOIN s_core_templates s5_ ON s0_.document_template_id = s5_.id LEFT JOIN s_core_shop_currencies s9_ ON s0_.id = s9_.shop_id LEFT JOIN s_core_currencies s6_ ON s6_.id = s9_.currency_id LEFT JOIN s_core_customergroups s7_ ON s0_.customer_group_id = s7_.id LEFT JOIN s_core_templates s8_ ON s1_.template_id = s8_.id LEFT JOIN s_core_shop_currencies s11_ ON s1_.id = s11_.shop_id LEFT JOIN s_core_currencies s10_ ON s10_.id = s11_.currency_id WHERE s0_.id = ? ORDER BY s0_.main_id ASC, s0_.position ASC, s6_.position ASC, s6_.id ASC |
array:1 [ 0 => 1 ] |
0.0002 ms |
SELECT org_path, path FROM s_core_rewrite_urls WHERE subshopID =: shopId AND org_path IN (: orgPath) AND main = 1 ORDER BY id DESC |
array:2 [ ":shopId" => 1 ":orgPath" => array:1 [ 0 => "sViewport=account&sAction=payment" ] ] |
0.0002 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_.template AS template_58, s4_.name AS name_59, s4_.description AS description_60, s4_.author AS author_61, s4_.license AS license_62, s4_.esi AS esi_63, s4_.style_support AS style_support_64, s4_.emotion AS emotion_65, s4_.version AS version_66, s4_.plugin_id AS plugin_id_67, s4_.parent_id AS parent_id_68, s5_.id AS id_69, s5_.template AS template_70, s5_.name AS name_71, s5_.description AS description_72, s5_.author AS author_73, s5_.license AS license_74, s5_.esi AS esi_75, s5_.style_support AS style_support_76, s5_.emotion AS emotion_77, s5_.version AS version_78, s5_.plugin_id AS plugin_id_79, s5_.parent_id AS parent_id_80, s6_.id AS id_81, s6_.currency AS currency_82, s6_.name AS name_83, s6_.standard AS standard_84, s6_.factor AS factor_85, s6_.templatechar AS templatechar_86, s6_.symbol_position AS symbol_position_87, s6_.position AS position_88, s7_.id AS id_89, s7_.groupkey AS groupkey_90, s7_.description AS description_91, s7_.tax AS tax_92, s7_.taxinput AS taxinput_93, s7_.mode AS mode_94, s7_.discount AS discount_95, s7_.minimumorder AS minimumorder_96, s7_.minimumordersurcharge AS minimumordersurcharge_97, s8_.id AS id_98, s8_.template AS template_99, s8_.name AS name_100, s8_.description AS description_101, s8_.author AS author_102, s8_.license AS license_103, s8_.esi AS esi_104, s8_.style_support AS style_support_105, s8_.emotion AS emotion_106, s8_.version AS version_107, s8_.plugin_id AS plugin_id_108, s8_.parent_id AS parent_id_109, s0_.main_id AS main_id_110, s0_.template_id AS template_id_111, s0_.document_template_id AS document_template_id_112, s0_.category_id AS category_id_113, s0_.locale_id AS locale_id_114, s0_.currency_id AS currency_id_115, s0_.customer_group_id AS customer_group_id_116, s0_.fallback_id AS fallback_id_117, s1_.main_id AS main_id_118, s1_.template_id AS template_id_119, s1_.document_template_id AS document_template_id_120, s1_.category_id AS category_id_121, s1_.locale_id AS locale_id_122, s1_.currency_id AS currency_id_123, s1_.customer_group_id AS customer_group_id_124, s1_.fallback_id AS fallback_id_125, s4_.parent_id AS parent_id_126, s4_.plugin_id AS plugin_id_127, s5_.parent_id AS parent_id_128, s5_.plugin_id AS plugin_id_129, s8_.parent_id AS parent_id_130, s8_.plugin_id AS plugin_id_131 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_templates s4_ ON s0_.template_id = s4_.id LEFT JOIN s_core_templates s5_ ON s0_.document_template_id = s5_.id LEFT JOIN s_core_shop_currencies s9_ ON s0_.id = s9_.shop_id LEFT JOIN s_core_currencies s6_ ON s6_.id = s9_.currency_id LEFT JOIN s_core_customergroups s7_ ON s0_.customer_group_id = s7_.id LEFT JOIN s_core_templates s8_ ON s1_.template_id = s8_.id LEFT JOIN s_core_shop_currencies s11_ ON s1_.id = s11_.shop_id LEFT JOIN s_core_currencies s10_ ON s10_.id = s11_.currency_id WHERE s0_.id = ? ORDER BY s0_.main_id ASC, s0_.position ASC, s6_.position ASC, s6_.id ASC |
array:1 [ 0 => 3 ] |
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=account&sAction=payment" ] ] |
0.0002 ms |
SELECT category.path FROM s_categories category WHERE category.id = : id |
array:1 [ ":id" => 3 ] |
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:1 [ 0 => 3 ] ":shopId" => "%|3|%" ] |
0.0003 ms |
SELECT category.id as __category_id, category.parent as __category_parent_id, category.position as __category_position, category.path as __category_path, category.description as __category_description, category.meta_title as __category_metatitle, category.metakeywords as __category_metakeywords, category.metadescription as __category_metadescription, category.cmsheadline as __category_cmsheadline, category.product_box_layout as __category_product_box_layout, category.cmstext as __category_cmstext, category.template as __category_template, category.blog as __category_blog, category.external as __category_external, category.external_target as __category_external_target, category.hidefilter as __category_hidefilter, category.hidetop as __category_hidetop, category.stream_id as __category_stream_id, category.hide_sortings as __category_hide_sortings, categoryAttribute.id as __categoryAttribute_id, categoryAttribute.categoryID as __categoryAttribute_categoryID, categoryAttribute.attribute1 as __categoryAttribute_attribute1, categoryAttribute.attribute2 as __categoryAttribute_attribute2, categoryAttribute.attribute3 as __categoryAttribute_attribute3, categoryAttribute.attribute4 as __categoryAttribute_attribute4, categoryAttribute.attribute5 as __categoryAttribute_attribute5, categoryAttribute.attribute6 as __categoryAttribute_attribute6, media.id as __media_id, media.albumID as __media_albumID, media.name as __media_name, media.description as __media_description, media.path as __media_path, media.type as __media_type, media.extension as __media_extension, media.file_size as __media_file_size, media.width as __media_width, media.height as __media_height, media.userID as __media_userID, media.created as __media_created, mediaSettings.id as __mediaSettings_id, mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, mediaSettings.icon as __mediaSettings_icon, mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, mediaAttribute.id as __mediaAttribute_id, mediaAttribute.mediaID as __mediaAttribute_mediaID, stream.id as __stream_id, stream.name as __stream_name, stream.description as __stream_description, stream.type as __stream_type, productStreamAttribute.id as __productStreamAttribute_id, productStreamAttribute.streamID as __productStreamAttribute_streamID, GROUP_CONCAT(customerGroups.customergroupID) as __category_customer_groups, translation67d41d1dd7e95s_categories_attributes.objectdata as __categoryAttribute_translation, translation67d41d1dd7e99fallbacks_categories_attributes.objectdata as __categoryAttribute_translation_fallback, translation67d41d1dd7e9cs_media_attributes.objectdata as __mediaAttribute_translation, translation67d41d1dd7e9dfallbacks_media_attributes.objectdata as __mediaAttribute_translation_fallback, translation67d41d1dd7ea0productStream.objectdata as __stream_translation, translation67d41d1dd7ea1fallbackproductStream.objectdata as __stream_translation_fallback, translation67d41d1dd7ea3category.objectdata as __category_translation, translation67d41d1dd7eaafallbackcategory.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 translation67d41d1dd7ea3category ON translation67d41d1dd7ea3category.objecttype = : translation67d41d1dd7ea3category AND translation67d41d1dd7ea3category.objectkey = category.id AND translation67d41d1dd7ea3category.objectlanguage = : language LEFT JOIN s_core_translations translation67d41d1dd7eaafallbackcategory ON translation67d41d1dd7eaafallbackcategory.objecttype = : translation67d41d1dd7eaafallbackcategory AND translation67d41d1dd7eaafallbackcategory.objectkey = category.id AND translation67d41d1dd7eaafallbackcategory.objectlanguage = : languagefallback LEFT JOIN s_core_translations translation67d41d1dd7e95s_categories_attributes ON translation67d41d1dd7e95s_categories_attributes.objecttype = : translation67d41d1dd7e95s_categories_attributes AND translation67d41d1dd7e95s_categories_attributes.objectkey = category.id AND translation67d41d1dd7e95s_categories_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d41d1dd7e99fallbacks_categories_attributes ON translation67d41d1dd7e99fallbacks_categories_attributes.objecttype = : translation67d41d1dd7e99fallbacks_categories_attributes AND translation67d41d1dd7e99fallbacks_categories_attributes.objectkey = category.id AND translation67d41d1dd7e99fallbacks_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 translation67d41d1dd7e9cs_media_attributes ON translation67d41d1dd7e9cs_media_attributes.objecttype = : translation67d41d1dd7e9cs_media_attributes AND translation67d41d1dd7e9cs_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d41d1dd7e9cs_media_attributes.objectlanguage = : language LEFT JOIN s_core_translations translation67d41d1dd7e9dfallbacks_media_attributes ON translation67d41d1dd7e9dfallbacks_media_attributes.objecttype = : translation67d41d1dd7e9dfallbacks_media_attributes AND translation67d41d1dd7e9dfallbacks_media_attributes.objectkey = mediaAttribute.mediaID AND translation67d41d1dd7e9dfallbacks_media_attributes.objectlanguage = : languagefallback LEFT JOIN s_product_streams_attributes productStreamAttribute ON stream.id = productStreamAttribute.streamId LEFT JOIN s_core_translations translation67d41d1dd7ea0productStream ON translation67d41d1dd7ea0productStream.objecttype = : translation67d41d1dd7ea0productStream AND translation67d41d1dd7ea0productStream.objectkey = stream.id AND translation67d41d1dd7ea0productStream.objectlanguage = : language LEFT JOIN s_core_translations translation67d41d1dd7ea1fallbackproductStream ON translation67d41d1dd7ea1fallbackproductStream.objecttype = : translation67d41d1dd7ea1fallbackproductStream AND translation67d41d1dd7ea1fallbackproductStream.objectkey = stream.id AND translation67d41d1dd7ea1fallbackproductStream.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:10 [ 0 => 3 1 => 3 2 => 5 3 => 7 4 => 8 5 => 9 6 => 10 7 => 11 8 => 81 9 => 12 ] ":shopId" => "%|3|%" ":language" => 3 ":translation67d41d1dd7e95s_categories_attributes" => "s_categories_attributes" ":languagefallback" => 0 ":translation67d41d1dd7e99fallbacks_categories_attributes" => "s_categories_attributes" ":translation67d41d1dd7e9cs_media_attributes" => "s_media_attributes" ":translation67d41d1dd7e9dfallbacks_media_attributes" => "s_media_attributes" ":translation67d41d1dd7ea0productStream" => "productStream" ":translation67d41d1dd7ea1fallbackproductStream" => "productStream" ":translation67d41d1dd7ea3category" => "category" ":translation67d41d1dd7eaafallbackcategory" => "category" ] |
0.0010 ms |
SELECT parent as id, COUNT(id) as childrenCount FROM s_categories category WHERE ( parent IN (: ids) ) AND (category.active = 1) GROUP BY parent |
array:1 [ ":ids" => array:10 [ 0 => 3 1 => 3 2 => 5 3 => 7 4 => 8 5 => 9 6 => 10 7 => 11 8 => 81 9 => 12 ] ] |
0.0001 ms |
SELECT shop.id as __shop_id, shop.main_id as __shop_main_id, shop.name as __shop_name, shop.title as __shop_title, shop.position as __shop_position, shop.host as __shop_host, shop.base_path as __shop_base_path, shop.base_url as __shop_base_url, shop.hosts as __shop_hosts, shop.secure as __shop_secure, shop.template_id as __shop_template_id, shop.document_template_id as __shop_document_template_id, shop.category_id as __shop_category_id, shop.locale_id as __shop_locale_id, shop.currency_id as __shop_currency_id, shop.customer_group_id as __shop_customer_group_id, shop.fallback_id as __shop_fallback_id, shop.customer_scope as __shop_customer_scope, shop.default as __shop_default, shop.active as __shop_active, shopAttribute.id as __shopAttribute_id, shopAttribute.shopID as __shopAttribute_shopID, currency.id as __currency_id, currency.currency as __currency_currency, currency.name as __currency_name, currency.standard as __currency_standard, currency.factor as __currency_factor, currency.templatechar as __currency_templatechar, currency.symbol_position as __currency_symbol_position, currency.position as __currency_position, template.id as __template_id, template.template as __template_template, template.name as __template_name, template.description as __template_description, template.author as __template_author, template.license as __template_license, template.esi as __template_esi, template.style_support as __template_style_support, template.emotion as __template_emotion, template.version as __template_version, template.plugin_id as __template_plugin_id, template.parent_id as __template_parent_id, locale.id as __locale_id, locale.locale as __locale_locale, locale.language as __locale_language, locale.territory as __locale_territory, customerGroup.id as __customerGroup_id, customerGroup.groupkey as __customerGroup_groupkey, customerGroup.description as __customerGroup_description, customerGroup.tax as __customerGroup_tax, customerGroup.taxinput as __customerGroup_taxinput, customerGroup.mode as __customerGroup_mode, customerGroup.discount as __customerGroup_discount, customerGroup.minimumorder as __customerGroup_minimumorder, customerGroup.minimumordersurcharge as __customerGroup_minimumordersurcharge, customerGroupAttribute.id as __customerGroupAttribute_id, customerGroupAttribute.customerGroupID as __customerGroupAttribute_customerGroupID, category.id as __category_id, category.parent as __category_parent_id, category.position as __category_position, category.path as __category_path, category.description as __category_description, category.meta_title as __category_metatitle, category.metakeywords as __category_metakeywords, category.metadescription as __category_metadescription, category.cmsheadline as __category_cmsheadline, category.product_box_layout as __category_product_box_layout, category.cmstext as __category_cmstext, category.template as __category_template, category.blog as __category_blog, category.external as __category_external, category.external_target as __category_external_target, category.hidefilter as __category_hidefilter, category.hidetop as __category_hidetop, category.stream_id as __category_stream_id, category.hide_sortings as __category_hide_sortings, categoryAttribute.id as __categoryAttribute_id, categoryAttribute.categoryID as __categoryAttribute_categoryID, categoryAttribute.attribute1 as __categoryAttribute_attribute1, categoryAttribute.attribute2 as __categoryAttribute_attribute2, categoryAttribute.attribute3 as __categoryAttribute_attribute3, categoryAttribute.attribute4 as __categoryAttribute_attribute4, categoryAttribute.attribute5 as __categoryAttribute_attribute5, categoryAttribute.attribute6 as __categoryAttribute_attribute6, media.id as __media_id, media.albumID as __media_albumID, media.name as __media_name, media.description as __media_description, media.path as __media_path, media.type as __media_type, media.extension as __media_extension, media.file_size as __media_file_size, media.width as __media_width, media.height as __media_height, media.userID as __media_userID, media.created as __media_created, mediaSettings.id as __mediaSettings_id, mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, mediaSettings.icon as __mediaSettings_icon, mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, mediaAttribute.id as __mediaAttribute_id, mediaAttribute.mediaID as __mediaAttribute_mediaID FROM s_core_shops shop LEFT JOIN s_core_shops_attributes shopAttribute ON shopAttribute.shopID = shop.id LEFT JOIN s_core_currencies currency ON currency.id = shop.currency_id LEFT JOIN s_core_templates template ON shop.template_id = template.id LEFT JOIN s_core_locales locale ON locale.id = shop.locale_id LEFT JOIN s_core_customergroups customerGroup ON customerGroup.id = shop.customer_group_id LEFT JOIN s_categories category ON category.id = shop.category_id LEFT JOIN s_core_customergroups_attributes customerGroupAttribute ON customerGroupAttribute.customerGroupID = customerGroup.id LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id LEFT JOIN s_media media ON media.id = category.mediaID LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id WHERE shop.id IN (: ids) |
array:1 [ ":ids" => array:1 [ 0 => 3 ] ] |
0.0001 ms |
SELECT shop.id as __shop_id, shop.main_id as __shop_main_id, shop.name as __shop_name, shop.title as __shop_title, shop.position as __shop_position, shop.host as __shop_host, shop.base_path as __shop_base_path, shop.base_url as __shop_base_url, shop.hosts as __shop_hosts, shop.secure as __shop_secure, shop.template_id as __shop_template_id, shop.document_template_id as __shop_document_template_id, shop.category_id as __shop_category_id, shop.locale_id as __shop_locale_id, shop.currency_id as __shop_currency_id, shop.customer_group_id as __shop_customer_group_id, shop.fallback_id as __shop_fallback_id, shop.customer_scope as __shop_customer_scope, shop.default as __shop_default, shop.active as __shop_active, shopAttribute.id as __shopAttribute_id, shopAttribute.shopID as __shopAttribute_shopID, currency.id as __currency_id, currency.currency as __currency_currency, currency.name as __currency_name, currency.standard as __currency_standard, currency.factor as __currency_factor, currency.templatechar as __currency_templatechar, currency.symbol_position as __currency_symbol_position, currency.position as __currency_position, template.id as __template_id, template.template as __template_template, template.name as __template_name, template.description as __template_description, template.author as __template_author, template.license as __template_license, template.esi as __template_esi, template.style_support as __template_style_support, template.emotion as __template_emotion, template.version as __template_version, template.plugin_id as __template_plugin_id, template.parent_id as __template_parent_id, locale.id as __locale_id, locale.locale as __locale_locale, locale.language as __locale_language, locale.territory as __locale_territory, customerGroup.id as __customerGroup_id, customerGroup.groupkey as __customerGroup_groupkey, customerGroup.description as __customerGroup_description, customerGroup.tax as __customerGroup_tax, customerGroup.taxinput as __customerGroup_taxinput, customerGroup.mode as __customerGroup_mode, customerGroup.discount as __customerGroup_discount, customerGroup.minimumorder as __customerGroup_minimumorder, customerGroup.minimumordersurcharge as __customerGroup_minimumordersurcharge, customerGroupAttribute.id as __customerGroupAttribute_id, customerGroupAttribute.customerGroupID as __customerGroupAttribute_customerGroupID, category.id as __category_id, category.parent as __category_parent_id, category.position as __category_position, category.path as __category_path, category.description as __category_description, category.meta_title as __category_metatitle, category.metakeywords as __category_metakeywords, category.metadescription as __category_metadescription, category.cmsheadline as __category_cmsheadline, category.product_box_layout as __category_product_box_layout, category.cmstext as __category_cmstext, category.template as __category_template, category.blog as __category_blog, category.external as __category_external, category.external_target as __category_external_target, category.hidefilter as __category_hidefilter, category.hidetop as __category_hidetop, category.stream_id as __category_stream_id, category.hide_sortings as __category_hide_sortings, categoryAttribute.id as __categoryAttribute_id, categoryAttribute.categoryID as __categoryAttribute_categoryID, categoryAttribute.attribute1 as __categoryAttribute_attribute1, categoryAttribute.attribute2 as __categoryAttribute_attribute2, categoryAttribute.attribute3 as __categoryAttribute_attribute3, categoryAttribute.attribute4 as __categoryAttribute_attribute4, categoryAttribute.attribute5 as __categoryAttribute_attribute5, categoryAttribute.attribute6 as __categoryAttribute_attribute6, media.id as __media_id, media.albumID as __media_albumID, media.name as __media_name, media.description as __media_description, media.path as __media_path, media.type as __media_type, media.extension as __media_extension, media.file_size as __media_file_size, media.width as __media_width, media.height as __media_height, media.userID as __media_userID, media.created as __media_created, mediaSettings.id as __mediaSettings_id, mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, mediaSettings.icon as __mediaSettings_icon, mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, mediaAttribute.id as __mediaAttribute_id, mediaAttribute.mediaID as __mediaAttribute_mediaID FROM s_core_shops shop LEFT JOIN s_core_shops_attributes shopAttribute ON shopAttribute.shopID = shop.id LEFT JOIN s_core_currencies currency ON currency.id = shop.currency_id LEFT JOIN s_core_templates template ON shop.template_id = template.id LEFT JOIN s_core_locales locale ON locale.id = shop.locale_id LEFT JOIN s_core_customergroups customerGroup ON customerGroup.id = shop.customer_group_id LEFT JOIN s_categories category ON category.id = shop.category_id LEFT JOIN s_core_customergroups_attributes customerGroupAttribute ON customerGroupAttribute.customerGroupID = customerGroup.id LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id LEFT JOIN s_media media ON media.id = category.mediaID LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id WHERE shop.id IN (: ids) |
array:1 [ ":ids" => array:1 [ 0 => "1" ] ] |
0.0001 ms |
SELECT customerGroup.id as __customerGroup_id, customerGroup.groupkey as __customerGroup_groupkey, customerGroup.description as __customerGroup_description, customerGroup.tax as __customerGroup_tax, customerGroup.taxinput as __customerGroup_taxinput, customerGroup.mode as __customerGroup_mode, customerGroup.discount as __customerGroup_discount, customerGroup.minimumorder as __customerGroup_minimumorder, customerGroup.minimumordersurcharge as __customerGroup_minimumordersurcharge, customerGroupAttribute.id as __customerGroupAttribute_id, customerGroupAttribute.customerGroupID as __customerGroupAttribute_customerGroupID FROM s_core_customergroups customerGroup LEFT JOIN s_core_customergroups_attributes customerGroupAttribute ON customerGroupAttribute.customerGroupID = customerGroup.id WHERE customerGroup.groupkey IN (: keys) |
array:1 [ ":keys" => array:2 [ 0 => "EK" 1 => "EK" ] ] |
0.0001 ms |
SELECT tax.id as __tax_id, tax.tax as __tax_tax, tax.description as __tax_description FROM s_core_tax tax |
[] |
0.0000 ms |
SELECT taxRule.groupID as __taxRule_groupID, taxRule.tax as __taxRule_tax, taxRule.name as __taxRule_name FROM s_core_tax_rules taxRule WHERE ( ( taxRule.areaID = : area OR taxRule.areaID IS NULL ) ) AND ( ( taxRule.countryID = : country OR taxRule.countryID IS NULL ) ) AND ( ( taxRule.stateID = : state OR taxRule.stateID IS NULL ) ) AND ( ( taxRule.customer_groupID = : customerGroup OR taxRule.customer_groupID IS NULL ) ) AND (taxRule.groupID = : taxId) AND (taxRule.active = 1) ORDER BY taxRule.customer_groupID DESC, taxRule.areaID DESC, taxRule.countryID DESC, taxRule.stateID DESC LIMIT 1 |
array:5 [ ":area" => null ":country" => null ":state" => null ":customerGroup" => 1 ":taxId" => "1" ] |
0.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.0000 ms |
SELECT page.id, page.description, page.link, page.target, page.parentID, groups.key as `group`, mapping.key as mapping, translation67d41d1dd8850page.objectdata as __page_translation, translation67d41d1dd8854fallbackpage.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 translation67d41d1dd8850page ON translation67d41d1dd8850page.objecttype = : translation67d41d1dd8850page AND translation67d41d1dd8850page.objectkey = page.id AND translation67d41d1dd8850page.objectlanguage = : language LEFT JOIN s_core_translations translation67d41d1dd8854fallbackpage ON translation67d41d1dd8854fallbackpage.objecttype = : translation67d41d1dd8854fallbackpage AND translation67d41d1dd8854fallbackpage.objectkey = page.id AND translation67d41d1dd8854fallbackpage.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 ":translation67d41d1dd8850page" => "page" ":languagefallback" => 0 ":translation67d41d1dd8854fallbackpage" => "page" ":shopId" => 3 ":staticShopId" => "%|3|%" ] |
0.0007 ms |
SELECT org_path, path FROM s_core_rewrite_urls WHERE subshopID =: shopId AND org_path IN (: orgPath) AND main = 1 ORDER BY id DESC |
array:2 [ ":shopId" => 3 ":orgPath" => array:13 [ 39 => "sViewport=forms&sFid=9" 21 => "sViewport=registerFC" 26 => "sViewport=newsletter" 37 => "sViewport=forms&sFid=8" 43 => "sViewport=custom&sCustom=43" 9 => "sViewport=custom&sCustom=9" 2 => "sViewport=custom&sCustom=2" 1 => "sViewport=forms&sFid=5" 6 => "sViewport=custom&sCustom=6" 41 => "sViewport=forms&sFid=10" 8 => "sViewport=custom&sCustom=8" 45 => "sViewport=custom&sCustom=45" 4 => "sViewport=custom&sCustom=4" ] ] |
0.0001 ms |
SELECT s_core_config_values.value FROM s_core_config_values INNER JOIN s_core_config_elements ON s_core_config_values.element_id = s_core_config_elements.id AND s_core_config_elements.`name` LIKE 'assetTimestamp' WHERE s_core_config_values.shop_id = : shopId |
array:1 [ "shopId" => 1 ] |
0.0003 ms |
SELECT s0_.id AS id_0, s0_.compiler_force AS compiler_force_1, s0_.compiler_create_source_map AS compiler_create_source_map_2, s0_.compiler_compress_css AS compiler_compress_css_3, s0_.compiler_compress_js AS compiler_compress_js_4, s0_.force_reload_snippets AS force_reload_snippets_5 FROM s_core_theme_settings s0_ ORDER BY s0_.id ASC LIMIT 1 |
[] |
0.0001 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.namespace AS namespace_4, t0.source AS source_5, t0.description AS description_6, t0.active AS active_7, t0.added AS added_8, t0.installation_date AS installation_date_9, t0.update_date AS update_date_10, t0.refresh_date AS refresh_date_11, t0.author AS author_12, t0.copyright AS copyright_13, t0.license AS license_14, t0.version AS version_15, t0.support AS support_16, t0.changes AS changes_17, t0.link AS link_18, t0.update_version AS update_version_19, t0.update_source AS update_source_20, t0.capability_update AS capability_update_21, t0.capability_install AS capability_install_22, t0.capability_enable AS capability_enable_23, t0.capability_secure_uninstall AS capability_secure_uninstall_24, t0.translations AS translations_25, t0.in_safe_mode AS in_safe_mode_26 FROM s_core_plugins t0 WHERE t0.id = ? LIMIT 1 |
array:1 [ 0 => "52" ] |
0.0001 ms |
SELECT template.id, template.id, template.template, template.plugin_id, template.parent_id, plugin.name as plugin_name, plugin.namespace as plugin_namespace, plugin.source as plugin_source FROM s_core_templates template LEFT JOIN s_core_plugins plugin ON plugin.id = template.plugin_id |
[] |
0.0001 ms |
SELECT template.id, template.id, template.template, template.plugin_id, template.parent_id, plugin.name as plugin_name, plugin.namespace as plugin_namespace, plugin.source as plugin_source FROM s_core_templates template LEFT JOIN s_core_plugins plugin ON plugin.id = template.plugin_id |
[] |
0.0001 ms |
SELECT template.id, template.id, template.template, template.plugin_id, template.parent_id, plugin.name as plugin_name, plugin.namespace as plugin_namespace, plugin.source as plugin_source FROM s_core_templates template LEFT JOIN s_core_plugins plugin ON plugin.id = template.plugin_id |
[] |
0.0001 ms |
SELECT org_path, path FROM s_core_rewrite_urls WHERE subshopID =: shopId AND org_path IN (: orgPath) AND main = 1 ORDER BY id DESC |
array:2 [ ":shopId" => 3 ":orgPath" => array:1 [ 0 => "sViewport=address&sAction=index" ] ] |
0.0001 ms |
SELECT host, hosts FROM s_core_shops WHERE id = : id |
array:1 [ ":id" => 1 ] |
0.0001 ms |
SELECT template.id, template.id, template.template, template.plugin_id, template.parent_id, plugin.name as plugin_name, plugin.namespace as plugin_namespace, plugin.source as plugin_source FROM s_core_templates template LEFT JOIN s_core_plugins plugin ON plugin.id = template.plugin_id |
[] |
0.0001 ms |
SELECT org_path, path FROM s_core_rewrite_urls WHERE subshopID =: shopId AND org_path IN (: orgPath) AND main = 1 ORDER BY id DESC |
array:2 [ ":shopId" => 3 ":orgPath" => array:1 [ 0 => "sViewport=register&sAction=saveRegister" ] ] |
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=account&sAction=login" ] ] |
0.0003 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:80 [ 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=5" 73 => "sViewport=cat&sCategory=7" 74 => "sViewport=cat&sCategory=8" 75 => "sViewport=cat&sCategory=9" 76 => "sViewport=cat&sCategory=10" 77 => "sViewport=cat&sCategory=11" 78 => "sViewport=blog&sCategory=81" 79 => "sViewport=cat&sCategory=12" ] ] |
0.0009 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/cookie_consent/groups' ) AND (shopID = '3') AND (localeID = '2') |
[] |
0.0892 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.0460 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.0439 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.0429 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.0420 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.0410 ms |
SELECT id FROM s_order_basket WHERE sessionID = ? AND esdarticle = 1 LIMIT 1; |
array:1 [ 1 => "9f582cef1940ad7e0692311f650b0ae4" ] |
7.1459 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.0620 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.0610 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.0539 ms |
SELECT * FROM s_order_comparisons WHERE sessionID = ? |
array:1 [ 1 => "9f582cef1940ad7e0692311f650b0ae4" ] |
0.2010 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 => "9f582cef1940ad7e0692311f650b0ae4" 2 => 0 ] |
0.2031 ms |
SELECT `s_core_snippets`.`name`, `s_core_snippets`.`value` FROM `s_core_snippets` WHERE ( namespace = 'frontend/salutation' ) AND (shopID = '3') AND (localeID = '2') |
[] |
0.8578 ms |
SELECT `s_core_snippets`.`name`, `s_core_snippets`.`value` FROM `s_core_snippets` WHERE ( namespace = 'frontend/salutation' ) AND (shopID = '1') AND (localeID = '2') |
[] |
0.4799 ms |
SELECT `s_core_snippets`.`name`, `s_core_snippets`.`value` FROM `s_core_snippets` WHERE ( namespace = 'frontend/salutation' ) AND (shopID = '1') AND (localeID = '1') |
[] |
0.1600 ms |