/* Origin (request): GET https://testtra.puntlandgov.org
   Query 11 - 2025-02-12 03:10:28 [247.52ms] */
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-02-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 12 - 2025-02-12 03:10:29 [769.96ms] */
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-02-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 7 - 2025-02-12 08:23:08 [138.17ms] */
select count(*) as aggregate from `vehicle` where `vehicle`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 9 - 2025-02-12 08:23:08 [140.3ms] */
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-02-11' and `Payment`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 11 - 2025-02-12 08:23:09 [542.82ms] */
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-02-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 12 - 2025-02-12 08:23:10 [993.65ms] */
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-02-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org/w/wkflw
   Query 9 - 2025-02-12 08:37:55 [246.25ms] */
select count(*) as aggregate from `transaction` inner join `workflow_definition` on `workflow_definition`.`id` = `transaction`.`current_workflow_state_id` where `workflow_definition`.`role_id` in (5) and `transaction`.`one_time_tax` <> 'Y' and `transaction`.`parent_id` is null and `workflow_definition`.`role_id` = 5 and `deliver_district_id` = 37 and `status` != 'CANCELED' and `transaction`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org/w/wkflw
   Query 10 - 2025-02-12 08:37:55 [327.22ms] */
select `transaction`.* from `transaction` inner join `workflow_definition` on `workflow_definition`.`id` = `transaction`.`current_workflow_state_id` where `workflow_definition`.`role_id` in (5) and `transaction`.`one_time_tax` <> 'Y' and `transaction`.`parent_id` is null and `workflow_definition`.`role_id` = 5 and `deliver_district_id` = 37 and `status` != 'CANCELED' and `transaction`.`deleted_at` is null order by `transaction`.`created_at` desc limit 10 offset 0;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/livewire/message/service.title-reprint-list-component
   Query 5 - 2025-02-12 08:38:11 [322.64ms] */
select count(*) as aggregate from `vehicle` inner join `party_vehicle` on `party_vehicle`.`vehicle_id` = `vehicle`.`id` where `party_vehicle`.`is_owner` = 'Y' and `party_vehicle`.`provisional` = 'N' and `vehicle`.`provisional` = 'N' and `party_vehicle`.`status` = 'REGISTERED' and (`license_plate` like '%1%' or `vin` like '%1%') and `ban_status` = 'GOOD_STANDING' and `vehicle`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/livewire/message/party.list-party-component
   Query 5 - 2025-02-12 08:38:24 [108.84ms] */
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 '%a%' or `second_name` like '%a%' or `third_name` like '%a%' or `fourth_name` like '%a%' or `phone_number_1` like '%a%' or `phone_number_2` like '%a%' or `customer_identity_documents`.`id_number` like '%a%')) and `provisional` = 'N') and `person`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/livewire/message/party.list-party-component
   Query 6 - 2025-02-12 08:38:24 [291.04ms] */
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 '%a%' or `second_name` like '%a%' or `third_name` like '%a%' or `fourth_name` like '%a%' or `phone_number_1` like '%a%' or `phone_number_2` like '%a%' or `customer_identity_documents`.`id_number` like '%a%')) 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.list-party-component
   Query 5 - 2025-02-12 08:38:25 [127.06ms] */
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 '%anand%' or `second_name` like '%anand%' or `third_name` like '%anand%' or `fourth_name` like '%anand%' or `phone_number_1` like '%anand%' or `phone_number_2` like '%anand%' or `customer_identity_documents`.`id_number` like '%anand%')) and `provisional` = 'N') and `person`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org/m/vehicle
   Query 7 - 2025-02-12 08:44:26 [156.29ms] */
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.list-vehicle-component
   Query 7 - 2025-02-12 08:54:12 [244.89ms] */
select count(*) as aggregate from `vehicle` where vehicle.id NOT IN (SELECT vehicle_id FROM party_vehicle WHERE party_vehicle.deleted_at IS NULL) and `vehicle`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org/m/service/title
   Query 9 - 2025-02-12 08:54:21 [101.93ms] */
select count(*) as aggregate from `person` where `person`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/livewire/message/party.select-party-component
   Query 5 - 2025-02-12 08:54:37 [502.31ms] */
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 '%k%' or `second_name` like '%k%' or `third_name` like '%k%' or `fourth_name` like '%k%' or `phone_number_1` like '%k%' or `phone_number_2` like '%k%' or `customer_identity_documents`.`id_number` like '%k%')) 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-02-12 08:54:38 [481.01ms] */
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 '%k%' or `second_name` like '%k%' or `third_name` like '%k%' or `fourth_name` like '%k%' or `phone_number_1` like '%k%' or `phone_number_2` like '%k%' or `customer_identity_documents`.`id_number` like '%k%')) 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-02-12 08:54:55 [327.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 '%ked%' or `second_name` like '%ked%' or `third_name` like '%ked%' or `fourth_name` like '%ked%' or `phone_number_1` like '%ked%' or `phone_number_2` like '%ked%' or `customer_identity_documents`.`id_number` like '%ked%')) 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-02-12 08:54:55 [277.4ms] */
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 '%ked%' or `second_name` like '%ked%' or `third_name` like '%ked%' or `fourth_name` like '%ked%' or `phone_number_1` like '%ked%' or `phone_number_2` like '%ked%' or `customer_identity_documents`.`id_number` like '%ked%')) 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-02-12 08:54:56 [230.37ms] */
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 '%kedi%' or `second_name` like '%kedi%' or `third_name` like '%kedi%' or `fourth_name` like '%kedi%' or `phone_number_1` like '%kedi%' or `phone_number_2` like '%kedi%' or `customer_identity_documents`.`id_number` like '%kedi%')) 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-02-12 08:54:56 [167.97ms] */
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 '%kedi%' or `second_name` like '%kedi%' or `third_name` like '%kedi%' or `fourth_name` like '%kedi%' or `phone_number_1` like '%kedi%' or `phone_number_2` like '%kedi%' or `customer_identity_documents`.`id_number` like '%kedi%')) 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 7 - 2025-02-12 08:55:28 [124.73ms] */
select `vehicle`.* from `vehicle` left outer join `party_vehicle` on `party_vehicle`.`vehicle_id` = `vehicle`.`id` where (`party_vehicle`.`party_id` is null or `party_vehicle`.`deleted_at` is not null) and `vehicle`.`deleted_at` is null order by `created_at` desc limit 1;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/livewire/message/vehicle.select-vehicle-component
   Query 14 - 2025-02-12 08:55:29 [120.27ms] */
select count(*) as aggregate from `vehicle` where (`license_plate` like '%56%' or `vin` like '%56%') 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-02-12 08:55:29 [142.99ms] */
select `vehicle`.* from `vehicle` where (`license_plate` like '%56%' or `vin` like '%56%') 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): POST https://testtra.puntlandgov.org/livewire/message/vehicle.select-vehicle-component
   Query 14 - 2025-02-12 08:55:30 [127.45ms] */
select count(*) as aggregate from `vehicle` where (`license_plate` like '%5656%' or `vin` like '%5656%') 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-02-12 08:55:30 [114.62ms] */
select `vehicle`.* from `vehicle` where (`license_plate` like '%5656%' or `vin` like '%5656%') 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/w/wkflw/510135
   Query 19 - 2025-02-12 08:57:42 [353.56ms] */
select count(*) as aggregate from `transaction_workflow` where `transaction_workflow`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 11 - 2025-02-12 08:58:01 [369.25ms] */
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-02-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 12 - 2025-02-12 08:58:02 [929.51ms] */
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-02-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org/w/wkflw/510135
   Query 20 - 2025-02-12 08:58:26 [298.97ms] */
select count(*) as aggregate from `transaction_workflow` where `transaction_workflow`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/livewire/message/workflow.view-workflow-transaction-component
   Query 44 - 2025-02-12 08:58:36 [252.16ms] */
select count(*) as aggregate from `transaction_workflow` where `transaction_workflow`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org/w/wkflw
   Query 9 - 2025-02-12 09:00:46 [198.83ms] */
select count(*) as aggregate from `transaction` inner join `workflow_definition` on `workflow_definition`.`id` = `transaction`.`current_workflow_state_id` where `workflow_definition`.`role_id` in (5) and `transaction`.`one_time_tax` <> 'Y' and `transaction`.`parent_id` is null and `workflow_definition`.`role_id` = 5 and `deliver_district_id` = 37 and `status` != 'CANCELED' and `transaction`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org/w/wkflw
   Query 10 - 2025-02-12 09:00:46 [298.78ms] */
select `transaction`.* from `transaction` inner join `workflow_definition` on `workflow_definition`.`id` = `transaction`.`current_workflow_state_id` where `workflow_definition`.`role_id` in (5) and `transaction`.`one_time_tax` <> 'Y' and `transaction`.`parent_id` is null and `workflow_definition`.`role_id` = 5 and `deliver_district_id` = 37 and `status` != 'CANCELED' and `transaction`.`deleted_at` is null order by `transaction`.`created_at` desc limit 10 offset 0;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 11 - 2025-02-12 09:00:59 [282.61ms] */
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-02-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 12 - 2025-02-12 09:00:59 [757.73ms] */
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-02-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org/w/wkflw
   Query 9 - 2025-02-12 09:01:04 [112.04ms] */
select count(*) as aggregate from `transaction` inner join `workflow_definition` on `workflow_definition`.`id` = `transaction`.`current_workflow_state_id` where `workflow_definition`.`role_id` in (7) and `transaction`.`one_time_tax` <> 'Y' and `transaction`.`parent_id` is null and `workflow_definition`.`role_id` = 7 and `deliver_district_id` = 37 and `status` != 'CANCELED' and `transaction`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org/w/wkflw/510135
   Query 19 - 2025-02-12 09:23:46 [429.59ms] */
select count(*) as aggregate from `transaction_workflow` where `transaction_workflow`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/api/login
   Query 13 - 2025-02-12 12:11:17 [327.19ms] */
insert into `oauth_access_tokens` (`id`, `user_id`, `client_id`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) values ('b40876bdb6faeef5778fb0bcccb7c0e878c851c30d544b1fa29fa4fd71cc29481617c6f781bc43ce', 149, 5, '[]', 0, '2025-02-12 12:11:17', '2025-02-12 12:11:17', '2026-02-12 12:11:17');
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 11 - 2025-02-12 14:14:53 [297.81ms] */
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-02-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 12 - 2025-02-12 14:14:54 [812.94ms] */
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-02-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 11 - 2025-02-12 15:29:22 [276.03ms] */
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-02-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 12 - 2025-02-12 15:29:23 [759.59ms] */
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-02-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/api/invoice
   Query 7 - 2025-02-12 15:49:53 [202.58ms] */
select `invoice`.`invoice_number`, `invoice`.`invoice_date` as `issue_date`, `invoice`.`due_date`, `invoice`.`status`, CASE
                WHEN person.id IS NOT NULL THEN CONCAT(person.first_name, " ", person.second_name, " ", person.third_name, " ", person.fourth_name)
                WHEN company.id IS NOT NULL THEN company.company_name
                ELSE "No Entity Found"
                END AS customer_name, CASE
                WHEN party.phone_number_2 IS NOT NULL THEN CONCAT(party.phone_number_1," / ",party.phone_number_2)
                ELSE party.phone_number_1 END as mobile_number, `invoice`.`total_invoice_amount`, `roles`.`name` as `role`, CASE WHEN invoice_payment.id IS NULL THEN "Y" ELSE "N" END as make_payment from `invoice` left join `party` on `invoice`.`party_id` = `party`.`id` left join `person` on `person`.`id` = `party`.`partyable_id` and `party`.`partyable_type` = 'Person' left join `company` on `company`.`id` = `party`.`partyable_id` and `party`.`partyable_type` = 'Company' left join `transaction` on `transaction`.`invoice_id` = `invoice`.`id` left join `workflow_definition` on `transaction`.`current_workflow_state_id` = `workflow_definition`.`id` left join `roles` on `workflow_definition`.`role_id` = `roles`.`id` left join `invoice_payment` on `invoice_payment`.`invoice_id` = `invoice`.`id` where `invoice`.`id` = 485831 and `invoice`.`deleted_at` is null limit 1;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org/w/wkflw
   Query 9 - 2025-02-12 15:51:30 [163.49ms] */
select count(*) as aggregate from `transaction` inner join `workflow_definition` on `workflow_definition`.`id` = `transaction`.`current_workflow_state_id` where `workflow_definition`.`role_id` in (5) and `transaction`.`one_time_tax` <> 'Y' and `transaction`.`parent_id` is null and `workflow_definition`.`role_id` = 5 and `deliver_district_id` = 37 and `status` != 'CANCELED' and `transaction`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org/w/wkflw
   Query 10 - 2025-02-12 15:51:30 [216.02ms] */
select `transaction`.* from `transaction` inner join `workflow_definition` on `workflow_definition`.`id` = `transaction`.`current_workflow_state_id` where `workflow_definition`.`role_id` in (5) and `transaction`.`one_time_tax` <> 'Y' and `transaction`.`parent_id` is null and `workflow_definition`.`role_id` = 5 and `deliver_district_id` = 37 and `status` != 'CANCELED' and `transaction`.`deleted_at` is null order by `transaction`.`created_at` desc limit 10 offset 0;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org/m/vehicle
   Query 7 - 2025-02-12 15:54:01 [145.21ms] */
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/party.select-party-component
   Query 5 - 2025-02-12 15:55:09 [118.63ms] */
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 '%l%' or `second_name` like '%l%' or `third_name` like '%l%' or `fourth_name` like '%l%' or `phone_number_1` like '%l%' or `phone_number_2` like '%l%' or `customer_identity_documents`.`id_number` like '%l%')) 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-02-12 15:55:09 [224.69ms] */
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 '%l%' or `second_name` like '%l%' or `third_name` like '%l%' or `fourth_name` like '%l%' or `phone_number_1` like '%l%' or `phone_number_2` like '%l%' or `customer_identity_documents`.`id_number` like '%l%')) 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-02-12 15:55:10 [120.49ms] */
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 '%lu%' or `second_name` like '%lu%' or `third_name` like '%lu%' or `fourth_name` like '%lu%' or `phone_number_1` like '%lu%' or `phone_number_2` like '%lu%' or `customer_identity_documents`.`id_number` like '%lu%')) 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-02-12 15:55:10 [167.05ms] */
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 '%lu%' or `second_name` like '%lu%' or `third_name` like '%lu%' or `fourth_name` like '%lu%' or `phone_number_1` like '%lu%' or `phone_number_2` like '%lu%' or `customer_identity_documents`.`id_number` like '%lu%')) 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-02-12 15:55:27 [121.96ms] */
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 '%luc%' or `second_name` like '%luc%' or `third_name` like '%luc%' or `fourth_name` like '%luc%' or `phone_number_1` like '%luc%' or `phone_number_2` like '%luc%' or `customer_identity_documents`.`id_number` like '%luc%')) 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-02-12 15:55:28 [154.53ms] */
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 '%luc%' or `second_name` like '%luc%' or `third_name` like '%luc%' or `fourth_name` like '%luc%' or `phone_number_1` like '%luc%' or `phone_number_2` like '%luc%' or `customer_identity_documents`.`id_number` like '%luc%')) 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 15 - 2025-02-12 15:55:47 [109.11ms] */
select `vehicle`.* from `vehicle` where (`license_plate` like '%t%' or `vin` like '%t%') 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): POST https://testtra.puntlandgov.org/livewire/message/vehicle.select-vehicle-component
   Query 15 - 2025-02-12 15:55:48 [105.6ms] */
select `vehicle`.* from `vehicle` where (`license_plate` like '%te%' or `vin` like '%te%') 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/w/wkflw/510136
   Query 19 - 2025-02-12 15:56:25 [243.43ms] */
select count(*) as aggregate from `transaction_workflow` where `transaction_workflow`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 11 - 2025-02-12 15:56:47 [251.99ms] */
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-02-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 12 - 2025-02-12 15:56:48 [818.9ms] */
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-02-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org/w/wkflw/510136
   Query 20 - 2025-02-12 15:57:00 [270.78ms] */
select count(*) as aggregate from `transaction_workflow` where `transaction_workflow`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/livewire/message/workflow.view-workflow-transaction-component
   Query 44 - 2025-02-12 15:57:06 [220.63ms] */
select count(*) as aggregate from `transaction_workflow` where `transaction_workflow`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 11 - 2025-02-12 15:58:43 [254.71ms] */
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-02-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 12 - 2025-02-12 15:58:43 [805.18ms] */
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-02-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org/w/wkflw
   Query 9 - 2025-02-12 15:58:53 [210.51ms] */
select count(*) as aggregate from `transaction` inner join `workflow_definition` on `workflow_definition`.`id` = `transaction`.`current_workflow_state_id` where `workflow_definition`.`role_id` in (5) and `transaction`.`one_time_tax` <> 'Y' and `transaction`.`parent_id` is null and `workflow_definition`.`role_id` = 5 and `deliver_district_id` = 37 and `status` != 'CANCELED' and `transaction`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org/w/wkflw
   Query 10 - 2025-02-12 15:58:53 [214.03ms] */
select `transaction`.* from `transaction` inner join `workflow_definition` on `workflow_definition`.`id` = `transaction`.`current_workflow_state_id` where `workflow_definition`.`role_id` in (5) and `transaction`.`one_time_tax` <> 'Y' and `transaction`.`parent_id` is null and `workflow_definition`.`role_id` = 5 and `deliver_district_id` = 37 and `status` != 'CANCELED' and `transaction`.`deleted_at` is null order by `transaction`.`created_at` desc limit 10 offset 0;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org/m/vehicle
   Query 7 - 2025-02-12 16:03:15 [109.49ms] */
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/party.select-party-component
   Query 5 - 2025-02-12 16:04:13 [120.1ms] */
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 '%j%' or `second_name` like '%j%' or `third_name` like '%j%' or `fourth_name` like '%j%' or `phone_number_1` like '%j%' or `phone_number_2` like '%j%' or `customer_identity_documents`.`id_number` like '%j%')) 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-02-12 16:04:13 [181.46ms] */
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 '%j%' or `second_name` like '%j%' or `third_name` like '%j%' or `fourth_name` like '%j%' or `phone_number_1` like '%j%' or `phone_number_2` like '%j%' or `customer_identity_documents`.`id_number` like '%j%')) 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-02-12 16:04:16 [120.2ms] */
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 '%ja%' or `second_name` like '%ja%' or `third_name` like '%ja%' or `fourth_name` like '%ja%' or `phone_number_1` like '%ja%' or `phone_number_2` like '%ja%' or `customer_identity_documents`.`id_number` like '%ja%')) 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-02-12 16:04:17 [178.25ms] */
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 '%ja%' or `second_name` like '%ja%' or `third_name` like '%ja%' or `fourth_name` like '%ja%' or `phone_number_1` like '%ja%' or `phone_number_2` like '%ja%' or `customer_identity_documents`.`id_number` like '%ja%')) 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-02-12 16:04:17 [118.62ms] */
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 '%jac%' or `second_name` like '%jac%' or `third_name` like '%jac%' or `fourth_name` like '%jac%' or `phone_number_1` like '%jac%' or `phone_number_2` like '%jac%' or `customer_identity_documents`.`id_number` like '%jac%')) 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-02-12 16:04:18 [162.68ms] */
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 '%jac%' or `second_name` like '%jac%' or `third_name` like '%jac%' or `fourth_name` like '%jac%' or `phone_number_1` like '%jac%' or `phone_number_2` like '%jac%' or `customer_identity_documents`.`id_number` like '%jac%')) 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-02-12 16:04:18 [120.76ms] */
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 '%jack%' or `second_name` like '%jack%' or `third_name` like '%jack%' or `fourth_name` like '%jack%' or `phone_number_1` like '%jack%' or `phone_number_2` like '%jack%' or `customer_identity_documents`.`id_number` like '%jack%')) 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-02-12 16:04:19 [161.48ms] */
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 '%jack%' or `second_name` like '%jack%' or `third_name` like '%jack%' or `fourth_name` like '%jack%' or `phone_number_1` like '%jack%' or `phone_number_2` like '%jack%' or `customer_identity_documents`.`id_number` like '%jack%')) 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 15 - 2025-02-12 16:04:36 [112.31ms] */
select `vehicle`.* from `vehicle` where (`license_plate` like '%s%' or `vin` like '%s%') 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): POST https://testtra.puntlandgov.org/livewire/message/vehicle.select-vehicle-component
   Query 15 - 2025-02-12 16:04:37 [108.07ms] */
select `vehicle`.* from `vehicle` where (`license_plate` like '%sf%' or `vin` like '%sf%') 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/w/wkflw/510137
   Query 19 - 2025-02-12 16:05:10 [239.21ms] */
select count(*) as aggregate from `transaction_workflow` where `transaction_workflow`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 11 - 2025-02-12 16:05:18 [257.2ms] */
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-02-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 12 - 2025-02-12 16:05:19 [806.5ms] */
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-02-12' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org/w/wkflw/510137
   Query 20 - 2025-02-12 16:05:46 [237.4ms] */
select count(*) as aggregate from `transaction_workflow` where `transaction_workflow`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/livewire/message/workflow.view-workflow-transaction-component
   Query 44 - 2025-02-12 16:05:53 [215.07ms] */
select count(*) as aggregate from `transaction_workflow` where `transaction_workflow`.`deleted_at` is null;
/*==================================================*/
