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
182  33052  01 20 33  高島支部A  たかしましぶ  2019-04-18 00:00:00    2000  1000  2000            View Edit Delete
181  33050  01 20 33  はなやか東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
179  31002  01 20 33  Palfo 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
177  33048  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
175  33044  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
173  33042  01 20 33  明治ごんぼう村(直納)B  めいじごんぼうむら  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
171  27014  01 6 27  和泉市A  いずみし  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
169  27013  01 6 27  枚方穂谷  まいかたほたに  2019-04-18 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
167  40005  01 11 40  コウヨウ(集荷)  こうようしゅうか  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
165  33038  01 20 33  おかやま青果_280  おかやませいか  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
163  33037  01 20 33  おかやま青果_250  おかやませいか  2021-07-08 00:00:00    2000  1000  2000            View Edit Delete

Page 2 of 8, showing 20 records out of 158 total, starting on record 21, ending on 40

(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`.`id` desc LIMIT 20, 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