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
5448  02  53  78  農産物78    のうさんぶつ78    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6216  02  51  802  愛果28号(紅まどんな)    あいかにじゅうはちごうべにまどんな    2018-05-22 00:00:00    2018-05-22 13:25:06  MG00000001  2018-05-22 13:25:06  MG00000001  View Edit Delete
8264  02  51  886  小菜    こな    2020-03-18 00:00:00    2020-03-18 15:06:50  MG00000001  2020-03-18 15:06:50  MG00000001  View Edit Delete
2633  02  51  161  白菜    はくさい    2017-02-27 00:00:00            View Edit Delete
5449  02  53  79  農産物79    のうさんぶつ79    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6217  02  51  294  ライム    らいむ    2018-05-22 00:00:00    2018-05-22 13:26:49  MG00000001  2018-05-22 13:26:49  MG00000001  View Edit Delete
8265  02  51  290  夏みかん    なつみかん    2020-03-18 00:00:00    2020-03-18 15:20:02  MG00000001  2020-03-18 15:20:02  MG00000001  View Edit Delete
2634  02  51  162  空豆    そらまめ    2017-02-27 00:00:00            View Edit Delete
5450  02  53  80  農産物80    のうさんぶつ80    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6218  02  51  245  はるみ    はるみ    2018-05-22 00:00:00    2018-05-22 13:29:38  MG00000001  2018-05-22 13:29:38  MG00000001  View Edit Delete
8266  02  51  351  だいだい    だいだい    2020-03-18 00:00:00    2020-03-18 15:26:58  MG00000001  2020-03-18 15:26:58  MG00000001  View Edit Delete
2635  02  51  167  ミニトマト    みにとまと    2017-02-27 00:00:00            View Edit Delete
5451  02  53  81  農産物81    のうさんぶつ81    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6219  02  51  298  甘平    かんぺい    2018-05-22 00:00:00    2018-05-22 13:31:24  MG00000001  2018-05-22 13:31:24  MG00000001  View Edit Delete
8267  02  51  270  豊水なし    ほうすいなし    2020-03-18 00:00:00    2020-03-18 15:29:31  MG00000001  2020-03-18 15:29:31  MG00000001  View Edit Delete
2636  02  51  168  大根菜    だいこんな    2017-02-27 00:00:00            View Edit Delete
5452  02  53  82  農産物82    のうさんぶつ82    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6220  02  51  254  せとか    せとか    2018-05-22 00:00:00    2018-05-22 13:32:05  MG00000001  2018-05-22 13:32:05  MG00000001  View Edit Delete
8268  02  51  269  幸水なし    こうすいなし    2020-03-18 00:00:00    2020-03-18 15:29:56  MG00000001  2020-03-18 15:29:56  MG00000001  View Edit Delete
2637  02  51  169  ブロッコリー    ぶろっこりー    2017-02-27 00:00:00            View Edit Delete

Page 131 of 2156, showing 20 records out of 43118 total, starting on record 2601, ending on 2620

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