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
8267  02  51  270  豊水なし    ほうすいなし    2020-03-18 00:00:00    2020-03-18 15:29:31  MG00000001  2020-03-18 15:29:31  MG00000001  View Edit Delete
12875  01  002  20110769  野菜    やさい    2022-08-31 00:00:00    2022-08-31 20:12:42  MG00000005  2022-08-31 20:12:42  MG00000005  View Edit Delete
13131  01  002  20110400  野菜    やさい    2022-09-30 00:00:00    2022-09-30 14:12:40  MG00000001  2022-09-30 14:12:40  MG00000001  View Edit Delete
18507  01  002  20110425  野菜    やさい    2023-01-26 00:00:00    2023-01-26 08:53:05  MG00000001  2023-01-26 08:53:05  MG00000001  View Edit Delete
42571  01  114  12440  2440_農産物1    のうさんぶつ    2023-04-18 00:00:00    2023-04-18 11:49:38  MG00000001  2023-04-18 11:49:38  MG00000001  View Edit Delete
47691  01  035  102120  2510212000000_農産物  産地直送 野菜212  のうさんぶつ    2023-10-12 00:00:00    2023-10-12 14:35:15  MG00000007  2023-10-12 14:35:15  MG00000007  View Edit Delete
47947  01  036  105570  5570_農産物4    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 12:03:35  MG00000007  2023-10-20 12:03:35  MG00000007  View Edit Delete
51019  01  036  109179  9179_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 15:37:29  MG00000007  2023-11-28 15:37:29  MG00000007  View Edit Delete
76  01  001  47  たけのこ    たけのこ    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1100  01  005  14031  さつま芋 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
2636  02  51  168  大根菜    だいこんな    2017-02-27 00:00:00            View Edit Delete
2892  01  006  7287  果物  産直野菜287  くだもの    2016-08-29 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
5196  07  81  74  農産物74    のうさんぶつ74    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5452  02  53  82  農産物82    のうさんぶつ82    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6220  02  51  254  せとか    せとか    2018-05-22 00:00:00    2018-05-22 13:32:05  MG00000001  2018-05-22 13:32:05  MG00000001  View Edit Delete
6476  01  004  472727  果物    くだもの    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6732  01  002  20110638  茄子    なす    2018-09-04 00:00:00    2018-09-04 09:19:11  MG00000001  2018-09-04 09:19:11  MG00000001  View Edit Delete
6988  01  002  20110561  野菜    やさい    2018-10-11 00:00:00    2018-10-11 10:26:44  MG00000001  2018-10-11 10:26:44  MG00000001  View Edit Delete
7244  08  97  766  みかんジュース    みかんじゅーす    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
8012  03  62  93  農産物93    のうさんぶつ93    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete

Page 77 of 2156, showing 20 records out of 43118 total, starting on record 1521, ending on 1540

(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 1520, 20202019
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117