Symfony Profiler

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

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 = 51 AND p0_.package_state_id = 9 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;

SELECT
  t0.id AS id_3,
  t0.package_state_id AS package_state_id_4,
  t0.last_customer_notification AS last_customer_notification_5,
  t0.order_id AS order_id_6,
  t0.package_code_id AS package_code_id_7,
  t0.measurement_id AS measurement_id_8,
  t0.discriminator,
  t1.content_description AS content_description_9,
  t1.customer_code_id AS customer_code_id_10,
  t2.last_date_for_pickup AS last_date_for_pickup_11,
  t2.delivery_code AS delivery_code_12,
  t2.box_id AS box_id_13
FROM
  pm_package t0
  LEFT JOIN pm_package_postman t1 ON t0.id = t1.id
  LEFT JOIN pm_package_delivery t2 ON t0.id = t2.id
WHERE
  t0.package_code_id = ?

SELECT t0.id AS id_3, t0.package_state_id AS package_state_id_4, t0.last_customer_notification AS last_customer_notification_5, t0.order_id AS order_id_6, t0.package_code_id AS package_code_id_7, t0.measurement_id AS measurement_id_8, t0.discriminator, t1.content_description AS content_description_9, t1.customer_code_id AS customer_code_id_10, t2.last_date_for_pickup AS last_date_for_pickup_11, t2.delivery_code AS delivery_code_12, t2.box_id AS box_id_13 FROM pm_package t0 LEFT JOIN pm_package_postman t1 ON t0.id = t1.id LEFT JOIN pm_package_delivery t2 ON t0.id = t2.id WHERE t0.package_code_id = 59477;

SELECT
  t0.id AS id_3,
  t0.identifier AS identifier_4,
  t0.invoice_id AS invoice_id_5,
  t0.invoice_hash AS invoice_hash_6,
  t0.proforma_invoice_id AS proforma_invoice_id_7,
  t0.proforma_invoice_hash AS proforma_invoice_hash_8,
  t0.paid AS paid_9,
  t0.vat AS vat_10,
  t0.price_vat AS price_vat_11,
  t0.price_no_vat AS price_no_vat_12,
  t0.order_state_id AS order_state_id_13,
  t0.created AS created_14,
  t0.currency_id AS currency_id_15,
  t0.user_account_sender_id AS user_account_sender_id_16,
  t0.carrier_price_id AS carrier_price_id_17,
  t0.discriminator,
  t1.sender_reference AS sender_reference_18,
  t1.sender_created AS sender_created_19,
  t1.sender_value AS sender_value_20,
  t1.sender_location AS sender_location_21,
  t1.contact_id AS contact_id_22,
  t1.delivery_point_id AS delivery_point_id_23,
  t2.delivery_address_id AS delivery_address_id_24,
  t2.return_address_id AS return_address_id_25,
  t2.billing_address_id AS billing_address_id_26
FROM
  pm_order t0
  LEFT JOIN pm_order_delivery t1 ON t0.id = t1.id
  LEFT JOIN pm_order_postman t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.identifier AS identifier_4, t0.invoice_id AS invoice_id_5, t0.invoice_hash AS invoice_hash_6, t0.proforma_invoice_id AS proforma_invoice_id_7, t0.proforma_invoice_hash AS proforma_invoice_hash_8, t0.paid AS paid_9, t0.vat AS vat_10, t0.price_vat AS price_vat_11, t0.price_no_vat AS price_no_vat_12, t0.order_state_id AS order_state_id_13, t0.created AS created_14, t0.currency_id AS currency_id_15, t0.user_account_sender_id AS user_account_sender_id_16, t0.carrier_price_id AS carrier_price_id_17, t0.discriminator, t1.sender_reference AS sender_reference_18, t1.sender_created AS sender_created_19, t1.sender_value AS sender_value_20, t1.sender_location AS sender_location_21, t1.contact_id AS contact_id_22, t1.delivery_point_id AS delivery_point_id_23, t2.delivery_address_id AS delivery_address_id_24, t2.return_address_id AS return_address_id_25, t2.billing_address_id AS billing_address_id_26 FROM pm_order t0 LEFT JOIN pm_order_delivery t1 ON t0.id = t1.id LEFT JOIN pm_order_postman t2 ON t0.id = t2.id WHERE t0.id = 41673;

SELECT
  t0.id AS id_9,
  t0.code AS code_10,
  t0.created AS created_11,
  t0.code_location_id AS code_location_id_12,
  t0.discriminator
FROM
  pm_package_code t0
  LEFT JOIN pm_package_code_dpd t1 ON t0.id = t1.id
  LEFT JOIN pm_package_code_sender_delivery t2 ON t0.id = t2.id
  LEFT JOIN pm_package_code_internal t3 ON t0.id = t3.id
  LEFT JOIN pm_package_code_customer t4 ON t0.id = t4.id
  LEFT JOIN pm_package_code_czech_post t5 ON t0.id = t5.id
  LEFT JOIN pm_package_code_dpdczech t6 ON t0.id = t6.id
  LEFT JOIN pm_package_code_sender_postman t7 ON t0.id = t7.id
  LEFT JOIN pm_package_code_internal_box t8 ON t0.id = t8.id
WHERE
  t0.id = ?

SELECT t0.id AS id_9, t0.code AS code_10, t0.created AS created_11, t0.code_location_id AS code_location_id_12, t0.discriminator FROM pm_package_code t0 LEFT JOIN pm_package_code_dpd t1 ON t0.id = t1.id LEFT JOIN pm_package_code_sender_delivery t2 ON t0.id = t2.id LEFT JOIN pm_package_code_internal t3 ON t0.id = t3.id LEFT JOIN pm_package_code_customer t4 ON t0.id = t4.id LEFT JOIN pm_package_code_czech_post t5 ON t0.id = t5.id LEFT JOIN pm_package_code_dpdczech t6 ON t0.id = t6.id LEFT JOIN pm_package_code_sender_postman t7 ON t0.id = t7.id LEFT JOIN pm_package_code_internal_box t8 ON t0.id = t8.id WHERE t0.id = 59477;

SELECT
  t0.id AS id_3,
  t0.discriminator,
  t1.weight AS weight_4,
  t1.size_check AS size_check_5,
  t2.length AS length_6,
  t2.width AS width_7,
  t2.height AS height_8,
  t2.weight AS weight_9,
  t2.source AS source_10
FROM
  pm_measurement t0
  LEFT JOIN pm_simple_measurement t1 ON t0.id = t1.id
  LEFT JOIN pm_complex_measurement t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.discriminator, t1.weight AS weight_4, t1.size_check AS size_check_5, t2.length AS length_6, t2.width AS width_7, t2.height AS height_8, t2.weight AS weight_9, t2.source AS source_10 FROM pm_measurement t0 LEFT JOIN pm_simple_measurement t1 ON t0.id = t1.id LEFT JOIN pm_complex_measurement t2 ON t0.id = t2.id WHERE t0.id = 26152;

SELECT
  t0.id AS id_3,
  t0.discriminator,
  t1.package_id AS package_id_4,
  t2.box_id AS box_id_5
FROM
  pm_code_location t0
  LEFT JOIN pm_code_location_package t1 ON t0.id = t1.id
  LEFT JOIN pm_code_location_box t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.discriminator, t1.package_id AS package_id_4, t2.box_id AS box_id_5 FROM pm_code_location t0 LEFT JOIN pm_code_location_package t1 ON t0.id = t1.id LEFT JOIN pm_code_location_box t2 ON t0.id = t2.id WHERE t0.id = 59443;

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

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 = 'PRO001' LIMIT 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

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 = 51 AND p0_.dt_to >= '2026-01-15 07:43:19' ORDER BY p0_.dt_from ASC;

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 = ?

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 = 1101;

SELECT
  t0.id AS id_3,
  t0.weight AS weight_4,
  t0.price_buy AS price_buy_5,
  t0.price_sell AS price_sell_6,
  t0.length AS length_7,
  t0.width AS width_8,
  t0.active AS active_9,
  t0.height AS height_10,
  t0.carrier_id AS carrier_id_11,
  t0.country_id AS country_id_12,
  t0.discriminator
FROM
  pm_carrier_price t0
  LEFT JOIN pm_carrier_price_delivery t1 ON t0.id = t1.id
  LEFT JOIN pm_carrier_price_postman t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.weight AS weight_4, t0.price_buy AS price_buy_5, t0.price_sell AS price_sell_6, t0.length AS length_7, t0.width AS width_8, t0.active AS active_9, t0.height AS height_10, t0.carrier_id AS carrier_id_11, t0.country_id AS country_id_12, t0.discriminator FROM pm_carrier_price t0 LEFT JOIN pm_carrier_price_delivery t1 ON t0.id = t1.id LEFT JOIN pm_carrier_price_postman t2 ON t0.id = t2.id WHERE t0.id = 7;

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 = ?

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 = 51;

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 = ?

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 = 51;

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

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 = 51 ORDER BY t0.id DESC;

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

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 = 'support_delivery_email' LIMIT 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 = ?

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 = 'support_delivery_email';