Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.eshop_order_parent_id AS eshop_order_parent_id_2,
  t0.eshop_order_id AS eshop_order_id_3,
  t0.number AS number_4,
  t0.currency_rate AS currency_rate_5,
  t0.invoice_number AS invoice_number_6,
  t0.status AS status_7,
  t0.currency AS currency_8,
  t0.discount_total AS discount_total_9,
  t0.discount_tax AS discount_tax_10,
  t0.total AS total_11,
  t0.total_tax AS total_tax_12,
  t0.shipping_total AS shipping_total_13,
  t0.shipping_tax AS shipping_tax_14,
  t0.cart_tax AS cart_tax_15,
  t0.prices_included_tax AS prices_included_tax_16,
  t0.customer_id AS customer_id_17,
  t0.customer_note AS customer_note_18,
  t0.note AS note_19,
  t0.payment_method AS payment_method_20,
  t0.payment_method_title AS payment_method_title_21,
  t0.transaction_id AS transaction_id_22,
  t0.paid AS paid_23,
  t0.eshop_id AS eshop_id_24,
  t0.synced AS synced_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.invoiced_at AS invoiced_at_28,
  t0.packeta_address_id AS packeta_address_id_29,
  t0.packeta_address_name AS packeta_address_name_30,
  t0.packeta_place AS packeta_place_31,
  t0.packeta_transport_id AS packeta_transport_id_32,
  t0.packeta_carrier_id AS packeta_carrier_id_33,
  t0.packeta_carrier_pickup_point_id AS packeta_carrier_pickup_point_id_34,
  t0.packeta_city AS packeta_city_35,
  t0.packeta_street AS packeta_street_36,
  t0.packeta_zip AS packeta_zip_37,
  t0.packeta_url AS packeta_url_38,
  t0.packeta_custom_dimension AS packeta_custom_dimension_39,
  t0.to_sync AS to_sync_40,
  t0.locked_date_time AS locked_date_time_41,
  t42.id AS id_43,
  t42.first_name AS first_name_44,
  t42.last_name AS last_name_45,
  t42.company AS company_46,
  t42.address AS address_47,
  t42.address2 AS address2_48,
  t42.city AS city_49,
  t42.state AS state_50,
  t42.postcode AS postcode_51,
  t42.country AS country_52,
  t42.email AS email_53,
  t42.phone AS phone_54,
  t42.order_id AS order_id_55,
  t56.id AS id_57,
  t56.first_name AS first_name_58,
  t56.last_name AS last_name_59,
  t56.company AS company_60,
  t56.address AS address_61,
  t56.address2 AS address2_62,
  t56.city AS city_63,
  t56.state AS state_64,
  t56.postcode AS postcode_65,
  t56.country AS country_66,
  t56.order_id AS order_id_67,
  t68.id AS id_69,
  t68.sent AS sent_70,
  t68.sent_status AS sent_status_71,
  t68.shipment_id AS shipment_id_72,
  t68.barcode AS barcode_73,
  t68.barcode_text AS barcode_text_74,
  t68.courier_number AS courier_number_75,
  t68.fail_text AS fail_text_76,
  t68.created_at AS created_at_77,
  t68.updated_at AS updated_at_78,
  t68.order_id AS order_id_79
FROM
  orders t0
  LEFT JOIN order_billing_address t42 ON t42.order_id = t0.id
  LEFT JOIN order_shipping_address t56 ON t56.order_id = t0.id
  LEFT JOIN order_packeta t68 ON t68.order_id = t0.id
  INNER JOIN order_order_pdf ON t0.id = order_order_pdf.order_id
WHERE
  order_order_pdf.order_pdf_id = ?

SELECT t0.id AS id_1, t0.eshop_order_parent_id AS eshop_order_parent_id_2, t0.eshop_order_id AS eshop_order_id_3, t0.number AS number_4, t0.currency_rate AS currency_rate_5, t0.invoice_number AS invoice_number_6, t0.status AS status_7, t0.currency AS currency_8, t0.discount_total AS discount_total_9, t0.discount_tax AS discount_tax_10, t0.total AS total_11, t0.total_tax AS total_tax_12, t0.shipping_total AS shipping_total_13, t0.shipping_tax AS shipping_tax_14, t0.cart_tax AS cart_tax_15, t0.prices_included_tax AS prices_included_tax_16, t0.customer_id AS customer_id_17, t0.customer_note AS customer_note_18, t0.note AS note_19, t0.payment_method AS payment_method_20, t0.payment_method_title AS payment_method_title_21, t0.transaction_id AS transaction_id_22, t0.paid AS paid_23, t0.eshop_id AS eshop_id_24, t0.synced AS synced_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.invoiced_at AS invoiced_at_28, t0.packeta_address_id AS packeta_address_id_29, t0.packeta_address_name AS packeta_address_name_30, t0.packeta_place AS packeta_place_31, t0.packeta_transport_id AS packeta_transport_id_32, t0.packeta_carrier_id AS packeta_carrier_id_33, t0.packeta_carrier_pickup_point_id AS packeta_carrier_pickup_point_id_34, t0.packeta_city AS packeta_city_35, t0.packeta_street AS packeta_street_36, t0.packeta_zip AS packeta_zip_37, t0.packeta_url AS packeta_url_38, t0.packeta_custom_dimension AS packeta_custom_dimension_39, t0.to_sync AS to_sync_40, t0.locked_date_time AS locked_date_time_41, t42.id AS id_43, t42.first_name AS first_name_44, t42.last_name AS last_name_45, t42.company AS company_46, t42.address AS address_47, t42.address2 AS address2_48, t42.city AS city_49, t42.state AS state_50, t42.postcode AS postcode_51, t42.country AS country_52, t42.email AS email_53, t42.phone AS phone_54, t42.order_id AS order_id_55, t56.id AS id_57, t56.first_name AS first_name_58, t56.last_name AS last_name_59, t56.company AS company_60, t56.address AS address_61, t56.address2 AS address2_62, t56.city AS city_63, t56.state AS state_64, t56.postcode AS postcode_65, t56.country AS country_66, t56.order_id AS order_id_67, t68.id AS id_69, t68.sent AS sent_70, t68.sent_status AS sent_status_71, t68.shipment_id AS shipment_id_72, t68.barcode AS barcode_73, t68.barcode_text AS barcode_text_74, t68.courier_number AS courier_number_75, t68.fail_text AS fail_text_76, t68.created_at AS created_at_77, t68.updated_at AS updated_at_78, t68.order_id AS order_id_79 FROM orders t0 LEFT JOIN order_billing_address t42 ON t42.order_id = t0.id LEFT JOIN order_shipping_address t56 ON t56.order_id = t0.id LEFT JOIN order_packeta t68 ON t68.order_id = t0.id INNER JOIN order_order_pdf ON t0.id = order_order_pdf.order_id WHERE order_order_pdf.order_pdf_id = 31191;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.entity_name AS entity_name_4,
  t0.entity_id AS entity_id_5,
  t0.extension AS extension_6,
  t0.modified_at AS modified_at_7,
  t0.type AS type_8,
  t0.position AS position_9
FROM
  uploaded_files t0
WHERE
  t0.entity_name = ?
  AND t0.entity_id = ?
  AND t0.type = ?
ORDER BY
  t0.position ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.entity_name AS entity_name_4, t0.entity_id AS entity_id_5, t0.extension AS extension_6, t0.modified_at AS modified_at_7, t0.type AS type_8, t0.position AS position_9 FROM uploaded_files t0 WHERE t0.entity_name = 'orderPdf' AND t0.entity_id = 31191 AND t0.type = 'default' ORDER BY t0.position ASC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.info AS info_3,
  t0.status AS status_4,
  t0.type AS type_5
FROM
  order_pdfs t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.info AS info_3, t0.status AS status_4, t0.type AS type_5 FROM order_pdfs t0 WHERE t0.id = 31191;

SELECT
  o0_.id AS id_0,
  o0_.info AS info_1,
  o0_.status AS status_2,
  o0_.created_at AS created_at_3
FROM
  order_pdfs o0_
GROUP BY
  o0_.id
ORDER BY
  o0_.created_at DESC NULLS LAST
LIMIT
  100

SELECT o0_.id AS id_0, o0_.info AS info_1, o0_.status AS status_2, o0_.created_at AS created_at_3 FROM order_pdfs o0_ GROUP BY o0_.id ORDER BY o0_.created_at DESC NULLS LAST LIMIT 100;

SELECT
  COUNT(*): :INTEGER AS total_count
FROM
  (
    SELECT
      o0_.id AS id_0,
      o0_.info AS info_1,
      o0_.status AS status_2,
      o0_.created_at AS created_at_3
    FROM
      order_pdfs o0_
    GROUP BY
      o0_.id
  ) ORIGINAL_QUERY

SELECT COUNT(*)::INTEGER AS total_count FROM (SELECT o0_.id AS id_0, o0_.info AS info_1, o0_.status AS status_2, o0_.created_at AS created_at_3 FROM order_pdfs o0_ GROUP BY o0_.id) ORIGINAL_QUERY;

SELECT
  a0_.id AS id_0,
  a0_.ip_address AS ip_address_1,
  a0_.login_time AS login_time_2,
  a0_.last_action_time AS last_action_time_3,
  a0_.administrator_id AS administrator_id_4
FROM
  administrator_activities a0_
WHERE
  a0_.administrator_id = ?
ORDER BY
  a0_.login_time DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.ip_address AS ip_address_1, a0_.login_time AS login_time_2, a0_.last_action_time AS last_action_time_3, a0_.administrator_id AS administrator_id_4 FROM administrator_activities a0_ WHERE a0_.administrator_id = 6 ORDER BY a0_.login_time DESC LIMIT 1;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.real_name AS real_name_3,
  t0.password AS password_4,
  t0.login_token AS login_token_5,
  t0.email AS email_6,
  t0.multidomain_login_token AS multidomain_login_token_7,
  t0.multidomain_login_token_expiration AS multidomain_login_token_expiration_8,
  t0.roles_changed_at AS roles_changed_at_9
FROM
  administrators t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.real_name AS real_name_3, t0.password AS password_4, t0.login_token AS login_token_5, t0.email AS email_6, t0.multidomain_login_token AS multidomain_login_token_7, t0.multidomain_login_token_expiration AS multidomain_login_token_expiration_8, t0.roles_changed_at AS roles_changed_at_9 FROM administrators t0 WHERE t0.id = 6;

UPDATE
  administrator_activities
SET
  last_action_time = ?
WHERE
  id = ?

UPDATE administrator_activities SET last_action_time = '2024-09-29 10:28:37' WHERE id = 2215;

SELECT
  t0.grid_id AS grid_id_1,
  t0."limit" AS limit_2,
  t0.administrator_id AS administrator_id_3
FROM
  administrator_grid_limits t0
WHERE
  t0.administrator_id = ?

SELECT t0.grid_id AS grid_id_1, t0."limit" AS limit_2, t0.administrator_id AS administrator_id_3 FROM administrator_grid_limits t0 WHERE t0.administrator_id = 6;

SELECT
  t0.role AS role_1,
  t0.administrator_id AS administrator_id_2
FROM
  administrator_roles t0
WHERE
  t0.administrator_id = ?

SELECT t0.role AS role_1, t0.administrator_id AS administrator_id_2 FROM administrator_roles t0 WHERE t0.administrator_id = 6;

"START TRANSACTION"

"START TRANSACTION";