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
1065  01  005  12041  カリフラワー 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
2601  01  006  7157  野菜  産直野菜157  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5161  07  81  39  農産物39    のうさんぶつ39    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5417  02  53  47  農産物47    のうさんぶつ47    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6185  02  52  1844  農産物    のうさんぶつ    2018-04-13 00:00:00    2018-04-13 00:00:00  MG00000001  2018-04-13 00:00:00  MG00000001  View Edit Delete
6441  01  004  398720  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6697  01  002  20110605  茄子    なす    2018-08-30 00:00:00    2018-08-30 16:43:17  MG00000001  2018-08-30 16:43:17  MG00000001  View Edit Delete
6953  08  96  716  アールスメロン    あーるすめろん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7209  08  97  671  ぶどう    ぶどう    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7721  01  102  2400033508975   ぶどう    ぶどう    2019-05-20 00:00:00            View Edit Delete
7977  03  62  58  農産物58    のうさんぶつ58    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8233  02  51  569  菊芋    きくいも    2019-12-09 00:00:00    2019-12-09 11:05:34  MG00000001  2019-12-09 11:05:34  MG00000001  View Edit Delete
11049  06  661  00048  芽キャベツ    めきゃべつ    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-10 14:33:33  MG00000001  View Edit Delete
11305  06  661  00306  桃花    とうか    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11561  06  661  00562  迎春セット(小)    げいしゅんせっと    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11817  06  661  00830  ルッコラの花    るっこらのはな    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12073  06  661  01087  秋映(りんご)    あきばえりんご    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12329  04  710  89686  農産物    のうさんぶつ    2022-06-23 00:00:00    2022-06-23 11:26:53  MG00000001  2022-06-23 11:26:53  MG00000001  View Edit Delete
12585  01  002  20905114  農産物⑤    のうさんぶつ    2022-08-02 00:00:00    2022-08-02 09:30:39  MG00000001  2022-08-02 09:30:39  MG00000001  View Edit Delete
12841  01  056  32829  農産物    のうさんぶつ    2022-08-22 00:00:00    2022-08-22 12:42:10  MG00000001  2022-08-22 12:42:10  MG00000001  View Edit Delete

Page 346 of 2156, showing 20 records out of 43118 total, starting on record 6901, ending on 6920

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