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
60033  AG01003272 01  5094 011  60601  90003  とら豆  とらまめ  熊本県山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2760601  12  2018-05-04 00:00:00    2018-05-04 19:08:10  AG01003272  2018-05-04 19:08:10  AG01003272  View Edit Delete
60034  AG01003272 01  5094 011  60601  90003  うずら豆  うずらまめ  熊本県山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2760601  12  2018-05-04 00:00:00    2018-05-04 19:08:59  AG01003272  2018-05-04 19:08:59  AG01003272  View Edit Delete
60037  AG01003297 01  5092 011  60599  31500  小松菜  こまつな  熊本県山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2760599  12  2018-05-05 00:00:00    2018-05-05 08:26:37  AG01003297  2018-05-05 08:26:37  AG01003297  View Edit Delete
60039  AG01003299 01  5104 011  60611  34200  黒皮南瓜  くろかわかぼちゃ  熊本県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2760611  12  2018-05-05 00:00:00    2018-05-05 17:12:09  AG01003299  2018-05-05 17:12:09  AG01003299  View Edit Delete
60042  AG02000019 02  2674 51  519  35200  スナップエンドウ  すなっぷえんどう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26584519  12  2018-05-08 00:00:00    2018-05-08 09:05:28  MG00000001  2018-05-08 09:05:28  MG00000001  View Edit Delete
60044  AG02000086 02  2608 51  108  31900  ねぎ  ねぎ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26299108  12  2018-05-08 00:00:00    2018-05-08 09:07:26  MG00000001  2018-05-08 09:07:26  MG00000001  View Edit Delete
60045  AG02000086 02  6158 51  763  33400  コスレタス  こすれたす  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26299763  12  2018-05-08 00:00:00    2018-05-08 09:07:59  MG00000001  2018-05-08 09:07:59  MG00000001  View Edit Delete
60046  AG02000086 02  2708 51  786  32700  フェンネル  ふぇんねる  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26299786  12  2018-05-08 00:00:00    2018-05-08 09:09:51  MG00000001  2018-05-08 09:09:51  MG00000001  View Edit Delete
60047  AG02000019 02  5352 54  77119  35200  スナップエンドウ  すなっぷえんどう  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0277119  12  2018-05-08 00:00:00    2018-05-08 09:15:13  MG00000001  2018-05-08 09:15:13  MG00000001  View Edit Delete
60051  AG02000086 02  6153 52  1843  31900  ねぎ  ねぎ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791843  12  2018-05-08 00:00:00    2018-05-08 09:16:24  MG00000001  2018-05-08 09:16:24  MG00000001  View Edit Delete
60052  AG02000086 02  6153 52  1843  33400  コスレタス  こすれたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791843  12  2018-05-08 00:00:00    2018-05-08 09:16:24  MG00000001  2018-05-08 09:16:24  MG00000001  View Edit Delete
60053  AG02000086 02  6153 52  1843  32700  フェンネル  ふぇんねる  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791843  12  2018-05-08 00:00:00    2018-05-08 09:16:24  MG00000001  2018-05-08 09:16:24  MG00000001  View Edit Delete
60055  AG02000019 02  5268 52  1673  35200  スナップエンドウ  すなっぷえんどう  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791673  12  2018-05-08 00:00:00    2018-05-08 09:16:37  MG00000001  2018-05-08 09:16:37  MG00000001  View Edit Delete
60056  AG02000089 02  6202 51  741  38600  きくらげ  きくらげ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26371741  12  2018-05-08 00:00:00    2018-05-08 11:41:00  MG00000001  2018-05-08 11:41:00  MG00000001  View Edit Delete
60057  AG02000089 02  6198 54  78689  38600  きくらげ  きくらげ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278689  12  2018-05-08 00:00:00    2018-05-08 11:51:32  MG00000001  2018-05-08 11:51:32  MG00000001  View Edit Delete
60058  AG02000089 02  6196 52  1849  38600  きくらげ  きくらげ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791849  12  2018-05-08 00:00:00    2018-05-08 11:51:55  MG00000001  2018-05-08 11:51:55  MG00000001  View Edit Delete
60061  AG03000002 03  6128 61  81  38900  こごみ  こごみ  飛騨 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0250281  12  2018-05-09 00:00:00    2018-05-09 13:50:13  MG00000001  2018-05-09 13:51:27  MG00000001  View Edit Delete
60062  AG02100020 02  5382 53  12  33300  ブロッコリー  ぶろっこりー  徳島県海部郡海陽町高園字松木谷126-2                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530812  12  2018-05-09 00:00:00    2018-05-09 14:10:43  MG00000001  2018-05-09 14:11:06  MG00000001  View Edit Delete
60063  AG02100020 02  5383 53  13  34460  ミニトマト  みにとまと  徳島県海部郡海陽町高園字松木谷126-2                                         
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2530813  12  2018-05-09 00:00:00    2018-05-09 14:11:35  MG00000001  2018-05-09 14:11:35  MG00000001  View Edit Delete
60065  AG01003392 01  2435 010  38600  きくらげ  きくらげ  熊本県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
25108850  12  2018-05-10 00:00:00    2018-05-10 11:42:20  MG00000001  2018-05-10 11:42:20  MG00000001  View Edit Delete

Page 325 of 15485, showing 20 records out of 309681 total, starting on record 6481, ending on 6500

(default) 2 queries took 1009 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 6480, 20202040
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 = 111969