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
6943  08  96  691  いちご    いちご    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7199  08  97  642  すもも    すもも    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7711  01  102  2400033508852   春菊    しゅんぎく    2019-05-20 00:00:00            View Edit Delete
7967  03  62  48  農産物48    のうさんぶつ48    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
10783  05  71  99144  農産物    のうさんぶつ    2021-07-27 00:00:00    2021-07-27 14:44:10  MG00000001  2021-07-27 14:44:10  MG00000001  View Edit Delete
18463  01  002  20110408  野菜    やさい    2022-12-21 00:00:00    2022-12-21 11:03:00  MG00000001  2022-12-21 11:03:00  MG00000001  View Edit Delete
47647  01  033  56576  56576_農産物  岡山農産06576  のうさんぶつ    2023-09-29 00:00:00    2023-09-29 13:24:17  MG00000007  2023-09-29 13:24:17  MG00000007  View Edit Delete
47903  01  033  59322  59322_農産物  岡山農産09322  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:43:57  MG00000007  2023-10-19 13:43:57  MG00000007  View Edit Delete
50975  01  036  105855  5855_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 09:50:48  MG00000007  2023-11-28 09:50:48  MG00000007  View Edit Delete
51487  01  033  50784  50784_農産物  岡山農産00784  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:56:53  MG00000007  2024-01-18 17:56:53  MG00000007  View Edit Delete
32  01  001  32  ニラ    にら    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1056  01  005  11131  南瓜 1/4カット 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
1568  01  007  6230  青ねぎ  近郷野菜130  あおねぎ    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2592  01  006  7148  野菜  産直野菜148  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5152  07  81  30  農産物30    のうさんぶつ30    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5408  02  53  38  農産物38    のうさんぶつ38    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6176  08  93  496241001054  つるむらさき    つるむらさき    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2019-02-25 15:32:47  MG00000001  View Edit Delete
6432  01  004  398362  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6688  02  52  2020  農産物    のうさんぶつ    2018-08-20 00:00:00    2018-08-20 14:56:29  MG00000001  2018-08-20 14:56:29  MG00000001  View Edit Delete
6944  08  96  692  あまおう    あまおう    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete

Page 31 of 2156, showing 20 records out of 43118 total, starting on record 601, ending on 620

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