Profiling parameters
This is problematic the program is declaring a query whose results will be spooled on the server. The the program will call for one record at a time from the result set. The literal variables (p1,p2,p5,p6,p7) should be related to the configuration of the system stored procedure. The stringed variables (p1-p7) are represented by the last 7 terms of the procedure call.

    exec sp_cursorprepexec 
        @p1 output, -- plan handle for statement after its prepared
        @p2 output, -- cursor, the the program can retrieve one row at a time from the result set
        N'@P1 int,@P2 int,@P3 int,@P4 int,@P5 int,@P6 int,@P7 int',--parameters for execution
        N'&lt;&lt;query text params here reference the list above&gt;&gt;', --statement, parameters here are the ones form the string list above
        @p5 output, --
        @p6 output, -- configuration terms see the docs
        @p7 output, -- 
        -- sql server will compile the query with unknown values for @P1 - @P7
        -- these values will be substituted for @P1-@P7 after its compiled
        1, --@P1
        4,
        1,
        3,
        1,
        8,
        1 --@P7


docs for this http://msdn.microsoft.com/en-us/library/Ff848775%28v=sql.105%29.aspx