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
9181  02  56  61  農産物61    のうさんぶつ61    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
4062  02  51  308  切り花    きりばな    2017-08-29 00:00:00            View Edit Delete
5342  02  54  78093  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
7902  02  51  509  ひらたけ    ひらたけ    2019-07-29 00:00:00    2019-07-29 12:42:46  MG00000001  2019-07-29 12:42:46  MG00000001  View Edit Delete
8158  02  51  373  カラフルトマト    からふるとまと    2019-11-25 00:00:00    2019-11-25 10:55:37  MG00000001  2019-11-25 10:55:37  MG00000001  View Edit Delete
9182  02  56  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
4063  02  51  309  サカキ    さかき    2017-08-29 00:00:00            View Edit Delete
5343  02  54  78107  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
7903  02  55  2132174  農産物    のうさんぶつ    2019-07-29 00:00:00    2019-07-29 16:44:18  MG00000001  2019-07-29 16:44:18  MG00000001  View Edit Delete
8159  02  51  163  かつお菜    かつおな    2019-11-25 00:00:00    2019-11-25 11:32:32  MG00000001  2019-11-25 11:32:32  MG00000001  View Edit Delete
9183  02  56  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
2784  02  51  984  黒キャベツ    くろきゃべつ    2017-03-13 00:00:00            View Edit Delete
4064  02  51  310  しきび    しきび    2017-08-29 00:00:00            View Edit Delete
5344  02  54  78131  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
7904  02  54  45004  農産物    のうさんぶつ    2019-07-30 00:00:00    2019-07-30 10:07:13  MG00000001  2019-07-30 10:07:13  MG00000001  View Edit Delete
8160  02  51  374  青パパイヤ    あおぱぱいや    2019-11-25 00:00:00    2019-11-25 11:44:44  MG00000001  2019-11-25 11:44:44  MG00000001  View Edit Delete
9184  02  56  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
2785  02  51  522  わさび菜    わさびな    2017-03-22 15:18:13            View Edit Delete
4065  02  51  327  荒神松    こうじんまつ    2017-08-29 00:00:00            View Edit Delete
5345  02  54  78204  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete

Page 154 of 2156, showing 20 records out of 43118 total, starting on record 3061, ending on 3080

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