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
47882  01  033  59301  59301_農産物  岡山農産09301  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:05:33  MG00000007  2023-10-19 13:05:33  MG00000007  View Edit Delete
48138  01  036  105184  5184_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48394  01  036  105447  5447_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48650  01  036  108199  8199_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48906  01  036  108462  8462_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49162  01  036  108727  8727_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49418  01  033  57929  57929_農産物  岡山農産07929  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49674  01  031  820606  820606_農産物6    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 11:45:44  MG00000007  2023-10-25 11:45:44  MG00000007  View Edit Delete
49930  01  036  109027  9027_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50186  01  033  58719  8719_農産物  岡山農産08719  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50442  01  033  58436  8436_農産物  広島農産08436  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50698  01  033  58303  8303_農産物  広島農産08303  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50954  01  036  109147  9147_農産物1    のうさんぶつ    2023-11-27 00:00:00    2023-11-27 00:00:00  MG00000001  2023-11-27 00:00:00  MG00000001  View Edit Delete
51210  01  031  600325  600325_農産物25    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51466  01  033  50807  50807_農産物  岡山農産00807  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:16:36  MG00000007  2024-01-18 17:16:36  MG00000007  View Edit Delete
11  01  001  11  なす    なす    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1035  01  005  11011  きゅうり 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
1291  01  005  24024  オレンジ パック    おれんじぱっく    2016-07-01 00:00:00    2016-08-30 12:24:45  MG00000001  2016-08-30 12:24:45  MG00000001  View Edit Delete
1547  01  007  6209  フルーツトマト  近郷野菜109  ふるーつとまと    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2571  01  006  7127  野菜  産直野菜127  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete

Page 93 of 2156, showing 20 records out of 43118 total, starting on record 1841, ending on 1860

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