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
49422  01  033  57933  57933_農産物  岡山農産07933  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49678  01  031  820610  820610_農産物10    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 11:58:54  MG00000007  2023-10-25 11:58:54  MG00000007  View Edit Delete
49934  01  036  109031  9031_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50190  01  033  58723  8723_農産物  岡山農産08723  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50446  01  033  58440  8440_農産物  広島農産08440  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50702  01  033  58307  8307_農産物  広島農産08307  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50958  01  036  105838  5838_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 09:22:03  MG00000007  2023-11-28 09:22:03  MG00000007  View Edit Delete
51214  01  031  600329  600329_農産物29    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51470  01  033  50811  50811_農産物  岡山農産00811  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:26:13  MG00000007  2024-01-18 17:26:13  MG00000007  View Edit Delete
15  01  001  15  ほうれん草    ほうれんそう    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1039  01  005  11021  トマト 1P    とまと1    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
1295  01  005  24034  グレープフルーツホワイト パック    ぐれーぷふるーつほわいとぱっく    2016-07-01 00:00:00    2016-08-30 12:24:45  MG00000001  2016-08-30 12:24:45  MG00000001  View Edit Delete
2575  01  006  7131  野菜  産直野菜131  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5135  07  81  13  農産物13    のうさんぶつ13    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5391  02  53  21  農産物21    のうさんぶつ21    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6159  02  51  109  水ナス    みずなす    2018-04-11 00:00:00    2018-04-11 00:00:00  MG00000001  2018-04-11 00:00:00  MG00000001  View Edit Delete
6415  01  004  343211  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6671  01  004  343648  野菜    やさい    2018-08-09 00:00:00    2018-08-09 14:59:19  MG00000001  2018-08-09 15:11:11  MG00000001  View Edit Delete
6927  08  96  643  大石すもも    おおいしすもも    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7183  08  97  552  りんご(つがる)    りんごつがる    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete

Page 127 of 2156, showing 20 records out of 43118 total, starting on record 2521, ending on 2540

(default) 2 queries took 25 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_end_day` desc LIMIT 2520, 20202018
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117