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
41232  01  033  56298  56298_農産物  岡山農産06298  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
41488  01  033  55388  55388_農産物  岡山農産05388  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
41744  01  033  53443  53443_農産物  岡山農産03443  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
42000  01  033  52928  52928_農産物  岡山農産02928  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
42256  01  033  52684  52684_農産物  岡山農産02684  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
42512  01  033  56841  56841_農産物  岡山農産06841  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
42768  01  031  605422  605422_農産物22    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
43024  01  031  600409  600409_農産物09    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
43280  01  031  787627  787627_農産物27    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
43536  01  031  629101  629101_農産物1    のうさんぶつ    2023-06-23 00:00:00    2023-06-23 00:00:00  MG00000001  2023-06-23 00:00:00  MG00000001  View Edit Delete
43792  01  031  647717  647717_農産物17    のうさんぶつ    2023-06-23 00:00:00    2023-06-23 00:00:00  MG00000001  2023-06-23 00:00:00  MG00000001  View Edit Delete
44048  04  710  99450  農産物    のうさんぶつ    2023-06-28 00:00:00    2023-06-28 09:09:39  MG00000001  2023-06-28 09:09:39  MG00000001  View Edit Delete
44304  01  033  50150  50150_農産物  岡山農産00150  のうさんぶつ    2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
44560  01  033  50406  50406_農産物  岡山農産00406  のうさんぶつ    2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
44816  01  033  50662  50662_農産物  岡山農産00662  のうさんぶつ    2023-07-03 00:00:00    2023-07-03 00:00:00  MG00000001  2023-07-03 00:00:00  MG00000001  View Edit Delete
45072  01  034  80461  04610_農産物    のうさんぶつ    2023-07-19 00:00:00    2023-07-19 00:00:00  MG00000001  2023-07-19 00:00:00  MG00000001  View Edit Delete
46352  01  035  101560  10156_農産物  産地直送 野菜156  のうさんぶつ    2023-08-25 00:00:00    2023-08-25 00:00:00  MG00000001  2023-08-25 00:00:00  MG00000001  View Edit Delete
46608  01  033  56529  56529_農産物  岡山農産06529  のうさんぶつ    2023-08-31 00:00:00    2023-08-31 00:00:00  MG00000001  2023-08-31 00:00:00  MG00000001  View Edit Delete
46864  01  033  58994  58994_農産物  岡山農産08994  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete
47120  01  033  57377  57377_農産物  岡山農産07377  のうさんぶつ    2023-09-25 00:00:00    2023-09-25 00:00:00  MG00000001  2023-09-25 00:00:00  MG00000001  View Edit Delete

Page 142 of 2156, showing 20 records out of 43118 total, starting on record 2821, ending on 2840

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