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
17687  01  911  104019  農産物⑮    のうさんぶつ    2022-11-01 00:00:00    2022-11-01 13:43:13  MG00000001  2022-11-01 13:43:13  MG00000001  View Edit Delete
17943  01  911  104268  農産物114    のうさんぶつ    2022-11-01 00:00:00    2022-11-01 13:43:13  MG00000001  2022-11-01 13:43:13  MG00000001  View Edit Delete
18199  01  911  104510  農産物56    のうさんぶつ    2022-11-01 00:00:00    2022-11-01 13:43:13  MG00000001  2022-11-01 13:43:13  MG00000001  View Edit Delete
18455  01  006  7191  野菜  産直野菜191  やさい    2022-12-20 00:00:00    2022-12-20 16:00:26  MG00000001  2022-12-20 16:00:26  MG00000001  View Edit Delete
18711  01  032  85364  85364_野菜    やさい    2023-03-27 00:00:00    2023-03-27 10:18:00  MG00000001  2023-03-27 10:18:00  MG00000001  View Edit Delete
18967  01  034  80441  80441_農産物    のうさんぶつ    2023-03-27 00:00:00    2023-03-27 14:32:06  MG00000001  2023-03-27 14:32:06  MG00000001  View Edit Delete
19223  01  031  665816  665816_農産物16    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
19479  01  031  662502  662502_農産物02    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
19735  01  031  657218  657218_農産物18    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
19991  01  031  666004  666004_農産物04    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
20247  01  031  659620  659620_農産物20    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
20503  01  031  685306  685306_農産物06    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
20759  01  031  680222  680222_農産物22    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
21015  01  031  671808  671808_農産物08    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
21271  01  031  689424  689424_農産物24    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
21527  01  031  658810  658810_農産物10    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
21783  01  031  657426  657426_農産物26    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
22039  01  031  642812  642812_農産物12    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
22295  01  031  622128  622128_農産物28    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
22551  01  031  653414  653414_農産物14    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete

Page 197 of 2156, showing 20 records out of 43118 total, starting on record 3921, ending on 3940

(default) 2 queries took 26 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` desc LIMIT 3920, 20202019
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117