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
5470  02  54  76945  農産物    のうさんぶつ    2018-02-16 00:00:00    2018-02-16 00:00:00  MG00000001  2018-02-16 00:00:00  MG00000001  View Edit Delete
6238  02  52  1894  農産物    のうさんぶつ    2018-05-31 00:00:00    2018-05-31 12:29:40  MG00000001  2018-05-31 12:29:40  MG00000001  View Edit Delete
2655  02  51  217  桃    もも    2017-02-27 00:00:00            View Edit Delete
5471  02  54  76937  農産物    のうさんぶつ    2018-02-16 00:00:00    2018-02-16 00:00:00  MG00000001  2018-02-16 00:00:00  MG00000001  View Edit Delete
6239  02  52  1895  農産物    のうさんぶつ    2018-05-31 00:00:00    2018-05-31 12:30:07  MG00000001  2018-05-31 12:30:07  MG00000001  View Edit Delete
2656  02  51  218  スイカ    すいか    2017-02-27 00:00:00            View Edit Delete
5472  02  54  76902  農産物    のうさんぶつ    2018-02-16 00:00:00    2018-02-16 00:00:00  MG00000001  2018-02-16 00:00:00  MG00000001  View Edit Delete
6240  02  52  1896  農産物    のうさんぶつ    2018-05-31 00:00:00    2018-05-31 12:30:37  MG00000001  2018-05-31 12:30:37  MG00000001  View Edit Delete
2657  02  51  219  栗    くり    2017-02-27 00:00:00            View Edit Delete
6241  02  52  1897  農産物    のうさんぶつ    2018-05-31 00:00:00    2018-05-31 12:30:58  MG00000001  2018-05-31 12:30:58  MG00000001  View Edit Delete
6753  02  51  165  穂じそ    ほじそ    2018-09-19 00:00:00    2018-09-19 10:39:36  MG00000001  2018-09-19 10:39:36  MG00000001  View Edit Delete
2658  02  51  220  ミカン    みかん    2017-02-27 00:00:00            View Edit Delete
6242  02  52  1898  農産物    のうさんぶつ    2018-05-31 00:00:00    2018-05-31 12:31:20  MG00000001  2018-05-31 12:31:20  MG00000001  View Edit Delete
6754  02  54  83089  農産物    のうさんぶつ    2018-09-21 00:00:00    2018-09-21 12:54:53  MG00000001  2018-09-21 12:54:53  MG00000001  View Edit Delete
2659  02  51  222  柿    かき    2017-02-27 00:00:00            View Edit Delete
6243  02  52  1899  農産物    のうさんぶつ    2018-05-31 00:00:00    2018-05-31 12:31:43  MG00000001  2018-05-31 12:31:43  MG00000001  View Edit Delete
7011  02  52  2061  農産物    のうさんぶつ    2018-10-11 00:00:00    2018-10-11 13:16:17  MG00000001  2018-10-11 13:16:17  MG00000001  View Edit Delete
7267  02  52  2132  農産物    のうさんぶつ    2018-12-19 00:00:00    2018-12-19 10:48:24  MG00000001  2018-12-19 10:48:24  MG00000001  View Edit Delete
8035  02  54  45012  農産物    のうさんぶつ    2019-09-17 00:00:00    2019-09-17 08:48:33  MG00000001  2019-09-17 08:48:33  MG00000001  View Edit Delete
2660  02  51  223  いちご    いちご    2017-02-27 00:00:00            View Edit Delete

Page 135 of 2156, showing 20 records out of 43118 total, starting on record 2681, ending on 2700

(default) 2 queries took 24 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 2680, 20202017
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117