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
52738  AG02000072 02  5492 52  1820  34100  きゅうり  きゅうり  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52739  AG02000072 02  5492 52  1820  36200  じゃがいも  じゃがいも  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52740  AG02000072 02  5492 52  1820  39330  すだち  すだち  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52741  AG02000072 02  5492 52  1820  38900  たらの芽  たらのめ  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52742  AG02000072 02  5492 52  1820  39310  ゆず  ゆず  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52743  AG02000072 02  5492 52  1820  45800  イチジク  いちじく  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52744  AG02000072 02  5492 52  1820  35100  インゲン  いんげん  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52745  AG02000072 02  5492 52  1820  35200  エンドウ豆  えんどうまめ  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52746  AG02000072 02  5492 52  1820  34800  オクラ  おくら  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52747  AG02000072 02  5492 52  1820  34200  カボチャ  かぼちゃ  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52748  AG02000072 02  5492 52  1820  35200  スナップエンドウ  すなっぷえんどう  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52749  AG02000072 02  5492 52  1820  34400  トマト  とまと  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52750  AG02000072 02  5492 52  1820  31900  ネギ  ねぎ  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52751  AG02000072 02  5492 52  1820  30100  大根  だいこん  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52752  AG02000072 02  5492 52  1820  31500  小松菜  こまつな  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52753  AG02000072 02  5492 52  1820  35500  枝豆  えだまめ  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52754  AG02000072 02  5492 52  1820  43500  柿  かき  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52755  AG02000072 02  5492 52  1820  35400  空豆  そらまめ  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52756  AG02000072 02  5492 52  1820  33920  菜花  なはな  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  12  2018-03-05 00:00:00    2018-03-05 19:06:03  MG00000001  2018-03-05 19:06:03  MG00000001  View Edit Delete
52757  AG02000072 02  5492 52  1820  90001  野菜その他  やさいそのた  徳島市国府町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791820  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 236 of 15485, showing 20 records out of 309681 total, starting on record 4701, ending on 4720

(default) 2 queries took 1001 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 4700, 20202026
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 = 111975