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
60276  AG02000093 02  2608 51  108  31900  ねぎ  ねぎ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26375108  12  2018-05-16 00:00:00    2018-05-16 11:16:48  MG00000001  2018-05-16 11:16:48  MG00000001  View Edit Delete
60277  AG02000093 02  2630 51  154  31800  ほうれん草  ほうれんそう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26375154  12  2018-05-16 00:00:00    2018-05-16 11:17:22  MG00000001  2018-05-16 11:17:22  MG00000001  View Edit Delete
60278  AG02000093 02  2650 51  193  30100  大根  だいこん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26375193  12  2018-05-16 00:00:00    2018-05-16 11:17:49  MG00000001  2018-05-16 11:17:49  MG00000001  View Edit Delete
60279  AG02000093 02  2632 51  160  30200  かぶら  かぶら  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26375160  12  2018-05-16 00:00:00    2018-05-16 11:18:56  MG00000001  2018-05-16 11:18:56  MG00000001  View Edit Delete
60280  AG02000093 02  2605 51  105  36200  じゃがいも  じゃがいも  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26375105  12  2018-05-16 00:00:00    2018-05-16 11:19:23  MG00000001  2018-05-16 11:19:23  MG00000001  View Edit Delete
60281  AG02000093 02  2615 51  119  34500  ピーマン  ぴーまん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26375119  12  2018-05-16 00:00:00    2018-05-16 11:19:47  MG00000001  2018-05-16 11:19:47  MG00000001  View Edit Delete
60282  AG02000093 02  2610 51  112  34300  なす  なす  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26375112  12  2018-05-16 00:00:00    2018-05-16 11:20:16  MG00000001  2018-05-16 11:20:16  MG00000001  View Edit Delete
60283  AG02000093 02  2607 51  107  34100  きゅうり  きゅうり  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26375107  12  2018-05-16 00:00:00    2018-05-16 11:20:46  MG00000001  2018-05-16 11:20:46  MG00000001  View Edit Delete
60284  AG02000093 02  2644 51  183  90003  キヌサヤ  きぬさや  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26375183  12  2018-05-16 00:00:00    2018-05-16 11:21:27  MG00000001  2018-05-16 11:21:27  MG00000001  View Edit Delete
60285  AG02000093 02  2636 51  168  30100  大根葉  だいこんは  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26375168  12  2018-05-16 00:00:00    2018-05-16 11:22:08  MG00000001  2018-05-16 11:23:45  MG00000001  View Edit Delete
60286  AG02000093 02  2611 51  114  34200  南瓜  かぼちゃ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26375114  12  2018-05-16 00:00:00    2018-05-16 11:22:34  MG00000001  2018-05-16 11:22:34  MG00000001  View Edit Delete
60287  AG02000093 02  6207 54  78735  30200  かぶら  かぶら  徳島県 
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
60288  AG02000093 02  6207 54  78735  34100  きゅうり  きゅうり  徳島県 
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
60289  AG02000093 02  6207 54  78735  36200  じゃがいも  じゃがいも  徳島県 
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
60290  AG02000093 02  6207 54  78735  34300  なす  なす  徳島県 
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
60291  AG02000093 02  6207 54  78735  36700  にんにく  にんにく  徳島県 
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
60292  AG02000093 02  6207 54  78735  31900  ねぎ  ねぎ  徳島県 
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
60293  AG02000093 02  6207 54  78735  31800  ほうれん草  ほうれんそう  徳島県 
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
60294  AG02000093 02  6207 54  78735  33200  カリフラワー  かりふらわー  徳島県 
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
60295  AG02000093 02  6207 54  78735  90003  キヌサヤ  きぬさや  徳島県 
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

Page 333 of 15485, showing 20 records out of 309681 total, starting on record 6641, ending on 6660

(default) 2 queries took 1002 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 6640, 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 = 111965