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
44818  01  033  50664  50664_農産物  岡山農産00664  のうさんぶつ    2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
45074  01  034  80467  04670_農産物    のうさんぶつ    2023-07-19 00:00:00    2023-07-19 00:00:00  MG00000001  2023-07-19 00:00:00  MG00000001  View Edit Delete
46354  01  035  120260  12026_農産物  産地直送 果物26  のうさんぶつ    2023-08-25 00:00:00    2023-08-25 00:00:00  MG00000001  2023-08-25 00:00:00  MG00000001  View Edit Delete
46610  01  033  56557  56557_農産物  岡山農産06557  のうさんぶつ    2023-08-31 00:00:00    2023-08-31 00:00:00  MG00000001  2023-08-31 00:00:00  MG00000001  View Edit Delete
46866  01  033  57513  57513_農産物  岡山農産07513  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47122  01  033  57379  57379_農産物  岡山農産07379  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47378  01  033  59034  59034_農産物  岡山農産09034  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47634  01  032  51375  13750_農産物    のうさんぶつ    2023-09-29 00:00:00    2023-09-29 09:23:34  MG00000007  2023-09-29 09:23:34  MG00000007  View Edit Delete
47890  01  033  59309  59309_農産物  岡山農産09309  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:23:02  MG00000007  2023-10-19 13:23:02  MG00000007  View Edit Delete
48146  01  036  105193  5193_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48402  01  036  105455  5455_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48658  01  036  108207  8207_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48914  01  036  108470  8470_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49170  01  036  108735  8735_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49426  01  033  57937  57937_農産物  岡山農産07937  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49682  01  036  105590  5590_農産物    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 00:00:00  MG00000001  2023-10-25 00:00:00  MG00000001  View Edit Delete
49938  01  036  109035  9035_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50194  01  033  58266  8266_農産物  広島農産08266  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50450  01  033  58444  8444_農産物  広島農産08444  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50706  01  033  58311  8311_農産物  広島農産08311  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete

Page 160 of 2156, showing 20 records out of 43118 total, starting on record 3181, ending on 3200

(default) 2 queries took 29 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 3180, 20202021
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1118