¡Realizamos envios a todo el país!

MI COMPRA

CARRITO ENVIO PAGO
Desde 2001 brindando asesoramiento y soluciones en tecnologia.

Powered by GlobalBluePoint© ERP



Modo de Diseño: Parámetros Internos del Sitio Web
Ws_ID: f1b68b65-c10e-4126-b085-5d74e97875e6
Page_Id: 972db931-c700-4be5-9050-d9380700e5be
WSU_Id: -1
Parámetros de la Página: ;micompra;GBPWSTID=f1b68b65-c10e-4126-b085-5d74e97875e6;
Cart Guid: 9d19d4ac-22fc-4f5b-a54b-0a2871e197c6

Estados Internos
* cust_id:-1 * st_id:111 * dl_id:9 * cc_id:-1 * ccp_id:-1 * Cuotas:-1 * disc_id:7 * bra_id:34 * prli_id:31 * prof_id:45 * stor_id:30 * item_id:-1 * camp_id:-1 *

Comp_Id: 18
Lang_Id: 2
216.73.216.90
* WebSite Designer *


Tiempo Total de Proceso: 1 Segundos.


Ultimos SQL Ejecutados:


GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ws_newCustomerAllowed, ws_manage_showStockSemaphore , ws_manage_hidePricesIfNotLogged FROM tbWebSiteII_Names WHERE comp_id=18 AND ws_id = 'f1b68b65-c10e-4126-b085-5d74e97875e6'

Tiempo Consumido: 00:00:00.0010011


GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT cust_name FROM tbCustomer WHERE cust_id = -1

Tiempo Consumido: 00:00:00.0010011


GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT convert (decimal(16,2), dbo.fnGetExchange2('18', 1, 2,1, 0, 0, 0, 'False'))

Tiempo Consumido: 00:00:00.0010006

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.CAT_ID, CASE WHEN TC.cat_WebSite_desc <> '' THEN SUBSTRING (TC.cat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.cat_desc, 1, 50) END [cat_WebSite_desc], dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc) FROM TBCATEGORY TC INNER JOIN tbWebSiteII_CategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.prli_id = 31 WHERE TC.CAT_WEB = 'TRUE' GROUP BY TC.CAT_ID, TC.cat_WebSite_desc, TC.cat_desc, tc.cat_web_order ORDER BY tc.cat_web_order ASC, tc.cat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0079795

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 31 AND tmp2.ws_id='f1b68b65-c10e-4126-b085-5d74e97875e6' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 76 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0060047

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 31 AND tmp2.ws_id='f1b68b65-c10e-4126-b085-5d74e97875e6' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 80 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0080088

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 31 AND tmp2.ws_id='f1b68b65-c10e-4126-b085-5d74e97875e6' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 61 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0070369

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 31 AND tmp2.ws_id='f1b68b65-c10e-4126-b085-5d74e97875e6' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 70 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0080082

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 31 AND tmp2.ws_id='f1b68b65-c10e-4126-b085-5d74e97875e6' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 88 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0069779

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 31 AND tmp2.ws_id='f1b68b65-c10e-4126-b085-5d74e97875e6' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 86 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0079805

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 31 AND tmp2.ws_id='f1b68b65-c10e-4126-b085-5d74e97875e6' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 63 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0080107

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id and tmp2.prli_id = 31 AND tmp2.ws_id='f1b68b65-c10e-4126-b085-5d74e97875e6' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 72 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0059788

GBP_LIST: MARCAS
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT brand_id, brand_desc FROM tbBrand WHERE brand_note2 like '%M%' Order By brand_desc

Tiempo Consumido: 00:00:00.0050328


GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT cust_name, cust_taxNumber, c.fc_id, CASE WHEN fc.fc_desc <> '' THEN fc.fc_desc ELSE 'Consumidor Final' END [fc_desc], convert (decimal(16,2), CASE WHEN credito.disponible » 0 THEN credito.disponible ELSE 0 END) FROM tbCustomer c LEFT JOIN tbsysFiscalClass fc on c.fc_id=fc.fc_id CROSS APPLY ( SELECT (cust_credit_max - cust_credit_cheque_own_used - cust_credit_cheque_3rd_used - cust_credit_balance - cust_credit_SaleOrder) as disponible FROM dbo.fnCustomer_getBalanceStatus(c.comp_id, c.curr_id, c.cust_id, 34, getDate() , 34, -1) ) as credito WHERE comp_id=18 and cust_id =-1

Tiempo Consumido: 00:00:00.0160150


GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ISNULL(tis_id,0) FROM [vwWebSiteII_tempItemStock] WHERE tis_guid = '9d19d4ac-22fc-4f5b-a54b-0a2871e197c6' and item_id in('2979') and comp_id=18

Tiempo Consumido: 00:00:00.0480471

GBP_LIST: LISTA_CHECKOUT
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT vis.tis_id, vis.item_id, CASE WHEN vis.item_WebSite_desc <> '' THEN SUBSTRING (vis.item_WebSite_desc, 1, 80) ELSE SUBSTRING (vis.item_desc, 1, 80) END [vis.item_WebSite_desc], convert (decimal(16,0), vis.tis_qty) [tis_qty], FORMAT(vis.tis_OriginalPriceInBranchCurrencyWithTaxes,'N2','de-DE') AS 'Numeric Format', --REPLACE(format(CAST(vis.tis_OriginalPriceInBranchCurrencyWithTaxes AS INT), 'N', 'de-de'),',00','') AS 'Numeric Format', dbo.fnStrAllTrim(ISNULL(vis.item_code ,vis.item_code)) [item_code], FORMAT(vis.tis_qty * vis.tis_OriginalPriceInBranchCurrencyWithTaxes,'N2','de-DE') AS 'Numeric Format', --REPLACE(format(CAST(vis.tis_qty * vis.tis_OriginalPriceInBranchCurrencyWithTaxes AS INT), 'N', 'de-de'),',00','') AS 'Numeric Format', --convert (decimal(16,2), vis.tis_qty * vis.tis_totalPriceInBranchCurrencyWithTaxes) [subTotal], vis.tis_isDeliveryCharge, vis.isItemAsociation, vis.tis_isParentAssociate, vis.tis_isEnvioPackItem, convert (decimal(16,2), ttn.tax_percentage) [IVA], tis_itemDiscount, CASE WHEN vis.tis_isChildAssociate <> 'True' THEN '' ELSE 'disabled' END [vis.tis_isChildAssociate], (SELECT TOP 1 CASE WHEN vwsiii.imageCodeOrURL IS NULL THEN 'http://gbp47.globalbluepoint.com/irion/Temp/App_WebSite/App_PictureFiles/Items/' + dbo.fnStrAllTrim(tpli2.item_code) + '_100.jpg' ELSE vwsiii.imageCodeOrURL END AS item_img FROM tbItem tpli2 LEFT JOIN vwWebSiteII_ItemsImages AS vwsiii ON vwsiii.item_id = tpli2.item_id AND vwsiii.imageType » 2 WHERE tpli2.item_id = vis.item_id) FROM vwWebSiteII_tempItemStock vis LEFT JOIN tbItemTaxes tit ON tit.item_id=vis.item_id AND tit.comp_id=vis.comp_id LEFT JOIN tbTaxName ttn ON ttn.tax_id=tit.tax_id AND ttn.comp_id=tit.comp_id and ttn.tax_class=1 WHERE tis_guid = '9d19d4ac-22fc-4f5b-a54b-0a2871e197c6' and vis.item_id IS NOT NULL and vis.item_id != 28760 ORDER BY vis.tis_isDeliveryCharge

Tiempo Consumido: 00:00:00.2072324