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
5363  02  54  76872  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
9203  02  56  83  農産物83    のうさんぶつ83    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
4084  02  51  147  インゲン    いんげん    2017-09-05 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
5364  02  54  76899  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  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
4085  02  51  541  ゆず    ゆず    2017-09-05 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
5365  02  54  47708  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  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
4086  02  51  963  フェイジョア    ふぇいじょあ    2017-09-05 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
5366  02  54  76929  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
6390  02  52  1961  農産物    のうさんぶつ    2018-07-11 00:00:00    2018-07-11 10:02:11  MG00000001  2018-07-11 10:02:11  MG00000001  View Edit Delete
7414  02  54  44938  農産物    のうさんぶつ    2019-03-29 00:00:00    2019-03-29 13:23:35  MG00000001  2019-03-29 13:23:35  MG00000001  View Edit Delete
9206  02  56  86  農産物86    のうさんぶつ86    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
4087  02  51  715  マコモダケ    まこもだけ    2017-09-20 00:00:00            View Edit Delete
5367  02  54  47538  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
6391  02  52  1962  農産物    のうさんぶつ    2018-07-11 00:00:00    2018-07-11 10:02:32  MG00000001  2018-07-11 10:02:32  MG00000001  View Edit Delete
7415  02  54  44954  農産物    のうさんぶつ    2019-03-29 00:00:00    2019-03-29 13:24:20  MG00000001  2019-03-29 13:24:20  MG00000001  View Edit Delete
9207  02  56  87  農産物87    のうさんぶつ87    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
4088  02  51  563  ウコン    うこん    2017-09-20 00:00:00            View Edit Delete
5368  02  54  47554  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete

Page 158 of 2156, showing 20 records out of 43118 total, starting on record 3141, ending on 3160

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