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
8490  AG01001287 01  2530 006  7086  33920  菜の花  なのはな  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217086  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-03-02 09:05:28  MG00000001  View Edit Delete
8491  AG01002728 01  2531 006  7087  90001  野菜  やさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217087  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001    MG00000001  View Edit Delete
8500  AG01001890 01  2540 006  7096  30600  れんこん  れんこん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217096  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-05-09 17:25:22  MG00000001  View Edit Delete
8504  AG01001905 01  2544 006  7100  90001  野菜  やさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217100  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001    MG00000001  View Edit Delete
8505  AG01001848 01  2545 006  7101  90001  野菜  やさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217101  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001    MG00000001  View Edit Delete
8506  AG01001910 01  2546 006  7102  38700  わらび  わらび  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217102  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-04-14 14:41:53  MG00000001  View Edit Delete
8507  AG01001723 01  2547 006  7103  90001  野菜  やさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217103  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001    MG00000001  View Edit Delete
8508  AG01002725 01  2548 006  7104  90001  野菜  やさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217104  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001    MG00000001  View Edit Delete
8509  AG01001870 01  2549 006  7105  31800  ほうれん草  ほうれんそう  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217105  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-03-02 14:26:33  MG00000001  View Edit Delete
8513  AG01001281 01  2553 006  7109  90001  野菜  やさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217109  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001    MG00000001  View Edit Delete
8515  AG01001561 01  2555 006  7111  90001  野菜  やさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217111  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001    MG00000001  View Edit Delete
8537  AG01001294 01  2577 006  7133  90001  野菜  やさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217133  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001    MG00000001  View Edit Delete
8554  AG01001775 01  2594 006  7150  90001  野菜  やさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217150  12  2017-02-27 00:00:00    2017-02-24 00:00:00  MG00000001  2017-07-07 09:57:57  MG00000001  View Edit Delete
8562  AG01001269 01  2448 006  7004  30100  大根  だいこん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217004      2017-02-24 00:00:00    2017-02-24 18:41:00  MG00000001  2017-02-24 18:42:06  AG01001269  View Edit Delete
8563  AG01001269 01  2448 006  7004  90001  野菜  やさい  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217004      2017-02-24 00:00:00    2017-02-24 18:42:52  MG00000001  2017-03-27 10:51:27  MG00000001  View Edit Delete
8564  AG01001569 01  2454 006  7010  31100  はくさい  はくさい  徳島県阿波市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217010      2017-02-28 00:00:00    2017-02-24 18:51:46  MG00000001  2017-02-24 18:52:59  MG00000001  View Edit Delete
8565  AG01001569 01  2454 006  7010  31700  キャベツ  きゃべつ  徳島県阿波市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217010      2017-02-28 00:00:00    2017-02-24 18:53:47  MG00000001  2017-02-24 18:53:47  MG00000001  View Edit Delete
8566  AG01001569 01  2454 006  7010  31800  ほうれん草  ほうれんそう  徳島県阿波市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217010      2017-02-28 00:00:00    2017-02-24 18:54:28  MG00000001  2017-02-24 18:54:28  MG00000001  View Edit Delete
8567  AG01001569 01  2454 006  7010  33200  カリフラワー  かりふらわー  徳島県阿波市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217010      2017-02-28 00:00:00    2017-02-24 18:55:01  MG00000001  2017-02-24 18:55:01  MG00000001  View Edit Delete
8568  AG01001569 01  2454 006  7010  33300  ブロッコリー  ぶろっこりー  徳島県阿波市 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0217010      2017-02-28 00:00:00    2017-02-24 18:55:38  MG00000001  2017-02-24 18:55:38  MG00000001  View Edit Delete

Page 58 of 15485, showing 20 records out of 309681 total, starting on record 1141, ending on 1160

(default) 2 queries took 1039 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 1140, 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 = 1111032