Hello Andrey,
I have fixed all the remaining tasks mentioned in post #16402. Please check the following link for reference:
[video src="https://excellentnumbers.com/temp_vid/Screencast%20from%202026-09-08%2016-04-51.mp4" /]
The 1 you are seeing on the device is nothing to be surprised about. It is basically a serial number, and there is no need to remove it—just something to be aware of.
Regarding the database issue, below are my findings. This is not related to the Bootstrap template integration. As an experienced developer, I am not surprised this issue exists because the technology used in the codebase is outdated, and query building was not as modern as it is today.
The related-products query is slow because:
It checks every product using levenshtein_ratio().
It calculates the same similarity multiple times.
Categories are stored as comma-separated values, so FIND_IN_SET() cannot use indexes.
Phone numbers are being matched as fuzzy product names.
The fallback query may return unrelated products.
The levenshtein_ratio() function is the main cause of the performance issue. To properly resolve this, I will need to create a relational table because categories are currently stored in a comma-separated format. After that, the query will need to be updated accordingly. If you would like me to proceed, please ensure that a backup of the latest database is taken.
Regarding database cleaning, I cannot safely remove data because records may be interlinked, and this is not a small project. However, you can clean data for a specific date range if you are sure it can be deleted.
