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
969  01  003  457122595593  京の和風ジャム柚子    きょうのわふうじゃむゆず    2016-08-29 00:00:00    2016-08-30 12:24:43  MG00000001  2016-08-30 12:24:43  MG00000001  View Edit Delete
4041  01  003  78  プラム    ぷらむ    2017-03-15 00:00:00            View Edit Delete
970  01  003  457122595599  京の和風ジャム桑の実    きょうのわふうじゃむくわのみ    2016-08-29 00:00:00    2016-08-30 12:24:43  MG00000001  2016-08-30 12:24:43  MG00000001  View Edit Delete
4042  01  003  79  桃    もも    2017-03-15 00:00:00            View Edit Delete
971  01  003  457122595602  京の野菜ジャムとうもろこし    きょうのやさいじゃむとうもろこし    2016-08-29 00:00:00    2016-08-30 12:24:43  MG00000001  2016-08-30 12:24:43  MG00000001  View Edit Delete
4043  01  003  80  いちじく    いちじく    2017-03-15 00:00:00            View Edit Delete
972  01  003  457122595611  京の和風ジャム柿    きょうのわふうじゃむかき    2016-08-29 00:00:00    2016-08-30 12:24:43  MG00000001  2016-08-30 12:24:43  MG00000001  View Edit Delete
4044  01  003  81  ぶどう    ぶどう    2017-03-15 00:00:00            View Edit Delete
973  01  003  457122595620  京の野菜ジャムほおずき    きょうのやさいじゃむほおずき    2016-08-29 00:00:00    2016-08-30 12:24:43  MG00000001  2016-08-30 12:24:43  MG00000001  View Edit Delete
4045  01  003  82  梨    なし    2017-03-15 00:00:00            View Edit Delete
974  01  003  457122595623  京の和風ジャム梨    きょうのわふうじゃむなし    2016-08-29 00:00:00    2016-08-30 12:24:43  MG00000001  2016-08-30 12:24:43  MG00000001  View Edit Delete
4046  01  003  83  柿    かき    2017-03-15 00:00:00            View Edit Delete
975  01  003  457122595629  京の和風ジャム苺おれんじ    きょうのわふうじゃむいちごおれんじ    2016-08-29 00:00:00    2016-08-30 12:24:43  MG00000001  2016-08-30 12:24:43  MG00000001  View Edit Delete
4047  01  003  84  栗    くり    2017-03-15 00:00:00            View Edit Delete
976  01  003  457122595631  京の和風ジャム丹波赤かぶ    きょうのわふうじゃむたんばあかかぶ    2016-08-29 00:00:00    2016-08-30 12:24:43  MG00000001  2016-08-30 12:24:43  MG00000001  View Edit Delete
4048  01  003  87  フラワー    ふらわー    2017-03-15 00:00:00            View Edit Delete
977  01  003  457122595633  京の野菜ジャム九条ねぎ    きょうのやさいじゃむくじょうねぎ    2016-08-29 00:00:00    2016-08-30 12:24:43  MG00000001  2016-08-30 12:24:43  MG00000001  View Edit Delete
4049  01  003  88  虫・魚    むしさかな    2017-03-15 00:00:00            View Edit Delete
978  01  003  458016844082  みちこ有機ぽんず    みちこゆうきぽんず    2016-08-29 00:00:00    2016-08-30 12:24:43  MG00000001  2016-08-30 12:24:43  MG00000001  View Edit Delete
4050  01  003  89  お米    おこめ    2017-03-15 00:00:00            View Edit Delete

Page 38 of 2156, showing 20 records out of 43118 total, starting on record 741, ending on 760

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