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
5249  02  51  711  たらの芽    たらのめ    2018-02-05 00:00:00            View Edit Delete
7297  02  51  543  ミディトマト    みでぃとまと    2019-02-05 00:00:00    2019-02-05 13:57:49  MG00000001  2019-02-05 13:57:49  MG00000001  View Edit Delete
7809  02  55  2132169  農産物    のうさんぶつ    2019-06-20 00:00:00    2019-06-20 15:21:22  MG00000001  2019-06-20 15:21:22  MG00000001  View Edit Delete
2690  02  51  589  パセリ    ぱせり    2017-02-27 00:00:00            View Edit Delete
5250  02  52  1648  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
7810  02  55  2132167  農産物    のうさんぶつ    2019-06-20 00:00:00    2019-06-20 15:24:44  MG00000001  2019-06-20 15:24:44  MG00000001  View Edit Delete
2691  02  51  595  三豊ナス    みとよなす    2017-02-27 00:00:00            View Edit Delete
5251  02  52  1649  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
7299  02  52  2159  農産物    のうさんぶつ    2019-02-18 00:00:00    2019-02-18 08:59:35  MG00000001  2019-02-18 08:59:35  MG00000001  View Edit Delete
7811  02  55  2132176  農産物    のうさんぶつ    2019-06-20 00:00:00    2019-06-20 15:28:57  MG00000001  2019-06-20 15:28:57  MG00000001  View Edit Delete
2692  02  51  597  アイスプラント    あいすぷらんと    2017-02-27 00:00:00            View Edit Delete
5252  02  52  1650  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
7300  02  52  2160  農産物    のうさんぶつ    2019-02-18 00:00:00    2019-02-18 09:00:30  MG00000001  2019-02-18 09:00:30  MG00000001  View Edit Delete
7812  02  55  2132163  農産物    のうさんぶつ    2019-06-20 00:00:00    2019-06-20 15:30:09  MG00000001  2019-06-20 15:30:09  MG00000001  View Edit Delete
2693  02  51  701  伏見甘長唐辛子    ふしみあまながとうがらし    2017-02-27 00:00:00            View Edit Delete
5253  02  52  1651  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
7301  02  51  564  青ネギ    あおねぎ    2019-02-19 00:00:00    2019-02-19 09:12:01  MG00000001  2020-01-07 16:37:45  MG00000001  View Edit Delete
7813  02  55  2132162  農産物    のうさんぶつ    2019-06-20 00:00:00    2019-06-20 15:31:27  MG00000001  2019-06-20 15:31:27  MG00000001  View Edit Delete
2694  02  51  702  ケール    けーる    2017-02-27 00:00:00            View Edit Delete
5254  02  52  1652  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete

Page 142 of 2156, showing 20 records out of 43118 total, starting on record 2821, ending on 2840

(default) 2 queries took 25 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`.`trader_id` desc LIMIT 2820, 20202018
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117