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
TR01000071  01000071  T金田  かねだ  12  586d0c1d030b93f66cc53ef8c5e27436d614600a  01000071      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 13:59:58  MG00000001  View Edit Delete
TR01000072  01000072  T大栄  だいえい  12  cc001c7b078cb3b458be9c724ba46eb1191e65b5  01000072      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 14:00:12  MG00000001  View Edit Delete
TR01000073  01000073  T深江  ふかえ  12  269be4618174f11cae30f3d850fa577b068815e6  01000073      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 14:00:32  MG00000001  View Edit Delete
TR01000074  01000074  T飯盛  いいもり  12  d45053cb396caa243df3fcf8351f13f003c07a70  01000074      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 14:01:39  MG00000001  View Edit Delete
TR01000075  01000075  T川田  かわた  12  b9e32ad2e725d66c09d95dd427f1d5d5cf77fd0b  01000075      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 14:01:50  MG00000001  View Edit Delete
TR01000076  01000076  T丸松  まるまつ  12  15a379e7166d63913a28880095a7e403421865a3  01000076      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 14:02:01  MG00000001  View Edit Delete
TR01000080  01000080  TYAFキリン堂  きりんどう  12  a90c5a22468d21d5b3a3f0217c71ea746b45fc6d  01000080      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 14:02:21  MG00000001  View Edit Delete
MG00000001  grp-support.agri-harvest@sato-global.com  T管理者(サトー)  かんりしゃ(さとー)  99  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  grp-support.agri-harvest@sato-global.com    2025-03-06 15:14:24  2016-08-01 00:00:00    2016-08-26 17:04:05  MG00000001  2016-09-01 10:51:25  MG00000001  View Edit Delete
TR00000001  trmail@trader.co.jp  T三井物産アグロビジネス  みついぶっさんあぐろびじねす  11    trmail@trader.co.jp      2016-08-01 00:00:00    2016-08-26 17:04:05  MG00000001  2016-09-23 10:24:30  MG00000001  View Edit Delete
AG01000335  01000335  T上田伊佐男  うえだいさお  01  128daf96fd3b3f779b1dc0104b938fd122025e35  coccodaisukidesu@yahoo.co.jp    2022-01-24 15:55:45  2016-08-29 00:00:00    2016-08-30 12:23:18  MG00000001  2022-06-01 11:05:04  MG00000001  View Edit Delete
AG01000611  01000611  T梨子本マミ子  なしもとまみこ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2023-05-02 13:57:16  2016-08-29 00:00:00    2016-08-30 12:23:20  MG00000001  2017-08-03 17:31:18  MG00000002  View Edit Delete
AG01000643  01000643  Tマルミヤ農園  まるみやのうえん  01  8f14cf117c8a77a294a63f30d72fe4b94f945c5f      2017-07-07 10:28:01  2016-08-29 00:00:00    2016-08-30 12:23:20  MG00000001  2017-03-17 17:37:14  MG00000001  View Edit Delete
AG01000675  01000675  T梨子本晃士  なしもとこうじ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-09-08 13:55:16  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-08-03 17:31:41  MG00000002  View Edit Delete
AG01000677  01000677  T鵜山久雄  うやまひさお  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-08-02 14:32:51  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-07-27 11:24:56  MG00000001  View Edit Delete
AG01000683  01000683  T吉井康  よしいやすし  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-09-08 13:54:37  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-08-03 17:33:28  MG00000002  View Edit Delete
AG01000684  01000684  T吉村孝雄  よしむらたかお  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-09-17 21:47:18  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-07-27 18:48:54  MG00000001  View Edit Delete
AG01000685  01000685  T吉村俊幸  よしむらとしゆき  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-09-02 09:56:04  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-07-27 19:06:36  MG00000001  View Edit Delete
AG01000692  01000692  T寺田佳史  てらだよしふみ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-08-01 14:28:28  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-08-03 17:34:21  MG00000002  View Edit Delete
AG01000693  01000693  T寺田勉  てらだつとむ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-09-08 13:57:20  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-07-28 10:06:03  MG00000001  View Edit Delete
AG01000695  01000695  T上田美加子  うえだみかこ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-09-08 14:02:26  2016-08-29 00:00:00    2016-08-30 12:23:21  MG00000001  2017-07-28 10:26:04  MG00000001  View Edit Delete

Page 2 of 256, showing 20 records out of 5104 total, starting on record 21, ending on 40

(default) 2 queries took 316 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 ORDER BY `User`.`use_start_day` asc LIMIT 20, 202020245
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 = 11171