Understanding what your application is doing under the hood is critical for performance tuning. Many extended PDO implementations include built-in that log every executed statement along with its execution time.
Table aliases used in complex SQL JOIN statements, making it easy to deduce exactly which database table generated a specific column value.
PDO v2.0 supports scrollable cursors, which enable you to traverse a result set in both forward and backward directions. You can use the scroll method to move the cursor to a specific position.