Distribuidora Mayorista con venta directa

Mi compra




Modo de Diseño: Parámetros Internos del Sitio Web

Ws_ID: 9af6db34-3ada-47ce-b029-1f91212586a2
Page_Id: 004e44c4-a480-4147-8df1-411d4f056df7
WSU_Id: -1
Parámetros de la Página: ;mycart;GBPWSTID=9af6db34-3ada-47ce-b029-1f91212586a2;
Cart Guid: c31264db-dec3-4924-bfc4-d6c65fcbc1d8

Estados Internos
* cust_id:-1 * st_id:1 * dl_id:1 * cc_id:-1 * ccp_id:-1 * Cuotas:-1 * disc_id:1 * bra_id:1 * prli_id:1 * prof_id:1 * stor_id:1 * item_id:-1 * camp_id:-1 *

Comp_Id: 1
Lang_Id: 2
3.235.31.131
* WebSite Designer *



Tiempo Total de Proceso: 0 Segundos.



Ultimos SQL Ejecutados:


GBP_REPLACE:
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 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 = '9af6db34-3ada-47ce-b029-1f91212586a2'

Tiempo Consumido: 00:00:00





GBP_REPLACE:
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_LIST: SCATAUX
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] 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 = 1 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





GBP_LIST: SCAT1
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 FROM tbSubCategory tc INNER JOIN vwWebSiteII_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 = 1 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 47 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.0156319





GBP_LIST: SCAT1
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 FROM tbSubCategory tc INNER JOIN vwWebSiteII_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 = 1 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 46 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.0156547





GBP_LIST: SCAT1
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 FROM tbSubCategory tc INNER JOIN vwWebSiteII_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 = 1 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 48 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.0156230





GBP_LIST: SCAT1
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 FROM tbSubCategory tc INNER JOIN vwWebSiteII_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 = 1 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 51 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.0156601





GBP_LIST: SCAT1
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 FROM tbSubCategory tc INNER JOIN vwWebSiteII_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 = 1 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 50 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





GBP_LIST: SCAT1
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 FROM tbSubCategory tc INNER JOIN vwWebSiteII_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 = 1 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 1 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





GBP_REPLACE:
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, 1, getDate() , 1, -1) ) as credito WHERE comp_id=1 and cust_id =-1

Tiempo Consumido: 00:00:00.0312856





GBP_REPLACE:
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.0312802





GBP_LIST: LISTA_CHECKOUT
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_priceInBranchCurrencyWithTaxes) [tis_priceInBranchCurrency], dbo.fnStrAllTrim(ISNULL(vis.item_code ,vis.item_code)) [item_code], convert (decimal(16,2), vis.tis_qty * vis.tis_priceInBranchCurrencyWithTaxes) [subTotal], vis.tis_isDeliveryCharge, vis.isItemAsociation, vis.tis_isParentAssociate, convert (decimal(16,2), ttn.tax_percentage) [IVA] 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 = 'c31264db-dec3-4924-bfc4-d6c65fcbc1d8'

Tiempo Consumido: 00:00:00.1250121





GBP_LIST: LISTA_DELIVERY
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], ENVIOPACK_enabled from tbDelivery td inner join tbWebSiteII_DeliverySalesTermsRelation dstr on dstr.dl_id = td.dl_id where dl_available4WebSite = 1 and dstr.ws_id = '9af6db34-3ada-47ce-b029-1f91212586a2'

Tiempo Consumido: 00:00:00.0156274





GBP_LIST: LISTA_SALESTERMS
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 = '9af6db34-3ada-47ce-b029-1f91212586a2' AND tb2.dl_id = 1 GROUP BY st.st_id, st.st_desc,st.st_webSiteDecription

Tiempo Consumido: 00:00:00.0625029





GBP_LIST: LISTA_CREDITCARDPLANS
SET LOCK_TIMEOUT 1000 SET DEADLOCK_PRIORITY LOW SELECT ccp_id,ccp_desc,spgw_id FROM [vwWebSiteII_salesTerms] WHERE st_id =1 AND comp_id=1 AND ccp_id is not null AND (brag_id = 23 OR brag_id IS NULL)

Tiempo Consumido: 00:00:00.0312256





GBP_LIST: LISTA_CREDITCARDPLANS
SET LOCK_TIMEOUT 1000 SET DEADLOCK_PRIORITY LOW SELECT ccp_id,ccp_desc,spgw_id FROM [vwWebSiteII_salesTerms] WHERE st_id =29 AND comp_id=1 AND ccp_id is not null AND (brag_id = 23 OR brag_id IS NULL)

Tiempo Consumido: 00:00:00.0312300