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
4076  02  51  329  切り花(和セット)    きりばなわせっと    2017-09-05 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
4077  02  51  311  高野槙    こうやまき    2017-09-05 00:00:00    2017-04-18 13:36:00  MG00000001  2019-02-26 11:06:23  MG00000001  View Edit Delete
4078  02  51  336  根付しきび    ねつきしきび    2017-09-05 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
4079  02  51  335  しきび大    しきびだい    2017-09-05 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
4080  02  51  333  しきび小    しきびしょう    2017-09-05 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
4081  02  51  328  サカキ小    さかきしょう    2017-09-05 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
4082  02  51  399  生け花【その他】    いけばなそのた    2017-09-05 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
4083  02  51  115  ダイダイ    だいだい    2017-09-05 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
4084  02  51  147  インゲン    いんげん    2017-09-05 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
4085  02  51  541  ゆず    ゆず    2017-09-05 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
4086  02  51  963  フェイジョア    ふぇいじょあ    2017-09-05 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
4087  02  51  715  マコモダケ    まこもだけ    2017-09-20 00:00:00            View Edit Delete
4088  02  51  563  ウコン    うこん    2017-09-20 00:00:00            View Edit Delete
4089  02  51  740  ヤングコーン    やんぐこーん    2017-09-20 00:00:00            View Edit Delete
4090  02  51  767  七草    ななくさ    2017-09-20 00:00:00            View Edit Delete
4092  02  51  710  フルーツトマト    ふるーつとまと    2017-10-17 00:00:00            View Edit Delete
4093  02  51  140  うり    うり    2017-10-17 00:00:00            View Edit Delete
4493  02  51  279  シークワーサー    しーくわーさー    2017-10-27 00:00:00            View Edit Delete
4494  02  51  122  チマサンチュ    ちまさんちゅ    2017-10-27 00:00:00            View Edit Delete
4995  05  71  89607  農産物    のうさんぶつ    2017-11-01 00:00:00    2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete

Page 56 of 2156, showing 20 records out of 43118 total, starting on record 1101, ending on 1120

(default) 2 queries took 23 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`.`use_start_day` asc LIMIT 1100, 20202015
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1118