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
47413  01  033  57657  57657_農産物  岡山農産07657  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47669  01  031  100026  100026_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:32:59  MG00000007  2023-10-03 16:32:59  MG00000007  View Edit Delete
47925  01  036  105553  5553_農産物1    のうさんぶつ    2023-10-19 00:00:00    2023-10-19 17:28:59  MG00000007  2023-10-19 17:28:59  MG00000007  View Edit Delete
48181  01  036  105228  5228_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48437  01  036  105490  5490_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48693  01  036  108246  8246_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48949  01  036  108505  8505_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49205  01  036  108770  8770_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49461  01  033  57835  57835_農産物  岡山農産07835  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49717  01  036  105613  5613_農産物    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 00:00:00  MG00000001  2023-10-25 00:00:00  MG00000001  View Edit Delete
49973  01  036  105707  5707_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50229  01  033  58257  8257_農産物  広島農産08257  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50485  01  038  58727  8727_農産物  産直花08727  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 14:15:32  MG00000001  2023-11-07 14:15:32  MG00000001  View Edit Delete
50741  01  033  58587  58587_農産物  広島農産08587  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50997  01  036  105877  5877_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 11:11:22  MG00000007  2023-11-28 11:11:22  MG00000007  View Edit Delete
51253  01  031  697008  697008_落花生(生)    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51509  01  032  53428  農産物    のうさんぶつ    2024-03-11 00:00:00    2024-03-11 14:39:11  TR01000110  2024-03-11 14:39:11  TR01000110  View Edit Delete
1078  01  005  12144  白葱 パック    しろねぎぱっく    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
1590  01  007  6252  四葉きゅうり  近郷野菜152  すうようきゅうり    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2614  02  51  118  レタス    れたす    2017-02-27 00:00:00            View Edit Delete

Page 455 of 2156, showing 20 records out of 43118 total, starting on record 9081, ending on 9100

(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 9080, 20202025
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117