ECCUBEの管理画面で規格をクリックしてもだんまり

完全に備忘録ですが・・・

 

ECCUBE 2.4.4で商品管理から商品一覧を表示し、規格をクリックしても、無反応というか時間がかかるというか、数分単位で待つ必要がありました。

ただ、なぜか一覧の一番上の商品の「規格」ボタンだけはすぐ表示されるという…

/data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php

 

変更前
“vw_cross_products_class” =>’
(SELECT T1.class_id1, T1.class_id2, T1.classcategory_id1, T1.classcategory_id2, T2.product_id,
T1.name1, T1.name2, T2.product_code, T2.stock, T2.price01, T2.price02, T1.rank1, T1.rank2
FROM (SELECT T1.class_id AS class_id1, T2.class_id AS class_id2, T1.classcategory_id AS classcategory_id1, T2.classcategory_id AS classcategory_id2, T1.name AS name1, T2.name AS name2, T1.rank AS rank1, T2.rank AS rank2
FROM dtb_classcategory AS T1, dtb_classcategory AS T2 ) AS T1 LEFT JOIN dtb_products_class AS T2
ON T1.classcategory_id1 = T2.classcategory_id1 AND T1.classcategory_id2 = T2.classcategory_id2) ‘,

変更後
“vw_cross_products_class” =>’
(SELECT T3.class_id1, T4.class_id AS class_id2, T3.classcategory_id1, T3.classcategory_id2, T3.product_id, T3.name1, T4.name AS name2, T3.product_code, T3.stock, T3.price01, T3.price02, T3.rank1, T4.rank AS rank2
FROM (SELECT T1.product_id, T1.product_code, T1.stock, T1.price01, T1.price02, T1.classcategory_id1, T1.classcategory_id2, T2.class_id AS class_id1, T2.name AS name1, T2.rank AS rank1
FROM dtb_products_class AS T1 LEFT JOIN dtb_classcategory AS T2 ON T1.classcategory_id1 = T2.classcategory_id) AS T3 LEFT JOIN dtb_classcategory AS T4 ON T3.classcategory_id2 = T4.classcategory_id) ‘,

で直りました。