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
2606  02  51  106  ニンジン    にんじん    2017-02-27 00:00:00            View Edit Delete
5166  07  81  44  農産物44    のうさんぶつ44    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5422  02  53  52  農産物52    のうさんぶつ52    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6190  01  007  6007  モロヘイヤ  近郷野菜8  もろへいや    2018-04-18 00:00:00    2018-04-18 12:24:48  MG00000001  2018-04-18 12:24:48  MG00000001  View Edit Delete
6446  01  004  398727  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6702  01  002  20110610  胡瓜    きゅうり    2018-08-31 00:00:00    2018-08-31 10:07:26  MG00000001  2018-08-31 10:07:26  MG00000001  View Edit Delete
6958  08  96  732  小玉すいか    こだますいか    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7214  08  97  676  ナガノパープル    ながのぱーぷる    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7726  01  102  2400033509033   柿    かき    2019-05-20 00:00:00            View Edit Delete
7982  03  62  63  農産物63    のうさんぶつ63    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8238  01  002  20110595  菌床栽培生しいたけ    きんしょうさいばいなましいたけ    2019-12-23 00:00:00    2019-12-23 08:57:57  MG00000001  2022-02-01 09:33:42  MG00000001  View Edit Delete
8494  01  011  68783  農産物    のうさんぶつ    2020-06-10 00:00:00    2020-06-10 13:42:51  MG00000005  2020-06-10 13:42:51  MG00000005  View Edit Delete
11054  06  661  00053  レタス    れたす    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-10 14:35:24  MG00000001  View Edit Delete
11310  06  661  00311  ミソハギ    みそはぎ    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11566  06  661  00567  ピンク卵    ぴんくたまご    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11822  06  661  00835  スペアーミント    すぺあーみんと    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12078  06  661  01092  里いも(親芋)    さといもおやいも    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12334  04  710  89691  農産物    のうさんぶつ    2022-06-23 00:00:00    2022-06-23 11:26:53  MG00000001  2022-06-23 11:26:53  MG00000001  View Edit Delete
12590  01  002  20905119  農産物⑩    のうさんぶつ    2022-08-02 00:00:00    2022-08-02 09:32:21  MG00000001  2022-08-02 09:32:21  MG00000001  View Edit Delete
12846  01  056  32865  農産物    のうさんぶつ    2022-08-22 00:00:00    2022-08-22 12:42:10  MG00000001  2022-08-22 12:42:10  MG00000001  View Edit Delete

Page 388 of 2156, showing 20 records out of 43118 total, starting on record 7741, ending on 7760

(default) 2 queries took 43 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` asc LIMIT 7740, 20202035
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1118