Query Metrics
9
Database Queries
9
Different statements
41.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
27.86 ms (67.82%) |
1 |
SELECT t0.id AS id_1, t0.image AS image_2, t0.image_prefix AS image_prefix_3, t0.delivery_point_id AS delivery_point_id_4 FROM pm_delivery_point_image t0 WHERE t0.delivery_point_id = ?
Parameters:
[
43
]
|
|
4.20 ms (10.24%) |
1 |
SELECT p0_.id AS id_0, p0_.package_state_id AS package_state_id_1, p0_.last_customer_notification AS last_customer_notification_2, p1_.last_date_for_pickup AS last_date_for_pickup_3, p1_.delivery_code AS delivery_code_4, p0_.discriminator AS discriminator_5, p0_.order_id AS order_id_6, p0_.package_code_id AS package_code_id_7, p0_.measurement_id AS measurement_id_8, p1_.box_id AS box_id_9 FROM pm_package_delivery p1_ INNER JOIN pm_package p0_ ON p1_.id = p0_.id LEFT JOIN (pm_order_delivery p2_ INNER JOIN pm_order p3_ ON p2_.id = p3_.id) ON (p0_.order_id = p3_.id) WHERE p2_.delivery_point_id = ? AND p0_.package_state_id = ? GROUP BY p0_.id, p0_.package_state_id, p0_.last_customer_notification, p1_.last_date_for_pickup, p1_.delivery_code, p0_.order_id, p0_.package_code_id, p0_.measurement_id, p1_.box_id
Parameters:
[ 43 9 ] |
|
2.13 ms (5.19%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.type AS type_4, t0.gps AS gps_5, t0.about_us AS about_us_6, t0.description_general AS description_general_7, t0.description_car AS description_car_8, t0.description_public AS description_public_9, t0.limit_max_weight AS limit_max_weight_10, t0.limit_max_packages AS limit_max_packages_11, t0.active_receive AS active_receive_12, t0.active AS active_13, t0.opening_hours AS opening_hours_14, t0.sms_text AS sms_text_15, t0.web_site AS web_site_16, t0.created AS created_17, t0.modified AS modified_18, t0.address_id AS address_id_19, t0.user_account_delivery_partner_id AS user_account_delivery_partner_id_20, t0.main_image_id AS main_image_id_21 FROM pm_delivery_point t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"KLA004"
]
|
|
1.94 ms (4.73%) |
1 |
SELECT p0_.id AS id_0, p0_.dt_from AS dt_from_1, p0_.dt_to AS dt_to_2, p0_.note AS note_3, p0_.delivery_point_id AS delivery_point_id_4 FROM pm_delivery_point_closed p0_ INNER JOIN pm_delivery_point p1_ ON (p0_.delivery_point_id = p1_.id) WHERE p0_.delivery_point_id = p1_.id AND p1_.id = ? AND p0_.dt_to >= ? ORDER BY p0_.dt_from ASC
Parameters:
[ 43 "2026-01-15 07:46:06" ] |
|
1.50 ms (3.65%) |
1 |
SELECT t0.id AS id_2, t0.name AS name_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.zip_code AS zip_code_6, t0.phone AS phone_7, t0.email AS email_8, t0.alias AS alias_9, t0.city AS city_10, t0.district AS district_11, t0.country_id AS country_id_12, t0.discriminator, t1.company_name AS company_name_13, t1.company_reg_number AS company_reg_number_14, t1.vat_number AS vat_number_15 FROM pm_address t0 LEFT JOIN pm_billing_address t1 ON t0.id = t1.id WHERE t0.id = ?
Parameters:
[
1067
]
|
|
1.12 ms (2.72%) |
1 |
SELECT t0.id AS id_1, t0.dt_from AS dt_from_2, t0.dt_to AS dt_to_3, t0.pay_until AS pay_until_4, t0.minimal_reward AS minimal_reward_5, t0.delivery_point_id AS delivery_point_id_6 FROM pm_delivery_point_contract t0 WHERE t0.delivery_point_id = ? ORDER BY t0.id DESC
Parameters:
[
43
]
|
|
1.01 ms (2.46%) |
1 |
SELECT t0.key AS key_1, t0.value AS value_2, t0.modified AS modified_3, t0.description AS description_4 FROM pm_configuration t0 WHERE t0.key = ? LIMIT 1
Parameters:
[
"support_delivery_email"
]
|
|
0.81 ms (1.96%) |
1 |
SELECT t0.id AS id_1, t0.dt_from AS dt_from_2, t0.dt_to AS dt_to_3, t0.note AS note_4, t0.delivery_point_id AS delivery_point_id_5 FROM pm_delivery_point_closed t0 WHERE t0.delivery_point_id = ?
Parameters:
[
43
]
|
|
0.50 ms (1.22%) |
1 |
SELECT t0.key AS key_1, t0.value AS value_2, t0.modified AS modified_3, t0.description AS description_4 FROM pm_configuration t0 WHERE t0.key = ?
Parameters:
[
"support_delivery_email"
]
|
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\DeliveryPoint | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\UserAccount | No errors. |
| App\Entity\UserAccountDeliveryPartner | No errors. |
| App\Entity\DeliveryPointImage | No errors. |
| App\Entity\BillingAddress | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\DeliveryPointContact | No errors. |
| App\Entity\Box | No errors. |
| App\Entity\UserAccountDeliveryPointEmployee | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\OrderDelivery | No errors. |
| App\Entity\DeliveryPointClosed | No errors. |
| App\Entity\DeliveryPointContract | No errors. |
| App\Entity\Note | No errors. |
| App\Entity\NoteDeliveryPoint | No errors. |
| App\Entity\Package | No errors. |
| App\Entity\PackageDelivery | No errors. |
| App\Entity\PackageCode | No errors. |
| App\Entity\Measurement | No errors. |
| App\Entity\Configuration | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\NoteUserAccountDeliveryPartner | No errors. |
| App\Entity\Language | No errors. |
| App\Entity\Currency | No errors. |
| App\Entity\CarrierPrice | No errors. |
| App\Entity\ContactDeliveryPoint | No errors. |
| App\Entity\Event | No errors. |
| App\Entity\EventBox | No errors. |
| App\Entity\NoteBox | No errors. |
| App\Entity\EventOrder | No errors. |
| App\Entity\NoteOrder | No errors. |
| App\Entity\UserAccountSender | No errors. |
| App\Entity\ContactDeliveryCustomer | No errors. |
| App\Entity\EventPackage | No errors. |
| App\Entity\PackagePhoto | No errors. |
| App\Entity\NotePackage | No errors. |
| App\Entity\CodeLocation | No errors. |
| App\Entity\CodeLocationPackage | No errors. |