Traders Pickup Points

Pickup Point Trader User Use Start Day Use End Day Created Insert User Modified Update User Actions
44  TR01000045 2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
45  TR01000046 2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
46  TR01000047 2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
47  TR01000048 2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
48  TR01000049 2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
48  TR01000088 0000-00-00 00:00:00    2016-12-27 15:45:53  MG00000001  2016-12-27 15:45:53  MG00000001  View Edit Delete
49  TR01000050 2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
49  TR01000100 0000-00-00 00:00:00    2018-01-29 17:25:48  MG00000002  2018-01-29 17:25:48  MG00000002  View Edit Delete
49  TR01000101 0000-00-00 00:00:00    2018-01-29 17:36:42  MG00000002  2018-01-29 17:36:42  MG00000002  View Edit Delete
TR01000006 2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
50  TR01000051 2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
51  TR01000052 2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
52  TR01000053 2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
53  TR01000054 2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
54  TR01000055 2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
55  TR01000056 2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
56  TR01000057 2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
58  TR01000059 2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
59  TR01000060 2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete
60  TR01000061 2016-08-29 00:00:00    2016-08-30 12:23:37  MG00000001  2016-08-30 12:23:37  MG00000001  View Edit Delete

Page 2 of 4, showing 20 records out of 61 total, starting on record 21, ending on 40

(default) 2 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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`, `TraderUser`.`user_id`, `TraderUser`.`trader_id`, `TraderUser`.`created`, `TraderUser`.`insert_user`, `TraderUser`.`modified`, `TraderUser`.`update_user`, `PickupPoint`.`id`, `PickupPoint`.`pickup_point_cd`, `PickupPoint`.`trader_id`, `PickupPoint`.`locality_id`, `PickupPoint`.`locality_cd`, `PickupPoint`.`pickup_point_nm`, `PickupPoint`.`pickup_point_fk`, `PickupPoint`.`use_start_day`, `PickupPoint`.`use_end_day`, `PickupPoint`.`margin_price_yen`, `PickupPoint`.`remain_label_roll`, `PickupPoint`.`threshold_label_roll`, `PickupPoint`.`inventory_label_roll`, `PickupPoint`.`inventory_date`, `PickupPoint`.`created`, `PickupPoint`.`insert_user`, `PickupPoint`.`modified`, `PickupPoint`.`update_user`, `PickupPoint`.`password` FROM `sato_agri`.`traders_pickup_points` AS `TradersPickupPoint` LEFT JOIN `sato_agri`.`trader_users` AS `TraderUser` ON (`TradersPickupPoint`.`trader_user_id` = `TraderUser`.`user_id`) LEFT JOIN `sato_agri`.`pickup_points` AS `PickupPoint` ON (`TradersPickupPoint`.`trader_user_id` = `PickupPoint`.`id`) WHERE 1 = 1 LIMIT 20, 2020201
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`traders_pickup_points` AS `TradersPickupPoint` LEFT JOIN `sato_agri`.`trader_users` AS `TraderUser` ON (`TradersPickupPoint`.`trader_user_id` = `TraderUser`.`user_id`) LEFT JOIN `sato_agri`.`pickup_points` AS `PickupPoint` ON (`TradersPickupPoint`.`trader_user_id` = `PickupPoint`.`id`) WHERE 1 = 1110