Jump to content

Getting 500 error on admin product page


ledsales
 Share

Recommended Posts

My partner's site started giving a 500 error after she signed in a couple of days ago. It logs in fine, but then tries to bring up the default page (ribboncafe.com.au/rcadmin.php?_g=products&node=index) and she gets a 500 error. If you change the URL to ribboncafe.com.au/rcadmin.php then the admin page displays and everything works, except when you click the Products link, you get the 500 error again.

Checking the error log shows this: "PHP Fatal error:  Allowed memory size of 11534336 bytes exhausted (tried to allocate 8192 bytes) in /home/ribbonca/public_html/classes/gd.class.php on line 113" which is also confirmed by her web host.

My question is, given 1MB/s is a common I/O limit on shared servers, what would be causing this and why did it just start happening after no changes to the site or hosting?

Note that line 113 in gd.class.php appears to be just a comment line?

There seems to be no way to increase any limits in her hosting, is it a case of CC just being too greedy? She has another site on the same hosting platform (different account though) in Zen Cart that has many more products and it has no issues.

Link to comment
Share on other sites

Welcome ledsales! Glad to see you made it to the forum.

The GD class provides functions that allow CubeCart to create derivations from source images.

Depending on the version of CubeCart, line 113 in the GD class should be:

$this->_gdImageSource = imagecreatefromjpeg($file);

PHP was given 11534336 bytes to run in (11 MiB) - which seems to be a mistake on the part of your hosting provider. (In admin, PHP Info, scroll to the core table and view 'memory_limit'. If it is not 256M, complain to your hosting provider.)

When this "memory exhausted" error occurs (on a typical 256M system), that means the admin has managed to put an image file much greater than 350K in filesize onto the system. The GD library needs to uncompress that image file and that is when large filesizes expand out to consume lots and lots of memory.

Edited by bsmither
Link to comment
Share on other sites

Thanks for that, memory_limit says 2G in both local and master columns, so that doesn't look to be the issue.

That's interesting about the image size, the largest image in any of the image subfolders is 349226 bytes, so just under the limit. But, I have no idea what level of compression she has used on them so they could in fact expand to be very large, but, there is no image larger than 62k uploaded in the last month, so not sure that's it as this only started a few days ago.

As for the gdclass file, screengrab attached.

Capture.JPG

Link to comment
Share on other sites

As for the screen grab, you may be using a text editor (Mac?) that is getting confused over the DOS line endings.

A DOS line ending is both a CR and a LF. OSX and Linux uses just a LF. But your editor is also effecting the CR - resulting in double line-spacing.

PHP Info says 2G is the 'memory_limit". (That's way more than enough, but whatever.)

So why is PHP complaining of:?

PHP Fatal error:  Allowed memory size of 11534336 bytes exhausted

Let me look around, see what I can find. (You might also want to query your host provider about what memory they see for your environment.)

Link to comment
Share on other sites

I just came across an unverified comment that suggests the PHP.INI file setting (can be overridden in .htaccess or by a command in the PHP script) for 'memory_limit' not be expressed as '2G' but rather '2048M'. This was referencing a PHP 7.4 quirk.

Did your host recently upgrade your environment to PHP 7.4?

 

Link to comment
Share on other sites

Hi, no, current version is 7.2.34.

I use Notepad++ as a text editor on windows, notepad++ was indeed set to CR+LF, can toggle it to LF only, so not a worry, just got to sort out this weird memory issue.

The web host confirmed that it is reaching the resource limit for php memory, but that doesn't explain why it's generating errors with an allowed memory size of just 11MB. I will have to hassle them tomorrow or monday.

Link to comment
Share on other sites

Web host said they have temporarily doubled the available memory for this account, but it made no difference. They didn't explain why it was hitting a limit at just 11MB, just said "upgrade to a better account".

Last time we had similar issues we got them, to do a restore from an earlier backup, which fixed it, so will have to resort to that I guess.

Link to comment
Share on other sites

"host confirmed that it is reaching the resource limit for php memory"

I am not sure I understand this expression. Are they saying that, yes indeed, your script is consuming all of the 2GiB of memory given to your hosted environment?

If things are now working, be sure debug mode is enabled and request the admin, Products page.

In the degug section at the bottom of the page, for each SQL query, there will be a leading point of info: how much memory has been consumed (peak amount) and the total amount available. At the very bottom, there will be a summary of memory usage.

Examine these data points looking for a serious jump in memory used.

Edited by bsmither
Link to comment
Share on other sites

Ok, thanks, relevant debug output is below, seems we are nowhere near the limit.

Debug Output

This can be disabled via "Store Settings" » "Advanced" (Tab) » "Enable Debugging".

PHP:
[Notice] /home/ribbonca/public_html/classes/ssl.class.php:39 - Undefined index: _g
GET:
'Before Sanitise:' =>
'After Sanitise:' =>

MySQLi
Queries (5):
1. Hack: 1626654766.98900 --- Duration: 308 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS * FROM `ccCubeCart_sessions` WHERE ccCubeCart_sessions.session_id = 'ff52f147baee495b75647ad7092113f2' LIMIT 1;
2. Hack: 1626654766.99690 --- Duration: 308 µs [CACHE READ] --- Key: sql.29136a2fd82e79bdc69cf14bfd234a44
SELECT * FROM `ccCubeCart_hooks` WHERE ccCubeCart_hooks.enabled = '1' ORDER BY priority ASC ;
3. Hack: 1626654766.99710 --- Duration: 308 µs [CACHE READ] --- Key: sql.301e5d710559e66eed39a32b08f958c9
SELECT * FROM `ccCubeCart_code_snippet` WHERE ccCubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ;
4. Hack: 1626654766.99800 --- Duration: 663 µs [ERROR - NOT CACHED]
INSERT INTO `ccCubeCart_system_error_log` (`message`,`url`,`backtrace`,`time`) VALUES ('[<strong>Notice</strong>] /home/ribbonca/public_html/classes/ssl.class.php:39 - Undefined index: _g','http://ribboncafe.com.au/favicon.ico','mutingErrorHandler() (ssl.class.php:39)\n__construct() (ssl.class.php:54)\ngetInstance() (controller.index.inc.php:60)\ninclude() (index.php:21)\n','1626654766');
5. Hack: 1626654766.99830 --- Duration: 191 µs [NOT CACHED]
DELETE FROM `ccCubeCart_system_error_log` WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 30 DAY)) ;

Memory: Peak Usage / Max (%):
4.07MB / 256M (1.59%)
Cache (File): Enabled
Cache Used: 384.92kB of 1.75MB (21.53%) [Clear Cache]
Page Load Time:
0.030229806900024 seconds

Debug Output

This can be disabled via "Store Settings" » "Advanced" (Tab) » "Enable Debugging".

PHP:
No Errors or Warnings
GET:
'Before Sanitise:' =>
'_g' => products
'node' => index
'After Sanitise:' =>
'_g' => products
'node' => index
'sort' =>
'updated' => DESC

 
 
Memory: Peak Usage / Max (%):
6.34MB / 256M (2.48%)
Cache (File): Always Disabled in ACP or Setup
Cache Used: 0B of 1.75MB (0.00%)
Page Load Time:
0.19681596755981 seconds

One thing the web host mentioned was that they had seen this issue on other cube cart stores, so it might be something in the way cube cart interacts with their particular setup?

Link to comment
Share on other sites

According to this, you have the standard 256M of memory given to PHP -- a very standard amount.

But, in the second debug section, there are no SQL queries listed. That cannot happen.

And when I said, "there will be a leading point of info: how much memory has been consumed (for each SQL query listed)," I guess that must be a customization of mine.

Link to comment
Share on other sites

Sorry, I removed all the sql query info as there were no errors, it all looked normal, I can turn it back on and post it if you think it's worthwhile.

Debug Output

This can be disabled via "Store Settings" » "Advanced" (Tab) » "Enable Debugging".

PHP:
[Notice] /home/ribbonca/public_html/classes/ssl.class.php:39 - Undefined index: _g
GET:
'Before Sanitise:' =>
'After Sanitise:' =>

MySQLi
Queries (5):
1. Hack: 1626695412.93550 --- Duration: 298 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS * FROM `ccCubeCart_sessions` WHERE ccCubeCart_sessions.session_id = '8a13809d9cc9d55b1bf5a924b2a435e6' LIMIT 1;
2. Hack: 1626695412.94330 --- Duration: 298 µs [CACHE READ] --- Key: sql.29136a2fd82e79bdc69cf14bfd234a44
SELECT * FROM `ccCubeCart_hooks` WHERE ccCubeCart_hooks.enabled = '1' ORDER BY priority ASC ;
3. Hack: 1626695412.94350 --- Duration: 298 µs [CACHE READ] --- Key: sql.301e5d710559e66eed39a32b08f958c9
SELECT * FROM `ccCubeCart_code_snippet` WHERE ccCubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ;
4. Hack: 1626695412.94460 --- Duration: 866 µs [ERROR - NOT CACHED]
INSERT INTO `ccCubeCart_system_error_log` (`message`,`url`,`backtrace`,`time`) VALUES ('[<strong>Notice</strong>] /home/ribbonca/public_html/classes/ssl.class.php:39 - Undefined index: _g','http://ribboncafe.com.au/favicon.ico','mutingErrorHandler() (ssl.class.php:39)\n__construct() (ssl.class.php:54)\ngetInstance() (controller.index.inc.php:60)\ninclude() (index.php:21)\n','1626695412');
5. Hack: 1626695412.94510 --- Duration: 363 µs [NOT CACHED]
DELETE FROM `ccCubeCart_system_error_log` WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 30 DAY)) ;

Memory: Peak Usage / Max (%):
4.09MB / 256M (1.6%)
Cache (File): Enabled
Cache Used: 389.93kB of 1.97MB (19.30%) [Clear Cache]
Page Load Time:
0.041549205780029 seconds

Debug Output

This can be disabled via "Store Settings" » "Advanced" (Tab) » "Enable Debugging".

PHP:
No Errors or Warnings
GET:
'Before Sanitise:' =>
'_g' => products
'node' => index
'After Sanitise:' =>
'_g' => products
'node' => index
'sort' =>
'updated' => DESC

MySQLi
Queries (165):
1. Hack: 1626695414.38550 --- Duration: 300 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS * FROM `ccCubeCart_sessions` WHERE ccCubeCart_sessions.session_id = '8a13809d9cc9d55b1bf5a924b2a435e6' LIMIT 1;
2. Hack: 1626695414.38570 --- Duration: 108 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
3. Hack: 1626695414.40940 --- Duration: 267 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_lang_strings` WHERE ccCubeCart_lang_strings.language = 'en-GB' ;
4. Hack: 1626695414.41160 --- Duration: 393 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_hooks` WHERE ccCubeCart_hooks.enabled = '1' ORDER BY priority ASC ;
5. Hack: 1626695414.41260 --- Duration: 232 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_code_snippet` WHERE ccCubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ;
6. Hack: 1626695414.41720 --- Duration: 243 µs [NOT CACHED]
SELECT `name` FROM `ccCubeCart_geo_country` WHERE ccCubeCart_geo_country.numcode = '036' ;
7. Hack: 1626695414.41950 --- Duration: 449 µs [NOT CACHED]
SELECT C.cat_id, C.cat_name, C.cat_parent_id, S.path FROM `ccCubeCart_category` as C LEFT JOIN `ccCubeCart_seo_urls` as S ON S.item_id=C.cat_id WHERE S.type='cat' AND S.redirect='0' ORDER BY C.cat_id DESC
8. Hack: 1626695414.42030 --- Duration: 141 µs [NOT CACHED]
SELECT `cat_id`, `cat_name` FROM `ccCubeCart_category_language` WHERE ccCubeCart_category_language.language = 'en-GB' ;
9. Hack: 1626695414.42560 --- Duration: 165 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MIN(`live_from`) AS `next_time` FROM `ccCubeCart_inventory` WHERE `live_from` > UNIX_TIMESTAMP() LIMIT 1;
10. Hack: 1626695414.42570 --- Duration: 90 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
11. Hack: 1626695414.42790 --- Duration: 173 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_permissions` WHERE ccCubeCart_permissions.admin_id = '2' ;
12. Hack: 1626695414.46470 --- Duration: 404 µs [NOT CACHED]
SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '0' ORDER BY priority, cat_name ASC ;
13. Hack: 1626695414.46490 --- Duration: 179 µs [NOT CACHED]
SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '24';
14. Hack: 1626695414.46510 --- Duration: 144 µs [NOT CACHED]
SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '4';
15. Hack: 1626695414.46530 --- Duration: 212 µs [NOT CACHED]
SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '7';
16. Hack: 1626695414.46550 --- Duration: 152 µs [NOT CACHED]
SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '22';
17. Hack: 1626695414.46570 --- Duration: 132 µs [NOT CACHED]
SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '23';
18. Hack: 1626695414.46600 --- Duration: 307 µs [NOT CACHED]
SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '5';
19. Hack: 1626695414.46620 --- Duration: 183 µs [NOT CACHED]
SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '3';
20. Hack: 1626695414.46640 --- Duration: 199 µs [NOT CACHED]
SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '2';
21. Hack: 1626695414.46660 --- Duration: 146 µs [NOT CACHED]
SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '19';
22. Hack: 1626695414.46680 --- Duration: 194 µs [NOT CACHED]
SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '25';
23. Hack: 1626695414.50110 --- Duration: 1335 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS * FROM `ccCubeCart_inventory` ORDER BY `updated` DESC LIMIT 20 OFFSET 0;
24. Hack: 1626695414.50130 --- Duration: 120 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
25. Hack: 1626695415.02580 --- Duration: 869 µs [NOT CACHED]
SELECT DISTINCT UPPER(LEFT(`name`, 1)) AS `char` FROM `ccCubeCart_inventory`
26. Hack: 1626695415.02700 --- Duration: 281 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '194' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
27. Hack: 1626695415.02720 --- Duration: 99 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
28. Hack: 1626695415.02820 --- Duration: 418 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '194' ;
29. Hack: 1626695415.02910 --- Duration: 314 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '194' AND ccCubeCart_image_index.main_img = '1' ;
30. Hack: 1626695415.03010 --- Duration: 305 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '168' ;
31. Hack: 1626695415.03090 --- Duration: 184 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '168' ;
32. Hack: 1626695415.06070 --- Duration: 139 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '194' ;
33. Hack: 1626695415.06160 --- Duration: 797 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '209' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
34. Hack: 1626695415.06170 --- Duration: 106 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
35. Hack: 1626695415.06210 --- Duration: 260 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '209' ;
36. Hack: 1626695415.06230 --- Duration: 180 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '209' AND ccCubeCart_image_index.main_img = '1' ;
37. Hack: 1626695415.06270 --- Duration: 395 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '167' ;
38. Hack: 1626695415.06310 --- Duration: 171 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '167' ;
39. Hack: 1626695415.06350 --- Duration: 231 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '209' ;
40. Hack: 1626695415.06380 --- Duration: 213 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '175' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
41. Hack: 1626695415.06390 --- Duration: 104 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
42. Hack: 1626695415.06420 --- Duration: 175 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '175' ;
43. Hack: 1626695415.06440 --- Duration: 150 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '175' AND ccCubeCart_image_index.main_img = '1' ;
44. Hack: 1626695415.06450 --- Duration: 152 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '167' ;
45. Hack: 1626695415.06480 --- Duration: 176 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '167' ;
46. Hack: 1626695415.06500 --- Duration: 103 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '175' ;
47. Hack: 1626695415.06530 --- Duration: 171 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '193' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
48. Hack: 1626695415.06540 --- Duration: 93 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
49. Hack: 1626695415.06570 --- Duration: 175 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '193' ;
50. Hack: 1626695415.06590 --- Duration: 156 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '193' AND ccCubeCart_image_index.main_img = '1' ;
51. Hack: 1626695415.06600 --- Duration: 146 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '167' ;
52. Hack: 1626695415.06630 --- Duration: 141 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '167' ;
53. Hack: 1626695415.06650 --- Duration: 118 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '193' ;
54. Hack: 1626695415.06680 --- Duration: 251 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '221' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
55. Hack: 1626695415.06690 --- Duration: 88 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
56. Hack: 1626695415.06710 --- Duration: 170 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '221' ;
57. Hack: 1626695415.06730 --- Duration: 162 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '221' AND ccCubeCart_image_index.main_img = '1' ;
58. Hack: 1626695415.06750 --- Duration: 151 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '166' ;
59. Hack: 1626695415.06780 --- Duration: 148 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '166' ;
60. Hack: 1626695415.06800 --- Duration: 115 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '221' ;
61. Hack: 1626695415.06820 --- Duration: 166 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '220' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
62. Hack: 1626695415.06830 --- Duration: 78 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
63. Hack: 1626695415.06850 --- Duration: 153 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '220' ;
64. Hack: 1626695415.06870 --- Duration: 161 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '220' AND ccCubeCart_image_index.main_img = '1' ;
65. Hack: 1626695415.06890 --- Duration: 150 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '165' ;
66. Hack: 1626695415.06920 --- Duration: 154 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '165' ;
67. Hack: 1626695415.06940 --- Duration: 112 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '220' ;
68. Hack: 1626695415.06960 --- Duration: 170 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '219' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
69. Hack: 1626695415.06970 --- Duration: 104 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
70. Hack: 1626695415.06990 --- Duration: 174 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '219' ;
71. Hack: 1626695415.07020 --- Duration: 238 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '219' AND ccCubeCart_image_index.main_img = '1' ;
72. Hack: 1626695415.07040 --- Duration: 166 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '127' ;
73. Hack: 1626695415.07070 --- Duration: 155 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '127' ;
74. Hack: 1626695415.07090 --- Duration: 125 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '219' ;
75. Hack: 1626695415.07120 --- Duration: 302 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '146' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
76. Hack: 1626695415.07140 --- Duration: 113 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
77. Hack: 1626695415.07170 --- Duration: 217 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '146' ;
78. Hack: 1626695415.07190 --- Duration: 161 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '146' AND ccCubeCart_image_index.main_img = '1' ;
79. Hack: 1626695415.07210 --- Duration: 144 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '128' ;
80. Hack: 1626695415.07240 --- Duration: 157 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '128' ;
81. Hack: 1626695415.07260 --- Duration: 100 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '146' ;
82. Hack: 1626695415.07280 --- Duration: 177 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '70' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
83. Hack: 1626695415.07290 --- Duration: 87 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
84. Hack: 1626695415.07320 --- Duration: 211 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '70' ;
85. Hack: 1626695415.07340 --- Duration: 166 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '70' AND ccCubeCart_image_index.main_img = '1' ;
86. Hack: 1626695415.07370 --- Duration: 242 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '62' ;
87. Hack: 1626695415.07400 --- Duration: 154 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '62' ;
88. Hack: 1626695415.07420 --- Duration: 101 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '70' ;
89. Hack: 1626695415.07440 --- Duration: 202 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '157' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
90. Hack: 1626695415.07450 --- Duration: 83 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
91. Hack: 1626695415.07480 --- Duration: 166 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '157' ;
92. Hack: 1626695415.07500 --- Duration: 163 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '157' AND ccCubeCart_image_index.main_img = '1' ;
93. Hack: 1626695415.07520 --- Duration: 161 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '130' ;
94. Hack: 1626695415.07540 --- Duration: 148 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '130' ;
95. Hack: 1626695415.07560 --- Duration: 108 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '157' ;
96. Hack: 1626695415.07580 --- Duration: 175 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '202' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
97. Hack: 1626695415.07590 --- Duration: 87 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
98. Hack: 1626695415.07630 --- Duration: 200 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '202' ;
99. Hack: 1626695415.07650 --- Duration: 161 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '202' AND ccCubeCart_image_index.main_img = '1' ;
100. Hack: 1626695415.07670 --- Duration: 156 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '136' ;
101. Hack: 1626695415.07700 --- Duration: 200 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '136' ;
102. Hack: 1626695415.07730 --- Duration: 125 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '202' ;
103. Hack: 1626695415.07750 --- Duration: 188 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '179' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
104. Hack: 1626695415.07760 --- Duration: 82 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
105. Hack: 1626695415.07780 --- Duration: 183 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '179' ;
106. Hack: 1626695415.07820 --- Duration: 281 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '179' AND ccCubeCart_image_index.main_img = '1' ;
107. Hack: 1626695415.07850 --- Duration: 269 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '101' ;
108. Hack: 1626695415.07880 --- Duration: 162 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '101' ;
109. Hack: 1626695415.07900 --- Duration: 114 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '179' ;
110. Hack: 1626695415.07940 --- Duration: 421 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '163' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
111. Hack: 1626695415.07970 --- Duration: 197 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
112. Hack: 1626695415.08000 --- Duration: 197 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '163' ;
113. Hack: 1626695415.08020 --- Duration: 183 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '163' AND ccCubeCart_image_index.main_img = '1' ;
114. Hack: 1626695415.08040 --- Duration: 180 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '136' ;
115. Hack: 1626695415.08070 --- Duration: 181 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '136' ;
116. Hack: 1626695415.08100 --- Duration: 127 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '163' ;
117. Hack: 1626695415.08130 --- Duration: 297 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '107' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
118. Hack: 1626695415.08150 --- Duration: 100 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
119. Hack: 1626695415.08180 --- Duration: 170 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '107' ;
120. Hack: 1626695415.08200 --- Duration: 161 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '107' AND ccCubeCart_image_index.main_img = '1' ;
121. Hack: 1626695415.08210 --- Duration: 157 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '130' ;
122. Hack: 1626695415.08240 --- Duration: 177 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '130' ;
123. Hack: 1626695415.08260 --- Duration: 112 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '107' ;
124. Hack: 1626695415.08290 --- Duration: 198 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '162' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
125. Hack: 1626695415.08300 --- Duration: 86 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
126. Hack: 1626695415.08330 --- Duration: 231 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '162' ;
127. Hack: 1626695415.08350 --- Duration: 203 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '162' AND ccCubeCart_image_index.main_img = '1' ;
128. Hack: 1626695415.08380 --- Duration: 189 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '135' ;
129. Hack: 1626695415.08410 --- Duration: 174 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '135' ;
130. Hack: 1626695415.08430 --- Duration: 101 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '162' ;
131. Hack: 1626695415.08450 --- Duration: 171 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '203' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
132. Hack: 1626695415.08460 --- Duration: 88 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
133. Hack: 1626695415.08490 --- Duration: 157 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '203' ;
134. Hack: 1626695415.08510 --- Duration: 167 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '203' AND ccCubeCart_image_index.main_img = '1' ;
135. Hack: 1626695415.08520 --- Duration: 142 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '136' ;
136. Hack: 1626695415.08550 --- Duration: 142 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '136' ;
137. Hack: 1626695415.08570 --- Duration: 129 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '203' ;
138. Hack: 1626695415.08590 --- Duration: 201 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '213' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
139. Hack: 1626695415.08600 --- Duration: 82 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
140. Hack: 1626695415.08630 --- Duration: 159 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '213' ;
141. Hack: 1626695415.08650 --- Duration: 154 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '213' AND ccCubeCart_image_index.main_img = '1' ;
142. Hack: 1626695415.08660 --- Duration: 147 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '154' ;
143. Hack: 1626695415.08690 --- Duration: 141 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '154' ;
144. Hack: 1626695415.08710 --- Duration: 116 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '213' ;
145. Hack: 1626695415.08750 --- Duration: 291 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '8' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
146. Hack: 1626695415.08760 --- Duration: 80 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
147. Hack: 1626695415.08790 --- Duration: 304 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '8' ;
148. Hack: 1626695415.08820 --- Duration: 202 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '8' AND ccCubeCart_image_index.main_img = '1' ;
149. Hack: 1626695415.08840 --- Duration: 141 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '160' ;
150. Hack: 1626695415.08860 --- Duration: 163 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '160' ;
151. Hack: 1626695415.08890 --- Duration: 133 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '8' ;
152. Hack: 1626695415.08920 --- Duration: 258 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '218' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
153. Hack: 1626695415.08930 --- Duration: 101 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
154. Hack: 1626695415.08960 --- Duration: 209 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '218' ;
155. Hack: 1626695415.08990 --- Duration: 207 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '218' AND ccCubeCart_image_index.main_img = '1' ;
156. Hack: 1626695415.09010 --- Duration: 161 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '79' ;
157. Hack: 1626695415.09030 --- Duration: 141 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '79' ;
158. Hack: 1626695415.09050 --- Duration: 110 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '218' ;
159. Hack: 1626695415.09070 --- Duration: 188 µs [NOT CACHED]
SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '217' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1;
160. Hack: 1626695415.09080 --- Duration: 83 µs [NOT CACHED]
SELECT FOUND_ROWS() as Count;
161. Hack: 1626695415.09110 --- Duration: 165 µs [NOT CACHED]
SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '217' ;
162. Hack: 1626695415.09130 --- Duration: 145 µs [NOT CACHED]
SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '217' AND ccCubeCart_image_index.main_img = '1' ;
163. Hack: 1626695415.09150 --- Duration: 177 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '79' ;
164. Hack: 1626695415.09170 --- Duration: 141 µs [NOT CACHED]
SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '79' ;
165. Hack: 1626695415.09190 --- Duration: 100 µs [NOT CACHED]
SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '217' ;

Memory: Peak Usage / Max (%):
8.15MB / 256M (3.18%)
Cache (File): Always Disabled in ACP or Setup
Cache Used: 0B of 1.97MB (0.00%)
Page Load Time:
1.0260000228882 seconds
Link to comment
Share on other sites

It looks like 256M is a good, working memory limit. Another common memory limit is 512M.

Your peak usage of 8.15MB has me wondering what is using that much memory. My peak usage is 3MB.

Did we learn what is the exact version of CubeCart you are using?

Please examine the file /classes/debug.class.php, looking for this function near line 564: private function _debugMemoryUsage($peak = false)

If that function is present, then look near line 222 at the bottom of the public function debugSQL():

            $this->_sql[$type][] = $this->_debugMemoryUsage(true).'<br />'.'<span style="color:#'.$colour.'">Hack: '.str_pad($this->_getTime(),16,'0').(isset($message[1])?' --- Duration: '.$message[1]:'').' ['.$tag.']'.((!$cache&&!$source)?'':' --- Key: sql.'.md5($message[0])).'<br />'.htmlentities($message[0], ENT_COMPAT, 'UTF-8').'</span>';
            return true;
        }

        return false;
    }

Having a call to $this->_debugMemoryUsage at this location will give us a running indicator and allow us to narrow down where the jumps in memory usage occur.

Link to comment
Share on other sites

Posted (edited)

Thanks again, version is 6.4.4

I reckon it's the size of images that is the issue, I didn't realise that admin listings show a thumbnail of each product image which is actually the full sized image scaled for display, so it's opening 20 images, some at up to several MB each once decompressed. So if the problem comes back again when they reduce the temporary higher memory limit I will start reducing image sizes, or get my partner to.

I don't think there are any corrupt files etc in the shop, it all operates normally, it was just bombing when it tried to display the products page in admin, and the only thing different about that is the images.

I don't have time to look at code etc at the moment, am on my regular job so that wouldn't happen until the weekend.

Edited by ledsales
Link to comment
Share on other sites

Well, they removed the increased limit and it all still works, but we decided to migrate it to a better account anyway. As luck would have it, they are discontinuing the cheaper service and shifting everyone to their main service in the next few weeks anyway, so we don't have to actually do anything...

Link to comment
Share on other sites

I am still flummoxed over an initial reported 2G memory_limit, then the host says they doubled it (4G???)!

Yet, in PHP Info afterwards, PHP reports 256M memory_limit - of which you are using 8M. So, something is successful at giving PHP a legitimate amount of memory for CubeCart.

As I said, I think 8M used is a bit high - but that's just me.

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...