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
8233  02  51  569  菊芋    きくいも    2019-12-09 00:00:00    2019-12-09 11:05:34  MG00000001  2019-12-09 11:05:34  MG00000001  View Edit Delete
12585  01  002  20905114  農産物⑤    のうさんぶつ    2022-08-02 00:00:00    2022-08-02 09:30:39  MG00000001  2022-08-02 09:30:39  MG00000001  View Edit Delete
18473  01  002  20110805  野菜    やさい    2022-12-28 00:00:00    2022-12-28 09:30:11  MG00000001  2022-12-28 09:30:11  MG00000001  View Edit Delete
45097  01  033  51659  51659_農産物  岡山農産01659  のうさんぶつ    2023-07-25 00:00:00    2023-07-25 12:19:16  MG00000001  2023-07-25 12:19:16  MG00000001  View Edit Delete
46121  01  033  51670  51670_農産物  岡山農産01670  のうさんぶつ    2023-08-21 00:00:00    2023-08-21 13:42:24  MG00000001  2023-08-21 13:42:24  MG00000001  View Edit Delete
47657  01  031  100014  100014_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 15:59:44  MG00000007  2023-10-03 15:59:44  MG00000007  View Edit Delete
47913  01  033  59332  59332_農産物  岡山農産09332  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:57:03  MG00000007  2023-10-19 13:57:03  MG00000007  View Edit Delete
50985  01  036  105865  5865_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 10:13:58  MG00000007  2023-11-28 10:13:58  MG00000007  View Edit Delete
51497  01  033  50794  50794_農産物  岡山農産00794  のうさんぶつ    2024-01-19 00:00:00    2024-01-19 11:25:11  MG00000007  2024-01-19 11:25:11  MG00000007  View Edit Delete
42  01  001  42  山菜    さんさい    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1066  01  005  12051  アスパラ 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
2602  02  51  101  トマト    とまと    2017-02-27 00:00:00            View Edit Delete
5162  07  81  40  農産物40    のうさんぶつ40    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5418  02  53  48  農産物48    のうさんぶつ48    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6186  02  52  1845  農産物    のうさんぶつ    2018-04-18 00:00:00    2018-04-18 00:00:00  MG00000001  2018-04-18 00:00:00  MG00000001  View Edit Delete
6442  01  004  398721  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6698  01  002  20110606  野菜    やさい    2018-08-31 00:00:00    2018-08-31 09:52:11  MG00000001  2018-08-31 09:52:11  MG00000001  View Edit Delete
6954  08  96  717  アンデスメロン    あんですめろん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7210  08  97  672  デラウェア    でらうぇあ    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7722  01  102  2400033508982   ぶどう    ぶどう    2019-05-20 00:00:00            View Edit Delete

Page 41 of 2156, showing 20 records out of 43118 total, starting on record 801, ending on 820

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