https://sys.nenocourier.co.ke/fos/new-parcel Return to referer URL

Query Metrics

11 Database Queries
10 Different statements
18.18 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.73 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.created_at AS created_at_4, t0.roles AS roles_5, t0.email AS email_6, t0.person_id AS person_id_7 FROM user t0 WHERE t0.id = ?
Parameters:
[
  150
]
2 0.94 ms
SELECT t0.id AS id_1, t0.organization_name AS organization_name_2, t0.code AS code_3, t0.county AS county_4, t0.town AS town_5, t0.address AS address_6, t0.person_id AS person_id_7, t0.created_by AS created_by_8 FROM organization t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
3 1.06 ms
SELECT s0_.id AS id_0, s0_.station_name AS station_name_1, s0_.station_address AS station_address_2, s0_.phone_numbers AS phone_numbers_3, s0_.created_at AS created_at_4, s0_.operating_hrs AS operating_hrs_5, s0_.is_mobile AS is_mobile_6, s0_.organization_id AS organization_id_7, s0_.created_by AS created_by_8 FROM station s0_ WHERE s0_.is_mobile = 0 LIMIT 50
Parameters:
[]
4 1.20 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.created_at AS created_at_3, t0.user AS user_4, t0.station_id AS station_id_5 FROM user_station t0 WHERE t0.user = ? AND t0.is_active = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  150
  1
]
5 1.23 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.created_at AS created_at_3, t0.user AS user_4, t0.station_id AS station_id_5 FROM user_station t0 WHERE t0.user = ? AND t0.is_active = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  150
  1
]
6 3.16 ms
SELECT t0.id AS id_1, t0.drawer_cash AS drawer_cash_2, t0.account_date AS account_date_3, t0.is_closed AS is_closed_4, t0.created_at AS created_at_5, t0.user_id AS user_id_6, t0.station_daily_account AS station_daily_account_7, t0.closed_by AS closed_by_8 FROM daily_account t0 WHERE t0.user_id = ? AND t0.is_closed = ? AND t0.account_date = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  150
  0
  "2025-03-17"
]
7 0.41 ms
"START TRANSACTION"
Parameters:
[]
8 3.21 ms
INSERT INTO way_bill (sender_name, sender_phone_number, receiver_name, receiver_phone_number, created_at, is_collected, is_received, received_at, percel_count, longitude, latitude, parcel_value, from_station_id, to_station_id, created_by, received_by, organization_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "winnes"
  "0726 339 604"
  "silivia njeri"
  "0707 390 258"
  "2025-03-17 13:33:42"
  0
  0
  null
  1
  null
  null
  1500
  1
  2
  150
  null
  1
]
9 1.08 ms
INSERT INTO transaction (amount, cash_amount, mpesa_amount, tax_percentage, tax_amount, gross_amount, station_expenses, station_balance, expenses, balance, created_at, is_cancelled, is_complete, is_paid, paid_by, mpesa_payment_phone, payment_method, pin_number, cu_invoice_number, cu_invoice_number_credit, cu_serial_number, is_final, way_bill_id, created_by, organization_id, daily_account_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  300
  0
  0
  16
  41.38
  300
  0
  300
  0
  300
  "2025-03-17 13:33:42"
  0
  0
  0
  "CASH"
  null
  null
  null
  null
  null
  null
  0
  1059022
  150
  1
  36908
]
10 0.43 ms
INSERT INTO parcel (description, number, is_in_delivery, created_at, way_bill_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "c ack shoes"
  1
  0
  "2025-03-17 13:33:42"
  1059022
]
11 4.74 ms
"COMMIT"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Person No errors.
App\Entity\Organization No errors.
App\Entity\Station No errors.
App\Entity\WayBill
  • The field App\Entity\WayBill#collectedParcel is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CollectedParcel#waybill does not contain the required 'inversedBy="collectedParcel"' attribute.
App\Entity\UserStation No errors.
App\Entity\Transaction No errors.
App\Entity\DailyAccount No errors.
App\Entity\StationDailyAccount No errors.
App\Entity\StationExpense No errors.
App\Entity\Parcel No errors.