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
44410  01  033  50256  50256_農産物  岡山農産00256  のうさんぶつ    2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
44666  01  033  50512  50512_農産物  岡山農産00512  のうさんぶつ    2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
44922  01  033  51175  51175_農産物  岡山農産01175  のうさんぶつ    2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
45178  01  031  820403  820403_農産物3    のうさんぶつ    2023-08-21 00:00:00    2023-08-21 00:00:00  MG00000001  2023-08-21 00:00:00  MG00000001  View Edit Delete
46202  01  035  101440  10144_農産物  産地直送 野菜144  のうさんぶつ    2023-08-25 00:00:00    2023-08-25 00:00:00  MG00000001  2023-08-25 00:00:00  MG00000001  View Edit Delete
46458  01  033  51711  51711_農産物  岡山農産01711  のうさんぶつ    2023-08-28 00:00:00    2023-08-28 00:00:00  MG00000001  2023-08-28 00:00:00  MG00000001  View Edit Delete
46714  01  034  81099  81099_農産物10    のうさんぶつ    2023-09-08 00:00:00    2023-09-08 00:00:00  MG00000001  2023-09-08 00:00:00  MG00000001  View Edit Delete
46970  01  033  57617  57617_農産物  岡山農産07617  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47226  01  033  58818  58818_農産物  岡山農産08818  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47482  01  033  59149  59149_農産物  鳥取農産09149  のうさんぶつ    2023-09-28 00:00:00    2023-09-28 00:00:00  MG00000001  2023-09-28 00:00:00  MG00000001  View Edit Delete
47738  01  036  105022  5022_農産物1    のうさんぶつ    2023-10-17 00:00:00    2023-10-17 00:00:00  MG00000001  2023-10-17 00:00:00  MG00000001  View Edit Delete
47994  01  036  105038  5038_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48250  01  036  105302  5302_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48506  01  036  108054  8054_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48762  01  036  108316  8316_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49018  01  036  108578  8578_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49274  01  036  108839  8839_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49530  01  033  58055  58055_農産物  岡山農産08055  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49786  01  036  108943  8943_農産物    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 00:00:00  MG00000001  2023-10-25 00:00:00  MG00000001  View Edit Delete
50042  01  036  109092  9092_農産物1    のうさんぶつ    2023-10-31 00:00:00    2023-10-31 00:00:00  MG00000001  2023-10-31 00:00:00  MG00000001  View Edit Delete

Page 1030 of 2156, showing 20 records out of 43118 total, starting on record 20581, ending on 20600

(default) 2 queries took 52 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`.`insert_user` desc LIMIT 20580, 20202044
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1118