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
6700  01  002  20110608  胡瓜    きゅうり    2018-08-31 00:00:00    2018-08-31 09:54:03  MG00000001  2018-08-31 09:54:03  MG00000001  View Edit Delete
6956  08  96  719  ホームランメロン    ほーむらんめろん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7212  08  97  674  ネオマスカット    ねおますかっと    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7724  01  102  2400033509019   梨    なし    2019-05-20 00:00:00            View Edit Delete
7980  03  62  61  農産物61    のうさんぶつ61    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8236  01  002  20110596  野菜    やさい    2019-12-23 00:00:00    2019-12-23 08:49:52  MG00000001  2019-12-23 08:49:52  MG00000001  View Edit Delete
11052  06  661  00051  かいらん    かいらん    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-10 14:34:53  MG00000001  View Edit Delete
11308  06  661  00309  スイトピー    すいとぴー    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11564  06  661  00565  園芸飾り    えんげいかざり    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11820  06  661  00833  シナモンバジル    しなもんばじる    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12076  06  661  01090  古代米    こだいまい    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12332  04  710  89689  農産物    のうさんぶつ    2022-06-23 00:00:00    2022-06-23 11:26:53  MG00000001  2022-06-23 11:26:53  MG00000001  View Edit Delete
12588  01  002  20905117  農産物⑧    のうさんぶつ    2022-08-02 00:00:00    2022-08-02 09:31:45  MG00000001  2022-08-02 09:31:45  MG00000001  View Edit Delete
12844  01  056  32832  農産物    のうさんぶつ    2022-08-22 00:00:00    2022-08-22 12:42:10  MG00000001  2022-08-22 12:42:10  MG00000001  View Edit Delete
13100  01  052  074653  農産物    のうさんぶつ    2022-07-20 00:00:00    2022-07-20 11:33:00  MG00000001  2022-07-20 11:33:00  MG00000001  View Edit Delete
13356  01  911  101040  農産物①    のうさんぶつ    2022-10-06 00:00:00    2022-10-06 14:58:38  MG00000001  2022-10-06 14:58:38  MG00000001  View Edit Delete
13612  01  911  101507  農産物⑦    のうさんぶつ    2022-10-06 00:00:00    2022-10-06 14:58:38  MG00000001  2022-10-06 14:58:38  MG00000001  View Edit Delete
13868  01  911  100169  農産物⑥    のうさんぶつ    2022-10-06 00:00:00    2022-10-06 14:58:38  MG00000001  2022-10-06 14:58:38  MG00000001  View Edit Delete
14124  01  911  100869  農産物5    のうさんぶつ    2022-10-19 00:00:00    2022-10-19 09:13:14  MG00000001  2022-10-19 09:13:14  MG00000001  View Edit Delete
14380  01  911  101440  農産物③    のうさんぶつ    2022-10-19 00:00:00    2022-10-19 09:13:14  MG00000001  2022-10-19 09:13:14  MG00000001  View Edit Delete

Page 372 of 2156, showing 20 records out of 43118 total, starting on record 7421, ending on 7440

(default) 2 queries took 40 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 7420, 20202032
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1118