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
5334  02  54  77984  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
9174  02  56  54  農産物54    のうさんぶつ54    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
5335  02  54  77992  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
9175  02  56  55  農産物55    のうさんぶつ55    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
5336  02  54  78018  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
9176  02  56  56  農産物56    のうさんぶつ56    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
5337  02  54  78026  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
9177  02  56  57  農産物57    のうさんぶつ57    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
5338  02  54  78034  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
9178  02  56  58  農産物58    のうさんぶつ58    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
5339  02  54  78042  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
9179  02  56  59  農産物59    のうさんぶつ59    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
5340  02  54  78069  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
7900  02  51  586  赤しそ    あかしそ    2019-07-24 00:00:00    2019-07-24 09:32:49  MG00000001  2019-07-24 09:32:49  MG00000001  View Edit Delete
8156  02  51  527  冬瓜    とうがん    2019-11-25 00:00:00    2019-11-25 10:19:03  MG00000001  2019-11-25 10:19:03  MG00000001  View Edit Delete
9180  02  56  60  農産物60    のうさんぶつ60    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
4061  02  51  197  洋人参    ようにんじん    2017-08-02 00:00:00            View Edit Delete
5341  02  54  78085  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
7901  02  51  776  ふだん草    ふだんそう    2019-07-24 00:00:00    2019-07-24 09:58:58  MG00000001  2019-07-24 09:58:58  MG00000001  View Edit Delete
8157  02  51  712  はやとうり    はやとうり    2019-11-25 00:00:00    2019-11-25 10:54:32  MG00000001  2019-11-25 10:54:32  MG00000001  View Edit Delete

Page 153 of 2156, showing 20 records out of 43118 total, starting on record 3041, ending on 3060

(default) 2 queries took 24 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 3040, 20202017
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117