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
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
107  41001  01 21 41  白石町  しらいしちょう  2019-11-11 16:40:56    2000  1000  2000            View Edit Delete
106  42009  01 10 42  山野  やまの  2019-11-06 16:00:59    2000  1000  2000            View Edit Delete
124  42101  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
125  42107  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
126  42103  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
130  42104  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
144  00001  01 10 42  西鉄ストア果実  にしてつすとあかじつ  2022-05-09 08:36:55    2000  1000  2000            View Edit Delete
146  42111  01 10 42  サンチョク  さんちょく  2022-07-20 10:09:11    2000  1000  2000            View Edit Delete
149  42112  01 10 42  きばる(サンチョク)  きばるさんちょく  2022-07-20 10:09:11    2000  1000  2000            View Edit Delete
152  42100  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
153  42102  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
154  42106  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
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
187  41002  01 21 42  あんくる佐賀  あんくるふくおか  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
114  44101  01 22 44  豊後大野(きばる)  ぶんごおおのきばる  2021-01-15 00:00:00    2000  1000  2000  2021-01-15 12:23:16  2021-01-15 12:23:37  MG00000005      View Edit Delete

Page 8 of 8, showing 18 records out of 158 total, starting on record 141, ending on 158

(default) 2 queries took 3 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_cd` asc LIMIT 140, 2018182
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