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
7978  03  62  59  農産物59    のうさんぶつ59    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8234  02  51  353  春キャベツ    はるきゃべつ    2019-12-10 00:00:00    2019-12-10 14:56:19  MG00000001  2019-12-10 14:56:19  MG00000001  View Edit Delete
10794  02  51  110  坊ちゃんかぼちゃ    ぼっちゃんかぼちゃ    2021-08-18 00:00:00    2021-08-18 11:30:51  MG00000001  2021-08-18 11:30:51  MG00000001  View Edit Delete
12586  01  002  20905115  農産物⑥    のうさんぶつ    2022-08-02 00:00:00    2022-08-02 09:31:03  MG00000001  2022-08-02 09:31:03  MG00000001  View Edit Delete
18474  01  002  20110806  野菜    やさい    2022-12-28 00:00:00    2022-12-28 09:39:37  MG00000001  2022-12-28 09:39:37  MG00000001  View Edit Delete
45098  01  033  51660  51660_農産物  岡山農産01660  のうさんぶつ    2023-07-25 00:00:00    2023-07-25 12:19:35  MG00000001  2023-07-25 12:19:35  MG00000001  View Edit Delete
46122  01  033  51671  51671_農産物  岡山農産01671  のうさんぶつ    2023-08-21 00:00:00    2023-08-21 13:42:45  MG00000001  2023-08-21 13:42:45  MG00000001  View Edit Delete
47658  01  031  100015  100015_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:01:53  MG00000007  2023-10-03 16:01:53  MG00000007  View Edit Delete
47914  01  033  59333  59333_農産物  岡山農産09333  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:58:09  MG00000007  2023-10-19 13:58:09  MG00000007  View Edit Delete
50986  01  036  105866  5866_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 10:15:38  MG00000007  2023-11-28 10:15:38  MG00000007  View Edit Delete
51498  01  033  50795  50795_農産物  岡山農産00795  のうさんぶつ    2024-01-19 00:00:00    2024-01-19 11:26:06  MG00000007  2024-01-19 11:26:06  MG00000007  View Edit Delete
43  01  001  43  にんにく    にんにく    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1067  01  005  12061  レタス 1P    れたす1    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
2603  02  51  103  ヨウサイ(空芯菜)    ようさいくうしんさい    2017-02-27 00:00:00        2020-04-24 10:41:05  MG00000001  View Edit Delete
5163  07  81  41  農産物41    のうさんぶつ41    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5419  02  53  49  農産物49    のうさんぶつ49    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6187  01  007  6000  小松菜  近郷野菜1  こまつな    2018-04-18 00:00:00    2018-04-18 12:24:48  MG00000001  2018-04-18 12:24:48  MG00000001  View Edit Delete
6443  01  004  398724  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6699  01  002  20110607  野菜    やさい    2018-08-31 00:00:00    2018-08-31 09:53:20  MG00000001  2020-06-16 10:46:35  MG00000005  View Edit Delete
6955  08  96  718  プリンスメロン    ぷりんすめろん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete

Page 42 of 2156, showing 20 records out of 43118 total, starting on record 821, ending on 840

(default) 2 queries took 26 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`.`limited_user_id` asc LIMIT 820, 20202018
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1118