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
4057  01  003  97  餅    もち    2017-03-15 00:00:00        2019-02-25 16:37:05  MG00000001  View Edit Delete
5081  05  71  89705  農産物    のうさんぶつ    2017-11-01 00:00:00    2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete
5337  02  54  78026  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
6105  03  61  58  農産物58    のうさんぶつ58    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
6361  09  101  38050  農産物    のうさんぶつ    2018-07-06 00:00:00    2018-07-06 11:12:12  MG00000001  2018-07-06 11:12:12  MG00000001  View Edit Delete
6873  08  96  351  生しいたけ    なましいたけ    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7129  08  97  268  ゆりね    ゆりね    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7385  01  101  2082891040608   トリコフルーツ 青果79  トリコフルーツ 青果79  とりこふるーつせいかななじゅうく    2019-03-05 00:00:00    2019-03-05 00:00:00  MG00000001  2019-03-05 00:00:00  MG00000001  View Edit Delete
8153  01  021  2027198567830  農産物④    のうさんぶつよん    2019-11-20 00:00:00    2019-11-20 10:26:00  MG00000001  2019-11-20 10:26:00  MG00000001  View Edit Delete
8409  08  96  522  はるみ    はるみ    2020-04-20 00:00:00    2020-04-20 11:14:58  MG00000001  2020-04-20 11:14:58  MG00000001  View Edit Delete
9177  02  56  57  農産物57    のうさんぶつ57    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
12249  01  002  20110008  しめじ    しめじ    2022-06-22 00:00:00    2022-06-22 10:39:17  MG00000001  2022-06-22 10:39:17  MG00000001  View Edit Delete
18393  01  002  20110774  野菜    やさい    2022-12-07 00:00:00    2022-12-07 08:14:17  MG00000001  2022-12-07 08:14:17  MG00000001  View Edit Delete
43481  01  113  20904984  4984_農産物01    のうさんぶつ    2023-06-13 00:00:00    2023-06-13 13:02:27  MG00000001  2023-06-13 13:02:27  MG00000001  View Edit Delete
47577  01  033  57795  57795_農産物  岡山農産07795  のうさんぶつ    2023-09-28 00:00:00    2023-09-28 14:26:15  MG00000007  2023-09-28 14:26:15  MG00000007  View Edit Delete
47833  01  033  59253  59253_農産物  岡山農産09253  のうさんぶつ    2023-10-18 00:00:00    2023-10-18 10:16:58  MG00000007  2023-10-18 10:16:58  MG00000007  View Edit Delete
50649  01  036  109111  農産物5_9111    のうさんぶつ    2023-11-14 00:00:00    2023-11-14 10:08:48  MG00000007  2023-11-14 10:08:48  MG00000007  View Edit Delete
51417  01  033  58900  58900_農産物  岡山農産08900  のうさんぶつ    2023-12-26 00:00:00    2023-12-26 10:42:56  MG00000007  2023-12-26 10:42:56  MG00000007  View Edit Delete
474  01  002  20120157  果実    かじつ    2016-08-29 00:00:00    2016-08-30 12:24:41  MG00000001  2022-05-10 15:53:45  MG00000001  View Edit Delete
986  01  003  458994935011  甘恋トマトケチャップトマトパスタソース(青)    あまこいとまとけちゃっぷとまとぱすたそーすあお    2016-08-29 00:00:00    2016-08-30 12:24:43  MG00000001  2016-08-30 12:24:43  MG00000001  View Edit Delete

Page 229 of 2156, showing 20 records out of 43118 total, starting on record 4561, ending on 4580

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