Código: GA00439-US SF-LA
ARS 52877.47
GOOGLE CHROMECAST 3 SMART TV HDMI USB (SIN FUENTE)
Disfruta de contenido Full HD desde tu dispositivo móvil favorito con el Google Chromecast de tercera generación. Se conecta al puerto HDMI en su pantalla o receptor, lo que le permite transmitir medios desde su dispositivo móvil o la web. Admite resolución Full HD (1920 x 1080) a 60 Hz para proporcionar una imagen detallada en pantallas compatibles. El Chromecast se conecta a su red doméstica a través del Wi-Fi 802.11ac y puede controlarse a través de su dispositivo móvil o por voz con su dispositivo Google Home.
Transmite desde sus dispositivos favoritos
Disfrute de miles de aplicaciones de Android o iPhone, y juegue o haga una pausa directamente desde su teléfono. Refleja la pantalla de tu computadora portátil a tu pantalla con tu navegador Chrome. Navegue por la web o vea su contenido multimedia en la pantalla grande. Simplemente toque el botón Cast en cualquier aplicación compatible para convertir su tableta Android o iOS en un dispositivo de entretenimiento.
Transmisión inalámbrica y contenido espejo
Resolución de video de hasta 1080p / 60 Hz
Conectividad Wi-Fi 802.11ac de banda dual
Conector HDMI integrado
Control desde dispositivos portátiles
Diseño circular compacto
Trabaja con el Asistente de Google
Modo de Diseño: Parámetros Internos del Sitio Web |
Ws_ID: 0d3bc506-4ccc-4b43-b8a9-8a22a89680c4 |
Page_Id: ae0b384b-b270-4371-ad04-19640af21a05 |
WSU_Id: -1 |
Parámetros de la Página: ;ITEM_ID=7993;GBPWSTID=0d3bc506-4ccc-4b43-b8a9-8a22a89680c4; |
Cart Guid: 6af3597a-71cd-411f-9f66-72e21c1ba0b6 |
Estados Internos * cust_id:-1 * st_id:191 * dl_id:1 * cc_id:-1 * ccp_id:-1 * Cuotas:-1 * disc_id:9 * bra_id:26 * prli_id:26 * prof_id:19 * stor_id:36 * item_id:-1 * camp_id:-1 * |
Comp_Id: 1 |
Lang_Id: 2 |
3.14.6.194 |
* WebSite Designer * |
|
Tiempo Total de Proceso: 2 Segundos. Ultimos SQL Ejecutados: 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 = 7993 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 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 TSCA.catg_id, TSCA.catg_desc, TSCA.catg_note2 FROM TBCATEGORYGROUP TSCA WHERE tsca.comp_id='1' ORDER BY TSCA.catg_desc ASC Tiempo Consumido: 00:00:00.0156275 GBP_LIST: CAT2 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TSCA.catg_id, TSCA.catg_desc FROM TBCATEGORYGROUP TSCA WHERE tsca.comp_id='1' ORDER BY TSCA.catg_desc ASC Tiempo Consumido: 00:00:00 GBP_LIST: CAT1 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 [subcat_WebSite_desc] FROM TBCATEGORY TC WHERE TC.CAT_WEB = 'TRUE' AND TC.catg_id = 2 AND comp_id='1' ORDER BY TC.cat_web_order Tiempo Consumido: 00:00:00.0156221 GBP_LIST: CAT1 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 [subcat_WebSite_desc] FROM TBCATEGORY TC WHERE TC.CAT_WEB = 'TRUE' AND TC.catg_id = 1 AND comp_id='1' ORDER BY TC.cat_web_order Tiempo Consumido: 00:00:00 GBP_LIST: CAT1 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 [subcat_WebSite_desc] FROM TBCATEGORY TC WHERE TC.CAT_WEB = 'TRUE' AND TC.catg_id = 3 AND comp_id='1' ORDER BY TC.cat_web_order Tiempo Consumido: 00:00:00.0156305 GBP_LIST: CAT1 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 [subcat_WebSite_desc] FROM TBCATEGORY TC WHERE TC.CAT_WEB = 'TRUE' AND TC.catg_id = 4 AND comp_id='1' ORDER BY TC.cat_web_order Tiempo Consumido: 00:00:00.0156236 GBP_LIST: CAT1 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 [subcat_WebSite_desc] FROM TBCATEGORY TC WHERE TC.CAT_WEB = 'TRUE' AND TC.catg_id = 5 AND comp_id='1' ORDER BY TC.cat_web_order Tiempo Consumido: 00:00:00.0156222 GBP_LIST: CAT1 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 WHERE TC.CAT_WEB = 'TRUE' ORDER BY tc.cat_web_order ASC Tiempo Consumido: 00:00:00.0156284 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 81 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0156232 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 82 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0156592 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 83 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0156041 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 85 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0156246 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 69 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0156246 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 3 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0156265 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 12 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0156256 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 1 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0312502 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 50 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0156261 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 86 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0156251 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 48 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0156241 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 62 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 4 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 6 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0156250 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 10 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 14 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0156222 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 13 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0156265 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 49 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 68 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0156246 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 71 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0156255 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 51 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0156266 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 15 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0312506 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 53 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0156246 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 19 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0156256 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 63 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 = 26 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 17 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC Tiempo Consumido: 00:00:00.0156231 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, ti.item_annotation2, SUBSTRING (ti.item_annotation2, 1, 100), 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, tcat.cat_desc, tsub.subcat_desc, tcat.cat_id, tsub.subcat_id, convert (decimal(16,2), ttn.tax_percentage) [IVA] 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 = 26 AND tpli.ws_id = '0d3bc506-4ccc-4b43-b8a9-8a22a89680c4' 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 = '0d3bc506-4ccc-4b43-b8a9-8a22a89680c4' 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 = 7993 Tiempo Consumido: 00:00:00 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 'block' 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 = 7993 and ti.comp_id=1 GROUP BY tc.item_id Tiempo Consumido: 00:00:00.0156241 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 = 7993 Tiempo Consumido: 00:00:00.0156251 GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT count(tit.ct_transaction) FROM tbItemTransactions tit LEFT JOIN tbItemTransactionDetails titd ON titd.comp_id = tit.comp_id AND titd.bra_id = tit.bra_id AND titd.ct_transaction = tit.ct_transaction AND titd.it_transaction = tit.it_transaction INNER JOIN tbCommercialTransactions tct ON tct.comp_id = tit.comp_id AND tct.ct_transaction = tit.ct_transaction INNER JOIN tbsysDocuments tsd ON tsd.sd_id = tct.sd_id LEFT JOIN tbItem ti ON ti.comp_id = tit.comp_id AND ti.item_id = tit.item_id WHERE tit.comp_id = 1 AND tct.cust_id = -1 AND tsd.sd_id = 1 AND ti.item_id = 7993 Tiempo Consumido: 00:00:00 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 = 7993 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/lef/COMPARA/X/GBPWSTID=0d3bc506-4ccc-4b43-b8a9-8a22a89680c4/gbpwst.aspx»Ver Comparacion«/a»' else 'Comparar' END [checked], convert (decimal(16,2), ttn.tax_percentage) [IVA] 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 = 26 AND tpli.ws_id = '0d3bc506-4ccc-4b43-b8a9-8a22a89680c4' 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 = '0d3bc506-4ccc-4b43-b8a9-8a22a89680c4' LEFT JOIN tbWebSiteII_TMPItem4Compare i4c On i4c.item_id = ti.item_id and i4c.ws_guid = '6af3597a-71cd-411f-9f66-72e21c1ba0b6' 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 <> '7993' and ti.subcat_id = '4011' Tiempo Consumido: 00:00:00.0624998 |
|