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
50177  01  033  58710  8710_農産物  岡山農産08710  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50433  01  033  58427  8427_農産物  広島農産08427  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50689  01  033  58294  8294_農産物  広島農産08294  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50945  01  037  114890  4890_農産物1    のうさんぶつ    2023-11-27 00:00:00    2023-11-27 00:00:00  MG00000001  2023-11-27 00:00:00  MG00000001  View Edit Delete
51201  01  031  600316  600316_農産物16    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51457  01  036  109253  2510925300000_農産物    のうさんぶつ    2023-12-28 00:00:00    2023-12-28 17:05:30  MG00000007  2023-12-28 17:05:30  MG00000007  View Edit Delete
01  001  02  ミニトマト    みにとまと    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1026  01  003  499464830405  ゆずサイダー京あわわ    ゆずさいだーきょうあわわ    2016-08-29 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
1282  01  005  23021  バナナ 1P    ばなな1    2016-07-01 00:00:00    2016-08-30 12:24:45  MG00000001  2016-08-30 12:24:45  MG00000001  View Edit Delete
1538  01  007  6149  デラウェア  近郷果実30  くだもの    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2562  01  006  7118  野菜  産直野菜118  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5122  01  002  20110528  小松菜    こまつな    2017-11-30 00:00:00    2016-08-30 12:24:40  MG00000001  2019-09-06 11:02:39  MG00000001  View Edit Delete
5378  02  53  08  農産物08    のうさんぶつ08    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6146  03  61  99  農産物99    のうさんぶつ99    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
6402  08  95  005765980000  訳あり茄子    わけありなす    2018-07-13 00:00:00    2018-07-13 18:55:45  MG00000001  2018-07-13 18:55:45  MG00000001  View Edit Delete
6914  08  96  556  りんご(ジョナゴールド)    りんごじょなごーるど    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7170  08  97  507  不知火    しらぬい    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7682  01  102  2400033508449   さといも    さといも    2019-05-20 00:00:00            View Edit Delete
7938  03  62  19  農産物19    のうさんぶつ19    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
9218  02  56  98  農産物98    のうさんぶつ98    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete

Page 18 of 2156, showing 20 records out of 43118 total, starting on record 341, ending on 360

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