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
42795  01  031  611429  611429_農産物29    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
43051  01  031  661806  661806_農産物06    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
43307  01  031  696724  696724_農産物24    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
43563  01  031  629128  629128_農産物28    のうさんぶつ    2023-06-23 00:00:00    2023-06-23 00:00:00  MG00000001  2023-06-23 00:00:00  MG00000001  View Edit Delete
43819  01  031  647914  647914_農産物14    のうさんぶつ    2023-06-23 00:00:00    2023-06-23 00:00:00  MG00000001  2023-06-23 00:00:00  MG00000001  View Edit Delete
44075  01  031  695516  695516_農産物16    のうさんぶつ    2023-06-28 00:00:00    2023-06-28 00:00:00  MG00000001  2023-06-28 00:00:00  MG00000001  View Edit Delete
44331  01  033  50177  50177_農産物  岡山農産00177  のうさんぶつ    2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
44587  01  033  50433  50433_農産物  岡山農産00433  のうさんぶつ    2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
44843  01  033  50689  50689_農産物  岡山農産00689  のうさんぶつ    2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
45099  01  033  51661  51661_農産物  岡山農産01661  のうさんぶつ    2023-07-25 00:00:00    2023-07-25 12:19:57  MG00000001  2023-07-25 12:19:57  MG00000001  View Edit Delete
46123  01  033  51672  51672_農産物  岡山農産01672  のうさんぶつ    2023-08-21 00:00:00    2023-08-21 13:43:15  MG00000001  2023-08-21 13:43:15  MG00000001  View Edit Delete
46379  01  035  110440  11044_農産物  産地直送 その他44  のうさんぶつ    2023-08-25 00:00:00    2023-08-25 00:00:00  MG00000001  2023-08-25 00:00:00  MG00000001  View Edit Delete
46635  01  035  102020  10202_野菜  産地直送 野菜202  のうさんぶつ    2023-09-01 00:00:00    2023-09-01 00:00:00  MG00000001  2023-09-01 00:00:00  MG00000001  View Edit Delete
46891  01  033  57538  57538_農産物  岡山農産07538  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47147  01  033  57404  57404_農産物  岡山農産07404  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47403  01  033  57623  57623_農産物  岡山農産07623  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47659  01  031  100016  100016_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:03:14  MG00000007  2023-10-03 16:03:14  MG00000007  View Edit Delete
47915  01  033  59334  59334_農産物  岡山農産09334  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:59:32  MG00000007  2023-10-19 13:59:32  MG00000007  View Edit Delete
48171  01  036  105218  5218_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48427  01  036  105480  5480_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete

Page 370 of 2156, showing 20 records out of 43118 total, starting on record 7381, ending on 7400

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