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
6303  07  84  027402  農産物    のうさんぶつ    2018-06-26 00:00:00    2018-06-26 10:17:02  MG00000001  2018-06-26 10:17:02  MG00000001  View Edit Delete
6304  07  84  027411  農産物    のうさんぶつ    2018-06-26 00:00:00    2018-06-26 10:17:37  MG00000001  2018-06-26 10:17:37  MG00000001  View Edit Delete
6305  07  84  027424  農産物    のうさんぶつ    2018-06-26 00:00:00    2018-06-26 10:18:05  MG00000001  2018-06-26 10:18:05  MG00000001  View Edit Delete
6245  07  83  0276070  農産物    のうさんぶつ    2018-06-07 00:00:00    2018-06-07 19:15:20  MG00000001  2018-06-07 19:15:20  MG00000001  View Edit Delete
5473  07  82  0281275  地場野菜    じばやさい    2018-02-28 00:00:00    2018-02-28 00:00:00  MG00000001  2018-02-28 09:21:23  MG00000001  View Edit Delete
5474  07  82  0281276  地場果物    じばくだもの    2018-02-28 00:00:00    2018-02-28 00:00:00  MG00000001  2018-02-28 09:21:23  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
5141  07  81  19  農産物19    のうさんぶつ19    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5142  07  81  20  農産物20    のうさんぶつ20    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5143  07  81  21  農産物21    のうさんぶつ21    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5144  07  81  22  農産物22    のうさんぶつ22    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5145  07  81  23  農産物23    のうさんぶつ23    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete

Page 199 of 2156, showing 20 records out of 43118 total, starting on record 3961, ending on 3980

(default) 2 queries took 46 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 3960, 20202036
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 11110