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
1463  01  007  6054  ピーマン  近郷野菜55  ぴーまん    2016-08-29 00:00:00    2016-08-30 12:24:46  MG00000001  2016-08-30 12:24:46  MG00000001  View Edit Delete
2231  01  009  13530  野菜    やさい    2016-07-01 00:00:00  2016-07-31 00:00:00  2016-08-30 12:24:51  MG00000001  2016-08-30 12:24:51  MG00000001  View Edit Delete
2487  01  006  7043  野菜  産直野菜43  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
4023  01  003  60  むかご    むかご    2017-03-15 00:00:00            View Edit Delete
5047  05  71  89669  農産物    のうさんぶつ    2017-11-01 00:00:00    2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete
5303  02  52  1734  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
6071  03  61  24  農産物24    のうさんぶつ24    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
6839  08  96  251  さつまいも    さつまいも    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7095  08  97  166  フルーツトマト    ふるーつとまと    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-26 14:37:00  MG00000001  View Edit Delete
7351  01  101  2082891040264   トリコフルーツ 青果45  トリコフルーツ 青果45  とりこふるーつせいかよんじゅうご    2019-03-05 00:00:00    2019-03-05 00:00:00  MG00000001  2019-03-05 00:00:00  MG00000001  View Edit Delete
7607  01  002  20904942  野菜    やさい    2019-04-18 00:00:00    2019-04-18 09:59:40  MG00000001  2019-04-24 11:12:00  MG00000001  View Edit Delete
8119  01  021  2027198564488  ブロッコリー    ぶろっこりー    2019-11-14 00:00:00    2019-11-14 14:28:29  MG00000001  2019-11-14 14:28:29  MG00000001  View Edit Delete
9143  02  56  23  農産物23    のうさんぶつ23    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
10423  01  910  加工品②    かこうひん2    2016-07-01 00:00:00    2016-08-30 12:24:53  MG00000001  2016-08-30 12:24:53  MG00000001  View Edit Delete
12215  01  111  00906  ばれいしょ    ばれいしょ    2022-06-09 00:00:00    2022-06-09 08:06:35  MG00000001  2022-06-09 08:06:35  MG00000001  View Edit Delete
46775  01  031  513880  513880_農産物80    のうさんぶつ    2023-09-14 00:00:00    2023-09-14 11:49:17  MG00000001  2023-09-14 11:49:17  MG00000001  View Edit Delete
47543  01  033  57760  57760_農産物  岡山農産07760  のうさんぶつ    2023-09-28 00:00:00    2023-09-28 13:41:44  MG00000007  2023-09-28 13:41:44  MG00000007  View Edit Delete
47799  01  033  59219  59219_農産物  岡山農産09219  のうさんぶつ    2023-10-17 00:00:00    2023-10-17 17:23:50  MG00000007  2023-10-17 17:23:50  MG00000007  View Edit Delete
50615  01  036  105765  農産物5_5765    のうさんぶつ    2023-11-13 00:00:00    2023-11-13 17:04:28  MG00000007  2023-11-13 17:04:28  MG00000007  View Edit Delete
51383  01  036  105923  2510592300000_農産物    のうさんぶつ    2023-12-22 00:00:00    2023-12-22 14:59:57  MG00000007  2023-12-22 14:59:57  MG00000007  View Edit Delete

Page 192 of 2156, showing 20 records out of 43118 total, starting on record 3821, ending on 3840

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