Exchange Label Roll Logs

Exchange Number Farmer Pickup Point Exchange Label Roll Acceptance Label Roll Exchange Date Acceptance Date Exchange User Created Insert User Modified Update User Actions
0120170300001  AG01001739 48   2017-03-07 13:18:46    2017-03-07 13:18:46  AG01001739  2017-03-07 13:18:46  AG01001739  View Edit Delete
0120170300002  AG01001739 48   2017-03-10 12:50:17    2017-03-10 12:50:17  AG01001739  2017-03-10 12:50:17  AG01001739  View Edit Delete
0120170500001  AG01001741 48 52    2017-05-19 14:30:19    2017-05-19 14:30:19  AG01001741  2017-05-19 14:30:19  AG01001741  View Edit Delete
0120170500002  AG01001741 48 220    2017-05-19 14:31:11    2017-05-19 14:31:11  AG01001741  2017-05-19 14:31:11  AG01001741  View Edit Delete
0120170500003  AG01001723 48   2017-05-19 15:24:23    2017-05-19 15:24:23  AG01001723  2017-05-19 15:24:23  AG01001723  View Edit Delete
0120170500004  AG01001264 48   2017-05-19 15:46:13    2017-05-19 15:46:13  AG01001264  2017-05-19 15:46:13  AG01001264  View Edit Delete
0120170500005  AG01001264 48 69    2017-05-19 15:46:45    2017-05-19 15:46:45  AG01001264  2017-05-19 15:46:45  AG01001264  View Edit Delete
0120170500006  AG01001264 48   2017-05-19 15:53:04    2017-05-19 15:53:04  AG01001264  2017-05-19 15:53:04  AG01001264  View Edit Delete
0120170500007  AG01001264 48   2017-05-19 15:53:10    2017-05-19 15:53:10  AG01001264  2017-05-19 15:53:10  AG01001264  View Edit Delete
0120170600001  AG00000000 47   2017-06-07 16:27:00    2017-06-07 16:27:00  AG00000000  2017-06-07 16:27:00  AG00000000  View Edit Delete
0120170600002  AG00000000 47   2017-06-09 10:03:29    2017-06-09 10:03:29  AG00000000  2017-06-09 10:03:29  AG00000000  View Edit Delete
0120170600003  AG00000000 47   2017-06-16 11:55:44    2017-06-16 11:55:44  AG00000000  2017-06-16 11:55:44  AG00000000  View Edit Delete
0120170600004  AG00000000 47   2017-06-19 16:24:59    2017-06-19 16:24:59  AG00000000  2017-06-19 16:24:59  AG00000000  View Edit Delete
0120170700001  AG00000000 47   2017-07-10 15:37:35    2017-07-10 15:37:35  AG00000000  2017-07-10 15:37:35  AG00000000  View Edit Delete
0120170800001  AG01001269 48   2017-08-02 16:49:17    2017-08-02 16:49:17  AG01001269  2017-08-02 16:49:17  AG01001269  View Edit Delete
0120170800002  AG01001269 48   2017-08-02 16:49:35    2017-08-02 16:49:35  AG01001269  2017-08-02 16:49:35  AG01001269  View Edit Delete
0120170800003  AG01001258 48   2017-08-02 16:53:53    2017-08-02 16:53:53  AG01001258  2017-08-02 16:53:53  AG01001258  View Edit Delete
0120170800004  AG00000000 47   2017-08-18 16:52:47    2017-08-18 16:52:47  AG00000000  2017-08-18 16:52:47  AG00000000  View Edit Delete
0120171000001  AG01003031 89   2017-10-18 10:37:07    2017-10-18 10:37:07  AG01003031  2017-10-18 10:37:07  AG01003031  View Edit Delete
0120171000002  AG00000000 47   2017-10-18 15:54:57    2017-10-18 15:54:57  AG00000000  2017-10-18 15:54:57  AG00000000  View Edit Delete

Page 1 of 4, showing 20 records out of 69 total, starting on record 1, ending on 20

< previous1234
(default) 2 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `ExchangeLabelRollLog`.`exchange_number`, `ExchangeLabelRollLog`.`farmer_id`, `ExchangeLabelRollLog`.`pickup_point_id`, `ExchangeLabelRollLog`.`exchange_label_roll`, `ExchangeLabelRollLog`.`acceptance_label_roll`, `ExchangeLabelRollLog`.`exchange_date`, `ExchangeLabelRollLog`.`acceptance_date`, `ExchangeLabelRollLog`.`exchange_user_id`, `ExchangeLabelRollLog`.`created`, `ExchangeLabelRollLog`.`insert_user`, `ExchangeLabelRollLog`.`modified`, `ExchangeLabelRollLog`.`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`, `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`, `ExchangeUser`.`user_id`, `ExchangeUser`.`trader_id`, `ExchangeUser`.`created`, `ExchangeUser`.`insert_user`, `ExchangeUser`.`modified`, `ExchangeUser`.`update_user` FROM `sato_agri`.`exchange_label_roll_logs` AS `ExchangeLabelRollLog` LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`ExchangeLabelRollLog`.`farmer_id` = `Farmer`.`user_id`) LEFT JOIN `sato_agri`.`pickup_points` AS `PickupPoint` ON (`ExchangeLabelRollLog`.`pickup_point_id` = `PickupPoint`.`id`) LEFT JOIN `sato_agri`.`trader_users` AS `ExchangeUser` ON (`ExchangeLabelRollLog`.`exchange_user_id` = `ExchangeUser`.`user_id`) WHERE 1 = 1 LIMIT 2020201
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`exchange_label_roll_logs` AS `ExchangeLabelRollLog` LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`ExchangeLabelRollLog`.`farmer_id` = `Farmer`.`user_id`) LEFT JOIN `sato_agri`.`pickup_points` AS `PickupPoint` ON (`ExchangeLabelRollLog`.`pickup_point_id` = `PickupPoint`.`id`) LEFT JOIN `sato_agri`.`trader_users` AS `ExchangeUser` ON (`ExchangeLabelRollLog`.`exchange_user_id` = `ExchangeUser`.`user_id`) WHERE 1 = 1110