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
1044  01  005  11041  高糖度ミニトマト 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
1300  01  005  25011  果物 1P    くだもの1    2016-07-01 00:00:00    2016-08-30 12:24:45  MG00000001  2016-08-30 12:24:45  MG00000001  View Edit Delete
1556  01  007  6218  しいたけ  近郷野菜118  しいたけ    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2019-04-02 09:39:51  MG00000001  View Edit Delete
2580  01  006  7136  野菜  産直野菜136  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5140  07  81  18  農産物18    のうさんぶつ18    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5396  02  53  26  農産物26    のうさんぶつ26    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6164  08  91  496241001054  つるむらさき    つるむらさき    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2019-02-25 15:32:35  MG00000001  View Edit Delete
6420  01  004  343263  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6676  01  004  499647  果実    かじつ    2018-08-09 00:00:00    2018-08-09 15:16:49  MG00000001  2018-08-09 15:16:49  MG00000001  View Edit Delete
6932  08  96  661  さくらんぼ    さくらんぼ    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 16:13:26  MG00000001  View Edit Delete
7188  08  97  557  りんご(スターキング)    りんごすたーきんぐ    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7700  01  102  2400033508715   なばな    なばな    2019-05-20 00:00:00            View Edit Delete
7956  03  62  37  農産物37    のうさんぶつ37    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
8212  02  55  2133450  農産物    のうさんぶつ    2019-11-29 00:00:00    2019-11-29 10:35:30  MG00000001  2019-11-29 10:35:30  MG00000001  View Edit Delete
18452  01  113  20904974  野菜④    やさい    2022-12-19 00:00:00    2022-12-19 13:29:30  MG00000001  2022-12-19 13:29:30  MG00000001  View Edit Delete
44052  01  911  100455  農産物6_0455    のうさんぶつ    2023-06-28 00:00:00    2023-06-28 13:44:44  MG00000001  2023-06-28 13:44:44  MG00000001  View Edit Delete
47636  01  032  51387  13870_農産物    のうさんぶつ    2023-09-29 00:00:00    2023-09-29 09:25:26  MG00000007  2023-09-29 09:25:26  MG00000007  View Edit Delete
47892  01  033  59311  59311_農産物  岡山農産09311  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:25:34  MG00000007  2023-10-19 13:25:34  MG00000007  View Edit Delete
50964  01  036  105844  5844_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 09:36:07  MG00000007  2023-11-28 09:36:07  MG00000007  View Edit Delete
51476  01  033  50773  50773_農産物  岡山農産00773  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:37:27  MG00000007  2024-01-18 17:37:27  MG00000007  View Edit Delete

Page 20 of 2156, showing 20 records out of 43118 total, starting on record 381, ending on 400

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