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
36655  01  031  650818  650818_農産物18    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
36911  01  031  667104  667104_農産物04    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
37167  01  031  678620  678620_農産物20    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
37423  01  031  687206  687206_農産物06    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
37679  01  031  688722  688722_農産物22    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
37935  01  031  692508  692508_農産物08    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
38191  01  031  699924  699924_農産物24    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
38447  01  031  718210  718210_農産物10    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
38703  01  031  724026  724026_農産物26    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
38959  01  031  729012  729012_農産物12    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
39215  01  031  821528  821528_農産物28    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
39471  01  031  823514  823514_農産物14    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
39727  01  031  824830  824830_農産物30    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
39983  01  033  54362  54362_農産物  岡山農産04362  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
40239  01  033  54618  54618_農産物  岡山農産04618  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
40495  01  033  54874  54874_農産物  岡山農産04874  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
40751  01  033  55006  55006_農産物  岡山農産05006  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
41007  01  033  56068  56068_農産物  岡山農産06068  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
41263  01  033  56329  56329_農産物  香川農産06329  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
41519  01  033  55419  55419_農産物  岡山農産05419  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete

Page 402 of 2156, showing 20 records out of 43118 total, starting on record 8021, ending on 8040

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