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
1297  01  005  24042  グレープフルーツルビー 2P    ぐれーぷふるーつるびー2    2016-07-01 00:00:00    2016-08-30 12:24:45  MG00000001  2016-08-30 12:24:45  MG00000001  View Edit Delete
1553  01  007  6215  空芯菜  近郷野菜115  やさい    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2577  01  006  7133  野菜  産直野菜133  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5137  07  81  15  農産物15    のうさんぶつ15    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5393  02  53  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
6161  08  91  496241001051  からし菜    からしな    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6417  01  004  343257  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6673  01  004  343651  野菜    やさい    2018-08-09 00:00:00    2018-08-09 15:03:08  MG00000001  2018-08-09 15:12:40  MG00000001  View Edit Delete
6929  08  96  645  プラム(貴陽)    ぷらむきよう    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7185  08  97  554  りんご(紅玉)    りんごこうぎょく    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7697  01  102  2400033508661   カリフラワー    かりふらわー    2019-05-20 00:00:00            View Edit Delete
7953  03  62  34  農産物34    のうさんぶつ34    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8209  02  55  2132639  農産物    のうさんぶつ    2019-11-29 00:00:00    2019-11-29 10:19:11  MG00000001  2019-11-29 10:19:11  MG00000001  View Edit Delete
18449  01  113  20904944  野菜①    やさい    2022-12-19 00:00:00    2022-12-19 13:28:35  MG00000001  2022-12-19 13:28:35  MG00000001  View Edit Delete
44049  01  033  56010  56010_農産物  岡山農産06010  のうさんぶつ    2023-06-28 00:00:00    2023-06-28 13:34:45  MG00000001  2023-06-28 13:34:45  MG00000001  View Edit Delete
47633  01  032  51374  13740_農産物    のうさんぶつ    2023-09-29 00:00:00    2023-09-29 09:22:13  MG00000007  2023-09-29 09:22:13  MG00000007  View Edit Delete
47889  01  033  59308  59308_農産物  岡山農産09308  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:20:33  MG00000007  2023-10-19 13:20:33  MG00000007  View Edit Delete
50961  01  036  105841  5841_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 09:31:11  MG00000007  2023-11-28 09:31:11  MG00000007  View Edit Delete
51473  01  033  50770  50770_農産物  岡山農産00770  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:31:22  MG00000007  2024-01-18 17:31:22  MG00000007  View Edit Delete
18  01  001  18  チンゲン菜    ちんげんさい    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete

Page 17 of 2156, showing 20 records out of 43118 total, starting on record 321, ending on 340

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