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
2586  01  006  7142  野菜  産直野菜142  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5146  07  81  24  農産物24    のうさんぶつ24    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5402  02  53  32  農産物32    のうさんぶつ32    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6170  08  91  496241001060  赤玉ねぎ    あかたまねぎ    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6426  01  004  398082  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6682  02  52  2021  農産物    のうさんぶつ    2018-08-20 00:00:00    2018-08-20 14:50:54  MG00000001  2018-08-20 14:50:54  MG00000001  View Edit Delete
6938  08  96  673  キャンベル    きゃんべる    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7194  08  97  604  なし(二十世紀)    なしにじゅっせいきなし    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7706  01  102  2400033508791   土ごぼう    つちごぼう    2019-05-20 00:00:00            View Edit Delete
7962  03  62  43  農産物43    のうさんぶつ43    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
11034  06  661  00033  泉州黄玉葱    せんしゅうきたまねぎ    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-10 09:48:44  MG00000001  View Edit Delete
11290  06  661  00291  ガーベラ    がーべら    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11546  06  661  00547  おから    おから    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11802  06  661  00814  ドライフルーツ    どらいふるーつ    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12058  06  661  01072  藤稔(ぶどう)    ふじみのりぶどう    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12314  04  710  89671  農産物    のうさんぶつ    2022-06-23 00:00:00    2022-06-23 11:26:53  MG00000001  2022-06-23 11:26:53  MG00000001  View Edit Delete
12570  01  053  67149  農産物    のうさんぶつ    2022-07-29 00:00:00    2022-07-29 13:16:29  MG00000001  2022-07-29 13:16:29  MG00000001  View Edit Delete
12826  01  056  32806  農産物    のうさんぶつ    2022-08-22 00:00:00    2022-08-22 12:42:10  MG00000001  2022-08-22 12:42:10  MG00000001  View Edit Delete
13082  01  052  074636  農産物    のうさんぶつ    2022-07-20 00:00:00    2022-07-20 11:33:00  MG00000001  2022-07-20 11:33:00  MG00000001  View Edit Delete
13338  01  911  101004  農産物⑥    のうさんぶつ    2022-10-06 00:00:00    2022-10-06 14:58:38  MG00000001  2022-10-06 14:58:38  MG00000001  View Edit Delete

Page 220 of 2156, showing 20 records out of 43118 total, starting on record 4381, ending on 4400

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