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
2616  02  51  120  オクラ    おくら    2017-02-27 00:00:00            View Edit Delete
5432  02  53  62  農産物62    のうさんぶつ62    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6200  02  54  78638  農産物    のうさんぶつ    2018-04-23 00:00:00    2018-04-23 14:58:15  MG00000001  2018-04-23 14:58:15  MG00000001  View Edit Delete
10808  02  51  376  スプラウト    すぷらうと    2021-09-27 00:00:00    2021-09-27 14:02:38  MG00000001  2021-09-27 14:02:38  MG00000001  View Edit Delete
2617  02  51  121  ゴーヤ    ごーや    2017-02-27 00:00:00            View Edit Delete
5433  02  53  63  農産物63    のうさんぶつ63    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
10809  02  51  749  豆苗    とうみょう    2021-09-27 00:00:00    2021-09-27 14:04:20  MG00000001  2021-09-27 14:04:20  MG00000001  View Edit Delete
2618  02  51  128  水菜    みずな    2017-02-27 00:00:00            View Edit Delete
5434  02  53  64  農産物64    のうさんぶつ64    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6202  02  51  741  きくらげ    きくらげ    2018-05-08 00:00:00    2018-05-08 11:39:02  MG00000001  2018-05-08 11:39:02  MG00000001  View Edit Delete
10810  02  51  764  かいわれ大根    かいわれだいこん    2021-09-27 00:00:00    2021-09-27 14:05:54  MG00000001  2021-09-27 14:05:54  MG00000001  View Edit Delete
2619  02  51  129  小松菜    こまつな    2017-02-27 00:00:00            View Edit Delete
5435  02  53  65  農産物65    のうさんぶつ65    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6203  02  52  1871  農産物    のうさんぶつ    2018-05-11 00:00:00    2018-05-11 09:25:04  MG00000001  2018-05-11 09:25:04  MG00000001  View Edit Delete
2620  02  51  133  ゴボウ    ごぼう    2017-02-27 00:00:00            View Edit Delete
5436  02  53  66  農産物66    のうさんぶつ66    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
8252  02  55  2134225  農産物    のうさんぶつ    2020-02-06 00:00:00    2020-02-06 10:01:25  MG00000001  2020-02-06 10:01:25  MG00000001  View Edit Delete
2621  02  51  136  トウモロコシ    とうもろこし    2017-02-27 00:00:00            View Edit Delete
5437  02  53  67  農産物67    のうさんぶつ67    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6205  02  51  537  イタリアンパセリ    いたりあんぱせり    2018-05-15 00:00:00    2018-05-15 10:31:59  MG00000001  2018-05-15 10:31:59  MG00000001  View Edit Delete

Page 128 of 2156, showing 20 records out of 43118 total, starting on record 2541, ending on 2560

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