Label Logs

Id User Farmer Product Arrival Day Trader Company Cd Company Product Cd Company Product Nm Company Product Reciept Nm Sys Product Cd Shop Cd Label Issue Number Real Issue Number Price Amount Recycling Mark Flg Issue Day Brc Info Brc Shipment Product Characters Brc Shipment Product Cd Brc Price Cd Brc Price Characters Locality Cd Pickup Point Cd Amount Not Sel Flg Brc Not Print Flg Print Status Created Insert User Modified Update User Actions
1147393  AG01001516 2023-06-20 00:00:00  01  002 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
30100  ALL9  40  40  198  2023-06-20 00:00:00  2011082701981  20110827  36  36003 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-06-20 07:23:56  AG01001516      View Edit Delete
1212929  AG04000078 1442922 2023-08-11 00:00:00  04  710 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34300  219  15  15  178  2023-08-10 00:00:00  2389695001928  2389695  15  OK02 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-08-10 14:08:20  AG04000078      View Edit Delete
1344001  AG01005440 1668289 2023-11-28 00:00:00  01  911 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
33200  ALL9  15  15  158  2023-11-27 00:00:00  2510461801583  25104618  42  42106 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-11-27 16:50:27  AG01005440      View Edit Delete
1409537  AG01004614 1723691 2024-01-18 00:00:00  01  031 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34460  ALL9  36  36  298  2024-01-18 00:00:00  1768620202981  17686202  36  36002 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-18 08:32:04  AG01004614      View Edit Delete
33537  AG05000063 2018-01-18 00:00:00  05  71 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
30100  245  20  20  198  2018-01-17 00:00:00  2389679002132  2389679  15  OK01 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2018-01-17 14:24:31  AG05000063  2018-01-17 14:24:34    View Edit Delete
426753  AG01001995 2020-08-19 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
45000  ALL9  30  30  398  2020-08-19 00:00:00  1770648103980  17706481  37  37005 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2020-08-19 06:54:21  AG01001995      View Edit Delete
492289  AG01003828 2021-01-14 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
40100  ALL9  40  40  180  2021-01-14 00:00:00  1770726901804  17707269  37  37003 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2021-01-14 08:08:04  AG01003828      View Edit Delete
688897  AG05000086 2021-10-20 00:00:00  05  71 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
31800  209  12  12  138  2021-10-19 00:00:00  2389704001499  2389704  15  OK01 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2021-10-19 14:49:03  AG05000086      View Edit Delete
951041  AG02000059 12127 2022-10-16 00:00:00  02  51 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34300  ALL9  47  47  170  2022-10-15 00:00:00  2694311201706  26943112  36  MZ01 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2022-10-15 09:12:39  AG02000059      View Edit Delete
1082113  AG01004534 2023-04-10 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34400  ALL9  150  150  280  2023-04-10 00:00:00  1769450102809  17694501  36  36002 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-04-10 12:30:51  AG01004534      View Edit Delete
1147649  AG01004959 1558399 2023-06-21 00:00:00  01  911 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34500  ALL9  110  2023-06-20 00:00:00  2510130701107  25101307  42  42112 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-06-20 09:51:00  AG01004959      View Edit Delete
1213185  AG01005035 1593739 2023-08-11 00:00:00  01  062 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34100  ALL9  128  2023-08-10 00:00:00  2364632301286  23646323  42  42112 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-08-10 18:47:02  AG01005035      View Edit Delete
33793  AG05000033 2018-01-19 00:00:00  05  71 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34400  281  340  2018-01-18 00:00:00  2389643003677  2389643  15  OK01 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2018-01-18 15:28:09  AG05000033  2018-01-18 15:28:11    View Edit Delete
99329  AG05000034 2018-07-16 00:00:00  05  71 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34300  215  15  15  168  2018-07-15 00:00:00  2389644001818  2389644  15  OK01 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2018-07-15 15:31:28  AG05000034      View Edit Delete
361473  AG01003019 2020-04-24 00:00:00  01  002 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
33400  ALL9  162  162  118  2020-04-23 00:00:00  2011052101186  20110521  26  26004 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2020-04-23 10:41:35  AG01003019      View Edit Delete
427009  AG01003701 0000-00-00 00:00:00  01  002 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34300  ALL9  130  2020-08-19 00:00:00  2090494301309  20904943  27  27002 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2020-08-19 12:33:01  AG01003701      View Edit Delete
492545  AG05000010 2021-01-15 00:00:00  05  71 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
31800  265  32  32  188  2021-01-14 00:00:00  2389619002031  2389619  15  OK01 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2021-01-14 14:39:40  AG05000010      View Edit Delete
558081  AG01003650 2021-05-23 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34500  ALL9  50  50  100  2021-05-20 00:00:00  1771230501009  17712305  37  37007 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2021-05-20 08:08:40  AG01003650      View Edit Delete
820225  AG05000025 2022-05-08 00:00:00  05  71 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
35100  231  12  12  210  2022-05-07 00:00:00  2389634002269  2389634  15  OK01 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2022-05-07 14:33:26  AG05000025      View Edit Delete
951297  AG04000041 1480374 2022-10-16 00:00:00  04  710 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
33400  207  12  12  158  2022-10-15 00:00:00  2389652001701  2389652  15  OK02 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2022-10-15 14:08:39  AG04000041      View Edit Delete

Page 223 of 70806, showing 20 records out of 1416111 total, starting on record 4441, ending on 4460

(default) 2 queries took 5672 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `LabelLog`.`id`, `LabelLog`.`user_id`, `LabelLog`.`farmer_product_id`, `LabelLog`.`sameday_sequence_no`, `LabelLog`.`arrival_day`, `LabelLog`.`trader_id`, `LabelLog`.`company_cd`, `LabelLog`.`co_product_cd`, `LabelLog`.`co_product_nm`, `LabelLog`.`co_product_reciept_nm`, `LabelLog`.`sys_product_cd`, `LabelLog`.`sys_product_nm`, `LabelLog`.`display_product_nm`, `LabelLog`.`display_product_fk`, `LabelLog`.`shop_cd`, `LabelLog`.`label_issue_number`, `LabelLog`.`Real_issue_number`, `LabelLog`.`price`, `LabelLog`.`amount`, `LabelLog`.`recycling_mark_flg`, `LabelLog`.`issue_day`, `LabelLog`.`brc_info`, `LabelLog`.`brc_shipment_product_characters`, `LabelLog`.`brc_shipment_product_cd`, `LabelLog`.`brc_price_cd`, `LabelLog`.`brc_price_characters`, `LabelLog`.`brc_type_flag`, `LabelLog`.`brc_mid_flag`, `LabelLog`.`val_pos_pattern`, `LabelLog`.`mid_checkdigit_flag`, `LabelLog`.`locality_cd`, `LabelLog`.`locality_nm`, `LabelLog`.`pickup_point_cd`, `LabelLog`.`amount_not_sel_flg`, `LabelLog`.`print_Status`, `LabelLog`.`created`, `LabelLog`.`insert_user`, `LabelLog`.`modified`, `LabelLog`.`update_user`, `User`.`id`, `User`.`login_id`, `User`.`user_nm`, `User`.`user_fk`, `User`.`user_type`, `User`.`password`, `User`.`mail_address_1`, `User`.`mail_address_2`, `User`.`login_rock_flg`, `User`.`last_login_day`, `User`.`use_start_day`, `User`.`use_end_day`, `User`.`del_flg`, `User`.`init_pass_flg`, `User`.`created`, `User`.`insert_user`, `User`.`modified`, `User`.`update_user`, `FarmerProduct`.`id`, `FarmerProduct`.`farmer_id`, `FarmerProduct`.`trader_id`, `FarmerProduct`.`cmp_product_id`, `FarmerProduct`.`company_cd`, `FarmerProduct`.`co_product_cd`, `FarmerProduct`.`sys_product_cd`, `FarmerProduct`.`display_product_nm`, `FarmerProduct`.`display_product_fk`, `FarmerProduct`.`display_locality`, `FarmerProduct`.`farmer_edit_status`, `FarmerProduct`.`brc_shipment_product_characters`, `FarmerProduct`.`brc_shipment_product_cd`, `FarmerProduct`.`brc_price_cd`, `FarmerProduct`.`brc_price_characters`, `FarmerProduct`.`company_shipment_cd`, `FarmerProduct`.`brc_type_flag`, `FarmerProduct`.`brc_mid_flag`, `FarmerProduct`.`val_pos_pattern`, `FarmerProduct`.`mid_checkdigit_flag`, `FarmerProduct`.`shipment_start_month`, `FarmerProduct`.`shipment_end_month`, `FarmerProduct`.`use_start_day`, `FarmerProduct`.`use_end_day`, `FarmerProduct`.`del_flg`, `FarmerProduct`.`created`, `FarmerProduct`.`insert_user`, `FarmerProduct`.`modified`, `FarmerProduct`.`update_user` FROM `sato_agri`.`label_logs` AS `LabelLog` LEFT JOIN `sato_agri`.`users` AS `User` ON (`LabelLog`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`farmer_products` AS `FarmerProduct` ON (`LabelLog`.`farmer_product_id` = `FarmerProduct`.`id`) WHERE 1 = 1 ORDER BY `LabelLog`.`brc_price_cd` asc LIMIT 4440, 202020940
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`label_logs` AS `LabelLog` LEFT JOIN `sato_agri`.`users` AS `User` ON (`LabelLog`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`farmer_products` AS `FarmerProduct` ON (`LabelLog`.`farmer_product_id` = `FarmerProduct`.`id`) WHERE 1 = 1114732