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
48148  01  036  105195  5195_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48404  01  036  105457  5457_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48660  01  036  108209  8209_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48916  01  036  108472  8472_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49172  01  036  108737  8737_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49428  01  033  57802  57802_農産物  岡山農産07802  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49684  01  036  105592  5592_農産物    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 00:00:00  MG00000001  2023-10-25 00:00:00  MG00000001  View Edit Delete
49940  01  036  109037  9037_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50196  01  033  58268  8268_農産物  広島農産08268  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50452  01  033  58446  8446_農産物  広島農産08446  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50708  01  033  58313  8313_農産物  広島農産08313  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50964  01  036  105844  5844_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 09:36:07  MG00000007  2023-11-28 09:36:07  MG00000007  View Edit Delete
51220  01  031  696905  696905_農産物05    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51476  01  033  50773  50773_農産物  岡山農産00773  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:37:27  MG00000007  2024-01-18 17:37:27  MG00000007  View Edit Delete
21  01  001  21  白ねぎ    しろねぎ    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1045  01  005  11051  ミディトマト 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
1301  01  005  25012  果物 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
1557  01  007  6219  ミニトマト  近郷野菜119  みにとまと    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2581  01  006  7137  野菜  産直野菜137  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5141  07  81  19  農産物19    のうさんぶつ19    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete

Page 177 of 2156, showing 20 records out of 43118 total, starting on record 3521, ending on 3540

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