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
52678  AG02000042 02  5486 52  1696  34300  ナス  なす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52679  AG02000042 02  5486 52  1696  32800  ニラ  にら  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52680  AG02000042 02  5486 52  1696  31900  ネギ  ねぎ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52681  AG02000042 02  5486 52  1696  41320  ハッサク  はっさく  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52682  AG02000042 02  5486 52  1696  34500  ピーマン  ぴーまん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52683  AG02000042 02  5486 52  1696  49540  ブルーベリー  ぶるーべりー  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52684  AG02000042 02  5486 52  1696  33300  ブロッコリー  ぶろっこりー  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52685  AG02000042 02  5486 52  1696  41390  ポンカン  ぽんかん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52686  AG02000042 02  5486 52  1696  47000  メロン  めろん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52687  AG02000042 02  5486 52  1696  33400  レタス  れたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52688  AG02000042 02  5486 52  1696  41410  レモン  れもん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52689  AG02000042 02  5486 52  1696  30600  レンコン  れんこん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52690  AG02000042 02  5486 52  1696  35200  三度豆  さんどまめ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52691  AG02000042 02  5486 52  1696  30100  大根  だいこん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52692  AG02000042 02  5486 52  1696  30100  大根葉  だいこんは  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52693  AG02000042 02  5486 52  1696  31500  小松菜  こまつな  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52694  AG02000042 02  5486 52  1696  90008  文旦  ぶんたん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52695  AG02000042 02  5486 52  1696  35500  枝豆  えだまめ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52696  AG02000042 02  5486 52  1696  43500  柿  かき  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52697  AG02000042 02  5486 52  1696  45700  栗  くり  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791696  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete

Page 233 of 15485, showing 20 records out of 309681 total, starting on record 4641, ending on 4660

(default) 2 queries took 1031 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 4640, 20202027
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 = 1111004