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
AG01003005  01003005  T綾部勝志  あやべかつし  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2018-08-07 08:04:17  2017-04-27 09:06:46        2017-06-29 09:50:01  MG00000001  View Edit Delete
AG01003006  01003006  Tベジファーム久門  べじふぁーむひさかど  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2019-01-25 11:39:20  2017-07-13 00:00:00        2017-07-13 10:42:12  AG01003006  View Edit Delete
AG01003007  01003007  Tやりみず農園  やりみずのうえん  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2018-04-21 14:53:16  2017-07-21 00:00:00        2017-07-21 09:52:56  AG01003007  View Edit Delete
AG01003008  01003008  T野村けい子  のむらけいこ  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2019-07-21 10:50:05  2017-07-21 00:00:00        2017-07-21 09:54:39  AG01003008  View Edit Delete
AG01003009  01003009  T地村秀代  ちむらひでよ  01  893228bb2581960aa3cc2d5bbdcc86c00b4614a4      2017-08-01 17:40:24  2017-07-27 00:00:00        2017-08-03 17:56:53  MG00000002  View Edit Delete
AG01003010  01003010  T鬼木培行  おにきますゆき  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2020-10-05 10:09:56  2017-07-31 00:00:00        2017-07-31 18:23:08  AG01003010  View Edit Delete
AG01003011  01003011  T石井良夫  いしいよしお  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2018-10-25 12:03:37  2017-08-17 00:00:00        2017-08-17 09:24:25  AG01003011  View Edit Delete
AG01003012  01003012  Tマルコ農園  まるこのうえん  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2022-04-08 07:48:20  2017-08-22 00:00:00        2017-08-22 13:18:27  AG01003012  View Edit Delete
AG01003013  01003013  T吉川直行  よしかわなおゆき  01  0e3719f4c4ebef16aa6d48cd5153ebaed3d4aec4  north.mountain_farm@ezweb.ne.jp    2024-01-24 10:24:55  2017-08-31 00:00:00        2018-09-10 10:01:59  AG01003013  View Edit Delete
AG01003014  01003014  Tマルハツ商店  まるはつしょうてん  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2022-04-08 08:55:22  2017-09-01 00:00:00        2017-09-01 10:19:34  AG01003014  View Edit Delete
AG01003015  01003015  T常岡倉一朗  つねおかそういちろう  01  58f4fd3c2c2dd87378f26bdd22b1bb2571336af3      2021-02-12 17:04:06  2017-09-06 00:00:00        2017-09-06 10:19:32  MG00000001  View Edit Delete
AG01003016  01003016  T佐古田博  さこだひろし  01  5eac4cedfb274ad8081adf87f495329d0a402357      2017-09-13 12:18:00  2017-09-11 00:00:00        2017-09-11 19:21:28  AG01003016  View Edit Delete
AG01003017  01003017  T西原農産  にしはらのうさん  01  5eac4cedfb274ad8081adf87f495329d0a402357      2022-05-31 11:06:59  2017-09-11 00:00:00        2017-09-12 16:07:12  MG00000002  View Edit Delete
AG01003018  01003018  Tフレッシュファーム菜  ふれっしゅふぁーむさい  01  b5d81d8275826b1808496b150a5975c4d2c5afe3  mika.tatuski1152@gmail.com    2018-01-08 21:58:44  2017-06-16 00:00:00        2018-07-31 15:56:47  MG00000001  View Edit Delete
AG01003019  01003019  T中西義晴  なかにしよしはる  01  8dd3a6d1676899d6666e63e609b9182831728a3c      2024-01-24 09:42:59  2017-09-19 00:00:00        2021-12-07 12:46:48  MG00000001  View Edit Delete
AG01003020  01003020  Tうなぎ昇り株式会社  うなぎのぼりかぶしきがいしゃ  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2019-05-23 09:14:56  2017-09-19 00:00:00        2017-09-19 16:33:47  MG00000002  View Edit Delete
AG01003021  01003021  T三德農場  みのりのうじょう  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2019-10-29 09:26:56  2017-09-19 00:00:00        2017-10-02 13:58:02  MG00000002  View Edit Delete
AG01003022  01003022  T三重アグリファーム  みえあぐりふぁーむ  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2021-02-27 08:45:04  2017-09-25 00:00:00        2017-10-02 13:59:30  MG00000002  View Edit Delete
AG01003023  01003023  Tスズカファーム  すずかふぁーむ  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2019-03-12 09:08:32  2017-09-25 00:00:00        2018-03-09 17:52:46  MG00000001  View Edit Delete
AG01003024  01003024  T麻生農園  あそうのうえん  01  bbe379aaf618fd4e0e5af55c1bd11b818dd4af68      2019-04-20 08:53:27  2017-09-25 00:00:00        2017-09-19 16:33:47  MG00000002  View Edit Delete

Page 15 of 256, showing 20 records out of 5104 total, starting on record 281, ending on 300

(default) 2 queries took 102 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 280, 20202030
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 = 11172