aaaa KIT DENTAL EN BOLSITA
Cod: 1900 Ideal para llevar en la cartera o mochila y tenerlo siempre por las dudas, de tamaño peque
ARS $118.92
aaaa COLGATE HILO DENTAL (2X1) X 50 MT
Cod: 7891024183120 Remueve los residuos que son la principal causa de las bacterias que causan la placa y la
ARS $3964.34
aaaa COLGATE CEP TWISTER C/CAPUCHON 2 PACK
Cod: 7702010130632 Cepillo de dientes limpieza multi-dimensionalBeneficios: -Cerdas señaladoras que indican eARS $4670.89
aaaa COLGATE HILO DENTAL MENTA X 50 MT
Cod: 7891024183021 Remueve los residuos que son la principal causa de las bacterias que causan la placa y laARS $3185.76
aaaa COLGATE CR HERBAL PROTEC 90 GR
Cod: 7509546695518 Cuida tu sonrisa con la Crema Dental Natural Herbal Protect x 90 Gr Colgate La Crema DentARS $3864.05
aaaa COLGATE CEP SMILE 0 A 2 AÑOS
Cod: 7591083011081 Los primeros pasos de salud bucal del bebé. Beneficios: Mango anti-deslizante ergoARS $3640.44
aaaa COLGATE CREMA DENTAL LIGA DE JUSTICIA 90 GRS
Cod: 7891024043530 ¡Crema Dental anticaries sabor menta y frutilla, con tus superhéroes favoritos y además soARS $3517.18
aaaa COLGATE CEP MAX WHITE MEDIO 2X1
Cod: 099176316565 Su estrella pulidora única y su patrón de cerdas especialmente diseñadas ayudan gentilmentARS $4421.24
aaaa COLGATE CEP ZIG ZAG PLUS SUAVE 2X1
Cod: 7509546012100 Cepillo Dental Colgate Zigzag Soft Plus, brinda una limpieza interdental profunda. BeneARS $3651.44
aaaa COLGATE CEP SMILES LIGA DE LA JUSTICIA (6+ AÑOS)
Cod: 7509546079401 Descripción Especialmente diseñado para niños que tienen una combinación de dientes de leARS $3644.83
aaaa COLGATE CREMA DENTAL LIGA DE JUSTICIA 6+ X 75ML
Cod: 7509546079400 Recomendado para niños mayores de 6 años. Beneficios: - Protección contra las cariesARS $3006.55
aaaa COLGATE CR TRIPLE BENEF BLANQ 70GR
Cod: 7509546686554 Triple Acción Xtra Blancura con micro-partículas pulidoras para dientes blancos. CepíllesARS $5205.35
Total: 38 | Página actual: 1
|
Modo de Diseño: Parámetros Internos del Sitio Web |
| Ws_ID: 9af6db34-3ada-47ce-b029-1f91212586a2 |
| Page_Id: 280a3fd2-adea-44e5-89e1-6d23a5dd78a3 |
| WSU_Id: -1 |
| Parámetros de la Página: ;SCAT_ID=3917;GBPWSTID=9af6db34-3ada-47ce-b029-1f91212586a2; |
| Cart Guid: 259cd9e9-e7e8-4e61-a342-ac900830d301 |
|
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.145.105.194 |
| * WebSite Designer * |
|
|
|
Tiempo Total de Proceso: 1 Segundos. Ultimos SQL Ejecutados: GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT CASE WHEN tcat.cat_WebSite_desc <> '' THEN SUBSTRING (tcat.cat_WebSite_desc, 1, 50) ELSE SUBSTRING (tcat.cat_desc, 1, 50) END [cat_WebSite_desc], tcat.cat_id, CASE WHEN tsub.subcat_WebSite_desc <> '' THEN SUBSTRING (tsub.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (tsub.subcat_desc, 1, 50) END [subcat_WebSite_desc] FROM tbCategory tcat INNER JOIN tbSubCategory tsub ON tcat.cat_id = tsub.cat_id WHERE tsub.subcat_id = '3917' Tiempo Consumido: 00:00:00.0080068 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.0010011 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.0010021 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.0010006 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.0060061 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 = 52 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.0150150 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.0480466 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 = 57 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.0100100 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 = 59 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.0120117 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.0100095 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.0550533 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.1661640 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.0890861 GBP_LIST: SPOTS1 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT imageName, CASE WHEN URL <> '' THEN URL ELSE '' END [URL], openMode FROM vwWebSiteII_Spots WHERE ws_id = '9af6db34-3ada-47ce-b029-1f91212586a2' and Type = 8 Tiempo Consumido: 00:00:00.0060056 GBP_LIST: SPOTS1 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT imageName, URL FROM vwWebSiteII_Spots WHERE ws_id = '9af6db34-3ada-47ce-b029-1f91212586a2' and Type = 9 Tiempo Consumido: 00:00:00.0060051 GBP_LIST: LISTA_ARTICULOS 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 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 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' WHERE ti.subcat_id = 3917 and ti.item_web = 'true' Tiempo Consumido: 00:00:00.0610594 |
|
|