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
5034  05  71  89651  農産物    のうさんぶつ    2017-11-01 00:00:00    2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete
5290  02  52  1695  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
5546  02  52  1837  農産物    のうさんぶつ    2018-03-09 00:00:00    2018-03-05 00:00:00  MG00000001  2018-03-05 00:00:00  MG00000001  View Edit Delete
6058  03  61  11  農産物11    のうさんぶつ11    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
6314  08  94  040020390670  じゃがいも (キタアカリ) LM    じゃがいもきたあかりえるえむ    2018-06-29 00:00:00    2018-06-29 14:54:17  MG00000001  2018-06-29 14:54:17  MG00000001  View Edit Delete
6826  08  96  170  ピーマン    ぴーまん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-26 14:40:36  MG00000001  View Edit Delete
7082  08  97  153  カボチャ(九重栗)    かぼちゃここのえくり    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-26 14:34:00  MG00000001  View Edit Delete
7338  01  101  2082891040134   トリコフルーツ 青果32  トリコフルーツ 青果32  とりこふるーつせいかさんじゅうに    2019-03-05 00:00:00    2019-03-05 00:00:00  MG00000001  2019-03-05 00:00:00  MG00000001  View Edit Delete
9130  02  56  10  農産物10    のうさんぶつ10    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
10922  01  004  499251  果実    かじつ    2021-12-03 00:00:00    2021-12-03 10:08:42  MG00000001  2021-12-03 10:08:42  MG00000001  View Edit Delete
12202  01  110  102566  小玉すいか(うり坊)    こだますいか    2022-06-06 00:00:00    2022-06-06 15:50:25  MG00000001  2022-06-06 15:50:25  MG00000001  View Edit Delete
18346  01  002  20110594  野菜    やさい    2022-11-21 00:00:00    2022-11-21 10:36:38  MG00000001  2022-11-21 10:36:38  MG00000001  View Edit Delete
46762  01  114  12770  2770_農産物1    のうさんぶつ    2023-09-12 00:00:00    2023-09-12 09:52:09  MG00000001  2023-09-12 09:52:09  MG00000001  View Edit Delete
47530  01  033  57747  57747_農産物  岡山農産07747  のうさんぶつ    2023-09-28 00:00:00    2023-09-28 13:19:51  MG00000007  2023-09-28 13:19:51  MG00000007  View Edit Delete
49834  01  031  820624  820624_農産物24    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 15:57:21  MG00000007  2023-10-25 15:57:21  MG00000007  View Edit Delete
50602  01  036  105752  農産物5_5752    のうさんぶつ    2023-11-13 00:00:00    2023-11-13 16:37:15  MG00000007  2023-11-13 16:37:15  MG00000007  View Edit Delete
51114  01  033  51889  51889_農産物  岡山農産01889  のうさんぶつ    2023-12-07 00:00:00    2023-12-07 15:40:22  MG00000007  2023-12-07 15:40:22  MG00000007  View Edit Delete
51370  01  036  105913  2510591300000_農産物    のうさんぶつ    2023-12-22 00:00:00    2023-12-22 14:43:53  MG00000007  2023-12-22 14:43:53  MG00000007  View Edit Delete
1195  01  005  18251  筑前煮 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
2475  01  006  7031  小松菜  産直野菜31  こまつな    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001  2022-02-01 09:55:48  MG00000001  View Edit Delete

Page 176 of 2156, showing 20 records out of 43118 total, starting on record 3501, ending on 3520

(default) 2 queries took 27 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 3500, 20202019
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1118