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
7976  03  62  57  農産物57    のうさんぶつ57    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
12584  01  002  20905113  農産物④    のうさんぶつ    2022-08-02 00:00:00    2022-08-02 09:30:18  MG00000001  2022-08-02 09:30:18  MG00000001  View Edit Delete
18472  01  002  20110804  野菜    やさい    2022-12-27 00:00:00    2022-12-27 13:52:50  MG00000001  2022-12-27 13:52:50  MG00000001  View Edit Delete
46120  01  033  51669  51669_農産物  岡山農産01669  のうさんぶつ    2023-08-21 00:00:00    2023-08-21 13:40:55  MG00000001  2023-08-21 13:40:55  MG00000001  View Edit Delete
47656  01  031  100013  100013_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 15:58:24  MG00000007  2023-10-03 15:58:24  MG00000007  View Edit Delete
47912  01  033  59331  59331_農産物  岡山農産09331  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:55:50  MG00000007  2023-10-19 13:55:50  MG00000007  View Edit Delete
50984  01  036  105864  5864_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 10:12:30  MG00000007  2023-11-28 10:12:30  MG00000007  View Edit Delete
51496  01  033  50793  50793_農産物  岡山農産00793  のうさんぶつ    2024-01-19 00:00:00    2024-01-19 11:24:11  MG00000007  2024-01-19 11:24:11  MG00000007  View Edit Delete
41  01  001  41  わらび    わらび    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2024-02-27 14:34:15  MG00000001  View Edit Delete
1065  01  005  12041  カリフラワー 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
2601  01  006  7157  野菜  産直野菜157  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5161  07  81  39  農産物39    のうさんぶつ39    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5417  02  53  47  農産物47    のうさんぶつ47    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6185  02  52  1844  農産物    のうさんぶつ    2018-04-13 00:00:00    2018-04-13 00:00:00  MG00000001  2018-04-13 00:00:00  MG00000001  View Edit Delete
6441  01  004  398720  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6697  01  002  20110605  茄子    なす    2018-08-30 00:00:00    2018-08-30 16:43:17  MG00000001  2018-08-30 16:43:17  MG00000001  View Edit Delete
6953  08  96  716  アールスメロン    あーるすめろん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7209  08  97  671  ぶどう    ぶどう    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7721  01  102  2400033508975   ぶどう    ぶどう    2019-05-20 00:00:00            View Edit Delete
7977  03  62  58  農産物58    のうさんぶつ58    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete

Page 40 of 2156, showing 20 records out of 43118 total, starting on record 781, ending on 800

(default) 2 queries took 23 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 780, 20202016
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117