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
2496  01  006  7052  野菜  産直野菜52  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
4032  01  003  69  みかん    みかん    2017-03-15 00:00:00            View Edit Delete
5056  05  71  89678  農産物    のうさんぶつ    2017-11-01 00:00:00    2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete
5312  02  52  1778  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
6080  03  61  33  農産物33    のうさんぶつ33    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
6336  09  101  38017  農産物    のうさんぶつ    2018-07-06 00:00:00    2018-07-06 10:26:41  MG00000001  2018-07-06 10:26:41  MG00000001  View Edit Delete
6848  08  96  260  じゃがいも(インカのめざめ)    じゃがいもいんかのめざめ    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7104  08  97  175  へちま    へちま    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7360  01  101  2082891040356   トリコフルーツ 青果54  トリコフルーツ 青果54  とりこふるーつせいかごじゅうし    2019-03-05 00:00:00    2019-03-05 00:00:00  MG00000001  2019-03-05 00:00:00  MG00000001  View Edit Delete
8128  01  021  2027198565928  ジャガイモ    じゃがいも    2019-11-14 00:00:00    2019-11-14 14:38:41  MG00000001  2019-11-14 14:38:41  MG00000001  View Edit Delete
9152  02  56  32  農産物32    のうさんぶつ32    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
12224  01  002  20110027  ミニトマト袋    みにとまとふくろ    2022-06-13 00:00:00    2022-06-13 11:09:26  MG00000001  2022-06-13 11:09:26  MG00000001  View Edit Delete
18368  01  002  20905264  レタス    れたす    2022-11-28 00:00:00    2022-11-28 12:21:14  MG00000001  2022-11-28 12:21:14  MG00000001  View Edit Delete
47552  01  033  57769  57769_農産物  岡山農産07769  のうさんぶつ    2023-09-28 00:00:00    2023-09-28 13:54:14  MG00000007  2023-09-28 13:54:14  MG00000007  View Edit Delete
47808  01  033  59228  59228_農産物  岡山農産09228  のうさんぶつ    2023-10-17 00:00:00    2023-10-17 17:38:13  MG00000007  2023-10-17 17:38:13  MG00000007  View Edit Delete
50624  01  036  109133  農産物5_9133    のうさんぶつ    2023-11-13 00:00:00    2023-11-13 17:22:41  MG00000007  2023-11-13 17:22:41  MG00000007  View Edit Delete
51392  01  034  80663  06630_農産物    のうさんぶつ    2023-12-22 00:00:00    2023-12-22 15:19:56  MG00000007  2023-12-22 15:19:56  MG00000007  View Edit Delete
961  01  003  457122595530  京の野菜ジャム京甘藷(紫)    きょうのやさいじゃむきょうかんしょむらさき    2016-08-29 00:00:00    2016-08-30 12:24:43  MG00000001  2016-08-30 12:24:43  MG00000001  View Edit Delete
1217  01  005  21071  ブドウ 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
2497  01  006  7053  野菜  産直野菜53  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete

Page 201 of 2156, showing 20 records out of 43118 total, starting on record 4001, ending on 4020

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