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
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
5244  01  002  20110374  野菜    やさい    2018-01-30 00:00:00    2018-01-30 12:24:39  MG00000001  2018-01-30 12:24:39  MG00000001  View Edit Delete
5245  02  51  354  こどもピーマン    こどもピーマン    2018-02-05 00:00:00            View Edit Delete
5246  02  51  568  パプリカ    ぱぷりか    2018-02-05 00:00:00            View Edit Delete
5247  02  51  211  イチジク    いちじく    2018-02-05 00:00:00            View Edit Delete
5248  02  51  524  エンドウ豆    えんどうまめ    2018-02-05 00:00:00            View Edit Delete
5249  02  51  711  たらの芽    たらのめ    2018-02-05 00:00:00            View Edit Delete
5250  02  52  1648  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
5251  02  52  1649  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
5252  02  52  1650  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
5253  02  52  1651  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
5254  02  52  1652  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
5255  02  52  1653  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
5256  02  52  1654  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete

Page 69 of 2156, showing 20 records out of 43118 total, starting on record 1361, ending on 1380

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