Query Metrics
8
Database Queries
8
Different statements
8.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.25 ms (26.22%) |
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:
[
"PRO002"
]
|
|
1.36 ms (15.82%) |
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:
[ 54 "2026-01-15 07:42:59" ] |
|
1.29 ms (15.06%) |
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:
[
1107
]
|
|
0.89 ms (10.31%) |
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:
[
54
]
|
|
0.82 ms (9.61%) |
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:
[
54
]
|
|
0.78 ms (9.12%) |
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.69 ms (8.10%) |
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:
[
54
]
|
|
0.49 ms (5.77%) |
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\Configuration | No errors. |