[1.7.6.2] Stock management crashes

[redactuk]

Hi folks

Testing an upgraded shop (from 1.6 to 1.7) on local WAMP server. Upgrade has gone well and everything seems to be working, except accessing Catalog > Stocks in admin area crashes/freezes PS (and requires WAMP restart). I've enabled debug mode but that doesn't show any errors just multiple failed or timed out calls to /index.php/api/stock.

Now I'm guessing that main Stock management page is doing query that involves ps_stock_available table, and my hunch is this is struggling as there are 38k records.

So my first step, is can anyone show me how I can see what the main query being run in default Stock management page is? If anyone can reply with SQL with that would be awesome. At least then I can run query on database and see if it's an optimisation issue or perhaps local environment resources issue.

Thanks

Edited December 6, 2019 by redactuk (see edit history)