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
18485  01  002  20110816  野菜    やさい    2023-01-05 00:00:00    2023-01-05 15:57:10  MG00000001  2023-01-05 15:57:10  MG00000001  View Edit Delete
6710  01  002  20110616  小松菜    こまつな    2018-09-03 00:00:00    2018-09-03 09:44:31  MG00000001  2018-09-03 09:44:31  MG00000001  View Edit Delete
10294  01  002  20904947  野菜    やさい    2021-04-02 00:00:00    2021-04-02 17:17:35  MG00000005  2021-04-02 17:17:35  MG00000005  View Edit Delete
12598  01  002  20905107  農産物⑧    のうさんぶつ    2022-08-02 00:00:00    2022-08-02 09:40:33  MG00000001  2022-08-02 09:40:33  MG00000001  View Edit Delete
18486  01  002  20110818  野菜    やさい    2023-01-06 00:00:00    2023-01-06 08:07:59  MG00000001  2023-01-06 08:07:59  MG00000001  View Edit Delete
6711  01  002  20110617  野菜    やさい    2018-09-03 00:00:00    2018-09-03 09:44:59  MG00000001  2018-09-03 09:44:59  MG00000001  View Edit Delete
12599  01  002  20905108  農産物⑨    のうさんぶつ    2022-08-02 00:00:00    2022-08-02 09:40:49  MG00000001  2022-08-02 09:40:49  MG00000001  View Edit Delete
18487  01  002  20110817  野菜    やさい    2023-01-06 00:00:00    2023-01-06 08:10:14  MG00000001  2023-01-06 08:10:14  MG00000001  View Edit Delete
6712  01  002  20110618  野菜    やさい    2018-09-03 00:00:00    2018-09-03 09:45:31  MG00000001  2018-09-03 09:45:31  MG00000001  View Edit Delete
8248  01  002  20110592  10592_農産物    のうさんぶつ    2020-01-31 00:00:00    2020-01-31 09:42:12  MG00000001  2023-06-21 13:17:43  MG00000001  View Edit Delete
12600  01  002  20905109  農産物⑩    のうさんぶつ    2022-08-02 00:00:00    2022-08-02 09:41:05  MG00000001  2022-08-02 09:41:05  MG00000001  View Edit Delete
18488  01  002  20110819  野菜    やさい    2023-01-06 00:00:00    2023-01-06 08:52:20  MG00000001  2023-01-06 08:52:20  MG00000001  View Edit Delete
6713  01  002  20110619  茄子    なす    2018-09-03 00:00:00    2018-09-03 09:46:02  MG00000001  2018-09-03 09:46:02  MG00000001  View Edit Delete
8249  01  002  20120229  果実    かじつ    2020-01-31 00:00:00    2020-01-31 09:49:50  MG00000001  2020-01-31 09:49:50  MG00000001  View Edit Delete
18489  01  002  20110820  野菜    やさい    2023-01-06 00:00:00    2023-01-06 10:02:54  MG00000001  2023-01-06 10:02:54  MG00000001  View Edit Delete
6714  01  002  20110620  茄子    なす    2018-09-03 00:00:00    2018-09-03 09:46:37  MG00000001  2018-09-03 09:46:37  MG00000001  View Edit Delete
8250  01  002  20120180  果実    かじつ    2020-01-31 00:00:00    2020-01-31 09:57:47  MG00000001  2020-01-31 09:57:47  MG00000001  View Edit Delete
18490  01  002  20110821  野菜    やさい    2023-01-06 00:00:00    2023-01-06 10:04:28  MG00000001  2023-01-06 10:04:28  MG00000001  View Edit Delete
6715  01  002  20110621  野菜    やさい    2018-09-03 00:00:00    2018-09-03 09:47:36  MG00000001  2018-09-03 09:47:36  MG00000001  View Edit Delete
8251  01  002  20120181  みかん    みかん    2020-01-31 00:00:00    2020-01-31 09:58:22  MG00000001  2020-01-31 09:58:22  MG00000001  View Edit Delete

Page 10 of 2156, showing 20 records out of 43118 total, starting on record 181, ending on 200

(default) 2 queries took 27 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`.`company_cd` asc LIMIT 180, 20202020
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117