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
472  01  002  20120155  ネーブルオレンジ    ねーぶるおれんじ    2016-08-29 00:00:00    2016-08-30 12:24:41  MG00000001  2020-10-13 13:31:53  MG00000005  View Edit Delete
2776  01  002  20110372  野菜    やさい    2017-02-28 00:00:00            View Edit Delete
12248  01  002  20110007  トマト    とまと    2022-06-22 00:00:00    2022-06-22 10:38:48  MG00000001  2022-06-22 10:38:48  MG00000001  View Edit Delete
473  01  002  20120156  不知火    しらぬい    2016-08-29 00:00:00    2016-08-30 12:24:41  MG00000001  2020-10-13 13:32:57  MG00000005  View Edit Delete
12249  01  002  20110008  しめじ    しめじ    2022-06-22 00:00:00    2022-06-22 10:39:17  MG00000001  2022-06-22 10:39:17  MG00000001  View Edit Delete
18393  01  002  20110774  野菜    やさい    2022-12-07 00:00:00    2022-12-07 08:14:17  MG00000001  2022-12-07 08:14:17  MG00000001  View Edit Delete
474  01  002  20120157  果実    かじつ    2016-08-29 00:00:00    2016-08-30 12:24:41  MG00000001  2022-05-10 15:53:45  MG00000001  View Edit Delete
12250  01  002  20110009  うすいえんどう    うすいえんどう    2022-06-22 00:00:00    2022-06-22 10:39:40  MG00000001  2022-06-22 10:39:40  MG00000001  View Edit Delete
475  01  002  20120158  柿    かき    2016-08-29 00:00:00    2016-08-30 12:24:41  MG00000001  2016-08-30 12:24:41  MG00000001  View Edit Delete
2779  01  002  20110375  野菜    やさい    2017-02-28 00:00:00            View Edit Delete
12251  01  002  20110041  野菜    やさい    2022-06-22 00:00:00    2022-06-22 10:40:10  MG00000001  2022-06-22 10:40:10  MG00000001  View Edit Delete
476  01  002  20120159  柿    かき    2016-08-29 00:00:00    2016-08-30 12:24:41  MG00000001  2020-10-15 10:15:15  MG00000005  View Edit Delete
2780  01  002  20110376  野菜    やさい    2017-02-28 00:00:00            View Edit Delete
4060  01  002  20110271  野菜    やさい    2016-08-29 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
12252  01  002  20110049  甘長とうがらし    あまながとうがらし    2022-06-22 00:00:00    2022-06-22 10:40:44  MG00000001  2022-06-22 10:40:44  MG00000001  View Edit Delete
477  01  002  20120160  温州みかん    うんしゅうみかん    2016-08-29 00:00:00    2016-08-30 12:24:41  MG00000001  2020-10-13 13:34:07  MG00000005  View Edit Delete
2781  01  002  20110377  野菜    やさい    2017-02-28 00:00:00            View Edit Delete
12253  01  002  20110051  ひもとうししとう    ひもとうししとう    2022-06-22 00:00:00    2022-06-22 10:41:05  MG00000001  2022-06-22 10:41:05  MG00000001  View Edit Delete
478  01  002  20120161  不知火    しらぬい    2016-08-29 00:00:00    2016-08-30 12:24:41  MG00000001  2020-10-13 13:34:38  MG00000005  View Edit Delete
12254  01  002  20110052  胡瓜    きゅうり    2022-06-22 00:00:00    2022-06-22 10:41:34  MG00000001  2022-06-22 10:41:34  MG00000001  View Edit Delete

Page 29 of 2156, showing 20 records out of 43118 total, starting on record 561, ending on 580

(default) 2 queries took 26 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`.`company_cd` asc LIMIT 560, 20202019
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117