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
8569  05  71  99028  農産物    のうさんぶつ    2020-09-15 00:00:00    2020-09-15 19:55:14  MG00000005  2020-09-15 19:55:14  MG00000005  View Edit Delete
12390  04  710  99026  農産物    のうさんぶつ    2022-06-23 00:00:00    2022-06-23 11:26:53  MG00000001  2022-06-23 11:26:53  MG00000001  View Edit Delete
8565  05  71  99026  農産物    のうさんぶつ    2020-09-10 00:00:00    2020-09-10 17:14:18  MG00000005  2020-09-10 17:14:18  MG00000005  View Edit Delete
12389  04  710  99024  農産物    のうさんぶつ    2022-06-23 00:00:00    2022-06-23 11:26:53  MG00000001  2022-06-23 11:26:53  MG00000001  View Edit Delete
8558  05  71  99024  農産物    のうさんぶつ    2020-08-27 00:00:00    2020-08-27 10:31:34  MG00000005  2020-08-27 10:31:34  MG00000005  View Edit Delete
12388  04  710  99023  農産物    のうさんぶつ    2022-06-23 00:00:00    2022-06-23 11:26:53  MG00000001  2022-06-23 11:26:53  MG00000001  View Edit Delete
8557  05  71  99023  農産物    のうさんぶつ    2020-08-24 00:00:00    2020-08-24 09:20:50  MG00000005  2020-08-24 09:20:50  MG00000005  View Edit Delete
8545  05  71  99012  農産物    のうさんぶつ    2020-07-20 00:00:00    2020-07-20 11:07:25  MG00000005  2020-07-20 11:07:25  MG00000005  View Edit Delete
12387  04  710  99012  農産物    のうさんぶつ    2022-06-23 00:00:00    2022-06-23 11:26:53  MG00000001  2022-06-23 11:26:53  MG00000001  View Edit Delete
8544  05  71  99004  農産物    のうさんぶつ    2020-07-13 00:00:00    2020-07-13 14:16:11  MG00000005  2020-07-13 14:16:11  MG00000005  View Edit Delete
12386  04  710  99004  農産物    のうさんぶつ    2022-06-23 00:00:00    2022-06-23 11:26:53  MG00000001  2022-06-23 11:26:53  MG00000001  View Edit Delete
8502  05  71  99002  農産物    のうさんぶつ    2020-07-01 00:00:00    2020-07-01 13:49:47  MG00000005  2020-07-01 13:49:47  MG00000005  View Edit Delete
12385  04  710  99002  農産物    のうさんぶつ    2022-06-23 00:00:00    2022-06-23 11:26:53  MG00000001  2022-06-23 11:26:53  MG00000001  View Edit Delete
6146  03  61  99  農産物99    のうさんぶつ99    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
9219  02  56  99  農産物99    のうさんぶつ99    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
8018  03  62  99  農産物99    のうさんぶつ99    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
5469  02  53  99  農産物99    のうさんぶつ99    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
5221  07  81  99  農産物99    のうさんぶつ99    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
153  01  001  99  たまご    たまご    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2016-08-30 12:24:39  MG00000001  View Edit Delete
4059  01  003  99  たまご    たまご    2017-03-15 00:00:00            View Edit Delete

Page 4 of 2156, showing 20 records out of 43118 total, starting on record 61, ending on 80

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