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
6814  08  96  158  なす    なす    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-26 14:35:21  MG00000001  View Edit Delete
7070  08  97  110  グリーンリーフレタス    ぐりーんりーふれたす    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 17:07:00  MG00000001  View Edit Delete
7326  01  101  2082891039596   トリコフルーツ 青果20  トリコフルーツ 青果20  とりこふるーつせいかにじゅう    2019-03-05 00:00:00    2019-03-05 00:00:00  MG00000001  2019-03-05 00:00:00  MG00000001  View Edit Delete
8350  01  002  20110323  野菜    やさい    2020-04-01 00:00:00    2020-04-01 10:16:13  MG00000001  2020-04-01 10:16:13  MG00000001  View Edit Delete
8606  01  002  20110441  赤玉葱    あかたまねぎ    2020-10-15 00:00:00    2020-10-15 15:48:42  MG00000005  2020-10-15 15:48:42  MG00000005  View Edit Delete
9118  01  011  68626  農産物    のうさんぶつ    2021-02-17 00:00:00    2021-02-17 14:36:03  MG00000005  2021-02-17 14:36:03  MG00000005  View Edit Delete
12190  01  110  102074  柑橘類(紅八朔)    かんきつるい    2022-06-06 00:00:00    2022-06-06 15:50:25  MG00000001  2022-06-06 15:50:25  MG00000001  View Edit Delete
18334  01  113  20904968  野菜    やさい    2022-11-18 00:00:00    2022-11-18 15:17:23  MG00000001  2022-11-24 15:02:04  MG00000001  View Edit Delete
49822  01  031  820612  820612_農産物12    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 14:35:00  MG00000007  2023-10-25 14:35:00  MG00000007  View Edit Delete
51102  01  033  51267  51267_農産物  岡山農産01267  のうさんぶつ    2023-12-07 00:00:00    2023-12-07 14:41:35  MG00000007  2023-12-07 14:41:35  MG00000007  View Edit Delete
1183  01  005  18131  ふき水煮 1P    ふきみずに1    2016-07-01 00:00:00    2016-08-30 12:24:45  MG00000001  2016-08-30 12:24:45  MG00000001  View Edit Delete
1439  01  007  6030  ミディトマト  近郷野菜31  みでぃとまと    2016-08-29 00:00:00    2016-08-30 12:24:46  MG00000001  2016-08-30 12:24:46  MG00000001  View Edit Delete
2463  01  006  7019  野菜  産直野菜19  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
2719  01  002  20110315  野菜    やさい    2017-02-28 00:00:00            View Edit Delete
3999  01  003  36  大根    だいこん    2017-03-15 00:00:00            View Edit Delete
5023  05  71  89638  農産物    のうさんぶつ    2017-11-01 00:00:00    2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete
5279  02  52  1684  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
5535  08  91  496241001040  米なす    べいなす    2018-03-02 00:00:00    2018-03-02 00:00:00  MG00000001  2018-03-02 09:21:23  MG00000001  View Edit Delete
6047  03  61  00  農産物00    のうさんぶつ00    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-08-31 18:50:15  MG00000001  View Edit Delete
6303  07  84  027402  農産物    のうさんぶつ    2018-06-26 00:00:00    2018-06-26 10:17:02  MG00000001  2018-06-26 10:17:02  MG00000001  View Edit Delete

Page 163 of 2156, showing 20 records out of 43118 total, starting on record 3241, ending on 3260

(default) 2 queries took 25 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 3240, 20202018
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117