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

# Запрос номер 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.0009 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 ('4247','5122','2676','3922','4646','5790','6228','2680','4429','5928','4548','5540','6277','6615','2687','4181','5086','5472','6908','4259','4676','5640','444','4599') 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)