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
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
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
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
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
0120230500001  AG01001920 48   2023-05-16 13:54:57    2023-05-16 13:54:57  AG01001920  2023-05-16 13:54:57  AG01001920  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
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
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
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
0120171100011  AG01001918 49 155    2017-11-22 08:31:15    2017-11-22 08:31:15  AG01001918  2017-11-22 08:31:15  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
0120171100010  AG01001918 49 155    2017-11-22 08:31:02    2017-11-22 08:31:02  AG01001918  2017-11-22 08:31:02  AG01001918  View Edit Delete
0120171100009  AG01001918 49   2017-11-11 09:51:33    2017-11-11 09:51:33  AG01001918  2017-11-11 09:51:33  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
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

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

(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 ORDER BY `ExchangeLabelRollLog`.`insert_user` desc 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 = 1110