機能要望 > その他 > MySQL での一覧商品表示の速度向上について |
その他
フラット表示 | 前のトピック | 次のトピック |
投稿者 | スレッド |
---|---|
lucky7 |
投稿日時: 2009/3/25 21:25
対応状況: −−−
|
一人前 登録日: 2008/6/2 居住地: 東京近郊 投稿: 101 |
Re: MySQL での一覧商品表示の速度向上について LOGはこのようになっていました…
難解です(;一_一) 2009/03/25 21:20:37 [/index.php] http://**************.com/ SERVER_ADDR:-------------- REMOTE_ADDR:-------------- USER_AGENT:Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/525.19 (KHTML, like Gecko) Chrome/1.0.154.48 Safari/525.19 SELECT DISTINCT A.*, name, price02_min, price01_min, main_list_image ,comment13 FROM dtb_best_products AS A INNER JOIN (SELECT pr.product_id ,pl.product_code_min ,pl.product_code_max ,pl.price01_min ,pl.price01_max ,pl.price02_min ,pl.price02_max ,pl.stock_min ,pl.stock_max ,pl.stock_unlimited_min ,pl.stock_unlimited_max ,pr.del_flg ,pr.status ,pr.name ,pr.comment1, ,pr.comment2, ,pr.comment3, ,pr.comment4, ,pr.comment5, ,pr.comment6, ,pr.comment7, ,pr.comment8, ,pr.comment9, ,pr.comment10, ,pr.comment11, ,pr.comment12, ,pr.comment13, ,pr.comment14, ,pr.comment15, ,pr.comment16, ,pr.comment17, ,pr.comment18, ,pr.comment19, ,pr.comment20, ,pr.comment21, ,pr.comment22, ,pr.comment23, ,pr.comment24, ,pr.comment25, ,pr.update_date, ,pr.main_list_comment ,pr.main_image ,pr.main_list_image ,pr.product_flag ,pr.deliv_date_id ,pr.sale_limit ,pr.point_rate ,pr.sale_unlimited ,pr.create_date ,pr.deliv_fee ,pc.rank ,cc.rank AS category_rank ,cc.category_id FROM (((SELECT product_id as product_id_sub ,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 FROM dtb_products_class GROUP BY product_id ) AS pl LEFT JOIN dtb_products AS pr ON pl.product_id_sub = pr.product_id) LEFT JOIN dtb_product_categories AS pc ON pr.product_id = pc.product_id) LEFT JOIN dtb_category AS cc ON pc.category_id = cc.category_id) AS allcls using(product_id) WHERE status = 1 ORDER BY rand() DB Error: syntax error SELECT DISTINCT A.*, name, price02_min, price01_min, main_list_image ,comment13 FROM dtb_best_products AS A INNER JOIN (SELECT pr.product_id ,pl.product_code_min ,pl.product_code_max ,pl.price01_min ,pl.price01_max ,pl.price02_min ,pl.price02_max ,pl.stock_min ,pl.stock_max ,pl.stock_unlimited_min ,pl.stock_unlimited_max ,pr.del_flg ,pr.status ,pr.name ,pr.comment1, ,pr.comment2, ,pr.comment3, ,pr.comment4, ,pr.comment5, ,pr.comment6, ,pr.comment7, ,pr.comment8, ,pr.comment9, ,pr.comment10, ,pr.comment11, ,pr.comment12, ,pr.comment13, ,pr.comment14, ,pr.comment15, ,pr.comment16, ,pr.comment17, ,pr.comment18, ,pr.comment19, ,pr.comment20, ,pr.comment21, ,pr.comment22, ,pr.comment23, ,pr.comment24, ,pr.comment25, ,pr.update_date, ,pr.main_list_comment ,pr.main_image ,pr.main_list_image ,pr.product_flag ,pr.deliv_date_id ,pr.sale_limit ,pr.point_rate ,pr.sale_unlimited ,pr.create_date ,pr.deliv_fee ,pc.rank ,cc.rank AS category_rank ,cc.category_id FROM (((SELECT product_id as product_id_sub ,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 FROM dtb_products_class GROUP BY product_id ) AS pl LEFT JOIN dtb_products AS pr ON pl.product_id_sub = pr.product_id) LEFT JOIN dtb_product_categories AS pc ON pr.product_id = pc.product_id) LEFT JOIN dtb_category AS cc ON pc.category_id = cc.category_id) AS allcls using(product_id) WHERE status = 1 ORDER BY rand() [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pr.comment2, ,pr.comment3, ,pr.comment4,' at line 1] /var/www/vhosts/**************.com/httpdocs/index.php 38:lc_page_index_ex->process /var/www/vhosts/**************.com/httpdocs/data/class_extends/page_extends/LC_Page_Index_Ex.php 56:lc_page_index->process /var/www/vhosts/**************.com/httpdocs/data/class/pages/LC_Page_Index.php 75:sc_siteview->display /var/www/vhosts/**************.com/httpdocs/data/class/SC_View.php 134:smarty->display /var/www/vhosts/**************.com/httpdocs/data/module/Smarty/libs/Smarty.class.php 1108:smarty->fetch /var/www/vhosts/**************.com/httpdocs/data/module/Smarty/libs/Smarty.class.php 1258:include /var/www/vhosts/**************.com/httpdocs/data/Smarty/templates_c/default/%%F1^F15^F158E3F4%%site_frame.tpl.php 79:smarty->_smarty_include /var/www/vhosts/**************.com/httpdocs/data/module/Smarty/libs/Smarty.class.php 1871:include /var/www/vhosts/**************.com/httpdocs/data/Smarty/templates_c/default/%%58^587^5876E692%%site_main.tpl.php 63:smarty_core_smarty_include_php /var/www/vhosts/**************.com/httpdocs/data/module/Smarty/libs/internals/core.smarty_include_php.php 40:smarty->_include /var/www/vhosts/**************.com/httpdocs/data/module/Smarty/libs/Smarty.class.php 1925:include /var/www/vhosts/**************.com/httpdocs/frontparts/bloc/best5.php 33:lc_page_frontparts_bloc_best5_ex->process /var/www/vhosts/**************.com/httpdocs/data/class_extends/page_extends/frontparts/bloc/LC_Page_FrontParts_Bloc_Best5_Ex.php 56:lc_page_frontparts_bloc_best5->process /var/www/vhosts/**************.com/httpdocs/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Best5.php 68:lc_page_frontparts_bloc_best5_ex->lfgetranking /var/www/vhosts/**************.com/httpdocs/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Best5.php 113:sc_query->select /var/www/vhosts/**************.com/httpdocs/data/class/SC_Query.php 95:sc_dbconn->getall /var/www/vhosts/**************.com/httpdocs/data/class/SC_DbConn.php 161:db_mysql->getall /var/www/vhosts/**************.com/httpdocs/data/module/DB/common.php 1613:db_mysql->query /var/www/vhosts/**************.com/httpdocs/data/module/DB/common.php 1167:db_mysql->simplequery /var/www/vhosts/**************.com/httpdocs/data/module/DB/mysql.php 324:db_mysql->mysqlraiseerror /var/www/vhosts/**************.com/httpdocs/data/module/DB/mysql.php 894:db_mysql->raiseerror /var/www/vhosts/**************.com/httpdocs/data/module/DB/common.php 1853:pear->raiseerror /var/www/vhosts/**************.com/httpdocs/data/module/PEAR.php 557:db_error->db_error /var/www/vhosts/**************.com/httpdocs/data/module/DB.php 893:db_error->pear_error from **************
|
フラット表示 | 前のトピック | 次のトピック |