Query Metrics
163
Database Queries
5
Different statements
136.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
78.27 ms (57.25%) |
80 |
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:
[
1274
]
|
|
40.39 ms (29.54%) |
80 |
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:
[
108
]
|
|
16.23 ms (11.87%) |
1 |
SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.name AS name_2, p0_.type AS type_3, p0_.gps AS gps_4, p0_.about_us AS about_us_5, p0_.description_general AS description_general_6, p0_.description_car AS description_car_7, p0_.description_public AS description_public_8, p0_.limit_max_weight AS limit_max_weight_9, p0_.limit_max_packages AS limit_max_packages_10, p0_.active_receive AS active_receive_11, p0_.active AS active_12, p0_.opening_hours AS opening_hours_13, p0_.sms_text AS sms_text_14, p0_.web_site AS web_site_15, p0_.created AS created_16, p0_.modified AS modified_17, p0_.address_id AS address_id_18, p0_.user_account_delivery_partner_id AS user_account_delivery_partner_id_19, p0_.main_image_id AS main_image_id_20 FROM pm_delivery_point p0_ WHERE p0_.active = true ORDER BY p0_.code ASC
Parameters:
[] |
|
1.24 ms (0.91%) |
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.59 ms (0.43%) |
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. |
| 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\PackageCode | No errors. |
| App\Entity\Package | No errors. |
| App\Entity\PackageDelivery | 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. |