-->
DISPENSER
DISPENSER JUMBO X 350MTS BRILLANTE
CODIGO: 10111
Espesor: 0,6mm
Llave de seguridad: Si
Diámetro del canuto: 4 ó 7cm
Aptos para rollos de: hasta 350mts
Diámetro: 21,8cm
Profundidad: 11,7cm
Alto: 22cm
ARS 90550.35
Fabricado en acero inoxidable brillante, calidad 430 (inoxidable al agua).
NO APTO PARA PRODUCTOS QUÍMICOS
Posee cerradura tanque.
Con cono chico de 4cm de diámetro, adaptable al cono grande de 7cm de diámetro.
Medidas: alto 22 cm, diámetro 21,5, prof
Productos relacionados
|
Modo de Diseño: Parámetros Internos del Sitio Web |
| Ws_ID: 9af6db34-3ada-47ce-b029-1f91212586a2 |
| Page_Id: f4f9b517-98df-4759-96b5-fec28d625817 |
| WSU_Id: -1 |
| Parámetros de la Página: ;ITEM_ID=147;OR=;H=;CANT=;GBPWSTID=9af6db34-3ada-47ce-b029-1f91212586a2; |
| Cart Guid: ad323f04-bb05-4e9d-9c98-513262199d87 |
|
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:17 * stor_id:1 * item_id:-1 * camp_id:-1 * |
| Comp_Id: 1 |
| Lang_Id: 2 |
| 3.147.103.8 |
| * 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 = 147 and tc.comp_id=1 GROUP BY tc.Size_code, tc.Size_desc Tiempo Consumido: 00:00:00.0312504 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 = 147 and tc.comp_id=1 GROUP BY tc.itemID4SizeColor, tc.color_code, tc.Size_code Tiempo Consumido: 00:00:00.0312812 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 = 1 AND tpli.ws_id = '9af6db34-3ada-47ce-b029-1f91212586a2' INNER JOIN tbsysCurrency c ON c.curr_id = tpli.curr_id WHERE tc.item_id = 147 AND tc.comp_id=1 AND tpli.ws_id = '9af6db34-3ada-47ce-b029-1f91212586a2' GROUP BY tc.itemID4SizeColor, tpli.prli_price,c.curr_symbol,tc.Item_id Tiempo Consumido: 00:00:00.0624970 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 = 147 Tiempo Consumido: 00:00:00 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 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 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_LIST: SCATAUX 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] 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 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 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.0312471 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 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 = 58 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 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 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 = 53 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.0312685 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 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.0781054 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 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.0468764 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 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 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 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.0312188 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.item_annotation1, ti.item_annotation2, ti.item_annotation, SUBSTRING (ti.item_annotation2, 1, 100), ti.item_descHTML, tbn.wssn_isNovelty, tbn.wssn_is4Sale, item_WebSite_vendorPage, CASE WHEN -1 = -1 AND '' <> '' THEN (SELECT '') else convert(nvarchar(20),convert(decimal(16,2), tpli.prli_price)) END [price], tc.curr_symbol, tbr.brand_desc, tbr.brand_id, tcat.cat_desc, tsub.subcat_desc, tcat.cat_id, tsub.subcat_id, convert (decimal(16,2), ttn.tax_percentage) [IVA], convert(nvarchar(20),convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0'))), CASE WHEN convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0')) » convert(decimal(16,2), tpli.prli_price) THEN 'True' else 'False' END [PRECIOTACHADOMOSTRAR] 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 = 1 AND tpli.ws_id = '9af6db34-3ada-47ce-b029-1f91212586a2' 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 = '9af6db34-3ada-47ce-b029-1f91212586a2' 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 = 147 Tiempo Consumido: 00:00:00.0624994 GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT CASE WHEN COUNT(tc.item_id) » 0 THEN 'block' ELSE 'none' END [cantidad] FROM tbitem ti LEFT JOIN vwWebSiteII_itemSizeColor tc ON tc.comp_id = ti.comp_id AND tc.item_id = ti.item_id WHERE ti.item_id = 147 and ti.comp_id=1 GROUP BY tc.item_id Tiempo Consumido: 00:00:00.0312529 GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT CASE WHEN COUNT(tpdf.item_id) » 0 THEN 'block' ELSE 'none' END [mostrar], CASE WHEN COUNT(tpdf.item_id) » 0 THEN 'none' ELSE 'block' END [no_mostrar] FROM tbItemPDF tpdf WHERE tpdf.item_id = 147 and tpdf.comp_id=1 Tiempo Consumido: 00:00:00 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 = 147 Tiempo Consumido: 00:00:00.0156241 GBP_LIST: LISTADODOCUMENTOS SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tpdf.itpdf_id , ISNULL(tpdf.itpdf_desc,'') FROM tbItemPDF tpdf WHERE tpdf.item_id = 147 AND tpdf.comp_id = 1 ORDER BY tpdf.itpdf_order Tiempo Consumido: 00:00:00.0156274 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 = 147 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 convert(nvarchar(20),convert(decimal(16,2), tpli.prli_price)) END [price], tc.curr_symbol, tbr.brand_desc, CASE WHEN i4c.item_id = ti.item_id THEN '«a href=http://gbp47.globalbluepoint.com/vileni/COMPARA/X/GBPWSTID=9af6db34-3ada-47ce-b029-1f91212586a2/gbpwst.aspx»Ver Comparacion«/a»' else 'Comparar' END [checked], convert (decimal(16,2), ttn.tax_percentage) [IVA], convert(nvarchar(20),convert(decimal(16,2), isnull(tpli.strikeThroughPriceNOTaxes,'0'))), CASE WHEN convert(decimal(16,2), isnull(tpli.strikeThroughPriceNOTaxes,'0')) » convert(decimal(16,2), tpli.prli_price) THEN 'True' else 'False' END [PRECIOTACHADOMOSTRAR] 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 = 1 AND tpli.ws_id = '9af6db34-3ada-47ce-b029-1f91212586a2' 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 = '9af6db34-3ada-47ce-b029-1f91212586a2' LEFT JOIN tbWebSiteII_TMPItem4Compare i4c On i4c.item_id = ti.item_id and i4c.ws_guid = 'ad323f04-bb05-4e9d-9c98-513262199d87' 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 <> '147' and ti.subcat_id = '3887' Tiempo Consumido: 00:00:00.0937226 |
|
|