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
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
6447  01  004  398728  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6703  01  002  20110611  野菜    やさい    2018-08-31 00:00:00    2018-08-31 10:08:42  MG00000001  2018-08-31 10:08:42  MG00000001  View Edit Delete
6959  08  96  733  黒スイカ    くろすいか    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7215  08  97  677  シャインマスカット    しゃいんますかっと    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7727  01  102  2400033509040   いちじく    いちじく    2019-05-20 00:00:00            View Edit Delete
7983  03  62  64  農産物64    のうさんぶつ64    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8239  01  002  20120227  果実    かじつ    2019-12-23 00:00:00    2019-12-23 09:09:43  MG00000001  2019-12-23 09:09:43  MG00000001  View Edit Delete
8495  02  51  249  いちご(女峰)    いちごにょほう    2020-06-15 00:00:00    2020-06-15 17:29:18  MG00000005  2020-06-15 17:29:18  MG00000005  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 31 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 7900, 20202024
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117