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
45  01  001  45  スダチ    すだち    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1069  01  005  12081  グリーンリーフ 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
2605  02  51  105  ジャガイモ    じゃがいも    2017-02-27 00:00:00            View Edit Delete
5165  07  81  43  農産物43    のうさんぶつ43    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5421  02  53  51  農産物51    のうさんぶつ51    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6189  01  007  6006  菜の花  近郷野菜7  なのはな    2018-04-18 00:00:00    2018-04-18 12:24:48  MG00000001  2018-04-18 12:24:48  MG00000001  View Edit Delete
6445  01  004  398726  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6701  01  002  20110609  野菜    やさい    2018-08-31 00:00:00    2018-08-31 10:03:36  MG00000001  2018-08-31 10:03:36  MG00000001  View Edit Delete
6957  08  96  731  すいか    すいか    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7213  08  97  675  巨峰    きょほう    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7725  01  102  2400033509026   柿    かき    2019-05-20 00:00:00            View Edit Delete
7981  03  62  62  農産物62    のうさんぶつ62    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8237  01  002  20110597  ミニトマト    みにとまと    2019-12-23 00:00:00    2019-12-23 08:56:07  MG00000001  2022-02-01 09:35:28  MG00000001  View Edit Delete
11053  06  661  00052  ケール    けーる    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-10 14:35:13  MG00000001  View Edit Delete
11309  06  661  00310  萩    はぎ    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11565  06  661  00566  園芸用品    えんげいようひん    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11821  06  661  00834  スイートバジル    すいーとばじる    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12077  06  661  01091  紅みかん    べにみかん    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12333  04  710  89690  農産物    のうさんぶつ    2022-06-23 00:00:00    2022-06-23 11:26:53  MG00000001  2022-06-23 11:26:53  MG00000001  View Edit Delete
12589  01  002  20905118  農産物⑨    のうさんぶつ    2022-08-02 00:00:00    2022-08-02 09:32:04  MG00000001  2022-08-02 09:32:04  MG00000001  View Edit Delete

Page 380 of 2156, showing 20 records out of 43118 total, starting on record 7581, ending on 7600

(default) 2 queries took 32 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 7580, 20202024
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1118