Tiempo Total de Proceso: 1 Segundos.
Ultimos SQL Ejecutados:
GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT
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 = 10600
Tiempo Consumido: 00:00:00.0019690
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.0010016
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.0010713
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.0054585
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.0056540
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.0050659
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.0156244
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 = 7 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 = 4 AND comp_id='1'
ORDER BY
TC.cat_web_order
Tiempo Consumido: 00:00:00.0156254
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
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
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.0156556
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.0155947
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
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.0155927
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.0156249
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
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.0156580
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.0155952
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.0156264
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.0156532
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
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
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
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
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.0156571
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.0156244
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
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.0155922
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.0156249
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
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 = 10600
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 = 10600 and ti.comp_id=1
GROUP BY tc.item_id
Tiempo Consumido: 00:00:00
GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 1000;
SET DEADLOCK_PRIORITY LOW;
SELECT tii.itimg_id ,ti.item_desc
FROM tbItemImages tii
INNER JOIN tbItem ti
ON ti.item_id = tii.item_id
WHERE tii.item_id = 10600
Tiempo Consumido: 00:00:00
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 = §ITEM_ID§
Error de Ejecución
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 = 10600
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 = '51423af8-a4a4-4077-b357-6d073bb112f3'
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 <> '10600' and ti.subcat_id = '4069'
Tiempo Consumido: 00:00:00.0624982
|
info@matroxdigital.com.ar
Lunes a Viernes
8.30 a 12.30hs
16 a 20hs /
Sabado
9 A 13hs
