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
TR01000107  test-yaf@yaf-nara.com  T大和アグロファーム  やまとあぐろふぁーむ  12  eb8c15a26cd54e42321ca619733379d1579b06c9  test-yaf@yaf-nara.com    2019-03-27 14:02:59  2018-03-23 17:57:53    2018-03-23 17:57:53    2019-03-27 14:03:30  MG00000001  View Edit Delete
AG02000008  02000008  Tよつばマルシェ 8  よつばまるしぇはち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  tani5037@icloud.com    2024-01-03 13:25:16  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-04-07 13:22:40  MG00000001  View Edit Delete
TR01000100  takekawa@okumurashoji.co.jp  T武川 七恵  たけかわ ななえ  12  95b04e1e8dac6016bdbaa01a2ef99129d3f3e5aa  takekawa@okumurashoji.co.jp    2023-08-25 10:26:02  2018-01-29 17:25:48    2018-01-29 17:25:48    2019-04-23 08:24:22  MG00000002  View Edit Delete
MG00000005  t.hisano@info-sense.co.jp  T久野友崇  ひさのともたか  99  3712a121fcffa0396831c0ebe451ee0c5934de60  t.hisano@info-sense.co.jp    2022-09-01 09:03:44  2020-06-02 00:00:00    2020-06-02 11:17:11  MG00000001  2020-06-02 11:18:50  MG00000001  View Edit Delete
TR08000107  shouzou-saigusa@arai-group.co.jp  T三枝 賞造  さいぐさ しょうぞう  11  e3b8ace069bcb03280bdb518f575199bad65d066  shouzou-saigusa@arai-group.co.jp    2023-03-23 09:52:46  2018-11-26 00:00:00    2018-11-26 17:04:28  MG00000002  2023-03-23 13:16:57  MG00000001  View Edit Delete
TR05000096  shimane@okumurashoji.co.jp  T島根 秀明  しまね ひであき  11  f918ab9cb639371db5c44c1b76f293414a0b7bd0  shimane@okumurashoji.co.jp    2019-05-24 16:51:27  2017-12-26 14:06:59    2017-12-26 14:06:59    2017-12-26 17:37:41  MG00000002  View Edit Delete
MG00000004  satoko.ogawa@sato-global.com  T小川 聡子  おがわさとこ  99  ac48bb28a0645c54ceaa56652880baae9e7e9d57  satoko.ogawa@sato-global.com    2020-03-02 17:33:00  2019-12-06 00:00:00    2019-12-06 10:47:13  MG00000001  2020-01-17 10:13:44  MG00000001  View Edit Delete
AG01003555  01003555  T泰田孝  やすだたかし  01  0e3719f4c4ebef16aa6d48cd5153ebaed3d4aec4  sanukilemon001@gmail.com    2024-01-24 09:59:49  2018-07-23 00:00:00    2018-07-23 15:44:58  MG00000001  2021-12-07 13:05:26  MG00000001  View Edit Delete
AG01002756  01002756  T高橋 光男  たかはしみつお  01  0e3719f4c4ebef16aa6d48cd5153ebaed3d4aec4  sanukifuji@mc.pikara.ne.jp    2023-11-13 18:36:51  2016-08-29 00:00:00    2017-04-18 13:36:00  MG00000001  2022-08-22 14:24:40  MG00000001  View Edit Delete
AG01001852  01001852  T増田和記  ますだかずき  01  87b61df05017322dc411d6eca20a205f57ed487e  sannma2sudachi@gmail.com    2024-01-22 10:03:35  2016-08-29 00:00:00    2016-08-30 12:23:31  MG00000001  2019-11-01 11:41:42  AG01001852  View Edit Delete
AG02000020  02000020  Tよつばマルシェ 20  よつばまるしぇにじゅう  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  sakura.tuneko-0427@docomo.ne.jp    2024-01-23 12:23:04  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-02-27 17:03:28  MG00000002  View Edit Delete
TR01000085  s.tanaka@mitsui-agro.co.jp  T田中俊平  たなかしゅんぺい  11  f0e0ac0804bae9d9a806a317f1240438e37a92cd  s.tanaka@mitsui-agro.co.jp    2016-09-23 18:59:38  2016-09-23 10:12:14    2016-09-23 10:12:14    2016-09-23 19:00:22  MG00000001  View Edit Delete
AG01002102  01002102  T谷本農園(飯山)  たにもとのうえん  01  697c8cd626f6b7afe9dbc8a1230512d8a342fc77  rz534832@yj9.so-net.ne.jp    2020-11-30 11:02:59  2016-08-29 00:00:00    2016-08-30 12:23:33  MG00000001  2017-10-04 14:25:39  AG01002102  View Edit Delete
AG01001569  01001569  T三原央行  みはらひろゆき  01  87b61df05017322dc411d6eca20a205f57ed487e  rtccx553@yahoo.co.jp    2024-01-23 12:16:21  2016-08-29 00:00:00    2016-08-30 12:23:29  MG00000001  2023-08-18 08:05:49  AG01001569  View Edit Delete
AG02000018  02000018  Tよつばマルシェ 18  よつばまるしぇじゅうはち  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  rio3kasiko@ezweb.ne.jp    2024-01-23 12:27:56  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2018-03-02 09:48:07  MG00000001  View Edit Delete
AG01002768  01002768  T水城太喜男  みずきたきお  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3  qq5u3st9@almond.ocn.ne.jp    2023-04-05 13:26:22  2016-07-01 00:00:00    2017-04-18 13:36:00  MG00000001  2018-07-06 09:24:20  MG00000001  View Edit Delete
AG02000024  02000024  Tよつばマルシェ 24  よつばまるしぇにじゅうし  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  puti-puti@ezweb.ne.jp    2022-06-07 11:27:36  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-04-07 13:26:22  MG00000001  View Edit Delete
TR03000099  otani@hida-surugaya.com  T駿河屋テスト  するがやてすと  11  8dd3a6d1676899d6666e63e609b9182831728a3c  otani@hida-surugaya.com    2018-04-02 10:18:25  2017-12-26 18:04:36    2017-12-26 18:04:36    2018-04-02 10:20:34  MG00000002  View Edit Delete
AG01003382  01003382  T松本出荷組合  まつもとしゅっかくみあい  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4  okanishi13@yahoo.co.jp    2019-08-16 11:44:15  2018-04-02 00:00:00    2018-04-02 00:00:00  MG00000001  2018-04-05 17:43:41  AG01003382  View Edit Delete
AG02000012  02000012  Tよつばマルシェ 12  よつばまるしぇじゅうに  01  733d15d5c81a7daa65441425cfac18e4e539d3dc  oharumaki455@gmail.com    2024-01-22 09:22:53  2017-02-01 00:00:00    2017-02-01 00:00:00  MG00000001  2017-03-24 18:06:51  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 320 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`.`mail_address_1` desc LIMIT 20, 202020246
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