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
5411  02  53  41  農産物41    のうさんぶつ41    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
5412  02  53  42  農産物42    のうさんぶつ42    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
5413  02  53  43  農産物43    のうさんぶつ43    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
5414  02  53  44  農産物44    のうさんぶつ44    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
5415  02  53  45  農産物45    のうさんぶつ45    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
5416  02  53  46  農産物46    のうさんぶつ46    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
5417  02  53  47  農産物47    のうさんぶつ47    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6185  02  52  1844  農産物    のうさんぶつ    2018-04-13 00:00:00    2018-04-13 00:00:00  MG00000001  2018-04-13 00:00:00  MG00000001  View Edit Delete
8233  02  51  569  菊芋    きくいも    2019-12-09 00:00:00    2019-12-09 11:05:34  MG00000001  2019-12-09 11:05:34  MG00000001  View Edit Delete
2602  02  51  101  トマト    とまと    2017-02-27 00:00:00            View Edit Delete
5418  02  53  48  農産物48    のうさんぶつ48    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6186  02  52  1845  農産物    のうさんぶつ    2018-04-18 00:00:00    2018-04-18 00:00:00  MG00000001  2018-04-18 00:00:00  MG00000001  View Edit Delete
8234  02  51  353  春キャベツ    はるきゃべつ    2019-12-10 00:00:00    2019-12-10 14:56:19  MG00000001  2019-12-10 14:56:19  MG00000001  View Edit Delete
10794  02  51  110  坊ちゃんかぼちゃ    ぼっちゃんかぼちゃ    2021-08-18 00:00:00    2021-08-18 11:30:51  MG00000001  2021-08-18 11:30:51  MG00000001  View Edit Delete
2603  02  51  103  ヨウサイ(空芯菜)    ようさいくうしんさい    2017-02-27 00:00:00        2020-04-24 10:41:05  MG00000001  View Edit Delete
5419  02  53  49  農産物49    のうさんぶつ49    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
2604  02  51  104  タマネギ    たまねぎ    2017-02-27 00:00:00            View Edit Delete
5420  02  53  50  農産物50    のうさんぶつ50    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
2605  02  51  105  ジャガイモ    じゃがいも    2017-02-27 00:00:00            View Edit Delete
5421  02  53  51  農産物51    のうさんぶつ51    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete

Page 125 of 2156, showing 20 records out of 43118 total, starting on record 2481, ending on 2500

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