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
60296  AG02000093 02  6207 54  78735  31700  キャベツ  きゃべつ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278735  12  2018-05-16 00:00:00    2018-05-16 11:24:38  MG00000001  2018-05-16 11:24:38  MG00000001  View Edit Delete
60298  AG02000093 02  6207 54  78735  33810  チンゲン菜  ちんげんさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278735  12  2018-05-16 00:00:00    2018-05-16 11:24:38  MG00000001  2018-05-16 11:24:38  MG00000001  View Edit Delete
60299  AG02000093 02  6207 54  78735  34500  ピーマン  ぴーまん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278735  12  2018-05-16 00:00:00    2018-05-16 11:24:38  MG00000001  2018-05-16 11:24:38  MG00000001  View Edit Delete
60300  AG02000093 02  6207 54  78735  33300  ブロッコリー  ぶろっこりー  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278735  12  2018-05-16 00:00:00    2018-05-16 11:24:38  MG00000001  2018-05-16 11:24:38  MG00000001  View Edit Delete
60301  AG02000093 02  6207 54  78735  33400  レタス  れたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278735  12  2018-05-16 00:00:00    2018-05-16 11:24:38  MG00000001  2018-05-16 11:24:38  MG00000001  View Edit Delete
60302  AG02000093 02  6207 54  78735  34200  南瓜  かぼちゃ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278735  12  2018-05-16 00:00:00    2018-05-16 11:24:38  MG00000001  2018-05-16 11:24:38  MG00000001  View Edit Delete
60303  AG02000093 02  6207 54  78735  30100  大根  だいこん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278735  12  2018-05-16 00:00:00    2018-05-16 11:24:38  MG00000001  2018-05-16 11:24:38  MG00000001  View Edit Delete
60304  AG02000093 02  6207 54  78735  30100  大根葉  だいこんは  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278735  12  2018-05-16 00:00:00    2018-05-16 11:24:38  MG00000001  2018-05-16 11:24:38  MG00000001  View Edit Delete
60305  AG02000093 02  6207 54  78735  31500  小松菜  こまつな  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278735  12  2018-05-16 00:00:00    2018-05-16 11:24:38  MG00000001  2018-05-16 11:24:38  MG00000001  View Edit Delete
60306  AG02000093 02  6207 54  78735  36600  玉ねぎ  たまねぎ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278735  12  2018-05-16 00:00:00    2018-05-16 11:24:38  MG00000001  2018-05-16 11:24:38  MG00000001  View Edit Delete
60307  AG02000093 02  6207 54  78735  31100  白菜  はくさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278735  12  2018-05-16 00:00:00    2018-05-16 11:24:38  MG00000001  2018-05-16 11:24:38  MG00000001  View Edit Delete
60308  AG02000093 02  6207 54  78735  90001  野菜その他  やさいそのた  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278735  12  2018-05-16 00:00:00    2018-05-16 11:24:38  MG00000001  2018-05-16 11:24:38  MG00000001  View Edit Delete
60319  AG02000091 02  6210 52  1851  30300  人参  にんじん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791851  12  2018-05-18 00:00:00    2018-05-18 12:17:17  MG00000001  2018-05-18 12:17:17  MG00000001  View Edit Delete
60320  AG02000091 02  6210 52  1851  90001  野菜その他  やさいそのた  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791851  12  2018-05-18 00:00:00    2018-05-18 12:17:17  MG00000001  2018-05-18 12:17:17  MG00000001  View Edit Delete
60322  AG02100004 02  5405 53  35  36600  玉ねぎ  たまねぎ  徳島県海部郡海陽町大里字松原34-171                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530735  12  2018-05-18 00:00:00    2018-05-18 12:21:15  MG00000001  2018-05-18 12:21:40  MG00000001  View Edit Delete
60323  AG02100004 02  5406 53  36  30300  人参  にんじん  徳島県海部郡海陽町大里字松原34-171                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530736  12  2018-05-18 00:00:00    2018-05-18 12:22:14  MG00000001  2018-05-18 12:22:14  MG00000001  View Edit Delete
60324  AG02100004 02  5407 53  37  49300  キウイフルーツ  きういふるーつ  徳島県海部郡海陽町大里字松原34-171                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530737  12  2018-05-18 00:00:00    2018-05-18 12:22:52  MG00000001  2018-05-18 12:22:52  MG00000001  View Edit Delete
60325  AG02100004 02  5408 53  38  33400  ロメインレタス  ろめいんれたす  徳島県海部郡海陽町大里字松原34-171                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530738  12  2018-05-18 00:00:00    2018-05-18 12:23:40  MG00000001  2018-05-18 12:23:40  MG00000001  View Edit Delete
60326  AG01003299 01  5104 011  60611  39200  小梅  こうめ  熊本県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2760611  12  2018-05-18 00:00:00    2018-05-18 16:33:29  AG01003299  2018-05-18 16:33:29  AG01003299  View Edit Delete
60330  AG02000092 02  6214 54  78832  34300  なす  なす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278832  12  2018-05-21 00:00:00    2018-05-21 13:56:54  MG00000001  2018-05-21 13:56:54  MG00000001  View Edit Delete

Page 334 of 15485, showing 20 records out of 309681 total, starting on record 6661, ending on 6680

(default) 2 queries took 983 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 LIMIT 6660, 20202037
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 = 111946