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
7717  01  102  2400033508937   りんご    りんご    2019-05-20 00:00:00            View Edit Delete
7973  03  62  54  農産物54    のうさんぶつ54    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
12581  01  002  20905110  農産物①    のうさんぶつ    2022-08-02 00:00:00    2022-08-02 09:05:36  MG00000001  2022-08-02 09:05:36  MG00000001  View Edit Delete
18469  01  006  7214  野菜  産直野菜214  やさい    2022-12-27 00:00:00    2022-12-27 10:34:56  MG00000001  2022-12-27 10:34:56  MG00000001  View Edit Delete
47653  01  031  100007  100007_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 15:50:34  MG00000007  2023-10-03 15:50:34  MG00000007  View Edit Delete
47909  01  033  59328  59328_農産物  岡山農産09328  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:52:18  MG00000007  2023-10-19 13:52:18  MG00000007  View Edit Delete
50981  01  036  105861  5861_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 10:07:55  MG00000007  2023-11-28 10:07:55  MG00000007  View Edit Delete
51493  01  033  50790  50790_農産物  岡山農産00790  のうさんぶつ    2024-01-19 00:00:00    2024-01-19 11:12:25  MG00000007  2024-01-19 11:12:25  MG00000007  View Edit Delete
38  01  001  38  とうもろこし    とうもろこし    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1062  01  005  12011  セロリ 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
1574  01  007  6236  ししとう  近郷野菜136  ししとう    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2598  01  006  7154  野菜  産直野菜154  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
4134  01  006  7228  ぶなしめじ  産直野菜228  ぶなしめじ    2016-08-29 00:00:00    2017-10-20 19:37:34  MG00000001  2017-10-20 19:37:34  MG00000001  View Edit Delete
5158  07  81  36  農産物36    のうさんぶつ36    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5414  02  53  44  農産物44    のうさんぶつ44    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6182  08  93  496241001060  赤玉ねぎ    あかたまねぎ    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6438  01  004  398715  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6694  01  002  20110602  野菜    やさい    2018-08-29 00:00:00    2018-08-29 16:14:09  MG00000001  2018-08-29 16:14:09  MG00000001  View Edit Delete
6950  08  96  713  キングルビー    きんぐるびー    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7206  08  97  662  さくらんぼ(佐藤錦)    さくらんぼさとうにしき    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 16:13:00  MG00000001  View Edit Delete

Page 37 of 2156, showing 20 records out of 43118 total, starting on record 721, ending on 740

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