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
11023  AG02000028 02  2652 51  199  90001  野菜(その他)  やさいそのた  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26594199  12  2017-07-11 00:00:00      MG00000001    MG00000000  View Edit Delete
11034  AG02000001 02  2618 51  128  31310  水菜  みずな  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26565128  12  2017-07-18 00:00:00      MG00000001    MG00000000  View Edit Delete
11035  AG02000016 02  2684 51  567  90002  つるむらさき  つるむらさき  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26581567  12  2017-07-18 00:00:00      MG00000001    MG00000000  View Edit Delete
11036  AG02000016 02  2711 51  897  90002  葉物  はもの  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26581897  12  2017-07-18 00:00:00      MG00000001    MG00000000  View Edit Delete
11037  AG02000018 02  2611 51  114  34200  かぼちゃ  かぼちゃ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26583114  12  2017-07-19 00:00:00      MG00000001    MG00000000  View Edit Delete
11052  AG02000016 02  2635 51  167  34460  ミニトマト  みにとまと  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26581167  12  2017-07-21 00:00:00      MG00000001    MG00000000  View Edit Delete
11053  AG02000016 02  2652 51  199  90001  野菜(その他)  やさいそのた  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26581199  12  2017-07-21 00:00:00      MG00000001    MG00000000  View Edit Delete
11058  AG02000006 02  2616 51  120  34800  オクラ  おくら  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26571120  12  2017-07-25 00:00:00      MG00000001    MG00000000  View Edit Delete
11067  AG01000683 01  1027 003  85  90001  野菜  やさい  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17540885      2017-07-27 00:00:00    2017-07-27 15:06:40  MG00000001  2017-08-01 14:12:11  MG00000001  View Edit Delete
11068  AG01000683 01  1028 003  86  90007  果物  くだもの  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17540886  12  2017-07-27 00:00:00      MG00000001    MG00000000  View Edit Delete
11069  AG01000683 01  4039 003  76  48000  すいか  すいか  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17540876  12  2017-07-27 00:00:00      MG00000001    MG00000000  View Edit Delete
11076  AG01000693 01  6441 004  398720  90001  野菜  やさい  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2398720  12  2017-07-28 00:00:00    2017-07-28 10:07:11  AG01000693  2017-08-01 14:32:25  MG00000001  View Edit Delete
11092  AG01000611 01  1029 003  91  91000  加工品  かこうひん  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17518891  12  2017-07-28 00:00:00      MG00000001    MG00000000  View Edit Delete
11093  AG01000611 01  1029 003  91  91000  加工品  かこうひん  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17527091  12  2017-07-28 00:00:00      MG00000001    MG00000000  View Edit Delete
11094  AG01000611 01  1029 003  91  91000  こんにゃく  こんにゃく  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17570891  12  2017-07-28 00:00:00      MG00000001    MG00000000  View Edit Delete
11095  AG01000611 01  4056 003  96  91000  サワー漬け  さわーづけ  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17535396  12  2017-07-28 00:00:00      MG00000001    MG00000000  View Edit Delete
11096  AG01000611 01  4057 003  97  91007  五條よもぎ餅  ごじょうよもぎもち  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17535697  12  2017-07-28 00:00:00      MG00000001    MG00000000  View Edit Delete
11097  AG01000611 01  1029 003  91  91000  山椒味噌  さんしょうみそ  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17570991  12  2017-07-28 00:00:00      MG00000001    MG00000000  View Edit Delete
11098  AG01000611 01  1029 003  91  91000  生姜みそ  しょうがみそ  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17570691  12  2017-07-28 00:00:00      MG00000001    MG00000000  View Edit Delete
11099  AG01000611 01  1029 003  91  91000  柚子味噌  ゆずみそ  奈良 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
17571091  12  2017-07-28 00:00:00      MG00000001    MG00000000  View Edit Delete

Page 93 of 15485, showing 20 records out of 309681 total, starting on record 1841, ending on 1860

(default) 2 queries took 934 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 1840, 20202011
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 = 111923