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
46614  01  033  56612  56612_農産物  岡山農産06612  のうさんぶつ    2023-08-31 00:00:00    2023-08-31 00:00:00  MG00000001  2023-08-31 00:00:00  MG00000001  View Edit Delete
46870  01  033  57517  57517_農産物  岡山農産07517  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47126  01  033  57383  57383_農産物  岡山農産07383  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47382  01  033  59038  59038_農産物  岡山農産09038  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47638  01  032  51389  13890_農産物    のうさんぶつ    2023-09-29 00:00:00    2023-09-29 09:27:48  MG00000007  2023-09-29 09:27:48  MG00000007  View Edit Delete
47894  01  033  59313  59313_農産物  岡山農産09313  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:27:40  MG00000007  2023-10-19 13:27:40  MG00000007  View Edit Delete
48150  01  036  105197  5197_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48406  01  036  105459  5459_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48662  01  036  108211  8211_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48918  01  036  108474  8474_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49174  01  036  108739  8739_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49430  01  033  57804  57804_農産物  岡山農産07804  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49686  01  036  105594  5594_農産物    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 00:00:00  MG00000001  2023-10-25 00:00:00  MG00000001  View Edit Delete
49942  01  036  105676  5676_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50198  01  033  58270  8270_農産物  広島農産08270  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50454  01  033  58448  8448_農産物  広島農産08448  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50710  01  033  58315  8315_農産物  広島農産08315  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50966  01  036  105846  5846_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 09:39:26  MG00000007  2023-11-28 09:39:26  MG00000007  View Edit Delete
51222  01  031  696907  696907_農産物07    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51478  01  033  50775  50775_農産物  岡山農産00775  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:40:57  MG00000007  2024-01-18 17:40:57  MG00000007  View Edit Delete

Page 194 of 2156, showing 20 records out of 43118 total, starting on record 3861, ending on 3880

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