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
60474  AG02000095 02  6213 54  78794  90007  果物その他  くだものそのた  高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278794  12  2018-05-22 00:00:00    2018-05-22 14:16:01  MG00000001  2018-05-22 14:16:01  MG00000001  View Edit Delete
60475  AG02000095 02  6213 54  78794  90008  柑橘  かんきつ  高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278794  12  2018-05-22 00:00:00    2018-05-22 14:16:01  MG00000001  2018-05-22 14:16:01  MG00000001  View Edit Delete
60476  AG02000095 02  6213 54  78794  43500  柿  かき  高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278794  12  2018-05-22 00:00:00    2018-05-22 14:16:01  MG00000001  2018-05-22 14:16:01  MG00000001  View Edit Delete
60477  AG02000095 02  6213 54  78794  41200  清見  きよみ  高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278794  12  2018-05-22 00:00:00    2018-05-22 14:16:01  MG00000001  2018-05-22 14:16:01  MG00000001  View Edit Delete
60478  AG02000095 02  6213 54  78794  40100  温州みかん  うんしゅうみかん  高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278794  12  2018-05-22 00:00:00    2018-05-22 14:16:01  MG00000001  2018-05-22 14:16:01  MG00000001  View Edit Delete
60479  AG02000095 02  6213 54  78794  41260  甘夏  あまなつ  高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278794  12  2018-05-22 00:00:00    2018-05-22 14:16:01  MG00000001  2018-05-22 14:16:01  MG00000001  View Edit Delete
60480  AG02000095 02  6213 54  78794  40100  甘平  かんぺい  高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278794  12  2018-05-22 00:00:00    2018-05-22 14:16:01  MG00000001  2018-05-22 14:16:01  MG00000001  View Edit Delete
60481  AG02000095 02  6213 54  78794  90001  野菜その他  やさいそのた  高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278794  12  2018-05-22 00:00:00    2018-05-22 14:16:01  MG00000001  2018-05-22 14:16:01  MG00000001  View Edit Delete
60482  AG02000095 02  6213 54  78794  90008  黄金柑  おうごんかん  高知県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278794  12  2018-05-22 00:00:00    2018-05-22 14:16:01  MG00000001  2018-05-22 14:16:01  MG00000001  View Edit Delete
60508  AG01003278 01  6230 011  69896  31900  葱  ねぎ  熊本県上益城郡山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2769896  12  2018-05-23 00:00:00    2018-05-23 09:01:51  MG00000001  2018-05-23 09:01:51  MG00000001  View Edit Delete
60509  AG01003278 01  6230 011  69896  36300  里芋  さといも  熊本県上益城郡山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2769896  12  2018-05-23 00:00:00    2018-05-23 09:05:03  MG00000001  2018-05-23 09:05:03  MG00000001  View Edit Delete
60510  AG01003278 01  6230 011  69896  30100  大根  だいこん  熊本県上益城郡山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2769896  12  2018-05-23 00:00:00    2018-05-23 09:05:41  MG00000001  2018-05-23 09:05:41  MG00000001  View Edit Delete
60511  AG01003305 01  6231 011  69897  39310  ゆず  ゆず  熊本県上益城郡山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2769897  12  2018-05-23 00:00:00    2018-05-23 09:51:48  MG00000001  2018-05-23 09:51:48  MG00000001  View Edit Delete
60512  AG01003305 01  6231 011  69897  31500  小松菜  こまつな  熊本県上益城郡山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2769897  12  2018-05-23 00:00:00    2018-05-23 09:52:02  MG00000001  2018-05-23 09:52:02  MG00000001  View Edit Delete
60513  AG01003305 01  6231 011  69897  36300  里芋  さといも  熊本県上益城郡山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2769897  12  2018-05-23 00:00:00    2018-05-23 09:52:38  MG00000001  2018-05-23 09:52:38  MG00000001  View Edit Delete
61407  AG02000097 02  2652 51  199  90001  野菜その他  やさいそのた  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26380199  12  2018-05-25 00:00:00    2018-05-25 14:26:00  MG00000001  2018-05-25 14:26:00  MG00000001  View Edit Delete
61408  AG02000097 02  2679 51  542  38100  菌床生椎茸  きんしょうなましいたけ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26380542  12  2018-05-25 00:00:00    2018-05-25 14:26:58  MG00000001  2018-05-25 14:26:58  MG00000001  View Edit Delete
61409  AG02000098 02  2652 51  199  90001  野菜その他  やさいそのた  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26381199  12  2018-05-25 00:00:00    2018-05-25 14:28:12  MG00000001  2018-07-03 12:29:30  MG00000001  View Edit Delete
61410  AG02000098 02  2635 51  167  34460  ミニトマト  みにとまと  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26381167  12  2018-05-25 00:00:00    2018-05-25 14:28:34  MG00000001  2018-07-03 12:29:17  MG00000001  View Edit Delete
61411  AG02000097 02  6233 54  78867  38100  菌床生椎茸  きんしょうなましいたけ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278867  12  2018-05-25 00:00:00    2018-05-25 14:34:05  MG00000001  2018-05-25 14:34:05  MG00000001  View Edit Delete

Page 342 of 15485, showing 20 records out of 309681 total, starting on record 6821, ending on 6840

(default) 2 queries took 975 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 6820, 20202035
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 = 111940