358-600-4181     0358-4780808 / 0810-444-6287
    info@matroxdigital.com.ar Lunes a Viernes 8.30 a 12.30hs 16 a 20hs / Sabado 9 A 13hs
  
Ordenar Mostrar

FILTRAR

Categoría:

SubCategoría:

Marca:

Si la cantidad seleccionada es mayor a la disponible, se ajustará automáticamente al stock existente.
Ante cualquier inconveniente por cantidad, consultar al vendedor asigando
product

LENOVO V15 G2 CELERON N4500/8GB/256GB SSD /15.6" FHD/FREEDOS/ESPAÑOL

Código: 82QY00PUSP-B

ARS 539075.50

COMPRAR

product

LENOVO V15 I3-1115G4/4GB/256GB SSD /15.6" FHD/FREEDOS/UK (MALETIN)

Código: 82KB00YXUE

ARS 609875.23

COMPRAR

product

LENOVO V15 G3 I3-1215U/4GB/256GB SSD /15.6" FHD/FREEDOS

Código: 82TT00J3UE

ARS 634040.12

COMPRAR

product

SIS LEN V15 I3-1215U/4GB/256GB SSD /15.6" FHD/FREEDOS

Código: 82TT001CUE

ARS 634388.79

COMPRAR

product

HP 250 G8 I3 1115G4/8GB/256GB SSD /15.6" HD/WIN 11/ESPAÑOL (+MOUSE)

Código: 5U0F8LT-ABM

ARS 647396.18

COMPRAR

product

HP 250 G9 I3 1215U/8GB/256GB SSD /15.6" HD/FREEDOS/ESPAÑOL

Código: 7C6E6LA-ABM

ARS 668558.61

COMPRAR

product

LENOVO V15 G2 RYZEN 5 5500U/8GB/256GB SSD/15.6" FHD/FREEDOS/ESPAÑOL

Código: 82KD00EHSP

ARS 751416.57

COMPRAR

product

DELL INSPIRON 3520 CORE I5-1135G7/8GB/SSD 256GB/15.6" FHD/UBUNTU/ESPAÑOL

Código: T0V6Y

ARS 772026.94

COMPRAR

product

SIS LEN V15 G2 I5-1135G7/8GB/512GB SSD/15.6" FHD/FREEDOS

Código: 82KB00CBEU-B

ARS 774012.43

COMPRAR

product

LENOVO V15 G2 RYZEN 5 5500U/8GB/256GB SSD/15.6" FHD/W11/ESPAÑOL

Código: 82KD00EPSP

ARS 793673.64

COMPRAR

product

LENOVO V15 G4 RYZEN 5 7520U/8GB/256GB SSD/15.6" FHD/FREEDOS/ESPAÑOL

Código: 82YU00X6LM

ARS 827620.71

COMPRAR

product

HP 250 G9 I5-1235U/8GB/256GB SSD /15.6" HD/FREEDOS/ESPAÑOL

Código: 7C6E9LA-ABM

ARS 836405.30

COMPRAR

product

LENOVO V15 G2 I5-1135G7/8GB/512GB SSD/15.6" FHD/ W11/ ESPAÑOL

Código: 82KB015USP-B

ARS 889248.43

COMPRAR

product

LENOVO IDEAPAD AMD RYZEN 7 5700U/8GB/512GB SSD/15.6" FHD /W11

Código: 82LN00F8US

ARS 999573.97

COMPRAR

product

LENOVO IDEAPAD AMD RYZEN 7 5700U/8GB/512GB SSD /15.6" FHD/WIN 10/ESPAÑOL

Código: 82LN004MCL

ARS 1050228.22

COMPRAR

product

LENOVO V15 G2 RYZEN 7 5825U/16GB/512GB SSD/15.6" FHD/FREEDOS/ESPAÑOL

Código: 82TV006CSP

ARS 1181348.15

COMPRAR

product

LENOVO V15 G2 I7-1165G7/8GB/512GB SSD/15.6" FHD/ W11/ ESPAÑOL

Código: 82KB015WSP-B

ARS 1186219.86

COMPRAR

product

LENOVO IDEAPAD GAMING I5-11300H/8GB/512GB SSD/15.6" FHD/GTX 1650 4GB/W11 BLACK

Código: 82K100LUUS

ARS 1442774.44

COMPRAR

product

HP VICTUS 15-FB0028NR RYZEN 7 5800H/16GB/SSD 512GB/15.6" FHD 144Hz/RTX 3050 TI 4GB

Código: 677H9UA-ABA

ARS 1760579.01

COMPRAR

product

MSI KATANA I7-13620H/16GB/1TB SSD /15.6" FHD/RTX 4050 6GB/W11

Código: BB71362H16GXXDX11MH

ARS 2229406.85

COMPRAR

  • Primero
  • Anterior
  • 1
  • Próximo
  • Último
  •     Total: 20 | Página actual: 1

    Si la cantidad seleccionada es mayor a la disponible, se ajustará automáticamente al stock existente.
    Ante cualquier inconveniente por cantidad, consultar al vendedor asigando



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

    Ws_ID: 0d3bc506-4ccc-4b43-b8a9-8a22a89680c4
    Page_Id: a6044319-0f9f-4c20-be79-869ba4116f92
    WSU_Id: -1
    Parámetros de la Página: ;CAT_ID=12;SCAT_ID=4098;BRAND_ID=-1;GBPWSTID=0d3bc506-4ccc-4b43-b8a9-8a22a89680c4;
    Cart Guid: 791df394-3dae-4815-b348-1d0dba2559c9

    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.237.46.120
    * 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 CASE WHEN cat_WebSite_NOTE1 <> '' THEN cat_WebSite_NOTE1 ELSE 'pixel.png' END [cat_WebSite_NOTE1] , CASE WHEN cat_WebSite_desc <> '' THEN SUBSTRING (cat_WebSite_desc, 1, 100) ELSE SUBSTRING (cat_desc, 1, 100) END [cat_WebSite_desc] FROM tbCategory WHERE cat_id = '12'

    Tiempo Consumido: 00:00:00.0156270



    GBP_REPLACE:
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT SUBSTRING (subcataux_desc, 1, 100) [subcataux_desc] FROM TBSUBCATEGORYAUX WHERE subcataux_id = ''

    Tiempo Consumido: 00:00:00



    GBP_REPLACE:
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT CASE WHEN subcat_WebSite_desc <> '' THEN SUBSTRING (subcat_WebSite_desc, 1, 100) ELSE SUBSTRING (subcat_desc, 1, 100) END [subcat_WebSite_desc] FROM tbSubCategory WHERE subcat_id = '4098'

    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.0156279


    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.0156250


    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.0156260


    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.0156269


    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.0312529


    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.0156288


    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.0156230


    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.0156275


    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


    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


    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.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 = 85 ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0156269


    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.0156303


    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


    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.0156260


    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.0156591


    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.0155942


    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.0156299


    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.0156235


    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.0156254


    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.0155962


    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.0312572


    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.0156274


    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.0156235


    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.0156259


    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


    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


    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.0312499


    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.0156260


    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


    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.0156250



    GBP_REPLACE:
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; IF (ISNUMERIC ('12') <> 1 OR '12' = '-1' ) BEGIN SELECT 'Todas' END ELSE BEGIN SELECT cat_desc FROM tbCategory WHERE cat_id='12' END

    Tiempo Consumido: 00:00:00


    GBP_LIST: LISTCAT
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; DECLARE @brand_id AS INT DECLARE @scat_ID AS INT DECLARE @sca_ID AS INT DECLARE @cat_ID AS INT DECLARE @busqueda varchar(100) -- TOMA LAs VARIABLES DE LA URL SET @busqueda = '' IF (ISNUMERIC ('-1') =1) BEGIN SET @brand_id = CAST('-1' AS INT) END ELSE BEGIN SET @brand_id = -1 END IF (ISNUMERIC ('4098') =1) BEGIN SET @scat_id = CAST('4098' AS INT) END ELSE BEGIN SET @scat_id = -1 END IF (ISNUMERIC ('') =1) BEGIN SET @sca_id = CAST('' AS INT) END ELSE BEGIN SET @sca_id = -1 END IF (ISNUMERIC ('12') =1) BEGIN SET @cat_id = CAST('12' AS INT) END ELSE BEGIN SET @cat_id = -1 END SELECT tbCategory.cat_desc AS s, tbCategory.cat_id AS cat_id, COUNT(tbItem.item_id) AS Cantidad, @scat_id AS subCategoria, @sca_id AS subCategoriaAux, @brand_id AS Marca, @busqueda as BUSQUEDA FROM tbItem INNER JOIN tbWebSiteII_ItemsData ON tbItem.comp_id = tbWebSiteII_ItemsData.comp_id AND tbItem.item_id = tbWebSiteII_ItemsData.item_id INNER JOIN tbCategory ON tbItem.comp_id = tbCategory.comp_id AND tbItem.cat_id = tbCategory.cat_id WHERE 1=1 --AND tbWebSiteII_ItemsData.itst_LastAvailableInRelalculation » 0 AND tbWebSiteII_ItemsData.prli_id = 26 AND tbItem.item_web = 1 AND tbWebSiteII_ItemsData.ws_id = '0d3bc506-4ccc-4b43-b8a9-8a22a89680c4' AND ((ISNULL(@cat_id, -1)=-1 AND 1=1 )OR(ISNULL(@cat_id, -1)<>-1 AND 1 <> 1 )) AND ((ISNULL(@scat_id, -1)=-1 AND 1=1 )OR(ISNULL(@scat_id, -1)<>-1 AND tbItem.subcat_id=@scat_id )) AND ((ISNULL(@sca_id, -1)=-1 AND 1=1 )OR(ISNULL(@sca_id, -1)<>-1 AND tbItem.subcataux_id=@sca_id )) AND ((ISNULL(@brand_id, -1)=-1 AND 1=1 )OR(ISNULL(@brand_id, -1)<>-1 AND tbItem.brand_id = @brand_id )) AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '')<>'' AND ((tbItem.item_desc like '%' + @busqueda + '%') OR (tbItem.item_WebSite_desc like '%' + @busqueda + '%') OR (tbItem.item_annotation1 like '%' + @busqueda + '%') OR (tbItem.item_annotation2 like '%' + @busqueda + '%') OR (tbItem.item_descHTML like '%' + @busqueda + '%') OR (tbItem.item_vendorCode like '%' + @busqueda + '%') OR (tbItem.item_Code like '%' + @busqueda + '%')))) GROUP BY tbCategory.cat_desc, tbCategory.cat_id, tbCategory.cat_web_order

    Tiempo Consumido: 00:00:00.0781321



    GBP_REPLACE:
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; IF (ISNUMERIC ('4098') <> 1 OR '4098' = '-1') BEGIN SELECT 'Todas' END ELSE BEGIN SELECT subcat_desc FROM tbSubCategory WHERE subcat_id= '4098' END

    Tiempo Consumido: 00:00:00.0156274


    GBP_LIST: LISTSCAT
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; DECLARE @brand_id AS INT DECLARE @scat_ID AS INT DECLARE @sca_ID AS INT DECLARE @cat_ID AS INT DECLARE @busqueda varchar(100) -- TOMA LAs VARIABLES DE LA URL SET @busqueda = '' IF (ISNUMERIC ('-1') =1) BEGIN SET @brand_id = CAST('-1' AS INT) END ELSE BEGIN SET @brand_id = -1 END IF (ISNUMERIC ('4098') =1) BEGIN SET @scat_id = CAST('4098' AS INT) END ELSE BEGIN SET @scat_id = -1 END IF (ISNUMERIC ('') =1) BEGIN SET @sca_id = CAST('' AS INT) END ELSE BEGIN SET @sca_id = -1 END IF (ISNUMERIC ('12') =1) BEGIN SET @cat_id = CAST('12' AS INT) END ELSE BEGIN SET @cat_id = -1 END SELECT tbSubCategory.subcat_desc AS s, tbSubCategory.subcat_id AS subcat_id, COUNT(tbItem.item_id) AS Cantidad, @cat_id AS Categoria, @sca_id AS subCategoriaAux, @brand_id AS Marca, @busqueda as BUSQUEDA FROM tbItem INNER JOIN tbWebSiteII_ItemsData ON tbItem.comp_id = tbWebSiteII_ItemsData.comp_id AND tbItem.item_id = tbWebSiteII_ItemsData.item_id INNER JOIN tbSubCategory ON tbItem.comp_id = tbSubCategory.comp_id AND tbItem.comp_id = tbSubCategory.comp_id AND tbItem.cat_id = tbSubCategory.cat_id AND tbItem.cat_id = tbSubCategory.cat_id AND tbItem.subcat_id = tbSubCategory.subcat_id AND tbItem.subcat_id = tbSubCategory.subcat_id WHERE 1 = 1 --tbWebSiteII_ItemsData.itst_LastAvailableInRelalculation » 0 AND tbWebSiteII_ItemsData.ws_id = '0d3bc506-4ccc-4b43-b8a9-8a22a89680c4' AND tbWebSiteII_ItemsData.prli_id = 26 AND tbItem.item_web = 1 AND ((ISNULL(@cat_id, -1)=-1 AND 1=1 )OR(ISNULL(@cat_id, -1)<>-1 AND tbItem.cat_id=@cat_id )) AND ((ISNULL(@scat_id, -1)=-1 AND 1=1 )OR(ISNULL(@scat_id, -1)<>-1 AND 1 <> 1 )) AND ((ISNULL(@sca_id, -1)=-1 AND 1=1 )OR(ISNULL(@sca_id, -1)<>-1 AND tbItem.subcataux_id=@sca_id )) AND ((ISNULL(@brand_id, -1)=-1 AND 1=1 )OR(ISNULL(@brand_id, -1)<>-1 AND tbItem.brand_id = @brand_id )) AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '')<>'' AND ((tbItem.item_desc like '%' + @busqueda + '%') OR (tbItem.item_WebSite_desc like '%' + @busqueda + '%') OR (tbItem.item_annotation1 like '%' + @busqueda + '%') OR (tbItem.item_annotation2 like '%' + @busqueda + '%') OR (tbItem.item_descHTML like '%' + @busqueda + '%') OR (tbItem.item_vendorCode like '%' + @busqueda + '%') OR (tbItem.item_Code like '%' + @busqueda + '%')))) GROUP BY tbSubCategory.subcat_desc, tbSubCategory.subcat_id, tbSubCategory.subcat_web_order

    Tiempo Consumido: 00:00:00.0937581



    GBP_REPLACE:
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; IF (ISNUMERIC ('-1') <> 1 OR '-1' = '-1') BEGIN SELECT 'Todas' END ELSE BEGIN SELECT brand_desc FROM tbBrand WHERE brand_id= '-1' END

    Tiempo Consumido: 00:00:00


    GBP_LIST: LISTSMARCA
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; DECLARE @brand_id AS INT DECLARE @scat_ID AS INT DECLARE @sca_ID AS INT DECLARE @cat_ID AS INT DECLARE @busqueda varchar(100) -- TOMA LAs VARIABLES DE LA URL SET @busqueda = '' IF (ISNUMERIC ('-1') =1) BEGIN SET @brand_id = CAST('-1' AS INT) END ELSE BEGIN SET @brand_id = -1 END IF (ISNUMERIC ('4098') =1) BEGIN SET @scat_id = CAST('4098' AS INT) END ELSE BEGIN SET @scat_id = -1 END IF (ISNUMERIC ('') =1) BEGIN SET @sca_id = CAST('' AS INT) END ELSE BEGIN SET @sca_id = -1 END IF (ISNUMERIC ('12') =1) BEGIN SET @cat_id = CAST('12' AS INT) END ELSE BEGIN SET @cat_id = -1 END SELECT tbBrand.brand_desc, tbBrand.brand_id, COUNT(tbItem.item_id) AS Cantidad, @cat_id as Categoria, @scat_id AS Subcategoria, @sca_id AS SubcategoriaAux, @busqueda as BUSQUEDA FROM tbItem INNER JOIN tbBrand ON tbItem.comp_id = tbBrand.comp_id AND tbItem.brand_id = tbBrand.brand_id INNER JOIN tbWebSiteII_ItemsData ON tbItem.comp_id = tbWebSiteII_ItemsData.comp_id AND tbItem.item_id = tbWebSiteII_ItemsData.item_id WHERE 1 = 1 --tbWebSiteII_ItemsData.itst_LastAvailableInRelalculation » 0 AND tbWebSiteII_ItemsData.ws_id = '0d3bc506-4ccc-4b43-b8a9-8a22a89680c4' AND tbWebSiteII_ItemsData.prli_id = 26 AND tbItem.item_web = 1 AND ((ISNULL(@cat_id, -1)=-1 AND 1=1 )OR(ISNULL(@cat_id, -1)<>-1 AND tbItem.cat_id=@cat_id )) AND ((ISNULL(@scat_id, -1)=-1 AND 1=1 )OR(ISNULL(@scat_id, -1)<>-1 AND tbItem.subcat_id=@scat_id )) AND ((ISNULL(@sca_id, -1)=-1 AND 1=1 )OR(ISNULL(@sca_id, -1)<>-1 AND tbItem.subcataux_id=@sca_id )) AND ((ISNULL(@brand_id, -1)=-1 AND 1=1 )OR(ISNULL(@brand_id, -1)<>-1 AND 1 <> 1 )) AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '')<>'' AND ((tbItem.item_desc like '%' + @busqueda + '%') OR (tbItem.item_WebSite_desc like '%' + @busqueda + '%') OR (tbItem.item_annotation1 like '%' + @busqueda + '%') OR (tbItem.item_annotation2 like '%' + @busqueda + '%') OR (tbItem.item_descHTML like '%' + @busqueda + '%') OR (tbItem.item_vendorCode like '%' + @busqueda + '%') OR (tbItem.item_Code like '%' + @busqueda + '%')))) GROUP BY tbBrand.brand_desc, tbBrand.brand_id ORDER BY Cantidad DESC

    Tiempo Consumido: 00:00:00.0937537


    GBP_LIST: SPOTS1
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT imageName, CASE WHEN URL <> '' THEN ' href="' + URL + '" ' ELSE '' END, openMode FROM vwWebSiteII_Spots WHERE ws_id = '0d3bc506-4ccc-4b43-b8a9-8a22a89680c4' and Type = 8

    Tiempo Consumido: 00:00:00


    GBP_LIST: LISTA_ARTICULOS
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; DECLARE @order as int DECLARE @brand_id AS INT DECLARE @scat_ID AS INT DECLARE @sca_ID AS INT DECLARE @cat_ID AS INT DECLARE @busqueda varchar(100) -- TOMA LAs VARIABLES DE LA URL SET @busqueda = '' SET @busqueda = replace(@busqueda, ' ','%') -- Agrega % a los espacios intermedios. IF (ISNUMERIC ('1') =1) BEGIN SET @order = CAST('1' AS INT) END ELSE BEGIN SET @order = -1 END IF (ISNUMERIC ('-1') =1) BEGIN SET @brand_id = CAST('-1' AS INT) END ELSE BEGIN SET @brand_id = -1 END IF (ISNUMERIC ('4098') =1) BEGIN SET @scat_id = CAST('4098' AS INT) END ELSE BEGIN SET @scat_id = -1 END IF (ISNUMERIC ('') =1) BEGIN SET @sca_id = CAST('' AS INT) END ELSE BEGIN SET @sca_id = -1 END IF (ISNUMERIC ('12') =1) BEGIN SET @cat_id = CAST('12' AS INT) END ELSE BEGIN SET @cat_id = -1 END SELECT ti.item_made, tpli.semaphoreValue, ti.Item_id, CASE WHEN ti.item_website_desc<>'' THEN SUBSTRING (ti.item_website_desc, 1, 100) ELSE SUBSTRING (ti.item_desc, 1, 100) 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), ti.item_newness, ti.item_liquidation, isnull(item_WebSite_vendorPage,'VACIO'), convert(nvarchar(20),convert(decimal(16,2), tpli.prli_price)) [price], tc.curr_symbol, tbr.brand_desc, CASE WHEN i4c.item_id = ti.item_id THEN 1 else 0 END [checkid], CASE WHEN i4c.item_id = ti.item_id THEN 'checked' else '' END [checked], 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 LEFT JOIN tbWebSiteII_ItemRates itr ON itr.comp_id = ti.comp_id AND itr.item_id = ti.item_id LEFT JOIN tbWebSiteII_TMPItem4Compare i4c ON i4c.item_id = ti.item_id AND i4c.ws_guid = '791df394-3dae-4815-b348-1d0dba2559c9' 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_web = 'true' --and tpli.itst_LastAvailableInRelalculation » 0 AND ((ISNULL(@cat_id, -1)=-1 AND 1=1 )OR(ISNULL(@cat_id, -1)<>-1 AND ti.cat_id=@cat_id )) AND ((ISNULL(@scat_id, -1)=-1 AND 1=1 )OR(ISNULL(@scat_id, -1)<>-1 AND ti.subcat_id=@scat_id )) AND ((ISNULL(@sca_id, -1)=-1 AND 1=1 )OR(ISNULL(@sca_id, -1)<>-1 AND ti.subcataux_id=@sca_id )) AND ((ISNULL(@brand_id, -1)=-1 AND 1=1 )OR(ISNULL(@brand_id, -1)<>-1 AND ti.brand_id = @brand_id )) AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '')<>'' AND ((ti.item_desc like '%' + @busqueda + '%') OR (ti.item_WebSite_desc like '%' + @busqueda + '%') OR (ti.item_annotation1 like '%' + @busqueda + '%') OR (ti.item_annotation2 like '%' + @busqueda + '%') OR (ti.item_descHTML like '%' + @busqueda + '%') OR (ti.item_vendorCode like '%' + @busqueda + '%') OR (ti.item_Code like '%' + @busqueda + '%')))) Group by ti.item_made,tpli.semaphoreValue, ti.item_id,item_WebSite_desc,item_desc, item_code,item_desc,item_vendorCode,ti.brand_id,tbr.brand_desc,item_annotation1,item_annotation2, item_newness,item_liquidation,item_WebSite_vendorPage,prli_price,curr_symbol,tpli.itst_cant,ti.comp_id,i4c.item_id,ttn.tax_percentage ORDER BY CASE WHEN @order=1 THEN tpli.prli_price END ASC, CASE WHEN @order=2 THEN tpli.prli_price END DESC, CASE WHEN @order=3 THEN ti.item_WebSite_desc END ASC, CASE WHEN @order=4 THEN ti.item_WebSite_desc END DESC, CASE WHEN @order=5 THEN tpli.semaphoreValue END DESC, tpli.itst_cant DESC

    Tiempo Consumido: 00:00:00.1562945