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
44073  01  031  695514  695514_農産物14    のうさんぶつ    2023-06-28 00:00:00    2023-06-28 00:00:00  MG00000001  2023-06-28 00:00:00  MG00000001  View Edit Delete
44329  01  033  50175  50175_農産物  岡山農産00175  のうさんぶつ    2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
44585  01  033  50431  50431_農産物  岡山農産00431  のうさんぶつ    2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
44841  01  033  50687  50687_農産物  岡山農産00687  のうさんぶつ    2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
45097  01  033  51659  51659_農産物  岡山農産01659  のうさんぶつ    2023-07-25 00:00:00    2023-07-25 12:19:16  MG00000001  2023-07-25 12:19:16  MG00000001  View Edit Delete
46121  01  033  51670  51670_農産物  岡山農産01670  のうさんぶつ    2023-08-21 00:00:00    2023-08-21 13:42:24  MG00000001  2023-08-21 13:42:24  MG00000001  View Edit Delete
46377  01  035  101670  10167_農産物  産地直送 野菜167  のうさんぶつ    2023-08-25 00:00:00    2023-08-25 00:00:00  MG00000001  2023-08-25 00:00:00  MG00000001  View Edit Delete
46633  01  035  101930  10193_野菜  産地直送 野菜193  のうさんぶつ    2023-09-01 00:00:00    2023-09-01 00:00:00  MG00000001  2023-09-01 00:00:00  MG00000001  View Edit Delete
46889  01  033  57536  57536_農産物  岡山農産07536  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47145  01  033  57402  57402_農産物  岡山農産07402  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47401  01  033  59057  59057_農産物  岡山農産09057  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47657  01  031  100014  100014_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 15:59:44  MG00000007  2023-10-03 15:59:44  MG00000007  View Edit Delete
47913  01  033  59332  59332_農産物  岡山農産09332  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:57:03  MG00000007  2023-10-19 13:57:03  MG00000007  View Edit Delete
48169  01  036  105216  5216_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48425  01  036  105478  5478_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48681  01  036  108234  8234_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48937  01  036  108493  8493_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49193  01  036  108758  8758_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49449  01  033  57823  57823_農産物  岡山農産07823  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49705  01  036  105576  5576_農産物    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 00:00:00  MG00000001  2023-10-25 00:00:00  MG00000001  View Edit Delete

Page 353 of 2156, showing 20 records out of 43118 total, starting on record 7041, ending on 7060

(default) 2 queries took 30 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 7040, 20202023
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117