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
2669  02  51  272  キウイ    きうい    2017-02-27 00:00:00            View Edit Delete
5485  02  54  76988  農産物    のうさんぶつ    2018-03-05 00:00:00    2018-03-05 00:00:00  MG00000001  2018-03-05 00:00:00  MG00000001  View Edit Delete
7021  02  51  706  しめじ    しめじ    2018-10-24 00:00:00    2018-10-24 10:36:49  MG00000001  2018-10-24 10:36:49  MG00000001  View Edit Delete
7277  02  52  2138  農産物    のうさんぶつ    2018-12-19 00:00:00    2018-12-19 13:38:09  MG00000001  2018-12-19 13:38:09  MG00000001  View Edit Delete
2670  02  51  299  果物(その他)    くだものそのた    2017-02-27 00:00:00            View Edit Delete
5486  02  52  1696  農産物    のうさんぶつ    2018-03-05 00:00:00    2018-03-05 00:00:00  MG00000001  2018-03-05 00:00:00  MG00000001  View Edit Delete
7278  02  54  44407  農産物    のうさんぶつ    2018-12-19 00:00:00    2018-12-19 14:24:54  MG00000001  2018-12-19 14:24:54  MG00000001  View Edit Delete
2671  02  51  503  菊菜    きくな    2017-02-27 00:00:00            View Edit Delete
5231  02  51  512  白ネギ    しろねぎ    2018-01-16 00:00:00    2018-01-16 11:34:46  MG00000001  2018-01-16 11:34:46  MG00000001  View Edit Delete
5487  02  52  1790  農産物    のうさんぶつ    2018-03-05 00:00:00    2018-03-05 00:00:00  MG00000001  2018-03-05 00:00:00  MG00000001  View Edit Delete
7279  02  54  44458  農産物    のうさんぶつ    2018-12-20 00:00:00    2018-12-20 13:45:21  MG00000001  2018-12-20 13:45:21  MG00000001  View Edit Delete
2672  02  51  508  ラディッシュ    らでぃっしゅ    2017-02-27 00:00:00            View Edit Delete
5232  02  51  123  太ネギ    ふとねぎ    2018-01-16 00:00:00    2018-01-16 11:34:46  MG00000001  2018-01-16 11:34:46  MG00000001  View Edit Delete
5488  02  52  1791  農産物    のうさんぶつ    2018-03-05 00:00:00    2018-03-05 00:00:00  MG00000001  2018-03-05 00:00:00  MG00000001  View Edit Delete
7280  02  52  2140  農産物    のうさんぶつ    2018-12-25 00:00:00    2018-12-25 11:30:35  MG00000001  2018-12-25 11:30:35  MG00000001  View Edit Delete
2673  02  51  516  タケノコ    たけのこ    2017-02-27 00:00:00            View Edit Delete
5489  02  52  1798  農産物    のうさんぶつ    2018-03-05 00:00:00    2018-03-05 00:00:00  MG00000001  2018-03-05 00:00:00  MG00000001  View Edit Delete
7281  02  54  44431  農産物    のうさんぶつ    2018-12-25 00:00:00    2018-12-25 11:30:59  MG00000001  2018-12-25 11:30:59  MG00000001  View Edit Delete
12401  02  52  3131  農産物    のうさんぶつ    2022-06-30 00:00:00    2022-06-30 09:29:37  MG00000001  2022-06-30 09:29:37  MG00000001  View Edit Delete
2674  02  51  519  スナップエンドウ    すなっぷえんどう    2017-02-27 00:00:00            View Edit Delete

Page 138 of 2156, showing 20 records out of 43118 total, starting on record 2741, ending on 2760

(default) 2 queries took 27 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 2740, 20202020
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117