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
52760  AG02000074 02  5494 52  1822  91000  加工品  かこうひん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791822  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52761  AG02000074 02  5494 52  1822  90001  野菜その他  やさいそのた  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791822  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52762  AG02000075 02  5495 52  1823  90001  野菜その他  やさいそのた  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791823  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52764  AG02000076 02  5496 52  1830  90001  野菜その他  やさいそのた  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791830  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52765  AG02000077 02  5497 52  1831  36100  さつま芋  さつまいも  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791831  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52766  AG02000077 02  5497 52  1831  30100  大根  だいこん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791831  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52767  AG02000077 02  5497 52  1831  31500  小松菜  こまつな  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791831  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52768  AG02000077 02  5497 52  1831  90001  野菜その他  やさいそのた  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791831  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52769  AG02000078 02  5498 52  1832  31800  ほうれん草  ほうれんそう  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791832  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52770  AG02000078 02  5498 52  1832  33420  グリーンリーフレタス  ぐりーんりーふれたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791832  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-04-18 16:04:33  AG02000078  View Edit Delete
52771  AG02000078 02  5498 52  1832  33410  サニーレタス  さにーれたす  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791832  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52772  AG02000078 02  5498 52  1832  31500  小松菜  こまつな  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791832  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52773  AG02000078 02  5498 52  1832  31310  水菜  みずな  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791832  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52774  AG02000078 02  5498 52  1832  90001  野菜その他  やさいそのた  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791832  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52783  AG02000080 02  5485 54  76988  30200  こかぶ  こかぶ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0276988  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52784  AG02000080 02  5485 54  76988  36200  じゃがいも  じゃがいも  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0276988  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52785  AG02000080 02  5485 54  76988  37300  とうがらし  とうがらし  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0276988  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52786  AG02000080 02  5485 54  76988  34200  カボチャ  かぼちゃ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0276988  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52787  AG02000080 02  5485 54  76988  36100  サツマイモ  さつまいも  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0276988  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52788  AG02000080 02  5485 54  76988  34270  ズッキーニ  ずっきーに  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
0276988  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete

Page 237 of 15485, showing 20 records out of 309681 total, starting on record 4721, ending on 4740

(default) 2 queries took 945 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 4720, 20202025
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 = 111920