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
47918  01  033  59337  59337_農産物  岡山農産09337  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 14:03:00  MG00000007  2023-10-19 14:03:00  MG00000007  View Edit Delete
48174  01  036  105221  5221_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48430  01  036  105483  5483_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48686  01  036  108239  8239_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48942  01  036  108498  8498_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49198  01  036  108763  8763_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49454  01  033  57828  57828_農産物  岡山農産07828  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49710  01  036  105581  5581_農産物    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 00:00:00  MG00000001  2023-10-25 00:00:00  MG00000001  View Edit Delete
49966  01  036  105700  5700_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50222  01  033  58234  8234_農産物  広島農産08234  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50478  01  032  51395  13950_農産物    のうさんぶつ    2023-11-07 00:00:00    2023-11-07 13:12:59  MG00000007  2023-11-07 13:12:59  MG00000007  View Edit Delete
50734  01  033  58580  58580_農産物  広島農産08580  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50990  01  036  105870  5870_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 10:32:01  MG00000007  2023-11-28 10:32:01  MG00000007  View Edit Delete
51246  01  031  697001  697001_農産物01    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51502  01  033  50799  50799_農産物  岡山農産00799  のうさんぶつ    2024-01-19 00:00:00    2024-01-19 11:30:47  MG00000007  2024-01-19 11:30:47  MG00000007  View Edit Delete
1071  01  005  12101  ハクサイ 1/4 1P    はくさいかっと4    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
2607  02  51  107  キュウリ    きゅうり    2017-02-27 00:00:00            View Edit Delete
5167  07  81  45  農産物45    のうさんぶつ45    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5423  02  53  53  農産物53    のうさんぶつ53    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6191  02  51  357  マイクロトマト  マイクロトマト  まいくろとまと    2018-04-20 00:00:00    2018-04-20 13:29:11  MG00000001  2018-04-20 13:29:11  MG00000001  View Edit Delete

Page 396 of 2156, showing 20 records out of 43118 total, starting on record 7901, ending on 7920

(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` desc LIMIT 7900, 20202025
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1118