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
1381121  AG01005904 16680444 2023-12-24 00:00:00  01  036 
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  170  2023-12-23 00:00:00  2510888701701  25108887  42  41002 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-12-23 16:58:01  AG01005904      View Edit Delete
5121  AG01001739 9144 2017-03-22 00:00:00  01  006 
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]
 
32600    10  10  128  2017-03-21 00:00:00  0217007101382  0217007  36  36001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2017-03-21 15:49:52  AG01001739  2017-03-21 15:49:57    View Edit Delete
136193  AG02000042 11288 2018-10-14 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]
 
34400  ALL9  42  42  280  2018-10-13 00:00:00  2669510102802  26695101  36  MZ01 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2018-10-13 12:35:45  AG02000042      View Edit Delete
922625  AG01003412 2022-09-08 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]
 
34910  ALL9  180  2022-09-07 00:00:00  1764051001803  17640510  36  36012 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2022-09-07 14:25:57  AG01003412      View Edit Delete
1053697  AG01003372 2023-03-04 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  50  50  300  2023-03-03 00:00:00  1778400103001  17784001  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-03-03 13:58:18  AG01003372      View Edit Delete
1381377  AG01005878 16680085 2023-12-24 00:00:00  01  036 
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]
 
31100  ALL9  90  2023-12-24 00:00:00  2510852100905  25108521  42  41002 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-12-24 07:15:05  AG01005878      View Edit Delete
5377  AG02000001 8634 2017-03-23 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]
 
38110    20  20  180  2017-03-23 00:00:00  2656554201806  26565542  36  MZ01 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2017-03-23 11:43:46  AG02000001  2017-03-23 11:43:47    View Edit Delete
70913  AG01002709 2018-05-18 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]
 
31700  ALL9  150  150  240  2018-05-17 00:00:00  1767582402408  17675824  36  36003 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2018-05-17 09:55:46  AG01002709      View Edit Delete
398593  AG01003907 2020-07-03 00:00:00  01  010 
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]
 
34800  ALL9  125  2020-07-02 00:00:00  2511079401257  25110794  40  40002 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2020-07-02 03:06:47  AG01003907      View Edit Delete
464129  AG02000067 45288 2020-11-09 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]
 
31100  ALL9  138  2020-11-08 00:00:00  2627716101388  26277161  36  MZ01 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2020-11-08 16:18:25  AG02000067      View Edit Delete
791809  AG01001994 2022-03-18 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]
 
90001  ALL9  200  200  128  2022-03-18 00:00:00  1770638501284  17706385  37  37005 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2022-03-18 08:15:38  AG01001994      View Edit Delete
1316097  AG01005847 16679542 2023-11-08 00:00:00  01  036 
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]
 
31500  ALL9  10  10  120  2023-11-08 00:00:00  2510547301204  25105473  40  40008 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-11-08 08:40:45  AG01005847      View Edit Delete
1381633  AG01003576 1739138 2023-12-24 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]
 
31310  ALL9  90  2023-12-24 00:00:00  1771182900905  17711829  37  37005 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-12-24 09:43:46  AG01003576      View Edit Delete
5633  AG01001550 2017-03-25 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]
 
33200    144  144  258  2017-03-24 00:00:00  1763432702582  17634327  36  36001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2017-03-24 16:51:54  AG01001550  2017-03-24 16:51:54    View Edit Delete
136705  AG01003276 2018-10-16 00:00:00  01  010 
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]
 
37300  ALL9  36  36  100  2018-10-15 00:00:00  2510361101004  25103611  43  43001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2018-10-15 08:21:44  AG01003276      View Edit Delete
333313  AG00000000 2020-02-18 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]
 
30600  ALL9  288  2020-02-18 00:00:00  1799993502880  17999935  30  30002 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2020-02-18 09:55:01  AG00000000      View Edit Delete
464385  AG01003911 2020-11-11 00:00:00  01  010 
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]
 
90000  ALL9  300  300  240  2020-11-09 00:00:00  2510418102404  25104181  42  42004 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2020-11-09 10:32:29  AG01003911      View Edit Delete
529921  AG01001633 2021-04-05 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]
 
30300  ALL9  40  40  40  2021-04-03 00:00:00  1764353400403  17643534  36  36002 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2021-04-03 18:18:53  AG01001633      View Edit Delete
1185281  AG01005076 1556839 2023-07-22 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]
 
34300  ALL9  128  2023-07-21 00:00:00  2510091901288  25100919  42  42112 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-07-21 08:19:37  AG01005076      View Edit Delete
1316353  AG01005358 1730952 2023-11-08 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]
 
31900  ALL9  120  2023-11-08 00:00:00  1767200301205  17672003  36  36003 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-11-08 10:26:38  AG01005358      View Edit Delete

Page 219 of 70806, showing 20 records out of 1416111 total, starting on record 4361, ending on 4380

(default) 2 queries took 5678 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_shipment_product_characters` desc LIMIT 4360, 202020933
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 = 1114745