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
49700  01  036  105608  5608_農産物    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 00:00:00  MG00000001  2023-10-25 00:00:00  MG00000001  View Edit Delete
49956  01  036  105690  5690_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50212  01  033  58241  8241_農産物  広島農産08241  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50468  01  033  58462  8462_農産物  広島農産08462  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50724  01  033  51862  51862_農産物  岡山農産01862  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50980  01  036  105860  5860_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 10:06:44  MG00000007  2023-11-28 10:06:44  MG00000007  View Edit Delete
51236  01  031  696921  696921_農産物21    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51492  01  033  50789  50789_農産物  岡山農産00789  のうさんぶつ    2024-01-19 00:00:00    2024-01-19 11:11:15  MG00000007  2024-01-19 11:11:15  MG00000007  View Edit Delete
37  01  001  37  オクラ    おくら    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1061  01  005  11164  とうもろこし パック    とうもろこしぱっく    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
2597  01  006  7153  野菜  産直野菜153  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
4133  01  006  7227  野菜  産直野菜227  やさい    2016-08-29 00:00:00    2017-10-20 19:37:34  MG00000001  2017-10-20 19:37:34  MG00000001  View Edit Delete
5157  07  81  35  農産物35    のうさんぶつ35    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5413  02  53  43  農産物43    のうさんぶつ43    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6181  08  93  496241001059  カブ    かぶ    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6437  01  004  398713  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6693  01  002  20110601  胡瓜    きゅうり    2018-08-29 00:00:00    2018-08-29 16:13:35  MG00000001  2018-08-29 16:13:35  MG00000001  View Edit Delete
6949  08  96  712  夕張メロン    ゆうばりめろん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7205  08  97  661  さくらんぼ    さくらんぼ    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 16:13:00  MG00000001  View Edit Delete
7717  01  102  2400033508937   りんご    りんご    2019-05-20 00:00:00            View Edit Delete

Page 312 of 2156, showing 20 records out of 43118 total, starting on record 6221, ending on 6240

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