https://dev.supervydejny.cz/delivery-points/

Query Metrics

163 Database Queries
5 Different statements
136.71 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.