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
7933  03  62  14  農産物14    のうさんぶつ14    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
6142  03  61  95  農産物95    のうさんぶつ95    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
7934  03  62  15  農産物15    のうさんぶつ15    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
6143  03  61  96  農産物96    のうさんぶつ96    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
7935  03  62  16  農産物16    のうさんぶつ16    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
6147  02  52  1839  農産物    のうさんぶつ    2018-03-22 00:00:00    2018-03-22 00:00:00  MG00000001  2018-03-22 00:00:00  MG00000001  View Edit Delete
6148  02  52  1840  農産物    のうさんぶつ    2018-03-22 00:00:00    2018-03-22 00:00:00  MG00000001  2018-03-22 00:00:00  MG00000001  View Edit Delete
6149  02  52  1841  農産物    のうさんぶつ    2018-03-22 00:00:00    2018-03-22 00:00:00  MG00000001  2018-03-22 00:00:00  MG00000001  View Edit Delete
6150  02  51  533  わらび    わらび    2018-03-29 00:00:00    2018-03-29 00:00:00  MG00000001  2018-03-29 00:00:00  MG00000001  View Edit Delete
6151  01  006  7240  野菜  産直野菜240  やさい    2018-04-02 00:00:00    2018-04-02 19:37:34  MG00000001  2018-04-02 19:37:34  MG00000001  View Edit Delete
6152  01  006  7293  小松菜  産直野菜293  こまつな    2018-04-02 00:00:00    2018-04-02 19:37:34  MG00000001  2018-04-02 19:37:34  MG00000001  View Edit Delete
6153  02  52  1843  農産物    のうさんぶつ    2018-04-03 00:00:00    2018-04-03 00:00:00  MG00000001  2018-04-03 00:00:00  MG00000001  View Edit Delete
6155  02  54  78522  農産物    のうさんぶつ    2018-04-11 00:00:00    2018-04-11 00:00:00  MG00000001  2018-04-11 00:00:00  MG00000001  View Edit Delete
6156  02  54  78565  農産物    のうさんぶつ    2018-04-11 00:00:00    2018-04-11 00:00:00  MG00000001  2018-04-11 00:00:00  MG00000001  View Edit Delete
6157  02  54  78581  農産物    のうさんぶつ    2018-04-11 00:00:00    2018-04-11 00:00:00  MG00000001  2018-04-11 00:00:00  MG00000001  View Edit Delete
6158  02  51  763  コスレタス    こすれたす    2018-04-11 00:00:00    2018-04-11 00:00:00  MG00000001  2018-04-11 00:00:00  MG00000001  View Edit Delete
6159  02  51  109  水ナス    みずなす    2018-04-11 00:00:00    2018-04-11 00:00:00  MG00000001  2018-04-11 00:00:00  MG00000001  View Edit Delete
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

Page 102 of 2156, showing 20 records out of 43118 total, starting on record 2021, ending on 2040

(default) 2 queries took 27 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`.`use_start_day` asc LIMIT 2020, 20202018
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1119