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
47372  01  033  59028  59028_農産物  岡山農産09028  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47628  01  032  51369  13690_農産物    のうさんぶつ    2023-09-29 00:00:00    2023-09-29 09:14:35  MG00000007  2023-09-29 09:14:35  MG00000007  View Edit Delete
47884  01  033  59303  59303_農産物  岡山農産09303  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:08:55  MG00000007  2023-10-19 13:08:55  MG00000007  View Edit Delete
48140  01  036  105186  5186_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48396  01  036  105449  5449_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48652  01  036  108201  8201_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48908  01  036  108464  8464_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49164  01  036  108729  8729_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49420  01  033  57931  57931_農産物  岡山農産07931  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49676  01  031  820608  820608_農産物8    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 11:49:03  MG00000007  2023-10-25 11:49:03  MG00000007  View Edit Delete
49932  01  036  109029  9029_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50188  01  033  58721  8721_農産物  岡山農産08721  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50444  01  033  58438  8438_農産物  広島農産08438  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50700  01  033  58305  8305_農産物  広島農産08305  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50956  01  037  114894  4894_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 09:16:50  MG00000007  2023-11-28 09:16:50  MG00000007  View Edit Delete
51212  01  031  600327  600327_農産物27    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51468  01  033  50809  50809_農産物  岡山農産00809  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:24:05  MG00000007  2024-01-18 17:24:05  MG00000007  View Edit Delete
13  01  001  13  えんどう豆    えんどうまめ    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1037  01  005  11013  きゅうり 3P    きゅうり3    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
1293  01  005  24032  グレープフルーツホワイト 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

Page 101 of 2156, showing 20 records out of 43118 total, starting on record 2001, ending on 2020

(default) 2 queries took 27 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`.`trader_id` asc LIMIT 2000, 20202020
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117