Developer Modules for OpenCart
Database query debugging, page profiling and code changes without editing system files.
SooR
For developers
SQL Query Log in Footer
The module adds a block with database queries that were executed to generate the current page
This category is for people who build modules and customize stores on OpenCart: tools that help you find what slows a page down and change code without touching the core.
SQL query debugging
SQL Query Log in Footer adds a block with every database query on the page, sorted from the slowest, and shows the method or function that called each one. Only the administrator sees the block, it works in both the storefront and the admin, and the module doesn't replace system files. That shows which module or controller makes extra or slow queries. The module runs on OpenCart 2.0.3–3.0.5.
Code changes and integrations
How to change OpenCart behavior through OCMOD without editing system files is covered in the article "OCMOD in OpenCart". For access to store data from external systems there is Advanced REST API with HMAC authentication, webhooks and an OpenAPI description. Modification backups, cron and redirects are in the Tools category, and you can order a module for your task in Module development.