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
5490  02  52  1799  農産物    のうさんぶつ    2018-03-05 00:00:00    2018-03-05 00:00:00  MG00000001  2018-03-05 00:00:00  MG00000001  View Edit Delete
7282  02  51  364  かぶ(もものすけ)    かぶもものすけ    2018-12-25 00:00:00    2018-12-25 11:32:44  MG00000001  2018-12-25 11:32:44  MG00000001  View Edit Delete
12402  02  52  3132  農産物    のうさんぶつ    2022-06-30 00:00:00    2022-06-30 09:41:42  MG00000001  2022-06-30 09:41:42  MG00000001  View Edit Delete
2675  02  51  530  原木生椎茸    げんぼくなましいたけ    2017-02-27 00:00:00            View Edit Delete
3955  02  51  124  アスパラガス    あすぱらがす    2017-02-27 00:00:00            View Edit Delete
5491  02  52  1819  農産物    のうさんぶつ    2018-03-05 00:00:00    2018-03-05 00:00:00  MG00000001  2018-03-05 00:00:00  MG00000001  View Edit Delete
7283  02  54  44466  農産物    のうさんぶつ    2019-01-16 00:00:00    2019-01-16 09:26:23  MG00000001  2019-01-16 09:26:23  MG00000001  View Edit Delete
2676  02  51  531  ふきのとう    ふきのとう    2017-02-27 00:00:00            View Edit Delete
3956  02  51  153  サラダ菜    さらだな    2017-06-13 11:57:28            View Edit Delete
5492  02  52  1820  農産物    のうさんぶつ    2018-03-05 00:00:00    2018-03-05 00:00:00  MG00000001  2018-03-05 00:00:00  MG00000001  View Edit Delete
7284  02  54  44474  農産物    のうさんぶつ    2019-01-16 00:00:00    2019-01-16 09:28:23  MG00000001  2019-01-16 09:28:23  MG00000001  View Edit Delete
8564  02  55  2136771  農産物    のうさんぶつ    2020-09-10 00:00:00    2020-09-10 16:02:59  MG00000005  2020-09-10 16:02:59  MG00000005  View Edit Delete
2677  02  51  532  ふき    ふき    2017-02-27 00:00:00            View Edit Delete
5493  02  52  1821  農産物    のうさんぶつ    2018-03-05 00:00:00    2018-03-05 00:00:00  MG00000001  2018-03-05 00:00:00  MG00000001  View Edit Delete
7285  02  54  44512  農産物    のうさんぶつ    2019-01-16 00:00:00    2019-01-16 09:29:24  MG00000001  2019-01-16 09:29:24  MG00000001  View Edit Delete
2678  02  51  539  梅    うめ    2017-02-27 00:00:00            View Edit Delete
3958  02  51  556  生姜    しょうが    2017-06-30 00:00:00            View Edit Delete
5494  02  52  1822  農産物    のうさんぶつ    2018-03-05 00:00:00    2018-03-05 00:00:00  MG00000001  2018-03-05 00:00:00  MG00000001  View Edit Delete
7286  02  51  363  ミニ白菜    みにはくさい    2019-01-16 00:00:00    2019-01-16 09:34:23  MG00000001  2019-01-16 09:34:23  MG00000001  View Edit Delete
8566  02  51  231  さくらんぼ    さくらんぼ    2020-09-15 00:00:00    2020-09-15 13:13:52  MG00000005  2020-09-15 13:13:52  MG00000005  View Edit Delete

Page 139 of 2156, showing 20 records out of 43118 total, starting on record 2761, ending on 2780

(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 2760, 20202018
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117