DEV Community

askerakbar
askerakbar

Posted on

Laminas Lens - a sleek, simple, SQL query logger for Laminas MVC

Ever wonder “What database queries is my app running right now?” When slow performance strikes, digging through code is painful. That’s why I built Lens a tiny package that logs every SQL query with timing, parameters, and a simple UI.

Laminas Lens - Query Logger

What Lens does:

  • Logs every DB query in your app (includes timing, bindings, and stack trace)
  • Clean UI at /lens for browsing and searching queries
  • No setup! Just install and go!

Quick install:

composer require askerakbar/lens
Enter fullscreen mode Exit fullscreen mode

Add to your module’s config:

'lens' => [
    'storage' => [
        'type'  => 'database',
        'table' => 'lens_logs', // Optional, default: lens_logs
    ],
],
Enter fullscreen mode Exit fullscreen mode

Once your app runs, you’ll get query logs like:

SELECT * FROM products WHERE category_id = 10 (15 ms)
Enter fullscreen mode Exit fullscreen mode

Lens is still in development. It’s been tested on Laminas MVC ≥3.7 + PDO_MySQL only, and is intended for only for development. It’s mostly for short-term help on existing projects, especially given Laminas MVC’s sunset status.

GitHub → https://github.com/askerakbar/lens

Top comments (0)