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
5121  01  002  20110527  ほうれん草    ほうれんそう    2017-11-30 00:00:00    2016-08-30 12:24:40  MG00000001  2019-09-06 11:04:02  MG00000001  View Edit Delete
5122  01  002  20110528  小松菜    こまつな    2017-11-30 00:00:00    2016-08-30 12:24:40  MG00000001  2019-09-06 11:02:39  MG00000001  View Edit Delete
5123  01  002  20110529  ラディッシュ    らでぃっしゅ    2017-11-30 00:00:00    2016-08-30 12:24:40  MG00000001  2019-09-06 11:03:04  MG00000001  View Edit Delete
5124  01  002  20110530  サラダ水菜    さらだみずな    2017-11-30 00:00:00    2016-08-30 12:24:40  MG00000001  2019-09-06 11:03:30  MG00000001  View Edit Delete
5125  01  002  20110531  かぶ    かぶ    2017-11-30 00:00:00    2016-08-30 12:24:40  MG00000001  2019-09-06 11:03:47  MG00000001  View Edit Delete
5126  02  51  320  ユリ    ゆり    2017-12-04 00:00:00            View Edit Delete
5127  02  51  348  観葉植物    かんようしょくぶつ    2017-12-04 00:00:00            View Edit Delete
5128  02  51  349  ポット苗    ぽっとなえ    2017-12-04 00:00:00            View Edit Delete
5129  02  51  350  鉢物    はちもの    2017-12-04 00:00:00            View Edit Delete
5130  01  011  60711  農産物    のうさんぶつ    2017-12-05 00:00:00    2017-12-05 11:34:46  MG00000001  2017-12-05 11:34:46  MG00000001  View Edit Delete
5131  01  011  60712  農産物    のうさんぶつ    2017-12-05 00:00:00    2017-12-05 11:34:46  MG00000001  2017-12-05 11:34:46  MG00000001  View Edit Delete
5132  07  81  10  農産物10    のうさんぶつ10    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5133  07  81  11  農産物11    のうさんぶつ11    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5134  07  81  12  農産物12    のうさんぶつ12    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5135  07  81  13  農産物13    のうさんぶつ13    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5136  07  81  14  農産物14    のうさんぶつ14    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5137  07  81  15  農産物15    のうさんぶつ15    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5138  07  81  16  農産物16    のうさんぶつ16    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5139  07  81  17  農産物17    のうさんぶつ17    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5140  07  81  18  農産物18    のうさんぶつ18    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete

Page 63 of 2156, showing 20 records out of 43118 total, starting on record 1241, ending on 1260

(default) 2 queries took 8 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`.`id` asc LIMIT 1240, 2020201
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117