Reply To: Stripe Integration

[Jeff Simpson]

#16438

Hi Andrey, Nishit please find the DB logs attached below:
https://webmaklay.com/slow-query-analysis.md

1. Headline finding
One single query pattern is responsible for 99.0% of all database time.

`SELECT p.*, pi.*FROM cart_products pLEFT JOIN cart_product_images pi ON (p.productid = pi.imageprodid AND pi.imageisthumb = 1)WHERE p.prodvisible = 1 AND productid != 76554 AND FIND_IN_SET(83, prodcatids) AND prodavailability = ‘unreserved’ AND prodcurrentinv != 0 AND levenshtein_ratio(‘(813) 896-2999’, prodname) > 60ORDER BY levenshtein_ratio(‘(813) 896-2999’, prodname) DESCLIMIT 5;

Cheers JF