Farmers

User Agreement Start Day Agreement End Day Plan Code Agreement Amount Rental Printer Sn Rental Tablet Sn Rental Tablet Tel Rental Tablet Gmail Label Flg Seal Flg Blog Flg Log Save Number User Post Number User Address User Tel Qr Url Notification File Plain Password Created Insert User Modified Update User Actions
AG01004850  2022-07-08                              2022-07-08 13:12:32  MG00000001  2022-07-14 11:10:11  AG01004850  View Edit Delete
AG01004854  2022-07-08                              2022-07-08 13:36:45  MG00000001  2022-07-14 10:43:30  AG01004854  View Edit Delete
AG01004853  2022-07-08                              2022-07-08 13:32:52  MG00000001  2022-07-14 10:36:43  AG01004853  View Edit Delete
AG01004857  2022-07-08                              2022-07-08 13:54:08  MG00000001  2022-07-14 10:10:35  AG01004857  View Edit Delete
AG01004315  2021-01-27                              2021-01-27 09:23:37  MG00000005  2022-07-13 17:11:40  AG01004315  View Edit Delete
AG01004489  2021-04-09                              2021-04-09 16:12:31  MG00000005  2022-07-12 08:48:21  AG01004489  View Edit Delete
AG04000068  2022-06-23                              2022-06-23 11:08:20  MG00000001  2022-07-11 13:30:18  AG04000068  View Edit Delete
AG01003984  2020-01-17                              2020-01-17 10:38:58  MG00000003  2022-07-11 13:16:48  AG01003984  View Edit Delete
AG01004286  2021-01-21                              2021-01-21 13:04:13  MG00000005  2022-07-11 13:16:07  AG01004286  View Edit Delete
AG01004349  2021-03-08                              2021-03-08 18:51:56  MG00000005  2022-07-11 07:47:13  AG01004349  View Edit Delete
AG01004118  2020-09-03                              2020-09-03 16:31:59  MG00000005  2022-07-08 17:19:01  AG01004118  View Edit Delete
AG01004501  2021-04-19                              2021-04-19 17:48:27  MG00000005  2022-07-08 15:01:43  AG01004501  View Edit Delete
AG04000059  2022-06-23                              2022-06-23 11:08:20  MG00000001  2022-07-08 13:38:53  AG04000059  View Edit Delete
AG04000076  2022-06-23                              2022-06-23 11:08:20  MG00000001  2022-07-06 13:15:03  AG04000076  View Edit Delete
AG04000055  2022-06-23                              2022-06-23 11:08:20  MG00000001  2022-07-04 14:02:08  AG04000055  View Edit Delete
AG01004600  2021-11-29                              2021-11-29 09:05:59  MG00000001  2022-07-04 10:26:48  AG01004600  View Edit Delete
AG04000118  2022-06-23                              2022-06-23 11:08:20  MG00000001  2022-07-02 11:20:14  AG04000118  View Edit Delete
AG04000029  2022-06-23                              2022-06-23 11:08:20  MG00000001  2022-07-01 18:25:48  AG04000029  View Edit Delete
AG04000043  2022-06-23                              2022-06-23 11:08:20  MG00000001  2022-07-01 15:53:19  AG04000043  View Edit Delete
AG04000037  2022-06-23                              2022-06-23 11:08:20  MG00000001  2022-07-01 14:43:38  AG04000037  View Edit Delete

Page 100 of 250, showing 20 records out of 5000 total, starting on record 1981, ending on 2000

(default) 2 queries took 22 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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`, `ContractPlan`.`plan_code`, `ContractPlan`.`plan_nm`, `ContractPlan`.`contract_months`, `ContractPlan`.`agreement_amount`, `ContractPlan`.`created`, `ContractPlan`.`insert_user`, `ContractPlan`.`modified`, `ContractPlan`.`update_user`, `User`.`id`, `User`.`login_id`, `User`.`user_nm`, `User`.`user_fk`, `User`.`user_type`, `User`.`password`, `User`.`mail_address_1`, `User`.`mail_address_2`, `User`.`login_rock_flg`, `User`.`last_login_day`, `User`.`use_start_day`, `User`.`use_end_day`, `User`.`del_flg`, `User`.`init_pass_flg`, `User`.`created`, `User`.`insert_user`, `User`.`modified`, `User`.`update_user` FROM `sato_agri`.`farmers` AS `Farmer` LEFT JOIN `sato_agri`.`contract_plan` AS `ContractPlan` ON (`Farmer`.`plan_code` = `ContractPlan`.`plan_code`) LEFT JOIN `sato_agri`.`users` AS `User` ON (`User`.`id` = `Farmer`.`user_id`) WHERE 1 = 1 ORDER BY `Farmer`.`modified` desc LIMIT 1980, 20202012
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`farmers` AS `Farmer` LEFT JOIN `sato_agri`.`contract_plan` AS `ContractPlan` ON (`Farmer`.`plan_code` = `ContractPlan`.`plan_code`) LEFT JOIN `sato_agri`.`users` AS `User` ON (`User`.`id` = `Farmer`.`user_id`) WHERE 1 = 11110