Farmer Products

Id Farmer Trader Cmp Product Company Cd Co Product Cd Sys Product Cd Display Product Nm Display Product Fk Display Locality Farmer Edit Flg Brc Shipment Product Characters Brc Shipment Product Cd Brc Price Cd Brc Price Characters Shipment Start Month Shipment End Month Use Start Day Use End Day Del Flg Created Insert User Modified Update User Actions
52240  AG02100005 02  5370 53  00  33200  カリフラワー  かりふらわー  徳島県名西郡石井町高川原字桜間139-2                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530400  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52241  AG02100005 02  5371 53  01  34300  ナス  なす  徳島県名西郡石井町高川原字桜間139-2                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530401  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52242  AG02100005 02  5372 53  02  34100  きゅうり  きゅうり  徳島県名西郡石井町高川原字桜間139-2                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530402  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52243  AG02100005 02  5373 53  03  35100  インゲン豆  いんげんまめ  徳島県名西郡石井町高川原字桜間139-2                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530403  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52244  AG02100005 02  5374 53  04  33920  菜の花  なのはな  徳島県名西郡石井町高川原字桜間139-2                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530404  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52245  AG02100005 02  5375 53  05  34700  とうもろこし  とうもろこし  徳島県名西郡石井町高川原字桜間139-2                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530405  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52246  AG02100005 02  5376 53  06  31310  水菜  みずな  徳島県名西郡石井町高川原字桜間139-2                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530406  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52247  AG02100005 02  5377 53  07  31800  ほうれん草  ほうれんそう  徳島県名西郡石井町高川原字桜間139-2                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530407  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52248  AG02100005 02  5378 53  08  30100  大根葉  だいこんは  徳島県名西郡石井町高川原字桜間139-2                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530408  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52249  AG02100005 02  5379 53  09  36200  じゃが芋  じゃがいも  徳島県名西郡石井町高川原字桜間139-2                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530409  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52250  AG02100006 02  5370 53  00  31900  ねぎ  ねぎ  徳島県板野郡北島町高房字百居内36                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530500  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52251  AG02100006 02  5371 53  01  35500  枝豆  えだまめ  徳島県板野郡北島町高房字百居内36                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530501  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52252  AG02100006 02  5372 53  02  34460  ミニトマト  みにとまと  徳島県板野郡北島町高房字百居内36                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530502  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52253  AG02100006 02  5373 53  03  34800  オクラ  おくら  徳島県板野郡北島町高房字百居内36                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530503  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52254  AG02100006 02  5374 53  04  90002  つるむらさき  つるむらさき  徳島県板野郡北島町高房字百居内36                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530504  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52255  AG02100006 02  5375 53  05  36200  じゃが芋  じゃがいも  徳島県板野郡北島町高房字百居内36                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530505  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52256  AG02100006 02  5376 53  06  36100  さつま芋  さつまいも  徳島県板野郡北島町高房字百居内36                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530506  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52257  AG02100006 02  5377 53  07  34300  ナス  なす  徳島県板野郡北島町高房字百居内36                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530507  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52258  AG02100006 02  5378 53  08  35100  インゲン豆  いんげんまめ  徳島県板野郡北島町高房字百居内36                                            
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530508  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete
52264  AG02100007 02  5370 53  00  90003  シカク豆  しかくまめ  徳島県鳴門市大麻町三俣字走出16                                             
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530100  12  2018-02-09 00:00:00    2018-02-09 00:00:00  MG00000001  2018-02-09 00:00:00  MG00000001  View Edit Delete

Page 216 of 15485, showing 20 records out of 309681 total, starting on record 4301, ending on 4320

(default) 2 queries took 938 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `FarmerProduct`.`id`, `FarmerProduct`.`farmer_id`, `FarmerProduct`.`trader_id`, `FarmerProduct`.`cmp_product_id`, `FarmerProduct`.`company_cd`, `FarmerProduct`.`co_product_cd`, `FarmerProduct`.`sys_product_cd`, `FarmerProduct`.`display_product_nm`, `FarmerProduct`.`display_product_fk`, `FarmerProduct`.`display_locality`, `FarmerProduct`.`farmer_edit_status`, `FarmerProduct`.`brc_shipment_product_characters`, `FarmerProduct`.`brc_shipment_product_cd`, `FarmerProduct`.`brc_price_cd`, `FarmerProduct`.`brc_price_characters`, `FarmerProduct`.`company_shipment_cd`, `FarmerProduct`.`brc_type_flag`, `FarmerProduct`.`brc_mid_flag`, `FarmerProduct`.`val_pos_pattern`, `FarmerProduct`.`mid_checkdigit_flag`, `FarmerProduct`.`shipment_start_month`, `FarmerProduct`.`shipment_end_month`, `FarmerProduct`.`use_start_day`, `FarmerProduct`.`use_end_day`, `FarmerProduct`.`del_flg`, `FarmerProduct`.`created`, `FarmerProduct`.`insert_user`, `FarmerProduct`.`modified`, `FarmerProduct`.`update_user`, `Farmer`.`user_id`, `Farmer`.`agreement_start_day`, `Farmer`.`agreement_end_day`, `Farmer`.`plan_code`, `Farmer`.`agreement_amount`, `Farmer`.`rental_printer_sn`, `Farmer`.`rental_tablet_sn`, `Farmer`.`rental_tablet_tel`, `Farmer`.`rental_tablet_gmail`, `Farmer`.`label_flg`, `Farmer`.`seal_flg`, `Farmer`.`blog_flg`, `Farmer`.`log_save_number`, `Farmer`.`user_post_number`, `Farmer`.`user_address`, `Farmer`.`user_tel`, `Farmer`.`qr_url`, `Farmer`.`notification_file`, `Farmer`.`plain_password`, `Farmer`.`admin_memo`, `Farmer`.`biz_browser_authorized_devices_count`, `Farmer`.`biz_browser_authorized_devices_limit`, `Farmer`.`created`, `Farmer`.`insert_user`, `Farmer`.`modified`, `Farmer`.`update_user`, `CmpProduct`.`id`, `CmpProduct`.`trader_id`, `CmpProduct`.`company_cd`, `CmpProduct`.`co_product_cd`, `CmpProduct`.`co_product_nm`, `CmpProduct`.`co_product_reciept_nm`, `CmpProduct`.`co_product_fk`, `CmpProduct`.`sys_product_cd`, `CmpProduct`.`farmer_linked_flag`, `CmpProduct`.`limited_user_id`, `CmpProduct`.`barcode_generate_pattern`, `CmpProduct`.`barcode_display_format`, `CmpProduct`.`use_start_day`, `CmpProduct`.`use_end_day`, `CmpProduct`.`created`, `CmpProduct`.`insert_user`, `CmpProduct`.`modified`, `CmpProduct`.`update_user`, `SysProduct`.`sys_product_cd`, `SysProduct`.`sys_product_nm`, `SysProduct`.`sys_product_fk`, `SysProduct`.`classify_cd`, `SysProduct`.`use_start_day`, `SysProduct`.`use_end_day`, `SysProduct`.`del_flg`, `SysProduct`.`created`, `SysProduct`.`insert_user`, `SysProduct`.`modified`, `SysProduct`.`update_user` FROM `sato_agri`.`farmer_products` AS `FarmerProduct` LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`FarmerProduct`.`farmer_id` = `Farmer`.`user_id`) LEFT JOIN `sato_agri`.`cmp_products` AS `CmpProduct` ON (`FarmerProduct`.`cmp_product_id` = `CmpProduct`.`id`) LEFT JOIN `sato_agri`.`sys_products` AS `SysProduct` ON (`FarmerProduct`.`sys_product_cd` = `SysProduct`.`sys_product_cd`) WHERE 1 = 1 ORDER BY `FarmerProduct`.`id` asc LIMIT 4300, 20202022
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`farmer_products` AS `FarmerProduct` LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`FarmerProduct`.`farmer_id` = `Farmer`.`user_id`) LEFT JOIN `sato_agri`.`cmp_products` AS `CmpProduct` ON (`FarmerProduct`.`cmp_product_id` = `CmpProduct`.`id`) LEFT JOIN `sato_agri`.`sys_products` AS `SysProduct` ON (`FarmerProduct`.`sys_product_cd` = `SysProduct`.`sys_product_cd`) WHERE 1 = 111916