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
1077  01  005  12143  白葱 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
1589  01  007  6251  いんげん  近郷野菜151  いんげん    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2613  02  51  117  枝豆    えだまめ    2017-02-27 00:00:00            View Edit Delete
5173  07  81  51  農産物51    のうさんぶつ51    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5429  02  53  59  農産物59    のうさんぶつ59    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6197  02  54  78662  農産物    のうさんぶつ    2018-04-23 00:00:00    2018-04-23 14:56:45  MG00000001  2018-04-23 14:56:45  MG00000001  View Edit Delete
6453  01  004  398743  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6965  08  96  746  マンゴー    まんごー    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-26 15:05:27  MG00000001  View Edit Delete
7221  08  97  711  メロン    めろん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7733  01  102  2400033509118   レモン    れもん    2019-05-20 00:00:00            View Edit Delete
7989  03  62  70  農産物70    のうさんぶつ70    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8245  01  006  7185  野菜  産直野菜185  やさい    2020-01-31 00:00:00    2020-01-31 09:07:34  MG00000001  2020-01-31 09:07:34  MG00000001  View Edit Delete
8501  02  55  2135569  農産物    のうさんぶつ    2020-06-22 00:00:00    2020-06-22 16:10:04  MG00000005  2020-06-22 16:10:04  MG00000005  View Edit Delete
11061  06  661  00060  ほうれん草    ほうれんそう    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-10 14:37:13  MG00000001  View Edit Delete
11317  06  661  00318  サンセベリア    さんせべりあ    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11573  06  661  00574  たかのつめ(生)    たかのつめなま    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11829  06  661  00842  ロメインレタス    ろめいんれたす    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12085  06  661  01099  早生玉ねぎ    わせたまねぎ    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12341  04  710  89699  農産物    のうさんぶつ    2022-06-23 00:00:00    2022-06-23 11:26:53  MG00000001  2022-06-23 11:26:53  MG00000001  View Edit Delete
12597  01  002  20905106  農産物⑦    のうさんぶつ    2022-08-02 00:00:00    2022-08-02 09:40:16  MG00000001  2022-08-02 09:40:16  MG00000001  View Edit Delete

Page 447 of 2156, showing 20 records out of 43118 total, starting on record 8921, ending on 8940

(default) 2 queries took 44 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 8920, 20202033
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 11111