Using Kohana framework v3 I have created model with N methods using query builder. For example N-10% - use DB::select().
Is there any integrated functionality to do explain select for each method which use DB::select()?
I think to do this in this way:
Extend base query builder class and in Application folder remap execute() function with same code as was original, but add string which will write into mysql_log_of_selects.txt result of execution each select query with prepended EXPLAIN to it.
But what will propose you? Thanks!
Extend base query builder class and in Application folder remap execute() function with same code as was in original, but add "EXPLAIN " before each final query and result of it's execution save to log file.