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
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
TR01000049  01000049  T徳島市  とくしまし  12  144e13358c57415ec89dacdbfc625450b2c63c35  01000049      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 13:53:22  MG00000001  View Edit Delete
TR01000050  01000050  T藍住町  あいずみ  12  73ba0bd50da8952b389de02f0b349499f84af18e  01000050      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 13:53:42  MG00000001  View Edit Delete
TR01000006  01000006  T月形新鮮組  つきがたしんせんぐみ  12  5f31cd69ee346b09cc6fed468dcfe1370d02c8bf  01000006      2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-11-18 09:04:59  MG00000001  View Edit Delete
TR01000051  01000051  T阿波市  あわ  12  d04b728edeebcd5657b67195a7174c383167a2b2  01000051      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 13:53:52  MG00000001  View Edit Delete
TR01000052  01000052  T美馬市  みま  12  d1640b4373c56576526c6d80905392155610517d  01000052      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 13:54:05  MG00000001  View Edit Delete
TR01000053  01000053  T鳴門市  なると  12  18b90d82031a37635c43be90429287359fa3e0b1  01000053      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 13:54:20  MG00000001  View Edit Delete
TR01000054  01000054  T美波町  みなみ  12  1cf795e7faebacad96584835532c6c02af39a8c6  01000054      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 13:55:11  MG00000001  View Edit Delete
TR01000055  01000055  T市場町①  いちば  12  fb7ce140af599cda0ee4893fc0f467b285734078  01000055      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 13:55:26  MG00000001  View Edit Delete
TR01000056  01000056  T海陽町  かいようちょう  12  7afd20b3831f17ab0d86b9348c110c0247ad400e  01000056      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 13:55:43  MG00000001  View Edit Delete
TR01000057  01000057  T阿南市  あなん  12  5ce379a034081691decf54959e3147a5356f5f3f  01000057      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 13:55:57  MG00000001  View Edit Delete
TR01000059  01000059  T市場町②  いちば  12  c5aa7786a3261347c45c0710ec7a94cd0e3c3396  01000059      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 13:56:24  MG00000001  View Edit Delete
TR01000060  01000060  T阿南市北部  あなんしほくぶ  12  f774b2f8e86496eddca3afa152e4f0086cac76f5  01000060      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 13:56:37  MG00000001  View Edit Delete
TR01000061  01000061  TMAB徳島  とくしま  12  5e1e9d0ec46232db7f02dc29706eeb1ff399877f  01000061      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 13:56:47  MG00000001  View Edit Delete
TR01000062  01000062  T三豊市  みとよ  12  37314f823c9c6d9a0d991e2f0e9f029ff0af21dd  01000062      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 13:57:20  MG00000001  View Edit Delete
TR01000063  01000063  T丸亀市南部  まるがめしなんぶ  12  e34251508f0e3822b02755dd7253721cb4a53bdc  01000063      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 13:57:41  MG00000001  View Edit Delete
TR01000064  01000064  T丸亀市北部  まるがめしほくぶ  12  a8037c63d62ceb37371de2ffc2c2c114d061812f  01000064      2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-11-18 13:57:55  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 322 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`.`init_pass_flg` desc LIMIT 20, 202020248
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