Changeset 21433 for branches/version-2_12-dev/data/class/SC_Product.php

Timestamp:

2012/02/03 11:07:25 (14 years ago)

Author:

Seasoft

Message:

#1626 (SQLチューニングによる商品一覧処理の高速化)

File:

• branches/version-2_12-dev/data/class/SC_Product.php (modified) (2 diffs)

branches/version-2_12-dev/data/class/SC_Product.php

@@ -75 +75 @@
         $table = <<< __EOS__
             dtb_products AS alldtl
-            LEFT JOIN dtb_products_class
-                ON alldtl.product_id = dtb_products_class.product_id
-            LEFT JOIN dtb_product_categories
-                ON alldtl.product_id = dtb_product_categories.product_id
 __EOS__;
         $objQuery->setGroupBy('alldtl.product_id');
@@ -118 +114 @@
         $table = <<< __EOS__
             dtb_products AS alldtl
-            LEFT JOIN dtb_products_class
-                ON alldtl.product_id = dtb_products_class.product_id
-            LEFT JOIN dtb_product_categories
-                ON alldtl.product_id = dtb_product_categories.product_id
-__EOS__;
-        $objQuery->setGroupBy('alldtl.product_id');
-        $sql_base = $objQuery->getSql('alldtl.product_id',$table);
-        return $objQuery->getOne( "SELECT count(*) FROM ( $sql_base ) as t" , $arrVal);
+__EOS__;
+        return $objQuery->count($table, '', $arrVal);
     }