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
AG01004233  01004233  T(直)齋藤農園  さいとうのうえん  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-21 07:51:57  2021-01-20 00:00:00    2021-01-20 08:55:40  MG00000005  2021-01-27 08:55:38  MG00000005  View Edit Delete
AG01004349  01004349  T(直)黒田寛  くろだひろし  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2022-07-11 07:47:13  2021-03-08 00:00:00    2021-03-08 18:51:56  MG00000005  2021-03-08 18:51:56  MG00000005  View Edit Delete
AG01004408  01004408  T(直)髙本仙一  たかもとせんいち  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-11-17 09:38:23  2021-03-11 00:00:00    2021-03-11 13:22:30  MG00000005  2021-03-11 13:22:30  MG00000005  View Edit Delete
AG01005673  01005673  T(直)高田  たかだ  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-08-23 00:00:00    2023-08-23 00:00:00  MG00000001  2023-08-23 00:00:00  MG00000001  View Edit Delete
AG01004329  01004329  T(直)高原俊六  たかはらしゅんろく  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-09-24 06:53:44  2021-03-08 00:00:00    2021-03-08 13:37:33  MG00000005  2021-03-08 13:37:33  MG00000005  View Edit Delete
AG01004412  01004412  T(直)駒井園  こまいえん  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2022-03-25 12:26:12  2021-03-11 00:00:00    2021-03-11 14:08:37  MG00000005  2021-03-12 11:46:33  MG00000005  View Edit Delete
AG01004362  01004362  T(直)馬場康喜  ばばやすよし  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-19 07:07:15  2021-03-09 00:00:00    2021-03-09 10:24:39  MG00000005  2021-03-09 10:24:39  MG00000005  View Edit Delete
AG01004638  01004638  T(直)関農園 関実  せきのうえんせきじつ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-10-02 07:31:15  2022-02-14 00:00:00    2022-02-14 13:54:51  MG00000001  2022-02-14 13:54:51  MG00000001  View Edit Delete
AG01005823  01005823  T(直)野中農園  のなかのうえん  01  a414b2d4cfef84f98d8c45e856482cf9c215707c        2023-10-12 00:00:00    2023-10-12 00:00:00  MG00000001  2023-10-12 00:00:00  MG00000001  View Edit Delete
AG01004377  01004377  T(直)辻本浩行  つじもとひろゆき  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2021-12-08 15:46:30  2021-03-10 00:00:00    2021-03-10 09:48:58  MG00000005  2021-10-26 11:07:35  MG00000001  View Edit Delete
AG01004410  01004410  T(直)赤枝康信  あかえだやすのぶ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-07-30 11:13:04  2021-03-11 00:00:00    2021-03-11 13:37:09  MG00000005  2021-03-11 13:37:09  MG00000005  View Edit Delete
AG01004429  01004429  T(直)虎倉ファームあっくん  こくらふぁーむあっくん  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-11-11 12:28:37  2021-03-18 00:00:00    2021-03-18 11:52:08  MG00000005  2021-03-18 11:52:08  MG00000005  View Edit Delete
AG01004385  01004385  T(直)藤原農園  ふじわらのうえん  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 13:54:10  2021-03-10 00:00:00    2021-03-10 11:04:39  MG00000005  2021-03-10 11:04:39  MG00000005  View Edit Delete
AG01004405  01004405  T(直)藤井陽子  ふじいようこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2021-03-23 16:13:48  2021-03-11 00:00:00    2021-03-11 13:05:48  MG00000005  2021-03-11 13:05:48  MG00000005  View Edit Delete
AG01004413  01004413  T(直)藤井久美  ふじいくみ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-08-15 10:32:43  2021-03-12 00:00:00    2021-03-12 08:45:38  MG00000005  2021-03-12 08:45:38  MG00000005  View Edit Delete
AG01004308  01004308  T(直)蒜山農産加工  ひるぜんのうさんかこう  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-01-25 16:07:24  2021-01-22 00:00:00    2021-01-22 16:03:40  MG00000005  2021-01-22 16:25:59  MG00000005  View Edit Delete
AG01005193  01005193  T(直)落合空きコード  おちあいあきこーど  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-04-26 18:02:19  2022-10-13 00:00:00    2022-10-13 15:29:56  MG00000001  2022-10-13 15:29:56  MG00000001  View Edit Delete
AG01004304  01004304  T(直)菜果  さいか  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2023-11-03 17:04:12  2021-01-22 00:00:00    2021-01-22 15:44:48  MG00000005  2021-01-22 15:44:48  MG00000005  View Edit Delete
AG01004391  01004391  T(直)荒堀智子  あらほりともこ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-24 09:07:05  2021-03-10 00:00:00    2021-03-10 13:21:18  MG00000005  2021-03-10 13:21:18  MG00000005  View Edit Delete
AG01004444  01004444  T(直)若林三喜昌  わかばやしみよしまさ  01  c429bccaaf941b3a2c604fc696a5fa6eb5651d2c      2024-01-22 07:20:49  2021-03-20 00:00:00    2021-03-20 23:23:34  MG00000005  2021-03-20 23:23:34  MG00000005  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`.`user_nm` desc LIMIT 20, 202020247
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 = 11173