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
139  01  001  85  野菜    やさい    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2018-05-28 17:29:36  MG00000001  View Edit Delete
6132  03  61  85  農産物85    のうさんぶつ85    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
9205  02  56  85  農産物85    のうさんぶつ85    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
8003  03  62  84  農産物84    のうさんぶつ84    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
5454  02  53  84  農産物84    のうさんぶつ84    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
5206  07  81  84  農産物84    のうさんぶつ84    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
138  01  001  84  栗    くり    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
4047  01  003  84  栗    くり    2017-03-15 00:00:00            View Edit Delete
6131  03  61  84  農産物84    のうさんぶつ84    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
9204  02  56  84  農産物84    のうさんぶつ84    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
7020  02  54  83135  農産物    のうさんぶつ    2018-10-24 00:00:00    2018-10-24 10:21:58  MG00000001  2018-10-24 10:21:58  MG00000001  View Edit Delete
7014  02  54  83127  農産物    のうさんぶつ    2018-10-22 00:00:00    2018-10-22 13:43:03  MG00000001  2018-10-22 13:43:03  MG00000001  View Edit Delete
7013  02  54  83119  農産物    のうさんぶつ    2018-10-22 00:00:00    2018-10-22 13:40:33  MG00000001  2018-10-22 13:40:33  MG00000001  View Edit Delete
6977  02  54  83097  農産物    のうさんぶつ    2018-10-09 00:00:00    2018-10-09 09:19:46  MG00000001  2018-10-09 09:19:46  MG00000001  View Edit Delete
6754  02  54  83089  農産物    のうさんぶつ    2018-09-21 00:00:00    2018-09-21 12:54:53  MG00000001  2018-09-21 12:54:53  MG00000001  View Edit Delete
6685  02  54  83062  農産物    のうさんぶつ    2018-08-20 00:00:00    2018-08-20 14:52:46  MG00000001  2018-08-20 14:52:46  MG00000001  View Edit Delete
6684  02  54  83054  農産物    のうさんぶつ    2018-08-20 00:00:00    2018-08-20 14:52:16  MG00000001  2018-08-20 14:52:16  MG00000001  View Edit Delete
6683  02  54  83046  農産物    のうさんぶつ    2018-08-20 00:00:00    2018-08-20 14:51:53  MG00000001  2018-08-20 14:51:53  MG00000001  View Edit Delete
6681  02  54  83038  農産物    のうさんぶつ    2018-08-20 00:00:00    2018-08-20 14:49:52  MG00000001  2018-08-20 14:49:52  MG00000001  View Edit Delete
6409  02  54  83011  農産物    のうさんぶつ    2018-07-30 00:00:00    2018-07-30 11:39:39  MG00000001  2018-07-30 11:39:39  MG00000001  View Edit Delete

Page 43 of 2156, showing 20 records out of 43118 total, starting on record 841, ending on 860

(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`.`co_product_cd` desc LIMIT 840, 20202019
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1118