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
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
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
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
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
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
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
0120170300002  AG01001739 48   2017-03-10 12:50:17    2017-03-10 12:50:17  AG01001739  2017-03-10 12:50:17  AG01001739  View Edit Delete
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
0120170500006  AG01001264 48   2017-05-19 15:53:04    2017-05-19 15:53:04  AG01001264  2017-05-19 15:53:04  AG01001264  View Edit Delete
0120170500007  AG01001264 48   2017-05-19 15:53:10    2017-05-19 15:53:10  AG01001264  2017-05-19 15:53:10  AG01001264  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
0120230300001  AG01003920 48 178    2023-03-29 14:31:31    2023-03-29 14:31:31  AG01003920  2023-03-29 14:31:31  AG01003920  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
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
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
0120200200001  AG01001269 48   2020-02-05 14:12:32    2020-02-05 14:12:32  AG01001269  2020-02-05 14:12:32  AG01001269  View Edit Delete
0120170300001  AG01001739 48   2017-03-07 13:18:46    2017-03-07 13:18:46  AG01001739  2017-03-07 13:18:46  AG01001739  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

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

(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`.`pickup_point_id` desc LIMIT 40, 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