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
7713  01  102  2400033508876   スナップエンドウ    すなっぷえんどう    2019-05-20 00:00:00            View Edit Delete
7969  03  62  50  農産物50    のうさんぶつ50    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8225  01  021  2027198566772  梅    うめ    2019-12-02 00:00:00    2019-12-02 14:45:02  MG00000001  2019-12-02 14:45:02  MG00000001  View Edit Delete
10273  01  002  20110321  野菜    やさい    2021-03-23 00:00:00    2021-03-23 16:47:35  MG00000005  2021-03-23 16:47:35  MG00000005  View Edit Delete
18465  08  96  359  干し椎茸    ほししいたけ    2022-12-22 00:00:00    2022-12-22 16:51:33  MG00000001  2022-12-22 16:51:33  MG00000001  View Edit Delete
47649  01  031  130401  130401_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 15:33:34  MG00000007  2023-10-03 15:33:34  MG00000007  View Edit Delete
47905  01  033  59324  59324_農産物  岡山農産09324  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:47:16  MG00000007  2023-10-19 13:47:16  MG00000007  View Edit Delete
50977  01  036  1058570  5857_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 10:00:55  MG00000007  2023-11-28 10:00:55  MG00000007  View Edit Delete
51489  01  033  50786  50786_農産物  岡山農産00786  のうさんぶつ    2024-01-19 00:00:00    2024-01-19 11:07:18  MG00000007  2024-01-19 11:07:18  MG00000007  View Edit Delete
34  01  001  34  人参    にんじん    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1058  01  005  11151  シシトウ 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
1570  01  007  6232  桃  近郷野菜132  やさい    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2594  01  006  7150  野菜  産直野菜150  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5154  07  81  32  農産物32    のうさんぶつ32    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5410  02  53  40  農産物40    のうさんぶつ40    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6178  08  93  496241001056  ズッキーニ    ずっきーに    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6434  01  004  398701  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6690  01  002  20110598  茄子    なす    2018-08-29 00:00:00    2018-08-29 14:53:03  MG00000001  2018-08-29 14:53:03  MG00000001  View Edit Delete
6946  08  96  694  やよいひめ    やよいひめ    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7202  08  97  645  プラム(貴陽)    ぷらむきよう    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete

Page 33 of 2156, showing 20 records out of 43118 total, starting on record 641, ending on 660

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