I have a Prestashop (version 1.6) module that provides search functionality for car parts via TecDoc, that is not working properly. Some parts of the module do work, yet car part searches in particular time out (504 Gateway errors), and certain settings are not saved via the administration panel.
The search issue is probably linked to the connection/queries to the SQL database, which is primarily what I would like you to troubleshoot, and if possible improve since they seem complicated and inefficient with for example a large amount of joins. It's possible the queries were initially generated by computer.
If the problem does not lie only with the SQL you will need to troubleshoot further via the module files and PrestaShop. Knowledge of TecDoc is beneficial since the script is undocumented and relies heavily on this.