How to process a request in nginx based on information from mysql database?

Question

MySQL

Good afternoon.
There is a php script that, based on the symbolic product code from the url (for example, /product-picture/shorty_100500.jpg), climbs into the database and returns the image file associated with this product.
In fact, I connect apache, php, framework core, and all for the sake of one simple query to the database.
Is it possible to organize such a request directly from nginx?
I say right away - creating a map file via cron and redirecting through it is not a solution.

Answer 1

1. nginx is able to LUA, LUA is able to MYSQL. But what the hell is needed
2. You can run php without Apache and the framework ...
3. Or you can not store pictures in the database and there will be no such problems at all.