X++:
SELECT A.SALESID,A.SALESNAME,A.RESERVATION,A.CUSTACCOUNT,A.INVOICEACCOUNT,A.DELIVERYDATE,A.DELIVERYADDRESS,A.URL,A.PURCHORDERFORMNUM,A.SALESTAKER,A.SALESGROUP,A.FREIGHTSLIPTYPE,A.DOCUMENTSTATUS,A.CURRENCYCODE,A.PAYMENT,A.CASHDISC,A.TAXGROUP,A.LINEDISC,A.CUSTGROUP,A.DISCPERCENT,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_,A.DIMENSION4_,A.DIMENSION5_,A.DIMENSION6_,A.DIMENSION7_,A.DIMENSION8_,A.DIMENSION9_,A.PRICEGROUPID,A.MULTILINEDISC,A.ENDDISC,A.CUSTOMERREF,A.LISTCODE,A.DLVTERM,A.DLVMODE,A.PURCHID,A.SALESSTATUS,A.MARKUPGROUP,A.SALESTYPE,A.SALESPOOLID,A.POSTINGPROFILE,A.TRANSACTIONCODE,A.DELIVERYZIPCODE,A.DELIVERYCOUNTY,A.DELIVERYCOUNTRY,A.SETTLEVOUCHER,A.DELIVERYSTATE,A.DELIVERYNAME,A.ONETIMECUSTOMER,A.COVSTATUS,A.COMMISSIONGROUP,A.PAYMENTSCHED,A.EMAIL,A.FREIGHTZONE,A.RETURNITEMNUM,A.CONTACTPERSONID,A.DEL_INVOICESUMNUM,A.DEL_PCKSLPSUMNUM,A.DEL_CONFIRMSUMNUM,A.DEL_QUOTATIONSUMNUM,A.DEADLINE,A.INVENTLOCATIONID,A.DEL_PICKINGLISTSUMNUM,A.VATNUM,A.PORT,A.DEL_INVOICEORIGINALS,A.DEL_INVOICECOPIES,A.DEL_PACKINGSLIPORIGINALS,A.DEL_PACKINGSLIPCOPIES,A.DEL_CONFIRMATIONORIGINALS,A.DEL_CONFIRMATIONCOPIES,A.DEL_QUOTATIONORIGINALS,A.DEL_QUOTATIONCOPIES,A.INCLTAX,A.NUMBERSEQUENCEGROUP,A.FIXEDEXCHRATE,A.LANGUAGEID,A.AUTOSUMMARYMODULETYPE,A.GIROTYPE,A.SALESORIGINID,A.ESTIMATE,A.TOUCHED,A.TRANSPORT,A.PRINTMODULETYPE,A.PAYMMODE,A.PAYMSPEC,A.FIXEDDUEDATE,A.DELIVERYCITY,A.DELIVERYSTREET,A.EXPORTREASON,A.DEL_DELIVERYNOTETRANSPORTCODE,A.DEL_DELIVERYNOTEAPPEARANCE,A.DEL_DELIVERYNOTESHIPPER,A.DEL_DELIVERYNOTECARRIER1,A.DEL_DELIVERYNOTECARRIER2,A.DEL_DELIVERYNOTETERMS,A.STATPROCID,A.REFDLVZIPCODE,A.INTERCOMPANYCOMPANYID,A.INTERCOMPANYPURCHID,A.INTERCOMPANYORDER,A.SALESRESPONSIBLE,A.SALESUNITID,A.SMMSALESAMOUNTTOTAL,A.SMMCAMPAIGNID,A.CONSIGNORACCOUNT_RU,A.CONSIGNEEACCOUNT_RU,A.DEL_INVOICE4PAYMSUMNUM_RU,A.DEL_INVOICE4PAYMORIGINALS_RU,A.DEL_INVOICE4PAYMCOPIES_RU,A.RCONTRACTACCOUNT,A.RCONTRACTCODE,A.DELIVERYTOWNID_RU,A.DELIVERYSETTLEMENTID_RU,A.DELIVERYSTREETID_RU,A.DELIVERYFLAT_RU,A.DELIVERYBUILDING_RU,A.DELIVERYESTATE_RU,A.SAPINVOICENUM,A.SAPINVOICEANDFACTUREDATE,A.SAPFACTURENUM,A.SAPSUMMARYINVOICENUM,A.SAPEXPEDITIONORG,A.NOYESSHIPMENT,A.SUBSCRIPTION,A.YEAR,A.INTERMINAL,A.VATPROCESS,A.PURCHBOOKOPERATIONCODE_RU,A.SALESCUSTACCOUNTNUM,A.NOT2SALESBOOK,A.PAYMORDERNUMBER,A.PAYMORDERDATE,A.NOTES,A.CONFREGISTER,A.CONFREGISTERDATE,A.SALESCUSTACCOUNTDATE,A.CREATEDDATE,A.RECID FROM SALESTABLE A WHERE ((DATAAREAID=?) AND (SALESUNITID=?)) ORDER BY A.DATAAREAID DESC,A.SALESID DESC OPTION(FAST 1)
журнал трассировки показывает это. Форма открылась спустя час - полтора, закрывается аналогично долго