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
AG01005724  01005724  T槇坂孝子  まきさかたかこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c        2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005725  01005725  T滝弘子  たきひろこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-12-18 06:44:04  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005726  01005726  T多賀義明  たがよしあき  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-10-17 07:34:08  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005727  01005727  T藤原範子  ふじわらのりこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 06:26:22  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005728  01005728  T森下義男  もりしたよしお  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-10-22 06:52:32  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005729  01005729  T(直)明治ごんぼう村  ちょくめいじごんぼうむら  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-22 06:40:38  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005730  01005730  T明治ごんぼう村  めいじごんぼうむら  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 06:43:10  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-29 09:31:08  AG01005730  View Edit Delete
AG01005731  01005731  T石井栄太郎  いしいえいたろう  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-11-06 12:47:47  2023-09-22 00:00:00    2023-09-22 10:59:35  MG00000001  2023-09-22 10:59:35  MG00000001  View Edit Delete
AG01005732  01005732  T須増和弘  すぞうかずひろ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-23 14:35:50  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005733  01005733  T徳田千恵子  とくだちえこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-18 10:08:11  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005734  01005734  T須増克利  すぞうかつとし  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-10-05 06:58:19  2023-09-22 00:00:00    2023-09-22 00:00:00  MG00000001  2023-09-22 00:00:00  MG00000001  View Edit Delete
AG01005735  01005735  T田中農場  たなかのうじょう  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 10:47:51  2023-09-28 00:00:00    2023-09-28 10:28:24  MG00000001  2023-09-28 10:28:24  MG00000001  View Edit Delete
AG01005736  01005736  T山上和子  やまがみかずこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-23 11:50:21  2023-09-28 00:00:00    2023-09-28 00:00:00  MG00000001  2023-09-28 00:00:00  MG00000001  View Edit Delete
AG01005737  01005737  T加藤俊恵  かとうしゅんめぐみ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-21 09:26:23  2023-09-28 00:00:00    2023-09-28 00:00:00  MG00000001  2023-09-28 00:00:00  MG00000001  View Edit Delete
AG01005738  01005738  Tきのこの里のぞみ園  きのこのさとのぞみえん  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-22 17:38:36  2023-09-28 00:00:00    2023-09-28 00:00:00  MG00000001  2023-09-28 00:00:00  MG00000001  View Edit Delete
AG01005739  01005739  T田村弘志  たむらひろし  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-16 08:52:26  2023-09-28 00:00:00    2023-09-28 10:43:42  MG00000001  2023-09-28 10:43:42  MG00000001  View Edit Delete
AG01005740  01005740  TJA岡山(米)  じぇいえいおかやまこめ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-09-28 19:48:03  2023-09-28 00:00:00    2023-09-28 00:00:00  MG00000001  2023-09-28 00:00:00  MG00000001  View Edit Delete
AG01005741  01005741  TJA岡山1  じぇいえいおかやまいち  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c        2023-09-28 00:00:00    2023-09-28 00:00:00  MG00000001  2023-09-28 00:00:00  MG00000001  View Edit Delete
AG01005742  01005742  T有吉佐代子  ありよしさよこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-22 07:32:54  2023-09-28 00:00:00    2023-09-28 00:00:00  MG00000001  2023-09-28 00:00:00  MG00000001  View Edit Delete
AG01005743  01005743  T池上美都子  いけがみみとこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-10-05 07:32:42  2023-09-28 00:00:00    2023-09-28 00:00:00  MG00000001  2023-09-28 00:00:00  MG00000001  View Edit Delete

Page 139 of 256, showing 20 records out of 5104 total, starting on record 2761, ending on 2780

(default) 2 queries took 240 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 2760, 202020165
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 = 11175