Всего выполнено запросов: 20 шт. за 0.4928 сек. Развернуть Закрыть

# Запрос номер 2: SELECT `value` FROM `mg_setting` WHERE `option` = 'useDefaultSettings' (0.0004 sec ) /var/www/u0375880/data/www/magic-foam.com/mg-core/lib/mg.php (line 0)

# Запрос номер 3: SELECT `option`, `value` FROM `mg_setting` (0.0041 sec ) /var/www/u0375880/data/www/magic-foam.com/mg-core/lib/mg.php (line 0)

Ошибка в SQL запросе: SELECT p.*, p.`id` AS id, CONCAT(c.`parent_url`, c.`url`) AS category_url, IF(c.`unit`, c.`unit`, "шт.") AS category_unit, p.`unit` AS product_unit, c.`weight_unit` AS category_weight_unit, p.`weight_unit` AS product_weight_unit, p.`url` AS product_url, pv.`product_id` AS variant_exist, c.`rate`, (p.`price_course` + p.`price_course` * (IFNULL(c.`rate`, 0))) as price_course, p.`storage_count` AS count_sort FROM `mg_product` AS p LEFT JOIN `mg_product_variant` AS pv ON pv.`product_id` = p.`id` LEFT JOIN `mg_category` AS c ON c.`id` = p.`cat_id` WHERE p.`id` IN ('4806','4952','5670','5697','5844','6551','6617','6627','6711','4050','6165','4246','4500','4518','5140','5730','5950','6506','3984','4172','4379','4428','4823','5089') GROUP BY p.`id` ORDER BY IF(pv.`product_id`, SUM(ABS(pv.`count`)), SUM(ABS(p.`count`))) DESC, p.`id`
Got error 28 from storage engine

/var/www/u0375880/data/www/magic-foam.com/mg-core/models/catalog.php (line 321)

/var/www/u0375880/data/www/magic-foam.com/mg-core/controllers/catalog.php (line 202)

/var/www/u0375880/data/www/magic-foam.com/mg-core/lib/moguta.php (line 0)

/var/www/u0375880/data/www/magic-foam.com/mg-core/mg-start.php (line 64)

/var/www/u0375880/data/www/magic-foam.com/mg-core/index-start.php (line 127)

/var/www/u0375880/data/www/magic-foam.com/index.php (line 6)