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
137  33028  01 20 33  秋山(センター)  あきやませんたー  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
138  33030  01 20 33  笠岡干拓(直納)  ささおかかんたく  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
142  33032  01 20 33  HF佐々木(センター)  えいちえふささきせんたー  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
143  33033  01 20 33  HFアグリA(センター)  えいちえふあぐりえーせんたー  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
156  33034  01 20 33  農愛会(市川センター)  のうあいかい  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
158  33035  01 20 33  HFループ(センター)  えいちえふるーぷ  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
159  33036  01 20 33  HF木村(センター)  えいちえふきむら  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
162  33013  01 20 33  山根(直納)  やまねちょくのう  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
163  33037  01 20 33  おかやま青果_250  おかやませいか  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
164  33039  01 20 33  おかやま青果_300  おかやませいか  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
165  33038  01 20 33  おかやま青果_280  おかやませいか  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
172  33041  01 20 33  明治ごんぼう村(直納)A  めいじごんぼうむら  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
173  33042  01 20 33  明治ごんぼう村(直納)B  めいじごんぼうむら  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
174  33043  01 20 33  明治ごんぼう村(センター)A  めいじごんぼうむら  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
175  33044  01 20 33  明治ごんぼう村(センター)B  めいじごんぼうむら  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
176  33047  01 20 33  まび農産物生産組合A  まびのうさんぶつせいさんくみあい  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
177  33048  01 20 33  まび農産物生産組合B  まびのうさんぶつせいさんくみあい  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
178  31001  01 20 33  Palfo A  ぱるふぉ  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
179  31002  01 20 33  Palfo B  ぱるふぉ  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
180  33049  01 20 33  はなやか東A  はなやかひがし  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete

Page 7 of 8, showing 20 records out of 158 total, starting on record 121, ending on 140

(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 120, 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