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
49937  01  036  109034  9034_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50193  01  033  58265  8265_農産物  広島農産08265  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50449  01  033  58443  8443_農産物  広島農産08443  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50705  01  033  58310  8310_農産物  広島農産08310  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50961  01  036  105841  5841_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 09:31:11  MG00000007  2023-11-28 09:31:11  MG00000007  View Edit Delete
51217  01  031  696902  696902_みかん    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51473  01  033  50770  50770_農産物  岡山農産00770  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:31:22  MG00000007  2024-01-18 17:31:22  MG00000007  View Edit Delete
18  01  001  18  チンゲン菜    ちんげんさい    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1042  01  005  11024  トマト パック    とまとぱっく    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
1298  01  005  24043  グレープフルーツルビー 3P    ぐれーぷふるーつるびー3    2016-07-01 00:00:00    2016-08-30 12:24:45  MG00000001  2016-08-30 12:24:45  MG00000001  View Edit Delete
2578  01  006  7134  野菜  産直野菜134  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5138  07  81  16  農産物16    のうさんぶつ16    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5394  02  53  24  農産物24    のうさんぶつ24    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6162  08  91  496241001052  空芯菜    くうしんさい    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6418  01  004  343259  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6674  01  004  343649  野菜    やさい    2018-08-09 00:00:00    2018-08-09 15:13:28  MG00000001  2018-08-09 15:13:28  MG00000001  View Edit Delete
6930  08  96  646  プラム(太陽)    ぷらむたいよう    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7186  08  97  555  りんご(シナノスィート)    りんごしなのすぃーと    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7698  01  102  2400033508692   カリフラワー    かりふらわー    2019-05-20 00:00:00            View Edit Delete
7954  03  62  35  農産物35    のうさんぶつ35    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete

Page 152 of 2156, showing 20 records out of 43118 total, starting on record 3021, ending on 3040

(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` asc LIMIT 3020, 20202018
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117