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
50735  01  033  58581  58581_農産物  広島農産08581  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50991  01  036  105871  5871_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 10:33:04  MG00000007  2023-11-28 10:33:04  MG00000007  View Edit Delete
51247  01  031  697002  697002_柿    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51503  01  033  50800  50800_農産物  岡山農産00800  のうさんぶつ    2024-01-19 00:00:00    2024-01-19 11:31:51  MG00000007  2024-01-19 11:31:51  MG00000007  View Edit Delete
1072  01  005  12111  ハクサイ 1/2 1P    はくさいかっと2    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
2608  02  51  108  ネギ    ねぎ    2017-02-27 00:00:00            View Edit Delete
5168  07  81  46  農産物46    のうさんぶつ46    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5424  02  53  54  農産物54    のうさんぶつ54    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6192  02  51  102  おかひじき    おかひじき    2018-04-20 00:00:00    2018-04-20 13:35:04  MG00000001  2018-04-20 13:35:04  MG00000001  View Edit Delete
6448  01  004  398734  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6704  01  002  20110612  茄子    なす    2018-08-31 00:00:00    2018-08-31 10:09:17  MG00000001  2018-08-31 10:09:17  MG00000001  View Edit Delete
6960  08  96  741  バナナ    ばなな    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7216  08  97  691  いちご    いちご    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7728  01  102  2400033509057   いちじく    いちじく    2019-05-20 00:00:00            View Edit Delete
7984  03  62  65  農産物65    のうさんぶつ65    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8240  01  002  20120228  果実    かじつ    2019-12-23 00:00:00    2019-12-23 09:12:58  MG00000001  2019-12-23 09:12:58  MG00000001  View Edit Delete
11056  06  661  00055  リーフレタス    りーふれたす    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-10 14:35:47  MG00000001  View Edit Delete
11312  06  661  00313  スカシユリ    すかしゆり    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11568  06  661  00569  ちょうほう菜    ちょうほうな    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11824  06  661  00837  イタリアンパセリ    いたりあんぱせり    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete

Page 405 of 2156, showing 20 records out of 43118 total, starting on record 8081, ending on 8100

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