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
47920  01  033  59339  59339_農産物  岡山農産09339  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 14:06:42  MG00000007  2023-10-19 14:06:42  MG00000007  View Edit Delete
50480  01  032  51397  13970_農産物    のうさんぶつ    2023-11-07 00:00:00    2023-11-07 13:34:38  MG00000007  2023-11-07 13:34:38  MG00000007  View Edit Delete
50992  01  036  105872  5872_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 10:34:46  MG00000007  2023-11-28 10:34:46  MG00000007  View Edit Delete
51504  01  033  50801  50801_農産物  岡山農産00801  のうさんぶつ    2024-01-19 00:00:00    2024-01-19 11:32:58  MG00000007  2024-01-19 11:32:58  MG00000007  View Edit Delete
305  01  002  20110291  野菜    やさい    2016-08-29 00:00:00    2016-08-30 12:24:40  MG00000001  2016-08-30 12:24:40  MG00000001  View Edit Delete
1073  01  005  12121  キャベツ 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
1585  01  007  6247  野菜  近郷野菜147  やさい    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2609  02  51  111  サツマイモ    さつまいも    2017-02-27 00:00:00            View Edit Delete
5169  07  81  47  農産物47    のうさんぶつ47    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5425  02  53  55  農産物55    のうさんぶつ55    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6193  02  51  144  メークイン    めーくいん    2018-04-20 00:00:00    2018-04-20 13:38:11  MG00000001  2018-04-20 13:38:11  MG00000001  View Edit Delete
6449  01  004  398735  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6705  01  002  20110613  野菜    やさい    2018-08-31 00:00:00    2018-08-31 10:13:12  MG00000001  2018-08-31 10:13:12  MG00000001  View Edit Delete
6961  08  96  742  パインアップル    ぱいんあっぷる    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7217  08  97  692  あまおう    あまおう    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7729  01  102  2400033509071   ブルーベリー    ぶるーべりー    2019-05-20 00:00:00            View Edit Delete
7985  03  62  66  農産物66    のうさんぶつ66    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8241  01  011  69210  農産物    のうさんぶつ    2019-12-26 00:00:00    2019-12-26 09:26:12  MG00000001  2019-12-26 09:26:12  MG00000001  View Edit Delete
8497  02  51  226  極早生みかん    ごくわせみかん    2020-06-19 00:00:00    2020-06-19 17:49:13  MG00000005  2020-06-19 17:49:13  MG00000005  View Edit Delete
12593  01  002  20905102  農産物③    のうさんぶつ    2022-08-02 00:00:00    2022-08-02 09:39:09  MG00000001  2022-08-02 09:39:09  MG00000001  View Edit Delete

Page 49 of 2156, showing 20 records out of 43118 total, starting on record 961, ending on 980

(default) 2 queries took 30 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 960, 20202021
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1119