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
5218  07  81  96  農産物96    のうさんぶつ96    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5219  07  81  97  農産物97    のうさんぶつ97    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5220  07  81  98  農産物98    のうさんぶつ98    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5221  07  81  99  農産物99    のうさんぶつ99    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5222  01  002  20110430  青ねぎ    あおねぎ    2018-01-09 00:00:00    2018-01-09 12:24:39  MG00000001  2018-01-09 12:24:39  MG00000001  View Edit Delete
5223  01  002  20110431  きたあかり    きたあかり    2018-01-09 00:00:00    2018-01-09 12:24:39  MG00000001  2018-01-09 12:24:39  MG00000001  View Edit Delete
5224  01  002  20110432  にんにく    にんにく    2018-01-09 00:00:00    2018-01-09 12:24:39  MG00000001  2018-01-09 12:24:39  MG00000001  View Edit Delete
5225  01  002  20110433  ししとう    ししとう    2018-01-09 00:00:00    2018-01-09 12:24:39  MG00000001  2018-01-09 12:24:39  MG00000001  View Edit Delete
5226  01  002  20110435  サラダほうれん草    さらだほうれんそう    2018-01-09 00:00:00    2018-01-09 12:24:39  MG00000001  2018-01-09 12:24:39  MG00000001  View Edit Delete
5231  02  51  512  白ネギ    しろねぎ    2018-01-16 00:00:00    2018-01-16 11:34:46  MG00000001  2018-01-16 11:34:46  MG00000001  View Edit Delete
5232  02  51  123  太ネギ    ふとねぎ    2018-01-16 00:00:00    2018-01-16 11:34:46  MG00000001  2018-01-16 11:34:46  MG00000001  View Edit Delete
5235  05  71  89724  農産物    のうさんぶつ    2018-01-24 00:00:00    2018-01-24 11:34:46  MG00000001  2018-01-24 11:34:46  MG00000001  View Edit Delete
5236  05  71  89723  農産物    のうさんぶつ    2018-01-24 00:00:00    2018-01-24 11:34:46  MG00000001  2018-01-24 11:34:46  MG00000001  View Edit Delete
5237  01  007  6381  野菜  近郷野菜281  やさい    2018-01-25 00:00:00    2018-01-25 19:37:36  MG00000001  2018-01-25 19:37:36  MG00000001  View Edit Delete
5238  01  007  6382  レタス  近郷野菜282  れたす    2018-01-25 00:00:00    2018-01-25 19:37:36  MG00000001  2018-01-25 19:37:36  MG00000001  View Edit Delete
5239  01  007  6383  グリーンリーフ  近郷野菜283  ぐりーんりーふ    2018-01-25 00:00:00    2018-01-25 19:37:36  MG00000001  2018-01-25 19:37:36  MG00000001  View Edit Delete
5240  01  007  6384  レタス  近郷野菜284  れたす    2018-01-25 00:00:00    2018-01-25 19:37:36  MG00000001  2018-01-25 19:37:36  MG00000001  View Edit Delete
5241  01  007  6385  小松菜  近郷野菜285  こまつな    2018-01-25 00:00:00    2018-01-25 19:37:36  MG00000001  2018-01-25 19:37:36  MG00000001  View Edit Delete
5242  01  007  6386  みずな  近郷野菜286  みずな    2018-01-25 00:00:00    2018-01-25 19:37:36  MG00000001  2018-01-25 19:37:36  MG00000001  View Edit Delete
5243  01  007  6387  葉物  近郷野菜287  はもの    2018-01-25 00:00:00    2018-01-25 19:37:36  MG00000001  2018-01-25 19:37:36  MG00000001  View Edit Delete

Page 71 of 2156, showing 20 records out of 43118 total, starting on record 1401, ending on 1420

(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`.`modified` asc LIMIT 1400, 20202017
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1119