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
50731  01  033  58577  58577_農産物  広島農産08577  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50987  01  036  105867  5867_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 10:16:57  MG00000007  2023-11-28 10:16:57  MG00000007  View Edit Delete
51243  01  031  696928  696928_農産物28    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51499  01  033  50796  50796_農産物  岡山農産00796  のうさんぶつ    2024-01-19 00:00:00    2024-01-19 11:27:11  MG00000007  2024-01-19 11:27:11  MG00000007  View Edit Delete
44  01  001  44  ゆず    ゆず    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
300  01  002  20110286  野菜    やさい    2016-08-29 00:00:00    2016-08-30 12:24:40  MG00000001  2016-08-30 12:24:40  MG00000001  View Edit Delete
1068  01  005  12071  サニーレタス 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
2604  02  51  104  タマネギ    たまねぎ    2017-02-27 00:00:00            View Edit Delete
5164  07  81  42  農産物42    のうさんぶつ42    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5420  02  53  50  農産物50    のうさんぶつ50    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6188  01  007  6001  わさび菜  近郷野菜2  わさびな    2018-04-18 00:00:00    2018-04-18 12:24:48  MG00000001  2018-04-18 12:24:48  MG00000001  View Edit Delete
6444  01  004  398725  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6700  01  002  20110608  胡瓜    きゅうり    2018-08-31 00:00:00    2018-08-31 09:54:03  MG00000001  2018-08-31 09:54:03  MG00000001  View Edit Delete
6956  08  96  719  ホームランメロン    ほーむらんめろん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7212  08  97  674  ネオマスカット    ねおますかっと    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7724  01  102  2400033509019   梨    なし    2019-05-20 00:00:00            View Edit Delete
7980  03  62  61  農産物61    のうさんぶつ61    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8236  01  002  20110596  野菜    やさい    2019-12-23 00:00:00    2019-12-23 08:49:52  MG00000001  2019-12-23 08:49:52  MG00000001  View Edit Delete
11052  06  661  00051  かいらん    かいらん    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-10 14:34:53  MG00000001  View Edit Delete
11308  06  661  00309  スイトピー    すいとぴー    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete

Page 371 of 2156, showing 20 records out of 43118 total, starting on record 7401, ending on 7420

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