Pickup Points

Id Pickup Point Cd Trader Locality Locality Cd Pickup Point Nm Pickup Point Fk Use Start Day Use End Day Remain Label Roll Threshold Label Roll Inventory Label Roll Inventory Date Created Insert User Modified Update User Actions
155  42108  01 10 42  有家(きばる)  ありいえきばる  2021-01-20 00:00:00    2000  1000  2000  2021-01-18 12:23:16  2021-01-18 14:03:51  MG00000001      View Edit Delete
84  40001  01 11 40  須恵  すえ  2016-07-01 00:00:00    2000  1000  2000  2017-04-18 13:36:00  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
105  40002  01 11 40  久留米  くるめ  2019-11-05 16:13:51    2000  1000  2000            View Edit Delete
112  40003  01 11 40  宮若市  みやわかし  2019-11-05 16:13:51    2000  1000  2000            View Edit Delete
166  40004  01 11 40  ゼンキョウ店舗持込  ぜんきょうてんぽもちこみ  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
167  40005  01 11 40  コウヨウ(集荷)  こうようしゅうか  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
168  40006  01 11 40  コクヨウ(持込)  こくようもちこみ  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
186  40008  01 11 40  あんくる福岡  あんくるふくおか  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
90  43001  01 12 43  山都町  やまとちょう  2017-10-30 09:57:55    2000  1000  2000            View Edit Delete
86  SR01  03 13 20  駿河屋魚一  するがやうおいち  2017-05-11 00:00:00    2000  1000  2000  2017-05-11 00:00:00          View Edit Delete
80  MZ01  02 14 36  南風ベジタブル  まぜべじたぶる  2017-02-22 00:00:00    2000  1000  2000  2017-02-22 00:00:00          View Edit Delete
91  OK01  05 15 15  奥村商事  おくむらしょうじ  2017-11-01 13:11:02    2000  1000  2000            View Edit Delete
145  OK02  04 15 15  奥村商事  おくむらしょうじ  2017-11-01 13:11:02    2000  1000  2000            View Edit Delete
92  AM01  07 16 28  山陽Amnak  さんようあむなっく  2017-12-22 13:11:02    2000  1000  2000            View Edit Delete
93  ARA01  08 17 14  荒井ベジアス  あらいべじあす  2018-03-08 17:02:00    2000  1000  2000  2018-03-08 17:02:14  2018-03-08 17:02:19  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
94  NR01  09 18 37  日本農産流通株式会社  にほんのうさんりゅうつうかぶしきがいしゃ  2018-06-15 00:00:00    2000  1000  2000  2018-06-15 17:17:12  2018-06-15 17:17:23    2018-06-15 17:17:26    View Edit Delete
96  06001  01 19 06  山形市  やまがたし  2018-11-27 22:54:34    2000  1000  2000            View Edit Delete
97  33002  01 20 33  富谷選果場  とみたにせんかじょう  2019-04-09 00:00:00    2000  1000  2000            View Edit Delete
98  33003  01 20 33  はなやか西  はなやかにし  2019-04-10 00:00:00    2000  1000  2000            View Edit Delete
100  33001  01 20 33  JA岡山  じぇいえーおかやま  2019-05-16 08:54:19    2000  1000  2000            View Edit Delete

Page 5 of 8, showing 20 records out of 158 total, starting on record 81, ending on 100

(default) 2 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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`, `Trader`.`id`, `Trader`.`formal_trader_nm`, `Trader`.`formal_trader_fk`, `Trader`.`designation_file`, `Trader`.`use_start_day`, `Trader`.`use_end_day`, `Trader`.`margin_price_yen`, `Trader`.`created`, `Trader`.`insert_user`, `Trader`.`modified`, `Trader`.`update_user`, `Locality`.`id`, `Locality`.`trader_id`, `Locality`.`locality_cd`, `Locality`.`locality_nm`, `Locality`.`use_start_day`, `Locality`.`use_end_day`, `Locality`.`created`, `Locality`.`insert_user`, `Locality`.`modified`, `Locality`.`update_user` FROM `sato_agri`.`pickup_points` AS `PickupPoint` LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`PickupPoint`.`trader_id` = `Trader`.`id`) LEFT JOIN `sato_agri`.`localities` AS `Locality` ON (`PickupPoint`.`locality_id` = `Locality`.`id`) WHERE 1 = 1 ORDER BY `PickupPoint`.`locality_id` asc LIMIT 80, 2020201
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`pickup_points` AS `PickupPoint` LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`PickupPoint`.`trader_id` = `Trader`.`id`) LEFT JOIN `sato_agri`.`localities` AS `Locality` ON (`PickupPoint`.`locality_id` = `Locality`.`id`) WHERE 1 = 1111