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
6160  08  91  496241001050  ラディッシュ    らでぃっしゅ    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6161  08  91  496241001051  からし菜    からしな    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6162  08  91  496241001052  空芯菜    くうしんさい    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6163  08  91  496241001053  モロヘイヤ    もろへいや    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6164  08  91  496241001054  つるむらさき    つるむらさき    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2019-02-25 15:32:35  MG00000001  View Edit Delete
6165  08  91  496241001055  オクラ    おくら    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6166  08  91  496241001056  ズッキーニ    ずっきーに    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6167  08  91  496241001057  わさび菜    わさびな    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6168  08  91  496241001058  ししとう    ししとう    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6169  08  91  496241001059  カブ    かぶ    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6170  08  91  496241001060  赤玉ねぎ    あかたまねぎ    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6171  08  91  496241001061  じゃが芋    じゃがいも    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
5499  08  91  496241001004  ほうれん草    ほうれんそう    2018-03-02 00:00:00    2018-03-02 00:00:00  MG00000001  2018-03-02 09:21:23  MG00000001  View Edit Delete
5500  08  91  496241001005  小松菜    こまつな    2018-03-02 00:00:00    2018-03-02 00:00:00  MG00000001  2018-03-02 09:21:23  MG00000001  View Edit Delete
5501  08  91  496241001006  ロメインレタス    ろめいんれたす    2018-03-02 00:00:00    2018-03-02 00:00:00  MG00000001  2018-03-02 09:21:23  MG00000001  View Edit Delete
5502  08  91  496241001007  リーフレタス(グリーン)    りーふれたす(ぐりーん)    2018-03-02 00:00:00    2018-03-02 00:00:00  MG00000001  2018-03-02 09:21:23  MG00000001  View Edit Delete
5503  08  91  496241001008  リーフレタス(レッド)    りーふれたす(れっど)    2018-03-02 00:00:00    2018-03-02 00:00:00  MG00000001  2018-03-02 09:21:23  MG00000001  View Edit Delete
5504  08  91  496241001009  白菜    はくさい    2018-03-02 00:00:00    2018-03-02 00:00:00  MG00000001  2018-03-02 09:21:23  MG00000001  View Edit Delete
5505  08  91  496241001010  はくさい    はくさい    2018-03-02 00:00:00    2018-03-02 00:00:00  MG00000001  2018-03-02 09:21:23  MG00000001  View Edit Delete
5506  08  91  496241001011  キャベツ    きゃべつ    2018-03-02 00:00:00    2018-03-02 00:00:00  MG00000001  2018-03-02 09:21:23  MG00000001  View Edit Delete

Page 196 of 2156, showing 20 records out of 43118 total, starting on record 3901, ending on 3920

(default) 2 queries took 36 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`.`company_cd` desc LIMIT 3900, 20202026
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 11110