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
12475  AG01003286 01  2437 010  34600  ししとう  ししとう  熊本県上益城郡山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108652  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2017-11-20 09:55:09  MG00000001  View Edit Delete
12476  AG01003286 01  2438 010  30200  かぶ  かぶ  熊本県上益城郡山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108653  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2018-11-19 08:30:56  AG01003286  View Edit Delete
12477  AG01003286 01  2439 010  30100  大根  だいこん  熊本県上益城郡山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108654  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2018-11-05 08:24:18  AG01003286  View Edit Delete
12478  AG01003286 01  2440 010  36100  さつまいも  さつまいも  熊本県上益城郡山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108655  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2018-10-15 08:32:31  AG01003286  View Edit Delete
12479  AG01003287 01  2435 010  35100  いんげん豆  いんげんまめ  熊本県上益城郡山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108660  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2017-11-20 09:56:05  MG00000001  View Edit Delete
12480  AG01003288 01  2435 010  34300  茄子  なす  熊本県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108680  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2017-10-30 00:00:00  MG00000001  View Edit Delete
12481  AG01003288 01  2436 010  90003  絹さや  きぬさや  熊本県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108681  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2018-05-01 16:17:01  AG01003288  View Edit Delete
12482  AG01003288 01  2437 010  34460  アイコトマト  あいことまと  熊本県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108682  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2018-01-21 10:37:40  AG01003288  View Edit Delete
12483  AG01003291 01  2435 010  35200  スナップエンドウ  すなっぷえんどう  熊本県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108690  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2018-03-25 15:52:15  AG01003291  View Edit Delete
12484  AG01003291 01  2436 010  34300  茄子  なす  熊本県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108691  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2018-04-20 16:15:59  AG01003291  View Edit Delete
12485  AG01003289 01  2435 010  30100  大根  だいこん  熊本県上益城郡山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108740  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2018-11-27 16:12:08  AG01003289  View Edit Delete
12486  AG01003289 01  2436 010  36300  里芋  さといも  熊本県上益城郡山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108741  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2018-10-26 08:25:43  AG01003289  View Edit Delete
12487  AG01003289 01  2437 010  36700  にんにく  にんにく  熊本県上益城郡山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108742  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2017-11-20 10:00:22  MG00000001  View Edit Delete
12488  AG01003289 01  2438 010  36200  メークイン  めーくいん  熊本県上益城郡山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108743  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2018-08-03 18:01:41  AG01003289  View Edit Delete
12489  AG01003289 01  2439 010  31100  白菜  はくさい  熊本県上益城郡山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108744  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2018-11-27 16:14:06  AG01003289  View Edit Delete
12490  AG01003289 01  2440 010  34300  茄子  なす  熊本県上益城郡山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108745  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2018-07-04 08:13:58  AG01003289  View Edit Delete
12491  AG01003290 01  2435 010  90002  ベビーリーフ  べびーりーふ  熊本県上益城郡山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108770  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2017-11-20 10:01:45  MG00000001  View Edit Delete
12497  AG02000060 02  2614 51  118  33400  レタス  れたす  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26944118  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2017-10-30 00:00:00  MG00000001  View Edit Delete
12498  AG02000060 02  2618 51  128  31310  水菜  みずな  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26944128  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2017-10-30 00:00:00  MG00000001  View Edit Delete
12499  AG02000060 02  2619 51  129  31500  小松菜  こまつな  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26944129  12  2017-10-30 00:00:00    2017-10-30 00:00:00  MG00000001  2017-10-30 00:00:00  MG00000001  View Edit Delete

Page 114 of 15485, showing 20 records out of 309681 total, starting on record 2261, ending on 2280

(default) 2 queries took 965 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 2260, 20202013
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 = 111952