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
47616  01  034  81284  12840_農産物    のうさんぶつ    2023-09-28 00:00:00    2023-09-28 16:21:21  MG00000007  2023-09-28 16:21:21  MG00000007  View Edit Delete
47872  01  033  59292  59292_農産物  岡山農産09292  のうさんぶつ    2023-10-18 00:00:00    2023-10-18 16:52:41  MG00000007  2023-10-18 16:52:41  MG00000007  View Edit Delete
48128  01  036  105174  5174_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48384  01  036  105437  5437_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48640  01  036  108189  8189_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48896  01  036  108452  8452_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49152  01  036  108717  8717_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49408  01  033  57919  57919_農産物  岡山農産07919  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49664  01  033  58008  58008_農産物  岡山農産08008  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49920  01  036  109017  9017_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50176  01  033  58709  8709_農産物  岡山農産08709  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50432  01  033  58426  8426_農産物  広島農産08426  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50688  01  033  58293  8293_農産物  広島農産08293  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50944  01  037  114889  4889_農産物1    のうさんぶつ    2023-11-27 00:00:00    2023-11-27 00:00:00  MG00000001  2023-11-27 00:00:00  MG00000001  View Edit Delete
51200  01  031  600315  600315_農産物15    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51456  01  036  109252  2510925200000_農産物    のうさんぶつ    2023-12-28 00:00:00    2023-12-28 17:04:43  MG00000007  2023-12-28 17:04:43  MG00000007  View Edit Delete
01  001  01  トマト    とまと    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2018-05-28 15:03:02  MG00000001  View Edit Delete
257  01  002  20110231  野菜    やさい    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2021-12-03 09:58:37  MG00000001  View Edit Delete
1025  01  003  499085505072  大和焼ねぎ地味噌    やまとやきねぎじみそ    2016-08-29 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
1281  01  005  23011  パイン 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

Page 9 of 2156, showing 20 records out of 43118 total, starting on record 161, ending on 180

(default) 2 queries took 26 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 160, 20202017
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1119