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
36619  01  031  648212  648212_農産物12    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
36875  01  031  661228  661228_農産物28    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
37131  01  031  677214  677214_農産物14    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
37387  01  031  686530  686530_農産物30    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
37643  01  031  688516  688516_農産物16    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
37899  01  031  692102  692102_農産物02    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
38155  01  031  699618  699618_農産物18    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
38411  01  031  715904  715904_農産物04    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
38667  01  031  723820  723820_農産物20    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
38923  01  031  728906  728906_農産物06    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
39179  01  031  820222  820222_農産物22    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
39435  01  031  823308  823308_農産物08    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
39691  01  031  824724  824724_農産物24    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
39947  01  033  54326  54326_農産物  岡山農産04326  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
40203  01  033  54582  54582_農産物  岡山農産04582  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
40459  01  033  54838  54838_農産物  岡山農産04838  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
40715  01  033  54970  54970_農産物  岡山農産04970  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
40971  01  033  56032  56032_農産物  岡山農産06032  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
41227  01  033  56292  56292_農産物  岡山農産06292  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
41483  01  033  55383  55383_農産物  岡山農産05383  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete

Page 99 of 2156, showing 20 records out of 43118 total, starting on record 1961, ending on 1980

(default) 2 queries took 31 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 1960, 20202022
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1119