/* Origin (request): GET https://testtra.puntlandgov.org
   Query 9 - 2025-05-12 11:29:41 [106.57ms] */
select sum(`payment_amount`) as aggregate from `Payment` inner join `invoice_payment` on `invoice_payment`.`payment_id` = `payment`.`id` inner join `invoice` on `invoice_payment`.`invoice_id` = `invoice`.`id` inner join `transaction` on `invoice`.`transaction_id` = `transaction`.`id` where `transaction`.`service_id` = 1 and `transaction`.`status` = 'END' and `payment_date` > '2025-05-11' and `Payment`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 11 - 2025-05-12 11:29:42 [280.38ms] */
select sum(`outstanding_balance`) as aggregate from `invoice` inner join `transaction` on `invoice`.`transaction_id` = `transaction`.`id` where `transaction`.`service_id` = 1 and `invoice`.`invoice_amount` <> 0.00 and `due_date` < '2025-05-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 12 - 2025-05-12 11:29:42 [964.26ms] */
select sum(`outstanding_balance`) as aggregate from `invoice` inner join `transaction` on `invoice`.`transaction_id` = `transaction`.`id` where `transaction`.`service_id` = 2 and `invoice`.`invoice_amount` <> 0.00 and `due_date` < '2025-05-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org/w/wkflw
   Query 8 - 2025-05-12 11:30:12 [287.99ms] */
select count(*) as aggregate from `transaction` where `transaction`.`parent_id` is null and `status` != 'CANCELED' and `transaction`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/livewire/message/party.select-party-component
   Query 5 - 2025-05-12 12:34:12 [304.57ms] */
select count(*) as aggregate from `person` inner join `party` on `party`.`partyable_id` = `person`.`id` and `party`.`partyable_type` = 'Person' left join `customer_identity_documents` on `customer_identity_documents`.`party_id` = `party`.`id` where (((`first_name` like '%96574590%' or `second_name` like '%96574590%' or `third_name` like '%96574590%' or `fourth_name` like '%96574590%' or `phone_number_1` like '%96574590%' or `phone_number_2` like '%96574590%' or `customer_identity_documents`.`id_number` like '%96574590%')) and `provisional` = 'N') and `person`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/livewire/message/party.select-party-component
   Query 6 - 2025-05-12 12:34:12 [190.79ms] */
select `person`.* from `person` inner join `party` on `party`.`partyable_id` = `person`.`id` and `party`.`partyable_type` = 'Person' left join `customer_identity_documents` on `customer_identity_documents`.`party_id` = `party`.`id` where (((`first_name` like '%96574590%' or `second_name` like '%96574590%' or `third_name` like '%96574590%' or `fourth_name` like '%96574590%' or `phone_number_1` like '%96574590%' or `phone_number_2` like '%96574590%' or `customer_identity_documents`.`id_number` like '%96574590%')) and `provisional` = 'N') and `person`.`deleted_at` is null order by `first_name` asc, `second_name` asc, `third_name` asc, `fourth_name` asc limit 10 offset 0;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/livewire/message/party.select-party-component
   Query 5 - 2025-05-12 12:49:15 [198.56ms] */
select count(*) as aggregate from `person` inner join `party` on `party`.`partyable_id` = `person`.`id` and `party`.`partyable_type` = 'Person' left join `customer_identity_documents` on `customer_identity_documents`.`party_id` = `party`.`id` where (((`first_name` like '%23%' or `second_name` like '%23%' or `third_name` like '%23%' or `fourth_name` like '%23%' or `phone_number_1` like '%23%' or `phone_number_2` like '%23%' or `customer_identity_documents`.`id_number` like '%23%')) and `provisional` = 'N') and `person`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/livewire/message/party.select-party-component
   Query 6 - 2025-05-12 12:49:15 [199.88ms] */
select `person`.* from `person` inner join `party` on `party`.`partyable_id` = `person`.`id` and `party`.`partyable_type` = 'Person' left join `customer_identity_documents` on `customer_identity_documents`.`party_id` = `party`.`id` where (((`first_name` like '%23%' or `second_name` like '%23%' or `third_name` like '%23%' or `fourth_name` like '%23%' or `phone_number_1` like '%23%' or `phone_number_2` like '%23%' or `customer_identity_documents`.`id_number` like '%23%')) and `provisional` = 'N') and `person`.`deleted_at` is null order by `first_name` asc, `second_name` asc, `third_name` asc, `fourth_name` asc limit 10 offset 0;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/livewire/message/party.select-party-component
   Query 5 - 2025-05-12 12:49:16 [137.41ms] */
select count(*) as aggregate from `person` inner join `party` on `party`.`partyable_id` = `person`.`id` and `party`.`partyable_type` = 'Person' left join `customer_identity_documents` on `customer_identity_documents`.`party_id` = `party`.`id` where (((`first_name` like '%233%' or `second_name` like '%233%' or `third_name` like '%233%' or `fourth_name` like '%233%' or `phone_number_1` like '%233%' or `phone_number_2` like '%233%' or `customer_identity_documents`.`id_number` like '%233%')) and `provisional` = 'N') and `person`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/livewire/message/party.select-party-component
   Query 6 - 2025-05-12 12:49:16 [186.12ms] */
select `person`.* from `person` inner join `party` on `party`.`partyable_id` = `person`.`id` and `party`.`partyable_type` = 'Person' left join `customer_identity_documents` on `customer_identity_documents`.`party_id` = `party`.`id` where (((`first_name` like '%233%' or `second_name` like '%233%' or `third_name` like '%233%' or `fourth_name` like '%233%' or `phone_number_1` like '%233%' or `phone_number_2` like '%233%' or `customer_identity_documents`.`id_number` like '%233%')) and `provisional` = 'N') and `person`.`deleted_at` is null order by `first_name` asc, `second_name` asc, `third_name` asc, `fourth_name` asc limit 10 offset 0;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org/m/vehicle
   Query 7 - 2025-05-12 12:49:33 [130.47ms] */
select count(*) as aggregate from `vehicle` left join `party_vehicle` on `party_vehicle`.`vehicle_id` = `vehicle`.`id` left join `party` on `party_vehicle`.`party_id` = `party`.`id` where `party_vehicle`.`is_owner` = 'Y' and `party_vehicle`.`deleted_at` is null and `vehicle`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/livewire/message/vehicle.select-vehicle-component
   Query 15 - 2025-05-12 12:49:42 [106.66ms] */
select `vehicle`.* from `vehicle` where (`license_plate` like '%TW161%' or `vin` like '%TW161%') and vehicle.id NOT IN (SELECT vehicle_id FROM party_vehicle WHERE party_vehicle.deleted_at IS NULL) and `vehicle`.`migration_id` is null and `vehicle`.`deleted_at` is null limit 6 offset 0;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 11 - 2025-05-12 15:02:46 [297.6ms] */
select sum(`outstanding_balance`) as aggregate from `invoice` inner join `transaction` on `invoice`.`transaction_id` = `transaction`.`id` where `transaction`.`service_id` = 1 and `invoice`.`invoice_amount` <> 0.00 and `due_date` < '2025-05-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 12 - 2025-05-12 15:02:47 [946.87ms] */
select sum(`outstanding_balance`) as aggregate from `invoice` inner join `transaction` on `invoice`.`transaction_id` = `transaction`.`id` where `transaction`.`service_id` = 2 and `invoice`.`invoice_amount` <> 0.00 and `due_date` < '2025-05-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/livewire/message/party.select-party-component
   Query 5 - 2025-05-12 15:02:53 [148.93ms] */
select count(*) as aggregate from `person` inner join `party` on `party`.`partyable_id` = `person`.`id` and `party`.`partyable_type` = 'Person' left join `customer_identity_documents` on `customer_identity_documents`.`party_id` = `party`.`id` where (((`first_name` like '%96574590%' or `second_name` like '%96574590%' or `third_name` like '%96574590%' or `fourth_name` like '%96574590%' or `phone_number_1` like '%96574590%' or `phone_number_2` like '%96574590%' or `customer_identity_documents`.`id_number` like '%96574590%')) and `provisional` = 'N') and `person`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/livewire/message/party.select-party-component
   Query 6 - 2025-05-12 15:02:53 [189.57ms] */
select `person`.* from `person` inner join `party` on `party`.`partyable_id` = `person`.`id` and `party`.`partyable_type` = 'Person' left join `customer_identity_documents` on `customer_identity_documents`.`party_id` = `party`.`id` where (((`first_name` like '%96574590%' or `second_name` like '%96574590%' or `third_name` like '%96574590%' or `fourth_name` like '%96574590%' or `phone_number_1` like '%96574590%' or `phone_number_2` like '%96574590%' or `customer_identity_documents`.`id_number` like '%96574590%')) and `provisional` = 'N') and `person`.`deleted_at` is null order by `first_name` asc, `second_name` asc, `third_name` asc, `fourth_name` asc limit 10 offset 0;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/livewire/message/vehicle.select-vehicle-component
   Query 14 - 2025-05-12 15:03:01 [101.91ms] */
select count(*) as aggregate from `vehicle` where (`license_plate` like '%TW161%' or `vin` like '%TW161%') and vehicle.id NOT IN (SELECT vehicle_id FROM party_vehicle WHERE party_vehicle.deleted_at IS NULL) and `vehicle`.`migration_id` is null and `vehicle`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/livewire/message/vehicle.select-vehicle-component
   Query 15 - 2025-05-12 15:03:01 [106.24ms] */
select `vehicle`.* from `vehicle` where (`license_plate` like '%TW161%' or `vin` like '%TW161%') and vehicle.id NOT IN (SELECT vehicle_id FROM party_vehicle WHERE party_vehicle.deleted_at IS NULL) and `vehicle`.`migration_id` is null and `vehicle`.`deleted_at` is null limit 6 offset 0;
/*==================================================*/
