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
7714  01  102  2400033508906   スナップエンドウ    すなっぷえんどう    2019-05-20 00:00:00            View Edit Delete
7970  03  62  51  農産物51    のうさんぶつ51    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8226  01  021  2027198566840  キウイ    きうい    2019-12-02 00:00:00    2019-12-02 14:45:28  MG00000001  2019-12-02 14:45:28  MG00000001  View Edit Delete
10274  01  002  20110443  野菜    やさい    2021-03-25 00:00:00    2021-03-25 10:25:47  MG00000005  2022-05-10 15:53:23  MG00000001  View Edit Delete
18466  01  002  20110413  野菜    やさい    2022-12-23 00:00:00    2022-12-23 11:02:12  MG00000001  2022-12-23 11:02:12  MG00000001  View Edit Delete
47650  01  031  112609  112609_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 15:35:02  MG00000007  2023-10-03 15:35:02  MG00000007  View Edit Delete
47906  01  033  59325  59325_農産物  岡山農産09325  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:48:28  MG00000007  2023-10-19 13:48:28  MG00000007  View Edit Delete
50978  01  036  105858  5858_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 10:03:15  MG00000007  2023-11-28 10:03:15  MG00000007  View Edit Delete
51490  01  033  50787  50787_農産物  岡山農産00787  のうさんぶつ    2024-01-19 00:00:00    2024-01-19 11:08:46  MG00000007  2024-01-19 11:08:46  MG00000007  View Edit Delete
35  01  001  35  れんこん    れんこん    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1059  01  005  11161  とうもろこし 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
1571  01  007  6233  野菜  近郷野菜133  やさい    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2595  01  006  7151  野菜  産直野菜151  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5155  07  81  33  農産物33    のうさんぶつ33    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5411  02  53  41  農産物41    のうさんぶつ41    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6179  08  93  496241001057  わさび菜    わさびな    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6435  01  004  398704  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6691  01  002  20110599  胡瓜    きゅうり    2018-08-29 00:00:00    2018-08-29 14:55:01  MG00000001  2018-08-29 14:55:01  MG00000001  View Edit Delete
6947  08  96  695  冷凍イチゴ    れいとういちご    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2023-02-06 14:46:22  MG00000001  View Edit Delete
7203  08  97  646  プラム(太陽)    ぷらむたいよう    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete

Page 34 of 2156, showing 20 records out of 43118 total, starting on record 661, ending on 680

(default) 2 queries took 25 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`.`limited_user_id` asc LIMIT 660, 20202018
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117