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

Query Metrics

8 Database Queries
8 Different statements
33.73 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 6.99 ms
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:
[
  "CEB001"
]
2 2.09 ms
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:
[
  1112
]
3 1.76 ms
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:
[
  57
  "2026-01-15 07:45:02"
]
4 12.74 ms
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:
[
  57
]
5 6.94 ms
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:
[
  57
]
6 1.20 ms
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:
[
  57
]
7 1.03 ms
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"
]
8 0.96 ms
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.