GET http://tracking.ecopanel.pw/api/v1/track/1ZT7919T0391234988?carrier=ups&s=%2F%2Fapi%2Fv1%2Ftrack%2F1ZT7919T0391234988

Query Metrics

7 Database Queries
7 Different statements
3.89 ms Query time
0 Invalid entities
5 Managed entities

Queries

Group similar statements

# Time Info
1 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.api_key AS api_key_3, t0.enabled AS enabled_4, t0.rate_limit_per_day AS rate_limit_per_day_5, t0.rate_limit_per_month AS rate_limit_per_month_6, t0.note AS note_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM api_client t0 WHERE t0.api_key = ? LIMIT 1
Parameters:
[
  "244e1ea55690ca9fd9e197ced9e7d207a533f4832d1eef95"
]
2 0.38 ms
SELECT t0.`key` AS key_1, t0.value AS value_2 FROM app_setting t0 WHERE t0.`key` = ?
Parameters:
[
  "tracking_hub_settings"
]
3 0.41 ms
SELECT t0.id AS id_1, t0.carrier AS carrier_2, t0.provider AS provider_3, t0.enabled AS enabled_4, t0.priority AS priority_5, t0.note AS note_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM carrier_provider_route t0 WHERE t0.carrier = ? AND t0.enabled = ? LIMIT 1
Parameters:
[
  "ups"
  1
]
4 0.93 ms
SELECT t0.id AS id_1, t0.tracking_number AS tracking_number_2, t0.carrier AS carrier_3, t0.provider AS provider_4, t0.queue_status AS queue_status_5, t0.delivery_status AS delivery_status_6, t0.status_label AS status_label_7, t0.location AS location_8, t0.last_update AS last_update_9, t0.events AS events_10, t0.raw AS raw_11, t0.whereparcel_request_id AS whereparcel_request_id_12, t0.webhook_endpoint_id AS webhook_endpoint_id_13, t0.attempts AS attempts_14, t0.next_attempt_at AS next_attempt_at_15, t0.last_error AS last_error_16, t0.registered_at AS registered_at_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.api_client_id AS api_client_id_20 FROM tracking_subscription t0 WHERE t0.provider = ? AND t0.carrier = ? AND t0.tracking_number = ? LIMIT 1
Parameters:
[
  "whereparcel"
  "ups"
  "1ZT7919T0391234988"
]
5 0.28 ms
"START TRANSACTION"
Parameters:
[]
6 0.53 ms
INSERT INTO tracking_log (tracking_number, carrier, provider, status, error_code, duration_ms, ip, created_at, api_client_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "1ZT7919T0391234988"
  "ups"
  "whereparcel"
  "queued"
  null
  0
  null
  "2026-06-13 03:00:18"
  1
]
7 0.83 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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\ApiClient 1
App\Entity\AppSetting 1
App\Entity\CarrierProviderRoute 1
App\Entity\TrackingSubscription 1
App\Entity\TrackingLog 1

Entities Mapping