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
13  01  001  13  えんどう豆    えんどうまめ    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1037  01  005  11013  きゅうり 3P    きゅうり3    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
1293  01  005  24032  グレープフルーツホワイト 2P    ぐれーぷふるーつほわいと2    2016-07-01 00:00:00    2016-08-30 12:24:45  MG00000001  2016-08-30 12:24:45  MG00000001  View Edit Delete
1549  01  007  6211  ミニトマト  近郷野菜111  みにとまと    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2573  01  006  7129  野菜  産直野菜129  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5133  07  81  11  農産物11    のうさんぶつ11    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5389  02  53  19  農産物19    のうさんぶつ19    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6157  02  54  78581  農産物    のうさんぶつ    2018-04-11 00:00:00    2018-04-11 00:00:00  MG00000001  2018-04-11 00:00:00  MG00000001  View Edit Delete
6413  01  004  343074  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6669  01  004  343646  野菜    やさい    2018-08-09 00:00:00    2018-08-09 14:58:19  MG00000001  2018-08-09 15:09:22  MG00000001  View Edit Delete
6925  08  96  641  プラム    ぷらむ    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7181  08  97  518  摘果みかん    てきかみかん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7693  01  102  2400033508609   モロヘイヤ    もろへいや    2019-05-20 00:00:00            View Edit Delete
7949  03  62  30  農産物30    のうさんぶつ30    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
18445  01  113  20904949  野菜①    やさい    2022-12-19 00:00:00    2022-12-19 13:24:52  MG00000001  2022-12-19 13:24:52  MG00000001  View Edit Delete
47629  01  032  51370  13700_農産物    のうさんぶつ    2023-09-29 00:00:00    2023-09-29 09:16:19  MG00000007  2023-09-29 09:16:19  MG00000007  View Edit Delete
47885  01  033  59304  59304_農産物  岡山農産09304  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:10:13  MG00000007  2023-10-19 13:10:13  MG00000007  View Edit Delete
49677  01  031  820609  820609_農産物9    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 11:57:56  MG00000007  2023-10-25 11:57:56  MG00000007  View Edit Delete
50957  01  036  105837  5837_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 09:20:38  MG00000007  2023-11-28 09:20:38  MG00000007  View Edit Delete
51469  01  033  50810  50810_農産物  岡山農産00810  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:25:11  MG00000007  2024-01-18 17:25:11  MG00000007  View Edit Delete

Page 13 of 2156, showing 20 records out of 43118 total, starting on record 241, ending on 260

(default) 2 queries took 26 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 240, 20202017
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1119