View All not working

[keat]

I'm almost certain that i've seen this issue before, but cannot find any results on the forum search.

 

https://www.beal.org.uk

If I search for the keyword 'socket', the site says 10 pages.

I can choose 'View All' and many many listings appear.

 

If I search for a partial part number 'SOK', the site says 7 pages.

Choose 'View All' and only 1 page appears.

 

Any Ideas.

[bsmither]

As I go through the seven pages of results for SOK, I get the same 12 products.

So, there is an issue with the query being built.

In admin, Store Settings, Advanced tab, enable debugging and enter your IP address in the adjacent field (www.whatismyip.com).

Go through the individual pages of search results. At the bottom of each page, examine the queries listed in the debug section.

Look through the list for the query that is looking for the search term.

Look for any query at the bottom of the list that is identified as having a problem.

Please post those complete queries.

[keat]

Does any of this mean anything.

 

[1] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_sessions` WHERE CubeCart_sessions.session_id = '49aq0mke0qa602o1dc5m632in4' LIMIT 1; -- (0.00023508071899414 sec) [NOT CACHED]
[2] SELECT * FROM `CubeCart_hooks` WHERE CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.00023508071899414 sec) [CACHE READ]
[3] SELECT `php_code`, `unique_id`, `description`, `hook_trigger` FROM `CubeCart_code_snippet` WHERE CubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; -- (0.00023508071899414 sec) [CACHE READ]
[4] SELECT * FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.path = 'search' ; -- (0.00047707557678223 sec) [CACHE WRITE]
[5] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'logos' LIMIT 1; -- (0.00047707557678223 sec) [CACHE READ]
[6] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'logos' LIMIT 1; -- (0.00047707557678223 sec) [CACHE READ]
[7] SELECT `folder` FROM `CubeCart_modules` WHERE CubeCart_modules.module = 'livehelp' AND CubeCart_modules.status = '1' ; -- (0.00047707557678223 sec) [CACHE READ]
[8] SELECT * FROM `CubeCart_currency` WHERE CubeCart_currency.code = 'GBP' ; -- (0.00047707557678223 sec) [CACHE READ]
[9] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_customer` WHERE CubeCart_customer.customer_id = '19834' LIMIT 1; -- (0.00021696090698242 sec) [CACHE WRITE]
[10] SELECT FOUND_ROWS() as Count; -- (7.0810317993164E-5 sec) [NOT CACHED]
[11] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'ccss' LIMIT 1; -- (0.00024294853210449 sec) [CACHE WRITE]
[12] SELECT FOUND_ROWS() as Count; -- (7.6055526733398E-5 sec) [NOT CACHED]
[13] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'ccss' LIMIT 1; -- (0.00020217895507812 sec) [CACHE WRITE]
[14] SELECT FOUND_ROWS() as Count; -- (7.3909759521484E-5 sec) [NOT CACHED]
[15] SELECT `ip_address` FROM `CubeCart_ccss_ip_addresses` WHERE CubeCart_ccss_ip_addresses.trusted = '0' ; -- (0.00017404556274414 sec) [CACHE WRITE]
[16] SELECT SQL_CALC_FOUND_ROWS `id`, `hits` FROM `CubeCart_search` WHERE CubeCart_search.searchstr = 'SOK' LIMIT 1; -- (0.0035159587860107 sec) [NOT CACHED]
[17] SELECT FOUND_ROWS() as Count; -- (8.7976455688477E-5 sec) [NOT CACHED]
[18] UPDATE `CubeCart_search` SET `hits` = '26' WHERE CubeCart_search.id = '10073'; -- (0.00015401840209961 sec) [NOT CACHED]
[19] SELECT `group_id` FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.00014209747314453 sec) [CACHE WRITE]
[20] SHOW INDEX FROM `CubeCart_inventory`; -- (0.0002288818359375 sec) [CACHE WRITE]
[21] SHOW VARIABLES LIKE 'ft_min_word_len' -- (0.00042891502380371 sec) [CACHE WRITE]
[22] SELECT I.*, MATCH (I.product_code,I.description,I.name) AGAINST('sok' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (MATCH (I.product_code,I.description,I.name) AGAINST('sok' IN BOOLEAN MODE)) >= 0.5 ORDER BY Relevance DESC LIMIT 12 OFFSET 0 -- (0.0005040168762207 sec) [CACHE WRITE]
[23] SELECT `group_id` FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.0005040168762207 sec) [CACHE READ]
[24] SHOW INDEX FROM `CubeCart_inventory`; -- (0.0005040168762207 sec) [CACHE READ]
[25] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name RLIKE '[[::]]' OR I.description RLIKE '[[::]]' OR I.product_code RLIKE '[[::]]') ORDER BY product_code ASC LIMIT 12 OFFSET 0 -- (0.15134787559509 sec) [CACHE WRITE]
[26] SELECT `group_id` FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.15134787559509 sec) [CACHE READ]
[27] SHOW INDEX FROM `CubeCart_inventory`; -- (0.15134787559509 sec) [CACHE READ]
[28] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name LIKE '%sok%' OR I.description LIKE '%sok%' OR I.product_code LIKE '%sok%') ORDER BY product_code ASC LIMIT 12 OFFSET 0 -- (0.072377920150757 sec) [CACHE WRITE]
[29] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name LIKE '%sok%' OR I.description LIKE '%sok%' OR I.product_code LIKE '%sok%') -- (0.073263883590698 sec) [CACHE WRITE]
[30] SELECT * FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.00032520294189453 sec) [CACHE WRITE]
[31] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '4777' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00017309188842773 sec) [CACHE WRITE]

[bsmither]

Was this from the first page of search results, or from the second or later page of search results?

Queries 22, 25, and 29 show the progression CubeCart took in making the search:
- in RELEVANCE mode - nothing relevant
- in RLIKE mode - the search term is missing (need to fix that)
- in LIKE mode - probably found the results here

But, the queries are using OFFSET 0, which is either the first page, or the offset calculator is getting bad info.

[keat]

Those results were from the first page of results.

If I choose the second page I get the following.#

MySQLi
Queries (502):
[1] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_sessions` WHERE CubeCart_sessions.session_id = '49aq0mke0qa602o1dc5m632in4' LIMIT 1; -- (0.0001990795135498 sec) [NOT CACHED]
[2] SELECT FOUND_ROWS() as Count; -- (7.5101852416992E-5 sec) [NOT CACHED]
[3] SELECT * FROM `CubeCart_lang_strings` WHERE CubeCart_lang_strings.language = 'en-GB' ; -- (0.0033090114593506 sec) [CACHE WRITE]
[4] SELECT * FROM `CubeCart_hooks` WHERE CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.00030279159545898 sec) [CACHE WRITE]
[5] SELECT `php_code`, `unique_id`, `description`, `hook_trigger` FROM `CubeCart_code_snippet` WHERE CubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; -- (0.00018215179443359 sec) [CACHE WRITE]
[6] SELECT C.cat_id, C.cat_name, C.cat_parent_id, S.path FROM `CubeCart_category` as C LEFT JOIN `CubeCart_seo_urls` as S ON S.item_id=C.cat_id AND S.type='cat' AND S.custom='1' ORDER BY C.cat_id DESC -- (0.0043911933898926 sec) [CACHE WRITE]
[7] SELECT `cat_id`, `cat_name` FROM `CubeCart_category_language` WHERE CubeCart_category_language.language = 'en-GB' ; -- (0.0043911933898926 sec) [CACHE READ]
[8] SELECT * FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.path = 'search' ; -- (0.00034785270690918 sec) [CACHE WRITE]
[9] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'logos' LIMIT 1; -- (0.00029301643371582 sec) [CACHE WRITE]
[10] SELECT FOUND_ROWS() as Count; -- (9.5129013061523E-5 sec) [NOT CACHED]
[11] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'logos' LIMIT 1; -- (9.5129013061523E-5 sec) [CACHE READ]
[12] SELECT `folder` FROM `CubeCart_modules` WHERE CubeCart_modules.module = 'livehelp' AND CubeCart_modules.status = '1' ; -- (9.5129013061523E-5 sec) [CACHE READ]
[13] SELECT * FROM `CubeCart_currency` WHERE CubeCart_currency.code = 'GBP' ; -- (0.00024914741516113 sec) [CACHE WRITE]
[14] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_customer` WHERE CubeCart_customer.customer_id = '19834' LIMIT 1; -- (0.00030708312988281 sec) [CACHE WRITE]
[15] SELECT FOUND_ROWS() as Count; -- (0.00010991096496582 sec) [NOT CACHED]
[16] SELECT * FROM `CubeCart_lang_strings` WHERE CubeCart_lang_strings.language = 'en-GB' ; -- (0.00010991096496582 sec) [CACHE READ]
[17] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'ccss' LIMIT 1; -- (0.0003972053527832 sec) [CACHE WRITE]
[18] SELECT FOUND_ROWS() as Count; -- (0.00011491775512695 sec) [NOT CACHED]
[19] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'ccss' LIMIT 1; -- (0.00031518936157227 sec) [CACHE WRITE]
[20] SELECT FOUND_ROWS() as Count; -- (0.00010299682617188 sec) [NOT CACHED]
[21] SELECT `ip_address` FROM `CubeCart_ccss_ip_addresses` WHERE CubeCart_ccss_ip_addresses.trusted = '0' ; -- (0.00010299682617188 sec) [CACHE READ]
[22] SELECT SQL_CALC_FOUND_ROWS `id`, `hits` FROM `CubeCart_search` WHERE CubeCart_search.searchstr = 'SOK' LIMIT 1; -- (0.0061938762664795 sec) [NOT CACHED]
[23] SELECT FOUND_ROWS() as Count; -- (0.00012397766113281 sec) [NOT CACHED]
[24] UPDATE `CubeCart_search` SET `hits` = '34' WHERE CubeCart_search.id = '10073'; -- (0.00026893615722656 sec) [NOT CACHED]
[25] SELECT `group_id` FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.00026893615722656 sec) [CACHE READ]
[26] SHOW INDEX FROM `CubeCart_inventory`; -- (0.00034594535827637 sec) [CACHE WRITE]
[27] SHOW VARIABLES LIKE 'ft_min_word_len' -- (0.00070905685424805 sec) [CACHE WRITE]
[28] SELECT I.*, MATCH (I.product_code,I.description,I.name) AGAINST('sok' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (MATCH (I.product_code,I.description,I.name) AGAINST('sok' IN BOOLEAN MODE)) >= 0.5 ORDER BY Relevance DESC LIMIT 12 OFFSET 12 -- (0.00077390670776367 sec) [CACHE WRITE]
[29] SELECT `group_id` FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.00077390670776367 sec) [CACHE READ]
[30] SHOW INDEX FROM `CubeCart_inventory`; -- (0.00077390670776367 sec) [CACHE READ]
[31] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name RLIKE '[[::]]' OR I.description RLIKE '[[::]]' OR I.product_code RLIKE '[[::]]') ORDER BY product_code ASC LIMIT 12 OFFSET 0 -- (0.00077390670776367 sec) [CACHE READ]
[32] SELECT `group_id` FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.00077390670776367 sec) [CACHE READ]
[33] SHOW INDEX FROM `CubeCart_inventory`; -- (0.00077390670776367 sec) [CACHE READ]
[34] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name LIKE '%sok%' OR I.description LIKE '%sok%' OR I.product_code LIKE '%sok%') ORDER BY product_code ASC LIMIT 12 OFFSET 0 -- (0.086556911468506 sec) [CACHE WRITE]
[35] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name LIKE '%sok%' OR I.description LIKE '%sok%' OR I.product_code LIKE '%sok%') -- (0.084884881973267 sec) [CACHE WRITE]

[bsmither]

Queries 28, 31 and 34 is, again, CubeCart working through the modes of searching - with 31 and 34 not using the proper OFFSET.

This tells me this is not the latest version of CubeCart running your store.

Please see this edit:
https://github.com/cubecart/v6/commit/d11f3e09690e106bf99d5fad72458f70acb75dca

 

[keat]

I made the edit, but the same happens.

Here is the debug output from about page 4 (although it's technically all page 1)

[1] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_sessions` WHERE CubeCart_sessions.session_id = 'ifhdc73bbgfn2o38k9rgmf3jb6' LIMIT 1; -- (0.00016689300537109 sec) [NOT CACHED]
[2] SELECT FOUND_ROWS() as Count; -- (7.4863433837891E-5 sec) [NOT CACHED]
[3] SELECT * FROM `CubeCart_hooks` WHERE CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.0003209114074707 sec) [CACHE WRITE]
[4] SELECT `php_code`, `unique_id`, `description`, `hook_trigger` FROM `CubeCart_code_snippet` WHERE CubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; -- (0.00020694732666016 sec) [CACHE WRITE]
[5] SELECT * FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.path = 'search' ; -- (0.00020098686218262 sec) [CACHE WRITE]
[6] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'logos' LIMIT 1; -- (0.00023984909057617 sec) [CACHE WRITE]
[7] SELECT FOUND_ROWS() as Count; -- (0.00010299682617188 sec) [NOT CACHED]
[8] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'logos' LIMIT 1; -- (0.00024700164794922 sec) [CACHE WRITE]
[9] SELECT `folder` FROM `CubeCart_modules` WHERE CubeCart_modules.module = 'livehelp' AND CubeCart_modules.status = '1' ; -- (0.00021600723266602 sec) [CACHE WRITE]
[10] SELECT * FROM `CubeCart_currency` WHERE CubeCart_currency.code = 'GBP' ; -- (0.00024294853210449 sec) [CACHE WRITE]
[11] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'ccss' LIMIT 1; -- (0.0003349781036377 sec) [CACHE WRITE]
[12] SELECT FOUND_ROWS() as Count; -- (8.2969665527344E-5 sec) [NOT CACHED]
[13] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'ccss' LIMIT 1; -- (0.00017690658569336 sec) [CACHE WRITE]
[14] SELECT FOUND_ROWS() as Count; -- (8.2969665527344E-5 sec) [NOT CACHED]
[15] SELECT `ip_address` FROM `CubeCart_ccss_ip_addresses` WHERE CubeCart_ccss_ip_addresses.trusted = '0' ; -- (0.00015711784362793 sec) [CACHE WRITE]
[16] SELECT SQL_CALC_FOUND_ROWS `id`, `hits` FROM `CubeCart_search` WHERE CubeCart_search.searchstr = 'SOK' LIMIT 1; -- (0.0038690567016602 sec) [NOT CACHED]
[17] SELECT FOUND_ROWS() as Count; -- (7.4863433837891E-5 sec) [NOT CACHED]
[18] UPDATE `CubeCart_search` SET `hits` = '43' WHERE CubeCart_search.id = '10073'; -- (0.00015592575073242 sec) [NOT CACHED]
[19] SHOW INDEX FROM `CubeCart_inventory`; -- (0.00026702880859375 sec) [CACHE WRITE]
[20] SHOW VARIABLES LIKE 'ft_min_word_len' -- (0.0004270076751709 sec) [CACHE WRITE]
[21] SELECT I.*, MATCH (I.product_code,I.description,I.name) AGAINST('sok' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (MATCH (I.product_code,I.description,I.name) AGAINST('sok' IN BOOLEAN MODE)) >= 0.5 ORDER BY Relevance DESC LIMIT 12 OFFSET 36 -- (0.00053691864013672 sec) [CACHE WRITE]
[22] SHOW INDEX FROM `CubeCart_inventory`; -- (0.00053691864013672 sec) [CACHE READ]
[23] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name RLIKE '[[::]]' OR I.description RLIKE '[[::]]' OR I.product_code RLIKE '[[::]]') ORDER BY product_code ASC LIMIT 12 OFFSET 0 -- (0.14987921714783 sec) [CACHE WRITE]
[24] SHOW INDEX FROM `CubeCart_inventory`; -- (0.14987921714783 sec) [CACHE READ]
[25] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name LIKE '%sok%' OR I.description LIKE '%sok%' OR I.product_code LIKE '%sok%') ORDER BY product_code ASC LIMIT 12 OFFSET 0 -- (0.073055028915405 sec) [CACHE WRITE]
[26] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name LIKE '%sok%' OR I.description LIKE '%sok%' OR I.product_code LIKE '%sok%') -- (0.074651002883911 sec) [CACHE WRITE]
[27] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '4777' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00023889541625977 sec) [CACHE WRITE]
[28] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '4777' ORDER BY `main_img` DESC LIMIT 1; -- (0.00018215179443359 sec) [CACHE WRITE]
[29] SELECT FOUND_ROWS() as Count; -- (7.3909759521484E-5 sec) [NOT CACHED]