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
TR01000022  01000022  TJA北いしかり①  きたいしかり  12  c2c81757eb4dcd50afb2592e2e371d808a9b6d32  01000022      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 09:08:05  MG00000001  View Edit Delete
TR01000023  01000023  TJA北いしかり②  きたいしかり  12  59916f16ae49dfd40b5ab983a49f922067a079f7  01000023      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 09:08:16  MG00000001  View Edit Delete
TR01000004  01000004  T南幌  なんぽろ  12  64aff6315bb39eca37879c2131e6db5572692057  01000004      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 09:04:32  MG00000001  View Edit Delete
TR01000032  01000032  T木津川市  きづがわ  12  b8d449de72ea4676276609e441c08148753b7679  01000032      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:10:45  MG00000001  View Edit Delete
TR01000033  01000033  T亀岡市  かめおか  12  d0ab0a8ba3990a2fac024ed147a5a44e11b2202e  01000033      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:10:56  MG00000001  View Edit Delete
TR01000034  01000034  TMAB京都  きょうと  12  e0fc39d68e1a0a326bfefe81892602ca28ad354e  01000034      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:11:08  MG00000001  View Edit Delete
TR01000036  01000036  T郡山市  こおりやま  12  7ba904560e55516e994029752d78820a5cd2014b  01000036      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:11:41  MG00000001  View Edit Delete
TR01000037  01000037  T高田市  たかだ  12  f16b982165486693063bdd0e2b4f34dcc4e71aff  01000037      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:11:51  MG00000001  View Edit Delete
TR01000038  01000038  T五條市  ごじょうし  12  b2410967112a7f2480b261a9026de2f148905be4  01000038      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:12:04  MG00000001  View Edit Delete
TR01000039  01000039  T河合町  かわいちょう  12  e4e55df5e52be2f706e99356c4db8c40a478b992  01000039      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:12:14  MG00000001  View Edit Delete
TR01000040  01000040  T奈良市  なら  12  90b1078b79873a664aa66948b936c8ca6aa5fb76  01000040      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:12:25  MG00000001  View Edit Delete
TR01000005  01000005  TJAいしかり  いしかり  12  1f65e792f507f481c677a4f079f58fa9f1ec5aa5  01000005      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 09:04:44  MG00000001  View Edit Delete
TR01000041  01000041  T御所市  ごせ  12  f07b060d770c84ec7d9b9b0c630d5a0d6b75989a  01000041      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:12:51  MG00000001  View Edit Delete
TR01000042  01000042  T平群町  へぐり  12  ac5e6dc924d1edc808322889cb2b141d3543d399  01000042      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:13:21  MG00000001  View Edit Delete
TR01000043  01000043  T明日香村  あすかむら  12  58c182c8c312b81e0dc8a146552dbf14fbddad55  01000043      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:13:33  MG00000001  View Edit Delete
TR01000044  01000044  T大淀町  おおよどちょう  12  93babe5e2f8a88b96e5117c5b72aab678ae9e618  01000044      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:39:00  MG00000001  View Edit Delete
TR01000045  01000045  T桜井市  さくらい  12  e9578665f422398c798ae74cd7ac4a8fe99ca67c  01000045      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:42:08  MG00000001  View Edit Delete
TR01000046  01000046  TMAB奈良  なら  12  760753f5371bdaabf56d2300e00f922555b0b456  01000046      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 09:42:21  MG00000001  View Edit Delete
TR01000047  01000047  T紀北かわかみ  きほくかわかみ  12  f350c2c7389732052ad3a8d3ed0c994f13d5b327  01000047      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 13:52:58  MG00000001  View Edit Delete
TR01000048  01000048  T橋本市  はしもと  12  6c50a7215957479718dcec349fd6e4a405b3e837  01000048      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 13:53:10  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 316 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`.`del_flg` desc LIMIT 20, 202020244
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