Cmp Products

Id Trader Company Cd Co Product Cd Co Product Nm Co Product Reciept Nm Co Product Fk Limited User Use Start Day Use End Day Created Insert User Modified Update User Actions
134  01  001  80  いちじく    いちじく    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
135  01  001  81  ぶどう    ぶどう    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
136  01  001  82  梨    なし    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
137  01  001  83  柿    かき    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
138  01  001  84  栗    くり    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
139  01  001  85  野菜    やさい    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2018-05-28 17:29:36  MG00000001  View Edit Delete
140  01  001  86  果物    くだもの    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
141  01  001  87  フラワー    ふらわー    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
142  01  001  88  虫・魚    むし・さかな    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
143  01  001  89  お米    おこめ    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
144  01  001  90  干し柿    ほしがき    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
145  01  001  91  加工品    かこうひん    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
146  01  001  92  雑貨    ざっか    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
147  01  001  93  豆腐    とうふ    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
148  01  001  94  あげ    あげ    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
149  01  001  95  お茶    おちゃ    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
150  01  001  96  漬物    つけもの    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
151  01  001  97  餅    もち    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2019-02-25 16:36:41  MG00000001  View Edit Delete
152  01  001  98  菓子    かし    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
153  01  001  99  たまご    たまご    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete

Page 5 of 2156, showing 20 records out of 43118 total, starting on record 81, ending on 100

(default) 2 queries took 10 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `CmpProduct`.`id`, `CmpProduct`.`trader_id`, `CmpProduct`.`company_cd`, `CmpProduct`.`co_product_cd`, `CmpProduct`.`co_product_nm`, `CmpProduct`.`co_product_reciept_nm`, `CmpProduct`.`co_product_fk`, `CmpProduct`.`sys_product_cd`, `CmpProduct`.`farmer_linked_flag`, `CmpProduct`.`limited_user_id`, `CmpProduct`.`barcode_generate_pattern`, `CmpProduct`.`barcode_display_format`, `CmpProduct`.`use_start_day`, `CmpProduct`.`use_end_day`, `CmpProduct`.`created`, `CmpProduct`.`insert_user`, `CmpProduct`.`modified`, `CmpProduct`.`update_user` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1 ORDER BY `CmpProduct`.`trader_id` asc LIMIT 80, 2020201
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1119