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
7314  01  101  2082891039473   トリコフルーツ 青果8  トリコフルーツ 青果8  とりこふるーつせいかはち    2019-03-05 00:00:00    2019-03-05 00:00:00  MG00000001  2019-03-05 00:00:00  MG00000001  View Edit Delete
8594  01  004  343291  野菜    やさい    2020-10-13 00:00:00    2020-10-13 10:50:22  MG00000005  2020-10-13 10:50:22  MG00000005  View Edit Delete
10898  01  112  20905072  農産物    のうさんぶつ    2021-11-08 00:00:00    2021-11-08 12:00:29  MG00000001  2021-11-08 12:00:29  MG00000001  View Edit Delete
12178  01  110  100224  メロン(ホームラン)    めろん    2022-06-06 00:00:00    2022-06-06 15:49:36  MG00000001  2022-06-06 15:49:36  MG00000001  View Edit Delete
12690  01  002  20120256  果実    かじつ    2022-08-22 00:00:00    2022-08-22 08:53:05  MG00000001  2022-08-22 08:53:05  MG00000001  View Edit Delete
12946  01  002  20120257  果実    かじつ    2022-09-16 00:00:00    2022-09-16 09:12:15  MG00000001  2022-09-16 09:12:15  MG00000001  View Edit Delete
18322  01  911  100400  農産物①    のうさんぶつ    2022-11-17 00:00:00    2022-11-17 15:35:43  MG00000001  2022-11-17 15:35:43  MG00000001  View Edit Delete
51090  01  036  109207  2510920700000_農産物    のうさんぶつ    2023-12-04 00:00:00    2023-12-04 17:32:12  MG00000007  2023-12-04 17:32:12  MG00000007  View Edit Delete
147  01  001  93  豆腐    とうふ    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
1171  01  005  18011  国産筍水煮 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
1683  01  007  6345  千筋水菜  近郷野菜245  せんすじみずな    2016-08-29 00:00:00    2016-08-30 12:24:48  MG00000001  2016-08-30 12:24:48  MG00000001  View Edit Delete
2451  01  006  7007  野菜  産直野菜7  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
2707  02  51  783  ローズマリー    ろーずまりー    2017-02-27 00:00:00            View Edit Delete
3987  01  003  24  キャベツ    きゃべつ    2017-03-15 00:00:00            View Edit Delete
5011  05  71  89626  農産物    のうさんぶつ    2017-11-01 00:00:00    2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete
5267  02  52  1672  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
5523  08  91  496241001028  里芋    さといも    2018-03-02 00:00:00    2018-03-02 00:00:00  MG00000001  2018-03-02 09:21:23  MG00000001  View Edit Delete
6035  08  93  496241001038  ワイルドルッコラ    わいるどるっこら    2018-03-20 00:00:00    2018-03-20 11:25:12  MG00000001  2018-03-20 11:25:12  MG00000001  View Edit Delete
6291  01  006  7299  野菜  産直野菜299  やさい    2018-06-20 00:00:00    2018-06-20 14:35:36  MG00000001  2018-06-20 14:35:36  MG00000001  View Edit Delete
6547  01  004  343631  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete

Page 151 of 2156, showing 20 records out of 43118 total, starting on record 3001, ending on 3020

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