[Sat, 06 Mar 21 13:11:53 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0
[Sat, 06 Mar 21 13:11:54 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 13:12:00 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0
[Sat, 06 Mar 21 13:12:01 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 13:12:08 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 13:12:45 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 13:13:21 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 13:13:59 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0
[Sat, 06 Mar 21 13:14:00 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 13:14:08 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 13:15:48 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 13:17:39 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 13:17:46 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 13:18:32 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 13:19:07 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 13:21:37 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 13:22:25 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 13:22:53 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 13:23:34 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 13:46:45 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0
[Sat, 06 Mar 21 13:46:46 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 13:46:55 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 13:52:48 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 13:53:59 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 13:54:26 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 13:54:56 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0
[Sat, 06 Mar 21 13:54:56 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 13:55:02 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 13:58:44 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 13:58:47 +0700][INFO] UPDATE `order_v2` SET `seller_order_id` = ?, `fulfill_vendor` = ?, `fulfill_date` = NOW() WHERE amz_order_id = ?
[Sat, 06 Mar 21 13:58:55 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0
[Sat, 06 Mar 21 13:58:55 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 14:00:09 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 14:00:12 +0700][INFO] UPDATE `order_v2` SET `seller_order_id` = ?, `fulfill_vendor` = ?, `fulfill_date` = NOW() WHERE amz_order_id = ?
[Sat, 06 Mar 21 14:00:26 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 14:00:28 +0700][INFO] UPDATE `order_v2` SET `seller_order_id` = ?, `fulfill_vendor` = ?, `fulfill_date` = NOW() WHERE amz_order_id = ?
[Sat, 06 Mar 21 14:00:39 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 14:00:42 +0700][INFO] UPDATE `order_v2` SET `seller_order_id` = ?, `fulfill_vendor` = ?, `fulfill_date` = NOW() WHERE amz_order_id = ?
[Sat, 06 Mar 21 14:19:33 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0
[Sat, 06 Mar 21 14:19:33 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 14:34:16 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0 OFFSET :APL1
[Sat, 06 Mar 21 14:34:17 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 14:34:52 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0
[Sat, 06 Mar 21 14:34:53 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 14:34:56 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0 OFFSET :APL1
[Sat, 06 Mar 21 14:34:57 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 14:43:58 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0
[Sat, 06 Mar 21 14:43:59 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 14:44:06 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 14:44:07 +0700][INFO] INSERT INTO `order_log` (`amz_order_id`, `date`, `request`) VALUES (?, NOW(), ?)
[Sat, 06 Mar 21 14:44:09 +0700][INFO] UPDATE `order_log` SET `response` = ? WHERE amz_order_id = ?
[Sat, 06 Mar 21 14:44:09 +0700][INFO] UPDATE `order_v2` SET `seller_order_id` = ?, `fulfill_vendor` = ?, `fulfill_date` = NOW() WHERE amz_order_id = ?
[Sat, 06 Mar 21 14:46:06 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0
[Sat, 06 Mar 21 14:46:07 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 14:46:43 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 14:46:44 +0700][INFO] INSERT INTO `order_log` (`amz_order_id`, `date`, `request`) VALUES (?, NOW(), ?)
[Sat, 06 Mar 21 14:46:45 +0700][INFO] UPDATE `order_log` SET `response` = ? WHERE amz_order_id = ?
[Sat, 06 Mar 21 14:46:46 +0700][INFO] UPDATE `order_v2` SET `seller_order_id` = ?, `fulfill_vendor` = ?, `fulfill_date` = IF(fulfill_date IS NULL, NOW(), fulfill_date) WHERE amz_order_id = ?
[Sat, 06 Mar 21 14:46:51 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0
[Sat, 06 Mar 21 14:46:52 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 14:49:03 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0
[Sat, 06 Mar 21 14:49:04 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 14:49:12 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 14:49:13 +0700][INFO] INSERT INTO `order_log` (`amz_order_id`, `date`, `request`) VALUES (?, NOW(), ?)
[Sat, 06 Mar 21 14:49:15 +0700][INFO] UPDATE `order_log` SET `response` = ? WHERE amz_order_id = ?
[Sat, 06 Mar 21 14:49:15 +0700][INFO] UPDATE `order_v2` SET `seller_order_id` = ?, `fulfill_vendor` = ?, `fulfill_date` = IF(fulfill_date IS NULL, NOW(), fulfill_date) WHERE amz_order_id = ?
[Sat, 06 Mar 21 14:50:49 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0
[Sat, 06 Mar 21 14:50:49 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 14:50:58 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0
[Sat, 06 Mar 21 14:50:58 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 14:51:45 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0
[Sat, 06 Mar 21 14:51:45 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 14:51:56 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 14:51:57 +0700][INFO] INSERT INTO `order_log` (`amz_order_id`, `date`, `request`) VALUES (?, NOW(), ?)
[Sat, 06 Mar 21 14:51:58 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 14:51:59 +0700][INFO] INSERT INTO `order_log` (`amz_order_id`, `date`, `request`) VALUES (?, NOW(), ?)
[Sat, 06 Mar 21 14:52:00 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 14:52:01 +0700][INFO] INSERT INTO `order_log` (`amz_order_id`, `date`, `request`) VALUES (?, NOW(), ?)
[Sat, 06 Mar 21 14:52:38 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0
[Sat, 06 Mar 21 14:52:39 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 14:53:01 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 14:53:03 +0700][INFO] INSERT INTO `order_log` (`amz_order_id`, `date`, `request`) VALUES (?, NOW(), ?)
[Sat, 06 Mar 21 14:53:53 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0
[Sat, 06 Mar 21 14:53:53 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 14:53:59 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 14:54:00 +0700][INFO] INSERT INTO `order_log` (`amz_order_id`, `date`, `request`) VALUES (?, NOW(), ?)
[Sat, 06 Mar 21 14:54:02 +0700][INFO] UPDATE `order_log` SET `response` = ? WHERE amz_order_id = ?
[Sat, 06 Mar 21 14:54:02 +0700][INFO] UPDATE `order_v2` SET `seller_order_id` = ?, `fulfill_vendor` = ?, `fulfill_date` = NOW() WHERE amz_order_id = ?
[Sat, 06 Mar 21 14:54:10 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0
[Sat, 06 Mar 21 14:54:11 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 15:00:05 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0 OFFSET :APL1
[Sat, 06 Mar 21 15:00:06 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 15:00:16 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 15:01:23 +0700][INFO] SELECT * FROM order_v2 WHERE amz_order_id = :amz_order_id
[Sat, 06 Mar 21 15:01:24 +0700][INFO] INSERT INTO `order_log` (`amz_order_id`, `date`, `request`) VALUES (?, NOW(), ?)
[Sat, 06 Mar 21 15:01:26 +0700][INFO] UPDATE `order_log` SET `response` = ? WHERE amz_order_id = ?
[Sat, 06 Mar 21 15:01:26 +0700][INFO] UPDATE `order_v2` SET `seller_order_id` = ?, `fulfill_vendor` = ?, `fulfill_date` = NOW() WHERE amz_order_id = ?
[Sat, 06 Mar 21 15:01:39 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0
[Sat, 06 Mar 21 15:01:39 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 15:01:42 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0 OFFSET :APL1
[Sat, 06 Mar 21 15:01:42 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 15:07:56 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0 OFFSET :APL1
[Sat, 06 Mar 21 15:07:57 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 15:08:00 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0 OFFSET :APL1
[Sat, 06 Mar 21 15:08:01 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'
[Sat, 06 Mar 21 15:09:12 +0700][INFO] SELECT `o`.`amz_order_id`, `o`.`seller_order_id`, `o`.`seller_id`, `o`.`seller_name`, `o`.`fulfill_vendor`, `o`.`case_status`, `o`.`order_status`, `o`.`fulfill_status`, `o`.`ship_status`, `o`.`purchase_date`, `o`.`latest_ship_date`, `o`.`latest_delivery_date`, `o`.`fulfill_date`, `o`.`ship_date`, `o`.`delivery_date`, `o`.`scheduled_delivery_date`, `o`.`last_activity_date`, `o`.`tracking_id`, `o`.`tracking_url`, `o`.`tracking_service`, `o`.`tracking_provider`, `o`.`order_data`, `o`.`is_custom`, `o`.`state`, `o`.`created_at`, `o`.`updated_at`, `o`.`last_check_tracking` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled' ORDER BY `o`.`purchase_date` DESC LIMIT :APL0 OFFSET :APL1
[Sat, 06 Mar 21 15:09:13 +0700][INFO] SELECT COUNT(*) AS `rowcount` FROM `order_v2` AS `o` WHERE `o`.`seller_id` = 'A2PYLFDOZ0GAT8' AND `o`.`order_status` <> 'Canceled'