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
8013  03  62  94  農産物94    のうさんぶつ94    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8269  02  51  658  新高なし    にいたかなし    2020-03-18 00:00:00    2020-03-18 15:31:58  MG00000001  2020-03-18 15:31:58  MG00000001  View Edit Delete
12109  01  111  00946  トマト    とまと    2022-05-09 00:00:00    2022-05-09 08:47:19  MG00000001  2022-05-09 08:47:19  MG00000001  View Edit Delete
13133  01  002  20110406  野菜    やさい    2022-09-30 00:00:00    2022-09-30 14:21:44  MG00000001  2022-09-30 14:21:44  MG00000001  View Edit Delete
18509  01  006  7172  野菜  産直野菜172  やさい    2023-01-26 00:00:00    2023-01-26 15:18:49  MG00000001  2023-01-26 15:18:49  MG00000001  View Edit Delete
42573  01  114  12490  2490_農産物3    のうさんぶつ    2023-04-18 00:00:00    2023-04-18 11:50:46  MG00000001  2023-04-18 11:50:46  MG00000001  View Edit Delete
47693  01  035  102140  2510214000000_農産物  産地直送 野菜214  のうさんぶつ    2023-10-12 00:00:00    2023-10-12 14:38:04  MG00000007  2023-10-12 14:38:04  MG00000007  View Edit Delete
47949  01  036  105561  5561_農産物4    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 12:05:36  MG00000007  2023-10-20 12:05:36  MG00000007  View Edit Delete
51021  01  036  109181  9181_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 15:49:08  MG00000007  2023-11-28 15:49:08  MG00000007  View Edit Delete
78  01  001  49  さんしょの実    さんしょのみ    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1102  01  005  14051  安納甘芋 1P    あんのうあまいも1    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
2638  02  51  170  カリフラワー    かりふらわー    2017-02-27 00:00:00            View Edit Delete
5198  07  81  76  農産物76    のうさんぶつ76    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5454  02  53  84  農産物84    のうさんぶつ84    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6222  02  51  281  柑橘    かんきつ    2018-05-22 00:00:00    2018-05-22 13:41:27  MG00000001  2018-05-22 13:41:27  MG00000001  View Edit Delete
6478  01  004  472734  果物    くだもの    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6734  01  002  20110640  茄子    なす    2018-09-04 00:00:00    2018-09-04 09:20:10  MG00000001  2018-09-04 09:20:10  MG00000001  View Edit Delete
6990  01  002  20110586  野菜    やさい    2018-10-11 00:00:00    2018-10-11 10:28:26  MG00000001  2018-10-11 10:28:26  MG00000001  View Edit Delete
7246  08  97  768  ジャム    じゃむ    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
8014  03  62  95  農産物95    のうさんぶつ95    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete

Page 79 of 2156, showing 20 records out of 43118 total, starting on record 1561, ending on 1580

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