Users

Id Login User Nm User Fk User Type Password Mail Address 1 Mail Address 2 Login Rock Flg Last Login Day Use Start Day Use End Day Del Flg Init Pass Flg Created Insert User Modified Update User Actions
AG01004383  01004383  T(直)岡野龍  おかのりゅう  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-09-03 13:18:06  2021-03-10 00:00:00    2021-03-10 10:43:39  MG00000005  2021-03-10 10:43:39  MG00000005  View Edit Delete
AG01004384  01004384  T(直)橋本憲佐  はしもとけんすけ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-07 09:29:38  2021-03-10 00:00:00    2021-03-10 11:00:13  MG00000005  2021-03-10 11:00:13  MG00000005  View Edit Delete
AG01004385  01004385  T(直)藤原農園  ふじわらのうえん  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 13:54:10  2021-03-10 00:00:00    2021-03-10 11:04:39  MG00000005  2021-03-10 11:04:39  MG00000005  View Edit Delete
AG01004386  01004386  T(直)石田ファーム  いしだふぁーむ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 08:51:43  2021-03-10 00:00:00    2021-03-10 11:44:02  MG00000005  2021-03-10 11:44:02  MG00000005  View Edit Delete
AG01004387  01004387  T(直)國安礼子  くにやすれいこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2022-12-02 11:06:37  2021-03-10 00:00:00    2021-03-10 11:58:02  MG00000005  2021-03-10 11:58:02  MG00000005  View Edit Delete
AG01004388  01004388  T(直)武田農園  たけだのうえん  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-23 20:27:08  2021-03-10 00:00:00    2021-03-10 13:01:57  MG00000005  2021-03-10 13:01:57  MG00000005  View Edit Delete
AG01004389  01004389  T(直)山岡昌治  やまおかしょうじ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 06:26:41  2021-03-10 00:00:00    2021-03-10 13:06:04  MG00000005  2021-03-10 13:06:04  MG00000005  View Edit Delete
AG01004390  01004390  T(直)みずがめ美星  みずがめびせい  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-01 06:57:27  2021-03-10 00:00:00    2021-03-10 13:14:26  MG00000005  2021-03-10 13:14:26  MG00000005  View Edit Delete
AG01004391  01004391  T(直)荒堀智子  あらほりともこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 09:07:05  2021-03-10 00:00:00    2021-03-10 13:21:18  MG00000005  2021-03-10 13:21:18  MG00000005  View Edit Delete
AG01004392  01004392  T(直)横山一成  よこやまいっせい  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 07:27:58  2021-03-10 00:00:00    2021-03-10 13:53:41  MG00000005  2021-03-15 08:51:15  MG00000005  View Edit Delete
AG01004393  01004393  Tイシイサトシ  いしいさとし  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-01-18 10:44:42  2021-03-11 00:00:00    2021-03-11 09:11:34  MG00000005  2021-03-11 09:11:34  MG00000005  View Edit Delete
AG01004394  01004394  T(直)彩園のら  さいえんのら  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 09:57:30  2021-03-11 00:00:00    2021-03-11 09:33:20  MG00000005  2021-03-11 09:33:20  MG00000005  View Edit Delete
AG01004395  01004395  T(直)グレープファーム  ぐれーぷふぁーむ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-09-03 11:15:39  2021-03-11 00:00:00    2021-03-11 09:40:33  MG00000005  2021-03-11 09:40:33  MG00000005  View Edit Delete
AG01004396  01004396  T(直)晴れ香  はれか  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-06-02 17:13:06  2021-03-11 00:00:00    2021-03-11 09:43:18  MG00000005  2021-03-11 09:43:18  MG00000005  View Edit Delete
AG01004397  01004397  T(直)松田範祐  まつだゆうはん  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-08-11 10:58:19  2021-03-11 00:00:00    2021-03-11 09:47:50  MG00000005  2021-03-11 09:47:50  MG00000005  View Edit Delete
AG01004398  01004398  T(直)山際泰夫  やまぎわよしお  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-23 07:02:35  2021-03-11 00:00:00    2021-03-11 09:55:41  MG00000005  2021-03-11 09:55:41  MG00000005  View Edit Delete
AG01004399  01004399  T(直)小林康三  こばやしこうぞう  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-06-01 12:24:52  2021-03-11 00:00:00    2021-03-11 10:04:42  MG00000005  2021-03-11 10:04:42  MG00000005  View Edit Delete
AG01004400  01004400  T(直)能町晃弘  のうまちあきひろ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-12-12 14:24:53  2021-03-11 00:00:00    2021-03-11 10:12:22  MG00000005  2021-03-11 10:12:22  MG00000005  View Edit Delete
AG01004401  01004401  T(直)小山輝美  こやまてるみ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-12-17 12:45:50  2021-03-11 00:00:00    2021-03-11 10:17:16  MG00000005  2021-03-11 10:17:16  MG00000005  View Edit Delete
AG01004402  01004402  T(直)おおのファーム  おおのふぁーむ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-06-19 08:04:05  2021-03-11 00:00:00    2021-03-11 10:37:25  MG00000005  2021-03-11 10:37:25  MG00000005  View Edit Delete

Page 72 of 256, showing 20 records out of 5104 total, starting on record 1421, ending on 1440

(default) 2 queries took 162 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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`, `Admin`.`user_id`, `Admin`.`mail_flg`, `Admin`.`created`, `Admin`.`insert_user`, `Admin`.`modified`, `Admin`.`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`, `TraderUser`.`user_id`, `TraderUser`.`trader_id`, `TraderUser`.`created`, `TraderUser`.`insert_user`, `TraderUser`.`modified`, `TraderUser`.`update_user`, `UsersPickupPoint`.`farmer_id`, `UsersPickupPoint`.`pickup_point_id`, `UsersPickupPoint`.`use_start_day`, `UsersPickupPoint`.`use_end_day`, `UsersPickupPoint`.`created`, `UsersPickupPoint`.`insert_user`, `UsersPickupPoint`.`modified`, `UsersPickupPoint`.`update_user`, `TradersFarmer`.`farmer_id`, `TradersFarmer`.`trader_id`, `TradersFarmer`.`farmer_cd`, `TradersFarmer`.`created`, `TradersFarmer`.`insert_user`, `TradersFarmer`.`modified`, `TradersFarmer`.`update_user`, `TradersPickupPoint`.`pickup_point_id`, `TradersPickupPoint`.`trader_user_id`, `TradersPickupPoint`.`use_start_day`, `TradersPickupPoint`.`use_end_day`, `TradersPickupPoint`.`created`, `TradersPickupPoint`.`insert_user`, `TradersPickupPoint`.`modified`, `TradersPickupPoint`.`update_user` FROM `sato_agri`.`users` AS `User` LEFT JOIN `sato_agri`.`admins` AS `Admin` ON (`Admin`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`Farmer`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`trader_users` AS `TraderUser` ON (`TraderUser`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`users_pickup_points` AS `UsersPickupPoint` ON (`UsersPickupPoint`.`farmer_id` = `User`.`id`) LEFT JOIN `sato_agri`.`traders_farmers` AS `TradersFarmer` ON (`TradersFarmer`.`farmer_id` = `User`.`id`) LEFT JOIN `sato_agri`.`traders_pickup_points` AS `TradersPickupPoint` ON (`TradersPickupPoint`.`trader_user_id` = `User`.`id`) WHERE 1 = 1 LIMIT 1420, 20202088
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`users` AS `User` LEFT JOIN `sato_agri`.`admins` AS `Admin` ON (`Admin`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`Farmer`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`trader_users` AS `TraderUser` ON (`TraderUser`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`users_pickup_points` AS `UsersPickupPoint` ON (`UsersPickupPoint`.`farmer_id` = `User`.`id`) LEFT JOIN `sato_agri`.`traders_farmers` AS `TradersFarmer` ON (`TradersFarmer`.`farmer_id` = `User`.`id`) LEFT JOIN `sato_agri`.`traders_pickup_points` AS `TradersPickupPoint` ON (`TradersPickupPoint`.`trader_user_id` = `User`.`id`) WHERE 1 = 11174