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

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

# Запрос номер 3: SELECT `option`, `value` FROM `mg_setting` (0.0013 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 ('6676','6725','6907','3875','4004','4359','4467','4787','4824','4964','5185','5443','5572','5949','6065','6540','6651','6753','6896','6903','512','2689','3700','3857') 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)