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
48388  01  036  105441  5441_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48644  01  036  108193  8193_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48900  01  036  108456  8456_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49156  01  036  108721  8721_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49412  01  033  57923  57923_農産物  岡山農産07923  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49668  01  033  57962  57962_農産物  岡山農産07962  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49924  01  036  109021  9021_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50180  01  033  58713  8713_農産物  岡山農産08713  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50436  01  033  58430  8430_農産物  広島農産08430  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50692  01  033  58297  8297_農産物  広島農産08297  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50948  01  036  109141  9141_農産物1    のうさんぶつ    2023-11-27 00:00:00    2023-11-27 00:00:00  MG00000001  2023-11-27 00:00:00  MG00000001  View Edit Delete
51204  01  031  600319  600319_農産物19    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51460  01  036  109257  2510925700000_農産物    のうさんぶつ    2023-12-28 00:00:00    2023-12-28 17:08:47  MG00000007  2023-12-28 17:08:47  MG00000007  View Edit Delete
01  001  05  ピーマン    ぴーまん    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1029  01  003  91  加工品    かこうひん    2016-08-29 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
1285  01  005  24012  レモン 2P    れもん2    2016-07-01 00:00:00    2016-08-30 12:24:45  MG00000001  2016-08-30 12:24:45  MG00000001  View Edit Delete
2565  01  006  7121  野菜  産直野菜121  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5125  01  002  20110531  かぶ    かぶ    2017-11-30 00:00:00    2016-08-30 12:24:40  MG00000001  2019-09-06 11:03:47  MG00000001  View Edit Delete
5381  02  53  11  農産物11    のうさんぶつ11    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6149  02  52  1841  農産物    のうさんぶつ    2018-03-22 00:00:00    2018-03-22 00:00:00  MG00000001  2018-03-22 00:00:00  MG00000001  View Edit Delete

Page 43 of 2156, showing 20 records out of 43118 total, starting on record 841, ending on 860

(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 840, 20202016
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117