A lot of queries during profiling

[Daniel]

Hey!

In Prestashop 1.7.3.0 I have over 50,000 products and for each product, each customer has a special price. When profiling mode is activated, eg on the home page, no products are displayed and the profiler shows over 13,000 pages. SQL queries to the database, most of which are queries about the specific price of each of the products. The loading time of the page without profiling and profiling is more or less the same, with the difference that when the profiling is turned on, the busy / loading circle is spinning and as if these 13,000. inquiries were being done.

Has anyone met with something like that? Why are there so many queries? Even on the side of a single product there are just as many of them. Please help.

Edited April 12, 2018 by Daniel (see edit history)