Select Sql_Calc_Found_Rows - Slow Query - Problem


i’m stating to troubleshoot a performance problem on my cs-cart 2.4.x shop …

i have a lot of messages like:

SELECT SQL_CALC_FOUND_ROWS products.*, descr1.product as product, MIN(prices.price) as price, descr1.short_description, IF(descr1.short_description = ‘’, descr1.full_description, ‘’) as full_description, GROUP_CONCAT(IF(products_categories.link_type = ‘M’, CONCAT(products_categories.category_id, ‘M’), products_categories.category_id)) as category_ids, products_categories.position, as seo_name FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = ‘RO’ LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = ‘’ OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN (‘A’, ‘H’) LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = products.product_id AND cscart_seo_names.type = ‘p’ AND cscart_seo_names.dispatch = ‘’ AND cscart_seo_names.lang_code = ‘RO’ WHERE 1 AND (((descr1.search_words LIKE ‘%ultrafast%’) OR descr1.product LIKE ‘%ultrafast%’ OR descr1.page_title LIKE ‘%ultrafast%’ OR products.product_code LIKE ‘%ultrafast%’ OR descr1.short_description LIKE ‘%ultrafast%’ OR descr1.full_description LIKE ‘%ultrafast%’ OR (descr1.meta_keywords LIKE ‘%ultrafast%’ OR descr1.meta_description LIKE ‘%ultrafast%’))) AND products.company_id = 0 AND products.status IN (‘A’) AND (products.usergroup_ids = ‘’ OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN (‘A’) AND prices.usergroup_id IN (0, 0, 1) GROUP BY products.product_id ORDER BY descr1.product desc LIMIT 60, 10;

anyone has a tip … ?!

tk in advance !


this is a standard cs-cart query for product search however it is possible to remove not used parts

you can try to do it yourself or our specialists might assist you as well

best regards,

WSA team

We are also at your service