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

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

# Запрос номер 3: SELECT `option`, `value` FROM `mg_setting` (0.001 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 ('3691','3693','3697','3715','3837','3854','3913','3942','3948','4498','4589','4602','4715','4864','4887','5202','5220','5376','5516','5658','5701','5988','6026','6064') 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)