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
2631  02  51  158  チンゲン菜    ちんげんさい    2017-02-27 00:00:00            View Edit Delete
6215  02  51  221  温州みかん    うんしゅうみかん    2018-05-22 00:00:00    2018-05-22 13:06:01  MG00000001  2018-05-22 13:06:01  MG00000001  View Edit Delete
8263  02  51  593  セレベス    せれべす    2020-03-18 00:00:00    2020-03-18 15:05:06  MG00000001  2020-03-18 15:05:06  MG00000001  View Edit Delete
2632  02  51  160  かぶ    かぶ    2017-02-27 00:00:00            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
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
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
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
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
6221  02  51  215  黄金柑    おうごんかん    2018-05-22 00:00:00    2018-05-22 13:39:40  MG00000001  2018-05-22 13:39:40  MG00000001  View Edit Delete

Page 312 of 2156, showing 20 records out of 43118 total, starting on record 6221, ending on 6240

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