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
8593  01  004  499556  大石早生    おおいしわせ    2020-09-29 00:00:00    2020-09-29 11:32:19  MG00000005  2020-10-13 14:01:25  MG00000005  View Edit Delete
9105  02  51  202  小玉スイカ    こだますいか    2021-01-29 00:00:00    2021-01-29 15:23:24  MG00000005  2021-01-29 15:23:24  MG00000005  View Edit Delete
10897  01  112  20905071  農産物    のうさんぶつ    2021-11-08 00:00:00    2021-11-08 12:00:15  MG00000001  2021-11-08 12:00:15  MG00000001  View Edit Delete
12177  01  110  100222  メロン(肥後グリーン)    めろん    2022-06-06 00:00:00    2022-06-06 13:36:49  MG00000001  2022-06-06 13:36:49  MG00000001  View Edit Delete
12689  01  002  20110768  野菜    やさい    2022-08-16 00:00:00    2022-08-16 16:18:57  MG00000001  2022-08-16 16:18:57  MG00000001  View Edit Delete
18321  01  002  20110348  野菜    やさい    2022-11-17 00:00:00    2022-11-17 09:43:34  MG00000001  2022-11-17 09:43:34  MG00000001  View Edit Delete
51089  01  036  109206  2510920600000_農産物    のうさんぶつ    2023-12-04 00:00:00    2023-12-04 17:31:14  MG00000007  2023-12-04 17:31:14  MG00000007  View Edit Delete
146  01  001  92  雑貨    ざっか    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
1170  01  005  17114  梅 パック    うめぱっく    2016-07-01 00:00:00    2016-08-30 12:24:45  MG00000001  2016-08-30 12:24:45  MG00000001  View Edit Delete
2450  01  006  7006  野菜  産直野菜6  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
2706  02  51  777  サラダごぼう    さらだごぼう    2017-02-27 00:00:00            View Edit Delete
3986  01  003  23  葉物    はもの    2017-03-15 00:00:00            View Edit Delete
5010  05  71  89625  農産物    のうさんぶつ    2017-11-01 00:00:00    2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete
5266  02  52  1671  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
5522  08  91  496241001027  さつま芋    さつまいも    2018-03-02 00:00:00    2018-03-02 00:00:00  MG00000001  2018-03-02 09:21:23  MG00000001  View Edit Delete
6034  08  93  496241001037  ルッコラ    るっこら    2018-03-20 00:00:00    2018-03-20 11:25:12  MG00000001  2018-03-20 11:25:12  MG00000001  View Edit Delete
6290  01  006  7298  野菜  産直野菜298  やさい    2018-06-20 00:00:00    2018-06-20 14:34:42  MG00000001  2018-06-20 14:34:42  MG00000001  View Edit Delete
6546  01  004  499630  果物    くだもの    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6802  08  96  115  バジル(ホーリー)    ばじるほーりー    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-26 14:31:34  MG00000001  View Edit Delete
7058  08  97  071  モロヘイヤ    もろへいや    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 17:04:00  MG00000001  View Edit Delete

Page 150 of 2156, showing 20 records out of 43118 total, starting on record 2981, ending on 3000

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