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
47663  01  031  100020  100020_農産物1    のうさんぶつ    2023-10-03 00:00:00    2023-10-03 16:23:29  MG00000007  2023-10-03 16:23:29  MG00000007  View Edit Delete
47919  01  033  59338  59338_農産物  岡山農産09338  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 14:05:39  MG00000007  2023-10-19 14:05:39  MG00000007  View Edit Delete
48175  01  036  105222  5222_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48431  01  036  105484  5484_農産物1    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48687  01  036  108240  8240_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
48943  01  036  108499  8499_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49199  01  036  108764  8764_農産物1  のうさんぶつ    2023-10-20 00:00:00    2023-10-20 00:00:00  MG00000001  2023-10-20 00:00:00  MG00000001  View Edit Delete
49455  01  033  57829  57829_農産物  岡山農産07829  のうさんぶつ    2023-10-24 00:00:00    2023-10-24 00:00:00  MG00000001  2023-10-24 00:00:00  MG00000001  View Edit Delete
49711  01  036  105582  5582_農産物    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 00:00:00  MG00000001  2023-10-25 00:00:00  MG00000001  View Edit Delete
49967  01  036  105701  5701_農産物1    のうさんぶつ    2023-10-30 00:00:00    2023-10-30 00:00:00  MG00000001  2023-10-30 00:00:00  MG00000001  View Edit Delete
50223  01  033  58235  8235_農産物  広島農産08235  のうさんぶつ    2023-11-07 00:00:00    2023-11-07 00:00:00  MG00000001  2023-11-07 00:00:00  MG00000001  View Edit Delete
50479  01  032  51396  13960_農産物    のうさんぶつ    2023-11-07 00:00:00    2023-11-07 13:33:50  MG00000007  2023-11-07 13:33:50  MG00000007  View Edit Delete
50735  01  033  58581  58581_農産物  広島農産08581  のうさんぶつ    2023-11-15 00:00:00    2023-11-15 00:00:00  MG00000001  2023-11-15 00:00:00  MG00000001  View Edit Delete
50991  01  036  105871  5871_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 10:33:04  MG00000007  2023-11-28 10:33:04  MG00000007  View Edit Delete
51247  01  031  697002  697002_柿    のうさんぶつ    2023-12-08 00:00:00    2023-12-08 00:00:00  MG00000001  2023-12-08 00:00:00  MG00000001  View Edit Delete
51503  01  033  50800  50800_農産物  岡山農産00800  のうさんぶつ    2024-01-19 00:00:00    2024-01-19 11:31:51  MG00000007  2024-01-19 11:31:51  MG00000007  View Edit Delete
1072  01  005  12111  ハクサイ 1/2 1P    はくさいかっと2    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
2608  02  51  108  ネギ    ねぎ    2017-02-27 00:00:00            View Edit Delete
5168  07  81  46  農産物46    のうさんぶつ46    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5424  02  53  54  農産物54    のうさんぶつ54    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete

Page 404 of 2156, showing 20 records out of 43118 total, starting on record 8061, ending on 8080

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