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
57591  AG02000088 02  6186 52  1845  30100  大根  だいこん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791845  12  2018-04-18 00:00:00    2018-04-18 12:17:30  MG00000001  2018-04-18 12:17:30  MG00000001  View Edit Delete
57592  AG02000088 02  6186 52  1845  31100  白菜  はくさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791845  12  2018-04-18 00:00:00    2018-04-18 12:17:30  MG00000001  2018-04-18 12:17:30  MG00000001  View Edit Delete
57593  AG02000088 02  6186 52  1845  90001  野菜(その他)  やさいそのた  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791845  12  2018-04-18 00:00:00    2018-04-18 12:17:30  MG00000001  2021-11-10 16:33:31  MG00000001  View Edit Delete
57597  AG02000086 02  6153 52  1843  36100  さつまいも  さつまいも  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791843  12  2018-04-18 00:00:00    2018-04-18 12:20:57  MG00000001  2018-04-18 12:20:57  MG00000001  View Edit Delete
57598  AG02000086 02  6153 52  1843  33200  カリフラワー  かりふらわー  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791843  12  2018-04-18 00:00:00    2018-04-18 12:20:57  MG00000001  2018-04-18 12:20:57  MG00000001  View Edit Delete
57599  AG02000086 02  6153 52  1843  90001  ビーツ  びーつ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791843  12  2018-04-18 00:00:00    2018-04-18 12:20:57  MG00000001  2018-04-18 12:20:57  MG00000001  View Edit Delete
57604  AG02000028 02  5277 52  1682  31800  ほうれん草  ほうれんそう  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791682  12  2018-04-18 00:00:00    2018-04-18 13:01:26  MG00000001  2018-04-18 13:01:26  MG00000001  View Edit Delete
57605  AG02000028 02  6155 54  78522  31800  ほうれん草  ほうれんそう  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278522  12  2018-04-18 00:00:00    2018-04-18 13:02:01  MG00000001  2018-04-18 13:02:01  MG00000001  View Edit Delete
57618  AG01003303 01  5110 011  60617  33100  アスパラガス  あすぱらがす  熊本県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2760617  12  2018-04-19 00:00:00    2018-04-19 20:32:07  AG01003303  2018-04-19 20:32:07  AG01003303  View Edit Delete
57624  AG02000053 02  2613 51  117  35500  枝豆  えだまめ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26936117  12  2018-04-20 00:00:00    2018-04-20 13:41:07  MG00000001  2018-04-20 13:41:07  MG00000001  View Edit Delete
57627  AG02000090 02  2652 51  199  90001  野菜その他  やさいそのた  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372199  12  2018-04-20 00:00:00    2018-04-20 15:33:06  MG00000001  2018-04-20 15:33:06  MG00000001  View Edit Delete
57628  AG02000090 02  2619 51  129  31500  小松菜  こまつな  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372129  12  2018-04-20 00:00:00    2018-04-20 15:33:29  MG00000001  2018-04-20 15:33:29  MG00000001  View Edit Delete
57629  AG02000090 02  2618 51  128  31310  水菜  みずな  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372128  12  2018-04-20 00:00:00    2018-04-20 15:34:10  MG00000001  2018-04-20 15:34:10  MG00000001  View Edit Delete
57630  AG02000090 02  2630 51  154  31800  ほうれん草  ほうれんそう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372154  12  2018-04-20 00:00:00    2018-04-20 15:34:34  MG00000001  2018-04-20 15:34:34  MG00000001  View Edit Delete
57631  AG02000090 02  2605 51  105  36200  じゃがいも  じゃがいも  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372105  12  2018-04-20 00:00:00    2018-04-20 15:37:16  MG00000001  2018-04-20 15:37:16  MG00000001  View Edit Delete
57633  AG02000090 02  2611 51  114  34200  かぼちゃ  かぼちゃ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372114  12  2018-04-20 00:00:00    2018-04-20 15:41:42  MG00000001  2018-04-20 15:41:42  MG00000001  View Edit Delete
57634  AG02000090 02  2616 51  120  34800  オクラ  おくら  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372120  12  2018-04-20 00:00:00    2018-04-20 15:42:19  MG00000001  2018-04-20 19:33:45  MG00000001  View Edit Delete
57635  AG02000090 02  2615 51  119  34500  ピーマン  ぴーまん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372119  12  2018-04-20 00:00:00    2018-04-20 15:42:48  MG00000001  2018-04-20 15:42:48  MG00000001  View Edit Delete
57636  AG02000090 02  2608 51  108  31910  青ネギ  あおねぎ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372108  12  2018-04-20 00:00:00    2018-04-20 15:44:18  MG00000001  2018-04-20 15:44:18  MG00000001  View Edit Delete
57637  AG02000090 02  2607 51  107  34100  きゅうり  きゅうり  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372107  12  2018-04-20 00:00:00    2018-04-20 15:44:51  MG00000001  2018-04-20 15:44:51  MG00000001  View Edit Delete

Page 316 of 15485, showing 20 records out of 309681 total, starting on record 6301, ending on 6320

(default) 2 queries took 937 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 6300, 20202032
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 = 111905