Display affected row count in the query info table

[squatto]

When using showQueries(), the table below the query currently displays the connection name and the query execution time. It would be useful to also see the number of rows affected by the query.

Thanks!

[squatto]

Here is an example for context. I'd love to know how many rows were affected by the update query:

[freekmurze]

Good idea, I would accept a PR that already adds the number of affected rows to the ExecutedQuery payload.

[squatto]

I've looked around for more information on retrieving the number of affected rows, and it's unfortunately not as easy as I had hoped. Since you're relying on the QueryExecuted event to get the query and info, we're limited to only what's available in the event payload. That unfortunately doesn't include the affected rows. I dug into the Laravel database code and the way it handles running queries seemingly makes it difficult to capture the affected rows in a way that could make them available to the event. There's a reference to it here. You can also check out the affectingStatement() and run() methods on the \Illuminate\Database\Connection class to see how the query is run.

For now I think that we can shelve this idea, since it's going to require a relatively non-trivial change to the framework itself.

[freekmurze]

Ok, thanks for the time you spent on investigating this.

[squatto]

My pleasure!