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
21  01  001  21  白ねぎ    しろねぎ    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1045  01  005  11051  ミディトマト 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
1301  01  005  25012  果物 2P    くだもの2    2016-07-01 00:00:00    2016-08-30 12:24:45  MG00000001  2016-08-30 12:24:45  MG00000001  View Edit Delete
1557  01  007  6219  ミニトマト  近郷野菜119  みにとまと    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2581  01  006  7137  野菜  産直野菜137  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5141  07  81  19  農産物19    のうさんぶつ19    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5397  02  53  27  農産物27    のうさんぶつ27    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6165  08  91  496241001055  オクラ    おくら    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6421  01  004  343312  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6677  01  004  499648  果実    かじつ    2018-08-09 00:00:00    2018-08-09 15:17:37  MG00000001  2018-08-09 15:17:37  MG00000001  View Edit Delete
6933  08  96  662  さくらんぼ(佐藤錦)    さくらんぼさとうにしき    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 16:13:38  MG00000001  View Edit Delete
7189  08  97  558  りんご(王林)    りんごおうりん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7701  01  102  2400033508739   アスパラ    あすぱら    2019-05-20 00:00:00            View Edit Delete
7957  03  62  38  農産物38    のうさんぶつ38    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
18453  01  002  20110417  野菜    やさい    2022-12-20 00:00:00    2022-12-20 11:01:12  MG00000001  2022-12-20 11:01:12  MG00000001  View Edit Delete
44053  01  911  100456  農産物7_0456    のうさんぶつ    2023-06-28 00:00:00    2023-06-28 13:45:07  MG00000001  2023-06-28 13:45:07  MG00000001  View Edit Delete
47637  01  032  51388  13880_農産物    のうさんぶつ    2023-09-29 00:00:00    2023-09-29 09:26:23  MG00000007  2023-09-29 09:26:23  MG00000007  View Edit Delete
47893  01  033  59312  59312_農産物  岡山農産09312  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:26:39  MG00000007  2023-10-19 13:26:39  MG00000007  View Edit Delete
50965  01  036  105845  5845_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 09:37:36  MG00000007  2023-11-28 09:37:36  MG00000007  View Edit Delete
51477  01  033  50774  50774_農産物  岡山農産00774  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:38:41  MG00000007  2024-01-18 17:38:41  MG00000007  View Edit Delete

Page 21 of 2156, showing 20 records out of 43118 total, starting on record 401, ending on 420

(default) 2 queries took 27 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`.`limited_user_id` asc LIMIT 400, 20202018
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1119