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
5260  02  52  1665  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
7820  02  55  2132179  農産物    のうさんぶつ    2019-06-20 00:00:00    2019-06-20 16:08:18  MG00000001  2019-06-20 16:08:18  MG00000001  View Edit Delete
2701  02  51  155  四角豆    しかくまめ    2017-02-27 00:00:00            View Edit Delete
4493  02  51  279  シークワーサー    しーくわーさー    2017-10-27 00:00:00            View Edit Delete
5261  02  52  1666  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
2702  02  51  747  イタドリ    いたどり    2017-02-27 00:00:00            View Edit Delete
4494  02  51  122  チマサンチュ    ちまさんちゅ    2017-10-27 00:00:00            View Edit Delete
5262  02  52  1667  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
7822  02  51  752  えごま    えごま    2019-06-25 00:00:00    2019-06-25 08:58:49  MG00000001  2019-06-25 08:58:49  MG00000001  View Edit Delete
2703  02  51  759  スイスチャード    すいすちゃーど    2017-02-27 00:00:00            View Edit Delete
5263  02  52  1668  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
2704  02  51  766  茎ブロッコリー    くきぶろっこりー    2017-02-27 00:00:00            View Edit Delete
5264  02  52  1669  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
2705  02  51  775  高菜    たかな    2017-02-27 00:00:00            View Edit Delete
5265  02  52  1670  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
9105  02  51  202  小玉スイカ    こだますいか    2021-01-29 00:00:00    2021-01-29 15:23:24  MG00000005  2021-01-29 15:23:24  MG00000005  View Edit Delete
2706  02  51  777  サラダごぼう    さらだごぼう    2017-02-27 00:00:00            View Edit Delete
5266  02  52  1671  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
2707  02  51  783  ローズマリー    ろーずまりー    2017-02-27 00:00:00            View Edit Delete
5267  02  52  1672  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete

Page 144 of 2156, showing 20 records out of 43118 total, starting on record 2861, ending on 2880

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