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
47658  01  031  100015  100015_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:01:53  MG00000007  2023-10-03 16:01:53  MG00000007  View Edit Delete
47914  01  033  59333  59333_農産物  岡山農産09333  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:58:09  MG00000007  2023-10-19 13:58:09  MG00000007  View Edit Delete
48170  01  036  105217  5217_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48426  01  036  105479  5479_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48682  01  036  108235  8235_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48938  01  036  108494  8494_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49194  01  036  108759  8759_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49450  01  033  57824  57824_農産物  岡山農産07824  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49706  01  036  105577  5577_農産物    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 00:00:00  MG00000001  2023-10-25 00:00:00  MG00000001  View Edit Delete
49962  01  036  105696  5696_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50218  01  033  58247  8247_農産物  広島農産08247  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50474  01  033  58468  8468_農産物  広島農産08468  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50730  01  033  51868  51868_農産物  岡山農産01868  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50986  01  036  105866  5866_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 10:15:38  MG00000007  2023-11-28 10:15:38  MG00000007  View Edit Delete
51242  01  031  696927  696927_農産物27    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51498  01  033  50795  50795_農産物  岡山農産00795  のうさんぶつ    2024-01-19 00:00:00    2024-01-19 11:26:06  MG00000007  2024-01-19 11:26:06  MG00000007  View Edit Delete
43  01  001  43  にんにく    にんにく    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1067  01  005  12061  レタス 1P    れたす1    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
2603  02  51  103  ヨウサイ(空芯菜)    ようさいくうしんさい    2017-02-27 00:00:00        2020-04-24 10:41:05  MG00000001  View Edit Delete
5163  07  81  41  農産物41    のうさんぶつ41    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete

Page 362 of 2156, showing 20 records out of 43118 total, starting on record 7221, ending on 7240

(default) 2 queries took 30 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 7220, 20202023
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117