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
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
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
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
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
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
0120231100005  AG01001918 49   2023-11-30 07:43:35    2023-11-30 07:43:35  AG01001918  2023-11-30 07:43:35  AG01001918  View Edit Delete
0120220400001  AG01001633 49 150    2022-04-13 16:00:29    2022-04-13 16:00:29  AG01001633  2022-04-13 16:00:29  AG01001633  View Edit Delete
0120231100006  AG01001918 49   2023-11-30 07:44:23    2023-11-30 07:44:23  AG01001918  2023-11-30 07:44:23  AG01001918  View Edit Delete
0120180100005  AG01001918 49 300    2018-01-16 09:17:55    2018-01-16 09:17:55  AG01001918  2018-01-16 09:17:55  AG01001918  View Edit Delete
0120180100004  AG01001918 49 300    2018-01-16 09:17:22    2018-01-16 09:17:22  AG01001918  2018-01-16 09:17:22  AG01001918  View Edit Delete
0120180100003  AG01001918 49 300    2018-01-16 09:17:02    2018-01-16 09:17:02  AG01001918  2018-01-16 09:17:02  AG01001918  View Edit Delete
0120180100002  AG01001918 49 300    2018-01-16 09:16:50    2018-01-16 09:16:50  AG01001918  2018-01-16 09:16:50  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
0120180100001  AG01001918 49 300    2018-01-16 09:16:39    2018-01-16 09:16:39  AG01001918  2018-01-16 09:16:39  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
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
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

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

(default) 2 queries took 2 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`.`pickup_point_id` asc LIMIT 20, 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 = 1111