1 cuota de $ 18.133 (PTF: $ 18.133)
3 cuotas de $ 6.044 (PTF: $ 18.133)
6 cuotas de $ 3.022 (PTF: $ 18.133)
|
Modo de Diseño: Parámetros Internos del Sitio Web |
| Ws_ID: 61651a50-c9fd-4d81-9c9e-3b5efa80712d |
| Page_Id: 29c74063-da20-462a-b1ba-68c69d737cd1 |
| WSU_Id: -1 |
| Parámetros de la Página: ;TONER-GLOBAL-PANTUM-PB211;ITEM_ID=907;GBPWSTID=61651a50-c9fd-4d81-9c9e-3b5efa80712d; |
| Cart Guid: 1c8eb292-da9d-46e3-8d47-4d28d8597da4 |
|
Estados Internos * cust_id:-1 * st_id:1 * dl_id:1 * cc_id:-1 * ccp_id:-1 * Cuotas:-1 * disc_id:1 * bra_id:1 * prli_id:1 * prof_id:1 * stor_id:1 * item_id:-1 * camp_id:-1 * |
| Comp_Id: 1 |
| Lang_Id: 2 |
| 216.73.216.51 |
| * WebSite Designer * |
|
|
|
Tiempo Total de Proceso: 1 Segundos. Ultimos SQL Ejecutados: GBP_LIST: ITEM SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tc.Size_code, tc.Size_desc, '', '' FROM vwWebSiteII_itemSizeColor tc WHERE tc.item_id = 907 and tc.comp_id=1 GROUP BY tc.Size_code, tc.Size_desc Tiempo Consumido: 00:00:00.0089773 GBP_LIST: ITEM SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tc.itemID4SizeColor, '', tc.Size_code, tc.color_code FROM vwWebSiteII_itemSizeColor tc WHERE tc.item_id = 907 and tc.comp_id=1 GROUP BY tc.itemID4SizeColor, tc.color_code, tc.Size_code Tiempo Consumido: 00:00:00.0089742 GBP_LIST: ITEM SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tc.itemID4SizeColor, CASE WHEN -1 = -1 AND '' <> '' THEN (SELECT '') else convert(nvarchar(20),convert(decimal(16,2), tpli.prli_price)) END [price], c.curr_symbol, tc.Item_id FROM vwWebSiteII_itemSizeColor tc INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = tc.comp_id AND tpli.item_id = tc.itemID4SizeColor AND tpli.prli_id = 1 AND tpli.ws_id = '61651a50-c9fd-4d81-9c9e-3b5efa80712d' INNER JOIN tbsysCurrency c ON c.curr_id = tpli.curr_id WHERE tc.item_id = 907 AND tc.comp_id=1 AND tpli.ws_id = '61651a50-c9fd-4d81-9c9e-3b5efa80712d' GROUP BY tc.itemID4SizeColor, tpli.prli_price,c.curr_symbol,tc.Item_id Tiempo Consumido: 00:00:00.0169260 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], ti.item_code, ti.item_annotation1 FROM tbitem ti WHERE ti.item_id = 907 Tiempo Consumido: 00:00:00.0009968 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 = '61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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 catg_id, catg_desc, catg_webnote1 FROM tbCategoryGroup WHERE comp_id=1 ORDER by catg_desc asc Tiempo Consumido: 00:00:00.0019901 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], CASE WHEN TC.cat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.cat_desc), 1, 50) END [cat_WebSite_desc], 'ico-ferreteria.png' FROM TBCATEGORY TC INNER JOIN tbWebSiteII_CategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.prli_id = 1 WHERE TC.CAT_WEB = 'TRUE' AND TC.catg_id='1' AND tmp2.ws_id='61651a50-c9fd-4d81-9c9e-3b5efa80712d' GROUP BY TC.CAT_ID, TC.cat_WebSite_NOTE1, 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.0029656 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 = 1 AND tmp2.ws_id='61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC Tiempo Consumido: 00:00:00.0030209 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 = 1 AND tmp2.ws_id='61651a50-c9fd-4d81-9c9e-3b5efa80712d' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 46 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC Tiempo Consumido: 00:00:00.0020237 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 = 1 AND tmp2.ws_id='61651a50-c9fd-4d81-9c9e-3b5efa80712d' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 47 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC Tiempo Consumido: 00:00:00.0059852 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 = 1 AND tmp2.ws_id='61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC Tiempo Consumido: 00:00:00.0019951 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 = 1 AND tmp2.ws_id='61651a50-c9fd-4d81-9c9e-3b5efa80712d' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 50 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC Tiempo Consumido: 00:00:00.0029909 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 = 1 AND tmp2.ws_id='61651a50-c9fd-4d81-9c9e-3b5efa80712d' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 51 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC Tiempo Consumido: 00:00:00.0029924 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 = 1 AND tmp2.ws_id='61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC Tiempo Consumido: 00:00:00.0029939 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 = 1 AND tmp2.ws_id='61651a50-c9fd-4d81-9c9e-3b5efa80712d' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 53 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC Tiempo Consumido: 00:00:00.0029928 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 = 1 AND tmp2.ws_id='61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC Tiempo Consumido: 00:00:00.0029916 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 = 1 AND tmp2.ws_id='61651a50-c9fd-4d81-9c9e-3b5efa80712d' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 55 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC Tiempo Consumido: 00:00:00.0029922 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 = 1 AND tmp2.ws_id='61651a50-c9fd-4d81-9c9e-3b5efa80712d' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 69 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC Tiempo Consumido: 00:00:00.0019947 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 = 1 AND tmp2.ws_id='61651a50-c9fd-4d81-9c9e-3b5efa80712d' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 72 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC Tiempo Consumido: 00:00:00.0019668 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 = 1 AND tmp2.ws_id='61651a50-c9fd-4d81-9c9e-3b5efa80712d' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 76 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC Tiempo Consumido: 00:00:00.0029918 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 = 1 AND tmp2.ws_id='61651a50-c9fd-4d81-9c9e-3b5efa80712d' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 82 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC Tiempo Consumido: 00:00:00.0019958 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 = 1 AND tmp2.ws_id='61651a50-c9fd-4d81-9c9e-3b5efa80712d' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 62 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_WebSite_desc ASC, TC.subcat_desc ASC, tc.subcat_web_order ASC Tiempo Consumido: 00:00:00.0019609 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), ti.item_code, ti.item_vendorCode, ti.brand_id, ti.item_annotation1, REPLACE(ti.item_annotation2, Char(10), '«br/»'), SUBSTRING (ti.item_annotation2, 1, 100), ti.item_descHTML, tbn.wssn_isNovelty, tbn.wssn_is4Sale, item_WebSite_vendorPage, -- PRECIO ESTANDAR REPLACE(format(convert(decimal(16,0), tpli.prli_price), 'N', 'de-de'),',00',''), convert(decimal(16,0), tpli.prli_price), -- MERCADOPAGO format(1.0760 * tpli.prli_price, 'N', 'de-de') AS 'Numeric Format', -- TARJETA 1 CUOTA format(1.10 * tpli.prli_price, 'N', 'de-de') AS 'Numeric Format', -- TARJETA 3 CUOTAS REPLACE(format(convert(decimal(16,0), 1 * tpli.prli_price), 'N', 'de-de'),',00',''), -- TARJETA 6 CUOTAS REPLACE(format(convert(decimal(16,0), 1 * tpli.prli_price), 'N', 'de-de'),',00',''), -- TARJETA 12 CUOTAS REPLACE(format(convert(decimal(16,0), 1 * tpli.prli_price), 'N', 'de-de'),',00',''), -- CUOTA EN 3 REPLACE(format(convert(decimal(16,0), 1 * tpli.prli_price/3), 'N', 'de-de'),',00',''), -- CUOTA EN 6 REPLACE(format(convert(decimal(16,0), 1 * tpli.prli_price/6), 'N', 'de-de'),',00',''), -- CUOTA EN 12 REPLACE(format(convert(decimal(16,0), 1 * tpli.prli_price/1), 'N', 'de-de'),',00',''), tc.curr_symbol, tbr.brand_desc, CASE WHEN tcat.cat_WebSite_desc <> '' THEN tcat.cat_WebSite_desc ELSE tcat.cat_desc END, --tcat.cat_desc, CASE WHEN tsub.subcat_WebSite_desc <> '' THEN tsub.subcat_WebSite_desc ELSE tsub.subcat_desc END, --tsub.subcat_desc, tcat.cat_id, tsub.subcat_id, convert (decimal(16,2), ttn.tax_percentage) [IVA], REPLACE(ti.item_code,'/','--'), CASE WHEN ti.item_NoStockCheck='true' AND ti.item_web = 'true' AND (ti.item_isForAssociation='false' OR ti.item_annotation1 like '%@@GRISAR%' ) THEN 'True' ELSE 'False' END [grisar_boton], CASE WHEN (tpli.itst_cant «= 0) THEN 0 ELSE CAST(tpli.itst_cant AS INT) END, tpli.itst_LastAvailableInRelalculation, REPLACE(format(CAST(isnull(tpli.strikeThroughPrice,'0') AS INT), 'N', 'de-de'),',00','') 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 convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0')) » 0 THEN convert(decimal(16,0),(-1 * (((tpli.prli_price * 100)/tpli.strikeThroughPrice) -100))) ELSE 0 END, (SELECT TOP 1 CASE WHEN ((tpli2.item_imageChecksum <> 0 and tpli2.item_imageChecksum is not NULL) or vwsiii.item_id IS NULL) THEN 'http://gbp83.globalbluepoint.com/pcq/Temp/App_WebSite/App_PictureFiles/Items/' + dbo.fnStrAllTrim(tpli2.item_code) + '_800.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) FROM tbitem ti INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = ti.comp_id AND tpli.item_id = ti.item_id AND tpli.prli_id = 1 AND tpli.ws_id = '61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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 = '61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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 = 907 Tiempo Consumido: 00:00:00.0807808 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 = 907 Tiempo Consumido: 00:00:00.0049860 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 = 907 Tiempo Consumido: 00:00:00 GBP_LIST: BODY_LIQ SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tpli.item__made, tpli.semaphoreValue, tpli.Item_id, SUBSTRING (tpli.item__WebSite_desc, 1, 50), 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), tbn.wssn_isNovelty, tbn.wssn_is4Sale, REPLACE(format(CAST(tpli.prli_price AS INT), 'N', 'de-de'),',00','') AS 'Numeric Format', tpli.currency_symbol, tpli._brand_desc, CASE WHEN i4c.item_id = tpli.item_id THEN '«a href=http://gbp83.globalbluepoint.com/pcq/COMPARA/X/GBPWSTID=61651a50-c9fd-4d81-9c9e-3b5efa80712d/gbpwst.aspx»Ver Comparacion«/a»' else 'Comparar' END [checked], convert (decimal(16,2), ttn.tax_percentage) [IVA], SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(tpli.item__WebSite_desc), 1, 100), REPLACE(dbo.fnStrAllTrim(tpli.item__code),'/','--'), (SELECT TOP 1 CASE WHEN ((tpli2.item_imageChecksum <> 0 and tpli2.item_imageChecksum is not NULL) or vwsiii.item_id IS NULL) THEN 'http://gbp83.globalbluepoint.com/pcq/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) FROM tbItemAdditional tia INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = tia.comp_id AND tpli.item_id = tia.item_id_1 AND tpli.prli_id = 1 AND tpli.ws_id = '61651a50-c9fd-4d81-9c9e-3b5efa80712d' INNER JOIN tbSubCategory tsub ON tsub.subcat_id = tpli.subcat_id INNER JOIN tbCategory tcat ON tcat.cat_id = tpli.cat_id LEFT JOIN tbWebSiteII_Items_NoveltyAnd4Sale tbn ON tbn.comp_id = tpli.comp_id AND tpli.item_id = tbn.item_id AND tbn.ws_id = '61651a50-c9fd-4d81-9c9e-3b5efa80712d' LEFT JOIN tbWebSiteII_TMPItem4Compare i4c On i4c.item_id = tpli.item_id and i4c.ws_guid = '1c8eb292-da9d-46e3-8d47-4d28d8597da4' 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 tia.item_id = 907 ORDER BY tpli.prli_price ASC Tiempo Consumido: 00:00:00.0548522 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 = 907 Tiempo Consumido: 00:00:00.0009965 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, REPLACE(format(convert(decimal(16,0), tpli.prli_price), 'N', 'de-de'),',00',''), tc.curr_symbol, tpli._brand_desc, CASE WHEN i4c.item_id = ti.item_id THEN '«a href=http://gbp83.globalbluepoint.com/pcq/COMPARA/X/GBPWSTID=61651a50-c9fd-4d81-9c9e-3b5efa80712d/gbpwst.aspx»Ver Comparacion«/a»' else 'Comparar' END [checked], convert (decimal(16,2), ttn.tax_percentage) [IVA], CASE WHEN ti.item_website_desc<>'' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(ti.item_website_desc), 1, 100) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(ti.item_desc), 1, 100) END [item_desc] , REPLACE(ti.item_code,'/','--'), (SELECT TOP 1 CASE WHEN vwsiii.imageCodeOrURL IS NULL THEN 'http://gbp83.globalbluepoint.com/pcq/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), REPLACE(format(CAST(isnull(tpli.strikeThroughPrice,'0') AS INT), 'N', 'de-de'),',00','') 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 convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0')) » 0 THEN convert(decimal(16,0),(-1 * (((tpli.prli_price * 100)/tpli.strikeThroughPrice) -100))) ELSE 0 END FROM tbitem ti INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = ti.comp_id AND tpli.item_id = ti.item_id AND tpli.prli_id = 1 AND tpli.ws_id = '61651a50-c9fd-4d81-9c9e-3b5efa80712d' 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 = '61651a50-c9fd-4d81-9c9e-3b5efa80712d' LEFT JOIN tbWebSiteII_TMPItem4Compare i4c On i4c.item_id = ti.item_id and i4c.ws_guid = '1c8eb292-da9d-46e3-8d47-4d28d8597da4' 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 <> '907' and ti.subcat_id = '3975' Tiempo Consumido: 00:00:00.0778178 |
|
|
Retirá en nuestro local
Destacado
