Tiempo Total de Proceso: 4 Segundos.
Ultimos SQL Ejecutados:
GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
IF -1 <> -1
SELECT
CASE
WHEN c.cat_WebSite_NOTE1 <> '' THEN 'https://gbp47s.globalbluepoint.com/hdc/Temp/App_WebSite/App_PictureFiles/' + c.cat_WebSite_NOTE1 END
FROM tbCategory c
WHERE c.cat_id = '-1'
Tiempo Consumido: 00:00:00.0040039
GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
DECLARE @scat_id2 AS INT
IF (ISNUMERIC ('-1') =1)
BEGIN
SET @scat_id2 = CAST('-1' AS INT)
END ELSE BEGIN
SET @scat_id2 = -1
END
IF @scat_id2 <> -1
SELECT
CASE
WHEN s.subcat_WebSite_NOTE1 <> '' THEN 'https://gbp47s.globalbluepoint.com/hdc/Temp/App_WebSite/App_PictureFiles/' + s.subcat_WebSite_NOTE1 ELSE NULL END
FROM tbSubCategory s
WHERE s.subcat_id = @scat_id2
Tiempo Consumido: 00:00:00.0040044
GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT
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 = '-1'
Tiempo Consumido: 00:00:00.0010006
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 = '-1'
Tiempo Consumido: 00:00:00.0030033
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 = '775cae0b-172a-4e96-8c4c-fad0f92757be'
Tiempo Consumido: 00:00:00.0020012
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.0010006
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.0020022
GBP_LIST: SCAT1
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],
dbo.fnSTRRemoveSpecialCharacters(TC.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 = 6
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.0070062
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,
CASE WHEN TC.subcat_WebSite_desc <> '' THEN
SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50)
ELSE
SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50)
END [subcat_WebSite_desc]
FROM tbSubCategory tc
INNER JOIN tbWebSiteII_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 = 6 AND tmp2.ws_id='775cae0b-172a-4e96-8c4c-fad0f92757be'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 1
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.0090089
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,
CASE WHEN TC.subcat_WebSite_desc <> '' THEN
SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50)
ELSE
SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50)
END [subcat_WebSite_desc]
FROM tbSubCategory tc
INNER JOIN tbWebSiteII_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 = 6 AND tmp2.ws_id='775cae0b-172a-4e96-8c4c-fad0f92757be'
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.0210206
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,
CASE WHEN TC.subcat_WebSite_desc <> '' THEN
SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50)
ELSE
SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50)
END [subcat_WebSite_desc]
FROM tbSubCategory tc
INNER JOIN tbWebSiteII_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 = 6 AND tmp2.ws_id='775cae0b-172a-4e96-8c4c-fad0f92757be'
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.0140134
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,
CASE WHEN TC.subcat_WebSite_desc <> '' THEN
SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50)
ELSE
SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50)
END [subcat_WebSite_desc]
FROM tbSubCategory tc
INNER JOIN tbWebSiteII_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 = 6 AND tmp2.ws_id='775cae0b-172a-4e96-8c4c-fad0f92757be'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 54
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.0170162
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,
CASE WHEN TC.subcat_WebSite_desc <> '' THEN
SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50)
ELSE
SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50)
END [subcat_WebSite_desc]
FROM tbSubCategory tc
INNER JOIN tbWebSiteII_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 = 6 AND tmp2.ws_id='775cae0b-172a-4e96-8c4c-fad0f92757be'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 65
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.0220212
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,
CASE WHEN TC.subcat_WebSite_desc <> '' THEN
SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50)
ELSE
SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50)
END [subcat_WebSite_desc]
FROM tbSubCategory tc
INNER JOIN tbWebSiteII_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 = 6 AND tmp2.ws_id='775cae0b-172a-4e96-8c4c-fad0f92757be'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 67
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.0210200
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,
CASE WHEN TC.subcat_WebSite_desc <> '' THEN
SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50)
ELSE
SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50)
END [subcat_WebSite_desc]
FROM tbSubCategory tc
INNER JOIN tbWebSiteII_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 = 6 AND tmp2.ws_id='775cae0b-172a-4e96-8c4c-fad0f92757be'
WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 64
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.0080078
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 cat_desc FROM tbCategory WHERE cat_id='-1'
END
Tiempo Consumido: 00:00:00.0030019
GBP_LIST: LISTCAT
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
DECLARE @scat_ID AS INT
DECLARE @sca_ID AS INT
DECLARE @cat_ID AS INT
DECLARE @busqueda varchar(100)
DECLARE @brand_id varchar
SET @busqueda = replace('', 'ñ','ñ')
SET @brand_id = '0'
IF (@brand_id ='0')
BEGIN
SET @brand_id = ''
END
IF (ISNUMERIC ('-1') =1)
BEGIN
SET @scat_id = CAST('-1' AS INT)
END ELSE BEGIN
SET @scat_id = -1
END
IF (ISNUMERIC ('-1') =1)
BEGIN
SET @sca_id = CAST('-1' AS INT)
END ELSE BEGIN
SET @sca_id = -1
END
IF (ISNUMERIC ('-1') =1)
BEGIN
SET @cat_id = CAST('-1' AS INT)
END ELSE BEGIN
SET @cat_id = -1
END
SELECT tbCategory.cat_desc AS s,
dbo.fnSTRRemoveSpecialCharacters(tbCategory.cat_desc),
tpli.cat_id AS cat_id,
COUNT(tpli.item_id) AS Cantidad,
@scat_id AS subCategoria,
@sca_id AS subCategoriaAux,
'0',
@busqueda as BUSQUEDA
FROM tbWebSiteII_ItemsData tpli
INNER JOIN tbCategory ON tpli.comp_id = tbCategory.comp_id AND tpli.cat_id = tbCategory.cat_id
WHERE tpli.prli_id = 6 AND tpli.ws_id = '775cae0b-172a-4e96-8c4c-fad0f92757be'
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 tpli.subcat_id=@scat_id ))
AND ((ISNULL(@sca_id, -1)=-1 AND 1=1 )OR(ISNULL(@sca_id, -1)<>-1 AND tpli.subcataux_id=@sca_id ))
AND ((ISNULL(@brand_id, '')='') OR (ISNULL(@brand_id, '')<>'' AND tpli._brand_id IN (0) ))
AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '')<>''
AND ((tpli.item__WebSite_desc like '%' + @busqueda + '%') OR
(tpli.item__WebSite_desc like '%' + @busqueda + '%') OR
(tpli.item__annotation1 like '%' + @busqueda + '%') OR
(tpli.item__annotation2 like '%' + @busqueda + '%') OR
(tpli.item__descHTML like '%' + @busqueda + '%') OR
(tpli.item__vendorCode like '%' + @busqueda + '%') OR
(tpli.item__Code like '%' + @busqueda + '%'))))
GROUP BY tbCategory.cat_desc, tpli.cat_id,tbCategory.cat_web_order
Tiempo Consumido: 00:00:00.1781733
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 subcat_desc FROM tbSubCategory WHERE subcat_id= '-1'
END
Tiempo Consumido: 00:00:00.0130128
GBP_LIST: LISTSCAT
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
DECLARE @scat_ID AS INT
DECLARE @sca_ID AS INT
DECLARE @cat_ID AS INT
DECLARE @busqueda1 varchar(100)
DECLARE @busqueda varchar(100)
DECLARE @brand_id varchar
SET @busqueda1 = replace('', 'ñ','ñ')
SET @busqueda = replace(@busqueda1, ' ','%')
SET @brand_id = '0'
IF (@brand_id ='0')
BEGIN
SET @brand_id = ''
END
IF (ISNUMERIC ('-1') =1)
BEGIN
SET @scat_id = CAST('-1' AS INT)
END ELSE BEGIN
SET @scat_id = -1
END
IF (ISNUMERIC ('-1') =1)
BEGIN
SET @sca_id = CAST('-1' AS INT)
END ELSE BEGIN
SET @sca_id = -1
END
IF (ISNUMERIC ('-1') =1)
BEGIN
SET @cat_id = CAST('-1' AS INT)
END ELSE BEGIN
SET @cat_id = -1
END
SELECT tbSubCategory.subcat_desc AS s,
dbo.fnSTRRemoveSpecialCharacters(tbSubCategory.subcat_desc),
tpli.subcat_id AS subcat_id,
COUNT(tpli.item_id) AS Cantidad, @cat_id AS Categoria, @sca_id AS subCategoriaAux, '0', @busqueda1 as BUSQUEDA
FROM tbWebSiteII_ItemsData tpli
INNER JOIN tbSubCategory ON tpli.comp_id = tbSubCategory.comp_id AND tpli.cat_id = tbSubCategory.cat_id AND tpli.subcat_id = tbSubCategory.subcat_id
WHERE tpli.ws_id = '775cae0b-172a-4e96-8c4c-fad0f92757be' AND tpli.prli_id = 6
AND ((ISNULL(@cat_id, -1)=-1 AND 1=1 )OR(ISNULL(@cat_id, -1)<>-1 AND tpli.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 tpli.subcataux_id=@sca_id ))
AND ((ISNULL(@brand_id, '')='') OR (ISNULL(@brand_id, '')<>'' AND tpli._brand_id IN (0) ))
AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '')<>''
AND (
(tpli.item__WebSite_desc like '%' + @busqueda + '%') OR
(tpli.item__annotation1 like '%' + @busqueda + '%') OR
(tpli.item__annotation2 like '%' + @busqueda + '%') OR
(tpli.item__descHTML like '%' + @busqueda + '%') OR
(tpli.item__vendorCode like '%' + @busqueda + '%') OR
(tpli.item__Code like '%' + @busqueda + '%'))))
GROUP BY tbSubCategory.subcat_desc, tpli.subcat_id, tbSubCategory.subcat_web_order
Tiempo Consumido: 00:00:00.0640618
GBP_LIST: LISTSMARCA
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
DECLARE @brand_id AS varchar
DECLARE @scat_ID AS INT
DECLARE @sca_ID AS INT
DECLARE @cat_ID AS INT
DECLARE @busqueda varchar(100)
SET @busqueda = replace('', 'ñ','ñ')
SET @busqueda = replace(@busqueda, ' ','%')
SET @brand_id = '0'
IF (@brand_id ='0')
BEGIN
SET @brand_id = ''
END
IF (ISNUMERIC ('-1') =1)
BEGIN
SET @scat_id = CAST('-1' AS INT)
END ELSE BEGIN
SET @scat_id = -1
END
IF (ISNUMERIC ('-1') =1)
BEGIN
SET @sca_id = CAST('-1' AS INT)
END ELSE BEGIN
SET @sca_id = -1
END
IF (ISNUMERIC ('-1') =1)
BEGIN
SET @cat_id = CAST('-1' AS INT)
END ELSE BEGIN
SET @cat_id = -1
END
SELECT '','«li class="term-item"»«label onchange="marcaClick(' + convert(varchar,tbBrand.brand_id),
')"» «input type="checkbox" id="marca',
tbBrand.brand_id,
'',
'" name="'+convert(varchar,tbBrand.brand_id)+'" value="' as BRAND_ID,
dbo.fnSTRRemoveSpecialCharacters(tbBrand.brand_desc)+'"» ',
lower(tbBrand.brand_desc),
' «span»('+convert(varchar,COUNT(ti.item_id))+')«/span»'as cantidad,
'«/label»«/li»'
FROM tbItem ti
INNER JOIN tbBrand ON ti.comp_id = tbBrand.comp_id AND ti.brand_id = tbBrand.brand_id
INNER JOIN tbWebSiteII_ItemsData ON ti.comp_id = tbWebSiteII_ItemsData.comp_id AND ti.item_id = tbWebSiteII_ItemsData.item_id AND tbWebSiteII_ItemsData.ws_id = '775cae0b-172a-4e96-8c4c-fad0f92757be'
WHERE ti.item_web = 'true'
AND tbWebSiteII_ItemsData.ws_id = '775cae0b-172a-4e96-8c4c-fad0f92757be'
AND tbWebSiteII_ItemsData.prli_id = 6
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, '')='') OR (ISNULL(@brand_id, '')<>'' AND ti.brand_id IN (@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 tbBrand.brand_desc, tbBrand.brand_id ORDER BY Cantidad DESC
Tiempo Consumido: 00:00:00.0790772
GBP_LIST: COMPA
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
DECLARE @scat_ID AS INT
DECLARE @sca_ID AS INT
DECLARE @cat_ID AS INT
DECLARE @busqueda varchar(100)
DECLARE @brand_id varchar
SET @busqueda = replace('', 'ñ','ñ')
SET @busqueda = replace(@busqueda, ' ','%')
SET @brand_id = '0'
IF (@brand_id ='0')
BEGIN
SET @brand_id = ''
END
IF (ISNUMERIC ('-1') =1)
BEGIN
SET @scat_id = CAST('-1' AS INT)
END ELSE BEGIN
SET @scat_id = -1
END
IF (ISNUMERIC ('-1') =1)
BEGIN
SET @sca_id = CAST('-1' AS INT)
END ELSE BEGIN
SET @sca_id = -1
END
IF (ISNUMERIC ('-1') =1)
BEGIN
SET @cat_id = CAST('-1' AS INT)
END ELSE BEGIN
SET @cat_id = -1
END
SELECT tic.wco_desc as orden1,'«li class="term-item"»«label onchange="filtroClick('+convert(varchar,tic.wco_id)+','''+ticr.wco_Text1,''')"»«input type="checkbox" id="',tic.wco_id as orden2,ticr.wco_Text1,'" name="'+convert(varchar,tic.wco_id)+'" value="'as WCOID,ticr.wco_Text1+'"» ',ticr.wco_Text1,' «span»('+convert(varchar,count(ti.item_id))+')«/span»'as cantidad,'«/label»«/li»'
FROM tbitem ti
INNER JOIN tbBrand tbr ON ti.brand_id = tbr.brand_id
INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = ti.comp_id AND tpli.item_id = ti.item_id AND tpli.prli_id = 6 AND tpli.ws_id = '775cae0b-172a-4e96-8c4c-fad0f92757be'
INNER JOIN tbCategory cat ON ti.cat_id = cat.cat_id
INNER JOIN tbItemComparativesRelations ticr ON ticr.item_id = ti.item_id
INNER JOIN tbItemComparatives tic ON tic.wco_id = ticr.wco_id
WHERE tpli.ws_id = '775cae0b-172a-4e96-8c4c-fad0f92757be' AND tpli.prli_id = 6 AND ti.item_web = 'true' AND tic.wco_isAvailable4Filters = 1
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, '')='') OR (ISNULL(@brand_id, '')<>'' AND ti.brand_id IN (0) ))
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 tic.wco_desc, tic.wco_id, ticr.wco_Text1
UNION
SELECT distinct tic.wco_desc,'«/ul»«li class="menuLatTit" id="','',0,'','"»','',tic.wco_desc,'','«/li»«ul class="menuUl term-list"»'
FROM tbitem ti
INNER JOIN tbBrand tbr ON ti.brand_id = tbr.brand_id
INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = ti.comp_id AND tpli.item_id = ti.item_id AND tpli.prli_id = 6 AND tpli.ws_id = '775cae0b-172a-4e96-8c4c-fad0f92757be'
INNER JOIN tbCategory cat ON ti.cat_id = cat.cat_id
INNER JOIN tbItemComparativesRelations ticr ON ticr.item_id = ti.item_id
INNER JOIN tbItemComparatives tic ON tic.wco_id = ticr.wco_id
WHERE tic.wco_isAvailable4Filters = 1
AND tpli.ws_id = '775cae0b-172a-4e96-8c4c-fad0f92757be' AND tpli.prli_id = 6 AND ti.item_web = 'true'
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, '')='') OR (ISNULL(@brand_id, '')<>'' AND ti.brand_id IN (0) ))
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 tic.wco_desc, tic.wco_id, ticr.wco_Text1
ORDER BY orden1, orden2
Tiempo Consumido: 00:00:00.1291245
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 = '775cae0b-172a-4e96-8c4c-fad0f92757be' and Type = 8
ORDER BY [Order]
Tiempo Consumido: 00:00:00.0060060
GBP_LIST: A
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
DECLARE @order AS INT
DECLARE @brand_id VARCHAR(50)
DECLARE @scat_ID AS INT
DECLARE @sca_ID AS INT
DECLARE @cat_ID AS INT
DECLARE @busqueda varchar(100)
DECLARE @comp_id AS INT
DECLARE @price_list AS INT
DECLARE @ws_id AS uniqueidentifier
SET @busqueda = replace('', 'ñ','ñ')
SET @busqueda = replace(@busqueda, ' ','%')
SET @brand_id = '0'
IF (@brand_id ='0')
BEGIN
SET @brand_id = ''
END
IF (ISNUMERIC ('1') =1)
BEGIN
SET @order = CAST('1' AS INT)
END ELSE BEGIN
SET @order = -1
END
IF (ISNUMERIC ('-1') =1)
BEGIN
SET @scat_id = CAST('-1' AS INT)
END ELSE BEGIN
SET @scat_id = -1
END
IF (ISNUMERIC ('-1') =1)
BEGIN
SET @sca_id = CAST('-1' AS INT)
END ELSE BEGIN
SET @sca_id = -1
END
IF (ISNUMERIC ('-1') =1)
BEGIN
SET @cat_id = CAST('-1' AS INT)
END ELSE BEGIN
SET @cat_id = -1
END
IF (ISNUMERIC ('6') =1)
BEGIN
SET @price_list = CAST('6' AS INT)
END ELSE BEGIN
SET @price_list = -1
END
IF (ISNUMERIC ('1') =1)
BEGIN
SET @comp_id = CAST('1' AS INT)
END ELSE BEGIN
SET @comp_id = -1
END
SET @ws_id = '775cae0b-172a-4e96-8c4c-fad0f92757be'
SELECT
tpli.item__made,
tpli.semaphoreValue,
tpli.item_id,
SUBSTRING (tpli.item__WebSite_desc, 1, 100) [item_desc],
SUBSTRING ( tpli.item__annotation1, 1, 20),
dbo.fnStrAllTrim(tpli.item__code) [item_code],
tpli.item__vendorCode,
tpli._brand_id,
tpli.item__annotation2,
SUBSTRING ( tpli.item__annotation2, 1, 90),
ISNULL(tbn.wssn_isNovelty, 'False'),
ISNULL(tbn.wssn_is4Sale, 'False'),
REPLACE(format(CAST(tpli.prli_price AS DECIMAL), 'N', 'de-de'),',02','') AS 'Numeric Format',
REPLACE(format(CAST(tpli.prli_price/6 AS DECIMAL), 'N', 'de-de'),',02','') AS 'Numeric Format',
CASE WHEN tpli.currency_symbol = 'ARS' THEN '$' ELSE tpli.currency_symbol END,
'',
CASE WHEN i4c.item_id = tpli.item_id THEN 1 else 0 END [checkid],
CASE WHEN i4c.item_id = tpli.item_id THEN 'checked' else '' END [checked],
CASE WHEN i4c.item_id = tpli.item_id THEN '«a href=https://gbp47s.globalbluepoint.com/hdc/COMPARA/X/GBPWSTID=775cae0b-172a-4e96-8c4c-fad0f92757be/gbpwst.aspx»Ver Comparacion«/a»' else 'Comparar' END [compatext],
convert (decimal(16,2), ttn.tax_percentage) [IVA],
SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(tpli.item__WebSite_desc), 1, 100) [item_desc] ,
REPLACE(tpli.item__code,'/','--'),
(SELECT TOP 1 CASE WHEN vwsiii.imageCodeOrURL IS NULL THEN 'https://gbp47s.globalbluepoint.com/hdc/Temp/App_WebSite/App_PictureFiles/Items/' + dbo.fnStrAllTrim(tpli2.item_code) + '_250.jpg'
ELSE vwsiii.imageCodeOrURL END AS item_img FROM tbitem tpli2 LEFT JOIN vwWebSiteII_ItemsImages AS vwsiii
ON vwsiii.item_id = tpli2.item_id AND vwsiii.imageType » 2 WHERE tpli2.item_id = tpli.item_id),
tpli.itst_cant,
REPLACE(format(CAST(isnull(tpli.strikeThroughPrice,'0') AS DECIMAL), 'N', 'de-de'),',02','') AS 'Numeric Format',
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 tif.wsif_id IS NULL THEN '' WHEN tif.wsif_isActive = 'True' THEN 'avisostockon' ELSE '' END,
REPLACE(format(CAST((tpli.strikeThroughPrice - tpli.prli_price) AS DECIMAL), 'N', 'de-de'),',02','') AS 'Numeric Format',
(SELECT CASE WHEN EXISTS (SELECT 1 FROM tbItemImages tii WHERE tii.item_id = tpli.item_id) THEN 'SI' ELSE 'NO' END AS tiene_imagen)
FROM tbWebSiteII_ItemsData tpli
LEFT JOIN tbWebSiteII_Items_Favorites tif ON tif.comp_id = tpli.comp_id AND tif.ws_id = tpli.ws_id AND tif.item_id = tpli.item_id AND tif.cust_id = -1
-- INNER JOIN tbitem ti ON tpli.comp_id = ti.comp_id AND tpli.item_id = ti.item_id AND tpli.prli_id = 6 AND tpli.ws_id = @ws_id
LEFT JOIN tbWebSiteII_ItemRates itr ON itr.comp_id = tpli.comp_id AND itr.item_id = tpli.item_id
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c ON i4c.item_id = tpli.item_id AND i4c.ws_guid = 'facb8a8a-9db9-444b-b6f7-548393160546'
LEFT JOIN tbWebSiteII_Items_NoveltyAnd4Sale tbn ON tbn.comp_id = tpli.comp_id AND tpli.item_id = tbn.item_id AND tbn.ws_id = @ws_id
LEFT JOIN vwWebSiteII_itemSizeColor vtc ON vtc.itemid4sizeColor = tpli.item_id and vtc.comp_id= tpli.comp_id
LEFT JOIN tbItemTaxes tit ON tit.item_id = tpli.item_id AND tit.comp_id = tpli.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
tpli.prli_id = @price_list AND tpli.ws_id = @ws_id AND
((ISNULL(@cat_id, -1)=-1 AND 1=1 )
OR(ISNULL(@cat_id, -1)<>-1 AND tpli.cat_id=@cat_id ))
AND ((ISNULL(@scat_id, -1)=-1 AND 1=1 )
OR(ISNULL(@scat_id, -1)<>-1 AND tpli.subcat_id=@scat_id ))
AND ((ISNULL(@sca_id, -1)=-1 AND 1=1 ) OR(ISNULL(@sca_id, -1)<>-1 AND tpli.subcataux_id=@sca_id ))
AND ((ISNULL(@brand_id, '')='') OR (ISNULL(@brand_id, '')<>'' AND tpli._brand_id IN (0) ))
AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '') <> ''
AND ((tpli.item__WebSite_desc like '%' + @busqueda + '%') OR
(tpli.item__WebSite_desc like '%' + @busqueda + '%') OR
(tpli.item__annotation1 like '%' + @busqueda + '%') OR
(tpli.item__annotation2 like '%' + @busqueda + '%') OR
(tpli.item__descHTML like '%' + @busqueda + '%') OR
(tpli.item__vendorCode like '%' + @busqueda + '%') OR
(tpli.item__code like '%' + @busqueda + '%'))))
AND vtc.comp_id is null
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 tpli.item__WebSite_desc END ASC,
CASE WHEN @order=4 THEN tpli.item__WebSite_desc END DESC,
CASE WHEN @order=5 THEN tpli.semaphoreValue END DESC,
tpli.itst_cant DESC
Tiempo Consumido: 00:00:00.6646456
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5288', 'Tablet-Hdc-T10-232-10---Allwinner-A133---2gb-Ram---32gb-Rom'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5288
Tiempo Consumido: 00:00:00.0380372
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5824', 'SMART-WATCH-HIFUTURE-MIX-2-22MM-GRIS'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5824
Tiempo Consumido: 00:00:00.0360350
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5826', 'SMART-WATCH-HIFUTURE-AIX-LITE-22MM-NEGRO'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5826
Tiempo Consumido: 00:00:00.0820795
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '3950', 'Cpu-Intel-Celeron-G5905-350-Ghz-3M-1200'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 3950
Tiempo Consumido: 00:00:00.0900872
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5725', 'FREIDORA-DE-AIRE-HDC-HAF-SH100DB-–-DOBLE-CESTA-INDEPENDIENTE-10-LITROS'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5725
Tiempo Consumido: 00:00:00.0400389
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5527', 'Parlante-PortAtil-Moonki-Sound-Malibu-Naranja---55---POT-500W18W---TWS---BAT-REC'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5527
Tiempo Consumido: 00:00:00.1611567
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5528', 'Parlante-PortAtil-Moonki-Sound-Malibu-Rosa---55---POT-500W18W---TWS---BAT-REC'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5528
Tiempo Consumido: 00:00:00.0470461
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5506', 'CPU-INTEL-CORE-I5-14100F--12MB--SVIDEO-LGA1700'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5506
Tiempo Consumido: 00:00:00.0350349
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5407', 'CUBE-RADIO-MOONKI-SOUND---30W---465---IPX5-MT-CR430'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5407
Tiempo Consumido: 00:00:00.0150139
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '4001', 'MONITOR-GAMING-HDC-238-HM-238FH144---1920-x-1080---TN-TFT---HDMI--DP---144Hz---1MS'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 4001
Tiempo Consumido: 00:00:00.0870854
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5148', 'stereo-single-din-nakamichi-nq821b-50wx4-btusb-frente-desmontable'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5148
Tiempo Consumido: 00:00:00.0630616
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5736', 'Gabinete-Corsair-Carbide-Spec-Delta-Negro-Mid-Tower-RGB-Sin-Fuente-cVentana-AcrIlico'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5736
Tiempo Consumido: 00:00:00.0500488
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5737', 'Gabinete-Corsair-Carbide-Spec-Delta-Negro-Mid-Tower-RGB-Sin-Fuente-cVentana-AcrIlico'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5737
Tiempo Consumido: 00:00:00.0140134
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '114', 'Adaptador-Wireless-Harman-Kardon-Omni-Blanco'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 114
Tiempo Consumido: 00:00:00.0180178
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '4742', 'Mesa-Keter-Quartet-95'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 4742
Tiempo Consumido: 00:00:00.0210205
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '3991', 'Aspiradora-Robot-Ecovacs-Deebot-500'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 3991
Tiempo Consumido: 00:00:00.0130133
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5197', 'Nakamichi-8ga-Power-Cable-50m164ft-Ofc'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5197
Tiempo Consumido: 00:00:00.0880856
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5136', 'Subwoofer-Amplificado-12-Caja-Slim-Nakamichi-Nbx30a'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5136
Tiempo Consumido: 00:00:00.0200195
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '260', 'Woofer-Rockford-Fosgate-10-Punch-PPS4-10-700W-4OHM'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 260
Tiempo Consumido: 00:00:00.1211183
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '4652', 'Amplificador-Monoblock-Nakamichi-Ngo-D9001-5400w'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 4652
Tiempo Consumido: 00:00:00.0500489
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5235', 'Stereo-Doble-Din--Nakamichi-Nam1612-7-Bt-Usb-Sd-50w-X-4'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5235
Tiempo Consumido: 00:00:00.0190179
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '1758', 'Subwoofer-Boss-PD12LED-12-1600W-4OHM-DVC-Led'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 1758
Tiempo Consumido: 00:00:00.0130128
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '3321', 'Stereo-Boss-480BRGB-Doble-DIN---BTUSBMP3FMAM'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 3321
Tiempo Consumido: 00:00:00.0140134
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5617', 'PARLANTE-PARTY-SPEAKER-MOONKI-SOUND-TRIP-MA-D65TR---65-X-2--15-X-2---900W-PMPO---60W-RMS---TWS'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5617
Tiempo Consumido: 00:00:00.0160156
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5302', 'KETER-COZY-SET-V2-CAMEL-BEIGE'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5302
Tiempo Consumido: 00:00:00.0060061
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5303', 'KETER-COZY-SET-V2-GREY-MISTY-BLUE'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5303
Tiempo Consumido: 00:00:00.0060061
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5304', 'KETER-COZY-SET-V2-YELLOW'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5304
Tiempo Consumido: 00:00:00.0180168
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '4649', 'Stereo-Doble-Din--Nakamichi-Na2300Nc5l-62-Bt-Dvd-Cd-Usb-50w-X-4'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 4649
Tiempo Consumido: 00:00:00.0260251
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5627', 'RELOJ-INTELIGENTE-CON-AUDIO-AMAZON-ECHO-SPOT-NEGRO-CON-FUENTETRAFO'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5627
Tiempo Consumido: 00:00:00.0470456
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc, '5629', 'RELOJ-INTELIGENTE-CON-AUDIO-AMAZON-ECHO-SPOT-BLANCO-CON-FUENTECON-USB'
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 5629
Tiempo Consumido: 00:00:00.0700678
|
