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
7302  02  51  805  シャインマスカット    しゃいんますかっと    2019-02-19 00:00:00    2019-02-19 09:20:12  MG00000001  2019-02-19 09:20:12  MG00000001  View Edit Delete
7814  02  55  2132164  農産物    のうさんぶつ    2019-06-20 00:00:00    2019-06-20 15:34:09  MG00000001  2019-06-20 15:34:09  MG00000001  View Edit Delete
2695  02  51  703  レンコン    れんこん    2017-02-27 00:00:00            View Edit Delete
5255  02  52  1653  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
7303  02  52  2192  農産物    のうさんぶつ    2019-02-20 00:00:00    2019-02-20 09:52:43  MG00000001  2019-02-20 09:52:43  MG00000001  View Edit Delete
7815  02  55  2132165  農産物    のうさんぶつ    2019-06-20 00:00:00    2019-06-20 15:48:39  MG00000001  2019-06-20 15:48:39  MG00000001  View Edit Delete
2696  02  51  707  バジル    ばじる    2017-02-27 00:00:00            View Edit Delete
5256  02  52  1654  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
7304  02  54  44881  農産物    のうさんぶつ    2019-02-20 00:00:00    2019-02-20 09:53:17  MG00000001  2019-02-20 09:53:17  MG00000001  View Edit Delete
7816  02  55  2132172  農産物    のうさんぶつ    2019-06-20 00:00:00    2019-06-20 15:50:40  MG00000001  2019-06-20 15:50:40  MG00000001  View Edit Delete
2697  02  51  708  ビーツ    びーつ    2017-02-27 00:00:00            View Edit Delete
5257  02  52  1655  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
7817  02  55  2132173  農産物    のうさんぶつ    2019-06-20 00:00:00    2019-06-20 15:56:54  MG00000001  2019-06-20 15:56:54  MG00000001  View Edit Delete
2698  02  51  727  クレソン    くれそん    2017-02-27 00:00:00        2019-02-22 15:14:38  MG00000001  View Edit Delete
5258  02  52  1656  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
7818  02  55  2132177  農産物    のうさんぶつ    2019-06-20 00:00:00    2019-06-20 16:01:16  MG00000001  2019-06-20 16:01:16  MG00000001  View Edit Delete
2699  02  51  730  グリーンリーフ    ぐりーんりーふ    2017-02-27 00:00:00            View Edit Delete
5259  02  52  1657  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
7819  02  55  2132178  農産物    のうさんぶつ    2019-06-20 00:00:00    2019-06-20 16:06:31  MG00000001  2019-06-20 16:06:31  MG00000001  View Edit Delete
2700  02  51  744  青梅    あおうめ    2017-02-27 00:00:00            View Edit Delete

Page 143 of 2156, showing 20 records out of 43118 total, starting on record 2841, ending on 2860

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