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
60221  AG02000060 02  5308 52  1762  33410  サニーレタス  さにーれたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791762  12  2018-05-15 00:00:00    2018-05-15 10:43:06  MG00000001  2018-05-15 10:43:06  MG00000001  View Edit Delete
60222  AG02000060 02  5308 52  1762  33420  リーフレタス  りーふれたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791762  12  2018-05-15 00:00:00    2018-05-15 10:43:06  MG00000001  2018-05-15 10:43:06  MG00000001  View Edit Delete
60224  AG02000032 02  5281 52  1686  33400  レタス  れたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791686  12  2018-05-15 00:00:00    2018-05-15 10:43:09  MG00000001  2018-05-15 10:43:09  MG00000001  View Edit Delete
60225  AG02000032 02  5281 52  1686  36600  玉ねぎ  たまねぎ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791686  12  2018-05-15 00:00:00    2018-05-15 10:43:09  MG00000001  2018-05-15 10:43:09  MG00000001  View Edit Delete
60227  AG02000019 02  5268 52  1673  35200  えんどう豆  えんどうまめ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791673  12  2018-05-15 00:00:00    2018-05-15 10:43:13  MG00000001  2018-05-15 10:43:13  MG00000001  View Edit Delete
60228  AG02000018 02  5267 52  1672  33400  レタス  れたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791672  12  2018-05-15 00:00:00    2018-05-15 10:43:15  MG00000001  2018-05-15 10:43:15  MG00000001  View Edit Delete
60229  AG02000012 02  5261 52  1666  35200  えんどう豆  えんどうまめ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791666  12  2018-05-15 00:00:00    2018-05-15 10:43:20  MG00000001  2018-05-15 10:43:20  MG00000001  View Edit Delete
60230  AG02000012 02  5261 52  1666  35400  そらまめ  そらまめ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791666  12  2018-05-15 00:00:00    2018-05-15 10:43:20  MG00000001  2018-05-15 10:43:20  MG00000001  View Edit Delete
60239  AG02000094 02  2652 51  199  90001  野菜その他  やさいそのた  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26377199  12  2018-05-16 00:00:00    2018-05-16 10:51:27  MG00000001  2018-05-16 10:51:27  MG00000001  View Edit Delete
60240  AG02000094 02  2647 51  188  34270  ズッキーニ  ずっきーに  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26377188  12  2018-05-16 00:00:00    2018-05-16 10:51:57  MG00000001  2018-05-16 10:51:57  MG00000001  View Edit Delete
60241  AG02000094 02  2615 51  119  34500  ピーマン  ぴーまん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26377119  12  2018-05-16 00:00:00    2018-05-16 10:52:23  MG00000001  2018-05-16 10:52:23  MG00000001  View Edit Delete
60242  AG02000094 02  2616 51  120  34800  おくら  おくら  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26377120  12  2018-05-16 00:00:00    2018-05-16 10:52:57  MG00000001  2018-05-16 10:52:57  MG00000001  View Edit Delete
60243  AG02000094 02  2607 51  107  34100  きゅうり  きゅうり  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26377107  12  2018-05-16 00:00:00    2018-05-16 10:53:26  MG00000001  2018-05-16 10:53:26  MG00000001  View Edit Delete
60244  AG02000094 02  2712 51  935  90003  サンド豆  さんどまめ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26377935  12  2018-05-16 00:00:00    2018-05-16 10:54:20  MG00000001  2018-05-16 10:54:20  MG00000001  View Edit Delete
60245  AG02000094 02  6209 51  731  90003  モロッコ豆  もろっこまめ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26377731  12  2018-05-16 00:00:00    2018-05-16 10:56:50  MG00000001  2018-05-16 10:56:50  MG00000001  View Edit Delete
60246  AG02000094 02  2608 51  108  31900  ねぎ  ねぎ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26377108  12  2018-05-16 00:00:00    2018-05-16 10:57:23  MG00000001  2018-05-16 10:57:23  MG00000001  View Edit Delete
60247  AG02000094 02  2645 51  184  33920  菜花  なのはな  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26377184  12  2018-05-16 00:00:00    2018-05-16 10:58:32  MG00000001  2018-05-16 10:58:32  MG00000001  View Edit Delete
60248  AG02000094 02  2631 51  158  33810  チンゲン菜  ちんげんさい  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26377158  12  2018-05-16 00:00:00    2018-05-16 10:58:59  MG00000001  2018-05-16 10:58:59  MG00000001  View Edit Delete
60249  AG02000094 02  2629 51  152  32800  ニラ  にら  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26377152  12  2018-05-16 00:00:00    2018-05-16 10:59:30  MG00000001  2018-05-16 10:59:30  MG00000001  View Edit Delete
60250  AG02000094 02  6208 54  78743  34800  おくら  おくら  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0278743  12  2018-05-16 00:00:00    2018-05-16 11:00:14  MG00000001  2018-05-16 11:00:14  MG00000001  View Edit Delete

Page 331 of 15485, showing 20 records out of 309681 total, starting on record 6601, ending on 6620

(default) 2 queries took 1059 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 6600, 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 = 1111019