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
2679  02  51  542  菌床生椎茸    きんしょうなましいたけ    2017-02-27 00:00:00            View Edit Delete
3959  02  51  705  らっきょう    らっきょう    2017-06-30 00:00:00            View Edit Delete
5495  02  52  1823  農産物    のうさんぶつ    2018-03-05 00:00:00    2018-03-05 00:00:00  MG00000001  2018-03-05 00:00:00  MG00000001  View Edit Delete
7287  02  51  287  ザボン    ざぼん    2019-01-16 00:00:00    2019-01-16 09:58:08  MG00000001  2019-01-16 09:58:08  MG00000001  View Edit Delete
8567  02  51  267  りんご    りんご    2020-09-15 00:00:00    2020-09-15 13:17:03  MG00000005  2020-09-15 13:17:03  MG00000005  View Edit Delete
2680  02  51  544  山菜    さんさい    2017-02-27 00:00:00            View Edit Delete
3960  02  51  884  サンチュ    さんちゅ    2017-07-05 13:13:09            View Edit Delete
5496  02  52  1830  農産物    のうさんぶつ    2018-03-05 00:00:00    2018-03-05 00:00:00  MG00000001  2018-03-05 00:00:00  MG00000001  View Edit Delete
7288  02  51  945  セージ    せーじ    2019-01-16 00:00:00    2019-01-16 09:59:56  MG00000001  2019-01-16 09:59:56  MG00000001  View Edit Delete
8568  02  51  952  はすいも    はすいも    2020-09-15 00:00:00    2020-09-15 13:25:20  MG00000005  2020-09-15 13:25:20  MG00000005  View Edit Delete
2681  02  51  549  大葉    おおば    2017-02-27 00:00:00            View Edit Delete
3961  02  51  772  フリルレタス    ふりるれたす    2017-07-05 13:26:02            View Edit Delete
5497  02  52  1831  農産物    のうさんぶつ    2018-03-05 00:00:00    2018-03-05 00:00:00  MG00000001  2018-03-05 00:00:00  MG00000001  View Edit Delete
7289  02  52  2141  農産物    のうさんぶつ    2019-01-16 00:00:00    2019-01-16 10:16:08  MG00000001  2019-01-16 10:16:08  MG00000001  View Edit Delete
2682  02  51  552  スイートコーン    すいーとこーん    2017-02-27 00:00:00            View Edit Delete
5498  02  52  1832  農産物    のうさんぶつ    2018-03-05 00:00:00    2018-03-05 00:00:00  MG00000001  2018-03-05 00:00:00  MG00000001  View Edit Delete
7290  02  52  2150  農産物    のうさんぶつ    2019-01-16 00:00:00    2019-01-16 10:16:33  MG00000001  2019-01-16 10:16:33  MG00000001  View Edit Delete
7802  02  55  2132159  農産物    のうさんぶつ    2019-06-19 00:00:00    2019-06-19 16:25:17  MG00000001  2019-06-19 16:25:17  MG00000001  View Edit Delete
2683  02  51  559  からし菜    からしな    2017-02-27 00:00:00            View Edit Delete
7291  02  52  2151  農産物    のうさんぶつ    2019-01-16 00:00:00    2019-01-16 10:17:03  MG00000001  2019-01-16 10:17:03  MG00000001  View Edit Delete

Page 140 of 2156, showing 20 records out of 43118 total, starting on record 2781, ending on 2800

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