|
Modo de Diseño: Parámetros Internos del Sitio Web |
| Ws_ID: 2defdd32-7141-4f72-ac82-7c1fabd335f0 |
| Page_Id: 9dd0065e-9203-4f4c-ab9c-4bf9016d1549 |
| WSU_Id: -1 |
| Parámetros de la Página: ;micompra;GBPWSTID=2defdd32-7141-4f72-ac82-7c1fabd335f0; |
| Cart Guid: 5d390451-bcbe-4e66-93aa-a421e91a1883 |
|
Estados Internos * cust_id:-1 * st_id:169 * dl_id:464 * cc_id:-1 * ccp_id:-1 * Cuotas:-1 * disc_id:1 * bra_id:29 * prli_id:13 * prof_id:1 * stor_id:41 * item_id:-1 * camp_id:-1 * |
| Comp_Id: 1 |
| Lang_Id: 2 |
| 18.188.245.104 |
| * WebSite Designer * |
|
|
|
Tiempo Total de Proceso: 0 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 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 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 = '2defdd32-7141-4f72-ac82-7c1fabd335f0' Tiempo Consumido: 00:00:00 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, 29, getDate() , 29, -1) ) as credito WHERE comp_id=1 and cust_id =-1 Tiempo Consumido: 00:00:00 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= 169 AND comp_id=1 AND ccp_id is not null Tiempo Consumido: 00:00:00 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 = '5d390451-bcbe-4e66-93aa-a421e91a1883' and item_id = 5254 Tiempo Consumido: 00:00:00.0156241 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_totalPriceInBranchCurrencyWithTaxes) [tis_priceInBranchCurrencyWithTaxes], dbo.fnStrAllTrim(ISNULL(vis.item_code ,vis.item_code)) [item_code], 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 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 = '5d390451-bcbe-4e66-93aa-a421e91a1883' Tiempo Consumido: 00:00:00.0937211 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, 100) ELSE SUBSTRING (td.dl_Note , 1, 100) 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 = '2defdd32-7141-4f72-ac82-7c1fabd335f0' Tiempo Consumido: 00:00:00.0156563 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 = '2defdd32-7141-4f72-ac82-7c1fabd335f0' AND tb2.dl_id = 464 GROUP BY st.st_id, st.st_desc,st.st_webSiteDecription Tiempo Consumido: 00:00:00.0156256 |
|
|