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
7714  01  102  2400033508906   スナップエンドウ    すなっぷえんどう    2019-05-20 00:00:00            View Edit Delete
7970  03  62  51  農産物51    のうさんぶつ51    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8226  01  021  2027198566840  キウイ    きうい    2019-12-02 00:00:00    2019-12-02 14:45:28  MG00000001  2019-12-02 14:45:28  MG00000001  View Edit Delete
10274  01  002  20110443  野菜    やさい    2021-03-25 00:00:00    2021-03-25 10:25:47  MG00000005  2022-05-10 15:53:23  MG00000001  View Edit Delete
11042  06  661  00041  葉しょうが    はしょうが    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-10 14:03:22  MG00000001  View Edit Delete
11298  06  661  00299  カラー    からー    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11554  06  661  00555  もち米    もちごめ    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11810  06  661  00823  漬物    つけもの    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12066  06  661  01080  チコリ    ちこり    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12322  04  710  89679  農産物    のうさんぶつ    2022-06-23 00:00:00    2022-06-23 11:26:53  MG00000001  2022-06-23 11:26:53  MG00000001  View Edit Delete
12578  01  053  67439  農産物    のうさんぶつ    2022-07-29 00:00:00    2022-07-29 13:16:29  MG00000001  2022-07-29 13:16:29  MG00000001  View Edit Delete
12834  01  056  32815  農産物    のうさんぶつ    2022-08-22 00:00:00    2022-08-22 12:42:10  MG00000001  2022-08-22 12:42:10  MG00000001  View Edit Delete
13090  01  052  074644  農産物    のうさんぶつ    2022-07-20 00:00:00    2022-07-20 11:33:00  MG00000001  2022-07-20 11:33:00  MG00000001  View Edit Delete
13346  01  911  101012  農産物②    のうさんぶつ    2022-10-06 00:00:00    2022-10-06 14:58:38  MG00000001  2022-10-06 14:58:38  MG00000001  View Edit Delete
13602  01  911  102654  農産物⑨    のうさんぶつ    2022-10-06 00:00:00    2022-10-06 14:58:38  MG00000001  2022-10-06 14:58:38  MG00000001  View Edit Delete
13858  01  911  100157  農産物①    のうさんぶつ    2022-10-06 00:00:00    2022-10-06 14:58:38  MG00000001  2022-10-06 14:58:38  MG00000001  View Edit Delete
14114  01  911  103009  農産物11    のうさんぶつ    2022-10-19 00:00:00    2022-10-19 09:13:14  MG00000001  2022-10-19 09:13:14  MG00000001  View Edit Delete
14370  01  911  100915  農産物⑤    のうさんぶつ    2022-10-19 00:00:00    2022-10-19 09:13:14  MG00000001  2022-10-19 09:13:14  MG00000001  View Edit Delete
14626  01  063  646234  野菜    やさい    2022-10-20 00:00:00    2022-10-20 09:34:15  MG00000001  2022-10-20 09:34:15  MG00000001  View Edit Delete
14882  01  062  646085  野菜    やさい    2022-10-20 00:00:00    2022-10-20 10:21:26  MG00000001  2022-10-20 10:21:26  MG00000001  View Edit Delete

Page 288 of 2156, showing 20 records out of 43118 total, starting on record 5741, ending on 5760

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