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

# Запрос номер 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.0008 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_weightUnit, p.`weight_unit` AS product_weightUnit, 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, c.default_vat as cat_vat, c.default_measure as cat_measure, c.default_payment_object as cat_payment_object, c.default_marking_required as cat_marking_required 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 ('4024','6520','3971','5877','4284','4013','5247','5607','5890','5486','5672','4523','4108','5122','4429','6908','6334','4187','5171','6205','6675','6752','4912','5324') 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 339)

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

/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)