表示が非常に遅くなってしまったので、sqlのスロークエリーログをとったのですが、どこのファイルから吐き出されたクエリーなのかわからないので、もし分かる方がいらしたらご連絡ください。

環境：
EC-CUBE 2.4.3
OS Linux www.junior.co.jp 2.6.18-164.10.1.el5 #1 SMP Wed Dec 30 18:35:37 EST 2009 i686
DBサーバ MySQL 5.0.77
WEBサーバ Apache/2.2.3 (Red Hat)
PHP 5.1.6
GD Loaded


探してほしいSQL文：
■ SELECT COUNT(*) FROM dtb_products WHERE del_flg = N AND comment4 = 'S' AND product_id IN (SELECT product_id FROM dtb_products_class GROUP BY product_id HAVING SUM(stock)=N)

■ SELECT product_id, name, main_list_image, status, product_code_min, product_code_max, price02_min, price02_max, stock_min, stock_max, stock_unlimited_min, stock_unlimited_max, update_date, comment4,comment5,comment6,create_date, product_flag FROM ( SELECT dtb_products.product_id, dtb_products.name, dtb_products.deliv_fee, dtb_products.sale_limit, dtb_products.sale_unlimited, dtb_products.rank, dtb_products.status, dtb_products.product_flag, dtb_products.point_rate, dtb_products.comment1, dtb_products.comment2, dtb_products.comment3, dtb_products.comment4, dtb_products.comment5, dtb_products.comment6, dtb_products.note, dtb_products.file1, dtb_products.file2, dtb_products.file3, dtb_products.file4, dtb_products.file5, dtb_products.file6, dtb_products.main_list_comment, dtb_products.main_list_image, dtb_products.main_comment, dtb_products.main_image, dtb_products.main_large_image, dtb_products.sub_title1, dtb_products.sub_comment1, dtb_products.sub_image1, dtb_products.sub_large_image1, dtb_products.sub_title2, dtb_products.sub_comment2, dtb_products.sub_image2, dtb_products.sub_large_image2, dtb_products.sub_title3, dtb_products.sub_comment3, dtb_products.sub_image3, dtb_products.sub_large_image3, dtb_products.sub_title4, dtb_products.sub_comment4, dtb_products.sub_image4, dtb_products.sub_large_image4, dtb_products.sub_title5, dtb_products.sub_comment5, dtb_products.sub_image5, dtb_products.sub_large_image5, dtb_products.sub_title6, dtb_products.sub_comment6, dtb_products.sub_image6, dtb_products.sub_large_image6, dtb_products.del_flg, dtb_products.creator_id, dtb_products.create_date, dtb_products.update_date, dtb_products.deliv_date_id, T4.product_code_min, T4.product_code_max, T4.price01_min, T4.price01_max, T4.price02_min, T4.price02_max, T4.stock_min, T4.stock_max, T4.stock_unlimited_min, T4.stock_unlimited_max, T4.class_count FROM dtb_products LEFT JOIN ( SELECT product_id, MIN(product_code) AS product_code_min, MAX(product_code) AS product_code_max, MIN(price01) AS price01_min, MAX(price01) AS price01_max, MIN(price02) AS price02_min, MAX(price02) AS price02_max, MIN(stock) AS stock_min, MAX(stock) AS stock_max, MIN(stock_unlimited) AS stock_unlimited_min, MAX(stock_unlimited) AS stock_unlimited_max, COUNT(*) as class_count FROM dtb_products_class GROUP BY product_id ) AS T4 ON dtb_products.product_id = T4.product_id ) AS alldtl WHERE del_flg = N AND comment4 = 'S' AND product_id IN (SELECT product_id FROM dtb_products_class GROUP BY product_id HAVING SUM(stock)=N) ORDER BY create_date DESC,SUBSTR(comment6,N,N),SUBSTR(comment6,N,N),SUBSTR(comment6,N,N),SUBSTR(comment6,N,N),SUBSTR(comment6,N,N) LIMIT N OFFSET N

■ SELECT COUNT(*) FROM dtb_products WHERE del_flg = N AND comment4 = 'S' AND SUBSTR(comment6,N,N) = 'S' AND (status = 'S' ) AND product_flag LIKE 'S' AND product_id IN (SELECT product_id FROM dtb_products_class GROUP BY product_id HAVING SUM(stock)>N)

■ SELECT COUNT(*) FROM dtb_products WHERE del_flg = N AND comment4 = 'S' AND SUBSTR(comment6,N,N) = 'S' AND product_flag LIKE 'S' AND product_id IN (SELECT product_id FROM dtb_products_class GROUP BY product_id HAVING SUM(stock)>N)

■ SELECT ord.order_id, ord.customer_id, ord.order_name01 AS name01, ord.order_name02 AS name02, ord.total, ord.create_date, (SELECT det.product_name FROM dtb_order_detail AS det WHERE ord.order_id = det.order_id LIMIT N ) AS product_name, (SELECT pay.payment_method FROM dtb_payment AS pay WHERE ord.payment_id = pay.payment_id ) AS payment_method FROM ( SELECT order_id, customer_id, order_name01, order_name02, total, create_date, payment_id FROM dtb_order AS ord WHERE del_flg = N AND status <> N ORDER BY create_date DESC LIMIT N OFFSET N ) AS ord

■ SELECT classcategory_id, name FROM dtb_classcategory WHERE del_flg = N ORDER BY rank DESC

■ SELECT DISTINCT main_list_image, price02_min, price02_max, price01_min, price01_max, name, point_rate, T3.product_rank FROM ( SELECT alldtl.*, dtb_category.rank AS category_rank, T2.category_id, T2.rank AS product_rank FROM ( SELECT dtb_products.product_id, dtb_products.name, dtb_products.deliv_fee, dtb_products.sale_limit, dtb_products.sale_unlimited, dtb_products.rank, dtb_products.status, dtb_products.product_flag, dtb_products.point_rate, dtb_products.comment1, dtb_products.comment2, dtb_products.comment3, dtb_products.comment4, dtb_products.comment5, dtb_products.comment6, dtb_products.note, dtb_products.file1, dtb_products.file2, dtb_products.file3, dtb_products.file4, dtb_products.file5, dtb_products.file6, dtb_products.main_list_comment, dtb_products.main_list_image, dtb_products.main_comment, dtb_products.main_image, dtb_products.main_large_image, dtb_products.sub_title1, dtb_products.sub_comment1, dtb_products.sub_image1, dtb_products.sub_large_image1, dtb_products.sub_title2, dtb_products.sub_comment2, dtb_products.sub_image2, dtb_products.sub_large_image2, dtb_products.sub_title3, dtb_products.sub_comment3, dtb_products.sub_image3, dtb_products.sub_large_image3, dtb_products.sub_title4, dtb_products.sub_comment4, dtb_products.sub_image4, dtb_products.sub_large_image4, dtb_products.sub_title5, dtb_products.sub_comment5, dtb_products.sub_image5, dtb_products.sub_large_image5, dtb_products.sub_title6, dtb_products.sub_comment6, dtb_products.sub_image6, dtb_products.sub_large_image6, dtb_products.del_flg, dtb_products.creator_id, dtb_products.create_date, dtb_products.update_date, dtb_products.deliv_date_id, T4.product_code_min, T4.product_code_max, T4.price01_min, T4.price01_max, T4.price02_min, T4.price02_max, T4.stock_min, T4.stock_max, T4.stock_unlimited_min, T4.stock_unlimited_max, T4.class_count FROM dtb_products LEFT JOIN ( SELECT product_id, MIN(product_code) AS product_code_min, MAX(product_code) AS product_code_max, MIN(price01) AS price01_min, MAX(price01) AS price01_max, MIN(price02) AS price02_min, MAX(price02) AS price02_max, MIN(stock) AS stock_min, MAX(stock) AS stock_max, MIN(stock_unlimited) AS stock_unlimited_min, MAX(stock_unlimited) AS stock_unlimited_max, COUNT(*) as class_count FROM dtb_products_class GROUP BY product_id ) AS T4 ON dtb_products.product_id = T4.product_id ) AS alldtl LEFT JOIN dtb_product_categories AS T2 ON alldtl.product_id = T2.product_id LEFT JOIN dtb_category ON T2.category_id = dtb_category.category_id ) AS T1 JOIN ( SELECT max(T2.rank) AS product_rank, T2.product_id FROM dtb_product_categories T2 GROUP BY product_id) AS T3 USING (product_id) WHERE del_flg = N AND T3.product_id = 'S' AND status = N ORDER BY T3.product_rank DESC

■ select param, val from misc

Count: 2143 Time=74.69s (160070s) Lock=0.10s (219s) Rows=1.0 (2142), shopuser[shopuser]@localhost
SELECT name, main_list_image, price01_min, price02_min, price01_max, price02_max, point_rate FROM ( SELECT alldtl.*, dtb_category.rank AS category_rank, T2.category_id, T2.rank AS product_rank FROM ( SELECT dtb_products.product_id, dtb_products.name, dtb_products.deliv_fee, dtb_products.sale_limit, dtb_products.sale_unlimited, dtb_products.rank, dtb_products.status, dtb_products.product_flag, dtb_products.point_rate, dtb_products.comment1, dtb_products.comment2, dtb_products.comment3, dtb_products.comment4, dtb_products.comment5, dtb_products.comment6, dtb_products.note, dtb_products.file1, dtb_products.file2, dtb_products.file3, dtb_products.file4, dtb_products.file5, dtb_products.file6, dtb_products.main_list_comment, dtb_products.main_list_image, dtb_products.main_comment, dtb_products.main_image, dtb_products.main_large_image, dtb_products.sub_title1, dtb_products.sub_comment1, dtb_products.sub_image1, dtb_products.sub_large_image1, dtb_products.sub_title2, dtb_products.sub_comment2, dtb_products.sub_image2, dtb_products.sub_large_image2, dtb_products.sub_title3, dtb_products.sub_comment3, dtb_products.sub_image3, dtb_products.sub_large_image3, dtb_products.sub_title4, dtb_products.sub_comment4, dtb_products.sub_image4, dtb_products.sub_large_image4, dtb_products.sub_title5, dtb_products.sub_comment5, dtb_products.sub_image5, dtb_products.sub_large_image5, dtb_products.sub_title6, dtb_products.sub_comment6, dtb_products.sub_image6, dtb_products.sub_large_image6, dtb_products.del_flg, dtb_products.creator_id, dtb_products.create_date, dtb_products.update_date, dtb_products.deliv_date_id, T4.product_code_min, T4.product_code_max, T4.price01_min, T4.price01_max, T4.price02_min, T4.price02_max, T4.stock_min, T4.stock_max, T4.stock_unlimited_min, T4.stock_unlimited_max, T4.class_count FROM dtb_products LEFT JOIN ( SELECT product_id, MIN(product_code) AS product_code_min, MAX(product_code) AS product_code_max, MIN(price01) AS price01_min, MAX(price01) AS price01_max, MIN(price02) AS price02_min, MAX(price02) AS price02_max, MIN(stock) AS stock_min, MAX(stock) AS stock_max, MIN(stock_unlimited) AS stock_unlimited_min, MAX(stock_unlimited) AS stock_unlimited_max, COUNT(*) as class_count FROM dtb_products_class GROUP BY product_id ) AS T4 ON dtb_products.product_id = T4.product_id ) AS alldtl LEFT JOIN dtb_product_categories AS T2 ON alldtl.product_id = T2.product_id LEFT JOIN dtb_category ON T2.category_id = dtb_category.category_id ) AS allcls WHERE del_flg = N AND status = N AND (stock_max <> N OR stock_max IS NULL) AND product_id = 'S' ORDER BY RAND() LIMIT N

■ SELECT t1.product_id,t1.name,t1.deliv_fee,t1.sale_limit,t1.sale_unlimited,t1.category_id,t1.rank,t1.status,t1.product_flag,t1.point_rate,t1.comment1,t1.comment2,t1.comment3,t1.comment4,t1.comment5,t1.comment6,t1.note,t1.file1,t1.file2,t1.file3,t1.file4,t1.file5,t1.file6,t1.main_list_comment,t1.main_list_image,t1.main_comment,t1.main_image,t1.main_large_image,t1.sub_title1,t1.sub_comment1,t1.sub_image1,t1.sub_large_image1,t1.sub_title2,t1.sub_comment2,t1.sub_image2,t1.sub_large_image2,t1.sub_title3,t1.sub_comment3,t1.sub_image3,t1.sub_large_image3,t1.sub_title4,t1.sub_comment4,t1.sub_image4,t1.sub_large_image4,t1.sub_title5,t1.sub_comment5,t1.sub_image5,t1.sub_large_image5,t1.sub_title6,t1.sub_comment6,t1.sub_image6,t1.sub_large_image6,t1.del_flg,t1.creator_id,t1.create_date,t1.update_date,t1.deliv_date_id,t2.stock,t3.price02,t2.size FROM dtb_products AS t1
LEFT JOIN (SELECT product_id,MAX(stock) AS stock ,classcategory_id2 AS size FROM dtb_products_class GROUP BY product_id) AS t2 ON t1.product_id=t2.product_id
LEFT JOIN (SELECT product_id,MIN(price02) AS price02 FROM dtb_products_class GROUP BY product_id) AS t3 ON t1.product_id=t3.product_id WHERE t1.del_flg='S' AND t1.status='S' AND t1.create_date < (NOW() - interval N hour) AND t1.comment4='S' AND SUBSTRING(t1.product_flag,N,N)=N ORDER BY t1.create_date DESC LIMIT N,N

ぱっと見、商品一覧ページではないでしょうか？

----------------
EC-CUBE公式エヴァンジェリスト
EC-CUBEインテグレートパートナー (株)スピリット・オブ
移転・拡張・高速化・問題解決
各種カスタマイズ・支援依頼承ります。
[url=h