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
0120230500005  AG01004743 50   2023-05-27 13:32:05    2023-05-27 13:32:05  AG01004743  2023-05-27 13:32:05  AG01004743  View Edit Delete
0120230500002  AG01005036 149 30    2023-05-25 07:42:43    2023-05-25 07:42:43  AG01005036  2023-05-25 07:42:43  AG01005036  View Edit Delete
0120230500003  AG01005036 149   2023-05-25 07:44:20    2023-05-25 07:44:20  AG01005036  2023-05-25 07:44:20  AG01005036  View Edit Delete
0120230500004  AG01005036 149   2023-05-25 07:44:38    2023-05-25 07:44:38  AG01005036  2023-05-25 07:44:38  AG01005036  View Edit Delete
0120220900001  AG01005134 109   2022-09-03 13:33:35    2022-09-03 13:33:35  AG01005134  2022-09-03 13:33:35  AG01005134  View Edit Delete
0120231000001  AG01005851 186   2023-10-29 08:45:31    2023-10-29 08:45:31  AG01005851  2023-10-29 08:45:31  AG01005851  View Edit Delete
0120231100002  AG01005862 187 25    2023-11-19 08:56:10    2023-11-19 08:56:10  AG01005862  2023-11-19 08:56:10  AG01005862  View Edit Delete
0120231100003  AG01005862 187 25    2023-11-19 08:56:38    2023-11-19 08:56:38  AG01005862  2023-11-19 08:56:38  AG01005862  View Edit Delete
0120231100004  AG01005862 187   2023-11-28 09:59:15    2023-11-28 09:59:15  AG01005862  2023-11-28 09:59:15  AG01005862  View Edit Delete

Page 4 of 4, showing 9 records out of 69 total, starting on record 61, ending on 69

1234next >
(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`.`farmer_id` asc LIMIT 60, 20991
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