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
47418  01  033  57662  57662_農産物  岡山農産07662  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47674  01  031  100031  100031_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:49:58  MG00000007  2023-10-03 16:49:58  MG00000007  View Edit Delete
47930  01  037  114811  4811_農産物4    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 09:39:30  MG00000007  2023-10-20 09:39:30  MG00000007  View Edit Delete
48186  01  036  105233  5233_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48442  01  036  105495  5495_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48698  01  036  108252  8252_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48954  01  036  108512  8512_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49210  01  036  108775  8775_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49466  01  033  57941  57941_農産物  岡山農産07941  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49722  01  036  105618  5618_農産物    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 00:00:00  MG00000001  2023-10-25 00:00:00  MG00000001  View Edit Delete
49978  01  036  105712  5712_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50234  01  033  58262  8262_農産物  広島農産08262  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50490  01  035  102210  2510221000000_農産物  産地直送 野菜221  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50746  01  033  58592  58592_農産物  広島農産08592  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
51002  01  036  109162  9162_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 11:54:19  MG00000007  2023-11-28 11:54:19  MG00000007  View Edit Delete
51258  01  031  697013  697013_農産物13    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
1083  01  005  12181  ほうれん草 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
1595  01  007  6257  アスパラ  近郷野菜157  あすぱら    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2619  02  51  129  小松菜    こまつな    2017-02-27 00:00:00            View Edit Delete
5179  07  81  57  農産物57    のうさんぶつ57    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete

Page 497 of 2156, showing 20 records out of 43118 total, starting on record 9921, ending on 9940

(default) 2 queries took 34 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 9920, 20202026
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1118