質問 > フロント機能 > 2.12系 お気に入り、表示順変更、検索ができない |
フロント機能
フラット表示 | 前のトピック | 次のトピック |
投稿者 | スレッド |
---|---|
acidorange |
投稿日時: 2015/2/13 0:27
対応状況: −−−
|
半人前 ![]() ![]() 登録日: 2015/2/9 居住地: 投稿: 12 |
Re: 2.12系 お気に入り、表示順変更、検索ができない yuh様
先ほどのはエラーログで、 実行したタイミングで20行ほど同じものが出ていました。 こちら、DBログです。 ----------------------------------------------- [execute end 54dcc36ea07a8#9] SQL: PREPARE mdb2_statement_mysql_9f618df6e9cb22490a9014a279d190ccdd217e7a4 FROM 'SELECT product_id ,product_code_min ,product_code_max ,name ,comment1 ,comment2 ,comment3 ,main_list_comment ,main_image ,main_list_image ,price01_min ,price01_max ,price02_min ,price02_max ,stock_min ,stock_max ,stock_unlimited_min ,stock_unlimited_max ,deliv_date_id ,status ,del_flg ,update_date ,product_class_id ,animal_type ,pedigree ,haircolor ,sex ,individual_no ,birthday ,breeder_name ,breeder_pref ,pedadmin_name ,vaccine_cnt ,pedadmin_type ,kennel_name ,animal_handling ,drawback ,parents ,weight ,note_statement ,note_disp ,remain_time ,bid_cnt FROM ( SELECT dtb_products.product_id ,dtb_products.name ,dtb_products.maker_id ,dtb_products.status ,dtb_products.comment1 ,dtb_products.comment2 ,dtb_products.comment3 ,dtb_products.comment4 ,dtb_products.comment5 ,dtb_products.comment6 ,dtb_products.note ,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_class_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.point_rate ,T4.deliv_fee ,T4.class_count ,T4.animal_type ,T4.pedigree ,T4.haircolor ,T4.sex ,T4.individual_no ,T4.birthday ,T4.breeder_name ,T4.breeder_pref ,T4.pedadmin_name ,T4.vaccine_cnt ,T4.pedadmin_type ,T4.kennel_name ,T4.animal_handling ,T4.drawback ,T4.parents ,T4.weight ,T4.note_statement ,T4.note_disp ,T4.remain_time ,T4.bid_cnt ,dtb_maker.name AS maker_name FROM dtb_products JOIN ( SELECT product_id, MAX(product_class_id) AS product_class_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, MAX(point_rate) AS point_rate, MAX(deliv_fee) AS deliv_fee, COUNT(*) as class_count, animal_type, pedigree, haircolor, sex, individual_no, birthday, breeder_name, breeder_pref, pedadmin_name, vaccine_cnt, pedadmin_type, kennel_name, animal_handling, drawback, parents, weight, note_statement, note_disp, end_date - NOW() AS remain_time, 0 AS bid_cnt FROM dtb_products_class WHERE del_flg = 0 GROUP BY product_id, animal_type, pedigree, haircolor, sex, individual_no, birthday, breeder_name, breeder_pref, pedadmin_name, vaccine_cnt, pedadmin_type, kennel_name, animal_handling, drawback, parents, weight, note_statement, note_disp, remain_time, bid_cnt ) AS T4 ON dtb_products.product_id = T4.product_id LEFT JOIN dtb_maker ON dtb_products.maker_id = dtb_maker.maker_id ) AS alldtl WHERE alldtl.product_id IN (?) AND alldtl.del_flg = 0 ' PlaceHolder: array ( 0 => '1', ) execution time: 3.24 sec from XXX.XX.XX.XXX ----------------------------------------------- いかがでしょうか? |
フラット表示 | 前のトピック | 次のトピック |
題名 | 投稿者 | 日時 |
---|---|---|
![]() |
acidorange | 2015/2/10 9:42 |
![]() |
IPLOGIC | 2015/2/12 21:00 |
![]() |
acidorange | 2015/2/12 21:50 |
![]() |
yuh | 2015/2/12 22:41 |
![]() |
acidorange | 2015/2/12 22:47 |
![]() |
yuh | 2015/2/12 22:53 |
![]() |
acidorange | 2015/2/12 23:13 |
![]() |
yuh | 2015/2/12 23:29 |
![]() |
acidorange | 2015/2/12 23:55 |
![]() |
yuh | 2015/2/13 0:13 |
![]() |
acidorange | 2015/2/13 0:21 |
![]() |
yuh | 2015/2/13 0:21 |
» ![]() |
acidorange | 2015/2/13 0:27 |
![]() |
yuh | 2015/2/13 0:44 |
![]() |
acidorange | 2015/2/13 0:58 |
![]() |
yuh | 2015/2/13 1:01 |
![]() |
acidorange | 2015/2/13 1:09 |
![](images/pixel.gif)