Changeset 21740


Ignore:
Timestamp:
2012/04/13 18:54:12 (9 years ago)
Author:
shutta
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products.php

    r21693 r21740  
    297297            // 商品コード 
    298298            case 'search_product_code': 
    299                 $where .= ' AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? GROUP BY product_id)'; 
     299                $where .= ' AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ?)'; 
    300300                $arrValues[] = sprintf('%%%s%%', $objFormParam->getValue($key)); 
    301301                break; 
Note: See TracChangeset for help on using the changeset viewer.