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
6415  01  004  343211  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6671  01  004  343648  野菜    やさい    2018-08-09 00:00:00    2018-08-09 14:59:19  MG00000001  2018-08-09 15:11:11  MG00000001  View Edit Delete
6416  01  004  343238  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6672  01  004  343650  野菜    やさい    2018-08-09 00:00:00    2018-08-09 15:02:04  MG00000001  2018-08-09 15:12:03  MG00000001  View Edit Delete
6417  01  004  343257  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6673  01  004  343651  野菜    やさい    2018-08-09 00:00:00    2018-08-09 15:03:08  MG00000001  2018-08-09 15:12:40  MG00000001  View Edit Delete
6418  01  004  343259  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6674  01  004  343649  野菜    やさい    2018-08-09 00:00:00    2018-08-09 15:13:28  MG00000001  2018-08-09 15:13:28  MG00000001  View Edit Delete
6419  01  004  343262  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6675  01  004  499646  果実    かじつ    2018-08-09 00:00:00    2018-08-09 15:16:03  MG00000001  2018-08-09 15:16:03  MG00000001  View Edit Delete
6420  01  004  343263  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6676  01  004  499647  果実    かじつ    2018-08-09 00:00:00    2018-08-09 15:16:49  MG00000001  2018-08-09 15:16:49  MG00000001  View Edit Delete
6421  01  004  343312  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6677  01  004  499648  果実    かじつ    2018-08-09 00:00:00    2018-08-09 15:17:37  MG00000001  2018-08-09 15:17:37  MG00000001  View Edit Delete
6422  01  004  343332  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6678  01  004  499649  果実    かじつ    2018-08-09 00:00:00    2018-08-09 15:18:34  MG00000001  2018-08-09 15:18:34  MG00000001  View Edit Delete
6423  01  004  343333  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6679  01  004  499650  果実    かじつ    2018-08-09 00:00:00    2018-08-09 15:19:16  MG00000001  2018-08-09 15:19:16  MG00000001  View Edit Delete
6424  01  004  343394  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6680  01  004  499651  果実    かじつ    2018-08-09 00:00:00    2018-08-09 15:20:09  MG00000001  2018-08-09 15:20:09  MG00000001  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 23 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 800, 20202016
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117