Dynamics NAV - LS Retail - OMNI - Enable tracing, Debug and enable logging

You can see the sql statement used in the ReplEcommItems method by enabling the tracing on the Omni server.
C:\LS Retail\LSOmni\LSOmniService
C:\LS Retail\LSOmni\LSOmniWinService
In Nlog.config file on the Omni server change
<logger name="*" minlevel="Debug" writeTo="file" />
to
<logger name="*" minlevel="Trace" writeTo="file" />

Restart the LSOmniService and you can see all sql statements in the Omni server logfile.txt  (C:\LS Retail\LSOmni\logs\logfile.txt)