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
50448  01  033  58442  8442_農産物  広島農産08442  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50704  01  033  58309  8309_農産物  広島農産08309  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50960  01  036  105840  5840_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 09:29:54  MG00000007  2023-11-28 09:29:54  MG00000007  View Edit Delete
51216  01  031  696901  696901_農産物01    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51472  01  033  50769  50769_農産物  岡山農産00769  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:29:33  MG00000007  2024-01-18 17:29:33  MG00000007  View Edit Delete
17  01  001  17  水菜    みずな    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1041  01  005  11023  トマト 3P    とまと3    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
1297  01  005  24042  グレープフルーツルビー 2P    ぐれーぷふるーつるびー2    2016-07-01 00:00:00    2016-08-30 12:24:45  MG00000001  2016-08-30 12:24:45  MG00000001  View Edit Delete
1553  01  007  6215  空芯菜  近郷野菜115  やさい    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2577  01  006  7133  野菜  産直野菜133  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5137  07  81  15  農産物15    のうさんぶつ15    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5393  02  53  23  農産物23    のうさんぶつ23    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6161  08  91  496241001051  からし菜    からしな    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6417  01  004  343257  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6673  01  004  343651  野菜    やさい    2018-08-09 00:00:00    2018-08-09 15:03:08  MG00000001  2018-08-09 15:12:40  MG00000001  View Edit Delete
6929  08  96  645  プラム(貴陽)    ぷらむきよう    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7185  08  97  554  りんご(紅玉)    りんごこうぎょく    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7697  01  102  2400033508661   カリフラワー    かりふらわー    2019-05-20 00:00:00            View Edit Delete
7953  03  62  34  農産物34    のうさんぶつ34    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8209  02  55  2132639  農産物    のうさんぶつ    2019-11-29 00:00:00    2019-11-29 10:19:11  MG00000001  2019-11-29 10:19:11  MG00000001  View Edit Delete

Page 144 of 2156, showing 20 records out of 43118 total, starting on record 2861, ending on 2880

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