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
0120171100008  AG01001918 49   2017-11-11 09:51:19    2017-11-11 09:51:19  AG01001918  2017-11-11 09:51:19  AG01001918  View Edit Delete
0120171100007  AG01001918 49 45    2017-11-11 09:18:10    2017-11-11 09:18:10  AG01001918  2017-11-11 09:18:10  AG01001918  View Edit Delete
0120171100006  AG01001918 49 45    2017-11-11 09:17:58    2017-11-11 09:17:58  AG01001918  2017-11-11 09:17:58  AG01001918  View Edit Delete
0120171100005  AG01001918 49 50    2017-11-01 11:35:37    2017-11-01 11:35:37  AG01001918  2017-11-01 11:35:37  AG01001918  View Edit Delete
0120171100004  AG01001918 49 50    2017-11-01 11:33:57    2017-11-01 11:33:57  AG01001918  2017-11-01 11:33:57  AG01001918  View Edit Delete
0120171100003  AG01001918 49 50    2017-11-01 11:33:25    2017-11-01 11:33:25  AG01001918  2017-11-01 11:33:25  AG01001918  View Edit Delete
0120171100002  AG01001918 49 50    2017-11-01 11:31:28    2017-11-01 11:31:28  AG01001918  2017-11-01 11:31:28  AG01001918  View Edit Delete
0120171100001  AG01001918 49 50    2017-11-01 11:31:06    2017-11-01 11:31:06  AG01001918  2017-11-01 11:31:06  AG01001918  View Edit Delete
0120171000003  AG01001918 49   2017-10-20 08:24:03    2017-10-20 08:24:03  AG01001918  2017-10-20 08:24:03  AG01001918  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
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
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
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
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
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
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
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
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
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
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

Page 3 of 4, showing 20 records out of 69 total, starting on record 41, ending on 60

(default) 2 queries took 3 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 ORDER BY `ExchangeLabelRollLog`.`modified` desc LIMIT 40, 2020202
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 = 1111