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
57638  AG02000090 02  2649 51  192  36100  なると金時  なるときんとき  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372192  12  2018-04-20 00:00:00    2018-04-20 15:49:00  MG00000001  2018-04-20 15:49:00  MG00000001  View Edit Delete
57639  AG02000090 02  2610 51  112  34300  なすび  なすび  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372112  12  2018-04-20 00:00:00    2018-04-20 15:56:26  MG00000001  2018-04-20 15:56:26  MG00000001  View Edit Delete
57640  AG02000090 02  2667 51  252  43000  梨  なし  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372252  12  2018-04-20 00:00:00    2018-04-20 15:56:56  MG00000001  2018-04-20 15:56:56  MG00000001  View Edit Delete
57641  AG02000090 02  5247 51  211  45800  いちじく  いちじく  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372211  12  2018-04-20 00:00:00    2018-04-20 15:57:42  MG00000001  2018-04-20 15:57:42  MG00000001  View Edit Delete
57642  AG02000090 02  2622 51  138  36300  里芋  さといも  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372138  12  2018-04-20 00:00:00    2018-04-20 15:58:16  MG00000001  2018-04-20 15:58:16  MG00000001  View Edit Delete
57643  AG02000090 02  2604 51  104  36600  玉ねぎ  たまねぎ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372104  12  2018-04-20 00:00:00    2018-04-20 15:58:49  MG00000001  2018-04-20 15:58:49  MG00000001  View Edit Delete
57644  AG02000090 02  2650 51  193  30100  大根  だいこん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372193  12  2018-04-20 00:00:00    2018-04-20 15:59:56  MG00000001  2018-04-20 19:38:26  MG00000001  View Edit Delete
57645  AG02000090 02  2614 51  118  33400  レタス  れたす  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372118  12  2018-04-20 00:00:00    2018-04-20 16:00:36  MG00000001  2018-04-20 16:00:36  MG00000001  View Edit Delete
57646  AG02000090 02  2637 51  169  33300  ブロッコリー  ぶろっこりー  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372169  12  2018-04-20 00:00:00    2018-04-20 16:01:22  MG00000001  2018-04-20 16:01:22  MG00000001  View Edit Delete
57647  AG02000090 02  2626 51  149  31700  キャベツ  きゃべつ  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372149  12  2018-04-20 00:00:00    2018-04-20 16:02:00  MG00000001  2018-04-20 16:02:00  MG00000001  View Edit Delete
57648  AG02000090 02  2606 51  106  30300  人参  にんじん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26372106  12  2018-04-20 00:00:00    2018-04-20 16:03:17  MG00000001  2018-04-20 16:03:17  MG00000001  View Edit Delete
57650  AG02000091 02  2652 51  199  90001  野菜その他  やさいそのた  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26373199  12  2018-04-20 00:00:00    2018-04-20 19:05:39  MG00000001  2018-04-20 19:05:39  MG00000001  View Edit Delete
57651  AG02000091 02  2606 51  106  30300  人参  にんじん  101徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
26373106  12  2018-04-20 00:00:00    2018-04-20 19:06:11  MG00000001  2018-04-20 19:06:11  MG00000001  View Edit Delete
57658  AG02000089 02  6196 52  1849  36100  さつまいも  さつまいも  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791849  12  2018-04-20 00:00:00    2018-04-20 19:14:53  MG00000001  2018-04-20 19:14:53  MG00000001  View Edit Delete
57659  AG02000089 02  6196 52  1849  40100  みかん  みかん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791849  12  2018-04-20 00:00:00    2018-04-20 19:14:53  MG00000001  2018-04-20 19:14:53  MG00000001  View Edit Delete
57660  AG02000089 02  6196 52  1849  30300  人参  にんじん  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791849  12  2018-04-20 00:00:00    2018-04-20 19:14:53  MG00000001  2018-04-20 19:14:53  MG00000001  View Edit Delete
57661  AG02000089 02  6196 52  1849  90001  野菜その他  やさいそのた  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791849  12  2018-04-20 00:00:00    2018-04-20 19:14:53  MG00000001  2018-04-20 19:14:53  MG00000001  View Edit Delete
57662  AG02000090 02  6195 52  1850  45800  いちじく  いちじく  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791850  12  2018-04-20 00:00:00    2018-04-20 19:14:53  MG00000001  2018-04-20 19:14:53  MG00000001  View Edit Delete
57663  AG02000090 02  6195 52  1850  34800  オクラ  おくら  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791850  12  2018-04-20 00:00:00    2018-04-20 19:14:53  MG00000001  2018-04-20 19:33:57  MG00000001  View Edit Delete
57664  AG02000090 02  6195 52  1850  34200  かぼちゃ  かぼちゃ  徳島県 
Notice (8): Undefined index: farmer_edit_flg [APP/View/FarmerProducts/index.ctp, line 50]
 
2791850  12  2018-04-20 00:00:00    2018-04-20 19:14:53  MG00000001  2018-04-20 19:14:53  MG00000001  View Edit Delete

Page 317 of 15485, showing 20 records out of 309681 total, starting on record 6321, ending on 6340

(default) 2 queries took 1018 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 6320, 20202035
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 = 111983