INSERTINTOcron_job_logs (job_name,description,status,data,started_at,finished_at,execution_time,processed_items,failed_items,api_calls,error_message,created_at,updated_at) VALUES ('orders_update','Atualização de status dos pedidos','running','[]','2026-01-29 01:20:03',NULL,NULL,0,0,NULL,NULL,'2026-01-29 01:20:03',NULL);
SELECTt0.idASid_1,t0.order_idASorder_id_2,t0.linkASlink_3,t0.quantityASquantity_4,t0.priceASprice_5,t0.statusASstatus_6,t0.start_countASstart_count_7,t0.remainsASremains_8,t0.created_atAScreated_at_9,t0.updated_atASupdated_at_10,t0.completed_atAScompleted_at_11,t0.api_responseASapi_response_12,t0.commentsAScomments_13,t0.service_typeASservice_type_14,t0.api_order_idASapi_order_id_15,t0.user_idASuser_id_16,t0.service_idASservice_id_17FROM`orders`t0WHEREt0.statusIN (?,?,?) ORDER BYt0.created_atASCLIMIT50
SELECTt0.idASid_1,t0.order_idASorder_id_2,t0.linkASlink_3,t0.quantityASquantity_4,t0.priceASprice_5,t0.statusASstatus_6,t0.start_countASstart_count_7,t0.remainsASremains_8,t0.created_atAScreated_at_9,t0.updated_atASupdated_at_10,t0.completed_atAScompleted_at_11,t0.api_responseASapi_response_12,t0.commentsAScomments_13,t0.service_typeASservice_type_14,t0.api_order_idASapi_order_id_15,t0.user_idASuser_id_16,t0.service_idASservice_id_17FROM`orders`t0WHEREt0.statusIN (?,?,?)
ORDER BYt0.created_atASCLIMIT50
SELECTt0.idASid_1,t0.order_idASorder_id_2,t0.linkASlink_3,t0.quantityASquantity_4,t0.priceASprice_5,t0.statusASstatus_6,t0.start_countASstart_count_7,t0.remainsASremains_8,t0.created_atAScreated_at_9,t0.updated_atASupdated_at_10,t0.completed_atAScompleted_at_11,t0.api_responseASapi_response_12,t0.commentsAScomments_13,t0.service_typeASservice_type_14,t0.api_order_idASapi_order_id_15,t0.user_idASuser_id_16,t0.service_idASservice_id_17FROM`orders`t0WHEREt0.statusIN ('pending','processing','in_progress') ORDER BYt0.created_atASCLIMIT50;