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
7200  08  97  643  大石すもも    おおいしすもも    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7712  01  102  2400033508869   春菊    しゅんぎく    2019-05-20 00:00:00            View Edit Delete
7968  03  62  49  農産物49    のうさんぶつ49    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8480  05  71  89974  農産物    のうさんぶつ    2020-05-28 00:00:00    2020-05-28 09:06:54  MG00000001  2020-05-28 09:06:54  MG00000001  View Edit Delete
18464  01  006  7176  野菜  産直野菜176  やさい    2022-12-21 00:00:00    2022-12-21 11:03:38  MG00000001  2022-12-21 11:03:38  MG00000001  View Edit Delete
47648  01  031  151001  151001_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 15:29:48  MG00000007  2023-10-03 15:29:48  MG00000007  View Edit Delete
47904  01  033  59323  59323_農産物  岡山農産09323  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:45:52  MG00000007  2023-10-19 13:45:52  MG00000007  View Edit Delete
50976  01  036  105856  5856_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 09:51:54  MG00000007  2023-11-28 09:51:54  MG00000007  View Edit Delete
51488  01  033  50785  50785_農産物  岡山農産00785  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:58:03  MG00000007  2024-01-18 17:58:03  MG00000007  View Edit Delete
33  01  001  33  ごぼう    ごぼう    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1057  01  005  11141  オクラ 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
1569  01  007  6231  しめじ  近郷野菜131  やさい    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2593  01  006  7149  野菜  産直野菜149  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5153  07  81  31  農産物31    のうさんぶつ31    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5409  02  53  39  農産物39    のうさんぶつ39    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6177  08  93  496241001055  オクラ    おくら    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6433  01  004  398363  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6689  01  005  02111  野菜    やさい    2018-08-28 00:00:00    2018-08-28 09:12:36  MG00000001  2018-08-28 09:12:36  MG00000001  View Edit Delete
6945  08  96  693  あきひめ    あきひめ    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7201  08  97  644  プラム(ソルダム)    ぷらむそるだむ    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete

Page 32 of 2156, showing 20 records out of 43118 total, starting on record 621, ending on 640

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