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
1079  01  005  12151  ふとねぎ 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
1591  01  007  6253  玉ねぎ  近郷野菜153  たまねぎ    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2615  02  51  119  ピーマン    ぴーまん    2017-02-27 00:00:00            View Edit Delete
5175  07  81  53  農産物53    のうさんぶつ53    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5431  02  53  61  農産物61    のうさんぶつ61    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6199  02  54  78697  農産物    のうさんぶつ    2018-04-23 00:00:00    2018-04-23 14:57:47  MG00000001  2018-04-23 14:57:47  MG00000001  View Edit Delete
6455  01  004  398976  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6711  01  002  20110617  野菜    やさい    2018-09-03 00:00:00    2018-09-03 09:44:59  MG00000001  2018-09-03 09:44:59  MG00000001  View Edit Delete
6967  08  96  762  ドライプルーン    どらいぷるーん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 16:50:24  MG00000001  View Edit Delete
7223  08  97  713  キングルビー    きんぐるびー    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7735  01  102  2400033509132   柑橘    かんきつ    2019-05-20 00:00:00            View Edit Delete
7991  03  62  72  農産物72    のうさんぶつ72    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8247  01  006  7183  野菜  産直野菜183  やさい    2020-01-31 00:00:00    2020-01-31 09:22:38  MG00000001  2020-01-31 09:22:38  MG00000001  View Edit Delete
9015  02  55  2138052  農産物    のうさんぶつ    2021-01-20 00:00:00    2021-01-20 13:11:10  MG00000005  2021-01-20 13:11:10  MG00000005  View Edit Delete
11063  06  661  00062  白ねぎ    しろねぎ    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-10 14:39:21  MG00000001  View Edit Delete
11319  06  661  00320  仏花    ぶっか    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11575  06  661  00576  千両    せんりょう    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11831  06  661  00844  ノースポール(食用)    のーすぼーる    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12087  06  661  01101  中生玉ねぎ    ちゅうせいたまねぎ    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12343  04  710  89701  農産物    のうさんぶつ    2022-06-23 00:00:00    2022-06-23 11:26:53  MG00000001  2022-06-23 11:26:53  MG00000001  View Edit Delete

Page 464 of 2156, showing 20 records out of 43118 total, starting on record 9261, ending on 9280

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