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
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
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
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
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
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
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
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
0120210300001  AG01004331 121   2021-03-30 16:42:56    2021-03-30 16:42:56  AG01004331  2021-03-30 16:42:56  AG01004331  View Edit Delete
0120210400001  AG01004331 121 16    2021-04-16 08:44:02    2021-04-16 08:44:02  AG01004331  2021-04-16 08:44:02  AG01004331  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
0120200500001  AG01003907 105   2020-05-11 15:38:45    2020-05-11 15:38:45  AG01003907  2020-05-11 15:38:45  AG01003907  View Edit Delete
0120200100001  AG01003926 102 40    2020-01-15 09:59:27    2020-01-15 09:59:27  AG01003926  2020-01-15 09:59:27  AG01003926  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
0120200100002  AG01003538 89 20    2020-01-15 09:59:37    2020-01-15 09:59:37  AG01003538  2020-01-15 09:59:37  AG01003538  View Edit Delete
0120200700001  AG01003415 82   2020-07-09 07:42:49    2020-07-09 07:42:49  AG01003415  2020-07-09 07:42:49  AG01003415  View Edit Delete
0120190200001  AG01003555 64   2019-02-16 09:30:43    2019-02-16 09:30:43  AG01003555  2019-02-16 09:30:43  AG01003555  View Edit Delete
0120181200002  AG01003623 64   2018-12-03 20:56:32    2018-12-03 20:56:32  AG01003623  2018-12-03 20:56:32  AG01003623  View Edit Delete
0120181200001  AG01003623 64   2018-12-03 20:56:02    2018-12-03 20:56:02  AG01003623  2018-12-03 20:56:02  AG01003623  View Edit Delete
0120191000002  AG01003845 63   2019-10-31 18:11:27    2019-10-31 18:11:27  AG01003845  2019-10-31 18:11:27  AG01003845  View Edit Delete
0120191000001  AG01003845 63 138    2019-10-31 18:05:17    2019-10-31 18:05:17  AG01003845  2019-10-31 18:05:17  AG01003845  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 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` desc 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 = 1111