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
2649  02  51  192  サツマイモ(鳴門金時)    なるときんとき    2017-02-27 00:00:00            View Edit Delete
5465  02  53  95  農産物95    のうさんぶつ95    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6233  02  54  78867  農産物    のうさんぶつ    2018-05-25 00:00:00    2018-05-25 14:21:11  MG00000001  2018-05-25 14:21:11  MG00000001  View Edit Delete
7257  02  51  662  グァバ    ぐぁば    2018-11-27 00:00:00    2018-11-27 09:22:13  MG00000001  2018-11-27 09:22:13  MG00000001  View Edit Delete
7769  02  55  2904001  農産物    のうさんぶつ    2019-06-05 00:00:00    2019-06-05 14:07:31  MG00000001  2019-06-05 14:07:31  MG00000001  View Edit Delete
2650  02  51  193  大根    だいこん    2017-02-27 00:00:00            View Edit Delete
5466  02  53  96  農産物96    のうさんぶつ96    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6234  02  54  82465  農産物    のうさんぶつ    2018-05-25 00:00:00    2018-05-25 14:21:51  MG00000001  2018-05-25 14:21:51  MG00000001  View Edit Delete
7258  02  52  2126  農産物    のうさんぶつ    2018-11-27 00:00:00    2018-11-27 23:29:55  MG00000001  2018-11-27 23:29:55  MG00000001  View Edit Delete
2651  02  51  198  金時ニンジン    きんときにんじん    2017-02-27 00:00:00            View Edit Delete
5467  02  53  97  農産物97    のうさんぶつ97    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
7259  02  54  78492  農産物    のうさんぶつ    2018-11-27 00:00:00    2018-11-27 23:35:25  MG00000001  2018-11-27 23:35:25  MG00000001  View Edit Delete
2652  02  51  199  野菜(その他)    やさいそのた    2017-02-27 00:00:00            View Edit Delete
5468  02  53  98  農産物98    のうさんぶつ98    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6236  02  51  558  ロマネスコ    ろまねすこ    2018-05-28 00:00:00    2018-05-28 15:59:49  MG00000001  2018-05-28 15:59:49  MG00000001  View Edit Delete
7260  02  51  352  安納芋    あんのういも    2018-11-27 00:00:00    2018-11-27 23:42:48  MG00000001  2018-11-27 23:42:48  MG00000001  View Edit Delete
2653  02  51  204  メロン    めろん    2017-02-27 00:00:00            View Edit Delete
5469  02  53  99  農産物99    のうさんぶつ99    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6237  02  52  1893  農産物    のうさんぶつ    2018-05-31 00:00:00    2018-05-31 12:28:27  MG00000001  2018-05-31 12:28:27  MG00000001  View Edit Delete
2654  02  51  216  ぶどう    ぶどう    2017-02-27 00:00:00            View Edit Delete

Page 134 of 2156, showing 20 records out of 43118 total, starting on record 2661, ending on 2680

(default) 2 queries took 24 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` desc LIMIT 2660, 20202017
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117