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
38913  01  031  728826  728826_農産物26    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
39169  01  031  820212  820212_農産物12    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
39425  01  031  823228  823228_農産物28    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
39681  01  031  824714  824714_農産物14    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
39937  01  033  54316  54316_農産物  岡山農産04316  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
40193  01  033  54572  54572_農産物  岡山農産04572  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
40449  01  033  54828  54828_農産物  岡山農産04828  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
40705  01  033  54960  54960_農産物  岡山農産04960  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
40961  01  033  56022  56022_農産物  岡山農産06022  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
41217  01  033  56282  56282_農産物  岡山農産06282  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
41473  01  033  55373  55373_農産物  岡山農産05373  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
41729  01  033  53346  53346_農産物  岡山農産03346  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
41985  01  033  52913  52913_農産物  岡山農産02913  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
42241  01  033  52669  52669_農産物  岡山農産02669  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
42497  01  033  56826  56826_農産物  岡山農産06826  のうさんぶつ    2023-04-13 00:00:00    2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
42753  01  031  605407  605407_農産物7    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
43009  01  031  531024  531024_農産物24    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
43265  01  031  787612  787612_農産物12    のうさんぶつ    2023-04-04 00:00:00    2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
43521  01  031  621516  621516_農産物16    のうさんぶつ    2023-06-23 00:00:00    2023-06-23 00:00:00  MG00000001  2023-06-23 00:00:00  MG00000001  View Edit Delete
43777  01  031  647702  647702_農産物2    のうさんぶつ    2023-06-23 00:00:00    2023-06-23 00:00:00  MG00000001  2023-06-23 00:00:00  MG00000001  View Edit Delete

Page 16 of 2156, showing 20 records out of 43118 total, starting on record 301, ending on 320

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