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
8168  AG01000001 01  1925 009  12919  31700  キャベツ  きゃべつ  北海道 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0212919  12  2016-09-05 00:00:00    2016-09-05 11:53:09  AG01000001  2017-04-05 09:27:08  MG00000001  View Edit Delete
8169  AG01000001 01  1925 009  12919  46000  あまおう  あまおうー  北海道 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0212919  12  2016-09-05 00:00:00    2016-09-05 13:23:08  AG01000001  2016-09-05 13:24:17  AG01000001  View Edit Delete
8171  AG01000001 01  1925 009  12919  33100  アスパラ  あすぱら  北海道 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0212919  12  2016-09-12 00:00:00    2016-09-12 11:05:06  AG01000001  2017-04-05 09:27:41  MG00000001  View Edit Delete
8408  AG01001269 01  2448 006  7004  33300  ブロッコリー  ぶろっこりー  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217004  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-03-01 09:05:20  MG00000001  View Edit Delete
8411  AG01001739 01  2451 006  7007  31800  ほうれん草  ほうれんそう  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217007  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-03-01 18:01:21  MG00000001  View Edit Delete
8412  AG01001687 01  2452 006  7008  36100  さつま芋  さつまいも  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217008  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-03-08 11:17:19  MG00000001  View Edit Delete
8413  AG01001272 01  2453 006  7009  36100  さつま芋  さつまいも  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217009  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-03-02 14:15:00  MG00000001  View Edit Delete
8419  AG01001741 01  2459 006  7015  33300  ブロッコリー  ぶろっこりー  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217015  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-03-01 17:18:55  MG00000001  View Edit Delete
8421  AG01001278 01  2461 006  7017  31100  はくさい  はくさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217017  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-03-03 11:55:40  MG00000001  View Edit Delete
8422  AG01002709 01  2462 006  7018  31700  キャベツ  きゃべつ  徳島県阿波市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217018  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-05-08 11:00:22  MG00000001  View Edit Delete
8423  AG01001258 01  2463 006  7019  33950  芽キャベツ  めきゃべつ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217019  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-02-28 17:48:11  MG00000001  View Edit Delete
8424  AG01001307 01  2464 006  7020  30600  れんこん  れんこん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217020  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-03-02 14:55:04  MG00000001  View Edit Delete
8427  AG01001315 01  2467 006  7023  90001  野菜  やさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217023  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001    MG00000001  View Edit Delete
8428  AG01001305 01  2468 006  7024  31310  水菜  みずな  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217024  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-03-01 17:50:43  MG00000001  View Edit Delete
8429  AG01002724 01  2469 006  7025  36100  さつま芋  さつまいも  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217025  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-05-09 16:53:32  MG00000001  View Edit Delete
8430  AG01001888 01  2470 006  7026  31800  ほうれん草  ほうれんそう  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217026  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-03-01 17:30:49  MG00000001  View Edit Delete
8431  AG01001250 01  2471 006  7027  31800  ほうれん草  ほうれんそう  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217027  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-03-01 17:21:51  MG00000001  View Edit Delete
8438  AG01001720 01  2478 006  7034  90001  野菜  やさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217034  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001    MG00000001  View Edit Delete
8440  AG01001587 01  2480 006  7036  30300  人参  にんじん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217036  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-02-28 18:01:06  MG00000001  View Edit Delete
8442  AG01001874 01  2482 006  7038  31700  キャベツ  きゃべつ  徳島県阿波市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217038  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-05-08 10:54:24  MG00000001  View Edit Delete

Page 56 of 15485, showing 20 records out of 309681 total, starting on record 1101, ending on 1120

(default) 2 queries took 933 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 1100, 2020207
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 = 111926