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
18353  01  113  20904943  野菜    やさい    2022-11-24 00:00:00    2022-11-24 14:46:34  MG00000001  2022-11-24 14:46:34  MG00000001  View Edit Delete
46769  01  031  513720  513720_農産物6    のうさんぶつ    2023-09-14 00:00:00    2023-09-14 11:31:11  MG00000001  2023-09-14 11:31:11  MG00000001  View Edit Delete
47537  01  033  57754  57754_農産物  岡山農産07754  のうさんぶつ    2023-09-28 00:00:00    2023-09-28 13:33:45  MG00000007  2023-09-28 13:33:45  MG00000007  View Edit Delete
47793  01  033  59213  59213_農産物  岡山農産09213  のうさんぶつ    2023-10-17 00:00:00    2023-10-17 17:14:28  MG00000007  2023-10-17 17:14:28  MG00000007  View Edit Delete
49841  01  032  85729  85729_野菜    のうさんぶつ    2023-10-26 00:00:00    2023-10-26 11:52:02  MG00000007  2023-10-26 11:52:02  MG00000007  View Edit Delete
50609  01  036  105759  農産物5_5759    のうさんぶつ    2023-11-13 00:00:00    2023-11-13 16:51:33  MG00000007  2023-11-13 16:51:33  MG00000007  View Edit Delete
51121  01  033  51896  51896_農産物  岡山農産01896  のうさんぶつ    2023-12-07 00:00:00    2023-12-07 15:50:47  MG00000007  2023-12-07 15:50:47  MG00000007  View Edit Delete
51377  01  036  105908  2510590800000_農産物    のうさんぶつ    2023-12-22 00:00:00    2023-12-22 14:53:03  MG00000007  2023-12-22 14:53:03  MG00000007  View Edit Delete
946  01  003  456230629001  おつけもんとカレーどす    おつけもんとかれーどす    2016-08-29 00:00:00    2016-08-30 12:24:43  MG00000001  2016-08-30 12:24:43  MG00000001  View Edit Delete
1202  01  005  21024  桃 パック    ももぱっく    2016-07-01 00:00:00    2016-08-30 12:24:45  MG00000001  2016-08-30 12:24:45  MG00000001  View Edit Delete
1458  01  007  6049  いんげん  近郷野菜50  いんげん    2016-08-29 00:00:00    2016-08-30 12:24:46  MG00000001  2016-08-30 12:24:46  MG00000001  View Edit Delete
1714  01  007  6376  祝蕾  近郷野菜276  しゅくらい    2016-08-29 00:00:00    2016-08-30 12:24:48  MG00000001  2016-08-30 12:24:48  MG00000001  View Edit Delete
2482  01  006  7038  野菜  産直野菜38  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
2738  01  002  20110334  野菜    やさい    2017-02-28 00:00:00            View Edit Delete
4018  01  003  55  ぶなしめじ    ぶなしめじ    2017-03-15 00:00:00            View Edit Delete
5042  05  71  89662  農産物    のうさんぶつ    2017-11-01 00:00:00    2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete
5298  02  52  1722  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
5554  02  54  78425  農産物    のうさんぶつ    2018-03-15 00:00:00    2018-03-15 00:00:00  MG00000001  2018-03-15 00:00:00  MG00000001  View Edit Delete
6066  03  61  19  農産物19    のうさんぶつ19    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
6322  08  94  040020390751  カボチャ (栗五郎) S    かぼちゃくりごろうえす    2018-06-29 00:00:00    2018-06-29 14:54:17  MG00000001  2018-06-29 14:54:17  MG00000001  View Edit Delete

Page 185 of 2156, showing 20 records out of 43118 total, starting on record 3681, ending on 3700

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