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
TR02000089  maze.vegetable@gmail.com  T乃一大樹  のいちひろき  11  eb805673110009c8955ad4c61066fe8a80dc8bd5  maze.vegetable@gmail.com    2024-01-18 09:06:35  2017-05-09 17:43:48    2017-05-09 17:43:48    2021-01-06 11:41:03  MG00000005  View Edit Delete
TR01000113  test5@test.com  中間業者テスト    11  c2debdbc6537ad963c4aa33c00418a32194f4325  test5@test.com      2024-03-12 00:00:00    2024-03-12 08:55:24  MG00000001  2024-03-12 08:55:24  MG00000001  View Edit Delete
TR01000112  test4@test.com  中間業者テスト    11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  test4@test.com      2024-03-12 00:00:00    2024-03-12 08:54:41  MG00000001  2024-03-12 08:54:41  MG00000001  View Edit Delete
TR01000111  chukan1@example.com  中間 太郎  ちゅうかん たろう  11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  chukan1@example.com      2024-03-11 00:00:00    2024-03-11 16:28:15  MG00000001  2024-03-11 16:28:15  MG00000001  View Edit Delete
TR01000110  test3@test.com  中間業者テスト    11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  test3@test.com    2024-03-15 14:26:49  2024-03-11 00:00:00    2024-03-11 13:55:09  MG00000001  2024-03-11 14:03:11  MG00000001  View Edit Delete
TR01000109  test@test.com  やさい    11  c8ae6862b7efa8edf8404740c8bfef8d89dc8b3d  test@test.com      2024-02-27 00:00:00    2024-02-27 14:15:46  MG00000001  2024-02-27 14:15:46  MG00000001  View Edit Delete
TR01000108  yaf@yaf-nara.com  T大和アグロファーム  やまとあぐろふぁーむ  12  e42652ab16049d9c1dea8a88c238d266a85dbe47  yaf@yaf-nara.com    2019-04-04 16:20:31  2019-03-27 00:00:00    2019-03-27 14:12:14  MG00000001  2019-04-04 16:21:10  MG00000001  View Edit Delete
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
TR01000105  test@mitsui-agro.co.jp  T三井物産テスト  みついぶっさんてすと  11  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  test@mitsui-agro.co.jp    2018-02-21 09:53:19  2018-02-21 09:51:45    2018-02-21 09:51:45    2018-02-21 09:53:35  MG00000002  View Edit Delete
TR01000101  aizumi@sato.com  T集荷場テスト(藍住町)  しゅうかじょうてすと  12  d0b76682a2a6ab4bf95ebec0f45212fe60830f61  aizumi@sato.com    2018-01-29 17:37:24  2018-01-29 17:36:42    2018-01-29 17:36:42    2018-01-29 17:56:13  MG00000002  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
TR01000092  01000092  T山都町  やまとちょう  12  52f6f70a27d83a8c15ac091e58f211ee7d0197d4      2017-10-30 12:00:50  2017-10-30 10:00:13        2017-10-30 12:01:00  MG00000001  View Edit Delete
TR01000091  01000091  T三重県  みえけん  12  5eac4cedfb274ad8081adf87f495329d0a402357        2017-09-19 15:28:56            View Edit Delete
TR01000090  01000090  T久御山町  くみやまちょう  12  5eac4cedfb274ad8081adf87f495329d0a402357        2017-09-19 15:27:52            View Edit Delete
TR01000089  01000089  T日吉町  ひよしちょう  12  5eac4cedfb274ad8081adf87f495329d0a402357  01000089    2017-09-12 14:37:13  2017-09-11 13:53:34        2017-09-12 14:37:29  MG00000001  View Edit Delete
TR01000088  miyazakifood@mx.tiki.ne.jp  T宮崎勝嘉  みやざきかつよし  12  30d1b1682a19f86b64d6b76508d7c00cfd73037c  miyazakifood@mx.tiki.ne.jp    2017-12-26 14:49:36  2016-12-27 15:45:53    2016-12-27 15:45:53    2017-12-26 14:50:08  MG00000002  View Edit Delete
TR01000087  ch.endo@mitsui-agro.co.jp  T遠藤千暁  えんどうちあき  11  09aa23e69fbdeb82eb1adf86f3e877cd5d54061f  ch.endo@mitsui-agro.co.jp    2019-06-06 10:11:50  2016-09-23 10:24:00    2016-09-23 10:24:00    2016-09-23 10:24:16  MG00000001  View Edit Delete
TR01000086  a.nishiwaki@mitsui-agro.co.jp  T西脇愛  にしわきあい  11  2fe007686862aae206a535a33fd2b82e6709e369  a.nishiwaki@mitsui-agro.co.jp    2016-09-23 10:25:32  2016-09-23 10:14:49    2016-09-23 10:14:49    2016-09-23 10:26:09  MG00000001  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
TR01000084  k.takebayashi@mitsui-agro.co.jp  T竹林清宏  たけばやしきよひろ  11  267b098376910964b6b90b932642f88076bca49a  k.takebayashi@mitsui-agro.co.jp    2016-10-12 14:30:16  2016-09-23 09:43:24    2016-09-23 09:43:24    2016-10-12 14:30:27  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 323 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`.`id` desc LIMIT 20, 202020249
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