Changeset 21740

Timestamp:

2012/04/13 18:54:12 (12 years ago)

Author:

shutta

Message:

#1749 商品管理> 商品コードで検索すると遅い(MySQL)
無駄なGROUP BY句が速度劣化を引き起こしていたので削除。

File:

• branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products.php (modified) (1 diff)

branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products.php

@@ -297 +297 @@
             // 商品コード
             case 'search_product_code':
-                $where .= ' AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? GROUP BY product_id)';
+                $where .= ' AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ?)';
                 $arrValues[] = sprintf('%%%s%%', $objFormParam->getValue($key));
                 break;