This figure illustrates the Profiler advanced tab. The Profiler contains and logs the following data:

• Query class

• Domain class

• Total time, total execution time of the query (in milliseconds)

• Local time, the amount of time spent on the user's workstation (in milliseconds)

• Number of objects, the total number of objects affected

• Number of objects handled per second

• Logging, the amount of time spent printing logging messages (in milliseconds)

• SQL prepare, the amount of time spent preparing the SQL (in milliseconds)

• SQL execute, the amount of time spent executing the SQL (in milliseconds)

• Row fetch, the amount of time spent fetching rows from the database (in milliseconds)

• Cache, the amount of time spent searching or updating the object cache (in milliseconds)

• Object build, the amount of time spent building the domain object (in milliseconds)

• Query prepare, the amount of time spent to prepare the query prior to execution (in milliseconds)

• SQL generation, the amount of time spent to generate the SQL before it is sent to the database (in milliseconds)