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
104906  AG01000335 01  6527 004  343621  31700  キャベツ  きゃべつ  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104897  AG01000335 01  6527 004  343621  31800  ほうれん草  ほうれんそう  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104903  AG01000335 01  6527 004  343621  31900  白ねぎ  しろねぎ  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104904  AG01000335 01  6527 004  343621  31910  青ねぎ  あおねぎ  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104922  AG01000335 01  6527 004  343621  32300  ふき  ふき  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104930  AG01000335 01  6527 004  343621  32400  うど  うど  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104901  AG01000335 01  6527 004  343621  32600  菊菜  きくな  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104914  AG01000335 01  6527 004  343621  32800  ニラ  にら  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104910  AG01000335 01  6527 004  343621  33100  アスパラ  あすぱら  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104909  AG01000335 01  6527 004  343621  33200  カリフラワー  かりふらわー  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104908  AG01000335 01  6527 004  343621  33300  ブロッコリー  ぶろっこりー  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104911  AG01000335 01  6527 004  343621  33400  レタス  れたす  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104912  AG01000335 01  6527 004  343621  33410  サニーレタス  さにーれたす  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104913  AG01000335 01  6527 004  343621  33420  グリーンリーフ  ぐりーんりーふ  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104935  AG01000335 01  6527 004  343621  33600  パセリ  ぱせり  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104900  AG01000335 01  6527 004  343621  33810  チンゲン菜  ちんげんさい  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104933  AG01000335 01  6527 004  343621  33930  ずいき  ずいき  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104885  AG01000335 01  6527 004  343621  34100  きゅうり  きゅうり  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104886  AG01000335 01  6527 004  343621  34200  南瓜  かぼちゃ  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete
104891  AG01000335 01  6527 004  343621  34270  ズッキーニ  ずっきーに  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2343621  12  2019-02-18 00:00:00    2019-02-18 11:43:46  MG00000001  2019-02-18 11:47:15  MG00000001  View Edit Delete

Page 2 of 15485, showing 20 records out of 309681 total, starting on record 21, ending on 40

(default) 2 queries took 935 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`.`farmer_id` asc LIMIT 20, 2020201
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 = 111934