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
2606  02  51  106  ニンジン    にんじん    2017-02-27 00:00:00            View Edit Delete
5422  02  53  52  農産物52    のうさんぶつ52    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
2607  02  51  107  キュウリ    きゅうり    2017-02-27 00:00:00            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
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
9519  02  51  368  リーキ    りーき    2021-03-09 00:00:00    2021-03-09 12:03:59  MG00000005  2021-03-09 12:03:59  MG00000005  View Edit Delete
2608  02  51  108  ネギ    ねぎ    2017-02-27 00:00:00            View Edit Delete
5424  02  53  54  農産物54    のうさんぶつ54    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6192  02  51  102  おかひじき    おかひじき    2018-04-20 00:00:00    2018-04-20 13:35:04  MG00000001  2018-04-20 13:35:04  MG00000001  View Edit Delete
2609  02  51  111  サツマイモ    さつまいも    2017-02-27 00:00:00            View Edit Delete
5425  02  53  55  農産物55    のうさんぶつ55    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6193  02  51  144  メークイン    めーくいん    2018-04-20 00:00:00    2018-04-20 13:38:11  MG00000001  2018-04-20 13:38:11  MG00000001  View Edit Delete
8497  02  51  226  極早生みかん    ごくわせみかん    2020-06-19 00:00:00    2020-06-19 17:49:13  MG00000005  2020-06-19 17:49:13  MG00000005  View Edit Delete
2610  02  51  112  ナス    なす    2017-02-27 00:00:00            View Edit Delete
5426  02  53  56  農産物56    のうさんぶつ56    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6194  02  51  571  まくわうり    まくわうり    2018-04-20 00:00:00    2018-04-20 13:38:42  MG00000001  2018-04-20 13:38:42  MG00000001  View Edit Delete
8242  02  55  2133818  農産物    のうさんぶつ    2019-12-26 00:00:00    2019-12-26 13:31:01  MG00000001  2019-12-26 13:31:01  MG00000001  View Edit Delete
8498  02  51  246  早生ミカン    わせみかん    2020-06-19 00:00:00    2020-06-19 17:52:16  MG00000005  2020-06-19 17:52:16  MG00000005  View Edit Delete
2611  02  51  114  カボチャ    かぼちゃ    2017-02-27 00:00:00            View Edit Delete

Page 126 of 2156, showing 20 records out of 43118 total, starting on record 2501, ending on 2520

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