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
17211  01  911  103564  農産物⑩    のうさんぶつ    2022-11-01 00:00:00    2022-11-01 13:43:13  MG00000001  2022-11-01 13:43:13  MG00000001  View Edit Delete
17467  01  911  103813  農産物109    のうさんぶつ    2022-11-01 00:00:00    2022-11-01 13:43:13  MG00000001  2022-11-01 13:43:13  MG00000001  View Edit Delete
17723  01  911  104055  農産物51    のうさんぶつ    2022-11-01 00:00:00    2022-11-01 13:43:13  MG00000001  2022-11-01 13:43:13  MG00000001  View Edit Delete
17979  01  911  104304  農産物150    のうさんぶつ    2022-11-01 00:00:00    2022-11-01 13:43:13  MG00000001  2022-11-01 13:43:13  MG00000001  View Edit Delete
18235  01  911  104546  農産物92    のうさんぶつ    2022-11-01 00:00:00    2022-11-01 13:43:13  MG00000001  2022-11-01 13:43:13  MG00000001  View Edit Delete
18491  01  002  20110822  野菜    やさい    2023-01-06 00:00:00    2023-01-06 10:08:06  MG00000001  2023-01-06 10:08:06  MG00000001  View Edit Delete
18747  01  032  85503  85503_野菜    やさい    2023-03-27 00:00:00    2023-03-27 10:18:00  MG00000001  2023-03-27 10:18:00  MG00000001  View Edit Delete
19003  01  034  80547  80547_農産物    のうさんぶつ    2023-03-27 00:00:00    2023-03-27 14:32:06  MG00000001  2023-03-27 14:32:06  MG00000001  View Edit Delete
19259  01  031  668522  668522_農産物22    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
19515  01  031  665308  665308_農産物08    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
19771  01  031  669124  669124_農産物24    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
20027  01  031  699310  699310_農産物10    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
20283  01  031  660326  660326_農産物26    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
20539  01  031  693912  693912_農産物12    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
20795  01  031  639628  639628_農産物28    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
21051  01  031  696814  696814_農産物14    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
21307  01  031  639330  639330_農産物30    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
21563  01  031  639916  639916_農産物16    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
21819  01  031  639702  639702_農産物02    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
22075  01  031  642718  642718_農産物18    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete

Page 500 of 2156, showing 20 records out of 43118 total, starting on record 9981, ending on 10000

(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` desc LIMIT 9980, 20202036
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1118