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
60190  AG01003271 01  5093 011  60600  33400  レタス  れたす  熊本県山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2760600  12  2018-05-15 00:00:00    2018-05-15 08:02:43  AG01003271  2018-05-15 08:02:43  AG01003271  View Edit Delete
60198  AG02000012 02  2634 51  162  35400  そらまめ  そらまめ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26577162  12  2018-05-15 00:00:00    2018-05-15 10:18:36  MG00000001  2018-05-15 10:18:36  MG00000001  View Edit Delete
60199  AG02000012 02  5248 51  524  35200  えんどう豆  えんどうまめ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26577524  12  2018-05-15 00:00:00    2018-05-15 10:19:11  MG00000001  2018-05-15 10:19:11  MG00000001  View Edit Delete
60200  AG02000018 02  2614 51  118  33400  レタス  れたす  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26583118  12  2018-05-15 00:00:00    2018-05-15 10:20:03  MG00000001  2018-05-15 10:20:03  MG00000001  View Edit Delete
60202  AG02000019 02  5248 51  524  35200  えんどう豆  えんどうまめ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26584524  12  2018-05-15 00:00:00    2018-05-15 10:23:00  MG00000001  2018-05-15 10:23:00  MG00000001  View Edit Delete
60203  AG02000032 02  2614 51  118  33400  レタス  れたす  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26599118  12  2018-05-15 00:00:00    2018-05-15 10:23:46  MG00000001  2018-05-15 10:24:12  MG00000001  View Edit Delete
60204  AG02000032 02  2604 51  104  36600  玉ねぎ  たまねぎ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26599104  12  2018-05-15 00:00:00    2018-05-15 10:24:34  MG00000001  2018-05-15 10:24:34  MG00000001  View Edit Delete
60205  AG02000060 02  4068 51  526  33420  リーフレタス  りーふれたす  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26944526  12  2018-05-15 00:00:00    2018-05-15 10:25:36  MG00000001  2018-05-15 10:25:36  MG00000001  View Edit Delete
60206  AG02000060 02  2628 51  151  33410  サニーレタス  さにーれたす  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26944151  12  2018-05-15 00:00:00    2018-05-15 10:29:27  MG00000001  2018-05-15 10:29:27  MG00000001  View Edit Delete
60207  AG02000088 02  6205 51  537  33600  イタリアンパセリ  いたりあんぱせり  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26370537  12  2018-05-15 00:00:00    2018-05-15 10:33:00  MG00000001  2018-05-15 10:33:00  MG00000001  View Edit Delete
60208  AG02000088 02  6197 54  78662  33600  イタリアンパセリ  いたりあんぱせり  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278662  12  2018-05-15 00:00:00    2018-05-15 10:42:07  MG00000001  2018-05-15 10:42:07  MG00000001  View Edit Delete
60209  AG02000060 02  5356 54  77216  33410  サニーレタス  さにーれたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0277216  12  2018-05-15 00:00:00    2018-05-15 10:42:17  MG00000001  2018-05-15 10:42:17  MG00000001  View Edit Delete
60210  AG02000060 02  5356 54  77216  33420  リーフレタス  りーふれたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0277216  12  2018-05-15 00:00:00    2018-05-15 10:42:17  MG00000001  2018-05-15 10:42:17  MG00000001  View Edit Delete
60212  AG02000032 02  5335 54  77992  33400  レタス  れたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0277992  12  2018-05-15 00:00:00    2018-05-15 10:42:26  MG00000001  2018-05-15 10:42:26  MG00000001  View Edit Delete
60213  AG02000032 02  5335 54  77992  36600  玉ねぎ  たまねぎ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0277992  12  2018-05-15 00:00:00    2018-05-15 10:42:26  MG00000001  2018-05-15 10:42:26  MG00000001  View Edit Delete
60215  AG02000019 02  5352 54  77119  35200  えんどう豆  えんどうまめ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0277119  12  2018-05-15 00:00:00    2018-05-15 10:42:31  MG00000001  2018-05-15 10:42:31  MG00000001  View Edit Delete
60216  AG02000018 02  5323 54  77801  33400  レタス  れたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0277801  12  2018-05-15 00:00:00    2018-05-15 10:42:34  MG00000001  2018-05-15 10:42:34  MG00000001  View Edit Delete
60217  AG02000012 02  5328 54  77917  35200  えんどう豆  えんどうまめ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0277917  12  2018-05-15 00:00:00    2018-05-15 10:42:38  MG00000001  2018-05-15 10:42:38  MG00000001  View Edit Delete
60218  AG02000012 02  5328 54  77917  35400  そらまめ  そらまめ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0277917  12  2018-05-15 00:00:00    2018-05-15 10:42:38  MG00000001  2018-05-15 10:42:38  MG00000001  View Edit Delete
60220  AG02000088 02  6186 52  1845  33600  イタリアンパセリ  いたりあんぱせり  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791845  12  2018-05-15 00:00:00    2018-05-15 10:43:02  MG00000001  2018-05-15 10:43:02  MG00000001  View Edit Delete

Page 330 of 15485, showing 20 records out of 309681 total, starting on record 6581, ending on 6600

(default) 2 queries took 1011 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 6580, 20202038
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 = 111973