Contado Efectivo
Transferencia Bancaria
Débito / Crédito
Modo de Diseño: Parámetros Internos del Sitio Web |
Ws_ID: ad2cd11b-a122-4b45-b062-9ab879d93aa5 |
Page_Id: d7bdca12-2b67-4aea-a267-dc8b93edfe00 |
WSU_Id: -1 |
Parámetros de la Página: ;BOTA-CAT-CASUAL-PRIM-ACORDONADA-MARRON-TALLE-39-CAT135232T7;ITEM_ID=33716;GBPWSTID=ad2cd11b-a122-4b45-b062-9ab879d93aa5; |
Cart Guid: 979aec63-06d5-4a81-afbe-9eec447ec3e9 |
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:12 * prof_id:1 * stor_id:32 * item_id:-1 * camp_id:-1 * |
Comp_Id: 1 |
Lang_Id: 2 |
18.224.60.155 |
* WebSite Designer * |
|
Tiempo Total de Proceso: 1 Segundos. Ultimos SQL Ejecutados: GBP_LIST: ITEM SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tc.Size_code, tc.Size_desc, '', '' FROM vwWebSiteII_itemSizeColor tc WHERE tc.item_id = 33716 and tc.comp_id=1 GROUP BY tc.Size_code, tc.Size_desc Tiempo Consumido: 00:00:00.0312490 GBP_LIST: ITEM SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tc.itemID4SizeColor, '', tc.Size_code, tc.color_code FROM vwWebSiteII_itemSizeColor tc WHERE tc.item_id = 33716 and tc.comp_id=1 GROUP BY tc.itemID4SizeColor, tc.color_code, tc.Size_code Tiempo Consumido: 00:00:00.0312797 GBP_LIST: ITEM SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tc.itemID4SizeColor, CASE WHEN -1 = -1 AND '' <> '' THEN (SELECT '') else convert(nvarchar(20),convert(decimal(16,2), tpli.prli_price)) END [price], c.curr_symbol, tc.Item_id FROM vwWebSiteII_itemSizeColor tc INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = tc.comp_id AND tpli.item_id = tc.itemID4SizeColor AND tpli.prli_id = 12 AND tpli.ws_id = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' INNER JOIN tbsysCurrency c ON c.curr_id = tpli.curr_id WHERE tc.item_id = 33716 AND tc.comp_id=1 AND tpli.ws_id = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' GROUP BY tc.itemID4SizeColor, tpli.prli_price,c.curr_symbol,tc.Item_id Tiempo Consumido: 00:00:00.0468491 GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ti.item_id, CASE WHEN ti.item_website_desc<>'' THEN ti.item_website_desc ELSE ti.item_desc END [item_desc], dbo.fnStrAllTrim(ti.item_code) [item_code], ti.item_annotation1 FROM tbitem ti WHERE ti.item_id = 33716 Tiempo Consumido: 00:00:00.0156211 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 = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' Tiempo Consumido: 00:00:00 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.0156279 GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ti.item_made, tpli.semaphoreValue, ti.Item_id, CASE WHEN ti.item_website_desc<>'' THEN SUBSTRING (ti.item_website_desc, 1, 75) ELSE SUBSTRING (ti.item_desc, 1, 75) END [item_desc], SUBSTRING (ti.item_annotation1, 1, 18), dbo.fnStrAllTrim(ti.item_code) [item_code], ti.item_vendorCode, ti.brand_id, ti.item_annotation1, REPLACE(ti.item_annotation2, Char(10), '«br/»'), SUBSTRING (ti.item_annotation2, 1, 100), ti.item_descHTML, tbn.wssn_isNovelty, tbn.wssn_is4Sale, item_WebSite_vendorPage, REPLACE(format(convert(decimal(16,0), tpli.prli_price), 'N', 'de-de'),',00',''), format( (1 * tpli.prli_price/3) , 'N', 'de-de') AS 'Numeric Format', format( (1.10 * tpli.prli_price/6) , 'N', 'de-de') AS 'Numeric Format', format( (1.30 * tpli.prli_price/12) , 'N', 'de-de') AS 'Numeric Format', format( (1.50 * tpli.prli_price/18) , 'N', 'de-de') AS 'Numeric Format', format( (1.7504 * tpli.prli_price/24) , 'N', 'de-de') AS 'Numeric Format', format( (1 * tpli.prli_price) , 'N', 'de-de') AS 'Numeric Format', format( (1.10 * tpli.prli_price) , 'N', 'de-de') AS 'Numeric Format', format( (1.30 * tpli.prli_price) , 'N', 'de-de') AS 'Numeric Format', format( (1.50 * tpli.prli_price) , 'N', 'de-de') AS 'Numeric Format', format( (1.7504 * tpli.prli_price) , 'N', 'de-de') AS 'Numeric Format', tc.curr_symbol, tbr.brand_desc, tcat.cat_desc, tsub.subcat_desc, tcat.cat_id, tsub.subcat_id, convert (decimal(16,2), ttn.tax_percentage) [IVA], REPLACE(ti.item_code,'/','--'), CASE WHEN ti.item_NoStockCheck='true' AND ti.item_web = 'true' AND (ti.item_isForAssociation='false' OR ti.item_annotation1 like '%@@GRISAR%' ) THEN 'True' ELSE 'False' END [grisar_boton] , --convert(nvarchar(20),convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0'))), REPLACE (format(convert(decimal(16,0), isnull(tpli.strikeThroughPrice,'0')), 'N', 'de-de'),',00',''), CASE WHEN convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0')) » convert(decimal(16,2), tpli.prli_price) THEN 'True' else 'False' END [PRECIOTACHADOMOSTRAR], CASE WHEN convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0')) » 0 THEN convert(decimal(16,0),(-1 * (((tpli.prli_price * 100)/tpli.strikeThroughPrice) -100))) ELSE 0 END FROM tbitem ti INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = ti.comp_id AND tpli.item_id = ti.item_id AND tpli.prli_id = 12 AND tpli.ws_id = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' INNER JOIN tbsysCurrency tc ON tc.curr_id = tpli.curr_id INNER JOIN tbBrand tbr ON ti.brand_id = tbr.brand_id INNER JOIN tbCategory tcat ON tcat.cat_id = ti.cat_id INNER JOIN tbSubCategory tsub ON tsub.subcat_id = ti.subcat_id LEFT JOIN tbWebSiteII_Items_NoveltyAnd4Sale tbn ON tbn.comp_id = ti.comp_id AND ti.item_id = tbn.item_id AND tbn.ws_id = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' LEFT JOIN tbItemTaxes tit ON tit.item_id=ti.item_id AND tit.comp_id=ti.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 ti.item_id = 33716 Tiempo Consumido: 00:00:00.0781279 GBP_LIST: GALERIADETALLE SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tii.itimg_id ,ti.item_desc FROM tbItemImages tii INNER JOIN tbItem ti ON ti.item_id = tii.item_id WHERE tii.item_id = 33716 Tiempo Consumido: 00:00:00.0156236 GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ti.item_id, ti.subcat_id FROM tbitem ti WHERE ti.item_id = 33716 Tiempo Consumido: 00:00:00 GBP_LIST: BODY_LIQ SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ti.item_made, tpli.semaphoreValue, ti.Item_id, CASE WHEN ti.item_website_desc<>'' THEN SUBSTRING (ti.item_website_desc, 1, 50) ELSE SUBSTRING (ti.item_desc, 1, 50) END [item_desc], SUBSTRING (ti.item_annotation1, 1, 20), dbo.fnStrAllTrim(ti.item_code) [item_code], ti.item_vendorCode, ti.brand_id, ti.item_annotation2, SUBSTRING (ti.item_annotation2, 1, 90), tbn.wssn_isNovelty, tbn.wssn_is4Sale, item_WebSite_vendorPage, CASE WHEN -1 = -1 AND '' <> '' THEN (SELECT '') else REPLACE(format(convert(decimal(16,0), tpli.prli_price), 'N', 'de-de'),',00','') END [price], tc.curr_symbol, tbr.brand_desc, CASE WHEN i4c.item_id = ti.item_id THEN '«a href=http://gbp47s.globalbluepoint.com/colucci/COMPARA/X/GBPWSTID=ad2cd11b-a122-4b45-b062-9ab879d93aa5/gbpwst.aspx»Ver Comparacion«/a»' else 'Comparar' END [checked], convert (decimal(16,2), ttn.tax_percentage) [IVA], CASE WHEN ti.item_website_desc<>'' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(ti.item_website_desc), 1, 100) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(ti.item_desc), 1, 100) END [item_desc] , REPLACE(ti.item_code,'/','--') , --convert(nvarchar(20),convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0'))), REPLACE (format(convert(decimal(16,0), isnull(tpli.strikeThroughPrice,'0')), 'N', 'de-de'),',00',''), CASE WHEN convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0')) » convert(decimal(16,2), tpli.prli_price) THEN 'True' else 'False' END [PRECIOTACHADOMOSTRAR], CASE WHEN convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0')) » 0 THEN convert(decimal(16,0),(-1 * (((tpli.prli_price * 100)/tpli.strikeThroughPrice) -100))) ELSE 0 END FROM tbitem ti INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = ti.comp_id AND tpli.item_id = ti.item_id AND tpli.prli_id = 12 AND tpli.ws_id = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' INNER JOIN tbsysCurrency tc ON tc.curr_id = tpli.curr_id INNER JOIN tbBrand tbr ON ti.brand_id = tbr.brand_id INNER JOIN tbSubCategory tsub ON tsub.subcat_id = ti.subcat_id INNER JOIN tbCategory tcat ON tcat.cat_id = ti.cat_id LEFT JOIN tbWebSiteII_Items_NoveltyAnd4Sale tbn ON tbn.comp_id = ti.comp_id AND ti.item_id = tbn.item_id AND tbn.ws_id = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' LEFT JOIN tbWebSiteII_TMPItem4Compare i4c On i4c.item_id = ti.item_id and i4c.ws_guid = '979aec63-06d5-4a81-afbe-9eec447ec3e9' LEFT JOIN tbItemTaxes tit ON tit.item_id=ti.item_id AND tit.comp_id=ti.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 ti.item_web = 'true' AND ti.item_id <> '33716' and ti.subcat_id = '4646' Tiempo Consumido: 00:00:00.1836276 |
|