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
45644  AG01003277 01  5097 011  60604  38100  原木生椎茸  げんぼくなましいたけ  熊本県山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2760604  12  2018-01-23 00:00:00    2018-01-23 11:54:59  AG01003277  2018-01-23 11:54:59  AG01003277  View Edit Delete
45649  AG01003304 01  5131 011  60712  31100  白菜  はくさい  熊本県山都町 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2760712  12  2018-01-23 00:00:00    2018-01-23 16:42:09  AG01003304  2018-01-23 16:42:09  AG01003304  View Edit Delete
46320  AG01003324 01  1418 007  6009  31910  青ねぎタブレット  あおねぎたぶれっと  和歌山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
246009  12  2018-01-24 00:00:00    2018-01-24 16:50:35  AG01003324  2018-01-24 16:50:35  AG01003324  View Edit Delete
46321  AG01003324 01  1418 007  6009  31910  あおねぎ管理  あおねぎ  和歌山県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
246009      2018-01-24 00:00:00    2018-01-24 16:52:03  MG00000001  2018-01-24 16:52:03  MG00000001  View Edit Delete
46324  AG01003019 01  5237 007  6381  90001  野菜  やさい  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
246381  12  2018-01-25 00:00:00    2018-01-25 13:55:39  AG01003019  2018-01-25 13:55:39  AG01003019  View Edit Delete
46325  AG01003019 01  5238 007  6382  33400  フリルレタス  ふりるれたす  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
246382  12  2018-01-25 00:00:00    2018-01-25 13:57:00  AG01003019  2018-03-12 13:28:05  AG01003019  View Edit Delete
46326  AG01003019 01  5239 007  6383  33420  グリーンリーフ  ぐりーんりーふ  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
246383  12  2018-01-25 00:00:00    2018-01-25 13:57:34  AG01003019  2018-03-12 13:26:59  AG01003019  View Edit Delete
46327  AG01003019 01  5240 007  6384  33400  ミヤコレタス  みやこれたす  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
246384  12  2018-01-25 00:00:00    2018-01-25 13:59:20  AG01003019  2018-01-25 13:59:20  AG01003019  View Edit Delete
46328  AG01003019 01  5241 007  6385  31500  こまつ菜  こまつな  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
246385  12  2018-01-25 00:00:00    2018-01-25 14:00:07  AG01003019  2018-01-25 14:08:51  AG01003019  View Edit Delete
46329  AG01003019 01  5242 007  6386  31310  ミズナ  みずな  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
246386  12  2018-01-25 00:00:00    2018-01-25 14:00:50  AG01003019  2018-01-25 14:09:03  AG01003019  View Edit Delete
46330  AG01003019 01  5243 007  6387  33710  パクチー(香菜)  ぱくちーこうさい  京都府 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
246387  12  2018-01-25 00:00:00    2018-01-25 14:01:14  AG01003019  2018-01-25 14:13:04  AG01003019  View Edit Delete
50310  AG02000069 02  2608 51  108  31900  ねぎ  ねぎ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26280108      2018-01-29 00:00:00    2018-01-29 11:10:06  MG00000001  2018-01-29 11:10:06  MG00000001  View Edit Delete
50311  AG02000069 02  2614 51  118  33400  レタス  れたす  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26280118      2018-01-29 00:00:00    2018-01-29 11:10:38  MG00000001  2018-01-29 11:10:38  MG00000001  View Edit Delete
50312  AG02000069 02  2628 51  151  33410  サニーレタス  さにーれたす  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26280151      2018-01-29 00:00:00    2018-01-29 11:11:12  MG00000001  2018-01-29 11:11:12  MG00000001  View Edit Delete
50313  AG02000069 02  2630 51  154  31800  ほうれん草  ほうれんそう  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26280154      2018-01-29 00:00:00    2018-01-29 11:12:06  MG00000001  2018-01-29 11:12:06  MG00000001  View Edit Delete
50314  AG02000069 02  2637 51  169  33300  ブロッコリー  ぶろっこりー  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26280169      2018-01-29 00:00:00    2018-01-29 11:12:29  MG00000001  2018-01-29 11:12:29  MG00000001  View Edit Delete
50316  AG02000069 02  2652 51  199  90001  野菜その他  やさいそのた  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26280199      2018-01-29 00:00:00    2018-01-29 11:13:42  MG00000001  2018-01-29 11:13:42  MG00000001  View Edit Delete
50317  AG02000070 02  2638 51  170  33200  カリフラワー  かりふらわー  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26281170      2018-01-29 00:00:00    2018-01-29 11:14:29  MG00000001  2018-01-29 11:14:29  MG00000001  View Edit Delete
50318  AG02000070 02  2647 51  188  34270  ズッキーニ  ずっきーに  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26281188      2018-01-29 00:00:00    2018-01-29 11:15:02  MG00000001  2018-01-29 11:15:02  MG00000001  View Edit Delete
50320  AG02000070 02  2652 51  199  90001  野菜その他  やさいそのた  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26281199      2018-01-29 00:00:00    2018-01-29 11:15:49  MG00000001  2018-01-29 11:15:49  MG00000001  View Edit Delete

Page 131 of 15485, showing 20 records out of 309681 total, starting on record 2601, ending on 2620

(default) 2 queries took 940 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 2600, 20202015
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 = 111925