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
157  26006  01 5 26  IZ六地蔵店  いずみやむじぞう  2022-07-20 10:09:11    2000  1000  2000            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
160  27010  01 6 27  IZ桑津店  いずみやくわつてん  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete
161  27011  01 6 27  箕面市  みのおし  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
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
169  27013  01 6 27  枚方穂谷  まいかたほたに  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
170  27017  01 6 27  泉南GF(大阪)  せんなん  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
171  27014  01 6 27  和泉市A  いずみし  2019-04-18 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

Page 3 of 8, showing 20 records out of 158 total, starting on record 41, ending on 60

(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`.`inventory_date` asc LIMIT 40, 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