|
Modo de Diseño: Parámetros Internos del Sitio Web |
| Ws_ID: ad2cd11b-a122-4b45-b062-9ab879d93aa5 |
| Page_Id: 9dd0065e-9203-4f4c-ab9c-4bf9016d1549 |
| WSU_Id: -1 |
| Parámetros de la Página: ;mycart;GBPWSTID=ad2cd11b-a122-4b45-b062-9ab879d93aa5; |
| Cart Guid: 9bb4400e-0214-4418-8711-e7975158c6c0 |
|
Estados Internos * cust_id:-1 * st_id:1 * dl_id:1 * cc_id:-1 * ccp_id:-1 * Cuotas:-1 * disc_id:1 * bra_id:54 * prli_id:1 * prof_id:1 * stor_id:32 * item_id:-1 * camp_id:-1 * |
| Comp_Id: 1 |
| Lang_Id: 2 |
| 3.12.154.121 |
| * WebSite Designer * |
|
|
|
Tiempo Total de Proceso: 3 Segundos. Ultimos SQL Ejecutados: 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.0010026 GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT convert (decimal(16,2), dbo.fnGetExchange2('1', 1, 2,1, 0, 0, 0, 'False')) Tiempo Consumido: 00:00:00.0020012 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=1 AND ws_id = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' Tiempo Consumido: 00:00:00.0010011 GBP_LIST: SCATAUX SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT CATG_ID, catg_desc FROM TBCATEGORYGROUP WHERE comp_id=1 AND catg_webNOTE1 <> 'N' ORDER BY CAST(catg_webNOTE1 AS INT) asc Tiempo Consumido: 00:00:00.0060115 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, 54, getDate() , 54, -1) ) as credito WHERE comp_id=1 and cust_id =-1 Tiempo Consumido: 00:00:00.0020042 GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT COUNT( ccp_id ) FROM [vwWebSiteII_salesTerms] WHERE st_id= 1 AND comp_id=1 AND ccp_id is not null Tiempo Consumido: 00:00:00.0020017 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 = '9bb4400e-0214-4418-8711-e7975158c6c0' and item_id = 30889 Tiempo Consumido: 00:00:00.0390651 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], --convert (decimal(16,2), vis.tis_totalPriceInBranchCurrencyWithTaxesNoDiscount) [tis_priceInBranchCurrencyWithTaxes], convert (decimal(16,2), vis.tis_OriginalPriceInBranchCurrencyWithTaxes) [tis_OriginalPriceInBranchCurrencyWithTaxes], dbo.fnStrAllTrim(ISNULL(vis.item_code ,vis.item_code)) [item_code], convert (decimal(16,2), vis.tis_qty * vis.tis_OriginalPriceInBranchCurrencyWithTaxes) [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], vis.tis_isDeliveryCharge 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 = '9bb4400e-0214-4418-8711-e7975158c6c0' and vis.item_id IS NOT NULL Tiempo Consumido: 00:00:00.0490786 GBP_LIST: LISTA_DELIVERY SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; select distinct td.dl_id, CASE WHEN td.dl_webSiteDecription <> '' THEN SUBSTRING (td.dl_webSiteDecription, 1, 100) ELSE SUBSTRING (td.dl_name, 1, 100) END [descripcion], CASE WHEN td.dl_webSiteNote <> '' THEN SUBSTRING (td.dl_webSiteNote, 1, 300) ELSE SUBSTRING (td.dl_Note , 1, 300) END [nota], ZIPPIN_enabled from tbDelivery td inner join tbWebSiteII_DeliverySalesTermsRelation dstr on dstr.dl_id = td.dl_id where dl_available4WebSite = 1 and dstr.ws_id = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' Tiempo Consumido: 00:00:00.0090108 GBP_LIST: LISTA_SALESTERMS SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT st.st_id, CASE WHEN st.st_webSiteDecription <> '' THEN SUBSTRING (st.st_webSiteDecription, 1, 100) ELSE SUBSTRING (st.st_desc, 1, 100) END [descripcion], COUNT(stv.ccp_id) as CANTCCP from tbWebSiteII_DeliverySalesTermsRelation tb2 inner join tbSalesTerms st on st.st_id = tb2.st_id left join vwWebSiteII_salesTerms stv on st.st_id = stv.st_id where st.st_available4WebSite = 1 and tb2.ws_id = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' AND tb2.dl_id = 1 GROUP BY st.st_id, st.st_desc,st.st_webSiteDecription Tiempo Consumido: 00:00:00.0070052 GBP_LIST: LISTA_CREDITCARDPLANS SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT st.ccp_id, st.ccp_desc, st.spgw_id, tcc.DECIDIR_enabled, tcc.DECIDIR_PrivateApiKey, tcc.DECIDIR_PublicApiKey FROM [vwWebSiteII_salesTerms] st LEFT JOIN tbCreditCardLoanPlan tcc ON st.ccp_id = tcc.ccp_id WHERE st.comp_id=1 AND st.st_id =1 AND st.ccp_id is not null Order By st.ccp_desc Tiempo Consumido: 00:00:00.0060056 GBP_LIST: LISTA_CREDITCARDPLANS SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT st.ccp_id, st.ccp_desc, st.spgw_id, tcc.DECIDIR_enabled, tcc.DECIDIR_PrivateApiKey, tcc.DECIDIR_PublicApiKey FROM [vwWebSiteII_salesTerms] st LEFT JOIN tbCreditCardLoanPlan tcc ON st.ccp_id = tcc.ccp_id WHERE st.comp_id=1 AND st.st_id =24 AND st.ccp_id is not null Order By st.ccp_desc Tiempo Consumido: 00:00:00.0060392 GBP_LIST: LISTA_CREDITCARDPLANS SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT st.ccp_id, st.ccp_desc, st.spgw_id, tcc.DECIDIR_enabled, tcc.DECIDIR_PrivateApiKey, tcc.DECIDIR_PublicApiKey FROM [vwWebSiteII_salesTerms] st LEFT JOIN tbCreditCardLoanPlan tcc ON st.ccp_id = tcc.ccp_id WHERE st.comp_id=1 AND st.st_id =41 AND st.ccp_id is not null Order By st.ccp_desc Tiempo Consumido: 00:00:00.0070081 GBP_LIST: LISTA_CREDITCARDPLANS SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT st.ccp_id, st.ccp_desc, st.spgw_id, tcc.DECIDIR_enabled, tcc.DECIDIR_PrivateApiKey, tcc.DECIDIR_PublicApiKey FROM [vwWebSiteII_salesTerms] st LEFT JOIN tbCreditCardLoanPlan tcc ON st.ccp_id = tcc.ccp_id WHERE st.comp_id=1 AND st.st_id =48 AND st.ccp_id is not null Order By st.ccp_desc Tiempo Consumido: 00:00:00.0070379 GBP_LIST: LISTA_CREDITCARDPLANS SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT st.ccp_id, st.ccp_desc, st.spgw_id, tcc.DECIDIR_enabled, tcc.DECIDIR_PrivateApiKey, tcc.DECIDIR_PublicApiKey FROM [vwWebSiteII_salesTerms] st LEFT JOIN tbCreditCardLoanPlan tcc ON st.ccp_id = tcc.ccp_id WHERE st.comp_id=1 AND st.st_id =49 AND st.ccp_id is not null Order By st.ccp_desc Tiempo Consumido: 00:00:00.0070067 GBP_LIST: LISTA_CREDITCARDPLANS SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT st.ccp_id, st.ccp_desc, st.spgw_id, tcc.DECIDIR_enabled, tcc.DECIDIR_PrivateApiKey, tcc.DECIDIR_PublicApiKey FROM [vwWebSiteII_salesTerms] st LEFT JOIN tbCreditCardLoanPlan tcc ON st.ccp_id = tcc.ccp_id WHERE st.comp_id=1 AND st.st_id =50 AND st.ccp_id is not null Order By st.ccp_desc Tiempo Consumido: 00:00:00.0060027 GBP_LIST: LISTA_CREDITCARDPLANS SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT st.ccp_id, st.ccp_desc, st.spgw_id, tcc.DECIDIR_enabled, tcc.DECIDIR_PrivateApiKey, tcc.DECIDIR_PublicApiKey FROM [vwWebSiteII_salesTerms] st LEFT JOIN tbCreditCardLoanPlan tcc ON st.ccp_id = tcc.ccp_id WHERE st.comp_id=1 AND st.st_id =51 AND st.ccp_id is not null Order By st.ccp_desc Tiempo Consumido: 00:00:00.0069750 GBP_LIST: LISTA_CREDITCARDPLANS SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT st.ccp_id, st.ccp_desc, st.spgw_id, tcc.DECIDIR_enabled, tcc.DECIDIR_PrivateApiKey, tcc.DECIDIR_PublicApiKey FROM [vwWebSiteII_salesTerms] st LEFT JOIN tbCreditCardLoanPlan tcc ON st.ccp_id = tcc.ccp_id WHERE st.comp_id=1 AND st.st_id =52 AND st.ccp_id is not null Order By st.ccp_desc Tiempo Consumido: 00:00:00.0070530 |
|
|
