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
48174  01  036  105221  5221_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48430  01  036  105483  5483_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48686  01  036  108239  8239_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48942  01  036  108498  8498_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49198  01  036  108763  8763_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49454  01  033  57828  57828_農産物  岡山農産07828  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49710  01  036  105581  5581_農産物    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 00:00:00  MG00000001  2023-10-25 00:00:00  MG00000001  View Edit Delete
49966  01  036  105700  5700_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50222  01  033  58234  8234_農産物  広島農産08234  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50478  01  032  51395  13950_農産物    のうさんぶつ    2023-11-07 00:00:00    2023-11-07 13:12:59  MG00000007  2023-11-07 13:12:59  MG00000007  View Edit Delete
50734  01  033  58580  58580_農産物  広島農産08580  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50990  01  036  105870  5870_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 10:32:01  MG00000007  2023-11-28 10:32:01  MG00000007  View Edit Delete
51246  01  031  697001  697001_農産物01    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51502  01  033  50799  50799_農産物  岡山農産00799  のうさんぶつ    2024-01-19 00:00:00    2024-01-19 11:30:47  MG00000007  2024-01-19 11:30:47  MG00000007  View Edit Delete
1071  01  005  12101  ハクサイ 1/4 1P    はくさいかっと4    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
6447  01  004  398728  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6703  01  002  20110611  野菜    やさい    2018-08-31 00:00:00    2018-08-31 10:08:42  MG00000001  2018-08-31 10:08:42  MG00000001  View Edit Delete
7727  01  102  2400033509040   いちじく    いちじく    2019-05-20 00:00:00            View Edit Delete
8239  01  002  20120227  果実    かじつ    2019-12-23 00:00:00    2019-12-23 09:09:43  MG00000001  2019-12-23 09:09:43  MG00000001  View Edit Delete
12591  01  002  20905100  農産物①    のうさんぶつ    2022-08-02 00:00:00    2022-08-02 09:33:15  MG00000001  2022-08-02 09:33:15  MG00000001  View Edit Delete

Page 525 of 2156, showing 20 records out of 43118 total, starting on record 10481, ending on 10500

(default) 2 queries took 33 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`.`trader_id` desc LIMIT 10480, 20202026
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117